Vice City: Multiplayer

Server Development => Scripting and Server Management => Topic started by: Mohamed Boubekri on Nov 21, 2017, 07:54 PM

Title: Guys Can Help Me For Cost :/
Post by: Mohamed Boubekri on Nov 21, 2017, 07:54 PM
Hello Guys How Are you All! :D I was finding How To Change The Cost Car i Have Made one Functions But Its Not Working

Note : I'm using Veh System @KrlozZ...

My Function ( I Added it For OnScriptLoad ).

QuerySQL( Vehicles, "UPDATE Price SET = '2500000' WHERE Model = '191' " );
I Added it But I'm Join The Game Not Say Me Anything :/
I Want To Set All Car infernus With 2500000$

My Table :
QuerySQL(Vehicles, "CREATE TABLE IF NOT EXISTS Creation ( id NUMERIC, model NUMERIC, x NUMERIC, y NUMERIC, z NUMERIC, col1 NUMERIC, col2 NUMERIC, world NUMERIC, angle NUMERIC)" );
QuerySQL(Vehicles, "CREATE TABLE IF NOT EXISTS Sale ( ID NUMERIC, Cost NUMERIC, Owner TEXT, Shared TEXT, Shared2 TEXT )" );
Title: Re: Guys Can Help Me For Cost :/
Post by: Xmair on Nov 22, 2017, 09:52 AM
QuerySQL( Vehicles, "UPDATE Sale SET Cost = 2500000 WHERE Model = 191" );
Title: Re: Guys Can Help Me For Cost :/
Post by: =RK=MarineForce on Nov 22, 2017, 02:05 PM
I Want Help Price

This is Database ? /QuerySQL( Vehicles, "UPDATE Price SET =  /This is Price OF Car ? // '2500000' WHERE Model = /This is ID Model OF CaR?/ '191' " );
Title: Re: Guys Can Help Me For Cost :/
Post by: Mohamed Boubekri on Nov 22, 2017, 02:37 PM
Quote from: Xmair on Nov 22, 2017, 09:52 AMQuerySQL( Vehicles, "UPDATE Sale SET Cost = 2500000 WHERE Model = 191" );
@Xmair Still Not Working. Can u Tell Me Any Command To setprice ?
Title: Re: Guys Can Help Me For Cost :/
Post by: D4rkR420R on Nov 22, 2017, 04:47 PM
Quote from: Mohamed on Nov 22, 2017, 02:37 PM
Quote from: Xmair on Nov 22, 2017, 09:52 AMQuerySQL( Vehicles, "UPDATE Sale SET Cost = 2500000 WHERE Model = 191" );
@Xmair Still Not Working. Can u Tell Me Any Command To setprice ?

What's the outcome of the error?
Title: Re: Guys Can Help Me For Cost :/
Post by: Mohamed Boubekri on Nov 22, 2017, 07:25 PM
Hm @KuRiMi Its Work No problem But, When Me join Sit For infernus Say Me Normal Cash

// Cost Not Changed :V
Title: Re: Guys Can Help Me For Cost :/
Post by: Xmair on Nov 23, 2017, 10:38 AM
Quote from: Mohamed on Nov 22, 2017, 07:25 PMHm @KuRiMi Its Work No problem But, When Me join Sit For infernus Say Me Normal Cash

// Cost Not Changed :V
QuerySQL( Vehicles, "UPDATE Sale SET Cost = 2500000 WHERE Model = 141" );Try now
Title: Re: Guys Can Help Me For Cost :/
Post by: Mohamed Boubekri on Nov 23, 2017, 12:39 PM
@Xmair Again Not Working :( Bro Can You Give Me Command /setprice Need it :/
Title: Re: Guys Can Help Me For Cost :/
Post by: Xmair on Nov 23, 2017, 01:56 PM
Quote from: Mohamed on Nov 23, 2017, 12:39 PM@Xmair Again Not Working :( Bro Can You Give Me Command /setprice Need it :/
I just downloaded KrloZz's vehicle system and took a look at it. Totally different from what I had thought so there's no hope of that working. Also it's coded in a shitty manner so not even gonna do anything to that. I'd suggest you to make your own system. Or just do something like this...
function getVehiclePrice( modelID )
{
switch( modelID ){
case 141:
{
return 900000;
}
break;

case 142:
{
return 300000;
}
break;
};
};
and do the required checks on your buycar command
Title: Re: Guys Can Help Me For Cost :/
Post by: umar4911 on Nov 23, 2017, 03:15 PM
Did you connect your server with database? Check that once too
Title: Re: Guys Can Help Me For Cost :/
Post by: Mohamed Boubekri on Nov 23, 2017, 06:29 PM
Quote from: umar4911 on Nov 23, 2017, 03:15 PMDid you connect your server with database? Check that once too
Yas I Already Connnect See My table.
Title: Re: Guys Can Help Me For Cost :/
Post by: umar4911 on Nov 24, 2017, 08:42 AM
Quote from: Mohamed on Nov 23, 2017, 06:29 PM
Quote from: umar4911 on Nov 23, 2017, 03:15 PMDid you connect your server with database? Check that once too
Yas I Already Connnect See My table.
First, The ID of infernus is 141 not 191. If not working, try making a function and add it onscriptload