SA-MP Forums

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

Reply
 
Thread Tools Display Modes
Old 12/02/2018, 01:40 PM   #1
enzulikeS
Big Clucker
 
Join Date: Jan 2018
Posts: 139
Reputation: 0
Default Dealership problem

When I edit a car price from MYSQL database or /dsprice (like Infernus price) up to 80.000.000$, it dissapear from the /buycar dialog.

What I need to modify for this problem? If I edit the prices up to 80kk, cars are dissapearing from the buy menu.
Tell me what to post here.
enzulikeS is offline   Reply With Quote
Old 12/02/2018, 02:06 PM   #2
Gforcez1337
High-roller
 
Gforcez1337's Avatar
 
Join Date: Jul 2010
Location: The Netherlands.
Posts: 1,102
Reputation: 367
Default Re: Dealership problem

Show us your code. We can't see what's wrong without the code.
__________________

Gforcez1337 is offline   Reply With Quote
Old 12/02/2018, 02:42 PM   #3
PepsiCola23
Gangsta
 
Join Date: May 2015
Posts: 676
Reputation: 3
Default Re: Dealership problem

show us the dialog and also the /dsprice command
PepsiCola23 is offline   Reply With Quote
Old 12/02/2018, 03:09 PM   #4
Mugala
Gangsta
 
Mugala's Avatar
 
Join Date: Nov 2012
Location: behind u
Posts: 646
Reputation: 30
Default Re: Dealership problem

also provide the database structure for this cars.
__________________
here to help
Mugala is offline   Reply With Quote
Old 12/02/2018, 03:19 PM   #5
enzulikeS
Big Clucker
 
Join Date: Jan 2018
Posts: 139
Reputation: 0
Default Re: Dealership problem

https://pastebin.com/i7W7z4tk - dialogs
https://pastebin.com/Y34mLVHg - dsprice
enzulikeS is offline   Reply With Quote
Old 12/02/2018, 03:26 PM   #6
Mugala
Gangsta
 
Mugala's Avatar
 
Join Date: Nov 2012
Location: behind u
Posts: 646
Reputation: 30
Default Re: Dealership problem

also show us /buycar dialog (command)
__________________
here to help
Mugala is offline   Reply With Quote
Old 12/02/2018, 03:29 PM   #7
PepsiCola23
Gangsta
 
Join Date: May 2015
Posts: 676
Reputation: 3
Default Re: Dealership problem

PHP Code:
mysql_format(SQLstringsizeof(string), "UPDATE `stock` SET `Price`='%d',`Stock`='%d' WHERE `vid`='%d'",price,stocks,model);
            
mysql_tquery(SQLstring""""); 
i dont get what you wanna do here?
PepsiCola23 is offline   Reply With Quote
Old 12/02/2018, 03:31 PM   #8
enzulikeS
Big Clucker
 
Join Date: Jan 2018
Posts: 139
Reputation: 0
Default Re: Dealership problem

Quote:
Originally Posted by PepsiCola23 View Post
PHP Code:
mysql_format(SQLstringsizeof(string), "UPDATE `stock` SET `Price`='%d',`Stock`='%d' WHERE `vid`='%d'",price,stocks,model);
            
mysql_tquery(SQLstring""""); 
i dont get what you wanna do here?
when i use /dsprice it updates the respective table of the stock from dealership in mysql

https://pastebin.com/qE58ArZM
enzulikeS is offline   Reply With Quote
Old 12/02/2018, 04:14 PM   #9
PepsiCola23
Gangsta
 
Join Date: May 2015
Posts: 676
Reputation: 3
Default Re: Dealership problem

i dont get it,you have a separate table for stock and a separate table for cars?why didnt you add a column to dscars table with "stock" ?
PepsiCola23 is offline   Reply With Quote
Old 12/02/2018, 06:25 PM   #10
enzulikeS
Big Clucker
 
Join Date: Jan 2018
Posts: 139
Reputation: 0
Default Re: Dealership problem

yes, i have 2 different tabels for cars and stock

i didn't added stock to cars bcuz i wanted something arranged ok

(sorry bad english)

any fixes?
enzulikeS is offline   Reply With Quote
Reply

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] Dealership Problem D0WN3D Scripting Help 10 10/12/2015 04:52 PM
DealerShip Problem Adnosius Scripting Help 2 25/07/2015 10:07 PM
Dealership Problem VladNo97 Scripting Help 4 08/08/2014 12:05 PM
Dealership problem Lunixx Scripting Help 2 22/10/2013 06:05 PM
[REP+] If anyone help me to fix DealerShip problem. zika Scripting Help 0 07/04/2013 10:26 AM


All times are GMT. The time now is 05:00 AM.


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