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!

[cdoyle]

Originally Posted by Swedie

Okay I am done with the admin edit feature. It is very simple, but it does its job. Nothing more. It is raw format edit. So this means you do not have the vBcode functions. It is not ment for admins to construct webpages while editing pages anyways.

I've named the feature "Quick Edit" and it is accessable straigth from the member's webpage (clickable button below page).

I'm not seeing this button, on my own page I made, or anyone elses?

any ideas?

Chris.

[Flow Fusion]

help...
I need to know how can I uninstall Table 'user_guestbook' already exists
Cause I need to remove and reinstall this hack.

Database error in vBulletin 3.0.7:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Administrators',
description = '',
usertitle = 'Administrator',
opentag = '',
closetag = '',
passwordexpires = '180',
passwordhistory = '360',
canhaveguestbook = '1',
canhavewebpage = '1',
canviewguestbook = '1',
canviewwebpage = '1',
canpostguestbook = '1',
shoutmaxdaily = '0',
shouthierarchy = '1',
attachlimit = '0',
avatarmaxwidth = '120',
avatarmaxheight = '120',
avatarmaxsize = '20000',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '65535',
pmquota = '200',
pmsendmax = '0',
forumpermissions = '393215',
pmpermissions = '2',
calendarpermissions = '31',
wolpermissions = '31',
adminpermissions = '3',
genericpermissions = '5504959',
genericoptions = '31',
journalpermissions = '2047',
awrequest = '1',
shoutboxpermissions = '1023'
WHERE usergroupid=6
mysql error: Unknown column 'canhaveguestbook' in 'field list'

mysql error number: 1054

Date: Friday 18th of March 2005 10:50:36 PM
Script: http://giftedsouls.com/gs/admincp/usergroup.php
Referer: http://giftedsouls.com/gs/admincp/us...&usergroupid=6
Username: Flow Fusion

[Lizard King]

If you are planning to reinstall you have to drop both user_webpage and user_guestbook tables. If you have phpmyadmin just login to it select the table user_webpage and drop the table and then select user_guestbook and drop that also.
Before the installation process be sure to check your phrases. If you have all the phrases then remove all the INSERT INTO `phrase` from insert.sql before running it.

[Flow Fusion]

Originally Posted by Lizard King

Before the installation process be sure to check your phrases. If you have all the phrases then remove all the INSERT INTO `phrase` from insert.sql before running it.

How do I do that?

Ok I dropped the tables now first off do I have to remove all of the phrases? And will the same error message occur cause I don't think the insert.iql file added the tables canviewwebpages and the canviewguestbook tables before.

[Lizard King]

Originally Posted by Flow Fusion

How do I do that?

Ok I dropped the tables now first off do I have to remove all of the phrases? And will the same error message occur cause I don't think the insert.iql file added the tables canviewwebpages and the canviewguestbook tables before.

If you didn't remove the phrases just run the attached install.sql

[Flow Fusion]

Error

SQL-query+:+


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',
`notification` varchar( 10 ) NOT NULL default 'no',
`showavatar` smallint( 6 ) NOT NULL default '0',
`text` text,
PRIMARY KEY ( `userid` )
) TYPE = MYISAM


MySQL said:


Table 'user_guestbook' already exists

Back

I tried to find it but I saw too many matches.

[Flow Fusion]

I figured it out. It was I had to add

'canpostownusernotes' => 32768,
'canpostothersusernotes' => 65536,
'caneditownusernotes' => 131072,
'canhaveguestbook' => 262144,
'canhavewebpage' => 524288,
'canviewwebpage' => 1045876,
'canviewguestbook' => 2097152,
'canpostguestbook' => 4194304,
'canseehiddencustomfields' => 8388608,

And do the math accordingly. Clicks install and thanks!

Someone needs to mention this in the first post.

[Jag]

You might want to make a mention that you have to edit the SQL file if you have a table prefix set.

Other than that, installed with no problems.

http://forums.4-jag.com/member.php?u=1

* Clicks Install

[cdoyle]

I still can't find the edit page button, but I do have another question/request.

Since most of our members most likely don't have a host for pictures for their pages. Is there anyway, that this hack could utilize the picture attachment feature of Vboard, to let them upload a photo to use on their page?

Thanks
Chris.

[Nordinho]

Originally Posted by cdoyle

I still can't find the edit page button, but I do have another question/request.

Since most of our members most likely don't have a host for pictures for their pages. Is there anyway, that this hack could utilize the picture attachment feature of Vboard, to let them upload a photo to use on their page?

Thanks
Chris.

I would like to see that feature as well...