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!

[laeth]

Originally Posted by frage

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;


laeth
I'm a mysql (professional) dummy
but check your sql file and compare the above text with the text in it

wih kind regards
frage

Didnt help unfortunatly. Thanks anyway.

[laeth]

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

I missed the last bit off last time. Maybe that will help more.

[Snow]

Originally Posted by Swedie

Snow and T3MEDIA, please download latest .ZIP and update members.php. Please don't mention the name of the site that was in there. Don't want to give that guy any more heartache.

I'm confused Swedie :ermm: I've just downloaded the latest zip but in file_memberphp the "site that was in there" is still there.

Line 191 of file_memberphp:

PHP Code:

                $emailmessage = "".$vbphrase['wg_you_have_a_new_guestbook_entry_from']." ".$bbuserinfo['username']."!\n
                \n
                <a href="http://www.site_name_deleted.com/community/member.php?u=".GBUSERID."">".$vbphrase['wg_click_here_to_view_guestbook']."</a>"; 


You know what would be really handy, Swedie, is if you could keep a log with details of all the changes made. I think that would lead to less confusion.

[Snow]

Originally Posted by frage

if I use firefox I can't edit and delete any guestbook entry

Netscape and IE I can

but 75% of my users using firefox

I hope this will help you to fix the prob

frage

I've just tried in IE but I can't edit and delete in IE either.
:cry: :cry: I seem to remember wayyyyy back when I first installed this hack, before all the updates, the edit/delete guestbook entry was working so it must be one of the "updates" that has caused this bug.

[T3MEDIA]

Cant edit... cant delete guestbooks. Firefox didnt try IE. AND I downloaded the zip ran the update non of the database stuff would work. oh man....

I dont know what sweed is talking about.

Snow did you get this to work?

[Snow]

Originally Posted by T3MEDIA

Cant edit... cant delete guestbooks. Firefox didnt try IE. AND I downloaded the zip ran the update non of the database stuff would work. oh man....

I dont know what sweed is talking about.

Snow did you get this to work?

The guestbooks/webpages are working, but the bugs aren't fixed if that's what you mean. I guess we'll just have to wait for Sweedie to return to give us an update on what's going on as I'm just as confused as you are.

[laeth]

I managed to fix my problem just running the sql file from phpmyadmin (although I didn't change my prefix's and had to delete everything and blah it took ages to sort out). But anyway, I was wondering if there was anyway to change the font color for the guestbook. e.g 'subject' 'rules' smilies' 'enabled' and 'message'?

Thanks a lot.

Laeth.

[JD210]

Okay, I have read through this thread 3 times now, and have done eveything recommended and I still cannot get this thing to work right, all it is doing in messing up my board now. How can I uninstall everything? I am running 3.0.3

[samjo]

My first hack working with the first install

[MojoNixon]

hmm ..i have to install 3.0.5 ...is this mod still working?