Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /**
- 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_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'"
- #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"
- // English
- //#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'"
- //#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'"
- //#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();
- getLastAdminActionId();
- SetTimer("checkUpdates", 3000, true);
- }
- 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;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement