View difference between Paste ID: qe0ckkdC and CM9rWENe

 /**
 	Notes:
 		[EN-UK]
 		    - Unfortunately we can't beautify SQL inside strings, they accept only in-line codes.
 			- You're allowed to copy this filterscript without keeping my credits if you want so.
 			- THIS FILTERSCRIPT NEEDS BLUEG'S MYSQL PLUGIN TO WORK.
 			- If this filterscript doesn't work somehow, see mysql_error.txt file inside your server's scriptfiles directory.
 
 		[PT-BR]
 		    - Código completamente livre para ser copiado sem que seja mantido os créditos, afinal, não há como impedir BRs de BRear.
 		    - Caso esta filterscript não funcione veja o log no arquivo mysql_error.txt dentro da pasta scriptfiles do servidor.
 		    - Este filterscript precisa do MySQL plugin (por BlueG) para rodar.
 **/
 
 /** <CHANGEIT> **/
 #define MYSQL_HOST	"" // MySQL IP host / IP do servidor MySQL
 #define MYSQL_USER	"" // MySQL username / Usuário MySQL
 #define MYSQL_PASS	"" // MySQL password / Senha MySQL
 #define MYSQL_DB 	"" // MySQL database / Banco de dados MySQL
 #define MYSQL_FORUMTABLE_PREFIX "" // PhpBB table prefix / Prefixo das tabelas PhpBB
 
 // Portuguese
-#define LANG_SERVER_MESSAGE "[FÓRUM] %s respondeu no tópico '%s'. Sessão: %s."
+#define LANG_SERVER_MESSAGE 			"[FÓRUM] %s respondeu no tópico '%s'. Sessão: %s."
 #define LANG_LOG_BAN_USER 				"[FÓRUM] Moderador %s baniu o usuário '%s' com a razão: '%s'"
 #define LANG_LOG_BAN_IP 				"[FÓRUM] Moderador %s baniu o IP '%s' com a razão: '%s'"
 #define LANG_LOG_UNBAN_USER 			"[FÓRUM] Moderador %s desbaniu o usuário '%s'"
 #define LANG_LOG_DELETE_POST 			"[FÓRUM] Moderador %s deletou o post '%s' criado por '%s' na sessão '%s'"
 #define LANG_LOG_DELETE_SHADOW_TOPIC 	"[FÓRUM] Moderador %s deletou o tópico fantasma '%s' na sessão '%s'"
 #define LANG_LOG_DELETE_TOPIC 			"[FÓRUM] Moderador %s deletou o tópico '%s' criado por '%s' na sessão '%s'"
 #define LANG_LOG_LOCK 					"[FÓRUM] Moderador %s trancou o tópico '%s' na sessão '%s'"
 #define LANG_LOG_MERGE 					"[FÓRUM] Moderador %s juntou posts em um novo tópico '%s' na sessão '%s'"
 #define LANG_LOG_MOVE 					"[FÓRUM] Moderador %s moveu o tópico '%s' de '%s' para '%s'"
-	lastPostId
+#define LANG_LOG_POST_APPROVED 			"[FÓRUM] Moderador %s aprovou o post '%s' do tópico '%s' na sessão '%s'"
 #define LANG_LOG_POST_DISAPPROVED 		"[FÓRUM] Moderador %s desaprovou o post '%s' do tópico '%s' na sessão '%s' com a seguinte razão: '%s'"
 #define LANG_LOG_POST_EDITED 			"[FÓRUM] Moderador %s editou o post '%s' do tópico '%s' '%s' escrito por '%s'"
 #define LANG_LOG_REPORT_CLOSED 			"[FÓRUM] Moderador %s fechou a denúncia '%s' na sessão '%s'"
 #define LANG_LOG_TOPIC_APPROVED 		"[FÓRUM] Moderador %s aprovou o tópico %s na sessão '%s'"
 #define LANG_LOG_TOPIC_DISAPPROVED 		"[FÓRUM] Moderador %s desaprovou o tópico '%s' na sessão '%s' com a seguinte razão: %s"
 #define LANG_LOG_UNLOCK 				"[FÓRUM] Moderador %s destrancou o tópico '%s' na sessão '%s'"
 #define LANG_LOG_USER_WARNING 			"[FÓRUM] Moderador %s deu uma advertência ao usuário %s"
 #define LANG_LOG_USER_LOCK 				"[FÓRUM] Usuário %s trancou seu próprio tópico '%s'"
 #define LANG_LOG_BAN_EXCLUDE_USER 		"[FÓRUM] Moderador %s retirou o usuário '%s' da lista de banidos com a razão: %s"
 
-	print(" Version 0.1 keep updated in: http://forum.sa-mp.com/showthread.php?t=486271");
+
 //#define LANG_SERVER_MESSAGE "[FORUM] %s answer at '%s' topic. Forum session: %s."
 //#define LANG_LOG_BAN_USER 				"[FORUM] Moderator %s banned user '%s' for reason: '%s'"
 //#define LANG_LOG_BAN_IP 				"[FORUM] Moderator %s banned IP '%s' for reason: '%s'"
 //#define LANG_LOG_UNBAN_USER 			"[FORUM] Moderator %s unbanned user '%s'"
-	lastPostId = getLastPostId();
+//#define LANG_LOG_DELETE_POST 			"[FORUM] Moderator %s deleted post '%s' written by '%s' at session '%s'"
 //#define LANG_LOG_DELETE_SHADOW_TOPIC 	"[FORUM] Moderator %s deleted shadow topic '%s' at session '%s'"
-	SetTimer("checkNewPosts", 5000, true);
+//#define LANG_LOG_DELETE_TOPIC 			"[FORUM] Moderator %s deleted topic '%s' written by '%s' at session '%s'"
 //#define LANG_LOG_LOCK 					"[FORUM] Moderador %s locked topic '%s' at session '%s'"
 //#define LANG_LOG_MERGE 					"[FORUM] Moderator %s merged posts into topic '%s' at session '%s'"
 //#define LANG_LOG_MOVE 					"[FORUM] Moderator %s moved topic '%s' from '%s' to '%s'"
 //#define LANG_LOG_POST_APPROVED 			"[FORUM] Moderator %s approved post '%s' in topic '%s' at session '%s'"
 //#define LANG_LOG_POST_DISAPPROVED 		"[FORUM] Moderator %s disapproved post '%s' in topic '%s' at session '%s' with the following reason: '%s'"
 //#define LANG_LOG_POST_EDITED 			"[FORUM] Moderator %s edited post '%s' in topic '%s' at session '%s' written by '%s'"
 //#define LANG_LOG_REPORT_CLOSED 			"[FORUM] Moderator %s closed report '%s' at session '%s'"
 //#define LANG_LOG_TOPIC_APPROVED 		"[FORUM] Moderator %s approved topic %s at session '%s'"
 //#define LANG_LOG_TOPIC_DISAPPROVED 		"[FORUM] Moderator %s disapproved topic %s at session '%s' with the following reason: %s"
 //#define LANG_LOG_UNLOCK 				"[FORUM] Moderator %s unlocked topic '%s' at session '%s'"
 //#define LANG_LOG_USER_WARNING 			"[FORUM] Moderator %s added warning to user %s"
 //#define LANG_LOG_USER_LOCK 				"[FORUM] User %s locked own topic %s"
 //#define LANG_LOG_BAN_EXCLUDE_USER 		"[FORUM] Moderator %s excluded user '%s' from ban for reason: %s"
 /** </CHANGE IT> **/
 
 #include <a_samp>
 #include <a_mysql>
 
 new
 	lastPostId,
 	lastAdminActionId,
 	dbConnectionHandle
 ;
 
 forward MySqlConnect();
 forward checkNewPosts();
 forward getLastPostId();
 forward checkUpdates();
 forward checkAdminActions();
 forward getLastAdminActionId();
 forward initChecks();
 
 public OnFilterScriptInit()
 {
 	print("\n--------------------------------------");
 	print(" in-game phpbb integration by Mandrakke ");
 	print(" Version 0.2 keep updated in: http://forum.sa-mp.com/showthread.php?p=2855241");
 	print("--------------------------------------\n");
 
 	MySqlConnect();
 
 	SetTimer("initChecks", 5000, false);
 
 	return 1;
 }
 
 public OnFilterScriptExit()
 {
 	return 1;
 }
 
 public initChecks() {
     getLastPostId();
-	return strval(post_id);
+	getLastAdminActionId();
 
 	SetTimer("checkUpdates", 3000, true);
 }
-	mysql_debug(0);
+
-    mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_DB, MYSQL_PASS);
+public checkUpdates() {
     checkNewPosts();
     checkAdminActions();
 }
 
 public checkNewPosts() {
 	new Query[512], username[64], forum_name[64], topic_title[64], serverMessage[256], post_idStr[64], post_id;
 
 	format(Query, sizeof(Query), "select u.username, t.topic_title, f.forum_name, p.post_id from %sposts p  join %susers u on p.poster_id = u.user_id join %stopics t on t.topic_id = p.topic_id join %sforums f on f.forum_id = p.forum_id where p.post_id > %d order by p.post_time desc limit 0,10",
         MYSQL_FORUMTABLE_PREFIX, MYSQL_FORUMTABLE_PREFIX, MYSQL_FORUMTABLE_PREFIX, MYSQL_FORUMTABLE_PREFIX, lastPostId
 	);
 
 	mysql_query(Query);
 	mysql_store_result();
 
 	if(mysql_num_rows() > 0) {
 		while(mysql_retrieve_row()) {
 			mysql_fetch_field_row(username, "username");
 			mysql_fetch_field_row(forum_name, "forum_name");
 			mysql_fetch_field_row(topic_title, "topic_title");
 			mysql_fetch_field_row(post_idStr, "post_id"); post_id = strval(post_idStr);
 
 			format(serverMessage, sizeof(serverMessage), LANG_SERVER_MESSAGE, username, topic_title, forum_name);
 			SendClientMessageToAll(0x00FF0000, serverMessage);
 
 			if(post_id > lastPostId) {
 				lastPostId = post_id;
 			}
 		}
 	}
 
 	mysql_free_result();
 
 	return 1;
 }
 
 public checkAdminActions() {
 	new Query[512], serverMessage[256], username[64], forum_name[64], topic_title[64], log_operation[32], log_data[128], log_idStr[15], log_id, log_data_explode[7][64], log_data_info1[64], log_data_info2[64];
 
 	format(Query, sizeof(Query), "SELECT u.username, f.forum_name, t.topic_title, l.log_operation, l.log_data, l.log_id FROM %slog l join %stopics t on t.topic_id = l.topic_id join %sforums f on f.forum_id = l.forum_id join %susers u on u.user_id = l.user_id where l.log_type = 1 and l.log_id > %d order by l.log_time desc limit 0,10",
         MYSQL_FORUMTABLE_PREFIX, MYSQL_FORUMTABLE_PREFIX, MYSQL_FORUMTABLE_PREFIX, MYSQL_FORUMTABLE_PREFIX, lastAdminActionId
 	);
 
 	mysql_query(Query);
 	mysql_store_result();
 
 	if(mysql_num_rows() > 0) {
 		while(mysql_retrieve_row()) {
 			mysql_fetch_field_row(username, "username");
 			mysql_fetch_field_row(forum_name, "forum_name");
 			mysql_fetch_field_row(topic_title, "topic_title");
 			mysql_fetch_field_row(log_operation, "log_operation");
 			mysql_fetch_field_row(log_data, "log_data");
 			mysql_fetch_field_row(log_idStr, "log_id"); log_id = strval(log_idStr);
 
 			explode(log_data_explode, log_data, "\"");
 
 			format(log_data_info1, sizeof(log_data_info1), "%s", log_data_explode[1]);
 			format(log_data_info2, sizeof(log_data_info2), "%s", log_data_explode[3]);
 
 			if(strcmp(log_operation, "LOG_BAN_EXCLUDE_USER", true) == 0) {
 				format(serverMessage, sizeof(serverMessage), LANG_LOG_BAN_EXCLUDE_USER, username, log_data_info1, log_data_info2);
 			} else if(strcmp(log_operation, "LOG_BAN_USER", true) == 0) {
 				format(serverMessage, sizeof(serverMessage), LANG_LOG_BAN_USER, username, log_data_info1, log_data_info2);
 			} else if(strcmp(log_operation, "LOG_BAN_IP", true) == 0) {
 				format(serverMessage, sizeof(serverMessage), LANG_LOG_BAN_IP, username, log_data_info2, log_data_info1);
 			} else if(strcmp(log_operation, "LOG_UNBAN_USER", true) == 0) {
 				format(serverMessage, sizeof(serverMessage), LANG_LOG_UNBAN_USER, username, log_data_info1);
 			} else if(strcmp(log_operation, "LOG_DELETE_POST", true) == 0) {
 				format(serverMessage, sizeof(serverMessage), LANG_LOG_DELETE_POST, username, log_data_info1, log_data_info2, forum_name);
 			} else if(strcmp(log_operation, "LOG_DELETE_SHADOW_TOPIC", true) == 0) {
 				format(serverMessage, sizeof(serverMessage), LANG_LOG_DELETE_SHADOW_TOPIC, username, log_data_info1, forum_name);
 			} else if(strcmp(log_operation, "LOG_DELETE_TOPIC", true) == 0) {
 				format(serverMessage, sizeof(serverMessage), LANG_LOG_DELETE_TOPIC, username, log_data_info1, forum_name);
 			} else if(strcmp(log_operation, "LOG_LOCK", true) == 0 || strcmp(log_operation, "LOG_LOCK_POST", true) == 0) {
 				format(serverMessage, sizeof(serverMessage), LANG_LOG_LOCK, username, topic_title, forum_name);
 			} else if(strcmp(log_operation, "LOG_MERGE", true) == 0) {
 				format(serverMessage, sizeof(serverMessage), LANG_LOG_MERGE, username, topic_title);
 			} else if(strcmp(log_operation, "LOG_MOVE", true) == 0) {
 				format(serverMessage, sizeof(serverMessage), LANG_LOG_MOVE, username, topic_title, log_data_info1, log_data_info2);
 			} else if(strcmp(log_operation, "LOG_POST_APPROVED", true) == 0) {
 				format(serverMessage, sizeof(serverMessage), LANG_LOG_POST_APPROVED, username, log_data_info1, topic_title, forum_name);
 			} else if(strcmp(log_operation, "LOG_POST_DISAPPROVED", true) == 0) {
 				format(serverMessage, sizeof(serverMessage), LANG_LOG_POST_DISAPPROVED, username, log_data_info1, topic_title, forum_name, log_data_info2);
 			} else if(strcmp(log_operation, "LOG_POST_EDITED", true) == 0) {
 				format(serverMessage, sizeof(serverMessage), LANG_LOG_POST_EDITED, username, log_data_info1, topic_title, forum_name, log_data_info2);
 			} else if(strcmp(log_operation, "LOG_REPORT_CLOSED", true) == 0) {
 				format(serverMessage, sizeof(serverMessage), LANG_LOG_REPORT_CLOSED, username, log_data_info1, forum_name);
 			} else if(strcmp(log_operation, "LOG_TOPIC_APPROVED", true) == 0) {
 				format(serverMessage, sizeof(serverMessage), LANG_LOG_TOPIC_APPROVED, username, log_data_info1);
 			} else if(strcmp(log_operation, "LOG_TOPIC_DISAPPROVED", true) == 0) {
 				format(serverMessage, sizeof(serverMessage), LANG_LOG_TOPIC_DISAPPROVED, username, log_data_info1, forum_name, log_data_info2);
 			} else if(strcmp(log_operation, "LOG_UNLOCK", true) == 0) {
 				format(serverMessage, sizeof(serverMessage), LANG_LOG_UNLOCK, username, log_data_info1, forum_name);
 			} else if(strcmp(log_operation, "LOG_USER_WARNING", true) == 0) {
 				format(serverMessage, sizeof(serverMessage), LANG_LOG_USER_WARNING, username, log_data_info1);
 			} else if(strcmp(log_operation, "LOG_USER_LOCK", true) == 0) {
 				format(serverMessage, sizeof(serverMessage), LANG_LOG_USER_LOCK, username, log_data_info1);
 			}
 
 			if(strlen(serverMessage) > 0) {
 				format(serverMessage, sizeof(serverMessage), "%s", serverMessage);
 				SendClientMessageToAll(0x00FF0000, serverMessage);
 			}
 
 			if(log_id > lastAdminActionId) {
 				lastAdminActionId = log_id;
 			}
 		}
 	}
 
 	mysql_free_result();
 }
 
 public getLastPostId() {
 	new Query[128], post_id[64];
 
 	format(Query, sizeof(Query), "select p.post_id from %sposts p order by p.post_time desc limit 0,1", MYSQL_FORUMTABLE_PREFIX);
 	mysql_query(Query);
 	mysql_store_result();
 
 	if(mysql_retrieve_row()) {
 		mysql_fetch_field_row(post_id, "post_id");
 	}
 
 	mysql_free_result();
 
 	lastPostId = strval(post_id);
 }
 
 public getLastAdminActionId() {
 	new Query[128], log_id[64];
 
 	format(Query, sizeof(Query), "select l.log_id from %slog l order by l.log_time desc limit 0,1", MYSQL_FORUMTABLE_PREFIX);
 	mysql_query(Query);
 	mysql_store_result();
 
 	if(mysql_retrieve_row()) {
 		mysql_fetch_field_row(log_id, "log_id");
 	}
 
 	mysql_free_result();
 
 	lastAdminActionId = strval(log_id);
 }
 
 public MySqlConnect() {
 	mysql_debug(1);
     dbConnectionHandle = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_DB, MYSQL_PASS);
 }
 
 public OnQueryError( errorid, error[], resultid, extraid, callback[], query[], connectionHandle ) {
 	new Query[128];
 
 	if(errorid!=1060 && errorid!=1062){
 		new hour,second,minute;
 		gettime(hour,minute,second);
 		new File:log=fopen("mysql_errors.txt",io_append);
 		format(Query,sizeof(Query),"[%d:%d:%d] Query: %s Erro: %d (%s)\r\n",hour,minute,second,query,errorid,error);
 		fwrite(log,Query);
 		fclose(log);
 	}
 
 	return 0;
 }
 
 stock explode(aExplode[][], const sSource[], const sDelimiter[] = " ", iVertices = sizeof aExplode, iLength = sizeof aExplode[]){
 	new
 		iNode,
 		iPointer,
 		iPrevious = -1,
 		iDelimiter = strlen(sDelimiter);
 
 	while(iNode < iVertices){
 		iPointer = strfind(sSource, sDelimiter, false, iPointer);
 
 		if(iPointer == -1){
 			strmid(aExplode[iNode], sSource, iPrevious, strlen(sSource), iLength);
 			break;
 		}
 		else {
 			strmid(aExplode[iNode], sSource, iPrevious, iPointer, iLength);
 		}
 
 		iPrevious = (iPointer += iDelimiter);
 		++iNode;
 	}
 	return iPrevious;
 }