<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><BR><DIV><DIV>On Sep 28, 2006, at 10:13 PM, Rodney Blackwell wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">On 9/28/06, Ben Wilson <<A href="mailto:dausha@gmail.com">dausha@gmail.com</A>> wrote:</DIV> <BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">I believe AuthUserDbase (or XesAuthUserDbase) will allow you to use</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">the vBulletin board user table. I finally got AuthUserDbase to work</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">(still need to publish the code), after allowing it to sit tantalizing</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">for a few months. In the interim, Xes co-opted the code, fixed it and</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">improved on it.</DIV> </BLOCKQUOTE><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Thanks for the point in the right direction, Ben :)</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Are there any published instructions (that you or anyone else knows</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">of), that explain how to take the AuthUserDbase (or XesAuthUserDbase)</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">and adapt it for a vbulletin forum?</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">I saw a user Tim had snippet of code posted here:</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="http://article.gmane.org/gmane.comp.web.wiki.pmwiki.user/21703/match=vbulletin">http://article.gmane.org/gmane.comp.web.wiki.pmwiki.user/21703/match=vbulletin</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">But I wasn't able to dicern whether this was the finished working code or not.</DIV></BLOCKQUOTE></DIV><BR><DIV>I think it's relatively simple for AuthUserDbase.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>1) look at the database for vbulletin</DIV><DIV>2) grab the name of the database & table</DIV><DIV>3) get the names of the "fields" that have the username and the password</DIV><DIV>4) make sure you have the connection info for the database server (you needed this to install vbulletin!)</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>I have no idea if the database encryption is md5 or sha1 (or crypt() or...)</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Follow these instructions (derived from <A href="http://www.pmwiki.org/wiki/Cookbook/AuthUserDbase">http://www.pmwiki.org/wiki/Cookbook/AuthUserDbase</A>):</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Add to config.php:</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>$AUDBaseEncryption = ''; // either md5 (default) or sha1 -- if md5 you can leave this out</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>$AUDBaseDBase = array(</DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>'host' => 'yourdatabasehost',</DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>'db' => 'thedatabasename',</DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>'user' => 'databaseusername',</DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>'password' => 'yourdatabasepassword'</DIV><DIV>);</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>$AUDBaseTable = array(</DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>'table' => 'thetablename',</DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>'userfield' => 'fieldcontainingusername',</DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>'pwfield' => 'passwordfieldname'</DIV><DIV>);</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>// use correct filenames! I'm tired and lazy</DIV><DIV><FONT class="Apple-style-span" face="Arial" size="4"><SPAN class="Apple-style-span" style="font-size: 14.7px;">include_once("/path/to/cookbook/authuserdbase.php");</SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Arial" size="4"><SPAN class="Apple-style-span" style="font-size: 14.7px;">include_once("/path/to/scripts/authuser.php");</SPAN></FONT><FONT class="Apple-style-span" face="Arial" size="4"><SPAN class="Apple-style-span" style="font-size: 14.7px;"></SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Arial" size="4"><SPAN class="Apple-style-span" style="font-size: 14.7px;"><BR class="khtml-block-placeholder"></SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Arial" size="4"><SPAN class="Apple-style-span" style="font-size: 14.7px;"><BR class="khtml-block-placeholder"></SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Arial" size="4"><SPAN class="Apple-style-span" style="font-size: 14.7px;">That should do it, except for the change to Site.AuthUser -- see the AuthUserDbase documentation for what to do.</SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Arial" size="4"><SPAN class="Apple-style-span" style="font-size: 14.7px;"><BR class="khtml-block-placeholder"></SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Arial" size="4"><SPAN class="Apple-style-span" style="font-size: 14.7px;"><BR class="khtml-block-placeholder"></SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Arial" size="4"><SPAN class="Apple-style-span" style="font-size: 14.7px;">I think that's all you need?</SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Arial" size="4"><SPAN class="Apple-style-span" style="font-size: 14.7px;"><BR class="khtml-block-placeholder"></SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Arial" size="4"><SPAN class="Apple-style-span" style="font-size: 14.7px;">Crisses</SPAN></FONT></DIV></BODY></HTML>