2013/2/25 22:35
preachur
Just can't stay away
Posts: 525
Since: 2006/2/4 4
$query_Recordset1 = "SELECT custom AS muser_id, option_selection1 as showname, DATE_FORMAT(payment_date, '%b %e') AS date, CONCAT('".$curr_sign."',SUM(mc_gross)) AS amt FROM ".$xoopsDB->prefix("donations_transactions")." WHERE (payment_date >= DATE_FORMAT(NOW(),'%Y-%m-".$swingd."')) GROUP BY txn_id ORDER BY payment_date DESC"; }else{ $query_Recordset1 = "SELECT custom AS muser_id, option_selection1 as showname, DATE_FORMAT(payment_date, '%b-%e') AS date, CONCAT('".$curr_sign."',SUM(mc_gross)) AS amt FROM ".$xoopsDB->prefix("donations_transactions")." WHERE (payment_date < DATE_FORMAT(NOW(), '%Y-%m-".$swingd."')) AND payment_date > DATE_FORMAT(SUBDATE(NOW(),INTERVAL ".$swingd." DAY), '%Y-%m-".$swingd."') GROUP BY txn_id ORDER BY payment_date DESC"; } $Recordset1 = $xoopsDB->query($query_Recordset1); $totalRows_Recordset1 = $xoopsDB->getRowsNum($Recordset1); $ROWS_DONATORS = ""; // Fill out the donators table tag while ($row_Recordset1 = $xoopsDB->fetchArray($Recordset1)) { if ( $row_Recordset1['amt'] > $curr_sign.'0' ) { $ROWS_DONATORS .= ""; $ROWS_DONATORS .= " "; $muser_id = $row_Recordset1['muser_id']; if ( strcmp($row_Recordset1['showname'],"Yes") == 0 && ($userfoin = mgetusrinfo($muser_id))) { $ROWS_DONATORS .= "getVar('uid')."'>".xdshorten($userfoin->getVar('uname'))."n"; Login Username Password Remember me Reset Search Advanced Search Recent Posts Re: wgFilemanager released for testing and contribution Yesterday 7:29 goffy Re: wgFilemanager released for testing and contribution 8/27 0:03 liomj Re: activate block by default 8/26 23:56 liomj activate block by default 8/24 9:52 goffy Re: wgFilemanager released for testing and contribution 8/21 15:19 heyula wgFilemanager released for testing and contribution 8/21 13:17 goffy Re: XOOPS 2.5.12 Beta-2 available for Testing 8/21 4:12 Mamba Re: XOOPS 2.5.12 Beta-2 available for Testing 8/18 21:19 jjdai Re: XOOPS 2.5.12 Beta-2 available for Testing 8/18 17:53 Mamba Re: XOOPS 2.5.12 Beta-2 available for Testing 8/18 9:58 jjdai Who's Online 165 user(s) are online (72 user(s) are browsing Support Forums) Members: 0 Guests: 165 more... Donat-O-Meter Stats Goal: $100.00 Due Date: Aug 31 Gross Amount: $0.00 Net Balance: $0.00 Left to go: $100.00 Latest GitHub Commits {{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }} {{ record.commit.author.name }} {{ record.commit.author.date | formatDate }}
Advanced Search
165 user(s) are online (72 user(s) are browsing Support Forums)
Members: 0
Guests: 165