Webwereld

sql fout

Gestart doorJordymen27 reacties59 weergaven
Log in om mee te praten

28 berichten · pagina 2 van 2

Jordymen

Lid · Topicstarter

Berichten
1.447
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
$total = mysql_query("SELECT COUNT(`users`.`id`) FROM `users` ".$add2) or ($msg_geen);
$tf = mysql_result($total, 0) or ($msg_geen);

$pp = 25;

$pages = ceil($tf / $pp);

if(isset($_GET[page]) && ctype_digit($_GET[page]) && $_GET[page] >= 0 && $_GET[page] < $pages){
$page = $_GET[page];
} else {
$page = 0;
}

if(!isset($_GET[page])){
$score = getScore(ID);
$page = floor($score / $pp);
}

$start = $page * $pp;

$sql = mysql_query("SELECT `username`, `users`.`id`, `bankmoney`+`cashmoney` AS `money`, `leven`, `rank`, `naam` FROM `speldata`
LEFT JOIN `familie` ON `familie`.`id` =`speldata`.`familie_id`
LEFT JOIN `users` ON `users`.`id`=`speldata`.`id`
LEFT JOIN `status` ON `status`.`id`=`speldata`.`id`
".$add."
ORDER BY `speldata`.`score` DESC
LIMIT ".$start.", ".$pp) or die("We zijn bezig met een aanpassing!");
0
Antonn

Lid

Berichten
8.649
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Jordymen schreef:
$total = mysql_query("SELECT COUNT(`users`.`id`) FROM `users` ".mysql_real_escape_string($add2)) or ($msg_geen);
$tf = mysql_result($total, 0) or ($msg_geen);

$pp = 25;

$pages = ceil($tf / $pp);
if(isset($_GET[page]) && ctype_digit($_GET[page]) && $_GET[page] >= 0 && $_GET[page] < $pages){
$page = mysql_real_escape_string($_GET[page]);
} else {
$page = 0;
}

if(!isset($_GET[page])){
$score = getScore(ID);
$page = floor($score / $pp);
}

$start = $page * $pp;

$sql = mysql_query("SELECT `username`, `users`.`id`, `bankmoney`+`cashmoney` AS `money`, `leven`, `rank`, `naam` FROM `speldata`
LEFT JOIN `familie` ON `familie`.`id` =`speldata`.`familie_id`
LEFT JOIN `users` ON `users`.`id`=`speldata`.`id`
LEFT JOIN `status` ON `status`.`id`=`speldata`.`id`
".mysql_real_escape_string($add)."
ORDER BY `speldata`.`score` DESC
LIMIT ".$start.", ".$pp) or die("We zijn bezig met een aanpassing!");
0
Jordymen

Lid · Topicstarter

Berichten
1.447
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
ty

toevoeging op 13 oktober 2012, 14:48:56:
maar heb nog steeds de fout melding?
0
One2xs

Bot

Berichten
93.699
Reputatie
0
Punten
1,27
Lid sinds
Laatst gezien
Plaats dan de rest van het scriptemo
0
Jordymen

Lid · Topicstarter

Berichten
1.447
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien

session_start();

ob_start();

include("./_menu_l.php");

?>


$add = "";
$add2 = "";

$adds = array(
"",
"WHERE `rank`<5",
"WHERE `rank`>=5 && `rank`<12",
"WHERE `rank`>=12 && `rank`<22",
"WHERE `rank`>=22 && `rank`<47",
"WHERE `rank`>=47 && `rank`<77",
"WHERE `rank`>=77 && `rank`<110",
"WHERE `rank`>=110 && `rank`<160",
"WHERE `rank`>=160 && `rank`<260",
"WHERE `rank`>=260 && `rank`<510",
"WHERE `rank`>=510 && `rank`<860",
"WHERE `rank`>=860 && `rank`<1310",
"WHERE `rank`>=1310"
);
$x = 0;
if(isset($_GET[x]) && array_key_exists($_GET[x], $adds)){
$add = $adds[$_GET[x]];
$add2 = "LEFT JOIN `speldata` ON `speldata`.`id`=`users`.`id` ".$add;
$x = $_GET[x];
}

$total = mysql_query("SELECT COUNT(`users`.`id`) FROM `users` ".mysql_real_escape_string($add2)) or ($msg_geen);
$tf = mysql_result($total, 0) or ($msg_geen);

$pp = 25;

$pages = ceil($tf / $pp);

if(isset($_GET[page]) && ctype_digit($_GET[page]) && $_GET[page] >= 0 && $_GET[page] < $pages){
$page = mysql_real_escape_string($_GET[page]);
} else {
$page = 0;
}

if(!isset($_GET[page])){
$score = getScore(ID);
$page = floor($score / $pp);
}

$start = $page * $pp;

$sql = mysql_query("SELECT `username`, `users`.`id`, `bankmoney`+`cashmoney` AS `money`, `leven`, `rank`, `naam` FROM `speldata`
LEFT JOIN `familie` ON `familie`.`id` =`speldata`.`familie_id`
LEFT JOIN `users` ON `users`.`id`=`speldata`.`id`
LEFT JOIN `status` ON `status`.`id`=`speldata`.`id`
".mysql_real_escape_string($add)."
ORDER BY `speldata`.`score` DESC
LIMIT ".$start.", ".$pp) or die("We zijn bezig met een aanpassing!");

?>











Ledenlijst















$i = $start + 1;
while($res = mysql_fetch_assoc($sql)){

$rnk = getRank($res[rank]);
echo "








";
$i++;
}
if(mysql_num_rows($sql) == "0"){
echo"";
}
?>

#
Naam

Rank
Geld Rank
Familie
Leven

".$i."
".cname($res[id], $res[username])."
".$rnk[rank]."
".geldrank($res[money])."
".(is_null($res[naam]) ? "Geen" : "".$res[naam]."")."
".createBalk($res[leven])."
";
echo bad("Spelers hebben deze rank nog niet!");
echo "


>Top 25















dits hele script waar fout in komt
0
One2xs

Bot

Berichten
93.699
Reputatie
0
Punten
1,27
Lid sinds
Laatst gezien
Plaats het eens in code tags emo
0
Jordymen

Lid · Topicstarter

Berichten
1.447
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
[COLOR= #0000BB]<?php[/COLOR]


[URL="http://www.php.net/session_start"]session_start[/URL][COLOR= #007700]();[/COLOR]

[URL="http://www.php.net/ob_start"]ob_start[/URL][COLOR= #007700]();[/COLOR]

[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"./_menu_l.php"[/COLOR][COLOR= #007700]);[/COLOR]

?>

[COLOR= #0000BB]<?php

$add[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$add2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]


[COLOR= #0000BB]$adds[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR]
    [COLOR= #DD0000]""[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`<5"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=5 && `rank`<12"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=12 && `rank`<22"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=22 && `rank`<47"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=47 && `rank`<77"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=77 && `rank`<110"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=110 && `rank`<160"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=160 && `rank`<260"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=260 && `rank`<510"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=510 && `rank`<860"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=860 && `rank`<1310"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=1310"[/COLOR]
[COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$x[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]x[/COLOR][COLOR= #007700]]) &&[/COLOR] [URL="http://www.php.net/array_key_exists"]array_key_exists[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]x[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]$adds[/COLOR][COLOR= #007700])){[/COLOR]
    [COLOR= #0000BB]$add[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$adds[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]x[/COLOR][COLOR= #007700]]];[/COLOR]
    [COLOR= #0000BB]$add2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"LEFT JOIN `speldata` ON `speldata`.`id`=`users`.`id` "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$add[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$x[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]x[/COLOR][COLOR= #007700]];
}[/COLOR]

[COLOR= #0000BB]$total[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT COUNT(`users`.`id`) FROM `users` "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$add2[/COLOR][COLOR= #007700]))[/COLOR] or [COLOR= #007700]([/COLOR][COLOR= #0000BB]$msg_geen[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$tf[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_result"]mysql_result[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$total[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])[/COLOR] or [COLOR= #007700]([/COLOR][COLOR= #0000BB]$msg_geen[/COLOR][COLOR= #007700]);[/COLOR]

[COLOR= #0000BB]$pp[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]25[/COLOR][COLOR= #007700];[/COLOR]

[COLOR= #0000BB]$pages[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/ceil"]ceil[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$tf[/COLOR] / [COLOR= #0000BB]$pp[/COLOR][COLOR= #007700]);[/COLOR]


[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]page[/COLOR][COLOR= #007700]]) &&[/COLOR] [URL="http://www.php.net/ctype_digit"]ctype_digit[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]page[/COLOR][COLOR= #007700]]) &&[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]page[/COLOR][COLOR= #007700]] >=[/COLOR] [COLOR= #0000BB]0[/COLOR] [COLOR= #007700]&&[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]page[/COLOR][COLOR= #007700]] <[/COLOR] [COLOR= #0000BB]$pages[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$page[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]page[/COLOR][COLOR= #007700]]);
}[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$page[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];
}[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]page[/COLOR][COLOR= #007700]])){[/COLOR]
[COLOR= #0000BB]$score[/COLOR] [COLOR= #007700]=[/COLOR] getScore[COLOR= #007700]([/COLOR]ID[COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$page[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/floor"]floor[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$score[/COLOR] / [COLOR= #0000BB]$pp[/COLOR][COLOR= #007700]);
}[/COLOR]


[COLOR= #0000BB]$start[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$page[/COLOR] [COLOR= #007700]*[/COLOR] [COLOR= #0000BB]$pp[/COLOR][COLOR= #007700];[/COLOR]

[COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT `username`, `users`.`id`, `bankmoney`+`cashmoney` AS `money`, `leven`, `rank`, `naam` FROM `speldata` 
LEFT JOIN `familie` ON `familie`.`id` =`speldata`.`familie_id`
LEFT JOIN `users` ON `users`.`id`=`speldata`.`id`
LEFT JOIN `status` ON `status`.`id`=`speldata`.`id`    
"[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$add[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]"    
ORDER BY `speldata`.`score` DESC
LIMIT "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$start[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$pp[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"We zijn bezig met een aanpassing!"[/COLOR][COLOR= #007700]);[/COLOR]


?>

<tr>

                <td style=text-align: center;>

                    
<table border=0 cellspacing=1 width=96% bgcolor=#000 align=center>
    <tr>
        <td class="top" colspan="4">
            Ledenlijst        </td>
    </tr>
    
</tr>

        
<tr>
        <td colspan="2" class="container">
            <table border="0" cellspacing="1" width="96%" bgcolor="#000" align="center">
    <tr>
        <td class="subtop" width="5%">
            #
        </td>
        <td class="subtop" width="19%">
            Naam        </td>
        <td class="subtop" width="19%">

            Rank        </td>
        <td class="subtop" width="19%">
            Geld Rank        </td>
        <td class="subtop" width="19%">
            Familie        </td>
        <td class="subtop" width="19%">
            Leven        </td>

    </tr>

    [COLOR= #0000BB]<?php 
    $i[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$start[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700])){[/COLOR]

         [COLOR= #0000BB]$rnk[/COLOR] [COLOR= #007700]=[/COLOR] getRank[COLOR= #007700]([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]rank[/COLOR][COLOR= #007700]]);[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"
        <tr>
            <td class=inhoud_c width=5% style=vertical-align: middle; "[/COLOR][COLOR= #007700].(([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] ==[/COLOR] ID[COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]"background-color: #606060"[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]";>
                "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"
            </td>
            <td class=inhoud width=20% "[/COLOR][COLOR= #007700].(([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] ==[/COLOR] ID[COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]"style=background-color: #606060;"[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]">
                "[/COLOR][COLOR= #007700].[/COLOR]cname[COLOR= #007700]([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"
            </td>
            <td class=inhoud width=20% "[/COLOR][COLOR= #007700].(([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] ==[/COLOR] ID[COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]"style=background-color: #606060;"[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]">
                "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rnk[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]rank[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"
            </td>
            <td class=inhoud width=20% "[/COLOR][COLOR= #007700].(([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] ==[/COLOR] ID[COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]"style=background-color: #606060;"[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]">
                "[/COLOR][COLOR= #007700].[/COLOR]geldrank[COLOR= #007700]([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]money[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"
            </td>
            <td class=inhoud width=20% "[/COLOR][COLOR= #007700].(([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] ==[/COLOR] ID[COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]"style=background-color: #606060;"[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]">
                "[/COLOR][COLOR= #007700].([/COLOR][URL="http://www.php.net/is_null"]is_null[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]]) ?[/COLOR] [COLOR= #DD0000]"Geen"[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]"<a href=fampage.php?x="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</a>"[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]"
            </td>
            <td class=inhoud width=15% "[/COLOR][COLOR= #007700].(([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] ==[/COLOR] ID[COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]"style=background-color: #606060;"[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]">
                "[/COLOR][COLOR= #007700].[/COLOR]createBalk[COLOR= #007700]([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]leven[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"
            </td>
        </tr>
        "[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$i[/COLOR][COLOR= #007700]++;
    }[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #DD0000]"0"[/COLOR][COLOR= #007700]){[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]"<tr><td class=inhoud colspan=6>"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] bad[COLOR= #007700]([/COLOR][COLOR= #DD0000]"Spelers hebben deze rank nog niet!"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</td></tr>"[/COLOR][COLOR= #007700];
}[/COLOR]
?>
</table>
<br>
<table border=0 cellspacing=1 width=96% bgcolor=#000 align=center>
    <tr>
        <td class=inhoud_c width=33%>
        
            <select onChange=location="ledenlijst.php?page=<?=$page;?>&x=" + this.value>
                [COLOR= #0000BB]<?php
                
                $options[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Allemaal"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Scum"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Pee Wee"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Thug"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Gangster"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Hitman"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Assassin"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Boss"[/COLOR][COLOR= #007700],[/COLOR] 
                                    [COLOR= #DD0000]"Godfather"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Legendary Godfather"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Don"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Respectable Don"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Legendary Don"[/COLOR][COLOR= #007700]);[/COLOR]
                
                [URL="http://www.php.net/foreach"]foreach[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$options[/COLOR] [COLOR= #007700]AS[/COLOR] [COLOR= #0000BB]$k[/COLOR] [COLOR= #007700]=>[/COLOR] [COLOR= #0000BB]$name[/COLOR][COLOR= #007700]){[/COLOR]
                    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$k[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]$x[/COLOR][COLOR= #007700]){[/COLOR]
                        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<option value="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$k[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" selected=selected>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$name[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</option>"[/COLOR][COLOR= #007700];
                    }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
                        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<option value="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$k[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$name[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</option>"[/COLOR][COLOR= #007700];
                    }
                }[/COLOR]
                ?>
            </select>
        </td>
        <td class=inhoud_c width=33%>
            <select onChange=location="ledenlijst.php?x=<?=$x;?>&page=" + this.value>
            [COLOR= #0000BB]<?php[/COLOR]
            [URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]<[/COLOR] [COLOR= #0000BB]$pages[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$j[/COLOR][COLOR= #007700]++){[/COLOR]
                 [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]$page[/COLOR][COLOR= #007700]){[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<option value="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" selected=selected>"[/COLOR][COLOR= #007700].([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]"</option>"[/COLOR][COLOR= #007700];
                }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<option value="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]"</option>"[/COLOR][COLOR= #007700];
                }    
            }[/COLOR]
            ?>
            </select>
        </td>
        <td class=inhoud_c width=33% style=vertical-align: middle;>
            <a href=ledenlijst.php?page=0&x=<?=$x;?>>Top <b>25</b></a>
        </td>
    </tr>
</table>

</td></tr>

        
</table>




                </td>

            </tr>

                </td>

            </tr>
[COLOR= #0000BB]<?[/COLOR] [URL="http://www.php.net/include"]include[/URL] [COLOR= #007700]([/COLOR][COLOR= #DD0000]"_menu_r.php"[/COLOR][COLOR= #007700]);[/COLOR] ?>


toevoeging op 13 oktober 2012, 16:02:16:
zobiggrin?
0
One2xs

Bot

Berichten
93.699
Reputatie
0
Punten
1,27
Lid sinds
Laatst gezien
Verander $page = 0; eens in $page = 1;
0
Jordymen

Lid · Topicstarter

Berichten
1.447
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
nog steeds de fout?

toevoeging op 13 oktober 2012, 16:08:05:
Sevvlor schreef:
Verander $page = 0; eens in $page = 1;
heb nog de fout hoor

toevoeging op 13 oktober 2012, 161151:

[COLOR= #0000BB]<?php[/COLOR]


[URL="http://www.php.net/session_start"]session_start[/URL][COLOR= #007700]();[/COLOR]

[URL="http://www.php.net/ob_start"]ob_start[/URL][COLOR= #007700]();[/COLOR]

[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"./_menu_l.php"[/COLOR][COLOR= #007700]);[/COLOR]

?>

[COLOR= #0000BB]<?php

$add[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$add2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]


[COLOR= #0000BB]$adds[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR]
    [COLOR= #DD0000]""[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`<5"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=5 && `rank`<12"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=12 && `rank`<22"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=22 && `rank`<47"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=47 && `rank`<77"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=77 && `rank`<110"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=110 && `rank`<160"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=160 && `rank`<260"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=260 && `rank`<510"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=510 && `rank`<860"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=860 && `rank`<1310"[/COLOR][COLOR= #007700],[/COLOR]
    [COLOR= #DD0000]"WHERE `rank`>=1310"[/COLOR]
[COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$x[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]x[/COLOR][COLOR= #007700]]) &&[/COLOR] [URL="http://www.php.net/array_key_exists"]array_key_exists[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]x[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]$adds[/COLOR][COLOR= #007700])){[/COLOR]
    [COLOR= #0000BB]$add[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$adds[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]x[/COLOR][COLOR= #007700]]];[/COLOR]
    [COLOR= #0000BB]$add2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"LEFT JOIN `speldata` ON `speldata`.`id`=`users`.`id` "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$add[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$x[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]x[/COLOR][COLOR= #007700]];
}[/COLOR]

[COLOR= #0000BB]$total[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT COUNT(`users`.`id`) FROM `users` "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$add2[/COLOR][COLOR= #007700]))[/COLOR] or [COLOR= #007700]([/COLOR][COLOR= #0000BB]$msg_geen[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$tf[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_result"]mysql_result[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$total[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])[/COLOR] or [COLOR= #007700]([/COLOR][COLOR= #0000BB]$msg_geen[/COLOR][COLOR= #007700]);[/COLOR]

[COLOR= #0000BB]$pp[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]25[/COLOR][COLOR= #007700];[/COLOR]

[COLOR= #0000BB]$pages[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/ceil"]ceil[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$tf[/COLOR] / [COLOR= #0000BB]$pp[/COLOR][COLOR= #007700]);[/COLOR]


[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]page[/COLOR][COLOR= #007700]]) &&[/COLOR] [URL="http://www.php.net/ctype_digit"]ctype_digit[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]page[/COLOR][COLOR= #007700]]) &&[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]page[/COLOR][COLOR= #007700]] >=[/COLOR] [COLOR= #0000BB]0[/COLOR] [COLOR= #007700]&&[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]page[/COLOR][COLOR= #007700]] <[/COLOR] [COLOR= #0000BB]$pages[/COLOR][COLOR= #007700]){[/COLOR]
[COLOR= #0000BB]$page[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]page[/COLOR][COLOR= #007700]]);
}[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
[COLOR= #0000BB]$page[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];
}[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]page[/COLOR][COLOR= #007700]])){[/COLOR]
[COLOR= #0000BB]$score[/COLOR] [COLOR= #007700]=[/COLOR] getScore[COLOR= #007700]([/COLOR]ID[COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$page[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/floor"]floor[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$score[/COLOR] / [COLOR= #0000BB]$pp[/COLOR][COLOR= #007700]);
}[/COLOR]


[COLOR= #0000BB]$start[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$page[/COLOR] [COLOR= #007700]*[/COLOR] [COLOR= #0000BB]$pp[/COLOR][COLOR= #007700];[/COLOR]

[COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT `username`, `users`.`id`, `bankmoney`+`cashmoney` AS `money`, `leven`, `rank`, `naam` FROM `speldata` 
LEFT JOIN `familie` ON `familie`.`id` =`speldata`.`familie_id`
LEFT JOIN `users` ON `users`.`id`=`speldata`.`id`
LEFT JOIN `status` ON `status`.`id`=`speldata`.`id`    
"[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$add[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]"    
ORDER BY `speldata`.`score` DESC
LIMIT "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$start[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$pp[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"We zijn bezig met een aanpassing!"[/COLOR][COLOR= #007700]);[/COLOR]


?>

<tr>

                <td style=text-align: center;>

                    
<table border=0 cellspacing=1 width=96% bgcolor=#000 align=center>
    <tr>
        <td class="top" colspan="4">
            Ledenlijst        </td>
    </tr>
    
</tr>

        
<tr>
        <td colspan="2" class="container">
            <table border="0" cellspacing="1" width="96%" bgcolor="#000" align="center">
    <tr>
        <td class="subtop" width="5%">
            #
        </td>
        <td class="subtop" width="19%">
            Naam        </td>
        <td class="subtop" width="19%">

            Rank        </td>
        <td class="subtop" width="19%">
            Geld Rank        </td>
        <td class="subtop" width="19%">
            Familie        </td>
        <td class="subtop" width="19%">
            Leven        </td>

    </tr>

    [COLOR= #0000BB]<?php 
    $i[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$start[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$res[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700])){[/COLOR]

         [COLOR= #0000BB]$rnk[/COLOR] [COLOR= #007700]=[/COLOR] getRank[COLOR= #007700]([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]rank[/COLOR][COLOR= #007700]]);[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"
        <tr>
            <td class=inhoud_c width=5% style=vertical-align: middle; "[/COLOR][COLOR= #007700].(([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] ==[/COLOR] ID[COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]"background-color: #606060"[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]";>
                "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"
            </td>
            <td class=inhoud width=20% "[/COLOR][COLOR= #007700].(([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] ==[/COLOR] ID[COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]"style=background-color: #606060;"[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]">
                "[/COLOR][COLOR= #007700].[/COLOR]cname[COLOR= #007700]([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"
            </td>
            <td class=inhoud width=20% "[/COLOR][COLOR= #007700].(([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] ==[/COLOR] ID[COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]"style=background-color: #606060;"[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]">
                "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rnk[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]rank[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"
            </td>
            <td class=inhoud width=20% "[/COLOR][COLOR= #007700].(([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] ==[/COLOR] ID[COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]"style=background-color: #606060;"[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]">
                "[/COLOR][COLOR= #007700].[/COLOR]geldrank[COLOR= #007700]([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]money[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"
            </td>
            <td class=inhoud width=20% "[/COLOR][COLOR= #007700].(([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] ==[/COLOR] ID[COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]"style=background-color: #606060;"[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]">
                "[/COLOR][COLOR= #007700].([/COLOR][URL="http://www.php.net/is_null"]is_null[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]]) ?[/COLOR] [COLOR= #DD0000]"Geen"[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]"<a href=fampage.php?x="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</a>"[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]"
            </td>
            <td class=inhoud width=15% "[/COLOR][COLOR= #007700].(([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] ==[/COLOR] ID[COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]"style=background-color: #606060;"[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]">
                "[/COLOR][COLOR= #007700].[/COLOR]createBalk[COLOR= #007700]([/COLOR][COLOR= #0000BB]$res[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]leven[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"
            </td>
        </tr>
        "[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$i[/COLOR][COLOR= #007700]++;
    }[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #DD0000]"0"[/COLOR][COLOR= #007700]){[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]"<tr><td class=inhoud colspan=6>"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] bad[COLOR= #007700]([/COLOR][COLOR= #DD0000]"Spelers hebben deze rank nog niet!"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</td></tr>"[/COLOR][COLOR= #007700];
}[/COLOR]
?>
</table>
<br>
<table border=0 cellspacing=1 width=96% bgcolor=#000 align=center>
    <tr>
        <td class=inhoud_c width=33%>
        
            <select onChange=location="ledenlijst.php?page=<?=$page;?>&x=" + this.value>
                [COLOR= #0000BB]<?php
                
                $options[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Allemaal"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Scum"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Pee Wee"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Thug"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Gangster"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Hitman"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Assassin"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Boss"[/COLOR][COLOR= #007700],[/COLOR] 
                                    [COLOR= #DD0000]"Godfather"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Legendary Godfather"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Don"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Respectable Don"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"Legendary Don"[/COLOR][COLOR= #007700]);[/COLOR]
                
                [URL="http://www.php.net/foreach"]foreach[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$options[/COLOR] [COLOR= #007700]AS[/COLOR] [COLOR= #0000BB]$k[/COLOR] [COLOR= #007700]=>[/COLOR] [COLOR= #0000BB]$name[/COLOR][COLOR= #007700]){[/COLOR]
                    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$k[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]$x[/COLOR][COLOR= #007700]){[/COLOR]
                        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<option value="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$k[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" selected=selected>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$name[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</option>"[/COLOR][COLOR= #007700];
                    }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
                        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<option value="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$k[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$name[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</option>"[/COLOR][COLOR= #007700];
                    }
                }[/COLOR]
                ?>
            </select>
        </td>
        <td class=inhoud_c width=33%>
            <select onChange=location="ledenlijst.php?x=<?=$x;?>&page=" + this.value>
            [COLOR= #0000BB]<?php[/COLOR]
            [URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]<[/COLOR] [COLOR= #0000BB]$pages[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$j[/COLOR][COLOR= #007700]++){[/COLOR]
                 [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]$page[/COLOR][COLOR= #007700]){[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<option value="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" selected=selected>"[/COLOR][COLOR= #007700].([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]"</option>"[/COLOR][COLOR= #007700];
                }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<option value="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$j[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].([/COLOR][COLOR= #0000BB]$j[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]"</option>"[/COLOR][COLOR= #007700];
                }    
            }[/COLOR]
            ?>
            </select>
        </td>
        <td class=inhoud_c width=33% style=vertical-align: middle;>
            <a href=ledenlijst.php?page=0&x=<?=$x;?>>Top <b>25</b></a>
        </td>
    </tr>
</table>

</td></tr>

        
</table>




                </td>

            </tr>

                </td>

            </tr>
[COLOR= #0000BB]<?[/COLOR] [URL="http://www.php.net/include"]include[/URL] [COLOR= #007700]([/COLOR][COLOR= #DD0000]"_menu_r.php"[/COLOR][COLOR= #007700]);[/COLOR] ?>
0
One2xs

Bot

Berichten
93.699
Reputatie
0
Punten
1,27
Lid sinds
Laatst gezien
ik zie m niet
0
Jordymen

Lid · Topicstarter

Berichten
1.447
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
line 51

toevoeging op 13 oktober 2012, 161413:
Sevvlor schreef:
ik zie m niet
line 51
0
One2xs

Bot

Berichten
93.699
Reputatie
0
Punten
1,27
Lid sinds
Laatst gezien
Jordymen schreef:
line 51
toevoeging op 13 oktober 2012, 161413:
Sevvlor schreef:
ik zie m niet
line 51

Ik zie de fout niet bedoelde ik sadley
0
Jordymen

Lid · Topicstarter

Berichten
1.447
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
dit krijg ik als ik de ledenlijst open

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near at line 1

toevoeging op 13 oktober 2012, 17:45:37:
wie kan dit oplossen?

toevoeging op 13 oktober 2012, 23:02:20:
Fanorg schreef:
Met een stukje van je code komen we al veel verder... emo
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near at line 1

code word ook weeergeven weet je miss wat?
0

Jouw reactie

Deel je idee, stel een vraag of help een ander verder.

Editor laden…

Praat mee met de One2xs-community.

Inloggen om te reageren