Letter counter

[Xenon]

thanks pal

i found out the same way yesterday night, after reading a book about mysql functions....

[Dean C]

haha cool... so that is all it takes logician?

- miSt

[Logician]

Originally posted by Mist
haha cool... so that is all it takes logician?

well I didnt test it myself but it seems ok so yes, it is all it takes..

[Dean C]

does it add any extra queries on any of the pages??

- miSt

[Logician]

Originally posted by Mist
does it add any extra queries on any of the pages??
- miSt

Yes it adds 1 query.. (Whenever you see a "..$DB_site->query..." term in a hack code, automatically add 1 query)

If you add the hack to global.php, the variable will be accessible in the entire vb scripts and 1 extra query will be added to all vb pages.

On the other hand you might want to consider adding the line to the relevant script if you only want to use it in a particular place like getinfo template(= User Info Page). Then 1 query will be added only when that particular page is loaded..

Your call..

[Dean C]

yes i'll probably use it in member.php

Thanks a lot Logician

- miSt

[Charles_1]

Originally Posted by 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

Hi Xenon,

I did my search here, but I found only old topics regarding my need. I need counting of characters for each post in one specific forum, but solution that you wrote, is not applicable to present version of vBulletin (3.6.x). I tried to look for mentioned lines in file functions.php, but without success (which is not surprise after 5 years of modifications of vB). So could you please provide to me solution for actual version of vB? I just need that posts in one specific forum would have information about number of characters included in them. Nothing more :-).

[Taragon]

Originally Posted by 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..

Very sorry for bumping this old request , but would this still work with vb 3.6/3.7?

Currently I'm running into this db error:

Database error in vBulletin 3.7.0 Release Candidate 1:

Invalid SQL:
SELECT SUM(LENGTH(pagetext)) as char FROM `post` WHERE userid='';

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'char FROM `post` WHERE userid=''' at line 1
Error Number  : 1064
Date          : Saturday, March 22nd 2008 @ 01:46:55 PM
Script        : http://www.letsgather.net/demo/
Referrer      : 
IP Address    : 62.166.43.206
Username      : Taragon
Classname     : vB_Database
MySQL Version : 4.1.22-standard

[Logician]

Wow.. A bump after 6 years!

Code for 3.6-3.7 must be:

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

However this adds 1 query to each page load and I don't suggest using it in a heavy traffic/busy board or forum with a lot of posts. It is neither optimized, nor a clean hack!

[Taragon]

Thanks! And sorry again for the bump.
I was looking for something, and this was the only similar thing I could find.