vb.org Archive - User Notes Icon/Link in Postbit, if user has notes

Page 2 of 3

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

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

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - User Notes Icon/Link in Postbit, if user has notes (https://vborg.vbsupport.ru/showthread.php?t=73534)

synn	01-28-2005 02:25 PM

I'm receiving the same db error as Trackpads...any fix for this?

DR?@M W?@V?R

01-28-2005 05:49 PM

Quote:

Originally Posted by alkatraz

Great idea! Makes the user notes feature a lot more useful and convenient

yeah I think It makes it more of a option for users to use it, its a great resource, just like a personal guestbook/journal/custom page.

Nice hack very simple but effective.https://vborg.vbsupport.ru/external/2011/01/19.gif

jluerken

01-28-2005 08:28 PM

Quote:

Originally Posted by trackpads

I got this whenever someone tried to open a post made by a guest user:

I have USENET import on my site and the posts from the usenet posters are guests.

Thanks,

-Jason

I get the same error. Any news?

h75	01-31-2005 02:05 AM

i git an db error after i install that hack. :devious:

Quote:

Datenbankfehler in vBulletin 3.0.6:

Ungueltige SQL-Abfrage:
SELECT MAX(dateline) AS lastpost, COUNT(*) AS total
FROM usernote AS usernote
WHERE userid =

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 '' at line 3

mysql error number: 1064

Datum: 31.01.2005 05:02:19
Skript: http://halloo.de/t.php?t=339
Referer: http://halloo.de/f.php?f=45
Benutzername: Hollii
IP-Adresse:

Mystics

02-03-2005 05:44 PM

Quote:

Originally Posted by h75

i git an db error after i install that hack. :devious:

Replace:

Code:

// ###### MOD display user notes in postbit if user has notes MOD ###### 

$usernote = $DB_site->query_first(" 

SELECT MAX(dateline) AS lastpost, COUNT(*) AS total 

FROM " . TABLE_PREFIX . "usernote AS usernote 

WHERE userid = $post[userid] 

"); 

$show['hasusernote'] = iif($usernote['total'], true, false); 

$show['usernotetotal'] = $usernote['total'];

with:

Code:

// ###### MOD display user notes in postbit if user has notes MOD ######

if ($post['userid'])

{

        $usernote = $DB_site->query_first("

                SELECT MAX(dateline) AS lastpost, COUNT(*) AS total

                FROM " . TABLE_PREFIX . "usernote AS usernote

                WHERE userid = $post[userid] 

        ");

        $show['hasusernote'] = iif($usernote['total'], true, false);

        $show['usernotetotal'] = $usernote['total'];

}

else

{

        $show['hasusernote'] = false;

        $show['usernotetotal'] = 0;

}

h75	02-03-2005 05:53 PM

Yeah! thats it! :) Thank you, Mystics.

Quote:

Originally Posted by Mystics

Code:

// ###### MOD display user notes in postbit if user has notes MOD ######

if ($post['userid'])

{

        $usernote = $DB_site->query_first("

                SELECT MAX(dateline) AS lastpost, COUNT(*) AS total

                FROM " . TABLE_PREFIX . "usernote AS usernote

                WHERE userid = $post[userid] 

        ");

        $show['hasusernote'] = iif($usernote['total'], true, false);

        $show['usernotetotal'] = $usernote['total'];

}

else

{

        $show['hasusernote'] = false;

        $show['usernotetotal'] = 0;

}

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

Jolten

03-30-2005 11:05 PM

Quote:

Originally Posted by Allan

No it doesn't. It pulls the usernotes if there are any.

Allan

03-31-2005 05:42 AM

Quote:

Originally Posted by Jolten

No it doesn't. It pulls the usernotes if there are any.

ok, but how creates usernotes ?

msimplay

04-10-2005 01:43 PM

A suggestion for this hack is if usernote contains a link to the post the new user note was made from

All times are GMT. The time now is 07:14 PM.

Page 2 of 3

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01969 seconds Memory Usage 1,739KB 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 (7)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 (10)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: