:: Make Skin and Ball to Pangya_Item_Typelist table. ::
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(952107015,'Green Bag Slot',5000)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(952107014,'Blue Bag Slot',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(952107013,'Pink Bag Slot',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(947912722,'Lolo Sticker',9)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(947912721,'Pipin Sticker',9)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(947912720,'Tiki Sticker',9)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(947912719,'Titang Boo Sticker',9)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(943718411,'Flower Garden Frame',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(943718410,'Green Water Drop Frame',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(943718409,'Pink Water Drop Frame',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(943718408,'Tangled Bronze Frame',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(939524103,'Green Tiki PangYa',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(939524102,'Purple Tiki PangYa',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(939524101,'Ivy Vines',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(939524100,'The Best Rice',7)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(335544330,'Chistmas Aztec (50)',12)
#----- Make Procedures to add Skin, Chistmas Ball, House Club -----
CREATE Proc AddSkinItemTo
@userid varchar(32)
as
DECLARE @UID int
select @UID = UID from Pangya_Member_Info where userid = @userid
IF @UID > 0
BEGIN
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 952107015, 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, 952107013, 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, 947912721, 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, 947912719, 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, 943718410, 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, 943718408, 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, 939524103, 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, 939524101, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 939524100, 1, getdate());
RETURN
END
GO
#----- Add Club and Status PWR,CTL,ACC,SPN,CRV -----
CREATE Proc AddHClubTo
@userid varchar(32)
as
DECLARE @UID int
select @UID = UID from Pangya_Member_Info where userid = @userid
IF @UID > 0
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate,C0,C1,C2,C3,C4) VALUES (@UID, 268435459, 1, getdate(), 3, 6, 4, 2, 2);
GO
#----- Add Chismas Aztech ball to player ------
CREATE Proc AddCMBallTo
@userid varchar(32),
@ball int
as
DECLARE @UID int
select @UID = UID from Pangya_Member_Info where userid = @userid
IF @UID > 0 and @ball > 0
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate,C0) VALUES (@UID, 335544330, 1, getdate(), @ball);
GO
#------ Example to use procedures -----
AddSkinItemTo 'yourloginname'
AddHClubTo 'yourloginname'
AddCMBallTo 'yourloginname', 100
Thanks to attagorn Again, very good job.