SQL -> Vehicle saving
#1

PHP код:
stock SaveCar(playerid)
{
    new 
tr playerCar1[playerid],
        
EngineLightsAlarmDoorsBonnetBootObjective;
    static 
Float:lastPosition[4], Float:bukles;
    
GetVehiclePos(trlastPosition[0], lastPosition[1], lastPosition[2]);
    
GetVehicleZAngle(trlastPosition[3]);
    
GetVehicleParamsEx (trEngineLightsAlarmDoorsBonnetBootObjective);
    
GetVehicleHealth(trbukles);
    if ( 
playerCar1 playerid ] != -)
    {
        
format(g_szBuffersizeof g_szBuffer
        
"UPDATE "MySQL_VEHICLE_TABLE" SET \
    \
            uzraktas = %i, \
            degalai = %f, \
            statusas = %i, \
            variklis = %i, \
            bukle = %f, \
            numeriai = %s, \
            rida = %f, \
            posX = %f, \
            posY = %f, \
            posZ = %f, \
            posA = %f, \
            technikine = %i, \
            techlaikas = %i \
    \
        WHERE savininkas = %s"
,
        
masinatr ][ lock ],
        
masinatr ][ Gas ],
        
masinatr ][ status ],
        
Engine,
        
bukles,
        
masinatr ][vehNumber],
        
masinatr ][ vehRida ],
        
lastPosition[0],
        
lastPosition[1],
        
lastPosition[2],
        
lastPosition[3],
        
masinatr ][ vehTech ],
        
masinatr ][ vehTechtime ],
        
getPlayerName(playerid));
        
sql_query(sqlg_szBufferQUERY_THREADED);
        
printf("%s transportas isaugotas ( %f , %f, %f, %f )"getPlayerName(playerid),lastPosition[0], lastPosition[1], lastPosition[2], lastPosition[3]);
    }
    
DestroyVehicle(tr);

printf:
PHP код:
[07:52:43Iam_Satan transportas isaugotas ( -2048.752929 307.54745440.62011349.947959 
SQL LOG
PHP код:
[21:24:36][debugNatives::sql_queryScheduling statement (stmt->id 16stmt->query UPDATE vehicles SET uzraktas 0degalai 40.000000statusas 0variklis 1bukle 789.740234numeriai NEREGISTRUOTArida 0.000000posX = -2276.572265posY 365.594726posZ 33.922851posA 229.472518technikine 0techlaikas 0 WHERE savininkas Iam_Satanstmt->callback = ) for execution...
[
21:24:36][debugSQL_Worker[1]: Executing query (stmt->id 16stmt->query UPDATE vehicles SET uzraktas 0degalai 40.000000statusas 0variklis 1bukle 789.740234numeriai NEREGISTRUOTArida 0.000000posX = -2276.572265posY 365.594726posZ 33.922851posA 229.472518technikine 0techlaikas 0 WHERE savininkas Iam_Satan)... 
But in dB nothing changes..:
Reply


Messages In This Thread
SQL -> Vehicle saving - by bogushas - 13.12.2014, 08:09
Re: SQL -> Vehicle saving - by bogushas - 13.12.2014, 10:41
Re: SQL -> Vehicle saving - by Vince - 13.12.2014, 10:55
Re: SQL -> Vehicle saving - by bogushas - 13.12.2014, 13:24
Re: SQL -> Vehicle saving - by bogushas - 13.12.2014, 13:56
Re: SQL -> Vehicle saving - by Kaperstone - 13.12.2014, 14:30
Re: SQL -> Vehicle saving - by PowerPC603 - 13.12.2014, 14:41
Re: SQL -> Vehicle saving - by bogushas - 13.12.2014, 15:26

Forum Jump:


Users browsing this thread: 1 Guest(s)