[RELEASE]UnderCoverCoSource(AndreaCo PvP)

A bug in the sql file for ya :)

Code:

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

Quote:

Originally Posted by grillmad

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.

Whats in the source?:

Spoiler

- = 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:
[Only registered and activated users can see links. Click Here To Register...]

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 :)