1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help
  4. Help Archive

Threaded Mode
need some help with a MySQL Connection
TheChaoz
High-roller
*****
Posts: 4,649
Threads: 64
Joined: Dec 2009
Reputation: 0
#1

06.03.2010, 03:27
hi, i'm making a MySQL connection, and I get a problem, when i enter the server it crash.
it stats happening then i put this on the callback OnPlayerConnect
pawn Код:
new playername[MAX_PLAYER_NAME], query[128];
    GetPlayerName(playerid, playername, sizeof(playername));
    format(query, sizeof(query), "SELECT UserName FROM 'usuarios' WHERE 'UserName' = '%s'", playername);
  ConexionMySQL();
  mysql_real_escape_string(playername, playername);
    mysql_query(query);
    mysql_store_result();
    if(mysql_num_rows() == 1){
        PlayerInfo[playerid][Registered] = 1;
    }
    else{
        PlayerInfo[playerid][Registered] = 0;
    }
    mysql_store_result();
there are no errors/warning when i compile the .pwn

and the log sed:
Код:
[01:11:32] Incoming connection: 127.1.1.1:2092
[01:11:32] [join] The_Chaoz has joined the server (0:127.1.1.1)
[01:11:32] MySQL Error (0): Could not execute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''usuarios' WHERE 'UserName' = 'The_Chaoz'' at line 1.
[01:11:32] MySQL Error (0): Could not store result. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''usuarios' WHERE 'UserName' = 'The_Chaoz'' at line 1.
Can someone tell me what i'm doing wrong

PD: Sorry for my bad english
Find
Reply
Miguel
High-roller
*****
Posts: 1,571
Threads: 49
Joined: Dec 2009
Reputation: 0
#2

06.03.2010, 04:06
pawn Код:
new playername[MAX_PLAYER_NAME], query[128];
GetPlayerName(playerid, playername, sizeof(playername)); 
mysql_real_escape(playername, playername);
format(query, sizeof(query), "SELECT * FROM `usuarios` WHERE UserName = '%s'", playername); 
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() == 1) PlayerInfo[playerid][Registered] = 1;
else PlayerInfo[playerid][Registered] = 0;
mysql_free_result();
That's how you should do it.
Find
Reply
TheChaoz
High-roller
*****
Posts: 4,649
Threads: 64
Joined: Dec 2009
Reputation: 0
#3

06.03.2010, 04:20
server keep crashing.
pawn code:
pawn Код:
new playername[MAX_PLAYER_NAME], query[128];
GetPlayerName(playerid, playername, sizeof(playername));
format(query, sizeof(query), "SELECT * FROM `usuarios` WHERE UserName = '%s'", playername);
ConexionMySQL();
mysql_real_escape_string(playername, playername);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() == 1){
  PlayerInfo[playerid][Registered] = 1;
}
else{
  PlayerInfo[playerid][Registered] = 0;
}
mysql_store_result();
log:
Код:
[02:11:25] Incoming connection: 127.1.1.1:2509
[02:11:25] [join] The_Chaoz has joined the server (0:127.1.1.1)
[02:11:25] MySQL Error (0): 'mysql_store_result' called when result already stored. Please use 'mysql_free_result' first..
[02:11:25] MySQL Error (0): Could not execute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''usuarios' WHERE UserName=The_Chaoz' at line 1.
any ideas?
Find
Reply
Miguel
High-roller
*****
Posts: 1,571
Threads: 49
Joined: Dec 2009
Reputation: 0
#4

06.03.2010, 04:25
Quote:
Originally Posted by SAWC™
pawn Код:
new playername[MAX_PLAYER_NAME], query[128];
GetPlayerName(playerid, playername, sizeof(playername)); 
mysql_real_escape(playername, playername); // cleaning player's name
format(query, sizeof(query), "SELECT * FROM `usuarios` WHERE UserName = '%s'", playername); // format query
mysql_query(query); // query
mysql_store_result(); // store results
if(mysql_num_rows() == 1) PlayerInfo[playerid][Registered] = 1; // check results
else PlayerInfo[playerid][Registered] = 0;
mysql_free_result(); // clean memory
That's how you should do it.
Find
Reply
TheChaoz
High-roller
*****
Posts: 4,649
Threads: 64
Joined: Dec 2009
Reputation: 0
#5

06.03.2010, 04:26
Quote:
Originally Posted by SAWC™
Quote:
Originally Posted by SAWC™
pawn Код:
new playername[MAX_PLAYER_NAME], query[128];
GetPlayerName(playerid, playername, sizeof(playername)); 
mysql_real_escape(playername, playername);
format(query, sizeof(query), "SELECT * FROM `usuarios` WHERE UserName = '%s'", playername); 
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() == 1) PlayerInfo[playerid][Registered] = 1;
else PlayerInfo[playerid][Registered] = 0;
mysql_free_result();
That's how you should do it.
Код:
error 017: undefined symbol "mysql_real_escape"
Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


1 Error.
Find
Reply
Miguel
High-roller
*****
Posts: 1,571
Threads: 49
Joined: Dec 2009
Reputation: 0
#6

06.03.2010, 04:28
Sorry, it was mysql_real_escape_string(input, output):
pawn Код:
mysql_real_escape_string(playername, playername);
Find
Reply
TheChaoz
High-roller
*****
Posts: 4,649
Threads: 64
Joined: Dec 2009
Reputation: 0
#7

06.03.2010, 04:34
the server still crash.

pawn code:
pawn Код:
new playername[MAX_PLAYER_NAME], query[128];
GetPlayerName(playerid, playername, sizeof(playername));
mysql_real_escape_string(playername, playername);
format(query, sizeof(query), "SELECT * FROM `usuarios` WHERE UserName = '%s'", playername);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() == 1) PlayerInfo[playerid][Registered] = 1;
else PlayerInfo[playerid][Registered] = 0;
mysql_free_result();
log:
Код:
[02:26:02] Incoming connection: 127.1.1.1:2616
[02:26:02] [join] The_Chaoz has joined the server (0:127.1.1.1)
[02:26:02] MySQL Error (0): Could not execute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''usuarios' WHERE UserName=The_Chaoz' at line 1.
Find
Reply
Miguel
High-roller
*****
Posts: 1,571
Threads: 49
Joined: Dec 2009
Reputation: 0
#8

06.03.2010, 04:43
This is how I do it:
pawn Код:
stock CheckAccount(playerid)
{
  MySQLCheck();

  new
    query[70];

  format(query, sizeof(query), "SELECT * FROM `players` WHERE Nickname = '%s'", Player[playerid][Name]);
  mysql_query(query);
  mysql_store_result();
  if(mysql_num_rows() > 0) Player[playerid][Registered] = 1;
  else Player[playerid][Registered] = 0;
  mysql_free_result();
}
pawn Код:
public OnPlayerConnect(playerid)
{
  ...
  CheckAccount(playerid);
  if(Player[playerid][Registered] == 1) BlaBlaBla;
  else BlaBlaBla2;
  return 1;
}
Find
Reply
TheChaoz
High-roller
*****
Posts: 4,649
Threads: 64
Joined: Dec 2009
Reputation: 0
#9

06.03.2010, 04:57
don't know what i'm doing wrong

pawn code:
pawn Код:
public OnPlayerConnect(playerid)
{
  CheckAccount(playerid);
  //code....
  return 1;
}
pawn Код:
stock ConexionMySQL()
{
  if(mysql_ping() == 0)
  {
    return true;
  }
  else
  {
    mysql_reload();
    ConexionMySQL();
  }
  return false;
}

//----------------------------------------------------------------------------------
stock CheckAccount(playerid)
{
  ConexionMySQL();

  new query[70], playername[MAX_PLAYER_NAME];
  GetPlayerName(playerid, playername, sizeof(playername));
  format(query, sizeof(query), "SELECT * FROM `usuarios` WHERE UserName = '%s'", playername);
  mysql_query(query);
  mysql_store_result();
  if(mysql_num_rows() > 0) PlayerInfo[playerid][Registered] = 1;
  else PlayerInfo[playerid][Registered] = 0;
  mysql_free_result();
}
log:
Код:
[02:46:04] Incoming connection: 127.1.1.1:2841
[02:46:04] [join] The_Chaoz has joined the server (0:127.1.1.1)
[02:46:04] MySQL Error (0): Could not execute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''usuarios' WHERE UserName=The_Chaoz' at line 1.
Find
Reply
Miguel
High-roller
*****
Posts: 1,571
Threads: 49
Joined: Dec 2009
Reputation: 0
#10

06.03.2010, 05:05
Change ConexionMySQL() for:
pawn Код:
ChequearMySQL()
{
  if(mysql_ping() == -1) mysql_connect(SQL_HOST, SQL_USER,SQL_DB, SQL_PASS); // remember to define those
  return 1;
}
And by the way, what mysql plugin are you using?
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 8 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help
  4. Help Archive