*/ session_start(); // 1. Determine request type $request = $_POST['request']; // 2. Call corresponding function if ($request == "login") { login(); } if ($request == "logout") { logout(); } if ($request == "register") { register(); } if ($request == "add-favorite") { addFavorite(); } if ($request == "delete-favorite") { deleteFavorite(); } function login() { // Establish DB connection $con = new mysqli("localhost", "root", "cjftns119", "DevLog"); // Get more fields $user_email = $_POST['u_email']; $user_pw = $_POST['u_pw']; $encrypted_pw = md5($user_pw); // Check if user exists first: $query = "SELECT * FROM dl_users WHERE u_email='{$user_email}'"; $result = $con->query($query);
/** * Add a new favorite for the action user */ function addFavorite() { global $GEDCOM; if (PGV_USER_ID && !empty($_REQUEST["gid"])) { $gid = strtoupper($_REQUEST["gid"]); $indirec = find_person_record($gid); if ($indirec) { $favorite = array(); $favorite["username"] = PGV_USER_NAME; $favorite["gid"] = $gid; $favorite["type"] = "INDI"; $favorite["file"] = $GEDCOM; $favorite["url"] = ""; $favorite["note"] = ""; $favorite["title"] = ""; addFavorite($favorite); } } }
/** * Add a new favorite for the action user */ function addFavorite() { global $GEDCOM; if (empty($this->uname)) { return; } if (!empty($_REQUEST["gid"])) { $gid = strtoupper($_REQUEST["gid"]); $indirec = find_other_record($gid); if ($indirec) { $favorite = array(); $favorite["username"] = $this->uname; $favorite["gid"] = $gid; $favorite["type"] = "NOTE"; $favorite["file"] = $GEDCOM; $favorite["url"] = ""; $favorite["note"] = ""; $favorite["title"] = ""; addFavorite($favorite); } } }
if ($stmt = $conn->prepare("INSERT INTO `favorites`(`Users_user_id`, `favo_companyid`) VALUES (?,?)")) { $stmt->bind_param("ii", $user, $company); $stmt->execute(); $stmt->store_result(); if ($stmt->affected_rows != 1) { echo ' <div class="alert alert-warning alert-modal" role="alert"> <span class="glyphicon glyphicon-exclamation-sign" aria-hidden="true"></span> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">× </button> Falha ao tentar adicionar empresa aos favoritos.</div>'; return false; } else { echo ' <div class="alert alert-success alert-modal" role="alert"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">× </button> Empresa adicionada aos favoritos. </div>'; return true; } } else { echo ' <div class="alert alert-danger alert-modal" role="alert"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">× </button> Falha na conexão: ' . $conn->error . ' </div>'; } } $check = alreadyFavorite($_GET['user'], $_GET['company']); if ($check === false) { addFavorite($_GET['user'], $_GET['company']); }
header('Content-type: application/json'); chdir('../../common'); require_once 'init.php'; chdir('../database'); require_once 'storeAccount.php'; chdir('../ajax/store'); if (isset($_GET['storeId']) and isset($_GET['productId'])) { $userId = $_SESSION['storesLogin'][$_GET['storeId']]['userId']; if (isset($userId)) { $userFavorites = getFavorites($userId); if (isset($userFavorites[0])) { $found = 'false'; foreach ($userFavorites as $favorite) { if ($favorite . id == $_GET["productId"]) { $found = 'true'; break; } } if ($found == 'false') { addFavorite($userId, $_GET["productId"]); } } else { addFavorite($userId, $_GET["productId"]); } echo json_encode(array("result" => "ok")); } else { echo json_encode(array("result" => "user must be logged in")); } } else { echo json_encode(array("result" => "missing data")); }
function init() { global $Dbwidth, $bwidth, $pbwidth, $pbheight, $bheight, $GEDCOM, $pgv_lang, $CONTACT_EMAIL, $show_famlink, $pgv_changes; $bwidth = $Dbwidth; $pbwidth = $bwidth + 12; $pbheight = $bheight + 14; $show_famlink = $this->view != 'preview'; $this->famid = safe_GET_xref('famid'); $this->family = Family::getInstance($this->famid); if (empty($this->famrec)) { $ct = preg_match("/(\\w+):(.+)/", $this->famid, $match); if ($ct > 0) { $servid = trim($match[1]); $remoteid = trim($match[2]); include_once 'includes/classes/class_serviceclient.php'; $service = ServiceClient::getInstance($servid); if (!is_null($service)) { $newrec = $service->mergeGedcomRecord($remoteid, "0 @" . $this->famid . "@ FAM\n1 RFN " . $this->famid, false); $this->famrec = $newrec; } } //-- if no record was found create a default empty one if (isset($pgv_changes[$this->famid . "_" . $GEDCOM])) { $this->famrec = "0 @" . $this->famid . "@ FAM\n"; $this->family = new Family($this->famrec); } else { if (empty($this->family)) { return false; } } } $this->famrec = $this->family->getGedcomRecord(); $this->display = displayDetailsById($this->famid, 'FAM'); //-- if the user can edit and there are changes then get the new changes if ($this->show_changes && PGV_USER_CAN_EDIT && isset($pgv_changes[$this->famid . "_" . $GEDCOM])) { $newrec = find_updated_record($this->famid); if (empty($newrec)) { $newrec = find_family_record($this->famid); } $this->difffam = new Family($newrec); $this->difffam->setChanged(true); $this->family->diffMerge($this->difffam); //$this->famrec = $newrec; //$this->family = new Family($this->famrec); } $this->parents = array('HUSB' => $this->family->getHusbId(), 'WIFE' => $this->family->getWifeId()); //-- check if we can display both parents if ($this->display == false) { $this->showLivingHusb = showLivingNameById($this->parents['HUSB']); $this->showLivingWife = showLivingNameById($this->parents['WIFE']); } //-- add favorites action if ($this->action == 'addfav' && !empty($_REQUEST['gid']) && PGV_USER_NAME) { $_REQUEST['gid'] = strtoupper($_REQUEST['gid']); $indirec = find_family_record($_REQUEST['gid']); if ($indirec) { $favorite = array('username' => PGV_USER_NAME, 'gid' => $_REQUEST['gid'], 'type' => 'FAM', 'file' => $GEDCOM, 'url' => '', 'note' => '', 'title' => ''); addFavorite($favorite); } } if (PGV_USER_CAN_ACCEPT) { if ($this->action == 'accept') { if (accept_changes($_REQUEST['famid'] . '_' . $GEDCOM)) { $this->show_changes = false; $this->accept_success = true; //-- check if we just deleted the record and redirect to index $famrec = find_family_record($_REQUEST['famid']); if (empty($famrec)) { header("Location: index.php?ctype=gedcom"); exit; } $this->family = new Family($famrec); $this->parents = find_parents($_REQUEST['famid']); } } if ($this->action == 'undo') { $this->family->undoChange(); $this->parents = find_parents($_REQUEST['famid']); } } //-- make sure we have the true id from the record $ct = preg_match("/0 @(.*)@/", $this->famrec, $match); if ($ct > 0) { $this->famid = trim($match[1]); } if ($this->showLivingHusb == false && $this->showLivingWife == false) { print_header($pgv_lang['private'] . " " . $pgv_lang['family_info']); print_privacy_error($CONTACT_EMAIL); print_footer(); exit; } $this->title = $this->family->getFullName(); if (empty($this->parents['HUSB']) || empty($this->parents['WIFE'])) { $this->link_relation = 0; } else { $this->link_relation = 1; } }
print '<a href="' . urlStr($uri) . '">' . $page->getDescription() . '</a>'; } else { print $uri; } ?> <br/> <?php } print '</div>'; } print '</div>'; } } if ($_GET['fav_action'] == 'add') { addFavorite($_GET['uri']); } if ($_GET['fav_action'] == 'del') { delFavorite($_GET['uri']); } $sort_a; foreach (listFavorites() as $uri) { list($m, $s, $a) = explode('/', $uri, 3); $sort_a[$m][$s][$a] = 1; } showFav($sort_a); //add favorites link $local_page = getPage($local_uri); if ($local_page->isVisible()) { $_GET['fav_action'] = 'add'; $_GET['uri'] = $local_uri;
/** * Add a new favorite for the action user */ function addFavorite() { global $GEDCOM; if (!PGV_USER_ID) { return; } if (!empty($_REQUEST["gid"])) { $gid = strtoupper($_REQUEST["gid"]); $mediarec = find_media_record($gid); if ($mediarec) { $favorite = array(); $favorite["username"] = PGV_USER_NAME; $favorite["gid"] = $gid; $favorite["type"] = "OBJE"; $favorite["file"] = $GEDCOM; $favorite["url"] = ""; $favorite["note"] = ""; $favorite["title"] = ""; addFavorite($favorite); } } }
/** * Import users etc. from index files * */ function import() { global $INDEX_DIRECTORY, $TBLPREFIX, $pgv_lang, $GEDCOMS, $GEDCOM, $gBitDb; if (file_exists($INDEX_DIRECTORY . "authenticate.php") == false) { $this->impSuccess = false; return; } else { require $INDEX_DIRECTORY . "authenticate.php"; $countold = count($users); $gBitDb->query("DELETE FROM {$TBLPREFIX}users"); foreach ($users as $username => $user) { if ($user["editaccount"] == "1") { $user["editaccount"] = "Y"; } else { $user["editaccount"] = "N"; } //-- make sure fields are set for v4.0 DB if (!isset($user["firstname"])) { if (isset($user["fullname"])) { $parts = explode(' ', trim($user["fullname"])); $user["lastname"] = array_pop($parts); $user["firstname"] = implode(" ", $parts); } else { $user["firstname"] = ''; $user["lastname"] = ''; } } if (!isset($user["comment"])) { $user["comment"] = ''; } if (!isset($user["comment_exp"])) { $user["comment_exp"] = ''; } if (!isset($user["sync_gedcom"])) { $user["sync_gedcom"] = 'N'; } if (!isset($user["relationship_privacy"])) { $user["relationship_privacy"] = 'N'; } if (!isset($user["max_relation_path"])) { $user["max_relation_path"] = '2'; } if (!isset($user["auto_accept"])) { $user["auto_accept"] = 'N'; } if ($user_id = create_user($user['username'], $user['password'])) { set_user_setting($user_id, 'firstname', $user["firstname"]); set_user_setting($user_id, 'lastname', $user["lastname"]); set_user_setting($user_id, 'email', $user["email"]); set_user_setting($user_id, 'theme', $user["theme"]); set_user_setting($user_id, 'language', $user["language"]); set_user_setting($user_id, 'contactmethod', $user["contactmethod"]); set_user_setting($user_id, 'defaulttab', $user["defaulttab"]); set_user_setting($user_id, 'comment', $user["comment"]); set_user_setting($user_id, 'comment_exp', $user["comment_exp"]); set_user_setting($user_id, 'pwrequested', $user["pwrequested"]); set_user_setting($user_id, 'reg_timestamp', $user["reg_timestamp"]); set_user_setting($user_id, 'reg_hashcode', $user["reg_hashcode"]); set_user_setting($user_id, 'loggedin', $user["loggedin"]); set_user_setting($user_id, 'sessiontime', $user["sessiontime"]); set_user_setting($user_id, 'max_relation_path', $user["max_relation_path"]); set_user_setting($user_id, 'sync_gedcom', $user["sync_gedcom"] ? 'Y' : 'N'); set_user_setting($user_id, 'relationship_privacy', $user["relationship_privacy"] ? 'Y' : 'N'); set_user_setting($user_id, 'auto_accept', $user["auto_accept"] ? 'Y' : 'N'); set_user_setting($user_id, 'canadmin', $user["canadmin"] ? 'Y' : 'N'); set_user_setting($user_id, 'visibleonline', $user["visibleonline"] ? 'Y' : 'N'); set_user_setting($user_id, 'editaccount', $user["editaccount"] ? 'Y' : 'N'); set_user_setting($user_id, 'verified', $user["verified"] ? 'yes' : 'no'); set_user_setting($user_id, 'verified_by_admin', $user["verified_by_admin"] ? 'yes' : 'no'); foreach (array('gedcomid', 'rootid', 'canedit') as $var) { if ($user[$var]) { foreach (unserialize(stripslashes($user[$var])) as $gedcom => $id) { set_user_gedcom_setting($user_id, $gedcom, $var, $id); } } } AddToLog("added user -> {$user['username']} <-"); } } if ($countold == get_user_count()) { $this->impSuccess = true; } else { $this->impSuccess = false; } } if (file_exists($INDEX_DIRECTORY . "messages.dat") == false) { $this->msgSuccess = false; } else { $gBitDb->query("DELETE FROM {$TBLPREFIX}messages"); $messages = array(); $fp = fopen($INDEX_DIRECTORY . "messages.dat", "rb"); $mstring = fread($fp, filesize($INDEX_DIRECTORY . "messages.dat")); fclose($fp); $messages = unserialize($mstring); foreach ($messages as $newid => $message) { $gBitDb->query("INSERT INTO {$TBLPREFIX}messages (m_id, m_from, m_to, m_subject, m_body, m_created) VALUES (?, ? ,? ,? ,? ,?)", array($newid, $message["from"], $message["to"], $message["subject"], $message["body"], $message["created"])); } $this->msgSuccess = true; } if (file_exists($INDEX_DIRECTORY . "favorites.dat") == false) { $this->favSuccess = false; print $pgv_lang["um_nofav"] . "<br /><br />"; } else { $gBitDb->query("DELETE FROM {$TBLPREFIX}favorites"); $favorites = array(); $fp = fopen($INDEX_DIRECTORY . "favorites.dat", "rb"); $mstring = fread($fp, filesize($INDEX_DIRECTORY . "favorites.dat")); fclose($fp); $favorites = unserialize($mstring); foreach ($favorites as $newid => $favorite) { $res = addFavorite($favorite); if (!$res || DB::isError($res)) { $this->errorMsg = "<span class=\"error\">Unable to update <i>Favorites</i> table.</span><br />\n"; return; } } $this->favSuccess = true; } if (file_exists($INDEX_DIRECTORY . "news.dat") == false) { $this->newsSuccess = false; } else { $gBitDb->query("DELETE FROM {$TBLPREFIX}news"); $allnews = array(); $fp = fopen($INDEX_DIRECTORY . "news.dat", "rb"); $mstring = fread($fp, filesize($INDEX_DIRECTORY . "news.dat")); fclose($fp); $allnews = unserialize($mstring); foreach ($allnews as $newid => $news) { $res = addNews($news); if (!$res) { $this->errorMsg = "<span class=\"error\">Unable to update <i>News</i> table.</span><br />\n"; return; } } $this->newsSuccess = true; } if (file_exists($INDEX_DIRECTORY . "blocks.dat") == false) { $this->blockSuccess = false; } else { $gBitDb->query("DELETE FROM {$TBLPREFIX}blocks"); $allblocks = array(); $fp = fopen($INDEX_DIRECTORY . "blocks.dat", "rb"); $mstring = fread($fp, filesize($INDEX_DIRECTORY . "blocks.dat")); fclose($fp); $allblocks = unserialize($mstring); foreach ($allblocks as $bid => $blocks) { $username = $blocks["username"]; $gBitDb->query("INSERT INTO {$TBLPREFIX}blocks (b_id, b_username, b_location, b_order, b_name, b_config) VALUES (?, ? ,? , ?, ?, ?)", array($bid, $blocks["username"], $blocks["location"], $blocks["order"], $blocks["name"], serialize($blocks["config"]))); } $this->blockSuccess = true; } }
<?php session_start(); include "carpoolingDAO.php"; $tripId = $_POST["tripId"]; $userid = $_SESSION["userId"]; addFavorite($userid, $tripId); ?>