26.06.2015, 11:33
You have problem in your query
1. You limited the row
2. You need to use where statement to filter the data
So you can't do this thing with that query
[ip] [name]
127.0.0.1 | Sasuke_Uchiha
127.0.0.1 | AroseKhanNiazi
81.111.111.222 | Random_user
81.122.222.222 | Sasuke_Uchiha
Here is some example syntax:
So every data on that table with same IP or same Name as that player will be loaded.
And for this error:
This error isn't from that code, it's from some script with "cache_get_field_content_int" syntax.
I hope you understand with this. And sorry about my english
Код:
mysql_format(g_SQL, mysqlquery, sizeof(mysqlquery), "SELECT ip,username FROM aka LIMIT 1");
2. You need to use where statement to filter the data
So you can't do this thing with that query
[ip] [name]
127.0.0.1 | Sasuke_Uchiha
127.0.0.1 | AroseKhanNiazi
81.111.111.222 | Random_user
81.122.222.222 | Sasuke_Uchiha
Here is some example syntax:
Код:
mysql_format(g_SQL, mysqlquery, sizeof(mysqlquery), "SELECT ip,username FROM aka WHERE username = '%e' OR ip = '%e'", PlayerInfo[playerid][pUserName], PlayerInfo[playerid][pIP]);
And for this error:
Код:
Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0); Log("15:29:02","cache_get_field_content_int",2,"no active cache",0);
I hope you understand with this. And sorry about my english