GetOne("SELECT fk_user_id FROM domains WHERE id=".$renewid); $domain_name=$conn->GetOne("SELECT domain FROM domains WHERE id=".$renewid); if ($domain_user==$user_id) { echo ''; echo ''; } } else { $default_sorting="ASCII(domain) ASC"; if (isset($sorting)) { $current_sorting=$sorting; } else { $current_sorting=$default_sorting; } //echo "SELECT id,domain,DATE_FORMAT(crDate,'%d/%m/%Y') crDateF,DATE_FORMAT(expDate,'%d/%m/%Y') expDateF,statusITE,IF(DATE_ADD(CURRENT_DATE,INTERVAL 90 DAY)>expDate,1,0) as renew FROM domains WHERE domains.statusITE<>3 and fk_user_id=".$user_id.' order by '. $current_sorting; $my_domains=$conn->GetArray("SELECT id,domain,DATE_FORMAT(crDate,'%d/%m/%Y') crDateF,DATE_FORMAT(expDate,'%d/%m/%Y') expDateF,statusITE,IF(DATE_ADD(CURRENT_DATE,INTERVAL 90 DAY)>expDate,1,0) as renew FROM domains WHERE domains.statusITE<>3 and fk_user_id=".$user_id.' order by '. $current_sorting); if ($my_domains) { //ola ektos ta pending tranfer $domains_count=dot_getValueBySql('SELECT count(*) as count FROM domains WHERE domains.statusITE<>"3" and fk_user_id="'.$user_id.'" order by domain ASC'); echo ''; echo ''; echo ''; echo ''; echo ''; foreach ($my_domains as $row_domain) { $statusITE_str=array_search($row_domain['statusITE'],$statusITE_arr)."_txt"; $domain_pay=$conn->GetRow("SELECT status,fk_type_id FROM basket INNER JOIN basket_items ON basket.id=basket_items.fk_basket_id INNER JOIN domains ON domains.id=basket_items.fk_item_id WHERE fk_type_id<=3 and domains.id=".$row_domain['id']." ORDER BY basket_items.dateLast DESC"); //print_r($domain_pay); if ($domain_pay) { $statusPAY_type_str=$basket_item_type[$domain_pay['fk_type_id']]."_txt"; $statusPAY_status_str=$statusPAY_arr[$domain_pay['status']]."_txt"; if (strpos($statusPAY_status_str,'not_paid')===false) { $statusPAY =''; } else { $statusPAY =''; } } else { $statusPAY_type_str="null_txt"; $statusPAY =''; } if ($row_domain['renew']) { $renew_needed_class='style="color:red"'; } else { $renew_needed_class=''; } echo ''; echo ''; echo''; echo ''; echo ''; //echo ''; echo ''; } } else { echo ''; } } ?>

'; $epp=new eppConn(); if (getDomainData($domain_name)) //SOS { if($epp->send_receive('domain','renew',$renewid)) { $conn->Execute("UPDATE domains SET lastDate=CURDATE(), expDate=DATE_ADD(expDate,INTERVAL 2 YEAR),statusITE=2 WHERE id=".$renewid); include('includes/basket.class.php'); $b=new basket($user_id); $b->add($renewid,2,$prices['domains_renew']); echo domain_update_success_msg; $user_fullΝame=dot_getValueBySql("SELECT fullName FROM users WHERE id=".$user_id); $mailBody=dot_readFile('messages/domain_renewed_'.$lang.'.show'); $mailBody=str_replace('^{domain}^',$renewdomain,$mailBody); $mailBody=str_replace('^{price}^',$prices['domains_renew'],$mailBody); $mailBody=str_replace('^{priceFPA}^',$prices['domains_renew']*1.23,$mailBody); $mailBody=str_replace('^{fullName}^',$user_fullΝame,$mailBody); $mailBody=str_replace('^{username}^',$user_name,$mailBody); $subject=$renewdomain.' - '.new_domain_renew; if (dot_sendEmail($mailBody,$subject,FROM_EMAIL,$user_email,1)=='' && dot_sendEmail($mailBody,$subject,FROM_EMAIL,FROM_EMAIL,1)=='') { echo ' '.domain_form_success_email_msg; } else { echo ' '.domain_form_error_email_msg; } include "inc_basket.php"; } else { echo ' '.ERROR_ITE_txt.' '; } } echo '
'. My_Domains_txt.'
'; echo SYNOLO_DOMAIN_TXT.''.$domains_count.''; echo '			'; $sort_data[0]=array("ASCII(domain) ASC",Sort_Domain_ASC); $sort_data[1]=array("ASCII(domain) DESC",Sort_Domain_DESC); $sort_data[2]=array("expDate ASC",Sort_expDomain_ASC); $sort_data[3]=array("expDate DESC",Sort_expDomain_DESC); $sort_data[4]=array("crDate ASC",Sort_crDomain_ASC); $sort_data[5]=array("crDate DESC",Sort_crDomain_DESC); //$sort_data[5]=array("statusITE ΑSC",Sort_statusITE); $sort_data[6]=array("fk_host_profile_id",Sort_dns); echo SORTING_DOMAIN_TXT.' '.dot_selectbox($sort_data,'sorting',$current_sorting,"",1,"tablehead","onchange=document.forms[0].submit()"); echo '
'.Status_txt.'		'.Domain_name_txt.'	'.Exp_Date_txt.'	DNS	'.Action_txt.'
'.CONSTANT($statusITE_str).'	'.$statusPAY .'	'; echo $row_domain['domain']; $data_bundles=$conn->GetArray("SELECT * FROM bundles WHERE parent='".$row_domain['domain']."' and bundle_name<>'".$row_domain['domain']."'"); if ($data_bundles) { foreach($data_bundles as $bundle) { echo '   '.$bundle['bundle_name']; } } echo '	'.$row_domain['expDateF'].'	'; $data_hosts=$conn->GetArray("SELECT fk_host_ns, num FROM domains_hosts WHERE fk_domain_id=".$row_domain['id']." ORDER BY num"); foreach($data_hosts as $ns) { echo $ns['num'].':'.$ns['fk_host_ns'].' '; } echo '	'.info_txt.'	'.update_txt.'		'; if ($row_domain['renew']) echo ''.RENEW_txt.''; else //echo RENEW_txt; echo '
'.No_domains_txt.'