POM & GOM

[Zezicla]

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>

[Zezicla]

up

[Zezicla]

if some1 can fix this there is a free version of GOM and POM out

[Zezicla]

up

[Zezicla]

down