View Single Post
  #11  
Old 03-05-2012, 12:35 PM
sorvani
Dragon
 
Join Date: May 2010
Posts: 966
Default

you could simply rewrite that script to update the account table.
Code:
my $NewStatus = $status;
my $AcctID = $client->AccountID();
my $SQLQuery = '';

event_whatever {
  $NewStatus = $NewStatus + 1;
  $SQLQuery = 'update account set status = '.$NewStatus.' where id = '.$AcctID.';';
 $dbh->do($SQLQuery);
}
Reply With Quote