View Single Post
  #2  
Old 09-08-2016, 08:46 PM
ghanja's Avatar
ghanja
Dragon
 
Join Date: Aug 2012
Location: Hershey, PA
Posts: 499
Default

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).
Reply With Quote