+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep2 Support (https://lckb.dev/forum/forumdisplay.php?fid=166)
+------ Forum: Solved Topics (https://lckb.dev/forum/forumdisplay.php?fid=144)
+------ Thread: Mysql Qurry help (/showthread.php?tid=1742)
- CDWriter - 05-08-2013
Could someone give me a Query here i can check to see if a Npc has t_npc_regen location, i would like to check them 1 at a time but a query on all of the npcs or just 1 would be great ... I forgot how to query a second table together with another ...iam 50 years old you know .....well 48.
- Koko - 05-08-2013
Hey,
First, #moved to help section
Then, im not sure to get exactly what u wanna do, u wanna check if a npc is in t_npc_regen? If so this is enough:
SELECT * FROM t_npc_regen WHERE a_npc_index = YOUR_NPC_INDEX;
- CDWriter - 05-09-2013
oo Iam sorry ...but thanks for the code Kokokoul
SELECT * FROM t_npc_regen WHERE a_npc_idx = 1;
This works but the query u gave helped alot ..... for anyone who need this ....
Kokokoul woulds it be hard for a querry to pull npc item drops based of the item itself , lets say i want to see where (25) Apprentice Tiara
may drop from what npcs ?
Does not work
SELECT * FROM t_npc WHERE a_item_* = 1;
- CDWriter - 05-10-2013
all the test i have done so far no luck ....
does not work
SELECT * FROM t_npc WHERE a_it* = 123;SELECT * FROM t_npc WHERE a_item_0 <> a_item_19 = 123;
- CDWriter - 05-11-2013
Solved this query works Sloppy but works.
-- Finding a Drop item from any MOb
-- Change value below of the item number to find
SET @a=603;
SELECT a_index, a_name FROM t_npc WHERE t_npc.a_item_0 = @a or t_npc.a_item_1 = @a or t_npc.a_item_2 = @a or t_npc.a_item_3 = @a or t_npc.a_item_4 = @a or t_npc.a_item_5 = @a or t_npc.a_item_7 = @a or t_npc.a_item_8 = @a or t_npc.a_item_9 = @a or t_npc.a_item_10 = @a or t_npc.a_item_11 = @a or t_npc.a_item_12 = @a or t_npc.a_item_13 = @a or t_npc.a_item_14 = @a or t_npc.a_item_15 = @a or t_npc.a_item_16 = @a or t_npc.a_item_17 = @a or t_npc.a_item_18 = @a or t_npc.a_item_19 = @a;
CLOSE TOPIC
- Koko - 05-11-2013
Woops sorry didnt see before now.
Glad to know u found what u were looking for!
