Most visitors online was 12542 , on 28 Apr 2024
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!Originally Posted by Answer/HASKOMAN
GO TO
SQL Database - PS_GameData - CHAR - design table and change Maketime in varchar
xd you have the same problem I've had but I am a good programmer
CHANGE MY SCRYPT
go to USP_SAVE_CHAR_ITEM_ADD_E
/****** Object: Stored Procedure dbo.usp_Save_Char_Item_Add_E Script Date: 2008-6-7 18:31:57 ******/
/****** Object: Stored Procedure dbo.usp_Save_Char_Item_Add_E Script Date: 2008/3/15 下午 05:25:52 ******/
/****** 偃羹: 盪濰 煎衛盪 dbo.usp_Save_Char_Item_Add_E 蝶觼董 陳瞼: 2006-04-11 螃 10:57:16 ******/
CREATE Proc usp_Save_Char_Item_Add_E
@CharID int,
@ItemUID bigint,
@Bag tinyint,
@Slot tinyint,
@ItemID int,
@Type tinyint,
@TypeID tinyint,
@Quality int,
@Gem1 tinyint,
@Gem2 tinyint,
@Gem3 tinyint,
@Gem4 tinyint,
@Gem5 tinyint,
@Gem6 tinyint,
@Craftname varchar(20) = '',
@Count tinyint,
@Maketime varchar(20)='01/01/1999',
@Maketype char(1)
AS
--SET NOCOUNT ON
IF(@Quality >= 5000)
BEGIN
SET @Quality=0
END
INSERT INTO CharItems
(CharID, bag, slot, ItemID, Type, TypeID, ItemUID, quality, gem1, gem2, gem3, gem4,
gem5, gem6, craftname, [count], maketime, maketype)
VALUES(@CharID, @Bag, @Slot, @ItemID, @Type, @TypeID, @ItemUID, @Quality, @Gem1, @Gem2, @Gem3, @Gem4,
@Gem5, @Gem6, @Craftname, @Count, @Maketime, @Maketype)
IF(@@ERROR = 0)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END
--SET NOCOUNT OFF
GO
and
go to usp_Read_Char_Items_Detail_R
CHANGE MY SCRYPT
/****** Object: Stored Procedure dbo.usp_Read_Char_Items_Detail_R Script Date: 2008-6-7 18:31:57 ******/
/****** Object: Stored Procedure dbo.usp_Read_Char_Items_Detail_R Script Date: 2008/3/15 下午 05:25:51 ******/
CREATE Proc usp_Read_Char_Items_Detail_R
@CharID int
AS
/******SET NOCOUNT ON******/
SELECT ItemID, Type, TypeID, ItemUID, Bag, Slot, Quality,
Gem1, Gem2, Gem3, Gem4, Gem5, Gem6, Craftname, [Count], Maketype ,
'2009' AS MakeTime_YYYY,
'01' AS MakeTime_MM,
'01' AS MakeTime_DD,
'00' AS MakeTime_HH,
'00' AS MakeTime_MI,
'00' AS MakeTime_SS
FROM CharItems
WHERE CharID = @CharID AND Del = 0
/******SET NOCOUNT OFF******/
GO
and restarts all the service and good luck
I've spend 4 days but I've successfully with these changes it is sufficient to look for or just the error ^ ^
And you can create characters now
..i think problem in database(tables or store proc..).. see logsAfter following every guide i can find to an exact my server is working. I load the game. Log the admin account. Select the server and then i get the same thing...either a character load error or it simply crashes before getting to the faction select screen.
-9thCircle, aka Frank
Hi, Ace i saw that u know a lot of thing about the creation of server so u can help me. Can u explain me how can i change red X in green X but in details plz