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!

[Lionel]

Originally Posted by Swedie

I double checked my .SQL file and ran it on a new database (copied my forum) and it installed flawlessly. Only trouble I saw was that it was saved using Unix style or somethign so if the SQL file is run as it is, some line brakes may not appear correctly, hence causing a problem.

This problem has been addressed in the new .ZIP file in my first post here in this thread.

I've also updated the installation instructions for your convenience.

Got more than that. Perhaps the Sweedish version is different? For example nothing was showing up in Control Panel as pictured above by someone. That was due to the fact that all names were inserted in the wrong fields. I had to manually adjust every single one of them.

[Swedie]

Originally Posted by Lionel

Got more than that. Perhaps the Sweedish version is different? For example nothing was showing up in Control Panel as pictured above by someone. That was due to the fact that all names were inserted in the wrong fields. I had to manually adjust every single one of them.

hmm! odd... are you talking about the languageid field .. please specify and I'll make the correction to the .SQL file. thanks

[Lionel]

I am talking about the setting groups.

[Lionel]

here, all the ones in that series were wrong:
INSERT INTO `setting` VALUES ('allowguestbook', '1', 'yesno', 10, 'guestbookwebpage', '1', 0, 1);

the value 'guestbookwebpage' for example should have been the second one. The yesno is wrong etc...

[Swedie]

Originally Posted by Lionel

here, all the ones in that series were wrong:
INSERT INTO `setting` VALUES ('allowguestbook', '1', 'yesno', 10, 'guestbookwebpage', '1', 0, 1);

the value 'guestbookwebpage' for example should have been the second one. The yesno is wrong etc...

Thing is that I've done a simple SQL dump and copied the INSERT's that PHPMYADMIN created for me for re-creating the database. I can't see how it would create the fields wrongly.

The fields goes like this:
varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile
the order in the INSERT CODE is correct... if you look at above line

Also when I am executing the SQL file and I'm looking at the database for any wrong inputs I can't see any wrongs. Everything is where it should be.

The .SQL file that you downloaded was saved incorrectly and had messed up line brakes. Maybe that is what caused it.

Sorry if I'm blind to see the problem, but I'm sitting here re-creating the database structure with my last .SQL file and everything is the way it should be.

[Wordplay]

Lionel can you please rerelease an install script that works? because as it seems nobody was able to really get this to work, right away, and i can't afford my board to not work for a while, it has to work right away.

where should we donate too? once i get it to run on my system i will definately do that, because this hack i've been waiting for.

[Lionel]

here is a snapshot of mysql and the order of the fields

you will see that grouptitle is number2. That is why no one can see it

[Lionel]

Wordplay all you have to do is rearrange the order. I had to do it manually in phpadmin.
Sweedie has a paypal account in first post :-)

and where he says before of after linebreak (there are a ton of them) simply put it in the general permissions group as he stated

[Andreas]

@swedie
I'd suggest to use complete INSERTs to avoid problems with different column ordering.

Eg.

[sql]INSERT INTO foobar (foo, bar) VALUES ('foo', 'bar')[/sql]

[oldfan]

/me will install and donate once this a bug free
Thanks for you hard work swedie!!