[Pomoc]MySQL

Mod:MojMod od 0
Problem:Koristim MySQL system spremanja podataka i napravio sam da mi sprema admin i GM level,on ga spremi ali na loginu ga ne ucita,kad izađem i pogledam preko phpMyAdmin pise da imam admin level a kad odem u igru ne ucita i onda kad izađem opet admin level bude 0
Dio Skripte: public OnPlayerConnect(playerid)
{
    new Query, Pname, escpname; //Creates the Query string and the Pname
    GetPlayerName(playerid, Pname, 24); //Gets the players name
    mysql_real_escape_string(Pname, escpname); //escapes the string so you cant MySQL inject
    format(Query, sizeof(Query), "SELECT * FROM `playerinfo` WHERE `user` = '%s'", escpname); //Selects the line where the playername is the player
    mysql_query(Query); //Querys the string
    mysql_store_result(); //Stores the result
    if(mysql_num_rows() != 0) //If the user is found
    {
        new PIP; //Creates the IP string
        GetPlayerIp(playerid, PIP, 56); //Gets the players IP
        format(Query, sizeof(Query), "SELECT * FROM `playerinfo` WHERE `user` = '%s' AND `IP` = '%s'", escpname, PIP); //Checks if the players IP is the same, if so it will auto login 🙂
        mysql_query(Query); //Queries the result
        mysql_store_result(); //Stores the result
        if(mysql_num_rows() != 0) // If the players IP is the same in the DB
        {
            new line;
            SetPVarInt(playerid, "Logged", 1); //Sets the logged variable to 1
            SendClientMessage(playerid, 0x009600AA, "Auto Logged in!");
            if(mysql_fetch_row(line)) //Fetches the line
            {
                  new data; //The data strings
                  new data2; //The data variables
                  sscanf(line, "p|ssdddds", data, data, data2, data2, data2, data2, data, data2, data2); //Splits the line with sscanf
                  SetPVarInt(playerid, "Kills", data2); //Sets Pvar ints
                  SetPVarInt(playerid, "Logged", 1); //Sets Pvar ints
                  SetPVarInt(playerid, "Deaths", data2); //Sets Pvar ints
                  SetPlayerScore(playerid, data2); //Sets players score
                  GivePlayerMoney(playerid, data2); //Sets players cash
                  SetPVarInt(playerid, "Admin", data2);
                  SetPVarInt(playerid, "GameMaster", data2);
                  mysql_free_result();
              }
        }
        if(!mysql_num_rows())
        {
            SendClientMessage(playerid, 0x009600AA, "This account is registered, please login"); //User is registered but IP does not match
            ShowPlayerDialog(playerid, 15000, DIALOG_STYLE_INPUT , "Login", "This account is registered, please login", "OK", "Cancel");
        }
    }
    else
    {
        ShowPlayerDialog(playerid, 14600, DIALOG_STYLE_INPUT , "Register", "This account is not registered, please register!", "OK", "Cancel");
        SendClientMessage(playerid, 0x009600AA, "This account is not registered, please register!"); // User is not registed
    }
    mysql_free_result(); //Frees the result 🙂
    return 1;
}

if(dialogid == 15000)
    {
      if(response)
      {
          new Query, Pname;
          GetPlayerName(playerid, Pname, 24);
          new escpname;
          mysql_real_escape_string(Pname, escpname);
          format(Query, sizeof(Query), "SELECT * FROM `playerinfo` WHERE `user` = '%s' AND `password` = '%s'", escpname, inputtext);
          mysql_query(Query);
          mysql_store_result();
          if(!mysql_num_rows())
          {
              SendClientMessage(playerid, 0xF60000AA, "Invalid password!");
              SetPVarInt(playerid, "WrongPass", GetPVarInt(playerid, "WrongPass") + 1);
              ShowPlayerDialog(playerid, 15000, DIALOG_STYLE_INPUT , "Login", "This account is registered, please login", "OK", "Cancel");
              if(GetPVarInt(playerid, "WrongPass") == 3)
              {
                  SendClientMessage(playerid, 0xF60000AA, "Max password tries exceeded!!");
                  Kick(playerid);
              }
          }
          else
          {
              new line; //I know it's big D=
              if(mysql_fetch_row(line)) //Fetches the line
              {
                  new data; //The data strings
                  new data2; //The data variables
                  sscanf(line, "p|ssdddds", data, data, data2, data2, data2, data2, data, data2, data2); //Splits the line with sscanf
                  SetPVarInt(playerid, "Kills", data2); //Sets Pvar ints
                  SetPVarInt(playerid, "Logged", 1); //Sets Pvar ints
                  SetPVarInt(playerid, "Deaths", data2); //Sets Pvar ints
                  SetPlayerScore(playerid, data2); //Sets players score
                  SetPVarInt(playerid, "MoneyGiven", data2); //Sets players cash
                  SetPVarInt(playerid, "Admin", data2); //Sets Pvar ints
                  SetPVarInt(playerid, "GameMaster", data2); //Sets Pvar ints
                  SendClientMessage(playerid, 0x0000D9AA, "Prijavljen!");
                  mysql_free_result();
              }
          }
      }
    }
    return 1;
}

Uvijek fulis vrstu varijable, procitaj malo sscanf2 dokumentaciju...

http://forum.sa-mp.com/showthread.php?t=120356

i

http://wiki.sa-mp.com/wiki/Scripting_Basics#Variables

prije nego sto pocnes raditi sa necim kao sto je mysql...

Kako sam fulo varijablu kad je je to broj ko i ono drugo pa sam isto napravio jer je isto broj ko ono do

gledaj, ti kod sebe ovdje nemas SetPVarString... a deklarisao si u sscanf-u da uzima string:

sscanf(line, "p|ssdddds", data, data, data2, data2, data2, data2, data, data2, data2); //Splits the line with sscanf  
                  SetPVarInt(playerid, "Kills", data2); //Sets Pvar ints  
                  SetPVarInt(playerid, "Logged", 1); //Sets Pvar ints  
                  SetPVarInt(playerid, "Deaths", data2); //Sets Pvar ints  
                  SetPlayerScore(playerid, data2); //Sets players score  
                  GivePlayerMoney(playerid, data2); //Sets players cash  
                  SetPVarInt(playerid, "Admin", data2);  
                  SetPVarInt(playerid, "GameMaster", data2);  

rekao sam ti procitaj prvo, nesto ces nauciti i skontati, ovako samo u prazno ides, nista neces nauciti...

Sta trebam koristit GetValue?

gledaj kako to ide:

sscanf(line, "p|ssdddds", data, data, data2, data2, data2, data2, data, data2, data2); //Ovo cita liniju pomocu sscanf-a, a pritom svaku vrijednost dijeli sa pregradom |, medutim ako je sscanf2 potrebno je koristiti p<|>, ovo je oznaka za delimiter...
// ti si trebao ovo ovako definisati:

sscanf(line, "p<|>dddddd", data2, data2, data2, data2, data2, data2);

                  SetPVarInt(playerid, "Kills", data2); //Sets Pvar ints  
                  SetPVarInt(playerid, "Logged", 1); //Sets Pvar ints  
                  SetPVarInt(playerid, "Deaths", data2); //Sets Pvar ints  
                  SetPlayerScore(playerid, data2); //Sets players score  
                  GivePlayerMoney(playerid, data2); //Sets players cash  
                  SetPVarInt(playerid, "Admin", data2);  
                  SetPVarInt(playerid, "GameMaster", data2); 

Ovo si pogrijesio... i kakav crni GetValue :S

EM|Pacino wrote on July 4, 2011, 5:44 pm:

Ovo si pogrijesio... i kakav crni GetValue :S

Ma nesto sam guglao xD

Ali prije nisu bile <|> i radilo je ovo drugo kad nije bio adminlevel i gmlevel

koja ti je verzija sscanf-a?

1.0,sad stavio 2.0 plugin i include,compilo,restarto i opet neradi

lol nije do plugina, rekao sam ti do cega je... problem je u tvom kodu, tj. ne dajes kako treba definicije varijabli...

Sad mi je ovako i opet neradi

new line; //I know it's big D=
              if(mysql_fetch_row(line)) //Fetches the line
              {
                  //new data; //The data strings
                  new data2; //The data variables
                  sscanf(line, "p<|>dddddd", data2, data2, data2, data2, data2, data2);
                  SetPVarInt(playerid, "Kills", data2); //Sets Pvar ints
                  SetPVarInt(playerid, "Logged", 1); //Sets Pvar ints
                  SetPVarInt(playerid, "Deaths", data2); //Sets Pvar ints
                  SetPlayerScore(playerid, data2); //Sets players score
                  GivePlayerMoney(playerid, data2); //Sets players cash
                  SetPVarInt(playerid, "Admin", data2);
                  SetPVarInt(playerid, "GameMaster", data2);
                  SendClientMessage(playerid, 0x0000D9AA, "Prijavljen!");
                  mysql_free_result();

cita li kako treba? ili ne sprema kako treba?

Ne cita kako treba a sprema kako treba,ali samo admin lvl a gm lvl nisam isprobo dal cita,a pass cita uredu ali admin lvl ne