price

[:P]

Is it Possible to set Vehicle price from cmds If yes then how

[KAKAN]

Yes, make a cmd and update the Price using a Query or an array.
Ex:-

Code Select Expand

QuerySQL(db,"UPDATE Vehicles SET Price='" + text + "' WHERE Vehicle ='" + player.Vehicle + "'" )

[:P]

this is but not works cost does not exists i try with price but dont work   

Code Select Expand

else if ( cmd == "setcarprice" )
    {
if ( IsNoob( player, cmd ) ) return 0;
          else if ( !text ) MessagePlayer("Error, [Syntax] setcarprice <car id> <newprice>", player ); 
        {
                local id = GetTok( text, " ", 1 ), newcost = GetTok ( text, " ", 2);
                if ( !IsNum( id ) ) MessagePlayer("Error, [Syntax] invalid car id", player );
                else
                {
                                       if ( !IsNum( newcost ) ) MessagePlayer("Error, [Syntax] the number must be in numbers", player );
                                       else
                                       {
                                                id = id.tointeger();
                                                newcost = newcost.tointeger();
                                                local setnewcost = format( "UPDATE cars SET Price=%i WHERE carID=" + id, newcost );
                                                if ( carcost( id ) == 0 )
                                                {
                                                        ::QuerySQL( DB, "REPLACE INTO cars (carID) VALUES (" + id + ")" );
                                                } 
                                                EMessage( "** Price Changed - car ID: " + id + " - Name: " + Findcar( id ) + " - New cost: $" + Bytes( newcost ) );
                                                QuerySQL( DB, setnewcost );
                                        }
                }     
        }
    }

[KAKAN]

See the table in your database file.

[:P]

in the table is cost

[KAKAN]

WTH is this?
if ( carcost( id ) == 0 )

[MacTavish]

Post an screenshot of your cars table where is your car cost

[:P]

[:P]

AND PLEASE FIX MY CMDS SOON

[MacTavish]

Here it is

Code Select Expand

else if ( cmd == "setcarprice" )
   {
   try {
        if ( IsNoob( player, cmd ) ) return 0;     
else if ( !text ) MessagePlayer("Syntax - /setcarprice <Vehicle ID> <Cost>", player );
        else
        {
                local id = GetTok( text, " ", 1 ), newprice = GetTok( text, " ", 2 );
                if ( !IsNum( id ) ) MessagePlayer("Error - Invalid vehicle ID.", player );
                else
                {
                                       if ( !IsNum( newprice ) ) MessagePlayer("Error - The price should be in number.", player );
                                       else
                                       {
                                                id = id.tointeger();
                                                newprice = newprice.tointeger();
                                                local setnewprice = format( "UPDATE Cars SET Cost=%i WHERE ID=" + id, newprice );
                                                MessagePlayer("Done -You have changed the price of vehicle Id ( " + id + " ) New price: $" + newprice + "", player );
                                                QuerySQL( db, setnewprice );
                                        }
                }
}
}
catch(e) print( "Setcarprice " + e );
}
ENJOY

[:P]

which cmds i post how is its good my first time try to make
And thanx For cmds