File manager

File manager - Edit - /home/autoph/public_html/connect/home/update_prospect_database.php

Back
<?php $connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; mysql_connect('localhost','root','aee1024') or die ($connect_error); mysql_select_db('db_vts') or die($connect_error); error_reporting(1); //if submit/ save to databasevar if(isset($_POST['done'])){ $RecordID = mysql_escape_string($_POST['RecordID']); $addBy = mysql_escape_string($_POST['svUserID']); $addDate = mysql_escape_string($_POST['svDate']); $addTime = mysql_escape_string($_POST['svTime']); $updateDesc = mysql_escape_string($_POST['updateDesc']); $sCompID = mysql_escape_string($_POST['sCompID']); $sDealID = mysql_escape_string($_POST['sDealID']); $clickAccountType = mysql_escape_string($_POST['clickAccountType']); $prospectAction = mysql_escape_string($_POST['prospectAction']); mysql_query("INSERT INTO prospect_updates (movement,description, prospect_id, prospect_type, dealer_id, comp_id, date, time, update_by) VALUES('{$prospectAction}','{$updateDesc}','{$RecordID}','{$clickAccountType}','{$sDealID}', '{$sCompID}','{$addDate}','{$addTime}','{$addBy}')"); switch($prospectAction){ case 'active': mysql_query("UPDATE `sales_prospecting` SET `warm_date`='$addDate' WHERE `id`='$RecordID'"); echo "<p style='font-size:16px;padding:5px;background:yellow;padding-left:30px;padding-right:30px;margin:2px'>Update Complete.</p>"; break; case 'demo': mysql_query("UPDATE `sales_prospecting` SET `hot_date`='$addDate' WHERE `id`='$RecordID'"); echo "<p style='font-size:16px;padding:5px;background:yellow;padding-left:30px;padding-right:30px;margin:2px'>Update Complete.</p>"; break; case 'approval': mysql_query("UPDATE `sales_prospecting` SET `sales_approval`='$addDate' WHERE `id`='$RecordID'"); echo "<p style='font-size:16px;padding:5px;background:yellow;padding-left:30px;padding-right:30px;margin:2px'>Update Complete.</p>"; break; case 'win': mysql_query("UPDATE `sales_prospecting` SET `status`='closed', `win_date`='$addDate' WHERE `id`='$RecordID'"); echo "<p style='font-size:16px;padding:5px;background:yellow;padding-left:30px;padding-right:30px;margin:2px'>Update Complete.</p>"; break; case 'lost': mysql_query("UPDATE `sales_prospecting` SET `status`='closed', `lost_date`='$addDate' WHERE `id`='$RecordID'"); echo "<p style='font-size:16px;padding:5px;background:yellow;padding-left:30px;padding-right:30px;margin:2px'>Update Complete.</p>"; break; } $getCustID = mysql_result(mysql_query("SELECT `cust_id` FROM `sales_prospecting` WHERE `id`='$RecordID'"),0); if($clickAccountType==='fleet'){ mysql_query("UPDATE `businesses_names` SET `last_update_date`='$addDate' WHERE `bid`='$getCustID'"); }else{ mysql_query("UPDATE `vts_customers` SET `last_update_date`='$addDate', `last_update_time`='$addTime' WHERE `c_id`='$getCustID'"); } exit(); } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings