[Help] With PHP Top Players page.

[Beta Limit]

Ok i downloaded a register/top players website source by scottdavey

It Shows the Top player for different thing, How would i go about adding the Top 3 or top 30 etc?

I'm not very good with PHP so i have no idea about this, i had a little mess around with it yesterday but anything i tried stopped it displaying anything.

[turk55]

there was a basic one posted by scottdavey here is the link to it :

[Beta Limit]

ok yeah thats the one i got but in that it only shows THE top person, what i want to do is show Top 10 or 30. Thats the help im asking for here

[turk55]

i c

[ph03nixx]

dude how do i start the site?

[sherwin9]

ph03nixx, please keep to this thread, if you want to know how to start the site, try to learn ´HOW TO READ´.

Ciao

[Beta Limit]

Bumping thread so i dont need to make a new one, Still need help with this.

[Incariuz]

I honestly don't know much about PHP, but it's ussually as simple as just reading to figure out what you need to change. I'll add the top players to my site and see if I can figure it out, I think I already have an idea of what it is. So I may be back editting this post, or making a new one in a few minutes.

Edit: Ok, well I tested it, but my idea didn't seem to work. However, the top players doesn't seem to gather information correctly, so... That's something else that would need to be worked on.

[Beta Limit]

Originally Posted by Incariuz

I honestly don't know much about PHP, but it's ussually as simple as just reading to figure out what you need to change. I'll add the top players to my site and see if I can figure it out, I think I already have an idea of what it is. So I may be back editting this post, or making a new one in a few minutes.

Edit: Ok, well I tested it, but my idea didn't seem to work. However, the top players doesn't seem to gather information correctly, so... That's something else that would need to be worked on.

yeah it needed a bit of editting

$res = mysql_query("SELECT CharName FROM characters ORDER BY Level DESC ;");
$res2 = mysql_query("SELECT Level FROM characters ORDER BY [U]Level[/U] DESC ;");

Underlined was edit made by me to make it right

and

$res = mysql_query("SELECT CharName FROM characters ORDER BY CPs DESC ;");
$res2 = mysql_query("SELECT CPs FROM characters ORDER BY [U]CPs[/U] DESC ;");

underlined editted here too.

Just need to get the next rows or something i dont know

[tanelipe]

$res = mysql_query("SELECT CharName FROM characters ORDER BY CPs DESC ;");
$res2 = mysql_query("SELECT CPs FROM characters ORDER BY CPs DESC ;");

Doesn't it have like,

LIMIT x

so something like...

$res = mysql_query("SELECT CharName FROM characters ORDER BY CPs DESC LIMIT 10;");
$res2 = mysql_query("SELECT CPs FROM characters ORDER BY CPs DESC LIMIT 10;");

then just, .res2[0,1,2,3,4...etc]

[nTL3fTy]

SELECT `CharName`,`Level` FROM `characters` WHERE `Job` BETWEEN 40 AND 45 ORDER BY `Level` DESC LIMIT 10;

[Beta Limit]

@Tanelipe, i tried that but the next values just show up as blank.

@nTL3fTy, will try that right now

EDIT: Didnt work, just blank spaces again

[Incariuz]

Originally Posted by Beta Limit

yeah it needed a bit of editting

$res = mysql_query("SELECT CharName FROM characters ORDER BY Level DESC ;");
$res2 = mysql_query("SELECT Level FROM characters ORDER BY [U]Level[/U] DESC ;");

Underlined was edit made by me to make it right

and

$res = mysql_query("SELECT CharName FROM characters ORDER BY CPs DESC ;");
$res2 = mysql_query("SELECT CPs FROM characters ORDER BY [U]CPs[/U] DESC ;");

underlined editted here too.

Just need to get the next rows or something i dont know

Ah, ok, didn't think of that, saw it, and was like huh... how does that make sense, lol, but didn't think to change it. Anyway, taking a break from quest making for a few, so I'll take a look at this again and see if I can find a way to make it work...

[nTL3fTy]

Here's an example, using my query with an added inner query to remove the high level accounts that are GMs. Of course, you will need to modify it to make it prettier as right now it only prints the data plainly. Hopefully you get the idea.

PHP Code:

<?php
$con = mysql_connect("localhost","root","") or die(mysql_error());
mysql_select_db("coproj");
$query = mysql_real_escape_string("SELECT `CharName`,`Level` FROM `characters` WHERE `Job` BETWEEN 10 AND 15 AND `Account` NOT IN(SELECT `AccountID` FROM `accounts` WHERE `Status`>0) ORDER BY `Level` DESC LIMIT 10;");
$res = mysql_query($query);
echo("Top Trojans<br />");
while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) {
    printf("Character: %s  Level: %s", $row["CharName"], $row["Level"]);
    echo("<br />");
}
$query = mysql_real_escape_string("SELECT `CharName`,`Level` FROM `characters` WHERE `Job` BETWEEN 20 AND 25 AND `Account` NOT IN(SELECT `AccountID` FROM `accounts` WHERE `Status`>0) ORDER BY `Level` DESC LIMIT 10;");
$res = mysql_query($query);
echo("<br />");
echo("Top Warriors<br />");
while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) {
    printf("Character: %s  Level: %s", $row["CharName"], $row["Level"]);
    echo("<br />");
}
mysql_free_result($res);
?>

[Beta Limit]

Originally Posted by Incariuz

Ah, ok, didn't think of that, saw it, and was like huh... how does that make sense, lol, but didn't think to change it. Anyway, taking a break from quest making for a few, so I'll take a look at this again and see if I can find a way to make it work...

Good luck

Originally Posted by nTL3fTy

Here's an example, using my query with an added inner query to remove the high level accounts that are GMs. Of course, you will need to modify it to make it prettier as right now it only prints the data plainly. Hopefully you get the idea.

Thank you so much it worked you are a genius