function login($dbdesc)
{
$request = $_POST;
$db = getdb("login", $dbdesc);
$sql = "SELECT \n\t\t\t\t\t\tid, name, permission_type \n\t\t\t\t\tFROM \n\t\t\t\t\t\tuser \n\t\t\t\t\tWHERE \n\t\t\t\t\t\tname = ? AND \n\t\t\t\t\t\tpassword = SHA1(?) AND \n\t\t\t\t\t\tactive = true;";
$stmt = $db->prepare($sql);
echo $db->error;
$stmt->bind_param("ss", $request["username"], $request["password"]);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_array();
if ($result->lengths < 1) {
error("Fatal: Invalid user name or password used, or your account is not active now.");
}
$_SESSION["id"] = $row["id"];
$_SESSION["name"] = $row["name"];
$_SESSION["permission_type"] = $row["permission_type"];
/*
Header("HTTP/1.1 303 See Other");
Header("Location: ".$dbdesc["hmap"][$_SESSION["permission_type"]]);
echo "If your browser stayed on this page, click <a href="
.$dbdesc["hmap"][$_SESSION["permission_type"]]
.">here</a> to your home page.<br />";*/
echo json_encode(array("status" => "success", "path" => $dbdesc["hmap"][$_SESSION["permission_type"]]));
}
function getmods_db()
{
$db = getdb();
$dbmods = array();
# opening the DB worked
if ($db) {
# get that db module list
$rv = $db->query("SELECT * FROM modules");
while ($row = $rv->fetchArray()) {
$dbmods[$row['moddir']] = $row;
}
}
return $dbmods;
}
function getnewest($cat)
{
// Currently unused...
$found = 0;
$count = getrows('all');
while ($found == 0) {
$DATA = getdb($count);
if ($DATA['Category'] == $cat) {
$found = 1;
} else {
$count--;
}
}
return $count;
}
echo $adress1;
?>
</div>
<div class="form_row" style="padding-bottom:0px;color:#000;text-align:left">
<?php
echo $adress2;
?>
</div>
<div class="form_row" style="padding-bottom:0px;color:#000;text-align:left">
<?php
echo $postcode . " - " . $city;
?>
</div>
<div class="form_row" style="padding-bottom:0px;color:#000;text-align:left">
<?php
echo getdb("state", $id_state) . " - " . getdb("country", $id_country);
?>
</div>
-->
<div id="map" style="height: 300px;border:1px solid black">
</div>
</div>
<div class="jqmWindow" id="myOverlay">
<ul class="gallery_demo_unstyled">
<li><img src="image/galleria/1.jpg" alt="Flowing Rock" title="Flowing Rock Caption"></li>
<li><img src="image/galleria/2.jpg" alt="Stones" title="Main room"></li>
<li class="active"><img src="image/galleria/3.jpg" alt="Grass Blades" title="Lounge bar"></li>
(at your option) any later version.
TorrentFlux is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with TorrentFlux; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
// ADODB support.
require_once 'db.php';
require_once "settingsfunctions.php";
// Create Connection.
$db = getdb();
loadSettings();
session_start("TorrentFlux");
require_once "config.php";
include "themes/" . $cfg["default_theme"] . "/index.php";
global $cfg;
if (isset($_SESSION['user'])) {
header("location: index.php");
exit;
}
ob_start();
// authentication
switch ($cfg['auth_type']) {
case 3:
/* Basic-Passthru */
/* Basic-Passthru */
function fetch_library($userid)
{
$stored = cache_fetch($userid, 'user');
if ($stored !== false) {
return $stored;
}
global $message;
$codes = array();
$db = getdb();
if (!$db) {
return $codes;
}
$sql = 'select now() as now, m.*, u.editable from ' . DB_TABLE . ' m, ' . DB_TABLE . '_users u where u.codeid = m.codeid and u.userid = \'' . $db->escape_string($userid) . '\' order by m.updated desc limit 100';
$res = $db->query($sql);
if ($res) {
require_once 'mapbbcode.php';
while ($row = $res->fetch_assoc()) {
$item = array();
$item['codeid'] = $row['codeid'];
$item['editid'] = $row['editable'] ? $row['editid'] : '';
$item['created'] = human_date($row['created'], $row['now']);
$item['updated'] = human_date($row['updated'], $row['now']);
$item['title'] = $row['title'];
$item['stats'] = mapbbcode_stats($row['bbcode']);
$codes[] = $item;
}
$res->free();
cache_put($userid, 'user', $codes);
} else {
$message = 'Failed to retrieve user library: ' . $db->error;
}
return $codes;
}
function setLocalContent($state)
{
$db = getdb();
$db_state = $db->escapeString($state);
$db->exec("REPLACE INTO prefs (pref, value) values ('show_local_content_link', '{$db_state}')");
header("HTTP/1.1 200 OK");
header("Content-Type: application/json");
echo "{ \"status\" : \"OK\" }\n";
exit;
}
<?php
$cfg["db_host"] = "localhost";
//es la direccion del servidor
$cfg["db_name"] = "encuest5_test";
//es el nombre de la base de datos
$cfg["db_pass"] = "******";
//es la contra del usuario
$cfg["db_user"] = "******";
//es el usuario
function getdb()
{
global $cfg;
#es para traer las variables
$db = mysql_pconnect($cfg["db_host"], $cfg["db_user"], $cfg["db_pass"]);
$db_sel = mysql_select_db($cfg["db_name"], $db);
//print_r($db_sel); //indica si hay conección
//echo($db_sel);
}
getdb();
function escape_str($str)
{
$db = getdb();
return substr($db->quote($str), 1, -1);
}
function updatemods()
{
# if we don't turn off visible errors, even caught db
# exceptions will print to the browser (as a "200 OK"),
# breaking our ability to signal failure
ini_set('display_errors', '0');
$position = 1;
try {
$db = getdb();
if (!$db) {
throw new Exception($db->lastErrorMsg);
}
# figure out which modules to hide
$hidden = array();
if (isset($_GET['hidden'])) {
foreach (explode(",", $_GET['hidden']) as $moddir) {
$hidden[$moddir] = 1;
}
}
$db->exec("BEGIN");
# go to the DB and set the new order and new hidden state
foreach (explode(",", $_GET['moddirs']) as $moddir) {
$moddir = $db->escapeString($moddir);
if (isset($hidden[$moddir])) {
$is_hidden = 1;
} else {
$is_hidden = 0;
}
$rv = $db->exec("UPDATE modules SET position = '{$position}', hidden = '{$is_hidden}'" . " WHERE moddir = '{$moddir}'");
if (!$rv) {
throw new Exception($db->lastErrorMsg());
}
++$position;
}
} catch (Exception $ex) {
$db->exec("ROLLBACK");
error_log($ex);
header("HTTP/1.1 500 Internal Server Error");
exit;
}
$db->exec("COMMIT");
# restart kiwix so it sees what modules are visible/hidden
kiwix_restart();
header("HTTP/1.1 200 OK");
}
echo $_SESSION["post_adress1"];
?>
</div>
<div class="form_row" style="padding-bottom:0px;color:#000;text-align:left">
<?php
echo $_SESSION["post_adress2"];
?>
</div>
<div class="form_row" style="padding-bottom:0px;color:#000;text-align:left">
<?php
echo $_SESSION["post_postcode"] . " - " . $_SESSION["post_city"];
?>
</div>
<div class="form_row" style="padding-bottom:0px;color:#000;text-align:left">
<?php
echo getdb("state", $_SESSION["post_state"]) . " - " . getdb("country", $_SESSION["post_country"]);
?>
</div>
-->
<div id="map" style="width: 330px; height: 300px;border:1px solid black">
</div>
</div>
<div style="clear: left;"></div>
</div>
<?php
function config($var = '')
{
$values = array('system_mail_from' => '', 'base_url' => '', 'password' => '', 'db_user' => '', 'db_pass' => '', 'db_name' => '', 'db_host' => 'localhost', 'capture_redirects' => 0, 'show_queries' => 1, 'show_debug' => 1, 'send_mail' => 1);
if (array_key_exists($var, $values)) {
return $values[$var];
}
if ($var == '') {
return $values;
} else {
return false;
}
}
function template_config()
{
return array('base_dir' => "", 'template' => 'templates', 'compile' => 'templates_c', 'cache' => 'cache', 'config' => 'configs');
}
ini_set("display_errors", 1);
error_reporting(E_ALL & ~E_DEPRECATED);
date_default_timezone_set("America/Chicago");
require_once "includes/db/base.php";
$db = getdb('mysql:host=' . config('db_host') . ';dbname=' . config('db_name'), config('db_user'), config('db_pass'));
function get_data($codeid)
{
if (!preg_match('/^[a-z]+$/', $codeid)) {
return;
}
$data = cache_fetch($codeid, 'code');
if ($data) {
return $data;
}
$db = getdb();
if (!$db) {
return false;
}
$res = $db->query('select editid, title, bbcode from ' . DB_TABLE . " where codeid = '{$codeid}'");
$assoc = $res->num_rows > 0 ? $res->fetch_assoc() : false;
$res->free();
cache_put($codeid, 'code', $assoc);
cache_purge();
// since we've accessed the db, why not purge the cache?
return $assoc;
}
function escapesql($string = "", $int = 0)
{
global $db;
if (empty($db)) {
$db = getdb();
}
if ($string) {
$string = $db->quote($string);
}
if (!strlen($string) && $int) {
$string = 'NULL';
} else {
if (!strlen($string)) {
$string = '0';
}
}
return $string;
}
function show_local_content_link()
{
$db = getdb();
$rv = $db->querySingle("SELECT 1 FROM prefs WHERE pref = 'show_local_content_link' AND value = '1'");
return $rv;
}
