vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Counting users posts in particular forum? (https://vborg.vbsupport.ru/showthread.php?t=203766)

Simon Lloyd 02-01-2009 06:56 PM

Oki'll explain everyting i have done:
opened AdminMyPhp then my db, selected vb_user and added ctoptip to it with the settings you gave, i then created a plugin as follows with newthread_post_complete as the hook
PHP Code:

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


i then created a template called postbit_ctoptip
PHP Code:

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

i then created another plugin with postbit_display_start as the hook
PHP Code:

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

i then used this in my postbit
PHP Code:

My Top Tip Count$post[ctoptip

making a post via a form to the forum (id 52) does not produce an error nor does it increase the counter, making a post direct gave a db error as shown below
Quote:

Database error in vBulletin 3.8.1:

Invalid SQL:
UPDATE user SET ctoptip = ctoptip + 1 WHERE userid=1;

MySQL Error : Table 'thexxxx_CCxxxx.user' doesn't exist
Error Number : 1146
Request Date : Sunday, February 1st 2009 @ 07:11:35 PM
Error Date : Sunday, February 1st 2009 @ 07:11:35 PM
Script : http://www.thecodecage.com/forumz/ne...ostthread&f=52
Referrer : http://www.thecodecage.com/forumz/ne...newthread&f=52
IP Address : xx.xxx.xxx.xx
Username : Simon Lloyd
Classname : vB_Database
MySQL Version : 5.0.67-community
The manual post posted ok, So i'm not sure what to do now?

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

could it be because userid 1 is an uneditable user?, it still doesn't explain no increments for the posts by form to the top tips forum (id 52).

Lynne 02-01-2009 08:34 PM

Ah, I don't use table prefixes, thus my query did not contain the table prefix. You need to change user to vb_user for your site.

Do you have the hook newthread_post_complete in your form? If not, you either need to add it (find it in the vb code and paste it when something similar is happening in your form code) or you need to add the code you put in the plugin directly into your form code.

Simon Lloyd 02-01-2009 08:37 PM

Quote:

Originally Posted by Lynne (Post 1731298)
Ah, I don't use table prefixes, thus my query did not contain the table prefix. You need to change user to vb_user for your site.

Do you have the hook newthread_post_complete in your form? If not, you either need to add it (find it in the vb code and paste it when something similar is happening in your form code) or you need to add the code you put in the plugin directly into your form code.

Thanks once again!, you said
Quote:

or you need to add the code you put in the plugin directly into your form code
which one of the plugins that i created?

Lynne 02-01-2009 08:42 PM

The one with the update query that uses the newthread_post_complete hook location. That is the one that isn't getting run because you don't have the hook location in your form.

Simon Lloyd 02-01-2009 08:51 PM

As for user i don't have user so cannot change is it for vb_user.....think i'm in over my head with this!

Lynne 02-01-2009 09:38 PM

I'm talking about in the query:
PHP Code:

UPDATE user SET ctoptip ctoptip 

To:
PHP Code:

UPDATE vb_user SET ctoptip ctoptip 


Simon Lloyd 02-02-2009 06:09 AM

Quote:

Originally Posted by Lynne (Post 1731351)
I'm talking about in the query:
PHP Code:

UPDATE user SET ctoptip ctoptip 

To:
PHP Code:

UPDATE vb_user SET ctoptip ctoptip 


Ah!, thanks, see told you i'm no coder!, i'm going to get in touch with Bananalive (hopefully) to see about adding the hook to his form code.

Thanks for all your help!

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

BTW, changing the prefix worked for direct posts, it counts them and displays in the postbit, but the form delivery does not until i can get some help with where and how to deliver the hook location in the form code.

Lynne 02-02-2009 03:21 PM

You just need to add the hook location into your form. I've got it in my form (I didn't use a modification from here - I wrote my own). Just look at where it is in the current vb code and see if you have some similar code in your form and just add it in the same place.

Simon Lloyd 02-02-2009 03:29 PM

Quote:

Originally Posted by Lynne (Post 1732019)
You just need to add the hook location into your form. I've got it in my form (I didn't use a modification from here - I wrote my own). Just look at where it is in the current vb code and see if you have some similar code in your form and just add it in the same place.

Lynne, thanks, the mod from Bananlive already has a couple of boxes when you create your form to add your plugin or hook code to it, so your code put in the box for befroe_submit worked like a charm, although i have found now that i will need to have some code that deletes from the count as i have had my first occurrence of that, editing the database regularly will be a definate no no!

Lynne 02-02-2009 04:00 PM

I run the queries I posted to get the initial count every night as a cron job (scheduled task) since I haven't written a plugin for deleted threads either.


All times are GMT. The time now is 03:53 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.01110 seconds
  • Memory Usage 1,758KB
  • 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
  • (8)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)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