AA Exp on or off

ghanja · #2 09-08-2016, 08:46 PM

GetEXP()

However, I don't believe the percentage of experience to AA's is being parsed (is a method) in either Perl or LUA. That's not to say it can't be though, however, I'll leave that to those more comfortable with C++

Until then, try this Perl method of finding out the percentage of experience going towards AA's (that is assuming 'e_percent_to_aa' is what I think it is). The schema in the wiki hasn't been updated I don't think since the deblobbing.

Code:

## /plugins/PercentageToAA.pl

sub PercentageToAA {
	my $toonid = $_[0];
	my $dbh = plugin::LoadMysql();
	my $sth = $dbh->prepare("SELECT `e_percent_to_aa` FROM `character_data` WHERE id = ".$toonid." LIMIT 1");
	$sth->execute();	
	@data = $sth->fetchrow_array();
	$sth->finish();
	$dbh->disconnect();
	return $data[0];
}

return 1;

Usage:

Code:

my $percent = plugins::PercentageToAA($charid);

Untested (still away from home).