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! :]

[Amavisca]

Originally Posted by Guy G

Possible of course...

Ill see what i can do.

Ya plz do it, I was gonna have the same question 4 u

[Guy G]

Originally Posted by Amavisca

Ya plz do it, I was gonna have the same question 4 u

Ok im not sure this gonna happen, a new article system came out, a better one...

[Polo]

Is there a way so that the number of articles written is shown only if the members has 1 article or more? not many of my members post articles and I would not like to see a bunch of

"articles written : 0"

all over my site..

[kall]

Probably

PHP Code:

<if condition="$post[user_article_count]">Articles Written: $post[user_article_count]</if> 


[Polo]

Originally Posted by kall

Probably

PHP Code:

<if condition="$post[user_article_count]">Articles Written: $post[user_article_count]</if> 


thanks kall... I will give it a try

[Guy G]

Originally Posted by kall

<if condition="$post[user_article_count]">Articles Written: $post[user_article_count]</if>

if that wont work than this might

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

[Polo]

I'm starting to have some problems with v3articles .... now I'm almost in the 130th article and it seems like the system just cant handle more articles... so I think I will start looking into other options :ermm:

thank you for the help anyways, I really appreciate it...

[commTRU]

This is a really useful add-on.. Sadly I can't seem to get it to work. In the post bit it says that everyone has posted a article when I have :\

Its a really good idea though