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!

[Snow]

Originally Posted by shortbus1662

okay, I'm going to need a little help here....

the query worked fine when I ran it on the wrong database.

when I ran it on the right one, it said somethin phrase or something didn't exist. I "almost" copied it to post it here, but instead, I just clicked "go" to try and do it again.

Then, I got a different error that said guestbook something something already exists...

AM I SCREWED?

Please help!

I don't know about the first error, but it sounds like at least some of the queries were run succesfully as it's now erroring when you try to re-run the INSERT queries. Use the attached delete.txt (rename it to delete.sql before using phpmyadmin to run it) and this will remove all the phrases and settings that the install.sql inserted then you can try again from scratch.

Edit: Actually I've just had a thought, do you use a table prefix? Maybe the first error was table phrase didn't exist or something like that?

[shortbus1662]

yes, here is the error I got when I deleted:

SQL-query:

DELETE FROM `phrase` WHERE varname = 'setting_allowguestbook_desc'

MySQL said: Documentation
#1146 - Table 'ostatesp_forum.phrase' doesn't exist
-----------------------

so, what should I do now? Thanks for the help Snow.

[Snow]

Originally Posted by shortbus1662

yes, here is the error I got when I deleted:

SQL-query:

DELETE FROM `phrase` WHERE varname = 'setting_allowguestbook_desc'

MySQL said: Documentation
#1146 - Table 'ostatesp_forum.phrase' doesn't exist
-----------------------

so, what should I do now? Thanks for the help Snow.

I'm no expert when it comes to MySQL, but I don't think that full stop should be there :speechless: I thought it's supposed to be tableprefix_table e.g. if your prefix is vb then it would be vb_phrase Maybe someone more experienced with MySQL can shed some light on the matter.

[shortbus1662]

well, that's the first sql query I've done in my life, so I have absolutely no idea . Thanks for the help. Hopefully someone else can pitch in and help.

[Marco van Herwaarden]

You are probably using a table prefix. Edit the query sa follows:
[sql]DELETE FROM TABLE_PREFIXphrase WHERE varname = 'setting_allowguestbook_desc'[/sql]
replacing TABLE_PREFIX with your prefix.

[shortbus1662]

I'm lost.

I don't see table_prefix anywhere in there...

in the delete file SNOW posted I there is, "delete from 'phrase' where VARNAME = yadda yadda yadda.

Sorry I don't understand, I'm just learning.

[Snow]

Originally Posted by shortbus1662

I'm lost.

I don't see table_prefix anywhere in there...

in the delete file SNOW posted I there is, "delete from 'phrase' where VARNAME = yadda yadda yadda.

Sorry I don't understand, I'm just learning.

What is your table prefix?

[Detomah]

Think this could possibly be a bit of a bug that i've found, not sure if anyone else is suffering it or it could be confirmed that i've either gone mad or it is actually happening.

Basically:

Write a message in a guestbook and confirm it, then basically refresh and it is duplicated, if a user refreshes over and over, the message can be duplicated sever times in quick succession, which also sends a pm every time too.

I can delete guestbook messages no problem, but i;ve had to disable the guestbook featur for the moment, until I can either get a fix for this or until I am told I have gone mad.

Besides that, super hack.

[shortbus1662]

the prefix is ostatesp_forum

[Snow]

Originally Posted by Detomah

Think this could possibly be a bit of a bug that i'vefound, not sure if anyone else is suffering it or it could be confirmedthat i've either gone mad or it is actually happening.

Basically:

Write a message in a guestbook and confirm it, then basically refreshand it is duplicated, if a user refreshes over and over, the messagecan be duplicated sever times in quick succession, which also sends apm every time too.

I can delete guestbook messages no problem, but i;ve had to disable theguestbook featur for the moment, until I can either get a fix for thisor until I am told I have gone mad.

You're lucky, you can deleteguestbook entries. I guess since the 'post guestbook entry' partis a form it would make sense that refreshing the page would repost theentry.... I suppose. The other day, some of my users told me theywere getting duplicate entries in the guestbooks and they swore theyweren't clicking the submit button twice (I assumed they were not alsorefreshing the page). I don't know, maybe this is a bug. :ermm: