176 Reply by ango

  • ango
  • Senior Member
  • Offline
  • From: Germany
  • Registered: 2006-03-07
  • Posts: 103

Re: My Mod Arcade beta 1

Cia,
please post the access error message.

My PunBB Arcade Mod & Game Packs 1-9 (update 01-06-2007):
Test and download here !

177 Reply by dharmil

  • Registered: 2006-03-15
  • Posts: 100

Re: My Mod Arcade beta 1

i tihnk it could be all the images it loaded from the games maby

http://www.dharmil.info/ - My site

http://www.yourarcadesite.1.vg/ - My Arcade, Play 250 games online for free and Save your high score!

http://www.forums.dharmil.info/ - My forums i created using php/mysql still working on them about 15% or more done

178 Reply by Cia

  • Cia
  • Member
  • Offline
  • Registered: 2006-05-25
  • Posts: 19

Re: My Mod Arcade beta 1

Sometimes it hangs so long it comes up with a 'Cannot find server' error (the forums load instantly however). The error that comes up is:

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

The arcade url is http://www.perfectdefect.com/forum/arcade.php

Thanks

179 Reply by Cia

  • Cia
  • Member
  • Offline
  • Registered: 2006-05-25
  • Posts: 19

Re: My Mod Arcade beta 1

The games themselves appear to load fine if you go directly to their URL (eg http://www.perfectdefect.com/forum/arca … .php?id=10)

It's only when trying to access arcade.php that the hanging occurs. About 50% of the time it works, and the rest it gives the errors above.

180 Reply by Cia

  • Cia
  • Member
  • Offline
  • Registered: 2006-05-25
  • Posts: 19

Re: My Mod Arcade beta 1

I've switched back to the original arcade.php as the updated arcade.php code appears to have been causing the problem with the script timing out. A shame because I like the look of the new code much more.


dharmil wrote:

Hrer Are the FIles
Arcade.php

<?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']);

181 Reply by ango

  • ango
  • Senior Member
  • Offline
  • From: Germany
  • Registered: 2006-03-07
  • Posts: 103

Re: My Mod Arcade beta 1

Cia wrote:

Sometimes it hangs so long it comes up with a 'Cannot find server' error (the forums load instantly however). The error that comes up is:

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

The arcade url is http://www.perfectdefect.com/forum/arcade.php

Thanks

As the message says its a server problem.
I´ve visit your forum, all is working fine.

My PunBB Arcade Mod & Game Packs 1-9 (update 01-06-2007):
Test and download here !

182 Reply by Cia

  • Cia
  • Member
  • Offline
  • Registered: 2006-05-25
  • Posts: 19

Re: My Mod Arcade beta 1

ango wrote:
Cia wrote:

Sometimes it hangs so long it comes up with a 'Cannot find server' error (the forums load instantly however). The error that comes up is:

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

The arcade url is http://www.perfectdefect.com/forum/arcade.php

Thanks

As the message says its a server problem.
I´ve visit your forum, all is working fine.

That's because i'm not using dharmils modified arcade.php now. If I switch back to it the errors come back.

I'm going to see if I can find the problem inside the code.

183 Reply by dharmil

  • Registered: 2006-03-15
  • Posts: 100

Re: My Mod Arcade beta 1

well my arcade code i didnt edit the php at all all i did was add ahtml so it looks diffrent so there is no diffrence in php and mysql..

http://www.dharmil.info/ - My site

http://www.yourarcadesite.1.vg/ - My Arcade, Play 250 games online for free and Save your high score!

http://www.forums.dharmil.info/ - My forums i created using php/mysql still working on them about 15% or more done

184 Reply by enoup

  • enoup
  • Junior Member
  • Offline
  • Registered: 2006-06-03
  • Posts: 2

Re: My Mod Arcade beta 1

Cia,

You don't post how you fix your problem about the incrementation of the number of played games. I have the same and don't know how to fix it tongue

can you help please
thx

185 Reply by enoup

  • enoup
  • Junior Member
  • Offline
  • Registered: 2006-06-03
  • Posts: 2

Re: My Mod Arcade beta 1

ok i have fixed it by change in the arcade_play.php (seen trick in page 3 of this post) :

thank you Ango for this and this fabulous mod. Tell me if it is an error to do this modification like this.

found : 

$line = $db->fetch_assoc($result);
if ($line['game_id'] <= 0)
    message($lang_common['Bad request']);

replaced by :

if(mysql_num_rows($result) <= 0)
    message($lang_common['Bad request']);
$line = $db->fetch_assoc($result);

all is working !!:D

186 Reply by Cia

  • Cia
  • Member
  • Offline
  • Registered: 2006-05-25
  • Posts: 19

Re: My Mod Arcade beta 1

This mod is great, sadly the high scores are 'hacked' daily on my forum by people who have made high score submit scripts. Anyone got a quick fix for this? thanks smile

187 Reply by Cia

  • Cia
  • Member
  • Offline
  • Registered: 2006-05-25
  • Posts: 19

Re: My Mod Arcade beta 1

enoup wrote:

Cia,

You don't post how you fix your problem about the incrementation of the number of played games. I have the same and don't know how to fix it tongue

can you help please
thx

Wish I knew, I actually found out its because the first game is counted as a zero... guess I should have played more than once before posting - sorry!

188 Reply by ango

  • ango
  • Senior Member
  • Offline
  • From: Germany
  • Registered: 2006-03-07
  • Posts: 103

Re: My Mod Arcade beta 1

Did you use my mod?

My PunBB Arcade Mod & Game Packs 1-9 (update 01-06-2007):
Test and download here !

189 Reply by dharmil

  • Registered: 2006-03-15
  • Posts: 100

Re: My Mod Arcade beta 1

Cia wrote:

This mod is great, sadly the high scores are 'hacked' daily on my forum by people who have made high score submit scripts. Anyone got a quick fix for this? thanks smile

the only thing you could do is maby ad a image varifiction thing but thats a lot of coding and whe you submit the highscore it will kinda be anoying

http://www.dharmil.info/ - My site

http://www.yourarcadesite.1.vg/ - My Arcade, Play 250 games online for free and Save your high score!

http://www.forums.dharmil.info/ - My forums i created using php/mysql still working on them about 15% or more done

190 Reply by Shizzled

  • Registered: 2006-05-11
  • Posts: 23

Re: My Mod Arcade beta 1

i'v looked all over for a 'Url Action Editor' and have been unseuccesful sad is paying $50 really the only way?

I would just download your game packs but rapidshare is a bitch sad i have never been able to dl from there.

191 Reply by ango

  • ango
  • Senior Member
  • Offline
  • From: Germany
  • Registered: 2006-03-07
  • Posts: 103

Re: My Mod Arcade beta 1

Shizzled wrote:

i'v looked all over for a 'Url Action Editor' and have been unseuccesful sad is paying $50 really the only way?

I would just download your game packs but rapidshare is a bitch sad i have never been able to dl from there.

Ok, I make some mirrors ...

My PunBB Arcade Mod & Game Packs 1-9 (update 01-06-2007):
Test and download here !

192 Reply by Shizzled

  • Registered: 2006-05-11
  • Posts: 23

Re: My Mod Arcade beta 1

Thank you very much.

And i apologize for not mentioning any Thank you's in my previous post roll
Thanks to Everyone who has put their effort into making this great mod tongue

193 Reply by ango

  • ango
  • Senior Member
  • Offline
  • From: Germany
  • Registered: 2006-03-07
  • Posts: 103

Re: My Mod Arcade beta 1

Added Game Pack 6!  :-)

... have fun

My PunBB Arcade Mod & Game Packs 1-9 (update 01-06-2007):
Test and download here !

194 Reply by Shizzled

  • Registered: 2006-05-11
  • Posts: 23

Re: My Mod Arcade beta 1

I have just installed the arcade_1_1 on a new forum. And just like my previous installations everything seem to go fine. But when clicking to play a game i get this:

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

Go back

and this above the page header

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/rickies/public_html/arcade_play.php on line 26

Here is that section of arcade_play.php

$result = $db->query('SELECT shortname, name, description, img_ext FROM '.$db->prefix.'arcade_games WHERE shortname = "'.$shortname.'"') or error('Unable to fetch games', __FILE__, __LINE__, $db->error());
if(mysql_num_rows($result) <= 0)
    message($lang_common['Bad request']);
$line = $db->fetch_assoc($result);

Any help is appreciated. Thank you.

195 Reply by cheuvlu

  • Registered: 2006-04-27
  • Posts: 4

Re: My Mod Arcade beta 1

is it possible to associate mod cash and arcade , in order to pay for playing the game or to enter in arcade room ?

sorry for my bad english

est-il possible d'associer les mods cash et arcade. Pour faire que les membres "payent" l'entré dans la salle de jeux ?

196 Reply by ango

  • ango
  • Senior Member
  • Offline
  • From: Germany
  • Registered: 2006-03-07
  • Posts: 103

Re: My Mod Arcade beta 1

Shizzled,
it looks like you have installed PANDARK´s arcade mod ,

Nico´s, DHARMIL and my mod are different! I´ve made all games addon packs compatible to DHARMIL and my mod.
Just try our mod.

My PunBB Arcade Mod & Game Packs 1-9 (update 01-06-2007):
Test and download here !

197 Reply by Shizzled

  • Registered: 2006-05-11
  • Posts: 23

Re: My Mod Arcade beta 1

Ango do you use msn or any other messenger programe?

I really need some help with setting up this mod. Please can you assist me smile
Rick@shizzled.com -Msn. TY.

198 Reply by ango

  • ango
  • Senior Member
  • Offline
  • From: Germany
  • Registered: 2006-03-07
  • Posts: 103

Re: My Mod Arcade beta 1

Shizzled wrote:

Ango do you use msn or any other messenger programe?

I really need some help with setting up this mod. Please can you assist me smile
Rick@shizzled.com -Msn. TY.

you have mail  :-)

My PunBB Arcade Mod & Game Packs 1-9 (update 01-06-2007):
Test and download here !

199 Reply by Shizzled (edited by Shizzled 2006-07-19 19:42)

  • Registered: 2006-05-11
  • Posts: 23

Re: My Mod Arcade beta 1

I have converted a few games and compiled a little pack, the pack contains the following 8 games:

Cannon   
Copter   
Cat   
Drop Blox   
Highway Hunter   
Hulk Smash   
SnowBall Warrior   
HangMan   

http://www.upit.be/download.php?id=2518

And also tyvm Ango for all your help smile

200 Reply by ango

  • ango
  • Senior Member
  • Offline
  • From: Germany
  • Registered: 2006-03-07
  • Posts: 103

Re: My Mod Arcade beta 1

Game Pack 7 added. :-)

I´ve also updated my mod.
- added mini thumbs for "new games" and "most played" games
- added on/off for the statistic block (Javascript must be enabled!)
- added newest user score
- added user top highscore table (more statistics in the next update)
  (click on the user link in the main arcade page of each player to see his top highscores)
- optical improvements
- fix for MySQL 4

... have fun

My PunBB Arcade Mod & Game Packs 1-9 (update 01-06-2007):
Test and download here !