<?

require("classes/settings.php");
$settings = new Settings;
require($settings->route_to_classes . "template.php");
require($settings->route_to_classes . "common.php");
require($settings->route_to_classes . "sql.php");
require($settings->route_to_classes . "tbl_links.php");
require($settings->route_to_classes . "tbl_keywords.php");
require($settings->route_to_classes . "tbl_category.php");
require($settings->route_to_classes . "tbl_payment.php");
require($settings->route_to_classes . "tbl_hits.php");
require($settings->route_to_classes . "tbl_transactions.php");
require($settings->route_to_classes . "tbl_country.php");
require($settings->route_to_classes . "tbl_language.php");
require($settings->route_to_classes . "tbl_parms.php");
require($settings->route_to_classes . "hrefs.php");

$sql = new Sql();
$sql->Connect();

$href = new Hrefs;

$common = new Common;

$ID = $HTTP_POST_VARS["ID"];
$PASSWORD = $HTTP_POST_VARS["Password"];

if( strlen($ID) == 0)
{
  $ID = $HTTP_COOKIE_VARS["ID"];
  $PASSWORD = $HTTP_COOKIE_VARS["Password"];
}


if( $common->check_password($sql, $ID, $PASSWORD) ) 
{
  setcookie ("ID", $ID , time() + 3*3600);
  setcookie ("Password", $PASSWORD , time() + 3*3600);
}
else
{
  print($common->header());
  print($common->build_login_form($settings, $href));
  print($common->footer());
  die('');
}

// settings in 
 $Silver_in = 1000;
 $parms = new tbl_parms($sql->parms_info("Silver_in"));
 $Silver_in = $parms->field["param_value_n"];

 $link = new tbl_links($sql->get_link_info($ID));

if($link->field['valid_email'] <> 'Y')
{

 print($common->header());

 $tmpl = new Template('membcentr/error-ve-email');
 if($tmpl->error()) {print($tmpl->error());}
 print( $tmpl->merge());

 print($common->footer());

 die();
}


print($common->header());
print(build_center_header($link));

$mo = $HTTP_POST_VARS["mo"];

#------------ make choose by "mo" variable ----------------------
if( strlen($mo) == 0) 
 $mo =$HTTP_GET_VARS["mo"]; 

switch ($mo) {

   case 'upgradegold':
        upgrade_gold($ID, $link, $sql, $href, $common, $settings); break;

   case 'updatebids':
        show_update_bids_form($ID, $link, $sql, $href, $common, $settings); break;

   case 'savebids':
        save_bids($ID, $link, $sql, $href, $common, $settings, $HTTP_POST_VARS); break;

   case 'upgradesilver':
        upgrade_silver(); break;

   case 'updatebusiness':
        show_update_business_details_form($ID, $link, $sql, $href, $common, $settings); break;

   case 'save_updbusiness':
        save_business_details ($ID, $link, $sql, $href, $common, $settings, $HTTP_POST_VARS );break;

   case 'updatedetails':
        show_update_details_form($ID, $link, $sql, $href, $common, $settings); break;

   case 'save_upddetails':
        save_update_details($ID, $link, $sql, $href, $common, $settings, $HTTP_POST_VARS); break;

   case 'makedeposit': 
        make_deposit_form($ID, $link, $sql, $href, $common, $settings); break;

   case 'updatecategory': 
        update_category_form($ID, $link, $sql, $href, $common, $settings); break;
   
   case 'save_updcategory': 
        save_update_category($ID, $link, $sql, $href, $common, $settings, $HTTP_POST_VARS); break;

   case 'monthlystatement': 
        monthly_statement($ID, $link, $sql, $href, $common, $settings, $HTTP_POST_VARS); break;

   case 'searchbox': 
        search_box($ID, $link, $sql, $href, $common, $settings, $HTTP_POST_VARS); break;

   default:

        show_main_member_page($ID, $link, $sql, $href, $common);
}
#-----------------------------------------------------------------

print(build_center_footer());

print($common->footer());

die();

//--------------------------------------------------------------

function show_main_member_page($ID, $link, $sql, $href, $common) {


if($link->field['isactive'] <> 'Y') { wait_admin(); }


//global $Silver_in;
// $bids = get_link_bids_array($sql, $ID);

 $tmpl = new Template('membcentr/main');
 if($tmpl->error()) {print($tmpl->error());}
// $tmpl->set_token(1, $href->upgrade_to_gold());
// $tmpl->set_token(2, $href->upgrade_to_silver());
// $tmpl->set_token(3, $href->make_deposit());
// $tmpl->set_token(4, $href->update_bids());
// $tmpl->set_token(5, $href->update_site_details());
// $tmpl->set_token(6, $href->update_business_details());
// $tmpl->set_token(7, $href->monthly_statement());
// $tmpl->set_token(8, $common->get_link_state( $link, $bids, $Silver_in, 'name'));
// $tmpl->set_token(9, $link->field['balance']);

 print($tmpl->merge());

}

//--------------------------------------------------------------

function upgrade_silver() {

 $tmpl = new Template('membcentr/upgrade-silver');
 if($tmpl->error()) {print($tmpl->error());}
 print($tmpl->merge());

}

//--------------------------------------------------------------

function upgrade_gold($ID, $link, $sql, $href, $common, $settings) {

global $Silver_in;

 $bids = get_link_bids_array($sql, $ID);
 $sql->payment_info ($ID);
 $payinf = $sql->rows;

 $tmpl = new Template('membcentr/upgrade-gold');
 if($tmpl->error()) {print($tmpl->error());}
 $tmpl->set_token(1, $common->get_link_state( $link, $bids,$Silver_in, 'name'));
 $tmpl->set_token(2, $payinf ? 'yes' : 'no' );
 $tmpl->set_token(3, count($bids) > 0 ? 'yes' : 'no' );
 $tmpl->set_token(4, $settings->pay_per_search );
 $tmpl->set_token(5, $href->update_business_details());
 $tmpl->set_token(6, $href->update_bids() );
 $tmpl->set_token(7, $href->make_deposit() );
 $tmpl->set_token(8, $href->search_box() );

 print($tmpl->merge());


}

//--------------------------------------------------------------

function get_link_bids_array($sql, $ID) {

 $sql->get_link_keywords($ID);

 unset($bids);
 for($i = 0; $i<$sql->rows ; $i++)
 {
   $sql->Fetch($i);
   $kwd = new tbl_keywords($sql->data);
   $bids[$i] = $kwd;
 }

  return $bids;
}

//--------------------------------------------------------------

function show_update_bids_form($ID, $link, $sql, $href, $common, $settings ) {

 $bids = get_link_bids_array($sql, $ID);

    $tmpl = new Template('membcentr/add-keyword-form');
    if($tmpl->error()) {print($tmpl->error());}
    $tmpl->set_type('raw');
    
    for($i=1;$i<11;$i++)
    {
      $term = "term" . $i;
      $bid = "bid" . $i;
      $termid = "id".$i;
      $termval = '';
      $bidval = 0.00;      
      $termidval='0';
      if(count($bids)>=$i)
      {
        $termval = $bids[$i-1]->field['search_term'];
        $bidval = $bids[$i-1]->field['bid'];
        $termidval = $bids[$i-1]->field['id'];
      }
    
      $tmpl->set_token(($i-1)*2 +1 , "<input name='$term' value='$termval' size='27'>
                                      <input name='$termid' value='$termidval' type=hidden>");
      $tmpl->set_token(($i-1)*2 +2 , "<input name='$bid' value = '$bidval' size='10'>");    
    }
    
    $tmpl->set_token(21, sprintf("<form action=%s method=POST target=_self>
                                  <input type='hidden' name='mo'  value='savebids'>", 
                                  $href->url('member_center')), 'raw');
    $tmpl->set_token(22, "</form>", 'raw');
    $tmpl->set_token(23, "<input name = 'submit' type = 'submit' value='submit'>", 'raw');
    $tmpl->set_token(24, $link->field['title'] );

    print($tmpl->merge());
}
//--------------------------------------------------------------

function save_bids ($ID, $link, $sql, $href, $common, $settings, $HTTP_POST_VARS ) {
//
//  saves bids changes
//

unset($doubles);

	for($i=1;$i<11;$i++)
	{
             $keyword = new tbl_keywords('');
             $term = "term" . $i;
             $search_term = $HTTP_POST_VARS[$term];
             $bid = "bid" . $i;
             $bid_amount = $HTTP_POST_VARS[$bid];
             $termid = "id" . $i;
             $termidval = $HTTP_POST_VARS[$termid];

             if($doubles[$search_term] <> 1)
             {
               $doubles[$search_term] = 1;

               $keyword->field['id'] = $termidval;
               $keyword->field['bid'] = $bid_amount;
               $keyword->field['link_id'] = $ID;
               $keyword->field['search_term'] = $search_term;

		if(strlen($keyword->field['search_term'])>0 && $keyword->field['bid']>0)
		{
                  if($termidval>0)
                  {
                    $sql->update_keyword($keyword);
                  }
                  else
                  {
                        $sql->save_keyword($keyword);
                  }
		}
                elseif($termidval>0)
                {
                      $sql->delete_keyword($termidval);
                }
            }
	}


 $tmpl = new Template('membcentr/keyw-upd-success');
 if($tmpl->error()) {print($tmpl->error());}
 $tmpl->set_token(1, $href->url('member_center'));
 print($tmpl->merge());


}
//--------------------------------------------------------------

function show_update_business_details_form($ID, $link, $sql, $href, $common, $settings) {

 unset($name); unset($business_name); unset($business_type);unset($email);
 unset($street); unset($city); unset($state); unset($zip);
 unset($country); unset($phone); unset($fax);

 $sql->payment_info ($ID);
 if($sql->rows)
 {
   $sql->Fetch(0);
   $pm = new tbl_payment($sql->data);

   $name = $pm->field['name'];
   $business_name = $pm->field['business_name'];
   $business_type = $pm->field['business_type'];
   $email = $pm->field['email_address'];
   $street = $pm->field['street_address']; 
   $city =$pm->field['city'];
   $state = $pm->field['state']; 
   $zip = $pm->field['zipcode'];
   $country = $pm->field['country']; 
   $phone = $pm->field['phone_no']; 
   $fax = $pm->field['fax_no'];
 }

    $tmpl = new Template('membcentr/add-payment-form');
    if($tmpl->error()) {print($tmpl->error());}
    $url = $href->url('member_center');
    $tmpl->set_token(1, "<form name=business action='$url' method=POST onsubmit='return Validate()'>
                        <input type=HIDDEN name='mo' value='save_updbusiness'>",'raw');
    $tmpl->set_token(2, "</form>", 'raw');
    $tmpl->set_token(3, "<input name=Name value='$name' size=27 maxlength=60>", 'raw');
    $tmpl->set_token(4, "<input name=Business_Name  value='$business_name' size=27 maxlength=80>", 'raw');
    $tmpl->set_token(5, "<input name=Business_Type  value='$business_type' size=27 maxlength=30>", 'raw');
    $tmpl->set_token(6, "<input name=Email value='$email' size=27 maxlength=60>", 'raw');
    $tmpl->set_token(7, "<input name=Street   value='$street' size=27 maxlength=60>", 'raw');
    $tmpl->set_token(8, "<input name=City  value='$city' size=27 maxlength=40>", 'raw');
    $tmpl->set_token(9, "<input name=State value='$state' size=27 maxlength=30>", 'raw');
    $tmpl->set_token(10, "<input name=Zip  value='$zip' size=10 maxlength=10>", 'raw');
    $tmpl->set_token(11, "<input name=Country value='$country' size=27 maxlength=30>", 'raw');
    $tmpl->set_token(12, "<input name=Phone value='$phone' size=27 maxlength=25>", 'raw');
    $tmpl->set_token(13, "<input name=Fax  value='$fax' size=27 maxlength=25>", 'raw');
    $tmpl->set_token(14, "<input type=SUBMIT value=Submit>", 'raw');
    $tmpl->set_token(15, "<input type=RESET value=Clear Form>", 'raw');
    print( $tmpl->merge());


}
//--------------------------------------------------------------
function save_business_details ($ID, $link, $sql, $href, $common, $settings, $HTTP_POST_VARS )
{
        $payment = new tbl_payment('');

	$payment->field['id']            = $ID;
	$payment->field['name']	         = $HTTP_POST_VARS["Name"];
	$payment->field['business_name'] = $HTTP_POST_VARS["Business_Name"];
	$payment->field['business_type'] = $HTTP_POST_VARS["Business_Type"];
	$payment->field['email_address'] = $HTTP_POST_VARS["Email"];
	$payment->field['street_address']= $HTTP_POST_VARS["Street"];
	$payment->field['city']          = $HTTP_POST_VARS["City"];
	$payment->field['state']         = $HTTP_POST_VARS["State"];
	$payment->field['zipcode']       = $HTTP_POST_VARS["Zip"];
	$payment->field['country']       = $HTTP_POST_VARS["Country"];
	$payment->field['phone_no']      = $HTTP_POST_VARS["Phone"];
	$payment->field['fax_no']        = $HTTP_POST_VARS["Fax"];

 $sql->payment_info ($ID);
 if($sql->rows)
 {
        $sql->update_payment($payment);
 }
 else
 {
        $sql->save_payment($payment);
 }

 $tmpl = new Template('membcentr/business-upd-success');
 if($tmpl->error()) {print($tmpl->error());}
 $tmpl->set_token(1, $href->url('member_center'));
 print($tmpl->merge());


}

//--------------------------------------------------------------
function build_category_name ($categories, $Category)
{


   return $categories[$Category-1]->field["absolute_name"];
}


//--------------------------------------------------------------

function build_category_options ($categories, $Category)
{

   $text = "<SELECT NAME=Category  SIZE=1 class=selectbox>";
   for($j = 0; $j < count($categories); $j++)
   {
     if($categories[$j]->field["id"] == $Category)
     {
        $text .= sprintf("<OPTION VALUE=%d SELECTED>%s </OPTION>\n", $categories[$j]->field["id"], $categories[$j]->field["absolute_name"]);
     }
     else
     {
        $text .=sprintf("<OPTION VALUE=%d>%s </OPTION>\n", $categories[$j]->field["id"], $categories[$j]->field["absolute_name"]);
     }
  }

  return $text;
}

//--------------------------------------------------------------

function show_update_details_form($ID, $link, $sql, $href, $common, $settings)
{


$sql->get_category_table();
$categories = $common->category_to_array($sql);


      $URL = $link->field['url'];
      $Description = $link->field['description'];
      $Title = $link->field['title'];
      $Contact_Name = $link->field['contact_name'];
      $Contact_Email = $link->field['contact_email'];


      $tmpl = new Template('membcentr/edit-site');
      if($tmpl->error()) {print($tmpl->error());}

      $p_url = $href->url('member_center');
      $tmpl->set_token(1, "<form name=edit action=$p_url method=POST onsubmit='return Validate()'>
                          <input type=HIDDEN name='mo' value='save_upddetails'>", 'raw');
      $tmpl->set_token(2, "</form>", 'raw');
      $tmpl->set_token(3, "<input name=Title size=27 value='$Title'>", 'raw');
      $tmpl->set_token(4, "<input name=URL size=27 value='$URL'>", 'raw');
      $tmpl->set_token(5, build_category_name ($categories, $link->field['category_id']), 'raw');
      $tmpl->set_token(6, "<textarea wrap=virtual name=Description value= rows=3 cols=20>$Description</textarea>", 'raw');
      $tmpl->set_token(7, "<input name=Contact_Name value='$Contact_Name' size=27>", 'raw');
      $tmpl->set_token(8, "<input name=Contact_Email value='$Contact_Email' size=27>", 'raw');
      $tmpl->set_token(9, "<input type=SUBMIT value='Edit Listing'>", 'raw');
      $tmpl->set_token(10, "<input type=RESET value='Clear Form'>", 'raw');
      $tmpl->set_token(11, $href->update_link_category());
      $tmpl->set_token(12, $common->country_options($sql,'', $link->field['country'] ), 'raw');
      $tmpl->set_token(13, $common->language_options($sql,'',$link->field['language'] ), 'raw');
      $tmpl->set_token(14, sprintf("<input name=Password type='password' value='%s' size=10>",$link->field['password'] ), 'raw');

      print( $tmpl->merge());

}

//--------------------------------------------------------------

function save_update_details($ID, $links, $sql, $href, $common, $settings, $HTTP_POST_VARS){


$links->field['title']        =  $HTTP_POST_VARS["Title"];
$links->field['url']          =  $HTTP_POST_VARS["URL"];
$links->field['category_id']  =  $HTTP_POST_VARS["Category"];
$links->field['description']  =  $HTTP_POST_VARS["Description"];
$links->field['contact_name'] =  $HTTP_POST_VARS["Contact_Name"];
$links->field['contact_email']=  $HTTP_POST_VARS["Contact_Email"];
$links->field['country']     =  $HTTP_POST_VARS["Country"];
$links->field['language']     =  $HTTP_POST_VARS["Language"];
$links->field['password']     =  $HTTP_POST_VARS["Password"];


$sql->update_links($links);

 $tmpl = new Template('membcentr/details-upd-success');
 if($tmpl->error()) {print($tmpl->error());}
 $tmpl->set_token(1, $href->url('member_center'));
 print($tmpl->merge());

}
//--------------------------------------------------------------

function make_deposit_form($ID, $link, $sql, $href, $common, $settings) {

//make deposit form 

 $tmpl = new Template('membcentr/make-deposit');
 if($tmpl->error()) {print($tmpl->error());}

 $p_url = $settings->bank_page;
 $tmpl->set_token(1, "<form action=$p_url method=POST onsubmit='return Validate()'>", 'raw');
 $tmpl->set_token(2, "</form>", 'raw');
 $tmpl->set_token(3, "<input name = 'amount' type = text size=10>" , 'raw');
 $tmpl->set_token(4, "<input type='submit' name='submit' value='submit'>", 'raw');

 print($tmpl->merge());

}
//--------------------------------------------------------------

function build_center_header($link)  {

global $href, $sql, $Silver_in, $common;

 $bids = get_link_bids_array($sql, $link->field['id']);

 $tmpl = new Template('membcentr/header');
 if($tmpl->error()) {print($tmpl->error());}

 $tmpl->set_token(1, $link->field['id']);
 $tmpl->set_token(2, $link->field['title']);
 $tmpl->set_token(3, $link->field['contact_email']);

 $tmpl->set_token(4, $href->upgrade_to_gold());
 $tmpl->set_token(5, $href->upgrade_to_silver());
 $tmpl->set_token(6, $href->make_deposit());
 $tmpl->set_token(7, $href->update_bids());
 $tmpl->set_token(8, $href->update_site_details());
 $tmpl->set_token(9, $href->update_business_details());
 $tmpl->set_token(10, $href->monthly_statement());
 $tmpl->set_token(11, $common->get_link_state( $link, $bids, $Silver_in, 'name'));
 $tmpl->set_token(12, $link->field['balance']);

 $nstate = $common->get_link_state( $link, $bids, $Silver_in, 'num');
 $tmpl->set_token(13, ($nstate == 2 OR $nstate ==3) ? 'yes' : 'no');
 $tmpl->set_token(14, ($nstate == 1 OR $nstate ==3) ? 'yes' : 'no');

 $tmpl->set_token(15, $href->url('member_center'));

 print($tmpl->merge());

}

//--------------------------------------------------------------

function build_center_footer()  {


 $tmpl = new Template('membcentr/footer');
 if($tmpl->error()) {print($tmpl->error());}
 print($tmpl->merge());

}

function update_category_form($ID, $link, $sql, $href, $common, $settings)
{

 $sql->get_category_table();
 $categories = $common->category_to_array($sql);


 $tmpl = new Template('membcentr/update-category-form');
 if($tmpl->error()) {print($tmpl->error());}

 $p_url = $href->url('member_center');
 $tmpl->set_token(1, "<form action=$p_url method=POST >
                     <input type=HIDDEN name='mo' value='save_updcategory'>", 'raw');
 $tmpl->set_token(2, "</form>", 'raw');
 $tmpl->set_token(3, build_category_options ($categories, $link->field['category_id']), 'raw');
 $tmpl->set_token(4, "<input type=SUBMIT value='Change Category'>", 'raw');

 print($tmpl->merge());

}
//--------------------------------------------------------------

function save_update_category($ID, $links, $sql, $href, $common, $settings, $HTTP_POST_VARS)
{

 $links->field['category_id']  =  $HTTP_POST_VARS["Category"];
 $sql->update_links($links);

 $tmpl = new Template('membcentr/category-upd-success');
 if($tmpl->error()) {print($tmpl->error());}
 $tmpl->set_token(1, $href->url('member_center'));
 print($tmpl->merge());


}
//--------------------------------------------------------------

function search_box($ID, $link, $sql, $href, $common, $settings, $HTTP_POST_VARS)
{

  $tmpl = new Template('membcentr/search/codegen');
  if($tmpl->error()) {print $tmpl->error();}
  $tmpl->set_type('raw');
  $searchcode = getsearchcode($href, $ID, '115X140');
  $tmpl->set_token(1, "<textarea name='affiliate_link_text' cols=50 rows=5> $searchcode </textarea>");
  $searchcode = getsearchcode($href, $ID, '100X60');
  $tmpl->set_token(2, "<textarea name='affiliate_link_text' cols=50 rows=5> $searchcode </textarea>");
  print($tmpl->merge());

}

//--------------------------------------------------------------
function getsearchcode($href, $id, $type) {

  $file = "membcentr/search/searchbox115X140";
  if($type == '100X60')
  {
  $file = "membcentr/search/searchbox100X60";
  }

  $tmpl = new Template($file);
  if($tmpl->error()) {print $tmpl->error();}

  $url = $href->url('search_result');
  $tmpl->set_token(1, "<form action='$url' method=post>".
                      "<input type='hidden' name='linkid' value='$id'>");
  if($type == '100X60')
  {
    $tmpl->set_token(2, "<input size='7' name='Search_Keyword'>");
  }
  else
  {
     $tmpl->set_token(2, "<input type='text' size=8 name='Search_Keyword'>");
  }
  $tmpl->set_token(3, "</form>");

  return $tmpl->merge();

}
//--------------------------------------------------------------

function monthly_statement($ID, $link, $sql, $href, $common, $settings, $HTTP_POST_VARS) {

global $HTTP_GET_VARS;

 $month =$HTTP_GET_VARS["month"]; 
 $year =$HTTP_GET_VARS["year"]; 
 if(strlen($month) ==0 )
 {
  $month = date('m'); $year =date("Y");
 }

 if($month == 12) { $next_month = 1; $next_year = $year+1; }
 else {$next_month = $month+1; $next_year = $year; }

 if($month == 1)
 { $prev_month = 12; $prev_year = $year - 1 ; }
 else {$prev_month = $month -1 ; $prev_year = $year; }

 $f_date = sprintf("%04d-%02d-01", $year, $month);
 $l_date = sprintf("%04d-%02d-01", $next_year, $next_month);

 // -----------------------------------------find balance at month start
 $sql->get_hits_totals($ID, '', $f_date);
 $debit = 0 ; $credit = 0;
 for($i = 0 ; $i < $sql->rows ; $i++)
 {
   $sql->Fetch($i); $row = $sql->data;
   $debit += $row[1];
   $credit += $row[2];
 }

 $sql->get_transactions_table($ID, '', $f_date);
 $tot_trs =0;
 for($i = 0 ; $i < $sql->rows ; $i++)
 {
    $sql->Fetch($i);
    $trans = new tbl_transactions($sql->data);
    $tot_trs += $trans->field['debit']; 
 }

 $month_balance = $tot_trs + $credit - $debit;


 //------------------------------------------------ get current month debs 

  $sql->get_link_keywords ( $ID );

  for($i = 0; $i < $sql->rows; $i++)
  {
 	$sql->Fetch($i);
	$keyword = new tbl_keywords($sql->data);
	$keywords[] = $keyword;
  }


 $row_tmpl = new Template('membcentr/monthly-statement-row');
 if($row_tmpl->error()) {print($row_tmpl->error());}

 $hits_html ='';

 $sql->get_hits_totals($ID, $f_date, $l_date);
 $debit = 0 ; $credit = 0;
 for($i = 0 ; $i < $sql->rows ; $i++)
 {
   $sql->Fetch($i); $row = $sql->data;
   $term = 'Unknown(removed)'; $bid = 'unknown';

   if($row[0] > 0)
   {
     //find keyword
     for($ii = 0; $ii<count($keywords); $ii++)
     {
        if($keywords[$ii]->field['id'] == $row[0])
        {
           $term = $keywords[$ii]->field['search_term'];
           $bid = $keywords[$ii]->field['bid'];
        }
     }
   }
   else
   {
     $term = '*** HITS IN ***';
     $bid = $settings->pay_per_search;
   }

   $row_tmpl->set_token(1, $term);
   $row_tmpl->set_token(2, $bid);
   $row_tmpl->set_token(3, $row[3]);
   $row_tmpl->set_token(4, $row[1]);
   $row_tmpl->set_token(5, $row[2]);

   $hits_html .= $row_tmpl->merge();

   $debit += $row[1];
   $credit += $row[2];
 }

 /// if no hits - empty rows
 if($hits_html =='')
 {
   $row_tmpl = new Template('membcentr/monthly-statement-norows');
   if($row_tmpl->error()) {print($row_tmpl->error());}
   $hits_html = $row_tmpl->merge();
 }


 //// Credit Transactions was maden (transactions)

 $row_tmpl = new Template('membcentr/monthly-statement-trans');
 if($row_tmpl->error()) {print($row_tmpl->error());}

 $sql->get_transactions_table($ID, $f_date, $l_date);
 $tot_trs =0;
 $trans_html = '';
 for($i = 0 ; $i < $sql->rows ; $i++)
 {
    $sql->Fetch($i);
    $trans = new tbl_transactions($sql->data);

    $row_tmpl->set_token(1, date("F j, Y", $trans->field['quand']));
    $row_tmpl->set_token(2, $trans->field['description']);
    $row_tmpl->set_token(3, $trans->field['debit']);
    $trans_html .= $row_tmpl->merge();
    $tot_trs += $trans->field['debit']; 
 }
 
 $end_balance = $month_balance + $credit + $tot_trs - $debit;

 /// if no trans - empty rows
 if($trans_html =='')
 {
   $row_tmpl = new Template('membcentr/monthly-statement-notrans');
   if($row_tmpl->error()) {print($row_tmpl->error());}
    $trans_html .= $row_tmpl->merge();
 }


 // Show main template
 
    $tmpl = new Template('membcentr/monthly-statement');
    if($tmpl->error()) {print($tmpl->error());}
  
    $tmpl->set_token(1, $link->field['title']);
    $tmpl->set_token(2, $link->field['contact_email']);
    $tmpl->set_token(3, substr($link->field['created_date'],0,10));

    $tmpl->set_token(4,  sprintf('%.2f',$month_balance));
    $tmpl->set_token(5,  sprintf('%.2f',$end_balance));
    $tmpl->set_token(6,  sprintf('%.2f',$debit));
    $tmpl->set_token(7,  sprintf('%.2f',$credit));
    $tmpl->set_token(8,  sprintf('%.2f',$tot_trs));
    $tmpl->set_token(9, $hits_html, 'raw');
    $tmpl->set_token(10, $trans_html, 'raw');
    $time = mktime(0,0,0, substr($f_date,5,2), substr($f_date, 8, 2), substr($f_date,0,4));
    $tmpl->set_token(11, date("F Y",$time)  );
    $tmpl->set_token(12,  $href->monthly_statement2($prev_month, $prev_year));
    $tmpl->set_token(13,  $href->monthly_statement2($next_month, $next_year));

    print($tmpl->merge());
}

//--------------------------------------------------------------

function wait_admin() {

 $tmpl = new Template('membcentr/error-wait-admin');
 if($tmpl->error()) {print($tmpl->error());}
 print( $tmpl->merge());


}
//--------------------------------------------------------------
?>