into the code but I don't know exactly where to place it. My code looks like this
- <?
- if(!defined('IN_PHPBB'))
- {
- define('IN_PHPBB', true);
- $phpbb_root_path = './phpbb/'; //set your path
- $album_root_path = $phpbb_root_path . 'album_mod/';
- include($phpbb_root_path . 'extension.inc');
- include($phpbb_root_path . 'common.'.$phpEx);
- }
- else
- {
- $album_root_path = $phpbb_root_path . 'album_mod/';
- }
- $language = $board_config['default_lang'];
- if ( !file_exists($phpbb_root_path . 'language/lang_' . $language . '/lang_album_main.'.$phpEx) )
- {
- $language = 'english'; // set your default language
- }
- include($phpbb_root_path . 'language/lang_' . $language . '/lang_album_main.' . $phpEx);
- print "<table align=center>";
- print "<tr><th align='center' colspan='3'>". $lang['Random_Pics'] ."</th></tr>";
- print "<tr>";
- for ($i=0;$i<3;$i++) //set number of pictures for the displayed line
- {
- while ($cat['cat_view_level'] != '-1')
- {
- $sql = "SELECT pic_id, pic_desc, pic_cat_id FROM ". ALBUM_TABLE ." ORDER BY RAND() LIMIT 1";
- $result = $db->sql_query($sql) or die ("SQL Error");
- $row = $db->sql_fetchrow($result);
- $sql = "SELECT * FROM ". ALBUM_CAT_TABLE ." WHERE cat_id = '". $row['pic_cat_id'] ."'";
- $result = $db->sql_query($sql) or die ("SQL Error");
- $cat = $db->sql_fetchrow($result);
- }
- $cat['cat_view_level'] = '0';
- print "<td valign='top'><table><tr><td align='center'>" . $row['pic_title'] . "<br /></td></tr><tr><td align='center'><a href='". append_sid($phpbb_root_path ."album_showpage.". $phpEx ."?pic_id=" . $row['pic_id']) ."'><img alt='" . $row['pic_desc'] . "' src='". $phpbb_root_path ."album_thumbnail.". $phpEx ."?pic_id=" . $row['pic_id'] . "'></a></td></tr></table></td>";
- }
- print "</tr>";
- print "</table>";
- print "<table align=center>";
- print "<tr>";
- for ($i=0;$i<3;$i++) //set number of pictures for the displayed line
- {
- while ($cat['cat_view_level'] != '-1')
- {
- $sql = "SELECT pic_id, pic_desc, pic_cat_id FROM ". ALBUM_TABLE ." ORDER BY RAND() LIMIT 1";
- $result = $db->sql_query($sql) or die ("SQL Error");
- $row = $db->sql_fetchrow($result);
- $sql = "SELECT * FROM ". ALBUM_CAT_TABLE ." WHERE cat_id = '". $row['pic_cat_id'] ."'";
- $result = $db->sql_query($sql) or die ("SQL Error");
- $cat = $db->sql_fetchrow($result);
- }
- $cat['cat_view_level'] = '0';
- print "<td valign='top'><table><tr><td align='center'>" . $row['pic_title'] . "<br /></td></tr><tr><td align='center'><a href='". append_sid($phpbb_root_path ."album_showpage.". $phpEx ."?pic_id=" . $row['pic_id']) ."'><img alt='" . $row['pic_desc'] . "' src='". $phpbb_root_path ."album_thumbnail.". $phpEx ."?pic_id=" . $row['pic_id'] . "'></a></td></tr></table></td>";
- }
- print "</tr>";
- print "</table>";
- ?>
I would greatly appreciate any help solving this problem.
Thank you