Guest
Public paste!

Untitled

By: a guest | Mar 21st, 2010 | Syntax: None | Size: 1.66 KB | Hits: 64 | Expires: Never
Copy text to clipboard
  1.  
  2. //MySQL-Stuff
  3. MySQL_CopCarSpawn()
  4. {
  5.         new copcarmodelidQ[256], copcarcoordsXQ[256], copcarcoordsYQ[256], copcarcoordsZQ[256],copcarangleQ[256],copcarcolor1Q[256], copcarcolor2Q[256], copcartimeQ[256];
  6.         MySQLCheck();
  7.         format(copcarmodelidQ,sizeof(copcarmodelidQ),"SELECT modelid FROM `copcars`");
  8.         mysql_query(copcarmodelidQ);
  9.         format(copcarcoordsXQ,sizeof(copcarcoordsXQ),"SELECT coordsx FROM `copcars`");
  10.         mysql_query(copcarcoordsXQ);
  11.         format(copcarcoordsYQ,sizeof(copcarcoordsYQ),"SELECT coordsy FROM `copcars`");
  12.         mysql_query(copcarcoordsYQ);
  13.         format(copcarcoordsZQ,sizeof(copcarcoordsZQ),"SELECT coordsz FROM `copcars`");
  14.         mysql_query(copcarcoordsZQ);
  15.         format(copcarangleQ,sizeof(copcarangleQ),"SELECT angle FROM `copcars`");
  16.         mysql_query(copcarangleQ);
  17.         format(copcarcolor1Q,sizeof(copcarcolor1Q),"SELECT color1 FROM `copcars`");
  18.         mysql_query(copcarcolor1Q);
  19.         format(copcarcolor2Q,sizeof(copcarcolor2Q),"SELECT color2 FROM `copcars`");
  20.         mysql_query(copcarcolor2Q);
  21.         format(copcartimeQ,sizeof(copcartimeQ),"SELECT respawntime FROM `copcars`");
  22.         mysql_query(copcartimeQ);
  23.         AddStaticVehicleEx_MySQL(strval(copcarmodelidQ),floatstr(copcarcoordsXQ),floatstr(copcarcoordsYQ),floatstr(copcarcoordsZQ),floatstr(copcarangleQ),strval(copcarcolor1Q),strval(copcarcolor2Q),strval(copcartimeQ));
  24. }
  25.  
  26. MySQLCheck()
  27. {
  28.         mysql_reconnect();
  29.         return 1;
  30. }
  31.  
  32. forward AddStaticVehicleEx_MySQL(modelid, Float:X, Float:Y, Float:Z, Float:Angle, Color1, Color2, CarRespawnTime);
  33. public AddStaticVehicleEx_MySQL(modelid, Float:X, Float:Y, Float:Z, Float:Angle, Color1, Color2, CarRespawnTime)
  34. {
  35.         AddStaticVehicleEx(modelid, X, Y, Z, Angle, Color1, Color2, CarRespawnTime);
  36.         return 1;
  37. }