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

Website problems

Sirdonald

Member
Joined
Jan 16, 2012
Messages
119
Reaction score
11
Hi, I have a problem, literally, I'm trying to put a line to Highscore.php to show me the reborn, but if I throw it from the machine, the page does not work for me when you enter the empty white page. Will anyone help or how to remedy this?
 
Hi, I have a problem, literally, I'm trying to put a line to Highscore.php to show me the reborn, but if I throw it from the machine, the page does not work for me when you enter the empty white page. Will anyone help or how to remedy this?

Spagetti and noodles?
I dont understand. Improve the explanation pls.

Assuming that I understood::
Did you try adding some code in highscores.php and as a result got an empty white page when you accessed it from your browser?
 
so one problem it this

CANNOT WRITE TO FILE: config/config.php - edit file access for PHP [on linux: chmod]
CANNOT WRITE TO FILE: cache - edit file access for PHP [on linux: chmod]
CANNOT WRITE TO FILE: cache/flags - edit file access for PHP [on linux: chmod]
CANNOT WRITE TO FILE: cache/DONT_EDIT_usercounter.txt - edit file access for PHP [on linux: chmod]
CANNOT WRITE TO FILE: cache/DONT_EDIT_serverstatus.txt - edit file access for PHP [on linux: chmod]
CANNOT WRITE TO FILE: custom_scripts - edit file access for PHP [on linux: chmod]
CANNOT WRITE TO FILE: install.txt - edit file access for PHP [on linux: chmod]
 
so one problem it this

CANNOT WRITE TO FILE: config/config.php - edit file access for PHP [on linux: chmod]
CANNOT WRITE TO FILE: cache - edit file access for PHP [on linux: chmod]
CANNOT WRITE TO FILE: cache/flags - edit file access for PHP [on linux: chmod]
CANNOT WRITE TO FILE: cache/DONT_EDIT_usercounter.txt - edit file access for PHP [on linux: chmod]
CANNOT WRITE TO FILE: cache/DONT_EDIT_serverstatus.txt - edit file access for PHP [on linux: chmod]
CANNOT WRITE TO FILE: custom_scripts - edit file access for PHP [on linux: chmod]
CANNOT WRITE TO FILE: install.txt - edit file access for PHP [on linux: chmod]
you should use this command: chmod 777 -R var/www
 
$query = $SQL->query('SELECT players.name,players.id,players.level,players.reborn, players.experience, server_motd.id, server_motd.text FROM players,server_motd WHERE players.group_id < '.$config['site']['players_group_id_block'].' AND players.name != "Account Manager" ORDER BY reborn DESC LIMIT 1;')->fetch();

as I put in a file on the page from the main page to my white page
 
$query = $SQL->query('SELECT players.name,players.id,players.level,players.reborn, players.experience, server_motd.id, server_motd.text FROM players,server_motd WHERE players.group_id < '.$config['site']['players_group_id_block'].' AND players.name != "Account Manager" ORDER BY reborn DESC LIMIT 1;')->fetch();

as I put in a file on the page from the main page to my white page

ok.. So First of all you can't possibly select from multiple tables without joining them.
also there's nothing in server_motd table that is associated with any of the columns in players table so joining is not possible.

What you can do is create two different queries, 1 for players, 1 for server motd

PHP:
$player_info = $SQL->query("SELECT `id`,`name`,`level`,`reborn`,`experience` FROM `players` WHERE `players`.`group_id` < '.$config['site']['players_group_id_block'].' AND `players`.`name` != "Account Manager" ORDER BY `reborn` DESC LIMIT 1")->fetchAll();

$server_motd = $SQL->query("SELECT * FROM `server_motd`")->fetchAll();
 
Last edited:
ok.. So First of all you can't possibly select from multiple tables without joining them.
also there's nothing in server_motd table that is associated with any of the columns in players table so joining is not possible.

What you can do is create two different queries, 1 for players, 1 for server motd

PHP:
$player_info = $SQL->query("SELECT `id`,`name`,`level`,`reborn`,`experience` FROM `players` WHERE `players`.`group_id` < '.$config['site']['players_group_id_block'].' AND `players`.`name` != "Account Manager" ORDER BY `reborn` DESC LIMIT 1")->fetchAll();

$server_motd = $SQL->query("SELECT * FROM `server_motd`")->fetchAll();

I checked it and it's still a white page
 
I checked it and it's still a white page

Are you on a linux machine or windows?
& what webserver are you using ?

BTW I did some mistakes in the players query, use this ::

PHP:
$player_info = $SQL->query("SELECT `id`,`name`,`level`,`reborn`,`experience` FROM `players` WHERE `players`.`group_id` < ".$config['site']['players_group_id_block']." AND `players`.`name` != 'Account Manager' ORDER BY `reborn` DESC LIMIT 1")->fetchAll();
 
I use the liniux system and the Gessior 2012 website under tfs 0.3.6-0.4

note: I updated my previous post, change the players query to the new one.

ok go to /etc/php5/apache2/php.ini assuming that's where your php.ini file is located...
search for "display_errors" it should be set to Off by default. Change it to On
and then save the file.

restart apache2 by service apache2 restart
 
@Sirdonald
type: nano /etc/php5/fpm/php.ini

when the file opens, press CTRL+W and type display_errors (press enter twice to find the correct one)

it should be set to Off, change that to On.
after modifying, press CTRL+X, Y, ENTER

then restart by service apache2 restart
 
Back
Top