LucasFerraz
Systems Analyst
Great version, but contains some bugs.
1 - Forum, not to make new posts..
2 - Não reconhece a localização dos jogadores na hora de criar conta.
3 - Page?subtopic=accountmanagement&action=manage
4 - Also in the Manage Account, does not show Account
5 - account/ajax_accountname.php / account/ajax_charactername.php / account/ajax_email.php
Erro:
Fix Bug 3Code:Access denied for user 'www-data'@'localhost' (using password: NO)
Change:
To:Code:$c=mysql_connect($config['site']['connection_host'],$config['site']['connection_user'],$config['site']['connection_pass']) or die(mysql_error()); $b=mysql_select_db($config['site']['connection_db'], $c) or die(mysql_error()); $acc_qr = mysql_query("SELECT * FROM accounts WHERE email = '$account_email'");
Fix Bug 4Code:$SQL->query("SELECT * FROM accounts WHERE email = '$account_email'");
Remove:
Search:Code:$SQL->query("SELECT * FROM accounts WHERE email = '$account_email'"); while($ls = mysql_fetch_array($acc_qr)){ $accName = $ls['name']; }
Add below:Code:$account_email = $account_logged->getEMail();
[background=#fafafa]$account_name = $account_logged->getName();[/size][/background]
Create Account ERROR's:
Fix Bug 5Code:[Sun Aug 03 15:20:55 2014] [error] [client 127.0.0.1] PHP Warning: parse_ini_file(../config/config.ini): failed to open stream: No such file or directory in /var/www/account/ajax_accountname.php on line 30, referer: http://127.0.0.1/?subtopic=createaccount [Sun Aug 03 15:20:55 2014] [error] [client 127.0.0.1] PHP Warning: parse_ini_file(config.lua): failed to open stream: No such file or directory in /var/www/account/ajax_accountname.php on line 31, referer: [url=http://127.0.0.1/?subtopic=createaccount]http://127.0.0.1/?subtopic=createaccount[/url] [Sun Aug 03 15:20:55 2014] [error] [client 127.0.0.1] PHP Warning: mysql_pconnect(): Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/account/ajax_accountname.php on line 33, referer: [url=http://127.0.0.1/?subtopic=createaccount]http://127.0.0.1/?subtopic=createaccount[/url] [Sun Aug 03 15:21:00 2014] [error] [client 127.0.0.1] PHP Warning: parse_ini_file(../config/config.ini): failed to open stream: No such file or directory in /var/www/account/ajax_email.php on line 23, referer: [url=http://127.0.0.1/?subtopic=createaccount]http://127.0.0.1/?subtopic=createaccount[/url] [Sun Aug 03 15:21:00 2014] [error] [client 127.0.0.1] PHP Warning: parse_ini_file(config.lua): failed to open stream: No such file or directory in /var/www/account/ajax_email.php on line 24, referer: [url=http://127.0.0.1/?subtopic=createaccount]http://127.0.0.1/?subtopic=createaccount[/url] [Sun Aug 03 15:21:00 2014] [error] [client 127.0.0.1] PHP Warning: mysql_pconnect(): Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/account/ajax_email.php on line 26, referer: [url=http://127.0.0.1/?subtopic=createaccount]http://127.0.0.1/?subtopic=createaccount[/url] [Sun Aug 03 15:21:03 2014] [error] [client 127.0.0.1] PHP Notice: Uninitialized string offset: 6 in /var/www/account/ajax_charactername.php on line 67, referer: [url=http://127.0.0.1/?subtopic=createaccount]http://127.0.0.1/?subtopic=createaccount[/url] [Sun Aug 03 15:21:03 2014] [error] [client 127.0.0.1] PHP Warning: parse_ini_file(../config/config.ini): failed to open stream: No such file or directory in /var/www/account/ajax_charactername.php on line 76, referer: [url=http://127.0.0.1/?subtopic=createaccount]http://127.0.0.1/?subtopic=createaccount[/url] [Sun Aug 03 15:21:03 2014] [error] [client 127.0.0.1] PHP Warning: parse_ini_file(config.lua): failed to open stream: No such file or directory in /var/www/account/ajax_charactername.php on line 77, referer: [url=http://127.0.0.1/?subtopic=createaccount]http://127.0.0.1/?subtopic=createaccount[/url] [Sun Aug 03 15:21:03 2014] [error] [client 127.0.0.1] PHP Warning: mysql_pconnect(): Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/account/ajax_charactername.php on line 79, referer: [url=http://127.0.0.1/?subtopic=createaccount]http://127.0.0.1/?subtopic=createaccount[/url]
Change in all 3 files that:
To:Code:$c = parse_ini_file('../config/config.ini'); $c = parse_ini_file($c['server_path'].'config.lua'); $conn = mysql_pconnect($c['sqlHost'], $c['sqlUser'], $c['sqlPass']) or die(); mysql_select_db($c['sqlDatabase']);
And add the MySQL settings in config.phpCode:include("../config/config.php"); $conn = mysql_pconnect($config['site']['sqlHost'], $config['site']['sqlUser'], $config['site']['sqlPass']) or die(); mysql_select_db($config['site']['sqlDatabase']);
Add no Config.php:
Code:# MySQL Configs $config['site']['sqlHost'] = "localhost"; $config['site']['sqlUser'] = "root"; $config['site']['sqlPass'] = ""; $config['site']['sqlDatabase'] = "tfs";
I couldn't solve problem 3 and 4. Can you describe plz?