Complete DataBase v11 by CDWriter

[CDWriter]

V11
***

Hello community

Here i release another complete sql release COMPLETE meaning with client data files to match.
These files are for the Centos USA last chaos release and should be compatible to gamigos release with a little change.

Accounts
** ******
There will be 1 account for this release, by now you all know how to add a account... also at this point you need to either delete the account steve and start with your own our leave steve there to get started. You also need to remove all the toons, and all there reference.
ill add LastChaos Password Hasher (by fabi202cool) a file needed to create one and get you started..

Thanks to dethunter12 WHO has shown me more bug then anyone else.
Thanks to anyone else who made the small effort to even POST anything, I at least owe u that ...

RELEASE Notes: v11
--------------------

What was Fixed:
-----------------
Fixed all shop keeper items.
Item Fixes
Booster potions.
Level 65 weapon attack speeds 11 in total.
All level 180 skills
Other skills needed work.

What was added:
------------------
Locked Case of Platinum Jewel
Case of Platinum Jewels       ** Added to Shop
Locked Case of Advanced Grade Jewels
Locked Case of Middle Grade Jewels
Case of Middle Grade Jewels       ** Added to Shop
Titans Clown Hat
Knights Clown Hat
Healers Clown Hat
Rogues Clown Hat
Sorcerers Clown Hat
Nightshadows Clown Hat
Pink April Fools Day Candy  *** NEW skill added to match
Blue April Fools Day Candy    *** NEW skill added to match
Case of Advanced Grade Jewels       ** Added to Shop
[Golden] Jewel Key
Jewel Fusion Scroll
Chaos Jewel Fusion Scroll
Costunes where all ready in the game, They added the whole Costume Set.
[Costume2]Titan Western Costume       ** Added to Shop
[Costume2]Knight Western Costume       ** Added to Shop
[Costume2]Healer Western Costume       ** Added to Shop
[Costume2]Mage Western Costume       ** Added to Shop
[Costume2]Rogue Western Costume       ** Added to Shop
[Costume2]Sorcerer Western Costume       ** Added to Shop
[Costume2]Titan Pirate Costume       ** Added to Shop
[Costume2]Knight Pirate Costume       ** Added to Shop
[Costume2]Healer Pirate Costume       ** Added to Shop
[Costume2]Mage Pirate Costume       ** Added to Shop
[Costume2]Rogue Pirate Costume       ** Added to Shop
[Costume2]Sorcerer Pirate Costume       ** Added to Shop
[Costume2]Night Shadow Pirate Costume       ** Added to Shop
[Costume2]Titan Carnival Costume       ** Added to Shop
[Costume2]Knight Carnival Costume       ** Added to Shop
[Costume2]Healer Carnival Costume       ** Added to Shop
[Costume2]Mage Carnival Costume       ** Added to Shop
[Costume2]Rogue Carnival Costume       ** Added to Shop
[Costume2]Sorcerer Carnival Costume       ** Added to Shop
[Costume2]Night Shadow Carnival Costume       ** Added to Shop
[Costume2]Titan Police Costume       ** Added to Shop
[Costume2]Knight Police Costume       ** Added to Shop
[Costume2]Healer Police Costume       ** Added to Shop
[Costume2]Mage Police Costume       ** Added to Shop
[Costume2]Rogue Police Costume       ** Added to Shop
[Costume2]Sorcerer Police Costume       ** Added to Shop
[Costume2]Night Shadow Police Costume       ** Added to Shop
Added Jewels to the Jewel cases, Based off official server.
Chaos Jems could be added, But No system for such, So no chaos Jems.

If you see anything wrong with anything i might have done please let me now.

**Extras
-----------
GSEditor <-- add a GS editor Thanks Wizatek for this public release.. Offsets from forum posts.
Time Stamp <-- Used to get a Correct Unix time for t_lc_time / Newproject_db needs to be there for Automation of Ranking list.
GameServer_d(USA) Newer___My Gameserver Lvl 180 gm 186 <-- WHAT i use so i can level to 180.
GameServer_d(USA) Newer.rar <-- Original release by blankname.
Readme for GameServer_d(USA) Newer.txt <-- Explains all about the Rar file also has all the OFFSETS by Blankname and Buff Npc Offsets where given by Douglas Origens.

**Notes
----------
Just remember i will reply to your post to understand the error better its not me attacking you in any way, Just need to understand how you worded the mistake...
Special thanks to Public Tool Designers, Wizatek, Hateme, Bash, Falo, and all the others i might have missed...
As long as there error reports ill keep releasing these bases ...something simple ill add the sql fix to this topic..

To DOWNLOAD this 11th release file go here: --> 2
My Server Files: --> 2

Simple WAY to get a client
*********************************
1. In Theory so far it looks like any USA client will work just update fully.
2. This UPDATED folder will be your NEW client..
3. Now Open my release u will see USA Files and Extras goto USA files copy the folders to the new client, BIN and DATA folders you must copy the content of each of them over into the same folders.
4. At this point you should be 100% compatible to my SQL. As long as you used the Extra folder and the GS in there. Steve account has 1 - 180 character and can support up to 8, if you can not get to this toon then you did not follow all what i put here in this new release... start again.

For every account you make you need to do the following to get the 8 character slot working. Lets get the 8 Character creation started ...Go into newproject_db find table t_extendcharslot and add in your char number (take from newproject_db_auth / bg_user - column user_code) date it starts and date it ends. I added my account name there for a reference. (Temp for now till someone figures the in-game item out).

5. Why did i not think of this before, This way we are using USA last chaos download sites for our NEW client and make it simple i always say.........

I have tested this myself and all works great, and still using it this way... any issues please let me now ...sorry for all the confusion before..

Please REPORT ERRORS CANT fix what i dont know of....

If you have any issues getting it started or loading the database please post it in the help section.

Client --> 2

Thanks to dethunter12 for this client upload..

CDWriter

V11, Took this long for others to start posting errors, lcdatabase.

[Nymphetamine]

Approved by Nymphetamine.
Status:Clean
 

[Assasin]

GooD Test :-)

[Kenpachi]

Nice work CD, always releasing fantastic work

[Sutz]

Nice release mate, keep it coming

[SnowFox]

Nice like always great release

 

Keep up the good working.

 

Regards,

SnowFox

[CyberClaus]

Good work CDWriter, keep up.

[CDWriter]

All chest locked our unlocked will work.i based it off what i could find off lc forum . if u are sure pm me what they should be .

i have it as follows

mid grade chest open jewels lvl 1-5

advance open 6-11

platnum opens 12-15

[CDWriter]

all locked jewel boxes should be added to npc drops but at a very very low drop rate ill add them randomy to npc for next realease......

[Shayna]

Nice CDWriter