function not working

[kokia]

Code Select Expand

function GetVehicleCount( player )
{
QuerySQL( db, "SELECT Vehicles FROM CountVehicle WHERE Name='" + player.Name + "'")
}
this is function and error is on line 43 of functions and    QuerySQL( db, "SELECT Vehicles FROM CountVehicle WHERE Name='" + player.Name + "'")
 is line 43 error is wrong number of parameters

[kokia]

plz help

[Mashreq]

You are trying to return the vehicles in your table countvehicles?
If yes try using this one:

Code Select Expand

function GetVehicleCount( player )
{
 local q = QuerySQL( db, "SELECT Vehicles FROM CountVehicle WHERE Name='" + player.Name + "'" )
 return GetSQLColumnData( q, 0 );
}


[Thijn]

Always free your result:

Code Select Expand

function GetVehicleCount( player )
{
 local q = QuerySQL( db, "SELECT Vehicles FROM CountVehicle WHERE Name='" + player.Name + "'" )
 local count = GetSQLColumnData( q, 0 );
 FreeSQLQuery( q );
 return count;
}


[kokia]

Always free your result:

Code Select Expand

function GetVehicleCount( player )
{
 local q = QuerySQL( db, "SELECT Vehicles FROM CountVehicle WHERE Name='" + player.Name + "'" )
 local count = GetSQLColumnData( q, 0 );
 FreeSQLQuery( q );
 return count;
}


You are trying to return the vehicles in your table countvehicles?
If yes try using this one:

Code Select Expand

function GetVehicleCount( player )
{
 local q = QuerySQL( db, "SELECT Vehicles FROM CountVehicle WHERE Name='" + player.Name + "'" )
 return GetSQLColumnData( q, 0 );
}


You are trying to return the vehicles in your table countvehicles?
If yes try using this one:

Code Select Expand

function GetVehicleCount( player )
{
 local q = QuerySQL( db, "SELECT Vehicles FROM CountVehicle WHERE Name='" + player.Name + "'" )
 return GetSQLColumnData( q, 0 );
}


@Mashreq
@Thijn
the code is not working still error is wrong number of parameters

[MacTavish]

Why using SQLite query when you can count vehice by GetVehicleCount()

Example

Code Select Expand

onScriptLoad
{
print("Counted Vehicles: "+GetVehicleCount());
}
I noticed that you using GetVehicleCount to get something from db since its an squirrel function, to avoid that error

Change your GetVehicleCount to just VehicleCount
 Do

Code Select Expand

function VehicleCount( player )
{
 local q = QuerySQL( db, "SELECT Vehicles FROM CountVehicle WHERE Name='" + player.Name + "'" )
 local count = GetSQLColumnData( q, 0 );
 FreeSQLQuery( q );
 return count;
}