Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
Prev Previous Post   Next Post Next
  #1  
Old 10-15-2012, 10:03 PM
CoffeeLovesYou CoffeeLovesYou is offline
 
Join Date: Feb 2010
Posts: 176
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Notification on New Database Row

Hi,

I have a form set up to make a request. After a user makes a request, it then shows up on a table and our Mod views it.
However, how can I make a Notification appear on the notification list when there is a new request, aka a new row in the table?
I am using the Group Membership Requests modification, and all it has is 1 phrase and the rest is 1 plugin, which is using the hook notifications_list. Here is the only plugin.

PHP Code:
$requests $vbulletin->db->query_read("
                SELECT COUNT(*) AS CountRequests, "
.TABLE_PREFIX."usergrouprequest.usergroupid as GroupID, ".TABLE_PREFIX."usergroupleader.userid
                FROM "
.TABLE_PREFIX."usergrouprequest
                                INNER JOIN "
.TABLE_PREFIX."usergroupleader ON
                                ("
.TABLE_PREFIX."usergrouprequest.usergroupid = ".TABLE_PREFIX."usergroupleader.usergroupid)
                                WHERE "
.TABLE_PREFIX."usergroupleader.userid= ".$vbulletin->userinfo['userid']."
                                GROUP BY GroupID
        "
);

if (
$vbulletin->db->num_rows($requests) == 1) {
  
$request $vbulletin->db->fetch_array($requests);
  
$vbulletin->userinfo['groupmembership_requests'] = $request['CountRequests'];
  
$groupurl "joinrequests.php?usergroupid=".$request['GroupID'];
 }
else if (
$vbulletin->db->num_rows($requests) > 1) {
  
$vbulletin->userinfo['groupmembership_requests'] = 0;
  
$count $vbulletin->db->num_rows($requests);
  for ( ; 
$count 0$count-- ) {
   
$request $vbulletin->db->fetch_array($requests);
     
$vbulletin->userinfo['groupmembership_requests'] += $request['CountRequests'];

  }
      
$groupurl "profile.php?do=editusergroups";
 } else {
  
$groupurl "profile.php?do=editusergroups";
  
$vbulletin->userinfo['groupmembership_requests'] = 0;
 }
          

    
$notifications['groupmembership_requests'] = array(
            
'phrase' => $vbphrase['groupmembership_requests'],
            
'link'   => $groupurl $vbulletin->session->vars['sessionurl_q'],
            
'order'  => 12); 
This mod basically, if you are a leader of a usergroup that has 1 or more join requests that need to be processed, you get a notification.
I want to modify it to give a notification when a new row is added to my table.
If anyone can guide me, please and Thank You!
Reply With Quote
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03397 seconds
  • Memory Usage 2,319KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_threadedmode.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete