für meine Zwecke etwas umgestalten. Zunächst geht es darum das die Spielzeit die jeder auf unseren Servern verbringt in einer Datenbank gespeichert wird. Später sollen daran bestimmte Rechte geknüpft werden. So ein Art Stammspieler-Plugin
Bereits am speichern der Spielzeit scheitere ich aber. Hab das o.g. Plugin erstmal auf den folgenden Code geschrumpft. Nun wird aber keinerlei Datenbank angelegt. Lege ich sie von Hand an werden auch keine Daten eingetragen. Es kommt auch keinerlei Fehlermeldung, kein Connection Failed oder so sowas, nix.
Code:
#include <amxmodx>
#include <amxmisc>
#include <dbi>
new gConnectTime[33]
//new gCurrentTime
new gTotalKills[33]
new gTotalDeaths[33]
new Sql:dbc
new Result:result
public plugin_init()
{
register_plugin("FrequentFraggerProgram","4.7","Slurpy [COF]")
register_cvar("FreqFragProg", "4.7",FCVAR_SERVER)
register_cvar("amx_ffphistory", "30") //how many days to keep when running amx_ffpprune
register_cvar("amx_ffpdbmaintenance","05:00")
register_cvar("amx_ffpdecay","5")
set_task(60.0,"schedule_dbmaintenance",1,"",0,"b")
new host[64], username[32], password[32], dbname[32], error[256]
get_cvar_string("amx_sql_host",host,63)
get_cvar_string("amx_sql_user",username,31)
get_cvar_string("amx_sql_pass",password,31)
get_cvar_string("amx_sql_db",dbname,31)
dbc = dbi_connect(host,username,password,dbname,error,255)
if (dbc == SQL_FAILED)
log_amx("[AMXX] SQL Connection Failed = %s", error)
else
{
dbi_query(dbc,"CREATE TABLE IF NOT EXISTS `freqfragger` (`lastname` VARCHAR(32) NOT NULL,`steamid` VARCHAR(32) NOT NULL,`connecttime` INT NOT NULL,`totalkills` INT NOT NULL,`totaldeaths` INT NOT NULL,`date` TIMESTAMP, PRIMARY KEY(`steamid`))")
}
}
//////////////////////////////////////////////////////////////////////////////////////////
// Update players stored time when they disconnect
//////////////////////////////////////////////////////////////////////////////////////////
public client_disconnect (id){
if ( is_user_bot(id) )
{ //Do not add to database/nvault
return PLUGIN_CONTINUE
}
if (is_user_hltv(id) )
{ //Do not add to database/nvault
return PLUGIN_CONTINUE
}
new authid[32]
new playtime = get_user_time (id)
get_user_authid(id,authid,31)
new player_name[33]
get_user_name(id,player_name,31)
if (gConnectTime[id]== 0) {
//New player, create a database entry for them
result = dbi_query(dbc,"INSERT INTO freqfragger (lastname, steamid, connecttime, totalkills, totaldeaths, date) values ('%s','%s',%i,%i,%i,NOW())",player_name,authid,playtime,gTotalKills[id],gTotalDeaths[id])
}else{
//Player exists in database, add the time to the total time
new store_time = (playtime + gConnectTime[id])
result = dbi_query(dbc,"UPDATE freqfragger SET lastname='%s', connecttime=%i, totalkills=%i, totaldeaths=%i, date=NOW() WHERE steamid='%s'",player_name,store_time, gTotalKills[id],gTotalDeaths[id],authid)
}
return PLUGIN_CONTINUE
}
//////////////////////////////////////////////////////////////////////////////////////////
// Remove old entries for players not on server in X days for MySql
//////////////////////////////////////////////////////////////////////////////////////////
public schedule_dbmaintenance() //Clean up database
{
new thetimeis[16],dbdecay_time[16]
get_time("%H:%M",thetimeis,16)
get_cvar_string("amx_ffpdbmaintenance",dbdecay_time,16)
if(equal(thetimeis,dbdecay_time)){ //It's time to do the maintenance
new history = get_cvar_num("amx_ffphistory") //Delete player from database after certain number of days not on server
result = dbi_query(dbc,"DELETE FROM freqfragger WHERE TO_DAYS( NOW( ) ) - TO_DAYS( date ) >=%d",history )
result = dbi_query(dbc,"DELETE FROM freqfragger WHERE steamid = 'STEAM_ID_PENDING'")
new slotdecay = get_cvar_num("amx_ffpdecay")
new decaypct = (100 - slotdecay)
//Remove percentage of players total time if not on server in the last day
result = dbi_query(dbc,"UPDATE freqfragger SET lastname=lastname, steamid=steamid, connecttime=connecttime*.%i, totalkills=totalkills, totaldeaths=totaldeaths, date=date WHERE TO_DAYS( NOW( ) ) - TO_DAYS( date ) >=1 ",decaypct)
dbi_free_result(result)
}
return PLUGIN_CONTINUE
}
Ich muss zugeben ich hab nicht gerade viel Ahnung vom coden. Bis auf ein paar kleinere Anpassung oder Übersetzungen hab ich noch nichts gemacht. Ich schau mir meist einfach die sma-dateien an und versuch draus schlau zu werden. Der Rest ist dann nach dem Prinzip "Versuch und Irrtum".
Aber vielleicht kann mir trotzdem jemand einen Tipp geben. Danke
Linear Mode
