Newbie Spellweaver
- Joined
- Sep 2, 2008
- Messages
- 27
- Reaction score
- 2
Hello everyone.
I've got a Problem. I tried to Implement the VIP System from Giants of War Source, in source everything is fine, all server's are compiling and starting, my neuz is starting But i think i did something wrong with the Database. When i try to log in to the WorldServer my DatabaseServer just crash. I dont know much about Debugging but thats what i get from there.
Inside the Database.sql from GoW VIP related is this:
To add this i did
Then there comes some CHARACTER_STR Stuff, i added all this into my Saved Procedures inside the CHARACTER_STR
So inside the CHARACTER_STR i THINK i added everything where it should be. But on the Image above you see that my DatabaseServer just crash.
The Image:
I've got a Problem. I tried to Implement the VIP System from Giants of War Source, in source everything is fine, all server's are compiling and starting, my neuz is starting But i think i did something wrong with the Database. When i try to log in to the WorldServer my DatabaseServer just crash. I dont know much about Debugging but thats what i get from there.
Inside the Database.sql from GoW VIP related is this:
Code:
CREATE TABLE [dbo].[CHARACTER_TBL](
[m_szVipEndTime] [varchar](13) COLLATE Latin1_General_CI_AS NULL,
To add this i did
Code:
ALTER TABLE dbo.CHARACTER_TBL
ADD m_szVipEndTime varchar (13);
Then there comes some CHARACTER_STR Stuff, i added all this into my Saved Procedures inside the CHARACTER_STR
Code:
CREATE proc [dbo].[CHARACTER_STR]
, @im_szVipEndTime varchar(13) = 20120202
Code:
SELECT @om_chLoginAuthority = m_chLoginAuthority
FROM ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL
WHERE account = @iaccount
SELECT m_chLoginAuthority = @om_chLoginAuthority,
, A.m_szVipEndTime
Code:
UPDATE CHARACTER_TBL
, m_szVipEndTime = @im_szVipEndTime
Code:
INSERT CHARACTER_TBL
, m_szVipEndTime
VALUES
(
, 20120202
So inside the CHARACTER_STR i THINK i added everything where it should be. But on the Image above you see that my DatabaseServer just crash.
The Image:
You must be registered to see links
Attachments
You must be registered for see attachments list