API tools faq
paste
Advertisement
Guest User

Basic Mysql...

a guest
Mar 21st, 2013
423
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 40.50 KB | None | 0 0
raw download clone embed print report
  1. /* Dieses Script wurde von Nighstr3am geschrieben !!
  2.     Es darf nicht weiter-Verkauft oder Veröffentlicht werden ohne seine Erlaubnis !
  3.     Copyright by Nightstr3am
  4. */
  5.  
  6.  
  7. /////////////////////////////////////=========== [Changelog] ===========/////////////////////////////////////
  8. /*
  9.                                        [ Mysql Version R5 by G-Stylezz ]
  10.                                        Haupt-Farben bei HTML : {16A63E} und {FEFEFE}
  11.                                        
  12.                                        
  13.                                     - 0.1 Mysql - Login / Register System
  14.                                     - PlayerInfo als Enum eingeschrieben
  15.                                     - Admin-System (SetAdmin ocmd)
  16.                                     - /makeleader || /makeadmin
  17.                                     - Fraktionen (11)
  18.                                     - /ahelp || /help//hilfe || /fliste
  19.                                     - Perso , Car-Lic, Flug-Lic, Mottorad-Lic, Waffenschein || Erstellt bzw. werden nur gespeichert
  20.                                     - Globaler Chat Radius ..
  21. */
  22.  
  23.  
  24.  
  25. //==== [Include's] ====//
  26. #include <a_samp>
  27. #include <a_mysql>
  28. #include <ocmd>
  29. #include <streamer>
  30.  
  31. //==== [Mysql - Daten] ====//
  32. #define my_Host   "localhost"
  33. #define my_User   "USERNAME"
  34. #define my_Pass   "PASSWORT"
  35. #define my_Data   "DATENBANKNAME"
  36.  
  37. //==== [Enum's] ====//
  38. enum PInfo
  39. {
  40.     pLevel,
  41.     pAdmin,
  42.     pGeld,
  43.     pFrak,
  44.     pRang,
  45.     pPerso,
  46.     pClic,
  47.     pFlic,
  48.     pMlic,
  49.     pWlic,
  50.     Float:pX,
  51.     Float:pY,
  52.     Float:pZ,
  53.     Float:pA
  54. }
  55. new PlayerInfo[MAX_PLAYERS][PInfo];
  56.  
  57. //==== [Define's] ====//
  58. #define C_ROT 0xFF0000FF
  59. #define C_BLAU 0x0000FFFF
  60. #define C_GRÜN 0x00FF00FF
  61. #define C_LILA 0x7600FFFF
  62. #define C_GRAU 0x828282FF
  63. #define C_PINK 0xF682FFFF
  64. #define C_GELB 0xFFFA00FF
  65.  
  66. //==== [Dialoge] ====//
  67. #define D_REGISTER 0
  68. #define D_LOGIN 1
  69. #define D_POL 2 //Police Spawn Auswahl
  70. #define D_AHELP 3
  71. #define D_FLISTE 4
  72. #define D_HELP 5
  73. //==== [Variablen] ====//
  74. new ver[MAX_PLAYERS]; //Login Versuche...
  75. new zivent; //=== Am Zivispawn das Interior
  76. new zivext;
  77.  
  78. //================================
  79. #if defined FILTERSCRIPT
  80.  
  81. public OnFilterScriptInit()
  82. {
  83.     print("\n--------------------------------------");
  84.     print(" Blank Filterscript by your name here");
  85.     print("--------------------------------------\n");
  86.     return 1;
  87. }
  88.  
  89. public OnFilterScriptExit()
  90. {
  91.     return 1;
  92. }
  93. //====================
  94. #else
  95.  
  96. main()
  97. {
  98.     print("\n----------------------------------");
  99.     print(" Selfmade Reallife by Nightstr3am");
  100.     print("----------------------------------\n");
  101. }
  102.  
  103. #endif
  104.  
  105. public OnGameModeInit()
  106. {
  107.     // Don't use these lines if it's a filterscript
  108.     SetGameModeText("[GER] Selfmade Reallife");
  109.     AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
  110.     ///=====
  111.     Connect_To_Database();
  112.     EnableStuntBonusForAll(false);
  113.     ShowPlayerMarkers(1);
  114.     LimitPlayerMarkerRadius(150.0);
  115.     DisableInteriorEnterExits();
  116.     LimitGlobalChatRadius(0);
  117.     //============
  118.     zivent = CreatePickup(12911,1,534.2451,-1813.1976,6.5713);
  119.     zivext = CreatePickup(12911,1,541.40002441406,-1850.9000244141,776.90002441406);
  120.    
  121.     //======================== [ OBJEKTE ] ==========================//
  122.     //Zivispawn das Haus
  123.     CreateDynamicObject(18460,527.0999756,-1845.5999756,775.7999878,0.0000000,90.0000000,0.0000000); //object(cs_detrok08) (1)
  124.     CreateDynamicObject(18460,530.5999756,-1845.5999756,775.7999878,0.0000000,90.0000000,0.0000000); //object(cs_detrok08) (2)
  125.     CreateDynamicObject(18460,534.0999756,-1845.5999756,775.7999878,0.0000000,90.0000000,0.0000000); //object(cs_detrok08) (3)
  126.     CreateDynamicObject(18460,537.5999756,-1845.5999756,775.7999878,0.0000000,90.0000000,0.0000000); //object(cs_detrok08) (4)
  127.     CreateDynamicObject(18460,541.0999756,-1845.5999756,775.7999878,0.0000000,90.0000000,0.0000000); //object(cs_detrok08) (5)
  128.     CreateDynamicObject(18460,541.0999756,-1855.0000000,775.7999878,0.0000000,90.0000000,0.0000000); //object(cs_detrok08) (6)
  129.     CreateDynamicObject(18460,537.7999878,-1855.0000000,775.7999878,0.0000000,90.0000000,0.0000000); //object(cs_detrok08) (7)
  130.     CreateDynamicObject(18460,534.5000000,-1855.0000000,775.7999878,0.0000000,90.0000000,0.0000000); //object(cs_detrok08) (8)
  131.     CreateDynamicObject(18460,531.0000000,-1855.0000000,775.7999878,0.0000000,90.0000000,0.0000000); //object(cs_detrok08) (9)
  132.     CreateDynamicObject(18460,527.5000000,-1855.0000000,775.7999878,0.0000000,90.0000000,0.0000000); //object(cs_detrok08) (10)
  133.     CreateDynamicObject(18460,524.2000122,-1855.0000000,775.7999878,0.0000000,90.0000000,0.0000000); //object(cs_detrok08) (11)
  134.     CreateDynamicObject(18460,524.2000122,-1845.5999756,775.7999878,0.0000000,90.0000000,0.0000000); //object(cs_detrok08) (12)
  135.     CreateDynamicObject(18460,520.7000122,-1845.5999756,775.7999878,0.0000000,90.0000000,0.0000000); //object(cs_detrok08) (13)
  136.     CreateDynamicObject(18460,520.7000122,-1855.0999756,775.7999878,0.0000000,90.0000000,0.0000000); //object(cs_detrok08) (14)
  137.     CreateDynamicObject(18459,542.7000122,-1855.0000000,777.5999756,0.0000000,0.0000000,0.0000000); //object(cs_detrok07) (1)
  138.     CreateDynamicObject(18459,542.7000122,-1845.4000244,777.5999756,0.0000000,0.0000000,0.0000000); //object(cs_detrok07) (2)
  139.     CreateDynamicObject(18459,537.9000244,-1840.9000244,777.5999756,0.0000000,0.0000000,90.0000000); //object(cs_detrok07) (3)
  140.     CreateDynamicObject(18459,528.4000244,-1840.9000244,777.5999756,0.0000000,0.0000000,90.0000000); //object(cs_detrok07) (4)
  141.     CreateDynamicObject(18459,538.7999878,-1859.8000488,777.5999756,0.0000000,0.0000000,90.0000000); //object(cs_detrok07) (5)
  142.     CreateDynamicObject(18459,519.0000000,-1855.0999756,777.5999756,0.0000000,0.0000000,180.0000000); //object(cs_detrok07) (6)
  143.     CreateDynamicObject(18459,519.0000000,-1845.8000488,777.5999756,0.0000000,0.0000000,179.9945068); //object(cs_detrok07) (7)
  144.     CreateDynamicObject(18459,523.0996094,-1840.8994141,777.5999756,0.0000000,0.0000000,90.0000000); //object(cs_detrok07) (8)
  145.     CreateDynamicObject(18459,523.8994141,-1859.7998047,777.5999756,0.0000000,0.0000000,90.0000000); //object(cs_detrok07) (9)
  146.     CreateDynamicObject(18459,533.5000000,-1859.7998047,777.5999756,0.0000000,0.0000000,90.0000000); //object(cs_detrok07) (10)
  147.     CreateDynamicObject(9603,542.5000000,-1850.6999512,777.5999756,0.0000000,0.0000000,0.0000000); //object(road_16_sfw) (1)
  148.     CreateDynamicObject(1506,542.5000000,-1849.9000244,775.9000244,0.0000000,0.0000000,270.0000000); //object(gen_doorext08) (1)
  149.     CreateDynamicObject(18459,524.9000244,-1855.0000000,777.5999756,0.0000000,0.0000000,179.9945068); //object(cs_detrok07) (11)
  150.     CreateDynamicObject(9603,524.9000244,-1842.5999756,777.5999756,0.0000000,0.0000000,0.0000000); //object(road_16_sfw) (2)
  151.     CreateDynamicObject(18459,538.2999878,-1844.4000244,777.5999756,0.0000000,0.0000000,179.9945068); //object(cs_detrok07) (13)
  152.     CreateDynamicObject(1502,538.2000122,-1850.0000000,775.9000244,0.0000000,0.0000000,270.0000000); //object(gen_doorint04) (1)
  153.     CreateDynamicObject(1502,524.9000244,-1841.8000488,775.9000244,0.0000000,0.0000000,270.0000000); //object(gen_doorint04) (2)
  154.     CreateDynamicObject(2290,519.5000000,-1859.1999512,775.9000244,0.0000000,0.0000000,90.0000000); //object(swk_couch_1) (1)
  155.     CreateDynamicObject(2290,524.2999878,-1857.3000488,775.9000244,0.0000000,0.0000000,270.0000000); //object(swk_couch_1) (2)
  156.     CreateDynamicObject(2111,520.0000000,-1855.6999512,776.2999878,0.0000000,0.0000000,0.0000000); //object(low_dinning_5) (1)
  157.     CreateDynamicObject(2290,519.5999756,-1854.1999512,775.9000244,0.0000000,0.0000000,90.0000000); //object(swk_couch_1) (3)
  158.     CreateDynamicObject(2111,520.0000000,-1850.6999512,776.2999878,0.0000000,0.0000000,0.0000000); //object(low_dinning_5) (2)
  159.     CreateDynamicObject(2290,519.7000122,-1849.3000488,775.9000244,0.0000000,0.0000000,90.0000000); //object(swk_couch_1) (4)
  160.     CreateDynamicObject(2111,520.0999756,-1845.8000488,776.2999878,0.0000000,0.0000000,0.0000000); //object(low_dinning_5) (3)
  161.     CreateDynamicObject(2290,519.7999878,-1844.1999512,775.9000244,0.0000000,0.0000000,90.0000000); //object(swk_couch_1) (5)
  162.     CreateDynamicObject(2111,523.9000244,-1855.9000244,776.2999878,0.0000000,0.0000000,0.0000000); //object(low_dinning_5) (4)
  163.     CreateDynamicObject(2111,523.9000244,-1851.0000000,776.2999878,0.0000000,0.0000000,0.0000000); //object(low_dinning_5) (5)
  164.     CreateDynamicObject(2290,524.2000122,-1852.5000000,775.9000244,0.0000000,0.0000000,269.9945068); //object(swk_couch_1) (6)
  165.     CreateDynamicObject(2290,524.2000122,-1847.5999756,775.9000244,0.0000000,0.0000000,269.9945068); //object(swk_couch_1) (7)
  166.     CreateDynamicObject(2111,523.9000244,-1846.1999512,776.2999878,0.0000000,0.0000000,0.0000000); //object(low_dinning_5) (6)
  167.     CreateDynamicObject(2726,524.0000000,-1846.1999512,777.0999756,0.0000000,0.0000000,0.0000000); //object(lm_striplamp) (1)
  168.     CreateDynamicObject(2726,523.9000244,-1851.0999756,777.0999756,0.0000000,0.0000000,0.0000000); //object(lm_striplamp) (2)
  169.     CreateDynamicObject(2726,524.0000000,-1855.9000244,777.0999756,0.0000000,0.0000000,0.0000000); //object(lm_striplamp) (3)
  170.     CreateDynamicObject(2726,520.0000000,-1855.6999512,777.0999756,0.0000000,0.0000000,0.0000000); //object(lm_striplamp) (4)
  171.     CreateDynamicObject(2726,520.0999756,-1845.8000488,777.0999756,0.0000000,0.0000000,0.0000000); //object(lm_striplamp) (5)
  172.     CreateDynamicObject(2726,520.0000000,-1850.5996094,777.0999756,0.0000000,0.0000000,0.0000000); //object(lm_striplamp) (6)
  173.     CreateDynamicObject(2281,519.5999756,-1858.3000488,777.7000122,0.0000000,0.0000000,86.0000000); //object(frame_thick_5) (1)
  174.     CreateDynamicObject(2280,519.5999756,-1853.1999512,777.5000000,0.0000000,0.0000000,90.0000000); //object(frame_thick_1) (1)
  175.     CreateDynamicObject(2279,519.5999756,-1848.1999512,777.7000122,0.0000000,0.0000000,90.0000000); //object(frame_thick_6) (1)
  176.     CreateDynamicObject(2275,519.5999756,-1843.1999512,777.5999756,0.0000000,0.0000000,90.0000000); //object(frame_fab_4) (1)
  177.     CreateDynamicObject(2273,524.2999878,-1858.4000244,777.7000122,0.0000000,0.0000000,270.0000000); //object(frame_fab_1) (1)
  178.     CreateDynamicObject(2267,524.7000122,-1853.5000000,778.0999756,0.0000000,0.0000000,269.9999695); //object(frame_wood_3) (1)
  179.     CreateDynamicObject(2265,524.2999878,-1848.6999512,777.7999878,0.0000000,0.0000000,270.0000000); //object(frame_slim_6) (1)
  180.     CreateDynamicObject(1518,522.0000000,-1859.3000488,777.0999756,0.0000000,0.0000000,180.0000000); //object(dyn_tv_2) (1)
  181.     CreateDynamicObject(2111,522.0000000,-1859.6999512,776.2999878,0.0000000,0.0000000,0.0000000); //object(low_dinning_5) (7)
  182.     CreateDynamicObject(1736,522.0000000,-1859.4000244,778.0999756,0.0000000,0.0000000,180.0000000); //object(cj_stags_head) (1)
  183.     CreateDynamicObject(18459,524.8994141,-1848.8994141,777.5999756,0.0000000,0.0000000,179.9945068); //object(cs_detrok07) (15)
  184.     CreateDynamicObject(9603,538.2999878,-1850.8000488,777.5999756,0.0000000,0.0000000,0.0000000); //object(road_16_sfw) (4)
  185.     CreateDynamicObject(18459,538.2999878,-1857.1999512,777.5999756,0.0000000,0.0000000,179.9945068); //object(cs_detrok07) (16)
  186.     CreateDynamicObject(2357,531.5000000,-1856.0999756,776.2999878,0.0000000,0.0000000,0.0000000); //object(dunc_dinning) (5)
  187.     CreateDynamicObject(2357,531.5000000,-1854.8000488,776.2999878,0.0000000,0.0000000,0.0000000); //object(dunc_dinning) (6)
  188.     CreateDynamicObject(1720,533.2000122,-1853.9000244,775.9000244,0.0000000,0.0000000,0.0000000); //object(rest_chair) (1)
  189.     CreateDynamicObject(1720,532.4000244,-1853.9000244,775.9000244,0.0000000,0.0000000,0.0000000); //object(rest_chair) (2)
  190.     CreateDynamicObject(1720,531.5999756,-1853.9000244,775.9000244,0.0000000,0.0000000,0.0000000); //object(rest_chair) (3)
  191.     CreateDynamicObject(1720,530.7999878,-1853.9000244,775.9000244,0.0000000,0.0000000,0.0000000); //object(rest_chair) (4)
  192.     CreateDynamicObject(1720,530.0000000,-1853.9000244,775.9000244,0.0000000,0.0000000,0.0000000); //object(rest_chair) (5)
  193.     CreateDynamicObject(1720,529.0000000,-1854.5999756,775.9000244,0.0000000,0.0000000,90.0000000); //object(rest_chair) (6)
  194.     CreateDynamicObject(1720,529.0000000,-1855.5000000,775.9000244,0.0000000,0.0000000,90.0000000); //object(rest_chair) (7)
  195.     CreateDynamicObject(1720,529.0000000,-1856.4000244,775.9000244,0.0000000,0.0000000,90.0000000); //object(rest_chair) (8)
  196.     CreateDynamicObject(1720,529.7000122,-1857.0999756,775.9000244,0.0000000,0.0000000,180.0000000); //object(rest_chair) (9)
  197.     CreateDynamicObject(1720,530.5999756,-1857.0999756,775.9000244,0.0000000,0.0000000,179.9945068); //object(rest_chair) (10)
  198.     CreateDynamicObject(1720,531.4000244,-1857.0999756,775.9000244,0.0000000,0.0000000,179.9945068); //object(rest_chair) (11)
  199.     CreateDynamicObject(1720,532.2999878,-1857.0999756,775.9000244,0.0000000,0.0000000,179.9945068); //object(rest_chair) (12)
  200.     CreateDynamicObject(1720,533.2000122,-1857.0999756,775.9000244,0.0000000,0.0000000,179.9945068); //object(rest_chair) (13)
  201.     CreateDynamicObject(1720,534.0999756,-1856.4000244,775.9000244,0.0000000,0.0000000,269.9945068); //object(rest_chair) (14)
  202.     CreateDynamicObject(1720,534.0999756,-1855.4000244,775.9000244,0.0000000,0.0000000,269.9890137); //object(rest_chair) (15)
  203.     CreateDynamicObject(1720,534.0999756,-1854.4000244,775.9000244,0.0000000,0.0000000,269.9890137); //object(rest_chair) (17)
  204.     CreateDynamicObject(16007,530.4000244,-1841.0000000,776.7000122,88.0000000,0.0000000,0.0000000); //object(desn2_cn2blok1) (1)
  205.     CreateDynamicObject(16006,528.9000244,-1841.0000000,776.7000122,88.0000000,0.0000000,0.0000000); //object(ros_townhall) (1)
  206.     CreateDynamicObject(16005,530.4000244,-1841.0000000,778.0999756,88.0000000,0.0000000,0.0000000); //object(desn2_stwnblok2) (1)
  207.     CreateDynamicObject(16004,528.9000244,-1841.0000000,778.0999756,88.0000000,0.0000000,0.0000000); //object(des_tepeoff) (1)
  208.     CreateDynamicObject(1824,535.4000244,-1843.3000488,776.4000244,0.0000000,0.0000000,0.0000000); //object(craps_table) (1)
  209.     CreateDynamicObject(1824,535.4000244,-1846.8000488,776.4000244,0.0000000,0.0000000,0.0000000); //object(craps_table) (2)
  210.     CreateDynamicObject(2964,530.7999878,-1846.5999756,775.9000244,0.0000000,0.0000000,0.0000000); //object(k_pooltablesm) (1)
  211.     CreateDynamicObject(2964,530.7999878,-1843.4000244,775.9000244,0.0000000,0.0000000,0.0000000); //object(k_pooltablesm) (2)
  212.     CreateDynamicObject(2405,538.7999878,-1841.0000000,777.0999756,0.0000000,0.0000000,0.0000000); //object(cj_surf_board2) (1)
  213.     CreateDynamicObject(2405,539.7000122,-1841.0000000,777.0999756,0.0000000,0.0000000,0.0000000); //object(cj_surf_board2) (2)
  214.     CreateDynamicObject(2405,540.5999756,-1841.0000000,777.0999756,0.0000000,0.0000000,0.0000000); //object(cj_surf_board2) (3)
  215.     CreateDynamicObject(2405,541.4000244,-1841.0000000,777.0999756,0.0000000,0.0000000,0.0000000); //object(cj_surf_board2) (4)
  216.     CreateDynamicObject(2405,542.2000122,-1841.0000000,777.0999756,0.0000000,0.0000000,0.0000000); //object(cj_surf_board2) (5)
  217.     CreateDynamicObject(2406,541.9000244,-1859.5999756,777.0999756,0.0000000,0.0000000,180.0000000); //object(cj_surf_board3) (1)
  218.     CreateDynamicObject(2406,541.0999756,-1859.6999512,777.0999756,0.0000000,0.0000000,179.9945068); //object(cj_surf_board3) (2)
  219.     CreateDynamicObject(2406,540.0999756,-1859.6999512,777.0999756,0.0000000,0.0000000,179.9945068); //object(cj_surf_board3) (3)
  220.     CreateDynamicObject(2406,539.2000122,-1859.6999512,777.0999756,0.0000000,0.0000000,179.9945068); //object(cj_surf_board3) (4)
  221.     return 1;
  222. }
  223.  
  224. public OnGameModeExit()
  225. {
  226.     return 1;
  227. }
  228.  
  229. public OnPlayerRequestClass(playerid, classid)
  230. {
  231.     if(GetPVarInt(playerid,"logged") == 0)
  232.     {
  233.         ver[playerid] = 0;
  234.         if(mysql_CheckAccount(playerid) == 1)
  235.         {
  236.             new strlog[250];
  237.             format(strlog,sizeof(strlog),"{FEFEFE}Herzlich Willkommen zurück {16A63E}%s\n{FEFEFE}Dein Account wurde in der Datenbank {16A63E}gefunden{FEFEFE}\nBitte logge dich nun ein !",SpielerName(playerid));
  238.             ShowPlayerDialog(playerid,D_LOGIN,DIALOG_STYLE_PASSWORD,"Login-Vorgang",strlog,"Login","Abbrechen");
  239.         }
  240.         else if(mysql_CheckAccount(playerid) == 0)
  241.         {
  242.             new strreg[250];
  243.             format(strreg,sizeof(strreg),"{FEFEFE}Herzlich Willkommen am Server, {16A63E}%s{FEFEFE}\nDein Account wurde in der Datenbank {16A63E}nicht gefunden {FEFEFE}!\nBitte registriere dich nun !",SpielerName(playerid));
  244.             ShowPlayerDialog(playerid,D_REGISTER,DIALOG_STYLE_PASSWORD,"Register-Vorgang",strreg,"Register","Abbrechen");
  245.         }
  246.     }
  247.     return 1;
  248. }
  249.  
  250. public OnPlayerConnect(playerid)
  251. {
  252.     return 1;
  253. }
  254.  
  255. public OnPlayerDisconnect(playerid, reason)
  256. {
  257.     SpielerSpeichern(playerid);
  258.     return 1;
  259. }
  260.  
  261. public OnPlayerSpawn(playerid)
  262. {
  263.     /*
  264.         Beispiel Für Laden an Pos :
  265.        
  266.         SetPlayerPosF ( Ist mein eigener Stock )
  267.         SetPlayerPosF(playerid,PlayerInfo[playerid][pX],PlayerInfo[playerid][pY],PlayerInfo[playerid][pZ],PlayerInfo[playerid][pA]);
  268.     */
  269.     if(PlayerInfo[playerid][pFrak] == 1)
  270.     {
  271.         ShowPlayerDialog(playerid,D_POL,DIALOG_STYLE_LIST,"Department - Wahl","Los Santos Police Dept.\nSan Fierro Police Dept.\nLas Venturas Police Dept.","Spawn","Abbrechen");
  272.         SetPlayerColor(playerid,0x007DFF22);
  273.     }
  274.     else if(PlayerInfo[playerid][pFrak] == 2)
  275.     {
  276.         ShowPlayerDialog(playerid,D_POL,DIALOG_STYLE_LIST,"Department - Wahl","Los Santos Police Dept.\nSan Fierro Police Dept.\nLas Venturas Police Dept.","Spawn","Abbrechen");
  277.         SetPlayerColor(playerid,0x000AFF22);
  278.     }
  279.     else if(PlayerInfo[playerid][pFrak] == 3)
  280.     {
  281.         SetPlayerColor(playerid,0xFF004122);
  282.     }
  283.     else if(PlayerInfo[playerid][pFrak] == 4)
  284.     {
  285.         SetPlayerColor(playerid,0x00FFFF22);
  286.     }
  287.     else if(PlayerInfo[playerid][pFrak] == 5)
  288.     {
  289.         SetPlayerColor(playerid,0xFF820022);
  290.     }
  291.     else if(PlayerInfo[playerid][pFrak] == 6)
  292.     {
  293.         SetPlayerColor(playerid,0x18FF0022);
  294.     }
  295.     else if(PlayerInfo[playerid][pFrak] == 7)
  296.     {
  297.         SetPlayerColor(playerid,0x8400FF22);
  298.     }
  299.     else if(PlayerInfo[playerid][pFrak] == 8)
  300.     {
  301.         SetPlayerColor(playerid,0x3C3C3C22);
  302.     }
  303.     else if(PlayerInfo[playerid][pFrak] == 9)
  304.     {
  305.         SetPlayerColor(playerid,0x205E4F22);
  306.     }
  307.     else if(PlayerInfo[playerid][pFrak] == 10)
  308.     {
  309.         SetPlayerColor(playerid,0xD7FF0022);
  310.     }
  311.     else if(PlayerInfo[playerid][pFrak] == 11)
  312.     {
  313.         SetPlayerColor(playerid,0x0F000022);
  314.     }
  315.     else
  316.     {
  317.         SetPlayerPosF(playerid,534.2451,-1813.1976,6.5713,267.9210);
  318.         SetPlayerColor(playerid,0xD2D2D222);
  319.     }
  320.     return 1;
  321. }
  322.  
  323. public OnPlayerDeath(playerid, killerid, reason)
  324. {
  325.     return 1;
  326. }
  327.  
  328. public OnVehicleSpawn(vehicleid)
  329. {
  330.     return 1;
  331. }
  332.  
  333. public OnVehicleDeath(vehicleid, killerid)
  334. {
  335.     return 1;
  336. }
  337.  
  338. public OnPlayerText(playerid, text[])
  339. {
  340.     new sendername[32],string[128];
  341.     GetPlayerName(playerid,sendername,sizeof(sendername));
  342.     format(string, sizeof(string),"%s sagt: %s",sendername,text);
  343.     SetPlayerChatBubble(playerid,text,C_ROT,15,5);
  344.     return 0;
  345. }
  346.  
  347. //============ [ OCMD ] ==============//
  348.  
  349. ocmd:makeadmin(playerid,params[])
  350. {
  351.     if(PlayerInfo[playerid][pAdmin] == 5 || IsPlayerAdmin(playerid))
  352.     {
  353.         new pID,rang;
  354.         if(sscanf(params,"ui",pID,rang))return SendClientMessage(playerid,C_GELB,"Info : /makeadmin [Name/ID] [Rang]");
  355.         if(rang>0||rang<5)return SendClientMessage(playerid,C_ROT,"Es gibt nur die Ränge 0 - 5!");
  356.         {
  357.             PlayerInfo[pID][pAdmin] = rang;
  358.         }
  359.     }
  360.     return 1;
  361. }
  362.  
  363. ocmd:makeleader(playerid,params[])
  364. {
  365.     if(PlayerInfo[playerid][pAdmin] == 4)
  366.     {
  367.         new pID,rang;
  368.         if(sscanf(params,"ui",pID,rang))return SendClientMessage(playerid,C_GELB,"Info : /makeleader [Name/ID] [FrakID] || (Liste der Fraktionen : /fliste");
  369.         if(rang>0||rang<11)return SendClientMessage(playerid,C_ROT,"Es gibt derzeit nur 0-11 Fraktionen");
  370.         {
  371.             PlayerInfo[pID][pFrak] = rang;
  372.             PlayerInfo[pID][pRang] = 6;
  373.             SpawnPlayer(playerid);
  374.         }
  375.     }
  376.     return 1;
  377. }
  378. //====================================//
  379. public OnPlayerCommandText(playerid, cmdtext[])
  380. {
  381.     if(GetPVarInt(playerid,"logged") == 1)
  382.     {
  383.         if(strcmp(cmdtext,"/help",true) == 0 || strcmp(cmdtext,"/hilfe",true) == 0)
  384.         {
  385.             new strh[200];
  386.             format(strh,sizeof(strh),"- /fliste || Um die Fraktionen zu sehen");
  387.             format(strh,sizeof(strh),"%s",strh);
  388.             format(strh,sizeof(strh),"%s",strh);
  389.             format(strh,sizeof(strh),"%s",strh);
  390.             format(strh,sizeof(strh),"%s",strh);
  391.             strcat(strh, strh, sizeof(strh));
  392.             ShowPlayerDialog(playerid,D_HELP,DIALOG_STYLE_MSGBOX,"InGame - Befehle",strh,"OK","");
  393.         }
  394.         if(strcmp(cmdtext,"/ahelp",true) == 0)
  395.         {
  396.             if(PlayerInfo[playerid][pAdmin] >= 1)
  397.             {
  398.                 new strah[200];
  399.                 format(strah,sizeof(strah),"----- [ Admin-Level 1 ] -----\n-");
  400.                 format(strah,sizeof(strah),"%s----- [ Admin-Level 2 ] -----\n-",strah);
  401.                 format(strah,sizeof(strah),"%s----- [ Admin-Level 3 ] -----\n-",strah);
  402.                 format(strah,sizeof(strah),"%s----- [ Admin-Level 4 ] -----\n- /makeleader",strah);
  403.                 format(strah,sizeof(strah),"%s----- [ Admin-Level 5 ] -----\n- /makeadmin",strah);
  404.                 strcat(strah, strah, sizeof(strah));
  405.                 ShowPlayerDialog(playerid,D_AHELP,DIALOG_STYLE_MSGBOX,"Admin-Befehle",strah,"OK","");
  406.             }
  407.             else
  408.             {
  409.                 SendClientMessage(playerid,C_ROT,"Du bist kein Admin");
  410.             }
  411.         }
  412.         if(strcmp(cmdtext,"/fliste",true) == 0)
  413.         {
  414.             ShowPlayerDialog(playerid,D_FLISTE,DIALOG_STYLE_MSGBOX,"Fraktion's - Liste (11 Fraktionen)","{0087FF}San Andreas Police Dept.\n{0019FF}Federal Bureau of Investigation\n{FF0055}Sanitäter\n{00FFFF}O-Amt\n{FF9600}News-Reporter\n{05FF00}Grove-Street\n{9700EB}Rollin Height Ballas\n{464646}Triaden\n{004646}Sacra Corona Unita\n{FFF000}Most Wanted\n{0A0A0A}Hitman Agency","Ok","");
  415.         }
  416.     }
  417.     return 1;
  418. }
  419.  
  420. public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
  421. {
  422.     return 1;
  423. }
  424.  
  425. public OnPlayerExitVehicle(playerid, vehicleid)
  426. {
  427.     return 1;
  428. }
  429.  
  430. public OnPlayerStateChange(playerid, newstate, oldstate)
  431. {
  432.     return 1;
  433. }
  434.  
  435. public OnPlayerEnterCheckpoint(playerid)
  436. {
  437.     return 1;
  438. }
  439.  
  440. public OnPlayerLeaveCheckpoint(playerid)
  441. {
  442.     return 1;
  443. }
  444.  
  445. public OnPlayerEnterRaceCheckpoint(playerid)
  446. {
  447.     return 1;
  448. }
  449.  
  450. public OnPlayerLeaveRaceCheckpoint(playerid)
  451. {
  452.     return 1;
  453. }
  454.  
  455. public OnRconCommand(cmd[])
  456. {
  457.     return 1;
  458. }
  459.  
  460. public OnPlayerRequestSpawn(playerid)
  461. {
  462.     return 1;
  463. }
  464.  
  465. public OnObjectMoved(objectid)
  466. {
  467.     return 1;
  468. }
  469.  
  470. public OnPlayerObjectMoved(playerid, objectid)
  471. {
  472.     return 1;
  473. }
  474.  
  475. public OnPlayerPickUpPickup(playerid, pickupid)
  476. {
  477.     if(pickupid == zivent)
  478.     {
  479.         GameTextForPlayer(playerid,"Drücke Enter / F",2000,1);
  480.     }
  481.     if(pickupid == zivext)
  482.     {
  483.         GameTextForPlayer(playerid,"Drücke Enter / F",2000,1);
  484.     }
  485.     return 1;
  486. }
  487.  
  488. public OnVehicleMod(playerid, vehicleid, componentid)
  489. {
  490.     return 1;
  491. }
  492.  
  493. public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
  494. {
  495.     return 1;
  496. }
  497.  
  498. public OnVehicleRespray(playerid, vehicleid, color1, color2)
  499. {
  500.     return 1;
  501. }
  502.  
  503. public OnPlayerSelectedMenuRow(playerid, row)
  504. {
  505.     return 1;
  506. }
  507.  
  508. public OnPlayerExitedMenu(playerid)
  509. {
  510.     return 1;
  511. }
  512.  
  513. public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
  514. {
  515.     return 1;
  516. }
  517.  
  518. public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
  519. {
  520.     if(newkeys == KEY_SECONDARY_ATTACK)
  521.     {
  522.         if(IsPlayerInRangeOfPoint(playerid,3.0,534.2451,-1813.1976,6.5713)) //=== Zivi-Spawn
  523.         {
  524.             SetPlayerPos(playerid,541.40002441406,-1850.9000244141,776.90002441406);
  525.             FreezePlayer(playerid);
  526.             SetTimerEx("UnFreezeing",3000,0,"i",playerid);
  527.         }
  528.         else if(IsPlayerInRangeOfPoint(playerid,3.0,541.40002441406,-1850.9000244141,776.90002441406)) //== Zivi Spawn
  529.         {
  530.             SetPlayerPos(playerid,534.2451,-1813.1976,6.5713);
  531.             FreezePlayer(playerid);
  532.             SetTimerEx("UnFreezeing",2000,0,"i",playerid);
  533.         }
  534.     }
  535.     return 1;
  536. }
  537.  
  538. public OnRconLoginAttempt(ip[], password[], success)
  539. {
  540.     return 1;
  541. }
  542.  
  543. public OnPlayerUpdate(playerid)
  544. {
  545.     return 1;
  546. }
  547.  
  548. public OnPlayerStreamIn(playerid, forplayerid)
  549. {
  550.     return 1;
  551. }
  552.  
  553. public OnPlayerStreamOut(playerid, forplayerid)
  554. {
  555.     return 1;
  556. }
  557.  
  558. public OnVehicleStreamIn(vehicleid, forplayerid)
  559. {
  560.     return 1;
  561. }
  562.  
  563. public OnVehicleStreamOut(vehicleid, forplayerid)
  564. {
  565.     return 1;
  566. }
  567.  
  568. public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
  569. {
  570.     if(dialogid == D_POL)
  571.     {
  572.         if(response)
  573.         {
  574.             if(listitem == 0) /// LSPD
  575.             {
  576.                 SetPlayerInterior(playerid,6);
  577.                 SetPlayerPos(playerid,246.783996,63.900199,1003.640625);
  578.             }
  579.             if(listitem == 1) //SFPD
  580.             {
  581.                 SetPlayerInterior(playerid,10);
  582.                 SetPlayerPos(playerid,246.375991,109.245994,1003.218750);
  583.             }
  584.             if(listitem == 3) //LVPD
  585.             {
  586.                 SetPlayerInterior(playerid,6);
  587.                 SetPlayerPos(playerid,288.745971,169.350997,1007.171875);
  588.             }
  589.         }
  590.         else
  591.         {
  592.             ShowPlayerDialog(playerid,D_POL,DIALOG_STYLE_LIST,"Department - Wahl","Los Santos Police Dept.\nSan Fierro Police Dept.\nLas Venturas Police Dept.","Spawn","Abbrechen");
  593.         }
  594.     }
  595.     if(dialogid == D_REGISTER)
  596.     {
  597.         if(response)
  598.         {
  599.             if(strlen(inputtext) == 0)
  600.             {
  601.                 ShowPlayerDialog(playerid,D_REGISTER,DIALOG_STYLE_INPUT,"Register","Dein angegebenes Passwort war zu kurz !\n Bitte gib ein neues ein :","Register","Abbrechen");
  602.                 return 1;
  603.             }
  604.             else
  605.             {
  606.                 CreateAccount(playerid, inputtext);
  607.                 SetPVarInt(playerid,"logged",1);
  608.                 SpawnPlayer(playerid);
  609.                 return 1;
  610.             }
  611.         }
  612.         else
  613.         {
  614.             Kick(playerid);
  615.         }
  616.     }
  617.     if(dialogid == D_LOGIN)
  618.     {
  619.         if(response)
  620.         {
  621.             if(strlen(inputtext) == 0)
  622.             {
  623.                 if(ver[playerid] == 0)
  624.                 {
  625.                     ShowPlayerDialog(playerid,D_LOGIN,DIALOG_STYLE_PASSWORD,"Login","{FEFEFE}Dein Eingegebenes Passwort war {FF0000}FLASCH {FEFEFE}!\n Bitte versuche es Erneut\n {FF0000}Noch 3 Versuche","Login","Abbrechen");
  626.                 }
  627.                 else if(ver[playerid] == 1)
  628.                 {
  629.                     ShowPlayerDialog(playerid,D_LOGIN,DIALOG_STYLE_PASSWORD,"Login","{FEFEFE}Dein Eingegebenes Passwort war {FF0000}FLASCH {FEFEFE}!\n Bitte versuche es Erneut\n {FF0000}Noch 3 Versuche","Login","Abbrechen");
  630.                 }
  631.                 else if(ver[playerid] == 2)
  632.                 {
  633.                     ShowPlayerDialog(playerid,D_LOGIN,DIALOG_STYLE_PASSWORD,"Login","{FEFEFE}Dein Eingegebenes Passwort war {FF0000}FLASCH {FEFEFE}!\n Bitte versuche es Erneut\n {FF0000}Noch 3 Versuche","Login","Abbrechen");
  634.                 }
  635.                 else if(ver[playerid] == 3)
  636.                 {
  637.                     SendClientMessage(playerid,C_ROT,"Da du 3 mal das Passwort falsch angegeben hast, wurdest du gekickt !");
  638.                     Kick(playerid);
  639.                 }
  640.                 return 1;
  641.             }
  642.             else
  643.             {
  644.                 if(!strcmp(inputtext, mysql_ReturnPasswort(SpielerName(playerid)), true))
  645.                 {
  646.                     SetPVarInt(playerid,"logged",1);
  647.                     SpielerLaden(playerid);
  648.                     SpawnPlayer(playerid);
  649.                     return 1;
  650.                 }
  651.                 else
  652.                 {
  653.                     if(ver[playerid] == 0)
  654.                     {
  655.                         ShowPlayerDialog(playerid,D_LOGIN,DIALOG_STYLE_PASSWORD,"Login","{FEFEFE}Dein Eingegebenes Passwort war {FF0000}FLASCH {FEFEFE}!\n Bitte versuche es Erneut\n {FF0000}Noch 3 Versuche","Login","Abbrechen");
  656.                     }
  657.                     else if(ver[playerid] == 1)
  658.                     {
  659.                         ShowPlayerDialog(playerid,D_LOGIN,DIALOG_STYLE_PASSWORD,"Login","{FEFEFE}Dein Eingegebenes Passwort war {FF0000}FLASCH {FEFEFE}!\n Bitte versuche es Erneut\n {FF0000}Noch 3 Versuche","Login","Abbrechen");
  660.                     }
  661.                     else if(ver[playerid] == 2)
  662.                     {
  663.                         ShowPlayerDialog(playerid,D_LOGIN,DIALOG_STYLE_PASSWORD,"Login","{FEFEFE}Dein Eingegebenes Passwort war {FF0000}FLASCH {FEFEFE}!\n Bitte versuche es Erneut\n {FF0000}Noch 3 Versuche","Login","Abbrechen");
  664.                     }
  665.                     else if(ver[playerid] == 3)
  666.                     {
  667.                         SendClientMessage(playerid,C_ROT,"Da du 3 mal das Passwort falsch angegeben hast, wurdest du gekickt !");
  668.                         Kick(playerid);
  669.                     }
  670.                     return 1;
  671.                 }
  672.             }
  673.         }
  674.         else
  675.         {
  676.             Kick(playerid);
  677.         }
  678.     }
  679.     return 1;
  680. }
  681.  
  682. public OnPlayerClickPlayer(playerid, clickedplayerid, source)
  683. {
  684.     return 1;
  685. }
  686. //============ [ Eigene Public's ] ========//
  687. forward UnFreezeing(playerid);
  688. public UnFreezeing(playerid)
  689. {
  690.     UnFreezePlayer(playerid);
  691. }
  692. //============ [STOCK's] ===============//
  693. stock sscanf(string[], format[], {Float,_}:...)
  694. {
  695.     #if defined isnull
  696.         if (isnull(string))
  697.     #else
  698.         if (string[0] == 0 || (string[0] == 1 && string[1] == 0))
  699.     #endif
  700.         {
  701.             return format[0];
  702.         }
  703.     #pragma tabsize 4
  704.     new
  705.         formatPos = 0,
  706.         stringPos = 0,
  707.         paramPos = 2,
  708.         paramCount = numargs(),
  709.         delim = ' ';
  710.     while (string[stringPos] && string[stringPos] <= ' ')
  711.     {
  712.         stringPos++;
  713.     }
  714.     while (paramPos < paramCount && string[stringPos])
  715.     {
  716.         switch (format[formatPos++])
  717.         {
  718.             case '\0':
  719.             {
  720.                 return 0;
  721.             }
  722.             case 'i', 'd':
  723.             {
  724.                 new
  725.                     neg = 1,
  726.                     num = 0,
  727.                     ch = string[stringPos];
  728.                 if (ch == '-')
  729.                 {
  730.                     neg = -1;
  731.                     ch = string[++stringPos];
  732.                 }
  733.                 do
  734.                 {
  735.                     stringPos++;
  736.                     if ('0' <= ch <= '9')
  737.                     {
  738.                         num = (num * 10) + (ch - '0');
  739.                     }
  740.                     else
  741.                     {
  742.                         return -1;
  743.                     }
  744.                 }
  745.                 while ((ch = string[stringPos]) > ' ' && ch != delim);
  746.                 setarg(paramPos, 0, num * neg);
  747.             }
  748.             case 'h', 'x':
  749.             {
  750.                 new
  751.                     num = 0,
  752.                     ch = string[stringPos];
  753.                 do
  754.                 {
  755.                     stringPos++;
  756.                     switch (ch)
  757.                     {
  758.                         case 'x', 'X':
  759.                         {
  760.                             num = 0;
  761.                             continue;
  762.                         }
  763.                         case '0' .. '9':
  764.                         {
  765.                             num = (num << 4) | (ch - '0');
  766.                         }
  767.                         case 'a' .. 'f':
  768.                         {
  769.                             num = (num << 4) | (ch - ('a' - 10));
  770.                         }
  771.                         case 'A' .. 'F':
  772.                         {
  773.                             num = (num << 4) | (ch - ('A' - 10));
  774.                         }
  775.                         default:
  776.                         {
  777.                             return -1;
  778.                         }
  779.                     }
  780.                 }
  781.                 while ((ch = string[stringPos]) > ' ' && ch != delim);
  782.                 setarg(paramPos, 0, num);
  783.             }
  784.             case 'c':
  785.             {
  786.                 setarg(paramPos, 0, string[stringPos++]);
  787.             }
  788.             case 'f':
  789.             {
  790.  
  791.                 new changestr[16], changepos = 0, strpos = stringPos;
  792.                 while(changepos < 16 && string[strpos] && string[strpos] != delim)
  793.                 {
  794.                     changestr[changepos++] = string[strpos++];
  795.                     }
  796.                 changestr[changepos] = '\0';
  797.                 setarg(paramPos,0,_:floatstr(changestr));
  798.             }
  799.             case 'p':
  800.             {
  801.                 delim = format[formatPos++];
  802.                 continue;
  803.             }
  804.             case '\'':
  805.             {
  806.                 new
  807.                     end = formatPos - 1,
  808.                     ch;
  809.                 while ((ch = format[++end]) && ch != '\'') {}
  810.                 if (!ch)
  811.                 {
  812.                     return -1;
  813.                 }
  814.                 format[end] = '\0';
  815.                 if ((ch = strfind(string, format[formatPos], false, stringPos)) == -1)
  816.                 {
  817.                     if (format[end + 1])
  818.                     {
  819.                         return -1;
  820.                     }
  821.                     return 0;
  822.                 }
  823.                 format[end] = '\'';
  824.                 stringPos = ch + (end - formatPos);
  825.                 formatPos = end + 1;
  826.             }
  827.             case 'u':
  828.             {
  829.                 new
  830.                     end = stringPos - 1,
  831.                     id = 0,
  832.                     bool:num = true,
  833.                     ch;
  834.                 while ((ch = string[++end]) && ch != delim)
  835.                 {
  836.                     if (num)
  837.                     {
  838.                         if ('0' <= ch <= '9')
  839.                         {
  840.                             id = (id * 10) + (ch - '0');
  841.                         }
  842.                         else
  843.                         {
  844.                             num = false;
  845.                         }
  846.                     }
  847.                 }
  848.                 if (num && IsPlayerConnected(id))
  849.                 {
  850.                     setarg(paramPos, 0, id);
  851.                 }
  852.                 else
  853.                 {
  854.                     #if !defined foreach
  855.                         #define foreach(%1,%2) for (new %2 = 0; %2 < MAX_PLAYERS; %2++) if (IsPlayerConnected(%2))
  856.                         #define __SSCANF_FOREACH__
  857.                     #endif
  858.                     string[end] = '\0';
  859.                     num = false;
  860.                     new
  861.                         name[MAX_PLAYER_NAME];
  862.                     id = end - stringPos;
  863.                     foreach (Player, playerid)
  864.                     {
  865.                         GetPlayerName(playerid, name, sizeof (name));
  866.                         if (!strcmp(name, string[stringPos], true, id))
  867.                         {
  868.                             setarg(paramPos, 0, playerid);
  869.                             num = true;
  870.                             break;
  871.                         }
  872.                     }
  873.                     if (!num)
  874.                     {
  875.                         setarg(paramPos, 0, INVALID_PLAYER_ID);
  876.                     }
  877.                     string[end] = ch;
  878.                     #if defined __SSCANF_FOREACH__
  879.                         #undef foreach
  880.                         #undef __SSCANF_FOREACH__
  881.                     #endif
  882.                 }
  883.                 stringPos = end;
  884.             }
  885.             case 's', 'z':
  886.             {
  887.                 new
  888.                     i = 0,
  889.                     ch;
  890.                 if (format[formatPos])
  891.                 {
  892.                     while ((ch = string[stringPos++]) && ch != delim)
  893.                     {
  894.                         setarg(paramPos, i++, ch);
  895.                     }
  896.                     if (!i)
  897.                     {
  898.                         return -1;
  899.                     }
  900.                 }
  901.                 else
  902.                 {
  903.                     while ((ch = string[stringPos++]))
  904.                     {
  905.                         setarg(paramPos, i++, ch);
  906.                     }
  907.                 }
  908.                 stringPos--;
  909.                 setarg(paramPos, i, '\0');
  910.             }
  911.             default:
  912.             {
  913.                 continue;
  914.             }
  915.         }
  916.         while (string[stringPos] && string[stringPos] != delim && string[stringPos] > ' ')
  917.         {
  918.             stringPos++;
  919.         }
  920.         while (string[stringPos] && (string[stringPos] == delim || string[stringPos] <= ' '))
  921.         {
  922.             stringPos++;
  923.         }
  924.         paramPos++;
  925.     }
  926.     do
  927.     {
  928.         if ((delim = format[formatPos++]) > ' ')
  929.         {
  930.             if (delim == '\'')
  931.             {
  932.                 while ((delim = format[formatPos++]) && delim != '\'') {}
  933.             }
  934.             else if (delim != 'z')
  935.             {
  936.                 return delim;
  937.             }
  938.         }
  939.     }
  940.     while (delim > ' ');
  941.     return 0;
  942. }
  943.  
  944. stock SpielerName(playerid)
  945. {
  946.     new name[MAX_PLAYER_NAME];
  947.     GetPlayerName(playerid,name,sizeof(name));
  948.     return name;
  949. }
  950. stock mysql_CheckAccount(playerid)
  951. {
  952.     new Query[128],Name[MAX_PLAYER_NAME],count;
  953.     GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
  954.     mysql_real_escape_string(Name, Name);
  955.     format(Query, sizeof(Query), "SELECT * FROM `accounts` WHERE `Name` = '%s'", Name);
  956.     mysql_query(Query);
  957.     mysql_store_result();
  958.     count = mysql_num_rows();
  959.     mysql_free_result();
  960.     return count;
  961. }
  962.  
  963. stock CreateAccount(playerid, pass[])
  964. {
  965.     new query[256],Name[MAX_PLAYER_NAME];
  966.     GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
  967.     mysql_real_escape_string(Name,Name);
  968.     mysql_real_escape_string(pass,pass);
  969.     format(query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Passwort`) VALUES ('%s', '%s')", Name, pass);
  970.     mysql_query(query);
  971.     return true;
  972. }
  973.  
  974. stock mysql_ReturnPasswort(Name[])
  975. {
  976.     new query[130], Get[130];
  977.     mysql_real_escape_string(Name, Name);
  978.     format(query, 128, "SELECT `passwort` FROM `accounts` WHERE `Name` = '%s'", Name);
  979.     mysql_query(query);
  980.     mysql_store_result();
  981.     mysql_fetch_row(Get);
  982.     mysql_free_result();
  983.     return Get;
  984. }
  985. stock Connect_To_Database()
  986. {
  987.     mysql_connect(my_Host,my_User, my_Data, my_Pass);
  988.     if(mysql_ping() == 1)
  989.     {
  990.         print("||>>|| Die Verbindung zu Mysql wurde hergestellt ||<<||!");
  991.         return true;
  992.     }
  993.     else
  994.     {
  995.         print("||>>|| Die Verbindung zu Mysql wurde nicht hergestellt ||<<||");
  996.         mysql_connect(my_Host,my_User, my_Data, my_Pass);
  997.         if(mysql_ping() == 1)
  998.         {
  999.             print("||>>|| Die Verbindung zu Mysql wurde beim 2mal hergestellt ||<<||");
  1000.             return true;
  1001.         }
  1002.         else
  1003.         {
  1004.             print("||>>|| Die Verbindung zu Mysql wurde nicht hergestellt (Server-Shutdown)||<<||");
  1005.             SendRconCommand("exit");
  1006.             return true;
  1007.         }
  1008.     }
  1009. }
  1010.  
  1011. stock SpielerLaden(playerid)
  1012. {
  1013.     if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
  1014.     {
  1015.         PlayerInfo[playerid][pLevel] = mysql_GetInt("accounts", "Level", "Name", SpielerName(playerid));
  1016.         PlayerInfo[playerid][pAdmin] = mysql_GetInt("accounts", "Admin", "Name", SpielerName(playerid));
  1017.         PlayerInfo[playerid][pGeld] = mysql_GetInt("accounts", "Geld", "Name", SpielerName(playerid));
  1018.         PlayerInfo[playerid][pFrak] = mysql_GetInt("accounts", "Frak", "Name", SpielerName(playerid));
  1019.         PlayerInfo[playerid][pRang] = mysql_GetInt("accounts","Frak","Name",SpielerName(playerid));
  1020.         PlayerInfo[playerid][pPerso] = mysql_GetInt("accounts", "Perso", "Name", SpielerName(playerid));
  1021.         PlayerInfo[playerid][pClic] = mysql_GetInt("accounts", "Clic", "Name", SpielerName(playerid));
  1022.         PlayerInfo[playerid][pFlic] = mysql_GetInt("accounts", "Flic", "Name", SpielerName(playerid));
  1023.         PlayerInfo[playerid][pMlic] = mysql_GetInt("accounts", "Mlic", "Name", SpielerName(playerid));
  1024.         PlayerInfo[playerid][pWlic] = mysql_GetInt("accounts", "Wlic", "Name", SpielerName(playerid));
  1025.         PlayerInfo[playerid][pX] = mysql_GetFloat("accounts", "PosX", "Name", SpielerName(playerid));
  1026.         PlayerInfo[playerid][pY] = mysql_GetFloat("accounts", "PosY", "Name", SpielerName(playerid));
  1027.         PlayerInfo[playerid][pZ] = mysql_GetFloat("accounts", "PosZ", "Name", SpielerName(playerid));
  1028.         PlayerInfo[playerid][pA] = mysql_GetFloat("accounts", "PosA", "Name", SpielerName(playerid));
  1029.  
  1030.         SetPlayerScore(playerid,PlayerInfo[playerid][pLevel]);
  1031.         GivePlayerMoney(playerid,PlayerInfo[playerid][pGeld]);
  1032.     }
  1033.     return 1;
  1034. }
  1035.  
  1036. stock SpielerSpeichern(playerid)
  1037. {
  1038.     if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
  1039.     {
  1040.         if(GetPVarInt(playerid,"logged") == 1)
  1041.         {
  1042.             new query[200];
  1043.             format(query, sizeof(query), "UPDATE `accounts` SET `Level` = '%d',`Admin` = '%d',`Geld` = '%d',`Frak` = '%d',`Perso` = '%d',`Clic` = '%d',`Flic` = '%d',`Mlic` = '%d',`Wlic` = '%d' WHERE `Name` = '%s'",
  1044.             PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pGeld],PlayerInfo[playerid][pFrak],PlayerInfo[playerid][pPerso],
  1045.             PlayerInfo[playerid][pClic],PlayerInfo[playerid][pFlic],PlayerInfo[playerid][pMlic],PlayerInfo[playerid][pWlic],SpielerName(playerid));
  1046.             mysql_query(query);
  1047.            
  1048.             format(query, sizeof(query), "UPDATE `accounts` SET `PosX` = '%f',`PosY` = '%f',`PosZ` = '%d',`PosA` = '%f',`Rang` = '%d' WHERE `Name` = '%s'",
  1049.             PlayerInfo[playerid][pX],PlayerInfo[playerid][pY],PlayerInfo[playerid][pZ],PlayerInfo[playerid][pA],PlayerInfo[playerid][pRang],SpielerName(playerid));
  1050.             mysql_query(query);
  1051.         }
  1052.     }
  1053.     return 1;
  1054. }
  1055.  
  1056. stock mysql_GetInt(Table[], Field[], Where[], Is[])
  1057. {
  1058.     new query[128];
  1059.     mysql_real_escape_string(Table, Table);
  1060.     mysql_real_escape_string(Field, Field);
  1061.     mysql_real_escape_string(Where, Where);
  1062.     mysql_real_escape_string(Is, Is);
  1063.     format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
  1064.     mysql_query(query);
  1065.     mysql_store_result();
  1066.     new sqlint = mysql_fetch_int();
  1067.     mysql_free_result();
  1068.     return sqlint;
  1069. }
  1070. stock mysql_GetString(Table[], Field[], Where[], Is[])
  1071. {
  1072.     new query[128], Get[128];
  1073.     mysql_real_escape_string(Table, Table);
  1074.     mysql_real_escape_string(Field, Field);
  1075.     mysql_real_escape_string(Where, Where);
  1076.     mysql_real_escape_string(Is, Is);
  1077.     format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
  1078.     mysql_query(query);
  1079.     mysql_store_result();
  1080.     mysql_fetch_row(Get);
  1081.     mysql_free_result();
  1082.     return Get;
  1083. }
  1084. forward Float:mysql_GetFloat(Table[], Field[], Where[], Is[]);
  1085. stock Float:mysql_GetFloat(Table[], Field[], Where[], Is[])
  1086. {
  1087.     new query[128], Float:sqlfloat;
  1088.     mysql_real_escape_string(Table, Table);
  1089.     mysql_real_escape_string(Field, Field);
  1090.     mysql_real_escape_string(Where, Where);
  1091.     mysql_real_escape_string(Is, Is);
  1092.     format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
  1093.     mysql_query(query);
  1094.     mysql_store_result();
  1095.     mysql_fetch_float(sqlfloat);
  1096.     mysql_free_result();
  1097.     return sqlfloat; //Zeile
  1098. }
  1099. stock mysql_SetInt(Table[], Field[], To, Where[], Where2[])
  1100. {
  1101.     new query[128];
  1102.     mysql_real_escape_string(Table, Table);
  1103.     mysql_real_escape_string(Field, Field);
  1104.     mysql_real_escape_string(Where, Where);
  1105.     mysql_real_escape_string(Where2, Where2);
  1106.     format(query, 128, "UPDATE `%s` SET `%s` = '%d' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
  1107.     mysql_query(query);
  1108.     return true;
  1109. }
  1110. stock mysql_SetString(Table[], Field[], To[], Where[], Where2[])
  1111. {
  1112.     new query[128];
  1113.     mysql_real_escape_string(Table, Table);
  1114.     mysql_real_escape_string(Field, Field);
  1115.     mysql_real_escape_string(To, To);
  1116.     mysql_real_escape_string(Where, Where);
  1117.     mysql_real_escape_string(Where2, Where2);
  1118.     format(query, 128, "UPDATE `%s` SET `%s` = '%s' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
  1119.     mysql_query(query);
  1120.     return true;
  1121. }
  1122. stock mysql_SetFloat(Table[], Field[], Float:To, Where[], Where2[])
  1123. {
  1124.     new query[128];
  1125.     mysql_real_escape_string(Table, Table);
  1126.     mysql_real_escape_string(Field, Field);
  1127.     mysql_real_escape_string(Where, Where);
  1128.     mysql_real_escape_string(Where2, Where2);
  1129.     format(query, 128, "UPDATE `%s` SET `%s` = '%f' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
  1130.     mysql_query(query);
  1131.     return true;
  1132. }
  1133.  
  1134. stock SetPlayerPosF(playerid,Float:X,Float:Y,Float:Z,Float:F)
  1135. {
  1136.     SetPlayerPos(playerid,X,Y,Z);
  1137.     SetPlayerFacingAngle(playerid,F);
  1138.     return 1;
  1139. }
  1140. stock FreezePlayer(playerid)
  1141. {
  1142.     TogglePlayerControllable(playerid, false);
  1143.     return 1;
  1144. }
  1145. stock UnFreezePlayer(playerid)
  1146. {
  1147.     TogglePlayerControllable(playerid, true);
  1148.     return 1;
  1149. }
  1150.  
  1151. stock Float:GetDistanceBetweenPlayers(p1,p2){
  1152.     new Float:x1,Float:y1,Float:z1,Float:x2,Float:y2,Float:z2;
  1153.     if(!IsPlayerConnected(p1) || !IsPlayerConnected(p2)){
  1154.         return -1.00;
  1155.     }
  1156.     GetPlayerPos(p1,x1,y1,z1);
  1157.     GetPlayerPos(p2,x2,y2,z2);
  1158.     return floatsqroot(floatpower(floatabs(floatsub(x2,x1)),2)+floatpower(floatabs(floatsub(y2,y1)),2)+floatpower(floatabs(floatsub(z2,z1)),2));
  1159. }
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!