Hey Paxton, i really like your release but i need help. I dont know how to install Modern aac. Can you make a tutorial installation with photos?
paxton the default guild injection on Modern AAC. How does it work exactly?
Because I have made several guilds and it doesnt seem to show up there in site.
Is it based on a guild war system? If so can you link it?
You have to kill someone to get frags. This shows the highest guilds with amount of frags. If there is none, then it won't show.
<?php
$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: 140px;
}
</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 "".round($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 proud of being 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 being the lowest level";
echo "</div>";
//<<#### END Fame Hall Tab ####>>//
//??<<>><<>><<>><<>><<>><<>><<>><<>>??//
echo "</div></div><br><br><br>";
?>
I see. Then it aint bugged
Though I'm having problems with joining a guild. When I click on "join"
I get redirected back to where guild page is.
So I cant join a guild. Have tried with a different account too.
I'm using Guild Statistics v2 by Kavvson
Here is script
PHP:<?php $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: 140px; } </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 "".round($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 proud of being 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 being the lowest level"; echo "</div>"; //<<#### END Fame Hall Tab ####>>// //??<<>><<>><<>><<>><<>><<>><<>><<>>??// echo "</div></div><br><br><br>"; ?>
Upload guild logos doesn't work for me.
When I says "picture uploaded", which is true, the picture doesn't change.
Help on this please?
In config.php, you have to give exact path to yours guild_logos folder.
Why having echo and IF etc in uppercase, looks very messy for me in that way. :$