1. #include <a_samp>
  2. #include <a_mysql>
  3. #include <streamer>
  4. #include <sscanf2>
  5. #include <zcmd>
  8. #define host "localhost"
  9. #define user "root"
  10. #define db "mydb" /* CHANGE THIS TO YOUR DATABASE NAME */
  11. #define pass ""
  12. #define COLOR_GREY 0xAFAFAFAA
  14. static mysql;
  16. enum aDATA {
  17. aID,
  18. ValidActor,
  19. aName[24],
  20. ActorSkin,
  21. Float:aX,
  22. Float:aY,
  23. Float:aZ,
  24. Float:aA,
  25. Text3D:ActorText,
  26. ActorPlayer,
  27. Actor_AnimLib[30],
  28. Actor_AnimName[30]
  29. };
  30. new ActorData[MAX_ACTORS][aDATA];
  33. /* SQL */
  34. forward OnActorLoad();
  37. #define FILTERSCRIPT
  39. #if defined FILTERSCRIPT
  41. public OnFilterScriptInit()
  42. {
  43. print("\n--------------------------------------");
  44. print(" Blank Filterscript by your name here");
  45. print("--------------------------------------\n");
  47. sql_LoadAllActors();
  48. return 1;
  49. }
  51. public OnFilterScriptExit()
  52. {
  53. return 1;
  54. }
  56. #else
  58. main()
  59. {
  60. print("\n----------------------------------");
  61. print(" Blank Gamemode by your name here");
  62. print("----------------------------------\n");
  63. }
  65. #endif
  69. /* Commands */
  70. CMD:reloadactors(playerid,params[]) {
  71. sql_LoadAllActors();
  72. return true;
  73. }
  75. CMD:changeactoranim(playerid,params[]) {
  76. new id;
  77. if(sscanf(params,"i",id)) return SendClientMessage(playerid,COLOR_GREY,"Usage: /changeactoranim [actorid]");
  79. new calc = id-1;
  80. if(ActorData[calc][ValidActor] == 0) return SendClientMessage(playerid,COLOR_GREY,"<ACTOR SYSTEM> Invalid actor ID");
  82. new animlib[32];
  83. new animname[32];
  84. GetAnimationName(GetPlayerAnimationIndex(playerid),animlib,32,animname,32);
  86. sql_UpdateActorAnim(id,animlib,animname);
  87. SendClientMessage(playerid,COLOR_GREY,"<ACTOR SYSTEM> You have changed actors animation to your current animation. Reload actors to apply effects");
  88. return true;
  89. }
  93. CMD:createactor(playerid,params[]) {
  94. new actorName[24],skin;
  95. if(sscanf(params,"is[24]",skin,actorName)) return SendClientMessage(playerid,COLOR_GREY,"Usage: /createactor [skinid] [name] ");
  96. new Float:x,Float:y,Float:z,Float:a;
  97. GetPlayerPos(playerid,x,y,z);
  98. GetPlayerFacingAngle(playerid,a);
  100. new animlib[32];
  101. new animname[32];
  103. GetAnimationName(GetPlayerAnimationIndex(playerid),animlib,32,animname,32);
  105. sql_CreateActor(actorName, skin, x,y,z,a, animlib, animname);
  107. new string[128];
  108. format(string,sizeof(string), "New actor created. Skin ID: %i Name: %s. Type /reloadactors to reload all actors",skin,actorName);
  109. SendClientMessage(playerid,COLOR_GREY,string);
  110. return true;
  111. }
  113. CMD:setactorskin(playerid,params[]) {
  114. new ss[10],id;
  115. if(sscanf(params,"is[10]",id,ss)) return SendClientMessage(playerid,COLOR_GREY,"Usage: /setactorskin [actorid] [skinid]");
  116. new calc = id-1;
  117. if(ActorData[calc][ValidActor] == 0) return SendClientMessage(playerid,COLOR_GREY,"<ACTOR SYSTEM> Invalid actor ID");
  118. sql_UpdateActor(id,"skin",ss);
  120. new string[128];
  121. format(string,sizeof(string),"<ACTOR SYSTEM> Edited actors ID: %i Skin ID to %s. Reload actors to apply effects",id,ss);
  122. SendClientMessage(playerid,COLOR_GREY,string);
  123. return true;
  124. }
  127. CMD:setactorname(playerid,params[]) {
  128. new ss[24],id;
  129. if(sscanf(params,"is[24]",id,ss))
  130. return SendClientMessage(playerid,COLOR_GREY,"Usage: /setactorname [actorid] [new_name]");
  132. new calc = id-1;
  133. if(ActorData[calc][ValidActor] == 0) return SendClientMessage(playerid,COLOR_GREY,"<ACTOR SYSTEM> Invalid actor ID");
  135. new string[128];
  136. format(string,sizeof(string),"<ACTOR SYSTEM> Edited actors ID: %i name to %s. Reload actors to apply effects",id,ss);
  137. SendClientMessage(playerid,COLOR_GREY,string);
  139. sql_UpdateActor(id,"name",ss);
  140. return true;
  141. }
  143. CMD:moveactor(playerid,params[]) {
  144. new id;
  145. if(sscanf(params,"i",id)) return SendClientMessage(playerid,COLOR_GREY,"Usage: /moveactor [actorid]");
  147. new calc = id-1;
  148. if(ActorData[calc][ValidActor] == 0) return SendClientMessage(playerid,COLOR_GREY,"<ACTOR SYSTEM> Invalid actor ID");
  150. new string[128];
  151. format(string,sizeof(string),"<ACTOR SYSTEM> Actor ID: %i moved to your current location. Reload actors to apply effects",id);
  152. SendClientMessage(playerid,COLOR_GREY,string);
  154. new Float:x,Float:y,Float:z,Float:a;
  155. GetPlayerFacingAngle(playerid,a);
  156. GetPlayerPos(playerid,x,y,z);
  157. sql_MoveActor(id,x,y,z,a);
  158. return true;
  159. }
  162. /* Functions */
  163. sql_CreateActor(name[]="N/A", skin, Float:x, Float:y,Float:z,Float:a,lib[],libname[]) {
  164. new query[256];
  165. mysql_format(mysql,query,sizeof(query),"INSERT INTO `actors` (`Name`,`SkinID`,`X`,`Y`,`Z`,`A`,`anim_lib`,`anim_name`) VALUES ('%e',%i,%f,%f,%f,%f,'%e','%e')",name,skin,x,y,z,a,lib,libname);
  166. mysql_tquery(mysql,query,"","");
  167. }
  169. sql_UpdateActorAnim(id, anim[], animname[]) {
  170. new query[128];
  171. mysql_format(mysql,query,sizeof(query),"UPDATE `actors` SET `anim_lib`='%e', `anim_name`='%e' WHERE `ID`=%d",anim,animname,id);
  172. mysql_tquery(mysql, query, "","");
  173. }
  175. stock PreloadAnimLib(playerid, animlib[])
  176. {
  177. ApplyAnimation(playerid,animlib,"null",0.0,0,0,0,0,0);
  178. }
  180. sql_LoadAllActors() {
  181. for(new i = 0; i < MAX_ACTORS; i++) {
  182. if(ActorData[i][ValidActor] == 1) {
  183. ActorData[i][aID] = 0;
  184. DestroyActor(ActorData[i][ActorPlayer]);
  185. DestroyDynamic3DTextLabel(ActorData[i][ActorText]);
  186. }
  187. }
  188. mysql_tquery(mysql, "SELECT * FROM `actors`", "OnActorLoad", "");
  189. return true;
  190. }
  192. sql_MoveActor(id,Float:x,Float:y,Float:z,Float:a) {
  193. new query[128];
  194. mysql_format(mysql,query,sizeof(query),"UPDATE `actors` SET `X`=%f, `Y`=%f, `Z`=%f, `A`=%f WHERE `ID`=%d",x,y,z,a,id);
  195. mysql_tquery(mysql,query,"","");
  196. }
  199. sql_UpdateActor(id,var[],varamount[]) {
  200. new query[128];
  202. if(strcmp(var,"name") == 0) {
  203. mysql_format(mysql,query,sizeof(query),"UPDATE `actors` SET `Name`='%e' WHERE `ID`=%d",varamount,id);
  204. mysql_tquery(mysql,query,"","");
  205. }
  206. if(strcmp(var,"skin") == 0) {
  207. new val = strval(varamount);
  208. mysql_format(mysql,query,sizeof(query),"UPDATE `actors` SET `SkinID`=%i WHERE `ID`=%d",val,id);
  209. mysql_tquery(mysql,query,"","");
  210. }
  211. }
  213. strcpy(dest[], const source[], maxlength=sizeof dest) strcat((dest[0] = EOS, dest), source, maxlength);
  217. /* SQL Callbacks */
  218. public OnActorLoad() {
  219. new rows = cache_num_rows(),
  220. count = 0,
  221. string[30],
  222. Sname[30],
  223. SLib[30],
  224. SAnimName[30];
  226. for(new i=0; i < rows; i++) {
  227. ActorData[i][ValidActor] = 1;
  228. ActorData[i][aID] = cache_get_field_content_int(i,"ID");
  229. ActorData[i][ActorSkin] = cache_get_field_content_int(i,"SkinID");
  230. ActorData[i][aX] = cache_get_field_content_float(i,"X");
  231. ActorData[i][aY] = cache_get_field_content_float(i,"Y");
  232. ActorData[i][aZ] = cache_get_field_content_float(i,"Z");
  233. ActorData[i][aA] = cache_get_field_content_float(i,"A");
  235. cache_get_field_content(i,"anim_lib",SLib);
  236. strcpy(ActorData[i][Actor_AnimLib],SLib,50);
  238. cache_get_field_content(i,"anim_name",SAnimName);
  239. strcpy(ActorData[i][Actor_AnimName],SAnimName,50);
  241. cache_get_field_content(i,"Name",Sname);
  242. strcpy(ActorData[i][aName],Sname,24);
  245. format(string,sizeof(string),"{00FFFF}%s(%i)",ActorData[i][aName],ActorData[i][aID]);
  246. ActorData[i][ActorText] = CreateDynamic3DTextLabel(string, 0x008080FF,ActorData[i][aX],ActorData[i][aY],ActorData[i][aZ]+1.05, 10.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0);
  247. ActorData[i][ActorPlayer] = CreateActor(ActorData[i][ActorSkin],ActorData[i][aX],ActorData[i][aY],ActorData[i][aZ],ActorData[i][aA]);
  248. count += 1;
  249. ApplyActorAnimation(ActorData[i][ActorPlayer],ActorData[i][Actor_AnimLib],ActorData[i][Actor_AnimName], 4.0, 1, 0, 0, 0, 0);
  250. }
  252. if(count == 0) print("<ACTOR SYSTEM> SQL: No actors found the in the SQL.");
  253. else printf("<ACTOR SYSTEM> Total %i actors loaded.",count);
  254. return true;
  255. }