[enzulikeS]

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.

[Gforcez]

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

[PepsiCola23]

show us the dialog and also the /dsprice command

[Mugala]

also provide the database structure for this cars.

[enzulikeS]

https://pastebin.com/i7W7z4tk - dialogs
https://pastebin.com/Y34mLVHg - dsprice

[Mugala]

also show us /buycar dialog (command)

[PepsiCola23]

PHP код:

mysql_format(SQL, string, sizeof(string), "UPDATE `stock` SET `Price`='%d',`Stock`='%d' WHERE `vid`='%d'",price,stocks,model);
            mysql_tquery(SQL, string, "", ""); 


i dont get what you wanna do here?

[enzulikeS]

Quote:

Originally Posted by PepsiCola23 PHP код: mysql_format(SQL, string, sizeof(string), "UPDATE `stock` SET `Price`='%d',`Stock`='%d' WHERE `vid`='%d'",price,stocks,model);             mysql_tquery(SQL, string, "", "");  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

[PepsiCola23]

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" ?

[enzulikeS]

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?