confused with codes

[dabriz]

first, very apologize if there were thread like this in past times

I wanna play Kooh in season 1 (offline), well I read webshop & LGKeiz from stickied thread, but sadly I don't understand a thing ;_;
the main problem, I not quite understand about some coding & application here. well....It's me who never learnt it, my bad.

is there any easier way to unlock Kooh or other feature? if there aren't, maybe you can explain to me more detailed... and what patch required to use Kooh? (I used 2.13c and 2.15c)

more detail about this one, perhaps?

:: 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, 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, 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 '!'

sorry if I wasted your time and thx 4 reply

[MentaL]