[MOD] PHPBB3 Integration v0.9 helium

[helium]

ok Guys had to do a fresh install myself because i messed up my database when i tried to move on to phpbb 3.0.4.

So i did a fresh install of each (and then readded the data from my backups).

IF YOU USE A FRESH INSTALL OF EACH THIS WILL WORK WITH THE LATEST VERSION OF EACH SOFTWARE

http://www.liveanime.org/gallery/  <--- Demo (new layout too)

I have fixed the redirection thing. In the /templates/user_loginform.html find

Code: [Select]

<input type="submit" value="Submit" name="login" />

before it add

Code: [Select]

<input type="hidden" name="redirect" value="<?php echo $_SERVER['REQUEST_URI']; ?>">

As for if your mods arent working, im sorry but as the mod changes everything to do with the users system then mods that need users for some reason will not work. I myself use a mod that i need to modify to get to work using the phpbb integration i will post the code here, however atm im only thinking of doing the ajax star rating (this may just work anyway, not sure yet).

[Fere]

REQUEST_URI would be the command to return to the previous page ?

I,ve visited your wbesite. Neat stuff you've got there. I really like the template and the thumbnail mood, looks great. Too bad you didn't changed the forum template. I've allready accomplished that task here, so if you'd like to give it a try I can help you with the problems you'll face whille moding the forum template (I see that you have prosilver, i choosed subsilver beacause it's a litle simpler, but the issues should be the same).

Would you be kind enough to tell me how you've built your stats box? Are you querying the database or just using phpbb script for user stats ?
Oh, and the featured content box has anny admin script ?

I'm finished with the templating task. All 5 CMS look the same, only minor glitches in diferent browser,  so I'll try again your integration method and I'll be learning PHP starting from tomorrow, so I can make my own adjustments. I would like to have control on user access on the gallery by creating a VIP category reserved only for proven artists (also on blog but there's another forum to discuss that problem) and the methods to aply to it so I can aprove (I'm thinking at a form and a recomandation system). Wish you could give me some links that you found usefull while working on the integration. For the moment w3schools is my first target, and after that this little tut on PHPbb costum page integration. Hope I'll gain enogh knowledge to be abble to work on your integration or maybe work a new method. I know it's a gargatuam task that I'm taking on but I can't aford for the moment to pay somebody else to this job...

Now I'll be going to sleep, I'm extremly tired

I'll be posting soon.

[helium]

Didnt really use any links or resources for making the modification you should just gtet some books on php and  stuff, all i really looked at is the source code and documentation for phpbb and 4 images. Yeah its a shame the forums are still the basic layout. It more of a matter of time rather than difficulty. Ill get round to it eventually , your forum layout looks good btw.

[pilavüstükuru]

i have a problem....i dont have phpbb_function....i installed 4images and phpbb3...why give me this problem...


Warning: require(C:/wamp/www/aaa/includes/phpbb_functions.php) [function.require]: failed to open stream: No such file or directory in C:\wamp\www\aaa\includes\sessions.php on line 20

Fatal error: require() [function.require]: Failed opening required 'C:/wamp/www/aaa/includes/phpbb_functions.php' (include_path='.;C:\php5\pear') in C:\wamp\www\aaa\includes\sessions.php on line 20

[ELO]

Can I find somewhere a download from the changed files for a new 4images-Installation?
Thaks
Michael

[olli1it]

Hi i tryed to change how it is in the description but now i have on my 4images Site a plain white site.

No errors just white ???

Anybody can help me??

Maybe is the best to start from zero

Or can somebody tell me witch file i can try to change?

Thanx

Olli

[olli1it]

Hi Helium

i have the following Error:

^{Fatal error: Call to a member function query_firstrow() on a non-object in /users/foto-forum/www/4images/includes/functions.php on line 599}

Can you help me please

Thanx

Olli

[dorin]

i have a problem....i dont have phpbb_function....i installed 4images and phpbb3...why give me this problem...


Warning: require(C:/wamp/www/aaa/includes/phpbb_functions.php) [function.require]: failed to open stream: No such file or directory in C:\wamp\www\aaa\includes\sessions.php on line 20

Fatal error: require() [function.require]: Failed opening required 'C:/wamp/www/aaa/includes/phpbb_functions.php' (include_path='.;C:\php5\pear') in C:\wamp\www\aaa\includes\sessions.php on line 20

You must read again the first post. Look at the atachament  Download the zip, unziped to yours PC and upload to the server in C:/wamp/www/aaa/includes/ .

[honsa]

i dont know if somebody have done this, but i had to import my old 4images 1.7.6 users to phpBB 3.04

so i wrote and copied this little simple php script:

Code: [Select]

<?php
/******************************************
* import 4images 1.7.6 users to phpBB 3.0.4
* v0.1.4 by honsa
* 24. März 2009
*
* place it in your "/gallery/admin/" folder
*
* http://www.4homepages.de
* http://www.phpbb.de
******************************************/
define('ROOT_PATH', '../');
include(ROOT_PATH.'global.php');
require(ROOT_PATH.'includes/sessions.php');
$user_access = get_permission();
include(ROOT_PATH.'includes/page_header.php');

if(0 < $site_sess->user_info['user_id']){

$sql = "SELECT user_id,user_name, LOWER(user_name) as username_clean,
                     user_password,user_email,user_showemail,
                     user_joindate,user_homepage,user_icq,user_invisible,user_level
        FROM 4img_users";

$result = mysql_query($sql);

if (!$result) {
    echo "Anfrage ($sql) konnte nicht ausgef&uuml;hrt werden : " . mysql_error();
    exit;
}

if (mysql_num_rows($result) == 0) {
    echo "Keine Zeilen gefunden, nichts auszugeben, daher Abbruch";
    exit;
}
//get 4images users
$i=0;
while ($row = mysql_fetch_assoc($result)) {
//only "real" and activated users
if($row["user_name"] != "Guest" && 1 < $row['user_level']) {

$username[$i] = $row["user_name"];
$username_clean[$i] = $row["username_clean"];
$user_password[$i] = $row["user_password"];
$user_email[$i] = $row["user_email"];
$user_allow_viewemail[$i] = $row['user_showemail'];

if($row["user_invisible"] == 0)
   $user_allow_viewonline[$i] = 1;
else
   $user_allow_viewonline[$i] = 0;

$user_icq[$i] = $row['user_icq'];
$user_regdate[$i] = $row['user_joindate'];
$user_website[$i] = $row['user_homepage'];

//change values if you need
$group_id[$i] = 7;
$user_type[$i] = 0;
$user_perm_from[$i] = 0;
$user_passchg[$i] = 0;
$user_pass_convert[$i] = 0;
$user_email_hash[$i] = 0;
$user_last_search[$i] = 0;
$user_warnings[$i] = 0;
$user_last_warning[$i] = 0;
$user_login_attempts[$i] = 0;
$user_inactive_reason[$i] = 0;
$user_inactive_time = 0;
$user_posts[$i] = 0;
$user_timezone[$i] = 1.00;
$user_dst[$i] = 0;
$user_dateformat[$i] = 'l j. F Y, H:i';
$user_style[$i] = 1;
$user_rank[$i] = 0;
$user_new_privmsg[$i] = 0;
$user_unread_privmsg[$i] = 0;
$user_last_privmsg[$i] = 0;
$user_message_rules[$i] = 0;
$user_full_folder[$i] = -3;
$user_emailtime[$i] = 0;
$user_topic_show_days[$i] = 0;
$user_topic_sortby_type[$i] = 't';
$user_topic_sortby_dir[$i] = 'd';
$user_post_show_days[$i] = 0;
$user_post_sortby_type[$i] = 't';
$user_post_sortby_dir[$i] = 'a';
$user_notify[$i] = 0;
$user_notify_pm[$i] = 1;
$user_notify_type[$i] = 0;
$user_allow_pm[$i] = 1;
$user_allow_massemail[$i] = 1;
$user_options[$i] = 895;
$user_avatar_type[$i] = 0;
$user_avatar_width[$i] = 0;
$user_avatar_height[$i] = 0;
$user_lang[$i] = 'de';
}
else
$i--;
$i++;
}

mysql_free_result($result);

echo "4images Users:";
echo"<pre>";
print_r($username);
echo"</pre>";

echo "phpBB Users:<ol>";

$i=$i-1;
//write into phpbb db new users error if duplicate exists
while(0 <= $i) {
echo "<li>".$username[$i]." ". $user_email[$i] . "</li>";

//change  prefix if you need
$insertmysql="INSERT INTO phpbb_users(
              username,
              username_clean,
              user_password,
              user_email,
              user_allow_viewemail,
              user_icq,
              user_regdate,
              user_website,
              group_id,
              user_type,
              user_perm_from,
              user_passchg,
              user_pass_convert,
              user_email_hash,
              user_last_search,
              user_warnings,
              user_last_warning,
              user_login_attempts,
              user_inactive_reason,
              user_inactive_time,
              user_posts,
              user_timezone,
              user_dst,
              user_dateformat,
              user_style,
              user_rank,
              user_new_privmsg,
              user_unread_privmsg,
              user_last_privmsg,
              user_message_rules,
              user_full_folder,
              user_emailtime,
              user_topic_show_days,
              user_topic_sortby_type,
              user_topic_sortby_dir,
              user_post_show_days,
              user_post_sortby_type,
              user_post_sortby_dir,
              user_notify,
              user_notify_pm,
              user_notify_type,
              user_allow_pm,
              user_allow_massemail,
              user_options,
              user_avatar_type,
              user_avatar_width,
              user_avatar_height,
              user_lang)
              VALUES(
              '".$username[$i]."',
              '".$username_clean[$i]."',
              '".$user_password[$i]."',
              '".$user_email[$i]."',
              '".$user_allow_viewemail[$i]."',
              '".$user_icq[$i]."',
              '".$user_regdate[$i]."',
              '".$user_website[$i]."',
              '".$group_id[$i]."',
              '".$user_type[$i]."',
              '".$user_perm_from[$i]."',
              '".$user_passchg[$i]."',
              '".$user_pass_convert[$i]."',
              '".$user_email_hash[$i]."',
              '".$user_last_search[$i]."',
              '".$user_warnings[$i]."',
              '".$user_last_warning[$i]."',
              '".$user_login_attempts[$i]."',
              '".$user_inactive_reason[$i]."',
              '".$user_inactive_time[$i]."',
              '".$user_posts[$i]."',
              '".$user_timezone[$i]."',
              '".$user_dst[$i]."',
              '".$user_dateformat[$i]."',
              '".$user_style[$i]."',
              '".$user_rank[$i]."',
              '".$user_new_privmsg[$i]."',
              '".$user_unread_privmsg[$i]."',
              '".$user_last_privmsg[$i]."',
              '".$user_message_rules[$i]."',
              '".$user_full_folder[$i]."',
              '".$user_emailtime[$i]."',
              '".$user_topic_show_days[$i]."',
              '".$user_topic_sortby_type[$i]."',
              '".$user_topic_sortby_dir[$i]."',
              '".$user_post_show_days[$i]."',
              '".$user_post_sortby_type[$i]."',
              '".$user_post_sortby_dir[$i]."',
              '".$user_notify[$i]."',
              '".$user_notify_pm[$i]."',
              '".$user_notify_type[$i]."',
              '".$user_allow_pm[$i]."',
              '".$user_allow_massemail[$i]."',
              '".$user_options[$i]."',
              '".$user_avatar_type[$i]."',
              '".$user_avatar_width[$i]."',
              '".$user_avatar_height[$i]."',
              '".$user_lang[$i]."')";

$result = mysql_query($insertmysql);

if (!$result) {
 echo '<ul  style="list-style-type:disc; color:red; font-weight:bold;">
          <li >Anfrage konnte nicht ausgef&uuml;hrt werden : ' . mysql_error() .'</li>
         </ul>';
}
else {
 echo '<ul  style="list-style-type:disc; color:green; font-weight:bold;">
          <li >Anfrage wurde ausgef&uuml;hrt</li>
         </ul>';
}

$i--;
mysql_free_result($result);
}
echo "</ol>";
}
else
   echo "Login!";
?>

might it could be useful for someone else

edit:
updates in my blog:
http://secure-blog.pytalhost.eu/4images2phpbb-3-4images-user-import-ins-phpbb

[darkcurves]

Does the integration works only if the tables of 4images and phpBB3 are on the same database?

[honsa]

yes, you have to change the prefix for your phpbb tables, you can delete the unused tables after the import

but it should work if you change the prefix to "yourphpbbdatabase.phpbb_users" i think 

edit: i was drunk, it is not possible, you have to modify the script, now it uses the 4images dbconfig file *bag

[darkcurves]

Wow, this is getting complicated. I am already using PHPBB2/4Images integration mod released by Jan. How can i upgrade to this mod? My 4images version is 1.7.4 and i am planning to change to 1.7.6 together with this mod.

Thanks for the reply. 

[honsa]

but by the way its not a clean phpbb import, only the user basics works, login, etc. some features like groups need extra table entries, the problem is i have never worked before with a phpbb

[honsa]

i made an update, added some fields now all 4images fields but not the avatar will be imported, import only activated users.

the next problem are the users with special chars phpbb might have some problems, 4images accept they, but phpbb dont

[koao]

After installing this, I cant login the administration panel...

How do I fix that?