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!

[oldfan]

this is crazy, I run swedies command and tried to the sql in the zip and I get this error

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

What I'm I doing wrong now

[seangworld]

wow, didn't know you released it. ok, time for me to try this bad boy out!

[Loki12]

Originally Posted by oldfan

this is crazy, I run swedies command and tried to the sql in the zip and I get this error

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

What I'm I doing wrong now

It means you'll have to delete the old sql entries on your database before re-running the script again.

[Loki12]

Originally Posted by seangworld

wow, didn't know you released it. ok, time for me to try this bad boy out!

Good luck... you'll need it!

[oldfan]

Isn't what this does?

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

Originally Posted by Loki12

It means you'll have to delete the old sql entries on your database before re-running the script again.

[Marco van Herwaarden]

Well this would only delete a row if in 1 row the field 'varname' would have the value 'setting_allowguestbook_desc' AND 'setting_allowguestbook_title' AND ..... at the same time.

This will never be the case.

Think you might be better of replacing those 'AND's by 'OR'.

[Swedie]

Originally Posted by Wordplay

swedie how is that update coming?

Only received one donation so far. I aint busting anything to update. But I will look at it some time this week.

[Swedie]

Originally Posted by KirbyDE

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

When you pay me $100.

[Swedie]

Originally Posted by MarcoH64

Well this would only delete a row if in 1 row the field 'varname' would have the value 'setting_allowguestbook_desc' AND 'setting_allowguestbook_title' AND ..... at the same time.

This will never be the case.

Think you might be better of replacing those 'AND's by 'OR'.

oh crap! that's right. Sorry oldfan. This is what it should look like:

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

[oldfan]

I'm going to donate as soon as I get this working
Everything was going good until I hit this error


Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE vB3usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'xxxxxxx',
description = 'xxxxx',
usertitle = 'xxxxx',
opentag = '',
closetag = '',
passwordexpires = '0',
passwordhistory = '0',
attachlimit = '0',
avatarmaxwidth = '80',
avatarmaxheight = '80',
avatarmaxsize = '20000',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '65535',
pmquota = '50',
pmsendmax = '5',
uttstore_discount = '0',
forumpermissions = '61555',
pmpermissions = '0',
calendarpermissions = '16',
wolpermissions = '0',
adminpermissions = '0',
genericpermissions = '4162',
genericoptions = '30',
arcadepermissions = '1'
WHERE usergroupid=2
mysql error: Unknown column 'pmpermissions' in 'field list'

mysql error number: 1054

Date: Monday 08th of November 2004 01:03:55 PM
Script: http://xxxxxxxx/admincp/usergroup.php
Referer: http://xxx/xxx/xxxxxx/usergroup.php?...&usergroupid=2
Username: xxxxxxx
IP Address: xxxxxxxx