Print Page - Saving Clan kills/Deaths in array

Title: Saving Clan kills/Deaths in array
Post by: Cool on Mar 09, 2017, 06:00 AM

class PlayerClass

 ClanKills = 0;
 ClanDeaths = 0;
 ClanDeads = 0;

Array

Code Select

pstats <- array( GetMaxPlayers(), null );OnPlayerKill

Code Select

function onPlayerKill( player, killer, reason, bodypart )
{
local KClan = GetTag( killer.Name ), DClan = GetTag( player.Name );

      if ( killer && player )
      {
                 if ( KClan && IsClanRegister( KClan ).tolower() ) { pstats[ KClan ].ClanKills++; }

                 if ( DClan && IsClanRegister( DClan ).tolower() ) { pstats[ DClan ].ClanDeaths++; }
      }         
}

savestats

Code Select

function SaveClanStats( player )
{
local id = player.ID;
   local Clan = GetTag( player.Name );
   if ( Clan && IsClanRegister ) {
        
   mysql_query( sDB, "UPDATE ClanStats SET Kills='" + pstats[ id ].ClanKills + "', Deaths='" + pstats[ id ].ClanDeaths + "' WHERE lower(Clan) = '" + Clan.tolower() + "'");
     print(mysql_error(sDB));

     print( "Saved Stats of Player" );
}
}

But its giving Error that the clan does not exists while its exists

Title: Re: Saving Clan kills/Deaths in array
Post by: Xmair on Mar 09, 2017, 07:42 AM

Show us the KClan and IsClanRegister functions.

Title: Re: Saving Clan kills/Deaths in array
Post by: Cool on Mar 09, 2017, 07:47 AM

@Xmair Kclan and Dclan is already defined as

Code Select

local KClan = GetTag( killer.Name ), DClan = GetTag( player.Name );isclanregister

Code Select

function IsClanRegister( clan )
{
        local q = ::SafeSelect( sDB, "SELECT Clan FROM ClanStats WHERE Clan='" + clan + "'" ); 
  if( mysql_num_rows( q ) == 1 )
  {
  local result = mysql_fetch_assoc( q );
  local Clan = result[ "Clan" ]; 
        local Reg = Clan;
        return (Reg) ? Reg : null;
mysql_free_result( q );
}
}

Vice City: Multiplayer

Server Development => Scripting and Server Management => Topic started by: Cool on Mar 09, 2017, 06:00 AM