Show Posts
1
Mods & Plugins (Requests & Discussions) / 4Images & PHPBB Integration
« on: July 14, 2002, 07:47:18 PM »
I am in the process of working on this as well. I saw that some people were attempting to do this with VBulletin, but when I realized that VB wasnt free, and PHPBB was, I figured it would have more of a draw if I tried it with PHPBB.
Also, it appears that the DB structure on 4I is modeled after PHPBB. So the transition was a lot easier. So far it is going fairly well. If you would like to see it, then I must warn you that the site is an adult oriented site. I will place the URL at the end of this mesage after I vaguely outline the steps I used to do this.
1 - Install PHPBB with defaults. Leaving PHPBB_ as the prefix to all the database names.
2 - Install 4Images with defaults to the same database. Leaving 4IMAGES_ as the prefix to all the database names.
3 - Export structure and data of 4IMAGES_USERS to a file with PHPMYADMIN with COMPLETE INSERTS and EXTENDED INSERTS both checked.
4 - Export structure and data of PHPBB_USERS to a file with PHPMYADMIN in the same fashion.
5 - Manually duplicate the data fields of the 4IMAGES db into the PHPBB db, changing the DB so that it creates a new DB named USERS (with no Prefix). Also, make sure the field of USER_NAME is not used. PHPBB uses USERNAME (no underscore).
6 - Using PHPMYADMIN again, run the new SQL script that you just created and allow it to create a new DB Table called users.
7 - Using PHPMYADMIN again, change the DB field in 4IMAGES_COMMENTS called USER_NAME to USERNAME as well.
8 - I use HomeSite 4.52 for HTML/ASP/CGI/PHP/Etc editing. One of my favorite features is a global search and replace in a directory structure. You may have to find another program to do this, or actually go through all files and do this by hand. If by hand, then this is the longest step of the whole process. Do a global replace of all instances of the phrase USER_NAME with USERNAME.
9 - Do another search and replace for USERNAME_LINK and change it back to USER_NAME_LINK.
10 - In both CONSTANTS.PHP files (for 4I and BB) remove the prefix for both of the USERS tables. so it looks like define('USERS_TABLE', 'users'); in both. This will let both of them use the same userbase.
11 - Also in both CONSTANTS.PHP files, make sure that the user settings match each other. I made USER = 2 and ADMIN = 9.
12 - in the FORUM/INCLUDES/USERCP_REGISTER.PHP, look for $user_style, 0, 1, at the end of a strign of values and replace it with $user_style, 2, 1,. This will set it so users have access to the GALLERY after registering. (Note: this is one of the problems I am working on. See end for list of them.)
13 - In your templae files, change the LOST PASSSWORD and REGISTRATION links, to point to the corresponding links in the FORUM. I have hard coded these in the templates I am using.
14 - Turn off the need for activation in the GALLERY. Since all registration is going through the forum, this message for activation will never get sent or even created.
--------------------------------------------
And thats pretty much it. Ther are probably a fewlittle things that you might need. Like I said above, this is very vague. I was doing this in the wee hours of the morning.
Here are a few things I am still trying to fix:
- A single login. As I have it now, once you register an account, you still have to login twice. Once to the forum, and then once to the gallery.
- Using the same sessions/cookies.
- Changing 4IMAGES to use the ACTIVATED field instead of the USER_LEVEL field. PHPBB has a seperate field that denotes whether or not the accoutn has been activated. 4IMAGES actually changes the USER_LEVEL.
- Combining the WHO'S ONLINE entries so that they cross over. Letting people on the gallery see who is on the forum and vice-versa.
- Changing the templates in the forum to show a Random image like the gallery does. I have found the code that was used in the RANDOM.PHP, but I am having trouble incorporating it into a HTML document.
I am not sure how hard these will be, but I also know next to nothing about PHP. Ihave messed with CGI and ASP in the past, so I am fumbling around through this entire thing. If anyone would like to take this start and run with it, I would be more than willing to help out what little I can.
Also, it appears that the DB structure on 4I is modeled after PHPBB. So the transition was a lot easier. So far it is going fairly well. If you would like to see it, then I must warn you that the site is an adult oriented site. I will place the URL at the end of this mesage after I vaguely outline the steps I used to do this.
1 - Install PHPBB with defaults. Leaving PHPBB_ as the prefix to all the database names.
2 - Install 4Images with defaults to the same database. Leaving 4IMAGES_ as the prefix to all the database names.
3 - Export structure and data of 4IMAGES_USERS to a file with PHPMYADMIN with COMPLETE INSERTS and EXTENDED INSERTS both checked.
4 - Export structure and data of PHPBB_USERS to a file with PHPMYADMIN in the same fashion.
5 - Manually duplicate the data fields of the 4IMAGES db into the PHPBB db, changing the DB so that it creates a new DB named USERS (with no Prefix). Also, make sure the field of USER_NAME is not used. PHPBB uses USERNAME (no underscore).
6 - Using PHPMYADMIN again, run the new SQL script that you just created and allow it to create a new DB Table called users.
7 - Using PHPMYADMIN again, change the DB field in 4IMAGES_COMMENTS called USER_NAME to USERNAME as well.
8 - I use HomeSite 4.52 for HTML/ASP/CGI/PHP/Etc editing. One of my favorite features is a global search and replace in a directory structure. You may have to find another program to do this, or actually go through all files and do this by hand. If by hand, then this is the longest step of the whole process. Do a global replace of all instances of the phrase USER_NAME with USERNAME.
9 - Do another search and replace for USERNAME_LINK and change it back to USER_NAME_LINK.
10 - In both CONSTANTS.PHP files (for 4I and BB) remove the prefix for both of the USERS tables. so it looks like define('USERS_TABLE', 'users'); in both. This will let both of them use the same userbase.
11 - Also in both CONSTANTS.PHP files, make sure that the user settings match each other. I made USER = 2 and ADMIN = 9.
12 - in the FORUM/INCLUDES/USERCP_REGISTER.PHP, look for $user_style, 0, 1, at the end of a strign of values and replace it with $user_style, 2, 1,. This will set it so users have access to the GALLERY after registering. (Note: this is one of the problems I am working on. See end for list of them.)
13 - In your templae files, change the LOST PASSSWORD and REGISTRATION links, to point to the corresponding links in the FORUM. I have hard coded these in the templates I am using.
14 - Turn off the need for activation in the GALLERY. Since all registration is going through the forum, this message for activation will never get sent or even created.
--------------------------------------------
And thats pretty much it. Ther are probably a fewlittle things that you might need. Like I said above, this is very vague. I was doing this in the wee hours of the morning.
Here are a few things I am still trying to fix:
- A single login. As I have it now, once you register an account, you still have to login twice. Once to the forum, and then once to the gallery.
- Using the same sessions/cookies.
- Changing 4IMAGES to use the ACTIVATED field instead of the USER_LEVEL field. PHPBB has a seperate field that denotes whether or not the accoutn has been activated. 4IMAGES actually changes the USER_LEVEL.
- Combining the WHO'S ONLINE entries so that they cross over. Letting people on the gallery see who is on the forum and vice-versa.
- Changing the templates in the forum to show a Random image like the gallery does. I have found the code that was used in the RANDOM.PHP, but I am having trouble incorporating it into a HTML document.
I am not sure how hard these will be, but I also know next to nothing about PHP. Ihave messed with CGI and ASP in the past, so I am fumbling around through this entire thing. If anyone would like to take this start and run with it, I would be more than willing to help out what little I can.