Deathrun elud

Tere!
Kas kellegil on sms elude scripti deathrunnile ?
Sooviks enda serverile.

T2nud.

Kahjuks pole seda tasuta ringlevuses, ainus võimalus on see kelleltki osta. Kui hästi suhtled, siis võib-olla Sander (@Pilvik) on nõus selle sulle tasuta ära tegema.

@Pilvik:

Kood:

public SaveElud(id) {
   szAlias[31] = GetAuth(id);
   new Data[256];
   format(Data, 255,"%i", g_Elud[id]);
   nvault_set(g_Vault, szAlias, Data);
   return PLUGIN_CONTINUE;
}
public LoadElud(id) {
   szAlias[31] = GetAuth(id);
   new Data[256], iElud[32];
   format(Data, 255,"%i", g_Elud[id]);
   nvault_get(g_Vault, szAlias, Data, 255);
   parse(Data, iElud, 31);
   g_Elud[id] = str_to_num(iElud);      
   return PLUGIN_CONTINUE;
}
public MySqlCon() {
   g_SqlTuple = SQL_MakeDbTuple(szHost , szUser , szPass , szDb);
   
   new ErrorCode , Handle:SqlConnection = SQL_Connect(g_SqlTuple , ErrorCode , g_Error , charsmax(g_Error));
   if(SqlConnection == Empty_Handle)
      return;
   //set_fail_state( g_Error);
   
   new Handle:Queries;
   Queries = SQL_PrepareQuery(SqlConnection , "CREATE TABLE IF NOT EXISTS `%s` (`auth` varchar(32) NOT NULL, `elud` varchar(64) NOT NULL)" , szTable);
   
   if(!SQL_Execute(Queries)) {
      SQL_QueryError(Queries , g_Error , charsmax(g_Error));
      //set_fail_state(g_Error);
   }
   SQL_FreeHandle(Queries);
   SQL_FreeHandle(SqlConnection);
}
public MySqlLoad(id) {
   szAlias[31] = GetAuth(id);
   
   new Data[1];
   Data[0] = id;
   
   new szTemp[512];
   format(szTemp , charsmax(szTemp) , "SELECT `elud` FROM `%s` WHERE auth = ^"%s^"", szTable , szAlias);
   SQL_ThreadQuery(g_SqlTuple , "LoadShit" , szTemp , Data , 1);
}
public LoadShit(FailState , Handle:Query , Error[] , Errcode , Data[] , DataSize) {
   if(FailState == TQUERY_CONNECT_FAILED)
      log_amx( "Load - Could not connect to SQL database.  [%d] %s" , Errcode , Error);
   else if(FailState == TQUERY_QUERY_FAILED)
      log_amx( "Load Query failed. [%d] %s" , Errcode , Error);
   
   new id;
   id = Data[0];
   
   if(SQL_NumResults(Query) < 1) {
      return PLUGIN_HANDLED;
      } else {
      g_smsElud[id] = SQL_ReadResult(Query , 0);
      g_Elud[id] += g_smsElud[id];
   }
   return PLUGIN_HANDLED;
}
public MySqlDelete(id) {
   szAlias[31] = GetAuth(id);
   
   new Data[1];
   Data[0] = id;
   
   new szTemp[512];
   format(szTemp , charsmax(szTemp) , "DELETE FROM `%s` WHERE auth='%s'", szTable , szAlias);
   SQL_ThreadQuery(g_SqlTuple , "handle_delete" , szTemp , Data , 1);
}
public handle_delete(FailState,Handle:Query,Error[],Errcode,Data[],DataSize) {
   if(FailState) {
      log_amx("SQL Error: %s (%d)", Error, Errcode)
      return PLUGIN_HANDLED
   }
   return PLUGIN_HANDLED
}
public IgnoreHandle(FailState , Handle:Query , Error[] , Errcode , Data[] , DataSize) {
   SQL_FreeHandle(Query);
   return PLUGIN_HANDLED;
}
GetAuth(id) {
   new szIp[32], szAuth[32];
   get_user_authid(id, szAuth, charsmax(szAuth));
   get_user_ip(id, szIp, charsmax(szIp), 1);
   
   if(equal(szAuth , "STEAM_ID_LAN") || equal(szAuth , "STEAM_ID_PENDING") || equal(szAuth , "VALVE_ID_LAN")  || equal(szAuth , "VALVE_ID_PENDING"))
      szAlias = szIp;
   else
      szAlias = szAuth;
   
   return szAlias[32];
}
public plugin_end() {
   nvault_close(g_Vault);
   SQL_FreeHandle(g_SqlTuple);
}

Kood:

public SaveElud(id) {
  szAlias[31] = GetAuth(id);
  new Data[256];
  format(Data, 255,"%i", g_Elud[id]);
  nvault_set(g_Vault, szAlias, Data);
  return PLUGIN_CONTINUE;
}
public LoadElud(id) {
  szAlias[31] = GetAuth(id);
  new Data[256], iElud[32];
  format(Data, 255,"%i", g_Elud[id]);
  nvault_get(g_Vault, szAlias, Data, 255);
  parse(Data, iElud, 31);
  g_Elud[id] = str_to_num(iElud);     
  return PLUGIN_CONTINUE;
}
public MySqlCon() {
  g_SqlTuple = SQL_MakeDbTuple(szHost , szUser , szPass , szDb);
 
  new ErrorCode , Handle:SqlConnection = SQL_Connect(g_SqlTuple , ErrorCode , g_Error , charsmax(g_Error));
  if(SqlConnection == Empty_Handle)
      return;
  //set_fail_state( g_Error);
 
  new Handle:Queries;
  Queries = SQL_PrepareQuery(SqlConnection , "CREATE TABLE IF NOT EXISTS `%s` (`auth` varchar(32) NOT NULL, `elud` varchar(64) NOT NULL)" , szTable);
 
  if(!SQL_Execute(Queries)) {
      SQL_QueryError(Queries , g_Error , charsmax(g_Error));
      //set_fail_state(g_Error);
  }
  SQL_FreeHandle(Queries);
  SQL_FreeHandle(SqlConnection);
}
public MySqlLoad(id) {
  szAlias[31] = GetAuth(id);
 
  new Data[1];
  Data[0] = id;
 
  new szTemp[512];
  format(szTemp , charsmax(szTemp) , "SELECT `elud` FROM `%s` WHERE auth = ^"%s^"", szTable , szAlias);
  SQL_ThreadQuery(g_SqlTuple , "LoadShit" , szTemp , Data , 1);
}
public LoadShit(FailState , Handle:Query , Error[] , Errcode , Data[] , DataSize) {
  if(FailState == TQUERY_CONNECT_FAILED)
      log_amx( "Load - Could not connect to SQL database.  [%d] %s" , Errcode , Error);
  else if(FailState == TQUERY_QUERY_FAILED)
      log_amx( "Load Query failed. [%d] %s" , Errcode , Error);
 
  new id;
  id = Data[0];
 
  if(SQL_NumResults(Query) < 1) {
      return PLUGIN_HANDLED;
      } else {
      g_smsElud[id] = SQL_ReadResult(Query , 0);
      g_Elud[id] += g_smsElud[id];
  }
  return PLUGIN_HANDLED;
}
public MySqlDelete(id) {
  szAlias[31] = GetAuth(id);
 
  new Data[1];
  Data[0] = id;
 
  new szTemp[512];
  format(szTemp , charsmax(szTemp) , "DELETE FROM `%s` WHERE auth='%s'", szTable , szAlias);
  SQL_ThreadQuery(g_SqlTuple , "handle_delete" , szTemp , Data , 1);
}
public handle_delete(FailState,Handle:Query,Error[],Errcode,Data[],DataSize) {
  if(FailState) {
      log_amx("SQL Error: %s (%d)", Error, Errcode)
      return PLUGIN_HANDLED
  }
  return PLUGIN_HANDLED
}
public IgnoreHandle(FailState , Handle:Query , Error[] , Errcode , Data[] , DataSize) {
  SQL_FreeHandle(Query);
  return PLUGIN_HANDLED;
}
GetAuth(id) {
  new szIp[32], szAuth[32];
  get_user_authid(id, szAuth, charsmax(szAuth));
  get_user_ip(id, szIp, charsmax(szIp), 1);
 
  if(equal(szAuth , "STEAM_ID_LAN") || equal(szAuth , "STEAM_ID_PENDING") || equal(szAuth , "VALVE_ID_LAN")  || equal(szAuth , "VALVE_ID_PENDING"))
      szAlias = szIp;
  else
      szAlias = szAuth;
 
  return szAlias[32];
}
public plugin_end() {
  nvault_close(g_Vault);
  SQL_FreeHandle(g_SqlTuple);
}


See ongi ?

Hyzz kirjutas:See ongi ?

Ei, see oli koodijupp, mis aitab Pilvikul scripti koostada.

Okei.
Aga ma ei usu, et ta nõus tegema on

No aga suhtle Pilvikuga ehk saad nõusse.

Lisa mind skype embeck.group, vaja paar asja täpsustada.

Hei!
Tean, et tõstin teema jälle ülesse, kuid oleks uuesti vaja. Pilvik addin sind skypes kohe.