vb.org Archive - Major Additions - Share users database among many forums

Page 2 of 14

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)

- - Major Additions - Share users database among many forums (https://vborg.vbsupport.ru/showthread.php?t=185021)

Lionel

07-11-2008 09:16 PM

Session is useful only if it's for different forums from the same site. It will avoid double login and keep who's online synchronized.

In the example above, I remembered that I had to do those 2 changes also (version 3.60) since they appeared to be independent from class_core

Quote:

In adminfunctions.php print_delete_confirmation you also need to specify the below (insert it somewhere) or it will switch to default and you will not be able to delete any usergroups. (I don't use prefixes so I have " . ")

case 'usergroup':
$item = $vbulletin->db->query_first("
SELECT usergroupid, title
FROM " . "usergroup
WHERE usergroupid = '" . $vbulletin->db->escape_string($itemid) . "'
");
break;

also in functions.php copy function fetch_query_sql into function fetch_query_sql2 . alter that copy by replacing the 2 instances of " . TABLE_PREFIX . to reflect your master prefix.

Then in usergroup.php call that fetch_query_sql2 instead of fetch_query_sql (many instances)

Q-v-n-s-Q

07-11-2008 09:23 PM

nice, thank you

Adrian Schneider

07-11-2008 09:42 PM

Quote:

Originally Posted by mangel.ajo (Post 1573069)

Hmmm, if database can gives us that functionality it could be interesting because we wouldn't need to patch at all.

Can you point us to some document about mysql5 views?

How do you setup a view?

Greetings,
Miguel ?ngel.

I gave a more concrete example in this thread.

mangel.ajo

07-11-2008 09:46 PM

Quote:

Originally Posted by Lionel (Post 1573084)

Session is useful only if it's for different forums from the same site. It will avoid double login and keep who's online synchronized.

Yes, for the same site it's ok. In my config I have different domain names. So I should keep session table independently

[QUOTE]

Quote:

Originally Posted by Lionel (Post 1573084)

In the example above, I remembered that I had to do those 2 changes also (version 3.60) since they appeared to be independent from class_core

I have tried to create/delete a usergroup from admincp in the secondary forum, and it worked fine, so I suppose that this change is not needed anymore (at least for 3.7.2PL1) :-)

Thanks Lionel! :)

mangel.ajo

07-11-2008 09:52 PM

I doubt if those tables are safe to be shared: "reputation","spamlog"

They point to postid, and probably they would only mess. What do you think about that? Should I take them out?

Lionel

07-11-2008 09:56 PM

I never used "reputation" and "spamlog" in the other integration 3.07 => 3.60 from 2 years ago.

Hornstar

07-11-2008 11:34 PM

This will just be duplicate content in search engines. If you think this is going to give you extra exposure your right, however at what cost? getting dropped from the search engines.

There is need for this tho, and only in some situations, eg. maybe you got a support board that is for registered users only and you have a few websites, then that would be useful.

Thanks for sharing, I do look forward to seeing this progress, however I currently don't have that need for it like some sites do. Just for the other sites who think great I can now have several domains but with the same forums showing, this is a really bad idea.

mangel.ajo

07-12-2008 07:25 AM

Quote:

Originally Posted by hornstar1337 (Post 1573186)

This will just be duplicate content in search engines. If you think this is going to give you extra exposure your right, however at what cost?

Code:

User-Agent: * 

Disallow: /forum/memberlist.php

Disallow: /forum/member.php

What I want is not to get my members indexed, the real intention of this patch is to make my users life easier to move between forums.

Greetings honstar1337!

Hornstar

07-12-2008 10:18 PM

Quote:

Originally Posted by mangel.ajo (Post 1573390)

Code:

User-Agent: * 

Disallow: /forum/memberlist.php

Disallow: /forum/member.php

What I want is not to get my members indexed, the real intention of this patch is to make my users life easier to move between forums.

Greetings honstar1337!

I must have been really tired when I made that post lol. I can now see a much larger purpose for this mod. (I was thinking something much different yesterday lol).

I might actually end up using this afterall. Thanks.

Super Jinni

07-13-2008 02:00 AM

this is really interesting and something that I was thinking about since a while..

I'm gonna keep an eye on this, and maybe I'm gonna use it soon for some reason

thanks for sharing man

best regards

:)

All times are GMT. The time now is 03:41 PM.

Page 2 of 14

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01175 seconds Memory Usage 1,745KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: