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: XOOPS Custom Field Module Today 21:04 Mamba XOOPS Custom Field Module Today 19:29 heyula Re: New module: Smartshare 6/28 7:54 heyula Re: New module: Weather 6/28 1:21 Mamba Re: New module: Weather 6/27 18:23 Runeher2 New module: Weather 6/27 18:16 Runeher2 Re: New module: Smartshare 6/27 14:12 liomj Re: New module: Smartshare 6/27 4:17 Mamba New module: Smartshare 6/26 10:56 Runeher2 Re: modules @ GitHub It doesn’t work 6/22 4:51 Mamba Who's Online 155 user(s) are online (114 user(s) are browsing Support Forums) Members: 0 Guests: 155 more... Donat-O-Meter Stats Goal: AU$15.00 Due Date: Jun 30 Gross Amount: AU$0.00 Net Balance: AU$0.00 Left to go: AU$15.00 Latest GitHub Commits {{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }} {{ record.commit.author.name }} {{ record.commit.author.date | formatDate }}
Advanced Search
155 user(s) are online (114 user(s) are browsing Support Forums)
Members: 0
Guests: 155