Alright so I did some shiz in appserv.
Here's what I did.
I went to SQL and put this.
and I get the error
Anybody know whats the deal?
I've reinstalled appserv many times and it does not help.
Here's what I did.
I went to SQL and put this.
Code:
CREATE TABLE `cq_npc` ( `id` int(4) unsigned zerofill NOT NULL default '0000', `ownerid` int(4) unsigned default '0', `playerid` int(4) unsigned default '0', `name` char(15) character set utf8 collate utf8_bin default '????¡§1??', `type` int(4) unsigned zerofill default '0000', `lookface` int(4) unsigned zerofill default '0000', `idxserver` int(4) default '-1', `mapid` int(4) unsigned zerofill default '0000', `cellx` int(4) unsigned zerofill default '0000', `celly` int(4) unsigned zerofill default '0000', `task0` int(4) unsigned zerofill default '0000', `task1` int(4) unsigned zerofill default '0000', `task2` int(4) unsigned zerofill default '0000', `task3` int(4) unsigned zerofill default '0000', `task4` int(4) unsigned zerofill default '0000', `task5` int(4) unsigned zerofill default '0000', `task6` int(4) unsigned zerofill default '0000', `task7` int(4) unsigned zerofill default '0000', `data0` int(4) NOT NULL default '0', `data1` int(4) NOT NULL default '0', `data2` int(4) NOT NULL default '0', `data3` int(4) NOT NULL default '0', `datastr` char(15) character set utf8 collate utf8_bin default '?T', `linkid` int(4) unsigned zerofill NOT NULL default '0000', `life` smallint(2) unsigned zerofill NOT NULL default '00', `maxlife` smallint(2) unsigned zerofill NOT NULL default '00', `base` int(4) unsigned zerofill NOT NULL default '0000', `sort` smallint(2) unsigned zerofill NOT NULL default '00', `itemid` int(4) unsigned zerofill default NULL, PRIMARY KEY (`id`) )
PHP Code:
#1064 - 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 'collate utf8_bin default '????¡§1??',
`type` int(4) unsigned
I've reinstalled appserv many times and it does not help.