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

[2009x2014]

Hello RageZoners.

Im going to release my old Mu Core rankings which i coded old times from the scratch, with cron jobs on/off for 6 of them, (gms, online players will be live).

There might be some small errors (i believe i've checked everything but who knows), since i removed custom functions, so if you find please report so i'll be able to fix.

Ok here we go.

So the Rankings gonna be:
- Custom Top Guilds (order by members lvl / pk / stats) disabled by default so if u wish enable in config
- Top Gens S5+(Gens columns can be changed by config, default support for Titan Tech)
- Top Killers (Top kills + Custom Ranks)
- Top Zen (Top zen + Custom Ranks + order by config)
- Online Players (Current Online Players by in-game nick & ConnectTime desc)
- Game Masters (Game master list + online/offline status check by in-game nick)
- Marry Top Must be supported by Server Files (Marry Husband / Wife, marry column can be
changed by config, default support for Titan Tech)
- Top Online (Top online by Total Hours in-game + Custom Ranks(by minutes), require modification of
WZ_DISCONNECT_MEMB stored procedure, guide scroll down)
- Top Voters (Top voters by total votes + Custom Ranks require new column in MEMB_INFO +
modified vote module, i'll include needed files/info)
- Top Duel (MuOnline & Ranking DB support default for IGCN & Titan Tech)


Dark styles 1-5 by config

Grey styles 6-10 by config

Custom Top Guilds - required modification

Run sql query on MuOnline db

ALTER TABLE Guild ADD G_LV bigint NOT NULL default 0
ALTER TABLE Guild ADD G_PK bigint NOT NULL default 0
ALTER TABLE Guild ADD G_STR bigint NOT NULL default 0

Top Online Ranking - required modification

Go to sql & run query

ALTER TABLE MEMB_STAT ADD TH int NOT NULL 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

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

!Important!

if you have different WZ_DISCONNECT_MEMB struct just add to update memb_stat query

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

additionaly i leave exchangehours from RZ release rewrited 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 & run query

ALTER TABLE MEMB_INFO ADD TVote int NOT NULL default 0

& replace ur old vote_credits.php with one i've included in /VoteforCreditsMOD.

Usage :

Paste Custom_Rankings dir to ur Mu Core directory

Configure everything you need in config
Custom_Rankings/Custom_Rankings_cfg.php

& replace rankings.php in page_modules

& use tops you want by enable/disable them at config

Cron Jobs :

If you want cache on rankings, enable cron jobs in config
Ex " $corecr['TKCronJobStatus'] = "0"; // 1 = ON, 0 = OFF "

for ranking you want & add new cron job in AdminCP-> Cron job Settings for ID (by default)
2 - Top Guilds ID
20 - Top Killers ID
21 - Top Gens ID
22 - Top Zen ID
23 - Top Online ID
24 - Top Voters ID
25 - Marry Status ID
26 - Top Duel ID

Else cache msg will be
Ex " Update for Top Killers is currently Live "

If something doesn't work, check/read X times before asking for help

Download

1.

You must be registered to see links

2.

You must be registered to see links

*if you going to release on other forum, respect the credits

by Martin a.k.a 4FUNer (c) 2013, Enjoy :]

 

[ScriptKid]

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

A great guy and a great release nice one bro!

 

[_Shotlandetsa_]

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

Its perfect 10x a lot nice realise for community !

 

[epocal]

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

Much respect for Martin, helped Ragezone Mu Comunity a lot, i'm very suspicious about " how the hell he knows everything ? " ) Anyway good codes, great coder, amazing job ! Thank you

 

[ianvalls90]

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

just awesome, keep it up Martin, this kind of releases are highly appreciated.

 

[ScriptKid]

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

yeah. Planning to create my own Webshop + Web market haha GL Guys!

 

[I Am NoLimiT]

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

Thanks Martin :junglejane:

 

[epocal]

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

Martin, here is the Top Zen module, I've added the module in page modules as I did with all of your modules. And I get this ...

You must be registered to see links

I know I did something wrong but don't know what ...

I think this :

include("engine/connect_core.php");
include("Custom_Rankings/Custom_Rankings_cfg.php");

And I don't have the files there ... I'm so busy doing stuffs in diablo 3 auction house and I know i miss something here )

 

[ScriptKid]

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

copy the Custom_Module on your MUCore Main Folder not on pages_module

 

[2009x2014]

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

Martin, here is the Top Zen module, I've added the module in page modules as I did with all of your modules. And I get this ...

It doesn't load style & config, so query can't load top X, also cache info, u haven't move Custom_Rankings to your MuCore directory.

so Custom_rankings going to MuCore directory
topzen.php to page_modules & it will work

 

[epocal]

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

Martin, can you give me some information about Top Voters module ?

I see that after I vote it updates the ranking and all works 100% ok but how does the module apply the name of the character who voted ? Is it random ? It just picks a character on your account and put it to Top Voters module ?

Because I have 3 characters on my account, voted today, and I got the ranking on my third character.

Mist , Testone, TestMG ( I get the ranking only on my TestMG ) Is this right ? Or it should rank my account name instead ?

PS : TestMG is my last online Character that I logged in. ( Must be something to do with that ) You know better

 

[2009x2014]

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

Martin, can you give me some information about Top Voters module ?

I see that after I vote it updates the ranking and all works 100% ok but how does the module apply the name of the character who voted ? Is it random ? It just picks a character on your account and put it to Top Voters module ?

Because I have 3 characters on my account, voted today, and I got the ranking on my third character.

Mist , Testone, TestMG ( I get the ranking only on my TestMG ) Is this right ? Or it should rank my account name instead ?

PS : TestMG is my last online Character that I logged in. ( Must be something to do with that ) You know better

Like you can see in config file

$corecr['CharacterNameTopVoters'] = "GameIDC"; // Character on Top (GameIDC = Last active of acc) (GameID1 = ID1 of acc etc)

so edit to GameID1 or 2/3/4/5 if you don't want to show last connected character in-game on top

Also votes r saved to account.

 

[clerigz]

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

@4FUNer Sir how i can put the position of the staff members for example:

Name Map Class Status Postion
4FUNer Lorencia BM Online Admin

like that sir and this the code and example pic

<?

/* ----------------------------------------------------------------
Game Masters Mu Core Ranking by Martin a.k.a 4FUNer (c) 2013
Coded & Released for Ragezone Community
----------------------------------------------------------------- */

include("engine/connect_core.php");
include("Custom_Rankings/Custom_Rankings_cfg.php");

if ($corecr['GameMastersStyle'] == 1) {
echo "<link rel='stylesheet' href='Custom_Rankings/Styles/Default/Custom_Rankings.css'>";
}
elseif ($corecr['GameMastersStyle'] == 2) {
echo "<link rel='stylesheet' href='Custom_Rankings/Styles/Dark_Blue/Custom_Rankings.css'>";
}
elseif ($corecr['GameMastersStyle'] == 3) {
echo "<link rel='stylesheet' href='Custom_Rankings/Styles/Dark_Red/Custom_Rankings.css'>";
}
elseif ($corecr['GameMastersStyle'] == 4) {
echo "<link rel='stylesheet' href='Custom_Rankings/Styles/Dark_Green/Custom_Rankings.css'>";
}
elseif ($corecr['GameMastersStyle'] == 5) {
echo "<link rel='stylesheet' href='Custom_Rankings/Styles/Dark_Orange/Custom_Rankings.css'>";
}

echo
'<div align="center" class="customRTitle">Game Masters</div><table border="0" cellspacing="2" cellpadding="2" width="100%" class="customRTable">
<tr id="customRbg">
<div style="height: 3px;"></div>
<td><div id="customRLegend" class="co-Legend">-</div></td>
<td><div id="customRLegend" class="co-Legend">Position</div></td>
<td><div id="customRLegend" class="co-Legend">Name</div></td>
<td><div id="customRLegend" class="co-Legend">Map</div></td>
<td><div id="customRLegend" class="co-Legend">Class</div></td>
<td><div id="customRLegend" class="co-Legend">Status</div></td></tr>
';
$gmdata = $core_db->Execute("Select top ".$corecr['GameMastersTop']." Name, AccountId, MapNumber,Class from Character where CtlCode > 1");
$gmid=1;
while (!$gmdata->EOF) {
$gmstatus = $core_db2->Execute("Select memb___id, ConnectStat from MEMB_STAT where memb___id=?", array(
$gmdata->fields[1]
));
$gmname = $core_db->Execute("Select GameIDC from AccountCharacter where id=?", array(
$gmdata->fields[1]
));
echo '
<tr id="customRbg" >
<td id="customRTDcontrol" class="co-ID">'. $gmid .'</td>
<td id="customRTDcontrol" class="co-1">'.$gmdata->fields[0].'
</td><td id="customRTDcontrol" class="co-2">'.decode_map($gmdata->fields[2]).'
</td><td id="customRTDcontrol" class="co-3"> '.decode_class($gmdata->fields[3]).'</td>
<td id="customRTDcontrol" class="co-4">';
if(($gmname->fields[0] == $gmdata->fields[0]) && ($gmstatus->fields[1] == 1))
{
echo '<span id="cRonline">Online</span>';
} else
echo'<span id="cRoffline">Offline</span>';
echo'
</td></tr>';
$gmid++;
$gmdata->MoveNext();
}
echo'</table>
<br><div class="cachemsg" align="right">Update for Game Masters is <span id="cRcJ">Live</span></div>';

/* ----------------------------------------------------------------
Game Masters Mu Core Ranking by Martin a.k.a 4FUNer (c) 2013
Coded & Released for Ragezone Community
----------------------------------------------------------------- */

?>

tnx in advance

 

[tranphuoctai]

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

whre is edit the code class??? i can't find to edit it! :$:

 

[2009x2014]

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

@4FUNer Sir how i can put the position of the staff members for example:

Name Map Class Status Postion
4FUNer Lorencia BM Online Admin
tnx in advance

Possible to configure in new ver.

whre is edit the code class??? i can't find to edit it! :$:

It's on ../engine/custom_variables.php

start -> $characters_class = array (

 

[clerigz]

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

tnx for this 4FUNer i have appreciated to your work and i have some question for this.. Where i can point the rank of the staff of this code?

 

[2009x2014]

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

tnx for this 4FUNer i have appreciated to your work and i have some question for this.. Where i can point the rank of the staff of this code?

Add rank to the gamemaster ?

just modify config i've provided
Ex.
$corecr['GM-Owner'] = "clerigz";

etc

 

[clerigz]

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

question sir there was a possible that this rank will be by ranks?

for example:
Server Owner
Administrator
Game Master
Etc.

 

[2009x2014]

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

question sir there was a possible that this rank will be by ranks?

for example:
Server Owner
Administrator
Game Master
Etc.

Yea sure configure in config

 

[clerigz]

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

tnx a lot sir