|
Senior Member
Join Date: May 2005
Location: Wiesbaden
|
01-19-2009
, 14:37
Re: Deutsche Scripting-Hilfe
|
#113
|
Quote:
Originally Posted by |PJ| Shorty
dbi war vor meiner zeit, hier mal ein beispiel mit sqlx.
es fehlt eigentlich nur das "db prune", alles andere sollte funktionieren.
PHP Code:
#include <amxmodx>
#include <amxmisc>
#include <sqlx>
new Handle:dbc;
new g_Cache[1024];
new g_authid[33][35]
public plugin_init() {
register_plugin("FrequentFraggerProgram","4.7","Slurpy [COF]")
register_cvar("FreqFragProg", "4.7",FCVAR_SERVER)
}
public plugin_cfg() {
set_task(1.0,"sql_init")
}
public sql_init() {
new host[64], username[32], password[32], dbname[32];
//no pcvar, only called once at plugin start
get_cvar_string("amx_sql_host",host,64);
get_cvar_string("amx_sql_user",username,32);
get_cvar_string("amx_sql_pass",password,32);
get_cvar_string("amx_sql_db",dbname,32);
SQL_SetAffinity("mysql");
dbc = SQL_MakeDbTuple(host,username,password,dbname);
formatex(g_Cache,1023,"CREATE TABLE IF NOT EXISTS `freqfragger` (\
`lastname` VARCHAR(32) NOT NULL,`steamid` VARCHAR(35) NOT NULL,\
`connecttime` INT NOT NULL,`totalkills` INT NOT NULL,\
`totaldeaths` INT NOT NULL,`date` TIMESTAMP NOT NULL, PRIMARY KEY(`steamid`))")
SQL_ThreadQuery(dbc,"TableHandle",g_Cache);
}
public client_authorized(id) {
get_user_authid(id,g_authid[id],charsmax(g_authid[]))
}
public client_disconnect(id){
if ( is_user_bot(id) || is_user_hltv(id) )
return PLUGIN_CONTINUE
new playtime = get_user_time (id,1); //1=without connection time
new player_name[32]
get_user_name(id,player_name,31)
new deaths=get_user_deaths(id)
new kills=get_user_frags(id)
formatex(g_Cache,1023,"INSERT INTO freqfragger \
(lastname, steamid, connecttime, totalkills, totaldeaths, date) \
values ('%s','%s',%i,%i,%i,NOW()) ON DUPLICATE KEY UPDATE \
lastname='%s', connecttime=connecttime+%i, totalkills=totalkills+%i, \
totaldeaths=totaldeaths+%i, date=NOW() \
WHERE steamid='%s'", \
player_name,g_authid[id],playtime,kills,deaths, \
player_name,playtime,kills,deaths,g_authid[id])
SQL_ThreadQuery(dbc,"TableHandle",g_Cache);
return PLUGIN_CONTINUE
}
public TableHandle(FailState,Handle:Query,Error[],Errcode,Data[],DataSize,Float:QueryTime)
{
// lots of error checking
if(FailState == TQUERY_CONNECT_FAILED)
return log_amx("Could not connect to SQL database.");
else if(FailState == TQUERY_QUERY_FAILED)
return log_amx("SQL Table Query failed.");
if(Errcode)
return log_amx("SQL Error on table query: %s",Error);
return PLUGIN_CONTINUE;
}
public plugin_end() {
SQL_FreeHandle(dbc)
}
|
Nochmal danke für die Hilfe, bin nun endlich dazu gekommen es zu testen. Datenbank wird nun angelegt, aber es werden keine Daten eingetragen.
__________________
|
|
Linear Mode
