MySQL retrieving Data, G-Styleeez Plugin.
#2

pawn Код:
if(mysql_num_rows() != 0)
    {
      new pName1[MAX_PLAYER_NAME];
      GetPlayerName(playerid,pName1,sizeof(pName1));
      format(query,sizeof(query),"SELECT * FROM `/*tablename*/` WHERE Username = '%s' LIMIT 1", pName1);
        mysql_query(query);
        mysql_store_result();

        new resultline[512],player[X][32];
        mysql_fetch_field_row(resultline,"|");
        split(resultline, player, '|');

        PlayerInfo[playerid][Money] = strval(player[0]);
        PlayerInfo[playerid][Admin] = strval(player[1]);

        //other variables

        mysql_free_result();
        LoggedIn[playerid] = true;
        SendClientMessage(playerid,NOTICE,"     You are now logged in!");
        return 1;
    }
Of course if you are selecting everything (*) it will load everything, so if first thing in the table is not money, you cannot use 'strval(player[0]) for money, but something higher (actual money field) like 'strval(player[5])'.
Reply


Messages In This Thread
MySQL retrieving Data, G-Styleeez Plugin. - by NeRoSiS - 25.09.2009, 17:11
Re: MySQL retrieving Data, G-Styleeez Plugin. - by Sergei - 25.09.2009, 17:29
Re: MySQL retrieving Data, G-Styleeez Plugin. - by NeRoSiS - 25.09.2009, 17:36
Re: MySQL retrieving Data, G-Styleeez Plugin. - by Sergei - 25.09.2009, 17:45
Re: MySQL retrieving Data, G-Styleeez Plugin. - by NeRoSiS - 25.09.2009, 17:57
Re: MySQL retrieving Data, G-Styleeez Plugin. - by Sergei - 25.09.2009, 18:07

Forum Jump:


Users browsing this thread: 1 Guest(s)