Complete DataBase V4 by CDWriter

[CDWriter]

V4
**
 
Hello community
 
Here i release another complete sql release COMPLETE meaning with client data files to match.
 
-- me
Login : steve
Password : steve
 
-- 2nd account
Login : shawn
Password : shawn
 
both of these account have GM 10 access, 1 toon per account and everything has been TRUNCATE.
 
 
Today I give you V4, Now this is still work in Progress and if you do not report errors i cant fix them for next release ..
Please report Errors 
 
-- German
Heute gebe ich euch V4, Nun ist dies immer noch in Arbeit, und wenn Sie nicht melden Fehler i cant lösen für nächste Release ..
Bitte melden Sie Fehler
 
-- Russian
áõóþôýѠѠôðю òðü V4, ÑÂõùчðѠÑÂтþ òÑÂõ õщõ ýõ÷ðòõршõýýþõ ÿрþø÷òþôÑÂтòþ ø õÑÂûø òы ýõ ÑÂþþñщðть þñ þшøñúðх Ѡýõ üþóу øÑÂÿрðòøть øх ôÃȄʄÂûõôующõóþ рõûø÷ð ..
ßþöðûуùÑÂтð, ÑÂþþñщðùтõ þñ þшøñúðх
 
I had many ppls help who answered question when i needed them.
 
Thanks everyone who helped, and everyone who has release public tools ....
As for what was done this time.
 
RELEASE V4
----------
 
Same Catalog and sql to match (USA Current) few errors (items Not added to DataBase), Use only if you want to .
Fixed ALL or most of the Seals ..If i might have missed any please let me know
Fixed the 1 reported Potion (Strong/Medium Medicine)....
Started Ranking list but still must be ran from a GM every 7 days.. (title reward Limits)
 
 
Just remmeber 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...
 
 
CDWriter
 
 
To DOWNLOAD this 4th release file go here:
 
 
2

 
 
Client
*******
lastchaos_us_installer_20120618.exe
2
another link  

2!TFhyEKAQ!W8fP7kVb7U_1TXQwQZlFCA5amSt2_FqxoMJFuTa6YMU
 
Thanks to dethunter12
 
 
This time i will be adding Client Bin file folders becuase some of the links on this site has been changed and you can not just install lastchaos_us_installer_20120618.exe or use LCGN with out the included files not sure never did the LCGN...
 
 
HOW TO FIX CLIENT
*****************
 
1. The best way is to download or find lastchaos_us_installer_20120618.exe (Maybe someone will send it to a site I wil not sorry) and then install it, then update it to current USA files. (If you go the LCGN way i do not know how to get it to what my release is made for, Please dont ask).. to continue,
 
2. Lets then rename the folder and install it again but do not UPDATE. This NONE UPDATED folder will be your NEW client.. 
 
3. what u need to do is OPEN the folder with the fully UPDATED Client and go into the DATA folder copy 
              EFFECTS and ITEMS
to your folder, This will fix the new skills and new items i added to this release... 
 
4. Now Open my release u will see BIN and DATA folders you must copy the content of each of them over into the same folds. 
 
5. At this point you should be 100% compatible to my SQL. Steve account has 1 - 180 Sorcerer fully Geared in 180 Gear if you can not get to this toon then you did not follow all what i put here in this new release... start again.
 
 
Extra
*****
 
I myself use 2

 
but thats a oppion you have to chooise your self.
 
 
ONLY on toxic-l33t.ddns.net
Please REPORT ERRORS CANT fix what i dont know off....

 

[Natzn]

Nice thanks

[peke1996]

Nice !

[wowa296]

i can´t drop lvl 180 armor

and weapons lol its buggy 

[CDWriter]

thanks you simple fix...... would have been nice if this was reported by others in Version 1 or 2 ..

 

its just a flag fix .....if that helps for you now .... could u give me a Name of one of the items that will not drop ....

 

 

so i can check the flag of that item and run a query on it in sql..

[CDWriter]

@2 

 

i can´t drop lvl 180 armor

and weapons lol its buggy 

 

all 180 items are droppable i am not sure what your using but its not my data...

 

On my sql run this query ....

SELECT a_index, a_set_4, a_name, a_level, a_flag, a_job_flag, a_rare_index_1 FROM t_item WHERE a_flag = 134743076;

but works ..that flag is none droppable tagged .....all 180 items are flagged with 134742078,

The query above list all 120 and 90 level armor that does not drop and is easily fixed with a new code ......

 

and items from 8909 - 9003 are flagged on Original server with 134743076. and are not droppable.

[lcclub]

2013/06/30 07:44:36 :: Error: Character DB Check: Not Found t_cashitemdate.a_xxx_new! > 

2013/06/30 07:44:36 :: Cannot Connect DB!! > 

[Natzn]

 

2013/06/30 07:44:36 :: Error: Character DB Check: Not Found t_cashitemdate.a_xxx_new! > 
2013/06/30 07:44:36 :: Cannot Connect DB!! > 
 

Go to your Char Database and rename the Table "t_cashItemdate" into "t_cashitemdate". (The big "I" to an small "i")

[CDWriter]

@2

 

 

2013/06/30 07:44:36 :: Error: Character DB Check: Not Found t_cashitemdate.a_xxx_new! > 

2013/06/30 07:44:36 :: Cannot Connect DB!! > 

 

did you copy over to your server the Newer Gameserver_d i supplied ......

 

Il start supporting Both of them files .... But your not using my data base eather because in newporject_db on my release i have 

 

t_cashItemdate

[lcclub]

Go to your Char Database and rename the Table "t_cashItemdate" into "t_cashitemdate". (The big "I" to an small "i")

ok, thanks

but update fail.