[RELEASE]UltimatePvp Source

[Adziunia]

umm donno why it wont work for me o.O i just have error when i am executing sql file here look and tell me whats wrong
[Err] 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 'USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1' at line 15
[Err] CREATE TABLE `accounts` (
`AccountID` varchar(16) NOT NULL DEFAULT '',
`Password` varchar(64) NOT NULL DEFAULT '',
`LogonType` int(8) unsigned NOT NULL DEFAULT '0',
`LogonCount` int(10) unsigned NOT NULL DEFAULT '0',
`Status` int(8) unsigned NOT NULL DEFAULT '0',
`Charr` varchar(16) NOT NULL DEFAULT '',
`AccNr` int(10) unsigned NOT NULL AUTO_INCREMENT,
`Online` int(8) unsigned NOT NULL DEFAULT '0',
`Email` varchar(255) NOT NULL,
`SecretQuestion` varchar(255) NOT NULL,
`Answer` varchar(255) NOT NULL,
`Identification` varchar(8) NOT NULL,
`WebPassword` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`AccNr`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully

i made database:
name: coproj
character set: utf8 -- UTF-8 Unicode
collation: utf8_general_ci

[ØnëwïngëÐ]

Originally Posted by Adziunia

umm donno why it wont work for me o.O i just have error when i am executing sql file here look and tell me whats wrong
[Err] 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 'USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1' at line 15
[Err] CREATE TABLE `accounts` (
`AccountID` varchar(16) NOT NULL DEFAULT '',
`Password` varchar(64) NOT NULL DEFAULT '',
`LogonType` int(8) unsigned NOT NULL DEFAULT '0',
`LogonCount` int(10) unsigned NOT NULL DEFAULT '0',
`Status` int(8) unsigned NOT NULL DEFAULT '0',
`Charr` varchar(16) NOT NULL DEFAULT '',
`AccNr` int(10) unsigned NOT NULL AUTO_INCREMENT,
`Online` int(8) unsigned NOT NULL DEFAULT '0',
`Email` varchar(255) NOT NULL,
`SecretQuestion` varchar(255) NOT NULL,
`Answer` varchar(255) NOT NULL,
`Identification` varchar(8) NOT NULL,
`WebPassword` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`AccNr`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully

i made database:
name: coproj
character set: utf8 -- UTF-8 Unicode
collation: utf8_general_ci

Bumping old threads LOL i dont have the source =\

[Huseby]

Dont bump.

#Closed