mysql help - Printable Version

mysql help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql help (/showthread.php?tid=299547)

A very small mysql+vehicle problem - fubar - 26.11.2011

ok i am using Dynamic Vehicle Ownership by [L3th4l],i have been working on this one command,but cant quite get it to work properly,since i have never used mysql before so bear with me

Well here is the problem i am trying to move a vehicle from where it was park by the owner to a postion from a diffrent database,ok this works ok apart from the vehicle angle,it always parks it what ever postion the person selling it is looking

so here is the code

Код:

CMD:sellveh(playerid, params[]){
    if(!IsPlayerInAnyVehicle(playerid)) return SendClientMessage(playerid, COLOR_RED, "You must be in a vehicle to use this command!");
    new ivID = GetPlayerVehicleID(playerid),Float:Pos[4],Query[300];
    format(Query, sizeof(Query), "SELECT vPosX,vPosY,vPosZ,vPosA FROM vehicle WHERE `vID` = %i LIMIT 1", ivID);
    mysql_query(Query);
    mysql_store_result();
    while(mysql_fetch_row(Query))
        sscanf(Query, "p<|>ffff",Pos[0], Pos[1], Pos[2], Pos[3]);
    if(OwnedVeh(ivID) != 0){
        if(strmatch(vInfo[OwnedVeh(ivID)][vOwner], pName(playerid))){
            vInfo[OwnedVeh(ivID)][vPrice] = vInfo[OwnedVeh(ivID)][vPrice];
            strmid(vInfo[OwnedVeh(ivID)][vOwner], "Unbought", 0, 20, 20);
            strmid(vInfo[OwnedVeh(ivID)][vPlate], "{WG}", 0, 32, 32);
            GivePlayerMoney(playerid, vInfo[OwnedVeh(ivID)][vPrice] - 100);//10000
            SendClientMessage(playerid, COLOR_GREY, "You've sold this vehicle and the money has been given back!");
            SetVehicleToRespawn(ivID);
            SetVehiclePos(ivID,Pos[0], Pos[1], Pos[2]);
            SetVehicleZAngle(ivID,Pos[3]);
            SetVehicleNumberPlate(ivID, "{WG}");
	        GetVehiclePos(ivID, Pos[0], Pos[1], Pos[2]);
	        GetVehicleZAngle(ivID, Pos[3]);
            vInfo[OwnedVeh(ivID)][vPosX] = Pos[0];
			vInfo[OwnedVeh(ivID)][vPosY] = Pos[1];
			vInfo[OwnedVeh(ivID)][vPosZ] = Pos[2];
			vInfo[OwnedVeh(ivID)][vPosA] = Pos[3];			
            SavePrivVeh(OwnedVeh(ivID));
            printf("vID:\t\t%i", ivID);printf("Spawn X:\t%f", Pos[0]);printf("Spawn y:\t%f", Pos[1]);printf("Spawn z:\t%f", Pos[2]);printf("Spawn a:\t%f", Pos[3]);
            mysql_free_result();
            return 1;}
        else return SendClientMessage(playerid, COLOR_RED, "This vehicle does not belong to you!");}
    else return SendClientMessage(playerid, COLOR_RED, "This vehicle is not ownable!");}

ok and here is the mysql debug

Код:

[19:56:24] CMySQLHandler::Query(SELECT vPosX,vPosY,vPosZ,vPosA FROM vehicle WHERE `vID` = 127 LIMIT 1) - Successfully executed.

[19:56:24] >> mysql_store_result( Connection handle: 1 )

[19:56:24] CMySQLHandler::StoreResult() - Result was stored.

[19:56:24] >> mysql_fetch_row_format( Connection handle: 1 )

[19:56:24] CMySQLHandler::FetchRow() - Return: 1944.37|1335.77|8.9094|178.764

178.764 is the correct angle,but it respawns it at this angle 90.808.
So can anyone help me out with what i have done wrong ?
Cheers in advance for any help

Re: mysql help - fubar - 27.11.2011

Can anyone help with this please

Re: mysql help - fubar - 29.11.2011

does anyone know the answer to this problem