premium inventory--old files

[anquietas]

Does anyone have a sql script, that would allow me to put an item into peoples premium inventories? i need 2. (not the new file releases)
- for just one person
- for everyone

[MentaL]

[LolOmgNoob]

Use Account

Insert into tChargeItem (userNo, goodsNo, amount, isDraw, orderNo) VALUES (x, x, x, x, x)

Replace X with your values. Make sure you have the items you want added into your mall database + shn's.

[Crystalz]

I guess this should work. You'll have to edit some of the values to match your info.
I'm sure there's a better way to do this, I'm not very good at sql.

INSERT INTO Account.dbo.tOrder (orderDate, orderType, userNo, goodsNo, goodsPrice, amount, discount, orderPrice, cashType, isPay, userIP)
VALUES ('1956', '1', '102', '10001', '0', '1', '0', '1', '1', '1', '127.0.0.1')

INSERT INTO Account.dbo.tChargeItem (userNo, orderNo, goodsNo, amount, registerDate, isDraw, drawDate)
VALUES ('102', '10001', '10001', '1', '2012', '0', '1999')