Usernote in Postbit v.1.2

[tnguy3n]

Requested here (https://vborg.vbsupport.ru/showthread.php?t=69165)

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]

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

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

[tnguy3n]

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

[SFishy]

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]

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."
ehh, I was just to clarify what you called "similar" in my codes & yours. anyway, i made this mod as it's requested here (https://vborg.vbsupport.ru/showthread.php?t=69165) . If you think it's should not be posted here, just PM ask forum mod to remove it. I can't btw.

[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 (https://vborg.vbsupport.ru/showthread.php?t=69165) . If you think it's should not be posted here, just PM ask forum mod to remove it. I can't btw.
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 (https://vborg.vbsupport.ru/showthread.php?t=69165) 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 (https://vborg.vbsupport.ru/showthread.php?t=73430) and my mod here (https://vborg.vbsupport.ru/showthread.php?t=73534)).

[Polo]

Nice, exactly what I was looking for ;) Thanks

[Polo]

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

[wynode]

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]

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]

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

[wynode]

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]

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]

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]

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]

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]

because the hack is query intensive...

[tnguy3n]

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:
// 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:
// 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]

it still uses one query per post?

[tnguy3n]

it's per thread.

[Polo]

it's per thread.
oh cool! in that case I may install this little addon ;)

[Allan]

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]

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 ....
Huh? VB3 comes with usernotes built in by default!

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

[Allan]

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]

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]

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

[nso]

Actually. This does add lots of queries.

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

[Polo]

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