+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Off-Topic (The Outer World) (https://lckb.dev/forum/forumdisplay.php?fid=198)
+---- Forum: General Discussion (https://lckb.dev/forum/forumdisplay.php?fid=147)
+---- Thread: Dont understand? (/showthread.php?tid=3082)
- CDWriter - 12-29-2013
I am helping another person fix there server and they tell me they have a private GS and there snare does not work so iam helping and they send me there gs .... Then they tell me that you need this sql also
///////Anticrash Ep3/////////
UPDATE newproject_data.t_npc SET a_item_18 = -1 WHERE a_item_18 NOT IN (SELECT a_index FROM newproject_data.t_item);
UPDATE newproject_data.t_npc SET a_item_19 = -1 WHERE a_item_19 NOT IN (SELECT a_index FROM newproject_data.t_item);
I was Shocked that a lot of you guys believe this .... This line deletes all the items in t_npc that should be dropped by npc but are NOT in t_items either event item our Quest item our what what ever, its going to remove the item at drop location table a_item_18 and 19 and replace it with a -1 .... Another words NOTHING .. and others are selling them these so called Special GS Wow ....guess its time for me to start selling worthless code and tell everyone its a major fix .....
Our i could tell you all out there dont waste your money on GARBAGE, Send it to me!!! since your wasting it all already for worthless garbage....
To fix these Find the missing item either from ep2 or ep1 ...... and if you cant replace it with a HP pots but don t delete it ....find out what it is first ..... It may be needed later for an event ...
How is this a fix our a special GS ??? if the items are missing from t_items deleting there drops in npc is not a fix too me .....
CDWriter
OO and PS the items missing are 6403 and 7649 ... the german lod reports 6403 as a Vertrauliches Schriftst?ck english its some kinda of event ticket ...not used as for the other one i could not find it ...
- Sickness - 12-31-2013
If people are buying files just because someone hands them a query and says they are special then they deserve to have their money taken.
- Walletman987 - 12-31-2013
I lold when I saw that query, what kind if wumbo dumbo would buy that? LOL