Letter counter

[Sho]

First of all, I want to apologize for my horrible English.

Now, my request. Alongside the post counter, I want a letter counter for my postbit template. Well, I'm not good at this stuff, that's why I'm posting a request, but I believe it shouldn't be too hard to do. A new column in the post table, one in the user table, some changes to newreply.php, newthread.php, showthread.php and probably member.php. Hm. It's probably hard to count the letters in existing posts, but maybe someone can come up with an addition to the "Update Counters" thingie.

Anyone interested?

[Xenon]

you can try that:

open functions.php find:

PHP Code:

    // do posts from ignored users
    if (($ignore[$post[userid]] and $post[userid] != 0)) {
        eval("\$retval = \"".gettemplate("postbit_ignore")."\";"); 


before that add:

PHP Code:

$post[numchars]=strlen($post[pagetext]); 


then add $post[numchars] in your postbit template

[Sho]

Hmm. Haven't tried it yet, but it seems surprisingly simple.

My explanation was probably too inaccurate. I want a letter counter for all posts a member has written, not just the current one.

Well, going to try that now.

[Sho]

Nope, that's not what I'm looking for. Amazing nonetheless.

[Xenon]

ah ok, missunderstood...

yes you're right then you have to add a field to user-table called letters

then open newreply.php and newthread.php
find:

PHP Code:

          $DB_site->query("UPDATE user SET
          ".iif ($foruminfo[countposts],"posts=posts+1,","")." 


change it to:

PHP Code:

          $DB_site->query("UPDATE user SET letters=letters+".strlen($message).",
          ".iif ($foruminfo[countposts],"posts=posts+1,","")." 


[Sho]

Hmm ... and editpost.php?

[Xenon]

that's a bit more complicated...

also if you want to get all old posts involved...

at first open editpost find this:

PHP Code:

  $postinfo[message]=htmlspecialchars($postinfo[pagetext]); 


below add:

PHP Code:

 $postinfo[len]=strlen($postinfo[pagetext]) 


then you have to edit your editpost template add(twice):

<input type="hidden" name="postlen" value="$postinfo[len]">

<input type="hidden" name="postid" value="$postid">

then back in editpost.php
after

PHP Code:

    $DB_site->query("UPDATE post SET title='".addslashes(htmlspecialchars($title))."',pagetext='".addslashes($message)."',allowsmilie='$allowsmilie',showsignature='$signature',iconid='$iconid'$editedbysql$attachmentsql WHERE postid='$postid'"); 


add this:

PHP Code:

$DB_site->query("UPDATE user SET letters=".($bbuserinfo[letters]-$postlen+strlen($message))." WHERE userid=".$buserinfo[userid]); 


then find:

PHP Code:

eval("standardredirect(\"".gettemplate("redirect_deletepost")."\",\"showthread.php?s=$session[sessionhash]&threadid=$threadinfo[threadid]\");"); 


before add:

PHP Code:

$DB_site->query("UPDATE user SET letters=".($bbuserinfo[letters]-$postlen)." WHERE userid=".$buserinfo[userid]); 


should be all

[Sho]

*starts implementing*

[Dean C]

this is interesting...

*bookmarks thread*

- miSt

[Logician]

If you are trying to calculate the total number of characters a user posted to your board, maybe you can find this easier to adopt. Basically 1 SQL query can calculate it easily:

SELECT SUM(LENGTH(pagetext)) FROM `post` WHERE userid=X

You can integrate it to vb like:

PHP Code:

$charcount=$DB_site->query_first("SELECT SUM(LENGTH(pagetext)) as char FROM `post` WHERE userid='$bbuserinfo[userid]'");
$bbuserinfo['charcount']=$charcount['char']; 


by adding this at the end of say, global.php. Then you can use the variable $bbuserinfo['charcount'] in any template you want (like getinfo etc.). This might not work for postbit, but there is also a solution for this if you are tying to implement it into postbit..

One obvious advantage of making a dynamic query is that the number returned will be always up to date after message editing, deleting etc.

Enjoy..