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!

[Wordplay]

first off, yeah the hack works perfectly fine if you install it correctly. i don't get how so many of y'all messed this up. i had a completely easy install, and everything worked form the start.

onlything that didn't work was deleting guestbook entries. but we got a fix for that now. thanks!

hey this is a completely out of the blue question. is it possible to count add every guestbook entry made to a user's post count. or what would be even better. i've got this shoutbox installed. it would be even better to add the count to that, but i guess you wouldn't want to go through all the trouble of making that possible since not everybody has the shoutbox installed.

[oldfan]

I've got the templates install and have set the permissions like the install says.
Everytime I got in admins permissions the webpage/guestbook are on "No", I then set it to "yes" and hit update.
The samething happens everything

look what I mean

http://bbs.metallifukinca.com/index.php?

test/test

[Lionel]

you probably have other hacks installed that are using the same bitfields number. Go back to init.php and verify that. If so, double the homepage bitfields values so they could be unique.

[oldfan]

Originally Posted by Lionel

you probably have other hacks installed that are using the same bitfields number. Go back to init.php and verify that. If so, double the homepage bitfields values so they could be unique.

thanks just tried that, I'm still getting the blank page

[Lionel]

But does it hold the permissions at least? Try to update them directly in mysql

[oldfan]

Originally Posted by Lionel

But does it hold the permissions at least? Try to update them directly in mysql

huh, what?
this is the tables is installed

# This creates all the database related
# tables and fields required for the
# webpage & guestbook script
#

CREATE TABLE `user_guestbook` (
`userid` varchar(100) NOT NULL default '',
`name` varchar(100) default '',
`lastentry` varchar(20) default '',
`status` char(3) NOT NULL default 'on',
`usesmilies` smallint(6) NOT NULL default '2',
`position` varchar(10) NOT NULL default 'right',
`text` text,
PRIMARY KEY (`userid`)
) TYPE=MyISAM;

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) default '5',
`bordercolor` varchar(10) default '#ECECEC',
`bgcolor` varchar(10) default '#FFFFFF',
`font` varchar(100) default 'Arial, Helvetica',
`fontcolor` varchar(10) default '#000000',
`fontsize` char(3) default '2',
`usehtml` smallint(6) NOT NULL default '1',
`usesmilies` smallint(6) NOT NULL default '1',
`usevbcode` smallint(6) NOT NULL default '1',
`hits` int(11) NOT NULL default '5',
PRIMARY KEY (`userid`)
) TYPE=MyISAM;

ALTER TABLE vB3usergroup ADD canuseguestbook SMALLINT NOT NULL;
ALTER TABLE vB3usergroup ADD canusewebpage SMALLINT NOT NULL;

UPDATE vB3usergroup SET canuseguestbook = '1';
UPDATE vB3usergroup SET canusewebpage = '1';

INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowguestbook_desc', 'Allow guestbook in your users guestbooks?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowguestbook_title', 'Enable Guestbook?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowwebpage_title', 'Enable Webpage?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowwebpage_desc', 'Allow users to create their own webpage using HTML (on their profile page)', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'settinggroup_guestbookwebpage', 'Guestbook / Webpage Preferences', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_webpagevbcode_desc', 'Allow vBcode on webpage?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_guestbooksmilies_desc', 'Allow smilies in guestbook?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_webpagevbcode_title', 'Webpage vBcode?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_webpagesmilies_title', 'Webpage Smilies?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_guestbooksmilies_title', 'Guestbook Smilies?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_webpagesmilies_desc', 'Allow Smilies on webpage?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_webpagehtml_title', 'Webpage HTML?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_webpagehtml_desc', 'Allow HTML on webpage? Be aware that this CAN cause security issues and "hacking" attempts.', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'can_use_guestbook', 'Can use Guestbook?', 3);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'can_use_webpage', 'Can use Webpage?', 3);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowedhtmltags_title', 'Webpage HTML tags allowed', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowedhtmltags_desc', 'Which HTML tags do you want to allow? (Leave empty to allow all)', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'edit_webpage_content', 'Webpage Content', 1);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'edit_guestbook_settings', 'Guestbook Settings', 1);

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

INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('allowguestbook', '1', 'yesno', 10, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('allowwebpage', '1', 'yesno', 20, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('guestbooksmilies', '1', 'yesno', 30, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('webpagevbcode', '0', 'yesno', 40, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('webpagesmilies', '0', 'yesno', 50, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('webpagehtml', '1', 'yesno', 60, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('allowedhtmltags', '<a><br><b><h1><h2><h3><h4><i><img><li><ol><p><str ong><table><tr><td><th><u><ul><font><b><div>', 'textarea', 70, 'guestbookwebpage', '<a><br><b><h1><h2><h3><h4><i><img><li><ol><p><str ong><table><tr><td><th><u><ul><font><b><div>', 0, 1);

[Lionel]

By looking at that db, I guess you'll have to read the posts. Your problem was addressed

[oldfan]

Originally Posted by Lionel

By looking at that db, I guess you'll have to read the posts. Your problem was addressed

Really? I most have missed it
Could you point out the page please/thank you ?

[Swedie]

Originally Posted by oldfan

Really? I most have missed it
Could you point out the page please/thank you ?

oldfan, you're using rex_b's SQL file. Where did you get that from? Download the latest .ZIP file and use the correct insert.SQL file. That will do the job.

Delete user_guestbook and user_webpage before you run the the SQL file though.

[Mickie D]

you dont think this maybe dangerous to give members html access ?

<a href="./../../../../../password/passwords.txt">click me</a>

just a thought ?

but then again i cant understand sweedish screenshots so i dunno what they all do ?