[Guide] Finally how to add Avatar in Item Mall VSRO Files

[GroundRave]

Originally Posted by wolfilein

Any1 knows how to change all Saletags to 0 in Management Studio 2008?
I don't want to do all 1879 pages manually lol

UPDATE _RefPackageItem SET SaleTag='0' WHERE SaleTag='1';

UPDATE _RefPackageItem SET SaleTag='0' WHERE SaleTag='8';

UPDATE _RefPackageItem SET SaleTag='0' WHERE SaleTag='32';


i hope that helped you

[lepitismak]

on SQL 2008 i can see only top200 row.
How i can change for see all row on table?

[taner9090]

thx thats work )

[carl0s_]

Originally Posted by GroundRave

UPDATE _RefPackageItem SET SaleTag='0' WHERE SaleTag='1';
UPDATE _RefPackageItem SET SaleTag='0' WHERE SaleTag='8';
UPDATE _RefPackageItem SET SaleTag='0' WHERE SaleTag='32';

i hope that helped you

^^ U can do this too

UPDATE _RefPackageItem SET SaleTag=0 WHERE SaleTag <> 0
more simply
UPDATE _RefPackageItem SET SaleTag=0

Forget quotations, field datatype is smallint, then u must put without ''

[xxmailal]

link *** ***

[xlinh]

add new weapons to the game how?
HELP ME !

[kaptin85]

thx bro

[pherona]

it works well thanks

[Kabloz™]

works perfectly, nice guide!

[xTomasky]

good work , thanks for share

[rmamakiller]

excellent contribution
Thank you very much, it worked very well