API tools faq
paste
Advertisement
Guest User

Hilfe

a guest
Dec 16th, 2012
67
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 29.69 KB | None | 0 0
raw download clone embed print report
  1. // DAS ist noch nicht fertig ABER es müsste gehen ....
  2.  
  3. //=======[MySQL-Daten]=======
  4. #define SQL_HOST   "127.0.0.1"
  5. #define SQL_USER   "root"
  6. #define SQL_PASS   ""
  7. #define SQL_DATA   "samp"
  8. //===========================
  9. //=========[Dialoge]=========
  10. #define DIALOG_REGISTER 1
  11. #define DIALOG_LOGIN 2
  12. //===========================
  13.  
  14. public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
  15. {
  16.     if(dialogid==DIALOG_REGISTER)
  17.     {
  18.         if(response)
  19.         {
  20.             if(strlen(inputtext) == 0)
  21.             {
  22.                 new string[200];//{}
  23.                 format(string,sizeof(string),"{FFFFFF}Das angegebene Passwort ist {FF0000}zu kurz!\n{FFFFFF}Bitte versuche es erneut:");
  24.                 ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"Einwohnermeldeamt",string,"Registrieren","Abbrechen");
  25.                 return 1;
  26.             }
  27.             else
  28.             {
  29.                 CreateAccount(playerid, inputtext);
  30.                 gPlayerLogged[playerid] = 1;
  31.                 SetSpawnInfo(playerid,0,0,1152.7500,-1440.1611,15.7969,92.2296,0,0,0,0,0,0);
  32.                 SpawnPlayer(playerid);
  33.                 return 1;
  34.             }
  35.         }
  36.         else
  37.         {
  38.             SendClientMessage(playerid,COLOR_RED,"Du wurdest gekickt, da du dich nicht registriert hast!");
  39.             Kick(playerid);
  40.         }
  41.     }
  42.  
  43.     if(dialogid==DIALOG_LOGIN)
  44.     {
  45.         if(response)
  46.         {
  47.             if(strlen(inputtext) == 0)
  48.             {
  49.                 new string[200];//{}
  50.                 format(string,sizeof(string),"{FFFFFF}Das angegebene Passwort ist {FF0000}falsch!\n{FFFFFF}Bitte versuche es erneut:");
  51.                 ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login",string,"Login","Abbrechen");
  52.                 return 1;
  53.             }
  54.             else
  55.             {
  56.                 new SpielerName[MAX_PLAYER_NAME];
  57.                 GetPlayerName(playerid, SpielerName, MAX_PLAYER_NAME);
  58.                 if(!strcmp(inputtext, mysql_ReturnPasswort(SpielerName), true))
  59.                 {
  60.                     gPlayerLogged[playerid] = 1;
  61.                     LoadPlayer(playerid);
  62.                     SetSpawnInfo(playerid,0,0,1152.7500,-1440.1611,15.7969,92.2296,0,0,0,0,0,0);
  63.                     SpawnPlayer(playerid);
  64.                     return 1;
  65.                 }
  66.                 else
  67.                 {
  68.                     new string[200];//{}
  69.                     format(string,sizeof(string),"{FFFFFF}Das angegebene Passwort ist {FF0000}falsch!\n{FFFFFF}Bitte versuche es erneut:");
  70.                     ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login",string,"Login","Abbrechen");
  71.                     return 1;
  72.                 }
  73.             }
  74.         }
  75.         else
  76.         {
  77.             SendClientMessage(playerid,COLOR_RED,"Du wurdest gekickt, da du dich nicht eingeloggt hast!");
  78.             Kick(playerid);
  79.         }
  80.     }
  81.     return 1;
  82. }
  83. stock Connect_To_Database()
  84. {
  85.     mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
  86.     if(mysql_ping() == 1)
  87.     {
  88.         print("Server wurde mit der Datenbank verbunden!");
  89.         return true;
  90.     }
  91.     else
  92.     {
  93.         print("Server konnte nicht zur Datenbank verbinden. 1/2");
  94.         mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
  95.         if(mysql_ping() == 1)
  96.         {
  97.             print("Server wurde mit der Datenbank verbunden! [2]");
  98.             return true;
  99.         }
  100.         else
  101.         {
  102.             print("Server konnte nicht zur Datenbank verbinden. 2/2");
  103.             print("SERVER: SHUTDOWN");
  104.             SendRconCommand("exit");
  105.             return true;
  106.         }
  107.     }
  108. }
  109.  
  110. stock mysql_CheckAccount(playerid)
  111. {
  112.     new Query[128],Name[MAX_PLAYER_NAME],count;
  113.     GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
  114.     mysql_real_escape_string(Name, Name);
  115.     format(Query, sizeof(Query), "SELECT * FROM `accounts` WHERE `Name` = '%s'", Name);
  116.     mysql_query(Query);
  117.     mysql_store_result();
  118.     count = mysql_num_rows();
  119.     mysql_free_result();
  120.     return count;
  121. }
  122.  
  123. stock CreateAccount(playerid, pass[])
  124. {
  125.     new query[256],Name[MAX_PLAYER_NAME];
  126.     GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
  127.     mysql_real_escape_string(Name,Name);
  128.     mysql_real_escape_string(pass,pass);
  129.     format(query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Passwort`) VALUES ('%s', '%s')", Name, pass);
  130.     mysql_query(query);
  131.     return true;
  132. }
  133.  
  134. stock mysql_ReturnPasswort(Name[])
  135. {
  136.     new query[130], Get[130];
  137.     mysql_real_escape_string(Name, Name);
  138.     format(query, 128, "SELECT `passwort` FROM `accounts` WHERE `Name` = '%s'", Name);
  139.     mysql_query(query);
  140.     mysql_store_result();
  141.     mysql_fetch_row(Get);
  142.     mysql_free_result();
  143.     return Get;
  144. }
  145.  
  146. stock mysql_GetInt(Table[], Field[], Where[], Is[])
  147. {
  148.     new query[128];
  149.     mysql_real_escape_string(Table, Table);
  150.     mysql_real_escape_string(Field, Field);
  151.     mysql_real_escape_string(Where, Where);
  152.     mysql_real_escape_string(Is, Is);
  153.     format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
  154.     mysql_query(query);
  155.     mysql_store_result();
  156.     new sqlint = mysql_fetch_int();
  157.     mysql_free_result();
  158.     return sqlint;
  159. }
  160.  
  161. stock mysql_GetString(Table[], Field[], Where[], Is[])
  162. {
  163.     new query[128], Get[128];
  164.     mysql_real_escape_string(Table, Table);
  165.     mysql_real_escape_string(Field, Field);
  166.     mysql_real_escape_string(Where, Where);
  167.     mysql_real_escape_string(Is, Is);
  168.     format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
  169.     mysql_query(query);
  170.     mysql_store_result();
  171.     mysql_fetch_row(Get);
  172.     mysql_free_result();
  173.     return Get;
  174. }
  175.  
  176. stock Float:mysql_GetFloat(Table[], Field[], Where[], Is[])
  177. {
  178.     new query[128], Float:sqlfloat;
  179.     mysql_real_escape_string(Table, Table);
  180.     mysql_real_escape_string(Field, Field);
  181.     mysql_real_escape_string(Where, Where);
  182.     mysql_real_escape_string(Is, Is);
  183.     format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
  184.     mysql_query(query);
  185.     mysql_store_result();
  186.     mysql_fetch_float(sqlfloat);
  187.     mysql_free_result();
  188.     return sqlfloat;
  189. }
  190.  
  191. stock mysql_SetInt(Table[], Field[], To, Where[], Where2[])
  192. {
  193.     new query[128];
  194.     mysql_real_escape_string(Table, Table);
  195.     mysql_real_escape_string(Field, Field);
  196.     mysql_real_escape_string(Where, Where);
  197.     mysql_real_escape_string(Where2, Where2);
  198.     format(query, 128, "UPDATE `%s` SET `%s` = '%d' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
  199.     mysql_query(query);
  200.     return true;
  201. }
  202.  
  203. stock mysql_SetString(Table[], Field[], To[], Where[], Where2[])
  204. {
  205.     new query[128];
  206.     mysql_real_escape_string(Table, Table);
  207.     mysql_real_escape_string(Field, Field);
  208.     mysql_real_escape_string(To, To);
  209.     mysql_real_escape_string(Where, Where);
  210.     mysql_real_escape_string(Where2, Where2);
  211.     format(query, 128, "UPDATE `%s` SET `%s` = '%s' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
  212.     mysql_query(query);
  213.     return true;
  214. }
  215.  
  216. stock mysql_SetFloat(Table[], Field[], Float:To, Where[], Where2[])
  217. {
  218.     new query[128];
  219.     mysql_real_escape_string(Table, Table);
  220.     mysql_real_escape_string(Field, Field);
  221.     mysql_real_escape_string(Where, Where);
  222.     mysql_real_escape_string(Where2, Where2);
  223.     format(query, 128, "UPDATE `%s` SET `%s` = '%f' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
  224.     mysql_query(query);
  225.     return true;
  226. }
  227. stock LoadPlayer(playerid)
  228. {
  229.     if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
  230.     {
  231.         GetPlayerName(playerid, PlayerInfo[playerid][pName], MAX_PLAYER_NAME);
  232.         PlayerInfo[playerid][pLevel] = mysql_GetInt("accounts","Level", "Name", PlayerInfo[playerid][pName]);
  233.         PlayerInfo[playerid][pAdmin] = mysql_GetInt("accounts","Adminlevel", "Name", PlayerInfo[playerid][pName]);
  234.         PlayerInfo[playerid][pDonateRank] = mysql_GetInt("accounts","Premiumrank", "Name", PlayerInfo[playerid][pName]);
  235.         PlayerInfo[playerid][gPupgrade] = mysql_GetInt("accounts","Upgradepunkte", "Name", PlayerInfo[playerid][pName]);
  236.         /*PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  237.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  238.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  239.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  240.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  241.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  242.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  243.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  244.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  245.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  246.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  247.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  248.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  249.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  250.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  251.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  252.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  253.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  254.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  255.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  256.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  257.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  258.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  259.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  260.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  261.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  262.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  263.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);
  264.         PlayerInfo[playerid][] = mysql_GetInt("accounts","", "Name", PlayerInfo[playerid][pName]);*/
  265.        
  266.        
  267.         /*
  268.             mysql_SetInt("accounts", "Adminlevel", PlayerInfo[playerid][pAdmin], "Name", PlayerInfo[playerid][pName]);
  269.             mysql_SetInt("accounts", "Premiumrank", PlayerInfo[playerid][pDonateRank], "Name", PlayerInfo[playerid][pName]);
  270.             mysql_SetInt("accounts", "Upgradepunkte", PlayerInfo[playerid][gPupgrade], "Name", PlayerInfo[playerid][pName]);
  271.             mysql_SetInt("accounts", "Spielzeit", PlayerInfo[playerid][pConnectTime], "Name", PlayerInfo[playerid][pName]);
  272.             mysql_SetInt("accounts", "Registriert", PlayerInfo[playerid][pReg], "Name", PlayerInfo[playerid][pName]);
  273.             mysql_SetInt("accounts", "Geschlecht", PlayerInfo[playerid][pSex], "Name", PlayerInfo[playerid][pName]);
  274.             mysql_SetInt("accounts", "Alter", PlayerInfo[playerid][pAge], "Name", PlayerInfo[playerid][pName]);
  275.             mysql_SetInt("accounts", "Herkunft", PlayerInfo[playerid][pOrigin], "Name", PlayerInfo[playerid][pName]);
  276.             mysql_SetInt("accounts", "CK", PlayerInfo[playerid][pCK], "Name", PlayerInfo[playerid][pName]);
  277.             mysql_SetInt("accounts", "Gemuted", PlayerInfo[playerid][pMuted], "Name", PlayerInfo[playerid][pName]);
  278.             mysql_SetInt("accounts", "Respektpunkte", PlayerInfo[playerid][pExp], "Name", PlayerInfo[playerid][pName]);
  279.             mysql_SetInt("accounts", "Geld", PlayerInfo[playerid][pCash], "Name", PlayerInfo[playerid][pName]);
  280.             mysql_SetInt("accounts", "Bankguthaben", PlayerInfo[playerid][pAccount], "Name", PlayerInfo[playerid][pName]);
  281.             mysql_SetInt("accounts", "Wantedlevel", PlayerInfo[playerid][pCrimes], "Name", PlayerInfo[playerid][pName]);
  282.             mysql_SetInt("accounts", "Kills", PlayerInfo[playerid][pKills], "Name", PlayerInfo[playerid][pName]);
  283.             mysql_SetInt("accounts", "Tode", PlayerInfo[playerid][pDeaths], "Name", PlayerInfo[playerid][pName]);
  284.             mysql_SetInt("accounts", "Eingebuchtet", PlayerInfo[playerid][pArrested], "Name", PlayerInfo[playerid][pName]);
  285.             mysql_SetInt("accounts", "Wantedtode", PlayerInfo[playerid][pWantedDeaths], "Name", PlayerInfo[playerid][pName]);
  286.             mysql_SetInt("accounts", "Telefonbuch", PlayerInfo[playerid][pPhoneBook], "Name", PlayerInfo[playerid][pName]);
  287.             mysql_SetInt("accounts", "Lottoticket", PlayerInfo[playerid][pLottoNr], "Name", PlayerInfo[playerid][pName]);
  288.             mysql_SetInt("accounts", "Fische", PlayerInfo[playerid][pFishes], "Name", PlayerInfo[playerid][pName]);
  289.             mysql_SetInt("accounts", "GrößterFisch", PlayerInfo[playerid][pBiggestFish], "Name", PlayerInfo[playerid][pName]);
  290.             mysql_SetInt("accounts", "Job", PlayerInfo[playerid][pJob], "Name", PlayerInfo[playerid][pName]);
  291.             mysql_SetInt("accounts", "Paycheck", PlayerInfo[playerid][pPayCheck], "Name", PlayerInfo[playerid][pName]);
  292.             mysql_SetInt("accounts", "Kopfgeld", PlayerInfo[playerid][pHeadValue], "Name", PlayerInfo[playerid][pName]);
  293.             mysql_SetInt("accounts", "Jailed", PlayerInfo[playerid][pJailed], "Name", PlayerInfo[playerid][pName]);
  294.             mysql_SetInt("accounts", "Knastzeit", PlayerInfo[playerid][pJailTime], "Name", PlayerInfo[playerid][pName]);
  295.             mysql_SetInt("accounts", "Materialien", PlayerInfo[playerid][pMats], "Name", PlayerInfo[playerid][pName]);
  296.             mysql_SetInt("accounts", "Drogen", PlayerInfo[playerid][pDrugs], "Name", PlayerInfo[playerid][pName]);
  297.             mysql_SetInt("accounts", "Leader", PlayerInfo[playerid][pLeader], "Name", PlayerInfo[playerid][pName]);
  298.             mysql_SetInt("accounts", "Member", PlayerInfo[playerid][pMember], "Name", PlayerInfo[playerid][pName]);
  299.             mysql_SetInt("accounts", "FMember", PlayerInfo[playerid][pFMember], "Name", PlayerInfo[playerid][pName]);
  300.             mysql_SetInt("accounts", "Rank", PlayerInfo[playerid][pRank], "Name", PlayerInfo[playerid][pName]);
  301.             mysql_SetInt("accounts", "Skin", PlayerInfo[playerid][pChar], "Name", PlayerInfo[playerid][pName]);
  302.             mysql_SetInt("accounts", "ContractTime", PlayerInfo[playerid][pContractTime], "Name", PlayerInfo[playerid][pName]);
  303.             mysql_SetInt("accounts", "DetSkill", PlayerInfo[playerid][pDetSkill], "Name", PlayerInfo[playerid][pName]);
  304.             mysql_SetInt("accounts", "SexSkill", PlayerInfo[playerid][pSexSkill], "Name", PlayerInfo[playerid][pName]);
  305.             mysql_SetInt("accounts", "BoxSkill", PlayerInfo[playerid][pBoxSkill], "Name", PlayerInfo[playerid][pName]);
  306.             mysql_SetInt("accounts", "LawSkill", PlayerInfo[playerid][pLawSkill], "Name", PlayerInfo[playerid][pName]);
  307.             mysql_SetInt("accounts", "MechSkill", PlayerInfo[playerid][pMechSkill], "Name", PlayerInfo[playerid][pName]);
  308.             mysql_SetInt("accounts", "JackSkill", PlayerInfo[playerid][pJackSkill], "Name", PlayerInfo[playerid][pName]);
  309.             mysql_SetInt("accounts", "CarSkill", PlayerInfo[playerid][pCarSkill], "Name", PlayerInfo[playerid][pName]);
  310.             mysql_SetInt("accounts", "NewsSkill", PlayerInfo[playerid][pNewsSkill], "Name", PlayerInfo[playerid][pName]);
  311.             mysql_SetInt("accounts", "DrugsSkill", PlayerInfo[playerid][pDrugsSkill], "Name", PlayerInfo[playerid][pName]);
  312.             mysql_SetInt("accounts", "CookSkill", PlayerInfo[playerid][pCookSkill], "Name", PlayerInfo[playerid][pName]);
  313.             mysql_SetInt("accounts", "FishSkill", PlayerInfo[playerid][pFishSkill], "Name", PlayerInfo[playerid][pName]);
  314.             mysql_SetFloat("accounts", "SEnergie", PlayerInfo[playerid][pSHealth], "Name", PlayerInfo[playerid][pName]);
  315.             mysql_SetFloat("accounts", "Energie", PlayerInfo[playerid][pHealth], "Name", PlayerInfo[playerid][pName]);
  316.             mysql_SetInt("accounts", "Int", PlayerInfo[playerid][pInt], "Name", PlayerInfo[playerid][pName]);
  317.             mysql_SetInt("accounts", "Local", PlayerInfo[playerid][pLocal], "Name", PlayerInfo[playerid][pName]);
  318.             mysql_SetInt("accounts", "Team", PlayerInfo[playerid][pTeam], "Name", PlayerInfo[playerid][pName]);
  319.             mysql_SetInt("accounts", "Model", PlayerInfo[playerid][pModel], "Name", PlayerInfo[playerid][pName]);
  320.             mysql_SetInt("accounts", "Telefonnummer", PlayerInfo[playerid][pPnumber], "Name", PlayerInfo[playerid][pName]);
  321.             mysql_SetInt("accounts", "Haus", PlayerInfo[playerid][pPhousekey], "Name", PlayerInfo[playerid][pName]);
  322.             mysql_SetInt("accounts", "Bizz", PlayerInfo[playerid][pPbiskey], "Name", PlayerInfo[playerid][pName]);
  323.             mysql_SetFloat("accounts", "PosX", PlayerInfo[playerid][pPos_x], "Name", PlayerInfo[playerid][pName]);
  324.             mysql_SetFloat("accounts", "PosY", PlayerInfo[playerid][pPos_y], "Name", PlayerInfo[playerid][pName]);
  325.             mysql_SetFloat("accounts", "PosZ", PlayerInfo[playerid][pPos_z], "Name", PlayerInfo[playerid][pName]);
  326.             mysql_SetInt("accounts", "CarLic", PlayerInfo[playerid][pCarLic], "Name", PlayerInfo[playerid][pName]);
  327.             mysql_SetInt("accounts", "BoatLic", PlayerInfo[playerid][pBoatLic], "Name", PlayerInfo[playerid][pName]);
  328.             mysql_SetInt("accounts", "FlyLic", PlayerInfo[playerid][pFlyLic], "Name", PlayerInfo[playerid][pName]);
  329.             mysql_SetInt("accounts", "FishLic", PlayerInfo[playerid][pFishLic], "Name", PlayerInfo[playerid][pName]);
  330.             mysql_SetInt("accounts", "Gunlic", PlayerInfo[playerid][pGunLic], "Name", PlayerInfo[playerid][pName]);
  331.             mysql_SetInt("accounts", "Waffe1", PlayerInfo[playerid][pGun1], "Name", PlayerInfo[playerid][pName]);
  332.             mysql_SetInt("accounts", "Waffe2", PlayerInfo[playerid][pGun2], "Name", PlayerInfo[playerid][pName]);
  333.             mysql_SetInt("accounts", "Waffe3", PlayerInfo[playerid][pGun3], "Name", PlayerInfo[playerid][pName]);
  334.             mysql_SetInt("accounts", "Waffe4", PlayerInfo[playerid][pGun4], "Name", PlayerInfo[playerid][pName]);
  335.             mysql_SetInt("accounts", "Muni1", PlayerInfo[playerid][pAmmo1], "Name", PlayerInfo[playerid][pName]);
  336.             mysql_SetInt("accounts", "Muni2", PlayerInfo[playerid][pAmmo2], "Name", PlayerInfo[playerid][pName]);
  337.             mysql_SetInt("accounts", "Muni3", PlayerInfo[playerid][pAmmo3], "Name", PlayerInfo[playerid][pName]);
  338.             mysql_SetInt("accounts", "Muni4", PlayerInfo[playerid][pAmmo4], "Name", PlayerInfo[playerid][pName]);
  339.             mysql_SetInt("accounts", "CarTime", PlayerInfo[playerid][pCarTime], "Name", PlayerInfo[playerid][pName]);
  340.             mysql_SetInt("accounts", "PayDay", PlayerInfo[playerid][pPayDay], "Name", PlayerInfo[playerid][pName]);
  341.             mysql_SetInt("accounts", "PayDayHad", PlayerInfo[playerid][pPayDayHad], "Name", PlayerInfo[playerid][pName]);
  342.             mysql_SetInt("accounts", "CDPlayer", PlayerInfo[playerid][pCDPlayer], "Name", PlayerInfo[playerid][pName]);
  343.             mysql_SetInt("accounts", "Wins", PlayerInfo[playerid][pWins], "Name", PlayerInfo[playerid][pName]);
  344.             mysql_SetInt("accounts", "Loses", PlayerInfo[playerid][pLoses], "Name", PlayerInfo[playerid][pName]);
  345.             mysql_SetInt("accounts", "AlkoholUpgrade", PlayerInfo[playerid][pAlcoholPerk], "Name", PlayerInfo[playerid][pName]);
  346.             mysql_SetInt("accounts", "DrogenUpgrade", PlayerInfo[playerid][pDrugPerk], "Name", PlayerInfo[playerid][pName]);
  347.             mysql_SetInt("accounts", "GeizhalsUpgrade", PlayerInfo[playerid][pMiserPerk], "Name", PlayerInfo[playerid][pName]);
  348.             mysql_SetInt("accounts", "SchmerzenUpgrade", PlayerInfo[playerid][pPainPerk], "Name", PlayerInfo[playerid][pName]);
  349.             mysql_SetInt("accounts", "HändlerUpgrade", PlayerInfo[playerid][pTraderPerk], "Name", PlayerInfo[playerid][pName]);
  350.             mysql_SetInt("accounts", "Tutorial", PlayerInfo[playerid][pTut], "Name", PlayerInfo[playerid][pName]);
  351.             mysql_SetInt("accounts", "Mission", PlayerInfo[playerid][pMissionNr], "Name", PlayerInfo[playerid][pName]);
  352.             mysql_SetInt("accounts", "Verwarnungen", PlayerInfo[playerid][pWarns], "Name", PlayerInfo[playerid][pName]);
  353.             mysql_SetInt("accounts", "Einstellbar", PlayerInfo[playerid][pAdjustable], "Name", PlayerInfo[playerid][pName]);
  354.             mysql_SetInt("accounts", "Kraftstoff", PlayerInfo[playerid][pFuel], "Name", PlayerInfo[playerid][pName]);
  355.             mysql_SetInt("accounts", "Verheiratet", PlayerInfo[playerid][pMarried], "Name", PlayerInfo[playerid][pName]);
  356.             mysql_SetInt("accounts", "VerheiratetMit", PlayerInfo[playerid][pMarriedTo], "Name", PlayerInfo[playerid][pName]);
  357.             */
  358.     }
  359.     return 1;
  360. }
  361.  
  362. stock SavePlayer(playerid)
  363. {
  364.     if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
  365.     {
  366.         if(gPlayerLogged[playerid] == 1)
  367.         {
  368.             mysql_SetInt("accounts", "Level", PlayerInfo[playerid][pLevel], "Name", PlayerInfo[playerid][pName]);
  369.             mysql_SetInt("accounts", "Adminlevel", PlayerInfo[playerid][pAdmin], "Name", PlayerInfo[playerid][pName]);
  370.             mysql_SetInt("accounts", "Premiumrank", PlayerInfo[playerid][pDonateRank], "Name", PlayerInfo[playerid][pName]);
  371.             mysql_SetInt("accounts", "Upgradepunkte", PlayerInfo[playerid][gPupgrade], "Name", PlayerInfo[playerid][pName]);
  372.             mysql_SetInt("accounts", "Spielzeit", PlayerInfo[playerid][pConnectTime], "Name", PlayerInfo[playerid][pName]);
  373.             mysql_SetInt("accounts", "Registriert", PlayerInfo[playerid][pReg], "Name", PlayerInfo[playerid][pName]);
  374.             mysql_SetInt("accounts", "Geschlecht", PlayerInfo[playerid][pSex], "Name", PlayerInfo[playerid][pName]);
  375.             mysql_SetInt("accounts", "Alter", PlayerInfo[playerid][pAge], "Name", PlayerInfo[playerid][pName]);
  376.             mysql_SetInt("accounts", "Herkunft", PlayerInfo[playerid][pOrigin], "Name", PlayerInfo[playerid][pName]);
  377.             mysql_SetInt("accounts", "CK", PlayerInfo[playerid][pCK], "Name", PlayerInfo[playerid][pName]);
  378.             mysql_SetInt("accounts", "Gemuted", PlayerInfo[playerid][pMuted], "Name", PlayerInfo[playerid][pName]);
  379.             mysql_SetInt("accounts", "Respektpunkte", PlayerInfo[playerid][pExp], "Name", PlayerInfo[playerid][pName]);
  380.             mysql_SetInt("accounts", "Geld", PlayerInfo[playerid][pCash], "Name", PlayerInfo[playerid][pName]);
  381.             mysql_SetInt("accounts", "Bankguthaben", PlayerInfo[playerid][pAccount], "Name", PlayerInfo[playerid][pName]);
  382.             mysql_SetInt("accounts", "Wantedlevel", PlayerInfo[playerid][pCrimes], "Name", PlayerInfo[playerid][pName]);
  383.             mysql_SetInt("accounts", "Kills", PlayerInfo[playerid][pKills], "Name", PlayerInfo[playerid][pName]);
  384.             mysql_SetInt("accounts", "Tode", PlayerInfo[playerid][pDeaths], "Name", PlayerInfo[playerid][pName]);
  385.             mysql_SetInt("accounts", "Eingebuchtet", PlayerInfo[playerid][pArrested], "Name", PlayerInfo[playerid][pName]);
  386.             mysql_SetInt("accounts", "Wantedtode", PlayerInfo[playerid][pWantedDeaths], "Name", PlayerInfo[playerid][pName]);
  387.             mysql_SetInt("accounts", "Telefonbuch", PlayerInfo[playerid][pPhoneBook], "Name", PlayerInfo[playerid][pName]);
  388.             mysql_SetInt("accounts", "Lottoticket", PlayerInfo[playerid][pLottoNr], "Name", PlayerInfo[playerid][pName]);
  389.             mysql_SetInt("accounts", "Fische", PlayerInfo[playerid][pFishes], "Name", PlayerInfo[playerid][pName]);
  390.             mysql_SetInt("accounts", "GrößterFisch", PlayerInfo[playerid][pBiggestFish], "Name", PlayerInfo[playerid][pName]);
  391.             mysql_SetInt("accounts", "Job", PlayerInfo[playerid][pJob], "Name", PlayerInfo[playerid][pName]);
  392.             mysql_SetInt("accounts", "Paycheck", PlayerInfo[playerid][pPayCheck], "Name", PlayerInfo[playerid][pName]);
  393.             mysql_SetInt("accounts", "Kopfgeld", PlayerInfo[playerid][pHeadValue], "Name", PlayerInfo[playerid][pName]);
  394.             mysql_SetInt("accounts", "Jailed", PlayerInfo[playerid][pJailed], "Name", PlayerInfo[playerid][pName]);
  395.             mysql_SetInt("accounts", "Knastzeit", PlayerInfo[playerid][pJailTime], "Name", PlayerInfo[playerid][pName]);
  396.             mysql_SetInt("accounts", "Materialien", PlayerInfo[playerid][pMats], "Name", PlayerInfo[playerid][pName]);
  397.             mysql_SetInt("accounts", "Drogen", PlayerInfo[playerid][pDrugs], "Name", PlayerInfo[playerid][pName]);
  398.             mysql_SetInt("accounts", "Leader", PlayerInfo[playerid][pLeader], "Name", PlayerInfo[playerid][pName]);
  399.             mysql_SetInt("accounts", "Member", PlayerInfo[playerid][pMember], "Name", PlayerInfo[playerid][pName]);
  400.             mysql_SetInt("accounts", "FMember", PlayerInfo[playerid][pFMember], "Name", PlayerInfo[playerid][pName]);
  401.             mysql_SetInt("accounts", "Rank", PlayerInfo[playerid][pRank], "Name", PlayerInfo[playerid][pName]);
  402.             mysql_SetInt("accounts", "Skin", PlayerInfo[playerid][pChar], "Name", PlayerInfo[playerid][pName]);
  403.             mysql_SetInt("accounts", "ContractTime", PlayerInfo[playerid][pContractTime], "Name", PlayerInfo[playerid][pName]);
  404.             mysql_SetInt("accounts", "DetSkill", PlayerInfo[playerid][pDetSkill], "Name", PlayerInfo[playerid][pName]);
  405.             mysql_SetInt("accounts", "SexSkill", PlayerInfo[playerid][pSexSkill], "Name", PlayerInfo[playerid][pName]);
  406.             mysql_SetInt("accounts", "BoxSkill", PlayerInfo[playerid][pBoxSkill], "Name", PlayerInfo[playerid][pName]);
  407.             mysql_SetInt("accounts", "LawSkill", PlayerInfo[playerid][pLawSkill], "Name", PlayerInfo[playerid][pName]);
  408.             mysql_SetInt("accounts", "MechSkill", PlayerInfo[playerid][pMechSkill], "Name", PlayerInfo[playerid][pName]);
  409.             mysql_SetInt("accounts", "JackSkill", PlayerInfo[playerid][pJackSkill], "Name", PlayerInfo[playerid][pName]);
  410.             mysql_SetInt("accounts", "CarSkill", PlayerInfo[playerid][pCarSkill], "Name", PlayerInfo[playerid][pName]);
  411.             mysql_SetInt("accounts", "NewsSkill", PlayerInfo[playerid][pNewsSkill], "Name", PlayerInfo[playerid][pName]);
  412.             mysql_SetInt("accounts", "DrugsSkill", PlayerInfo[playerid][pDrugsSkill], "Name", PlayerInfo[playerid][pName]);
  413.             mysql_SetInt("accounts", "CookSkill", PlayerInfo[playerid][pCookSkill], "Name", PlayerInfo[playerid][pName]);
  414.             mysql_SetInt("accounts", "FishSkill", PlayerInfo[playerid][pFishSkill], "Name", PlayerInfo[playerid][pName]);
  415.             mysql_SetFloat("accounts", "SEnergie", PlayerInfo[playerid][pSHealth], "Name", PlayerInfo[playerid][pName]);
  416.             mysql_SetFloat("accounts", "Energie", PlayerInfo[playerid][pHealth], "Name", PlayerInfo[playerid][pName]);
  417.             mysql_SetInt("accounts", "Int", PlayerInfo[playerid][pInt], "Name", PlayerInfo[playerid][pName]);
  418.             mysql_SetInt("accounts", "Local", PlayerInfo[playerid][pLocal], "Name", PlayerInfo[playerid][pName]);
  419.             mysql_SetInt("accounts", "Team", PlayerInfo[playerid][pTeam], "Name", PlayerInfo[playerid][pName]);
  420.             mysql_SetInt("accounts", "Model", PlayerInfo[playerid][pModel], "Name", PlayerInfo[playerid][pName]);
  421.             mysql_SetInt("accounts", "Telefonnummer", PlayerInfo[playerid][pPnumber], "Name", PlayerInfo[playerid][pName]);
  422.             mysql_SetInt("accounts", "Haus", PlayerInfo[playerid][pPhousekey], "Name", PlayerInfo[playerid][pName]);
  423.             mysql_SetInt("accounts", "Bizz", PlayerInfo[playerid][pPbiskey], "Name", PlayerInfo[playerid][pName]);
  424.             mysql_SetFloat("accounts", "PosX", PlayerInfo[playerid][pPos_x], "Name", PlayerInfo[playerid][pName]);
  425.             mysql_SetFloat("accounts", "PosY", PlayerInfo[playerid][pPos_y], "Name", PlayerInfo[playerid][pName]);
  426.             mysql_SetFloat("accounts", "PosZ", PlayerInfo[playerid][pPos_z], "Name", PlayerInfo[playerid][pName]);
  427.             mysql_SetInt("accounts", "CarLic", PlayerInfo[playerid][pCarLic], "Name", PlayerInfo[playerid][pName]);
  428.             mysql_SetInt("accounts", "BoatLic", PlayerInfo[playerid][pBoatLic], "Name", PlayerInfo[playerid][pName]);
  429.             mysql_SetInt("accounts", "FlyLic", PlayerInfo[playerid][pFlyLic], "Name", PlayerInfo[playerid][pName]);
  430.             mysql_SetInt("accounts", "FishLic", PlayerInfo[playerid][pFishLic], "Name", PlayerInfo[playerid][pName]);
  431.             mysql_SetInt("accounts", "Gunlic", PlayerInfo[playerid][pGunLic], "Name", PlayerInfo[playerid][pName]);
  432.             mysql_SetInt("accounts", "Waffe1", PlayerInfo[playerid][pGun1], "Name", PlayerInfo[playerid][pName]);
  433.             mysql_SetInt("accounts", "Waffe2", PlayerInfo[playerid][pGun2], "Name", PlayerInfo[playerid][pName]);
  434.             mysql_SetInt("accounts", "Waffe3", PlayerInfo[playerid][pGun3], "Name", PlayerInfo[playerid][pName]);
  435.             mysql_SetInt("accounts", "Waffe4", PlayerInfo[playerid][pGun4], "Name", PlayerInfo[playerid][pName]);
  436.             mysql_SetInt("accounts", "Muni1", PlayerInfo[playerid][pAmmo1], "Name", PlayerInfo[playerid][pName]);
  437.             mysql_SetInt("accounts", "Muni2", PlayerInfo[playerid][pAmmo2], "Name", PlayerInfo[playerid][pName]);
  438.             mysql_SetInt("accounts", "Muni3", PlayerInfo[playerid][pAmmo3], "Name", PlayerInfo[playerid][pName]);
  439.             mysql_SetInt("accounts", "Muni4", PlayerInfo[playerid][pAmmo4], "Name", PlayerInfo[playerid][pName]);
  440.             mysql_SetInt("accounts", "CarTime", PlayerInfo[playerid][pCarTime], "Name", PlayerInfo[playerid][pName]);
  441.             mysql_SetInt("accounts", "PayDay", PlayerInfo[playerid][pPayDay], "Name", PlayerInfo[playerid][pName]);
  442.             mysql_SetInt("accounts", "PayDayHad", PlayerInfo[playerid][pPayDayHad], "Name", PlayerInfo[playerid][pName]);
  443.             mysql_SetInt("accounts", "CDPlayer", PlayerInfo[playerid][pCDPlayer], "Name", PlayerInfo[playerid][pName]);
  444.             mysql_SetInt("accounts", "Wins", PlayerInfo[playerid][pWins], "Name", PlayerInfo[playerid][pName]);
  445.             mysql_SetInt("accounts", "Loses", PlayerInfo[playerid][pLoses], "Name", PlayerInfo[playerid][pName]);
  446.             mysql_SetInt("accounts", "AlkoholUpgrade", PlayerInfo[playerid][pAlcoholPerk], "Name", PlayerInfo[playerid][pName]);
  447.             mysql_SetInt("accounts", "DrogenUpgrade", PlayerInfo[playerid][pDrugPerk], "Name", PlayerInfo[playerid][pName]);
  448.             mysql_SetInt("accounts", "GeizhalsUpgrade", PlayerInfo[playerid][pMiserPerk], "Name", PlayerInfo[playerid][pName]);
  449.             mysql_SetInt("accounts", "SchmerzenUpgrade", PlayerInfo[playerid][pPainPerk], "Name", PlayerInfo[playerid][pName]);
  450.             mysql_SetInt("accounts", "HändlerUpgrade", PlayerInfo[playerid][pTraderPerk], "Name", PlayerInfo[playerid][pName]);
  451.             mysql_SetInt("accounts", "Tutorial", PlayerInfo[playerid][pTut], "Name", PlayerInfo[playerid][pName]);
  452.             mysql_SetInt("accounts", "Mission", PlayerInfo[playerid][pMissionNr], "Name", PlayerInfo[playerid][pName]);
  453.             mysql_SetInt("accounts", "Verwarnungen", PlayerInfo[playerid][pWarns], "Name", PlayerInfo[playerid][pName]);
  454.             mysql_SetInt("accounts", "Einstellbar", PlayerInfo[playerid][pAdjustable], "Name", PlayerInfo[playerid][pName]);
  455.             mysql_SetInt("accounts", "Kraftstoff", PlayerInfo[playerid][pFuel], "Name", PlayerInfo[playerid][pName]);
  456.             mysql_SetInt("accounts", "Verheiratet", PlayerInfo[playerid][pMarried], "Name", PlayerInfo[playerid][pName]);
  457.             mysql_SetInt("accounts", "VerheiratetMit", PlayerInfo[playerid][pMarriedTo], "Name", PlayerInfo[playerid][pName]);
  458.         }
  459.     }
  460.     return 1;
  461. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!