how to delete varibles from offline players

[rom3r]

set .@self, getcharid(3);
set .@size, query_sql("select account_id from `char` where online = 1", .@aid);
for(set .@i,0; .@i<.@size; set .@i,.@i+1) {
if(attachrid(.@aid[.@i])){
set Kill, 0;
set Death, 0;
set KillingStreak, 0;
set MultiKill, 0;
set KillingSpree, 0;
set Dominating, 0;
set MegaKill, 0;
set Unstoppable, 0;
set WickedSick, 0;
set MonsterKill, 0;
set Godlike, 0;
set BeyondGodlike, 0;
set DoubleKill, 0;
set TripleKill, 0;
set UltraKill, 0;
set Rampage, 0;
set Ownage, 0;
set NemesisKill, 0;
set FeedCount, 0;
query_sql("TRUNCATE TABLE `pvp_rank`");

This will clear them for online people but nothing ive tried clears the offline people.

Okay i got it working

query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'Kill'");
query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'Death'");
query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'KillingStreak'");
query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'MultiKill'");
query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'KillingSpree'");
query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'Dominating'");
query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'MegaKill'");
query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'Unstoppable'");
query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'WickedSick'");
query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'MonsterKill'");
query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'Godlike'");
query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'BeyondGodlike'");
query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'DoubleKill'");
query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'TripleKill'");
query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'UltraKill'");
query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'Rampage'");
query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'Ownage'");
query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'NemesisKill'");
query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'NemesisKilled'");
query_sql("DELETE FROM `global_reg_value` WHERE `str` = 'FeedCount'");

need that but is there a way to make it neater looking instead of all that?

[GmOcean]

Try this.

prontera,155,160,4	script	Global Reg Deleter	123,{
set .@a, getarraysize( .global_delete$ );
while( .@b < .@a )
{query_sql("DELETE FROM `global_reg_value` WHERE `str` = '"+ .global_delete$[.@b] +"'"); set .@b,.@b+1;}
end;
OnInit:
setarray .global_delete$[0],"Kill","Death","KillingStreak","MultiKill","KillingSpree","Dominating","MegaKill","Unstoppable","WickedSick","MonsterKill","Godlike","BeyondGodlike","DoubleKill","TripleKill","UltraKill","NemesisKill","NemesisKilled","FeedCount";
end;
}

[eKoh]

or you can use @var instead of var, this is a temporary variable, that means, once the player logs off it automatically gets deleted, for example:

 

set @Kill, @Kill + 1;
set @Death, @Death + 1;

[rom3r]

ill try that ty

[shadowscreen]

+1

 

if you want to rely on your current script, I think you can also change this line

select account_id from `char` where online = 1

to

select account_id from `char` where online = 1 OR online = 0

Edited August 19, 2014 by shadowscreen

[rom3r]

 

+1

 

if you want to rely on your current script, I think you can also change this line

select account_id from `char` where online = 1

to

select account_id from `char` where online = 1 OR online = 0

I tried that it still wouldnt delete the offline

[rom3r]

 

Try this.

prontera,155,160,4	script	Global Reg Deleter	123,{
set .@a, getarraysize( .global_delete$ );
while( .@b < .@a )
{query_sql("DELETE FROM `global_reg_value` WHERE `str` = '"+ .global_delete$[.@b] +"'"); set .@b,.@b+1;}
end;
OnInit:
setarray .global_delete$[0],"Kill","Death","KillingStreak","MultiKill","KillingSpree","Dominating","MegaKill","Unstoppable","WickedSick","MonsterKill","Godlike","BeyondGodlike","DoubleKill","TripleKill","UltraKill","NemesisKill","NemesisKilled","FeedCount";
end;
}

thank you looks so much neater