Sziasztok.
Valaki tudna nekem segíteni ebben: hogy ne legyen elcsúszva?
Világ részt kivettem azaz a birodalmat. hogy ne legyen ott viszont a Szint el van csúszva és a helyezés is kicsit bal oldalra megy.
(https://board.ddmt2.net/proxy.php?request=http%3A%2F%2Fkephost.com%2Fimages%2F2016%2F09%2F11%2Fasd.png&hash=3ed4f829268c330b056f02c95d355cf31f819992)
TOP5 php kód:
<div class="ranking"><center>
<table style="border-spacing:0px;border-collapse:inherit;">
<?PHP
$sqlCmd = "SELECT player.id,player.name,player.level,player.exp,player_index.empire,guild.name AS guild_name
FROM player.player
LEFT JOIN player.player_index
ON player_index.id=player.account_id
LEFT JOIN player.guild_member
ON guild_member.pid=player.id
LEFT JOIN player.guild
ON guild.id=guild_member.guild_id
INNER JOIN account.account
ON account.id=player.account_id
WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
ORDER BY player.level DESC, player.exp DESC , name asc limit 5";
echo "<tr style='padding:0;'><td style='padding-right:15px;border-right:1px solid #101112;border-bottom:1px solid #101112;color:#444;text-align:center;'>Helyezés</td><td style='padding-left:10px;border-right:1px solid #101112;border-bottom:1px solid #101112;color:#444;'>Név</td><td style='padding-left:10px;border-right:1px solid #101112;border-bottom:1px solid #101112;color:#444;'>Szint</tr>";
$sqlQry = mysql_query($sqlCmd,$sqlServ);
$x=1;
while($getPlayers = mysql_fetch_object($sqlQry)) {
if($x=='1') {$rang='<img src="img/icons/gold.png"/>';} elseif($x=='2') {$rang='<img src="img/icons/silber.png"/>';} elseif($x=='3') {$rang='<img src="img/icons/bronze.png"/>';} else {$rang = $x;}
echo "<tr style='padding:0;'>";
echo "<td style='padding-right:15px;border-right:1px solid #101112;text-align:center;'>".$rang."</td>";
echo "<td style='padding-left:10px;border-right:1px solid #101112;'>".$getPlayers->name."</td>";
echo "<td style='padding-left:10px;text-align:center;'>";
if(!empty($getPlayers->empire)) {
}
echo "</td>";
echo "<td style='padding-left:5px;text-align:center;'>".$getPlayers->level."</td>";
echo "</tr>";
$x++;
}
?>
</table>
<br/>
<div style="text-align:center;"><a href="index.php?s=rankings">• Teljes Ranglista</a></div>
</div>
<div class="ranking" style="display:none">
<table style="border-spacing:0px;border-collapse:inherit;">
<?php $sql = "SELECT * FROM player.guild WHERE name NOT LIKE '[GM]%' AND name NOT LIKE '[GA]%' AND name NOT LIKE '[SGM]%' ORDER BY ladder_point desc LIMIT 5"; $i = "0" ; $ergebnis = mysql_query($sql);echo "<tr style='padding:0;'><td style='padding-right:15px;border-right:1px solid #101112;border-bottom:1px solid #101112;color:#444;text-align:center;'>Platz</td><td style='padding-left:10px;border-right:1px solid #101112;border-bottom:1px solid #101112;color:#444;'>Name</td><td style='padding-left:10px;border-bottom:1px solid #101112;color:#444;text-align:center;'>Punkte</tr>"; while($row = mysql_fetch_object($ergebnis)) { $i = $i + 1 ; if($i=='1') {$rang='<img src="img/gold.png"/>';} elseif($i=='2') {$rang='<img src="img/silber.png"/>';} elseif($i=='3') {$rang='<img src="img/bronze.png"/>';} else {$rang = $i;} echo " <tr style='padding:0;'> <td style='padding-right:15px;border-right:1px solid #101112;text-align:center;border-collapse:inherit;'>$rang</td> <td style='padding-left:10px;border-right:1px solid #101112;border-collapse:inherit;'>$row->name</td> <td style='padding-left:10px;text-align:center;border-collapse:inherit;'>$row->ladder_point</td></tr>"; }echo ' </table>';?>
<br/>
<div class="ranking-button" style="text-align:center;"><a style="cursor:pointer;">• Spielerrangliste</a></div>
<div style="text-align:center;"><a href="?s=ranking_gilden">• Komplette Rangliste</a></div>>
</center>
</div>
Szerintem inkább a cssbe keresgélj ne a phpban. Vagy itt írogasd át a számokat amiket meglátsz és px aztán kiderül mi van. Sose értettem a phphoz se egy css átírásához/megalkotásához de józan ésszel ezt simán meg lehet csinálni, good luck.
Őhm, értem én próbálgattam is. de semmi sikerrel nem haladtam a px-eket át írni.. mert egyszerűen nem megy összébb. valaki valamit?
Így próbáld meg:
<div class="ranking"><center>
<table style="border-spacing:0px;border-collapse:inherit;">
<?PHP
$sqlCmd = "SELECT player.id,player.name,player.level,player.exp,player_index.empire,guild.name AS guild_name
FROM player.player
LEFT JOIN player.player_index
ON player_index.id=player.account_id
LEFT JOIN player.guild_member
ON guild_member.pid=player.id
LEFT JOIN player.guild
ON guild.id=guild_member.guild_id
INNER JOIN account.account
ON account.id=player.account_id
WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
ORDER BY player.level DESC, player.exp DESC , name asc limit 5";
echo "<tr style='padding:0;'><td style='padding-right:15px;border-right:1px solid #101112;border-bottom:1px solid #101112;color:#444;text-align:center;'>Helyezés</td><td style='padding-left:10px;border-right:1px solid #101112;border-bottom:1px solid #101112;color:#444;'>Név</td><td style='padding-left:10px;border-right:1px solid #101112;border-bottom:1px solid #101112;color:#444;'>Szint</td></tr>";
$sqlQry = mysql_query($sqlCmd,$sqlServ);
$x=1;
while($getPlayers = mysql_fetch_object($sqlQry)) {
if($x=='1') {$rang='<img src="img/icons/gold.png"/>';} elseif($x=='2') {$rang='<img src="img/icons/silber.png"/>';} elseif($x=='3') {$rang='<img src="img/icons/bronze.png"/>';} else {$rang = $x;}
echo "<tr style='padding:0;'>";
echo "<td style='padding-right:15px;border-right:1px solid #101112;text-align:center;'>".$rang."</td>";
echo "<td style='padding-left:10px;border-right:1px solid #101112;'>".$getPlayers->name."</td>";
echo "<td style='padding-left:10px;text-align:center;'>";
if(!empty($getPlayers->empire)) {
}
echo "</td>";
echo "<td style='padding-left:5px;text-align:center;'>".$getPlayers->level."</td>";
echo "</tr>";
$x++;
}
?>
</table>
<br/>
<div style="text-align:center;"><a href="index.php?s=rankings">• Teljes Ranglista</a></div>
</div>
<div class="ranking" style="display:none">
<table style="border-spacing:0px;border-collapse:inherit;">
<?php $sql = "SELECT * FROM player.guild WHERE name NOT LIKE '[GM]%' AND name NOT LIKE '[GA]%' AND name NOT LIKE '[SGM]%' ORDER BY ladder_point desc LIMIT 5"; $i = "0" ; $ergebnis = mysql_query($sql);echo "<tr style='padding:0;'><td style='padding-right:15px;border-right:1px solid #101112;border-bottom:1px solid #101112;color:#444;text-align:center;'>Platz</td><td style='padding-left:10px;border-right:1px solid #101112;border-bottom:1px solid #101112;color:#444;'>Name</td><td style='padding-left:10px;border-bottom:1px solid #101112;color:#444;text-align:center;'>Punkte</tr>"; while($row = mysql_fetch_object($ergebnis)) { $i = $i + 1 ; if($i=='1') {$rang='<img src="img/gold.png"/>';} elseif($i=='2') {$rang='<img src="img/silber.png"/>';} elseif($i=='3') {$rang='<img src="img/bronze.png"/>';} else {$rang = $i;} echo " <tr style='padding:0;'> <td style='padding-right:15px;border-right:1px solid #101112;text-align:center;border-collapse:inherit;'>$rang</td> <td style='padding-left:10px;border-right:1px solid #101112;border-collapse:inherit;'>$row->name</td> <td style='padding-left:10px;text-align:center;border-collapse:inherit;'>$row->ladder_point</td></tr>"; }echo ' </table>';?>
<br/>
<div class="ranking-button" style="text-align:center;"><a style="cursor:pointer;">• Spielerrangliste</a></div>
<div style="text-align:center;"><a href="?s=ranking_gilden">• Komplette Rangliste</a></div>>
</center>
</div>
Ha nem működik a föntivel akkor próbáld meg így:
<div class="ranking"><center>
<table style="border-spacing:0px;border-collapse:inherit;">
<?PHP
$sqlCmd = "SELECT player.id,player.name,player.level,player.exp,player_index.empire,guild.name AS guild_name
FROM player.player
LEFT JOIN player.player_index
ON player_index.id=player.account_id
LEFT JOIN player.guild_member
ON guild_member.pid=player.id
LEFT JOIN player.guild
ON guild.id=guild_member.guild_id
INNER JOIN account.account
ON account.id=player.account_id
WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
ORDER BY player.level DESC, player.exp DESC , name asc limit 5";
echo "<tr style='padding:0;'><td style='padding-right:15px;border-right:1px solid #101112;border-bottom:1px solid #101112;color:#444;text-align:center;'>Helyezés</td><td style='padding-left:10px;border-right:1px solid #101112;border-bottom:1px solid #101112;color:#444;'>Név</td><td style='padding-left:10px;border-right:1px solid #101112;border-bottom:1px solid #101112;color:#444;'>Szint</td></tr>";
$sqlQry = mysql_query($sqlCmd,$sqlServ);
$x=1;
while($getPlayers = mysql_fetch_object($sqlQry)) {
if($x=='1') {$rang='<img src="img/icons/gold.png"/>';} elseif($x=='2') {$rang='<img src="img/icons/silber.png"/>';} elseif($x=='3') {$rang='<img src="img/icons/bronze.png"/>';} else {$rang = $x;}
echo "<tr style='padding:0;'>";
echo "<td style='padding-right:15px;border-right:1px solid #101112;text-align:center;'>".$rang."</td>";
echo "<td style='padding-left:10px;border-right:1px solid #101112;'>".$getPlayers->name."</td>";
echo "<td style='padding-left:5px;text-align:center;'>".$getPlayers->level."</td>";
echo "</tr>";
$x++;
}
?>
</table>
<br/>
<div style="text-align:center;"><a href="index.php?s=rankings">• Teljes Ranglista</a></div>
</div>
<div class="ranking" style="display:none">
<table style="border-spacing:0px;border-collapse:inherit;">
<?php $sql = "SELECT * FROM player.guild WHERE name NOT LIKE '[GM]%' AND name NOT LIKE '[GA]%' AND name NOT LIKE '[SGM]%' ORDER BY ladder_point desc LIMIT 5"; $i = "0" ; $ergebnis = mysql_query($sql);echo "<tr style='padding:0;'><td style='padding-right:15px;border-right:1px solid #101112;border-bottom:1px solid #101112;color:#444;text-align:center;'>Platz</td><td style='padding-left:10px;border-right:1px solid #101112;border-bottom:1px solid #101112;color:#444;'>Name</td><td style='padding-left:10px;border-bottom:1px solid #101112;color:#444;text-align:center;'>Punkte</tr>"; while($row = mysql_fetch_object($ergebnis)) { $i = $i + 1 ; if($i=='1') {$rang='<img src="img/gold.png"/>';} elseif($i=='2') {$rang='<img src="img/silber.png"/>';} elseif($i=='3') {$rang='<img src="img/bronze.png"/>';} else {$rang = $i;} echo " <tr style='padding:0;'> <td style='padding-right:15px;border-right:1px solid #101112;text-align:center;border-collapse:inherit;'>$rang</td> <td style='padding-left:10px;border-right:1px solid #101112;border-collapse:inherit;'>$row->name</td> <td style='padding-left:10px;text-align:center;border-collapse:inherit;'>$row->ladder_point</td></tr>"; }echo ' </table>';?>
<br/>
<div class="ranking-button" style="text-align:center;"><a style="cursor:pointer;">• Spielerrangliste</a></div>
<div style="text-align:center;"><a href="?s=ranking_gilden">• Komplette Rangliste</a></div>>
</center>
</div>
Melyik web? Ha nem volt jó a fenti illető, amit küldött, küldj egy képet a könyvtár szerkezetéről.
Ha megnézed akkor a táblázat nem jó
nézd meg hogy az első <tr> és </tr>(oszlop) között mennyi <td> (sor) van.
Ja meg először ha jól tudom akkor még a <tr> se volt lezárva