Threads notifications

Threads notifications show thread read req. as notification in notifications system 1.2 http://www.vbulletin.org/forum/showthread.php?t=183128


			hide_errors();
echo 'Adding Table : nlp_notifications_thread 
';vbflush();
$db->query_write("
	CREATE TABLE `" . TABLE_PREFIX . "nlp_notifications_thread` (
		`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
		`threadid` INT( 10 ) NOT NULL ,
		`dateline` INT( 10 ) NOT NULL,
		`forumid` INT( 10 ) NOT NULL,
		PRIMARY KEY ( `id`, `threadid` )
	)ENGINE = MYISAM ;
");
$db->show_errors();
echo 'Adding Table : nlp_notifications_read ';vbflush();
$db->query_write("
	CREATE TABLE `" . TABLE_PREFIX . "nlp_notifications_read` (
		`userid` INT( 10 ) NOT NULL ,
		`threadid` INT( 10 ) NOT NULL ,
		`dateline` INT( 10 ) NOT NULL
	)ENGINE = MYISAM ;
");
$db->show_errors();]]>
			show_errors();
echo 'Remove Table : nlp_notifications_read, nlp_notifications_thread'; vbflush();
$db->query_write("
	DROP TABLE `" . TABLE_PREFIX . "nlp_notifications_read` ,`" . TABLE_PREFIX . "nlp_notifications_thread`
");
$db->show_errors();]]>

Threads notifications - fetch notifications in list notifications_list options['nlp_notifications_active'] AND $vbulletin->userinfo['userid']) { // fetch custom permission (exusers) AND (exusergroupids) $NLP['notifications']['usergroupid'] = (in_array($vbulletin->userinfo['usergroupid'], explode(',', $vbulletin->options['nlp_notifications_exusergroups']))) ? true : false; $NLP['notifications']['userid'] = (in_array($vbulletin->userinfo['userid'], explode(',', $vbulletin->options['nlp_notifications_exusers']))) ? true : false; // fetch user readed threads $notifications_get = $vbulletin->db->query_read(" SELECT * FROM " . TABLE_PREFIX . "nlp_notifications_read WHERE userid = " . $vbulletin->userinfo['userid'] . iif(((THIS_SCRIPT == 'SHOWTHREAD') AND $threadid),'AND threadid =' . $threadid)); while($notifications_ids = $db->fetch_array($notifications_get)) { $notifications_threadids .= ', ' . $notifications_ids['threadid']; } foreach (array_keys($vbulletin->forumcache) AS $key => $id) { if (!($vbulletin->userinfo['forumpermissions'][$id] & $vbulletin->bf_ugp_forumpermissions['canview']) OR !($vbulletin->userinfo['forumpermissions'][$id] & $vbulletin->bf_ugp_forumpermissions['canviewthreads'])) { $notifications_forumids .= ', ' . $id; } } $notifications_thrds = $vbulletin->db->query_read_slave(" SELECT threadid FROM " . TABLE_PREFIX . "nlp_notifications_thread WHERE threadid NOT IN (0$notifications_threadids) AND forumid NOT IN (0$notifications_forumids) ORDER BY dateline ASC "); $vbulletin->userinfo['nlp_notifications_thread'] = intval($db->num_rows($notifications_thrds)); $notificationsidf = $db->fetch_array($notifications_thrds); $notifications['nlp_notifications_thread'] = array( 'phrase' => $vbphrase['nlp_notifications_threads'], 'link' => ($notificationsidf['threadid']) ? 'showthread.php?'.$vbulletin->session->vars['sessionurl'].'t=' . $notificationsidf['threadid'] : '', 'order' => 15 ); }]]> Threads notifications - something happent in SHOWTHREAD showthread_start options['nlp_notifications_active']) { if(!in_array($threadid, explode(',', $notifications_threadids)) AND $vbulletin->userinfo['userid'])// fix userid = 0 value(insert no need val) : Bug#2 { // if not readed yet ;) => instert into DB thread as readed $vbulletin->db->query_write(" INSERT INTO `" . TABLE_PREFIX . "nlp_notifications_read` ( `userid` , `threadid` , `dateline` ) VALUES ( '" . $vbulletin->userinfo['userid'] . "', '$threadid', '" . TIMENOW . "' ) "); } if(can_moderate($threadinfo['forumid']) AND !$NLP['notifications']['usergroupid'] AND !$NLP['notifications']['userid']) { // templates replacing. $nlp_notifications_phrase = iif(!in_array($threadid,explode(',', $notifications_threadids)),construct_phrase($vbphrase['nlp_notifications_add_thread']),construct_phrase($vbphrase['nlp_notifications_remove_thread'])); $vbulletin->templatecache['SHOWTHREAD'] = str_replace( '$vbphrase[remove_redirects]', '$vbphrase[remove_redirects]\n

$nlp_notifications_phrase

', $vbulletin->templatecache['SHOWTHREAD'] ); } }]]> Threads notifications - add,remove notification threadmanage_action_switch options['nlp_notifications_active'] AND $_REQUEST['do'] == 'notifications') { $forumid = false; // only mods with the correct permissions should be able to access this if (!can_moderate($threadinfo['forumid']) OR $NLP['notifications']['usergroupid'] OR $NLP['notifications']['userid']) print_no_permission(); // check data $NLP['notifications']['exists']= $vbulletin->db->query_first(" SELECT * FROM " . TABLE_PREFIX . "nlp_notifications_thread WHERE threadid = $threadid "); if(empty($NLP['notifications']['exists'])) { // add thread in notifications list for users $vbulletin->db->query_write(" INSERT INTO " . TABLE_PREFIX . "nlp_notifications_thread (`threadid` ,`dateline`, `forumid`) VALUES ( '$threadid', '" . TIMENOW . "', '" . $threadinfo['forumid'] . "' ) "); // redirect back to thread #$threadid eval(print_standard_redirect('redirect_nlp_notifications_thread_add', true, true)); }else{ // if notifications exists , remove if from notifications list ;) $vbulletin->db->query_write(" DELETE FROM " . TABLE_PREFIX . "nlp_notifications_thread WHERE threadid = $threadid "); $vbulletin->db->query_write(" DELETE FROM " . TABLE_PREFIX . "nlp_notifications_read WHERE threadid = $threadid "); // redirect back to thread #$threadid eval(print_standard_redirect('redirect_nlp_notifications_thread_removed', true, true)); } }]]> áÊÚØíá åÐå ÇáÎÇÕíÉ ÇÊÑßåÇ ÝÇÑÛÉ Çæ ÖÚ ÕÝÑ "0"]]> áÊÚØíá åÐÇ ÇáÎíÇÑ ÇÊÑßå ÝÇÑÛ Ãæ ÇÖÝ ÑÞã "0"]]> integer yesno 1 free free