Grochu
New Member
- Joined
- Aug 10, 2009
- Messages
- 202
- Reaction score
- 2
Hi guys, i got some Znote ACC problems:
I use dwarf layout:
-CLICK!
1. After login in localhost/myaccount.php it shows me:
Code:string(128) "SELECT `name`, `level`, `vocation`, `town_id`, `lastlogin`, `online` FROM `players` WHERE `account_id`='1' ORDER BY `level` DESC" (query - SQL error) Type: select_multi (select multiple rows from database) Unknown column 'online' in 'field list'
2. localhost/onlinelist.php error:
Code:Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\engine\function\users.php on line 1180 Nobody is online.
1180 line:
Code:return mysql_result(mysql_query("SELECT COUNT(`id`) from `players` WHERE `online` = 1;"), 0);
3. localhost/guilds.php error:
Code:string(128) "SELECT `name`, `level`, `vocation`, `town_id`, `lastlogin`, `online` FROM `players` WHERE `account_id`='1' ORDER BY `level` DESC" (query - SQL error) Type: select_multi (select multiple rows from database) Unknown column 'online' in 'field list'
4. localhost/support.php error:
Code:Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\engine\function\users.php on line 140
140 line:
Code:while ($row = mysql_fetch_assoc($query)) {
Thanx for help!
and my database:
http://pastebin.com/Gxc2i9ta
+znote SQL
Andd sorry because of it (all massage not in one post)
http://otland.net/threads/znote-aac-dwarf-layout.208644/