The php web script that I’m trying to modify shows an html page of transactions. I’d like to change what is displayed there. The array begins on approx line 184 (in bold, near the bottom of the code below, with the line:
$ads_list .= PT_LoadPage('transactions/list',array(
I’d like help to change the html transaction page to reflect what appears in the ‘u_paid_videos’ table, which has these columns:
id, id_user, id_video, video_title, time, user_id_uploaded, time_date, earned_amount, currency
to replace what is in the array now:
'ID' => $tr->id,
'PAID_USER' => substr($user_data->name, 0,20),
'USER_NAME' => $user_data->username,
'VIDEO_NAME' => substr($video->title, 0,20) ,
'VIDEO_ID_' => PT_Slug($video->title, $video->video_id),
'AMOUNT' => $tr->earned_amount,
"CURRENCY" => $currency,
"TIME" => PT_Time_Elapsed_String($tr->time)
the change, for example, would change:
‘PAYER_NAME’ to be ‘id_user’
‘USER_NAME’’ to be ‘user_id_uploaded’
‘VIDEO_ID_’ to be ‘id_video’
‘AMOUNT’ to be ‘earned_amount’
“TIME” to be ‘time_date’
here’s the php code:
<?php
error_reporting(-1); // set maximum errors
ini_set('display_errors' , 'true');
if (!IS_LOGGED || ($pt->config->sell_videos_system == 'off' && $pt->config->usr_v_mon == 'off') ) {
header('Location: ' . PT_Link('404'));
exit;
}
$currency = '$';
if ($pt->config->payment_currency == 'EUR') {
$currency = '€';
}
$types = array('today','this_week','this_month','this_year');
$type = 'today';
if (!empty($_GET['type']) && in_array($_GET['type'], $types)) {
$type = $_GET['type'];
}
if ($type == 'today') {
$start = strtotime(date('M')." ".date('d').", ".date('Y')." 12:00am");
$end = strtotime(date('M')." ".date('d').", ".date('Y')." 11:59pm");
$array = array('00' => 0 ,'01' => 0 ,'02' => 0 ,'03' => 0 ,'04' => 0 ,'05' => 0 ,'06' => 0 ,'07' => 0 ,'08' => 0 ,'09' => 0 ,'10' => 0 ,'11' => 0 ,'12' => 0 ,'13' => 0 ,'14' => 0 ,'15' => 0 ,'16' => 0 ,'17' => 0 ,'18' => 0 ,'19' => 0 ,'20' => 0 ,'21' => 0 ,'22' => 0 ,'23' => 0);
$ads_array = $array;
$date_type = 'H';
$pt->cat_type = 'today';
$pt->chart_title = $lang->today;
$pt->chart_text = date("l");
}
elseif ($type == 'this_week') {
$time = strtotime(date('l').", ".date('M')." ".date('d').", ".date('Y'));
if (date('l') == 'Saturday') {
$start = strtotime(date('M')." ".date('d').", ".date('Y')." 12:00am");
}
else{
$start = strtotime('last saturday, 12:00am', $time);
}
if (date('l') == 'Friday') {
$end = strtotime(date('M')." ".date('d').", ".date('Y')." 11:59pm");
}
else{
$end = strtotime('next Friday, 11:59pm', $time);
}
$array = array('Saturday' => 0 , 'Sunday' => 0 , 'Monday' => 0 , 'Tuesday' => 0 , 'Wednesday' => 0 , 'Thursday' => 0 , 'Friday' => 0);
$ads_array = $array;
$date_type = 'l';
$pt->cat_type = 'this_week';
$pt->chart_title = $lang->this_week;
$pt->chart_text = date('y/M/d',$start)." To ".date('y/M/d',$end);
}
elseif ($type == 'this_month') {
$start = strtotime("1 ".date('M')." ".date('Y')." 12:00am");
$end = strtotime(cal_days_in_month(CAL_GREGORIAN, date('m'), date('Y'))." ".date('M')." ".date('Y')." 11:59pm");
if (cal_days_in_month(CAL_GREGORIAN, date('m'), date('Y')) == 31) {
$array = array('01' => 0 ,'02' => 0 ,'03' => 0 ,'04' => 0 ,'05' => 0 ,'06' => 0 ,'07' => 0 ,'08' => 0 ,'09' => 0 ,'10' => 0 ,'11' => 0 ,'12' => 0 ,'13' => 0 ,'14' => 0 ,'15' => 0 ,'16' => 0 ,'17' => 0 ,'18' => 0 ,'19' => 0 ,'20' => 0 ,'21' => 0 ,'22' => 0 ,'23' => 0,'24' => 0 ,'25' => 0 ,'26' => 0 ,'27' => 0 ,'28' => 0 ,'29' => 0 ,'30' => 0 ,'31' => 0);
}elseif (cal_days_in_month(CAL_GREGORIAN, date('m'), date('Y')) == 30) {
$array = array('01' => 0 ,'02' => 0 ,'03' => 0 ,'04' => 0 ,'05' => 0 ,'06' => 0 ,'07' => 0 ,'08' => 0 ,'09' => 0 ,'10' => 0 ,'11' => 0 ,'12' => 0 ,'13' => 0 ,'14' => 0 ,'15' => 0 ,'16' => 0 ,'17' => 0 ,'18' => 0 ,'19' => 0 ,'20' => 0 ,'21' => 0 ,'22' => 0 ,'23' => 0,'24' => 0 ,'25' => 0 ,'26' => 0 ,'27' => 0 ,'28' => 0 ,'29' => 0 ,'30' => 0);
}elseif (cal_days_in_month(CAL_GREGORIAN, date('m'), date('Y')) == 29) {
$array = array('01' => 0 ,'02' => 0 ,'03' => 0 ,'04' => 0 ,'05' => 0 ,'06' => 0 ,'07' => 0 ,'08' => 0 ,'09' => 0 ,'10' => 0 ,'11' => 0 ,'12' => 0 ,'13' => 0 ,'14' => 0 ,'15' => 0 ,'16' => 0 ,'17' => 0 ,'18' => 0 ,'19' => 0 ,'20' => 0 ,'21' => 0 ,'22' => 0 ,'23' => 0,'24' => 0 ,'25' => 0 ,'26' => 0 ,'27' => 0 ,'28' => 0 ,'29' => 0);
}elseif (cal_days_in_month(CAL_GREGORIAN, date('m'), date('Y')) == 28) {
$array = array('01' => 0 ,'02' => 0 ,'03' => 0 ,'04' => 0 ,'05' => 0 ,'06' => 0 ,'07' => 0 ,'08' => 0 ,'09' => 0 ,'10' => 0 ,'11' => 0 ,'12' => 0 ,'13' => 0 ,'14' => 0 ,'15' => 0 ,'16' => 0 ,'17' => 0 ,'18' => 0 ,'19' => 0 ,'20' => 0 ,'21' => 0 ,'22' => 0 ,'23' => 0,'24' => 0 ,'25' => 0 ,'26' => 0 ,'27' => 0 ,'28' => 0);
}
$ads_array = $array;
$pt->month_days = count($array);
$date_type = 'd';
$pt->cat_type = 'this_month';
$pt->chart_title = $lang->this_month;
$pt->chart_text = date("M");
}
elseif ($type == 'this_year') {
$start = strtotime("1 January ".date('Y')." 12:00am");
$end = strtotime("31 December ".date('Y')." 11:59pm");
$array = array('01' => 0 ,'02' => 0 ,'03' => 0 ,'04' => 0 ,'05' => 0 ,'06' => 0 ,'07' => 0 ,'08' => 0 ,'09' => 0 ,'10' => 0 ,'11' => 0 ,'12' => 0);
$ads_array = $array;
$date_type = 'm';
$pt->cat_type = 'this_year';
$pt->chart_title = $lang->this_year;
$pt->chart_text = date("Y");
}
$day_start = strtotime(date('M')." ".date('d').", ".date('Y')." 12:00am");
$day_end = strtotime(date('M')." ".date('d').", ".date('Y')." 11:59pm");
$this_day_ads_earn = $db->rawQuery("SELECT SUM(amount) AS sum FROM ".T_ADS_TRANS." c WHERE `time` >= ".$day_start." AND `time` <= ".$day_end." AND type = 'video' AND video_owner = ".$pt->user->id);
//$this_day_video_earn = $db->rawQuery("SELECT * FROM ".T_VIDEOS_TRSNS." c WHERE `time` >= ".$day_start." AND `time` <= ".$day_end." AND user_id = ".$pt->user->id);
$this_day_video_earn = $db->rawQuery("SELECT * FROM u_paid_videos c WHERE `time` >= ".$day_start." AND `time` <= ".$day_end." AND user_id_uploaded = ".$pt->user->id);
$day_net = 0;
foreach ($this_day_video_earn as $tr) {
if ($tr->currency == "USD") {
//$day_net = $day_net + ($tr->amount - $tr->admin_com);
$day_net = $day_net + ($tr->earned_amount);
}
}
$today_earn = $this_day_ads_earn[0]->sum + $day_net ;
$month_start = strtotime("1 ".date('M')." ".date('Y')." 12:00am");
$month_end = strtotime(cal_days_in_month(CAL_GREGORIAN, date('m'), date('Y'))." ".date('M')." ".date('Y')." 11:59pm");
$this_month_ads_earn = $db->rawQuery("SELECT SUM(amount) AS sum FROM ".T_ADS_TRANS." c WHERE `time` >= ".$month_start." AND `time` <= ".$month_end." AND type = 'video' AND video_owner = ".$pt->user->id);
//$this_month_video_earn = $db->rawQuery("SELECT * FROM ".T_VIDEOS_TRSNS." c WHERE `time` >= ".$month_start." AND `time` <= ".$month_end." AND user_id = ".$pt->user->id);
$this_month_video_earn = $db->rawQuery("SELECT * FROM u_paid_videos c WHERE `time` >= ".$month_start." AND `time` <= ".$month_end." AND user_id_uploaded = ".$pt->user->id);
$month_net = 0;
foreach ($this_month_video_earn as $tr) {
if ($tr->currency == "USD") {
//$month_net = $month_net + ($tr->amount - $tr->admin_com);
$month_net = $month_net + ($tr->earned_amount);
}
}
$month_earn = $this_month_ads_earn[0]->sum + $month_net ;
//$trans = $db->where('user_id',$user->id)->orderBy('id','DESC')->get(T_VIDEOS_TRSNS);
$trans = $db->where('user_id_uploaded',$user->id)->orderBy('id_user')->get('u_paid_videos');
$ads_trans = $db->where('time',$start,'>=')->where('time',$end,'<=')->where('video_owner',$pt->user->id)->where('type','video')->get(T_ADS_TRANS);
$total_ads = 0;
if (!empty($ads_trans)) {
foreach ($ads_trans as $key => $ad) {
if ($ad->time >= $start && $ad->time <= $end) {
$day = date($date_type,$ad->time);
if (in_array($day, array_keys($ads_array))) {
$ads_array[$day] += $ad->amount;
$total_ads += $ad->amount;
}
}
}
}
$ads_list = "";
$total_earn = 0;
if (!empty($trans)) {
foreach ($trans as $tr) {
//$video = PT_GetVideoByID($tr->video_id, 0, 0, 2);
$video = PT_GetVideoByID($tr->id_video, 0, 0, 2);
$user_data = PT_UserData($tr->id);
$currency = "";
$admin_currency = "";
$net = 0;
if ($tr->currency == "USD") {
$currency = "$";
//$admin_currency = "$".$tr->admin_com;
$net = $tr->earned_amount;
}
else if($tr->currency == "EUR"){
$currency = "€";
//$admin_currency = "€".$tr->admin_com;
//$net = $tr->amount - $tr->admin_com;
$net = $tr->earned_amount;
}
elseif ($tr->currency == "EUR_PERCENT") {
$currency = "€";
//$admin_currency = $tr->admin_com."%";
//$net = $tr->amount - ($tr->admin_com * $tr->amount)/100;
$net = $tr->earned_amount;
}
elseif ($tr->currency == "USD_PERCENT") {
$currency = "$";
//$admin_currency = $tr->admin_com."%";
//$net = $tr->amount - ($tr->admin_com * $tr->amount)/100;
$net = $tr->earned_amount;
}
if ($tr->time >= $start && $tr->time <= $end) {
$day = date($date_type,$tr->time);
if (in_array($day, array_keys($array))) {
$array[$day] += $net;
}
}
$total_earn = $total_earn + (float)$net;
if (!empty($video) && !empty($user_data)) {
**$ads_list .= PT_LoadPage('transactions/list',array(**
'ID' => $tr->id,
'PAID_USER' => substr($user_data->name, 0,20),
//'PAID_URL' => $user_data->url,
'USER_NAME' => $user_data->username,
'VIDEO_NAME' => substr($video->title, 0,20) ,
//'VIDEO_URL' => $video->url,
'VIDEO_ID_' => PT_Slug($video->title, $video->video_id),
'AMOUNT' => $tr->earned_amount,
"CURRENCY" => $currency,
"A_CURRENCY" => $admin_currency,
//"NET" => $net,
"TIME" => PT_Time_Elapsed_String($tr->time)
));
}
}
}
$total_earn = $total_earn + $total_ads;
$pt->array = implode(', ', $array);
$pt->ads_array = implode(', ', $ads_array);
$pt->page_url_ = $pt->config->site_url.'/transactions';
$pt->title = $lang->earnings . ' | ' . $pt->config->title;
$pt->page = "transactions";
$pt->description = $pt->config->description;
$pt->keyword = @$pt->config->keyword;
$pt->currency = $currency;
$pt->content = PT_LoadPage('transactions/content',array(
'CURRENCY' => $currency,
'ADS_LIST' => $ads_list,
'TOTAL_EARN' => $total_earn,
'TODAY_EARN' => $today_earn,
'MONTH_EARN' => $month_earn
));
any help will be appreciated.