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!

[docvader]

Originally Posted by ogetbilo

dude can you explain your reinstallation process like which phrases are missing ?
cause i want to get this script work and i dont want to mess with the database...

Well, I could not run the install.sql through MyPHP, because, the first few "INSTALL" commands will stop the process, as it will find previous copies of those phrases. Those beginning phrases were not destroyed in the vb upgrade.

So, if you open install.sql with Notebook, and copy each command into your VB Admin maintenance area, starting from the bottom of the page, you'll find that those commands will be accepted into your database. If you work your way up, eventually you'll get to the point where you'll get MYSQL errors; I've found that you can stop there, because those phrases are still in your database. If you really want to play it safe, try installing each and every one. There are a few, on the very top, that need to be reinstalled, such as the ones that need to go into the Usergroup Manager. These are:

Can have guestbook
Can have webpage
Can view guestbook
Can view webpage
Can post in guestbook
(and a whole bunch on the very bottom of install.sql)

Therefore: open install.sql with Notebook (or whatever), copy each individual INSTALL line into ADMIN CP / Import and Maintenance / Execute SQL Query, starting from the bottom of the page, and work your way up, until you get MYSQL errors. Also, input the commands that reference the above five statements.

Second, I suggest "reinstalling" all file edits. I was amazed at what got changed when I upgraded to 3.05; it was easy to miss the file edits that this hack has you do.

Therefore: Go through install process again, concerning file edits, as if you were doing a clean install. You might find that some of your hack file edits got wiped during upgrade.

Third, there should be no problems with the previous install of templates. I found that none of those had issues.

Fourth, open ADMIN CP / Languages and Phrases / Search in Phrases; search for "guestbook", and save one of those phrases.

Fifth, open ADMIN CP / VBulletin Options, look for Guestbook / Webpage Preferences, do what you need to in there (it should show, once you've fixed your file edits), and save it.

Sixth, open ADMIN CP / Usergroup Manager, check your permissions. (Mine didn't change during the upgrade, but, because some phrases got lost, my Usergroup manager had some empty lines), and save them.

That's what worked for me. I don't think I missed anything.

docvader, AKA "dude"

[ogetbilo]

Thanks docvader ,
By your help I get the script working.

[Snow]

Originally Posted by docvader

Therefore: open install.sql with Notebook (or whatever), copy each individual INSTALL line into ADMIN CP / Import and Maintenance / Execute SQL Query, starting from the bottom of the page, and work your way up, until you get MYSQL errors. Also, input the commands that reference the above five statements.

I was too lazy to run each individual INSERT, so I just deleted all the phrases and settings (see attached delete.txt) and re-executed the insert.sql (without the create tables). It seemed to work for me. :squareeyed:

[MojoNixon]

I can´t believe it ..its working again...i just checked the templates again ... and after that all was visible in admincp. What about the smilies in the guestbook? They are not converted to icons ...hmm i can´t remember what to do at this point.

[SiFor]

A couple of things:

1: There seems to be a problem with the template modify_webpage on my site as when I edit my webpage in the vbcode mode the footer of the page is not correct (see image) and the page width expands. How do I fix this?

2: Also the alt text for the "Go vbcode" button has the wrong phrase. Simple enough to change though and I've figured that one out.

3. When in the HTML editing mode the smiles dont work so would it be possible to remove the smile box from the page.

Great hack BTW, thanks for the time your put into this. Good Job. :up:

[Neutral Singh]

** Installed in first attempt ** THANKS SWEDIE !!

Is it possible that the a user can create webpage in the internal enhanced WYSIWYG Editor so that members is spared of formatting the webpage and rather cut paste the stuff onto the editor. Anyways, I have been looking for this hack for eternity... i am shocked that missed it out for 2-3 months since its official launch. Anayways, kudos to Swedie...

Respect

[docvader]

Upgrade to 3.06

Same issues as upgrade to 3.05. Above directions seem to take care of it, post 496 and 498.

Wasn't that fun.
rich

[Sean S]

Swedie you are awsome man, after a few days I was finally able to fix some of the coding and get it working on my test forums and now I'm going to install it to my actual forums. I'll make sure that I'll donate as soon as I get paid this month.

[defi]

Using this hack, I decided to take it a step further - a type of myspace.com reformed.

Basically, I created a type of member.php (to keep some of the variables I may need etc in tact) to mypage.php and placed the code in that file. Then, I added a custom field where users could edit the css of their custom page. Basically, the users now can create their own, fully coded page which uses their own template in theory.

I'm thinking of actually also adding another option so user's can literally create a type of myspace.com theme which displays their profile picture, and other custom fields they provide using the template they used on this modification.

Great hack. (I've included screenshots to show you).

[Sean S]

thats a very nice idea you have there with the CSS, keep up the good work.

[UManiac]

Originally Posted by defi

Using this hack, I decided to take it a step further - a type of myspace.com reformed.

Basically, I created a type of member.php (to keep some of the variables I may need etc in tact) to mypage.php and placed the code in that file. Then, I added a custom field where users could edit the css of their custom page. Basically, the users now can create their own, fully coded page which uses their own template in theory.

I'm thinking of actually also adding another option so user's can literally create a type of myspace.com theme which displays their profile picture, and other custom fields they provide using the template they used on this modification.

Great hack. (I've included screenshots to show you).

Can you post a copy of the file you've changed? I'm curious to see what you did...

You added the custom field using the adminCp?

Thanks

[defi]

Originally Posted by UManiac

Can you post a copy of the file you've changed? I'm curious to see what you did...



Thanks

My modification was pretty much custom tailored to my site, and the coding is pretty ugly since I hadn't planned on releasing it... The big thing is using this css will basically overwrite the $bgcolor variable since it will be useless and I found no more use for the font and font color variables so if you're serious about doing this, I suggest giving your users pre-defined css text or something to give them a start with.

If anyone is serious about setting the css (basically) in place of the other body tags, pm me and I'll write a rough tutorial of how I did it.

You added the custom field using the adminCp?

No, this field required me to insert a new field into the webpage table and two file modifications

[Snow]

Cool idea Defi I'd love to see how you did it.

Do you have to have html enabled for the webpage in order for the custom css to work?

[Harlequin]

Just out of curiosity, I was curious if someone had removed the hard-coded HTML (such as how the guestbook entries are in the member.php file) and actually made them into vB templates instead? The webpage settings I can understand for being configurable and hardcoded in a file (webgbset.php) -- but the guestbook is something I'd like to be tied in with /my/ site, not the user's webpage.. especially if a user doesn't have a webpage to begin with. There're some things here I'm noticing in the code that can't be configured without dropping them out.. and considering I'd like tcat and thead to be used a bit more for this (for ease of layouts changing so everything matches).. I think you get where I'm going here. I think. Even if it remained hard-coded and the guestbook look were changed up to be used with 'tcat's and 'thead's, 'alt1, alt2, smallfont', etc. etc. etc., I'd go for that, too.

Granted, I can do this, but I was curious of anyone else had taken on this task. But, great hack -- works beautifully here on 3.0.3 with what I've tested.

[merseybeat]

This sounds like the hack of the century... I am going to try and install this tonight.. One question though.

I have checked the insert file for the database and just need to clear something up before I insert...

Are you missing a prefix in the

INSERT INTO `phrase`

As you have not created a table called 'phrase'
I can only assume you are inserting into the existing 'phrase' table and in my case that would be 'vb3_phrase'

So do I change all the 'phrase' to 'vb3_phrase'

i.e.

INSERT INTO `vb3_phrase`

Thanks

Eddie Hughes