hallo com habe vergeblichst versucht das script umzuschreiben so das anstadt exp die online zeit abgelesen wird beckomme staendig i welche errors
hoffe es schreibt mir ein kenner kurz um so das das ranking von der online zeit
erstaelt wird und nicht laut dem exp
mfg
if(isset($_POST['suche']) && $_POST['suche']=='Αναζήτηση') { if(!empty($_POST['charakter'])) { $sqlCmd="SELECT id, name, level, exp, empire, guild_name, rang FROM (
SELECT id, name, level, exp, empire, guild_name, @num := @num +1 AS rang FROM (
SELECT player.id, player.name, player.level, player.exp, player_index.empire, guild.name AS guild_name, @num :=0 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
) AS t1
) AS t2
WHERE name = '".mysql_real_escape_string($_POST['charakter'])."' LIMIT 1"; $sqlQry=mysql_query($sqlCmd,$sqlServ); if(mysql_num_rows($sqlQry)>0) {
$sqlCmd = "SELECT COUNT(*) as summeChars 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";
<table> <tr> <th class="topLine">Βαθμ</th> <th class="topLine">Όνομα</th> <th class="topLine">Επίπεδο</th> <th class="topLine">EXP</th> <th class="topLine">Συντεχνία</th> <th class="topLine">Βασίλειο</th> </tr> <?PHP $sqlCmd = "SELECT player.id,player.name,player.level,player.exp,player_index.empire,guild.name AS guild_name,guild.id AS guild_id 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 LIMIT ".$cSeite[1].",".$CPSeite;
$sqlCmd2 = "SELECT player.name,player.account_id FROM player.player INNER JOIN account.account ON account.id=player.account_id WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'";
if(isset($_POST['suche']) && $_POST['suche']=='Αναζήτηση') {
if(!empty($_POST['charakter'])) {
$sqlCmd="SELECT id, name, level, playtime, empire, guild_name, rang
FROM (
SELECT id, name, level, playtime, empire, guild_name, @num := @num +1 AS rang
FROM (
SELECT player.id, player.name, player.level, player.playtime, player_index.empire, guild.name AS guild_name, @num :=0
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.playtime DESC
) AS t1
) AS t2
WHERE name = '".mysql_real_escape_string($_POST['charakter'])."' LIMIT 1";
$sqlQry=mysql_query($sqlCmd,$sqlServ);
if(mysql_num_rows($sqlQry)>0) {
$sqlCmd = "SELECT COUNT(*) as summeChars
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";
<table>
<tr>
<th class="topLine">Βαθμ</th>
<th class="topLine">Όνομα</th>
<th class="topLine">Επίπεδο</th>
<th class="topLine">Χρόνος Online</th>
<th class="topLine">Συντεχνία</th>
<th class="topLine">Βασίλειο</th>
</tr>
<?PHP
$sqlCmd = "SELECT player.id,player.name,player.level,player.playtime,player_index.empire,guild.name AS guild_name,guild.id AS guild_id
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.playtime DESC
LIMIT ".$cSeite[1].",".$CPSeite;
$sqlCmd2 = "SELECT player.name,player.account_id FROM player.player
INNER JOIN account.account
ON account.id=player.account_id
WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'";
Ranking Script 10/18/2012 - Flyff Private Server - 5 Replies Habe gehört hier gibt es ein Fixxed Ranking Script aber ich find es ned..
Hat es einer wo die Xss lücken weg sind? Will was probieren^^
[Web]Script Ranking 12/27/2011 - Rappelz Private Server - 2 Replies I Make the Script for Select Ranking TOP Levels
***********************************************
<?php
$host = "(local)"; // your sql instance
$user = "sa"; // username
$pw = ""; // password
[Suche] Homepage Ranking 08/05/2011 - Flyff Private Server - 5 Replies Hallo epvp'ers
Ich bin wie schon wie oben geschriben auf der suche nach einem PHP-Skript für die Homepage unzwar einem Ranking mit einer Online-Anzeige und die nicht nach Klasse sortiert. Am besten ist es wenn es erst nach LVL und dann nach Online-Anzeige sortier. Ich habe auch nichts mit der Suchmaschine entdeken können. Würde mich sehr freuen über einen Skript die hoffentlich so ist wie da oben beschriben ist.
lg. Play
[Release]Hamachi Homepage Script {Ranking, Download, Registrierung,Status} 12/29/2010 - Metin2 PServer Guides & Strategies - 17 Replies Hallo Leute
Ich habe mich heute mal rangesetzt und ein Homepage Script für Hamachi server zu basteln.
Ich will jetzt nicht soviel schreiben weils eh kaum einer ließt xD
Lets go :D
Hier eine kleine Vorschau:
http://img832.imageshack.us/img832/5175/vorschauz .jpg
Was beitet das Script :
Ranking Script v15 06/26/2010 - Flyff Private Server - 4 Replies Hi,
Hat hier vielleicht wer ne voll funktionstüchtige Ranking script für v15.?
Danke schon mal^^
