vb.org Archive - Getting difference between previous posted thread in same section.

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

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - Getting difference between previous posted thread in same section. (https://vborg.vbsupport.ru/showthread.php?t=315379)

3lou 55

11-12-2014 11:28 AM

Getting difference between previous posted thread in same section.

Hello,

I am creating a plugin that checks wether the user has already made a thread in the past 12 hours.
If they do, then don't allow them to make the thread.
All I need to know is how I would get the last inserted thread's time and then compare it to the actual time.
Is there anyone that can help me with this one?

Cheers,

kh99	11-12-2014 11:46 AM

I think you could do a query like this:

PHP Code:


		
			
$limit = 3600 * 12; // seconds in 12 hours
$result = $vbulletin->db->query_first("SELECT dateline FROM ".TABLE_PREFIX."thread WHERE postuserid = $userid ORDER BY dateline DESC");
if ($result && TIMENOW-$result['dateline'] < $limit)
{
   // too soon
}

You could do it all in SQL by something like "WHERE UNIX_TIMESTAMP()-dateline < $limit", but this way if you want to display how long the user has to wait, you have the time of his last thread.

All times are GMT. The time now is 10:07 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00986 seconds Memory Usage 1,710KB 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 (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)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: