Try to create aka system with mysql
#3

You have problem in your query
Код:
mysql_format(g_SQL, mysqlquery, sizeof(mysqlquery), "SELECT ip,username FROM aka LIMIT 1");
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:
Код:
mysql_format(g_SQL, mysqlquery, sizeof(mysqlquery), "SELECT ip,username FROM aka WHERE username = '%e' OR ip = '%e'", PlayerInfo[playerid][pUserName], PlayerInfo[playerid][pIP]);
So every data on that table with same IP or same Name as that player will be loaded.

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);
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
Reply


Messages In This Thread
Try to create aka system with mysql - by AroseKhanNiazi - 26.06.2015, 10:47
Re: Try to create aka system with mysql - by mamorunl - 26.06.2015, 11:24
Re: Try to create aka system with mysql - by X337 - 26.06.2015, 11:33
Re: Try to create aka system with mysql - by AroseKhanNiazi - 26.06.2015, 12:20

Forum Jump:


Users browsing this thread: 1 Guest(s)