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

[filburt1]

I'd rather not post it publicly but for future reference:

[Boofo]

04-21-03 at 04:36 PM rake said this in Post #73
I don't personally use this hack, since i've designed my own user comments system, but i decided to help out. Upload the file below and add $pages somewhere in your "usercomments" template and you'll have pagination.

Rake.

rake, how is yours different from this one? I'd be interested in seeing it.

[SemperFidelis]

Hmmm
Great idea for a hack filburt1
Thanks.


Just one thing, has anyone been able to sucessfully add a new group since adding this hack ?

Below is what I am now getting

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: INSERT INTO usergroup (candeleteusercomments, usergroupid,title,usertitle,cancontrolpanel,canmodifyprofile,canviewmembers,canview,showgroup,cansearch,canemail,canpostnew,canmove,canopenclose,candeletethread,canreplyown,canreplyothers,canviewothers,caneditpost,candeletepost,canusepm,canpostpoll,canvote,canpostattachment,ismoderator,canpublicevent,canpublicedit,canthreadrate,cantrackpm,candenypmreceipts,maxbuddypm,maxforwardpm,canwhosonline,canwhosonlineip,cangetattachment)
	VALUES (NULL,'Banned by Warnings','',0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0)
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Tuesday 06th of May 2003 07:57:10 PM
Script: http://localhost/rnas/rnas/admin/usergroup.php
Referer: http://localhost/rnas/admin/usergroup.php?action=add&s=

[filburt1]

That's a known bug; easy to fix but I don't have the time.

[Jacko]

will you have time for the payed version if i get it cause everything but the known bug is making me buy it.

[filburt1]

I believe this is fixed in the paid version (it definitely is in my webmail hack which uses the same concept), checking now.

[filburt1]

Yes, it's fixed in that version.

(to those who want to fix it in the meantime, just update the VALUES part of the INSERT query to add $candeleteusercomments).

[SemperFidelis]

Today at 03:57 PM filburt1 said this in Post #87
Yes, it's fixed in that version.

(to those who want to fix it in the meantime, just update the VALUES part of the INSERT query to add $candeleteusercomments).

Huh ?
[high]* SemperFidelis pleads stupid[/high]

[drumsy]

Yesterday at 11:50 AM v-net said this in Post #88
Huh ?
* v-net pleads stupid

Find:

PHP Code:

VALUES (NULL,'".addslashes($title)."','".addslashes($usertitle)."' 


Replace with:

PHP Code:

VALUES ($candeleteusercomments,NULL,'".addslashes($title)."','".addslashes($usertitle)."' 


[SemperFidelis]

Ok
Thanks for that drumsy

But if Ive done what you have suggested correctly, it hasnt worked.

Here is the code in usergroup.php

$DB_site->query("INSERT INTO usergroup (candeleteusercomments, usergroupid,title,usertitle,cancontrolpanel,canmodifyprofile,canviewmembers,canview,showgroup,cansearch,canemail,canpostnew,canmove,canopenclose,candeletethread,canreplyown,canreplyothers,canviewothers,caneditpost,candeletepost,canusepm,canpostpoll,canvote,canpostattachment,ismoderator,cancalendar,canpublicevent,canpublicedit,canthreadrate,cantrackpm,candenypmreceipts,maxbuddypm,maxforwardpm,canwhosonline,canwhosonlineip,cangetattachment)
	VALUES ($candeleteusercomments,NULL,'".addslashes($title)."','".addslashes($usertitle)."',$cancontrolpanel,$canmodifyprofile,$canviewmembers,$canview,$showgroup,$cansearch,$canemail,$canpostnew,$canmove,$canopenclose,$candeletethread,$canreplyown,$canreplyothers,$canviewothers,$caneditpost,$candeletepost,$canusepm,$canpostpoll,$canvote,$canpostattachment,$ismoderator,$canpublicevent,$canpublicedit,$canthreadrate,$cantrackpm,$candenypmreceipts,$maxbuddypm,$maxforwardpm,$canwhosonline,$canwhosonlineip,$cangetattachment)");

And here is the error Im now getting :

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: INSERT INTO usergroup (candeleteusercomments, usergroupid,title,usertitle,cancontrolpanel,canmodifyprofile,canviewmembers,canview,showgroup,cansearch,canemail,canpostnew,canmove,canopenclose,candeletethread,canreplyown,canreplyothers,canviewothers,caneditpost,candeletepost,canusepm,canpostpoll,canvote,canpostattachment,ismoderator,cancalendar,canpublicevent,canpublicedit,canthreadrate,cantrackpm,candenypmreceipts,maxbuddypm,maxforwardpm,canwhosonline,canwhosonlineip,cangetattachment)
	VALUES (1,NULL,'Testing Group','Im A Test User !',0,1,1,1,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1,1,1,1,0,0,0,1,0,1)
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Thursday 08th of May 2003 12:13:55 PM
Script: http://localhost/rnas/rnas/admin/usergroup.php

Have I messed up or does something else need to be done ?