DB:
1st colum - steamid
2nd - hp
Plugin must:
if player steamid exist in DB he get hp
Sma
PHP Code:
#include <amxmodx>
#include <amxmisc>
#include <dbi>
#include <fun>
new Sql:g_SqlConnection
new g_Error[512]
public plugin_init() {
register_plugin("Donate HP SQL","0.1","aTei")
new Host[64],User[64],Pass[64],Db[64]
get_cvar_string("amx_sql_host",Host,63)
get_cvar_string("amx_sql_user",User,63)
get_cvar_string("amx_sql_pass",Pass,63)
get_cvar_string("amx_sql_db",Db,63)
g_SqlConnection = dbi_connect(Host,User,Pass,Db,g_Error,511)
if(g_SqlConnection < SQL_OK)
set_fail_state(g_Error)
if (!g_SqlConnection)
{
console_print(0,"[Donate HP] Can't connect to DB!")
}
dbi_query(g_SqlConnection,"CREATE TABLE IF NOT EXISTS donate_hp (steamid text,hp INT(11))")
}
public client_putinserver (id){
new steamid[38]
get_user_authid(id, steamid, 37)
new result = dbi_query(g_SqlConnection, "SELECT * FROM donate_hp WHERE steamid = '%s'", steamid);
if (result){
new db_hp = dbi_field(result,2)
set_user_health(id, db_hp)
}
return PLUGIN_CONTINUE
}
Errors
Compiler
PHP Code:
//// donate_hp.sma
// F:\servers\files\amxmodx 1.8.1\addons\amx
arning 213: tag mismatch
// F:\servers\files\amxmodx 1.8.1\addons\amx
arning 213: tag mismatch
// Header size: 364 bytes
// Code size: 980 bytes
// Data size: 2908 bytes
// Stack/heap size: 16384 bytes; estima
)
// Total requirements: 20636 bytes
//
// 2 Warnings.
// Done.
//
// Compilation Time: 0,58 sec
Server
PHP Code:
L 02/18/2009 - 19:12:36: [AMXX] Plugin ("donate_hp.amxx") is setting itself as f
ailed.
L 02/18/2009 - 19:12:36: [AMXX] Plugin says: Access denied for user 'root'@'loca
lhost' (using password: NO)
L 02/18/2009 - 19:12:36: [AMXX] Run time error 1 (plugin "donate_hp.amxx") - for
ced exit
Help plz