Problem with GoW VIP System

Status
Not open for further replies.
S

Sponglogix

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:

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
Sort by date Sort by votes
L

Lodelight

Inactive
Joined
Jan 20, 2009
Messages
1,014
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
S

Sponglogix

Newbie Spellweaver
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.