Search options (Page 2 of 3)

2007-03-17 06:07

[Bug] in tag [hide]

this mod : http://www.punres.org/viewtopic.php?id=1322

if I use [hide]blablabla[/hide]

Guest can see hide text

Guest go to Search page

"Select how to view search results" >>> "Show results as"

select "Posts"

put word do you want to see in topic in "Keyword search"

Ex.

Topic Name : BlaBlaBla
Message : BlaBlaBlaBlaBla
[hide]Hello World[/hide]

I is guest I search BlaBlaBlaBlaBla select "Posts" i can see

BlaBlaBla
BlaBlaBlaBlaBla
[hide]Hello World[/hide]

not
BlaBlaBla
BlaBlaBlaBlaBla
You must login to view hidden text

very very very sorry my bad english

2007-03-17 05:01

[requests] Admin Note

admin can edit word in form for admins and moderators see announcement in Administration page

Admins can edit and read

Moderaters can read only

sorry my bad english

2007-03-16 13:22

hi

pls help me

I'm use rewrite url mod

step8. REPLACE WITH

// [3-] mod Topic Preview
        if ($cur_topic['moved_to'] != 0)
            $subject = $lang_forum['Moved'].': <a href="viewtopic.php?id='.$cur_topic['moved_to'].'" onmouseover="ddrivetip(\''.$topic_preview[$cur_topic['moved_to']].'\')" onmouseout="hideddrivetip()">'.pun_htmlspecialchars($cur_topic['subject']).'</a> <span class="byuser">'.$lang_common['by'].' '.pun_htmlspecialchars($cur_topic['poster']).'</span>';
        else if ($cur_topic['closed'] == '0')
            $subject = '<a href="viewtopic.php?id='.$cur_topic['id'].'" onmouseover="ddrivetip(\''.$topic_preview[$cur_topic['id']].'\')" onmouseout="hideddrivetip()">'.pun_htmlspecialchars($cur_topic['subject']).'</a> <span class="byuser">'.$lang_common['by'].' '.pun_htmlspecialchars($cur_topic['poster']).'</span>';
        else
        {
            $subject = '<a href="viewtopic.php?id='.$cur_topic['id'].'" onmouseover="ddrivetip(\''.$topic_preview[$cur_topic['id']].'\')" onmouseout="hideddrivetip()">'.pun_htmlspecialchars($cur_topic['subject']).'</a> <span class="byuser">'.$lang_common['by'].' '.pun_htmlspecialchars($cur_topic['poster']).'</span>';
            $icon_text = $lang_common['Closed icon'];
            $item_status = 'iclosed';
        }
        // [-3] mod Topic Preview

but my file code have a rewrite mod

this code

        if ($cur_topic['moved_to'] != 0)
            $subject = $lang_forum['Moved'].': <a href="'.makeurl("t", $cur_topic['moved_to'], $cur_topic['subject']).'">'.pun_htmlspecialchars($cur_topic['subject']).'</a> <span class="byuser">'.$lang_common['by'].' '.pun_htmlspecialchars($cur_topic['poster']).'</span>';

        else if ($cur_topic['closed'] == '0')
            $subject = '<a href="'.makeurl("t", $cur_topic['id'], $cur_topic['subject']).'">'.pun_htmlspecialchars($cur_topic['subject']).'</a> <span class="byuser">'.$lang_common['by'].' '.pun_htmlspecialchars($cur_topic['poster']).'</span>';

        else
        {
            $subject = '<a href="'.makeurl("t", $cur_topic['id'], $cur_topic['subject']).'">'.pun_htmlspecialchars($cur_topic['subject']).'</a> <span class="byuser">'.$lang_common['by'].' '.pun_htmlspecialchars($cur_topic['poster']).'</span>';

            $icon_text = $lang_common['Closed icon'];
            $item_status = 'iclosed';
        }

how can I edit code in step8 to use with rewrite mod

sorry my bad english

2007-02-04 13:23

i see some board have a [ Generated in 0.131 seconds, 15 queries executed ] in the footer

how can i do that ?

2007-01-24 14:11

thank

and on this

2007-01-24 12:59

I have many style if I use html in that

this style it look nice but many style is look not good

I need to change in css

sorry my bad english

2007-01-23 14:06

Change in CSS ?

how to do that

change text color Board description ?

and

that (see in pic)

2007-01-23 09:58

what i can do ?

2007-01-21 13:54

I'm use punBB 1.2.14 and Arcade 1.1 ??

2007-01-21 13:38

oh

I have new error

An error was encountered
Error: Unable to get latest games.

2007-01-21 13:23

how to do the necessary DB modifications ?

2007-01-20 16:41

An error was encountered
File: **********************/httpdocs/arcade.php
Line: 59

PunBB reported: Unable to fetch total game count

Database reported: Unknown column 'game_id' in 'field list' (Errno: 1054)

2007-01-20 15:45

I install with original mod it not have error but when i change arcade.php to

<?php

session_name("arcade_games");
session_start();

// Session first run?
if (!isset($_SESSION['firsttime']))
{
// Set defaults
$_SESSION['firsttime'] = true;
$_SESSION['cat']=0;
$_SESSION['nump']=10;
$_SESSION['search']='';
$_SESSION['rsearch']='game_name';
$_SESSION['page']=0;
$_SESSION['sorto']='DESC';
$_SESSION['sortby']='game_id';
....
....
....

I have that error

2007-01-19 12:51

Tubby wrote:

if you are refering to the modified arcade.php then have a look at this code:

<?php


session_name("arcade_games");
session_start();

// Session first run?
if (!isset($_SESSION['firsttime']))
{
    // Set defaults
    $_SESSION['firsttime'] = true;
    $_SESSION['cat']=0;
    $_SESSION['nump']=10;
    $_SESSION['search']='';
    $_SESSION['rsearch']='game_name';
    $_SESSION['page']=0;
    $_SESSION['sorto']='DESC';
    $_SESSION['sortby']='game_id';
}
else
{
    // no first run, use post or request
    if (isset($_POST['nump'])) $_SESSION['nump']=$_POST['nump'];
    if (isset($_POST['cat'])) $_SESSION['cat']=$_POST['cat'];
    if (isset($_POST['search'])) $_SESSION['search']=$_POST['search'];
    if (isset($_POST['rsearch'])) $_SESSION['rsearch']=$_POST['rsearch'];
    if (isset($_REQUEST['page'])) $_SESSION['page']=$_REQUEST['page'];
    if (isset($_POST['sorto'])) $_SESSION['sorto']=$_POST['sorto'];
    if (isset($_POST['sortby'])) $_SESSION['sortby']=$_POST['sortby'];
}

// Define local vars
$s_nump = $_SESSION['nump'];
$s_cat = $_SESSION['cat'];
$s_search = $_SESSION['search'];
$s_rsearch = $_SESSION['rsearch'];
$s_page = $_SESSION['page'];
$s_sorto = $_SESSION['sorto'];
$s_sortby = $_SESSION['sortby'];


if (!defined('PUN_ROOT')) define('PUN_ROOT','./');

require PUN_ROOT.'include/common.php';
require PUN_ROOT.'lang/'.$pun_user['language'].'/arcade.php';
require PUN_ROOT.'header.php';

$page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / Arcade Games';
if (!function_exists('generate_config_cache'))
    require PUN_ROOT.'include/cache.php';
    
if ($pun_config['arcade_live'] == '0')
    message($lang_arcade['arcade disabled']);
    
    
if (!$pun_user['is_guest'])
{
    // Fetch total game count
    $result = $db->query('SELECT COUNT(game_id) FROM '.$db->prefix.'arcade_games') or error('Unable to fetch total game count', __FILE__, __LINE__, $db->error());
    $num_games = $db->result($result);

    
    // Arcade Statistic Block
    ?>
    <div class="blockform">
    <h2><span><?php echo 'Arcade Games ('.$lang_arcade['number games'].' '.$num_games.')' ?></span></h2>
        <div class="box">
        <?// Newest games ?>
        <table cellspacing="0" style="padding: 2px 2px 2px 2px; border:none;">            
        <tr style="padding: 2px 2px 2px 2px; border:none;" width="25%">
            <td valign="top" width="20%" style="padding: 2px 2px 2px 2px; border:none;">
            <fieldset>
            <legend align="left"> <?php echo ''.$lang_arcade['new_games'].'' ?> </legend>
            <table width="0" border="0" cellspacing="0" cellpadding="0" style="padding: 0px 0px 0px 0px; border:none;">
            <?
            // Get latest games
            $result2 = $db->query('SELECT game_id, game_name, game_image FROM '.$db->prefix.'arcade_games ORDER BY game_id DESC LIMIT '.$pun_config['arcade_numnew'].'') or error('Unable to get latest games', __FILE__, __LINE__, $db->error());
            $i = 1;
            while($line = $db->fetch_assoc($result2))
            {
                echo '
  <tr style="padding: 0px 0px 0px 0px; border:none;">
    <td style="padding: 0px 0px 0px 0px; border:none;"><a href="arcade_play.php?id='.$line['game_id'].'"><img width="15" hight="5" align="center" src="games/images/'.$line['game_image'].'" /></a></td>
    <td style="padding: 0px 0px 0px 2px; border:none;"><div align="left"><a href="arcade_play.php?id='.$line['game_id'].'">'.$line['game_name'].'</a></div></td>
  </tr>
';
                $i++;
            }

            ?></table><p></p>

            </td></fieldset>
            <?// King of Highscore images ?>
            <td valign="top" width="50%" style="padding: 2px 2px 2px 2px; border:none;">
            <fieldset>
            <legend align="left"> <?php echo ''.$lang_arcade['highscore_champs'].'' ?> </legend><p></p>
            
            <table cellspacing="0" style="padding: 0px 0px 0px 0px; border:none;">
            <tr style="padding: 0px 0px 0px 0px; border:none;">
            <td class="alt2" align="center" nowrap="nowrap" valign="middle" width="33%" style="padding: 0px 0px 0px 0px; border:none;"><b><img src="./img/arcade/king1.gif" alt="1"></b></td>
            <td class="alt2" align="center" nowrap="nowrap" valign="middle" width="33%" style="padding: 0px 0px 0px 0px; border:none;"><b><img src="./img/arcade/king2.gif" alt="2"></b></td>
            <td class="alt2" align="center" nowrap="nowrap" valign="middle" width="33%" style="padding: 0px 0px 0px 0px; border:none;"><b><img src="./img/arcade/king3.gif" alt="3"></b></td>
            </tr>
    <?php
            // Count all Highscores per user, display the king of the highscores
            $sql = 'SELECT id,username, COUNT(*) AS count_top FROM '.$db->prefix.'arcade_ranking INNER JOIN '.$db->prefix.'users ON ('.$db->prefix.'users.id = '.$db->prefix.'arcade_ranking.rank_player) WHERE '.$db->prefix.'arcade_ranking.rank_topscore = 1 GROUP BY '.$db->prefix.'arcade_ranking.rank_player ORDER BY count_top DESC LIMIT 3';
            $query = $db->query($sql) or error("Impossible to collect highscores per user.", __FILE__, __LINE__, $db->error());
            $i = 1;
            while($line = $db->fetch_assoc($query))
            {                
                echo '<td width="33%" align="center" nowrap="nowrap" valign="middle" style="padding: 0px 0px 0px 0px; margin-top: 0px; margin-left: 0px; margin-right: 0px; margin-bottom: 0px; border:none; "><strong><span style="text-decoration:blink"><a href="profile.php?id='.$line['id'].'">'.$line['username'].'</a></strong></span><br/>'.$lang_arcade['with'].' <b>'.$line['count_top'].'</b> '.$lang_arcade['highscores'].'</td>';
                $i++;
            }
    ?>
            </table>
            </fieldset>
            <p></p>
            <fieldset>
            <legend align="left"> <?php echo ''.$lang_arcade['new_highscore_champs'].'' ?> </legend><table cellspacing="0" style="padding: 2px 2px 2px 2px; border:none;" width="100%"><tr style="padding: 2px 2px 2px 2px; border:none; "><td style="padding: 2px 2px 2px 2px; border:none;" ><strong>User</strong></td><td style="padding: 2px 2px 2px 2px; border:none;" ><strong>Game</strong></td><td style="padding: 2px 2px 2px 2px; border:none;" ><strong>Score</strong></td><td style="padding: 2px 2px 2px 2px; border:none;" ><strong>Date</strong></td></tr>
    <?php
            // Find the latest Highscores    
            $sql = 'SELECT game_name, game_id, game_image, rank_topscore, username, id, rank_date, rank_score FROM '.$db->prefix.'arcade_ranking, '.$db->prefix.'arcade_games, '.$db->prefix.'users WHERE rank_topscore = 1 AND rank_game = game_filename AND '.$db->prefix.'users.id = rank_player GROUP BY game_name ORDER BY rank_date DESC LIMIT '.$pun_config['arcade_numchamps'].'';
            $query = $db->query($sql) or error("Impossible to select the latest highscores.", __FILE__, __LINE__, $db->error());
            $i = 1;
            while($line = $db->fetch_assoc($query))
            {
                // Display the latest Highscores    
                echo '
<tr style="padding: 0px 0px 0px 0px; border:none; "><td style="padding: 0px 0px 0px 0px; border:none; "><a href="profile.php?id='.$line['id'].'">'.$line['username'].'</a></td><td style="padding: 0px 0px 0px 0px; border:none; "><table style="padding: 0px 0px 0px 0px; border:none; ">
  <tr style="padding: 0px 0px 0px 0px; border:none; ">
    <td style="padding: 0px 0px 0px 0px; border:none;" width="15"><a href="arcade_play.php?id='.$line['game_id'].'"><img width="15" hight="15" src="games/images/'.$line['game_image'].'" /></a></td>
    <td style="padding: 0px 0px 0px 0px; border:none;" align="left"><a href="arcade_play.php?id='.$line['game_id'].'">'.$line['game_name'].'</a></td>
  </tr>
</table>
</td><td style="padding: 0px 0px 0px 0px; border:none; ">'.$line['rank_score'].'</td><td style="padding: 0px 0px 0px 0px; border:none; ">('.format_time($line['rank_date']).')</td></tr>';
                $i++;
            }
    ?></table>
            
    
            </fieldset>
            <?// Most played games ?>
            </td>
            <td  valign="top" width="25%" style="padding: 2px 2px 2px 2px; border:none;" >
            <fieldset>
            <legend align="left"> <?php echo ''.$lang_arcade['most_played'].'' ?> </legend><p></p>
            <table width="0" border="0" cellspacing="0" cellpadding="0" style="padding: 0px 0px 0px 0px; border:none;">
            <?
            // Find most played games
            $result3 = $db->query('SELECT game_id, game_name, game_played, game_image FROM '.$db->prefix.'arcade_games ORDER BY game_played DESC LIMIT '.$pun_config['arcade_mostplayed'].'') or error('Unable to get most played games', __FILE__, __LINE__, $db->error());
            $i = 1;
            while($line = $db->fetch_assoc($result3))
            {
                // Display most played games
                                echo '
  <tr style="padding: 0px 0px 0px 0px; border:none;">
    <td style="padding: 0px 0px 0px 0px; border:none;"><a href="arcade_play.php?id='.$line['game_id'].'"><img width="15" hight="5" align="center" src="games/images/'.$line['game_image'].'" /></a></td>
    <td style="padding: 0px 0px 0px 2px; border:none;"><div align="left"><a href="arcade_play.php?id='.$line['game_id'].'">'.$line['game_name'].'</a></div></td>
  </tr>
';
                $i++;
            }
            ?></table><p></p>
            </fieldset>
            
            <?// Get random game
            $result6 = $db->query('SELECT game_id, game_name,game_image,game_played,rank_topscore,username,id,rank_date,rank_score FROM '.$db->prefix.'arcade_games, '.$db->prefix.'arcade_ranking, '.$db->prefix.'users order by RAND() LIMIT 1') or error('Unable to fetch total game count', __FILE__, __LINE__, $db->error());
    $randg = $db->fetch_assoc($result6);?>
            <p><fieldset>
            <legend align="left"><? echo $lang_arcade['randomg'] ?></legend><p></p>
            <table width="0" border="0" cellspacing="0" cellpadding="0" style="padding: 0px 0px 0px 0px; border:none;">
  <tr style="padding: 0px 0px 0px 0px; border:none;">
    <td style="padding: 0px 0px 0px 0px; border:none;" width="50"><a href="arcade_play.php?id=<? echo $randg['game_id'] ?>" title="<? echo $lang_arcade['Pic Click']?>"><img align="center" src="games/images/<? echo $randg['game_image']?>" /></a></td>
    <td style="padding: 2px 2px 2px 2px; border:none;"><div align="left"><a href="arcade_play.php?id=<? echo $randg['game_id']?>"><? echo $randg['game_name']?></a><br><?php echo''.$lang_arcade['times played'].' <strong>'.$randg['game_played'].'</strong><br />
<a href="arcade_ranking.php?id='.$randg['game_id'].'">'.$lang_arcade['View Highscores'].'</a>'; ?>
</div></td>
  </tr>
</table>

            <p>
            </fieldset>
            
            </td>
        </tr>
        </table>
        </div>
    </div>    

<?php


    // Define search query
    if (strlen($s_search)>0) $sqlquery .= " WHERE {$s_rsearch} LIKE '%{$s_search}%'";
    
    // Did we use a category or the search box?
    if ($s_cat>0)
    {
        if (strlen($s_search)>0)
        {
            $sqlquery .= " AND game_cat = {$s_cat} ORDER BY game_name {$s_sorto}";
        }
        else
        {
            $sqlquery .= " WHERE game_cat = {$s_cat} ORDER BY game_name {$s_sorto}";
        }
    }
    else
    {
        $sqlquery .= " ORDER BY {$s_sortby} {$s_sorto}";
    }
    
    // Filter Block
    ?>
    <div class="box" style="padding:5px;">
        <fieldset>
            <legend><? echo $lang_arcade['filter']?></legend>
            <div class="infldset">
                <form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>" enctype="multipart/form-data">
                    <table cellspacing="0" style="padding: 0px 0px 0px 0px; margin-top: 0px; margin-left: 0px; margin-right: 0px; margin-bottom: 0px; border:none; ">
                    <tr>
                        <td valign="top" align="left" width="20%" style="padding: 0px 0px 0px 0px; margin-top: 0px; margin-left: 0px; margin-right: 0px; margin-bottom: 0px; border:none; "><? echo $lang_arcade['numgames']?><p>
                        <select id="nump" name="nump">
                        <option value="10" <?php if ($s_nump == 10) echo ' selected="selected"' ?>>10</option>
                        <option value="25" <?php if ($s_nump == 25) echo ' selected="selected"' ?>>25</option>
                        <option value="50" <?php if ($s_nump == 50) echo ' selected="selected"' ?>>50</option>
                        <option value="100" <?php if ($s_nump == 100) echo ' selected="selected"' ?>>100</option>
                        </select><p>
                        <input type="radio" name="sorto" value="ASC" <?php if ($s_sorto == 'ASC') { echo ' checked'; } ?> />
                         <?echo $lang_arcade['asc']?> 
                        <input type="radio" name="sorto" value="DESC" <?php if ($s_sorto == 'DESC') { echo ' checked'; } ?> />
                         <?echo $lang_arcade['desc']?>
                        </td>
                        <td valign="top" align="left" style="padding: 0px 0px 0px 0px; margin-top: 0px; margin-left: 0px; margin-right: 0px; margin-bottom: 0px; border:none; "><? echo $lang_arcade['sortby']?><p>
                        <select id="sortby" name="sortby">
                        <option value="game_name" <?php if ($s_sortby == 'game_name') echo ' selected="selected"' ?>><? echo $lang_arcade['name']?></option>
                        <option value="game_id" <?php if ($s_sortby == 'game_id') echo ' selected="selected"' ?>><? echo $lang_arcade['date']?></option>
                        </select><p>
                        </td>
                        <td valign="top" align="left" style="padding: 0px 0px 0px 0px; margin-top: 0px; margin-left: 0px; margin-right: 0px; margin-bottom: 0px; border:none; "><? echo $lang_arcade['category']?><p>
                        <select id="cat" name="cat">
                        <option value="0" <?php if ($s_cat == 0) echo ' selected="selected"' ?>><? echo $lang_arcade['all cat']?></option>
                        <option value="1" <?php if ($s_cat == 1) echo ' selected="selected"' ?>><? echo $lang_arcade['cat1']?></option>
                        <option value="2" <?php if ($s_cat == 2) echo ' selected="selected"' ?>><? echo $lang_arcade['cat2']?></option>
                        <option value="3" <?php if ($s_cat == 3) echo ' selected="selected"' ?>><? echo $lang_arcade['cat3']?></option>
                        <option value="4" <?php if ($s_cat == 4) echo ' selected="selected"' ?>><? echo $lang_arcade['cat4']?></option>
                        <option value="5" <?php if ($s_cat == 5) echo ' selected="selected"' ?>><? echo $lang_arcade['cat5']?></option>
                        <option value="6" <?php if ($s_cat == 6) echo ' selected="selected"' ?>><? echo $lang_arcade['cat6']?></option>
                        <option value="7" <?php if ($s_cat == 7) echo ' selected="selected"' ?>><? echo $lang_arcade['cat7']?></option>
                        <option value="8" <?php if ($s_cat == 8) echo ' selected="selected"' ?>><? echo $lang_arcade['cat8']?></option>
                        <option value="9" <?php if ($s_cat == 9) echo ' selected="selected"' ?>><? echo $lang_arcade['cat9']?></option>
                        </select>
                        </td>
                        <td valign="top" align="left" style="padding: 0px 0px 0px 0px; margin-top: 0px; margin-left: 0px; margin-right: 0px; margin-bottom: 0px; border:none; "><? echo $lang_arcade['search']?><p>
                        <input type="text" id="search" name="search" size="20" maxlength="100" value="<?php echo pun_htmlspecialchars($s_search); ?>" />
                          
                        <p><input type="radio" name="rsearch" value="game_name" <?php if ($s_rsearch == 'game_name') { echo ' checked'; } ?> />
                         <?echo $lang_arcade['gname']?> 
                        <input type="radio" name="rsearch" value="game_desc" <?php if ($s_rsearch == 'game_desc') { echo ' checked'; } ?> />
                         <?echo $lang_arcade['gdesc']?>
                        </td>
                    </tr>
                    <tr>
                        <td valign="bottom" colspan="5" style="padding: 0px 0px 0px 0px; margin-top: 0px; margin-left: 0px; margin-right: 0px; margin-bottom: 0px; border:none; ">
                        <input type="hidden" name="page" value="0" />
                        <br><p><input type="submit" name="filter" value="<?echo $lang_arcade['start']?>" />      <input name="filter" type="submit" onclick="nump.value='10';cat.value='0';search.value='';rsearch.value='game_name';elements[5].checked = true;elements[2].checked = true;sortby.value='game_id';window.location='<?php echo $_SERVER['PHP_SELF'] ?>';" value="<?echo $lang_arcade['reset']?>" />
                        </td>
                    </tr>
                    </table>
                </form>
            </div>
        </fieldset>
    </div>    
    
<?php

    // Fetch game count and generate pages, after using filter
    $result = $db->query('SELECT COUNT(game_id) FROM '.$db->prefix.'arcade_games '.$sqlquery) or error('Unable to fetch filter count', __FILE__, __LINE__, $db->error());
    $num_games2 = $db->result($result);
    $currec = $s_page * $s_nump;
    $kolvop = ceil($num_games2 / $s_nump);
    $cp = ($kolvop == 0? 1 : $kolvop);
    $nump = $s_nump;


    // Generate page links
     if ($cp>1)
        {
            echo '<p>', $lang_common['Pages'],':';
            for ($i=1;$i<=$cp;$i++)
            if (($i-1)==$s_page) echo " $i ";
            else echo ' <a href="'.$_SERVER['PHP_SELF'].'?page='.($i-1).'">'.$i.'</a> ';
        }
        echo '<p>';

?>
<div class="blockform">
<h2><span><?php echo ''.$lang_arcade['Games'].''; ?></span></h2>
    <div class="box">
        <div class="inbox">
            <table cellspacing="0">
            <thead>
                <tr>
                    <th class="tc2" scope="col" width="25%" nowrap="nowrap"><?php echo $lang_arcade['Games'] ?></th>
                    <th class="tc2" scope="col" width="25%" nowrap="nowrap"><?php echo $lang_arcade['Champion'] ?></th>
                    <th class="tc3" scope="col" width="25%" nowrap="nowrap"><?php echo $lang_arcade['Personal Best'] ?></th>
                    <th class="tcr" scope="col" width="25%" ><?php echo $lang_arcade['Description'] ?> / <?php echo $lang_arcade['How to play'] ?></th>
                </tr>
            </thead>
<tbody>
            
<?php
        // Filter query
        $result = $db->query('SELECT * FROM '.$db->prefix.'arcade_games '.$sqlquery." LIMIT $currec,$nump") or error("Impossible to filter games", __FILE__, __LINE__, $db->error());
        while($line = $db->fetch_assoc($result))
        {
            // Find Top Highscore of each game        
            $sql2 = 'SELECT rank_player, rank_score, username, id FROM '.$db->prefix.'arcade_ranking, '.$db->prefix.'users WHERE rank_game = "'.$line['game_filename'].'" AND '.$db->prefix.'users.id = '.$db->prefix.'arcade_ranking.rank_player ORDER BY rank_score DESC LIMIT 1';
            $query = $db->query($sql2) or error("Impossible to find the topscore of each game", __FILE__, __LINE__, $db->error());
            $resultat = $db->fetch_assoc($query);
            if (($resultat['rank_score']) && ($pun_config['arcade_showtop'] > 0))
                $h_score = ''.$lang_arcade['Top highscore'].'<strong>'.$resultat['rank_score'].'</strong><i> '.$lang_arcade['by'].' <strong><a href="profile.php?id='.$resultat['id'].'">'.$resultat['username'].'</a></i></strong> <p>'.$lang_arcade['played'].' <strong>'.$line['game_played'].'</strong></p>';
            else
                $h_score = ' ';
                echo '            <thead>
                <tr>
                    <td class="tc1" scope="col" width="25%" ><table style="padding: 0px 0px 0px 0px; border:none; "><tr style="padding: 0px 0px 0px 0px; border:none; ">
                                                <td style="padding: 0px 0px 0px 0px; border:none; " align="left" width="50"><a href="arcade_play.php?id='.$line['game_id'].'" title="'.$lang_arcade['Pic Click'].'"><img src="games/images/'.$line['game_image'].'" alt="'.$line['game_name'].'" /></a></td>
                                                <td style="padding: 0px 0px 0px 0px; border:none; " align="left">'.$lang_arcade['Play'].': "<a href="arcade_play.php?id='.$line['game_id'].'" title="'.$lang_arcade['Pic Click'].'">'.$line['game_name'].'</a>"<br>
'.$lang_arcade['times played'].' <strong>'.$line['game_played'].'</strong></td>
                                                </tr>
                                                </table></td>
                    <td class="tc2" scope="col" width="25%" nowrap="nowrap">';
                    if ($resultat['rank_score'] > 0) {
                    echo''.$lang_arcade['Top highscore'].'<strong>'.$resultat['rank_score'].'</strong><br />
<i> '.$lang_arcade['by'].' <strong><a href="profile.php?id='.$resultat['id'].'">'.$resultat['username'].'</a></i></strong><br />
<a href="arcade_ranking.php?id='.$line['game_id'].'">'.$lang_arcade['View Highscores'].'</a>'; } else { echo ''.$lang_arcade['Top highscore'].'<strong> N/A'; } echo '</td>
                    <td class="tc2" scope="col" width="25%" nowrap="nowrap">'; 
                    $result21 = $db->query('SELECT rank_score, game_id, game_name, game_played FROM '.$db->prefix.'arcade_ranking, '.$db->prefix.'arcade_games WHERE rank_game = "'.$line['game_filename'].'" AND rank_player = "'.$pun_user['id'].'"') or error('Unable to fetch scores info', __FILE__, __LINE__, $db->error());
if(mysql_num_rows($result21) <= 0)
{
?>
<? echo $lang_arcade['Not played Yet'] ?><?php echo '<br />'.$lang_arcade['Play'].': <br />"<a href="arcade_play.php?id='.$line['game_id'].'" title="'.$lang_arcade['Pic Click'].'">'.$line['game_name'].'</a>"'; ?>
<?php
}
else
{
    $line21 = $db->fetch_assoc($result21);
?>
    
    <? echo $lang_arcade['Personal Best'],': ' ?> <strong><? echo $line21['rank_score'] ?></strong>
    
<?php
}
?><?php echo '</td>
                    <td class="tc1" scope="col" width="25%" ><i>'.$line['game_desc'].'</i></td>
                </tr>
            </thead>';
            }
    ?>
    </tbody></table></div></div></div>

    <?php
        // Generate page links
     if ($cp>1)
        {
            echo $lang_common['Pages'],':';
            for ($i=1;$i<=$cp;$i++)
            if (($i-1)==$s_page) echo " $i ";
            else echo ' <a href="'.$_SERVER['PHP_SELF'].'?page='.($i-1).'">'.$i.'</a> ';
        }
        echo '<p>';
        
    require PUN_ROOT.'footer.php';

}
else
    message($lang_common['No permission']);

I have error pls help me ??????

An error was encountered
Error: Unable to fetch total game count.

2007-01-18 05:08

I try it but it not same this http://www.ruspravo.net/go/arcade.php

??

2007-01-16 14:18

http://www.somb.org/punbb/zip/arcade.zip

I can't download ............

????

2006-12-03 03:21

[Requests] Show recent posts ([category] [Name Topic] [By ?] [Time])

Ex.

[Show off] BlaBlaBlafsdfsdf By FruitCake 12.00
[Troubleshooting] BlaBlaBlaf By FruitCake 11.00
[Feature requests] BlaBlaBla By FruitCake 10.00

2006-11-24 13:23

Pekz0r wrote:

I would like to see who made tha latest post too
I want a table like this:
Topic 1 <time> by <nick>
Topic 2 <time> by <nick>
Topic 3 <time> by <nick>
For example:
test topic 19:30:45 by pekz0r
I gues it shouldn't be too hard to fix, i'm giving it a try myself
The best would probably be to edit the extern.php and not this script

I need too

[category] Topic1 by <nick> <time>
[category] Topic2 by <nick> <time>
[category] Topic3 by <nick> <time>

ex.

[Test forum] Test post by FruitCake [20:36:35]

2006-11-22 15:22

very nice

thank thank you

2006-11-22 15:20

thank work !

$text = str_replace('[name]', $pun_user['username'], $text);

your code have "i" in "str_ireplace"

thank thank

2006-11-22 15:02

strange ? :):)

2006-11-22 15:01

thank you for reply

I make new page

<?php
 
define('PUN_ROOT', './');
require PUN_ROOT.'include/common.php';

//query info out of the DB
$result = $db->query("SELECT id, title, content FROM ".$db_prefix."pages WHERE id='".intval($_GET['id'])."'") or error('Unable to fetch page information', __FILE__, __LINE__, $db->error());
if (!$db->num_rows($result))
    message($lang_common['Bad request']);
    
$data = $db->fetch_assoc($result);

//Set the page title here
$page_title = pun_htmlspecialchars($pun_config['o_board_title']) . ' / '. $data['title'];
define('PUN_ALLOW_INDEX', 1);
require PUN_ROOT.'header.php';

//replace custom bbcode
$pattern = array('#\n\[page_title=([^\[]*?)\]#s',
                 '#\n\[page_break\]#s');
$replace = array("\n\t\t".'</div>'."\n\t".'</div>'."\n".'</div>'."\n".'<div class="block">'."\n\t".'<h2><span>$1</span></h2>'."\n\t".'<div class="box">'."\n\t\t".'<div class="inbox">',
                 "\n\t\t".'</div>'."\n\t".'</div>'."\n".'</div>'."\n".'<div class="block">'."\n\t".'<div class="box">'."\n\t\t".'<div class="inbox">');
                 
$content = preg_replace($pattern, $replace, $data['content']);

?>
<div class="block">
    <h2><span>Top 20 Rated Topic</span></h2>
    <div class="box">
        <div class="inbox">
<!--==================-->
<!--Start Page Content-->
<?php
$result = $db->query("SELECT id, subject, rating FROM ".$db->prefix."topics ORDER BY rating DESC LIMIT 0,20");
while($row = $db->fetch_assoc($result))
{
echo '<a href="viewtopic.php?id='.$row['id'].'">'.$row['subject']." ( ".$row['rating']." )</a><br />\n";
}
?>
<!-- End Page Content -->
<!--==================-->
        </div>
    </div>
</div>
<?php
require PUN_ROOT.'footer.php';

name : top20.php

and I come in that page it show

Info

Bad request. The link you followed is incorrect or outdated.

Go back

how to make page

sorry my bad english sorry sorry

2006-11-22 14:12

[requests] show name tag

tag like this

[name]

when use this tag it show username

ex.

Hello [name]

Member Name is : Peter

come in this topic it show

Hello Peter

Member Name is : Admin

come in this topic it show

Hello Admin

sorry my bad english sorry sorry

2006-11-22 14:07

my idea
can make page for show top 20 rating topic

ex.

topic1 ( Topic rating: 98 )
topic2 ( Topic rating: 2 )
topic3 ( Topic rating: 78 )
asdasd ( Topic rating: 0 )
blablabla ( Topic rating: 35 )
.....
.....

and come to top rating page show top rating

topic1 ( Topic rating: 98 )
topic3 ( Topic rating: 78 )
blablabla ( Topic rating: 35 )
topic2 ( Topic rating: 2 )
....
....
.... 20 topic

can make ?

very thank you for nice mod

sorry my bad english sorry sorry

2006-11-22 14:06

can you make it to show who online in chatbox

see my pic

sorry my bad english sorry sorry

Search options (Page 2 of 3)

Posts found: 26 to 50 of 61

26 Topic by FruitCake 2007-03-17 06:07

Topic: [Bug] in tag [hide] (0 replies, posted in PunBB 1.2 modifications, plugins and integrations)

27 Topic by FruitCake 2007-03-17 05:01

Topic: [requests] Admin Note (2 replies, posted in PunBB 1.2 modifications, plugins and integrations)

28 Reply by FruitCake 2007-03-16 13:22

Re: [Mod] Topic Preview (13 replies, posted in PunBB 1.2 modifications, plugins and integrations)

29 Topic by FruitCake 2007-02-04 13:23

Topic: how to show that ? (2 replies, posted in General discussion)

30 Reply by FruitCake 2007-01-24 14:11

Re: how to change board description text color ? (4 replies, posted in PunBB 1.2 discussion)

31 Reply by FruitCake 2007-01-24 12:59

Re: how to change board description text color ? (4 replies, posted in PunBB 1.2 discussion)

32 Topic by FruitCake 2007-01-23 14:06

Topic: how to change board description text color ? (4 replies, posted in PunBB 1.2 discussion)

33 Reply by FruitCake 2007-01-23 09:58

Re: My Mod Arcade beta 1 (239 replies, posted in PunBB 1.2 modifications, plugins and integrations)

34 Reply by FruitCake 2007-01-21 13:54

Re: My Mod Arcade beta 1 (239 replies, posted in PunBB 1.2 modifications, plugins and integrations)

35 Reply by FruitCake 2007-01-21 13:38

Re: My Mod Arcade beta 1 (239 replies, posted in PunBB 1.2 modifications, plugins and integrations)

36 Reply by FruitCake 2007-01-21 13:23

Re: My Mod Arcade beta 1 (239 replies, posted in PunBB 1.2 modifications, plugins and integrations)

37 Reply by FruitCake 2007-01-20 16:41

Re: My Mod Arcade beta 1 (239 replies, posted in PunBB 1.2 modifications, plugins and integrations)

38 Reply by FruitCake 2007-01-20 15:45

Re: My Mod Arcade beta 1 (239 replies, posted in PunBB 1.2 modifications, plugins and integrations)

39 Reply by FruitCake 2007-01-19 12:51

Re: My Mod Arcade beta 1 (239 replies, posted in PunBB 1.2 modifications, plugins and integrations)

40 Reply by FruitCake 2007-01-18 05:08

Re: My Mod Arcade beta 1 (239 replies, posted in PunBB 1.2 modifications, plugins and integrations)

41 Reply by FruitCake 2007-01-16 14:18

Re: My Mod Arcade beta 1 (239 replies, posted in PunBB 1.2 modifications, plugins and integrations)

42 Topic by FruitCake 2006-12-03 03:21

Topic: [Requests] Show recent posts ([category] [Name Topic] [By ?] [Time]) (1 replies, posted in Feature requests)

43 Reply by FruitCake 2006-11-24 13:23

Re: AJAX meets extern.php: Active topics etc. (41 replies, posted in PunBB 1.2 modifications, plugins and integrations)

44 Reply by FruitCake 2006-11-22 15:22

Re: Topic Rating 1.2 (21 replies, posted in PunBB 1.2 modifications, plugins and integrations)

45 Reply by FruitCake 2006-11-22 15:20

Re: [requests] show name tag :) (7 replies, posted in PunBB 1.2 modifications, plugins and integrations)

46 Reply by FruitCake 2006-11-22 15:02

Re: [requests] show name tag :) (7 replies, posted in PunBB 1.2 modifications, plugins and integrations)

47 Reply by FruitCake 2006-11-22 15:01

Re: Topic Rating 1.2 (21 replies, posted in PunBB 1.2 modifications, plugins and integrations)

48 Topic by FruitCake 2006-11-22 14:12

Topic: [requests] show name tag :) (7 replies, posted in PunBB 1.2 modifications, plugins and integrations)

49 Reply by FruitCake 2006-11-22 14:07

Re: Topic Rating 1.2 (21 replies, posted in PunBB 1.2 modifications, plugins and integrations)

50 Reply by FruitCake 2006-11-22 14:06

Re: OLD TOPIC TO DELETE (65 replies, posted in PunBB 1.2 modifications, plugins and integrations)

Posts found: 26 to 50 of 61