1. #include <a_samp>
  2. #include <a_mysql>
  4. #define MYSQL_SERVER "HOST"
  5. #define MYSQL_USER "USUARIO"
  6. #define MYSQL_PASSWORD "CONTRASEÑA"
  7. #define MYSQL_DB "BASE DE DATOS"
  9. forward ActualizarClima();
  10. new NumeroClima[2];
  12. public OnFilterScriptInit()
  13. {
  14. print("\n--------------------------------------");
  15. print("Sistema de Clima Real por The Scope");
  16. print("--------------------------------------\n");
  18. mysql_connect(#MYSQL_SERVER,#MYSQL_USER,#MYSQL_USER,#MYSQL_PASSWORD);
  19. ActualizarClima();
  20. return 1;
  21. }
  23. public OnFilterScriptExit()
  24. {
  25. mysql_close();
  26. return 1;
  27. }
  29. public ActualizarClima()
  30. {
  31. new query[300], savingstring[20];
  32. format(query, sizeof(query), "SELECT * FROM ClimaRealista");
  33. mysql_query(query);
  34. mysql_store_result();
  35. while(mysql_fetch_row_format(query,"|"))
  36. {
  37. mysql_fetch_field_row(savingstring, "NumeroClima"); NumeroClima[0] = strval(savingstring);
  38. mysql_fetch_field_row(savingstring, "DiaNoche"); NumeroClima[1] = strval(savingstring);
  39. }
  40. mysql_free_result();
  42. switch (NumeroClima[1])
  43. {
  44. case 0: SetWorldTime(12); // Noche
  45. case 1: SetWorldTime(0); // Día
  46. }
  47. switch (NumeroClima[0])
  48. {
  49. case 0, 1, 2, 3, 4, 17, 35, 37, 38, 47, 48: SetWeather(8); // Tormenta
  50. case 5, 6, 7, 8, 9, 10, 11, 12, 18, 39, 40, 45: SetWeather(16); // Lluvia
  51. case 13, 14, 15, 16, 41, 42, 43, 46: SetWeather(16); // Nieve
  52. case 19, 21, 22, 23: SetWeather(2); // Nievla Soleado
  53. case 26: SetWeather(36); // Nubleado
  54. case 27, 28, 29, 30, 36: SetWeather(33); // Nubleado Soleado
  55. case 31, 32, 33, 34: SetWeather(46); // Soleado
  56. }
  57. SetTimer("ActualizarClima", 300000, false);//5 Minutos
  58. }