comecondo.com

Linux Sandbox-A 4.4.0-210-generic #242-Ubuntu SMP Fri Apr 16 09:57:56 UTC 2021 x86_64
Apache/2.4.18 (Ubuntu)
68.183.124.220
Cant read /etc/named.conf

File Name : original_submission_contact_details.php

<?php

require_once( dirname( __FILE__ ) . '/admin.php' );

$email = $_POST['email'];
$submission_details = $wpdb->get_results("select firstname, lastname, phone, whereFrom from cc_submission_details where email='{$email}';");
$tags = $wpdb->get_results("select distinct tag_name, tag_value from cc_submission_tags where email='{$email}' order by 1,2;");
foreach ($submission_details as $s){
?>    
    <h2> 
<?php echo $s->firstname . " " . $s->lastname; ?>
    </h2>
    <h3>
<?php  echo "Email: " . $email;?>
    </h3>
    <h3>
<?php  echo "Phone: " . $s->phone;?>
    </h3>
    <h3>
<?php  echo "From: " . $s->whereFrom;?>
    </h3>
    <h3>
<?php
    foreach ($tags as $tag) {
        echo $tag->tag_name . ":" . $tag->tag_value . " / ";
    }
 ?>
    </h3>

<?php
}

$visits = $wpdb->get_results("select distinct country, concat(logdate,' ', logtime) as logtime, agent, page_name, property_city, page_id from cc_view_visitors_property_history where page_name is not null and submission='{$email}' order by 2 desc;");
?>
<style>
.flex-container {
    display: flex;
}
.flex-child {
    flex: 1;
    border: none;
}  
.flex-child:first-child {
    margin-right: 20px;
}

.mytable{}

.mytd {
white-space: pre-line;
}

th, td {
  border: 1px solid black;
  border-collapse:  collapse;
  white-space:pre;
  word-wrap: break-word
}

</style>

<html>
<div class="flex-container">
  <div class="flex-child">
    <h2>客户访问记录</h2>
    <table frame='border' cellspacing='5'>
<?php
    echo "<th>访问时间</th>";
    echo "<th>浏览器</th>";
    echo "<th>访问页面</th>";
    echo "<th>楼盘城市</th>";
    foreach ($visits as $visit) {
?>
        <col align='left'</col>
<?php
        echo "<td>" . $visit->logtime . "</td>";
        echo "<td>" . $visit->agent . "</td>";
        echo "<td><a href='comecondo.com/?p=" .$visit->page_id . "' target='_blank'>"  . $visit->page_name . "</a></td>";
        echo "<td>" . $visit->property_city . "</td>";
?>
<?php
    }
?>
    </table>
  </div>
  
  <div class="flex-child">
    <h2>客户沟通记录</h2>
    <form action="" method="post">
        <input name="email" type="text" value="<?php echo $email; ?>">
        <input name="contactdate" type="date" value="<?php echo date('Y-m-d');?>">
        <input name="contacttime" type="time" value="<?php echo date('h:i:sa');?>">
        <textarea name="notes" cols="80" rows="5"></textarea>
        <input name="Submitt" type="submit"> 
    </form>
<?php
  if(isset($_POST['Submitt'])){
      $contactdate = $_POST["contactdate"];
      $contacttime = $_POST["contacttime"];
      $notes       = $_POST["notes"];
      $email       = $_POST["email"];
      global $wpdb;
      $wpdb->set_charset($wpdb->dbh, 'gb2312');
      $wpdb->insert('cc_submissions_contact_history', array('email'=>$email,'contact_date'=>$contactdate,'contact_time'=>$contacttime,'notes'=>$notes));
      echo $wpdb->last_error;
  }
  $contacts = $wpdb->get_results("select distinct email, concat(contact_date,' ',contact_time) as contact_time, notes from cc_submissions_contact_history where email='{$email}' order by 2 desc;");
?>

<table class="mytable">
        <th>时间</th>
        <th>记录</th>
<?php 
        foreach ($contacts as $c) {
?>
        <col style="width:20%;"></col>
        <col style="width:80%;"></col>
        <td class="mytd"> <?php echo $c->contact_time;?></td>
        <td class="mytd"> <?php echo $c->notes;?></td>
<?php        
        }
?>
    </table>
  </div>
  
</div>

</html>

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	gavin/www-data	drwxr-sr-x	2025-08-29 03:10:31
..	dir	-	gavin/www-data	drwxr-sr-x	2024-12-15 11:41:30
css	dir	-	gavin/www-data	drwxr-sr-x	2019-06-18 05:50:52
dk7kdoeyIkd6ll1dk	dir	-	gavin/www-data	drwxrwsr-x	2026-05-23 05:31:31
images	dir	-	gavin/www-data	drwxr-sr-x	2019-06-18 05:50:52
includes	dir	-	gavin/www-data	drwxr-sr-x	2024-12-15 11:43:46
js	dir	-	gavin/www-data	drwxr-sr-x	2019-06-18 05:50:52
maint	dir	-	gavin/www-data	drwxr-sr-x	2019-06-18 05:50:52
network	dir	-	gavin/www-data	drwxr-sr-x	2021-02-02 03:37:58
user	dir	-	gavin/www-data	drwxr-sr-x	2021-06-15 03:55:22
about.php	text/x-php	9.6 KB	gavin/www-data	-rw-r--r--	2019-06-18 04:53:52
admin-ajax.php	text/x-php	4.52 KB	gavin/www-data	-rw-r--r--	2019-04-12 07:24:51
admin-footer.php	text/x-php	2.56 KB	gavin/www-data	-rw-r--r--	2017-11-30 11:11:00
admin-functions.php	text/x-php	409 B	gavin/www-data	-rw-r--r--	2017-11-30 11:11:00
admin-header.php	text/x-php	7.69 KB	gavin/www-data	-rw-r--r--	2019-04-12 07:05:51
admin-post.php	text/x-php	1.65 KB	gavin/www-data	-rw-r--r--	2019-01-16 05:41:50
admin.php	text/x-php	11.15 KB	gavin/www-data	-rw-r--r--	2019-01-15 05:48:50
async-upload.php	text/x-php	3.58 KB	gavin/www-data	-rw-r--r--	2018-12-19 07:42:49
comment.php	text/x-php	10.65 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
credits.php	text/x-php	5.48 KB	gavin/www-data	-rw-r--r--	2019-05-17 01:09:52
custom-background.php	text/x-php	20.04 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
custom-header.php	text/x-php	46.3 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
customize.php	text/x-php	9.34 KB	gavin/www-data	-rw-r--r--	2018-02-19 02:13:32
edit-comments.php	text/x-php	13.81 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
edit-form-advanced.php	text/x-php	27.52 KB	gavin/www-data	-rw-r--r--	2019-04-17 01:56:52
edit-form-blocks.php	text/x-php	12.88 KB	gavin/www-data	-rw-r--r--	2019-03-20 08:12:51
edit-form-comment.php	text/x-php	7.32 KB	gavin/www-data	-rw-r--r--	2019-01-29 07:10:49
edit-link-form.php	text/x-php	6 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
edit-tag-form.php	text/x-php	9.27 KB	gavin/www-data	-rw-r--r--	2019-01-21 04:50:50
edit-tags.php	text/x-php	20.5 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
edit.php	text/x-php	16.76 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
export.php	text/x-php	10.67 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
freedoms.php	text/x-php	5.91 KB	gavin/www-data	-rw-r--r--	2019-05-17 01:09:52
import.php	text/x-php	7.26 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
index.php	text/x-php	5.75 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
install-helper.php	text/x-php	5.77 KB	gavin/www-data	-rw-r--r--	2017-11-30 11:11:00
install.php	text/x-php	16.44 KB	gavin/www-data	-rw-r--r--	2019-05-17 06:16:54
link-add.php	text/x-php	727 B	gavin/www-data	-rw-r--r--	2017-11-30 11:11:00
link-manager.php	text/x-php	3.91 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
link-parse-opml.php	text/x-php	2.38 KB	gavin/www-data	-rw-r--r--	2017-11-30 11:11:00
link.php	text/x-php	2.67 KB	gavin/www-data	-rw-r--r--	2017-11-30 11:11:00
load-scripts.php	text/x-php	1.62 KB	gavin/www-data	-rw-r--r--	2018-12-17 03:15:20
load-styles.php	text/x-php	2.21 KB	gavin/www-data	-rw-r--r--	2018-08-20 01:51:24
media-new.php	text/x-php	3.11 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
media-upload.php	text/x-php	3.3 KB	gavin/www-data	-rw-r--r--	2018-02-19 02:13:32
media.php	text/x-php	5.49 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
menu-header.php	text/x-php	9.47 KB	gavin/www-data	-rw-r--r--	2018-12-19 07:42:49
menu.php	text/x-php	13.86 KB	gavin/www-data	-rw-r--r--	2019-06-10 07:50:53
moderation.php	text/x-php	322 B	gavin/www-data	-rw-r--r--	2017-11-30 11:11:00
ms-admin.php	text/x-php	211 B	gavin/www-data	-rw-r--r--	2013-09-25 12:18:11
ms-delete-site.php	text/x-php	3.94 KB	gavin/www-data	-rw-r--r--	2018-08-17 01:51:36
ms-edit.php	text/x-php	231 B	gavin/www-data	-rw-r--r--	2013-09-25 12:18:11
ms-options.php	text/x-php	238 B	gavin/www-data	-rw-r--r--	2017-11-30 11:11:00
ms-sites.php	text/x-php	230 B	gavin/www-data	-rw-r--r--	2017-11-30 11:11:00
ms-themes.php	text/x-php	232 B	gavin/www-data	-rw-r--r--	2017-11-30 11:11:00
ms-upgrade-network.php	text/x-php	234 B	gavin/www-data	-rw-r--r--	2017-11-30 11:11:00
ms-users.php	text/x-php	230 B	gavin/www-data	-rw-r--r--	2017-11-30 11:11:00
my-sites.php	text/x-php	4.55 KB	gavin/www-data	-rw-r--r--	2021-02-02 03:37:36
nav-menus.php	text/x-php	42.56 KB	gavin/www-data	-rw-r--r--	2019-05-16 04:35:04
network.php	text/x-php	5.24 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
options-discussion.php	text/x-php	14.82 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
options-general.php	text/x-php	14.75 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
options-head.php	text/x-php	492 B	gavin/www-data	-rw-r--r--	2017-11-30 11:11:00
options-media.php	text/x-php	6.03 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
options-permalink.php	text/x-php	18.13 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
options-reading.php	text/x-php	8.36 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
options-writing.php	text/x-php	8.37 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
options.php	text/x-php	11.62 KB	gavin/www-data	-rw-r--r--	2018-08-17 01:51:36
original_submission_contact_details.php	text/x-php	3.43 KB	gavin/www-data	-rw-rw-r--	2024-12-07 04:24:32
plugin-editor.php	text/x-php	12.94 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
plugin-install.php	text/x-php	6.17 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
plugins.php	text/x-php	23.69 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
post-new.php	text/x-php	2.62 KB	gavin/www-data	-rw-r--r--	2019-04-17 01:56:52
post.php	text/x-php	9.36 KB	gavin/www-data	-rw-r--r--	2019-02-07 04:12:51
press-this.php	text/x-php	2.33 KB	gavin/www-data	-rw-r--r--	2018-08-17 01:51:36
privacy.php	text/x-php	7.92 KB	gavin/www-data	-rw-r--r--	2019-03-21 09:17:50
profile.php	text/x-php	298 B	gavin/www-data	-rw-r--r--	2017-11-30 11:11:00
revision.php	text/x-php	5.05 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
setup-config.php	text/x-php	15.19 KB	gavin/www-data	-rw-r--r--	2019-02-12 04:52:53
site-health-info.php	text/x-php	5.5 KB	gavin/www-data	-rw-r--r--	2019-06-10 07:50:53
site-health.php	text/x-php	5.17 KB	gavin/www-data	-rw-r--r--	2019-06-10 01:48:52
submission_contact_details.php	text/html	3.41 KB	gavin/www-data	-rw-rw-r--	2025-08-29 03:09:08
term.php	text/x-php	2.06 KB	gavin/www-data	-rw-r--r--	2018-02-19 02:13:32
theme-editor.php	text/x-php	14.47 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
theme-install.php	text/x-php	14.79 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
themes.php	text/x-php	22.75 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
tools.php	text/x-php	2.55 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
update-core.php	text/x-php	31.79 KB	gavin/www-data	-rw-r--r--	2019-05-17 06:16:54
update.php	text/x-php	10.1 KB	gavin/www-data	-rw-r--r--	2018-08-17 01:51:36
upgrade-functions.php	text/x-php	344 B	gavin/www-data	-rw-r--r--	2017-11-30 11:11:00
upgrade.php	text/x-php	5.52 KB	gavin/www-data	-rw-r--r--	2019-05-17 06:16:54
upload.php	text/x-php	13.35 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
user-edit.php	text/x-php	28.13 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
user-new.php	text/x-php	21.72 KB	gavin/www-data	-rw-r--r--	2019-04-15 10:39:50
users.php	text/x-php	19.25 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56
widgets.php	text/x-php	19.14 KB	gavin/www-data	-rw-r--r--	2019-04-08 10:59:56

Name	Size	Last Modified	Owner / Group	Permissions	Options
..	--	December 15 2024 23:41:30	gavin / www-data	2755
css	--	June 18 2019 17:50:52	gavin / www-data	2755
dk7kdoeyIkd6ll1dk	--	May 23 2026 05:31:31	gavin / www-data	2775
images	--	June 18 2019 17:50:52	gavin / www-data	2755
includes	--	December 15 2024 23:43:46	gavin / www-data	2755
js	--	June 18 2019 17:50:52	gavin / www-data	2755
maint	--	June 18 2019 17:50:52	gavin / www-data	2755
network	--	February 02 2021 03:37:58	gavin / www-data	2755
user	--	June 15 2021 03:55:22	gavin / www-data	2755

about.php	9.604 KB	June 18 2019 16:53:52	gavin / www-data	0644
admin-ajax.php	4.519 KB	April 12 2019 19:24:51	gavin / www-data	0644
admin-footer.php	2.564 KB	November 30 2017 23:11:00	gavin / www-data	0644
admin-functions.php	0.399 KB	November 30 2017 23:11:00	gavin / www-data	0644
admin-header.php	7.687 KB	April 12 2019 19:05:51	gavin / www-data	0644
admin-post.php	1.652 KB	January 16 2019 05:41:50	gavin / www-data	0644
admin.php	11.151 KB	January 15 2019 05:48:50	gavin / www-data	0644
async-upload.php	3.585 KB	December 19 2018 07:42:49	gavin / www-data	0644
comment.php	10.646 KB	April 08 2019 22:59:56	gavin / www-data	0644
credits.php	5.479 KB	May 17 2019 01:09:52	gavin / www-data	0644
custom-background.php	20.036 KB	April 08 2019 22:59:56	gavin / www-data	0644
custom-header.php	46.299 KB	April 08 2019 22:59:56	gavin / www-data	0644
customize.php	9.343 KB	February 19 2018 02:13:32	gavin / www-data	0644
edit-comments.php	13.806 KB	April 08 2019 22:59:56	gavin / www-data	0644
edit-form-advanced.php	27.517 KB	April 17 2019 01:56:52	gavin / www-data	0644
edit-form-blocks.php	12.876 KB	March 20 2019 08:12:51	gavin / www-data	0644
edit-form-comment.php	7.322 KB	January 29 2019 19:10:49	gavin / www-data	0644
edit-link-form.php	5.996 KB	April 08 2019 22:59:56	gavin / www-data	0644
edit-tag-form.php	9.271 KB	January 21 2019 04:50:50	gavin / www-data	0644
edit-tags.php	20.502 KB	April 08 2019 22:59:56	gavin / www-data	0644
edit.php	16.761 KB	April 08 2019 22:59:56	gavin / www-data	0644
export.php	10.671 KB	April 08 2019 22:59:56	gavin / www-data	0644
freedoms.php	5.907 KB	May 17 2019 01:09:52	gavin / www-data	0644
import.php	7.256 KB	April 08 2019 22:59:56	gavin / www-data	0644
index.php	5.751 KB	April 08 2019 22:59:56	gavin / www-data	0644
install-helper.php	5.769 KB	November 30 2017 23:11:00	gavin / www-data	0644
install.php	16.438 KB	May 17 2019 18:16:54	gavin / www-data	0644
link-add.php	0.71 KB	November 30 2017 23:11:00	gavin / www-data	0644
link-manager.php	3.911 KB	April 08 2019 22:59:56	gavin / www-data	0644
link-parse-opml.php	2.382 KB	November 30 2017 23:11:00	gavin / www-data	0644
link.php	2.673 KB	November 30 2017 23:11:00	gavin / www-data	0644
load-scripts.php	1.616 KB	December 17 2018 03:15:20	gavin / www-data	0644
load-styles.php	2.209 KB	August 20 2018 13:51:24	gavin / www-data	0644
media-new.php	3.114 KB	April 08 2019 22:59:56	gavin / www-data	0644
media-upload.php	3.297 KB	February 19 2018 02:13:32	gavin / www-data	0644
media.php	5.486 KB	April 08 2019 22:59:56	gavin / www-data	0644
menu-header.php	9.466 KB	December 19 2018 07:42:49	gavin / www-data	0644
menu.php	13.857 KB	June 10 2019 07:50:53	gavin / www-data	0644
moderation.php	0.314 KB	November 30 2017 23:11:00	gavin / www-data	0644
ms-admin.php	0.206 KB	September 25 2013 00:18:11	gavin / www-data	0644
ms-delete-site.php	3.937 KB	August 17 2018 01:51:36	gavin / www-data	0644
ms-edit.php	0.226 KB	September 25 2013 00:18:11	gavin / www-data	0644
ms-options.php	0.232 KB	November 30 2017 23:11:00	gavin / www-data	0644
ms-sites.php	0.225 KB	November 30 2017 23:11:00	gavin / www-data	0644
ms-themes.php	0.227 KB	November 30 2017 23:11:00	gavin / www-data	0644
ms-upgrade-network.php	0.229 KB	November 30 2017 23:11:00	gavin / www-data	0644
ms-users.php	0.225 KB	November 30 2017 23:11:00	gavin / www-data	0644
my-sites.php	4.55 KB	February 02 2021 03:37:36	gavin / www-data	0644
nav-menus.php	42.563 KB	May 16 2019 16:35:04	gavin / www-data	0644
network.php	5.236 KB	April 08 2019 22:59:56	gavin / www-data	0644
options-discussion.php	14.824 KB	April 08 2019 22:59:56	gavin / www-data	0644
options-general.php	14.747 KB	April 08 2019 22:59:56	gavin / www-data	0644
options-head.php	0.48 KB	November 30 2017 23:11:00	gavin / www-data	0644
options-media.php	6.031 KB	April 08 2019 22:59:56	gavin / www-data	0644
options-permalink.php	18.127 KB	April 08 2019 22:59:56	gavin / www-data	0644
options-reading.php	8.36 KB	April 08 2019 22:59:56	gavin / www-data	0644
options-writing.php	8.369 KB	April 08 2019 22:59:56	gavin / www-data	0644
options.php	11.619 KB	August 17 2018 01:51:36	gavin / www-data	0644
original_submission_contact_details.php	3.431 KB	December 07 2024 16:24:32	gavin / www-data	0664
plugin-editor.php	12.938 KB	April 08 2019 22:59:56	gavin / www-data	0644
plugin-install.php	6.172 KB	April 08 2019 22:59:56	gavin / www-data	0644
plugins.php	23.687 KB	April 08 2019 22:59:56	gavin / www-data	0644
post-new.php	2.617 KB	April 17 2019 01:56:52	gavin / www-data	0644
post.php	9.362 KB	February 07 2019 04:12:51	gavin / www-data	0644
press-this.php	2.327 KB	August 17 2018 01:51:36	gavin / www-data	0644
privacy.php	7.922 KB	March 21 2019 21:17:50	gavin / www-data	0644
profile.php	0.291 KB	November 30 2017 23:11:00	gavin / www-data	0644
revision.php	5.047 KB	April 08 2019 22:59:56	gavin / www-data	0644
setup-config.php	15.191 KB	February 12 2019 16:52:53	gavin / www-data	0644
site-health-info.php	5.5 KB	June 10 2019 07:50:53	gavin / www-data	0644
site-health.php	5.172 KB	June 10 2019 13:48:52	gavin / www-data	0644
submission_contact_details.php	3.406 KB	August 29 2025 15:09:08	gavin / www-data	0664
term.php	2.064 KB	February 19 2018 02:13:32	gavin / www-data	0644
theme-editor.php	14.468 KB	April 08 2019 22:59:56	gavin / www-data	0644
theme-install.php	14.789 KB	April 08 2019 22:59:56	gavin / www-data	0644
themes.php	22.747 KB	April 08 2019 22:59:56	gavin / www-data	0644
tools.php	2.551 KB	April 08 2019 22:59:56	gavin / www-data	0644
update-core.php	31.789 KB	May 17 2019 18:16:54	gavin / www-data	0644
update.php	10.102 KB	August 17 2018 01:51:36	gavin / www-data	0644
upgrade-functions.php	0.336 KB	November 30 2017 23:11:00	gavin / www-data	0644
upgrade.php	5.521 KB	May 17 2019 18:16:54	gavin / www-data	0644
upload.php	13.348 KB	April 08 2019 22:59:56	gavin / www-data	0644
user-edit.php	28.126 KB	April 08 2019 22:59:56	gavin / www-data	0644
user-new.php	21.719 KB	April 15 2019 22:39:50	gavin / www-data	0644
users.php	19.254 KB	April 08 2019 22:59:56	gavin / www-data	0644
widgets.php	19.143 KB	April 08 2019 22:59:56	gavin / www-data	0644