|
Senior Member
Join Date: Dec 2015
Location: Roman, Romania.
|

12-01-2018
, 07:39
sqlx help
|
#1
|
Code:
#include < amxmodx >
#include < amxmisc >
#include < sqlx >
#define PLUGIN "VIP SQL"
#define VERSION "1.0"
#define AUTHOR "LondoN eXtream"
// SQL Stuff
new g_CvarHost, g_CvarUser, g_CvarPass, g_CvarDB;
new g_pGlobalQuery [ 256 ];
new Handle: Tuple;
// VIP Stuff
new g_pName [ 33 ] [ 32 ];
new g_pPass [ 33 ] [ 32 ];
new bool: is_user_vip [ 33 ];
public plugin_precache ( )
{
server_print ( "[VIP] Pluginul a pornit cu success" );
g_CvarHost = register_cvar ( "vip_sqlx_host", "" );
g_CvarUser = register_cvar ( "vip_sqlx_user", "" );
g_CvarPass = register_cvar ( "vip_sqlx_pass", "" );
g_CvarDB = register_cvar ( "vip_sqlx_db", "" );
SQLX_Connect ( );
}
public plugin_init ( )
{
register_plugin ( PLUGIN, VERSION, AUTHOR );
register_cvar ( "vip_sqlx_london", VERSION, FCVAR_SERVER|FCVAR_SPONLY );
set_cvar_string ( "vip_sqlx_london", VERSION );
}
public SQLX_Connect ( )
{
new szHost [ 32 ], szUser [ 32 ], szPass [ 32 ], szDB [ 32 ];
get_pcvar_string ( g_CvarHost, szHost, charsmax ( szHost ) );
get_pcvar_string ( g_CvarUser, szUser, charsmax ( szUser ) );
get_pcvar_string ( g_CvarPass, szPass, charsmax ( szPass ) );
get_pcvar_string ( g_CvarDB, szDB, charsmax ( szDB ) );
Tuple = SQL_MakeDbTuple ( szHost, szUser, szPass, szDB, 10 );
}
public client_connect ( id )
{
if ( is_user_bot ( id ) || is_user_hltv ( id ) )
return;
get_user_name ( id, g_pName [ id ], charsmax ( g_pName ) );
get_user_info ( id, "_pass", g_pPass [ id ], charsmax ( g_pPass ) );
formatex ( g_pGlobalQuery, charsmax ( g_pGlobalQuery ), "SELECT * FROM vip_users" );
SQL_ThreadQuery ( Tuple, "ReadInfo", g_pGlobalQuery );
}
public ReadInfo ( FailState, Handle: Query, szError, Errcode, Data [ ], DataSize )
{
if ( FailState == TQUERY_CONNECT_FAILED )
{
log_amx ( "Nu ne putem conecta la %d [%s]", Errcode, szError );
return;
}
else if ( FailState == TQUERY_QUERY_FAILED )
{
log_amx ( "Query Error: %d [%s]", Errcode, szError );
return;
}
if ( SQL_NumResults ( Query ) > 1 )
{
new Player = Data [ 0 ];
new TempUser [ 32 ], TempPass [ 32 ];
SQL_ReadResult ( Query, 1, TempUser, charsmax ( TempUser ) );
SQL_ReadResult ( Query, 2, TempPass, charsmax ( TempPass ) );
if ( equal ( g_pName [ Player ], TempUser ) )
{
if ( equal ( g_pPass [ Player ], TempPass ) )
{
is_user_vip [ Player ] = true;
server_print ( "[VIP] %s connected with success", g_pName [ Player ] );
}
else
{
server_cmd ( "kick #%d", get_user_userid ( Player ) );
server_print ( "[VIP] %s Kicked due to Invalid Password", g_pName [ Player ] );
}
}
}
}
i want to retrive user and pass from database, i have some error, can someone explain me what is wrong with the code?
__________________
Last edited by LondoN; 12-01-2018 at 17:33.
|
|