Saving Clan kills/Deaths in array

[Cool]

class PlayerClass

Code Select Expand

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

Code Select Expand

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

Code Select Expand

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 Expand

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

[Xmair]

Show us the KClan and IsClanRegister functions.

[Cool]

@Xmair Kclan and Dclan is already defined as

Code Select Expand

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

Code Select Expand

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 );
}
}