Error
SQL query:
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 default '0',
`Charr` varchar( 16 ) NOT NULL default '',
`AccNr` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`Online` int( 8 ) unsigned NOT NULL default '0',
PRIMARY KEY USING BTREE(
`AccNr`
)
) ENGINE = MYISAM AUTO_INCREMENT =14 DEFAULT CHARSET = latin1;
MySQL said: Documentation
#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 (`AccNr`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT
"your MySQL server version for the right syntax to use near 'USING BTREE (`AccNr`)"
;O.:. lol insert them 1 BY 1 xP or use another Database account table,
Is LOTF
I will stop upgrade source, when i have done whats on my progress list.
Is not the full version and is not fully done.
I will upgrade version
If anyone want to upgrade it, then feel free to post the upgrade here
and i will add it.
If found any bugs,errors etc.
Please reply or PM me.
Thanks.
Click thanks if you use the source
or think is good. First flame and i remove source.
- = Not Finished • = Finished
•All NPC's from CoEmu
•Client with Textures & Effects
•Extra NPC's
•LadyLuck
•LotteryWomen
•Buy NPC Off
•WeaponSkills
•Reborn 1 & 2(With bless)
-GuardSkill
•Simon give Reborn Items
•Celestialstone & Exemption Token removed from ShoppingMall
•Coins
•Higher Upgrade rate in TC(soc chance is high)
•Compose,Enchant,Bless
•PremiumAdmin that exchange coins
10coins to CoinPack
CoinPack to 10coins
•VIP NPC's
+12Item Shop (Buy for coins)
Weapons (35)
HeadGear (30)
Accessory (40)
BodyGear (45)
Boots (30)
•Archer removed
Promotion NPC just make you Trojan.
-Shop with CelestialStone & ExemptionToken(Buy for coins)
C.S. 1coin
E.T. 2coins
•GuildWar give MiraculousGourd +12 -7 255Hp SDG SDG
•Jail + Arena (No PKP Gets)
•PvP Commands
Commands:
PLAYERCOMMANDS:
/aloot -for looting items ex. /aloot gold
/save -for saving cha, in case of rollback (Not needed really, but for sure)
/dc -disconnects you
/vps -shows your vp's
/mwh -open mobilewarehouse
/weather -changeweather
/refresh -updating your area
/clearinv -clearing your inventory
/tc -teleport to twincity
/removeskill -removingskill
/skill -learn skill
/cps -get cps
/money -get silvers
/prof -learn a weapon proficy
/level -give level (Max is 255)
/online -shows whos online and how many
/revive -revives you
GMCOMMANDS:
/cps -get cps
/learnall -learns you all skills
/statp -gives you statpoints
/gear -gives you full +12 ex. /gear trojan
/money -get silvers
/botjail -put one to botjail
/online -shows whos online and how many
/scroll -scrolls you to a place
Places:
tc
pc
am
dc
bi
ma
jail
arena
/i -makes you invisible
/goto -go to a player ex. /goto PhoeNix[GM]
/item event -start an item event
/aloot -for looting items ex. /aloot gold
/stats -shows your stat
/gwstart -starts gw
/vps -gives you vp
/recall -warps a player to you
/heal -gives you full heal
/msg -sends message from you (GM MESSAGE)
/service -sends message from service (GM MESSAGE)
/c -sends message from GM (GM MESSAGE)
/playerskill -remove skill
/playerlvl -gives level
/prof -learn a weapon proficy
/job -makes you to certain job ex. /job 15 -is for trojan
/revive -revives you
/numberlotto -starting lottery and finding the winner
/level -gives level
/unban -unbanning a player
/ban -banning a player
/warning -send warning to player
/item -gives you an item ex. /item Super KingsClub 12 7 255 13 13
/clearpkp -set pkpoints to 0
/skill -learn skill
/clearskills -removing all skills
/dc -disconnects you
/sr -sending message with "Server Restart in 10 seconds!"
and then "Server Restart in 5 seconds!"
and then server restart
/mm - teleports you to a certain place ex. /mm 1002 46 55 AND MANY OTHER THINGS
Download:
lol noob here...I downloaded ur source and it worked perfectly XD...but the thing is I don't see THAT many things as YOU said in the 1st post...DON'T take this an offense...I'm just saying DID I DO SOMETHING wrong? 0r is it something else lol? thnx ur source rockz BTW