a Navicat question->Sellprice

[secretdragon008]

Hey there, i got a question on the navicat sellprice.
is it possible to mark all the sellprice on 1 page,and set that sellprice to 0.
i mean,in normal must i change 1 and 1,is it a way to change all on 1 time?

well need it,since almost all of the items in the shoping mall is free. so the players use to buy items for free and sell them to get easy money.
and i dont want that.

and to change 1 and 1 item sellprice,will take very long time.

[Le Froid]

i dont understand your question

[Daxo]

Hmm are you saying you want your items to cost gold but not like tokens or honor points?

[secretdragon008]

i dont understand your question

when i is in navicat,i open the items table.
and i go to the collum Sellprice.

is it a way you mark all the sellprice in 1 row on the page,and change that nummbers i have marked to 0,in 1 press/push/click.

to normal i must change the items sellprice 1 and 1.

[Illidan1]

He is saying
" Alot of the items in my Mall's Dont cost any Gold, Causing Players
To buy them items and then sell them for Easy money, But i don't wont that, so
is there a way that i can change all the Items Sell price at once so they don't get money or they cant sell them
at all?"

He wont's to change all the Sell prices on 1 page of Naivcat to "0"

[secretdragon008]

Hmm are you saying you want your items to cost gold but not like tokens or honor points?

no,i dont mean the buyprice,but the sellprice.
i want to change it to 0,so you dont get any money,when you try to sell it.

ofc i know how to change it to 0.
but that is only 1 and 1.
is it a way to change all to 0 in 1 time.

[Illidan1]

You could use this Sql Format to do it

UPDATE `items` SET `sellprice`='0' WHERE (`entry`='ItemID')
UPDATE `items` SET `sellprice`='0' WHERE (`entry`='ItemID')
UPDATE `items` SET `sellprice`='0' WHERE (`entry`='ItemID')
UPDATE `items` SET `sellprice`='0' WHERE (`entry`='ItemID')
UPDATE `items` SET `sellprice`='0' WHERE (`entry`='ItemID')
UPDATE `items` SET `sellprice`='0' WHERE (`entry`='ItemID')

Were it says "ItemId" change it to the Id of the Item you wont to
Change the sell price to "0"

You can just add more of these \/

UPDATE `items` SET `sellprice`='0' WHERE (`entry`='ItemID')

If it is more then them Items

When put the sql into a note pad And when you have added all the Item
Id's that you wonted to change go to File > Save as
and call it "Items.sql" With out Quotes

Or you could tell me the Item Id's for the itme you wont to chnage Sell price to
and i could make the Sql for you

[secretdragon008]

You could use this Sql Format to do it

UPDATE `items` SET `sellprice`='0' WHERE (`entry`='ItemID')
UPDATE `items` SET `sellprice`='0' WHERE (`entry`='ItemID')
UPDATE `items` SET `sellprice`='0' WHERE (`entry`='ItemID')
UPDATE `items` SET `sellprice`='0' WHERE (`entry`='ItemID')
UPDATE `items` SET `sellprice`='0' WHERE (`entry`='ItemID')
UPDATE `items` SET `sellprice`='0' WHERE (`entry`='ItemID')

Were it says "ItemId" change it to the Id of the Item you wont to
Change the sell price to "0"

You can just add more of these /


If it is more then them Items

When put the sql into a note pad And when you have added all the Item
Id's that you wonted to change go to File > Save as
and call it "Items.sql" With out Quotes

Or you could tell me the Item Id's for the itme you wont to chnage Sell price to
and i could make the Sql for you

do you realy want to change that for me,since its a very long list.
since its all the items in the chrispee's shoping mall.

[Illidan1]

Yes i will, just give me a list of all the Item Ids

[secretdragon008]

itemid:

28588
28783
29982
30080
32343
32363
28504
32253
29360
23554
23555
29275
29346
28524
28572
30723
28770
28768
29962
30103
30865
32237
32269
30901
32471
29348
28584
32944
29948
31334
29355
29359
28658
28633
28604
30732
28782
30021
29981
29988
32344
30883
32374
30908
29356
23541
28428
28573
28429
28430
29993
30902
18582
31332
29362
23540
28425
28729
28749
30733
28426
28802
30082
30095
28427
30874
32369
30881
30910
32838
32837
28774
32248
31322
32854
23546
28440
28441
28800
30090
28442
32332
31342
29353
23544
23556
28437
28522
28657
28438
28771
30058
28439
29996
30108
32262
32943
30918
32500
31323
32756
28581
30724
29949
32325
29351
28772
30105
30906
32336
31318
23543
28434
28587
30722
28435
28773
28794
28436
32348
23542
28431
28432
28767
29924
28433
32254
32236

i think this is only the items that sell for very much money.and all this items is
only from 1 vendor, the weapon+100.
the damn soul cleaver cost free and sells for almost 20g,or the illdians sword that is 25g

[Illidan1]

It will be done within 2 hours lol

[secretdragon008]

It will be done within 2 hours lol

okey,thanks.

yes thats was why i only needed 1 vendor to,to save very much time to you.
i cant think of,how long the list is....if i put all the vendors there.

[Illidan1]

Yeah, Lol so you wont them all to have the Sell price all set to "0"?

[secretdragon008]

Yeah, Lol so you wont them all to have the Sell price all set to "0"?

thats right....but most the weapon vendors..its the weapons thats sells for very much,not so much on the armor.

[secretdragon008]

Illidan1, did you make that list to me?
with the id`s.
since you sayd it will be done within 2 hours,and now its have been over a day.