Mysql Qurry help

[CDWriter]

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]

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]

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]

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]

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]

Woops sorry didnt see before now.

Glad to know u found what u were looking for!