Daily submissions block [Q and A] - XOOPS Web Application System

Daily submissions block

2009/4/21 10:42
deka87
Friend of XOOPS
Posts: 1125
Since: 2007/10/5

Hi, I need a block that would show recent submissions like this: "There's been 5 news, 10 articles, 8 downloads, 20 terms submitted today".

any ideas?

Mind anchors

Re: Daily submissions block

2009/4/21 12:55
trabis
Core Developer
Posts: 2269
Since: 2006/9/1 1

Just create the block and add it to an existent module, or create new module to hold the block.

You don't need to use module handlers, you can use queries like SELECT COUNT... FROM ... WHERE datefield > 24hoursago

Look at news module story class and look for stats method to get more ideas.

LatinoPoemas

Re: Daily submissions block

2009/4/21 13:00
trabis
Core Developer
Posts: 2269
Since: 2006/9/1 1

You can also look at mypoints plugins.
Here is one example:

 function news_useritems_count($uid, $since) 
{ 
    global $xoopsDB; 
    list($ret) = $xoopsDB->fetchRow($xoopsDB->query("SELECT  COUNT(*)  FROM ".$xoopsDB->prefix("stories")." WHERE (uid='$uid' AND published > '$since')")); 
    return $ret; 
}

Since must be a valid timestamp
$since = time() - 24*60*60;
will give last 24 hours (not today).

LatinoPoemas

Stats
Goal:	$100.00
Due Date:	Jul 31
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Daily submissions block

Re: Daily submissions block

Re: Daily submissions block

Login

Search

Recent Posts

PHP 8.4.0 Alpha 1 released

Overview of the Composer packages in Admin

Re: xoops_getBaseDomain

xoops_getBaseDomain

Re: Test 3

Test 3

Re: Test2

Re: Test2

Re: Test2

Test2

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}