DataBase v13-TD and Server by CDWriter

[CDWriter]

V13-TD
******

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..

RELEASE Notes: v13-TD
------------------------
If you do not download my Centos Server files then Tarain Dungeon Map will not work.
Like all ways your welcome to use any part of my files.

***********BUT PLEASE DONT CHANGE THINGS THEN COMPLAIN HOW MY FILES ARE BAD.*************************
If there is a bug please report and someone our i will help you with it. If we can ....

What was Fixed:
-----------------
Added Tarain Dungeon Teleport
Fixed all Quest for TD and added the items to npcs
Chapel Fix .. No more Mobs frozen in time inside chapel...... (This had to be bad for awhile)
Costumes Fixed
Fixed Item stats on a few things 60-175 Wep and armor (thanks guxpw)
Removed Npc in Tarain Dungeon till i can figure out the Pos-H.
Fixed Crafting Npc You can know create and get the skill ..

Thinks that will not be able to Fix.
-------------------------------------
Affinity Boosters (Not in GS)
In game 8 Charater slots Items (Not in GS)
Chaos Jewels System (Not in GS)
Moru of Magic (Not in GS)

What was added In v12
----------------------
Tarain Dungeon (Thanks Ucaff, Released with Permission As a Package)

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 13th release file go here: --> 2
Another download sit for 13th release : 2
My Tarain Dungeon Server Files: --> 2

****************SETUP 1 - 6 Must be done*********************
Simple WAY to get a client and to Setup Tarian Dungeon
********************************************************

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. Get client ready for Tarain Dungeon. you need to open the client you updated. DO not add in my release YET ....
goto DATA/World/STAEIANA(cave)3 delete the 3 files there leaving the folders alone . they would be

STREANA(cave)3.tbn <-- DELETE
STREANA(cave)3.wld <-- DELETE
STREANA(cave)3.wtr <-- DELETE
Ska <-- KEEP
Texture <-- Keep

now open your DATA/World/Tarian_dungeon
and copy ALL the contents to STAEIANA(cave)3 over writing everything...
Now you should see in both folders STAEIANA(cave)3 and Tarian_dungeon these 3 files.

tarian_dungeon.tbn <-- rename
tarian_dungeon.wld <-- rename
tarian_dungeon.wtr <-- rename

and these 2 folders
Ska
Texture

rename all 3 files to read.

STREANA(cave)3.tbn
STREANA(cave)3.wld
STREANA(cave)3.wtr

In both folders......No worries you will still have STAEIANA(cave) caves there ...

this is all you need to do with the client ....... Simple and Small...... (So far of the testing ive done all works great.)

4. 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.

5. 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.

6. I will not release tarain dungeon by itself it is made for my release and my release only for now, I will maybe in the future give you all the way to use it, and add it to your own server but for now ... If you like you can pick it apart and use it but do not ask for help.

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

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..