phpnukebb addon

Posted: Sat Apr 05, 2003 2:46 pm

Hello,

I noticed there are forums for blocks & modules but I didn't see one for addons therefore, I thought it was safe to post this topic here.

I want to install the flag hack for the forum. I did everything accordingly, when I click the profile link I get this debug error message:

Code:

Couldn't obtain flags information.

DEBUG MODE

SQL Error : 1146 Table 'foxy.bbflags' doesn't exist

SELECT * FROM bbflags ORDER BY flag_id

Line : 892
File : /home/foxy/www/includes/usercp_register.php

This is the information I have on line 892 usercp_register.php

Code:

// FLAGHACK-start
// query to get the list of flags
$sql = "SELECT *
   FROM " . FLAG_TABLE . "
   ORDER BY flag_id";
if(!$flags_result = $db->sql_query($sql))
{
   message_die(GENERAL_ERROR, "Couldn't obtain flags information.", "", __LINE__, __FILE__, $sql);
}
$flag_row = $db->sql_fetchrowset($ranksresult);
$num_flags = $db->sql_numrows($ranksresult) ;

// build the html select statement
$flag_start_image = 'blank.gif' ;
$selected = ( isset($user_flag) ) ? '' : ' selected="selected"' ;
$flag_select = "<select name=\"user_flag\" onChange=\"document.images['user_flag'].src = 'images/flags/' + this.value;\" >";
$flag_select .= "<option value=\"blank.gif\"$selected>" . $lang['Select_Country'] . "</option>";
for ($i = 0; $i < $num_flags; $i++)
{
   $flag_name = $flag_row[$i]['flag_name'];
   $flag_image = $flag_row[$i]['flag_image'];
   $selected = ( isset( $user_flag) ) ? (($user_flag == $flag_image) ? 'selected="selected"' : '' ) : '' ;
   $flag_select .= "\t<option value=\"$flag_image\"$selected>$flag_name</option>";
   if ( isset( $user_flag) && ($user_flag == $flag_image))
   {
      $flag_start_image = $flag_image ;
   }
}
$flag_select .= '</select>';
// FLAGHACK-end

The flag table is nuke_bbflags. What I don't understand is why is it looking for the flags in foxy.bbflags? note: foxy is my database name.

I'd appreciate any input one has to offer.

Joined: Jan 31, 2004 Posts: -88

add-ons are modules.

As for ur problem, it sounds like ur using an unported add-on for the phpBB forum. It's looking for a table called bbflags in ur foxy database. What I suggest you do is alter the code in the files mentioned and add nuke_ in front of bbflags.

AI

Posted: Sat Apr 05, 2003 3:01 pm

ArtificialIntel wrote:

What I suggest you do is alter the code in the files mentioned and add nuke_ in front of bbflags.

Alter what codes? Assuming you're referring to this one

Code:

$sql = "SELECT *
FROM " . FLAG_TABLE . "

The nuke_bbflags table already exist.

addendum: I changed FLAG_TABLE to nuke_bbflags and it worked, user can select their country flag when they edit their profile.

Thanks for helping me.

Nuke Cadet Joined: Jun 05, 2003 Posts: 2

Hi Foxyfemfem!!

Can i ask a dumb q - how do you install that hack?

I had a go but it is all SQL which i am not very good at........

i managed to launch the sql file from myphpadmin but received an error saying that it couldnt create the table due to phpbb_users not being there.........which it isnt.........can the code safely be edited to look at nuke_users?

How did you get it to work? - i am really keen to stick this hack onto my bb and would really appreciate any help - Thanks!!!

Doc