Offline |
|
Csatlakozott: 2018.09.27. 00:29 Hozzászólások: 4
Megköszönt másnak: 2 alkalommal
|
Szia, tessék. #include <amxmodx> #include <sqlx> #define PLUGIN "Save Time" #define VERSION "1.0" #define AUTHOR "Dooz" new const SQL_INFO[][] = { "-", // HOST "-", // USERNAME "-", // PASSWORD "-" // DATABASE } new Handle:g_SqlTuple; public plugin_cfg() { new Query[512]; g_SqlTuple = SQL_MakeDbTuple(SQL_INFO[0],SQL_INFO[1],SQL_INFO[2],SQL_INFO[3]); formatex(Query, charsmax(Query), "CREATE TABLE IF NOT EXISTS `Ido` (`Id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,`UserName` varchar(32) NOT NULL,`UserLoggedTime` varchar(32) NOT NULL)"); SQL_ThreadQuery(g_SqlTuple,"createTableThread", Query); } public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED) set_fail_state("Nem tudtam csatlakozni az adatbazishoz."); else if(FailState == TQUERY_QUERY_FAILED) set_fail_state("Query Error"); if(Errcode) log_amx("Hibat dobtam: %s",Error); } public client_putinserver(id) { if(!is_user_bot(id)) Check_User(id); } public Check_User(id) { new Query[512], Data[1], Name[32]; get_user_name(id, Name, charsmax(Name)); Data[0] = id; formatex(Query, charsmax(Query), "SELECT * FROM `Ido` WHERE UserName = '%s';", Name); SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", Query, Data, 1); } public QuerySelectData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) { log_amx("%s", Error) return; } else { new id = Data[0]; Time(id, SQL_NumRows(Query)); } } public Time(id, Num) { new Query[512], Name[32], Date[32], CurrentTime[9], CurrentDate[11]; get_user_name(id, Name, charsmax(Name)); get_time("%H:%M:%S",CurrentTime,8); get_time("%Y/%m/%d",CurrentDate,10); format(Date,charsmax(Date),"%s %s", CurrentDate, CurrentTime); if(Num) formatex(Query, charsmax(Query), "UPDATE `Ido` SET UserLoggedTime = '%s' WHERE UserName = '%s';", Date, Name); else formatex(Query, charsmax(Query), "INSERT INTO `Ido` (UserName, UserLoggedTime) VALUES ('%s', '%s') ",Name, Date); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public QuerySetData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) { log_amx("%s", Error); return; } } public plugin_end() SQL_FreeHandle(g_SqlTuple);
Az első csatlakozáskor lementi a játékos nevet és az időt amikor fellépett. Ezt követően bármikor fellép frissíteni fogja a régi időt.
|
|