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!

[Swedie]

Originally Posted by laeth

http://gothtopic.com/forum/member.php?userid=2

Is there anyway to set how large the tables are? They seem to be larger than what we have the forum set to, and it looks out of place.

Thanks.

Requires registration...

[Acido]

After Upgrade to 3.0.7 i loss the Option (Under Vbulletín Options) "Guestbook / Webpage Preferences" and the hack is not working.

I'm sure that all templates, and files edits are OK. Can you tell me what query i need run again to have this hack working ?

Thanx in advance.

[Lizard King]

Originally Posted by Acido

After Upgrade to 3.0.7 i loss the Option (Under Vbullet?n Options) "Guestbook / Webpage Preferences" and the hack is not working.

I'm sure that all templates, and files edits are OK. Can you tell me what query i need run again to have this hack working ?

Thanx in advance.

Run this queries

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);

[Acido]

That's Work Perfectly.

Thanx Amigo

[cdoyle]

I'm trying to install it, and when I run the insert.sql this is the error I get

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';

CREATE TABLE `user_webpage` (
`userid` int(11) NOT NULL

Does anyone know what I"m doing wrong?

[cdoyle]

Anyone have any ideas why I keep getting that error?

[Swedie]

Originally Posted by cdoyle

I'm trying to install it, and when I run the insert.sql this is the error I get


An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';

CREATE TABLE `user_webpage` (
`userid` int(11) NOT NULL



Does anyone know what I"m doing wrong?

The insert should look like this:

CREATE TABLE `user_webpage` (
`userid` int(11) NOT NULL default '0',
`name` varchar(100) default '',
`description` varchar(255) default '',
`text` text,
`lastupdate` varchar(20) default '',
`bordersize` smallint(6) NOT NULL default '5',
`bordercolor` varchar(10) NOT NULL default '#EDF0FF',
`bgcolor` varchar(10) default '#FFFFFF',
`fontface` varchar(100) NOT NULL default 'Arial, Helvetica',
`fontcolor` varchar(10) NOT NULL default '#000000',
`fontsize` char(3) NOT NULL default '2',
`vbcodeorhtml` varchar(10) NOT NULL default 'vbcode',
`usesmilies` smallint(6) NOT NULL default '1',
`hits` int(11) NOT NULL default '5',
PRIMARY KEY (`userid`)
) TYPE=MyISAM;

What are you running this SQL command through? I hope it is not the vBulletin area.

[Swedie]

I have identified a bug with the current version. If you post a ' (that character) and tries to post anything again in that guestbook it won't enter, so don't do that for now. The new version will have this issue resolved.

I am testing version 1.0.2 on my own site and I'm just collceting a bit more input before releasing it to you all.

[cdoyle]

Ya I was trying to use the admin area, I used myphp and got it to work.

but doh, just noticed your post about hte bug in 1.01.
Hopefully it will be easy to upgrade from 1.0.1 to 1.0.2

thanks again for this hack, it's great!!

[Swedie]

Originally Posted by cdoyle

Ya I was trying to use the admin area, I used myphp and got it to work.

but doh, just noticed your post about hte bug in 1.01.
Hopefully it will be easy to upgrade from 1.0.1 to 1.0.2

thanks again for this hack, it's great!!

Yes, very easy. Just a few replacement codes and new templates.