how to sync client and data

[tvquan90]

i have an data d14 and i want sync this in old client. Please help me how is sync

[MentaL]

[lemoniscool]

err .. i guess by "sync" you mean how to get the data from your database into the client?
if yes there is a stored procedure in most of the databases called __GetMediaLines you can get media lines for items and mobs/npcs with it. if you dont have this stored procedure tell me and ill paste it here. if you have it just execute a query like:

exec __GetMediaLines 1, 'ITEM_%_14%'

the 1 tells it to query data for items, if you use 2 it will query mob/npc data. the string that comes after the number is for the CodeName128 in _RefObjCommon table. Just in case you dont know % is a wildcard operator meaning all items that start with ITEM_ and containing _14 somewhere after that will be shown.

The data this query spits out goes into itemdataXXXXX.txt or characterdataXXXXX.txt depending on what kind of data you were querying. the XXXXX stands for numbers, in your case since the items you want to insert into the client are new with ids that are probably over 40000 the full filename will be itemdata45000.txt

I hope you know how to find these files inside the client. if not im sure i can find a link to a guide about it

greetz

[tvquan90]

i try impot file of data to media and client talk me not reponding. I use another client i disconnect game when i chose character. Please help me

[lemoniscool]

just a tip .. use a clean client and a clean database and add everything you need yourself.. changing between different clients wont do any good

[tvquan90]

i dont know any client is right. I want to sync data and client. I try impot data to client but client crash