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!

[Release]Rebirth column for darkmagic's ranking

Experienced Elementalist
Joined
Apr 6, 2008
Messages
296
Reaction score
3
Edit: Mini description: What this does, is it adds a column to your ranking, it doesn't mess up the table or make it look different. It shows your the number of rebirths.
If you do NOT have a rebirth column execute this

Code:
ALTER TABLE `characters` ADD COLUMN `rebirth` int(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `pvpdeaths`;
Ok, since i figured out how to do it, and i realized many people don't have this i decided to release it.

This is only for DarkMagic's ranking which can be found Here

First off,

Find this line
Code:
$result2 = mysql_query("SELECT level, exp, characters.name name, meso, job, fame, logo, logoColor, guilds.name guildname, logoBG, logoBGColor, COUNT(eventstats.characterid) wins FROM accounts, characters LEFT JOIN guilds ON guilds.guildid = characters.guildid LEFT JOIN eventstats ON characters.id=eventstats.characterid WHERE characters.gm = 0 AND accountid = accounts.id AND banned = 0 ".$show." GROUP BY characters.id DESC ORDER BY $order level DESC, exp DESC")
And replace it with this
Code:
$result2 = mysql_query("SELECT level, rebirth, exp, characters.name name, meso, job, fame, logo, logoColor, guilds.name guildname, logoBG, logoBGColor, COUNT(eventstats.characterid) wins FROM accounts, characters LEFT JOIN guilds ON guilds.guildid = characters.guildid LEFT JOIN eventstats ON characters.id=eventstats.characterid WHERE characters.gm = 0 AND accountid = accounts.id AND banned = 0 ".$show." GROUP BY characters.id DESC ORDER BY $order rebirth DESC, level DESC, exp DESC")
Next, find this line.
Code:
$result = mysql_query("SELECT level, exp, characters.name name, meso, job, fame, logo, logoColor, guilds.name guildname, logoBG, logoBGColor, COUNT(eventstats.characterid) wins FROM accounts, characters LEFT JOIN guilds ON guilds.guildid = characters.guildid LEFT JOIN eventstats ON characters.id=eventstats.characterid WHERE characters.gm = 0 AND accountid = accounts.id AND banned = 0".$show." GROUP BY characters.id DESC ORDER BY $order level DESC, exp DESC LIMIT $start, ".$page_records)
And replace it with this,
Code:
$result = mysql_query("SELECT level, rebirth, exp, characters.name name, meso, job, fame, logo, logoColor, guilds.name guildname, logoBG, logoBGColor, COUNT(eventstats.characterid) wins FROM accounts, characters LEFT JOIN guilds ON guilds.guildid = characters.guildid LEFT JOIN eventstats ON characters.id=eventstats.characterid WHERE characters.gm = 0 AND accountid = accounts.id AND banned = 0".$show." GROUP BY characters.id DESC ORDER BY $order rebirth DESC, level DESC, exp DESC LIMIT $start, ".$page_records)
Next, find this line
Code:
echo "<tr valign=\"bottom\"> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b> Rank </b></font></td> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b> Character </b></font></td> <td align =\"center\"  bgcolor='".$title_bar."' width = 100><font color=\"".$title_font."\"><b> Name </b></font></td> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b> Fame </b></font></td> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b> FoJ </b></font></td> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b> Job Class </b></font></td> <td align =\"center\"  bgcolor='".$title_bar."' width = 100><font color=\"".$title_font."\"><b> Level </b></font></td> </tr>";
Replace it with this.
Code:
echo "<tr valign=\"bottom\"> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b> Rank </b></font></td> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b> Character </b></font></td> <td align =\"center\"  bgcolor='".$title_bar."' width = 100><font color=\"".$title_font."\"><b> Name </b></font></td> <td align =\"center\"  bgcolor='".$title_bar."' width = 100><font color=\"".$title_font."\"><b> Rebirth </b></font></td> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b> Fame </b></font></td> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b> FoJ </b></font></td> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b> Job Class </b></font></td> <td align =\"center\"  bgcolor='".$title_bar."' width = 100><font color=\"".$title_font."\"><b> Level </b></font></td> </tr>";
Then find this,
Code:
echo $row['fame'];
    echo " </b></td><td align =\"center\" bgcolor='".$backcolor."'>  <b>";
And put ABOVE it
Code:
    echo $row['rebirth'];
    echo " </b></td><td align =\"center\" bgcolor='".$backcolor."'>  <b>";
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

If you would like to have the index ranking show characters with more rebirths have a higher rank than use this.

This is for s0wh4t's CMS, i have not tested on any other!

In Index.php
Find this
Code:
$gc = mysql_query("SELECT * FROM `characters` WHERE `gm`='0' ORDER BY `level` DESC,`exp`") or die(mysql_error());
And replace it with
Code:
$gc = mysql_query("SELECT * FROM `characters` WHERE `gm`='0' ORDER BY `rebirth` DESC, `level` DESC,`exp`") or die(mysql_error());
Then find
Code:
echo "<td>".$player['level']."</td>";
Then add BELOW it
Code:
echo "<td>(".$player['rebirth'].")</td>";
If you need any help, just ask me.
Hope you enjoy this, even how easy it is, it took me quite a bit to figure it out haha.

~
EDIT:
Go here for a great reborn method!
http://forum.ragezone.com/f427/release-proper-rebirth-command-must-see-471853/
Credits to xazerrx
~


Credits:
Me for making this,
DarkMagic for ranking
s0wh4t? for CMS
 
Last edited:
Experienced Elementalist
Joined
Apr 6, 2008
Messages
296
Reaction score
3
Haha thanks, well this was a little bit harder than the fame seller :p
 
Banned
Banned
Joined
Sep 13, 2008
Messages
181
Reaction score
0
does thus make the char thing work??

i get this error when accecing my site
Parse error: syntax error, unexpected T_ECHO in C:\xampp\htdocs\index.php on line 136
 
Experienced Elementalist
Joined
Apr 6, 2008
Messages
296
Reaction score
3
You must have the character ranking images, from darkmagic's working completely for this to work.

And it doesnt show the avatar in the ranking on index.
 
Experienced Elementalist
Joined
Apr 6, 2008
Messages
296
Reaction score
3
Thanks.
Haxor, btw i see your sig, it says buzzfizz.
Are you buzzfizz or a friend or something?
 
Banned
Banned
Joined
Sep 13, 2008
Messages
181
Reaction score
0
soooooo if im using s0wh4t?'s CMS waht do i needah add for this to work?? o_O
 
Experienced Elementalist
Joined
Apr 6, 2008
Messages
296
Reaction score
3
The link is at the top,
You need to download darkmagic's ranking for s0wh4t CMS
 
Experienced Elementalist
Joined
Apr 6, 2008
Messages
296
Reaction score
3
Haha cause buzzfizz is one of my old friends whom i havent seen in a while.
 
Experienced Elementalist
Joined
Apr 6, 2008
Messages
296
Reaction score
3
Thanks, it helped me and i was hoping it helped some other people too. Glad to see it did ^^
 
Experienced Elementalist
Joined
Apr 6, 2008
Messages
296
Reaction score
3
Lol, maybe u can have someone help you.
I dont know how to explain it anymore haha
 
Experienced Elementalist
Joined
Apr 6, 2008
Messages
296
Reaction score
3
darkmagic is a user who created a ranking system, which i use.
This is only for darkmagics Ranking system
 
Back
Top