How to decrease count in database automatically?

[Simon Lloyd]

Hi all,
Currently i have two plug-ins to count "Top Tips" that are submitted by a form to a specific forum, every member of my forums has a "My Top Tips" count in their info bar along with a button to submit more if they wish.

My problem is they can submit a tip and the count increases fine, so mine shows 5, joe bloggs will show 3....etc however if the post is deleted the figure doesn't decrease and i have to go to the database and change the count manually, can anyone tweak my plugins to do this automatic please?

Originally Posted by 1st plugin:

PRODUCT: VBulletin
HOOK LOCATION: postbit_display_start
EXECUTION ORDER: 5

PHP Code:

eval('$template_hook[postbit_userinfo_right] .= " ' . fetch_template('postbit_ctoptip') . '";'); 


Originally Posted by 2nd plugin

PRODUCT: VBulletin
HOOK LOCATION: newthread_post_complete
EXECUTION ORDER: 5

PHP Code:

if (in_array($foruminfo['forumid'], array('52'))) { 
    $db->query_write("UPDATE vb_user SET ctoptip = ctoptip + 1 WHERE userid=" . $vbulletin->userinfo['userid']); 
} 


and this is the content of the template postbit_ctoptip

PHP Code:

<if condition="$post['ctoptip']>= '1'">$post[ctoptip] Top Tips<br /></if> 


[Lynne]

You'll need to add a plugin that is called when the post is deleted and then change the count there. When in debug mode, go to delete a post and all the hook locations that are available on that page will be listed on the bottom of the page.

[Simon Lloyd]

Originally Posted by Lynne

You'll need to add a plugin that is called when the post is deleted and then change the count there. When in debug mode, go to delete a post and all the hook locations that are available on that page will be listed on the bottom of the page.

Lynne how do i set vbulletin in debug mode?

[Lynne]

Add this at the top of your config.php file right under <?php :

    $config['Misc']['debug'] = true;

I would suggest only doing this on your test site, or putting a condition around that to only show it to your IP.

[Simon Lloyd]

Originally Posted by Lynne

Add this at the top of your config.php file right under <?php :

    $config['Misc']['debug'] = true;

I would suggest only doing this on your test site, or putting a condition around that to only show it to your IP.

Thanks for that, i don't have a test site and i think it will be ok as it will only be for a few minutes

--------------- Added [DATE]1244483578[/DATE] at [TIME]1244483578[/TIME] ---------------

Lynne, could you tell me which hook i should use for the plugin?
Hooks Called:
init_startup
fetch_userinfo_query

style_fetch
cache_templates
global_start
parse_templates

notifications_list
global_setup_complete

I have this line to remove from the count:

PHP Code:

 if (in_array($foruminfo['forumid'], array('52'))) {  
    $db->query_write("UPDATE vb_user SET ctoptip = ctoptip -1 WHERE userid=" . $vbulletin->userinfo['userid'] . " and ctoptip > 0"); 


--------------- Added [DATE]1244485448[/DATE] at [TIME]1244485448[/TIME] ---------------

The above were the hooks called prior to me choosing soft or permanent delete!

[Simon Lloyd]

Lynne any thoughts with this?

[Lynne]

What script is it you are calling to delete the post? Are you talking about a user deleting it or a mod deleting it? Both of those are different scripts. You'll have different hooks called for each. If a user is doing it in the post, perhaps an editpost_ hook. Go see where those are and if one of them makes sense to use (do a search through your files for "editpost_"). If it's the Moderator dropdown box (so a moderator), then that takes you to the inlinemoderation.php page. Take a look at that page for which hooks are used.

[Simon Lloyd]

Originally Posted by Lynne

What script is it you are calling to delete the post? Are you talking about a user deleting it or a mod deleting it? Both of those are different scripts. You'll have different hooks called for each. If a user is doing it in the post, perhaps an editpost_ hook. Go see where those are and if one of them makes sense to use (do a search through your files for "editpost_"). If it's the Thread Tools (so a moderator), then that takes you to the inlinemoderation.php page. Take a look at that page for which hooks are used.

Its when a mod or admin deletes the post.....users do not hav ethe permissions to delete. If your sure its an editpost_...etc hook i'll try a few of them until it works
Thanks!

--------------- Added [DATE]1244572968[/DATE] at [TIME]1244572968[/TIME] ---------------

im going to try this hook: inlinemod_deletethread

--------------- Added [DATE]1244573206[/DATE] at [TIME]1244573206[/TIME] ---------------

It didnt work with the plugin code but didn't cause an error

[Lynne]

What did you put in the inlinemod_deletethread plugin? Did you find that hook location in the code and verify the variables you are using are correct? (And I thought you were deleting a post, not a thread.)

[Simon Lloyd]

Hi Lynne, the post/thread will be un answerable the thread is created by a form, users do not have permission to reply or post, so in effect im deleting the thread, im using this in the plugin

PHP Code:

if (in_array($foruminfo['forumid'], array('52'))) {   
    $db->query_write("UPDATE vb_user SET ctoptip = ctoptip -1 WHERE userid=" . $vbulletin->userinfo['userid'] . " and ctoptip > 0");