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!

[Swedie]

Originally Posted by KirbyDE

@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]

Yeah, I'm gonna do that now. I didn't have in my calculations that the field order would be different on different computers. I've tried it on two different servers and it works on both. But yeah, just to be sure I'm gonna force to the correct fieldname. I'm on it...

[Swedie]

Originally Posted by Swedie

Yeah, I'm gonna do that now. I didn't have in my calculations that the field order would be different on different computers. I've tried it on two different servers and it works on both. But yeah, just to be sure I'm gonna force to the correct fieldname. I'm on it...

Okay! I've updated again. The new .SQL file now included complete INSERTS and cannot fail. Sorry, I should've done this in the first place!

Thanks all for assisting and making it work (at all?).

[Nordinho]

Heya,

I'm having some trouble displaying/viewing the hack...it doesn't show up anywhere. I've changed the permissions, logged in and out and cleared my cache...

I think the problem is in the general permissions screen, since it isn't showing up correctly (see attachment)

I tried changing the general permissions in the init.php file since this looked wrong...I think...

PHP Code:

'caneditownusernotes'      => 131072,
'canuseguestbook'          => 262144,
'canusewebpage'            => 524288,
'canseehiddencustomfields' => 262144, 


to this

PHP Code:

'caneditownusernotes'      => 131072,
'canseehiddencustomfields' => 262144,
'canuseguestbook'          => 524288,
'canusewebpage'            => 1048576, 


could someone help me out??

greets Nordinho,

[Polo]

Thanks swedie

[Swedie]

Originally Posted by Nordinho

Heya,

I'm having some trouble displaying/viewing the hack...it doesn't show up anywhere. I've changed the permissions, logged in and out and cleared my cache...

I think the problem is in the general permissions screen, since it isn't showing up correctly (see attachment)

I tried changing the general permissions in the init.php file since this looked wrong...I think...

PHP Code:

'caneditownusernotes'      => 131072,
'canuseguestbook'          => 262144,
'canusewebpage'            => 524288,
'canseehiddencustomfields' => 262144, 


to this

PHP Code:

'caneditownusernotes'      => 131072,
'canseehiddencustomfields' => 262144,
'canuseguestbook'          => 524288,
'canusewebpage'            => 1048576, 


could someone help me out??

greets Nordinho,

I can see that what is missing is the text. Because you have the two fields. So what you need to do is make sure that you have added the phrases called:
can_use_guestbook, can_use_webpage
They should be under: Permissions
in the Phrase Manager.

Or run this SQL again.
INSERT INTO `phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '-1', 'can_use_guestbook', 'Can use Guestbook?', 3);
INSERT INTO `phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '-1', 'can_use_webpage', 'Can use Webpage?', 3);

[Nordinho]

Originally Posted by Swedie

I can see that what is missing is the text. Because you have the two fields. So what you need to do is make sure that you have added the phrases called:
can_use_guestbook, can_use_webpage
They should be under: Permissions
in the Phrase Manager.

Or run this SQL again.
INSERT INTO `phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '-1', 'can_use_guestbook', 'Can use Guestbook?', 3);
INSERT INTO `phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '-1', 'can_use_webpage', 'Can use Webpage?', 3);

thanks for the reply Swedie, but both the phrases allready do exist...any other idea's??

Or should I change this back??

'caneditownusernotes' => 131072,
'canseehiddencustomfields' => 262144,
'canuseguestbook' => 524288,
'canusewebpage' => 1048576,

[Swedie]

Originally Posted by Nordinho

thanks for the reply Swedie, but both the phrases allready do exist...any other idea's??

Or should I change this back??

Make your genericpermissions array look like this:

// field names for general permissions
$_BITFIELD['usergroup']['genericpermissions'] = array(
'canviewmembers' => 1,
'canmodifyprofile' => 2,
'caninvisible' => 4,
'canviewothersusernotes' => 8,
'canmanageownusernotes' => 16,
'canseehidden' => 32,
'canbeusernoted' => 64,
'canprofilepic' => 128,
'canseeraters' => 256,
'canuseavatar' => 512,
'canusesignature' => 1024,
'canusecustomtitle' => 2048,
'canseeprofilepic' => 4096,
'canviewownusernotes' => 8192,
'canmanageothersusernotes' => 16384,
'canpostownusernotes' => 32768,
'canpostothersusernotes' => 65536,
'caneditownusernotes' => 131072,
'canuseguestbook' => 262144,
'canusewebpage' => 524288,
'canseehiddencustomfields' => 1048576
);

Just like that!

[Nordinho]

Originally Posted by Nordinho

thanks for the reply Swedie, but both the phrases allready do exist...any other idea's??

Or should I change this back??

I've just changed the default permissions in phpmyadmin back and forth, now the webpage is starting to show...still no guestbook or editing options...

I can see it's installed by going to http://www.nordinho.com/vbull/profil...do=editwebpage....

[Snow]

I'm having exactly the same problems as Nordinho. I don't know much about php but the genericpermissions array actually continues further down in my init.php file.

// field names for general permissions
$_BITFIELD['usergroup']['genericpermissions'] = array(
'canviewmembers' => 1,
'canmodifyprofile' => 2,
'caninvisible' => 4,
'canviewothersusernotes' => 8,
'canmanageownusernotes' => 16,
'canseehidden' => 32,
'canbeusernoted' => 64,
'canprofilepic' => 128,
'canuseavatar' => 512,
'canusesignature' => 1024,
'canusecustomtitle' => 2048,
'canseeprofilepic' => 4096,
'canviewownusernotes' => 8192,
'canmanageothersusernotes' => 16384,
'canpostownusernotes' => 32768,
'canpostothersusernotes' => 65536,
'caneditownusernotes' => 131072,
'canuseguestbook' => 262144,
'canusewebpage' => 524288,
'canseehiddencustomfields' => 1048576,

// Reputation

'canseeownrep' => 256,
'canuserep' => 524288,
'canhiderep' => 1048576,
'cannegativerep' => 2097152,
'canseeothersrep' => 4194304,
'canhaverepleft' => 8388608,
);

Can 2 field names (or whatever their called) have the same value?

Nordinho, my phrases were "missing" even though the phrases were there but when I provided a US translation they work now.

[Nordinho]

Originally Posted by Snow

I'm having exactly the same problems as Nordinho. I don't know much about php but the genericpermissions array actually continues further down in my init.php file.

// field names for general permissions
$_BITFIELD['usergroup']['genericpermissions'] = array(
'canviewmembers' => 1,
'canmodifyprofile' => 2,
'caninvisible' => 4,
'canviewothersusernotes' => 8,
'canmanageownusernotes' => 16,
'canseehidden' => 32,
'canbeusernoted' => 64,
'canprofilepic' => 128,
'canuseavatar' => 512,
'canusesignature' => 1024,
'canusecustomtitle' => 2048,
'canseeprofilepic' => 4096,
'canviewownusernotes' => 8192,
'canmanageothersusernotes' => 16384,
'canpostownusernotes' => 32768,
'canpostothersusernotes' => 65536,
'caneditownusernotes' => 131072,
'canuseguestbook' => 262144,
'canusewebpage' => 524288,
'canseehiddencustomfields' => 1048576,

// Reputation

'canseeownrep' => 256,
'canuserep' => 524288,
'canhiderep' => 1048576,
'cannegativerep' => 2097152,
'canseeothersrep' => 4194304,
'canhaverepleft' => 8388608,
);

Can 2 field names (or whatever their called) have the same value?

Nordinho, my phrases were "missing" even though the phrases were there but when I provided a US translation they work now.

Thanx Snow, the translation thingie worked...the phrases are showing up now...

I'm actually having the exact same permissions list as you got...indeed there are some double values...Swedie has the one below as well, which I don't got...Can the double values just be changed or are they specific??

'canseeraters' => 256,

[Nordinho]

I got it showing now!!...don't know how, but it is showing (and breaking the layout worries for later)...

The permissions seem to change though each time I save them, I guess because of the double values...

[Snow]

I'm still trying to get it to work. :tired:

[Swedie]

I don't have that //Reputation thingy you guys have. I'm using vb3.0.0 RC2. Maybe it doesn't have the Reputation thingy all working.

I once again updated the .SQL file with some changes to the INSERTS for all the phrases. I put a different language ID in there...

If you don't get the lanuage to display, go into mysqlcc or phpmyadmin and change the field languageid to '0' instead of '-1'. That should make it work.

[Nordinho]

I'm using vb3.0.3, do you know a way to change those values??

[Swedie]

Originally Posted by Nordinho

I'm using vb3.0.3, do you know a way to change those values??

I just told you a way to do it. But I'll repeat

You need PHPMYADMIN or MySQLcc. List the content of the table called "phrase". Then change the values by hand.

To quicker find the last added phrases type this as a SQL command:
SELECT * FROM phrase ORDER BY phraseid DESC LIMIT 30

This will show the last 30 added phrases. Now go through them one by one.