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!

OnlineHours Problem

Status
Not open for further replies.
Junior Spellweaver
Joined
Aug 9, 2012
Messages
160
Reaction score
34
Helo guyz, i`m using 11.11.82 files, and i have a problem in MEM_STAT with Online Hours.
Heres My Table:


I have made MinutesOnline by this topic:
http://forum.ragezone.com/f82/mucore-top-online-module-working-847278/
And it works perfectly. But i need OnlineHours to work because i have an exchange online hours module.

I need a query or something to fix my HoursOnline start counting online Hours of Users.
 
Newbie
Joined
Feb 13, 2011
Messages
772
Reaction score
69
Changed the "int: to "real" and unchecked "Allow Null" for OnlineHours
 
Upvote 0
Junior Spellweaver
Joined
Aug 9, 2012
Messages
160
Reaction score
34
Yes, but how to change that ?
Because if i edit in Enterprise and then try to save, it wont let me.
PHP:
'MEMB_STAT' table
- Unable to modify table.  
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'OnlineHours', table 'MuOnline.dbo.Tmp_MEMB_STAT'; column does not allow nulls. INSERT fails.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
And you have done that? It works for you ?
 
Upvote 0
Initiate Mage
Joined
Jun 11, 2008
Messages
45
Reaction score
5
search for wz_disconnect_memb procedure and change (DATEDIFF(hh,ConnectTM,getdate()) with (DATEDIFF(mi,ConnectTM,getdate())
 
Upvote 0
Junior Spellweaver
Joined
Aug 9, 2012
Messages
160
Reaction score
34
Yes, but how to change that ?
Because if i edit in Enterprise and then try to save, it wont let me.
PHP:
'MEMB_STAT' table
- Unable to modify table.  
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'OnlineHours', table 'MuOnline.dbo.Tmp_MEMB_STAT'; column does not allow nulls. INSERT fails.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
And you have done that? It works for you ?
I know that is in Tabels.. but i already told you that i dont know how to change those values, after i edite table and i try to save, i get this error :-s
So can someone tell me what i need to edit ?
 
Last edited:
Upvote 0
Junior Spellweaver
Joined
Aug 9, 2012
Messages
160
Reaction score
34
I used this comand
Code:
ALTER TABLE [MEMB_STAT]
ALTER COLUMN [OnlineHours] [int] NOT NULL
But i recieve this error
Code:
Server: Msg 515, Level 16, State 2, Line 1
Cannot insert the value NULL into column 'OnlineHours', table 'MuOnline.dbo.MEMB_STAT'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
So please someone fix this for me? I really need those OnlineHours To count!
 
Upvote 0
Initiate Mage
Joined
Jun 11, 2008
Messages
45
Reaction score
5
MuOnline Tables

not in mu online tables --- in procedures

search for wz_disconnect_memb procedure and change (DATEDIFF(hh,ConnectTM,getdate()) with (DATEDIFF(mi,ConnectTM,getdate())

mytzu - OnlineHours Problem - RaGEZONE Forums


There are stored procedure

you need to searchfor wz_disconnect_memb
 
Upvote 0
Status
Not open for further replies.
Back
Top