Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

here is a stored procedure to add ALL items to your character

Status
Not open for further replies.
O

OnyX

Newbie Spellweaver
Joined
May 13, 2006
Messages
35
Reaction score
0
go to stored procedures and right click, CREAT NEW PROCEDURE

enter the script below

then save as new procedure named ADDeverythingTO

afte that go to tables, select pangya_items_list, right click, return all tables

go to toolbar and select SQL

in the sql command box delete all the existing text and replace with

ADDeverythingTO 'yourusername'

(insert your username in that section)

then press !

it will then say altered one line, this means EVERYTHING has been applied to your character

or just make a new character and run the above procedure if you dont want to mess with the existing one!

you need this and the one below


CREATE Proc AddeverythingTo
@userid varchar(32)
as
DECLARE @UID int
select @UID = UID from Pangya_Member_Info where userid = @userid
IF @UID > 0
BEGIN

INSERT INTO PangYa_Character_Information (uid, typeid) VALUES (@UID,67108864);
INSERT INTO PangYa_Character_Information (uid, typeid) VALUES (@UID,67108865);
INSERT INTO PangYa_Character_Information (uid, typeid) VALUES (@UID,67108866);
INSERT INTO PangYa_Character_Information (uid, typeid) VALUES (@UID,67108867);
INSERT INTO PangYa_Character_Information (uid, typeid) VALUES (@UID,67108868);
INSERT INTO PangYa_Character_Information (uid, typeid) VALUES (@UID,67108869);
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134219776,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134219777,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134219779,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134219780,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134219781,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134219782,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134219784,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134242304,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134242305,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134242306,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134242307,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134242308,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134242309,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134242310,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134242311,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134242312,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134242313,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134242314,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134242315,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134242316,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134252544,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134252545,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134258688,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134258689,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134258690,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134258692,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134258693,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134258694,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134258695,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134258696,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134258697,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134258698,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134258699,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134258700,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134283264,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134283265,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134283266,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134283267,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134283268,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134283269,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134283270,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134283271,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134293504,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134293505,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134301696,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134481920,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134481921,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134481922,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134481923,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134481924,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134481925,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134481926,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134481927,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134481928,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134481929,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134481930,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134481931,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134481932,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134481933,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134481934,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134481935,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134496256,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134496257,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134496258,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134496259,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134496260,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134496262,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134496263,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134496264,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134496265,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134496266,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134496267,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134506496,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134506497,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134506498,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134512640,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134512641,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134512642,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134512643,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134512644,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134512645,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134512646,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134512647,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134537216,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134537217,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134537218,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134537219,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134537220,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134537221,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134537222,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134547456,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134547457,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134555648,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134555649,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134555650,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134572032,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134744064,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134744065,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134744066,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134744067,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134744068,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134744070,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134758401,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134758402,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134758403,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134758404,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134758405,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134758406,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134758407,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134776832,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134776833,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134776834,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134782977,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134782978,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134782979,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134782980,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134782981,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134782982,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134782983,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134799360,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134799361,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134799362,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134799363,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134799364,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134799365,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134809600,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134809601,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134817792,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,134834176,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135004160,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135004161,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135004162,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135020544,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135020545,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135020546,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135020547,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135020548,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135020549,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135020550,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135020551,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135036928,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135045120,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135045121,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135045122,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135045123,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135045124,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135045125,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135045126,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135045127,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135061504,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135061505,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135061506,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135061507,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135061508,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135061509,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135061510,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135069698,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135071744,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135071745,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135079936,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135088128,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135088129,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135088130,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135088131,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135096320,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135266304,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135282688,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135282689,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135282690,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135282694,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135290880,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135290881,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135299072,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135299073,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135307264,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135307265,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135307266,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135340032,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135348224,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135528449,1, getdate());
 
Last edited:
The Best DDoS Protected Servers
O

OnyX

Newbie Spellweaver
Joined
May 13, 2006
Messages
35
Reaction score
0
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135544832,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135544833,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135544834,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135561217,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135569408,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135569409,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135585792,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135585793,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135585794,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135610368,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135634944,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135634945,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,135651328,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326592,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326593,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326594,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326595,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326596,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326597,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326598,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326599,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326600,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326601,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326602,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326603,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326604,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326605,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326606,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326607,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326608,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326609,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326610,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326611,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326612,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326613,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326614,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326615,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326616,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326617,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326618,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,201326619,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,268435456,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,268435457,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,268435458,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,268435459,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,335544320,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,335544321,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,335544322,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,335544323,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,335544330,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,402653184,99, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,402653185,99, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,402653186,99, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,402653187,99, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,402653188,99, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,402653189,99, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,402653190,99, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,402653191,99, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,402653192,99, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,402653193,99, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,402653194,99, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,402653195,99, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,436207616,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,436207617,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,436207618,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,436207620,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,436207622,1, getdate());
INSERT INTO PangYa_Caddie_Info (uid, typeid) VALUES (@UID,469762048);
INSERT INTO PangYa_Caddie_Info (uid, typeid) VALUES (@UID,469762049);
INSERT INTO PangYa_Caddie_Info (uid, typeid) VALUES (@UID,469762050);
INSERT INTO PangYa_Caddie_Info (uid, typeid) VALUES (@UID,469762051);
INSERT INTO PangYa_Caddie_Info (uid, typeid) VALUES (@UID,469762052);
INSERT INTO PangYa_Caddie_Info (uid, typeid) VALUES (@UID,469762053);
INSERT INTO PangYa_Caddie_Info (uid, typeid) VALUES (@UID,469762054);
INSERT INTO PangYa_Caddie_Info (uid, typeid) VALUES (@UID,469762055);
INSERT INTO PangYa_Caddie_Info (uid, typeid) VALUES (@UID,536870912);
INSERT INTO PangYa_Caddie_Info (uid, typeid) VALUES (@UID,537657344);
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,537919488,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,538443776,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,538705920,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,606117889,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,939524096,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,939524097,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,939524098,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,939524099,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,939524100,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,939524101,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,939524102,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,939524103,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,939524104,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,939524105,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,943718400,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,943718401,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,943718402,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,943718403,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,943718404,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,943718405,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,943718406,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,943718407,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,943718408,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,943718409,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,943718410,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,943718411,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,943718412,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912704,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912705,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912706,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912707,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912708,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912709,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912710,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912711,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912712,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912713,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912714,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912715,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912716,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912717,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912718,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912719,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912720,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912721,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912722,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912723,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,947912724,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,952107008,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,952107009,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,952107010,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,952107011,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,952107012,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,952107013,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,952107014,1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID,952107015,1, getdate());
RETURN
END
GO
 
S

shma

Newbie Spellweaver
Joined
Jun 20, 2006
Messages
6
Reaction score
0
Thnx ,Ahh Is this the command for season2 huh?
 
G

gubrax

Initiate Mage
Joined
Jul 6, 2006
Messages
4
Reaction score
0
error

@OnyX

I got all the item but...
when I select an aztec and a club to use, i got an error message... can you help me please :Confuzzle ?
 
G

guitarusa

Newbie Spellweaver
Joined
May 11, 2006
Messages
10
Reaction score
0
Well done Mr.OnyX
I got everything that your codes and I already changed some of your codes because Antez balls have some problem (just a little problem).
IO would like to know how can I delete code for Air knight (I already delete but still come)because it made my server hang when I played on mode family
 
Status
Not open for further replies.

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
197
Guests online
2,129
Total visitors
2,326
Totals may include hidden visitors.

Forum statistics

Threads
428,865
Messages
4,589,077
Members
279,458
Latest member
rcex
Most visitors online was 8830 , on 6 Feb 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top