MySQL Problem
#1

I got this issue, that it doesn't work.

It should give the user the 100 dollars, but it doesn't... And yeah, it's when he is offline...

Can anybody tell me why it doesn't work?

pawn Код:
mysql_format(sqlHandle, buffer, sizeof(buffer), "SELECT FROM `samp_users` GET `bank` WHERE `user` = 'Orson_Lynch'");
                           
                            new int_dest = cache_get_row_int(0, 0);
                           
                            int_dest += 100;
                           
                            mysql_format(sqlHandle, buffer, sizeof(buffer), "UPDATE samp_users SET bank = %i WHERE user = 'Orson_Lynch'", int_dest);
                           

                            mysql_format(sqlHandle, buffer, sizeof(buffer), "INSERT INTO `samp_adverts` (`advert`, `owner`) VALUES ('%e', '%e')", inputtext, PlayerInfo[playerid][pName]);
                            mysql_function_query(sqlHandle, buffer, false, "", "");
Reply


Messages In This Thread
MySQL Problem - by EmilLykke - 03.10.2014, 13:55
Re: MySQL Problem - by EmilLykke - 03.10.2014, 14:29
Re: MySQL Problem - by Vince - 03.10.2014, 15:21

Forum Jump:


Users browsing this thread: 2 Guest(s)