Get information for mysql
#22

Quote:
Originally Posted by JaTochNietDan
That's because pass is a variable, it needs to be a string.

Also I've taken the liberty of re-writing this for you in dcmd/sscanf, I think it's alot easier/cleaner.

pawn Код:
dcmd_login(playerid,params[])
{
  new password[20];
  if(sscanf(params,"s",password)) SendClientMessage(playerid,red,"Usage: /login <password>");
  else
  {
    new
        query[128],
        name[24];
    GetPlayerName(playerid,name,sizeof(name));
    mysql_escape_string(password,password);
    format(query,sizeof(query),"SELECT id FROM `players` WHERE Nombre = '%s' AND Password = '%s'",name,password);
    mysql_query(query);
    mysql_store_result();
    if(mysql_num_rows() > 0)
    {
      //And you can continue on here yourself ;)
You need dcmd and sscanf, which are popular functions all over the forums
much thanks but i dont know how to use that code u use dcmd_login i use if(cmdtext... :S
Reply


Messages In This Thread
Get information for mysql - by Zafire1410 - 23.08.2009, 20:56
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 21:00
Re: Get information for mysql - by MenaceX^ - 23.08.2009, 21:00
Re: Get information for mysql - by Joe Staff - 23.08.2009, 21:11
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 21:11
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 21:28
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 21:32
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 21:45
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 21:50
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 21:51
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 22:04
Re: Get information for mysql - by MenaceX^ - 23.08.2009, 22:04
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 22:12
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 22:13
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 22:15
Re: Get information for mysql - by MenaceX^ - 23.08.2009, 22:17
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 22:20
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 22:22
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 22:25
Re: Get information for mysql - by MenaceX^ - 23.08.2009, 22:26
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 22:30
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 22:34
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 22:36
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 22:46
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 22:53
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 23:01
Re: Get information for mysql - by JaTochNietDan - 23.08.2009, 23:03
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 23:08
Re: Get information for mysql - by MenaceX^ - 23.08.2009, 23:16
Re: Get information for mysql - by Zafire1410 - 23.08.2009, 23:18

Forum Jump:


Users browsing this thread: 1 Guest(s)