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!

[rex_b]

Originally Posted by Swedie

If you know the prefix, just place it before each table name. Say "phrase" it would then be "vb_phrase" in your case if your prefix is "vb_". let me know if you figure it out. Do let me know what your prefix is anyhow, and I'll create a special .SQL file for you.

Loki12, great to hear you got it to work. Now send me some love! (money... ) And don't forget to click on the "INSTALL" button to show you've installed it. :ninja:

Thanks. My prefix is vb3

[Swedie]

Originally Posted by rex_b

Thanks. My prefix is vb3

okay, download the attached file. Rename it the file to .SQL instead of .txt.

The two databases created will not have a vb3 extension. I'd have to rewrite the scripts. that's not difficult though. hum...

maybe I should create an installation proggy. it's rather simple really. let me know and give me a few days if so.

[rex_b]

Originally Posted by Swedie

okay, download the attached file. Rename it the file to .SQL instead of .txt.

The two databases created will not have a vb3 extension. I'd have to rewrite the scripts. that's not difficult though. hum...

maybe I should create an installation proggy. it's rather simple really. let me know and give me a few days if so.

Error
#1146 - Table 'rexb3_vb.usergroup' doesn't exist

[rex_b]

Ok I read this thread about 10 times and finally figured out that those sql statements to run to change those defaults to 1 instead of 0 were not doing the job so I did it manually and now I'm waiting for my db to update and hopefully that will fix it!

[rex_b]

nevermind there was one missing vb3 in the new text.

[rex_b]

OK I've got everything installed but I can't find the permissions to update in the admin/usergroup area under general permissions. Nothing is there.

[rex_b]

BWAHAHAHAH IT WORKS.. I SAY MAN..!! IT WOOORRRKSSSS.....

Now try to install it on the live site..

[Skyline_GT]

how to fix this?

[rex_b]

Originally Posted by Skyline_GT

how to fix this?

Go into phrases and search for can view guestbook and can view webpage and make sure you have the text in the "english" block which is the empty block.

[Skyline_GT]

n/m fixed

[rex_b]

So I'm trying to get it to work on my live site but I'm having problems again. I did the SQL change from 0 to 1 and I assume that means the userid? B/c I am admin but my userid is 3 so I changed it from 0 to 3 now and hopefully when sql updates it will work but just wondering if I am on the right track?

[Swedie]

Originally Posted by rex_b

So I'm trying to get it to work on my live site but I'm having problems again. I did the SQL change from 0 to 1 and I assume that means the userid? B/c I am admin but my userid is 3 so I changed it from 0 to 3 now and hopefully when sql updates it will work but just wondering if I am on the right track?

Which value did you change over to 3 from 0?

Here is a new memberpage code. overwrite what you first pasted into member.php. This file includes a change over so that it detects who's got admin rights. This user can delete messages in any of your users guestbooks.

And like I said earlier in a post. Run this SQL query:
(this one has the vb3 prefix for rex_b table structure!)
UPDATE vb3usergroup SET canuseguestbook = '1';
UPDATE vb3usergroup SET canusewebpage = '1';

I uploaded a new .SQL file to my post before.

[Wordplay]

first error / conflict >

if my users set the guestbook to show up on the bottom, it doesn't show at all.

[Snow]

I've got a slight permissions problem. I hadn't made this hack available to regular members yet but it appears they've been able to create webpages and guestbooks. I've double checked the usergroup permissions and triple checked them and they are all set to "Can use Guestbook?" - No "Can use webpage?" -No. Does anyone else have this problem as it's got me stumped as to how they can use the webpage and guestbook when they don't have permission to.

[Swedie]

Originally Posted by Snow

I've got a slight permissions problem. I hadn't made this hack available to regular members yet but it appears they've been able to create webpages and guestbooks. I've double checked the usergroup permissions and triple checked them and they are all set to "Can use Guestbook?" - No "Can use webpage?" -No. Does anyone else have this problem as it's got me stumped as to how they can use the webpage and guestbook when they don't have permission to.

Crapholios.. works splendid for me. I think. I'll check and get back to you all.