Reg/Log mysql bug

Započeo #bokenzi, Jun 04, 2020, 11:00:39 PRE PODNE

prethodna tema - sledeća tema

0 članova i 1 gost pregledaju ovu temu.

Štampaj
Idi dole Stranice1
Korisničke akcije

#bokenzi

*

Jun 04, 2020, 11:00:39 PRE PODNE
Problem(error/warning): Kad se ja registrujem na server, fino mi se zapise u databazu lozinka, spol drzava itd... Dok se drugi igrac registruje na server a ja sam u tom trenu aktivan, sve podatke koje on unese (lozinka, drzava, spol, godine...) se upise u moju tablicu pod mojim podacima, dok se njemu sve postavi na 0. Kada se ja disconectujem, meni se vrate moji zapisani registrovani podaci, dok drugom igracu je i dalje sve na 0. Postavit cu vam cijeli log/reg sistem, errora u mysql log nema, ukoliko vam nesto zatreba jos da provjerite, napisite mi :)
Dio skripte:[pawn]
public OnGameModeInit() {
   new MySQLOpt: option_id = mysql_init_options();
   mysql_set_option(option_id, AUTO_RECONNECT, true);
   Database = mysql_connect(mysql_host, mysql_user, mysql_pass, mysql_database, option_id);
   if(Database == MYSQL_INVALID_HANDLE || mysql_errno(Database) != 0) {
      print("Connecting to MySQL database failed");
      SendRconCommand("exit");
      return (false);
   }
        return (true);
}

public OnGameModeExit() {
   foreach(new i: Player) {
      Corrupt_Check++;
      SavePlayer(i);
      if(cache_is_valid(PlayerInfo[Player_Cache])) {
         cache_delete(PlayerInfo[Player_Cache]);
         PlayerInfo[Player_Cache] = MYSQL_INVALID_CACHE;
      }
   }
   mysql_close(Database);
}

public OnPlayerConnect(playerid) {
   //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   CreatePlayerTextDraws(playerid);
   //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   new DB_Query[115];
   GetPlayerName(playerid, PlayerInfo[playerid][Name], MAX_PLAYER_NAME);
   Corrupt_Check[playerid]++;
   mysql_format(Database, DB_Query, sizeof(DB_Query), "SELECT * FROM `users` WHERE `username` = '%e' LIMIT 1", PlayerInfo[playerid][Name]);
   mysql_tquery(Database, DB_Query, "OnPlayerDataCheck", "ii", playerid, Corrupt_Check[playerid]);
   //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   return (true);
}

forward OnPlayerDataCheck(playerid, corrupt_check);
public OnPlayerDataCheck(playerid, corrupt_check) {
   if (corrupt_check != Corrupt_Check[playerid]) return Kick(playerid);
   new rows;
   cache_get_row_count(rows);
   if(rows > 0) {
      new String[512];
      cache_get_value(0, "Password", PlayerInfo[playerid][Password], 65);
      PlayerInfo[playerid][Player_Cache] = cache_save();
      InterpolateCameraPos(playerid, 1294.575073, -1863.813354, 18.763757, 1384.041992, -885.596618, 71.000038, 30000);
      InterpolateCameraLookAt(playerid, 1294.750732, -1858.821411, 18.541175, 1385.695800, -880.888000, 71.305839, 30000);
      ClearChat(playerid);
      format(String, sizeof(String), ""server_col"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n"server_col"--> "white"Dobrodosao "server_col"%s "white"na "server_col"Worldwide Community\n\
        "server_col"--> "white"Vas racun je pronadjen u bazi podataka, molimo vas prijavite se\n\
        "server_col"--> "white"Imate 30 sekundi da se prijavite na server\n"server_col"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~", PlayerInfo[playerid][Name]);
      spd(playerid, d_log, dsp, ""wwhp"Prijava na server", String, "Prijava", "Izlaz");
      LogKick[playerid] = SetTimerEx("LogKickTimer", 30000, false, "i", playerid);
   }
   else {
      TogglePlayerSpectating(playerid, true);
      InterpolateCameraPos(playerid, 1294.575073, -1863.813354, 18.763757, 1384.041992, -885.596618, 71.000038, 30000);
      InterpolateCameraLookAt(playerid, 1294.750732, -1858.821411, 18.541175, 1385.695800, -880.888000, 71.305839, 30000);
      for(new i=0; i<13; i++) {
         ptds(playerid, RegisterTD[playerid]);
         SelectTextDraw(playerid, 0x1783E2FF);
      }
      ptdh(playerid, RegisterTD[playerid][7]);
      OnRegister[playerid] = 1;
      ClearChat(playerid);
   }
   return (true);
}

public OnPlayerDisconnect(playerid, reason) {
   foreach(new i: Player) {
      Corrupt_Check++;
      SavePlayer(i);
      if(cache_is_valid(PlayerInfo[Player_Cache])) {
         cache_delete(PlayerInfo[Player_Cache]);
         PlayerInfo[Player_Cache] = MYSQL_INVALID_CACHE;
      }
       }

}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[]) {
   switch (dialogid) {
      case d_log: {
         if(!response) return Kick(playerid);
         else {
            new account_pass[65];
            SHA256_PassHash(inputtext, GetName(playerid), account_pass, 65);
            if(strcmp(account_pass, PlayerInfo[playerid][Password]) == 0) {
               cache_set_active(PlayerInfo[playerid][Player_Cache]);
                  cache_get_value_int(0, "ID", PlayerInfo[playerid][ID]);
                 cache_get_value_int(0, "Kills", PlayerInfo[playerid][Kills]);
                 cache_get_value_int(0, "Deaths", PlayerInfo[playerid][Deaths]);
                 cache_get_value_int(0, "Score", PlayerInfo[playerid][Score]);
                 cache_get_value_int(0, "Cash", PlayerInfo[playerid][Cash]);
                 cache_get_value_int(0, "Admin", PlayerInfo[playerid][Admin]);
                 cache_get_value_int(0, "Country", PlayerInfo[playerid][Country]);
                 cache_get_value_int(0, "Age", PlayerInfo[playerid][Ages]);
                 cache_get_value_int(0, "Sex", PlayerInfo[playerid][Sex]);
                 cache_get_value_int(0, "AdminCode", PlayerInfo[playerid][AdminCode]);
                 SetPlayerScore(playerid, PlayerInfo[playerid][Score]);   
                 ResetPlayerMoney(playerid);
                 GivePlayerMoney(playerid, PlayerInfo[playerid][Cash]);            
               cache_delete(PlayerInfo[playerid][Player_Cache]);
               PlayerInfo[playerid][Player_Cache] = MYSQL_INVALID_CACHE;
               LoggedIn[playerid] = 1;
               CreatePlayer(playerid);
               KillTimer(LogKick[playerid]);
            }
            else {
                new String[512];
               PlayerInfo[playerid][PasswordFails] += 1;
               if (PlayerInfo[playerid][PasswordFails] >= 3) {
                  Kick(playerid);
               }
               else {
                  format(String, sizeof(String), ""error"Pogresna lozinka, imate jos %d od 3 pokusaja", PlayerInfo[playerid][PasswordFails]);
                  scm(playerid, -1, String);
                       format(String, sizeof(String), ""server_col"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n"server_col"--> "white"Dobrodosao "server_col"%s "white"na "server_col"Worldwide Community\n\
                       "server_col"--> "white"Vas racun je pronadjen u bazi podataka, molimo vas prijavite se\n"server_col"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~", PlayerInfo[playerid][Name]);
                     spd(playerid, d_log, dsp, ""wwhp"Prijava na server", String, "Prijava", "Izlaz");
               }
            }
         }
      }
      case d_pass: {
         if(!response) return (false);
         else{
            strmid(RegPass[playerid], inputtext, 0, strlen(inputtext), 65);
         }   
      }
      case d_country: {
         if(!response) return (false);
         else {
            switch(listitem) {
               case 0: {
                  RegCountry[playerid] = 1;
               }
               case 1: {
                  RegCountry[playerid] = 2;
               }
               case 2: {
                  RegCountry[playerid] = 3;
               }
               case 3: {
                  RegCountry[playerid] = 4;
               }
               case 4: {
                  RegCountry[playerid] = 5;
               }
               case 5: {
                  RegCountry[playerid] = 6;
               }
               case 6: {
                  RegCountry[playerid] = 7;
               }
               case 7: {
                  RegCountry[playerid] = 8;
               }
            }
         }
      }
      case d_ages: {
         if(!response) return (false);
         else {
            if(strval(inputtext) < 8 || strval(inputtext) > 50) {
               scm(playerid, -1, ""error"Ne mozete unijeti godine manje od 8 i vece od 50");
               spd(playerid, d_ages, dsi, ""wwhp"Unos godina",""server_col"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n"server_col"--> "white"Sada vas molimo da unesete koliko imate godina u prazan dijalog\n\
               "server_col"--> "white"Ne mozete ici manje od 8 i vise od 50 godina\n"server_col"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~","Unos","Prekid");
               return (false);
            }
            RegAges[playerid] = strval(inputtext);
         }
      }
      case d_sex: {
         if(!response) {
            RegSex[playerid] = 2;
         }
         else {
            RegSex[playerid] = 1;
         }
      }
        }
}

stock SavePlayer(playerid) {
   new DB_Query[256];
   mysql_format(Database, DB_Query, sizeof(DB_Query), "UPDATE `users` SET `Score` = %d, `Cash` = %d, `Kills` = %d, `Deaths` = %d, `Admin` = %d, `Country` = %d, `Age` = %d, `Sex` = %d, \
   `Tutorial` = %d, `AdminCode` = %d WHERE `ID` = %d LIMIT 1",
   PlayerInfo[playerid][Score], PlayerInfo[playerid][Cash], PlayerInfo[playerid][Kills], PlayerInfo[playerid][Deaths], PlayerInfo[playerid][Admin],PlayerInfo[playerid][Country],\
   PlayerInfo[playerid][Ages],PlayerInfo[playerid][Sex], PlayerInfo[playerid][Tutorial], PlayerInfo[playerid][AdminCode], PlayerInfo[playerid][ID]);
   mysql_tquery(Database, DB_Query);
   return (true);
}
[/pawn]
Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log): //
Slika/video ingame problema(obavezno ako je ingame problem): //
Poslednja Izmena: Jun 05, 2020, 16:04:37 POSLE PODNE od daddy.

musoviich

*

#1
Jun 04, 2020, 11:09:45 PRE PODNE
https://pastebin.com/9zLjXyhY

De prvo probaj sa onako default, kada uzmes od nekog, pa ga onda pokusaj editovat, moguce da si nesto izmjenio sto nisi trebao :P

#bokenzi

*

#2
Jun 04, 2020, 11:11:09 PRE PODNE
Citat: musoviich poslato Jun 04, 2020, 11:09:45 PRE PODNE
https://pastebin.com/9zLjXyhY

De prvo probaj sa onako default, kada uzmes od nekog, pa ga onda pokusaj editovat, moguce da si nesto izmjenio sto nisi trebao :P
Po default fino sve radi, ali mi nikako nije jasno sta sam ovdje zeznio kad sam dodao pun vrag stvari u reg sistem

musoviich

*

#3
Jun 04, 2020, 11:16:08 PRE PODNE
Citat: #bokenzi poslato Jun 04, 2020, 11:00:39 PRE PODNE
Problem(error/warning): Kad se ja registrujem na server, fino mi se zapise u databazu lozinka, spol drzava itd... Dok se drugi igrac registruje na server a ja sam u tom trenu aktivan, sve podatke koje on unese (lozinka, drzava, spol, godine...) se upise u moju tablicu pod mojim podacima, dok se njemu sve postavi na 0. Kada se ja disconectujem, meni se vrate moji zapisani registrovani podaci, dok drugom igracu je i dalje sve na 0. Postavit cu vam cijeli log/reg sistem, errora u mysql log nema, ukoliko vam nesto zatreba jos da provjerite, napisite mi :)
Dio skripte:[pawn]
public OnGameModeInit() {
   new MySQLOpt: option_id = mysql_init_options();
   mysql_set_option(option_id, AUTO_RECONNECT, true);
   Database = mysql_connect(mysql_host, mysql_user, mysql_pass, mysql_database, option_id);
   if(Database == MYSQL_INVALID_HANDLE || mysql_errno(Database) != 0) {
      print("Connecting to MySQL database failed");
      SendRconCommand("exit");
      return (false);
   }
        return (true);
}

public OnGameModeExit() {
   foreach(new i: Player) {
      Corrupt_Check++;
      SavePlayer(i);
      if(cache_is_valid(PlayerInfo[Player_Cache])) {
         cache_delete(PlayerInfo[Player_Cache]);
         PlayerInfo[Player_Cache] = MYSQL_INVALID_CACHE;
      }
   }
   mysql_close(Database);
}

public OnPlayerConnect(playerid) {
   //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   CreatePlayerTextDraws(playerid);
   //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   new DB_Query[115];
   GetPlayerName(playerid, PlayerInfo[playerid][Name], MAX_PLAYER_NAME);
   Corrupt_Check[playerid]++;
   mysql_format(Database, DB_Query, sizeof(DB_Query), "SELECT * FROM `users` WHERE `username` = '%e' LIMIT 1", PlayerInfo[playerid][Name]);
   mysql_tquery(Database, DB_Query, "OnPlayerDataCheck", "ii", playerid, Corrupt_Check[playerid]);
   //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
   return (true);
}

forward OnPlayerDataCheck(playerid, corrupt_check);
public OnPlayerDataCheck(playerid, corrupt_check) {
   if (corrupt_check != Corrupt_Check[playerid]) return Kick(playerid);
   new rows;
   cache_get_row_count(rows);
   if(rows > 0) {
      new String[512];
      cache_get_value(0, "Password", PlayerInfo[playerid][Password], 65);
      PlayerInfo[playerid][Player_Cache] = cache_save();
      InterpolateCameraPos(playerid, 1294.575073, -1863.813354, 18.763757, 1384.041992, -885.596618, 71.000038, 30000);
      InterpolateCameraLookAt(playerid, 1294.750732, -1858.821411, 18.541175, 1385.695800, -880.888000, 71.305839, 30000);
      ClearChat(playerid);
      format(String, sizeof(String), ""server_col"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n"server_col"--> "white"Dobrodosao "server_col"%s "white"na "server_col"Worldwide Community\n\
        "server_col"--> "white"Vas racun je pronadjen u bazi podataka, molimo vas prijavite se\n\
        "server_col"--> "white"Imate 30 sekundi da se prijavite na server\n"server_col"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~", PlayerInfo[playerid][Name]);
      spd(playerid, d_log, dsp, ""wwhp"Prijava na server", String, "Prijava", "Izlaz");
      LogKick[playerid] = SetTimerEx("LogKickTimer", 30000, false, "i", playerid);
   }
   else {
      TogglePlayerSpectating(playerid, true);
      InterpolateCameraPos(playerid, 1294.575073, -1863.813354, 18.763757, 1384.041992, -885.596618, 71.000038, 30000);
      InterpolateCameraLookAt(playerid, 1294.750732, -1858.821411, 18.541175, 1385.695800, -880.888000, 71.305839, 30000);
      for(new i=0; i<13; i++) {
         ptds(playerid, RegisterTD[playerid]);
         SelectTextDraw(playerid, 0x1783E2FF);
      }
      ptdh(playerid, RegisterTD[playerid][7]);
      OnRegister[playerid] = 1;
      ClearChat(playerid);
   }
   return (true);
}

public OnPlayerDisconnect(playerid, reason) {
   foreach(new i: Player) {
      Corrupt_Check++;
      SavePlayer(i);
      if(cache_is_valid(PlayerInfo[Player_Cache])) {
         cache_delete(PlayerInfo[Player_Cache]);
         PlayerInfo[Player_Cache] = MYSQL_INVALID_CACHE;
      }
       }

}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[]) {
   switch (dialogid) {
      case d_log: {
         if(!response) return Kick(playerid);
         else {
            new account_pass[65];
            SHA256_PassHash(inputtext, GetName(playerid), account_pass, 65);
            if(strcmp(account_pass, PlayerInfo[playerid][Password]) == 0) {
               cache_set_active(PlayerInfo[playerid][Player_Cache]);
                  cache_get_value_int(0, "ID", PlayerInfo[playerid][ID]);
                 cache_get_value_int(0, "Kills", PlayerInfo[playerid][Kills]);
                 cache_get_value_int(0, "Deaths", PlayerInfo[playerid][Deaths]);
                 cache_get_value_int(0, "Score", PlayerInfo[playerid][Score]);
                 cache_get_value_int(0, "Cash", PlayerInfo[playerid][Cash]);
                 cache_get_value_int(0, "Admin", PlayerInfo[playerid][Admin]);
                 cache_get_value_int(0, "Country", PlayerInfo[playerid][Country]);
                 cache_get_value_int(0, "Age", PlayerInfo[playerid][Ages]);
                 cache_get_value_int(0, "Sex", PlayerInfo[playerid][Sex]);
                 cache_get_value_int(0, "AdminCode", PlayerInfo[playerid][AdminCode]);
                 SetPlayerScore(playerid, PlayerInfo[playerid][Score]);   
                 ResetPlayerMoney(playerid);
                 GivePlayerMoney(playerid, PlayerInfo[playerid][Cash]);            
               cache_delete(PlayerInfo[playerid][Player_Cache]);
               PlayerInfo[playerid][Player_Cache] = MYSQL_INVALID_CACHE;
               LoggedIn[playerid] = 1;
               CreatePlayer(playerid);
               KillTimer(LogKick[playerid]);
            }
            else {
                new String[512];
               PlayerInfo[playerid][PasswordFails] += 1;
               if (PlayerInfo[playerid][PasswordFails] >= 3) {
                  Kick(playerid);
               }
               else {
                  format(String, sizeof(String), ""error"Pogresna lozinka, imate jos %d od 3 pokusaja", PlayerInfo[playerid][PasswordFails]);
                  scm(playerid, -1, String);
                       format(String, sizeof(String), ""server_col"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n"server_col"--> "white"Dobrodosao "server_col"%s "white"na "server_col"Worldwide Community\n\
                       "server_col"--> "white"Vas racun je pronadjen u bazi podataka, molimo vas prijavite se\n"server_col"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~", PlayerInfo[playerid][Name]);
                     spd(playerid, d_log, dsp, ""wwhp"Prijava na server", String, "Prijava", "Izlaz");
               }
            }
         }
      }
      case d_pass: {
         if(!response) return (false);
         else{
            strmid(RegPass[playerid], inputtext, 0, strlen(inputtext), 65);
         }   
      }
      case d_country: {
         if(!response) return (false);
         else {
            switch(listitem) {
               case 0: {
                  RegCountry[playerid] = 1;
               }
               case 1: {
                  RegCountry[playerid] = 2;
               }
               case 2: {
                  RegCountry[playerid] = 3;
               }
               case 3: {
                  RegCountry[playerid] = 4;
               }
               case 4: {
                  RegCountry[playerid] = 5;
               }
               case 5: {
                  RegCountry[playerid] = 6;
               }
               case 6: {
                  RegCountry[playerid] = 7;
               }
               case 7: {
                  RegCountry[playerid] = 8;
               }
            }
         }
      }
      case d_ages: {
         if(!response) return (false);
         else {
            if(strval(inputtext) < 8 || strval(inputtext) > 50) {
               scm(playerid, -1, ""error"Ne mozete unijeti godine manje od 8 i vece od 50");
               spd(playerid, d_ages, dsi, ""wwhp"Unos godina",""server_col"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n"server_col"--> "white"Sada vas molimo da unesete koliko imate godina u prazan dijalog\n\
               "server_col"--> "white"Ne mozete ici manje od 8 i vise od 50 godina\n"server_col"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~","Unos","Prekid");
               return (false);
            }
            RegAges[playerid] = strval(inputtext);
         }
      }
      case d_sex: {
         if(!response) {
            RegSex[playerid] = 2;
         }
         else {
            RegSex[playerid] = 1;
         }
      }
        }
}

stock SavePlayer(playerid) {
   new DB_Query[256];
   mysql_format(Database, DB_Query, sizeof(DB_Query), "UPDATE `users` SET `Score` = %d, `Cash` = %d, `Kills` = %d, `Deaths` = %d, `Admin` = %d, `Country` = %d, `Age` = %d, `Sex` = %d, \
   `Tutorial` = %d, `AdminCode` = %d WHERE `ID` = %d LIMIT 1",
   PlayerInfo[playerid][Score], PlayerInfo[playerid][Cash], PlayerInfo[playerid][Kills], PlayerInfo[playerid][Deaths], PlayerInfo[playerid][Admin],PlayerInfo[playerid][Country],\
   PlayerInfo[playerid][Ages],PlayerInfo[playerid][Sex], PlayerInfo[playerid][Tutorial], PlayerInfo[playerid][AdminCode], PlayerInfo[playerid][ID]);
   mysql_tquery(Database, DB_Query);
   return (true);
}
[/pawn]
Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log): //
Slika/video ingame problema(obavezno ako je ingame problem): //

pregledaj svoje

[pawn]
Corrupt_Check[playerid]++;

    new DB_Query[256];
    //Running a query to save the player's data using the stored stuff.
    mysql_format(Database, DB_Query, sizeof(DB_Query), "UPDATE `PLAYERS` SET `SCORE` = %d, `CASH` = %d, `KILLS` = %d, `DEATHS` = %d WHERE `ID` = %d LIMIT 1",
    pInfo[playerid][Score], pInfo[playerid][Cash], pInfo[playerid][Kills], pInfo[playerid][Deaths], pInfo[playerid][ID]);

    mysql_tquery(Database, DB_Query);

    if(cache_is_valid(pInfo[playerid][Player_Cache])) //Checking if the player's cache ID is valid.
    {
        cache_delete(pInfo[playerid][Player_Cache]); // Deleting the cache.
        pInfo[playerid][Player_Cache] = MYSQL_INVALID_CACHE; // Setting the stored player Cache as invalid.
    }

    pInfo[playerid][LoggedIn] = false;
    print("OnPlayerDisconnect has been called."); // Sending message once OnPlayerDisconnect is called.
    return 1;[/pawn]
Ovo sam ja izvukao iz default-nog OnPlayerDisconnect, pogledaj tu jel ti sta fali :)

#bokenzi

*

#4
Jun 04, 2020, 11:20:54 PRE PODNE
Citat: musoviich poslato Jun 04, 2020, 11:16:08 PRE PODNE
pregledaj svoje

[pawn]
Corrupt_Check[playerid]++;

    new DB_Query[256];
    //Running a query to save the player's data using the stored stuff.
    mysql_format(Database, DB_Query, sizeof(DB_Query), "UPDATE `PLAYERS` SET `SCORE` = %d, `CASH` = %d, `KILLS` = %d, `DEATHS` = %d WHERE `ID` = %d LIMIT 1",
    pInfo[playerid][Score], pInfo[playerid][Cash], pInfo[playerid][Kills], pInfo[playerid][Deaths], pInfo[playerid][ID]);

    mysql_tquery(Database, DB_Query);

    if(cache_is_valid(pInfo[playerid][Player_Cache])) //Checking if the player's cache ID is valid.
    {
        cache_delete(pInfo[playerid][Player_Cache]); // Deleting the cache.
        pInfo[playerid][Player_Cache] = MYSQL_INVALID_CACHE; // Setting the stored player Cache as invalid.
    }

    pInfo[playerid][LoggedIn] = false;
    print("OnPlayerDisconnect has been called."); // Sending message once OnPlayerDisconnect is called.
    return 1;[/pawn]
Ovo sam ja izvukao iz default-nog OnPlayerDisconnect, pogledaj tu jel ti sta fali :)

Ne fali mi nista, ja sam samo skratio, umjesto dugog procesa sam sve spremio u SavePlayer, obriso nebitan printf i to je to :)

musoviich

*

#5
Jun 04, 2020, 11:27:09 PRE PODNE
Citat: #bokenzi poslato Jun 04, 2020, 11:20:54 PRE PODNE
Ne fali mi nista, ja sam samo skratio, umjesto dugog procesa sam sve spremio u SavePlayer, obriso nebitan printf i to je to :)

SavePlayer proces ti je uredu, pri registraciji korisnika negdje imas greksu.
Ukoliko pronadjem javim ti :)

Darkic

*

#6
Jun 04, 2020, 11:35:18 PRE PODNE
Čemu foreach pod OnPlayerDisconnect?

musoviich

*

#7
Jun 04, 2020, 11:49:44 PRE PODNE
Citat: Darkic poslato Jun 04, 2020, 11:35:18 PRE PODNE
Čemu foreach pod OnPlayerDisconnect?

Auu, to nisam ni vidio, vjerovatno tako misli kupit id igrača...

#bokenzi

*

#8
Jun 04, 2020, 11:59:34 PRE PODNE
Citat: Darkic poslato Jun 04, 2020, 11:35:18 PRE PODNE
Čemu foreach pod OnPlayerDisconnect?
Ne killaju mi se timeri, nekad se ne spremaju neki podaci, zato stavim pod foreach

#bokenzi

*

#9
Jun 04, 2020, 12:05:50 POSLE PODNE
Fixano, problem je u ID, svi igraci imaju ID 0 u bazi podataka sve se promjesa, lockam
Štampaj
Idi gore Stranice1
Korisničke akcije