[SOLVED] [Trinity] "Cooking Items" default gold cost won't be removed

[Synth]

Hello Emudevs,today i make an npc for "Professions Reagents" and i add custom gossips in and i have add alot of reagents on each gossip and i make query's that will remove gold cost from those reagents but i make a query for "Cooking" for i remove the gold cost from whole items on this gossip but the default gold won't be removed.
That's the SQL Query:

-- Cooking
UPDATE `item_template` SET `BuyPrice`='0' WHERE entry in (728,2697,2698,2699,2700,2701,2889,3678,3679,3680,3681,3682,3683,3734,3735,3736,3737,4609,5482,5483,5484,5485,5486,5487,5488,5489,5528,6039,6025,6326,6328,6329,6330,6368,6369,6661,6892,7678,12226,12227,12228,12229,12231,12232,12233,12239,12240,13939,13940,13941,13942,13943,13944,13945,13946,13947,13948,13949,16072,16110,16111,16767,17062,17200,17201,18046,18160,18267,20075,21025,21099,21219,22647,27684,27685,27686,27687,27688,27689,27690,27691,27692,27693,27694,27695,27696,27697,27698,27699,27700,27736,30156,31674,31675,33869,33870,33871,33873,33875,33925,34126,34413,34834,35564,35566,39644,39692,43017,43018,43019,43020,43021,43022,43023,43024,43025,43026,43027,43028,43029,43030,43031,43032,43033,43034,43035,43036,43037,43505,43506,43507,43509,43508,43510,44858,44859,44860,44861,44862,44954,44977,46710,46803,46804,46805,46807,46806,46810);
UPDATE `item_template` SET `SellPrice`='0' WHERE entry in (728,2697,2698,2699,2700,2701,2889,3678,3679,3680,3681,3682,3683,3734,3735,3736,3737,4609,5482,5483,5484,5485,5486,5487,5488,5489,5528,6039,6025,6326,6328,6329,6330,6368,6369,6661,6892,7678,12226,12227,12228,12229,12231,12232,12233,12239,12240,13939,13940,13941,13942,13943,13944,13945,13946,13947,13948,13949,16072,16110,16111,16767,17062,17200,17201,18046,18160,18267,20075,21025,21099,21219,22647,27684,27685,27686,27687,27688,27689,27690,27691,27692,27693,27694,27695,27696,27697,27698,27699,27700,27736,30156,31674,31675,33869,33870,33871,33873,33875,33925,34126,34413,34834,35564,35566,39644,39692,43017,43018,43019,43020,43021,43022,43023,43024,43025,43026,43027,43028,43029,43030,43031,43032,43033,43034,43035,43036,43037,43505,43506,43507,43509,43508,43510,44858,44859,44860,44861,44862,44954,44977,46710,46803,46804,46805,46807,46806,46810);

Result of this both query's"

/* Affected rows: 0  Found rows: 0  Warnings: 0  Duration for 2 queries: 0.000 sec. */

I don't know what is the problem but i make custom query's for i remove gold cost from some gossip on this npc but this one won't work.
Anyone have an idea what is the solution of this issue?

Thank you !
Best regards,
Synth!

 

[Tommy]

Instead of having two queries, it can be one:

UPDATE `item_template` SET `BuyPrice`='0' AND `SellPrice`='0' WHERE entry in (728,2697,2698,2699,2700,2701,2889,3678,3679,3680,3681,3682,3683,3734,3735,3736,3737,4609,5482,5483,5484,5485,5486,5487,5488,5489,5528,6039,6025,6326,6328,6329,6330,6368,6369,6661,6892,7678,12226,12227,12228,12229,12231,12232,12233,12239,12240,13939,13940,13941,13942,13943,13944,13945,13946,13947,13948,13949,16072,16110,16111,16767,17062,17200,17201,18046,18160,18267,20075,21025,21099,21219,22647,27684,27685,27686,27687,27688,27689,27690,27691,27692,27693,27694,27695,27696,27697,27698,27699,27700,27736,30156,31674,31675,33869,33870,33871,33873,33875,33925,34126,34413,34834,35564,35566,39644,39692,43017,43018,43019,43020,43021,43022,43023,43024,43025,43026,43027,43028,43029,43030,43031,43032,43033,43034,43035,43036,43037,43505,43506,43507,43509,43508,43510,44858,44859,44860,44861,44862,44954,44977,46710,46803,46804,46805,46807,46806,46810);

Anyway, I ran that and it worked (Only showing a few since you have a lot of ids):

 

[Synth]

Instead of having two queries, it can be one:

UPDATE `item_template` SET `BuyPrice`='0' AND `SellPrice`='0' WHERE entry in (728,2697,2698,2699,2700,2701,2889,3678,3679,3680,3681,3682,3683,3734,3735,3736,3737,4609,5482,5483,5484,5485,5486,5487,5488,5489,5528,6039,6025,6326,6328,6329,6330,6368,6369,6661,6892,7678,12226,12227,12228,12229,12231,12232,12233,12239,12240,13939,13940,13941,13942,13943,13944,13945,13946,13947,13948,13949,16072,16110,16111,16767,17062,17200,17201,18046,18160,18267,20075,21025,21099,21219,22647,27684,27685,27686,27687,27688,27689,27690,27691,27692,27693,27694,27695,27696,27697,27698,27699,27700,27736,30156,31674,31675,33869,33870,33871,33873,33875,33925,34126,34413,34834,35564,35566,39644,39692,43017,43018,43019,43020,43021,43022,43023,43024,43025,43026,43027,43028,43029,43030,43031,43032,43033,43034,43035,43036,43037,43505,43506,43507,43509,43508,43510,44858,44859,44860,44861,44862,44954,44977,46710,46803,46804,46805,46807,46806,46810);

Anyway, I ran that and it worked (Only showing a few since you have a lot of ids):

It worked when you ran the query but in-game won't work
Also the result of this query is:

/* Affected rows: 0  Found rows: 0  Warnings: 0  Duration for 1 query: 0.015 sec. */

And on DB i check for some ids buyprice is 0 and sell price 0.
I delete my cache everytime.Also my friends can't see it so i'm sure its not cilent side.

 

[Tommy]

Works ingame for me. I don't see how your query is failing and it isn't working ingame. Did you restart the server?

 

[Synth]

Works ingame for me. I don't see how your query is failing and it isn't working ingame. Did you restart the server?

Yes i did,how the other work so.Do you skype i can show you on TV how its failing i'm really wiered.
Here is a simple screenshots: