full_name; $email = $row0->email; $telephone = $row0->telephone; $company = $row0->company; $profile = $row0->profile; $date = $row0->date; $modified_date = $row0->modified_date; $photo = $row0->photo; } // ENQUIRY COUNT $q2 = "select * from enquiry where i_name = '$login_name' and sndr_read_res = '0'"; $r2 = mysql_query($q2); $cnt2 = mysql_num_rows($r2); if ($cnt2 >= 2){ $sent_e = "enquiries"; } else { $sent_e = "enquiry"; } if ($cnt == 0){ $mess_me="You have no enquiries pending."; } while ($row2 = mysql_fetch_object($r2)){ $res_se = $row2->response; $res_da = $row2->date; } if ($res_se){ $res_e = "reponses. Check now"; } else { $res_e = "no response"; } // FEEDBACK COUNT $qa2 = "select * from feedback"; $ra2 = mysql_query($qa2); $cnta2 = mysql_num_rows($ra2); extract($_POST); // CHANGING PASSWORD if($change_password){ $pas1 = $password; $pas2 = md5($pas1); date_default_timezone_set ("Asia/Calcutta"); $cd = date("YmdHis",time()); $query2 = "update register set password = '$pas2', modified_date = '$cd' where login_name = '$temp'"; $result2 = mysql_query($query2) or die (mysql_error()); $tos = mysql_affected_rows(); if ($tos){ unset($_SESSION['username']); session_destroy(); header("location:myaccount.html?passChange=yes"); } else { $msgy .= "There is problem changing your details. Please email administrator."; } } // CHANGING PROFILE if($change_profile){ date_default_timezone_set ("Asia/Calcutta"); $cd = date("YmdHis",time()); $query3 = "update register set email = '$email', telephone = '$telephone', company = '$company', profile = '$profile', modified_date = '$cd' where login_name = '$temp'"; $result3 = mysql_query($query3) or die (mysql_error()); $tosx = mysql_affected_rows(); if ($tosx){ $msg_ch = "Your details have been reflected in our database. Please check the details."; } else { $msg_ch = "There is problem updating your changes. Please email administrator."; } } // CHANGING PROFESSIONAL PROFILE if ($change_pp_profile){ include_once('connect_db.php'); $query44 = "update real_data set address = '$pp_address', telephone = '$pp_telephone', fax = '$pp_fax', email = '$pp_email', website = '$pp_web', description = '$pp_description', contact = '$pp_contact' where company = '$pp_company'"; $result44 = mysql_query($query44) or die (mysql_error()); $tos44 = mysql_affected_rows(); if ($tos44){ $msg_ch = "Your details have been reflected in our database. Please check the details."; } else { $msg_ch = "There is problem updating your changes. Please email administrator."; } mysql_close($link); } // ADD KEYWORDS TO RESPECTIVE COMPANY if ($add_keywords){ include_once('connect_db.php'); $query54 = "select * from real_data where company = '$company'"; $result54 = mysql_query($query54) or die (mysql_error()); while ($row54 = mysql_fetch_object($result54)){ $keys = $row54->keyword; } $keysw = "$keys" . " $keyword"; $query55 = "update real_data set keyword = '$keysw' where company = '$company'"; $result55 = mysql_query($query55) or die (mysql_error()); $tos55 = mysql_affected_rows(); if ($tos55){ $msg_ch = "Your details have been reflected in our database. Please check the details."; } else { $msg_ch = "There is problem updating your changes. Please email administrator."; } mysql_close($link); } // ENQUIRY RESPONSE if ($modify_response){ date_default_timezone_set ("Asia/Calcutta"); $cd = date("YmdHis",time()); $query4 = "update enquiry set response = '$my_response', response_date = '$cd' where id = '$ids'"; $result4 = mysql_query($query4) or die (mysql_error()); $tosj = mysql_affected_rows(); if ($tosj){ $msg_ch = "Your details have been reflected in our database. Please check the details."; } else { $msg_ch = "There is problem updating your changes. Please email administrator."; } } // UPLOAD VIDEO if ($upload_video){ if ($dka){ $fn=$_FILES['video']['name']; $tn=$_FILES['video']['tmp_name']; $allowed_filetypes = array('.flv'); $ext = substr($fn, strpos($fn,'.'), strlen($fn)-1); if(!in_array($ext,$allowed_filetypes)){ die('The file you attempted to upload is not allowed. It should be a .flv file.'); } if ($_FILES["video"]["size"] < 5242880) { $paths = "video/$dka"; if (!is_dir($paths)){ mkdir("$paths",0777); } $newpath = "$paths/$fn"; $domain = preg_replace("/^(.*\.)?([^.]*\..*)$/", "$2", $_SERVER['HTTP_HOST']); move_uploaded_file($tn,$newpath); $query5 = "update register set video = '$fn', domain = '$domain' where company = '$dka'"; $result5 = mysql_query($query5); include_once('connect_db.php'); $query6="update real_data_industrial set video = '$fn', domain = '$domain' where company = '$dka'"; $result6=mysql_query($query6) or die(mysql_error()); $query7="update real_data set video = '$fn', domain = '$domain' where company = '$dka'"; $result7=mysql_query($query7) or die(mysql_error()); $nos = mysql_affected_rows(); mysql_close($link); include('connect_db.php'); } else { $video_msg = "The file size should be less 5 mb."; header('location:myaccount.html?page=video&value=exceeded'); } } else { $video_msg = "You haven't defined your company name, can't upload your video."; header('location:myaccount.html?page=video&value=missing'); } } // PHOTO UPLOAD if ($photo_upload){ $fn=$_FILES['photo']['name']; $tn=$_FILES['photo']['tmp_name']; $allowed_filetypes = array('.jpg','.png','.gif','.ico'); $ext = substr($fn, strpos($fn,'.'), strlen($fn)-1); if(!in_array($ext,$allowed_filetypes)){ die('The file you attempted to set your photo ain\'t a valid file. It should be a .jpg, .png, .gif or .ico one.'); } $paths = "video/photo/$company"; if (!is_dir($paths)){ mkdir("$paths",0777); } if(!file_exists("$paths/$fn")){ move_uploaded_file($tn,"$paths/$fn"); $query="update register set photo = '$fn' where company = '$company'"; $result=mysql_query($query) or die(mysql_error()); if($result) { $query="select photo from register where company='$company'"; $result=mysql_query($query) or die (mysql_error()); $row=mysql_fetch_object($result); $n="$row->photo"; echo "
"; if ($n) { header('location:myaccount.html?page=photo&value=success'); } else { header('location:myaccount.html?page=photo&value=fails'); } echo "
"; } else { $photo_msg = "file is not uploaded"; } } } // EXISTING PHOTO UPLOAD if ($photo_upload_ex){ $query="update register set photo = '$photox' where company = '$company'"; $result=mysql_query($query) or die(mysql_error()); if($result) { header('location:myaccount.html?page=photo'); } } // EMAIL TO ADMINISTRATOR if ($send_email){ @mysql_close($link); require('connect_db_indiaonline.php'); date_default_timezone_set ("Asia/Calcutta"); $cd = date("YmdHis",time()); $q24 = "insert into yellowpd_yellowpdlg.admin_mail (sender_n,sender_e,sender_s,sender_t,sender_m,domain,date) values ('$y_name','$y_email','$y_subject','$y_telephone','$y_message','$domain','$cd')"; $re24 = mysql_query($q24) or die ("The errors are: " .mysql_error()); $cnt24 = mysql_affected_rows(); if (!$cnt24){ exit; } mysql_close($linkt); if ($y_telephone){ $tele = "You also can call at this number $y_telephone."; } $message = stripslashes(nl2br($y_message)); $receiver = $sender_by_force; $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; $headers .= "From: " . $y_name . "<" . $y_email .">" . "\r\n"; $headers .= "Reply-to: " . $y_name . "<" . $y_email .">" . "\r\n"; $subject = "Subject: $y_subject"; $message="
An email from $y_email at $domain
Hello admin,

Following are my details:

My name: $y_name
The telephone #: $y_telephone

The email: $y_email


$y_name typed following message:
$message

Yours faithfully,
$y_name


Email service
Economical Host Team
"; $sent = mail($receiver, $subject, $message, $headers); if ($sent){ header('location:myaccount.html?page=email&value=email_sent'); } // END EMAIL NOTIFICATION } $title = ":: My account :: $temp"; extract($_GET); ?> <?= $title ?>
HomeVideoFriends
  You are welcome
"; } else { echo ""; } ?>
profile
edit

feedback
 

enquiry
 

video
upload

add friends
 

photo
upload


mail to administrator
"; echo "log out
"; } ?>
 
Welcome $temps
"; echo "
"; if ($msg_ch){ echo "Message: $msg_ch"; echo "
"; } //profile echo "
Profile
"; echo "
"; echo "With profile you can view your own profile and edit them. Any one can view your profile. You can change this using settings option given on left of screen."; //enquiry echo "
"; echo "
Enquiry
"; echo "
"; echo "Your have sent $cnt2 $sent_e and you have $res_e."; echo "
"; // friends echo "
"; echo "
Friends
"; echo "
"; echo "This part is under construction."; echo "
"; // Feedback echo "
"; echo "
Feedback
"; echo "
"; include('connect_db.php'); $q3 = "select * from feedback where c_email = '$email'"; $r3 = mysql_query($q3); $cnt3 = mysql_num_rows($r3); if ($cnt3){ echo "You have given us your feedback. Please see if there is some response."; } else { echo "You haven't given us any feedback as yet. We are eager to know what you think about us."; } if ($cnta2){ echo " There are $cnta2 feedbacks. View them"; } echo "
"; } // PROFILE PAGE if ($page == "profile"){ echo "
"; echo "
$full_name
View or update profile.
"; echo "
"; // start profile dispaly echo "
"; include_once('connect_db.php'); $qu0 = "select * from real_data where company = '$company'"; $re0 = mysql_query($qu0); $cn01 = mysql_num_rows($re0); while ($rw0 = mysql_fetch_object($re0)){ $cmpny = $rw0->company; $addre = $rw0->address; $telep = $rw0->telephone; $faxs = $rw0->fax; $emil = $rw0->email; $web = $rw0->website; $descp = $rw0->description; $cntct = $rw0->contact; $keywrd = $rw0->keyword; } // displaying professional profile. echo "
"; echo "
Professional profile
"; echo "
"; if ($cn01){ echo "
"; echo "company: $cmpny"; echo "
"; echo "address: $addre"; echo "
"; echo "telephone: $telep"; echo "
"; echo "fax: $faxs"; echo "
"; echo "email: $emil"; echo "
"; echo "Website: $web"; echo "
"; echo "contact: $cntct"; echo "
"; echo "description: $descp"; echo "
"; } else { echo "According to our database, you have no professional profile. But if you have one and it is not displaying please do one of the following:"; echo "
"; echo "
    "; echo "
  1. Please update your personal profile with the same company name exists in our database and appears after search."; echo "
  2. Please email to administrator with your problems in detail."; echo "
"; echo "
"; } echo "
"; echo "
"; mysql_close($link); include('connect_db.php'); // displaying personal profile. echo "
"; echo "
Personal profile
"; echo "
"; echo "
"; echo "Email: $email"; echo "
"; echo "Telephone # $telephone"; echo "
"; echo "Company: "; if ($company == ""){ echo "no company name."; } else { echo "$company"; } echo "
"; echo "Profile: "; if ($profile == ""){ echo "no profile name."; } else { echo "$profile"; } echo "
"; echo "You last time modified your profile on $modified_date"; echo "
"; echo "
"; echo "
"; echo "
"; // end profile display echo "
$msg_ch
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "Professional Profile"; echo "
"; echo "
"; echo "
company:
"; echo "
"; echo "
"; echo "
address:
"; echo "
"; echo "
"; echo "
telephone:
"; echo "
"; echo "
"; echo "
fax:
"; echo "
"; echo "
"; echo "
email:
"; echo "
"; echo "
"; echo "
website:
"; echo "
"; echo "
"; echo "
description:
"; echo "
"; echo "
"; echo "
contact person:
"; echo "
"; echo "
"; echo "
 
"; echo "
  
"; echo "
"; echo "
"; echo "
"; // MODIFY PERSONAL PROFILE echo "
"; echo "Personal Profile"; echo "
"; echo "
"; echo "
Email:
"; echo "
"; echo "
"; echo "
Telephone:
"; echo "
"; echo "
"; echo "
Company:
"; echo "
"; echo "
"; echo "
Profile:
"; echo "
"; echo "
"; echo "
 
"; echo "
  
"; echo "
"; echo "
"; echo "
"; // KEYWORD MODIFY echo "
"; echo "Add keywords"; echo "
"; echo "seperate tags using comma"; echo "
"; echo "
"; echo "
Add keywords:
"; echo "
"; echo "
"; echo "
 
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "Change Password"; echo "
"; echo "
"; echo "
Password:
"; echo "
"; echo "
"; echo "
 
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; } echo "
"; // FEEDBACK PAGE if ($page == "feedback"){ echo "
"; echo "
$full_name
Below are feedbacks submitted by users.
"; echo "
"; if ($cnta2 == 0){ echo "There is no feedback received as yet."; } echo "
"; $q4 = "select * from feedback where active='T' order by date asc limit 20"; $r4 = mysql_query($q4); while ($row4 = mysql_fetch_object($r4)){ echo "
Submitted by: $row4->c_name on $row4->date
"; echo "
"; echo "
Feedback: $row4->c_message
"; echo "
"; echo "
Admin: "; if ($row4->response){ echo $row4->response; } else { echo "no response as yet."; } echo "
"; echo "
"; } echo "
"; } // ENQUIRY PAGE if ($page == "enquiry"){ // if advertiser, give an option to submit his response. echo "
"; echo "
$full_name
You can view your enquiry and response.
"; echo "
"; if ($mess_me){ echo "$mess_me"; } $q5 = "select * from enquiry where c_cell = '$telephone'"; $r5 = mysql_query($q5); $cnt5 = mysql_num_rows($r5); if ($cnt5){ while ($row5 = mysql_fetch_object($r5)){ $comp = $row5->comp; $responsee = $row5->response; echo "
Enquiry (on $row5->date):
$row5->c_desc
"; echo "
"; echo "
Response "; if ($responsee){ echo "(on $row5->response_date):
$responsee
"; } else { echo "Please wait for response...
"; } } } $q7 = "select * from enquiry where comp = '$company' and response = ''"; $r7 = mysql_query($q7); $sp = 1; while ($row7 = mysql_fetch_object($r7)){ $query_me = $row7->c_desc; $resp = $row7->response; echo "
Enquiry (on $row7->date):
$query_me
"; echo "
"; echo "
Response "; if ($resp){ echo "(on $row6->resp_date):
$resp
"; } else { echo "No response given..."; } $id = $row7->id; echo "
"; echo "
"; echo "
"; echo ""; echo ""; echo "
"; echo "
"; echo "
 
"; $sp++; } $q6 = "select * from enquiry where comp = '$company' and response != ''"; $r6 = mysql_query($q6); $cnt6 = mysql_num_rows($r6); if ($cnt6){ while ($row6 = mysql_fetch_object($r6)){ $comp = $row6->comp; $responsee = $row6->response; echo "
Enquiry (on $row6->date):
$row6->c_desc
"; echo "
"; echo "
Response "; if ($responsee){ echo "(on $row6->response_date):
$responsee
"; } else { echo "Please wait for response..."; } } } } // VIDEO PAGE if ($page == "video"){ // give both option upload as well view echo "
"; echo "
$full_name
You can upload your video here.
"; echo "
"; if ($value=="missing"){ echo "Message: Your company name is missing in our database. Please update your profile before you upload your video."; echo "
"; } else if ($value=="exceeded"){ echo "Message: Now you got a size problem. The flv file you are uploading should have size not maximum than 5mb."; echo "
"; } echo "There are conditions before you upload video. They are the following:"; echo "
    "; echo "
  1. You need to specify your company name in your profile if there is none."; echo "
  2. The company name you specify should be exactly the same as that on search page. If there is any difference, there may be problem viewing data on the search page. But your friends can view your video on here."; echo "
  3. Your video should be an \"flv\" file and can be maximum of 5mb in size."; echo "
  4. Your video shouldn't contain films of obscene nature."; echo "
  5. Please keep the website integrity intact."; echo "
"; // upload video echo "
"; echo "
"; echo "Upload video:   "; echo ""; echo ""; echo ""; echo "
"; // div align center // view video. echo "
"; include_once('connect_db.php'); $querys = "select * from real_data where company = '$company' and video != ''"; $results = mysql_query($querys) or die (mysql_error()); $count = mysql_num_rows($results); //echo $count; if ($count == 1){ while ($rows = mysql_fetch_object($results)){ $videos = $rows->video; $domains = $rows->domain; } if ($videos){ echo ""; echo ""; } else { echo "
"; echo "
Video has not been uploaded as yet. Please click on the respective link to upload it.
"; } mysql_close($link); } else { include('connect_db.php'); $querys = "select * from register where company = '$company'"; $results = mysql_query($querys) or die (mysql_error()); $count = mysql_num_rows($results); while ($rows = mysql_fetch_object($results)){ $videos = $rows->video; $domains = $rows->domain; } echo "
"; if ($videos){ echo ""; echo ""; } else { echo "
"; echo "
Video has not been uploaded as yet.
"; } echo "
"; } echo "
"; } // PHOTO PAGE if ($page == "photo"){ // echo "
"; echo "
$full_name
Change your image here, only the picture.
"; echo "
"; echo "
"; if ($value=="success"){ echo "Message: You have successfully uploaded your image."; echo "
"; } else if ($value=="fails"){ echo "Message: You couldn't upload your image because of two reasons: either you are uploading same image or the image format is not good."; echo "
"; } // $path = $_SERVER["REQUEST_URI"]; $file = basename ($path); $dir1 = "video/photo/$company"; if (@$handle = opendir($dir1)) { echo ""; echo ""; while (false !== ($file = readdir($handle))) { if ($file != "." && $file != "..") { echo ""; if($x==3){ echo ""; echo ""; $x=-1; } $x++; } } echo "
"; echo "  "; echo "
"; closedir($handle); echo ""; echo ""; echo ""; echo ""; echo "
Load already existing photos you have uploaded recently. Click on image to select photo and hit replace button.
"; echo ""; echo "Photo:  "; echo ""; echo ""; echo "
"; } // END CHECK CODES @unlink ("$dir1/Thumbs.db"); // echo "
"; // upload photo echo "
"; echo "
"; echo "
"; echo "Upload your photo"; echo "
"; echo "
"; echo "
Photo:
  
"; echo "
"; echo "
 
"; echo "
"; echo "
"; echo "
"; echo "
"; } // FRIENDS PAGE if ($page == "friends"){ // Add your friends here. But not updated as well. echo "
"; echo "
$full_name
You can add as many friends and view their profile.
"; echo "
"; echo "This part hasn't been configured. It will be done in near future"; echo "
"; } // SETTINGS PAGE if ($page == "settings"){ // Define your settings here. But not updated as well. echo "
"; echo "
$full_name
You can change some of settings.
"; echo "
"; echo "This part hasn't been configured. It will be done in near future"; echo "
"; } // EMAIL TO ADMINISTRATOR if ($page == "email"){ // Email to administrator. echo "
"; echo "
$full_name
You can email to administrator.
"; echo "
"; if ($value=="email_sent"){ echo ""; echo ""; echo ""; echo ""; echo "
Your email has successfully been sent to administrator.
"; echo ""; echo "
 
"; } ?>
The following form will process your email
your name:    your email:    
your subject:    your telephone:    
Type in your message below
"; } // SIGN OUT PAGE if ($page == "logout"){ // if advertiser, give an option to submit his response. unset($_SESSION['username']); session_destroy(); header("location:myaccount.html?logoutme=yes"); } ?>
Sign in
Username:
Password: