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!

[hasan2k]

Hey Swedie

I have not heard from you. I sent two emails. Please respond.

[Swedie]

Originally Posted by hasan2k

Hey Swedie

I have not heard from you. I sent two emails. Please respond.

If everyone remember, I had a date a while ago. And well, she's been here at my place for the last week. I've been "busy" with all of what that means.

[Lionel]

way to go swedie :up:

relax all you can and come back with some more hacks. :lick:

[Benj]

Originally Posted by Lionel

way to go swedie :up:

relax all you can and come back with some more hacks. :lick:

cheeky bugger :banana: :laugh:

[Wordplay]

swedie how is that update coming?

[Andreas]

Some things I'd like to see

• Full-featured editor
• Guestbook-entries on a separate page, with pagination
• Possibility to edit entries
• Notification when there is a new entry (PM/eMail)
• Moer usergroup permissions: Can post in other guestbooks, Can edit own guestbook, Can edit own entries, Can edit other users guestbooks, Can delete own entries, Can delete entries in own guestbook, Can delete entries in other users guestbooks

[Loki12]

I deleted everything the first sql query did via phpMyadmin, and re-run the queries. Now it is working, and everything showing up.

*Loki12 clicks install!

[oldfan]

I did what you said and I got this error
MySQL said:
#1062 - Duplicate entry 'setting_allowguestbook_desc-1-5000' for key 2

Originally Posted by Swedie

oldfan! STOP!! right now! dude. what you doing. If you don't know how to do it, then please don't make your own attempts of "reversing" it with your guessing.

Run this .SQL and all YOU installed (using vB3 prefix on everything by mistake) will be erased. Then after that, you run the proper .SQL file coming with the .ZIP file in my first post.

PHP Code:

DROP TABLE `user_guestbook`; 
DROP TABLE `user_webpage`; 

ALTER TABLE vb3usergroup DROP canuseguestbook;
ALTER TABLE vb3usergroup DROP canusewebpage;

DELETE FROM vb3phrase WHERE varname = 'setting_allowguestbook_desc' AND varname = 'setting_allowguestbook_title' AND varname = 'setting_allowwebpage_title' AND varname = 'setting_allowwebpage_desc' AND varname = 'settinggroup_guestbookwebpage' AND varname = 'setting_webpagevbcode_desc' AND varname = 'setting_guestbooksmilies_desc' AND varname = 'setting_webpagevbcode_title' AND varname = 'setting_webpagesmilies_title' AND varname = 'setting_guestbooksmilies_title' AND varname = 'setting_webpagesmilies_desc' AND varname = 'setting_webpagehtml_title' AND varname = 'setting_webpagehtml_desc' AND varname = 'can_use_guestbook' AND varname = 'can_use_webpage' AND varname = 'setting_allowedhtmltags_title' AND varname = 'setting_allowedhtmltags_desc' AND varname = 'edit_webpage_content' AND varname = 'edit_guestbook_settings';

DELETE FROM vb3settinggroup WHERE grouptitle = 'guestbookwebpage';

DELETE FROM vb3setting WHERE grouptitle = 'guestbookwebpage'; 


[Loki12]

Originally Posted by oldfan

I did what you said and I got this error
MySQL said:
#1062 - Duplicate entry 'setting_allowguestbook_desc-1-5000' for key 2

Then it probably means you have not ran this command Swedie gave:

DELETE FROM vb3phrase WHERE varname = 'setting_allowguestbook_desc' AND varname = 'setting_allowguestbook_title' AND varname = 'setting_allowwebpage_title' AND varname = 'setting_allowwebpage_desc' AND varname = 'settinggroup_guestbookwebpage' AND varname = 'setting_webpagevbcode_desc' AND varname = 'setting_guestbooksmilies_desc' AND varname = 'setting_webpagevbcode_title' AND varname = 'setting_webpagesmilies_title' AND varname = 'setting_guestbooksmilies_title' AND varname = 'setting_webpagesmilies_desc' AND varname = 'setting_webpagehtml_title' AND varname = 'setting_webpagehtml_desc' AND varname = 'can_use_guestbook' AND varname = 'can_use_webpage' AND varname = 'setting_allowedhtmltags_title' AND varname = 'setting_allowedhtmltags_desc' AND varname = 'edit_webpage_content' AND varname = 'edit_guestbook_settings';

Remember that your table will not necessarily be called "vb3phrase". Mine is simply called "phrase". I suggest going into the "phrase" table via phpMyadmin, and manually delete the specific phrase, then try again.

[oldfan]

I did run that command...

ALTER TABLE vB3usergroup DROP canuseguestbook;# Affected rows:9
ALTER TABLE vB3usergroup DROP canusewebpage;# Affected rows:9
DELETE FROM vB3phrase WHERE varname = 'setting_allowguestbook_desc' AND varname = 'setting_allowguestbook_title' AND varname = 'setting_allowwebpage_title' AND varname = 'setting_allowwebpage_desc' AND varname = 'settinggroup_guestbookwebpage' AND varname = 'setting_webpagevbcode_desc' AND varname = 'setting_guestbooksmilies_desc' AND varname = 'setting_webpagevbcode_title' AND varname = 'setting_webpagesmilies_title' AND varname = 'setting_guestbooksmilies_title' AND varname = 'setting_webpagesmilies_desc' AND varname = 'setting_webpagehtml_title' AND varname = 'setting_webpagehtml_desc' AND varname = 'can_use_guestbook' AND varname = 'can_use_webpage' AND varname = 'setting_allowedhtmltags_title' AND varname = 'setting_allowedhtmltags_desc' AND varname = 'edit_webpage_content' AND varname = 'edit_guestbook_settings';# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM vB3settinggroup WHERE grouptitle = 'guestbookwebpage';# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM vB3setting WHERE grouptitle = 'guestbookwebpage';# MySQL returned an empty result set (i.e. zero rows).

I got the error when I tried the install the sql in the new zip

Originally Posted by Loki12

Then it probably means you have not ran this command Swedie gave:




Remember that your table will not necessarily be called "vb3phrase". Mine is simply called "phrase". I suggest going into the "phrase" table via phpMyadmin, and manually delete the specific phrase, then try again.

ALTER TABLE vB3usergroup DROP canuseguestbook;# Affected rows:9
ALTER TABLE vB3usergroup DROP canusewebpage;# Affected rows:9
DELETE FROM vB3phrase WHERE varname = 'setting_allowguestbook_desc' AND varname = 'setting_allowguestbook_title' AND varname = 'setting_allowwebpage_title' AND varname = 'setting_allowwebpage_desc' AND varname = 'settinggroup_guestbookwebpage' AND varname = 'setting_webpagevbcode_desc' AND varname = 'setting_guestbooksmilies_desc' AND varname = 'setting_webpagevbcode_title' AND varname = 'setting_webpagesmilies_title' AND varname = 'setting_guestbooksmilies_title' AND varname = 'setting_webpagesmilies_desc' AND varname = 'setting_webpagehtml_title' AND varname = 'setting_webpagehtml_desc' AND varname = 'can_use_guestbook' AND varname = 'can_use_webpage' AND varname = 'setting_allowedhtmltags_title' AND varname = 'setting_allowedhtmltags_desc' AND varname = 'edit_webpage_content' AND varname = 'edit_guestbook_settings';# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM vB3settinggroup WHERE grouptitle = 'guestbookwebpage';# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM vB3setting WHERE grouptitle = 'guestbookwebpage';# MySQL returned an empty result set (i.e. zero rows).