Name of code: sqlbb
Date of release: 10/16/2004

Description of the code, number of objects, its functions, $commands it
defines, etc.: The SQLBB object contains commands to tie into a phpnuke site.  Assuming that you have the phpnuke db as your default sql db in penn and assuming that you have nuke_ as your db prefix.

It also contains the modified commands for Myrddin's Global BBS v4.0.6


Code Author:Impster
Email Address:impster667@cox.net

"As used on" this MUSH, if any:Excalibur.kyndig.com 6670

Server required for code: pennmush & mysql
Patchlevel/version of server required/tested on: 1.7.7p38
Privileges required: sqlbb should be set wizard.  If you wish to use the journal command then you might want to place it in your master room

Terms of code use: Feel free to use it pass it around but don't blame me if it blows something up.
Support policy: none

Installation instructions:

First off, this is the first code I've released into the public.  It's ugly and I imagine there are better ways of doing these commands.  But I it works ;).  

The first thing I would do is create another forum category in PHPNuke.  At http://excalibur.kyndig.com it's the #2 forum. If you use something other than 2 then you'll want to change "setq(y,sql(select forum_id from nuke_bbforums where forum_name ='%qz' AND cat_id='2'))" in CMD.BBPOST.SQL to the forum number.  You'll also need to adjust TRI_SQLNEWGROUP to the new number as well. It's the second value in the value() string.  The next thing you'll need to do is add a new field to nuke_users called Dbref.  This will hold the player's objid number.

Once you have the catid set in PHPNuke you'll need to add the forum name.  These need to match your Myrddin forum names exactly.  Once you have updated Myrddin's CMD_+BBNEWGROUP any new group should be added to your sql db automatically.  Though you'll still need to set your forum permission in PHPNuke.

Personally I have my Myrddin forums set as readonly in PHPNuke because this system only adds new posts to the db.  It doesn't update any edits, deletes, or moves.  This system did what I wanted for now so I didn't work on the others.  But this should hopefully help someone get a jump on it if they wanted to add those commands.  Also it doesn't take messages from PHPNuke and post them in the BB.  Which is the other reason I've set the forums to readonly.

I've also thrown in a bonus command, +journal.  This will allow someone to update their phpnuke journal from the mush. +journal title=text.


Help instructions:

The limitation on this system is the users need an account on the phpnuke system.  As such I've placed a lock on the BBS object to check if they're registered.  The player needs to have used the +register command from SGP Sandbox which I've included and then performed a +bbnuke <password> which updates the database with their objid number.

Once they have +registered and used the +bbnuke then you can set the players to !unregistered.  Until they perform those steps they should not be allowed to use the BBS system as it will cause problems placing the post in PHPnuke.

The DB#'s you'll need to change to match your system are:
#86=bbpocket
#155=sqlbb