• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[Creaturescripts][PHP]Top Frags And second script only php

Top 25 Frags on New Era World
Name Frags
Warlock Of Earth 3456
War Frag System 2817
Will-oz 2508
Johnny Fahrenheit 1756
Ezkilo Da Morte 1457
Juquis 1345
Dulib Achmed Saab 1049
Rush Delta 745
Katchups 692


Is counting on High ;/ plz help me?
 
Where I copy this ?

Lua:
        case "frags";
        $topic = "Top Frags";
        $subtopic = "frags";
        include("frags.php");
    break;

I know that index.php, but i don't have this ruler:
Lua:
    case "bugtracker";
        $topic = "Bug Tracker";
        $subtopic = "bugtracker";
        include("bug.php");
    break;
 
Help me Elf..

zapytanie SQL: Dokumentacja

SELECT `p`.`name` AS `name` , COUNT( `p`.`name` ) AS `frags`
FROM `killers` k
LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id`
LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id`
WHERE `k`.`unjustified` =1
GROUP BY `name`
ORDER BY `frags` DESC , `name` ASC
LIMIT 0 , 30

MySQL zwrócił komunikat: Dokumentacja
#1054 - Unknown column 'pk.player_id' in 'on clause'



Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pk.player_id' in 'on clause'' in /home/www/acc/acc1/frags.php:17 Stack trace: #0 /home/www/acc/acc1/frags.php(17): PDO->query('SELECT `p`.`nam...') #1 /home/www/acc/acc1/index.php(82): include('/home/www/acc/a...') #2 {main} thrown in /home/www/acc/acc1/frags.php on line 17
 
SQL:
ALTER TABLE `player_killers` ADD `player_id` INT(11);
 
Back
Top