[mod][alpha] Integration 4images / Invisionboard 1.01

[singtel22]

Beta release anyone?

[NightWalk8r]

yeah............i really want to check this out  

[windrider]

He ended up re-writing the script to get it to integrate. Not really sure it could be called an "integration" anymore  

Hey whatever works.  I'd be interested in looking at it and giving it a try.  Is he going to release it at all?

[DeGrey]

I don't know. I ended up paying a lot of money for it

[windrider]

I don't know. I ended up paying a lot of money for it

Hrmm that sucks.  Do you have it in action someplace I could look at?  I'd just like to see how it looks if it's fully integrated into InvisionBoard.  

Guess I'll just add it to my very large list of things to do.

[Aaron]

*bump*

[Aaron]

Nevermind, got it working finally after two days.

[singtel22]

Nevermind, got it working finally after two days.

How? I never got mine to work....  

[Aaron]

Since both my 4images and ib were fairly new installations, I edited my ibf_members table to look like this:

Code: [Select]


#
# Structure for Table ibf_members
#
DROP TABLE IF EXISTS ibf_members;
CREATE TABLE ibf_members (
  id bigint(10) NOT NULL default '0',
  name varchar(32) NOT NULL default '',
  mgroup tinyint(2) NOT NULL default '0',
  password varchar(32) NOT NULL default '',
  email varchar(60) NOT NULL default '',
  i_user_level smallint(6) NOT NULL default '2',
  i_user_showemail tinyint(1) NOT NULL default '0',
  i_user_allowemails tinyint(1) NOT NULL default '1',
  i_user_invisible tinyint(1) NOT NULL default '0',
  i_user_activationkey varchar(32) NOT NULL default '',
  i_user_lastaction int(11) NOT NULL default '0',
  i_user_location varchar(255) NOT NULL default '',
  i_user_lastvisit int(11) NOT NULL default '0',
  joined int(10) NOT NULL default '0',
  ip_address varchar(16) NOT NULL default '',
  avatar varchar(128) default NULL,
  avatar_size varchar(9) default NULL,
  posts mediumint(7) default '0',
  photo varchar(70) default NULL,
  aim_name varchar(40) default NULL,
  icq_number varchar(40) default NULL,
  location varchar(128) default NULL,
  signature text,
  website varchar(70) default NULL,
  yahoo varchar(32) default NULL,
  title varchar(64) default NULL,
  allow_admin_mails tinyint(1) default NULL,
  time_offset varchar(10) default NULL,
  interests text,
  hide_email varchar(8) default NULL,
  email_pm tinyint(1) default NULL,
  email_full tinyint(1) default NULL,
  skin smallint(5) default NULL,
  warn_level int(10) default NULL,
  language varchar(32) default NULL,
  msnname varchar(64) default NULL,
  last_post int(10) default NULL,
  allow_post tinyint(1) default '1',
  view_sigs tinyint(1) default '1',
  view_img tinyint(1) default '1',
  view_avs tinyint(1) default '1',
  view_pop tinyint(1) default '1',
  bday_day int(2) default NULL,
  bday_month int(2) default NULL,
  bday_year int(4) default NULL,
  new_msg tinyint(2) default NULL,
  msg_from_id varchar(32) default NULL,
  msg_msg_id int(10) default NULL,
  msg_total smallint(5) default NULL,
  vdirs text,
  show_popup tinyint(1) default NULL,
  validate_key varchar(32) default NULL,
  prev_group smallint(3) default '0',
  new_pass varchar(32) default NULL,
  misc varchar(128) default NULL,
  last_visit int(10) default '0',
  last_activity int(10) default '0',
  dst_in_use tinyint(1) default '0',
  PRIMARY KEY  (id),
  KEY name (name),
  KEY mgroup (mgroup)
) TYPE=MyISAM;

#
# Table Data for ibf_members
#
INSERT INTO ibf_members (id, name, mgroup, password, email, i_user_level, i_user_showemail, i_user_allowemails, i_user_invisible, i_user_activationkey, i_user_lastaction, i_user_location, i_user_lastvisit, joined, ip_address, avatar, avatar_size, posts, photo, aim_name, icq_number, location, signature, website, yahoo, title, allow_admin_mails, time_offset, interests, hide_email, email_pm, email_full, skin, warn_level, language, msnname, last_post, allow_post, view_sigs, view_img, view_avs, view_pop, bday_day, bday_month, bday_year, new_msg, msg_from_id, msg_msg_id, msg_total, vdirs, show_popup, validate_key, prev_group, new_pass, misc, last_visit, last_activity, dst_in_use) VALUES (0, 'Guest', 2, '', 'guest@ibforums.com', -1, 1, 0, 0, '', 0, '', 0, 0, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '0', 1036056227, 1036056227, 0);
INSERT INTO ibf_members (id, name, mgroup, password, email, i_user_level, i_user_showemail, i_user_allowemails, i_user_invisible, i_user_activationkey, i_user_lastaction, i_user_location, i_user_lastvisit, joined, ip_address, avatar, avatar_size, posts, photo, aim_name, icq_number, location, signature, website, yahoo, title, allow_admin_mails, time_offset, interests, hide_email, email_pm, email_full, skin, warn_level, language, msnname, last_post, allow_post, view_sigs, view_img, view_avs, view_pop, bday_day, bday_month, bday_year, new_msg, msg_from_id, msg_msg_id, msg_total, vdirs, show_popup, validate_key, prev_group, new_pass, misc, last_visit, last_activity, dst_in_use) VALUES (1, 'Aaron', 4, 'somepassword', 'aaron@klubdiva.com', 9, 1, 1, 0, '1e3457c0b2052a9633b886fd75ef91e0', 1036056581, 'Control Panel', 1035673621, 1035695458, '127.0.0.1', NULL, NULL, 0, '', 'Klub Diva', '98001627', '', NULL, 'http://www.klubdiva.com', 'DopeyAaron', 'Administrator', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'aaronjsaxton@hotmail.com', NULL, 1, 1, 1, 1, 1, 28, 11, 1982, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1036056159, 1036056164, 0);


Basically I just added the vars 'i_user_level', 'i_user_showemail', 'i_user_allowemails', 'i_user_invisible', 'i_user_activationkey', 'i_user_lastaction', 'i_user_location', and 'i_user_lastvisit' (which all correspond with the vars in 4images - 'user_level', 'user_showemail', 'user_allowemails', 'user_invisible', 'user_activationkey', 'user_lastaction', 'user_location', 'user_lastvisit') to the table structure, and inserted them manually with the default values.

While I was doing this, I also deleted all rows in tables ibf_sessions and 4images_sessionvars. After that, I re-uploaded the changed sql database and restored it via 4images control panel, then made the other changes.

After that I used the same modifications as in genius' betarelease, except for in sessions.php I have the settings as follows for the user_table_settings array:

Code: [Select]


$user_table_fields = array(
  "user_id" => "id",
  "user_level" => "i_user_level",
  "user_name" => "name",
  "user_password" => "password",
  "user_email" => "email",
  "user_showemail" => "i_user_showemail",
  "user_allowemails" => "i_user_allowemails",
  "user_invisible" => "i_user_invisible",
  "user_joindate" => "joined",
  "user_activationkey" => "i_user_activationkey",
  "user_lastaction" => "i_user_lastaction",
  "user_location" => "i_user_location",
  "user_lastvisit" => "i_user_lastvisit",
  "user_comments" => "posts",
  "user_homepage" => "website",
  "user_icq" => "icq_number"
);


user_comments corresponds to 'posts', thus the total amount of posts for user is 4images comments plus ib posts.

And commented out the define command for templates as such:

Code: [Select]


// define('VB_TEMPLATE_TABLE', 'template');


and changed the following template-related commands:

Code: [Select]


// $optionstemp = $site_db->query_firstrow("SELECT template FROM ".VB_TEMPLATE_TABLE." WHERE title='options'");
// eval($optionstemp['template']);

define('COOKIE_NAME', '');
define('COOKIE_PATH', '');
define('COOKIE_DOMAIN', 'klubdiva.com');
$secure = (isset($SERVER_PORT) && $SERVER_PORT == "443") ? 1 : 0;
define('COOKIE_SECURE', $secure);

COOKIE_DOMAIN should be defined as your domain, not mine.  

And it worked! Now I'm in the process of making minor modifications to ib so that the options for i_user_invisible, i_user_showemail, i_user_allowemails can be changed through the member control panels. This way, a user can choose to be invisible on ib and not invisible on 4images, or show email address on 4images and not on ib, or allow emails from mods/admins on 4images and not on ib, etc.

[Aaron]

One other thing, I left the user level definitions as follows:

Code: [Select]


// User levels
define('GUEST', -1);
define('USER_AWAITING', 1);
define('USER', 2);
define('ADMIN', 9);


[cross]

hi zusammen,

funktioniert das schon bei jemandem? .. bei mir ist es so, das ich mich von 4images bei ibf einloggen kann, aber dennoch nicht bei 4images selbst eingeloggt bin?! komme stets nur als gast drauf ..

habe ne neuinstallation von 4images durchgeführt .. die tabellen ibf und 4images sind in der selben datenbank ..

für einen tipp wäre ich dankbar

[windrider]

I've made some changes to the initial alpha version that seems to work much better with logging in and out and such.  

Feel free to download it: http://www.braindead.net/ibf/ibf-4images-integration.zip and try if you want.  No guarantees of course.

[cross]

hey ..

it works!!

thank u very much!! ..  

[silversurfer]

Hi. I used the updated zip. And this are the errors on the Front page (main page) of 4Images. Please help. I am not exactly a programmer. So please be clear where possible thanks. I am using invision 1.1b2 amd 4images 1.7.  If I am logged in, it works on both the forum and 4images. The problem are the following error messages in the header of the main page.

DB Error: Bad SQL Query: DELETE FROM ibf_sessions WHERE start_session < 3600
Unknown column 'start_session' in 'where clause'

DB Error: Bad SQL Query: INSERT INTO ibf_sessions (id, member_name, member_pass, member_id, ip_address, start_session, location) VALUES ('222b5f35e0cec5f9725300000804ebc3', '', '', '-1', '202.156.2.92', 1037097025, 'index.php')
Unknown column 'member_pass' in 'field list'

DB Error: Bad SQL Query: SELECT s.member_id, s.start_session, s.ip_address, u.id, u.mgroup, u.name FROM ibf_sessions s LEFT JOIN ibf_members u ON (u.id = s.member_id) WHERE s.start_session >= 1037096726 ORDER BY u.id ASC, s.ip_address ASC
Unknown column 's.start_session' in 'field list'

[silversurfer]

Hi. If I login from 4images, I get redirected to ibf. That to me shouldn't be the case. If I log in from 4images, I should be redirected back to 4images and vice versa. I know this means we have to mod invision code. Anyone has already done it and would like to share the method?