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

AAC what i need install on ubuntu 16.04 for gesior tfs0.4?

Sort by date Sort by votes
that means u need to add the sql into your database ,u can prolly find it in config,php or in a sql file inside the folder ,all explains in readme to probarly
 
Upvote 0 Downvote
theru said:
PHP - <- [TUTORIAL] * Gesior AAC 0.3.1 - How to Setup! steps is most likely the same on all gesiors websites :)
Click to expand...

It turotial for idiots, i have problems with my vps, cuz this gesior GesiorACC 2012 8.60 UPDATE 19/09/2016
worked with xampp without any errors, but on my vps he suck :(
I tested all versions, from all forums but any thing not work good.

> First site (latesnews.php) work but i have error in logs
[Tue Aug 14 06:18:14.280093 2018] [:error] [pid 15745] [client XXXX MY IP] PHP Warning: Invalid argument supplied for foreach() in /var/www/html/pages/latestnews.php on line 15
> I can't login it cuz i get htttp 500 error
> Samples dont be created
> Highscores - http 500 error
 
Upvote 0 Downvote
vexler222 said:
It turotial for idiots, i have problems with my vps, cuz this gesior GesiorACC 2012 8.60 UPDATE 19/09/2016
worked with xampp without any errors, but on my vps he suck :(
I tested all versions, from all forums but any thing not work good.

> First site (latesnews.php) work but i have error in logs
[Tue Aug 14 06:18:14.280093 2018] [:error] [pid 15745] [client XXXX MY IP] PHP Warning: Invalid argument supplied for foreach() in /var/www/html/pages/latestnews.php on line 15
> I can't login it cuz i get htttp 500 error
> Samples dont be created
> Highscores - http 500 error
Click to expand...
is it the $guild variable foreach statement?
 
Upvote 0 Downvote
theru said:
is it the $guild variable foreach statement?
Click to expand...
yep

Code: 
foreach($SQL->query('SELECT ' . $SQL->tableName('g') . '.' . $SQL->fieldName('id') . ' AS ' . $SQL->fieldName('id') . ', ' . $SQL->tableName('g') . '.' . $SQL->fieldName('name') . ' AS ' . $SQL->fieldName('name') . ', COUNT(' . $SQL->tableName('g') . '.' . $SQL->fieldName('name') . ') AS ' . $SQL->fieldName('frags') . ' FROM ' . $SQL->tableName('killers') . ' k LEFT JOIN ' . $SQL->tableName('player_killers') . ' pk ON ' . $SQL->tableName('k') . '.' . $SQL->fieldName('id') . ' = ' . $SQL->tableName('pk') . '.' . $SQL->fieldName('kill_id') . ' LEFT JOIN ' . $SQL->tableName('players') . ' p ON ' . $SQL->tableName('pk') . '.' . $SQL->fieldName('player_id') . ' = ' . $SQL->tableName('p') . '.' . $SQL->fieldName('id') . ' LEFT JOIN ' . $SQL->tableName('guild_ranks') . ' gr ON ' . $SQL->tableName('p') . '.' . $SQL->fieldName('rank_id') . ' = ' . $SQL->tableName('gr') . '.' . $SQL->fieldName('id') . ' LEFT JOIN ' . $SQL->tableName('guilds') . ' g ON ' . $SQL->tableName('gr') . '.' . $SQL->fieldName('guild_id') . ' = ' . $SQL->tableName('g') . '.' . $SQL->fieldName('id') . ' WHERE ' . $SQL->tableName('g') . '.' . $SQL->fieldName('id') . ' > 0 AND ' . $SQL->tableName('k') . '.' . $SQL->fieldName('unjustified') . ' = 1 AND ' . $SQL->tableName('k') . '.' . $SQL->fieldName('final_hit') . ' = 1 GROUP BY ' . $SQL->fieldName('name') . ' ORDER BY ' . $SQL->fieldName('frags') . ' DESC, ' . $SQL->fieldName('name') . ' ASC LIMIT 4;') as $guild)



but i remove old files and upload new, now work all (99%) but i can't create account, i try create account after cliked button "Sumbit" i see "Failed to create account."

Create character not work too, i try create new character on admin account but i see

Code: 
Error occured!
Error ID: Cannot save ItemsList. Player ID not set.
More info: 

File: /var/www/html/classes/itemslist.php   Line: 67
File: /var/www/html/classes/player.php   Line: 87
File: /var/www/html/pages/accountmanagement.php   Line: 1939
File: /var/www/html/system/load.page.php   Line: 7
File: /var/www/html/index.php   Line: 37
 
Upvote 0 Downvote
vexler222 said:
yep

Code: 
foreach($SQL->query('SELECT ' . $SQL->tableName('g') . '.' . $SQL->fieldName('id') . ' AS ' . $SQL->fieldName('id') . ', ' . $SQL->tableName('g') . '.' . $SQL->fieldName('name') . ' AS ' . $SQL->fieldName('name') . ', COUNT(' . $SQL->tableName('g') . '.' . $SQL->fieldName('name') . ') AS ' . $SQL->fieldName('frags') . ' FROM ' . $SQL->tableName('killers') . ' k LEFT JOIN ' . $SQL->tableName('player_killers') . ' pk ON ' . $SQL->tableName('k') . '.' . $SQL->fieldName('id') . ' = ' . $SQL->tableName('pk') . '.' . $SQL->fieldName('kill_id') . ' LEFT JOIN ' . $SQL->tableName('players') . ' p ON ' . $SQL->tableName('pk') . '.' . $SQL->fieldName('player_id') . ' = ' . $SQL->tableName('p') . '.' . $SQL->fieldName('id') . ' LEFT JOIN ' . $SQL->tableName('guild_ranks') . ' gr ON ' . $SQL->tableName('p') . '.' . $SQL->fieldName('rank_id') . ' = ' . $SQL->tableName('gr') . '.' . $SQL->fieldName('id') . ' LEFT JOIN ' . $SQL->tableName('guilds') . ' g ON ' . $SQL->tableName('gr') . '.' . $SQL->fieldName('guild_id') . ' = ' . $SQL->tableName('g') . '.' . $SQL->fieldName('id') . ' WHERE ' . $SQL->tableName('g') . '.' . $SQL->fieldName('id') . ' > 0 AND ' . $SQL->tableName('k') . '.' . $SQL->fieldName('unjustified') . ' = 1 AND ' . $SQL->tableName('k') . '.' . $SQL->fieldName('final_hit') . ' = 1 GROUP BY ' . $SQL->fieldName('name') . ' ORDER BY ' . $SQL->fieldName('frags') . ' DESC, ' . $SQL->fieldName('name') . ' ASC LIMIT 4;') as $guild)



but i remove old files and upload new, now work all (99%) but i can't create account, i try create account after cliked button "Sumbit" i see "Failed to create account."

Create character not work too, i try create new character on admin account but i see

Code: 
Error occured!
Error ID: Cannot save ItemsList. Player ID not set.
More info:

File: /var/www/html/classes/itemslist.php   Line: 67
File: /var/www/html/classes/player.php   Line: 87
File: /var/www/html/pages/accountmanagement.php   Line: 1939
File: /var/www/html/system/load.page.php   Line: 7
File: /var/www/html/index.php   Line: 37
Click to expand...
ok i found your solution,this is how u fix it [Solved] Gesior AAC issue while creating characted
 
Upvote 0 Downvote
If you have uniform server running mysql turn it off.
Go to
C:\UniServerZ\core\mysql/my.ini
find
thread_stack = 128K
increase it to 200k
save
restart mysql
 
Upvote 0 Downvote
PHP: 
if($guild) // Returns true if there is data (or not false/null)
{
    foreach($SQL->query('SELECT ' . $SQL->tableName('g') . '.' . $SQL->fieldName('id') . ' AS ' . $SQL->fieldName('id') . ', ' . $SQL->tableName('g') . '.' . $SQL->fieldName('name') . ' AS ' . $SQL->fieldName('name') . ', COUNT(' . $SQL->tableName('g') . '.' . $SQL->fieldName('name') . ') AS ' . $SQL->fieldName('frags') . ' FROM ' . $SQL->tableName('killers') . ' k LEFT JOIN ' . $SQL->tableName('player_killers') . ' pk ON ' . $SQL->tableName('k') . '.' . $SQL->fieldName('id') . ' = ' . $SQL->tableName('pk') . '.' . $SQL->fieldName('kill_id') . ' LEFT JOIN ' . $SQL->tableName('players') . ' p ON ' . $SQL->tableName('pk') . '.' . $SQL->fieldName('player_id') . ' = ' . $SQL->tableName('p') . '.' . $SQL->fieldName('id') . ' LEFT JOIN ' . $SQL->tableName('guild_ranks') . ' gr ON ' . $SQL->tableName('p') . '.' . $SQL->fieldName('rank_id') . ' = ' . $SQL->tableName('gr') . '.' . $SQL->fieldName('id') . ' LEFT JOIN ' . $SQL->tableName('guilds') . ' g ON ' . $SQL->tableName('gr') . '.' . $SQL->fieldName('guild_id') . ' = ' . $SQL->tableName('g') . '.' . $SQL->fieldName('id') . ' WHERE ' . $SQL->tableName('g') . '.' . $SQL->fieldName('id') . ' > 0 AND ' . $SQL->tableName('k') . '.' . $SQL->fieldName('unjustified') . ' = 1 AND ' . $SQL->tableName('k') . '.' . $SQL->fieldName('final_hit') . ' = 1 GROUP BY ' . $SQL->fieldName('name') . ' ORDER BY ' . $SQL->fieldName('frags') . ' DESC, ' . $SQL->fieldName('name') . ' ASC LIMIT 4;') as $guild)
}
and as for the guild issue if u get that again another time wrap it in a if statement
 
Upvote 0 Downvote
theru said:
If you have uniform server running mysql turn it off.
Go to
C:\UniServerZ\core\mysql/my.ini
find
thread_stack = 128K
increase it to 200k
save
restart mysql
Click to expand...

I dont have my.ini in mysql folder, but i have file msqld.cnf and i change thread_stack = 192k for 200k but still not work
 
Upvote 0 Downvote

Similar threads

Adorius Black
  • Question
AAC Xampp Linux
Replies
7
Views
340
Adorius Black
Adorius Black
J
  • Question
Gesior new php ubuntu problem
Replies
1
Views
284
Mateus Robeerto
Mateus Robeerto
L
  • Question
AAC gesior aac 2012 empty page
Replies
1
Views
275
Adorius Black
Adorius Black
dnmk
  • Question
AAC MyAAC site not working after installation
Replies
7
Views
675
Acubens
Acubens
falkyon
  • Question
AAC MyAAC v0.8.16 - cannot access admin page after installing gesior plugin
Replies
9
Views
427
falkyon
falkyon
T
  • Question
AAC Uncaught RuntimeException: Unable to create the cache directory (/home/ubuntu/html/system/cache/twig/7e)
Replies
2
Views
203
tobi132
T
Back
Top