pnConcept :: PostNuke Design and Custom Work

	Top News submitters
wicked	Posted: 24.05.2005, 02:55
Noob registered: Oct 27, 2004 Posts: 11 Status: offline last visit: 27.07.05	I try to create a block that shows the top news submitters on the last [period time] and it doesn't show anything :S This is the sql that i execute... Code $newDayRaw = (time()-(86400 * 7)); $newDB = Date("Y-m-d", $newDayRaw); $sql = "SELECT $userscolumn[uid], $userscolumn[uname], $userscolumn[counter], $newscolumn[time] FROM $userstable, $newstable AND $newscolumn[time] LIKE '%$newDB%'"; Where 7 is the number of days. Thanks for your support :)


Chestnut	Posted: 24.05.2005, 08:03
Site Admin registered: Jun 02, 2002 Posts: 1320 Status: offline last visit: 07.02.08	I'm not expert of this sort of things but from what I see... you are asking in your sql what news is LIKE 7days before and ... think I see another error. You are missing a where... Think something like this would be more appropriate : Code $newDayRaw = (time()-(86400 * 7)); $newDB = date("Y-m-d H:i:s", $newDayRaw); $sql = "SELECT $userscolumn[uid], $userscolumn[uname], $userscolumn[counter], $newscolumn[time] count(*) as ncount, FROM $userstable, $newstable WHERE $usercolumn[uname] = $newscolumn[informant] AND $newscolumn[time] >= '".pnVarPrepForStore($newDB)."'"; This is to tell the sql that you want the news where the username is like the news informant Code WHERE $usercolumn[uname] = $newscolumn[informant] And this is to get all what happened since 7 days ago Code AND $newscolumn[time] >= '".pnVarPrepForStore($newDB)."'"; The number of news for each user will be given in the "ncount" later in your code. Code list($uid, $uname, $newscounter, $newstime, $ncount) = $result->fields; Try this and see if it works... Chestnut ! Site Admin

wicked

Posted: 24.05.2005, 02:55

Noob

registered: Oct 27, 2004

Posts: 11

Status: offline
last visit: 27.07.05

I try to create a block that shows the top news submitters on the last [period time] and it doesn't show anything :S

This is the sql that i execute...

Code$newDayRaw = &#40;time()-(86400 * 7));
$newDB = Date&#40;"Y-m-d", $newDayRaw);
 
$sql  = "SELECT $userscolumn&#91;uid], $userscolumn[uname], $userscolumn[counter], $newscolumn[time] FROM $userstable, $newstable AND $newscolumn[time] LIKE '%$newDB%'"; 
 

Where 7 is the number of days.

Thanks for your support :)

Chestnut

Posted: 24.05.2005, 08:03

Site Admin

registered: Jun 02, 2002

Posts: 1320

Status: offline
last visit: 07.02.08

I'm not expert of this sort of things but from what I see... you are asking in your sql what news is LIKE 7days before and ... think I see another error. You are missing a where...

Think something like this would be more appropriate :

Code$newDayRaw = &#40;time()-(86400 * 7));
$newDB     = date&#40;"Y-m-d H:i:s", $newDayRaw);
 
$sql  = "SELECT $userscolumn&#91;uid],
                $userscolumn&#91;uname],
                $userscolumn&#91;counter],
                $newscolumn&#91;time]
                count&#40;*) as ncount,
         FROM   $userstable,
                $newstable
         WHERE  $usercolumn&#91;uname] = $newscolumn[informant]
         AND    $newscolumn&#91;time] >= '".pnVarPrepForStore($newDB)."'"; 
 

This is to tell the sql that you want the news where the username is like the news informant

CodeWHERE  $usercolumn&#91;uname] = $newscolumn[informant] 
 

And this is to get all what happened since 7 days ago

CodeAND    $newscolumn&#91;time] >= '".pnVarPrepForStore($newDB)."'"; 
 

The number of news for each user will be given in the "ncount" later in your code.

Codelist&#40;$uid, $uname, $newscounter, $newstime, $ncount) = $result->fields; 
 

Try this and see if it works...

Chestnut ! Cool

Site Admin

Login

Main Menu

Ressources

Online

Contribute

Spread FireFox