Page 2 of 4

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 08:36
by Solidjeuh
yes i did..

// Recent Active Topics
if (isset($config['tsrat_enable']) && $config['tsrat_enable'] == 1)
{
if (!isset($flist)){
$flist = array(0);}

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 08:38
by Stoker
Which version of phpbb are you using?

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 08:39
by Solidjeuh
Stoker wrote:Which version of phpbb are you using?
phpbb 3.0.8

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 08:50
by Solidjeuh
Also those buttons are not working.. when i click on play or stop or those 2 other
the forum just scrolls to top .. lol
Maybe the problem is in my overal_header?

Code: Select all

            <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
            <html xmlns="http://www.w3.org/1999/xhtml" dir="{S_CONTENT_DIRECTION}" lang="{S_USER_LANG}" xml:lang="{S_USER_LANG}">

            <head>
           
            <link rel="shortcut icon" href='http://www.presents4you.net/images/icon.ico' />
            <meta name="robots" content="noindex, nofollow" />
            <meta http-equiv="content-type" content="text/html; charset={S_CONTENT_ENCODING}" />
            <meta http-equiv="content-style-type" content="text/css" />
            <meta http-equiv="content-language" content="{S_USER_LANG}" />
            <meta http-equiv="imagetoolbar" content="no" />
            <meta name="resource-type" content="document" />
            <meta name="distribution" content="global" />
            <meta name="copyright" content="2000, 2002, 2005, 2007 phpBB Group, 2007 - 2010 Marc Alexander" />
            <meta name="keywords" content="" />
            <meta name="description" content="" />
            <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7; IE=EmulateIE9" />
            <!-- IF S_ARCADE_FACEBOOK -->
            <meta property="og:url"         content="{U_GAME_PLAY}" />
            <meta property="og:title"       content="{GAME_NAME_FLASH_GAME}"/>
            <!-- IF GAME_IMAGE -->
            <meta property="og:image"       content="{GAME_IMAGE}"/>
            <!-- ENDIF -->
            <meta property="og:site_name"   content="{SITENAME}"/>
            <meta property="og:description" content="{SITE_DESCRIPTION}"/>
            <!-- ENDIF -->
            {META}
            <title>&bull; {SITENAME} &bull;  {PAGE_TITLE}</title>

            <!-- MOD : MSSTI RSS Feeds (V1.2.1) - Start //-->
            <!-- IF S_FEEDS -->
            <link rel="alternate" type="application/rss+xml" title="{L_RSS_FEEDS} - {SITENAME}" href="{U_RSS}" />
            <!-- IF U_FEEDS_NEWS --><link rel="alternate" type="application/rss+xml" title="{L_RSS_FEEDS} - {L_RSS_NEWS}" href="{U_FEEDS_NEWS}" /><!-- ENDIF -->
            <!-- ENDIF -->
            <!-- MOD : MSSTI RSS Feeds (V1.2.1) - End //-->

            <!-- IF S_ERROR_PAGE -->
            <base href="{U_FORUM_BASE}" />
            <!-- ENDIF -->
            <!-- IF S_ENABLE_FEEDS -->
               <!-- IF S_ENABLE_FEEDS_OVERALL --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {SITENAME}" href="{U_FEED}" /><!-- ENDIF -->
               <!-- IF S_ENABLE_FEEDS_NEWS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FEED_NEWS}" href="{U_FEED}?mode=news" /><!-- ENDIF -->
               <!-- IF S_ENABLE_FEEDS_FORUMS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_ALL_FORUMS}" href="{U_FEED}?mode=forums" /><!-- ENDIF -->
               <!-- IF S_ENABLE_FEEDS_TOPICS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FEED_TOPICS_NEW}" href="{U_FEED}?mode=topics" /><!-- ENDIF -->
               <!-- IF S_ENABLE_FEEDS_TOPICS_ACTIVE --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FEED_TOPICS_ACTIVE}" href="{U_FEED}?mode=topics_active" /><!-- ENDIF -->
               <!-- IF S_ENABLE_FEEDS_FORUM and S_FORUM_ID --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FORUM} - {FORUM_NAME}" href="{U_FEED}?f={S_FORUM_ID}" /><!-- ENDIF -->
               <!-- IF S_ENABLE_FEEDS_TOPIC and S_TOPIC_ID --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_TOPIC} - {TOPIC_TITLE}" href="{U_FEED}?f={S_FORUM_ID}&t={S_TOPIC_ID}" /><!-- ENDIF -->
            <!-- ENDIF -->

            <!--
               phpBB style name: proFormell
               Based on style:   prosilver
               Inspired by:     Formell (Joomla Style)
               Original author:  Tom Beddard ( http://www.subBlue.com/ )
               Modified by:       Marc Alexander
               
               NOTE: This page was generated by phpBB, the free open-source bulletin board package.
                     The phpBB Group is not responsible for the content of this page and forum. For more information
                     about phpBB please visit http://www.phpbb.com
            -->

            <script type="text/javascript">
            // <![CDATA[
               var jump_page = '{LA_JUMP_PAGE}:';
               var on_page = '{ON_PAGE}';
               var per_page = '{PER_PAGE}';
               var base_url = '{A_BASE_URL}';
               var style_cookie = 'phpBBstyle';
               var style_cookie_settings = '{A_COOKIE_SETTINGS}';
               var onload_functions = new Array();
               var onunload_functions = new Array();
               var is_ie6 = false;

                  window.onbeforeunload = loader;

       onunload_functions.push('loader()');

       function loader()
       {
          var l = document.getElementById('loader');
          if (l)
          {
             l.style.display = 'block';
          }            
       }
			   /**
               * Find a member
               */
               function find_username(url)
               {
                  popup(url, 760, 570, '_usersearch');
                  return false;
               }

               /**
               * New function for handling multiple calls to window.onload and window.unload by pentapenguin
               */
               window.onload = function()
               {
                  for (var i = 0; i < onload_functions.length; i++)
                  {
                     eval(onload_functions[i]);
                  }
               }

               window.onunload = function()
               {
                  for (var i = 0; i < onunload_functions.length; i++)
                  {
                     eval(onunload_functions[i]);
                  }
               }

            // ]]>
            </script>
            <!--[if lt IE 7]>
            <script type="text/javascript">
            // <![CDATA[
            var is_ie6 = true;
            // ]]>
            </script>
            <![endif]-->
            <!-- INCLUDE mods/reimg_content.html -->
            <!-- IF U_PRINT_TOPIC -->

            <link href="{T_THEME_PATH}/print.css" rel="stylesheet" type="text/css" media="print" title="printonly" />
            <!-- ENDIF -->
            <link href="{T_STYLESHEET_LINK}" rel="stylesheet" type="text/css" media="screen, projection" />

            <!-- IF S_CONTENT_DIRECTION eq 'rtl' -->
               <link href="{T_THEME_PATH}/bidi.css" rel="stylesheet" type="text/css" media="screen, projection" />
            <!-- ENDIF -->
            <!-- IF S_IN_ARCADE -->
               <link href="{T_THEME_PATH}/arcade.css" rel="stylesheet" type="text/css" media="screen, projection" />
            <!-- ENDIF -->
    
    <!-- Start Highslide -->
    <script type="text/javascript" src="{ROOT_PATH}highslide/highslide-full.js"></script>
    <link rel="stylesheet" href="{ROOT_PATH}highslide/highslide.css" type="text/css" />
    <!-- End Highslide -->

    <!-- YOUTUBE VIDEOS MOD BEGIN -->
    <script type="text/javascript" src="youtube/swfobject.js"></script>
    <script type="text/javascript" src="youtube/quvic.js"></script>
    <script type="text/javascript" src="youtube/jquery.js"></script>
    <link href="youtube/quvic.css" type="text/css" rel="stylesheet"/>
    <!-- YOUTUBE VIDEOS MOD END -->
    <script type="text/javascript">
    function brokenImage(img)
    {
        img.src='{ROOT_PATH}images/notfound.png';
    }
    </script>
    <script type="text/javascript" src="{T_TEMPLATE_PATH}/forum_fn.js"></script>
    <!-- IF (S_TSRAT_ENABLE and S_TS_JSSCROLL) or (S_TSRAT_ENABLE and S_TS_TICKER) -->

<!-- IF S_TS_JSSCROLL and not S_TS_TICKER -->
<script src="{ROOT_PATH}script/jquery.totemticker.min.js" type="text/javascript"></script>
<script type="text/javascript">
// <![CDATA[
$(document).ready(function() {
	$('#vertical-ticker').totemticker({
				row_height	:	'41px',
				max_items   :   3,
				speed       :   {JSSCROLL_SPEED},
				interval    :   {JSSCROLL_INTERVAL},
				<!-- IF TS_JSSCROLL_NAVIGATION -->
				next		:	'#ticker-next',
				previous	:	'#ticker-previous',
				stop		:	'#stop',
				start		:	'#start',
				<!-- ENDIF -->
				mousestop	:	true,
				direction	:	'<!-- IF TS_JSSCROLL_DIRECTION -->down<!-- ELSE -->up<!-- ENDIF -->'
	});
});
// ]]>
</script>
<!-- ELSEIF S_TS_TICKER and not S_TS_JSSCROLL -->
<script src="{ROOT_PATH}script/jquery.newsticker.js" type="text/javascript"></script>
<script type="text/javascript">
// <![CDATA[
$(document).ready(function() {
	$("#news").newsTicker();
});
// ]]>
</script>
<!-- ENDIF -->
<!-- ENDIF -->
    <script src="{ROOT_PATH}script/reflection.js" type="text/javascript"></script>

    <script type="text/javascript">
    // <![CDATA[
            /**
            * New pop-up functions
            * based on  http://yensdesign.com/2008/09/how-to-create-a-stunning-and-smooth-popup-using-jquery/
            */

            //SETTING UP OUR POPUP
            //0 means disabled; 1 means enabled;
            var popupStatus = 0;
            var openPopup = '';

            //loading popup with jQuery magic!
            function loadPopup()

            {
               //loads popup only if it is disabled
               if(popupStatus==0)
               {
                  $('#backgroundPopup').css({'opacity': '0.7'});
                  // Now let's make sure we actually see the image
                  var scroll = $(window).scrollTop();
                  $('#popupPM').animate({marginTop: scroll}, 'fast', function() {
                     // Animation complete.
                     });
                  $('#backgroundPopup').fadeIn('slow');
                  $('#popupPM').fadeIn('slow');
                  popupStatus = 1;
                  openPopup = 'PM';
               }
            }

            //disabling popup with jQuery magic!
            function disablePopup()
            {
               //disables popup only if it is enabled
               if(popupStatus==1 && openPopup == 'PM')
               {
                  $('#backgroundPopup').fadeOut('slow');
                  $('#popupPM').fadeOut('slow');
                  popupStatus = 0;
                  openPopup = '';
               }
            }

            //centering popup
            function centerPopup()
            {
               //request data for centering
               var windowWidth = document.documentElement.clientWidth;
               var windowHeight = document.documentElement.clientHeight;
               var popupHeight = $('#popupPM').height();
               var popupWidth = $('#popupPM').width();
               //centering
               $('#popupPM').css({
               'position': 'absolute',
               'top': windowHeight/2-popupHeight/2,
               'left': windowWidth/2-popupWidth/2
               });
               //only need force for IE6
               $('#backgroundPopup').css({'height': windowHeight});
            }

            $(document).ready(function(){
               <!-- IF S_USER_PM_POPUP -->   
               if({S_NEW_PM})
               {
                  //centering with css
                  centerPopup();
                  //load popup
                  loadPopup();
               }
               <!-- ENDIF -->
               <!-- IF S_VIEWTOPIC -->
               resize_images();
               <!-- ENDIF -->
               
               // IE6 and below PNG fix (not really)
               if(is_ie6)
               {
                  replace_png();
               }
               
               //CLOSING POPUP
               //Click the x event!
               $('#popupPMClose').click(function(){
                  disablePopup();
               });
               //Click out event!
               $('#backgroundPopup').click(function(){
                  disablePopup();
                  disableImage();
               });
               //Press Escape event!
               $(document).keypress(function(e){
                  if(e.keyCode==27 && popupStatus==1)
                  {
                     disablePopup();
                     disableImage();
                  }
               });
               
               <!-- IF S_VIEWTOPIC -->
               // Image popup
               $('img', 'dt.attach-image').click(function(){
                  image_load($(this).attr('src'), $(this).attr('alt'));
                  centerImage();
               });
               
               $('.content img').click(function(){
                  var check = $(this).parent().hasClass('content');
                  if(check)
                  {
                     image_load($(this).attr('src'), $(this).attr('alt'));
                     centerImage();
                  }
               });
               
               // Closing Image popup
               //Click the x event!
               $('#popupImageClose').click(function(){
                  disableImage();
               });
               
               //Click image box event
               $('#popupImage').click(function(){
                  disableImage();
               });
               
               //Click image event
               $('#ImagePopup img').click(function(){
                  disableImage();
               });
               <!-- ENDIF -->

            });

            /**
            * Replaces weird looking PNG files with the respectie GIF file
            * Only run this if the browser is IE6 or below
            */
            function replace_png()
            {
               // Fix Logo
               var str = $('#logo img').attr('src');
               $('#logo img').attr('src', str.substring(0, str.length - 3) + 'gif');
               
               // Fix forum icons
               $('dl.icon').each(function() {
                  var str = $(this).css('background-image');
                  if(str != '')
                  {
                     $(this).css('background-image', str.substring(0, str.length - 5) + 'gif")');
                  }
               });
            }

            <!-- IF S_VIEWTOPIC -->
            /**
            * Image resizer
            */
            function resize_images()
            {
               var hello = $('dl.attachbox dd dl.file dt.attach-image img').innerWidth();
               var maxWidth = $('div.content').innerWidth() - 30;
               
               // resize the attached images
               $('img', 'dt.attach-image').each(function(i){
                  // check the width of the image
                  if ($(this).width() > maxWidth)
                  {
                     // calculate new image dimensions
                     newWidth = maxWidth;
                     newHeight = $(this).height() / ( $(this).width() / maxWidth );
                       
                     // set new image dimensions
                     $(this).height(newHeight).width(newWidth);
                  }
               });
               
               // resize the images that were added via [img] bbcode
               $('img', 'div.content').each(function(i){
                  // check the width of the image
                  $(this).css('max-width', maxWidth); // fix for IE
                  if ($(this).width() > maxWidth)
                  {
                     // calculate new image dimensions
                     newWidth = maxWidth;
                     newHeight = $(this).height() / ( $(this).width() / maxWidth );
                       
                     // set new image dimensions
                     $(this).height(newHeight).width(newWidth);
                  }
               });
            }

            /**
            * Image pop-up
            */
            function image_load(src, alt)
            {
               //loads popup only if it is disabled
               if(popupStatus==0)
               {
                  $('#ImagePopup').html('<img id="imgpopup" src="' + src + '" alt="' + alt + '" />');
                  var windowWidth = document.documentElement.clientWidth;
                  var windowHeight = document.documentElement.clientHeight;
                  var maxWidth = windowWidth * 0.85;
                  var maxHeight = windowHeight * 0.85;
                  $('#popupImage img').css('max-width', maxWidth);
                  $('#popupImage img').css('max-height', maxHeight);
                  $('#backgroundPopup').css({'opacity': '0.7'});
                  // Now let's make sure we actually see the image
                  var scroll = $(window).scrollTop();
                  $('#popupImage').animate({marginTop: scroll}, 'fast', function() {
                     // Animation complete.
                     });
                  $('#backgroundPopup').fadeIn('slow');
                  $('#popupImage').fadeIn('slow');
                  popupStatus = 1;
                  openPopup = 'Image';
               }
            }

            //centering popup
            function centerImage()
            {
               //request data for centering
               var windowWidth = document.documentElement.clientWidth;
               var windowHeight = document.documentElement.clientHeight;
               var popupHeight = $('#popupImage').height();
               var popupWidth = $('#popupImage').width();
               var newTop = windowHeight/2-popupHeight/2;
               var newLeft = windowWidth/2-popupWidth/2;
               //centering
               $('#popupImage').css({
               'position': 'absolute',
               'top': newTop,
               'left': newLeft
               });
               
               //only need force for IE6
               $('#backgroundPopup').css({'height': windowHeight});
            }

            //disabling popup with jQuery magic!
            function disableImage()
            {
               //disables popup only if it is enabled
               if(popupStatus==1 && openPopup == 'Image')
               {
                  $('#backgroundPopup').fadeOut('slow');
                  $('#popupImage').fadeOut('slow');
                  popupStatus = 0;
                  openPopup = '';
               }
            }
            <!-- ENDIF -->
    // ]]>

    </script>

	<!-- effortless script below -->
	<script type="text/javascript">
	    jQuery(document).ready(function(){
	        jQuery('#backtotop a').click(function(){
	            jQuery('html, body').animate({scrollTop:0}, 'slow');
	            return false;
	        });
	    });
	</script>
    <script type="text/javascript" src="{T_TEMPLATE_PATH}/move.js"></script>
    <!-- IF S_MCHAT_ENABLE and (S_MCHAT_ON_INDEX or U_MCHAT) -->
    <script type="text/javascript" src="{ROOT_PATH}mchat/jquery-1.5.0.min.js"></script>
    <script type="text/javascript" src="{ROOT_PATH}mchat/jquery.titlealert.min.js"></script>
    <script type="text/javascript" src="{ROOT_PATH}mchat/jquery_cookie_mini.js"></script>
    <!-- ENDIF -->
    <script type="text/javascript" src="src/swfobject.js"></script>

    </head>

            <body id="phpbb" class="section-{SCRIPT_NAME} {S_CONTENT_DIRECTION}">
                <div id="loader">
       <span>Laden van pagina.. Even geduld aub..</span>
    </div>

            <!--- box border START -->
            <div id="box">
            <div class="top-left"></div><div class="top-center"></div><div class="top-right"></div>
            <div id="left-border">
            <div id="right-border">

            <!--- box border END -->
            <div class="inside">
            <div class="notopgap">
            <div id="wrap">
               <a id="top" name="top" accesskey="t"></a>
               <div id="page-header">
                  <div class="headerbar">
                     <div class="inner"><span class="corners-top"><span></span></span>
                            <div class="menu-block" style="float: {S_CONTENT_FLOW_END}; width: 19%;">
                          <!-- IF not S_IS_BOT and S_USER_LOGGED_IN -->
                         <div class="menu-row-first"><a class="left menu-link" href="http://www.presents4you.net/arcade.php">Spelletjes</a></div>
                         <div class="menu-row"><a class="left menu-link" href="http://www.presents4you.net/knuffel.php">yahtzee</a></div>
                         <div class="menu-row"><a class="left menu-link" href="http://www.presents4you.net/youtube.php">Youtube</a></div>
                         <div class="menu-row"><a class="left menu-link" href="{U_SMILIESPAGE}" title="{L_SMSMILIES}">{L_SMSMILIES}</a></div>
                         <div class="menu-row"><a class="left menu-link" href="{U_RANKSPAGE}" title="{L_RARANKS}">{L_RARANKS}</a></div>
                         <!-- ENDIF -->
                         <div class="menu-row-last"><a class="left menu-link" href="{U_LOGIN_LOGOUT}" title="{L_LOGIN_LOGOUT}" accesskey="x">{L_LOGIN_LOGOUT}</a></div>
                      </div>
                      <div style="float: {S_CONTENT_FLOW_BEGIN}; width: 79.5%;">
                     <div style="height: 140px ;">
                     <div id="site-description">
                        <div class="header-pad"><a href="{U_INDEX}" title="{L_INDEX}" id="logo">{SITE_LOGO_IMG}</a></div>
                     
                        <p class="site-desc">{SITE_DESCRIPTION}</p>
                        <p class="skiplink"><a href="#start_here">{L_SKIP}</a></p>
                     </div>

            </div>
                </div>

                     <span class="corners-bottom"><span></span></span></div>
                  </div>

                  <div class="navbar">
                     <div class="inner"><span class="corners-top"><span></span></span>

                     <ul class="linklist navlinks">

                        <li class="icon-home"><a href="{U_INDEX}" accesskey="h">{L_INDEX}</a> <!-- BEGIN navlinks --> <strong>&#8249;</strong> <a href="{navlinks.U_VIEW_FORUM}">{navlinks.FORUM_NAME}</a><!-- END navlinks --></li>
                                  <!-- IF S_DISPLAY_SEARCH and not S_IN_SEARCH -->
                        <li class="rightside">
                        <form action="{U_SEARCH}" method="post" id="search">
                        <fieldset>
            <input name="search_id" id="search_id" type="hidden" value="speedsearch" />
                           <input name="zoekwoorden" id="zoekwoorden" type="text" maxlength="128" title="{L_SEARCH_KEYWORDS}" class="inputbox search" value="<!-- IF SEARCH_WORDS-->{SEARCH_WORDS}<!-- ELSE -->{L_SEARCH_MINI}<!-- ENDIF -->" onclick="if(this.value=='{LA_SEARCH_MINI}')this.value='';" onblur="if(this.value=='')this.value='{LA_SEARCH_MINI}';" />
            <br />
                            {S_SEARCH_HIDDEN_FIELDS}
                        </fieldset>
                        </form>
            </li>
                  <!-- ENDIF -->
                         
                     </ul>

                     <!-- IF not S_IS_BOT and S_USER_LOGGED_IN -->
                     <ul class="linklist leftside">

                        <li class="icon-ucp">
                           [<a href="{U_PROFILE}" title="{L_PROFILE}" accesskey="e">{L_PROFILE}</a>]
                              <!-- IF S_DISPLAY_PM --> [<a href="{U_PRIVATEMSGS}">{PRIVATE_MESSAGE_INFO}</a>]<!-- ENDIF -->
                           <!-- IF U_RESTORE_PERMISSIONS --> &bull;
                           <a href="{U_RESTORE_PERMISSIONS}">{L_RESTORE_PERMISSIONS}</a>
                           <!-- ENDIF -->
                        </li>
                     </ul>
                     <!-- ENDIF -->

    <!-- IF not S_IS_BOT and S_USER_LOGGED_IN -->
    <ul class="linklist rightside">
    <li class="icon-rss"><a href="http://www.solidjeuhforumradio.be/player/index.html" target="_blank" onclick="popup(this.href, 960, 282, 'Ultratop 50 mp3 speler'); return false;"> P4Y Music Player</a></li>
       <!-- Start Ultimate Points -->
       <!-- IF S_POINTS_ENABLE -->
       <li class="icon-faq"><a href="{U_POINTS}" title="{L_POINTS_EXPLAIN}">{POINTS_LINK}<!-- IF S_USER_LOGGED_IN and S_USE_POINTS --> [ {USER_POINTS} ] <!-- ENDIF --></a></li>
       <!-- ENDIF -->
       <!-- End Ultimate Points -->

       <li class="icon-faq"><a href="{U_SHOP}" title="{L_UPS_EASY_SHOP}">{SHOP_LINK}</a></li>
       <!-- IF S_DISPLAY_INVITE -->                                                 
       <li class="icon-faq"><a href="{U_INVITE_A_FRIEND}"><strong>{L_ACP_INVITE}</strong></a></li>
       <!-- ENDIF -->
       <li class="icon-rss"><a class="Donatie" href="http://www.presents4you.net/donate/index.php"><strong><span class="stijl1">Donatie</span></strong></a></li>

       <li class="icon-rss"><a href="{U_NEWSLETTER}" title="{L_NEWSLETTER_EXPLAIN}">{L_NEWSLETTER}</a></li>

       <li class="icon-faq"><a class="Zoeken" href="http://www.presents4you.net/search.php"><span>Zoeken</span></a></li>
       <!-- IF S_DISPLAY_MEMBERLIST --><li class="icon-faq"><a href="{U_MEMBERLIST}" title="{L_MEMBERLIST_EXPLAIN}">{L_MEMBERLIST}</a></li><!-- ENDIF -->
       <!-- IF S_DISPLAY_TOPLIST --><li class="icon-thanks_toplist"><a href="{U_REPUT_TOPLIST}" title="{L_REPUT_TOPLIST}">{L_REPUT_TOPLIST}</a></li><!-- ENDIF -->
       <!-- IF S_DISPLAY_THANKSLIST --><li class="icon-thanks"><a href="{U_THANKSLIST}" title="{L_THANKS_USER}">{L_GRATITUDES}</a></li><!-- ENDIF -->
    </ul>
    <!-- ENDIF -->

                     <span class="corners-bottom"><span></span></span></div>
                  </div>
                           

               </div>
               <!-- IF not S_IS_BOT and S_USER_LOGGED_IN -->
<div id="backtotop">
<a href="#start_here"><img src="http://www.presents4you.net/backtotop/images/back_to_top_btn.png" alt="Back to TOP" /></a>
</div>
<div id="supportus">
<a href="http://www.presents4you.net/donate/index.php"><img src="http://www.presents4you.net/images/support-us.png" alt="Support" /></a>
</div>
<!-- ENDIF -->

               <a name="start_here"></a>
               <div id="page-body">
                           <!-- IF S_USER_UNREAD_PRIVMSG -->
                      <div id="message" class="rules">
                         <div class="inner"><span class="corners-top"><span></span></span>
                            <strong>{L_INFORMATION}:</strong> {L_NEW_PM_NOTICE} - Klik <a href="{U_PRIVATEMSGS}">hier</a> om naar jou inbox te gaan.
                         <span class="corners-bottom"><span></span></span></div>
                      </div>
                      <!-- ENDIF -->
                  <!-- IF S_BOARD_DISABLED and S_USER_LOGGED_IN and (U_MCP or U_ACP) -->
                  <div id="information" class="rules">
                     <div class="inner"><span class="corners-top"><span></span></span>
                        <strong>{L_INFORMATION}:</strong> {L_BOARD_DISABLED}
                     <span class="corners-bottom"><span></span></span></div>
                  </div>
                  <!-- ENDIF -->
                    <!-- INCLUDE arcade/arcade_info_body.html -->
                    <!-- INCLUDE announcement_centre.html -->


SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 09:33
by Stoker
Yes, you have a shitload of js in your header :D
And jquery twice. Delete this line and check if everything works

Code: Select all

<script type="text/javascript" src="{ROOT_PATH}mchat/jquery-1.5.0.min.js"></script>

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 09:49
by Solidjeuh
Stoker wrote:Yes, you have a shitload of js in your header :D
And jquery twice. Delete this line and check if everything works

Code: Select all

<script type="text/javascript" src="{ROOT_PATH}mchat/jquery-1.5.0.min.js"></script>
Yes! Thank you! those buttons work now! :)
Now just that stupid general sql error .. :cry: :D

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 09:57
by Stoker
I havent been able to figure out the reason for this bug yet.
But I will test the mod on a 3.0.8 board later and see if that triggers it.

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 11:11
by Stoker
Tested on a 3.0.8 vanilla board = no problems
Tested on a 3.0.8 modded board with Arcade and much more = no problems

Which mods do you have installed on that board?

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 13:20
by RMcGirr83
What happens if a guest does not have auths to read any forums? This variable will be empty

Code: Select all

$flist
and will cause a problem within the sql query.

BTW, this

Code: Select all

isset($config['tsrat_enable']) && $config['tsrat_enable'] == 1
can simply be this

Code: Select all

!empty($config['tsrat_enable'])
I would probably due something like this (and you know where it goes)

Code: Select all

if (!empty($config['tsrat_enable']) && sizeof($flist))

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 13:43
by Stoker
Great. Now I am able to troubleshoot the error.
And your fix works 100% - Thanks a lot Rich :)

But Dammit!!! Now I have to resubmit for the third time...