[Request] Queries

[SectorSeven]

I need a few queries! +Rep if you can provide the query for me.

First, I need that mouseflags query.

Second, I need a query that will set, for ids X through Y, the heroicpercentchance to 100% in the itemloot table.

Third, I need a query to set, for ids X through Y, the amount to 0 for min and max, for the vendors table.

Thats all I need for now! Thanks.

[SectorSeven]

come on... the mouseflags one is the easiest

[Spartansp]

you meen this one?

ALTER TABLE creature_names CHANGE mouseFlags info_str VARCHAR(500) NOT NULL;
UPDATE creature_names set info_str=""

[SectorSeven]

yes sir +rep

[SectorSeven]

Well, i cant.
but here is what i needed:
every entry in mouseflags changed to 0

[latruwski]

I need a few queries! +Rep if you can provide the query for me.

First, I need that mouseflags query.

Second, I need a query that will set, for ids X through Y, the heroicpercentchance to 100% in the itemloot table.

Third, I need a query to set, for ids X through Y, the amount to 0 for min and max, for the vendors table.

Thats all I need for now! Thanks.

2nd:

UPDATE itemloot SET heroicpercentchance = '1' WHERE itemid IN (select entry from items where entry between X and Y );

change X and Y to itemIDs so for example from itemID 0 to 1000 you must change x to 0 and Y to 1000

3th:
there is no min and max column in there?
if you mean change amount to 0 for itemID X to Y then use this:

UPDATE vendors SET amount = '0' WHERE item IN (select entry from items where entry between X and Y );

again change X and Y to itemIDs (same as 2nd query)




grtz