New Bridge file for phpBB ERROR in CPM Fetch RSS

[freesouljah]

I tried asking this in the cpm fetch rss post...but vuud told me it wasn't a cpmfetch issue...


with the new bridge file for phpBB 2.18 the rss feed isn't working right...

It shows the photo & info like normal, but when someone clicks the thumbnail or the 'open in browser' option it gives this error:

Notice: Use of undefined constant PHPBB_SESSIONS_KEYS_TABLE - assumed 'PHPBB_SESSIONS_KEYS_TABLE' in /home/staticp/public_html/photos/bridge/phpbb.inc.php on line 108
Fatal error :
There was an error while processing a database query

line 108 is:

Code Select Expand

$sql = "SELECT u.user_id, u.username as user_name, u.user_level, u.user_posts " . "FROM " .  $UDB_DB_NAME_PREFIX . PHPBB_TABLE_PREFIX . PHPBB_SESSIONS_KEYS_TABLE . " AS s INNER JOIN " . $UDB_DB_NAME_PREFIX . PHPBB_TABLE_PREFIX . PHPBB_USER_TABLE . " AS u ON s.user_id = u.user_id WHERE u.user_id = '$cookie_uid' AND u.user_active = 1 AND s.key_id = MD5('$cookie_pass')";



and the old one (before the 2.18 update) was:

Code Select Expand

$sql = "SELECT user_id, username as user_name, user_level " . "FROM " . $UDB_DB_NAME_PREFIX . PHPBB_TABLE_PREFIX . PHPBB_USER_TABLE . " " . "WHERE user_id='$cookie_uid' AND user_password='$cookie_pass' AND user_active='1'";

thanks

[Joachim Müller]

http://forum.coppermine-gallery.net/index.php?topic=17684.0

[freesouljah]

oops...sorry...

well, I had some extra time on my hands...so I decided to go ahead and upgrade to 1.4 and the problem is fixed....so thanks for replying anyways