SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help > Help Archive

 
 
Thread Tools Display Modes
Old 24/11/2010, 11:53 AM   #1
ihatetn931
Gangsta
 
Join Date: Apr 2008
Posts: 600
Reputation: 8
Default Updating a mysql row

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 Code:
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 Code:
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?

Last edited by ihatetn931; 24/11/2010 at 12:25 PM.
ihatetn931 is offline  
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL account updating does'nt work, help please! Auxxx Help Archive 15 25/10/2010 12:55 PM
Updating Car [Mysql] Cameltoe Help Archive 10 14/08/2010 09:56 PM
When it comes to updating... Jesant13 General 2 13/08/2010 02:39 AM
MySQL error when updating stats Ozz Help Archive 7 16/03/2010 04:22 PM


All times are GMT. The time now is 10:22 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.