Updating a mysql row - Printable Version

Updating a mysql row - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Updating a mysql row (/showthread.php?tid=192952)

Updating a mysql row - ihatetn931 - 24.11.2010

Well when you sell your car in my scirpt it sets your Vehicle to None, Well it's suppose to.

For some reason this query isn't working

pawn Код:

format(str,sizeof(str),"UPDATE playervehicles SET Vehicle1='None' WHERE CarOwner = '%s'"plname);
mysql_query(str);

Any reason why it's not updating the vehicle to "None" ?

Unless i'm missing somthing. It's not even giving out a print

pawn Код:

if(strmatch(str1, PlayerVehicle[playerid][pVeh1])){
                        DestroyVehicle(vehi);[color = green] // this is getting called [/color]
                        format(str,sizeof(str),"UPDATE playervehicles SET Vehicle1='None' WHERE CarOwner = '%s'"plname);
                        mysql_query(str);
                        printf("%s",str);
                        return 1;
                    }

Edit:

I got it working, Nevermind. Someone mind locking/delteing this topic?