Guest User

Untitled

a guest
Apr 26th, 2016
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.63 KB | None | 0 0
  1. forward LoadingSandeliai(skaina, sPavadinimas[], Float:sX,Float:sY,Float:sZ);
  2. public LoadingSandeliai(skaina, sPavadinimas[], Float:sX,Float:sY,Float:sZ)
  3. {
  4. Sandeliu++;
  5.  
  6. new textx[220];
  7. new rows, fields;
  8. cache_get_data(rows, fields);
  9.  
  10. if(rows)
  11. {
  12. s_Sandelys[Sandeliu][s_ID] = cache_get_field_content_int(0, "ID");
  13. format(s_Sandelys[Sandeliu][s_Owner],MAX_PLAYER_NAME,"%s",s_Sandelys[Sandeliu][s_Owner]);
  14. strmid(s_Sandelys[Sandeliu][s_Pavadinimas],"%s",s_Sandelys[Sandeliu][s_Pavadinimas],30,30);
  15. s_Sandelys[Sandeliu][s_Nupirktas] = cache_get_field_content_int(0,"Nupirktas");
  16. s_Sandelys[Sandeliu][s_Price] = cache_get_field_content_int(0,"Kaina");
  17. s_Sandelys[Sandeliu][s_Biudzetas] = cache_get_field_content_int(0,"Biudzetas");
  18. s_Sandelys[Sandeliu][s_Tipas] = cache_get_field_content_int(0,"Tipas");
  19. s_Sandelys[Sandeliu][s_Nuobaudos] = cache_get_field_content_int(0,"Nuobaudos");
  20. s_Sandelys[Sandeliu][s_Slot] = cache_get_field_content_int(0,"Slot");
  21. s_Sandelys[Sandeliu][sXYZ][0] = cache_get_field_content_float(0,"X");
  22. s_Sandelys[Sandeliu][sXYZ][1] = cache_get_field_content_float(0,"Y");
  23. s_Sandelys[Sandeliu][sXYZ][2] = cache_get_field_content_float(0,"Z");
  24.  
  25. printf("[SERVER]: Sandelys nr. %d Pavadinimu - %s uzkrautas zaidejui %s", Sandeliu, s_Sandelys[Sandeliu][s_Pavadinimas], s_Sandelys[Sandeliu][s_Owner]);
  26.  
  27. if(s_Sandelys[Sandeliu][s_Nupirktas] == 1)
  28. {
  29. format(textx,sizeof(textx),"{48DD00}%s\n{FFFFFF}Savininkas: {48DD00}%s",s_Sandelys[Sandeliu][s_Pavadinimas],s_Sandelys[Sandeliu][s_Owner]);
  30. s_Sandelys[Sandeliu][s_Info3D] = Create3DTextLabel(textx, 0x00FF00FF, s_Sandelys[Sandeliu][sXYZ][0], s_Sandelys[Sandeliu][sXYZ][1], s_Sandelys[Sandeliu][sXYZ][2] ,20.0, 0, 1);
  31. s_Sandelys[Sandeliu][s_Valdymas] = CreateDynamicPickup(1314 , 2, s_Sandelys[Sandeliu][sXYZ][0], s_Sandelys[Sandeliu][sXYZ][1], s_Sandelys[Sandeliu][sXYZ][2], 0, -1, -1, 100.0);
  32. }
  33. else
  34. {
  35. return 1;
  36. }
  37.  
  38. }
  39. else
  40. {
  41. new query[512];
  42. format(s_Sandelys[Sandeliu][s_Owner],MAX_PLAYER_NAME,"NONE");
  43. strmid(s_Sandelys[Sandeliu][s_Pavadinimas],sPavadinimas,0,128,128);
  44. s_Sandelys[Sandeliu][s_Price]=skaina;
  45. s_Sandelys[Sandeliu][s_Biudzetas]=0;
  46. s_Sandelys[Sandeliu][s_Nuobaudos]=0;
  47. s_Sandelys[Sandeliu][s_Slot]=0;
  48. s_Sandelys[Sandeliu][sXYZ][0] = sX;
  49. s_Sandelys[Sandeliu][sXYZ][1] = sY;
  50. s_Sandelys[Sandeliu][sXYZ][2] = sZ;
  51. s_Sandelys[Sandeliu][s_Nupirktas] = 0;
  52.  
  53. format(textx,sizeof(textx),"{48DD00}%s\n{FFFFFF}Savininkas: {48DD00}%s",s_Sandelys[Sandeliu][s_Pavadinimas],s_Sandelys[Sandeliu][s_Owner]);
  54. s_Sandelys[Sandeliu][s_Valdymas] = CreateDynamicPickup(1314,2,s_Sandelys[Sandeliu][sXYZ][0],s_Sandelys[Sandeliu][sXYZ][1],s_Sandelys[Sandeliu][sXYZ][2], 0, -1, -1, 100.0);
  55. s_Sandelys[Sandeliu][s_Info3D] = Create3DTextLabel(textx, 0x00FF00FF, s_Sandelys[Sandeliu][sXYZ][0], s_Sandelys[Sandeliu][sXYZ][1], s_Sandelys[Sandeliu][sXYZ][2] ,20.0, 0, 1);
  56.  
  57. mysql_format(mysql, query, sizeof(query), "INSERT INTO `Sandeliai` (`ID`, `Owner`, `Pavadinimas`, `Nupirktas`) VALUES ('%i', '%s', '%s', 0)", Sandeliu, s_Sandelys[Sandeliu][s_Owner], s_Sandelys[Sandeliu][s_Pavadinimas]);
  58. mysql_tquery(mysql, query,"", "");
  59.  
  60. mysql_format(mysql, query, sizeof(query), "UPDATE `Sandeliai` SET `Biudzetas` = %d, `Kaina` = %d, `Nuobaudos` = %d, `X` = %f,`Y` = %f,`Z` = %f WHERE `ID` = %d", s_Sandelys[Sandeliu][s_Biudzetas],s_Sandelys[Sandeliu][s_Price],s_Sandelys[Sandeliu][s_Nuobaudos],sX,sY,sZ,Sandeliu);
  61. mysql_tquery(mysql, query, "", "");
  62.  
  63. printf("[SERVER] Sandelys nr. %d sÄ—kmingai sukurtas!", Sandeliu);
  64. }
  65. return true;
  66. }
Advertisement
Add Comment
Please, Sign In to add comment