vb.org Archive
Page 94 of 138 « First 44849293 94 9596104 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=5)
-   -   vbProArcade v1.0 Flash Games Development (https://vborg.vbsupport.ru/showthread.php?t=47198)

Link14716 04-26-2003 03:41 PM
Hence why I am not adding any more games until I get the queries down. ;)

DigitalDesktops 04-26-2003 03:44 PM
i have 88 queries on my arcade page. ;)

if i change this:

PHP Code:
      $miniboard_q = $DB_site->query("SELECT * FROM arcadescores WHERE game='$gamename' AND valid=1 ORDER BY score DESC LIMIT 5"); 
to this:

PHP Code:
      $miniboard_q = $DB_site->query("SELECT * FROM arcadescores WHERE game='$gamename' AND valid=1 ORDER BY score DESC LIMIT 3"); 
will that lower the number of queries on the arcade?

gwhooooey 04-26-2003 04:26 PM
Hehe, isn't it nudge, not nadge

joecool 04-26-2003 05:02 PM
People, Why not use the sulution that Erwin came up with to get the queries down to 16? (doesn't matter howe many games you add, it will still be 16) I use that on my board together with around 100 games :D

Having over 100 queries doesn't sound like a good idea to me anyway o_O

Jakor Sevel 04-26-2003 05:04 PM
slotx works great! Great job. And thanks to joe for updating the first post.

gwhooooey 04-26-2003 05:09 PM
Quote:
Today at 07:02 PM joecool said this in Post #934
People, Why not use the sulution that Erwin came up with to get the queries down to 16? (doesn't matter howe many games you add, it will still be 16) I use that on my board together with around 100 games :D

Having over 100 queries doesn't sound like a good idea to me anyway o_O
Can you explain how to do that, please?

joecool 04-26-2003 06:03 PM
Quote:
Today at 02:09 PM gwhooooey said this in Post #936
Can you explain how to do that, please?

1) Replace you're proarcade.php file with this one
2) Go into you're AdminCP
3) Go down to Templates/Modify
4) Edit thease templates:

vbproarcade_arcade

PHP Code:
{htmldoctype} 
<html>

<head>
<title>$bbtitle - Arcade</title>
$headinclude
</head>

<body>
$header 

$navbar

<br>

<table cellpadding="{tableouterborderwidth}" cellspacing="0" border="0" bgcolor="{tablebordercolor}" {tableouterextra} width="{contenttablewidth}" align="center">
<tr>
 <td>
  <table cellpadding="4" cellspacing="{tableinnerborderwidth}" border="0" {tableinnerextra} width="100%">
  <tr> 
   <td bgcolor="{categorybackcolor}" align="center">
    <normalfont color="{categoryfontcolor}">
    <b>$bbtitle Arcade</b>
    </normalfont>
    </td>
   </tr>
   <tr>
    <td bgcolor="{firstaltcolor}" align="center" valign="center">

     <!-- begin scoreboard -->
     <table cellpadding=10 cellspacing=0 border=0 width="100%">
     <tr>
      <td width="100%" align="center">

      <table cellpadding="4" cellspacing="1" border="0" bgcolor="{tablebordercolor}" width="100%">
      <tr> 
       <td width=150 bgcolor="{tableheadbgcolor}" align="center">
        <normalfont color="{tableheadtextcolor}">
        <b>Game</b>
        </normalfont>
       </td>
       <td bgcolor="{tableheadbgcolor}" align="center">
        <normalfont color="{tableheadtextcolor}">
        <b>Description</b>
        </normalfont>
       </td>
      </tr>
      $arcadebits
      </table>
     </td>
    </tr>
    </table>
    <!-- end scoreboard -->

    <table cellpadding="10" cellspacing="0" border="0" width="100%">
    $gamescores
    </table>

    </td>
   </tr>
  <tr> 
   <td bgcolor="{categorybackcolor}" align="center">
    <normalfont color="{timecolor}">
    </normalfont>
    </td>
   </tr>
   </table>
  </td>
 </tr>
</table>

$footer 

</body>
</html> 
vbproarcade_arcadebit

PHP Code:
      <tr> 
       <td width=150 bgcolor="{secondaltcolor}" align="center">
        $gamelink
       </td>
       <td bgcolor="{secondaltcolor}" align="center">
        $gamedescription
       </td>
      </tr> 
Done!

joecool 04-26-2003 06:19 PM
Quote:
Today at 12:35 PM NuclioN said this in Post #930
SlotX fruitmachine. Random hold and shuffle untill you score trough the roof. Hit it. :p
The submit button is not there after every time, it would be nice to be able to submit you're score whenever you want ;)

Nice game tho, i'ts a winner :)

NuclioN 04-26-2003 06:25 PM
Thx joecool. :) The submit score button must stay visible all the time. Here it does. I've test it but i can't see it disappear.

gwhooooey 04-26-2003 06:50 PM
Quote:
Today at 08:03 PM joecool said this in Post #937
1) Replace you're proarcade.php file with this one
2) Go into you're AdminCP
3) Go down to Templates/Modify
4) Edit:

vbproarcade_arcade (remove all usless stuff thats not needed anymore)
vbproarcade_arcadebit (remove all usless stuff thats not needed anymore)

Done!
Thanks, what's the useless stuff that I need to remove though? :smoke:


All times are GMT. The time now is 09:31 AM.
Page 94 of 138 « First 44849293 94 9596104 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03234 seconds
  • Memory Usage 1,776KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete