API tools faq
paste
Advertisement
Guest User

Call Of Duty - SAMP by NIKEiD2.0

a guest
Jun 17th, 2012
978
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 38.00 KB | None | 0 0
raw download clone embed print report
  1. #include <a_samp>
  2. #include <a_mysql>
  3.  
  4. #define SQL_HOST   "" //MYSQL-Datenbank HOST IP
  5. #define SQL_USER   "" //MYSQL-Datenbank Benutzer
  6. #define SQL_PASS   "" //MYSQL-Datenbank Benutzerpasswort
  7. #define SQL_DATA   "" //MYSQL-Datenbankname
  8.  
  9. new Text:start0;
  10. new Text:start1;
  11. new Text:start2;
  12. new Text:start3;
  13. new Text:start5;
  14. new Text:start7;
  15. new Text:start8;
  16. new Text:start9;
  17. new Text:start10;
  18. new Text:start11;
  19. new Text:start12;
  20. new Text:start13;
  21. new Text:start14;
  22. new Text:start15;
  23.  
  24. #define ROT 0xFF6347AA
  25. #define BLAU 0x33CCFFAA
  26. #define GRUEN 0x9ACD32AA
  27. #define WEISS 0xFFFFFFAA
  28. #define DIALOG_REGISTER (1)
  29. #define DIALOG_LOGIN (2)
  30. #define DIALOG_WAFFEN 3
  31. #define DIALOG_WAFFENWAHL 4
  32.  
  33. forward SetzteSpawn(playerid);
  34. forward SetzteWaffe(playerid);
  35. forward Timer();
  36. forward CheckTimer();
  37. new TimerKill;
  38. new CheckTimerKill;
  39.  
  40. new TeamA = 0;
  41. new TeamB = 0;
  42. new TeamAPoints = 0;
  43. new TeamBPoints = 0;
  44. new SpielerA[MAX_PLAYERS];
  45. new SpielerB[MAX_PLAYERS];
  46. new Eingeloggt[MAX_PLAYERS];
  47. new RundenZeit = 0;
  48.  
  49. new TeamASultan[1];
  50. new TeamAPatriot[1];
  51. new TeamAWasserwerfer[1];
  52. new TeamAHydra[1];
  53. new TeamBSultan[1];
  54. new TeamBPatriot[1];
  55. new TeamBWasserwerfer[1];
  56. new TeamBHydra[1];
  57.  
  58. new Float:TeamASpawn[8][3] = {
  59. {507.3759,754.7705,10.0446},
  60. {544.5608,743.2770,12.8841},
  61. {584.1591,730.0757,12.0930},
  62. {625.4068,716.3243,11.7393},
  63. {609.9855,753.6337,-14.2165},
  64. {587.5355,764.0435,-15.7258},
  65. {562.6123,773.6474,-17.1855},
  66. {532.3210,786.4099,-20.4322}
  67. };
  68.  
  69. new Float:TeamBSpawn[8][3] = {
  70. {720.2353,984.3275,5.5624},
  71. {687.0422,999.4839,5.5627},
  72. {652.2397,1001.6922,5.5651},
  73. {610.1581,998.7349,3.9524},
  74. {765.6714,959.2229,27.9723},
  75. {754.3467,978.7115,28.3028},
  76. {740.1129,991.9997,28.3732},
  77. {719.6809,1004.4276,28.2773}
  78. };
  79.  
  80. public OnGameModeInit()
  81. {
  82.     Connect_To_Database();
  83.     SetGameModeText("COD - SAMP");
  84.     SetWeather(2);
  85.     UsePlayerPedAnims();
  86.     EnableStuntBonusForAll(false);
  87.     ShowPlayerMarkers(1);
  88.     DisableInteriorEnterExits();
  89.     AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
  90.     TimerKill = SetTimer("Timer", 1000, 1);
  91.     CheckTimerKill = SetTimer("CheckTimer", 1000, 1);
  92.    
  93.     start0 = TextDrawCreate(269.000000, 134.000000, "_");
  94.     TextDrawAlignment(start0, 2);
  95.     TextDrawBackgroundColor(start0, 255);
  96.     TextDrawFont(start0, 1);
  97.     TextDrawLetterSize(start0, 0.500000, 22.299987);
  98.     TextDrawColor(start0, 30);
  99.     TextDrawSetOutline(start0, 0);
  100.     TextDrawSetProportional(start0, 1);
  101.     TextDrawSetShadow(start0, 1);
  102.     TextDrawUseBox(start0, 1);
  103.     TextDrawBoxColor(start0, 80);
  104.     TextDrawTextSize(start0, 0.000000, 787.000000);
  105.  
  106.     start1 = TextDrawCreate(250.000000, -27.000000, "_");
  107.     TextDrawAlignment(start1, 2);
  108.     TextDrawBackgroundColor(start1, 255);
  109.     TextDrawFont(start1, 1);
  110.     TextDrawLetterSize(start1, 0.500000, 17.300004);
  111.     TextDrawColor(start1, -1);
  112.     TextDrawSetOutline(start1, 0);
  113.     TextDrawSetProportional(start1, 1);
  114.     TextDrawSetShadow(start1, 1);
  115.     TextDrawUseBox(start1, 1);
  116.     TextDrawBoxColor(start1, 200);
  117.     TextDrawTextSize(start1, 0.000000, 787.000000);
  118.  
  119.     start2 = TextDrawCreate(250.000000, 341.000000, "_");
  120.     TextDrawAlignment(start2, 2);
  121.     TextDrawBackgroundColor(start2, 255);
  122.     TextDrawFont(start2, 1);
  123.     TextDrawLetterSize(start2, 0.500000, 16.200000);
  124.     TextDrawColor(start2, -1);
  125.     TextDrawSetOutline(start2, 0);
  126.     TextDrawSetProportional(start2, 1);
  127.     TextDrawSetShadow(start2, 1);
  128.     TextDrawUseBox(start2, 1);
  129.     TextDrawBoxColor(start2, 200);
  130.     TextDrawTextSize(start2, 0.000000, 787.000000);
  131.  
  132.     start3 = TextDrawCreate(250.000000, 340.000000, "_");
  133.     TextDrawAlignment(start3, 2);
  134.     TextDrawBackgroundColor(start3, 255);
  135.     TextDrawFont(start3, 1);
  136.     TextDrawLetterSize(start3, 0.500000, -0.500000);
  137.     TextDrawColor(start3, -1);
  138.     TextDrawSetOutline(start3, 0);
  139.     TextDrawSetProportional(start3, 1);
  140.     TextDrawSetShadow(start3, 1);
  141.     TextDrawUseBox(start3, 1);
  142.     TextDrawBoxColor(start3, 848756735);
  143.     TextDrawTextSize(start3, 0.000000, 787.000000);
  144.  
  145.     start5 = TextDrawCreate(250.000000, 134.000000, "_");
  146.     TextDrawAlignment(start5, 2);
  147.     TextDrawBackgroundColor(start5, 255);
  148.     TextDrawFont(start5, 1);
  149.     TextDrawLetterSize(start5, 0.500000, -0.500000);
  150.     TextDrawColor(start5, -1);
  151.     TextDrawSetOutline(start5, 0);
  152.     TextDrawSetProportional(start5, 1);
  153.     TextDrawSetShadow(start5, 1);
  154.     TextDrawUseBox(start5, 1);
  155.     TextDrawBoxColor(start5, 848756735);
  156.     TextDrawTextSize(start5, 0.000000, 787.000000);
  157.  
  158.     start7 = TextDrawCreate(284.000000, 31.000000, "Willkommen");
  159.     TextDrawBackgroundColor(start7, 255);
  160.     TextDrawFont(start7, 3);
  161.     TextDrawLetterSize(start7, 0.529999, 1.900000);
  162.     TextDrawColor(start7, -156);
  163.     TextDrawSetOutline(start7, 0);
  164.     TextDrawSetProportional(start7, 1);
  165.     TextDrawSetShadow(start7, 1);
  166.  
  167.     start8 = TextDrawCreate(325.000000, 51.000000, "AUF DEM");
  168.     TextDrawBackgroundColor(start8, 255);
  169.     TextDrawFont(start8, 2);
  170.     TextDrawLetterSize(start8, 0.440000, 1.700000);
  171.     TextDrawColor(start8, -156);
  172.     TextDrawSetOutline(start8, 0);
  173.     TextDrawSetProportional(start8, 1);
  174.     TextDrawSetShadow(start8, 1);
  175.  
  176.     start9 = TextDrawCreate(246.000000, 73.000000, "CallOfDuty");
  177.     TextDrawBackgroundColor(start9, 255);
  178.     TextDrawFont(start9, 3);
  179.     TextDrawLetterSize(start9, 0.779999, 3.699998);
  180.     TextDrawColor(start9, -1);
  181.     TextDrawSetOutline(start9, 1);
  182.     TextDrawSetProportional(start9, 1);
  183.  
  184.     start10 = TextDrawCreate(79.000000, 103.000000, ".");
  185.     TextDrawBackgroundColor(start10, 255);
  186.     TextDrawFont(start10, 1);
  187.     TextDrawLetterSize(start10, 29.940078, 1.000000);
  188.     TextDrawColor(start10, -1);
  189.     TextDrawSetOutline(start10, 1);
  190.     TextDrawSetProportional(start10, 1);
  191.  
  192.     start11 = TextDrawCreate(281.000000, 109.000000, "SA-MP");
  193.     TextDrawBackgroundColor(start11, 255);
  194.     TextDrawFont(start11, 2);
  195.     TextDrawLetterSize(start11, 0.470000, 1.500000);
  196.     TextDrawColor(start11, 513867775);
  197.     TextDrawSetOutline(start11, 1);
  198.     TextDrawSetProportional(start11, 1);
  199.  
  200.     start12 = TextDrawCreate(390.000000, 108.000000, "v1.0");
  201.     TextDrawBackgroundColor(start12, 255);
  202.     TextDrawFont(start12, 2);
  203.     TextDrawLetterSize(start12, 0.270000, 1.200000);
  204.     TextDrawColor(start12, -156);
  205.     TextDrawSetOutline(start12, 0);
  206.     TextDrawSetProportional(start12, 1);
  207.     TextDrawSetShadow(start12, 1);
  208.  
  209.     start13 = TextDrawCreate(340.000000, 73.000000, "");
  210.     TextDrawBackgroundColor(start13, 255);
  211.     TextDrawFont(start13, 3);
  212.     TextDrawLetterSize(start13, 0.779999, 3.699998);
  213.     TextDrawColor(start13, 346095615);
  214.     TextDrawSetOutline(start13, 1);
  215.     TextDrawSetProportional(start13, 1);
  216.  
  217.     start14 = TextDrawCreate(337.000000, 109.000000, "  Server");
  218.     TextDrawBackgroundColor(start14, 255);
  219.     TextDrawFont(start14, 2);
  220.     TextDrawLetterSize(start14, 0.470000, 1.500000);
  221.     TextDrawColor(start14, -1);
  222.     TextDrawSetOutline(start14, 1);
  223.     TextDrawSetProportional(start14, 1);
  224.  
  225.     start15 = TextDrawCreate(244.000000, 64.000000, ".");
  226.     TextDrawBackgroundColor(start15, 255);
  227.     TextDrawFont(start15, 1);
  228.     TextDrawLetterSize(start15, 29.940078, 1.000000);
  229.     TextDrawColor(start15, -1);
  230.     TextDrawSetOutline(start15, 1);
  231.     TextDrawSetProportional(start15, 1);
  232.    
  233.     TeamAWasserwerfer[0]=AddStaticVehicleEx(601,567.6130,739.8389,11.5103,347.1858,1,1,1200); // WasserA
  234.     TeamAPatriot[0]=AddStaticVehicleEx(470,553.0523,740.5221,12.5199,359.4840,1,1,1200); // PatrA
  235.     TeamASultan[0]=AddStaticVehicleEx(560,547.6265,739.6863,12.2315,0.0869,1,1,1200); // SuöltA
  236.     TeamAHydra[0]=AddStaticVehicleEx(520,560.5493,735.1230,12.9319,352.6046,1,1,1200); // HydraA
  237.     TeamBPatriot[0]=AddStaticVehicleEx(470,628.0826,1031.3182,22.0700,189.7814,1,1,1200); // patrB
  238.     TeamBSultan[0]=AddStaticVehicleEx(560,623.1033,1030.5229,21.7101,188.6581,1,1,1200); // sB
  239.     TeamBWasserwerfer[0]=AddStaticVehicleEx(601,641.7836,1033.4379,22.2986,181.9540,1,1,1200); // wB
  240.     TeamBHydra[0]=AddStaticVehicleEx(520,633.6248,1034.7910,23.4353,198.5664,1,1,1200); // Hb
  241.     return 1;
  242. }
  243.  
  244. enum pInfo
  245. {
  246.     pName[MAX_PLAYER_NAME],
  247.     pKills,
  248.     pCash,
  249.     pSiege,
  250.     pNiederlagen,
  251.     pAdmin,
  252.     pRank,
  253.     pBan,
  254.     pJeep,
  255.     pWasserwerfer,
  256.     pSultan,
  257.     pHydra,
  258. };
  259. new Stats[MAX_PLAYERS][pInfo];
  260.  
  261. pn(pid)
  262. {
  263.     new nn[MAX_PLAYER_NAME];
  264.     GetPlayerName(pid, nn, sizeof nn);
  265.     return nn;
  266. }
  267.  
  268. public Timer()
  269. {
  270.     if(RundenZeit > 0) { RundenZeit--; }
  271.     if(RundenZeit == 0){
  272.     TeamAPoints = 0;
  273.     TeamBPoints = 0;
  274.     SendClientMessageToAll(ROT,"Es beginnt eine neue Runde.");
  275.     RundenZeit = 1200;
  276.     for(new i=0; i<MAX_PLAYERS; i++){ if(SpielerA[i] == 1 || SpielerB[i] == 1) { SetzteSpawn(i); }}}
  277.     return 1;
  278. }
  279.  
  280. public CheckTimer()
  281. {
  282.     for(new i=0; i<MAX_PLAYERS; i++)
  283.     {
  284.         if(Eingeloggt[i] == 1)
  285.         {
  286.             if(Stats[i][pKills] < 20){ Stats[i][pRank] = 0; }
  287.             if(Stats[i][pKills] < 60 && Stats[i][pKills] > 20){ Stats[i][pRank] = 1; }
  288.             if(Stats[i][pKills] < 100 && Stats[i][pKills] > 60){ Stats[i][pRank] = 2; }
  289.             if(Stats[i][pKills] < 160 && Stats[i][pKills] > 100){ Stats[i][pRank] = 3; }
  290.             if(Stats[i][pKills] > 200){ Stats[i][pRank] = 4; }
  291.             SetPlayerScore(i, Stats[i][pRank]);
  292.         }
  293.     }
  294.     return 1;
  295. }
  296.  
  297. public OnGameModeExit()
  298. {
  299.     for(new i=0; i<MAX_PLAYERS; i++){ SavePlayer(i); }
  300.     KillTimer(TimerKill);
  301.     KillTimer(CheckTimerKill);
  302.     return 1;
  303. }
  304.  
  305. public OnPlayerRequestClass(playerid, classid)
  306. {
  307.     if(Stats[playerid][pBan] == 1){ SendClientMessage(playerid,ROT,"Dieser Account ist gebannt"); Kick(playerid); }
  308.     SetPlayerPos(playerid, 736.1979,1037.7520,30.4844);
  309.     SetPlayerCameraPos(playerid, 722.9339,1033.3351,32.0165);
  310.     SetPlayerCameraLookAt(playerid, 736.1979,1037.7520,30.4844);
  311.     SendClientMessage(playerid,WEISS,"<< Willkommen auf dem Call Of Duty - SAMP Server >>");
  312.     if(Eingeloggt[playerid] == 0) //Als erstes fragen wir ab ob der Spieler schon eingeloggt ist oder nicht, damit wir nicht bei jeder Skin auswahl uns neu Einloggen müssen.
  313.     {
  314.         if(mysql_CheckAccount(playerid) == 0)//Wür überprüfen ob der Account Existiert, falls nicht Zeigen wir den Dialog zum Registrieren.
  315.         {
  316.             ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Register","Gib das Passwort für deinen Account ein:","Register","Exit");
  317.         }
  318.         else if(mysql_CheckAccount(playerid) == 1)//Falls doch zeigen wir den Dialog zum Einloggen.
  319.         {
  320.             ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","{FFFFFF}Willkommen auf {4BFF00}CallOfDuty SA-MP{FFFFFF}\nBitte logge dich nun in deinen Account ein!","Login","Abbrechen");
  321.         }
  322.     }
  323.     return 1;
  324. }
  325.  
  326. public OnPlayerConnect(playerid)
  327. {
  328.     TextDrawShowForPlayer(playerid, start0);
  329.     TextDrawShowForPlayer(playerid, start1);
  330.     TextDrawShowForPlayer(playerid, start2);
  331.     TextDrawShowForPlayer(playerid, start3);
  332.     TextDrawShowForPlayer(playerid, start5);
  333.     TextDrawShowForPlayer(playerid, start7);
  334.     TextDrawShowForPlayer(playerid, start8);
  335.     TextDrawShowForPlayer(playerid, start9);
  336.     TextDrawShowForPlayer(playerid, start10);
  337.     TextDrawShowForPlayer(playerid, start11);
  338.     TextDrawShowForPlayer(playerid, start12);
  339.     TextDrawShowForPlayer(playerid, start13);
  340.     TextDrawShowForPlayer(playerid, start14);
  341.     TextDrawShowForPlayer(playerid, start15);
  342.     Eingeloggt[playerid] = 0;
  343.     SpielerA[playerid] = 0;
  344.     SpielerB[playerid] = 0;
  345.     ResetPlayerMoney(playerid);
  346.     SetPlayerColor(playerid,WEISS);
  347.     return 1;
  348. }
  349.  
  350. public OnPlayerDisconnect(playerid, reason)
  351. {
  352.     SavePlayer(playerid);
  353.     if(SpielerA[playerid] == 1){ TeamA--; }
  354.     if(SpielerB[playerid] == 1){ TeamB--; }
  355.     return 1;
  356. }
  357.  
  358. public OnPlayerSpawn(playerid)
  359. {
  360.  
  361.     ShowPlayerDialog(playerid,DIALOG_WAFFENWAHL,DIALOG_STYLE_LIST,"Waffenshop","Standard  [0 CP]\nStürmer  [10 CP]\nScharfschütze  [10 CP]\nTaktiker [10 CP]\nNahkämpfer[10 CP]","Auswählen","");
  362.     TextDrawHideForPlayer(playerid, start0);
  363.     TextDrawHideForPlayer(playerid, start1);
  364.     TextDrawHideForPlayer(playerid, start2);
  365.     TextDrawHideForPlayer(playerid, start3);
  366.     TextDrawHideForPlayer(playerid, start5);
  367.     TextDrawHideForPlayer(playerid, start7);
  368.     TextDrawHideForPlayer(playerid, start8);
  369.     TextDrawHideForPlayer(playerid, start9);
  370.     TextDrawHideForPlayer(playerid, start10);
  371.     TextDrawHideForPlayer(playerid, start11);
  372.     TextDrawHideForPlayer(playerid, start12);
  373.     TextDrawHideForPlayer(playerid, start13);
  374.     TextDrawHideForPlayer(playerid, start14);
  375.     TextDrawHideForPlayer(playerid, start15);
  376.     /*if(Eingeloggt[playerid] == 0){
  377.     if(TeamA < TeamB){ SpielerA[playerid] = 1; TeamA++; SetzteSpawn(playerid); Eingeloggt[playerid] = 1; return 1; }
  378.     if(TeamB < TeamA){ SpielerB[playerid] = 1; TeamB++; SetzteSpawn(playerid); Eingeloggt[playerid] = 1; return 1; }
  379.     if(TeamA == TeamB){ SpielerA[playerid] = 1; TeamA++; SetzteSpawn(playerid); Eingeloggt[playerid] = 1; return 1; }}*/
  380.     if(Eingeloggt[playerid] == 0){ SendClientMessage(playerid,ROT,"Du musst dich einloggen bevor du auf Spawn klickst."); Kick(playerid); }
  381.     SetzteSpawn(playerid);
  382.     return 1;
  383. }
  384.  
  385. public SetzteSpawn(playerid)
  386. {
  387.     if(IsPlayerConnected(playerid))
  388.     {
  389.         new randA;
  390.         new randB;
  391.         if(SpielerA[playerid] == 1){
  392.         randA = random(sizeof(TeamASpawn));
  393.         SetPlayerPos(playerid, TeamASpawn[randA][0], TeamASpawn[randA][1], TeamASpawn[randA][2]);}
  394.         if(SpielerB[playerid] == 1){
  395.         randB = random(sizeof(TeamBSpawn));
  396.         SetPlayerPos(playerid, TeamBSpawn[randB][0], TeamBSpawn[randB][1], TeamBSpawn[randB][2]);}
  397.         SetPlayerInterior(playerid, 0);
  398.         if(SpielerA[playerid] == 1){ SetPlayerColor(playerid,ROT); SetPlayerSkin(playerid, 287);}
  399.         if(SpielerB[playerid] == 1){ SetPlayerColor(playerid,BLAU); SetPlayerSkin(playerid, 285);}
  400.         SetzteWaffe(playerid);//GivePlayerWeapon(playerid, 24,300);
  401.     }
  402.     return 1;
  403. }
  404.  
  405. public SetzteWaffe(playerid)
  406. {
  407.     /*if(Stats[playerid][pRank] < 1){
  408.     GivePlayerWeapon(playerid,24, 75);}//Deagle [X]}//Fallschirm [X]
  409.     if(Stats[playerid][pRank] == 1){
  410.     GivePlayerWeapon(playerid,24, 75);//Deagle [X]
  411.     GivePlayerWeapon(playerid,46,1);}//Fallschirm [X]
  412.     if(Stats[playerid][pRank] == 2){
  413.     GivePlayerWeapon(playerid,29, 200);//MP5 [X]
  414.     GivePlayerWeapon(playerid,25,75);}//Shotgun [X]
  415.     if(Stats[playerid][pRank] == 3){
  416.     GivePlayerWeapon(playerid,31, 200);//M4 [X]
  417.     GivePlayerWeapon(playerid,34,15);}//Sniper [X]
  418.     if(Stats[playerid][pRank] == 4){
  419.     GivePlayerWeapon(playerid,24, 300);//Bazooka []
  420.     GivePlayerWeapon(playerid,46,50);}//Shotgunhalb []*/
  421.     return 1;
  422. }
  423.  
  424. public OnPlayerDeath(playerid, killerid, reason)
  425. {
  426.     if(SpielerA[playerid] == 1 && SpielerA[killerid] == 1){
  427.     SendClientMessage(killerid,ROT,"10 Cashpoints abzug wegen Teamkill");
  428.     Stats[killerid][pCash] -= 10;
  429.     return 1;}
  430.     if(SpielerB[playerid] == 1 && SpielerB[killerid] == 1){
  431.     SendClientMessage(killerid,ROT,"10 Cashpoints abzug wegen Teamkill");
  432.     Stats[killerid][pCash] -= 10;
  433.     return 1;}
  434.     if(SpielerA[playerid] == 1){ TeamBPoints++; }
  435.     if(SpielerB[playerid] == 1){ TeamAPoints++; }
  436.     SendClientMessage(playerid, ROT,"Du hast 5 Cashpunkte verloren.");
  437.     Stats[playerid][pCash] -= 5;
  438.     Stats[killerid][pKills]++;
  439.     Stats[killerid][pCash] += 10;
  440.     SendClientMessage(killerid, ROT,"Du hast 10 Cashpunkte bekommen.");
  441.     new Float:health;
  442.     GetPlayerHealth(killerid,health);
  443.     if(health > 230){ return 1; }
  444.     SetPlayerHealth(killerid, health+20);
  445.     GameTextForPlayer(killerid,"~w~~n~~n~~n~~n~~n~~n~~n~~n~~n~~r~+20HP",2000,3);
  446.     return 1;
  447. }
  448.  
  449. public OnVehicleSpawn(vehicleid)
  450. {
  451.     return 1;
  452. }
  453.  
  454. public OnVehicleDeath(vehicleid, killerid)
  455. {
  456.     return 1;
  457. }
  458.  
  459. public OnPlayerText(playerid, text[])
  460. {
  461.     return 1;
  462. }
  463.  
  464. public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
  465. {
  466.         if(dialogid == DIALOG_WAFFENWAHL)
  467.         {
  468.            //if(response==0) { ShowPlayerDialog(playerid,DIALOG_WAFFENWAHL,DIALOG_STYLE_LIST,"Waffenshop","Standard  [0 CP]\nStürmer  [10 CP]\nScharfschütze  [10 CP]\nTaktiker [10 CP]\nNahkämpfer[10 CP]","Auswählen","Abbruch"); }
  469.             if(response==1)
  470.             {
  471.                 if(listitem==0)
  472.                 {
  473.                     GivePlayerWeapon(playerid,24,200);
  474.                     GivePlayerWeapon(playerid,16,1);
  475.                 }
  476.                 if(listitem==1)
  477.                 {
  478.                     if(Stats[playerid][pCash] < 10){
  479.                     SendClientMessage(playerid,ROT,"Du hast zu wenig Cashpoints.");
  480.                     GivePlayerWeapon(playerid,24,200);
  481.                     GivePlayerWeapon(playerid,16,1); return 1; }
  482.                     GivePlayerWeapon(playerid,31,500);
  483.                     GivePlayerWeapon(playerid,24,250);
  484.                     GivePlayerWeapon(playerid,16,2);
  485.                     Stats[playerid][pCash] -= 10;
  486.                 }
  487.                 if(listitem==2)
  488.                 {
  489.                     if(Stats[playerid][pCash] < 10){
  490.                     SendClientMessage(playerid,ROT,"Du hast zu wenig Cashpoints.");
  491.                     GivePlayerWeapon(playerid,24,200);
  492.                     GivePlayerWeapon(playerid,16,1); return 1; }
  493.                     GivePlayerWeapon(playerid,34,150);
  494.                     GivePlayerWeapon(playerid,24,250);
  495.                     GivePlayerWeapon(playerid,16,2);
  496.                     Stats[playerid][pCash] -= 10;
  497.                 }
  498.                 if(listitem==3)
  499.                 {
  500.                     if(Stats[playerid][pCash] < 10){
  501.                     SendClientMessage(playerid,ROT,"Du hast zu wenig Cashpoints.");
  502.                     GivePlayerWeapon(playerid,24,200);
  503.                     GivePlayerWeapon(playerid,16,1); return 1; }
  504.                     GivePlayerWeapon(playerid,29,500);
  505.                     GivePlayerWeapon(playerid,24,250);
  506.                     GivePlayerWeapon(playerid,16,2);
  507.                     Stats[playerid][pCash] -= 10;
  508.                 }
  509.                 if(listitem==4)
  510.                 {
  511.                     if(Stats[playerid][pCash] < 10){
  512.                     SendClientMessage(playerid,ROT,"Du hast zu wenig Cashpoints.");
  513.                     GivePlayerWeapon(playerid,24,200);
  514.                     GivePlayerWeapon(playerid,16,1); return 1; }
  515.                     GivePlayerWeapon(playerid,25,500);
  516.                     GivePlayerWeapon(playerid,24,250);
  517.                     GivePlayerWeapon(playerid,16,2);
  518.                     Stats[playerid][pCash] -= 10;
  519.                 }
  520.             }
  521.         }
  522.         if(dialogid == DIALOG_WAFFEN)
  523.         {
  524.             if(response==0) { return 1; }
  525.             if(response==1)
  526.             {
  527.                 if(listitem==0)
  528.                 {
  529.                     if(Stats[playerid][pCash] < 75){ SendClientMessage(playerid,ROT,"Du hast zu wenige Cashpunkte"); return 1; }
  530.                     Stats[playerid][pSultan] = 1;
  531.                     Stats[playerid][pCash] -= 75;
  532.                     SendClientMessage(playerid,WEISS,"<< Du hast dir den Schlüssel für den Sultan gekauft >>");
  533.                 }
  534.                 if(listitem==1)
  535.                 {
  536.                     if(Stats[playerid][pCash] < 100){ SendClientMessage(playerid,ROT,"Du hast zu wenige Cashpunkte"); return 1; }
  537.                     Stats[playerid][pJeep] = 1;
  538.                     Stats[playerid][pCash] -= 100;
  539.                     SendClientMessage(playerid,WEISS,"<< Du hast dir den Schlüssel für den Jeep gekauft >>");
  540.                 }
  541.                 if(listitem==2)
  542.                 {
  543.                     if(Stats[playerid][pCash] < 150){ SendClientMessage(playerid,ROT,"Du hast zu wenige Cashpunkte"); return 1; }
  544.                     Stats[playerid][pWasserwerfer] = 1;
  545.                     Stats[playerid][pCash] -= 150;
  546.                     SendClientMessage(playerid,WEISS,"<< Du hast dir den Schlüssel für den Wasserwerfer gekauft >>");
  547.                 }
  548.                 if(listitem==3)
  549.                 {
  550.                     if(Stats[playerid][pCash] < 250){ SendClientMessage(playerid,ROT,"Du hast zu wenige Cashpunkte"); return 1; }
  551.                     Stats[playerid][pHydra] = 1;
  552.                     Stats[playerid][pCash] -= 250;
  553.                     SendClientMessage(playerid,WEISS,"<< Du hast dir den Schlüssel für die Hydra gekauft >>");
  554.                 }
  555.             }
  556.         }
  557.         if(dialogid == DIALOG_REGISTER)
  558.         {
  559.             if(response)
  560.             {
  561.                 if(strlen(inputtext) == 0)
  562.                 {
  563.                     ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Register","Das angegebene Passwort war zu Kurtz...\nBitte Registrier dich jetzt mit einem Passwort:","Register","Abbrechen");
  564.                     return 1;
  565.                 }
  566.                 else
  567.                 {
  568.                     CreateAccount(playerid, inputtext);
  569.                     LoadPlayer(playerid);
  570.                     if(TeamA < TeamB){ SpielerA[playerid] = 1; TeamA++; SpawnPlayer(playerid);  Eingeloggt[playerid] = 1; return 1; }
  571.                     if(TeamB < TeamA){ SpielerB[playerid] = 1; TeamB++; SpawnPlayer(playerid);  Eingeloggt[playerid] = 1; return 1; }
  572.                     if(TeamA == TeamB){ SpielerA[playerid] = 1; TeamA++; SpawnPlayer(playerid); Eingeloggt[playerid] = 1; return 1; }
  573.                     return 1;
  574.                 }
  575.             }
  576.             else
  577.             {
  578.                 Kick(playerid);
  579.             }
  580.         }
  581.         if(dialogid == DIALOG_LOGIN)
  582.         {
  583.             if(response)
  584.             {
  585.                 if(strlen(inputtext) == 0)
  586.                 {
  587.                     ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_INPUT,"Login","Das Angegebene Passwort war Falsch.\nBitte log dich jetzt mit dem richtigen Passwort ein:","Login","Abbrechen");
  588.                     return 1;
  589.                 }
  590.                 else
  591.                 {
  592.                     new SpielerName[MAX_PLAYER_NAME];
  593.                     GetPlayerName(playerid, SpielerName, MAX_PLAYER_NAME);
  594.                     if(!strcmp(inputtext, mysql_ReturnPasswort(SpielerName), true))
  595.                     {
  596.                         LoadPlayer(playerid);
  597.                         if(TeamA < TeamB){ SpielerA[playerid] = 1; TeamA++; SpawnPlayer(playerid);  Eingeloggt[playerid] = 1; return 1; }
  598.                         if(TeamB < TeamA){ SpielerB[playerid] = 1; TeamB++; SpawnPlayer(playerid);  Eingeloggt[playerid] = 1; return 1; }
  599.                         if(TeamA == TeamB){ SpielerA[playerid] = 1; TeamA++; SpawnPlayer(playerid); Eingeloggt[playerid] = 1; return 1; }
  600.                         return 1;
  601.                     }
  602.                     else
  603.                     {
  604.                         ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_INPUT,"Login","Das war das Falsche Passwort.\nBitte log dich jetzt mit dem richtigen Passwort ein:","Login","Abbrechen");
  605.                         return 1;
  606.                     }
  607.                 }
  608.             }
  609.             else
  610.             {
  611.                 Kick(playerid);
  612.             }
  613.         }
  614.         return 1;
  615. }
  616. public OnPlayerCommandText(playerid, cmdtext[])
  617. {
  618.     new string[256];
  619.     if (strcmp("/help", cmdtext, true, 10) == 0)
  620.     {
  621.         SendClientMessage(playerid,WEISS,"Du bekommst pro Kill 10 Cashpunkte und du verlierst 5 pro Tod.");
  622.         SendClientMessage(playerid,WEISS,"Mit den Cashpunkten kannst du dir Waffen kaufen.");
  623.         SendClientMessage(playerid,WEISS,"Du kannst Ränge aufsteigen und bekommst immer bessere Waffen.");
  624.         SendClientMessage(playerid,WEISS,"Um alle Befehle zu sehen, benutze den Befehl: {CC00CC}/commands");
  625.         return 1;
  626.     }
  627.     if (strcmp("/commands", cmdtext, true, 10) == 0)
  628.     {
  629.         SendClientMessage(playerid,WEISS,"   {FFFFFF}                                                << Es gibt folgende Befehle >>");
  630.         SendClientMessage(playerid,WEISS,"{FFFFFF}<< /punktestand {CC00CC}|{FFFFFF} /stats {CC00CC}|{FFFFFF} /zeit {CC00CC}|{FFFFFF} /schlüssel  >>");
  631.         return 1;
  632.     }
  633.     if (strcmp("/punktestand", cmdtext, true, 10) == 0)
  634.     {
  635.         format(string, sizeof(string), "|||   TeamA: %d  |  TeamB: %d   |||",TeamAPoints,TeamBPoints);
  636.         SendClientMessage(playerid,WEISS,"**********************************");
  637.         SendClientMessage(playerid,BLAU,string);
  638.         SendClientMessage(playerid,WEISS,"**********************************");
  639.         return 1;
  640.     }
  641.     if (strcmp("/zeit", cmdtext, true, 10) == 0)
  642.     {
  643.         format(string, sizeof(string), "<< Noch ca. %d Minuten bis zur neuen Runde >>",RundenZeit/60);
  644.         SendClientMessage(playerid,BLAU,string);
  645.         return 1;
  646.     }
  647.     if (strcmp("/schlüssel", cmdtext, true, 10) == 0)
  648.     {
  649.         ShowPlayerDialog(playerid,DIALOG_WAFFEN,DIALOG_STYLE_LIST,"Schlüsselshop","Sultan [75 CP]\nJeep [100 CP]\nWasserwerfer [150 CP]\nHydra [250 CP]","Auswählen","Abbruch");
  650.         return 1;
  651.     }
  652.     if (strcmp("/stats", cmdtext, true, 10) == 0)
  653.     {
  654.         new stringa[64];
  655.         new stringb[64];
  656.         new stringc[64];
  657.         SendClientMessage(playerid,WEISS,"**********************************");
  658.         format(string, sizeof(string), "Name:{CC00CC} %s",pn(playerid));
  659.         format(stringa, sizeof(stringa), "Kills:{CC00CC} %d",Stats[playerid][pKills]);
  660.         format(stringb, sizeof(stringb), "Siege:{CC00CC}  %d",Stats[playerid][pSiege]);
  661.         format(stringc, sizeof(stringc), "CP's:{CC00CC}  %d",Stats[playerid][pCash]);
  662.         SendClientMessage(playerid,WEISS,string);
  663.         SendClientMessage(playerid,WEISS,stringa);
  664.         SendClientMessage(playerid,WEISS,stringb);
  665.         SendClientMessage(playerid,WEISS,stringc);
  666.         SendClientMessage(playerid,WEISS,"**********************************");
  667.         return 1;
  668.     }
  669.     if (strcmp("/gmx", cmdtext, true, 10) == 0)
  670.     {
  671.         if(Stats[playerid][pAdmin] == 0){ SendClientMessage(playerid,ROT,"Du bist kein Admin"); return 1; }
  672.         SendRconCommand("gmx");
  673.         return 1;
  674.     }
  675.     if (strcmp("/hackcp", cmdtext, true, 10) == 0)
  676.     {
  677.         if(Stats[playerid][pAdmin] == 0){ SendClientMessage(playerid,ROT,"Du bist kein Admin"); return 1; }
  678.         Stats[playerid][pCash] += 100;
  679.         SendClientMessage(playerid,BLAU,"<< Du hast 100 Cashpoints gehackt. >>");
  680.         return 1;
  681.     }
  682.     if (strcmp("/admin", cmdtext, true, 10) == 0)
  683.     {
  684.         if(!IsPlayerAdmin(playerid)){ SendClientMessage(playerid,ROT,"Du bist kein Admin."); return 1; }
  685.         Stats[playerid][pAdmin] = 1;
  686.         return 1;
  687.     }
  688.     /*if (strcmp("/munition", cmdtext, true, 10) == 0)
  689.     {
  690.         if(Stats[playerid][pCash] < 25){ SendClientMessage(playerid,ROT,"Du benötigst 25 Cashpoints."); return 1;}
  691.         SetzteWaffe(playerid);
  692.         Stats[playerid][pCash] -= 25;
  693.         SendClientMessage(playerid,BLAU,"<< Deine Waffen haben jetzt alle wieder Munition | Preis: 25 CP");
  694.         return 1;
  695.     }*/
  696.     if (strcmp("/auto1veh", cmdtext, true, 10) == 0)
  697.     {
  698.         new Float:X,Float:Y,Float:Z;
  699.         GetPlayerPos(playerid,X,Y,Z);
  700.         AddStaticVehicle(560,X,Y,Z+10,0.0,1,1);
  701.     }
  702.     if (strcmp("/auto2veh", cmdtext, true, 10) == 0)
  703.     {
  704.         new Float:X,Float:Y,Float:Z;
  705.         GetPlayerPos(playerid,X,Y,Z);
  706.         AddStaticVehicle(470,X,Y,Z+10,0.0,1,1);
  707.     }
  708.     if (strcmp("/auto3veh", cmdtext, true, 10) == 0)
  709.     {
  710.         new Float:X,Float:Y,Float:Z;
  711.         GetPlayerPos(playerid,X,Y,Z);
  712.         AddStaticVehicle(520,X,Y,Z+10,0.0,1,1);
  713.     }
  714.     if (strcmp("/auto4veh", cmdtext, true, 10) == 0)
  715.     {
  716.         new Float:X,Float:Y,Float:Z;
  717.         GetPlayerPos(playerid,X,Y,Z);
  718.         AddStaticVehicle(601,X,Y,Z+10,0.0,1,1);
  719.     }
  720.     return 1;
  721. }
  722.  
  723. public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
  724. {
  725.         for(new i=0; i<sizeof(TeamASultan); i++)
  726.         {
  727.             if(vehicleid==TeamASultan[i])
  728.             if(!ispassenger)
  729.             if(SpielerA[playerid] == 1 && Stats[playerid][pSultan] ==1)
  730.             {
  731.                 return 1;
  732.             }
  733.             else
  734.             {
  735.                 new Float:X,Float:Y,Float:Z;
  736.                 GetPlayerPos(playerid,X,Y,Z);
  737.                 SetPlayerPos(playerid,X,Y,Z);
  738.                 SendClientMessage(playerid,ROT,"Du benötigst einen Schlüssel | /schlüssel");
  739.                 return 1;
  740.             }
  741.         }
  742.         for(new i=0; i<sizeof(TeamAPatriot); i++)
  743.         {
  744.             if(vehicleid==TeamAPatriot[i])
  745.             if(!ispassenger)
  746.             if(SpielerA[playerid] == 1 && Stats[playerid][pJeep] ==1)
  747.             {
  748.                 return 1;
  749.             }
  750.             else
  751.             {
  752.                 new Float:X,Float:Y,Float:Z;
  753.                 GetPlayerPos(playerid,X,Y,Z);
  754.                 SetPlayerPos(playerid,X,Y,Z);
  755.                 SendClientMessage(playerid,ROT,"Du benötigst einen Schlüssel | /schlüssel");
  756.                 return 1;
  757.             }
  758.         }
  759.         for(new i=0; i<sizeof(TeamAHydra); i++)
  760.         {
  761.             if(vehicleid==TeamAHydra[i])
  762.             if(!ispassenger)
  763.             if(SpielerA[playerid] == 1 && Stats[playerid][pHydra] ==1)
  764.             {
  765.                 return 1;
  766.             }
  767.             else
  768.             {
  769.                 new Float:X,Float:Y,Float:Z;
  770.                 GetPlayerPos(playerid,X,Y,Z);
  771.                 SetPlayerPos(playerid,X,Y,Z);
  772.                 SendClientMessage(playerid,ROT,"Du benötigst einen Schlüssel | /schlüssel");
  773.                 return 1;
  774.             }
  775.         }
  776.         for(new i=0; i<sizeof(TeamAWasserwerfer); i++)
  777.         {
  778.             if(vehicleid==TeamAWasserwerfer[i])
  779.             if(!ispassenger)
  780.             if(SpielerA[playerid] == 1 && Stats[playerid][pWasserwerfer] ==1)
  781.             {
  782.                 return 1;
  783.             }
  784.             else
  785.             {
  786.                 new Float:X,Float:Y,Float:Z;
  787.                 GetPlayerPos(playerid,X,Y,Z);
  788.                 SetPlayerPos(playerid,X,Y,Z);
  789.                 SendClientMessage(playerid,ROT,"Du benötigst einen Schlüssel | /schlüssel");
  790.                 return 1;
  791.             }
  792.         }
  793.         //BBBBBBBBBBBBBBBBBBBBBBBBBBBBBbb
  794.         for(new i=0; i<sizeof(TeamBSultan); i++)
  795.         {
  796.             if(vehicleid==TeamBSultan[i])
  797.             if(!ispassenger)
  798.             if(SpielerB[playerid] == 1 && Stats[playerid][pSultan] ==1)
  799.             {
  800.                 return 1;
  801.             }
  802.             else
  803.             {
  804.                 new Float:X,Float:Y,Float:Z;
  805.                 GetPlayerPos(playerid,X,Y,Z);
  806.                 SetPlayerPos(playerid,X,Y,Z);
  807.                 SendClientMessage(playerid,ROT,"Du benötigst einen Schlüssel | /schlüssel");
  808.                 return 1;
  809.             }
  810.         }
  811.         for(new i=0; i<sizeof(TeamBPatriot); i++)
  812.         {
  813.             if(vehicleid==TeamBPatriot[i])
  814.             if(!ispassenger)
  815.             if(SpielerB[playerid] == 1 && Stats[playerid][pJeep] ==1)
  816.             {
  817.                 return 1;
  818.             }
  819.             else
  820.             {
  821.                 new Float:X,Float:Y,Float:Z;
  822.                 GetPlayerPos(playerid,X,Y,Z);
  823.                 SetPlayerPos(playerid,X,Y,Z);
  824.                 SendClientMessage(playerid,ROT,"Du benötigst einen Schlüssel | /schlüssel");
  825.                 return 1;
  826.             }
  827.         }
  828.         for(new i=0; i<sizeof(TeamBHydra); i++)
  829.         {
  830.             if(vehicleid==TeamBHydra[i])
  831.             if(!ispassenger)
  832.             if(SpielerB[playerid] == 1 && Stats[playerid][pHydra] ==1)
  833.             {
  834.                 return 1;
  835.             }
  836.             else
  837.             {
  838.                 new Float:X,Float:Y,Float:Z;
  839.                 GetPlayerPos(playerid,X,Y,Z);
  840.                 SetPlayerPos(playerid,X,Y,Z);
  841.                 SendClientMessage(playerid,ROT,"Du benötigst einen Schlüssel | /schlüssel");
  842.                 return 1;
  843.             }
  844.         }
  845.         for(new i=0; i<sizeof(TeamBWasserwerfer); i++)
  846.         {
  847.             if(vehicleid==TeamBWasserwerfer[i])
  848.             if(!ispassenger)
  849.             if(SpielerB[playerid] == 1 && Stats[playerid][pWasserwerfer] ==1)
  850.             {
  851.                 return 1;
  852.             }
  853.             else
  854.             {
  855.                 new Float:X,Float:Y,Float:Z;
  856.                 GetPlayerPos(playerid,X,Y,Z);
  857.                 SetPlayerPos(playerid,X,Y,Z);
  858.                 SendClientMessage(playerid,ROT,"Du benötigst einen Schlüssel | /schlüssel");
  859.                 return 1;
  860.             }
  861.         }
  862.         return 1;
  863. }
  864.  
  865. public OnPlayerExitVehicle(playerid, vehicleid)
  866. {
  867.     return 1;
  868. }
  869.  
  870. public OnPlayerStateChange(playerid, newstate, oldstate)
  871. {
  872.     return 1;
  873. }
  874.  
  875. public OnPlayerEnterCheckpoint(playerid)
  876. {
  877.     return 1;
  878. }
  879.  
  880. public OnPlayerLeaveCheckpoint(playerid)
  881. {
  882.     return 1;
  883. }
  884.  
  885. public OnPlayerEnterRaceCheckpoint(playerid)
  886. {
  887.     return 1;
  888. }
  889.  
  890. public OnPlayerLeaveRaceCheckpoint(playerid)
  891. {
  892.     return 1;
  893. }
  894.  
  895. public OnRconCommand(cmd[])
  896. {
  897.     return 1;
  898. }
  899.  
  900. public OnPlayerRequestSpawn(playerid)
  901. {
  902.     return 1;
  903. }
  904.  
  905. public OnObjectMoved(objectid)
  906. {
  907.     return 1;
  908. }
  909.  
  910. public OnPlayerObjectMoved(playerid, objectid)
  911. {
  912.     return 1;
  913. }
  914.  
  915. public OnPlayerPickUpPickup(playerid, pickupid)
  916. {
  917.     return 1;
  918. }
  919.  
  920. public OnVehicleMod(playerid, vehicleid, componentid)
  921. {
  922.     return 1;
  923. }
  924.  
  925. public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
  926. {
  927.     return 1;
  928. }
  929.  
  930. public OnVehicleRespray(playerid, vehicleid, color1, color2)
  931. {
  932.     return 1;
  933. }
  934.  
  935. public OnPlayerSelectedMenuRow(playerid, row)
  936. {
  937.     return 1;
  938. }
  939.  
  940. public OnPlayerExitedMenu(playerid)
  941. {
  942.     return 1;
  943. }
  944.  
  945. public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
  946. {
  947.     return 1;
  948. }
  949.  
  950. public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
  951. {
  952.     return 1;
  953. }
  954.  
  955. public OnRconLoginAttempt(ip[], password[], success)
  956. {
  957.     return 1;
  958. }
  959.  
  960. public OnPlayerUpdate(playerid)
  961. {
  962.     return 1;
  963. }
  964.  
  965. public OnPlayerStreamIn(playerid, forplayerid)
  966. {
  967.     return 1;
  968. }
  969.  
  970. public OnPlayerStreamOut(playerid, forplayerid)
  971. {
  972.     return 1;
  973. }
  974.  
  975. public OnVehicleStreamIn(vehicleid, forplayerid)
  976. {
  977.     return 1;
  978. }
  979.  
  980. public OnVehicleStreamOut(vehicleid, forplayerid)
  981. {
  982.     return 1;
  983. }
  984.  
  985. public OnPlayerClickPlayer(playerid, clickedplayerid, source)
  986. {
  987.     return 1;
  988. }
  989.  
  990. stock IsPlayerInArea(playerid,Float:minX,Float:minY,Float:maxX,Float:maxY)
  991. {
  992.     new Float:pX,Float:pY,Float:pZ;
  993.     GetPlayerPos(playerid,pX,pY,pZ);
  994.     if(pX >= minX && pX <= maxX && pY >= minY && pY <= maxY) return 1;
  995.     else return 0;
  996. }
  997.  
  998. stock Connect_To_Database()
  999. {
  1000.     mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS); //Wir versuchen mit den Angaben die wir oben im Script gemacht haben uns mit dem MySQL Server zu verbinden.
  1001.     if(mysql_ping() == 1) //Es wird überprüft ob die Verbindung steht.
  1002.     {
  1003.         //Falls ja wird das in die Console geschrieben und die Funktion wird beendet.
  1004.         print("<-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!");
  1005.         return true;
  1006.     }
  1007.     else
  1008.     {
  1009.         //Falls nicht wird erneut versucht eine verbindung aufzubauen.
  1010.         print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
  1011.         print("<-| [MYSQL] Es wird erneut versucht eine Verbindung zur Datenbank herzustellen!");
  1012.         mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
  1013.         if(mysql_ping() == 1)
  1014.         {
  1015.             print("<-| [MYSQL] Es konnte im 2 Versuch eine Verbindung hergestellt werden!");
  1016.             return true;
  1017.         }
  1018.         else
  1019.         {
  1020.             //Falls das auch nicht Funktioniert wird der Server zur Sicherheit wieder heruntergefahren.
  1021.             print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
  1022.             print("<-| [MYSQL] Der Server wird nun beendet!");
  1023.             SendRconCommand("exit");
  1024.             return true;
  1025.         }
  1026.     }
  1027. }
  1028. stock mysql_CheckAccount(playerid)
  1029. {
  1030.     new Query[128],Name[MAX_PLAYER_NAME],count;
  1031.     GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
  1032.     mysql_real_escape_string(Name, Name);
  1033.     format(Query, sizeof(Query), "SELECT * FROM `accounts` WHERE `Name` = '%s'", Name);
  1034.     mysql_query(Query);
  1035.     mysql_store_result();
  1036.     count = mysql_num_rows();
  1037.     mysql_free_result();
  1038.     return count;
  1039. }
  1040. stock CreateAccount(playerid, pass[])
  1041. {
  1042.     new query[256],Name[MAX_PLAYER_NAME];
  1043.     GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
  1044.     mysql_real_escape_string(Name,Name);
  1045.     mysql_real_escape_string(pass,pass);
  1046.     format(query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Passwort`) VALUES ('%s', '%s')", Name, pass);
  1047.     mysql_query(query);
  1048.     return true;
  1049. }
  1050. stock mysql_ReturnPasswort(Name[])
  1051. {
  1052.     new query[130], Get[130];
  1053.     mysql_real_escape_string(Name, Name);
  1054.     format(query, 128, "SELECT `passwort` FROM `accounts` WHERE `Name` = '%s'", Name);
  1055.     mysql_query(query);
  1056.     mysql_store_result();
  1057.     mysql_fetch_row(Get);
  1058.     mysql_free_result();
  1059.     return Get;
  1060. }
  1061. stock LoadPlayer(playerid)
  1062. {
  1063.     if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
  1064.     {
  1065.         GetPlayerName(playerid, Stats[playerid][pName], MAX_PLAYER_NAME);
  1066.         Stats[playerid][pKills] = mysql_GetInt("accounts", "pKills", "Name", Stats[playerid][pName]);
  1067.         Stats[playerid][pCash] = mysql_GetInt("accounts", "pCash", "Name", Stats[playerid][pName]);
  1068.         Stats[playerid][pSiege] = mysql_GetInt("accounts", "pSiege", "Name", Stats[playerid][pName]);
  1069.         Stats[playerid][pNiederlagen] = mysql_GetInt("accounts", "pNiederlagen", "Name", Stats[playerid][pName]);
  1070.         Stats[playerid][pAdmin] = mysql_GetInt("accounts", "pAdmin", "Name", Stats[playerid][pName]);
  1071.         Stats[playerid][pRank] = mysql_GetInt("accounts", "pRank", "Name", Stats[playerid][pName]);
  1072.         Stats[playerid][pBan] = mysql_GetInt("accounts", "pBan", "Name", Stats[playerid][pName]);
  1073.         Stats[playerid][pJeep] = mysql_GetInt("accounts", "pJeep", "Name", Stats[playerid][pName]);
  1074.         Stats[playerid][pWasserwerfer] = mysql_GetInt("accounts", "pWasserwerfer", "Name", Stats[playerid][pName]);
  1075.         Stats[playerid][pSultan] = mysql_GetInt("accounts", "pSultan", "Name", Stats[playerid][pName]);
  1076.         Stats[playerid][pHydra] = mysql_GetInt("accounts", "pHydra", "Name", Stats[playerid][pName]);
  1077.     }
  1078.     return 1;
  1079. }
  1080.  
  1081. stock SavePlayer(playerid)
  1082. {
  1083.     if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
  1084.     {
  1085.         if(Eingeloggt[playerid] == 1)
  1086.         {
  1087.             mysql_SetInt("accounts", "pKills", Stats[playerid][pKills], "Name", Stats[playerid][pName]);
  1088.             mysql_SetInt("accounts", "pCash", Stats[playerid][pCash], "Name", Stats[playerid][pName]);
  1089.             mysql_SetInt("accounts", "pSiege", Stats[playerid][pSiege], "Name", Stats[playerid][pName]);
  1090.             mysql_SetInt("accounts", "pNiederlagen", Stats[playerid][pNiederlagen], "Name", Stats[playerid][pName]);
  1091.             mysql_SetInt("accounts", "pAdmin", Stats[playerid][pAdmin], "Name", Stats[playerid][pName]);
  1092.             mysql_SetInt("accounts", "pRank", Stats[playerid][pRank], "Name", Stats[playerid][pName]);
  1093.             mysql_SetInt("accounts", "pBan", Stats[playerid][pBan], "Name", Stats[playerid][pName]);
  1094.             mysql_SetInt("accounts", "pJeep", Stats[playerid][pJeep], "Name", Stats[playerid][pName]);
  1095.             mysql_SetInt("accounts", "pWasserwerfer", Stats[playerid][pWasserwerfer], "Name", Stats[playerid][pName]);
  1096.             mysql_SetInt("accounts", "pSultan", Stats[playerid][pSultan], "Name", Stats[playerid][pName]);
  1097.             mysql_SetInt("accounts", "pHydra", Stats[playerid][pHydra], "Name", Stats[playerid][pName]);
  1098.         }
  1099.     }
  1100.     return 1;
  1101. }
  1102. stock mysql_GetString(Table[], Field[], Where[], Is[])
  1103. {
  1104.     new query[128], Get[128];
  1105.     mysql_real_escape_string(Table, Table);
  1106.     mysql_real_escape_string(Field, Field);
  1107.     mysql_real_escape_string(Where, Where);
  1108.     mysql_real_escape_string(Is, Is);
  1109.     format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
  1110.     mysql_query(query);
  1111.     mysql_store_result();
  1112.     mysql_fetch_row(Get);
  1113.     mysql_free_result();
  1114.     return Get;
  1115. }
  1116. stock mysql_GetInt(Table[], Field[], Where[], Is[])
  1117. {
  1118.     new query[128];
  1119.     mysql_real_escape_string(Table, Table);
  1120.     mysql_real_escape_string(Field, Field);
  1121.     mysql_real_escape_string(Where, Where);
  1122.     mysql_real_escape_string(Is, Is);
  1123.     format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
  1124.     mysql_query(query);
  1125.     mysql_store_result();
  1126.     new sqlint = mysql_fetch_int();
  1127.     mysql_free_result();
  1128.     return sqlint;
  1129. }
  1130. stock Float:mysql_GetFloat(Table[], Field[], Where[], Is[])
  1131. {
  1132.     new query[128], Float:sqlfloat;
  1133.     mysql_real_escape_string(Table, Table);
  1134.     mysql_real_escape_string(Field, Field);
  1135.     mysql_real_escape_string(Where, Where);
  1136.     mysql_real_escape_string(Is, Is);
  1137.     format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
  1138.     mysql_query(query);
  1139.     mysql_store_result();
  1140.     mysql_fetch_float(sqlfloat);
  1141.     mysql_free_result();
  1142.     return sqlfloat;
  1143. }
  1144. stock mysql_SetInt(Table[], Field[], To, Where[], Where2[])
  1145. {
  1146.     new query[128];
  1147.     mysql_real_escape_string(Table, Table);
  1148.     mysql_real_escape_string(Field, Field);
  1149.     mysql_real_escape_string(Where, Where);
  1150.     mysql_real_escape_string(Where2, Where2);
  1151.     format(query, 128, "UPDATE `%s` SET `%s` = '%d' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
  1152.     mysql_query(query);
  1153.     return true;
  1154. }
  1155. stock mysql_SetString(Table[], Field[], To[], Where[], Where2[])
  1156. {
  1157.     new query[128];
  1158.     mysql_real_escape_string(Table, Table);
  1159.     mysql_real_escape_string(Field, Field);
  1160.     mysql_real_escape_string(To, To);
  1161.     mysql_real_escape_string(Where, Where);
  1162.     mysql_real_escape_string(Where2, Where2);
  1163.     format(query, 128, "UPDATE `%s` SET `%s` = '%s' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
  1164.     mysql_query(query);
  1165.     return true;
  1166. }
  1167. stock mysql_SetFloat(Table[], Field[], Float:To, Where[], Where2[])
  1168. {
  1169.     new query[128];
  1170.     mysql_real_escape_string(Table, Table);
  1171.     mysql_real_escape_string(Field, Field);
  1172.     mysql_real_escape_string(Where, Where);
  1173.     mysql_real_escape_string(Where2, Where2);
  1174.     format(query, 128, "UPDATE `%s` SET `%s` = '%f' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
  1175.     mysql_query(query);
  1176.     return true;
  1177. }
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!