[Gesior ACC] Guild statistics new version!

Stasiu13 · Sep 28, 2011

Hello i have got 2 errors

Uploaded with ImageShack.us

Kavvson · Sep 30, 2011

I know but I can fix it no clue how ^^

Wangsta · Jan 13, 2012

Stasiu13 said:
Hello i have got 2 errors

Uploaded with ImageShack.us

I have this same problem. It displays the new stats but all fields are blank. Anybody know what the problem is?

Wangsta · Jan 20, 2012

Still need help with this. Am I missing tables in my database or what? None of the advanced statistics are working.

mateusf26 · Jan 21, 2012

Nice! Thanks!!!

Marok · Jan 24, 2012

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause' in C:\Users\Administrator\Desktop\xampp\htdocs\guilds.php:296 Stack trace: #0 C:\Users\Administrator\Desktop\xampp\htdocs\guilds.php(296): PDO->query(' ?? SELE...') #1 C:\Users\Administrator\Desktop\xampp\htdocs\index.php(170): include('C:\Users\Admini...') #2 {main} thrown in C:\Users\Administrator\Desktop\xampp\htdocs\guilds.php on line 296

Naxtie · Feb 3, 2012

Got an error x)

Code:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause' in C:\xampp\htdocs\guilds.php:304 Stack trace: #0 C:\xampp\htdocs\guilds.php(304): PDO->query(' ?? SELE...') #1 C:\xampp\htdocs\index.php(136): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\guilds.php on line 304

Line 304: ')->fetch();

enrikeeee · Feb 7, 2012

Fatal error: Call to a member function getCustomField() on a non-object in C:\xampp\htdocs\guilds.php on line 136

how can fix it

suiciniv · Feb 19, 2012

sorry for my bad English but I used a translator. to solve this problem.

guild.php open and look for

if ($ guild_leader)
$ Main_content. = '<a Href="?subtopic=guilds&action=manager&guild='.$guild_name.'"> <IMG SRC = "'. $ Layout_name. '/ Images / buttons / sbutton_manageguild.png "BORDER = 0 WIDTH = 120 HEIGHT = 18 alt =" Manage Guild "> </ a> ';
$ Main_content. = '<BR>

select up

$ Main_content. = '</ FORM> </ TD> </ TR>';
}
$ Main_content. = '</ TABLE> </ TD> </ TR>';
}
}

and replace it by

if ($ guild_leader)
$ Main_content. = '<a Href="?subtopic=guilds&action=manager&guild='.$guild_name.'"> <IMG SRC = "'. $ Layout_name. '/ Images / buttons / sbutton_manageguild.png "BORDER = 0 WIDTH = 120 HEIGHT = 18 alt =" Manage Guild "> </ a> ';
$ Main_content. = '<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. = '<font Size=1> {<a
$ Main_content. = '</ FORM> </ TD> </ TR>';
}
$ Main_content. = '</ TABLE> </ TD> </ TR>';
}
}

I'm new here: D

suiciniv · Feb 19, 2012

sorry for my bad English but I used a translator. to solve this problem.

open guild.php and search for

Code:

  if($guild_leader)
            $main_content .= '&nbsp;&nbsp;&nbsp;<a href="?subtopic=guilds&action=manager&guild='.$guild_name.'"><IMG SRC="'.$layout_name.'/images/buttons/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>';
            }
        }

and replace it by

Code:

        if ($ guild_leader)
            $ Main_content. = '<a Href="?subtopic=guilds&action=manager&guild='.$guild_name.'"> <IMG SRC = "'. $ Layout_name. '/ Images / buttons / sbutton_manageguild.png "BORDER = 0 WIDTH = 120 HEIGHT = 18 alt =" Manage Guild "> </ a> ';
        $ Main_content. = '<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. = '<font Size=1> {<a
                    $ Main_content. = '</ FORM> </ TD> </ TR>';
                }
                $ Main_content. = '</ TABLE> </ TD> </ TR>';
            }
        }

I'm new here: D

TibiaGameHost · Feb 22, 2012

hey, upload guilds.php
Pleasy !

Naxtie · Feb 23, 2012

Doesn't work..

Wangsta · Feb 23, 2012

Naxtie said:
Doesn't work..

Yeah, no point in re-up. Tons of errors, and no support. It basically doesn't function at all as intended.

suiciniv · Feb 25, 2012

here is the guild.php

View attachment guilds.rar

sorry for not helping.

TibiaGameHost · Feb 26, 2012

suiciniv said:
here is the guild.php

View attachment 12619

sorry for not helping.

Thanks man!

Naxtie · Mar 6, 2012

Code:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause' in C:\xampp\htdocs\guilds.php:304 Stack trace: #0 C:\xampp\htdocs\guilds.php(304): PDO->query(' ?? SELE...') #1 C:\xampp\htdocs\index.php(136): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\guilds.php on line 304

Aint working for me...

Tachi · Jan 31, 2013

HAVING PROBLEMS... All i really want to to is add The Basic Stats.. Like Each players Level & Vocation... And I want to add right above the area for the invited players the Lowest Level, Highest Level, Total Guild Level, Total Members w/ invited members noted, Total Guild points...

beenii · May 9, 2016

no work.

[Gesior ACC] Guild statistics new version!

Stasiu13

New Member

Kavvson

Gdy boli cie glowa wez

Wangsta

TFS Dev/Gobal Tibia Expert

Wangsta

TFS Dev/Gobal Tibia Expert

mateusf26

New Member

Marok

Excellent OT User

Naxtie

mapper, designer

enrikeeee

New Member

suiciniv

New Member

suiciniv

New Member

TibiaGameHost

Hello!

Naxtie

mapper, designer

Wangsta

TFS Dev/Gobal Tibia Expert

suiciniv

New Member

TibiaGameHost

Hello!

Naxtie

mapper, designer

Tachi

New Member

beenii

Well-Known Member

Similar threads