• 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!

top fraggers problem

tim26

Member
Joined
Aug 12, 2008
Messages
618
Reaction score
11
Location
Poland
I have thus error

1648689959095.png


ITS MY SCRIPT

<?php
require_once 'engine/init.php';
include 'layout/overall/header.php';
?>
<h2>Top Fraggers</h2>
<?php


$i = 0;
$ee = mysql_query("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 AND k.final_hit = 1
GROUP BY name
ORDER BY frags DESC, name ASC
LIMIT 0,30;")or die(mysql_error());
echo '<table><tr class="yellow"><td>Name</td><td>Frags</td></tr>';
while($e = mysql_fetch_assoc($ee))

{
$i++;
echo

'<tr><td>'.$e['name'] .'</td> <td> '.$e['frags'].'</tr><br>';
}
echo '</table>';
?>
<?php

include 'layout/overall/footer.php';
?>
 
I see you are posting several errors regarding your website.

Instead of creating a new thread for each of your errors, how about one of the following options:

1. Post all your errors in one thread, instead of littering the forum.
2. Use a more reliable acc maker, clearly the one you are using is not suitable with your current server.
3. Post in the jobs section for someone to help you fix all of these errors.
 
ok but wherer add this fix? "D
Post automatically merged:

ok i know how but dont work th4e same error i have this in fraggers.php

<?php
require_once 'engine/init.php';
include 'layout/overall/header.php';
include_once('fix_mysql.inc.php');
?>
<h2>Top Fraggers</h2>
<?php


$i = 0;
$ee = mysql_query("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 AND k.final_hit = 1
GROUP BY name
ORDER BY frags DESC, name ASC
LIMIT 0,30;")or die(mysql_error());
echo '<table><tr class="yellow"><td>Name</td><td>Frags</td></tr>';
while($e = mysql_fetch_assoc($ee))

{
$i++;
echo

'<tr><td>'.$e['name'] .'</td> <td> '.$e['frags'].'</tr><br>';
}
echo '</table>';
?>
<?php

include 'layout/overall/footer.php';
?>
Post automatically merged:

and of courtse in htdocs file fix_mysql.inc.php
Post automatically merged:

sorry i repair but now i have this error.....

1648713258349.png
 
Last edited:
Looks like these pages are not compatible with acc. maker.
This page expects that acc. maker executed mysql_connect somewhere and that there is already connection to MySQL.

Where did you get that acc. maker?
 
acc is official but i dowland layyout with all and now i add new scripts
Post automatically merged:

1648715233895.png
 
Last edited:
<?php
require_once 'engine/init.php';
include 'layout/overall/header.php';
?>
<h2>Top Fraggers</h2>
<?php


$i = 0;
$ee = mysql_query("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 AND k.final_hit = 1
GROUP BY name
ORDER BY frags DESC, name ASC
LIMIT 0,30;")or die(mysql_error());
echo '<table><tr class="yellow"><td>Name</td><td>Frags</td></tr>';
while($e = mysql_fetch_assoc($ee))

{
$i++;
echo

'<tr><td>'.$e['name'] .'</td> <td> '.$e['frags'].'</tr><br>';
}
?>
<?php

include 'layout/overall/footer.php';
?>
 
Back
Top