Eroare plugin, nu face update in baza de date.[rezolvat!]

[Xeno985]

Salut, am luat un plugin de pe net SQL si l-am modificat pentru necesitatea mea, insa nu functioneaza. Ce nu functioneaza? Ei bine, acesta s-a compilat cu succes, fara erori, si ruleaza corect pe server, insa cand un jucator intra pe server, nu se face update in baza de date.

| Afiseaza codul

[code]
#include <amxmodx>
#include <sqlx>

#define PLUGIN "Tutorial"
#define VERSION "1.0"
#define AUTHOR "Grim"

// Ur Mysql Information
new Host[]      = "127.0.0.1"
new User[]      = "root"
new Pass[]      = ""
new Db[]        = "amx"


new Handle:g_SqlTuple
new g_Error[512]

public plugin_init() {
    register_plugin(PLUGIN, VERSION, AUTHOR)
    set_task(1.0, "MySql_Init") // set a task to activate the mysql_init
}

public MySql_Init()
{
    g_SqlTuple = SQL_MakeDbTuple(Host,User,Pass,Db)
   
    new ErrorCode,Handle:SqlConnection = SQL_Connect(g_SqlTuple,ErrorCode,g_Error,charsmax(g_Error))
    if(SqlConnection == Empty_Handle)
        set_fail_state(g_Error)
    // you free everything with SQL_FreeHandle
    SQL_FreeHandle(SqlConnection)   
}

public plugin_end()
{
    // free the tuple - note that this does not close the connection,
    // since it wasn't connected in the first place
    SQL_FreeHandle(g_SqlTuple)
}

public Load_MySql(id)
{
    new szName[32], szTemp[512]
    get_user_authid(id, szName, charsmax(szName))
    
    // Here we will update the user hes information in the database where the steamid matches.
    format(szTemp,charsmax(szTemp),"UPDATE `amx_users` SET `is_online` = '1' WHERE `amx_users`.`auth` = '%s';", szName)
    SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTemp)
}

public Save_MySql(id)
{
    new szName[32], szTemp[512]
    get_user_authid(id, szName, charsmax(szName))
    
    // Here we will update the user hes information in the database where the steamid matches.
    format(szTemp,charsmax(szTemp),"UPDATE `amx_users` SET `is_online` = '0' WHERE `amx_users`.`auth` = '%s';", szName)
    SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTemp)
}

public IgnoreHandle(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
    SQL_FreeHandle(Query)
    
    return PLUGIN_HANDLED
}

public client_putinserver(id)
{
    Load_MySql(id)
}

public client_disconnect(id)
{
    Save_MySql(id)
}
[/code]

Ma poate ajuta cineva?

[Xeno985]

Rezolvat, m-a ajutat original.

[Laurentiu P.]

Lasa te rog si rezolvarea, poate mai intampina vreun utilizator aceeasi problema(sau asemanatoare).

Topic marcat ca rezolvat.

[Xeno985]

Lasa te rog si rezolvarea, poate mai intampina vreun utilizator aceeasi problema(sau asemanatoare).

Topic marcat ca rezolvat.

Mi-a dat Original un plugin facut de el.

Afiseaza | Afiseaza codul

[code]#include <amxmodx> 
#include <sqlx>

new c_SqlHost, c_SqlUser, c_SqlPass, c_SqlDB, c_SqlType, g_Error[512], Handle:g_SqlTuple;

public plugin_init()
{
	register_plugin("Player On", "1.0", "*Or!g!naL*")
	c_SqlHost = register_cvar( "zp_ammo_bank_host", "localhost" )
	c_SqlUser = register_cvar( "zp_ammo_bank_user", "root" )
	c_SqlPass = register_cvar( "zp_ammo_bank_pass", "" )
	c_SqlDB =    register_cvar( "zp_ammo_bank_db", "amx_panel" )
	c_SqlType = register_cvar( "zp_ammo_bank_type", "mysql" )
	if( !_PrepareSQL() ){

	}
}
_PrepareSQL() {
   
    new host[32], user[32], pass[32], db[32], type[12]
    get_pcvar_string( c_SqlHost, host, charsmax(host) )
    get_pcvar_string( c_SqlUser, user, charsmax(user) )
    get_pcvar_string( c_SqlPass, pass, charsmax(pass) )
    get_pcvar_string( c_SqlDB, db, charsmax(db) )
    get_pcvar_string( c_SqlType, type, charsmax(type) )
   
    new get_type[12]
    SQL_GetAffinity( get_type, charsmax(get_type) )
  
   
    g_SqlTuple = SQL_MakeDbTuple( host, user, pass, db )

   
    new errcode, error[128];
    new Handle:link = SQL_Connect( g_SqlTuple, errcode, error, charsmax(error) )
   
    if( link == Empty_Handle )
    {
        log_amx( "[ZP Ammo Bank] Failed to connect to database (%d): %s", errcode, error )
        return 0;
    }

    SQL_FreeHandle(link)
   
    return 1;
}

public client_putinserver(id) 
{
	_LoadSQL(id)
}

public client_disconnect(id)
{
	_SaveSQL(id)
}
_MakeStringSQLSafe( output[], len ) {
	
	replace_all( output, len, "'", "*" )
	replace_all( output, len, "^"", "*" ) //" - fix Sublime Text syntax highlight
	replace_all( output, len, "`", "*" )
}

_LoadSQL(id) {
	new Name[64], onnli[64] = 1;
	get_user_name( id, Name, charsmax(Name) )
	
	_MakeStringSQLSafe( Name, charsmax(Name) )
	
	new queryString[512]
	
	new data[2]
	data[0] = id
	
	new ErrorCode,Handle:SqlConnection = SQL_Connect(g_SqlTuple,ErrorCode,g_Error,511)
	if(SqlConnection == Empty_Handle)
		set_fail_state(g_Error)

	
	formatex( queryString, charsmax(queryString), 
	"UPDATE `amx_users` SET `is_online` = '%d' WHERE `auth` = '%s'",
	onnli, Name);
	
	new Handle:Query = SQL_PrepareQuery(SqlConnection,queryString)
	
	if(!SQL_Execute(Query))
	{
		SQL_QueryError(Query,g_Error,511)
	}
	
	while(SQL_MoreResults(Query))
	{
		
		SQL_NextRow(Query)
	}
	
	SQL_FreeHandle(Query)
	
	SQL_FreeHandle(SqlConnection)
}

_SaveSQL(id) {
	new data[2]
	data[0] = id
	
	new Name[64], online[64] = 0;
	get_user_name( id, Name, charsmax(Name) )
	
	_MakeStringSQLSafe( Name, charsmax(Name) )
	
	new ErrorCode,Handle:SqlConnection = SQL_Connect(g_SqlTuple,ErrorCode,g_Error,511)
	if(SqlConnection == Empty_Handle)
		set_fail_state(g_Error)
	
	new queryString[ 1024 ];
	
	formatex( queryString, charsmax(queryString), 
	"UPDATE `amx_users` SET `is_online` = '%d' WHERE `auth` = '%s'",
	online, Name);
	
	new Handle:Query = SQL_PrepareQuery(SqlConnection,queryString)
	if(!SQL_Execute(Query))
	{
		SQL_QueryError(Query,g_Error,511)
		set_fail_state(g_Error)
	}
	SQL_FreeHandle(Query)
	
	SQL_FreeHandle(SqlConnection)
}
public QuerySaveData( failstate, Handle:query, error[], errcode, data[], size, Float:queueTime )
{
	if( failstate == TQUERY_CONNECT_FAILED )
	{
		log_amx( "[ZP Achievement] Failed connecting to save data (%d): %s", errcode, error )
	}
	else if( failstate == TQUERY_QUERY_FAILED )
	{
		log_amx( "[ZP Achievement] Failed query on save data (%d): %s", errcode, error )
	}
	else
	{
	}
}[/code]