Inject Item.sql into DB

[Covea]

#

[STIV123]

Ok ... steps :

1. Double - Click it
2. It will open a query in SQL
3. HIT EXECUTE. Wait for finish>>

Think youre done :P

[JohnHeatz]

Just remember that when you have a .sql file, it means that there is a query in it, what you have to do is simply execute it on your SQL and it will take effect

[STIV123]

Oh and btw Remember restarting Server... for the effect... ^_^ And Importing in the client, of course.

[hellgunner]

I stumble upon this, for I was trying to do this too. Importing into the client, meaning into the data.sah? Or make new client (Not a completely new client) Or import the item.sdata into the data.sah?

[TeddyBear94]

importing into the client back ( not the sql file so still item.sdata) data.sah and data.saf = part of the client

[hellgunner]

I guess my question is, after I query it to the Database, how do I make it so it can be used in the new data.sah/client etc? I imported the item.sdata to the client (data.sah) but I get a character load error. What do I need to do to fix that?

[TeddyBear94]

if u get char load error that mostly happends because u imported the item.sdata in the wrong way back. remember if u extract stuff press "no" if u import stuff press "yes" just 1 execption if u export npcquest.data take care that it is decrypted to use it for ur server files. good hint always have back up clients with back up data.sah´s and data.saf´s ( they only work toghter)
after u edit the item.sdata safe it ones as item.sdata and ones as item.sql item.sdata goes back into data.sah for the client and the item.sql will be runned in db.

[getupkid77]

after i make new data.sah and data.saf can i move them directly to replace the ones in my client or do i have to make a patch? because i want to test it first

i made an item.sql from my item.Sdata ran it and executed it but ran with errors and the armor was not replaced anyone have an idea of what i did wrong ?