]>
Commit | Line | Data |
---|---|---|
38a0c7cb | 1 | <?php |
43058315 | 2 | include ('mysql.php'); |
38a0c7cb | 3 | |
8443f36d | 4 | |
e5043fe9 | 5 | $query = "CREATE Table `$itemtablename` (`id` bigint NOT NULL auto_increment, `name` text NOT NULL, `price` bigint NOT NULL default 0, `uses` int NOT NULL, `strengthmod` int NOT NULL default 0, `defensemod` int NOT NULL default 0, `maxhpmod` int NOT NULL default 0, `hpmod` int NOT NULL default 0, PRIMARY KEY (`id`)) ENGINE=InnoDB"; |
43058315 | 6 | |
7 | mysql_query($query) or die("Couldn't create table $itemtablename: " . mysql_error()); | |
8 | ||
9 | echo "Item table created.<br>"; | |
10 | ||
11 | $query = "CREATE Table `$playertablename` (`name` text, `level` int NOT NULL default 1, `exp` bigint NOT NULL default 0, `gold` bigint NOT NULL default 0, `bank` bigint NOT NULL default 0, `hp` int NOT NULL default 0, `maxhp` int NOT NULL default 0, `strength` int NOT NULL default 0, `defense` int NOT NULL default 0, `forestfights` int NOT NULL default 0, `playerfights` int NOT NULL default 0, `lastlogin` text, `weaponID` bigint NOT NULL default 0, `armorID` bigint NOT NULL default 0, PRIMARY KEY (`name`(255)), KEY `weaponID` (`weaponID`), KEY `armorID` (`armorID`), CONSTRAINT `" . $playertablename . "_ibfk_1` FOREIGN KEY (`weaponID`) REFERENCES $itemtablename(`id`), CONSTRAINT `" . $playertablename . "_ibfk_2` FOREIGN KEY (`armorID`) REFERENCES $itemtablename(`id`)) ENGINE=InnoDB"; | |
12 | ||
43058315 | 13 | mysql_query($query) or die("Couldn't create table $playertablename: " . mysql_error()); |
14 | ||
ee09d4c0 | 15 | mysql_close($link); |
16 | ||
43058315 | 17 | echo "Player table created.<br>"; |
18 | ||
19 | echo '<a href="readdata.php">Click here to import the data into mysql</a>'; | |
38a0c7cb | 20 | ?> |