date + interval ' . $settings['time_dif'] . ' hour '; if ($frm['ttype'] != '') { $typewhere = ' and type=\'' . quote ($frm['ttype']) . '\' '; } $u_id = sprintf ('%d', $frm['u_id']); if (1 < $u_id) { $userwhere = '' . ' and user_id = ' . $u_id . ' '; } $q = '' . 'select count(*) as col from hm3_history where ' . $datewhere . ' ' . $userwhere . ' ' . $typewhere; ($sth = mysql_query ($q) OR print mysql_error ()); $row = mysql_fetch_array ($sth); $count_all = $row['col']; $page = $frm['page']; $onpage = 20; $colpages = ceil ($count_all / $onpage); if ($page <= 1) { $page = 1; } if (($colpages < $page AND 1 < $colpages)) { $page = $colpages; } $from = ($page - 1) * $onpage; $q = 'select *, date_format(date + interval ' . $settings['time_dif'] . ('' . ' hour, \'%b-%e-%Y %r\') as d from hm3_history where ' . $datewhere . ' ' . $userwhere . ' ' . $typewhere . ' order by date desc, id desc limit ' . $from . ', ' . $onpage); ($sth = mysql_query ($q) OR print mysql_error ()); $trans = array (); while ($row = mysql_fetch_array ($sth)) { $q = 'select username from hm3_users where id = ' . $row['user_id']; $sth1 = mysql_query ($q); $row1 = mysql_fetch_array ($sth1); if ($row1) { $row['username'] = $row1['username']; } else { $row['username'] = '-- deleted user --'; } array_push ($trans, $row); } $month = array ('Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'); $q = '' . 'select sum(actual_amount) as periodsum from hm3_history where ' . $datewhere . ' ' . $userwhere . ' ' . $typewhere; $sth = mysql_query ($q); $row = mysql_fetch_array ($sth); $periodsum = $row['periodsum']; $q = '' . 'select sum(actual_amount) as sum from hm3_history where 1=1 ' . $userwhere . ' ' . $typewhere; $sth = mysql_query ($q); $row = mysql_fetch_array ($sth); $allsum = $row['sum']; echo ' function go(p) { document.trans.page.value = p; document.trans.submit(); }

Transactions history: '; echo ' All transactions Transfers from e-gold Deposits Bonuses Penalties Earnings Withdrawals Request withdraws Commisions Deposit early releases Deposit returns

From: '; echo ' '; for ($i = 0; $i < sizeof ($month); ++$i) { echo ''; echo $month[$i]; } echo '   '; echo ' '; for ($i = 1; $i <= 31; ++$i) { echo ''; echo $i; } echo '   '; echo ' '; for ($i = $settings['site_start_year']; $i <= date ('Y', time () + $settings['time_dif'] * 60 * 60); ++$i) { echo ''; echo $i; } echo ' To: '; echo ' '; for ($i = 0; $i < sizeof ($month); ++$i) { echo ''; echo $month[$i]; } echo '   '; echo ' '; for ($i = 1; $i <= 31; ++$i) { echo ''; echo $i; } echo '   '; echo ' '; for ($i = $settings['site_start_year']; $i <= date ('Y', time () + $settings['time_dif'] * 60 * 60); ++$i) { echo ''; echo $i; } echo '

'; if (($frm['ttype'] == 'withdraw_pending' AND $frm['say'] == 'yes')) { echo 'Withdrawal has been sent

'; } if (($frm['ttype'] == 'withdraw_pending' AND $frm['say'] == 'no')) { echo 'Withdrawal has not been sent

'; } echo ' '; if ($frm['say'] == 'massremove') { print 'Pending transactions removed!

'; } if ($frm['say'] == 'massprocessed') { print 'Pending transactions selected as processed!

'; } echo ' '; if (0 < sizeof ($trans)) { for ($i = 0; $i < sizeof ($trans); ++$i) { echo ' '; } echo ' '; } else { echo ' '; } echo '

User	Amount	Date
'; echo ($frm['ttype'] == 'withdraw_pending' ? '   ' : ''); echo ''; echo $trans[$i]['username']; echo '	$'; echo number_format (abs ($trans[$i]['actual_amount']), 2); echo ''; echo ($frm['ttype'] == 'withdraw_pending' ? '   [pay] [remove]' : ''); echo '	'; echo ''; echo $trans[$i]['d']; echo '
'; echo ''; echo $transtype[$trans[$i]['type']]; echo ':   '; echo $trans[$i]['description']; echo '
Total for this period:		$ '; echo number_format ((($frm['ttype'] == 'deposit' OR $frm['ttype'] == 'withdraw_pending') ? '-1' : '1') * $periodsum, 2); echo '
No transactions found
Total for all time:		$ '; echo number_format ((($frm['ttype'] == 'deposit' OR $frm['ttype'] == 'withdraw_pending') ? '-1' : '1') * $allsum, 2); echo '

'; if ($frm['ttype'] == 'withdraw_pending') { echo '
'; echo ' function func2() { document.massform.action2.value=\'massremove\'; if (confirm("Are you sure remove those withdraw?\\n\\nFunds will be returned to users\\\'s system accounts.")) { document.massform.submit(); } } function func3() { document.massform.action2.value=\'masssetprocessed\'; if (confirm("Are you sure set those request as processed?\\n\\nNo funds will be sent'; echo ' to user\\\'s egold accounts!")) { document.massform.submit(); } } function func4() { document.massform.action2.value=\'masscsv\'; document.massform.submit(); }    
'; } echo '

'; if (1 < $colpages) { for ($i = 1; $i <= $colpages; ++$i) { if ($i == $page) { echo ' '; echo $i; continue; } else { echo ' '; echo $i; echo ' '; continue; } } } echo '
'; echo start_info_table ('100%'); echo 'Transaction history:
Every transaction in the script has own type.
Transfer from e-gold. This transaction will appear in system when user deposit money from e-gold.
Deposit. This transaction will appear in system when user deposit money from e-gold or account.
Bonus. This transaction will appear when admin add bonus to user.
Penalty. This transaction will appear when admin make pena'; echo 'lity for user.
Earning. This transaction will appear when user receive earning.
Withdraw. This transaction will appear when admin withdraw funds to user e-gold account.
Request withdraw. This transaction will appear when user ask for withdraw.
Early deposit release. Admin can release deposit or part of deposit to user account.
Referal commissions. This transaction will appear when u'; echo 'ser register from referal link and deposit funds from e-gold account.

Top left select helps you select only transactions you interested.
Top right select helps you select transactions for period you interested.

'; if ($frm['ttype'] == 'withdraw_pending') { echo '\'Remove selected\' - this button allow you remove requested withdrawals. Funds will be returned to user account.
\'Set selected as processed\' - if you use third party mass pay script, you can pay to user\'s e-gold account and then set request as processed using this button
\'Export to CSV selected\' - provide scv file for third party mass pay scripts.
'; } echo ' '; echo end_info_table (); ?>