Converting this to mysql
#7

I have tried it and it's still not working like it's suppose to.

pawn Код:
if (CMySQL_Exists1(plname))
    {
       
       
        CMySQL_Get(plname, "Vehicle1", PlayerInfo[playerid][pVeh1]);
        printf("Vehicle One %s",PlayerInfo[playerid][pVeh1]);
        CMySQL_Get(plname, "Vehicle2", PlayerInfo[playerid][pVeh2]);
        printf("Vehicle Two %s",PlayerInfo[playerid][pVeh2]);
        CMySQL_Get(plname, "Vehicle3", PlayerInfo[playerid][pVeh3]);
        printf("Vehicle Three %s",PlayerInfo[playerid][pVeh3]);
        CMySQL_Get(plname, "Vehicle4", PlayerInfo[playerid][pVeh4]);
        printf("Vehicle Four %s",PlayerInfo[playerid][pVeh4]);
        CMySQL_Get(plname, "Vehicle5", PlayerInfo[playerid][pVeh5]);
        printf("Vehicle Five %s",PlayerInfo[playerid][pVeh5]);

       
    }
    else
    {
       
        format(sql, sizeof(sql), "UPDATE players SET Vehicle1='None',Vehicle2='None',Vehicle3='None',Vehicle4='None',Vehicle5='None' WHERE Username='%s'", plname);
        mysql_query(sql);
        printf("%s",sql);
       
    {
The cmysql_exist is the only way i could think of a way to tell if the user has a car. If i add a query like Select Vehicle1 and shit like that, It dosen't do my account info right.
Reply


Messages In This Thread
Converting this to mysql - by ihatetn931 - 24.09.2010, 14:05
Re: Converting this to mysql - by Cameltoe - 24.09.2010, 14:30
Re: Converting this to mysql - by ihatetn931 - 24.09.2010, 14:32
Re: Converting this to mysql - by ihatetn931 - 28.09.2010, 13:05
Re: Converting this to mysql - by ihatetn931 - 29.09.2010, 12:56
Re: Converting this to mysql - by Cameltoe - 29.09.2010, 14:08
Re: Converting this to mysql - by ihatetn931 - 29.09.2010, 15:10
Re: Converting this to mysql - by Cameltoe - 29.09.2010, 15:39
Re: Converting this to mysql - by ihatetn931 - 29.09.2010, 22:05
Re: Converting this to mysql - by Cameltoe - 29.09.2010, 23:42

Forum Jump:


Users browsing this thread: 1 Guest(s)