Webpage & Guestbook Script

Webpage and Guestbook for vBulletin 3.0.x

This script installs a Webpage and a Guestbook on your users profile page.

Upcoming fixes:
* Adding leads to user's guestbooks via post icons.
* More? Send me suggestions by posting in this thread.

LATEST VERSION NEW FEATURES v1.0.4 - November 14th, 2005 (Re-released)
* Now comes with an easy to use installer that does all the database entries.
* Also includes an uninstaller (works even though you don't have version 1.0.4 installed)
* Includes upgrade from v1.03 to v1.04 (previous versions are left unsupported)
* Corrected some Javascript errors with the Editor.
* Optimized code (less rows)
* Smilie icon show when enabled in HTML mode
* Quick Edit works better and also updates Webpage name and Description.
- Added Cancel button
- Only show Quick Edit box when editing
* BUG for large Guestbooks fixed. (Altering of table)

NEW FEATURES v1.0.3
* Webpage editing is now improved and stable (had javascript error before)
(only need to update template modify_webpage and file profile.php with new code)

NEW FEATURES v1.0.2
* Admin edit ability
* Improved code
* Using more of CSS from vBulletin rather than through a control file
* FIXED: Removal / Editing of posts (includes a FIX file that you need to run ONCE)
* FIXED: Avatar now show when file based system is used.

(VERSION 1.02 .ZIP FILE HAS BEEN UPDATED! DOWNLOAD CURRENT FILE)

NEW FEATURES v1.0.1
* Added ability to edit or remove his/her guestbook entry within the default vB's timeout setting
* Lots more Usergroup settings (that actually work )
* Colors etc are changed from one configuration file (didn't add to vBulletin admin area because it was just too much for one settings page...)
* PM or Email Notification option, or none (Default option is set by Admin)
* HTML or vBcode when creating webpage content (not both)
* HTML is limited to Admin set HTML tags in the Administration area
* Language controlled through vB's Language system
* Option to display users Avatars (controllable FORCED sizing)
* Smilies option (On or Off)

Usergroup settings added
* Can have Webpage
* Can have Guestbook
* Can view Guestbook
* Can view Webpage
* Can post in Guestbook

------------------------------------------------------------------

THIS SCRIPT IS NOT FOR COMPLETE NEWBIES!
If you are not used to changing script code. Please let someone else do the job for you that know more 'scripting'.

This script requires modification to your database.

I take no responsibily as to what happens to your website after you install this script.

Good luck and I hope you enjoy my contribution!

[Snow]

Originally Posted by shortbus1662

the prefix is ostatesp_forum

Where are the experts when you need them?

I'm not sure, but could your table prefix actually be ostatespnotostatesp_forum (it just seems like a rather odd prefix to me, butI'm no expert). If you go into your phpMyadmin, and look at the list oftables on the left, you'll see the name of the table you need to use inthequeries. For example, my test forum has the table prefix tvb3. So myphrase table is actually tvb3_phrase. Therefore, in the queries itwould look like:

DELETE FROM `tvb3_phrase`WHEREvarname= 'setting_allowguestbook_desc';

Am I making sense? Sobasically, in phpmyadmin, look for the phrase table, make a note ofwhat it's called and do a search replace on the insert.sql filereplacing phrase with yourprefix_phrase, (do the same for thesettingtable and the settinggroup table) save and re-run. (sorry I'mterrible at explaining things)

[shortbus1662]

ostatesp_forum is the name of my database.

tables in that database are user_guestbook and user_webpage

all the other ones are vb_

that's all I know. I know nothing :disappointed:

[Oreamnos]

help!

i am upgrading from 3.0.6 to 3.0.7 and when i try to run upgrade.sql i get the following error:

 SQL-query:

ALTER TABLE user_webpage DROP usevbcode

MySQL said: Documentation
#1091 - Can't DROP 'usevbcode'. Check that column/key exists

everything worked fine in 306. any reason i am getting this error?

thanks

[Oreamnos]

do i have to re-install (run insert.sql) this and if so, will the previous data(webapges and guestbooks) remain?

[Lizard King]

I just upgraded to 3.0.7 and after the upgrade I just run the following queries and saved any guestbook phrases and now it is working again.

INSERT INTO `settinggroup` (grouptitle, displayorder, volatile) VALUES ('guestbookwebpage', 199, 1);

INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('allowguestbook', 'guestbookwebpage', '1', '1', 'yesno', 10, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('allowwebpage', 'guestbookwebpage', '1', '1', 'yesno', 20, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('guestbooksmilies', 'guestbookwebpage', '1', '1', 'yesno', 30, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('webpageallowvbcode', 'guestbookwebpage', '1', '1', 'yesno', 40, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('webpageallowhtml', 'guestbookwebpage', '1', '0', 'yesno', 50, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('webpagesmilies', 'guestbookwebpage', '1', '1', 'yesno', 60, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('webpagevbcodeorhtml', 'guestbookwebpage', 'vbcode', '1', '<select name=\\"setting[$setting[varname]]\\" tabindex=\\"1\\" class=\\"bginput\\">\n<option value=\\"vbcode\\" " . iif($setting[\'value\']==\'vbcode\',\'selected="selected"\') . ">$vbphrase[wg_vbcode]</option>\n<option value=\\"html\\" " . iif($setting[\'value\']==\'html\',\'selected="selected"\') . ">$vbphrase[wg_html]</option>\n</select>', 70, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('allowedhtmltags', 'guestbookwebpage', '<hr><a><br><b><h1><h2><h3><h4><i><img><li><ol><p><strong><table><tr><td><th><u><ul><font><b><div><center>', '<a><br><b><h1><h2><h3><h4><i><img><li><ol><p><strong><table><tr><td><th><u><ul><font><b><div><center>', 'textarea', 80, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('webpageadvanced', 'guestbookwebpage', '1', '1', 'yesno', 90, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('gb_notification', 'guestbookwebpage', 'pm', 'pm', '<select name=\\"setting[$setting[varname]]\\" tabindex=\\"1\\" class=\\"bginput\\">\n<option value=\\"no\\" " . iif($setting[\'value\']==\'no\',\'selected="selected"\') . ">$vbphrase[wg_no]</option>\n<option value=\\"pm\\" " . iif($setting[\'value\']==\'pm\',\'selected="selected"\') . ">$vbphrase[wg_sendpm]</option>\n<option value=\\"email\\" " . iif($setting[\'value\']==\'email\',\'selected="selected"\') . ">$vbphrase[wg_sendemail]</option>\n</select>', 100, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('gb_showavatar', 'guestbookwebpage', '1', '0', 'yesno', 110, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('gb_avatarheight', 'guestbookwebpage', '50', '50', '<input name=\\"setting[gb_avatarheight]\\" size=1 class=\\"bginput\\" value=\\"".$setting[\'value\']."\\">', 120, 0, 1);

Working with 3.0.7

[Lizard King]

Originally Posted by Oreamnos

do i have to re-install (run insert.sql) this and if so, will the previous data(webapges and guestbooks) remain?

If you didn't delete all guesbook and webpages data from your database then you dont have to re run the install.sql. Just make all the file edits and then run the queries I paste the previous post save any guestbook phrase , check your usergroup permissions and save them. After that you shall have the mod working again.

[Oreamnos]

cool, thanks! up and running again in 3.0.7

[animate]

any know when comes new version with installer?

[Creed]

Is there anyway that I could make the webpage show up standalone? Such as the profile having a link to their webpage, then webpage.php?memberid=x would display their webpage and guestbook? That would make it much cleaner on their profile, then members could use the webpage as their "homepage" on the web If it hasn't been done yet, I'm sure I could do it. It would just take me a while, no its not that I'm lazy its just that I'm checking to see if its been done yet.

[Lizard King]

Originally Posted by Creed

Is there anyway that I could make the webpage show up standalone? Such as the profile having a link to their webpage, then webpage.php?memberid=x would display their webpage and guestbook? That would make it much cleaner on their profile, then members could use the webpage as their "homepage" on the web If it hasn't been done yet, I'm sure I could do it. It would just take me a while, no its not that I'm lazy its just that I'm checking to see if its been done yet.

That is something I am looking for if you will code it I may want to make some of the tests