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

Results 1 to 8 of 8
  1. 07-07-06 #1
    OnyX
    Enthusiast OnyX is offline
    MemberRank
    May 2006 Join Date
    UKLocation
    35Posts

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

    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 by OnyX; 07-07-06 at 03:55 PM. Reason: Automerged Doublepost
  2. Check out our sponsor
    here is a stored procedure to add ALL items to your character
  3. 07-07-06 #2
    OnyX
    Enthusiast OnyX is offline
    MemberRank
    May 2006 Join Date
    UKLocation
    35Posts
    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
  4. 12-07-06 #3
    shma
    Apprentice shma is offline
    MemberRank
    Jun 2006 Join Date
    6Posts
    Thnx ,Ahh Is this the command for season2 huh?
  5. 12-07-06 #4
    killy
    Valued Member killy is offline
    MemberRank
    Nov 2005 Join Date
    113Posts
    Quote Originally Posted by shma
    Thnx ,Ahh Is this the command for season2 huh?
    Sesson1 only:sweatdrop
  6. 13-07-06 #5
    shma
    Apprentice shma is offline
    MemberRank
    Jun 2006 Join Date
    6Posts
    I see...
  7. 14-07-06 #6
    gubrax
    Novice gubrax is offline
    MemberRank
    Jul 2006 Join Date
    4Posts

    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 ?
  8. 14-07-06 #7
    Keith
    MentaL's Slave Keith is offline
    LegendRank
    Nov 2004 Join Date
    2,670Posts
    Thats.... look like it taken forever to make, not useful to me, but thanks anywas :p
  9. 15-07-06 #8
    guitarusa
    Apprentice guitarusa is offline
    MemberRank
    May 2006 Join Date
    10Posts
    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


« Previous Thread | Next Thread »

Advertisement