v3 Articles, How many Articles a user made (in postbit)

This is my first hack so please be nice to me :P
This is an addon for the v3Article hack which can be found HERE
Anyway, this hack will add a field in the postbit for how many articles a user has posted.

Specs:
Templates Edited:1
Queries added: 1 during new article post.
File Edits: 1
Tables Changed: 1
Installation Time: 3min

So, first of all open Article.php and find the following code:

PHP Code:

// insert new article
    $DB_site->query("INSERT INTO " . TABLE_PREFIX . "article
    (articleid,title,firstpostid,categoryid,open,articleusername,articleuserid,dateline,iconid,articlehash)
    VALUES (NULL,'" . addslashes($title) . "',
    0,
    $c,
    $open,
    '" . addslashes($bbuserinfo['username']) . "',
    '$bbuserinfo[userid]',
    " . TIMENOW . ",
    $iconid,
    '" . addslashes($posthash) . "')");
    $newarticleid = $DB_site->insert_id(); 


under it add:

PHP Code:

        $DB_site->query("UPDATE " . TABLE_PREFIX . "user 
        SET user_article_count = user_article_count+1 "); 


Now run this query through PhpMyAdmin or something...

PHP Code:

ALTER TABLE vb3_user` ADD `user_article_count` INT(10) UNSIGNED DEFAULT '0' NOT NULL; 


note that "vb3" should be your table prefix!

now after you done that its time for template editing..
go to postbit_legacy (for me) and search for this line:

PHP Code:

$vbphrase[posts]:</span> $post[posts]</div> 


directly under it add this(customize colors as you want..):

PHP Code:

<div class="postbit" align="left"">
                    <span style="color: #8B9DB0; font-weight: bold">Articles Written:</span> $post[user_article_count]</div> 


note: if you already created articles than it will not update your status, you will need to manually add the numbers to the ppl who posted articles.

Feel free to comment and enhance this hack by any way.

Thats it! your done Click Install! :]

[cinq]

I don't use this hack, but just wondering how did you call

PHP Code:

$post[user_article_count] 


without amending showthread.php ?

Also, instead of creating a new column in the user table, why not just query the article table for count(articleuserid) ?

[Guy G]

1. $post[user_article_count] uses the existing array that the showthread.php uses, so all i had to do is echo it.. showthread.php already SELECT * from vb3_user ...

2.you could do that, but it would be better to have 1 additional query used whenever posting a new article than adding an additional query to showthread.php which is excuted alot more times, therfore better performance :]

[cinq]

Ic. Thanks for the clarification,Zorobz

[BarHopper]

Im gonna defaintly use this, excellant. Also, on your screenshot, i see the boxes around the fields, in the postbit. How do you do that?

[Guy G]

thats just part of the style...

[Guy G]

Update hopefully coming soon...

[trackpads]

Excellent, gonna use for sure!

[KTBleeding]

Question: Is there an easy way to get this to link to all the articles submitted by the user? Rather than just listing how many they have posted, could it also link to them? Thanks.

[Guy G]

Originally Posted by KTBleeding

Question: Is there an easy way to get this to link to all the articles submitted by the user? Rather than just listing how many they have posted, could it also link to them? Thanks.

Possible of course...

Ill see what i can do.