While installing a game on my server, I ran into a problem with the database queries that came with it.
The game, Legend of the Green Dragon, is a text game similar to one I wish to create one day.
Perhaps I am doing this wrong? I use phpMyAdmin to create the database tables using the sql queries. When I hit GO!, this is returned:
Error
SQL-query :
logd.sql01007440000764000076700000130713076354644050124450 CREATE TABLE accounts(
acctid int( 11 ) unsigned NOT NULL auto_increment,
name varchar( 50 ) NOT NULL default '',
sex tinyint( 4 ) unsigned NOT NULL default '0',
specialty int( 4 ) unsigned NOT NULL default '0',
darkarts int( 11 ) unsigned NOT NULL default '0',
magic int( 11 ) unsigned NOT NULL default '0',
thievery int( 11 ) unsigned NOT NULL default '0',
experience int( 11 ) unsigned NOT NULL default '0',
charisma int( 11 ) unsigned NOT NULL default '0',
seenlover tinyint( 4 ) unsigned NOT NULL default '0',
gold int( 11 ) unsigned NOT NULL default '0',
weapon varchar( 50 ) NOT NULL default 'Fists',
armor varchar( 50 ) NOT NULL default 'T-Shirt',
seenmaster int( 4 ) unsigned NOT NULL default '0',
LEVEL int( 11 ) unsigned NOT NULL default '1',
defence int( 11 ) unsigned NOT NULL default '1',
attack int( 11 ) unsigned NOT NULL default '1',
alive int( 11 ) unsigned NOT NULL default '1',
goldinbank int( 11 ) unsigned NOT NULL default '0',
marriedto int( 11 ) unsigned NOT NULL default '0',
playerkills int( 4 ) unsigned NOT NULL default '1',
spirits int( 4 ) NOT NULL default '0',
laston datetime NOT NULL default '0000-00-00 00:00:00',
hitpoints int( 11 ) NOT NULL default '10',
maxhitpoints int( 11 ) unsigned NOT NULL default '10',
gems int( 11 ) unsigned NOT NULL default '0',
weaponvalue int( 11 ) unsigned NOT NULL default '0',
armorvalue int( 11 ) unsigned NOT NULL default '0',
location int( 4 ) unsigned NOT NULL default '0',
turns int( 11 ) unsigned NOT NULL default '10',
title varchar( 20 ) NOT NULL default '',
PASSWORD varchar( 32 ) binary NOT NULL default '',
darkartuses int( 4 ) unsigned NOT NULL default '0',
magicuses int( 4 ) unsigned NOT NULL default '0',
thieveryuses int( 4 ) unsigned NOT NULL default '0',
badguy text NOT NULL ,
allowednavs text NOT NULL ,
output text NOT NULL ,
loggedin tinyint( 4 ) unsigned NOT NULL default '0',
resurrections int( 11 ) unsigned NOT NULL default '0',
superuser int( 11 ) unsigned NOT NULL default '0',
weapondmg int( 11 ) NOT NULL default '0',
armordef int( 11 ) NOT NULL default '0',
age int( 11 ) unsigned NOT NULL default '0',
charm int( 11 ) unsigned NOT NULL default '0',
specialinc varchar( 50 ) NOT NULL default '',
specialmisc text NOT NULL ,
login varchar( 50 ) NOT NULL default '',
slainby varchar( 50 ) NOT NULL default '',
lastmotd datetime NOT NULL default '0000-00-00 00:00:00',
playerfights int( 11 ) unsigned NOT NULL default '3',
lasthit datetime NOT NULL default '0000-00-00 00:00:00',
seendragon tinyint( 4 ) unsigned NOT NULL default '0',
dragonkills int( 11 ) unsigned NOT NULL default '0',
drunkenness int( 11 ) unsigned NOT NULL default '0',
locked tinyint( 4 ) unsigned NOT NULL default '0',
restorepage varchar( 128 ) default '',
seenbard tinyint( 4 ) unsigned NOT NULL default '0',
hashorse tinyint( 4 ) unsigned NOT NULL default '0',
bufflist text NOT NULL ,
gentime double unsigned NOT NULL default '0',
gentimecount int( 11 ) unsigned NOT NULL default '0',
lastip varchar( 15 ) NOT NULL default '',
uniqueid varchar( 32 ) default NULL ,
PRIMARY KEY ( acctid )
) TYPE = MYISAM
MySQL said:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'logd.sql
Please help!
