##############################################################
## MOD Title: Transaction mod for the point system
## MOD Author: conanqtran < [ Register or login to view links on this board. ] > (Conan Tran) http://www.maihoatrang.com
## MOD Description: This mod enable you to track who is donating point to who in your forum
## MOD Version: 1.3.0
##
## Installation Level: Easy
## Installation Time: 10 Minutes
## Files To Edit:    pointscp.php
##         viewonline.php
##         admin/index.php
##             includes/constants.php
##         includes/page_header.php
##           language/lang_english/lang_main.php
##           language/lang_english/email/user_notify_donation.tpl
##         templates/subSilver/overall_header.tpl
##         templates/subSilver/points_system.tpl
##
## Included Files:    transaction.php
##         mytransfer.php
##         viewtransfrom.php
##         viewtransto.php
##         viewtransfrom_body.tpl
##         transaction_body.tpl
##         mytransfer_body.tpl
##         viewtransto_body.tpl
##############################################################
## For Security Purposes, Please Check: http://www.phpbb.com/mods/ for the
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered
## in our MOD-Database, located at: http://www.phpbb.com/mods/
##############################################################
## Author Notes:
##
##  Copyright  Conan Tran. 2003 - http://www.maihoatrang.com/
##  No placement of this MOD at sites other than [ Register or login to view links on this board. ] without my permission.
##
##  Development topic at phpBB: http://www.phpbb.com/phpBB/viewtopic.php?t=52933
##
##  Duong Qua is the nick of Conan Tran at http://www.maihoatrang.com/forums/
##
##  You will need to install the point system mod written by eXplosive first before attempt
##  to install my mod. Download the point mod at: http://www.phpbb.com/phpBB/viewtopic.php?t=75337
## 
##  This mod is for phpBB2 version 2.0.4
##############################################################
## MOD History:
##
##   2002-10-04 - Version 1.0.0
##      - initial beta, store transaction details into the DB and display them in a single page
##
##   2002-10-07 - Version 1.0.1
##      - fixed: also record if user enter 0 in the donate point field which, shouldn't be inserted into the DB
##
##   2002-10-20 - Version 1.1.0
##      - added feature: if user is viewing different transaction page, online status will change accordingly
##
##   2002-11-16 - Version 1.1.1
##      - fixed some typos in the transaction.php file - Thanks gatty for pointing this out :)
##
##   2003-03-6 - Version 1.2.0
##      - added: the list of people who donate point(s) to you and the total number of points donated to you
##      - added: the list of people YOU donate point(s) to and the total number of points you have donated
##
##   2003-04-25 - Version 1.3.0
##      - Upgrade to compatible with phpBB2.0.4 and the latest point mod
##   - Force the user to enter the reason for sending you point(s)
##
## To Do:
##   1. Only Admin/Mods can view the list of who donates point(s) to who (can be set ON/OFF via Admin CP)
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################


#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE phpbb_transactions (
  trans_date int(11) NOT NULL default '0',
  trans_from varchar(25) NOT NULL default '',
  trans_to varchar(25) NOT NULL default '',
  trans_amount mediumint(8) NOT NULL default '0',
  trans_reason varchar(255) NOT NULL default '',
  PRIMARY KEY  (trans_date)
) TYPE=MyISAM;

#
#Run this command if you have the old transaction table
#
ALTER TABLE phpbb_transactions ADD trans_reason VARCHAR (255) NOT NULL default '' AFTER trans_amount;
UPDATE phpbb_transactions SET trans_reason='N/A';

#
#-----[ OPEN ]------------------------------------------
#
pointscp.php

#
#-----[ FIND ]------------------------------------------
#

         $error_msg .= ((!empty($error_msg)) ? '<br />' : '') . sprintf($lang['Points_enter_some_donate'], $board_config['points_name']);
      }

#
#-----[ AFTER, ADD ]------------------------------------------
#

      if(empty($HTTP_POST_VARS['reason_donate']))
      {
         $error = true;
         $error_msg = $lang['Points_no_reason_donate'];
      }
         
#
#-----[ FIND ]------------------------------------------
#          

         $from_points = get_user_points($userdata['user_id']);         
         
#
#-----[ AFTER, ADD ]------------------------------------------
#          

         $reason_donate = $HTTP_POST_VARS['reason_donate'];         

#
#-----[ FIND ]------------------------------------------
#          

         subtract_points($userdata['user_id'], $amount);         
         
         
#
#-----[ AFTER, ADD ]------------------------------------------
#          
         
         // Transaction mod by Conan Tran http://www.maihoatrang.com
         if( $amount != 0 )
         {

         $sql = "INSERT INTO " . TRANSACTION_TABLE . " (trans_date, trans_from, trans_to, trans_amount, trans_reason)
               VALUES ( " . time() . ", '" . $userdata['username'] . "', '" . str_replace("\'", "''", $username) . "', '$amount', '" . str_replace("\'", "''", $reason_donate) . "')";
         }

         if( !$db->sql_query($sql) )
         {
            message_die(GENERAL_ERROR, "Could not insert data into transaction table", '', __LINE__, __FILE__, $sql);
         }
         // Transaction mod by Conan Tran http://www.maihoatrang.com
         

#
#-----[ FIND ]------------------------------------------
#          

            $emailer->assign_vars(array(
               'DONATOR' => $userdata['username'],
               'USERNAME' => $to_userdata['username'],
               'AMOUNT_DONATE' => $amount,
               
#
#-----[ AFTER, ADD ]------------------------------------------
#          

               'REASON_DONATE' => $reason_donate,

#
#-----[ FIND ]------------------------------------------
#          

      'L_AMOUNT_GIVE' => sprintf($lang['Points_give'], $board_config['points_name']),
      
#
#-----[ AFTER, ADD ]------------------------------------------
#          

      'L_REASON' => $lang['Points_reason'],
      'L_REASON_DONATE' => $lang['Points_reason_donate'],

#
#-----[ OPEN ]------------------------------------------
#
viewonline.php

#
#-----[ FIND ]------------------------------------------
#
            case PAGE_FAQ:
               $location = $lang['Viewing_FAQ'];
               $location_url = "faq.$phpEx";
               break;

#
#-----[ AFTER, ADD ]------------------------------------------
#
            case PAGE_MY_TRANS:
               $location = $lang['My_Trans'];
               $location_url = "mytransfer.$phpEx";
               break;
               
            case PAGE_GLOBAL_TRANS:
               $location = $lang['Global_Trans'];
               $location_url = "transaction.$phpEx";
               break;   
               
#
#-----[ OPEN ]------------------------------------------
#
admin/index.php

#
#-----[ FIND ]------------------------------------------
#Note: there are 2 occurences

         case PAGE_FAQ:
            $location = $lang['Viewing_FAQ'];
            $location_url = "index.$phpEx?pane=right";
            break;         

#
#-----[ AFTER, ADD ]------------------------------------------
#
                    case PAGE_MY_TRANS:
                        $location = $lang['My_Trans'];
                          $location_url = "../mytransfer.$phpEx";
                  break;            
               case PAGE_GLOBAL_TRANS:
                  $location = $lang['Global_Trans'];
                  $location_url = "transaction.$phpEx";
                  break;            
                  

#
#-----[ OPEN ]------------------------------------------
#
includes/constants.php

#
#-----[ FIND ]------------------------------------------
#
define('PAGE_GROUPCP', -11);

#
#-----[ AFTER, ADD ]------------------------------------------
#
define('PAGE_MY_TRANS', -60);
define('PAGE_GLOBAL_TRANS', -61);

#
#-----[ FIND ]------------------------------------------
#

?>

#
#-----[ BEFORE, ADD ]------------------------------------------
#
// Transaction mod by Conan Tran [ Register or login to view links on this board. ]
define('TRANSACTION_TABLE', $table_prefix.'transactions');

            
#
#-----[ OPEN ]------------------------------------------
#
includes/page_header.php

#
#-----[ FIND ]------------------------------------------
#
   'U_GROUP_CP' => append_sid('groupcp.'.$phpEx),
   
#
#-----[ AFTER, ADD ]------------------------------------------
#
   'U_MY_TRANS' => append_sid('mytransfer.'.$phpEx),
   'U_VIEW_TRANS_TO' => append_sid('viewtransto.'.$phpEx),
   'U_VIEW_TRANS_FROM' => append_sid('viewtransfrom.'.$phpEx),
   'U_GLOBAL_TRANS' => append_sid('transaction.'.$phpEx),
   'L_MY_TRANS' => $lang['My_Trans'],
   'L_GLOBAL_TRANS' => $lang['Global_Trans'],   


#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/lang_main.php

#
#-----[ FIND ]------------------------------------------
#
//
// That's all Folks!

#
#-----[ BEFORE, ADD ]------------------------------------------
#
//Transaction mod by Conan Tran [ Register or login to view links on this board. ]
$lang['My_Trans'] = 'View my transactions';
$lang['Global_Trans'] = 'View global transaction';
$lang['View_The_Rest'] = 'View the rest';
$lang['Recent_Trans_To'] = 'Recent transactions to your account';
$lang['Recent_Trans_From'] = 'Recent transactions that you made';
$lang['Sort_Trans_From'] = 'Sort by sender';
$lang['Sort_Trans_To'] = 'Sort by reciever';
$lang['Sort_Trans_Amount'] = 'Sort by amount';
$lang['Sort_Trans_Date'] = 'Sort by send date';
$lang['Sort_Top_Ten_Trans'] = 'Top Ten';
$lang['Trans_From'] = 'Send From Account';
$lang['Trans_To'] = 'Send To Account';
$lang['Trans_Amount'] = 'Amount';
$lang['Trans_Date'] = 'Send Date';
$lang['Custom_Point_Name'] = '$';
$lang['Total_Trans'] = 'Total';
$lang['Points_reason'] = 'Reason';
$lang['Points_reason_donate'] = 'Enter reason for donation';
$lang['Points_no_reason_donate'] = 'Please enter reason for donation';
//Transaction mod by Conan Tran [ Register or login to view links on this board. ]


#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/email/user_notify_donation.tpl

#
#-----[ FIND ]------------------------------------------
#
{DONATOR} has donated ({AMOUNT_DONATE}) {L_POINTS} to you.

#
#-----[ AFTER, ADD ]------------------------------------------
#
The reason is: {REASON_DONATE}

#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/points_system.tpl

#
#-----[ FIND ]------------------------------------------
#Note: there are 2 occurences, find the second one only

      <input type="text" name="amount" maxlength="11" value="0" size="11">
     </td>
   </tr>
   
#
#-----[ AFTER, ADD ]------------------------------------------
#
   <tr>
     <td class="row1"><span class="gen">{L_REASON}:</span><br />
      <span class="gensmall">{L_REASON_DONATE}</span> </td>
     <td class="row2">
      <input type="text" name="reason_donate" maxlength="50" value="" size="30">
     </td>
   </tr>


#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/overall_header.tpl

#
#-----[ FIND ]------------------------------------------
#
<!-- END switch_user_logged_in -->
   
#
#-----[ AFTER, ADD ]------------------------------------------
#Note: you can add the following line to the position you like, doesn't have to be after the: <!-- END switch_user_logged_in -->

.:: <a href="{U_MY_TRANS}" class="mainmenu"><font size = 2 color=red><b>{L_MY_TRANS}</b></font></a> ::.
                                           
#
#-----[ COPY ]------------------------------------------
#

copy *.php to /
copy *.tpl to templates/subSilver/
                         
               
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM