API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 25th, 2012
168
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 32.22 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. ________________________________________________> <________________________________________________
  3. > <
  4. > <
  5. > <
  6. > <
  7. > <
  8. > <
  9. Version: 1.0 > Weihnachtsferien <
  10. > <
  11. > <
  12. > <
  13. > <
  14. > <
  15. > <
  16. ________________________________________________> <________________________________________________
  17. */
  18.  
  19.  
  20. #define SQL_HOST "localhost"
  21. #define SQL_USER "samp867"
  22. #define SQL_PASS ""
  23. #define SQL_DATA "samp867_test"
  24.  
  25. #include <a_samp>
  26. #include <a_mysql>
  27. #include <dini>
  28. #include <streamer>
  29. //#include <Junkbuster>
  30.  
  31. #define COLOR_GRAD1 0xB4B5B7FF
  32. #define COLOR_GRAD2 0xBFC0C2FF
  33. #define COLOR_GRAD3 0xCBCCCEFF
  34. #define COLOR_GRAD4 0xD8D8D8FF
  35. #define COLOR_GRAD5 0xE3E3E3FF
  36. #define COLOR_GREY 0xAFAFAFAA
  37. #define COLOR_BLACK 0x000000AA
  38. #define COLOR_RED 0xFF0000AA
  39. #define COLOR_LIGHTRED 0xFF6347AA
  40. #define COLOR_BLUE 0x000080AA
  41. #define COLOR_LIGHTBLUE 0x33CCFFAA
  42. #define COLOR_GREEN 0x33AA33AA
  43. #define COLOR_LIGHTGREEN 0x9ACD32AA
  44. #define COLOR_YELLOW 0xFFFF00AA
  45. #define COLOR_YELLOW2 0xF5DEB3AA
  46. #define COLOR_WHITE 0xFFFFFFAA
  47. #define COLOR_FADE1 0xE6E6E6E6
  48. #define COLOR_FADE2 0xC8C8C8C8
  49. #define COLOR_FADE3 0xAAAAAAAA
  50. #define COLOR_FADE4 0x8C8C8C8C
  51. #define COLOR_FADE5 0x6E6E6E6E
  52. #define COLOR_PURPLE 0xC2A2DAAA
  53. #define COLOR_DBLUE 0x2641FEAA
  54. #define COLOR_ALLDEPT 0xFF8282AA
  55. #define COLOR_NEWS 0xFFA500AA
  56. #define COLOR_OOC 0xE0FFFFAA
  57. #define COLOR_GROVE 0x00FF00FF
  58.  
  59. #define Zombiedm 105
  60.  
  61. #define DIALOG_REGISTER (1)
  62. #define DIALOG_LOGIN (2)
  63.  
  64.  
  65. main()
  66. {
  67.  
  68. print(" ");
  69. print(" _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _");
  70. print("_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _");
  71. print(" Weihnachtsferien)");
  72. print(" 1.v.0");
  73. print("_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _");
  74. print(" _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _");
  75. print(" ");
  76. print(" ");
  77.  
  78. }
  79.  
  80. public OnGameModeInit()
  81. {
  82. Connect_To_Database();
  83. mysql_query("CREATE TABLE IF NOT EXISTS `accounts` (`id` int(11) AUTO_INCREMENT,`Name` varchar(64),`Passwort` varchar(128),`Level` int(11),`Geld` int(11),`Kills` int(11),`Tode` int(11), PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
  84. mysql_query("ALTER TABLE `accounts` ADD `Admin` int(11)");//Da wo intgerwert steht das neue Feld eintragen (Nur für intger da da steht int(11)) 11 Zeichen reichen kann immer so bleiben
  85. //mysql_query("ALTER TABLE `accounts` ADD `STRINGWERT` varchar(64)");//Da wo stringwert steht das neue Feld eintragen (Nur für strings da da steht varchar(64)) Die 64 steht für die länge
  86. //mysql_query("ALTER TABLE `accounts` ADD `FLOATWERT` float(20)");//Da wo floatwert steht das neue Feld eintragen (Nur für floats da da steht float(20)) 20 Zeichen reichen kann immer so bleiben
  87. SetGameModeText(" Weihnachtsferien");
  88. EnableStuntBonusForAll(0);
  89. DisableInteriorEnterExits();
  90. UsePlayerPedAnims();
  91.  
  92. //map
  93. CreateDynamicObject(18226, 2168.41015625, 1019.1840209961, 467.99569702148, 0, 0, 160);
  94. CreateDynamicObject(18226, 2115.2780761719, 1037.3486328125, 465.53289794922, 0, 0, 237.99938964844);
  95. CreateDynamicObject(18226, 2110.361328125, 1123.2875976563, 466.06369018555, 0, 0, 59.996826171875);
  96. CreateDynamicObject(18226, 2187.5485839844, 1120.3668212891, 459.69500732422, 0, 0, 59.996337890625);
  97. CreateDynamicObject(18226, 2231.1484375, 1121.5025634766, 468.31323242188, 0, 0, 59.996337890625);
  98. CreateDynamicObject(18226, 2264.1213378906, 1061.5715332031, 466.16983032227, 0, 0, 345.99633789063);
  99. CreateDynamicObject(18226, 2272.9265136719, 1008.0489501953, 464.17193603516, 0, 0, 341.99243164063);
  100. CreateDynamicObject(18226, 2172.2006835938, 966.12219238281, 467.99002075195, 0, 0, 159.99938964844);
  101. CreateDynamicObject(18226, 2192.3796386719, 908.29852294922, 463.13143920898, 0, 0, 249.99938964844);
  102. CreateDynamicObject(18226, 2264.8188476563, 943.30108642578, 464.3132019043, 0, 0, 323.99389648438);
  103. CreateDynamicObject(18226, 2069.4663085938, 1036.0904541016, 464.33840942383, 0, 0, 237.99682617188);
  104. CreateDynamicObject(18226, 2045.2092285156, 1101.2852783203, 466.29821777344, 0, 0, 159.99633789063);
  105. CreateDynamicObject(6959, 2179.5336914063, 933.31713867188, 501.18978881836, 270.22204589844, 0, 274);
  106. CreateDynamicObject(6959, 2176.955078125, 973.48583984375, 501.1018371582, 270.21936035156, 0, 273.9990234375);
  107. CreateDynamicObject(6959, 2174.2353515625, 1012.365234375, 501.16192626953, 270.21936035156, 0, 273.9990234375);
  108. CreateDynamicObject(6959, 2152.1831054688, 1034.3707275391, 501.18804931641, 270.21939086914, 0, 356.20104980469);
  109. CreateDynamicObject(6959, 2111.6870117188, 1037.0153808594, 501.16445922852, 270.21398925781, 0, 356.19873046875);
  110. CreateDynamicObject(6959, 2072.6516113281, 1039.5871582031, 501.20684814453, 270.21398925781, 0, 356.19873046875);
  111. CreateDynamicObject(6959, 2051.3647460938, 1061.3431396484, 501.14541625977, 270.21398925781, 0, 272.19873046875);
  112. CreateDynamicObject(6959, 2049.7885742188, 1102.2291259766, 501.16976928711, 270.20843505859, 0, 272.197265625);
  113. CreateDynamicObject(6959, 2069.0424804688, 1122.7413330078, 501.13452148438, 270.20843505859, 0, 180.197265625);
  114. CreateDynamicObject(6959, 2109.521484375, 1122.8806152344, 501.13320922852, 270.20843505859, 0, 180.19226074219);
  115. CreateDynamicObject(6959, 2148.7138671875, 1123.0314941406, 501.17834472656, 270.20843505859, 0, 180.19226074219);
  116. CreateDynamicObject(6959, 2188.8784179688, 1123.1716308594, 501.24435424805, 270.20843505859, 0, 180.19226074219);
  117. CreateDynamicObject(6959, 2229.4143066406, 1123.3292236328, 501.34625244141, 270.20843505859, 0, 180.19226074219);
  118. CreateDynamicObject(6959, 2252.1298828125, 1103.4777832031, 501.42965698242, 270.20843505859, 0, 96.192260742188);
  119. CreateDynamicObject(6959, 2256.7580566406, 1062.5612792969, 501.48922729492, 270.20843505859, 0, 96.77685546875);
  120. CreateDynamicObject(6959, 2261.3747558594, 1022.0999145508, 501.47198486328, 270.20843505859, 0, 96.190795898438);
  121. CreateDynamicObject(6959, 2265.7524414063, 981.84350585938, 501.52798461914, 270.20843505859, 0, 96.190795898438);
  122. CreateDynamicObject(6959, 2270.1574707031, 941.18463134766, 501.50936889648, 270.20843505859, 0, 96.190795898438);
  123. CreateDynamicObject(6959, 2200.2358398438, 915.98400878906, 501.46380615234, 270.20843505859, 0, 184.19079589844);
  124. CreateDynamicObject(6959, 2233.7119140625, 918.12268066406, 501.52398681641, 270.20367431641, 0, 184.18579101563);
  125. CreateDynamicObject(18226, 2265.7888183594, 907.97174072266, 470.82650756836, 0, 0, 323.99230957031);
  126. CreateDynamicObject(6959, 2261.0905761719, 920.13531494141, 501.43957519531, 270.20324707031, 0, 184.18579101563);
  127. CreateDynamicObject(16771, 2093.8022460938, 1078.4235839844, 480.57723999023, 0, 0, 270);
  128. CreateDynamicObject(16771, 2220.8095703125, 956.50225830078, 480.56631469727, 0, 0, 6);
  129. CreateDynamicObject(18364, 2204.3254394531, 1073.1801757813, 481.21002197266, 1.3940124511719, 0, 0);
  130. CreateDynamicObject(18364, 2231.3510742188, 986.39978027344, 480.45767211914, 0, 0, 334);
  131. CreateDynamicObject(18364, 2105.0642089844, 1093.966796875, 481.52575683594, 0, 0, 176);
  132. CreateDynamicObject(3887, 2168.4274902344, 1052.5034179688, 482.21435546875, 0, 0, 224);
  133. CreateDynamicObject(3866, 2232.6201171875, 1094.7624511719, 483.62554931641, 0, 0, 48);
  134. CreateDynamicObject(3932, 2100.4777832031, 1060.3374023438, 477.35998535156, 0, 0, 90);
  135. CreateDynamicObject(3932, 2094.609375, 1060.3492431641, 477.31686401367, 0, 0, 90);
  136. CreateDynamicObject(3932, 2201.7158203125, 964.16137695313, 476.33602905273, 0, 0, 5.7780456542969);
  137. CreateDynamicObject(3932, 2202.3037109375, 958.33569335938, 476.3388671875, 0, 0, 5.7733154296875);
  138. CreateDynamicObject(1271, 2239.1364746094, 1089.7847900391, 476.49624633789, 0, 0, 0);
  139. CreateDynamicObject(1271, 2239.4802246094, 1089.4331054688, 477.11535644531, 0, 0, 330);
  140. CreateDynamicObject(1271, 2239.8583984375, 1088.9558105469, 477.76321411133, 0, 0, 359.99633789063);
  141. CreateDynamicObject(18257, 2236.5656738281, 1096.3571777344, 475.95559692383, 0, 0, 268);
  142. CreateDynamicObject(923, 2228.5549316406, 1082.2175292969, 484.70651245117, 0, 0, 340);
  143. CreateDynamicObject(923, 2231.3269042969, 1080.6478271484, 484.73046875, 0, 0, 257.99938964844);
  144. CreateDynamicObject(923, 2229.7858886719, 1081.1529541016, 480.63049316406, 0, 0, 317.99743652344);
  145. CreateDynamicObject(944, 2223.6586914063, 1082.0430908203, 476.57135009766, 0, 0, 8);
  146. CreateDynamicObject(944, 2184.8732910156, 1041.9981689453, 486.17803955078, 0, 0, 7.998046875);
  147. CreateDynamicObject(944, 2174.6052246094, 1055.0467529297, 481.91946411133, 0, 0, 251.998046875);
  148. CreateDynamicObject(923, 2164.2182617188, 1063.2644042969, 481.91436767578, 0, 0, 351.99377441406);
  149. CreateDynamicObject(3865, 2210.2414550781, 1059.8427734375, 476.55123901367, 0, 0, 34);
  150. CreateDynamicObject(3865, 2198.8540039063, 1071.7733154297, 476.85665893555, 0, 0, 310);
  151. CreateDynamicObject(3470, 2221.837890625, 1086.6173095703, 479.82446289063, 0, 0, 228);
  152. CreateDynamicObject(3470, 2219.1977539063, 1089.0161132813, 485.41903686523, 0, 0, 227.99926757813);
  153. CreateDynamicObject(3470, 2216.5971679688, 1091.3125, 490.80905151367, 0, 0, 227.99928283691);
  154. CreateDynamicObject(3470, 2221.6337890625, 1086.7882080078, 490.57659912109, 0, 0, 227.99928283691);
  155. CreateDynamicObject(3470, 2222.2824707031, 1098.7987060547, 483.07022094727, 0, 0, 137.99923706055);
  156. CreateDynamicObject(3470, 2220.2390136719, 1096.3289794922, 487.22125244141, 0, 0, 137.99377441406);
  157. CreateDynamicObject(3470, 2226.9228515625, 1103.8453369141, 490.97094726563, 0, 0, 137.99377441406);
  158. CreateDynamicObject(3470, 2224.7006835938, 1101.3376464844, 487.6266784668, 0, 0, 137.99377441406);
  159. CreateDynamicObject(923, 2244.2312011719, 1120.5091552734, 489.77047729492, 359.46331787109, 332.32470703125, 317.71234130859);
  160. CreateDynamicObject(923, 2239.5986328125, 1120.0104980469, 491.61242675781, 2.8660888671875, 32.36669921875, 356.17532348633);
  161. CreateDynamicObject(923, 2240.9099121094, 1116.3311767578, 487.51043701172, 359.46166992188, 332.31994628906, 317.70812988281);
  162. CreateDynamicObject(3633, 2157.9792480469, 1063.0842285156, 480.88806152344, 0, 0, 76.258544921875);
  163. CreateDynamicObject(3633, 2157.6137695313, 1064.6286621094, 480.86602783203, 0, 0, 50.256103515625);
  164. CreateDynamicObject(923, 2157.8815917969, 1063.5124511719, 482.25540161133, 0, 0, 277.99096679688);
  165. CreateDynamicObject(3633, 2175.142578125, 1078.0238037109, 476.71633911133, 0, 0, 50.25146484375);
  166. CreateDynamicObject(3799, 2201.0124511719, 1054.3734130859, 474.82885742188, 0, 0, 342);
  167. CreateDynamicObject(3576, 2189.2009277344, 1038.8822021484, 491.84182739258, 0, 0, 80);
  168. CreateDynamicObject(3632, 2175.1440429688, 1079.2862548828, 476.59979248047, 44, 0, 0);
  169. CreateDynamicObject(3632, 2157.0556640625, 1065.7664794922, 480.47903442383, 78, 0, 34);
  170. CreateDynamicObject(3632, 2168.4211425781, 1061.9650878906, 481.50946044922, 0, 0, 0);
  171. CreateDynamicObject(3632, 2229.1906738281, 1093.5858154297, 476.4296875, 0, 0, 0);
  172. CreateDynamicObject(3632, 2228.3989257813, 1093.3438720703, 476.37121582031, 48, 0, 106);
  173. CreateDynamicObject(3630, 2173.4816894531, 1052.291015625, 476.32650756836, 0, 0, 260);
  174. CreateDynamicObject(1271, 2173.9025878906, 1051.4014892578, 476.67449951172, 0, 0, 347.99450683594);
  175. CreateDynamicObject(5118, 2172.4372558594, 1085.2030029297, 475.79595947266, 0, 0, 0);
  176. CreateDynamicObject(5118, 2219.0180664063, 1023.1607055664, 474.71975708008, 0, 0, 318);
  177. CreateDynamicObject(11446, 2176.6411132813, 1097.0035400391, 476.03805541992, 0, 0, 22);
  178. CreateDynamicObject(11445, 2228.0268554688, 1036.6407470703, 474.70767211914, 0, 0, 40);
  179. CreateDynamicObject(11442, 2223.37890625, 1054.8240966797, 475.02996826172, 0, 0, 328);
  180. CreateDynamicObject(11445, 2209.6896972656, 1076.5476074219, 475.77575683594, 0, 0, 239.99572753906);
  181. CreateDynamicObject(3524, 2115.7995605469, 1064.7757568359, 476.83990478516, 0, 0, 100);
  182. CreateDynamicObject(3524, 2115.7885742188, 1092.3663330078, 476.73727416992, 0, 0, 89.99755859375);
  183. CreateDynamicObject(3524, 2204.8615722656, 976.91528320313, 476.2158203125, 0, 0, 185.99449157715);
  184. CreateDynamicObject(3524, 2231.8334960938, 979.85943603516, 476.0436706543, 0, 0, 185.99304199219);
  185. CreateDynamicObject(2985, 2190.5485839844, 1040.1667480469, 491.82083129883, 0, 0, 22.645904541016);
  186. CreateDynamicObject(745, 2244.6599121094, 1030.8128662109, 474.71408081055, 0, 0, 200);
  187. CreateDynamicObject(745, 2241.0400390625, 1029.2017822266, 473.88488769531, 0, 0, 199.9951171875);
  188. CreateDynamicObject(745, 2236.7292480469, 1026.34375, 473.67477416992, 0, 0, 199.9951171875);
  189. CreateDynamicObject(745, 2234.4213867188, 1023.2528686523, 473.84692382813, 0, 0, 279.9951171875);
  190. CreateDynamicObject(745, 2237.359375, 1024.6936035156, 473.57879638672, 0, 0, 327.99206542969);
  191. CreateDynamicObject(745, 2243.1384277344, 1025.7980957031, 473.50903320313, 0, 0, 327.99133300781);
  192. CreateDynamicObject(745, 2237.7102050781, 1031.7114257813, 473.53079223633, 0, 0, 359.99133300781);
  193. CreateDynamicObject(745, 2242.4184570313, 1038.7572021484, 473.81149291992, 0, 0, 359.98901367188);
  194. CreateDynamicObject(745, 2237.4565429688, 1046.2800292969, 473.83602905273, 0, 0, 61.989013671875);
  195. CreateDynamicObject(745, 2248.869140625, 1048.6693115234, 473.95379638672, 0, 0, 325.98901367188);
  196. CreateDynamicObject(745, 2224.3642578125, 1046.7548828125, 472.8659362793, 0, 0, 61.98486328125);
  197. CreateDynamicObject(745, 2193.1228027344, 1059.3630371094, 472.71197509766, 0, 0, 61.98486328125);
  198. CreateDynamicObject(745, 2192.765625, 1095.982421875, 474.6360168457, 0, 0, 121.98486328125);
  199. CreateDynamicObject(3585, 2183.8239746094, 1090.1614990234, 477.48513793945, 0, 0, 0);
  200. CreateDynamicObject(3585, 2218.3654785156, 1024.9951171875, 476.30401611328, 0, 0, 317.39392089844);
  201. CreateDynamicObject(3632, 2183.7658691406, 1091.9145507813, 476.20797729492, 69.71533203125, 0, 5.9971923828125);
  202. CreateDynamicObject(3632, 2217.2448730469, 1023.6416625977, 475.01956176758, 69.713745117188, 0, 139.99304199219);
  203.  
  204. return 1;
  205. }
  206.  
  207.  
  208. public OnVehicleSpawn(vehicleid)
  209. {
  210.  
  211. return 1;
  212. }
  213.  
  214. public OnGameModeExit()
  215. {
  216. mysql_close();
  217. return 1;
  218. }
  219.  
  220. public OnPlayerRequestClass(playerid, classid)
  221. {
  222. if(GetPVarInt(playerid,"Eingeloggt") == 0)
  223. {
  224. if(mysql_CheckAccount(playerid) == 0)
  225. {
  226. SendClientMessage(playerid, 0xFFFFFFFF,"________-> Willkommen auf auf meinem Server <-________");
  227. SendClientMessage(playerid, 0xFFFFFFFF,"Dein Account wurde nicht gefunden, bitte Registriere dich!");
  228. ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"Register","Bitte Gib ein Passwort an:","Register","Exit");
  229. }
  230. else if(mysql_CheckAccount(playerid) == 1)
  231. {
  232. SendClientMessage(playerid, 0xFFFFFFFF,"________-> Willkommen auf auf meinem Server <-________");
  233. SendClientMessage(playerid, 0xFFFFFFFF,"Dein Account wurde gefunden, bitte Log dich nun ein!");
  234. ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Bitte gib dein Passwort ein:","Login","Abbrechen");
  235. }
  236. }
  237. return 1;
  238. }
  239.  
  240. public OnPlayerConnect(playerid)
  241. {
  242. SendClientMessage(playerid, 0xFFA500AA,"");
  243. SendClientMessage(playerid, 0xFFA500AA,"");
  244. SendClientMessage(playerid, 0xFFA500AA,"");
  245. SendClientMessage(playerid, 0xFFA500AA,"");
  246. SendClientMessage(playerid, 0xFFA500AA,"");
  247. SendClientMessage(playerid, 0xFFA500AA,"");
  248. SendClientMessage(playerid, 0xFFA500AA,"");
  249. SendClientMessage(playerid, 0xFFA500AA,"Weihnachtsferien.");
  250. new string[128];
  251. new spname[MAX_PLAYER_NAME];
  252. GetPlayerName(playerid, spname, sizeof(spname));
  253. format(string,sizeof(string),"INFO: Spieler %s [ID: %d] hat den Server betreten", spname,playerid);
  254. SendClientMessageToAll(COLOR_OOC,string);
  255. SetPlayerVirtualWorld(playerid,0);
  256.  
  257. return 1;
  258. }
  259.  
  260. public OnPlayerDisconnect(playerid, reason)
  261. {
  262. SavePlayer(playerid);
  263. DeletePVar(playerid,"Eingeloggt");
  264.  
  265. new string[150];
  266. new spname[MAX_PLAYER_NAME];
  267. GetPlayerName(playerid,spname,sizeof(spname));
  268. switch(reason)
  269. {
  270. case 0: format(string,sizeof (string),"INFO: Spieler %s hatte einen Timeout",spname);
  271. case 1: format(string,sizeof (string),"INFO: Spieler %s hat den Server verlassen",spname);
  272. case 2: format(string,sizeof (string),"INFO: Spieler %s [ID: %d] wurde gekickt/gebannt",spname,playerid);
  273. }
  274. SendClientMessageToAll(COLOR_OOC,string);
  275.  
  276. return 1;
  277. }
  278.  
  279. public OnPlayerSpawn(playerid)
  280. {
  281.  
  282. SetPlayerPos(playerid,1542.1978,-1674.7806,13.5540);
  283. SetPlayerFacingAngle(playerid,89.1676);
  284. return 1;
  285. }
  286.  
  287. public OnPlayerDeath(playerid, killerid, reason)
  288. {
  289. SetPlayerWantedLevel(playerid, 0);
  290.  
  291. return 1;
  292. }
  293.  
  294. public OnVehicleDeath(vehicleid, killerid)
  295. {
  296. return 1;
  297. }
  298.  
  299. public OnPlayerText(playerid, text[])
  300. {
  301. return 1;
  302. }
  303.  
  304. public OnPlayerCommandText(playerid, cmdtext[])
  305. {
  306. if(strcmp("/start", cmdtext, true) == 0)
  307. {
  308. ShowPlayerDialog(playerid,105,DIALOG_STYLE_LIST,"Auswahl","{22FF00}MENSCH\n{FF0000}ZOMBIE","OK","");
  309. return 1;
  310. }
  311. return 1;
  312. }
  313.  
  314. public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
  315. {
  316. return 1;
  317. }
  318.  
  319. public OnPlayerExitVehicle(playerid, vehicleid)
  320. {
  321.  
  322. return 1;
  323. }
  324.  
  325. public OnPlayerStateChange(playerid, newstate, oldstate)
  326. {
  327.  
  328. return 1;
  329. }
  330.  
  331.  
  332.  
  333. public OnPlayerEnterCheckpoint(playerid)
  334. {
  335. return 1;
  336. }
  337.  
  338. public OnPlayerLeaveCheckpoint(playerid)
  339. {
  340. return 1;
  341. }
  342.  
  343. public OnPlayerEnterRaceCheckpoint(playerid)
  344. {
  345. return 1;
  346. }
  347.  
  348. public OnPlayerLeaveRaceCheckpoint(playerid)
  349. {
  350. return 1;
  351. }
  352.  
  353. public OnRconCommand(cmd[])
  354. {
  355. return 1;
  356. }
  357.  
  358. public OnPlayerRequestSpawn(playerid)
  359. {
  360. return 1;
  361. }
  362.  
  363. public OnObjectMoved(objectid)
  364. {
  365. return 1;
  366. }
  367.  
  368. public OnPlayerObjectMoved(playerid, objectid)
  369. {
  370. return 1;
  371. }
  372.  
  373. public OnPlayerPickUpPickup(playerid, pickupid)
  374. {
  375. return 1;
  376. }
  377.  
  378. public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
  379. {
  380. return 1;
  381. }
  382.  
  383. public OnVehicleRespray(playerid, vehicleid, color1, color2)
  384. {
  385. return 1;
  386. }
  387.  
  388. public OnPlayerExitedMenu(playerid)
  389. {
  390. return 1;
  391. }
  392.  
  393. public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
  394. {
  395. return 1;
  396. }
  397.  
  398. public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
  399. {
  400.  
  401. return 1;
  402. }
  403.  
  404.  
  405. public OnRconLoginAttempt(ip[], password[], success)
  406. {
  407. return 1;
  408. }
  409.  
  410. public OnPlayerUpdate(playerid)
  411. {
  412.  
  413. return 1;
  414. }
  415.  
  416. public OnPlayerStreamIn(playerid, forplayerid)
  417. {
  418. return 1;
  419. }
  420.  
  421. public OnPlayerStreamOut(playerid, forplayerid)
  422. {
  423. return 1;
  424. }
  425.  
  426. public OnVehicleStreamIn(vehicleid, forplayerid)
  427. {
  428. return 1;
  429. }
  430.  
  431. public OnVehicleStreamOut(vehicleid, forplayerid)
  432. {
  433. return 1;
  434. }
  435.  
  436. public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
  437. {
  438. if(dialogid == 105)
  439. {
  440. if(listitem == 0)
  441. {
  442. new RandomTl = random(5);
  443. switch(RandomTl)
  444. {
  445. case 0: SetPlayerPos(playerid,2155.0940,1058.5396,481.8625);
  446. case 1: SetPlayerPos(playerid,2210.0044,1059.6101,476.1281);
  447. case 2: SetPlayerPos(playerid,2219.0857,1024.0841,476.5229);
  448. case 3: SetPlayerPos(playerid,2230.8157,1082.7217,484.8508);
  449. case 4: SetPlayerPos(playerid,2210.1804,1072.2139,476.4348);
  450. }
  451. new dragName[MAX_PLAYER_NAME];
  452. new string2[100];
  453. GetPlayerName(playerid, dragName, sizeof(dragName));
  454. format(string2, sizeof(string2), "{ACFF00}« {FFFF00}%s {ACFF00}Ging nach /start »", dragName);
  455. SendClientMessageToAll(COLOR_YELLOW, string2);
  456. SendClientMessage(playerid, COLOR_RED, "[SERVER INFO]: Menschen Killen {33AA33}ZOMBIES {ff001b}Schutzen vor Infizierung!");
  457. ResetPlayerWeapons(playerid);
  458. SetPlayerHealth(playerid, 100);
  459. SetPlayerSkin(playerid,285);
  460. GivePlayerWeapon(playerid,29,100000);
  461. GivePlayerWeapon(playerid,31,100000);
  462. GivePlayerWeapon(playerid,25,100000);
  463. GivePlayerWeapon(playerid,44,1);
  464. SetPlayerWeather(playerid, 9);
  465. SetPlayerTime(playerid, 0, 0);
  466. SetPlayerColor(playerid, COLOR_RED);
  467. }
  468.  
  469. if(listitem == 1)
  470. {
  471. new RandomTl = random(5);
  472. switch(RandomTl)
  473. {
  474. case 0: SetPlayerPos(playerid,2155.0940,1058.5396,481.8625);
  475. case 1: SetPlayerPos(playerid,2210.0044,1059.6101,476.1281);
  476. case 2: SetPlayerPos(playerid,2219.0857,1024.0841,476.5229);
  477. case 3: SetPlayerPos(playerid,2230.8157,1082.7217,484.8508);
  478. case 4: SetPlayerPos(playerid,2210.1804,1072.2139,476.4348);
  479. }
  480. new dragName[MAX_PLAYER_NAME];
  481. new string2[100];
  482. GetPlayerName(playerid, dragName, sizeof(dragName));
  483. format(string2, sizeof(string2), "{ACFF00}« {FFFF00}%s {ACFF00}Ging nach /start »", dragName);
  484. SendClientMessageToAll(COLOR_YELLOW, string2);
  485. SendClientMessage(playerid, COLOR_GREEN, "[SERVER INFO]: Zombies killen Meschen {ff001b}Meschen {33AA33}Tötten dich!");
  486. ResetPlayerWeapons(playerid);
  487. SetPlayerHealth(playerid, 100);
  488. SetPlayerSkin(playerid,162);
  489. ApplyAnimation(playerid,"PED", "WALK_DRUNK",4.0,1,1,1,1,500);
  490. GivePlayerWeapon(playerid,24,1);
  491. GivePlayerWeapon(playerid,9,200);
  492. GivePlayerWeapon(playerid,6,1);
  493. SetPlayerWeather(playerid, 9);
  494. SetPlayerTime(playerid, 0, 0);
  495. SetPlayerColor(playerid, COLOR_GREEN);
  496. }
  497. }
  498. switch(dialogid)
  499. {
  500. case DIALOG_REGISTER:
  501. {
  502. if(response)
  503. {
  504. if(strlen(inputtext) == 0) // Wenn kein Passwort angegebene wurde
  505. {
  506. ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"Register","Das angegebene Passwort war zu Kurz...\nBitte Registrier dich jetzt mit einem Passwort:","Register","Abbrechen");
  507. return 1;
  508. }
  509. else
  510. {
  511. CreateAccount(playerid, inputtext); //Account wird erstellt
  512. SetPVarInt(playerid,"Eingeloggt",1); //Die variable wird auf 1 gesetzt, damit wir nun die Skin Auswahl benutzen können ohne wieder nach unserem Passwort gefragt zu werden.
  513. SpawnPlayer(playerid); //Wir lassen den Spieler Spawnen
  514. return 1;
  515. }
  516. }
  517. else
  518. {
  519. Kick(playerid); //Wenn auf Abbrechen geklickt wurde, wird der Spieler gekickt damit man ohne Account nicht Spielen kann.
  520. }
  521. }
  522. case DIALOG_LOGIN:
  523. {
  524. if(response)
  525. {
  526. if(strlen(inputtext) == 0) // Wenn kein Passwort angegebene wurde
  527. {
  528. ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Das Angegebene Passwort war Falsch.\nBitte log dich jetzt mit dem richtigen Passwort ein:","Login","Abbrechen");
  529. return 1;
  530. }
  531. else
  532. {
  533. new SpielerName[MAX_PLAYER_NAME];
  534. GetPlayerName(playerid, SpielerName, MAX_PLAYER_NAME);
  535. if(!strcmp(inputtext, mysql_ReturnPasswort(SpielerName), true)) // Wir holen uns das Passwort aus der MySQL Datenbank und überprüfen es mit dem angegebenen passwort.
  536. {
  537. SetPVarInt(playerid,"Eingeloggt",1); //Falls beide passwörter übereinstimmen wird die Variable auf 1 gesetzt damit wir die Skin auswahl benutzen können.
  538. LoadPlayer(playerid); //Der Spieler wird "geladen", speich es werden seine Daten aus der Datenbank geholt und in variablen gespeichert um diese im Skript zu verwenden.
  539. SpawnPlayer(playerid); //Wir lassen den Spieler Spawnen
  540. return 1;
  541. }
  542. else
  543. {
  544. //Wenn das Passwort falsch war, lassen wir erneut das Login fenster erscheinen damit der Spieler das Richtige Passwort eingibt.
  545. ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Das war das Falsche Passwort.\nBitte log dich jetzt mit dem richtigen Passwort ein:","Login","Abbrechen");
  546. return 1;
  547. }
  548. }
  549. }
  550. else
  551. {
  552. Kick(playerid); //Wenn auf Abbrechen geklickt wurde, wird der Spieler gekickt damit man ohne Account nicht Spielen kann.
  553. }
  554. }
  555. }
  556. return 1;
  557. }
  558.  
  559.  
  560. public OnPlayerTakeDamage(playerid, issuerid, Float: amount, weaponid)
  561. {
  562.  
  563. return 1;
  564. }
  565.  
  566.  
  567. public OnVehicleMod(playerid,vehicleid,componentid)
  568. {
  569.  
  570. return 1;
  571. }
  572. //mysql Login
  573. stock Connect_To_Database()
  574. {
  575. 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.
  576. if(mysql_ping() == 1) //Es wird überprüft ob die Verbindung steht.
  577. {
  578. //Falls ja wird das in die Console geschrieben und die Funktion wird beendet.
  579. print("<-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!");
  580. return true;
  581. }
  582. else
  583. {
  584. //Falls nicht wird erneut versucht eine Verbindung aufzubauen.
  585. print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
  586. print("<-| [MYSQL] Es wird erneut versucht eine Verbindung zur Datenbank herzustellen!");
  587. mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
  588. if(mysql_ping() == 1)
  589. {
  590. print("<-| [MYSQL] Es konnte im 2 Versuch eine Verbindung hergestellt werden!");
  591. return true;
  592. }
  593. else
  594. {
  595. //Falls das auch nicht Funktioniert wird der Server zur Sicherheit wieder heruntergefahren.
  596. print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
  597. print("<-| [MYSQL] Der Server wird nun beendet!");
  598. SendRconCommand("exit");
  599. return true;
  600. }
  601. }
  602. }
  603.  
  604. stock mysql_CheckAccount(playerid)
  605. {
  606. mysql_reconnect();//Das Blue G verliert gerne die Verbindung damit stellen wir die wieder her
  607. new Query[128],Name[MAX_PLAYER_NAME],count;
  608. GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
  609. mysql_real_escape_string(Name, Name);
  610. format(Query, sizeof(Query), "SELECT * FROM `accounts` WHERE `Name` = '%s'", Name);
  611. mysql_query(Query);
  612. mysql_store_result();
  613. count = mysql_num_rows();
  614. mysql_free_result();
  615. return count;
  616. }
  617. stock CreateAccount(playerid, pass[])
  618. {
  619. mysql_reconnect();
  620. new query[256],Name[MAX_PLAYER_NAME];
  621. GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
  622. mysql_real_escape_string(Name,Name);
  623. mysql_real_escape_string(pass,pass);
  624. format(query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Passwort`) VALUES ('%s', '%s')", Name, pass);
  625. mysql_query(query);
  626. return true;
  627. }
  628. stock mysql_ReturnPasswort(Name[])
  629. {
  630. mysql_reconnect();
  631. new query[130], Get[130];
  632. mysql_real_escape_string(Name, Name);
  633. format(query, 128, "SELECT `passwort` FROM `accounts` WHERE `Name` = '%s'", Name);
  634. mysql_query(query);
  635. mysql_store_result();
  636. mysql_fetch_row(Get);
  637. mysql_free_result();
  638. return Get;
  639. }
  640. stock LoadPlayer(playerid)
  641. {
  642. if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))//Wir fragen ab ob der angegebene Spieler auch Online ist, und kein NPC ist (nur zur sicherhheit)
  643. {
  644. new Name[64]; //das wihcigste ^^ ehm wie frage ich Admin ab? mom das mach ich eben rein
  645. GetPlayerName(playerid, Name, 64);//mom
  646. SetPlayerScore(playerid,mysql_GetInt("accounts", "Level", "Name", Name)); //Wir holen uns den wert der unter "Level" eingetragen ist und Speichern ihn in unserer Variable.
  647. GivePlayerMoney(playerid,mysql_GetInt("accounts", "Geld", "Name", Name)); //Wir holen uns den wert der unter "Geld" eingetragen ist und Speichern ihn in unserer Variable.
  648. //SpielerInfo[playerid][pKills] = mysql_GetInt("accounts", "Kills", "Name", Name); //Wir holen uns den wert der unter "Kills" eingetragen ist und Speichern ihn in unserer Variable.
  649. //SpielerInfo[playerid][pTode] = mysql_GetInt("accounts", "Tode", "Name", Name); //Wir holen uns den wert der unter "Tode" eingetragen ist und Speichern ihn in unserer Variable.
  650. //SpielerInfo[playerid][pAdmin] = mysql_GetInt("accounts", "Admin", "Name", Name);
  651. }
  652. return 1;
  653. }
  654. stock mysql_GetInt(Table[], Field[], Where[], Is[])
  655. {
  656. mysql_reconnect();
  657. new query[128];
  658. mysql_real_escape_string(Table, Table);
  659. mysql_real_escape_string(Field, Field);
  660. mysql_real_escape_string(Where, Where);
  661. mysql_real_escape_string(Is, Is);
  662. format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
  663. mysql_query(query);
  664. mysql_store_result();
  665. new sqlint = mysql_fetch_int();
  666. mysql_free_result();
  667. return sqlint;
  668. }
  669. stock mysql_GetString(Table[], Field[], Where[], Is[])
  670. {
  671. mysql_reconnect();
  672. new query[128], Get[128];
  673. mysql_real_escape_string(Table, Table);
  674. mysql_real_escape_string(Field, Field);
  675. mysql_real_escape_string(Where, Where);
  676. mysql_real_escape_string(Is, Is);
  677. format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
  678. mysql_query(query);
  679. mysql_store_result();
  680. mysql_fetch_row(Get);
  681. mysql_free_result();
  682. return Get;
  683. }
  684. stock Float:mysql_GetFloat(Table[], Field[], Where[], Is[])
  685. {
  686. mysql_reconnect();
  687. new query[128], Float:sqlfloat;
  688. mysql_real_escape_string(Table, Table);
  689. mysql_real_escape_string(Field, Field);
  690. mysql_real_escape_string(Where, Where);
  691. mysql_real_escape_string(Is, Is);
  692. format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
  693. mysql_query(query);
  694. mysql_store_result();
  695. mysql_fetch_float(sqlfloat);
  696. mysql_free_result();
  697. return sqlfloat;
  698. }
  699. stock SavePlayer(playerid)
  700. {
  701. if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid)) //wir überprüfen ob der Spieler überhaupt noch Connected ist und ob er nicht ein NPC ist.
  702. {
  703. if(GetPVarInt(playerid,"Eingeloggt") == 1) //Und hier ob er noch eingeloggt ist.
  704. {
  705. new Name[64];
  706. GetPlayerName(playerid, Name, 64);
  707. mysql_SetInt("accounts", "Level", GetPlayerScore(playerid), "Name", Name);
  708. mysql_SetInt("accounts", "Geld", GetPlayerMoney(playerid), "Name", Name);
  709. // mysql_SetInt("accounts", "Kills", SpielerInfo[playerid][pKills], "Name", Name);
  710. // mysql_SetInt("accounts", "Tode", SpielerInfo[playerid][pTode], "Name",Name);
  711. // mysql_SetInt("accounts", "Admin", SpielerInfo[playerid][pAdmin], "Name",Name);
  712. }
  713. }
  714. return 1;
  715. }
  716. stock mysql_SetInt(Table[], Field[], To, Where[], Where2[])
  717. {
  718. mysql_reconnect();
  719. new query[128];
  720. mysql_real_escape_string(Table, Table);
  721. mysql_real_escape_string(Field, Field);
  722. mysql_real_escape_string(Where, Where);
  723. mysql_real_escape_string(Where2, Where2);
  724. format(query, 128, "UPDATE `%s` SET `%s` = '%d' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
  725. mysql_query(query);
  726. return true;
  727. }
  728. stock mysql_SetString(Table[], Field[], To[], Where[], Where2[])
  729. {
  730. mysql_reconnect();
  731. new query[128];
  732. mysql_real_escape_string(Table, Table);
  733. mysql_real_escape_string(Field, Field);
  734. mysql_real_escape_string(To, To);
  735. mysql_real_escape_string(Where, Where);
  736. mysql_real_escape_string(Where2, Where2);
  737. format(query, 128, "UPDATE `%s` SET `%s` = '%s' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
  738. mysql_query(query);
  739. return true;
  740. }
  741. stock mysql_SetFloat(Table[], Field[], Float:To, Where[], Where2[])
  742. {
  743. mysql_reconnect();
  744. new query[128];
  745. mysql_real_escape_string(Table, Table);
  746. mysql_real_escape_string(Field, Field);
  747. mysql_real_escape_string(Where, Where);
  748. mysql_real_escape_string(Where2, Where2);
  749. format(query, 128, "UPDATE `%s` SET `%s` = '%f' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
  750. mysql_query(query);
  751. return true;
  752. }
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!