Integrate vB with portal script

http://www.fudgecakedesign.co.uk/justforyou/

Take a look - it's something i'd looked at before, but now it's totally free to download

I wonder if one of you experts might take a look at it and let me know if it's possible to integrate the member database of both systems, so that our users simply register once for the whole community - and get to personalise the lot

Anyone ? Or maybe this is something which John/James might wish to investigate once V2.0 is out ?

Thank you Thank you Thank you

I think I have fallen in love with your for that link

I have been working on something similar for weeks and did not like the results I was getting.

Thank you

The Just for You script uses a mySQL database so in theory they would be easy to integrate. The problem is that I don't have a copy of vBulletin.

I'll have a go if someone could email me the format of vBulletin's user database/table.

Many thanks,
Peter.

isn't this going to be in 2.0.0?

I believe that there will be a facility to personalise the forums in the new release... but not the ability to personalise the front page of the main website. However, I feel that there is a big demand for a full community suite - forum, articles, links, news headlines grabber, homepage peronalisation, etc, etc. - all based around a central membership system, so maybe John/James are considering something like this ?

Peter,
That sounds great, but i'm no expert, else i'd have a go myself - I could send you the whole script, but I am sure that's against the rules, so i'll have to let someone who knows vB take a look at it if they are interested in this. And, rather than hack vB, I feel it'd be far better to amend Just For You to fit with the existing structure set by vB. The reason being that, once I had this up and running, i'd not expect to make any changes to it... whereas i'll be updating vB every time a new release comes out...

Glad others are interested in it though...

Peter, just saw your sig and realised that you are 'Mr Fudgecake' himself...

Might it be possible to incorporate some standard membership system between these teo products in a future release ? I see at the moment that this script is now freeware, well if the two systems could be tied in - with active forum topics, etc. as an option in the personalisation system, then I feel sure that you would attract paying customers. (hint, hint...)

It shouldn't be too hard to change, as user database queries are limited to 6 or 7 pages (at a quick glance).

The user table structure follows:

CREATE TABLE user (
   userid int(10) unsigned NOT NULL auto_increment,
   usergroupid smallint(5) unsigned NOT NULL,
   username varchar(50) NOT NULL,
   password varchar(50) NOT NULL,
   email varchar(50) NOT NULL,
   parentemail varchar(50) NOT NULL,
   coppauser smallint(6) NOT NULL,
   homepage varchar(100) NOT NULL,
   icq varchar(20) NOT NULL,
   aim varchar(20) NOT NULL,
   yahoo varchar(20) NOT NULL,
   biography mediumtext NOT NULL,
   signature mediumtext NOT NULL,
   adminemail smallint(6) NOT NULL,
   showemail smallint(6) NOT NULL,
   invisible smallint(6) NOT NULL,
   usertitle varchar(250) NOT NULL,
   customtitle smallint(6) NOT NULL,
   joindate int(10) unsigned NOT NULL,
   canpost smallint(6) NOT NULL,
   cookieuser smallint(6) NOT NULL,
   daysprune smallint(6) NOT NULL,
   lastvisit int(10) unsigned NOT NULL,
   lastactivity int(10) unsigned NOT NULL,
   lastpost int(10) unsigned NOT NULL,
   posts smallint(5) unsigned NOT NULL,
   timezoneoffset smallint(6) NOT NULL,
   emailnotification smallint(6) NOT NULL,
   PRIMARY KEY (userid),
   KEY idxgroups (username, usergroupid)
);

I don't think there'd be any objections to me posting this, as a good section of this structure can be obtained from alternative *cough*error->view source*cough* methods.

is this similar to PHP Nuke ?? because I have already integrated the membership of Nuke and vB (lite)

Hi all, I have the same sort of problem.

My site is completely database driven (mySQL), excluding vBulleting the db size is around 10mb at the mo. Site url http://www.e-tones.co.uk

I have nearly 5000 registered members (100+ new ones each day, whay! ) however my bulletin has only 300 members, buts its growing pretty quick

I have lots of confused visitors who try to post using their site login details.

Would it be possible to maybe perform a join of my 'people' table and the vbulletin 'user' table ? Or would both need to be merged, if they do I can see problems occuring...

Please help, I need you <G>

Thanks for the user table info Stallion.

As I don't have the full vBulletin script myself perhaps someone could explain what the following fields mean and the parameters that they take?

The ones I need more information on are:

usergroupid
parentemail
coppauser
adminemail
usertitle & customtitle
daysprune
idxgroups

Short explanations of these would speed up my coding enormously.

Cheers,
Peter.