Mu Core 1.0.8 Custom Rankings (10 ranks + config + styles)

[clerigz]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

question sir martin win i click the vote there are no vote reward will pop up

this my pictures:

 

[2009x2014]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

@clerigz

Have you installed full release from Isumeru

Spoiler

http://forum.ragezone.com/f197/mucore-vote-credits-module-includes-830324/

It's original rz release, one included in pack i've only modified to add vote rank, so for support ask author of vote module.

anw downloaded to test & works fine

 

[clerigz]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

yeah ive already installed it even i put this code in my index.php in my template nothing happens

<?
mssql_connect($core['db_host'],$core['db_user'],$core['db_password']);
mssql_select_db($core['db_name']);
?>

 

[2009x2014]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

yeah ive already installed it even i put this code in my index.php in my template nothing happens

Vote in my package doesn't use mssql connect but core_db execute, the original one does.

Have you executed sql querys from original vote package?
Have you added column TVote in sql for vote rank ?

Name = TVote
Data type = int
default 0

If yes then i told you, where to report vote problem.

 

[clerigz]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

no sir i didnt add that code in my sql..

 

[2009x2014]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

no sir i didnt add that code in my sql..

so add this column on MEMB_INFO table.

 

[clerigz]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

ok sir i will try this by tomorrow cause i'm sleepy now ^_^

 

[clerigz]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

sir martin add that column in memb_info the module Top voters is working but when you click the vote button there nothing happens. what should i do for this problem??

 

[2009x2014]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

sir martin add that column in memb_info the module Top voters is working but when you click the vote button there nothing happens. what should i do for this problem??

like i said before about vote module

It's original rz release, one included in pack i've only modified to add vote rank, so for support ask author of vote module.

anw ok, let me check
.....
...
.
Found problem, if there's no ip found on MUCore_VoteCreditsIP

first it's adding IP & then on 2nd click it's starting to adding Votes to database

So it's working just, when no ip, it's gonna work on 2nd click.

 

[UnCleanOne]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

hello,4funer
thanks for a great release of ranking packed
it so cool

but i have a question regarding on exchangehours

do you have any sql script with it?
coz when im trying to put it on my page module it didnt
work

how to fix it?

thanks in advance

 

[2009x2014]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

hello,4funer
thanks for a great release of ranking packed
it so cool

but i have a question regarding on exchangehours

do you have any sql script with it?
coz when im trying to put it on my page module it didnt
work

how to fix it?

thanks in advance

Sorry for late reply UnCleanOne, exchange hours works perfectly with TopOnline db modification (TH Column)

So execute query

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

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

 

[UnCleanOne]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

Sorry for late reply UnCleanOne, exchange hours works perfectly with TopOnline db modification (TH Column)

So execute query

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

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

Thanks a lot bro
now im just trying if my work will do

thanks you are the bes \m/

 

[andyxdz]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

YOU CAN UPLOAD COMPLET MU CORE? for hosting thx you

 

[clerigz]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

is this ok martin?

cause there was and row affected..

and this is the result martin after i run that querry

 

[2009x2014]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

YOU CAN UPLOAD COMPLET MU CORE? for hosting thx you

You have on ragezone, there ->
http://forum.ragezone.com/f197/mucore-1-0-8-nulled-820508/

is this ok martin?

Yup

and this is the result martin after i run that querry

Query doesn't added online hours, but a place to save online hours (by minutes),
so if you also modified Stored procedure WZ_DISCONNECT_MEMB,

then after 60min in-game 1 hour will appear and so on.

There's nothing complicated to make it work, just use ur brain

 

[clerigz]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

martin is this WZ_DISCONNECT_MEMB is okay?

CREATE PROCEDURE WZ_DISCONNECT_MEMB

@uid varchar(20)
AS
Begin

BEGIN TRANSACTION

SET NOCOUNT ON

IF EXISTS ( SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED)
WHERE memb___id = @uid )
Begin
UPDATE MEMB_STAT
SET DisConnectTM = (getdate()), connectstat = 0 WHERE memb___id = @uid
End
ELSE
Begin
INSERT INTO MEMB_STAT ( memb___id,DisConnectTM,connectstat) valueS (
@uid,
(getdate()),
0
)
End


IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION

SET NOCOUNT OFF
End

GO

 

[2009x2014]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

martin is this WZ_DISCONNECT_MEMB is okay?

replace it with one i've included in 1st post & will be fine.

 

[clerigz]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

i found a error martin
when i put the WZ_DISCONNECT_MEMB in the first page in your post in stored procedure there was an error

 

[LordArcanine]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

i have exactly same error

can you help us?

 

[2009x2014]

Re: Mu Core 1.0.8 Custom Rankings (8 ranks + config + styles)

@clerigz sorry i was on holiday & didn't noticed ur reply

anw i didn't see at first shot you have different WZ_DISCONNECT_MEMB structure im blind -_-

same applies for you LordArcanine

if you guys have different structure of WZ_DISCONNECT_MEMB

just add to UPDATE MEMB_STAT following line

TH = TH+(DATEDIFF(mi,ConnectTM,getdate()))

and if u have "INSERT INTO"

TH

and value 0

for example structure of clerigz

SET DisConnectTM = (getdate()), connectstat = 0[COLOR="#FF0000"][B], TH = 
TH+(DATEDIFF(mi,ConnectTM,getdate()))[/B][/COLOR] WHERE memb___id = @uid
End
ELSE
Begin
INSERT INTO MEMB_STAT ( memb___id,DisConnectTM,connectstat[COLOR="#FF0000"][B],TH)[/B][/COLOR] valueS (
@uid,
(getdate()),
0[COLOR="#FF0000"][B],
0[/B][/COLOR]
)
End