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

[Black Vivi]

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

[Craigr]

Thanks, looks great.

Craig

[filburt1]

Today at 02:12 PM Xelation said this in Post #10
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

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.

[Zelda-King]

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

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 near '"usergroup" ADD "candeleteusercomments"
SMALLINT(6) DEFAULT 0 NOT NULL' at line 1

mysql error number: 1064

Date: Sunday 13th of April 2003 12:22:56 PM
Script: http://www.gamercrossfire.net/bb/bb/...es=1&styleid=4
Referer: http://www.gamercrossfire.net/bb/adm...sercomment.php

[filburt1]

See my post above.

[filburt1]

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

[Xelation]

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

[Xelation]

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

[bharvey42]

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?

[Zelda-King]

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)! :-[