Modern AAC Injection - Guild statistics V2!

Kavvson · May 13, 2010

Greetings Fellows.

I would like you to present a Injection for the latest Aac maker. Its not official don't its still a beta version but you might use it later.

I made a injection based on showing the amount of players in guild and the amount of players that are invited in the guild. I hope i inspirited you and i hope that you people take a chance and try to make a new and safer aac maker!

Tutorial where to place it?

enter the following direction \injections\guild_view crate a new folder with a name Statistics paste in it the code.. Save it as injection.php

In version 2

I added

PHP:

//%% - Fade %%//
//%% - Tabs %%//
//** - Show online members in the guild **//
//** - Show the total level of members in guild **//
//** - Show the average level of members in guild **//
//** - Show the highest level in guild **//
//** - Show the lowest level in guild **//

PHP:

   <?php
//** Connection to the database and getting the $guild_id **//
$ots = POT::getInstance();
$ots->connect(POT::DB_MYSQL, connection());
$connection = POT::getInstance()->getDBHandle();
$CI =& get_instance(); 
$CI->load->helper("url");
$guild_id = $CI->uri->segment(3);

//** SQL Query **//
//** List **//
//** Functions **//
//** - Show the amount of members in guild **//
//** - Show the amount of members that are invited **//
//** - V2 **//
//%% - Fade %%//
//%% - Tabs %%//
//** - Show online members in the guild **//
//** - Show the total level of members in guild **//
//** - Show the average level of members in guild **//
//** - Show the highest level in guild **//
//** - Show the lowest level in guild **//
$guildMembers = $connection->query ( 'SELECT COUNT(`gr`.`id`) AS `total` FROM `players` AS `p` LEFT JOIN `guild_ranks` AS `gr` ON `gr`.`id` = `p`.`rank_id` WHERE `gr`.`guild_id` = '.$guild_id )->fetch( );
$invite = $connection->query( 'SELECT COUNT(*) FROM `guild_invites` WHERE `guild_id` = '.$guild_id)->fetch( );
$allM = $connection->query ('SELECT COUNT(1) as `people` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') AND online = 1')->fetch(); 
$allM1 = $connection->query ('SELECT SUM(`level`) as `level` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') ')->fetch(); 
$allM2 = $connection->query ('SELECT AVG(`level`) as `level` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') ')->fetch(); 
$allM3 = $connection->query ('SELECT `name` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') ORDER BY `level` ASC LIMIT 1')->fetch(); 
$allM4 = $connection->query ('SELECT `name` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') ORDER BY `level` DESC LIMIT 1')->fetch(); 

//** Fade Effect **/
//** You can change the speed of the fade in .fadeIn(7000) **/
?>
<script>
$(document).ready(function() {$('#serverStats').fadeIn(6000)});
</script> 
<script>$(function(){$("#tabs").tabs();});</script>
<?PHP

//** - Start of the main content -**//
//** - You can add a tab -**//
echo "<style type=\"text/css\">
	.ui-tabs {
	height: 100px;
}
</style><div id=\"serverStats\" style=\"display: none;\"><div id='tabs'>";
echo '<ul>
		<li><a href="#general">General Informations</a></li>
		<li><a href="#statistics">Statistics</a></li>
		<li><a href="#glory">Fame Hall</a></li>
	</ul>';
	
	//<<#### General information Tab ####>>//
	//??<<>><<>><<>><<>><<>><<>><<>><<>>??//
	
	echo "<div id='general'>";
//@  Description of the Members amount @//
IF ( $guildMembers[0] == 1 )
ECHO "The Guild has ".$guildMembers[0]." member";
ELSE
ECHO "The Guild has ".$guildMembers[0]." members";
//** Separator between the members amount and invited players **//
ECHO "<br>";
//** End of Separator **//
//@  Description of the invited Members amount @//
IF ( $invite[0] == 0 )
ECHO "No members are invited";
ELSEIF ( $invite[0] == 1 )
ECHO "One member is invited";
ELSE "".$invite[0]." Members are currently invited";
//** Separator between the invited Members **//
ECHO "<br>";
//** End of Separator **//
//@  Description of the Online Members @//
IF ( $allM[0] == 0 )
ECHO "No one is online";
ELSEIF ( $allM[0] == 1 )
ECHO "One member is online";
ELSE "".$allM[0]." Members are currently online";
	echo "</div>";
	//<<#### END of General information Tab ####>>//
		//??<<>><<>><<>><<>><<>><<>><<>><<>>??//
		
		
	//<<#### StatisticsTab ####>>//
//??<<>><<>><<>><<>><<>><<>><<>><<>>??//

	echo "<div id='statistics'>";	
//@  Description of the Total Level of all members @//
ECHO "".$allM1[0]." Total level in guild";
//** Separator **//
ECHO "<br>";
//** End of Separator **//
//@  Description of the Avg Level of all members @//
ECHO "".$allM2[0]." Average level of all members in the guild";
//** Separator **//
ECHO "<br>";
//** End of Separator **//
	echo "</div>";
	
	//<<#### END Statistics Tab ####>>//
		//??<<>><<>><<>><<>><<>><<>><<>><<>>??//
		
		
	//<<#### Fame Hall Tab ####>>//
//??<<>><<>><<>><<>><<>><<>><<>><<>>??//

	echo "<div id='glory'>";
//@  Description of the Highest level in guild @//
ECHO "".$allM3[0]." Can be pround of beeing the best in guild";
//** Separator **//
ECHO "<br>";
//** End of Separator **//
//@  Description of the Lowest level in guild @//
ECHO "".$allM4[0]." Is a shame for the guild for beeing the lowest level";
			echo "</div>";
	//<<#### END Fame Hall Tab ####>>//
//??<<>><<>><<>><<>><<>><<>><<>><<>>??//
echo "</div></div><br><br><br>";

?>

Dont Forget to rep me

Still not enough

? check other scripts for Modern AAC
OtLand - Threads Tagged with modern aac kavvson

Paxton · May 13, 2010

Good

Tip for average levels

PHP: round - Manual and u can use LEFT JOIN

Marco96 · May 13, 2010

Its not official don't its still a beta version but you might use it later.

Its official but version 0.1 or what do you mean and for what is this scriptsi dont now really^^

Kavvson · May 13, 2010

Marco96 said:
Its not official don't its still a beta version but you might use it later.

Its official but version 0.1 or what do you mean and for what is this scriptsi dont now really^^

Hmmm Its a kind of a plugin.. You dont need to edit the whole file like it was in Gesior Acc , here u create a injection.php file and it will be included to a page that you want..

You can add anything

akues · May 13, 2010

Nice script

Kavvson · May 13, 2010

FIX!

Find

PHP:

ECHO "".$allM2[0]." Average level of all members in the guild";

Replace

PHP:

ECHO "".round($allM2[0])." Average level of all members in the guild";

Deleted member 12419 · May 14, 2010

Kavvson can you make it work properly for the new wow layout??

The text is really tiny and, it seems
* General Informations
* Statistics
* Fame Hall

Doesnt seem to work when you click there. Other than that it looks awesome

very useful indeed.

:thumbup:

stian · May 14, 2010

No credits for the queries?

http://otland.net/844441-post5.html
http://otland.net/844300-post3.html

EDIT:

Better version of the average is to round in mysql:

PHP:

$allM2 = $connection->query ('SELECT ROUND(AVG(`level`),0) FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') ')->fetch();

Korrex · May 14, 2010

Ooh. Me like =).

Kavvson · May 14, 2010

stian said:
No credits for the queries?

http://otland.net/844441-post5.html
http://otland.net/844300-post3.html

EDIT:

Better version of the average is to round in mysql:

PHP:

$allM2 = $connection->query ('SELECT ROUND(AVG(`level`),0) FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') ')->fetch();

true stain

Kavvson · May 14, 2010

Kavvson said:
true stain

stian i hate that here is no edit option:!

Kavvson · May 14, 2010

LeOoX said:
Kavvson can you make it work properly for the new wow layout??

The text is really tiny and, it seems
* General Informations
* Statistics
* Fame Hall

Doesnt seem to work when you click there. Other than that it looks awesome very useful indeed.

:thumbup:

Hmm show me a screen shoot so i will help you

stian · May 14, 2010

Kavvson said:
stian i hate that here is no edit option:!

I agree, all users should have edit option!

Kavvson · May 14, 2010

stian said:
I agree, all users should have edit option!

I posted a suggestion sign in

Zonet · May 15, 2010

PAXTON said:
Good

Tip for average levels

PHP: round - Manual and u can use LEFT JOIN

ceil() == round() :blink:

Paxton · May 15, 2010

Zonet said:
ceil() == round() :blink:

Not really, ceil will always raise up, round changes to the nearest.

Ecstacy · May 15, 2010

Thanks

Jeovani · May 24, 2010

I am looking for my site, gesior acc, but i not found

Kavvson · May 24, 2010

No gesior acc version and it wont be

Ecstacy · May 24, 2010

Fixed english in 'statics' tab.

PHP:

//<<#### Fame Hall Tab ####>>//
//??<<>><<>><<>><<>><<>><<>><<>><<>>??//

    echo "<div id='glory'>";
//@  Description of the Highest level in guild @//
ECHO "".$allM3[0]." can be proud for being the best player in guild";
//** Separator **//
ECHO "<br>";
//** End of Separator **//
//@  Description of the Lowest level in guild @//
ECHO "".$allM4[0]." is a shame for being the lowest level in the guild";
            echo "</div>";
    //<<#### END Fame Hall Tab ####>>//

Modern AAC Injection - Guild statistics V2!

Gdy boli cie glowa wez

Banned User

Nevoria War Project

Gdy boli cie glowa wez

Well-Known Member

Gdy boli cie glowa wez

Deleted member 12419

Guest

Banned User

Intermediate OT User

Gdy boli cie glowa wez

Gdy boli cie glowa wez

Gdy boli cie glowa wez

Banned User

Gdy boli cie glowa wez

Web Developer

Banned User

Mothafuckaaa

New Member

Gdy boli cie glowa wez

Mothafuckaaa

Similar threads