• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Modern AAC General Discussion.

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?
 
Upload guild logos doesn't work for me.
When I says "picture uploaded", which is true, the picture doesn't change.
 
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?

i wrote one
 

Attachments

Last edited:
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?
 
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.
 
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.

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>";

?>
 
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>";

?>

LeO, this is a injection it dont influence in the functionality :/ of the guild page
 
@ Kavvson so it was bug with the guild page :D

@ paxton awesome work ;) works now to join guild.
 
Last edited by a moderator:
Why having echo and IF etc in uppercase, looks very messy for me in that way. :$

Where do we use ECHO and IF in uppercase? The only place I can find is in the SQL forge things (in the queries), and thats just fine.
 
Back
Top