: Adding Kooh to your server ::
1. Goto Pangya_Item_TypeList table (SQL Manager) -> Open Table -> Return all rows ->
Click SQL in toolbar menu and replace this command :
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Icon, Price) VALUES(67108869, 'Kooh','e_def', 29000)
then click '!' in toolbar menu.
2. Right Click on 'Stored Procedures' -> Click 'New Stored Procedure...' then replace all text to textbox area :
CREATE Proc AddKoohAndItemTo
@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,67108869)
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 1355448*** 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, 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, 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, 135528449, 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 135561217, 1, getdate());
RETURN
END
GO
3. Go to sql command to execute procedure name 'AddKoohAndItemTo' with parameter userid :
example : AddKoohAndItemTo 'yourloginname'
then click '!'
Quote:
:: 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(939524****'Ivy Vines',5)
INSERT INTO Pangya_Item_TypeList (TypeId, Name, Price) VALUES(939524****'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, 939524**** 1, getdate());
INSERT INTO PangYa_Item_WareHouse (uid, typeid, valid, regdate) VALUES (@UID, 939524**** 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 -----
Look Menu Bar and Go to Tools > SQL Query Manager
AddSkinItemTo 'yourloginname'
AddHClubTo 'yourloginname'
AddCMBallTo 'yourloginname', 100
Example : My ID is Gerrard
then type AddSkinItemTo Gerrard
And If you Want Some Item In Shop But you can't buy it, go to Pangya Bn game > DataBase> Pangya Item List and search item code, and change item code in procedure.
Source : Ragezone.com
