DataBase v12-TD by CDWriter
#1

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

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: v12-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 THING 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:
-----------------
Re-did all the new fixes from v11 so all IDs Matched Current USA release.
Fixed all the titles that needed a time Expiration.
Fixed the 175 Armor and Weapons to have Stats. (Thanks Mendozza)
Deleted all the Npc Out side Terrain Dungeon
Fixed Npcs

What was added:
------------------
Tarain Dungeon (Thanks Ucaff, Released with Permission As a Package)
All Spawns to Tarian_dungeon (Thanks YouTube and me)
All Room titles and Map.

What needs added Yet:
-----------------------
World Tarain Map needs edited, Pointing to zone 41 needs changed to 26. In order to teleport correctly into tarian dungeon.
If above can not be fixed then Teleport guy needs added.

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 12th release file go here: --> 2
My Tarain Dungeon 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. 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).

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

 

 

[success=Virus Scan]Scanned by MaX - Passed[/success]

#2
Nice release, Thankyou Smile

#3
Thanks,great work ofc.

#4
Thx bro

#5
:o, nice release Big Grin

#6
Thank

#7
good man

#8
good job CDWriter  Smile

#9
good job bro appricated 100%

#10

If you come to my lcdatabase forum you will get all fixes and updates ..... but to help a lot here ill add to this the fixes so far.......

 

 

Here we go the teleporter into Tarain dungeon ....and a fix to come out the Particle teleports from inside.

2

----------------------------------------------------------------------------------------------------------------

OK here is the complete Quest fix for all the 160 - up quest issues ..

2

-------------------------------------------------------------------------------------------------------

Chapel Fix .... No more Mobs frozen in time inside chapel...... This had to be bad for awhile ...i find out about it today ...damn community ....

 

UPDATE `newproject_data`.`t_zonedata` SET `a_zone_index`=33, `a_name`=Chapel 1F, `a_width`=1920, `a_height`=1920, `a_ylayer`=1, `a_attrmap`=data/Ascadia_MondShine_Cappella_1_1920_1920_0.sat, `a_heightmap`=data/Ascadia_MondShine_Cappella_1_1920_1920_0.[CeNsOrEd], `a_areacount`=20, `a_canusemempos`=0, `a_poscount`=8, `a_posylayer`=0 0 0 0 0 0 0 0, `a_posleft`=374 450 298 1013 992 831 1258 1407, `a_postop`=800 662 666 925 809 394 397 545, `a_posright`=370 445 303 1008 998 837 1253 1417, `a_posbottom`=795 667 661 930 815 400 402 550, `a_posmemo`=![0] ÀÃâ€Ã‚±Â¸![1] ȸ¶û1Ãþ¿¡¼­ ȸ¶û2ÃþÀ¸·Î ¿Ã¶ó°¡´Â ÀÃâ€Ã‚±Â¸![2] ¹¦½Ç·Î ³»·Ã°¡´Â ÀÃâ€Ã‚±Â¸![3] ȸ¶û2Ãþ¿¡¼­ ȸ¶û 1ÃþÀ¸·Î ³»·Ã°¨![4] ȸ¶û 2Ãþ¿¡¼­ ȍæ°ü 1ÃþÀ¸·Î ³»·Ã°¨![5] ȍæ°ü¿¡¼­ ¿¹¹è´ç º»°ü ÀÃâ€Ã‚±Â¸Â·ÃŽ ³»·Ã°¨![6] ȍæ°ü 1Ãþ¿¡¼­ ȸ¶û 2ÃþÀ¸·Î ¿Ã¶ó°¨![7] º»°ü¿¡¼­ ȍæ°üÀ¸·Î ¿Ã¶ó°¡´Â ÀÃâ€Ã‚±Â¸, `a_cansummonpet`=1, `a_canmountpet`=0, `a_continent_no`=1, `a_minlevel`=0, `a_maxlevel`=999, `a_flag`=0, `a_treasurecount`=0, `a_treasure_area`=, `a_treasurecount_dungeon`=0, `a_treasure_dengeon`= WHERE (`a_zone_index`=33);
-----------------------------------------------------------------------------------------------------------------------------------------------------------------

Read more: 2



Forum Jump:


Users browsing this thread: 1 Guest(s)