]>
jfr.im git - irc/gameservirc.git/blob - gameserv/php/install.php
19f036996fde6569c3da625e698fdebbc0ce4a86
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" ;
7 mysql_query ( $query ) or die ( "Couldn't create table $itemtablename : " . mysql_error ());
9 echo "Item table created.<br>" ;
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" ;
13 mysql_query ( $query ) or die ( "Couldn't create table $playertablename : " . mysql_error ());
17 echo "Player table created.<br>" ;
19 echo '<a href="readdata.php">Click here to import the data into mysql</a>' ;