player and guild of month
help me fix this
this is guild
<?php if (!defined('FLUX_ROOT')) exit; $query = "SELECT name, master FROM {$session->loginAthenaGroup->loginDatabase}.guild WHERE guild_id = ? "; $sth = $session->loginAthenaGroup->connection->getStatement($query); $sth->execute(array($gtheme_config['guild_id'])); $gtheme_gom = $sth->fetchAll(); ?> <ul id="pgom"> <?php if($gtheme_gom): ?> <?php foreach($gtheme_gom as $row): ?> <li> <img class="gom" src="<?php echo $this->emblem($row->guild_id) ?>" /> </li> <li id="lbl" ><b>Guild: </b> <?php echo ($row->name)?$row->name:'???' ?></li> <li id="lbl" ><b>GM: </b> <?php echo ($row->master)? $row->master:'???' ?></li> <?php endforeach; ?> <?php else: ?> <li> <img class="gom" src="<?php echo $this->themePath('img/empty.bmp') ?>"/> </li> <li id="lbl" ><b>Guild: </b> rAthena</li> <li id="lbl" ><b>GM: </b> John Gerome Baldonado</li> <?php endif; ?> </ul>
this is player
<?php if (!defined('FLUX_ROOT')) exit; $query = "SELECT `char`.name as char_name, guild.name as guild_name FROM {$session->loginAthenaGroup->loginDatabase}.`char` "; $query .= "LEFT JOIN {$session->loginAthenaGroup->loginDatabase}.guild "; $query .= "ON {$session->loginAthenaGroup->loginDatabase}.`char`.char_id = {$session->loginAthenaGroup->loginDatabase}.guild.char_id "; $query .= "WHERE {$session->loginAthenaGroup->loginDatabase}.`char`.char_id = ? "; $sth = $session->loginAthenaGroup->connection->getStatement($query); $sth->execute(array($gtheme_config['char_id'])); $gtheme_pom = $sth->fetchAll(); //see gtheme/config.php ?> <ul id="pgom"> <?php if($gtheme_pom): ?> <li> <img class="pom" src="<?php echo $this->themePath('img/'.$gtheme_config['pom_image']) ?>"/> </li> <?php foreach($gtheme_pom as $row): ?> <li id="lbl" ><b>Name: </b> <?php echo ($row->char_name)? $row->char_name:'???' ?> </li> <li id="lbl" ><b>Guild: </b> <?php echo ($row->guild_name)? $row->guild_name:'???' ?></li> <?php endforeach; ?> <?php else: ?> <li> <img src="<?php echo $this->themePath('img/pom.gif') ?>"/> </li> <li id="lbl" ><b>Name: </b> John Gerome Baldonado </li> <li id="lbl" ><b>Guild: </b> rAthena</li> <?php endif; ?> </ul>
how to let this work instead of just the preassingd
and the news page i cant install cms as we got alrdy how to fix the next newspage??
<?php if (!defined('FLUX_ROOT')) exit; $title = Flux::message('NewsPage'); $news = Flux::config('FluxTables.NewsTable'); if(!$news){ echo '<p class="red">WARNING: FluxCMS is not Installed! Please download it in rathena.org</p>'; }else{ $sql = "SELECT * FROM {$server->loginDatabase}.$news ORDER BY id DESC"; $sth = $server->connection->getStatement($sql); $sth->execute(); $news = $sth->fetchAll(); } ?> <table cellpadding="20" cellspacing="10"> <?php if($news): ?> <?php foreach($news as $nrow):?> <tr> <td class="title"> <b> <a href="<?php echo $this->url('news','view') ?>"> <?php echo $nrow->title?> </a> </b><br/> <span class="author">Posted by: <strong><?php echo $nrow->author ?></strong></span> </td> <td class="date"><?php echo date('d-m-Y',strtotime($nrow->created))?></td> </tr> <?php endforeach; ?> <?php else: ?> <p>No News has been added.</p> <?php endif; ?> </table>