The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
MYSQL Query to count words written
I've got a query written that more or less counts words, that I can execute on a per-user basis because it needs the userid in WHEREs.
What I'd like to do is be able to update the entire table and run it as a cron job -- but I can't figure out how to get the userid into the subquery. X = userid @thisuser = where I need the userids Code:
SET @thisuser := X; UPDATE user SET words = (SELECT SUM(words) FROM (SELECT LENGTH(p.pagetext) - LENGTH(REPLACE(p.pagetext, ' ', ''))+1 AS words FROM post as p WHERE userid = @thisuser UNION ALL SELECT LENGTH(gm.pagetext) - LENGTH(REPLACE(gm.pagetext, ' ', ''))+1 AS words FROM groupmessage as gm WHERE postuserid = @thisuser) a) WHERE userid = @thisuser; Suggestions? |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|