[Release]Rebirth column for darkmagic's ranking

[KillShadow05]

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

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

$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

$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.

$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,

$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

echo "<tr valign=\"bottom\"> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b>&nbsp;Rank&nbsp;</b></font></td> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b>&nbsp;Character&nbsp;</b></font></td> <td align =\"center\"  bgcolor='".$title_bar."' width = 100><font color=\"".$title_font."\"><b>&nbsp;Name&nbsp;</b></font></td> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b>&nbsp;Fame&nbsp;</b></font></td> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b>&nbsp;FoJ&nbsp;</b></font></td> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b>&nbsp;Job Class&nbsp;</b></font></td> <td align =\"center\"  bgcolor='".$title_bar."' width = 100><font color=\"".$title_font."\"><b>&nbsp;Level&nbsp;</b></font></td> </tr>";

Replace it with this.

echo "<tr valign=\"bottom\"> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b>&nbsp;Rank&nbsp;</b></font></td> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b>&nbsp;Character&nbsp;</b></font></td> <td align =\"center\"  bgcolor='".$title_bar."' width = 100><font color=\"".$title_font."\"><b>&nbsp;Name&nbsp;</b></font></td> <td align =\"center\"  bgcolor='".$title_bar."' width = 100><font color=\"".$title_font."\"><b>&nbsp;Rebirth&nbsp;</b></font></td> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b>&nbsp;Fame&nbsp;</b></font></td> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b>&nbsp;FoJ&nbsp;</b></font></td> <td align =\"center\"  bgcolor='".$title_bar."'><font color=\"".$title_font."\"><b>&nbsp;Job Class&nbsp;</b></font></td> <td align =\"center\"  bgcolor='".$title_bar."' width = 100><font color=\"".$title_font."\"><b>&nbsp;Level&nbsp;</b></font></td> </tr>";

Then find this,

    
echo $row['fame'];
    echo "&nbsp;</b></td><td align =\"center\" bgcolor='".$backcolor."'>&nbsp;&nbsp;<b>";

And put ABOVE it

    echo $row['rebirth'];
    echo "&nbsp;</b></td><td align =\"center\" bgcolor='".$backcolor."'>&nbsp;&nbsp;<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

$gc = mysql_query("SELECT * FROM `characters` WHERE `gm`='0' ORDER BY `level` DESC,`exp`") or die(mysql_error());

And replace it with

$gc = mysql_query("SELECT * FROM `characters` WHERE `gm`='0' ORDER BY `rebirth` DESC, `level` DESC,`exp`") or die(mysql_error());

Then find

echo "<td>".$player['level']."</td>";

Then add BELOW it

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/relea...st-see-471853/
Credits to xazerrx
~


Credits:
Me for making this,
DarkMagic for ranking
s0wh4t? for CMS

[MentaL]

[lols1996]

nice

[KillShadow05]

Haha thanks, well this was a little bit harder than the fame seller :P

[Leaf Story]

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

[KillShadow05]

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.

[ihatehaxor]

nice release

[KillShadow05]

Thanks.
Haxor, btw i see your sig, it says buzzfizz.
Are you buzzfizz or a friend or something?

[Leaf Story]

soooooo if im using s0wh4t?'s CMS waht do i needah add for this to work?? O_o

[KillShadow05]

The link is at the top,
You need to download darkmagic's ranking for s0wh4t CMS

[Leaf Story]

ooooooo ok ok and do i do teh top part too??

[KillShadow05]

Yea if you do not have it

[Leaf Story]

oooooooooooo ok ok ty

[Leimone]

I think buzzfizz made it for him.

[KillShadow05]

Haha cause buzzfizz is one of my old friends whom i havent seen in a while.

[DarkGoddes]

Pretty nice , Usefull thnx

[KillShadow05]

Thanks, it helped me and i was hoping it helped some other people too. Glad to see it did ^^

[brianobb]

im two dumb for this xD

[KillShadow05]

Lol, maybe u can have someone help you.
I dont know how to explain it anymore haha

[Leimone]

What's
darkmagic?

[KillShadow05]

darkmagic is a user who created a ranking system, which i use.
This is only for darkmagics Ranking system

[Im Blue]

Does darkmagic work with s0wh4ts cms

[KillShadow05]

Yes..thats the whole reason i said to use it. O_o

[tuunade]

Ahaha.Nice Reaper =]

[KillShadow05]

Thanks haha, sad to see not many people use it :P

[gengyun12]

Thanks