Welcome!

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!

Problem with GoW VIP System

Status
Not open for further replies.
Initiate Mage
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.
QqPPkM - Problem with GoW VIP System - RaGEZONE Forums

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:

 

Attachments

You must be registered for see attachments list
Inactive
Joined
Jan 20, 2009
Messages
1,015
Reaction score
1,830
Your missing some stuff from the STR i assume.

Search the file attached for "-- VIPSTUFF" and make sure all of it is added.
 

Attachments

You must be registered for see attachments list
Upvote 0
Initiate Mage
Joined
Sep 2, 2008
Messages
27
Reaction score
2
Thank you for the quick reply but yep. i've added all this. im not sure if i made a mistake with this
Code:
	[m_szVipEndTime] [varchar](13) COLLATE Latin1_General_CI_AS NULL, -- VIPSTUFF

Thats what i added like this:
Code:
ALTER TABLE dbo.CHARACTER_TBL
ADD m_szVipEndTime varchar (13);

EDIT: Oh i found out why its not working. its because the Default value is NULL for all currently working characters and not 20120202, i've made a new character and it worked so i just change all this and im fine, but thanks for your help.

But something seems Wrong with my Spec_Item.txt entry.

Code:
17    II_SYS_VIP_ACCESS_3    "VIP (3 Days)"    1    9999    IK1_SYSTEM    IK2_SYSTEM    IK3_SCROLL    =    =    1    =    1    =    =    =    =    =    =    =    0    =    =    1    1    =    1    0    =    =    =    =    _NONE    0    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    =    XI_SYS_EXCHAN01    =    =    =    =    =    =    WUI_NOW    =    =    =    =    =    =    =    =    =    =    =    =    =    0    0    0    0    0    0    =    =    =    =    =    =    =    =    =    =    =    =    """Item_sys_scr_VIP.dds"""    0    """"""    "Get some Premium Stat-Points for your Character! (3 Days)"    1    300    0    0    1    0    0    0    0    0    2    =    =    =    =    =    =    =    =    =    =    1    1    1    1    1    0    ITEM_GRADE_NORMAL    1    TYPE1_CONSUME    TYPE2_CONSUME_SCROLL    1    0    0    0
When i'll add it my game instantly crashes after starting generating no error log.
 
Last edited:
Upvote 0
Status
Not open for further replies.
Back
Top