Viewonline in de stress OPGELOST

[Muiter]

Support template:

• Wat is het probleem? Probleem in viewonline
  Wanneer ontstond het probleem? Gisteren
  Adres van je forum: http://modelautoforum.nl
  Geïnstalleerde mods: te veel om op te noemen
  Huidige template: eigen
  phpBB versie: 2.0.18
  Host: Flexwebhosting
  Heb je onlangs een mod of stijl geïnstalleerd? Soduku mod

Overige opmerkingen:Zelfde probleem in ACP

[Paul]

En wat is precies het probleem?

[Muiter]

En wat is precies het probleem?

What the *beep*, gisteravond en vanmorgen stond er alleen foutmelding

[Paul]

Je bedoelt:

Code: Selecteer alles

Could not obtain regd user/online information

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'WHERE page_id = 2745' at line 1

SELECT u.user_id, u.username, u.user_allow_viewonline, u.user_level, u.user_whosonline_color, s.session_logged_in, s.session_time, s.session_page, s.session_topic, s.session_ip FROM phpbb_users u, phpbb_sessions s WHERE u.user_id = s.session_user_id AND s.session_time >= 1131884553 ORDER BY u.username ASC, s.session_ip ASC

Line : 218
File : viewonline.php

?

EDIT: maar das wel de foute query die erbij wordt gegeven

[Muiter]

Die bedoel ik ja, wel vreemd dat de melding er niet constant staat.

[Bee]

Zou je viewonline.php in een tekstbestand willen zetten en deze hier willen posten.

[Muiter]

Zou je viewonline.php in een tekstbestand willen zetten en deze hier willen posten.

http://www.modelautoforum.nl/viewonline.txt

[Bee]

De code waar de fout zit is die van de Blank Page Mod, maar de foutmelding wordt misschien beter als je de volgende wijziging doet:

Code: Selecteer alles

message_die(GENERAL_ERROR, 'Could not obtain regd user/online information', '', __LINE__, __FILE__, $sql);

wordt

Code: Selecteer alles

message_die(GENERAL_ERROR, 'Could not obtain regd user/online information', '', __LINE__, __FILE__, $sql_tpl);

[Paul]

De code waar de fout zit is die van de Blank Page Mod, maar de foutmelding wordt misschien beter als je de volgende wijziging doet:

Code: Selecteer alles

message_die(GENERAL_ERROR, 'Could not obtain regd user/online information', '', __LINE__, __FILE__, $sql);

wordt

Code: Selecteer alles

message_die(GENERAL_ERROR, 'Could not obtain regd user/online information', '', __LINE__, __FILE__, $sql_tpl);

LET OP: verander niet de EERSTE die je tegenkomt, maar de TWEEDE!

[Muiter]

Heb ik aangepast maar volgens mij maakt dat niet veel verschil.

[Paul]

Code: Selecteer alles

$sql_tpl = "SELECT page_name WHERE page_id = $page_id";

Klopt niet. Geef de instructie van de blank page tempalte eens?

[Muiter]

Code: Selecteer alles

# 
#-----[ OPEN ]------------------------------------------ 
# 
viewonline.php

# 
#-----[ FIND ]------------------------------------------ 
# 

      switch( $row['session_page'] )

# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 
      
      // BEGIN Blank Template MOD
      if( $row['session_page'] < PAGE_TEMPLATE )
      {
        $page_id = - ($row['session_page'] + PAGE_TEMPLATE);
        $sql_tpl = "SELECT page_name WHERE page_id = $page_id";
        if ( !($result_tpl = $db->sql_query($sql_tpl)) )
        {
	  message_die(GENERAL_ERROR, 'Could not obtain regd user/online information', '', __LINE__, __FILE__, $sql);
        }
        while( $rowtpl = $db->sql_fetchrow($result_tpl) )
        {
          $location = $rowtpl['page_name'];
	  $location_url = "template.$phpEx?page=$page_id";
	}	
      }
      // END Blank Template MOD

# 
#-----[ OPEN ]------------------------------------------ 
# 
admin/index.php

# 
#-----[ FIND ]------------------------------------------ 
# 

	  switch($onlinerow_reg[$i]['user_session_page'])

# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 
      
          // BEGIN Blank Template MOD
          if( $onlinerow_reg[$i]['user_session_page'] < PAGE_TEMPLATE )
          {
            $page_id = - ($onlinerow_reg[$i]['user_session_page'] + PAGE_TEMPLATE);
            $sql_tpl = "SELECT page_name WHERE page_id = $page_id";
            if ( !($result_tpl = $db->sql_query($sql_tpl)) )
            {
	      message_die(GENERAL_ERROR, 'Could not obtain regd user/online information', '', __LINE__, __FILE__, $sql);
            }
            while( $rowtpl = $db->sql_fetchrow($result_tpl) )
            {
              $location = $rowtpl['page_name'];
	      $location_url = "template.$phpEx?page=$page_id";
	    }	
          }
          // END Blank Template MOD

# 
#-----[ FIND ]------------------------------------------ 
# 

	switch( $onlinerow_guest[$i]['session_page'] )						

# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 
      
      // BEGIN Blank Template MOD
      if( $onlinerow_guest[$i]['session_page'] < PAGE_TEMPLATE )
      {
        $page_id = - ($onlinerow_guest[$i]['session_page'] + PAGE_TEMPLATE);
        $sql_tpl = "SELECT page_name WHERE page_id = $page_id";
        if ( !($result_tpl = $db->sql_query($sql_tpl)) )
        {
	  message_die(GENERAL_ERROR, 'Could not obtain regd user/online information', '', __LINE__, __FILE__, $sql);
        }
        while( $rowtpl = $db->sql_fetchrow($result_tpl) )
        {
          $location = $rowtpl['page_name'];
	  $location_url = "template.$phpEx?page=$page_id";
	}	
      }
      // END Blank Template MOD

[Paul]

En welke sql moest je uitvoeren? Want ij beide files zit dezelfde fout

[Muiter]

De hele mod staat hier: http://www.phpbbhacks.com/download/3562

[Paul]

Code: Selecteer alles

#
#-----[ OPEN ]------------------------------------------
# 

viewonline.php

#
#-----[ FIND ]------------------------------------------
# 

$sql_tpl = "SELECT page_name WHERE page_id = $page_id";

#
#-----[ REPLACE, WITH ]------------------------------------------
# 

$sql_tpl = "SELECT page_name FROM phpbb_add_pages WHERE page_id = $page_id";

#
#-----[ OPEN ]------------------------------------------
# 
admin/index.php

#
#-----[ FIND ]------------------------------------------
# 

$sql_tpl = "SELECT page_name WHERE page_id = $page_id";

#
#-----[ REPLACE, WITH ]------------------------------------------
# 

$sql_tpl = "SELECT page_name FROM phpbb_add_pages WHERE page_id = $page_id";

Dat moet wekren.

[Muiter]

Dat moet wekren.

:thumb: