Proyectos de Subversion LeadersLinked - SPA

Rev

| Ultima modificación | Ver Log |

Rev Autor Línea Nro. Línea
5 stevensc 1
<?php
818 efrain 2
 
819 efrain 3
 
637 stevensc 4
$sandbox = 1;
1 efrain 5
 
5 stevensc 6
if ($sandbox) {
2 efrain 7
    $google_map_api_key = 'AIzaSyDqfGXxql_vcpCJZ_5C8X4ARoPzv_kQepk';
8
    $google_captcha_site_key = '6Lf4W1gUAAAAAE7gdIH5Xv4vJu7VuO6SxArAmdjZ';
9
    $google_captcha_secret_key = '6Lf4W1gUAAAAAIz_VFO0768UyKcG9inVD1TIUatR';
817 efrain 10
 
11
    $database_host = 'localhost';
12
    $database_port = '3306';
13
    $database_dbname = 'db_leaderslinked_dev';
821 efrain 14
    $database_user = 'leaderslinked-db';
15
    $database_password = 'NzY1CxNG-Gkb';
817 efrain 16
 
821 efrain 17
 
2 efrain 18
} else {
19
    $google_map_api_key = 'AIzaSyDqfGXxql_vcpCJZ_5C8X4ARoPzv_kQepk';
5 stevensc 20
 
2 efrain 21
    $google_captcha_site_key = '6Lenx8QZAAAAAAJh-kTLNktsi3mJ47svNmQkoIIv';
22
    $google_captcha_secret_key = '6Lenx8QZAAAAAO44E3iN3jAkVvQ84lRmXvaDWdSY';
817 efrain 23
 
24
 
25
    $database_host = 'localhost';
26
    $database_port = '3306';
27
    $database_dbname = 'db_leaderslinked_dev';
28
    $database_user = 'leaderslinked-db';
29
    $database_password = 'NzY1CxNG-Gkb';
2 efrain 30
}
817 efrain 31
 
32
try {
33
    $hostname = empty($_SERVER['HTTP_HOST']) ?  '' : $_SERVER['HTTP_HOST'];
827 efrain 34
    $sql = 'SELECT * FROM tbl_networks '.
35
        ' WHERE `main_hostname` = ? OR `alternative_hostname` = ? ' .
36
        ' LIMIT 1';
817 efrain 37
 
824 efrain 38
 
39
    echo 'SQL = ' . $sql .  ' hostname = ' . $hostname . '<br>';
820 efrain 40
 
817 efrain 41
    $mysqli = new mysqli($database_host, $database_user, $database_password, $database_dbname, $database_port);
823 efrain 42
    if (!mysqli_connect_errno()) {
817 efrain 43
 
44
        if ($stmt = $mysqli->prepare($sql)) {
45
 
825 efrain 46
            $stmt->bind_param('ss', $hostname, $hostname);
817 efrain 47
            $stmt->execute();
48
 
49
            $result = $stmt->get_result();
50
 
51
 
827 efrain 52
            $row = $result->fetch_row();
53
            echo '<pre>';
54
            print_r($row);
55
            echo '</pre>';
817 efrain 56
 
57
 
58
            //$stmt->bind_result($district);
59
 
60
 
61
            //$stmt->fetch();
62
 
63
            //printf("%s is in district %s\n", $city, $district);
64
 
65
            /* cerrar sentencia */
66
            $stmt->close();
67
        }
68
 
69
        /* cerrar conexión */
70
        $mysqli->close();
71
    }
72
 
73
 
74
 
75
 
76
 
77
} catch(\Exception $e) {
78
 
819 efrain 79
    echo $e->getMessage();
817 efrain 80
 
81
}
82
 
2 efrain 83
?>
5 stevensc 84
<html>
1 efrain 85
 
5 stevensc 86
<head>
87
    <title></title>
88
    <link rel="icon" href="/storage-network/type/favico">
379 stevensc 89
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
5 stevensc 90
    <meta http-equiv="expires" content="0">
91
    <meta http-equiv="expires" content="Tue,&#x20;01&#x20;Jan&#x20;1980&#x20;1&#x3A;00&#x3A;00&#x20;GMT">
92
    <meta http-equiv="pragma" content="no-cache">
93
    <meta http-equiv="Cache-Control" content="no-store">
379 stevensc 94
    <meta http-equiv="Cache-Control" content="max-age=0">
5 stevensc 95
    <meta http-equiv="Cache-Control" content="no-cache">
96
    <meta http-equiv="charset" content="UTF-8">
379 stevensc 97
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
48 stevensc 98
 
5 stevensc 99
    <link rel="stylesheet" type="text/css" href="/css/animate.css">
100
    <link rel="stylesheet" type="text/css" href="/css/bootstrap.min.css">
101
    <link rel="stylesheet" type="text/css" href="/css/line-awesome.css">
102
    <link rel="stylesheet" type="text/css" href="/css/line-awesome-font-awesome.min.css">
103
    <link rel="stylesheet" type="text/css" href="/css/font-awesome.min.css">
48 stevensc 104
 
5 stevensc 105
    <link rel="stylesheet" type="text/css" href="/lib/slick/slick.css">
106
    <link rel="stylesheet" type="text/css" href="/lib/slick/slick-theme.css">
44 stevensc 107
 
48 stevensc 108
    <link rel="stylesheet" type="text/css" href="/vendors/fontawesome-free/css/all.min.css">
521 stevensc 109
    <link rel="stylesheet" type="text/css" href="/vendors/smiley/assets/sprites/emojione.sprites.css">
48 stevensc 110
 
44 stevensc 111
    <link rel="stylesheet" type="text/css" href="/look-and-field/chat.css" />
112
    <link rel="stylesheet" type="text/css" href="/look-and-field/navbar.css" />
113
    <link rel="stylesheet" type="text/css" href="/look-and-field/dashboard.css" />
5 stevensc 114
 
115
    <link rel="stylesheet" type="text/css" href="/vendors/nprogress/nprogress.css">
116
 
117
    <style>
2 efrain 118
        :root {
119
            --bg-color: #fff;
120
            --body-bg-color: #f2f2f2;
121
            --bg-color-secondary: #D9D9D9;
122
            --font-color: #1d315c;
123
            --font-color-hover: #1d315c;
124
            --title-color: #000;
125
            --subtitle-color: #626d7a;
126
            --icons-color: #666666;
127
            --button-bg: #16283c;
128
            --button-bg-hover: #1d315c;
129
            --button-text-color: #fff;
130
            --button-bg-secondary: #16283c;
131
            --button-bg-secondary-hover: #1d315c;
132
            --button-text-color-secondary: #fff;
133
            --button-bg-tertiary: #b3b3b3;
134
            --button-text-color-tertiary: #fff;
135
            --border-primary: #e8e8e8;
136
            --border-trasnparent: #0000;
137
            --chat-received: #fff;
138
            --chat-send: #d8f1e4;
139
            --chat-color: #626d7a;
140
            --light-gray: #bebebe;
141
            --gray: #909090;
142
            --danger: #e20808;
143
            --danger-hover: #a10707;
144
            --online-green: #42b72a;
145
            --border-gray-primary: #b3b3b3;
146
            --white: #ffffff;
147
            --white-backdrop: rgba(255, 255, 255, 0.4);
148
            --border-radius: 10px;
149
            --light-shadow: 0px 0px 11px 0px rgb(0 0 0 / 5%);
150
            --shadow: 0px 4px 14px _2px rgb(0 0 0 / 12%);
151
        }
7 stevensc 152
    </style>
1 efrain 153
 
9 stevensc 154
    <link rel="stylesheet" type="text/css" href="/public/bundles/main.css" />
7 stevensc 155
</head>
156
 
157
<body>
158
 
159
    <div id="app">
8 stevensc 160
 
161
        <div class="process-comm" id="paginator-process-comm">
162
            <div class="spinner">
163
                <div class="bounce1"></div>
164
                <div class="bounce2"></div>
165
                <div class="bounce3"></div>
7 stevensc 166
            </div>
167
        </div>
8 stevensc 168
 
7 stevensc 169
    </div>
170
 
69 stevensc 171
    <script type="text/javascript" src="/vendors/smiley/smiley.js"></script>
172
    <script type="text/javascript" src="/vendors/smiley/js/emojione.min.js"></script>
173
    <script type="text/javascript" src="/vendors/jquery/jquery.min.js"></script>
7 stevensc 174
 
69 stevensc 175
    <script type="text/javascript" src="/vendors/bootstrap/js/bootstrap.bundle.min.js"></script>
7 stevensc 176
 
9 stevensc 177
    <script type="text/javascript" src="/public/bundles/applicationBundle.js"></script>
7 stevensc 178
    <script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?key=<?php echo $google_map_api_key ?>&libraries=places"></script>
179
    <script async="async" defer="defer" src="https://www.google.com/recaptcha/api.js?render=explicit"></script>
180
</body>
181
 
182
</html>