Item in NPC Problem

01/27/2015 08:07 !Ego#1

Hello Guy's ,,
I Was adding a Item to my New NPC
and when i finished the line on RefShopGoods
I closed the Table and Opened it again
and the line disappeared o.O ? Why ?

I discovered that the table order change after i close it
and no prog from server files progs gives me error
but when i open the client i can't find the item on the NPC ! :V

and iam sure that i added my lines 10000% correct on the 4 tables

01/27/2015 10:41 Zodiao#2

Copy those lines into your media:

Code:

--RefShopgoods:
SELECT * FROM _RefShopGoods where RefPackageItemCodeName like '%CODE NAME HERE%'
/****/
--RefPackageItem
SELECT * FROM _RefPackageItem where CodeName128 like '%CODE NAME HERE%'
/***/
--RefScrapPacakgeOfItem--I don't remember the name so well.
SELECT * FROM _RefScrapPackageOfItem where RefPackageItemCodeName like '%CODE NAME HERE%'

Texts names:
RefShopgoods/RefPackageItem/RefScrapOfPackageItem
Path:
media/server_dep/silkroad/textdata/

01/27/2015 10:50 !Ego#3

do you mean to use the query on the SQL ?
and the lines i got paste in media ?

bro lol crush in client

tnx bro working now i used the query to get the 4th table line ^^

01/27/2015 21:29 Dunarsund#4

You added the line database sided?. Maybe the database puts the line on alphabetic order so you can find it back easier. I'm not sure but you can try and see

01/28/2015 00:04 asanoftw#5

depends on line code, if u added on ACCESORRY_TAB3 etc, u will found them all in 1 place. i hope i helped.

01/28/2015 00:16 !Ego#6

Tnx guy's but the problem was that :
I added the lines in DB Side but i didn't with Client
Thx for attention guy's

01/28/2015 09:04 Exo#7

PS: Always order the tables which contains IDs by IDs so you can find recently added shit faster.

#casesolved