Quote:
:: 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