mccode-v2 SMF Registration Intergration!!!!!

[PrimeSuspect]

Membership integration is ok for me but when i try to enter a topic or category i get tht errors ;

Unknown column 't.ID_TOPIC' in 'field list'

File: /home/xxxxxx/public_html/forum/Sources/MessageIndex.php

Line: 457

and

Unknown column 't.ID_BOARD' in 'where clause'

 

Also when i try to delete them in admin panel i get tht error ;

Unknown column 'ID_TOPIC' in 'field list'

File: /home/xxxxxx/public_html/forum/Sources/Subs-Boards.php

Line: 1203

Smf version : 1.1.12

[peterisgb]

i been trying to get this to work with SMF 2.0.2 with a few changes but i cant get it to work, has anyone done this yet, thanks

[rulerofzu]

Seen as the last post was over a year ago then I doubt it.

[Spudinski]

There are many o' scripts for this.

Google it.

[peterisgb]

if you google this this is the only thing that comes up.

[Spudinski]

*facepalm*

You don't specify MCCodes specifically.

[peterisgb]

erm..... all i need is the game register.php database code bit for auto making account for the forums like step 3.

[rulerofzu]

View the structure of the forum_members for SMF and then write the code to insert into it. Has the db structure for SMF changed?

[peterisgb]

er,,, well there is no db structure like that in the main one, i donknot how to get it to work in a seprate datbase

[rulerofzu]

There is a database for SMF so there is a database structure. Find what table holds the users.

[peterisgb]

well there is a forum database but its seprate from the main game database and the code on here trys and place the code into the same database as the game which its in another database......

[rulerofzu]

I would suggest you go back to pg1 read what it says as it most certainly does not say that.

[peterisgb]

i done those steps, its comes up that the table does not exsist when it does.

[Dominion]

i done those steps, its comes up that the table does not exsist when it does.

If you have just downloaded SMF it's no longer version 1. Version 2 is now the stable download, and this seems designed for v1?

[peterisgb]

If you have just downloaded SMF it's no longer version 1. Version 2 is now the stable download, and this seems designed for v1?

hense why i originally ask if anyone has done an update for this, in return for this i'll post a mod i have done,

[rulerofzu]

I just downloaded SMF. Your still looking for the members table. Following the instructions on the first page making sure the prefix is forum_

# Table structure for table `members`

#

 

CREATE TABLE {$db_prefix}members (

id_member mediumint(8) unsigned NOT NULL auto_increment,

member_name varchar(80) NOT NULL default '',

date_registered int(10) unsigned NOT NULL default '0',

posts mediumint(8) unsigned NOT NULL default '0',

id_group smallint(5) unsigned NOT NULL default '0',

lngfile varchar(255) NOT NULL default '',

last_login int(10) unsigned NOT NULL default '0',

real_name varchar(255) NOT NULL default '',

instant_messages smallint(5) NOT NULL default 0,

unread_messages smallint(5) NOT NULL default 0,

new_pm tinyint(3) unsigned NOT NULL default '0',

buddy_list text NOT NULL,

pm_ignore_list varchar(255) NOT NULL default '',

pm_prefs mediumint(8) NOT NULL default '0',

mod_prefs varchar(20) NOT NULL default '',

message_labels text NOT NULL,

passwd varchar(64) NOT NULL default '',

openid_uri text NOT NULL,

email_address varchar(255) NOT NULL default '',

personal_text varchar(255) NOT NULL default '',

gender tinyint(4) unsigned NOT NULL default '0',

birthdate date NOT NULL default '0001-01-01',

website_title varchar(255) NOT NULL default '',

website_url varchar(255) NOT NULL default '',

location varchar(255) NOT NULL default '',

icq varchar(255) NOT NULL default '',

aim varchar(255) NOT NULL default '',

yim varchar(32) NOT NULL default '',

msn varchar(255) NOT NULL default '',

hide_email tinyint(4) NOT NULL default '0',

show_online tinyint(4) NOT NULL default '1',

time_format varchar(80) NOT NULL default '',

signature text NOT NULL,

time_offset float NOT NULL default '0',

avatar varchar(255) NOT NULL default '',

pm_email_notify tinyint(4) NOT NULL default '0',

karma_bad smallint(5) unsigned NOT NULL default '0',

karma_good smallint(5) unsigned NOT NULL default '0',

usertitle varchar(255) NOT NULL default '',

notify_announcements tinyint(4) NOT NULL default '1',

notify_regularity tinyint(4) NOT NULL default '1',

notify_send_body tinyint(4) NOT NULL default '0',

notify_types tinyint(4) NOT NULL default '2',

member_ip varchar(255) NOT NULL default '',

member_ip2 varchar(255) NOT NULL default '',

secret_question varchar(255) NOT NULL default '',

secret_answer varchar(64) NOT NULL default '',

id_theme tinyint(4) unsigned NOT NULL default '0',

is_activated tinyint(3) unsigned NOT NULL default '1',

validation_code varchar(10) NOT NULL default '',

id_msg_last_visit int(10) unsigned NOT NULL default '0',

additional_groups varchar(255) NOT NULL default '',

smiley_set varchar(48) NOT NULL default '',

id_post_group smallint(5) unsigned NOT NULL default '0',

total_time_logged_in int(10) unsigned NOT NULL default '0',

password_salt varchar(255) NOT NULL default '',

ignore_boards text NOT NULL,

warning tinyint(4) NOT NULL default '0',

passwd_flood varchar(12) NOT NULL default '',

pm_receive_from tinyint(4) unsigned NOT NULL default '1',

PRIMARY KEY (id_member),

KEY member_name (member_name),

KEY real_name (real_name),

KEY date_registered (date_registered),

KEY id_group (id_group),

KEY birthdate (birthdate),

KEY posts (posts),

KEY last_login (last_login),

KEY lngfile (lngfile(30)),

KEY id_post_group (id_post_group),

KEY warning (warning),

KEY total_time_logged_in (total_time_logged_in),

KEY id_theme (id_theme)

) ENGINE=MyISAM;

Changes from what I can see is memberName is now member_name and there is a password salt. Passwords are still SHA1

Now looking at the files.

A quick look I found

$user_settings['password_salt'] = substr(md5(mt_rand()), 0, 4);

As it is creating a different salt for each login and setting a cookie. I dont believe you have to take this into account for intergration unless you wish them to be auto logged into SMF in which case you will need to have a look at the loginout.php file and take into account the setLoginCookie function.

For auto login for SMF you would on the login to your game set the cookie and insert the salt into the SMF members table.

[rajjak24]

This is pretty much what I need but for AVArcade 5.5 any ideas how I can acomplish this?

[peterisgb]

This mod works perfect, is there an auto login into the forums when going from the game?

[KyleMassacre]

This mod works perfect, is there an auto login into the forums when going from the game?

Sniko also did something for smf integration and this question was brought up but I dont think there was a definate answer but here is what I think may work. In authenticate.php maybe you can set the session that is used for smf.

Also smf has an option to always stay logged into the forums when they login and I noticed in Dayos original post he mentions that it wont convert over you existing users, well I made a script that you can run that will import the users over as well

Here is the link to the script. Just make sure you edit it to suit http://pastebin.com/cv1cRy0b

Edited March 23, 2013 by KyleMassacre

[peterisgb]

yeah i used that and it worked a charm, thanks for replpost it lol, its a good code. i'll have to look into it, if i get anywhere i'll post here.