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
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><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 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>';
}
}
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>';
}
}
Doesn't work..
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