User Comment System
 

This hack allows users to leave comments about users. It is integrated into the admin CP options and is configurable via the normal permissions system (by default, mods/smods/admins can delete user comments).

Admin CP options:

New setting in permissions:

getinfo:

Filburt as I said you are a god!

/me clicks install and goes to install it

Comments page:

And finally, leaving a comment:

Redo step 3, I forgot to add a link to post comments if the user already has one comment.

YES! Thank so much! :D Gonna install it in a few minutes.. I'll let you know how it goes.

when I ran install_usercomment.php I got this error when it tried to run the 3rd query.. what could be wrong?

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: ALTER TABLE "usergroup" ADD "candeleteusercomments"
SMALLINT(6) DEFAULT 0 NOT NULL
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '"usergroup" ADD "candeleteusercomments"
SMALLINT(6) DEF

mysql error number: 1064

Date: Sunday 13th of April 2003 02:11:37 PM
Script: http://www.texeo.com/web/web/admin/i...es=1&styleid=1
Referer: http://www.texeo.com/web/admin/install_usercomment.php

[high]* Black Vivi clicks install, but not gonna install it later.
[/high]
I'll prob redesign it alot aswell, but looks k00l;):D

Thanks, looks great.

Craig

Anybody else getting this?

Either way I updated the script with a query straight from PMA. Run this query:
[sql]
DROP TABLE usercomment;
[/sql]
Then re-run the install script.

This doesn't like me. I'm stumped on step one of running the installation script. :/

See my post above.

I ran that query and now I get this error
----------------------------------------------------------
Database texeoco_web running on localhost
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 22
STR: '
SQL: DROP TABLE usercomment'
Error

SQL-query :

DROP TABLE usercomment'

MySQL said:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1
Back

I edited my post one second after you copied that query :p, look again.

ok, I dropped it and reinstalled it.. same error

Hey filburt,

Would it be possible to allow groups the ability to only comment on users in the same group?

Would it be possible to enable the user of having there comments be viewed by only themselves and admins?

Gah! I HAD seen that post. I just didn't recognise it was the same error (and I downloaded just after seeing that. I assumed I had the updated version)! :-[

Same here. I get this error:

Craig

Try again.

Works great now.

Thanks
Craig

craigr.. what did you do?

It works better now. Just clear out your cache and redownload, etc.

thx zelda... worked :)

I've installed. Works great so far! :)

To leave comments about yourself remove this from commentaboutuser.php

You can also remove the template.

Works for me.

Craig

Not saying you have to create all these features but they would be nice to have....[list=1][*]Let yourself comment on yourself (incase people may want to ask questions and such then you can reply).[*]Time posted[*]give me a code to put their avatar somewhere in comment.[*]Other buttons like on the postbit (email, profile, etc).[*]Show most recent comment on the profile page (such as a simple value like $recentcomment). Have an extra template for this so we can customize the look of it[*]Have a reply button on the actual comment page[/list=1]

Most of these will probably be quite easy to do. I will have a tinker around with it myself.

You can leave a comment on yourself by doing what i stated above.

Craig

Kool, I hope you can do it :)

thx :D this is realy usefull :D
we got a kinda "coment the persone who posted b4 you" forum game and this wi'll be nice :D

I have installled this hack and everything appears to be fine apart from i don't see the links on the getinfo panel - i have double checked the info in installed correctly but when i click on the username there is no link there.
I have deleted my cashe etc but still can't see anything - any ideas?

Ok figured it out - thnx excellent hack - now they can call me names all they want....

well if you have a customized profile... it might not allow you to see it if you put it in the wrong part of the html code.. just find $header and put this below it..

<center><br><a href="viewusercomments.php?s=$session[sessionhash]&aboutuserid=$userid">View</a>/<a href="commentaboutuser.php?s=$session[sessionhash]&aboutuserid=$userid">Post</a> Comments</center>

and it should be centered right at the top of the profile page. then you can see if it works from their and customize it later

Works perfect guys on a 2.3.0 install...... anyone know a way so it can put like the last 3 or so comments in the getinfo?

im wondering the same oricon... I was it so you can set the options in the admin cp.. put

$recentcomments somewhere in the getinfo template and have it link to a template where you can customize the look of the comments....

then in vbulletinoptions you can set how many recent comments you want to show up in the getinfo... if I knew php I would do this but I dont... so oh well


I also would like a quick reply if possible... I know im asking for a lot here but its only to make a kick ass hack! :D

Here's another option I would like to see...

after x comments show next page

Nice1 filburt1. Yet another cool hack.

[high]* Intex added to install list :cool:.[/high]

*Whaps Install* Thank you! I've been waiting quite a while for something like this. :)