[Bridge]vBulletin user and skin integration

calash · 2007-02-21T18:23:18Z

Title: vBulletin to eFiction bridge/vBulletin template export to eFictionDescription: This mod contains two parts. The first is a user bridge that will replace the eFiction user tables with the vBulletin user tables. The second part of this mod is an eFiction skin that will load vBulletin templates into tpl variables. This way you can maintain a constant look across your entire site.Requirements: eFiction 3.3 or highervBulletin 3.6 or highervBulletin bridge must be installed for template exporting skin to work.Example:This mod is based on Tammy's SMF bridge that was supplied with eFiction 3.0 (Thank you Tammy :) ). It replaces the author tables with the vBulletin user tables, and uses the forum session information to handle login and logout.The mod is split into 2 parts. The core is the user table integration that handles all of the login and session data. The other is a skin sharing system that will pull templates from vBulletin and use them in a standard eFiction skin. Both mods require very few changes to ether scripts, instead relying on already established systems.Details of each mod will be provided in posts below to allow individual tracking of updates.Integration Notes: eFiction functions can easily be included into vBulletin by using the plugin system. By including corefunctions.php you gain access to several key functions that will help you add eFiction links into the forum area.Example - This plugin loads the corefunction.php file, and then loads a random story for use anywhere on the page. I have this running at the global_start hook.define ("_CHARSET", "ISO-8859-1");define("_BASEDIR", &quot("_PROFILEURL", &quot("/home/******/*******l/eFiction/includes/corefunctions.php");$ratings = 1;$ratlist = $vbulletin->db->query_read ("SELECT * FROM fanfiction_ratings");while($rate = $vbulletin->db->fetch_array($ratlist)) {$ratingslist[$rate['rid']] = array("name" => $rate['rating'], "ratingwarning" => $rate['ratingwarning'], "warningtext" => $rate['warningtext']);}$content = "";$randomqueryr =$vbulletin->db->query_read('SELECT stories.*,stories.sid, author.username as penname, UNIX_TIMESTAMP(stories.date) as date, UNIX_TIMESTAMP(stories.updated) as updated FROM (vb_user as author, fanfiction_stories as stories) WHERE author.userid = stories.uid AND stories.validated > 0 ORDER BY rand( ) DESC LIMIT 1');while($storiesr = $vbulletin->db->fetch_array($randomqueryr)){$content = "<br/><br /><div style='font-size:12px;'>".title_link($storiesr)." by:<a href="'"._PROFILEURL."$storiesr[uid"]'>$storiesr[penname]</a><br /><br />".truncate_text($storiesr[summary],70)."</div>";}$efic_rand = $content;All queries were modified to use vBulletin DB calls. With corefunction.php loaded at the start other queries become easier to format. For example, here is the code I use to show the story list in the profile page.$content="";$results = $vbulletin->db->query_read ("SELECT s.*, unix_timestamp(updated) from fanfiction_stories as s,vb_user as a WHERE a.userid = s.uid AND s.validated > 0 AND s.uid = $userinfo[userid] ORDER BY updated DESC");while ($story = $vbulletin->db->fetch_array($results)){ $content .="<div class='thead'>".title_link($story)." - ".ratingpics($story['rating'])." [<a href="'"._BASEDIR."reviews.php?type=ST&item=$story[sid"]'>Reviews - $story[reviews]</a>]<br /><span style='font-size:10px; font-weight:normal;'>(Wordcount: $story[wordcount] - Reads: $story[count]) - Published:$story[updated]</span></div>".truncate_text($story[summary],150)."<br /><br />"; } if ($content){$efic_mystory = $content;} else {$efic_mystory = "No Stories";}$efic_myseries = "TEST";Ignore the $efic_myseries part, it is the next step but has not been setup yet.

Page 5 / 5 Prev

Graveyard

Last Post by Anonymous 13 years ago

65 Posts

4 Users

0 Reactions

30.5 K Views

RSS

calash

(@calash)

Posts: 180

Estimable Member

Topic starter

It looks like you may be missing a " mark in the ectra_header.php file. The output you are seeing is the str_replace array that corrects some of the paths. Double check the code and see if anything is missing a " mark or a , at the end.

The World of Necrotania - Story Writing Community

Posted : 25/11/2008 9:41 am

guest6569

(@guest6569)

Posts: 0

Did anyone successfully integrate this? Cause I'm getting the blank page

Posted : 28/02/2010 9:33 pm

BlackFalcon

(@BlackFalcon)

Posts: 0

Just curious if this bridge works with the latest version of vBulletin (4.2)?

Posted : 19/06/2012 4:23 pm

guest11882

(@guest11882)

Posts: 0

Just curious if this bridge works with the latest version of vBulletin (4.2)?

The user bridge works fine.

I haven't tried the style bridge yet but I doubt that would work 'out of the box' due to the style changes from vBulletin 3 to 4.

I'll give it a try and let you know.

Posted : 15/07/2012 10:01 am

BlackFalcon

(@BlackFalcon)

Posts: 0

So what's the verdict?

Posted : 26/09/2012 4:25 am

Page 5 / 5 Prev

32 Forums
3,758 Topics
20.9 K Posts
0 Online
4,465 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Become a Patron!

[Bridge]vBulletin user and skin integration

Share this:

Like this: