Showing ONLINE PPL ON GUILDS_VIEW

The extros · Jun 9, 2012

Hi.. im using modern aac and i wanna know if is there any injection on guilds_view that can make like some tibiarls layouts, show in green people who is online and in red who aren't... I realllyyyy need it, so if u know sthg plz tell me... THANKS!

Chris · Jun 9, 2012

Could you please share the existing guilds_view injection with us? So that we could alter that one?

The extros · Jun 9, 2012

Code:

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

?>

The extros · Jun 11, 2012

The extros · Jun 12, 2012

Chris · Jun 12, 2012

That is not the correct file.

The extros · Jun 12, 2012

what do i have to put.. can u specify plz?

Chris · Jun 12, 2012

/system/application/views/view_guild.php

The extros · Jun 12, 2012

Code:

<?php
$ide = new IDE;
try { $ide->loadInjections('guild_view'); } catch(Exception $e) { error($e->getMessage()); }
$logo = (file_exists("public/guild_logos/".$guild->getId().".gif")) ? "<img src='".WEBSITE."/public/guild_logos/".$guild->getId().".gif' width='64' height='64'>" : "<img src='".WEBSITE."/public/guild_logos/default.gif'>";
	echo "<div style='float: left; padding-right: 10px;'>$logo</div>";
	echo "<h1>".$guild->getName()."</h1>";
	echo $guild->getCustomField("motd");
	echo "<br /><br />Guild owner: <b><a href='".WEBSITE."/index.php/character/view/".$guild->getOwner()."'>".$guild->getOwner()."</a></b><br /><br />";
	
	$rank_list = $guild->getGuildRanksList();
	$rank_list->orderBy('level', POT::ORDER_DESC);
	$showed_players = 1;
		if($ide->isLogged()) {
		$ots = POT::getInstance();
		$ots->connect(POT::DB_MYSQL, connection());
		$account_logged = new OTS_Account();
		$account_logged->load($_SESSION['account_id']);
		$account_players = $account_logged->getPlayers();
		}
	echo "<table width='100%'>";
		foreach($rank_list as $rank)
		{
			$players_with_rank = $rank->getPlayersList();
			$players_with_rank->orderBy('name');
			$players_with_rank_number = count($players_with_rank);
			if($players_with_rank_number > 0)
			{
				echo "<tr class='rankBar'><td><b>".$rank->getName()."</b></td></tr>";
				foreach($players_with_rank as $player)
				{
					$guild_nick = $player->getGuildNick();
					if(!empty($guild_nick)) $guild_nick = "($guild_nick)"; else $guild_nick = "";
					if($ide->isLogged()) {$leave = (in_array($player->getName(), $account_players)) ? "<a href='#' onClick='if(confirm(\"Are you sure you want to leave ".$guild->getName()." with a ".$player->getName()." ?\")) window.location.href=\"".WEBSITE."/index.php/guilds/leave/".$guild->getId()."/".$player->getId()."\"'><img src='".WEBSITE."/public/images/false.gif'/></a>" : ""; }
					echo @"<tr class='playerGuildBar'><td>$leave<a href=\"".WEBSITE."/index.php/character/view/".$player->getName()."\">".$player->getName()."</a> $guild_nick</td></tr>";
				}
			}
		}
	echo "</table>";
		
	if(!$ide->isLogged()) {
		alert("You need to be logged in to access any options.");
	}
	else {

		require_once('system/application/libraries/POT/InvitesDriver.php');
		new InvitesDriver($guild);
		$invited_list = $guild->listInvites();
		if(count($invited_list) == 0)
			echo "<center><b>This guild did not invite anyone.</b></center>";
		else {
		echo "<table width='100%'>";
		echo "<tr><td><center><b>Name</b></center></td><td><center><b>Join</b></center></td></tr>";
		$characters = array();
		if($ide->isLogged()) {
			foreach($account_players as $player_from_acc) {
				$characters[] = $player_from_acc->getName();
			}
		}
			
		foreach($invited_list as $invited_player)
			{
				
						
						
						if($ide->isLogged() && in_array($invited_player->getName(), $characters)) {
							echo "<tr><td><center><a href=\"".WEBSITE."/index.php/character/view/".$invited_player->getName()."\">".$invited_player->getName()."</a></center></td><td><center><a href='".WEBSITE."/index.php/guilds/join/".$guild->getId()."/".$invited_player->getId()."'>Join</a></center></td></tr>";
							
						}
						else {
							echo "<tr><td><center><a href=\"".WEBSITE."/index.php/character/view/".$invited_player->getName()."\">".$invited_player->getName()."</a></center></td><td><center>Cannot join</center></td></tr>";
						
						}
				
				
			}
		echo "</table>";
		}
	
	}
	if($ide->isLogged() && in_array($guild->getOwner(), $account_players) || $leaders) {
		echo "<table style='text-align: center; margin-top: 10px;'><tr class='first'><td>Guild Management</td></tr><tr><td>";
		echo "<a href='".WEBSITE."/index.php/guilds/management/".$guild->getId()."'>Guild Management</a>";	
		echo "</td></tr></table>";
	}
	
	if(($ide->isLogged() && $viceleaders)) {
		echo "<table style='text-align: center; margin-top: 10px;'><tr class='first'><td>Guild Management</td></tr><tr><td>";
		echo "<a href='".WEBSITE."/index.php/guilds/management/".$guild->getId()."'>Guild Management</a>";	
		echo "</td></tr></table>";
	}

?>

Chris · Jun 12, 2012

Code:

<?php
$ide = new IDE;
try { $ide->loadInjections('guild_view'); } catch(Exception $e) { error($e->getMessage()); }
$logo = (file_exists("public/guild_logos/".$guild->getId().".gif")) ? "<img src='".WEBSITE."/public/guild_logos/".$guild->getId().".gif' width='64' height='64'>" : "<img src='".WEBSITE."/public/guild_logos/default.gif'>";
    echo "<div style='float: left; padding-right: 10px;'>$logo</div>";
    echo "<h1>".$guild->getName()."</h1>";
    echo $guild->getCustomField("motd");
    echo "<br /><br />Guild owner: <b><a href='".WEBSITE."/index.php/character/view/".$guild->getOwner()."'>".$guild->getOwner()."</a></b><br /><br />";
    
    $rank_list = $guild->getGuildRanksList();
    $rank_list->orderBy('level', POT::ORDER_DESC);
    $showed_players = 1;
        if($ide->isLogged()) {
        $ots = POT::getInstance();
        $ots->connect(POT::DB_MYSQL, connection());
        $account_logged = new OTS_Account();
        $account_logged->load($_SESSION['account_id']);
        $account_players = $account_logged->getPlayers();
        }
    echo "<table width='100%'>";
        foreach($rank_list as $rank)
        {
            $players_with_rank = $rank->getPlayersList();
            $players_with_rank->orderBy('name');
            $players_with_rank_number = count($players_with_rank);
            if($players_with_rank_number > 0)
            {
                echo "<tr class='rankBar'><td><b>".$rank->getName()."</b></td></tr>";
                foreach($players_with_rank as $player)
                {
                    $guild_nick = $player->getGuildNick();
                    if(!empty($guild_nick)) $guild_nick = "($guild_nick)"; else $guild_nick = "";
                    if($ide->isLogged()) {$leave = (in_array($player->getName(), $account_players)) ? "<a href='#' onClick='if(confirm(\"Are you sure you want to leave ".$guild->getName()." with a ".$player->getName()." ?\")) window.location.href=\"".WEBSITE."/index.php/guilds/leave/".$guild->getId()."/".$player->getId()."\"'><img src='".WEBSITE."/public/images/false.gif'/></a>" : ""; }
                    echo @"<tr class='playerGuildBar'><td>$leave<a href=\"".WEBSITE."/index.php/character/view/".$player->getName()."\">".'<span style="color: '.($player->isOnline() ? 'green' : 'red').';">' . $player->getName()."</a> $guild_nick</td></tr>";
                }
            }
        }
    echo "</table>";
        
    if(!$ide->isLogged()) {
        alert("You need to be logged in to access any options.");
    }
    else {


        require_once('system/application/libraries/POT/InvitesDriver.php');
        new InvitesDriver($guild);
        $invited_list = $guild->listInvites();
        if(count($invited_list) == 0)
            echo "<center><b>This guild did not invite anyone.</b></center>";
        else {
        echo "<table width='100%'>";
        echo "<tr><td><center><b>Name</b></center></td><td><center><b>Join</b></center></td></tr>";
        $characters = array();
        if($ide->isLogged()) {
            foreach($account_players as $player_from_acc) {
                $characters[] = $player_from_acc->getName();
            }
        }
            
        foreach($invited_list as $invited_player)
            {
                
                        
                        
                        if($ide->isLogged() && in_array($invited_player->getName(), $characters)) {
                            echo "<tr><td><center><a href=\"".WEBSITE."/index.php/character/view/".$invited_player->getName()."\">".'<span style="color: '.($invited_player->isOnline() ? 'green' : 'red').';">' . $invited_player->getName()."</span></a></center></td><td><center><a href='".WEBSITE."/index.php/guilds/join/".$guild->getId()."/".$invited_player->getId()."'>Join</a></center></td></tr>";
                            
                        }
                        else {
                            echo "<tr><td><center><a href=\"".WEBSITE."/index.php/character/view/".$invited_player->getName()."\">".'<span style="color: '.($invited_player->isOnline() ? 'green' : 'red').';">' . $invited_player->getName()."</a></center></td><td><center>Cannot join</center></td></tr>";
                        
                        }
                
                
            }
        echo "</table>";
        }
    
    }
    if($ide->isLogged() && in_array($guild->getOwner(), $account_players) || $leaders) {
        echo "<table style='text-align: center; margin-top: 10px;'><tr class='first'><td>Guild Management</td></tr><tr><td>";
        echo "<a href='".WEBSITE."/index.php/guilds/management/".$guild->getId()."'>Guild Management</a>";    
        echo "</td></tr></table>";
    }
    
    if(($ide->isLogged() && $viceleaders)) {
        echo "<table style='text-align: center; margin-top: 10px;'><tr class='first'><td>Guild Management</td></tr><tr><td>";
        echo "<a href='".WEBSITE."/index.php/guilds/management/".$guild->getId()."'>Guild Management</a>";    
        echo "</td></tr></table>";
    }


?>

Give that a shot and let me know if it works or not.

The extros · Jun 12, 2012

Code:

loadInjections('guild_view'); } catch(Exception $e) { >error($e-getMessage()); } $logo = >(file_exists("public/guild_logos/".$guild-getId().".gif")) ? "height='64'" : ""; echo "$logo"; echo "
>".$guild-getName()."

"; echo >$guild-getCustomField("motd"); echo "

Guild owner: 

"; $rank_list = >$guild-getGuildRanksList(); >$rank_list-orderBy('level', POT::ORDER_DESC); $showed_players = 1; >if($ide-isLogged()) { $ots = POT::getInstance(); >$ots-connect(POT::DB_MYSQL, connection()); $account_logged = new OTS_Account(); >$account_logged-load($_SESSION['account_id']); $account_players = >$account_logged-getPlayers(); } echo ""; foreach($rank_list as $rank) { $players_with_rank = >$rank-getPlayersList(); >$players_with_rank-orderBy('name'); $players_with_rank_number = count($players_with_rank); if($players_with_rank_number > 0) { echo ""; foreach($players_with_rank as $player) { $guild_nick = >$player-getGuildNick(); if(!empty($guild_nick)) $guild_nick = "($guild_nick)"; else $guild_nick = ""; >if($ide-isLogged()) {$leave = >(in_array($player-getName(), $account_players)) ? "" : ""; } echo @""; } } } echo "
>".$rank-getName()."
$leave>getName()."\"".'$player-getName()." $guild_nick
"; >if(!$ide-isLogged()) { alert("You need to be logged in to access any options."); } else { require_once('system/application/libraries/POT/InvitesDriver.php'); new InvitesDriver($guild); $invited_list = >$guild-listInvites(); if(count($invited_list) == 0) echo "
This guild did not invite anyone.
"; else { echo ""; echo ""; $characters = array(); >if($ide-isLogged()) { foreach($account_players as $player_from_acc) { $characters[] = >$player_from_acc-getName(); } } foreach($invited_list as $invited_player) { >if($ide-isLogged() && >in_array($invited_player-getName(), $characters)) { echo ""; } else { echo ""; } } echo "
Name
Join
>getName()."\"".'$invited_player-getName()."
>getName()."\"".'$invited_player-getName()."
Cannot join
"; } } >if($ide-isLogged() && >in_array($guild-getOwner(), $account_players) || $leaders) { echo "
Guild Management
"; echo "";	 echo "
"; } >if(($ide-isLogged() && $viceleaders)) { echo "
Guild Management
"; echo "";	 echo "
"; } >?

The extros · Jun 15, 2012

The extros · Jun 16, 2012

bring
up
my
post

The extros · Jun 17, 2012

Bump! Please help, really need it!

Chris · Jun 17, 2012

The code that you posted is incomplete. What exactly is not working with the code that I provided you with in my previous reply? Did you get an error?

The extros · Jun 17, 2012

that is the error i got...

Code:

loadInjections('guild_view'); } catch(Exception $e) { >error($e-getMessage()); } $logo = >(file_exists("public/guild_logos/".$guild-getId().".gif")) ? "height='64'" : ""; echo "$logo"; echo "
>".$guild-getName()."

"; echo >$guild-getCustomField("motd"); echo "

Guild owner: 

"; $rank_list = >$guild-getGuildRanksList(); >$rank_list-orderBy('level', POT::ORDER_DESC); $showed_players = 1; >if($ide-isLogged()) { $ots = POT::getInstance(); >$ots-connect(POT::DB_MYSQL, connection()); $account_logged = new OTS_Account(); >$account_logged-load($_SESSION['account_id']); $account_players = >$account_logged-getPlayers(); } echo ""; foreach($rank_list as $rank) { $players_with_rank = >$rank-getPlayersList(); >$players_with_rank-orderBy('name'); $players_with_rank_number = count($players_with_rank); if($players_with_rank_number > 0) { echo ""; foreach($players_with_rank as $player) { $guild_nick = >$player-getGuildNick(); if(!empty($guild_nick)) $guild_nick = "($guild_nick)"; else $guild_nick = ""; >if($ide-isLogged()) {$leave = >(in_array($player-getName(), $account_players)) ? "" : ""; } echo @""; } } } echo "
>".$rank-getName()."
$leave>getName()."\"".'$player-getName()." $guild_nick
"; >if(!$ide-isLogged()) { alert("You need to be logged in to access any options."); } else { require_once('system/application/libraries/POT/InvitesDriver.php'); new InvitesDriver($guild); $invited_list = >$guild-listInvites(); if(count($invited_list) == 0) echo "
This guild did not invite anyone.
"; else { echo ""; echo ""; $characters = array(); >if($ide-isLogged()) { foreach($account_players as $player_from_acc) { $characters[] = >$player_from_acc-getName(); } } foreach($invited_list as $invited_player) { >if($ide-isLogged() && >in_array($invited_player-getName(), $characters)) { echo ""; } else { echo ""; } } echo "
Name
Join
>getName()."\"".'$invited_player-getName()."
>getName()."\"".'$invited_player-getName()."
Cannot join
"; } } >if($ide-isLogged() && >in_array($guild-getOwner(), $account_players) || $leaders) { echo "
Guild Management
"; echo "";	 echo "
"; } >if(($ide-isLogged() && $viceleaders)) { echo "
Guild Management
"; echo "";	 echo "
"; } >?

Chris · Jun 17, 2012

Uh, that's no error. That's part of the code itself. Try copying the code again from my post.

Showing ONLINE PPL ON GUILDS_VIEW

The extros

New Member

Chris

Inactive

The extros

New Member

The extros

New Member

The extros

New Member

Chris

Inactive

The extros

New Member

Chris

Inactive

The extros

New Member

Chris

Inactive

The extros

New Member

The extros

New Member

The extros

New Member

The extros

New Member

Chris

Inactive

The extros

New Member

Chris

Inactive

Similar threads