• 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!

[Gesior AAC] Guild statisctic + extras

try with this

PHP: 
//show guild page  
if($action == 'show')  
{  
	$guild_name = $_REQUEST['guild'];
	if(!check_guild_name($guild_name))
		$guild_errors[] = 'Invalid guild name format.';
	if(empty($guild_errors))
	{
		$guild = $ots->createObject('Guild');
		$guild->find($guild_name);
		if(!$guild->isLoaded())
			$guild_errors[] = 'Guild with name <b>'.$guild_name.'</b> doesn\'t exist.';
	}    if(!empty($guild_errors))  
    {  
        //show errors  
        $main_content .= '<div class="SmallBox" >  <div class="MessageContainer" >    <div class="BoxFrameHorizontal" style="background-image:url('.$layout_name.'/images/content/box-frame-horizontal.gif);" /></div>    <div class="BoxFrameEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div>    <div class="BoxFrameEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div>    <div class="ErrorMessage" >      <div class="BoxFrameVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);" /></div>      <div class="BoxFrameVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);" /></div>      <div class="AttentionSign" style="background-image:url('.$layout_name.'/images/content/attentionsign.gif);" /></div><b>The Following Errors Have Occurred:</b><br/>';  
        foreach($guild_errors as $guild_error)  
            $main_content .= '<li>'.$guild_error;  
        //errors and back button  
        $main_content .= '</div>    <div class="BoxFrameHorizontal" style="background-image:url('.$layout_name.'/images/content/box-frame-horizontal.gif);" /></div>    <div class="BoxFrameEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div>    <div class="BoxFrameEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div>  </div></div><br/><TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=100%><FORM ACTION="?subtopic=guilds" METHOD=post><TR><TD><center><INPUT TYPE=image NAME="Back" ALT="Back" SRC="'.$layout_name.'/images/buttons/sbutton_back.gif" BORDER=0 WIDTH=120 HEIGHT=18></center></TD></TR></FORM></TABLE>';  
    }  
    else  
    {  
        //check is it vice or/and leader account (leader has vice + leader rights)  
        $guild_leader_char = $guild->getOwner();  
        $rank_list = $guild->getGuildRanksList();  
        $rank_list->orderBy('level', POT::ORDER_DESC);  
        $guild_leader = FALSE;  
        $guild_vice = FALSE;  
        if($logged)  
        {  
            $account_players = $account_logged->getPlayers();  
            foreach($account_players as $player)  
            {  
                $players_from_account_ids[] = $player->getId();  
                $player_rank = $player->getRank();  
                if(!empty($player_rank))  
                    foreach($rank_list as $rank_in_guild)  
                        if($rank_in_guild->getId() == $player_rank->getId())  
                        {  
                            $players_from_account_in_guild[] = $player->getName();  
                            if($player_rank->getLevel() > 1)  
                            {  
                                $guild_vice = TRUE;  
                                $level_in_guild = $player_rank->getLevel();  
                            }  
                            if($guild->getOwner()->getId() == $player->getId())  
                            {  
                                $guild_vice = TRUE;  
                                $guild_leader = TRUE;  
                            }  
                        }  
            }  
        }  
        //show guild page  
        $guild_logo = $guild->getCustomField('logo_gfx_name');  
        if(empty($guild_logo) || !file_exists("guilds/".$guild_logo))  
            $guild_logo = "default_logo.gif";  
        $description = $guild->getCustomField('description');  
        $newlines   = array("\r\n", "\n", "\r");  
        $description_with_lines = str_replace($newlines, '<br />', $description, $count);  
        if($count < $config['site']['guild_description_lines_limit'])  
            $description = $description_with_lines;  
        $guild_owner = $guild->getOwner();  
        if($guild_owner->isLoaded())  
            $guild_owner = $guild_owner->getName();  
        $main_content .= '<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100%><TR>  
        <TD><IMG SRC="'.$layout_name.'/images/general/blank.gif" WIDTH=10 HEIGHT=1 BORDER=0></TD><TD>  
        <TABLE BORDER=0 WIDTH=100%>  
        <TR><TD WIDTH=64><IMG SRC="images/guilds/'.$guild_logo.'" WIDTH=64 HEIGHT=64></TD>  
        <TD ALIGN=center WIDTH=100%><H1>'.$guild->getName().'</H1></TD>  
        <TD WIDTH=64><IMG SRC="images/guilds/'.$guild_logo.'" WIDTH=64 HEIGHT=64></TD></TR>  
        </TABLE><BR> 
        <table BORDER=0 CELLPaDDING="4" CELLSPACING="1" width=100%;>  
        <TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><B>Description:</TD></TR> 
         
        <TR BGCOLOR="'.$config['site']['darkborder'].'"><TD> 
            <a href="?subtopic=characters&name='.urlencode($guild_owner).'"><b>'.$guild_owner.'</b></a> is guild leader of <b>'.$guild->getName().'</b>.</TD></TR> 
        <TR BGCOLOR="'.$config['site']['lightborder'].'"><TD> 
        The guild was founded on '.$config['server']['serverName'].' on '.date("j F Y", $guild->getCreationData()).'. 
        </TD</TR> 
        </TABLE>';  
        if($guild_leader)  
            $main_content .= '&nbsp;&nbsp;&nbsp;<a href="?subtopic=guilds&action=manager&guild='.$guild_name.'"><IMG SRC="http://i63.photobucket.com/albums/h122/Mister_Dude/sbutton_manageguild.png" BORDER=0 WIDTH=120 HEIGHT=18 alt="Manage Guild"></a>';  
        $main_content .= '<BR><BR>  
        <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>  
        <TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=3 CLASS=white><B>Guild Members</B></TD></TR>  
        <TR BGCOLOR='.$config['site']['darkborder'].'><TD WIDTH=30%><B>Rank</B></TD>  
        <TD WIDTH=70%><B>Name and Title</B></TD></TR>';  
        $showed_players = 1;  
        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)  
            {  
                if(is_int($showed_players / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $showed_players++;  
                $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD valign="top">'.$rank->getName().'</TD>  
                <TD><TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=100%>';  
                foreach($players_with_rank as $player)  
                {  
$main_content .= '';  
                    $main_content .= '<TR><TD><FORM ACTION="?subtopic=guilds&action=change_nick&name='.urlencode($player->getName()).'" METHOD=post><A HREF="?subtopic=characters&name='.urlencode($player->getName()).'">'.($player->isOnline() ? "<font color=\"green\">".$player->getName()."</font>" : "<font color=\"red\">".$player->getName()."</font>").'</A> <br><small>Level: '.$player->getLevel().' '.$vocation_name[$player->getWorld()][$player->getPromotion()][$player->getVocation()].'</small>';  
                    $guild_nick = $player->getGuildNick();  
                    if($logged)  
                        if(in_array($player->getId(), $players_from_account_ids))  
                            $main_content .= '(<input type="text" name="nick" value="'.htmlentities($player->getGuildNick()).'"><input type="submit" value="Change">)';  
                        else  
                        if(!empty($guild_nick))  
                            $main_content .= ' ('.htmlentities($player->getGuildNick()).')';  
                    else  
                        if(!empty($guild_nick))  
                            $main_content .= ' ('.htmlentities($player->getGuildNick()).')';  
                    if($level_in_guild > $rank->getLevel() || $guild_leader)  
                        if($guild_leader_char->getName() != $player->getName())  
                            $main_content .= '&nbsp;<font size=1>{<a href="?subtopic=guilds&action=kickplayer&guild='.$guild->getId().'&name='.urlencode($player->getName()).'">KICK</a>}</font>';  
                    $main_content .= '</FORM></TD></TR>';  
                }  
                $main_content .= '</TABLE></TD></TR>';  
            }  
                                                         
        }  
        $main_content .= '</TABLE><br><br>';  
             
        $guild_id = (int)$_GET['guild'];$guildMembers = $SQL->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( );$allM = $SQL->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 = $SQL->query ('SELECT SUM(`level`) as `level` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') ')->fetch();  
        $allM2 = $SQL->query ('SELECT AVG(`level`) as `level` FROM `players` WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = '.$guild_id.') ')->fetch();  
        $allM3 = $SQL->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 = $SQL->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();  
        $invite = $SQL->query( 'SELECT COUNT(*) FROM `guild_invites` WHERE `guild_id` = '.$guild_id.'')->fetch( );                         
         
        if(empty($allM3)) 
            $lowest .= 'Guilds dont have members.'; 
        else 
            $lowest .= ' '.$allM3[0].' '; 
        if(empty($allM4)) 
            $highest .= 'Guilds dont have members.'; 
        else 
            $highest .= ' '.$allM4[0].' '; 

$main_content .= '<table width="100%" cellspacing="1" cellpadding="4" border="0" ">         
        <tbody><tr bgcolor="'.$config['site']['vdarkborder'].'"><td class="white" colspan="3"><b>Guild Statistic</b></td></tr>         
        <tr bgcolor="'.$config['site']['darkborder'].'"><td width="30%"><b>Type</b></td>         
        <td width="50%"><b>Value</b></td></tr><tr bgcolor="'.$config['site']['lightborder'].'">               
        <td valign="top">Number of Members in Guild</td>      
        <td><table width="100%" cellspacing="0" cellpadding="0" border="0">   
        <tbody><tr><td>'.$guildMembers['total'].'</td></tr></tbody></table>      
        </td></tr>             
        <tr bgcolor="'.$config['site']['darkborder'].'"><td valign="top">Number of Members Online in Guild</td>           
        <td><table width="100%" cellspacing="0" cellpadding="0" border="0">      
        <tbody><tr><td>'.$allM[0].'</td></tr></tbody></table>     
        </td></tr>     
         
                      <tr bgcolor="'.$config['site']['lightborder'].'">  
        <td valign="top">Total Level in guild</td>         
        <td><table width="100%" cellspacing="0" cellpadding="0" border="0">       
        <tbody><tr><td>'.$allM1[0].'</td></tr></tbody></table>     
        </td></tr>            
        <tr bgcolor="'.$config['site']['darkborder'].'"><td valign="top">Avg Level in guild</td>           
        <td><table width="100%" cellspacing="0" cellpadding="0" border="0">     
        <tbody><tr><td>'.round($allM2[0]).'</td></tr></tbody></table>    
        </td></tr>  
         
        <tr bgcolor="'.$config['site']['lightborder'].'"> 
        <td valign="top">Lowest Level in guild</td>    
        <td><table width="100%" cellspacing="0" cellpadding="0" border="0"> 
        <tbody><tr><td>'.$lowest.'</td></tr></tbody></table>      
        </td></tr>           
        <tr bgcolor="'.$config['site']['darkborder'].'"><td valign="top">Highest Level in guild</td>     
        <td><table width="100%" cellspacing="0" cellpadding="0" border="0">    
        <tbody><tr><td>'.$highest.'</td></tr></tbody></table>      
        </td></tr>      
        <tr bgcolor="'.$config['site']['lightborder'].'"><td valign="top">Number of Invited Members</td>      
        <td><table width="100%" cellspacing="0" cellpadding="0" border="0">      
        <tbody><tr><td>'.$invite[0].'</td></tr></tbody></table>   
        </td></tr>      
        </table>';
 
Ok Well Every Post of the script im getting this error, (BTW: Gesior 2012, Version: 1.0.1... TFS 0.3.7 Crying Damson)
Code: 
[B]Fatal error: Call to a member function createObject() on a non-object in [B]D:\xampp\htdocs\pages\guilds.php on line [B]123[/B][/B][/B]

Here is line 123, im thinking its because i don't have variable $ots declared in it anywhere..
Code: 
$guild = $ots->createObject('Guild');


And if you could get it working that'd be pimp, Heres my FULL WORKING (before i edit with this) Guilds.php!!!!!
Code: 
ID POST HERE BUT 153000+ Pages long and OTLand only allows 37500 Characters to be posted...

LOOK  HERE:  [URL]http://aldoriana.servegame.com/guilds.txt[/URL]
 

Similar threads

Czorcik
  • Question
Problem with Gesior Acc HIGHSCORE (offline player)
Replies
2
Views
539
Czorcik
Czorcik
V
  • Question
AAC reset system geisor
Replies
0
Views
336
vitorelias1
V
johnsamir
  • Solved
AAC ZnoteAAC HELP highlighting boxes inside boxes php
Replies
10
Views
390
johnsamir
johnsamir
Back
Top Bottom