vb.org Archive - Show Thread Enhancements - Usernote in Postbit v.1.2

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

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Show Thread Enhancements - Usernote in Postbit v.1.2 (https://vborg.vbsupport.ru/showthread.php?t=73599)

tnguy3n

12-31-2004 10:00 PM

Usernote in Postbit v.1.2

Requested here

Modded by tnguy3n
This mod shows number of usernote in postbit, and usernote is visible only to the user and administrator of the board. You can make it visible to more usergroup by adding usergroupid in the conditionals.

File mod: 1
Template mod: 1
Installation time: 2-3 mins

SFishy

01-01-2005 03:38 AM

This is a duplicate (or very similar) of what I posted yesterday.

https://vborg.vbsupport.ru/showthread.php?t=73534

tnguy3n

01-01-2005 03:47 AM

how would that be similar? did you see the code of this hack? yours show the number of notes in postbit?

SFishy

01-01-2005 04:00 AM

Quote:

Originally Posted by tnguy3n

how would that be similar? did you see the code of this hack? yours show the number of notes in postbit?

Yes I saw your code. Did you look at mine? It DOES shows the number of notes a user has in postbit.

"Description: https://vborg.vbsupport.ru/showthread.php?t=73534
This modification adds an icon and link to a member's usernotes in the postbit template. The icon will only appear to the people with proper permissions for viewing notes. The icon will only appear IF the member actually has usernotes posted about them. Icon links directly to that member's notes. Rolling over the icon reveals the number of notes a member has posted about them."

tnguy3n

01-01-2005 09:16 AM

Quote:

Originally Posted by SFishy

ehh, I was just to clarify what you called "similar" in my codes & yours. anyway, i made this mod as it's requested here . If you think it's should not be posted here, just PM ask forum mod to remove it. I can't btw.

SFishy

01-01-2005 04:18 PM

Quote:

Originally Posted by tnguy3n

TNguy,

I think all mods should be welcome. I was just stating that I had done a similar one. The post you referred to here was from September. I bumped it up because I was looking for something similar, but ended up doing it with the help of a friend since no one here seemed particular interested (my newer request here and my mod here).

Polo	01-03-2005 01:35 PM

Nice, exactly what I was looking for ;) Thanks

Polo	01-18-2005 01:11 PM

this mod creates alot of queries :( anyway to reduce them?

wynode

01-26-2005 10:08 AM

Quote:

Originally Posted by Polo

this mod creates alot of queries :( anyway to reduce them?

Is that true?

I'm not sure whether to use this hack or this one:

https://vborg.vbsupport.ru/showthread.php?t=73534

Jolten

01-26-2005 08:00 PM

Well I use this one.. But either one works fine. If you don't want an icon and you want the number of notes to be visible. This one is a little better.

Polo	01-26-2005 08:24 PM

I like this one but like I said... it uses too many queires... :ermm:

wynode

01-26-2005 10:52 PM

Quote:

Originally Posted by Polo

I like this one but like I said... it uses too many queires... :ermm:

More than the other one? (Because I preffer this one which shows the number of usernotes!)

Polo	01-27-2005 12:06 PM

Yeah I think so... I like this one too better but seems like I will wait to install it until somone make it less query intensive

Ig@r	03-18-2005 03:48 PM

Quote:

Originally Posted by Polo

Yeah I think so... I like this one too better but seems like I will wait to install it until somone make it less query intensive

Eah.... one extra querry for each post. :(

Polo	03-18-2005 03:56 PM

I was using this one for a while but had to take it down.. i wondering if there is even a way to make it less query intenssive... maybe there is not way at all...

wynode

03-19-2005 12:29 AM

Quote:

Originally Posted by Polo

I was using this one for a while but had to take it down.. i wondering if there is even a way to make it less query intenssive... maybe there is not way at all...

How come you took it down?

Polo	03-19-2005 12:39 AM

because the hack is query intensive...

tnguy3n

03-23-2005 01:40 PM

okie, I've just did a minor fix to it. I use query_first() instead of query(), and besides, it only shows if the users have a note.
*update hack*

To update, look for:

PHP Code:


		
			
        // show usernote in postbit

        $usernote = $DB_site->query("

        SELECT COUNT(*) AS usernoteid FROM " . TABLE_PREFIX . "usernote

        WHERE userid = $post[userid]");

        $totalnotes = mysql_result($usernote, 0, 'usernoteid');

REPLACE WITH:

PHP Code:


		
			
        // show usernote in postbit

        $usernote = $DB_site->query_first("

        SELECT COUNT(*) AS usernote FROM " . TABLE_PREFIX . "usernote

        WHERE userid = $post[userid]");

        $totalnotes = $usernote['usernote'];

Polo	03-23-2005 03:08 PM

it still uses one query per post?

tnguy3n

03-30-2005 03:27 PM

it's per thread.

Polo	03-30-2005 05:26 PM

Quote:

Originally Posted by tnguy3n

it's per thread.

oh cool! in that case I may install this little addon ;)

Allan

03-30-2005 06:45 PM

but one needs a hack which allows creates a note before being able to use your hack !

a hack is needed as that (https://vborg.vbsupport.ru/showthread.php?t=75429) which creates initially a personal note ....

wynode

03-31-2005 07:39 AM

Quote:

Originally Posted by Allan

Huh? VB3 comes with usernotes built in by default!

Polo.......how did you go with this new(hacked) version?

Allan

03-31-2005 07:58 AM

Quote:

Originally Posted by wynode

Huh? VB3 comes with usernotes built in by default!

Polo.......how did you go with this new(hacked) version?

then, I does not understand can you show me how one reaches has these notes please ! :rolleyes:

wynode

04-01-2005 07:04 AM

Quote:

Originally Posted by Allan

then, I does not understand can you show me how one reaches has these notes please ! :rolleyes:

Don't mean to be rude but its prob best to either read through the VB user manual or search the VB.com forums as it would be going off topic on this thread.

Polo	04-01-2005 12:25 PM

I havent installed this yet, will in the future though... :)

nso	04-30-2005 12:22 PM

Actually. This does add lots of queries.

Queries on thread before install: 11
Queries on same thread after install: 24

Polo	05-01-2005 10:07 PM

Quote:

Originally Posted by nso

Actually. This does add lots of queries.

Queries on thread before install: 11
Queries on same thread after install: 24

ouch :ermm: I think i will not install this one after all then...

All times are GMT. The time now is 03:02 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01467 seconds Memory Usage 1,786KB 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 (2)bbcode_php_printable (12)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (28)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: