vb.org Archive - User Comment System

Page 3 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - User Comment System (https://vborg.vbsupport.ru/showthread.php?t=51570)

filburt1

05-04-2003 08:33 PM

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

Boofo

05-04-2003 09:23 PM

Quote:

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

05-06-2003 11:36 AM

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

Code:

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

05-06-2003 01:31 PM

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

Jacko

05-06-2003 01:52 PM

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

filburt1

05-06-2003 01:54 PM

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

filburt1

05-06-2003 01:57 PM

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

05-06-2003 02:50 PM

Quote:

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

05-07-2003 09:48 PM

Quote:

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

05-08-2003 03:18 AM

Ok
Thanks for that drumsy

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

Here is the code in usergroup.php

Code:

$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 :

Code:

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 ?

Boofo

05-08-2003 03:24 AM

Change this:

PHP Code:


		
			
$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)");

To this:

PHP Code:


		
			
$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,$cancalendar,$canpublicevent,$canpublicedit,$canthreadrate,$cantrackpm,$candenypmreceipts,$maxbuddypm,$maxforwardpm,$canwhosonline,$canwhosonlineip,$cangetattachment)");

You forgot the $cancalendar

SemperFidelis

05-08-2003 10:38 AM

Outstanding.
All is working fine now.

Thankyou very much Boofo.
:)

ap0c	05-24-2003 01:02 AM

Quote:

04-13-03 at 03:21 PM Craigr said this in Post #31
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

clicks install...
Craig, have you done any of these yet?

SinisterX

05-27-2003 04:19 AM

ok maybei 'm stupid but where is step 3. 3. In getinfo, find:

where is this getinfo file? :(

Boofo

05-27-2003 04:32 AM

getinfo is a template.

filburt1

06-01-2003 01:14 PM

As I've said numerous times, this is included in the advanced version of this hack which I do not publicly release.

Chris M

06-01-2003 04:07 PM

Nice mr filby:)

Satan

Dan	06-01-2003 04:10 PM

Now if I had the money filbie was asking for.... I'd be a happy man and buy it.

/me hates being broke

groovesalad

06-02-2003 06:21 PM

Is there anyway to add a "View Comments" in the postbit?

Dan	06-02-2003 06:41 PM

just make a normal link from the postbit to the comments.... the same code in the getinfo should work to do that

kino	06-02-2003 07:43 PM

Can you modify this to meet this:
I am building a clan hack and want a commenting/chat feature on each clan page. So is it possible to integrade it to that page so people can chat on the clan page?

SaintDog

06-03-2003 06:46 AM

Not that everyone else has not already said it, but great hack, it is installed at SpyderWire and will serve as a great tool. I usually don't add hacks, but 2.3.0 sounds and is stable, so I hope it will remain that way :).

DaveRobbo

07-23-2003 02:37 PM

How about a notification system so that a user gets (say) a PM when someone adds a comment?

FleaBag

10-17-2003 12:21 AM

Is there a way this can be enabled so only admin specified users can have user comments?

Also, I can't get your paid hacks page to load.

filburt1

10-17-2003 10:32 AM

Quote:

Originally Posted by FleaBag

Also, I can't get your paid hacks page to load.

A DDoS attack on another server on my host's network caused the whole network to go down yesterday. It should be fine now.

FleaBag

10-23-2003 01:33 PM

As I asked before, can you tell me how I can modify this so only usergroups or specific users I denote can use the comments system?

Logitech-2004

11-17-2003 09:33 PM

wheres the getinfo ????

Logitech-2004

11-17-2003 09:50 PM

it's not showing up in post.... only 1 option showed up in the admin panel, allow multi comments

Logitech-2004

11-17-2003 10:06 PM

n/m got it working, still no 2nd option in admin panel!
i put mine on the postbits, quicker to find :)

Logitech-2004

11-17-2003 10:19 PM

Lookie :)

Kaelon

01-30-2004 05:02 AM

Installed and working under vBulletin 2.3.2. Very nicely done.

Tips to people thinking about installing this: be sure to pick up the modified viewusercomments.php for built-in pagination. The usergroup bug which was mentioned earlier -- and whose fix is already included in this thread -- also needs to be fixed. Just refer to the notes on Page 7 for the fix to admin/usergroup.php

Crank

02-22-2004 10:10 PM

what about having a setting for only mods/admins being able to make and view comments

ChrisBaktis

03-06-2004 05:23 AM

Quote:

Originally Posted by Dan

just make a normal link from the postbit to the comments.... the same code in the getinfo should work to do that

This HACK works great on my 2.3.4 version but I tried adding the code from getinfo to the postbit template4 to get feedback link on ths posts but I get errors

Invalid user specified. If you followed a valid link, please notify the webmaster

I used this code which I copied from getinfo

Most Recent <a href="viewusercomments.php?s=$session[sessionhash]&aboutuserid=$userid">Comments about $userinfo[username]</a>

Can someone help me with what im missing?

Kaelon

03-10-2004 01:40 AM

ChrisBaktis -- your $userid needs to be $userinfo[userid] =)

Crank -- You can easily do this with Logician's Template Conditionals hack.

Benj	01-05-2005 11:08 AM

any chance of a vb3 version ?

gcallman

09-16-2005 09:48 PM

Hi

I ?m working on a site for an international non-profit organization. The online community will be key, and so we?re looking at various ways to incorporate member to member feedback into the site. Before beginning this research, we planned a hack that we thought might do the trick. It?s outlined below. However, we would like to ask if you all think that other, existing hacks-like this one- might be equally/more functional. Anyway here was our idea:

First, one would create a forum exclusively for positive feedback.
The hack would then:

1) Create a new thread for each user upon registration. The thread could be named after the user in some standard format. (amykhar already did this, it seems: https://vborg.vbsupport.ru/showthrea...light=feedback Would her hack work as part of this scheme?)
2) Paste the URL for that user?s feedback thread directly into his/her signature, perhaps just after ?Feedback at:?

We thought this might be a very elegant way to incorporate feedback into VB, as the forum?s features would very functional. For example:

It would be easy to click from a users post to his/her feedback thread, because the link would be in the signature. Likewise, it would be easy to jump to or from their profile, which would facilitate making contact.
Because the forum is only for positive feedback, ranking by post would have meaning.
Similarly, hot threads would point to people who have done a lot of good work recently.
The report bad post feature could be used to report the presence of negative feedback.
We?re assuming that everyone would subscribe to their own feedback thread and so would be automatically notified.

Thanks

All times are GMT. The time now is 04:17 AM.

Page 3 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01381 seconds Memory Usage 1,838KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (4)bbcode_php_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (36)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: