top fraggers problem

[tim26]

I have thus error




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';
?>

 

[Boy67]

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.

 

[kor]

mysql_query

This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. via https://www.php.net/manual/en/function.mysql-query.php

You should use newer extension (MySQLi) or include some function replacement like this php-mysql-fix/fix_mysql.inc.php at master · rubo77/php-mysql-fix (https://github.com/rubo77/php-mysql-fix/blob/master/fix_mysql.inc.php)

 

[tim26]

ok but wherer add this fix? "D

Post automatically merged: Mar 31, 2022

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: Mar 31, 2022

and of courtse in htdocs file fix_mysql.inc.php

Post automatically merged: Mar 31, 2022

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

 

[Gesior.pl]

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?

 

[tim26]

acc is official but i dowland layyout with all and now i add new scripts

Post automatically merged: Mar 31, 2022

 

[Leo Nard]

<?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';
?>

 

[tim26]

dont work ;/

 

[Leo Nard]

I think it's not from the text it's from mysql

 

[kor]

Don't put it in every file, instead place that include somewhere in AAC engine, for example in engine/init.php. Anyway, you should update your AAC, because in current Znote version it's proper usage of mysql methods - ZnoteAAC/connect.php at master · Znote/ZnoteAAC (https://github.com/Znote/ZnoteAAC/blob/master/engine/database/connect.php#L34)

 

[tim26]

bump