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!

English screenshots would be nice :)

Not possible, sorry. My system is in Swedish. No need for it to be in English to understand what is going. I think. Please read this thread for possibly more insight:
https://vborg.vbsupport.ru/showthread.php?t=69827

Maybe someone else installing this script (if anyone is successful) can post up screenshots?!

Thanks for your hard work Swedie, I'm going to attempt at installing it. :)

Great job! Thanks for finally releasing!

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in /home/virtual/site87/fst/var/www/html/forum/includes/init.php on line 721
Parsing functions.php Time before: 1098911616.135 Time after: 1098911616.1649 Time taken: 0.029879093170166

:surprised:

Nevermind, problem fixed. :)

There should be a " , " after 'canusewebpage' => 524288 in init.php

So --> 'canusewebpage' => 524288,

Line 721 for me the wrong place. This is how the array for general permissions should look like:

// 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
);

I think it is maybe not a good idea to specify certain lines... because in hacked templates, the lines may differ...

I have just tried to run the query from my admincp. Here is an error I get:

Nice job but I would like to see english screens !

I don't know what is wrong, but looking in my admincp options it displays like this:

Has anybody gotten this successfully running? I'd like to see a live English version.

/me clicks install anyway because this is an awesome hack.

It would be nice if you could be more specific for those of us who have installed hacks instead of telling us to go lines numbers

member.php
Line 223:
* PASTE ALL CODE FROM memberpage.txt *

profile.php
Line 141:
* PASTE ALL CODE FROM profilepage.txt *

admin/usergroup.php
Line 103:

etc...

you also got the settings inserts all messed up

INSERT INTO `setting` VALUES ('allowguestbook', '1', 'yesno', 10, 'guestbookwebpage', '1', 0, 1);
guestbookwebpage belongs to the second value

Loki12 that's because he's got all the settings inserts in the wrong order

I've got it to work. It's really nice, but you should update those instructions. Also, how do I prevent the avatar and picture table above *not* to show crooked if user has no webpage.

P.S. Thank you for that hack. It was long overdue that someone did it.

Thanks for this great hack! I?m gonna install it when the bugs are out because i?m so dumbass at PHP. Unfortunately.

Please post up a picture as I cannot see what is going on.

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.

It got fixed after a few minutes, like you said. Once all the groups got updated. I had to change the bitfields as they were conflicting with other hacks. I also had to update permissions manually in mysql. For some reasons they were not updating. Overall, it's a very nice hack.

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

I am talking about the setting groups.

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.

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.

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

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

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

/me will install and donate once this a bug free
Thanks for you hard work 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?).

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...

to this
could someone help me out??

greets Nordinho,

Thanks 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??

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!

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....

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,