Problema salvare/incarcare KM

Extremys · May 6, 2016

Problema intalnita (descriere): Pai intru pe server cumpar masina si fac km, daca ies si intru iar km raman, dar daca ies dau restart la server km nu mai raman

Ero(area / rile) / warning-(ul / urile): Nu imi da
Liniile de cod / sursa / script-ul(obligatoriu): Ce imi veti cere aia o sa va dau

Imagini / Video (optional):-
Ati incercat sa rezolvati singur?: Da am incercat, nustiu ce sa fac sunt nou in mysql

Mister · May 6, 2016

Arata functia loadcar si arata si functia cum salvezi km cum ii contorizezi

Extremys · May 6, 2016

Acum 1 oră, Mister a spus:

Arata functia loadcar si arata si functia cum salvezi km cum ii contorizezi

Nu gasesc nici o functie care sa incarce masinile

Citat

forward DistanceCheck();
public DistanceCheck()
{
    for(new i=0; i<MAX_PLAYERS; i++)
    {
       new saveQuery[369];
       new Float:d;
        if(IsPlayerConnected(i))
        {
           if(GetPlayerState(i) == PLAYER_STATE_DRIVER)
           {
                new Float:dist, Float:X, Float:Y, Float:Z;
                if(IsPlayerInAnyVehicle(i))
                {
                    GetVehiclePos(GetPlayerVehicleID(i),X,Y,Z);
                }
                else
                {
                    GetPlayerPos(i,X,Y,Z);
                }
                dist = floatsqroot(floatpower(floatabs(floatsub(PosX,X)),2)+floatpower(floatabs(floatsub(PosY,Y)),2)+floatpower(floatabs(floatsub(PosZ,Z)),2));
                if(CheckDelay >= 1)
                {
                    CheckDelay--;
                }
                else
                {
                    if(floatround(dist) < 1000) Distance += floatround(dist);
                }
                GetPlayerPos(i,d,PosY,PosZ);
                GetPlayerPos(i,PosX,PosY,PosZ);
                new dist2;
                dist2 = Distance / 1000;
                if(dist2 >= 1)
                {
                    if(!IsPlayerPaused(i))
                      {
                       new vehicleid = GetPlayerVehicleID(i);
                       if(GetPlayerState(i) == PLAYER_STATE_DRIVER)
                       {
                           if(playerVariables[pCarID] == vehicleid)
                           {
                               Distance = 0;
                               playerVariables[pCarKM] += 1;
                               format(saveQuery, sizeof(saveQuery), "UPDATE playeraccounts SET playerCarKM = '%f', playerCarLock = '%d' WHERE playerID = '%d'",playerVariables[pCarKM],playerVariables[pCarLock],playerVariables[pInternalID]);
                               mysql_tquery(handle,saveQuery);
                           }
                           else if(playerVariables[pCarID2] == vehicleid)
                           {
                               Distance = 0;
                               playerVariables[pCarKM2] += 1;
                               format(saveQuery, sizeof(saveQuery), "UPDATE playeraccounts SET playerCarKM2 = '%f', playerCarLock2 = '%d' WHERE playerID = '%d'",playerVariables[pCarKM2],playerVariables[pCarLock2],playerVariables[pInternalID]);
                               mysql_tquery(handle,saveQuery);
                           }
                           else if(playerVariables[pCarID3] == vehicleid)
                           {
                               Distance = 0;
                               playerVariables[pCarKM3] += 1;
                               format(saveQuery, sizeof(saveQuery), "UPDATE playeraccounts SET playerCarKM3 = '%f', playerCarLock3 = '%d' WHERE playerID = '%d'",playerVariables[pCarKM3],playerVariables[pCarLock3],playerVariables[pInternalID]);
                               mysql_tquery(handle,saveQuery);
                           }
                           else if(playerVariables[pCarID4] == vehicleid)
                           {
                               Distance = 0;
                               playerVariables[pCarKM4] += 1;
                               format(saveQuery, sizeof(saveQuery), "UPDATE playeraccounts SET playerCarKM4 = '%f', playerCarLock4 = '%d' WHERE playerID = '%d'",playerVariables[pCarKM4],playerVariables[pCarLock4],playerVariables[pInternalID]);
                               mysql_tquery(handle,saveQuery);
                           }
                       }
                   }
                }
            }
        }
    }
}

@Mister asta am gasit despre vehicule

Citat

public IniVehs()
{
   new Cache: result5 = mysql_query (handle, "SELECT * FROM `vehicles` ORDER BY `vehicles`.`vehicleID` ASC");
   new x;
   new success = 1;

    for ( new i, j = cache_get_row_count ( ); i != j; ++i )
   {
       //cache_get_field_content(i, "vehicleID", result); x = strval(result);
         x++;
       if(systemVariables[vehicleCounts][0] + systemVariables[vehicleCounts][1] + systemVariables[vehicleCounts][2] < MAX_VEHICLES)
       {
           cache_get_field_content(i, "vehicleModelID", result); vehicleVariables[x][vVehicleModelID] = strval(result);
           cache_get_field_content(i, "vehiclePosX", result); vehicleVariables[x][vVehiclePosition][0] = floatstr(result);
           cache_get_field_content(i, "vehiclePosY", result); vehicleVariables[x][vVehiclePosition][1] = floatstr(result);
           cache_get_field_content(i, "vehiclePosZ", result); vehicleVariables[x][vVehiclePosition][2] = floatstr(result);
           cache_get_field_content(i, "vehiclePosRotation", result); vehicleVariables[x][vVehicleRotation] = floatstr(result);
           cache_get_field_content(i, "vehicleGroup", result); vehicleVariables[x][vVehicleGroup] = strval(result);
           cache_get_field_content(i, "vehicleDMV", result); vehicleVariables[x][vVehicleDMV] = strval(result);
           cache_get_field_content(i, "vehicleJob", result); vehicleVariables[x][vVehicleJob] = strval(result);
           cache_get_field_content(i, "vehicleRank", result); vehicleVariables[x][vVehicleRank] = strval(result);
           cache_get_field_content(i, "vehicleDS", result); vehicleVariables[x][vVehicleDS] = strval(result);
           cache_get_field_content(i, "vehicleCol1", result); vehicleVariables[x][vVehicleColour][0] = strval(result);
           cache_get_field_content(i, "vehicleCol2", result); vehicleVariables[x][vVehicleColour][1] = strval(result);

           if(vehicleVariables[x][vVehicleColour][0] < 0) {
               vehicleVariables[x][vVehicleColour][0] = random(126);
           }
           if(vehicleVariables[x][vVehicleColour][1] < 0) {
               vehicleVariables[x][vVehicleColour][1] = random(126);
           }

           vehicleVariables[x][vVehicleScriptID] = CreateVehicle(vehicleVariables[x][vVehicleModelID], vehicleVariables[x][vVehiclePosition][0], vehicleVariables[x][vVehiclePosition][1], vehicleVariables[x][vVehiclePosition][2], vehicleVariables[x][vVehicleRotation], vehicleVariables[x][vVehicleColour][0], vehicleVariables[x][vVehicleColour][1], -1);

           switch(vehicleVariables[x][vVehicleModelID])
           { // OnVehicleSpawn has some annoying glitches with this!1. Should fix.
               case 427, 428, 432, 601, 528: SetVehicleHealth(vehicleVariables[x][vVehicleScriptID], 5000.0);
           }
           systemVariables[vehicleCounts][0]++;

           new stringcar[256];
           format(stringcar, 256, "%s",groupVariables[vehicleVariables[x][vVehicleGroup]][gGroupName]);
           if(vehicleVariables[x][vVehicleGroup] >= 1)
           {
               SetVehicleNumberPlate(x, stringcar);
           }

           format(stringcar, 256, "%s",jobVariables[vehicleVariables[x][vVehicleJob]][jJobName]);
           if(vehicleVariables[x][vVehicleJob] >= 1)
           {
               SetVehicleNumberPlate(x, stringcar);
           }

           if(vehicleVariables[x][vVehicleDMV] == 1)
           {
               dmv[x] = CreateObject(19309,0,0,0,0,0,0,100.0);
               SetObjectMaterialText(dmv[x], "DMV", 0, 50, "Times New Roman", 27, 1, COLOR_YELLOW, 0xFF000000, 1);
               AttachObjectToVehicle(dmv[x], x, 0.0, -0.5, 0.9, 0.0, 0.0, 0.0);
           }

           if((vehicleVariables[x][vVehicleGroup] == 1 || vehicleVariables[x][vVehicleGroup] == 10) && vehicleVariables[x][vVehicleModelID] == 411)
           {
               sirena[x] = CreateObject(19419, 0, 0, 0, 0, 0, 0, 0);
               AttachObjectToVehicle(sirena[x], x, 0.0, 0.0, 0.7, 0.0, 0.0, 0.0);
           }

           if(vehicleVariables[x][vVehicleGroup] == 7 && vehicleVariables[x][vVehicleModelID] == 560)
           {
               taxiobj[x] = CreateObject(19308, 0, 0, 0, 0, 0, 0, 0);
               AttachObjectToVehicle(taxiobj[x], x, 0.0, 0.0, 0.92, 0.0, 0.0, 0.0);
           }
       }
       else
       {
           success = 0;
           printf("ERROR: Vehicle limit reached (MODEL %d, VEHICLEID %d, MAXIMUM %d, TYPE STATIC) [01x08]", vehicleVariables[x][vVehicleModelID], x, MAX_VEHICLES);
       }
   }
   cache_delete(result5);
   if(success) printf("[script] %d vehicles loaded.", systemVariables[vehicleCounts][0]);
   return 1;
}

vehiculele personale se salveaza in tabelul cu conturi

Edited May 6, 2016 by Extremys

.Kr0niX[] · May 7, 2016

6 hours ago, Extremys said:

Nu gasesc nici o functie care sa incarce masinile

@Mister asta am gasit despre vehicule

vehiculele personale se salveaza in tabelul cu conturi

Daca e gm Bladex iti spun clar abandoneaza edit-ul ai prea mult de munca pe el si nu se merita.

Si aici i lipseste o functie care sa salveze in baza de date Km ca Hurdrock = n00b a uitat sa salveze Km am avut un Notepad cu rezolvarea o sa il caut si revin cu edit daca gasesc.

Extremys · May 7, 2016

Nu este gm bladex cand l-am luat prima data de la un prieten scrie ceva cu DRPORT GAMEMODE si atat, dar in caz ca gasesti notepad-ul poti sa mi-l arati

Sinner.PWN · May 7, 2016

GM praf oricum, faci un query la fiecare modificare de distanta la masini?...

Extremys · May 7, 2016

Acum 35 minute, SoNNy.sys a spus:

GM praf oricum, faci un query la fiecare modificare de distanta la masini?...

Citat

forward DistanceCheck();
public DistanceCheck()
{
    for(new i=0; i<MAX_PLAYERS; i++)
    {
       new saveQuery[369];
       new Float:d;
        if(IsPlayerConnected(i))
        {
           if(GetPlayerState(i) == PLAYER_STATE_DRIVER)
           {
                new Float:dist, Float:X, Float:Y, Float:Z;
                if(IsPlayerInAnyVehicle(i))
                {
                    GetVehiclePos(GetPlayerVehicleID(i),X,Y,Z);
                }
                else
                {
                    GetPlayerPos(i,X,Y,Z);
                }
                dist = floatsqroot(floatpower(floatabs(floatsub(PosX,X)),2)+floatpower(floatabs(floatsub(PosY,Y)),2)+floatpower(floatabs(floatsub(PosZ,Z)),2));
                if(CheckDelay >= 1)
                {
                    CheckDelay--;
                }
                else
                {
                    if(floatround(dist) < 1000) Distance += floatround(dist);
                }
                GetPlayerPos(i,d,PosY,PosZ);
                GetPlayerPos(i,PosX,PosY,PosZ);
                new dist2;
                dist2 = Distance / 1000;
                if(dist2 >= 1)
                {
                    if(!IsPlayerPaused(i))
                      {
                       new vehicleid = GetPlayerVehicleID(i);
                       if(GetPlayerState(i) == PLAYER_STATE_DRIVER)
                       {
                           if(playerVariables[pCarID] == vehicleid)
                           {
                               Distance = 0;
                               playerVariables[pCarKM] += 1;
                               format(saveQuery, sizeof(saveQuery), "UPDATE playeraccounts SET playerCarKM = '%f', playerCarLock = '%d' WHERE playerID = '%d'",playerVariables[pCarKM],playerVariables[pCarLock],playerVariables[pInternalID]);
                               mysql_tquery(handle,saveQuery);
                           }
                           else if(playerVariables[pCarID2] == vehicleid)
                           {
                               Distance = 0;
                               playerVariables[pCarKM2] += 1;
                               format(saveQuery, sizeof(saveQuery), "UPDATE playeraccounts SET playerCarKM2 = '%f', playerCarLock2 = '%d' WHERE playerID = '%d'",playerVariables[pCarKM2],playerVariables[pCarLock2],playerVariables[pInternalID]);
                               mysql_tquery(handle,saveQuery);
                           }
                           else if(playerVariables[pCarID3] == vehicleid)
                           {
                               Distance = 0;
                               playerVariables[pCarKM3] += 1;
                               format(saveQuery, sizeof(saveQuery), "UPDATE playeraccounts SET playerCarKM3 = '%f', playerCarLock3 = '%d' WHERE playerID = '%d'",playerVariables[pCarKM3],playerVariables[pCarLock3],playerVariables[pInternalID]);
                               mysql_tquery(handle,saveQuery);
                           }
                           else if(playerVariables[pCarID4] == vehicleid)
                           {
                               Distance = 0;
                               playerVariables[pCarKM4] += 1;
                               format(saveQuery, sizeof(saveQuery), "UPDATE playeraccounts SET playerCarKM4 = '%f', playerCarLock4 = '%d' WHERE playerID = '%d'",playerVariables[pCarKM4],playerVariables[pCarLock4],playerVariables[pInternalID]);
                               mysql_tquery(handle,saveQuery);
                           }
                       }
                   }
                }
            }
        }
    }
}

Sinner.PWN · May 7, 2016

@Extremys de ce m-ai citat?...

Extremys · May 7, 2016

@SoNNy.sys mai intrebat daca fac un queri la fiecare modificare de distanta iar eu tiam dat funcita sa vezi

Sinner.PWN · May 7, 2016

Era doar o concluzie, o intrebare ironica. Nu te mai chinui cu script-uri de ca*** Nu poti sa-ti faci server si sa folosesti un query la fiecare 2 secunde pentru fiecare masina personala de pe server.

Extremys · May 7, 2016

Acum 5 minute, SoNNy.sys a spus:

Era doar o concluzie, o intrebare ironica. Nu te mai chinui cu script-uri de ca*** Nu poti sa-ti faci server si sa folosesti un query la fiecare 2 secunde pentru fiecare masina personala de pe server.

Nu vreau sa imi fac server, vreau sa invat sa creez unu in viitor pe alt gamemode intelegi?

DreiVian · May 7, 2016

nu stiu daca e corect, dar nu e mai simplu sa stochezi intr-o variabila cati km face si sa faca update doar cand masina este distrusa si primeste spawn ?:) ?

Extremys · May 8, 2016

Am rezolvat cer T/C

EquiNoxAdv · May 8, 2016

Topic Closed.

Sign In

Problema salvare/incarcare KM

Question

Extremys

13 answers to this question

Recommended Posts

Mister

Extremys

.Kr0niX[]

Extremys

Sinner.PWN

Extremys

Sinner.PWN

Extremys

Sinner.PWN

Extremys

DreiVian

Extremys

EquiNoxAdv

Similar Content

Actualizare textdraw (speedometer) la secunda (problema)

Problema /vehicles

Problema billboards (la expirarea billboard-ului nu seteaza variabila Billboard 0 jucatorului offline)

Problema clan members: Nu afiseaza membrii.

Problema dialog dealership (nu afiseaza ID-ul masinii)

Recently Browsing 0 members

Browse

Activity

Important Information