Webpage & Guestbook Script

[Swedie]

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!

[Andreas]

English screenshots would be nice :)

[Swedie]

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

[Loki12]

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

[Surtain23]

Great job! Thanks for finally releasing!

[Loki12]

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:

[Loki12]

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,

[Swedie]

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

[Loki12]

Line 721 for me the wrong place.

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:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ';

CREATE TABLE `user_webpage` (
`userid` int(11) NOT NULL default '0',
' at line 10

[HiDeo]

Nice job but I would like to see english screens !

[Loki12]

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

[dndog]

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.

[Lionel]

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

[Lionel]

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

[Lionel]

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

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

[Lionel]

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.

[Tradjick]

Hello all friendly people,

This is a script I've been working my rearend off to finish after hearing how wanted it was by several members here on this site. I even received PM's threatening me if i did not finish it and released it to everyone. Haha! Just kidding. I did ask if I was going to make this script something you will have to pay for. but I was convinced I should rely on donations instead. So... everyone using this script...Please consider donating, it'd be much appreciate and make the time I've put down on this script worth my while. Thank you!

My PayPal email is: swedie@wheeliepimp.com. Or click here:
https://www.paypal.com/xclick/business=swedie%40wheeliepimp.com&item_name=Webpage+%26+Guestbook+Script&no_note=1&tax=0&currency_code=USD

Webpage features:
- global On/Off
- usergroup On/Off
- html/vbcode/smilies On/Off (globaly or user set)

Guestbook features:
- global On/Off
- usergroup On/Off
- smilies On/Off (globaly or user set)

Umh, what else... well. Here are some screenshots!

I've attached a ZIP file for you to download. It holds a bunch of text files and a .SQL file.

As usual, I take no responsibily as to what happens to your website after you install this script, I just know it works for my website and I'm happy as well as all my users using it!

Cheers and enjoy! :)

UPDATED WITH A NEW .ZIP FILE THAT INCUDES A NEW IMAGE
Thanks for this great hack! I?m gonna install it when the bugs are out because i?m so dumbass at PHP. Unfortunately.

[Swedie]

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.
Please post up a picture as I cannot see what is going on.

[Swedie]

Thanks for this great hack! I?m gonna install it when the bugs are out because i?m so dumbass at PHP. Unfortunately.
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.

[Lionel]

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.

[Lionel]

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.

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.

[Swedie]

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

[Lionel]

I am talking about the setting groups.

[Lionel]

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

[Swedie]

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.

[Wordplay]

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.

[Lionel]

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

[Lionel]

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

[Andreas]

@swedie
I'd suggest to use complete INSERTs to avoid problems with different column ordering.

Eg.

INSERT INTO foobar (foo, bar) VALUES ('foo', 'bar')

[oldfan]

/me will install and donate once this a bug free
Thanks for you hard work swedie!!

[Swedie]

@swedie
I'd suggest to use complete INSERTs to avoid problems with different column ordering.

Eg.

INSERT INTO foobar (foo, bar) VALUES ('foo', 'bar')
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]

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


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

to this

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

could someone help me out??

greets Nordinho,

[Polo]

Thanks swedie :)

[Swedie]

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


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

to this

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

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]

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]

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/profile.php?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]

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]

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.

[Nordinho]

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.

Thanx for your fast replies Swedie, but I actually meant the other values, since they seem to be conflicting...

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

// Reputation

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

[Swedie]

Thanx for your fast replies Swedie, but I actually meant the other values, since they seem to be conflicting...

those values are nothing special. As you can see the next value should have the double number of the one before. Do the math and you should have no problem fixing your problem.

But here is how yours should look


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

// Reputation

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


notice WITHOUT the , after the last array / number.

[Nordinho]

those values are nothing special. As you can see the next value should have the double number of the one before. Do the math and you should have no problem fixing your problem.

But here is how yours should look


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

// Reputation

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


notice WITHOUT the , after the last array / number.

It looks like that did the trick!!! thanks again Swedie for the great support!!!

[rex_b]

so does this thing work for 3.0.3 or not?

[Snow]

Thanks Sweedie, changing the array has sorted out the problems I was having with usergroup permissions.

rex_b I'm using vb3.0.3 but I can't seem to be able to get it to work. So far, I've managed to get everything in the admin CP to work, going to /profile.php?do=editguestbook and /profile.php?do=editwebpage manually takes me to the edit pages, but I can't view either the guestbook or the webpage in the profile and the links are not visible in the user CP for some mysterious reason. I'll post here if I do eventually get it to work. :disappointed:

[Lionel]

You have to wait 15 minutes as he explained. If that still does not work. Make sure that mysql is updating.

[Snow]

You have to wait 15 minutes as he explained. If that still does not work. Make sure that mysql is updating.
I made those changes last night so it's been about 6-7 hours. Forgive my ignorance but how do I make sure that MySQL is updatin?

[Lionel]

If you do not know about mysql, don't go in there. You might mess things up big time.

[Lionel]

If I remember well, mysql was not updating and I had to do the permissions manually (set them to 1). He probably got the fields reverse in there too.

[Snow]

Luckily I backed up the database before installing this hack. Thanks for the info, although I know very little about MySQL I'll try to make those changes. :confused:

[Nordinho]

Luckily I backed up the database before installing this hack. Thanks for the info, although I know very little about MySQL I'll try to make those changes. :confused:

it works for me on vb3.03...allthough I had some problems getting started. At first nothing showed up. After I changed the default permissions in phpmyadmin from 0 to 1 the links started showing up.

@Snow...it's not that hard to change them, if you have control panel, then go to your vbulletin database...then go to the usergroup table, you'll see all the permission fields...the 2 at the bottom of the list are 'canuseguestbook' and 'canusewebpage'...you'll see the value for 'default' is 0...if you click on the edit button for those tables you can change the value to 1...

I changed the default permissions back to 0 later on and it's still working...

Greets Nordinho

[Swedie]

Oh! Crap! I realize I never included these two SQL commands:


UPDATE usergroup SET canuseguestbook = '1';
UPDATE usergroup SET canusewebpage = '1';


Run these in your SQL command line! That will solve your problem.

[Snow]

Yipeee!! It's working now!!! Thank you Swedie.

PS It's a fantastic hack. :D

[Swedie]

Yipeee!! It's working now!!! Thank you Swedie.

PS It's a fantastic hack. :D

Great! Happy for you. Btw I looked at your website and your profile page looks real nice now. :)

I relied on people donationg money. There was atleast 3 people saying that they would donate. Now I'm left with nothing. bohoo. :ermm: hehe. It's okay. I just wish I had received atleast some donations. but none? :rolleyes:

Anyhow, I'll add a buddy list to the profile page where the "owner" can administrate his buddies. The default vBulletin buddy-list is very weak.

[Hades-1]

I was wondering if anyone has used this hack in a smaller width skin like the default VB3 skin?

It seems like it may be too small and cramp the users webpage together.

Thats the only thing stopping me from download & install could someone with it installed clarify.

Thanks

[hasan2k]

Great! Happy for you. Btw I looked at your website and your profile page looks real nice now. :)

I relied on people donationg money. There was atleast 3 people saying that they would donate. Now I'm left with nothing. bohoo. :ermm: hehe. It's okay. I just wish I had received atleast some donations. but none? :rolleyes:

Anyhow, I'll add a buddy list to the profile page where the "owner" can administrate his buddies. The default vBulletin buddy-list is very weak.

hey swedie..great job.

Anyways, I was wondering if your CLASSIFIEDS script has the feature of expering an add determined by the person submitting the ad.

[Swedie]

I was wondering if anyone has used this hack in a smaller width skin like the default VB3 skin?

It seems like it may be too small and cramp the users webpage together.


I haven't even thought about that vB3 skin.

But what I've done is giving the user the option to place the guestbook to the Right, Left or Bottom. This way if the user's webpage is too cramped up already, he can just place the guestbook at the bottom and it will give him more space for his little webpage.

For example, here's a user on my website that has placed his guestbook at the bottom:
http://www.sporthoj.com/forum/member.php?u=5248

I just saw something... that I got to fix.... doing it right now.. and when I have posted this reply to you it will have been fixed by me adding a new .ZIP to my first post. the problem was that texts changed colors... Download the new .ZIP file and paste the content of memberpage.txt into member.php (overwrite previous code)

[Swedie]

hey swedie..great job.

Anyways, I was wondering if your CLASSIFIEDS script has the feature of expering an add determined by the person submitting the ad.

Not sure I understand you completely. Expering? You mean to expire an ad? .. please try to explain yourself better. thanks

[Hades-1]

I haven't even thought about that vB3 skin.

But what I've done is giving the user the option to place the guestbook to the Right, Left or Bottom. This way if the user's webpage is too cramped up already, he can just place the guestbook at the bottom and it will give him more space for his little webpage.

For example, here's a user on my website that has placed his guestbook at the bottom:
http://www.sporthoj.com/forum/member.php?u=5248

I just saw something... that I got to fix.... doing it right now.. and when I have posted this reply to you it will have been fixed by me adding a new .ZIP to my first post. the problem was that texts changed colors... Download the new .ZIP file and paste the content of memberpage.txt into member.php (overwrite previous code)

thanks for the quick reply, i do feel that your unique skin does not give me any idea what it would be like lol, guess its all trial and error.....do i dare?

[hasan2k]

Not sure I understand you completely. Expering? You mean to expire an ad? .. please try to explain yourself better. thanks

What I am trying to say is:

when someone tries to post a classified advertisement, does he have an option there to set an expiration date (the date when the ad will expire)?

[Swedie]

What I am trying to say is:

when someone tries to post a classified advertisement, does he have an option there to set an expiration date (the date when the ad will expire)?

oh okay! Now i get it... :ninja:

Not at the moment. Simply because I have not even thought about it. That's a good idea. I'll add that feature this weekend. It's quick.

Any more ideas? ... maybe we should take this by PM! Please.. I don't want this threat to too off topic. thanks

[Swedie]

thanks for the quick reply, i do feel that your unique skin does not give me any idea what it would be like lol, guess its all trial and error.....do i dare?

just do a backup!

I would do it. It's a nice addon for your users.

[Snow]

thanks for the quick reply, i do feel that your unique skin does not give me any idea what it would be like lol, guess its all trial and error.....do i dare?
The table widths are percentages so it should resize to your forum width
<table width=100% border=0 cellspacing=0 cellpadding=1>
<tr><td>
<font size=+1 color=black><b>$userinfo[username]'s webpage</b></font>
</td></tr>
<tr><td bgcolor="red"></td></tr>
<tr><td bgcolor="#FFCD78">
<if condition="$webpage[description]">
<b>Description:</b> <font color="#333333">$webpage[description]</font>
</if>
</td></tr>
This is what it looks like on my forum (http://aboho.com/forum/member.php?u=2)

Swedie, the styles were a bit scattered and it took a while to find them and change them to match my forum design, would it be possible in future releases to seperate the styles from the rest of the code so that it's easier to customise?

[Snow]

Great! Happy for you. Btw I looked at your website and your profile page looks real nice now. :)

I relied on people donationg money. There was atleast 3 people saying that they would donate. Now I'm left with nothing. bohoo. :ermm: hehe. It's okay. I just wish I had received atleast some donations. but none? :rolleyes: I've done something really nasty to my forum members, I've not made any of the major hacks available to them and I'm trying to set up a donation pot so that they can contribute in order to keep the hacks and then I can distribute that money to the coders like yourself that are accepting donations.

[Hades-1]

The table widths are percentages so it should resize to your forum width
<table width=100% border=0 cellspacing=0 cellpadding=1>
<tr><td>
<font size=+1 color=black><b>$userinfo[username]'s webpage</b></font>
</td></tr>
<tr><td bgcolor="red"></td></tr>
<tr><td bgcolor="#FFCD78">
<if condition="$webpage[description]">
<b>Description:</b> <font color="#333333">$webpage[description]</font>
</if>
</td></tr>
This is what it looks like on my forum (http://aboho.com/forum/member.php?u=2)

Swedie, the styles were a bit scattered and it took a while to find them and change them to match my forum design, would it be possible in future releases to seperate the styles from the rest of the code so that it's easier to customise?

thanks your forum helped, it helped me to realize it qont work on my website, i think this mod looks best with the webpage and g-book side by side, but that would look horrible on my site damn :(

[Swedie]

Swedie, the styles were a bit scattered and it took a while to find them and change them to match my forum design, would it be possible in future releases to seperate the styles from the rest of the code so that it's easier to customise?

Yeah, I was rushing the release for some members here. Next release will include more design customization from the user settings areas.

[Nordinho]

Great! Happy for you. Btw I looked at your website and your profile page looks real nice now. :)

I relied on people donationg money. There was atleast 3 people saying that they would donate. Now I'm left with nothing. bohoo. :ermm: hehe. It's okay. I just wish I had received atleast some donations. but none? :rolleyes:

Anyhow, I'll add a buddy list to the profile page where the "owner" can administrate his buddies. The default vBulletin buddy-list is very weak.

I've just made a small donation for you...thanks for the great help so far!!

[Swedie]

I've just made a small donation for you...thanks for the great help so far!!

thanks! much appreciated.

i can't believe how much paypal charges you nowadays. I remember when they were maybe 5-10 staffed ... but now with ebay and how bad ebay is going with all the scams etc they've apparently bumped up they're transaction fee's. it's almost at 10% now.. fuk

[rex_b]

I'm not using the default "vb" as the prefix. Can you fix this in the sql inserts to find what ther person is using rather than default?

[Swedie]

I'm not using the default "vb" as the prefix. Can you fix this in the sql inserts to find what ther person is using rather than default?

That would mean I'd have to write a PHP script that you'd have to execute, otherwise I can't have it so that it autodetects what your vb prefix is for your forum database tables. hmm

[Nordinho]

thanks! much appreciated.

i can't believe how much paypal charges you nowadays. I remember when they were maybe 5-10 staffed ... but now with ebay and how bad ebay is going with all the scams etc they've apparently bumped up they're transaction fee's. it's almost at 10% now.. fuk

Yep, I've send you 10$, they charge 4$ for transaction costs, so to send you 10$ I had to pay 14$...now that's making 'fast money' for pay-pal!! Anyways, I just wanted to donate something, because I think that once I've figured out all the templates, and changed them, this hack will really add some extra value to my site!!

Greets Nordinho,

[Wordplay]

Yeah, I was rushing the release for some members here. Next release will include more design customization from the user settings areas.
when ist that going to come out? because i'm not really in such a rush to get this. i want it when it's complete.

[Swedie]

when ist that going to come out? because i'm not really in such a rush to get this. i want it when it's complete.

maybe next weekend... probably not.

[Wordplay]

well i had a clean install, no wrong goings, no errors what so every, everything worked right from the get go. do y'all still need screen shots of an english board, if so i will drop that.

[Loki12]

well i had a clean install, no wrong goings, no errors what so every, everything worked right from the get go. do y'all still need screen shots of an english board, if so i will drop that.

You are lucky. I don't have that success yet. :disappointed:

[Wordplay]

what's not workin, maybe i can help out?

[Loki12]

what's not workin, maybe i can help out?

Nothing is showing up. I tried just about everything mentioned in this thread.

However, when I go here:

/profile.php?do=editwebpage

.. then I can see the edit page. But the link to that doesn't show up on my user cp, and also not on my profile when edited. Also, the admincp options are not there:

https://vborg.vbsupport.ru/attachment.php?attachmentid=21434

I have used the most recently updated files from Swedie's script (today's).

[Lionel]

that's because your group members do not have permissions. Go in DATABASE itself, and make sure that permissions are set properly.

P.S. I don't believe you read that thread. All you mentioned was covered.

[rex_b]

That would mean I'd have to write a PHP script that you'd have to execute, otherwise I can't have it so that it autodetects what your vb prefix is for your forum database tables. hmm


So uhh.. What do I do?

[Loki12]

that's because your group members do not have permissions. Go in DATABASE itself, and make sure that permissions are set properly.

P.S. I don't believe you read that thread. All you mentioned was covered.

I read everything. I also edited all usergroup permissions through phpMyadmin for "canuseguestbook" and "canusewebpage" to show "1" in the columns. Still not working.

[Lionel]

I read everything. I also edited all usergroup permissions through phpMyadmin for "canuseguestbook" and "canusewebpage" to show "1" in the columns. Still not working.

here is the reason why you are not seeing the settings in admin
https://vborg.vbsupport.ru/showpost.php?p=566297&postcount=15

[Loki12]

here is the reason why you are not seeing the settings in admin
https://vborg.vbsupport.ru/showpost.php?p=566297&postcount=15

I did read that post, thank you, and I assumed that Swedie had fixed that in his latest update... that is how I understand it. I downloaded a fresh file pack today from his first post.

[Loki12]

I did read that post, thank you, and I assumed that Swedie had fixed that in his latest update... that is how I understand it. I downloaded a fresh file pack today from his first post.

Damn... I see what you mean... the values from the first script are still there... I have to change them.

[Loki12]

Excellent! I got it to work! :D

Thanks Lionel & Swedie!

[Swedie]

So uhh.. What do I do?
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... :D) And don't forget to click on the "INSTALL" button to show you've installed it. :ninja:

[rex_b]

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... :D) And don't forget to click on the "INSTALL" button to show you've installed it. :ninja:


Thanks. My prefix is vb3

[Swedie]

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]

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]

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]

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

[Swedie]

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. :confused:
Crapholios.. works splendid for me. I think. I'll check and get back to you all.

[Lionel]

Works splendid for me too. Only the guestbook not showing at the bottom like Wolrplay

[rex_b]

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.


I've done all of that. and uploaded the new memer.php and I still can't see it in the admincp/usergroup manager

[StarBuG]

first error / conflict >

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

Same problem here!

I have a design that has a defined width and doesn?t use the whole screen and the position option doesn?t work.
If I use left or right it both looks like this:
https://vborg.vbsupport.ru/

and if I select bottom then it?s missing totaly!

What I would need is:

a) how to fix the position problem
b) How can I do it that the questbook uses the forum size
c) I want the guestbook to be at the bottom for all users (no choice for them)

Can you PLEASE help me

StarBuG

[Swedie]

Same problem here!

I have a design that has a defined width and doesn?t use the whole screen and the position option doesn?t work.
If I use left or right it both looks like this:
http://www.hiphop-battles.com/images/profile.jpg

and if I select bottom then it?s missing totaly!

What I would need is:

a) how to fix the position problem
b) How can I do it that the questbook uses the forum size
c) I want the guestbook to be at the bottom for all users (no choice for them)

Can you PLEASE help me

StarBuG
Let a few days pass. I need to redo the scripts so you have more design settings to play with such as width for webpage/guestbook table, font size/type/color etc.

any more bugs? please report and I'll fix it.

[StarBuG]

Let a few days pass. I need to redo the scripts so you have more design settings to play with such as width for webpage/guestbook table, font size/type/color etc.

any more bugs? please report and I'll fix it.
It is not only the design flaw that I could fix myself but why is the guestbook not showing up when I select bottom?

Please help

StarBuG

[rex_b]

Ugh.. why can't I see them in the admincp/usergroup manager.

// set default yes permissions (bitfields)
$ug_bitfield = array(
'showgroup' => 1,
'canview' => 1,
'canviewmembers' => 1,
'canuseguestbook' => 1,
'canusewebpage' => 1,
'canviewothers' => 1,
'cagetattachment' => 1,
'cansearch' => 1,
'canmodifyprofile' => 1,
'canthreadrate' => 1,
'canpostattachment' => 1,
'canpostpoll' => 1,
'canvote' => 1,
'canwhosonline' => 1,
'allowhidden' => 1,
'showeditedby' => 1,
'canseeprofilepic' => 1,
'canusesignature' => 1,
'cannegativerep' => 1,
'canuserep' => 1
);

They are there.. but not.. UGHHH

[StarBuG]

if you only the the radiobuttons but not the text search the two phrases and add the text into the english box!

StarBuG

[rex_b]

if you only the the radiobuttons but not the text search the two phrases and add the text into the english box!

StarBuG

Done that. I've installed it on one site correctly but now on this other one it's giving me problems.

I don't even see the radio buttons. :(

[Swedie]

Ugh.. why can't I see them in the admincp/usergroup manager.

// set default yes permissions (bitfields)
blah =)

They are there.. but not.. UGHHH

That array is only for when creating a new usergroup and you want default values added right away. So that's nothing to do with your problem.

The problem you're having is with the phrase language. Please try and run this SQL query: (it will change the value of your languageid to 1 instead of 0)


UPDATE vb3phrase SET languageid = '1' WHERE
varname = 'setting_allowguestbook_desc' AND
varname = 'setting_allowguestbook_title' AND
varname = 'setting_allowwebpage_title' AND
varname = 'setting_allowwebpage_desc' AND
varname = 'settinggroup_guestbookwebpage' AND
varname = 'setting_webpagevbcode_desc' AND
varname = 'setting_guestbooksmilies_desc' AND
varname = 'setting_webpagevbcode_title' AND
varname = 'setting_webpagesmilies_title' AND
varname = 'setting_guestbooksmilies_title' AND
varname = 'setting_webpagesmilies_desc' AND
varname = 'setting_webpagehtml_title' AND
varname = 'setting_webpagehtml_desc' AND
varname = 'can_use_guestbook' AND
varname = 'can_use_webpage' AND
varname = 'setting_allowedhtmltags_title' AND
varname = 'setting_allowedhtmltags_desc' AND
varname = 'edit_webpage_content' AND
varname = 'edit_guestbook_settings'
;

[StarBuG]

Hey Swedie

Do u have any idea why the guestbook is not showing up when bottom is selected?

StarBuG

[Swedie]

Hey Swedie

Do u have any idea why the guestbook is not showing up when bottom is selected?

StarBuG
ask me one more time, please do it!

[Swedie]

FIX FOR SHOWING GUESTBOOK

PASTE THIS:
<if condition="$vboptions[allowguestbook] == '1'">
<if condition="$userinfo[permissions][canuseguestbook] == '1'">
<if condition="$webpage[gb_status] == 'on'">
<if condition="$webpage[gb_position] == 'bottom'">
$webpage[gb_html]
</if>
</if>
</if>
</if>

before:
<if condition="$show['signature']">

IN TEMPLATE: MEMBERINFO

[rex_b]

That array is only for when creating a new usergroup and you want default values added right away. So that's nothing to do with your problem.

The problem you're having is with the phrase language. Please try and run this SQL query: (it will change the value of your languageid to 1 instead of 0)


UPDATE vb3phrase SET languageid = '1' WHERE
varname = 'setting_allowguestbook_desc' AND
varname = 'setting_allowguestbook_title' AND
varname = 'setting_allowwebpage_title' AND
varname = 'setting_allowwebpage_desc' AND
varname = 'settinggroup_guestbookwebpage' AND
varname = 'setting_webpagevbcode_desc' AND
varname = 'setting_guestbooksmilies_desc' AND
varname = 'setting_webpagevbcode_title' AND
varname = 'setting_webpagesmilies_title' AND
varname = 'setting_guestbooksmilies_title' AND
varname = 'setting_webpagesmilies_desc' AND
varname = 'setting_webpagehtml_title' AND
varname = 'setting_webpagehtml_desc' AND
varname = 'can_use_guestbook' AND
varname = 'can_use_webpage' AND
varname = 'setting_allowedhtmltags_title' AND
varname = 'setting_allowedhtmltags_desc' AND
varname = 'edit_webpage_content' AND
varname = 'edit_guestbook_settings'
;



Hmm. I ran that and I still don't see the 2 options in admincp/usergroup manager

[StarBuG]

the problem is in admin/usergroup.php

you where told to:

Add on row 174 BEFORE "print_table_break();":

but because of the multiple times this little bastard :D is in the file you propably put it in the wrong place (Like I did the first time!).

So find:

print_table_header($vbphrase['general_permissions']);

the "print_table_break();" after this is the right one ;)

Greetings

StarBuG

ps: You should describe this better in your instructions Swedie. You sometimes tell people to find a text that occures multiple times in the file so people get easily confused ;)

[rex_b]

Yep I figured that out like 2 min ago.. I had it after line 184..

NOW IT WORKS!!!!!

[Lionel]

Some experience huh?

[Swedie]

StarBug, if he had not done that it would not show up at all. It has to do with the phrase not showing up for some weird reason.

[StarBuG]

StarBug, if he had not done that it would not show up at all. It has to do with the phrase not showing up for some weird reason.
Na his problem was different.


I don't even see the radio buttons. :(

I am no real phrase expert but I think you need to atleast add the phrase line twice like this:

INSERT INTO `phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'can_use_guestbook', 'Can use Guestbook?', 3);
INSERT INTO `phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'can_use_guestbook', 'Can use Guestbook?', 3);

Cause the problem is when you edit a phrase you have two boxes for text
(I have 2 languages installed so I have three. I don?t know if forums with only one laguage have the second box called "English (US) Translation") and you only enter the phrase text in the "Custom Phrase" field ( languageid = 0).
You need to add languageid = 1 also

His problem was the wrong location of:

print_yes_no_row($vbphrase['can_use_guestbook'], 'usergroup[canuseguestbook]', $ug_bitfield['canuseguestbook']);
print_yes_no_row($vbphrase['can_use_webpage'], 'usergroup[canusewebpage]', $ug_bitfield['canusewebpage']);


If a user has a modified usergroup.php your line description for where to insert the code above doesn?t fit! And because the search text can be found in multiple places it?s easy to put the code in the wrong place.
That is why naming lines is not the way to use in install instructions ;)

He Propably put the code below

if ($usergroupid > 7 OR $_REQUEST['do'] == 'add')

and above the "print_table_break();"

Greetings

StarBuG

[Lionel]

about the phrases, once you insert them, you have to go apply the update in CP by updating any phrase.

[Swedie]

about the phrases, once you insert them, you have to go apply the update in CP by updating any phrase.
hmm, you sure? ... i gotta try this out.

[Wordplay]

yeah i had to do that too, but i had to do that on the other 2 hacks i installed that used new phrases as well. that's just the way to update all the phrases, by saving any.

[StarBuG]

Another nice litte feature addon would be if you could post a little image in the postbit if a user has a guestbook, like next to the IM Icons

Can you do that?

StarBuG

[Swedie]

Another nice litte feature addon would be if you could post a little image in the postbit if a user has a guestbook, like next to the IM Icons

Can you do that?

StarBuG
I'll write that down to include in a coming update.

[Reeve of shinra]

How customizable is this from a users perspective?

[Loki12]

I did a thorough test on the system today, and found that it is not completely working for me yet. :ermm:

The guestbook works perfectly, and shows on the member profile page.

The webpage does not work ... the edit page works, and it shows as an option in the usercp. But when I view the user profile after updating the webpage, I see nothing. Only the guestbook. :surprised:

[Swedie]

I did a thorough test on the system today, and found that it is not completely working for me yet. :ermm:

The guestbook works perfectly, and shows on the member profile page.

The webpage does not work ... the edit page works, and it shows as an option in the usercp. But when I view the user profile after updating the webpage, I see nothing. Only the guestbook. :surprised:
The webpage works when you have it enabled or disabled where and when and why and such. I gotta know more.

[Swedie]

Hey everyone using this script. Take this new member.php script and overwrite what the current code with. There is a bug fixed (not removing last guestbook entry correctly).

[Loki12]

The webpage works when you have it enabled or disabled where and when and why and such. I gotta know more.

It never works. It is enabled, and the editing page works through the usercp. But the webpage never shows on the profile page.

[Wordplay]

the webpage works perfectly fine on mine. u must've messed up loki.

[oldfan]

So its working now?

[oldfan]

I gave it a try and I got errors when I tried to install the tables :(

[Benj]

same here key 1 taken or something

[oldfan]

Ok i got it to work, BUT when I go into my profile and click on Webpage Content or
Guestbook Settings.
I get a blank page :(
Any clues why?

[rex_b]

Ok i got it to work, BUT when I go into my profile and click on Webpage Content or
Guestbook Settings.
I get a blank page :(
Any clues why?

That sounds like either you don't have the permissions set up or the templates haven't been installed.

[StarBuG]

Another suggestion:

It would be good to let people know when a new entry in the guestbook was made.
Like the pm notification or a pm for each new entry!?

StarBuG

[Wordplay]

first off, yeah the hack works perfectly fine if you install it correctly. i don't get how so many of y'all messed this up. i had a completely easy install, and everything worked form the start.

onlything that didn't work was deleting guestbook entries. but we got a fix for that now. thanks!

hey this is a completely out of the blue question. is it possible to count add every guestbook entry made to a user's post count. or what would be even better. i've got this shoutbox installed. it would be even better to add the count to that, but i guess you wouldn't want to go through all the trouble of making that possible since not everybody has the shoutbox installed.

[oldfan]

I've got the templates install and have set the permissions like the install says.
Everytime I got in admins permissions the webpage/guestbook are on "No", I then set it to "yes" and hit update.
The samething happens everything

look what I mean

http://bbs.metallifukinca.com/index.php?

test/test

[Lionel]

you probably have other hacks installed that are using the same bitfields number. Go back to init.php and verify that. If so, double the homepage bitfields values so they could be unique.

[oldfan]

you probably have other hacks installed that are using the same bitfields number. Go back to init.php and verify that. If so, double the homepage bitfields values so they could be unique.

thanks just tried that, I'm still getting the blank page :(

[Lionel]

But does it hold the permissions at least? Try to update them directly in mysql

[oldfan]

But does it hold the permissions at least? Try to update them directly in mysql

huh, what?
this is the tables is installed



# This creates all the database related
# tables and fields required for the
# webpage & guestbook script
#

CREATE TABLE `user_guestbook` (
`userid` varchar(100) NOT NULL default '',
`name` varchar(100) default '',
`lastentry` varchar(20) default '',
`status` char(3) NOT NULL default 'on',
`usesmilies` smallint(6) NOT NULL default '2',
`position` varchar(10) NOT NULL default 'right',
`text` text,
PRIMARY KEY (`userid`)
) TYPE=MyISAM;

CREATE TABLE `user_webpage` (
`userid` int(11) NOT NULL default '0',
`name` varchar(100) default '',
`description` varchar(255) default '',
`text` text,
`lastupdate` varchar(20) default '',
`bordersize` smallint(6) default '5',
`bordercolor` varchar(10) default '#ECECEC',
`bgcolor` varchar(10) default '#FFFFFF',
`font` varchar(100) default 'Arial, Helvetica',
`fontcolor` varchar(10) default '#000000',
`fontsize` char(3) default '2',
`usehtml` smallint(6) NOT NULL default '1',
`usesmilies` smallint(6) NOT NULL default '1',
`usevbcode` smallint(6) NOT NULL default '1',
`hits` int(11) NOT NULL default '5',
PRIMARY KEY (`userid`)
) TYPE=MyISAM;

ALTER TABLE vB3usergroup ADD canuseguestbook SMALLINT NOT NULL;
ALTER TABLE vB3usergroup ADD canusewebpage SMALLINT NOT NULL;

UPDATE vB3usergroup SET canuseguestbook = '1';
UPDATE vB3usergroup SET canusewebpage = '1';

INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowguestbook_desc', 'Allow guestbook in your users guestbooks?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowguestbook_title', 'Enable Guestbook?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowwebpage_title', 'Enable Webpage?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowwebpage_desc', 'Allow users to create their own webpage using HTML (on their profile page)', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'settinggroup_guestbookwebpage', 'Guestbook / Webpage Preferences', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_webpagevbcode_desc', 'Allow vBcode on webpage?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_guestbooksmilies_desc', 'Allow smilies in guestbook?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_webpagevbcode_title', 'Webpage vBcode?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_webpagesmilies_title', 'Webpage Smilies?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_guestbooksmilies_title', 'Guestbook Smilies?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_webpagesmilies_desc', 'Allow Smilies on webpage?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_webpagehtml_title', 'Webpage HTML?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_webpagehtml_desc', 'Allow HTML on webpage? Be aware that this CAN cause security issues and "hacking" attempts.', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'can_use_guestbook', 'Can use Guestbook?', 3);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'can_use_webpage', 'Can use Webpage?', 3);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowedhtmltags_title', 'Webpage HTML tags allowed', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowedhtmltags_desc', 'Which HTML tags do you want to allow? (Leave empty to allow all)', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'edit_webpage_content', 'Webpage Content', 1);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'edit_guestbook_settings', 'Guestbook Settings', 1);

INSERT INTO `vB3settinggroup` (grouptitle, displayorder, volatile) VALUES ('guestbookwebpage', 199, 1);

INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('allowguestbook', '1', 'yesno', 10, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('allowwebpage', '1', 'yesno', 20, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('guestbooksmilies', '1', 'yesno', 30, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('webpagevbcode', '0', 'yesno', 40, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('webpagesmilies', '0', 'yesno', 50, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('webpagehtml', '1', 'yesno', 60, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('allowedhtmltags', '<a><br><b><h1><h2><h3><h4><i><img><li><ol><p><strong><table><tr><td><th><u><ul><font><b><div>', 'textarea', 70, 'guestbookwebpage', '<a><br><b><h1><h2><h3><h4><i><img><li><ol><p><strong><table><tr><td><th><u><ul><font><b><div>', 0, 1);

[Lionel]

By looking at that db, I guess you'll have to read the posts. Your problem was addressed

[oldfan]

By looking at that db, I guess you'll have to read the posts. Your problem was addressed


Really? I most have missed it :(
Could you point out the page please/thank you ?

[Swedie]

Really? I most have missed it :(
Could you point out the page please/thank you ?
oldfan, you're using rex_b's SQL file. Where did you get that from? Download the latest .ZIP file and use the correct insert.SQL file. That will do the job.

Delete user_guestbook and user_webpage before you run the the SQL file though.

[Mickie D]

you dont think this maybe dangerous to give members html access ?



<a href="./../../../../../password/passwords.txt">click me</a>



just a thought ?

but then again i cant understand sweedish screenshots :( so i dunno what they all do ?

[oldfan]

oldfan, you're using rex_b's SQL file. Where did you get that from? Download the latest .ZIP file and use the correct insert.SQL file. That will do the job.

Delete user_guestbook and user_webpage before you run the the SQL file
though.


oh fart!
HOw do I remove the one I installed now?
Thanks for clearing that up :)

[StarBuG]

oh fart!
HOw do I remove the one I installed now?
Thanks for clearing that up :)
Go into your phpmyadmin (if you don?t have it yet get it at phpmyadmin.net) select your db, then the table. Mark both entries and at the bottom select delete ;)

StarBuG

[rex_b]

oh fart!
HOw do I remove the one I installed now?
Thanks for clearing that up :)

I feel somewhat to blame :disappointed:

[oldfan]

I can delete the guestbook and webpage no problem, but how do I delete the "INSERT INTO" ones?

[oldfan]

I tried install this

# This creates all the database related
# tables and fields required for the
# webpage & guestbook script
#

CREATE TABLE `vB3user_guestbook` (
`userid` varchar(100) NOT NULL default '',
`name` varchar(100) default '',
`lastentry` varchar(20) default '',
`status` char(3) NOT NULL default 'on',
`usesmilies` smallint(6) NOT NULL default '2',
`position` varchar(10) NOT NULL default 'right',
`text` text,
PRIMARY KEY (`userid`)
) TYPE=MyISAM;

CREATE TABLE `vB3user_webpage` (
`userid` int(11) NOT NULL default '0',
`name` varchar(100) default '',
`description` varchar(255) default '',
`text` text,
`lastupdate` varchar(20) default '',
`bordersize` smallint(6) default '5',
`bordercolor` varchar(10) default '#ECECEC',
`bgcolor` varchar(10) default '#FFFFFF',
`font` varchar(100) default 'Arial, Helvetica',
`fontcolor` varchar(10) default '#000000',
`fontsize` char(3) default '2',
`usehtml` smallint(6) NOT NULL default '1',
`usesmilies` smallint(6) NOT NULL default '1',
`usevbcode` smallint(6) NOT NULL default '1',
`hits` int(11) NOT NULL default '5',
PRIMARY KEY (`userid`)
) TYPE=MyISAM;

ALTER TABLE vB3usergroup ADD canuseguestbook SMALLINT NOT NULL;
ALTER TABLE vB3usergroup ADD canusewebpage SMALLINT NOT NULL;

UPDATE vB3usergroup SET canuseguestbook = '1';
UPDATE vB3usergroup SET canusewebpage = '1';

INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_allowguestbook_desc', 'Allow the guestbook in your users profile?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_allowguestbook_title', 'Enable Guestbook?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_allowwebpage_title', 'Enable Webpage?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_allowwebpage_desc', 'Allow users to create their own webpage using HTML (on their profile page)', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'settinggroup_guestbookwebpage', 'Guestbook / Webpage Preferences', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_webpagevbcode_desc', 'Allow vBcode on webpage?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_guestbooksmilies_desc', 'Allow smilies in guestbook?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_webpagevbcode_title', 'Webpage vBcode?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_webpagesmilies_title', 'Webpage Smilies?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_guestbooksmilies_title', 'Guestbook Smilies?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_webpagesmilies_desc', 'Allow Smilies on webpage?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_webpagehtml_title', 'Webpage HTML?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_webpagehtml_desc', 'Allow HTML on webpage? Be aware that this CAN cause security issues and "hacking" attempts.', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'can_use_guestbook', 'Can use Guestbook?', 3);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'can_use_webpage', 'Can use Webpage?', 3);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_allowedhtmltags_title', 'Webpage HTML tags allowed', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_allowedhtmltags_desc', 'Which HTML tags do you want to allow? (Leave empty to allow all)', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'edit_webpage_content', 'Webpage Content', 1);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'edit_guestbook_settings', 'Guestbook Settings', 1);

INSERT INTO `vB3settinggroup` (grouptitle, displayorder, volatile) VALUES ('guestbookwebpage', 199, 1);

INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('allowguestbook', '1', 'yesno', 10, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('allowwebpage', '1', 'yesno', 20, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('guestbooksmilies', '1', 'yesno', 30, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('webpagevbcode', '0', 'yesno', 40, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('webpagesmilies', '0', 'yesno', 50, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('webpagehtml', '1', 'yesno', 60, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('allowedhtmltags', '<a><br><b><h1><h2><h3><h4><i><img><li><ol><p><strong><table><tr><td><th><u><ul><font><b><div>', 'textarea', 70, 'guestbookwebpage', '<a><br><b><h1><h2><h3><h4><i><img><li><ol><p><strong><table><tr><td><th><u><ul><font><b><div>', 0, 1);



now I'm getting this error :(

MySQL said:
#1062 - Duplicate entry 'setting_allowguestbook_desc-1-5000' for key 2

[StarBuG]

you need to remove ALL entries by the script!
This error means that this entry is already in the database.
Go through each query and remove everything or add the missing querys ;)

StarBuG

[oldfan]

I was afraid you were going to say that :(

[oldfan]

ELETE FROM `vB3phrase` (
phraseid,
languageid,
varname,
text,
phrasetypeid
) VALUES (
'', '0', 'setting_allowguestbook_desc', 'Allow guestbook in your users guestbooks?', 5000
)

MySQL said:
#1064 - You have an error in your SQL syntax near '( phraseid,
languageid,
varname,
text,
phrasetypeid ) VALUES ( '', '0', 'sett' at line 1

[oldfan]

I'm tying to reverse the install of these "INSERT INTO"
Could someone please show me how to do it with the I pasted below.
I'm getting mixed up with the commands :(

INSERT INTO `vB3phrase`WHERE (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowguestbook_desc', 'Allow guestbook in your users guestbooks?', 5000);

thanks

[Swedie]

I'm tying to reverse the install of these "INSERT INTO"
Could someone please show me how to do it with the I pasted below.
I'm getting mixed up with the commands :(

INSERT INTO `vB3phrase`WHERE (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowguestbook_desc', 'Allow guestbook in your users guestbooks?', 5000);

thanks

oldfan! STOP!! right now! dude. what you doing. If you don't know how to do it, then please don't make your own attempts of "reversing" it with your guessing.

Run this .SQL and all YOU installed (using vB3 prefix on everything by mistake) will be erased. Then after that, you run the proper .SQL file coming with the .ZIP file in my first post.


DROP TABLE `user_guestbook`;
DROP TABLE `user_webpage`;

ALTER TABLE vb3usergroup DROP canuseguestbook;
ALTER TABLE vb3usergroup DROP canusewebpage;

DELETE FROM vb3phrase WHERE varname = 'setting_allowguestbook_desc' OR varname = 'setting_allowguestbook_title' OR varname = 'setting_allowwebpage_title' OR varname = 'setting_allowwebpage_desc' AND varname = 'settinggroup_guestbookwebpage' OR varname = 'setting_webpagevbcode_desc' OR varname = 'setting_guestbooksmilies_desc' OR varname = 'setting_webpagevbcode_title' OR varname = 'setting_webpagesmilies_title' OR varname = 'setting_guestbooksmilies_title' OR varname = 'setting_webpagesmilies_desc' OR varname = 'setting_webpagehtml_title' OR varname = 'setting_webpagehtml_desc' OR varname = 'can_use_guestbook' OR varname = 'can_use_webpage' OR varname = 'setting_allowedhtmltags_title' OR varname = 'setting_allowedhtmltags_desc' OR varname = 'edit_webpage_content' OR varname = 'edit_guestbook_settings';

DELETE FROM vb3settinggroup WHERE grouptitle = 'guestbookwebpage';

DELETE FROM vb3setting WHERE grouptitle = 'guestbookwebpage';

[hasan2k]

Hey Swedie

I have not heard from you. I sent two emails. Please respond.

[Swedie]

Hey Swedie

I have not heard from you. I sent two emails. Please respond.
If everyone remember, I had a date a while ago. And well, she's been here at my place for the last week. I've been "busy" with all of what that means. :p

[Lionel]

way to go swedie :up:

relax all you can and come back with some more hacks. :lick:

[Benj]

way to go swedie :up:

relax all you can and come back with some more hacks. :lick:

cheeky bugger :banana: :laugh:

[Wordplay]

swedie how is that update coming?

[Andreas]

Some things I'd like to see

Full-featured editor
Guestbook-entries on a separate page, with pagination
Possibility to edit entries
Notification when there is a new entry (PM/eMail)
Moer usergroup permissions: Can post in other guestbooks, Can edit own guestbook, Can edit own entries, Can edit other users guestbooks, Can delete own entries, Can delete entries in own guestbook, Can delete entries in other users guestbooks

[Loki12]

I deleted everything the first sql query did via phpMyadmin, and re-run the queries. Now it is working, and everything showing up. :)

*Loki12 clicks install!

[oldfan]

I did what you said and I got this error :(
MySQL said:
#1062 - Duplicate entry 'setting_allowguestbook_desc-1-5000' for key 2




oldfan! STOP!! right now! dude. what you doing. If you don't know how to do it, then please don't make your own attempts of "reversing" it with your guessing.

Run this .SQL and all YOU installed (using vB3 prefix on everything by mistake) will be erased. Then after that, you run the proper .SQL file coming with the .ZIP file in my first post.


DROP TABLE `user_guestbook`;
DROP TABLE `user_webpage`;

ALTER TABLE vb3usergroup DROP canuseguestbook;
ALTER TABLE vb3usergroup DROP canusewebpage;

DELETE FROM vb3phrase WHERE varname = 'setting_allowguestbook_desc' AND varname = 'setting_allowguestbook_title' AND varname = 'setting_allowwebpage_title' AND varname = 'setting_allowwebpage_desc' AND varname = 'settinggroup_guestbookwebpage' AND varname = 'setting_webpagevbcode_desc' AND varname = 'setting_guestbooksmilies_desc' AND varname = 'setting_webpagevbcode_title' AND varname = 'setting_webpagesmilies_title' AND varname = 'setting_guestbooksmilies_title' AND varname = 'setting_webpagesmilies_desc' AND varname = 'setting_webpagehtml_title' AND varname = 'setting_webpagehtml_desc' AND varname = 'can_use_guestbook' AND varname = 'can_use_webpage' AND varname = 'setting_allowedhtmltags_title' AND varname = 'setting_allowedhtmltags_desc' AND varname = 'edit_webpage_content' AND varname = 'edit_guestbook_settings';

DELETE FROM vb3settinggroup WHERE grouptitle = 'guestbookwebpage';

DELETE FROM vb3setting WHERE grouptitle = 'guestbookwebpage';

[Loki12]

I did what you said and I got this error :(
MySQL said:
#1062 - Duplicate entry 'setting_allowguestbook_desc-1-5000' for key 2

Then it probably means you have not ran this command Swedie gave:


DELETE FROM vb3phrase WHERE varname = 'setting_allowguestbook_desc' AND varname = 'setting_allowguestbook_title' AND varname = 'setting_allowwebpage_title' AND varname = 'setting_allowwebpage_desc' AND varname = 'settinggroup_guestbookwebpage' AND varname = 'setting_webpagevbcode_desc' AND varname = 'setting_guestbooksmilies_desc' AND varname = 'setting_webpagevbcode_title' AND varname = 'setting_webpagesmilies_title' AND varname = 'setting_guestbooksmilies_title' AND varname = 'setting_webpagesmilies_desc' AND varname = 'setting_webpagehtml_title' AND varname = 'setting_webpagehtml_desc' AND varname = 'can_use_guestbook' AND varname = 'can_use_webpage' AND varname = 'setting_allowedhtmltags_title' AND varname = 'setting_allowedhtmltags_desc' AND varname = 'edit_webpage_content' AND varname = 'edit_guestbook_settings';

Remember that your table will not necessarily be called "vb3phrase". Mine is simply called "phrase". I suggest going into the "phrase" table via phpMyadmin, and manually delete the specific phrase, then try again.

[oldfan]

I did run that command...

ALTER TABLE vB3usergroup DROP canuseguestbook;# Affected rows:9
ALTER TABLE vB3usergroup DROP canusewebpage;# Affected rows:9
DELETE FROM vB3phrase WHERE varname = 'setting_allowguestbook_desc' AND varname = 'setting_allowguestbook_title' AND varname = 'setting_allowwebpage_title' AND varname = 'setting_allowwebpage_desc' AND varname = 'settinggroup_guestbookwebpage' AND varname = 'setting_webpagevbcode_desc' AND varname = 'setting_guestbooksmilies_desc' AND varname = 'setting_webpagevbcode_title' AND varname = 'setting_webpagesmilies_title' AND varname = 'setting_guestbooksmilies_title' AND varname = 'setting_webpagesmilies_desc' AND varname = 'setting_webpagehtml_title' AND varname = 'setting_webpagehtml_desc' AND varname = 'can_use_guestbook' AND varname = 'can_use_webpage' AND varname = 'setting_allowedhtmltags_title' AND varname = 'setting_allowedhtmltags_desc' AND varname = 'edit_webpage_content' AND varname = 'edit_guestbook_settings';# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM vB3settinggroup WHERE grouptitle = 'guestbookwebpage';# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM vB3setting WHERE grouptitle = 'guestbookwebpage';# MySQL returned an empty result set (i.e. zero rows).


I got the error when I tried the install the sql in the new zip

Then it probably means you have not ran this command Swedie gave:




Remember that your table will not necessarily be called "vb3phrase". Mine is simply called "phrase". I suggest going into the "phrase" table via phpMyadmin, and manually delete the specific phrase, then try again.
ALTER TABLE vB3usergroup DROP canuseguestbook;# Affected rows:9
ALTER TABLE vB3usergroup DROP canusewebpage;# Affected rows:9
DELETE FROM vB3phrase WHERE varname = 'setting_allowguestbook_desc' AND varname = 'setting_allowguestbook_title' AND varname = 'setting_allowwebpage_title' AND varname = 'setting_allowwebpage_desc' AND varname = 'settinggroup_guestbookwebpage' AND varname = 'setting_webpagevbcode_desc' AND varname = 'setting_guestbooksmilies_desc' AND varname = 'setting_webpagevbcode_title' AND varname = 'setting_webpagesmilies_title' AND varname = 'setting_guestbooksmilies_title' AND varname = 'setting_webpagesmilies_desc' AND varname = 'setting_webpagehtml_title' AND varname = 'setting_webpagehtml_desc' AND varname = 'can_use_guestbook' AND varname = 'can_use_webpage' AND varname = 'setting_allowedhtmltags_title' AND varname = 'setting_allowedhtmltags_desc' AND varname = 'edit_webpage_content' AND varname = 'edit_guestbook_settings';# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM vB3settinggroup WHERE grouptitle = 'guestbookwebpage';# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM vB3setting WHERE grouptitle = 'guestbookwebpage';# MySQL returned an empty result set (i.e. zero rows).

[oldfan]

this is crazy, I run swedies command and tried to the sql in the zip and I get this error :)

Originally Posted by oldfan
I did what you said and I got this error
MySQL said:
#1062 - Duplicate entry 'setting_allowguestbook_desc-1-5000' for key 2

What I'm I doing wrong now :(

[seangworld]

wow, didn't know you released it. ok, time for me to try this bad boy out! :)

[Loki12]

this is crazy, I run swedies command and tried to the sql in the zip and I get this error :)

Originally Posted by oldfan
I did what you said and I got this error
MySQL said:
#1062 - Duplicate entry 'setting_allowguestbook_desc-1-5000' for key 2

What I'm I doing wrong now :(

It means you'll have to delete the old sql entries on your database before re-running the script again.

[Loki12]

wow, didn't know you released it. ok, time for me to try this bad boy out! :)

Good luck... you'll need it! ;)

[oldfan]

Isn't what this does?


DELETE FROM vb3phrase WHERE varname = 'setting_allowguestbook_desc' AND varname = 'setting_allowguestbook_title' AND varname = 'setting_allowwebpage_title' AND varname = 'setting_allowwebpage_desc' AND varname = 'settinggroup_guestbookwebpage' AND varname = 'setting_webpagevbcode_desc' AND varname = 'setting_guestbooksmilies_desc' AND varname = 'setting_webpagevbcode_title' AND varname = 'setting_webpagesmilies_title' AND varname = 'setting_guestbooksmilies_title' AND varname = 'setting_webpagesmilies_desc' AND varname = 'setting_webpagehtml_title' AND varname = 'setting_webpagehtml_desc' AND varname = 'can_use_guestbook' AND varname = 'can_use_webpage' AND varname = 'setting_allowedhtmltags_title' AND varname = 'setting_allowedhtmltags_desc' AND varname = 'edit_webpage_content' AND varname = 'edit_guestbook_settings';


It means you'll have to delete the old sql entries on your database before re-running the script again.

[Marco van Herwaarden]

Well this would only delete a row if in 1 row the field 'varname' would have the value 'setting_allowguestbook_desc' AND 'setting_allowguestbook_title' AND ..... at the same time.

This will never be the case.

Think you might be better of replacing those 'AND's by 'OR'. :D

[Swedie]

swedie how is that update coming?
Only received one donation so far. I aint busting anything to update. But I will look at it some time this week.

[Swedie]

Some things I'd like to see

Full-featured editor
Guestbook-entries on a separate page, with pagination
Possibility to edit entries
Notification when there is a new entry (PM/eMail)
Moer usergroup permissions: Can post in other guestbooks, Can edit own guestbook, Can edit own entries, Can edit other users guestbooks, Can delete own entries, Can delete entries in own guestbook, Can delete entries in other users guestbooks

When you pay me $100.

[Swedie]

Well this would only delete a row if in 1 row the field 'varname' would have the value 'setting_allowguestbook_desc' AND 'setting_allowguestbook_title' AND ..... at the same time.

This will never be the case.

Think you might be better of replacing those 'AND's by 'OR'. :D
oh crap! that's right. Sorry oldfan. This is what it should look like:

DELETE FROM vb3phrase WHERE varname = 'setting_allowguestbook_desc' OR varname = 'setting_allowguestbook_title' OR varname = 'setting_allowwebpage_title' OR varname = 'setting_allowwebpage_desc' OR varname = 'settinggroup_guestbookwebpage' OR varname = 'setting_webpagevbcode_desc' OR varname = 'setting_guestbooksmilies_desc' OR varname = 'setting_webpagevbcode_title' OR varname = 'setting_webpagesmilies_title' OR varname = 'setting_guestbooksmilies_title' OR varname = 'setting_webpagesmilies_desc' OR varname = 'setting_webpagehtml_title' OR varname = 'setting_webpagehtml_desc' OR varname = 'can_use_guestbook' OR varname = 'can_use_webpage' OR varname = 'setting_allowedhtmltags_title' OR varname = 'setting_allowedhtmltags_desc' OR varname = 'edit_webpage_content' OR varname = 'edit_guestbook_settings';

[oldfan]

I'm going to donate as soon as I get this working :)
Everything was going good until I hit this error :(


Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE vB3usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'xxxxxxx',
description = 'xxxxx:)',
usertitle = 'xxxxx:)',
opentag = '',
closetag = '',
passwordexpires = '0',
passwordhistory = '0',
attachlimit = '0',
avatarmaxwidth = '80',
avatarmaxheight = '80',
avatarmaxsize = '20000',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '65535',
pmquota = '50',
pmsendmax = '5',
uttstore_discount = '0',
forumpermissions = '61555',
pmpermissions = '0',
calendarpermissions = '16',
wolpermissions = '0',
adminpermissions = '0',
genericpermissions = '4162',
genericoptions = '30',
arcadepermissions = '1'
WHERE usergroupid=2
mysql error: Unknown column 'pmpermissions' in 'field list'

mysql error number: 1054

Date: Monday 08th of November 2004 01:03:55 PM
Script: http://xxxxxxxx/admincp/usergroup.php
Referer: http://xxx/xxx/xxxxxx/usergroup.php?s=&do=edit&usergroupid=2
Username: xxxxxxx
IP Address: xxxxxxxx

[Swedie]

it means that your table called pmpermissions has been removed. maybe you went into your database manually and started removing tables? (trying to blame you.. ;) j/k)

[oldfan]

dohhhhhhh....
can this be fixed?

[Marco van Herwaarden]

it means that your table called pmpermissions has been removed. maybe you went into your database manually and started removing tables? (trying to blame you.. ;) j/k)
Not the table but the column.

[Swedie]

Not the table but the column.
stop it, you're making me look bad :D

yeah. it is just names! it is of course column.

[Swedie]

dohhhhhhh....
can this be fixed?
yes, use this SQL command:

ALTER TABLE vB3usergroup ADD pmpermissions SMALLINT NOT NULL DEFAULT '0';

Then go into your Usergroup Manager and add PM permissions again for all the usersgroups you wish to allow it for.

[oldfan]

* oldfan clicks install and paypal buttons :)

[Wordplay]

is there anyway to change the time of the posts in the guestbook. apperently i can't get that to change, because it's all wrong.

[Marco van Herwaarden]

stop it, you're making me look bad :D

yeah. it is just names! it is of course column.
Sorry Swedie,

Never ment to make you look bad ;)

[HarryBO]

Hi!

I have read the complete Instructions very often, but I have the same error as many persons before!

Here is a screenshot! https://vborg.vbsupport.ru/attachment.php?attachmentid=21434

Otherwise I can?t see a webpage or a guestbook in my profile!

Must I changethe SQL File? Sorry I don?t understand all Posts here, because I came from Germany. It?s very hard to translate all the Postings!

I hope someone can help!

Ist hier vll. jemand deutschsprachiges, der den Hack zum Laufen bekommen hat?

[Andreas]

When you pay me $100.
Too much ... 10, maybe 15.
But for 100 bucks i'm gonna code that myself :)

[Benj]

ill give you 50 bucks if you can tell me how i can but the guestbook part of your script on a page of its own which i can link to from member.php like comments.php?u=8 dont have a use for the web page :/

[Swedie]

ill give you 50 bucks if you can tell me how i can but the guestbook part of your script on a page of its own which i can link to from member.php like comments.php?u=8 dont have a use for the web page :/
send 50 bucks first to swedie@wheeliepimp.com and I'll have that done for you right now. No problem.

[Swedie]

is there anyway to change the time of the posts in the guestbook. apperently i can't get that to change, because it's all wrong.
Well, you mean the date formatting? I can make it a setting in a future release.

I've started a new project and it is taking all my attention.

[Wordplay]

Well, you mean the date formatting? I can make it a setting in a future release.

I've started a new project and it is taking all my attention.
just curious where it's getting the time from. because my site isn't located in the usa, and that guest book is using usa time.

my site does promotion for asian parties, there are 3 parties i know of already i'll be promoting in december, i actually get alot of money for the promotion, and they'll pay the second the month starts. without your hack i wouldn't be able to have gotten so many hits i believe, because some ++++s just sit around practically chatting to each other on that guestbook. and man the next page button says nastra sida or something along those... letters. that's confusing. can't be in the templates, cause i searched through all those. but no biggy. just lettin you know, i'll get that donation to you the second i get payed, because until 2005 i intend to use all the money that comes in for the site anyways, i'll probably have a quick 50 bucks for you then.

but you know that, full featured ++++ for 100 bucks for a couple of features got me insanely curious. what would you pull off for 50 bucks? and you guys said paypal charges what an extra 14 bucks just for the transaction? so i'd be paying 64 bucks. that's still alright. let me know, whether you'd be willing to have some updates up for this for 50 bucks.

[Swedie]

money decides. I thought I was gonna get more out of this. But I am also aware that I rushed the release by mistake. I should've waited and bug-fixed everything before releasing. Maybe that would have more people interested in donating.

I'm making an ads script right now that is quite nice. I'll show it off later.

[Benj]

swedie dont get payed till next thu will pay then :) cheers

[PranK]

/me clicks install.

Thanks swedie!

[Snatch]

Sorry but i can not find everything about Phrases in your instruction text. Am I blind ?

[Benj]

the phrases are added in the insert.sql sql dump

[idslamyou]

I am getting this error when I am trying to execute the sql query in VB admin section:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ';

CREATE TABLE `user_webpage` (
`userid` int(11) NOT NULL default '0',
' at line 15

Can anyone help?

[PranK]

Hey Guys,

I just have a blank page when I click on 'edit webpage/guestbook' in the usercp.

I have read and reread the instructions a couple of times and have gone through this thread, but nothing is helping.... any help would be great!

Christian

[Snatch]

Hmm, i installed the hack without errors. But i can´t see any menues in AdminCP oder userCP nothing.

[FleaBag]

I got it working... A lot of the HTML is messed up though, I'm planning on cleaning up my templates and adding some new features.

Just wondering but why didn't you just use the user notes for a base for the guestbook? I can't think how there'd be a need for both?

[shawno]

Hey Swedie,

When you get a chance, could you take a look at the PM I sent you?

Later

Shawno

[Swedie]

I got it working... A lot of the HTML is messed up though, I'm planning on cleaning up my templates and adding some new features.

Just wondering but why didn't you just use the user notes for a base for the guestbook? I can't think how there'd be a need for both?
I haven't even had a look at user notes. Ever. I wanted it to look a certain way according to My website. Then when i showed it off to some here on vB.org i was requested to release it.

[KTBleeding]

This hack has so much potential, but it's just very confusing..

I have attempted an install several times, and each time there were new/ different errors. I seem to have fixed the errors I had from the first install, but now I'm running into even more.

Swedie, you keep talking about donations.. which is fine, but I don't think anyone is going to donate for something that doesn't work for them. Going by this thread, only a few people actually have installed this succesfully.

If I were able to get it running, I would have donated.. but I unfortuneately have not, and I don't want to take on another install/uninstall of this hack.

Overal, this is a very nice hack and I would donate in a second for your hard work Swedie, if I were able to get it up. Thanks for the contribution.

[cdoyle]

I am getting this error when I am trying to execute the sql query in VB admin section:



Can anyone help?

I get the same error, not sure what to do.

[idslamyou]

This hack has so much potential, but it's just very confusing..

I have attempted an install several times, and each time there were new/ different errors. I seem to have fixed the errors I had from the first install, but now I'm running into even more.

Swedie, you keep talking about donations.. which is fine, but I don't think anyone is going to donate for something that doesn't work for them. Going by this thread, only a few people actually have installed this succesfully.

If I were able to get it running, I would have donated.. but I unfortuneately have not, and I don't want to take on another install/uninstall of this hack.

Overal, this is a very nice hack and I would donate in a second for your hard work Swedie, if I were able to get it up. Thanks for the contribution.

I second this. I am more than willing to donate, but when I can't even get through the first step of the installation nor any support to help me get it installed, why should I donate?

[rex_b]

there has to be a way to put something in the postbit to show they have a webpage that doesn't take more than 5 minutes to whip up..

[Scerina]

This sounds very interesting...can someone please tell me more about this hack and how it works? What is the main purpose of this hack? Please contact me via email as am thinking of havin it installed and I would need help with the installations...my email address is:
Pandora@Sweet-November.Net

Thanx!

[Swedie]

An update to everyone! I just installed a Clean copy of vB3.0.3. I saw a couple of things thad had changed from version 3.0.0 Release Candidate 2 that i was using.

The changes has been uploaded to the new .ZIP file. Mostly it involves a couple of locations of lines in files that should be edit. I also noticed that the structure of some files has changed as well, making my installation script worthless.

I have NOT upgraded anything as far as HTML goes, or added any options. Just a new INSTALLATION INSTRUCTIONS file that should have most people understanding how to install this script.

Main "problem" i could see people is with the init.php file changes. THEREFOR I post MY VERSION of this, which is the CORRECT ONE FOR vB3.0.3 !

// 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,
'canseehiddencustomfields' => 262144,

// Reputation

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

DO NOT USE FOR ANY OTHER VB VERSION!

NOW, important for those that CANNOT see the "Can use Webpage?" text under Usergroup Settings. GO INTO YOUR "PHRASE MANAGER". Locate by searching for "can_use_guestbook" and specify to search in 'phrase variable name only'. Now click on Edit for 'can_use_guestbook'. And click "Save".

DONE! This will make sure the text under Usergroup Manager pops up!

[KTBleeding]

Good to hear Swedie! I will try this out tomorrow morning. :)

[KTBleeding]

It works!!!!!!!

Very nice of you to update, Swedie. Unfortuneately until next friday I am very short on cash so I won't be able to send a donation for another week or so..

Now here is just me being picky. Is there anyway to display the user who left a message on the guestbooks avatar under their name?

Also, is there any way to have the guestbook/webpage turned on by default, so it shows up in the profile unless they disable it?

Thanks again Swedie, it worked first time install this time. :)

* KTBleeding clicks install

[ChuanSE]

Swedie mate, first of all, congratz dude...
This is a great hack allright.

I have one request about it to make it perfect within vbulletin...

you use 2 parameters at the moment:


canuseguestbook
canuse webpage


this includes and "having" and "be able to post in" guestbook and having a webpage?

but to make this perfect we need the following set up :)


can view webpage
can view guestbook
can post guestbook
can have guestbook
can have webpage


If ya manage to make it like that, i'm ready for a nice donation ;)

ps: i need a vb php coder for a small job ;p

[Scerina]

Do you have one for a vb forum which is version 3.00????? I would luv to have this hack but I got an older version...v3

[Swedie]

Do you have one for a vb forum which is version 3.00????? I would luv to have this hack but I got an older version...v3
It works with vB3.0.0 as well. Only difference is the looks of init.php and usergroup.php. Here is how it looks with vb3.0.0.

INIT.PHP
// 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
);


USERGROUP.PHP
$ug_bitfield = array(
'showgroup' => 1, 'canview' => 1, 'canviewmembers' => 1,
'canuseguestbook' => 1, 'canusewebpage' => 1,
'canviewothers' => 1, 'cagetattachment' => 1, 'cansearch' => 1,
'canmodifyprofile' => 1, 'canthreadrate' => 1, 'canpostattachment' => 1,
'canpostpoll' => 1, 'canvote' => 1, 'canwhosonline' => 1,
'allowhidden' => 1, 'showeditedby' => 1, 'canseeprofilepic' => 1,
'canusesignature' => 1
);

Rest of the installation is the same.

I do suggest holding off. I have an update for this script now and it includes the WYSIWYG editor.

[Swedie]

ChuanSE, I will do those things. I have an updated version of this script that would do well with those settings. it's a rather simple fix.

I have cleaned up both the PHP code and HTML pretty good.

KTBleeding, i'll see about making it default. If so, by Admin default. (yes or no to be default).

[ChuanSE]

gimme the stuff mate, i'll go paypal then ;)
no scam, i mean it ;)

[influence]

ChuanSE, I will do those things. I have an updated version of this script that would do well with those settings. it's a rather simple fix.

I have cleaned up both the PHP code and HTML pretty good.

KTBleeding, i'll see about making it default. If so, by Admin default. (yes or no to be default).
hello,

are you going to post the updated version of this beautiful hack please?

also, is there anyway to include the bottom default vbulletin member info into your hack instead of them being below like that while your hack is at the top?

please let me know. i will see if i can donate something even though i dont wanna deal with paypal

[Swedie]

hello,

are you going to post the updated version of this beautiful hack please?

also, is there anyway to include the bottom default vbulletin member info into your hack instead of them being below like that while your hack is at the top?

please let me know. i will see if i can donate something even though i dont wanna deal with paypal
not sure i completely understand what you mean. Try again.

[trackpads]

Great hack!

I am still having two problems

1. See attached image. Ayn ideas on why that is happening?

2. My other problem is the display of the actual guestbook ni the profile bit. I am going to mess around with it some myself but for some reason no matter where I put the thing it still shows up smack in the middle of the profile. any ideas?

Thanks again for all your work,

-Jason

[Swedie]

Great hack!

I am still having two problems

1. See attached image. Ayn ideas on why that is happening?

2. My other problem is the display of the actual guestbook ni the profile bit. I am going to mess around with it some myself but for some reason no matter where I put the thing it still shows up smack in the middle of the profile. any ideas?

Thanks again for all your work,

-Jason
I don't see what the problem is really. Try again.

[trackpads]

I don't see what the problem is really. Try again.
In the image all the options are grren in my left side user cp menu, see above

[Swedie]

In the image all the options are grren in my left side user cp menu, see above
Sorry but only thing I could guess it be is that one of the values (in a $ string) is used also for coloring that installed modification you have there. Check your code for each block of code and see if something matches eachother (color options or class ids for table cells).

[KTBleeding]

ChuanSE, I will do those things. I have an updated version of this script that would do well with those settings. it's a rather simple fix.

I have cleaned up both the PHP code and HTML pretty good.

KTBleeding, i'll see about making it default. If so, by Admin default. (yes or no to be default).
Cool, I think that would be an awesome feature to include.

Until then, do you know of a way I could do it manually? While I wait for this update? :)

[Swedie]

Cool, I think that would be an awesome feature to include.

Until then, do you know of a way I could do it manually? While I wait for this update? :)
The next release will have Guestbook ON by default. So this means that if you visit a members profile a guestbook will automatically appear as if it always been there.

I should probably release this new update. But I'd like an admin to delete this thread, as the new version is way better.

[Nordinho]

The next release will have Guestbook ON by default. So this means that if you visit a members profile a guestbook will automatically appear as if it always been there.

I should probably release this new update. But I'd like an admin to delete this thread, as the new version is way better.

So are you going to release it?? If so will there be an upgrade script??

Greets Nordinho,

[KTBleeding]

The next release will have Guestbook ON by default. So this means that if you visit a members profile a guestbook will automatically appear as if it always been there.

I should probably release this new update. But I'd like an admin to delete this thread, as the new version is way better.
So are you going to release it?? If so will there be an upgrade script??

Greets Nordinho,
Yes, I'm also curious if there will be an upgrade now. :ermm: :)
EDIT: And is it for 3.0.3? :hurt:

[MojoNixon]

Well ... first of all ...amazing! looking for ages now for such a functionality.

Now i´m a little bit unsure ....install it right away or wait for the new version?
would be really nice if you can tell us when we can expect the release...

and by the away..if its working fine i will donate to you. Great work!

[KTBleeding]

Well ... first of all ...amazing! looking for ages now for such a functionality.

Now i?m a little bit unsure ....install it right away or wait for the new version?
would be really nice if you can tell us when we can expect the release...

and by the away..if its working fine i will donate to you. Great work!I would wait if I were you, it sounds like he pretty much has it completed.

[Swedie]

I would wait if I were you, it sounds like he pretty much has it completed.
Wait for the new version. It holds all the fixes and tweaks that might've been necassary before. It has a language file from where you can control all the texts. And also a HTML settings file for colors, font face, text sizes etc.

Bit more advance editor. You can choose either to go hardcore HTML (where just a handful of HTML tags are allowed (up to admin to set)), or take use of the vBulletin's WYSQMFAAS12F (never remember how to spell it out, haha! ) editor.

And there will be more usergroup options, such as the ones mentioned earlier by a member here. Things like: can post, can view, can edit .. etc.

I will supply you with a INSTALLATION UPDATE file also. It won't be overly dramatic to do the upgrade. I'll try to keep it simple.

[KTBleeding]

Cool Swedie, Is the guestbook html going to be a new template too? Or will it still be hard coded?

[ChuanSE]

The next release will have Guestbook ON by default. So this means that if you visit a members profile a guestbook will automatically appear as if it always been there.

I should probably release this new update. But I'd like an admin to delete this thread, as the new version is way better.

Swedie it doesn't work like that, this thread will stick around,

you have to edit the text in the first post you made and attach the new files...That's how it used to work around here allright ;D

ps: What You See Is What You Get (WYSIWYG) ;)

[Swedie]

Swedie it doesn't work like that, this thread will stick around,

you have to edit the text in the first post you made and attach the new files...That's how it used to work around here allright ;D

ps: What You See Is What You Get (WYSIWYG) ;)
Full feathered version will now also include a notification feature either by Email or PM.

[stamos2003]

works fine here, but at the guestbook my smilies are not working, whether the option is on or off :confused: there is just a : ) instead of a smilie ....

any ideas?

[stamos2003]

.... hmmm weird... no i turned the option at the admin c/p off and the smilies are working :p i guess i messed up some options :P

[Swedie]

.... hmmm weird... no i turned the option at the admin c/p off and the smilies are working :p i guess i messed up some options :P
Good you got it working.

Well the script is now almost final for release! I have a few more functions to add but the major stuff has been implemented and appears to be working nicely.

[KTBleeding]

Good you got it working.

Well the script is now almost final for release! I have a few more functions to add but the major stuff has been implemented and appears to be working nicely.
Can't wait. With my luck you'll release it tomorrow morning and it will tease me all day while I'm working. ;)

[Swedie]

Can't wait. With my luck you'll release it tomorrow morning and it will tease me all day while I'm working. ;)
Installed a new language system controlled through vBulletin administration area.

I have yet to add the "can post", "can view" feature.

If you wish for more features, list them!

[Nordinho]

Installed a new language system controlled through vBulletin administration area.

I have yet to add the "can post", "can view" feature.

If you wish for more features, list them!

clickable smilies in the guestbook editor...can't wait for this to be released!!

[KTBleeding]

Hmm, well these are just me being picky.. and I think you already plan on doing some of them, but just incase..

- Show users avatar when they comment in the gustbook.. (if someone doesn't want it they can remove it from the template.. so you don't have to add a "yes/no" option in the admincp)
- Guestbook is on by default.
- Guestbook HTML is a template rather than hardcoded (this isn't a big deal, just makes it easier to skin ;) )


That's about all I can think of. Maybe allow HTML in the guestbook (basic img, b, i, etc) or allow guestbook attachments that create thumbnails, like vb does. That's not really all that wanted for me though.

[ChuanSE]

Nononono, don't do that...
No html in the gb, no reason to. you forget the focus should stay on the forums :p. It's supposed to stay a small guestbook hehehe ;)

just my 2 cents :D

[MojoNixon]

well html on the userpages would be really nice ...so implement it .
i guess there are some people like me who want that html / page-building feature on the profiles. ;)

[Swedie]

well html on the userpages would be really nice ...so implement it .
i guess there are some people like me who want that html / page-building feature on the profiles. ;)
there won't be HTML nor vBcode in guestbooks.

HTML or vBcode for the webpage is an option set by the user.

It is gonna be hard to show an avatar since they're most often too big to fit. I would have to scale it down to something like 60x60 pixels so it fits OK'ish without messing up content.

[Swedie]

there won't be HTML nor vBcode in guestbooks.

HTML or vBcode for the webpage is an option set by the user.

It is gonna be hard to show an avatar since they're most often too big to fit. I would have to scale it down to something like 60x60 pixels so it fits OK'ish without messing up content.
okay, the Avatar and HTML or vBcode option is done.

[ogetbilo]

Installed the new version and worked fine.
But when a user updates his webpage content the default colors are different from the board's style as you can see in the attached file.
How can we fix the default color same with the style ?

[ogetbilo]

Same problem with the guestbook also. Can we change their colors ?
As you can see in laptopscreen3.jpg user control panel menu's style is wrong.

And in laptopscreen4.jpg guestbook color are not similiar with the boards style. Where can we change the colors to match the boards style ?

[ogetbilo]

I managed to fit the webpage part in the members profile to the style but i disabled my users to choose their background color , font color , border color. But where can I edit Guestbook colors ?
It is not in memberinfo template. I am not an expert but here is the memberinfo template I'm using <br />

<if condition="$show['signature']">
<br>

<if condition="$vboptions[allowguestbook] == '1'">
<if condition="$userinfo[permissions][canuseguestbook] == '1'">
<if condition="$webpage[gb_status] == 'on'">
<if condition="$webpage[gb_position] == 'right'">
<table width=100% border=0 cellspacing=0 cellpadding=0>
<tr><td valign=top>
</if>
<if condition="$webpage[gb_position] == 'left'">
<table width=100% border=0 cellspacing=0 cellpadding=0>
<tr><td valign=top width=350 nowrap>
$webpage[gb_html]
</td><td valign=top>
</if>
</if>
<else />
<table width=100% border=0 cellspacing=0 cellpadding=0>
<tr><td valign=top>
</if>
</if>

<if condition="$vboptions[allowwebpage] == '1'">
<if condition="$userinfo[permissions][canusewebpage] == '1'">

<table width=100% border=0 cellspacing=0 cellpadding=1>
<tr><td class="tborder" align="center">
<font size=2 color=cccccc><b>$userinfo[username]'s webpage</b></font>
</td></tr>
<tr><td class="thead" border=1 cellpadding=1>
<if condition="$webpage[description]">
<b>A?ıklama:</b> $webpage[description]
</if>
</td></tr>
</table>

<table width=100%>
<tr><td class="alt1" border=1 valign=top>

<if condition="$webpage[name]">
<font size=3><b>$webpage[name]</b></font><br>
</if>
<br>
<if condition="$webpage[text]">
$webpage[text]<br>
</font>
<else />
<font color="#CCCCCC">This user has no webpage content.</font>
</if>
<br>
<br>

<font size="small">
<i>View:</i> $webpage[hits]<br>
</font>

</td></tr>
</table>

<br />

</if>
</if>

<if condition="$vboptions[allowguestbook] == '1'">
<if condition="$userinfo[permissions][canuseguestbook] == '1'">
<if condition="$webpage[gb_status] == 'on'">
<if condition="$webpage[gb_position] == 'right'">
</td><td valign=top width=350 nowrap>
$webpage[gb_html]
</td></tr>
</table>
</if>
</if>
</if>
</if>

<if condition="$vboptions[allowguestbook] == '1'">
<if condition="$userinfo[permissions][canuseguestbook] == '1'">
<if condition="$webpage[gb_status] == 'on'">
<if condition="$webpage[gb_position] == 'left'">
</td></tr>
</table>
</if>
</if>
</if>
</if>

<if condition="$vboptions[allowguestbook] == '1'">
<if condition="$userinfo[permissions][canuseguestbook] == '1'">
<if condition="$webpage[gb_status] == 'on'">
<if condition="$webpage[gb_position] == 'bottom'">
$webpage[gb_html]
</if>
</if>
</if>
</if>

[ChuanSE]

okay, the Avatar and HTML or vBcode option is done.

When can we expect the release Swedie? :D

[Swedie]

ogetbilo, you're better of waiting for the new version to come out. it is much easier to change things for you now.

a few more days. I gotta write new installation instructions.