- Joined
- Mar 28, 2012
- Messages
- 1,356
- Reaction score
- 68
after the sql queries now my mucore dont want to register accounts, now says system error i tryed to reinstall db and mucore and i cant register
did you go to your stored procedure?? you can check the WZ_DISCONNECT_MEM in stored procedure..
Sir why I can't see WZ_DISCONNECT_MEM
But when i'm creating new query and naming it WZ_DISCONNECT_MEM it tells that WZ_DISCOONECT_MEM is already exist -.-"
Need help please.
Not yet sir, I'm a newbie on developing but i'm a good follower of the instruction
Can you give me a Screenshot guides? So that I can easily follow you. Thank you
Or any instructions besides Screenshot Guides
View attachment 137395
I had this error and also with the other php modules.
when I use the default rankings module it functions without no error
but when I use Sir Martin's php module nothing came out in the rankings module.
like I read on the first page I put all the php files on the page module.
help please?
Maybe you connect it with MSSQL.Or maybe you didn't run Sir.Martin sql queries for TH Column on MEMB_STAT.
View attachment 137395
I had this error and also with the other php modules.
when I use the default rankings module it functions without no error
but when I use Sir Martin's php module nothing came out in the rankings module.
like I read on the first page I put all the php files on the page module.
help please?
nah online players doesn't require this mod.
Are you Mu Core 1.0.8 User ?
If yes, then
module .php going to pages_modules (or pages_modules/user_cp)
and Custom_Rankings directory there
if still doesn't work, change in config.php
$core['debug'] = '0';
to $core['debug'] = '1';
log in admincp
and check ranking for error
----------------------
this is the error i got from the rankings using the original rankings.php module
(mssql): Select next_cron from MUCore_Cron_Jobs where cron_id=? [ (0=>'1') ]
[SIZE=-1]sp_executesql N'Select next_cron from MUCore_Cron_Jobs where cron_id=@P0',N'@P0 NVARCHAR(1)',@P0=N'1'[/SIZE]
when i tried your module it's the same nothing displays and no error ...
other modules like "Online Players and Top Killers" works great.
Any idea Sir Martin?
at first i forgot to restart my xampp CP sorry for that
now it works but the problem is about the rankings module i had
it displays nothing and no error displayed when i set the debug module to 1
hmmmm, maybe there is a misunderstanding?
Rankings.php on MU Core 1.0.8 is the default right?
so your file Sir Martin is a module to replace/modify the original rankings.php or create another one?
If to replace/modify then I will to go admincp and then edit module right?
sorry if i am wrong.... just confused and i dont really get the idea until now my bad ..
Top Online Ranking - required modification
Go to sql & run query
Code:ALTER TABLE dbo.MEMB_STAT ADD TH int NOT NULL CONSTRAINT DF_MEMB_STAT_TH DEFAULT 0
then open in sql stored procedures & replace WZ_DISCONNECT_MEMB
(Q: wth are stored procedures ?)
(A: google will tell you)
with new one
Code:CREATE PROCEDURE WZ_DISCONNECT_MEMB @memb___id varchar(10) AS Begin set nocount on Declare @find_id varchar(10) Declare @ConnectStat tinyint Set @ConnectStat = 0 Set @find_id = 'NOT' select @find_id = S.memb___id from MEMB_STAT S INNER JOIN MEMB_INFO I ON S.memb___id = I.memb___id where I.memb___id = @memb___id if( @find_id <> 'NOT' ) begin update MEMB_STAT set ConnectStat = @ConnectStat, DisConnectTM = getdate(), TH = TH+(DATEDIFF(mi,ConnectTM,getdate())) where memb___id = @memb___id end end GO
additionaly i leave exchangehours from RZ release rewrited by myself to ado, to work with TH mod/column.
Top Voters - required modification
Since i use my own module, i've modified RZ release
(can be found there : http://forum.ragezone.com/f197/mucore-vote-credits-module-includes-830324/)
to add +1 tvote every vote.
If you use different than rz release, just add in query adding +1 tvote to MEMB_INFO table every vote.
Go to sql & Create column in MEMB_INFO table
Code:Name = TVote Data type = int default 0
Sorry for late reply UnCleanOne, exchange hours works perfectly with TopOnline db modification (TH Column)
So execute query
Code:ALTER TABLE dbo.MEMB_STAT ADD TH int NOT NULL CONSTRAINT DF_MEMB_STAT_TH DEFAULT 0
on MuOnline (or if you use Me_MuOnline for accounts) database
+ modify Stored procedure WZ_DISCONNECT_MEMB
to this one
Code:CREATE PROCEDURE WZ_DISCONNECT_MEMB @memb___id varchar(10) AS Begin set nocount on Declare @find_id varchar(10) Declare @ConnectStat tinyint Set @ConnectStat = 0 Set @find_id = 'NOT' select @find_id = S.memb___id from MEMB_STAT S INNER JOIN MEMB_INFO I ON S.memb___id = I.memb___id where I.memb___id = @memb___id if( @find_id <> 'NOT' ) begin update MEMB_STAT set ConnectStat = @ConnectStat, DisConnectTM = getdate(), TH = TH+(DATEDIFF(mi,ConnectTM,getdate())) where memb___id = @memb___id end end GO
Time will be saved by minutes on account, so every 60 min, 1 hour will appear on exchange hours.
HF
Sir Martin if you combine this 2 query what will be the new look of the QUERY?
View attachment 137435
View attachment 137434
View attachment 137436
Sir Martin, is there something i missed???