function executeQuery($query) { // call the dbConnect function $conn = dbConnect(); try { // execute query and assign results to a PDOStatement object $stmt = $conn->query($query); do { if ($stmt->columnCount() > 0) { $results = $stmt->fetchAll(PDO::FETCH_ASSOC); //retreive the rows as an associative array } } while ($stmt->nextRowset()); // if multiple queries are executed, repeat the process for each set of results //Uncomment these 4 lines to display $results // echo '<pre style="font-size:large">'; // print_r($results); // echo '</pre>'; // die; //call dbDisconnect() method to close the connection dbDisconnect($conn); return $results; } catch (PDOException $e) { //if execution fails dbDisconnect($conn); die('Query failed: ' . $e->getMessage()); } }
function getListOfBuyClicks($dt) { global $mycatid; $str = ""; $lnk = dbConnect('localhost', 'root', 'lyntik'); $query = "SELECT b.fdate as fdate,b.ip as cip,b.goodid as gid,b.name as sname,b.source as src,b.price as price FROM buylog b WHERE b.date='{$dt}' AND b.mycat_id={$mycatid} ORDER BY b.ip,b.fdate"; $res = exec_query($query); $ip = "0.0.0.0"; $i = 0; $str .= "<div class=\"all_clicks\">"; $str .= "<div class=\"click_row_title\">\n <div class=\"left click_date title\">Дата</div>\n <div class=\"left click_id title\">ID товара</div>\n <div class=\"left click_name title\">Наименование</div>\n <div class=\"left click_id title\">Цена</div>\n <div class=\"left click_name title\">Источник</div>\n " . closeFloat() . "\n </div>"; if (mysql_num_rows($res) == 0) { $str .= "<div>За выбранную дату нажатий не было</div>"; } else { while ($rows = fetch_array($res)) { if ($ip != $rows['cip']) { $ip = $rows['cip']; if ($i != 0) { $str .= "</div>"; } $str .= "<div class=\"ipclicks\">"; $str .= "<div class=\"client_ip\">Клики с адреса:<b>" . $rows['cip'] . "</b></div>"; } $str .= "<div class=\"click_row\">\n <div class=\"left click_date\">" . $rows['fdate'] . "</div>\n <div class=\"left click_id\">" . $rows['gid'] . "</div>\n <div class=\"left click_name\">" . $rows['sname'] . "</div>\n <div class=\"left click_id\">" . $rows['price'] . "</div>\n <div class=\"left click_name\">" . $rows['src'] . "</div>\n " . closeFloat() . "\n </div>"; } $str .= "</div>"; } $str .= "</div></div>"; mysql_free_result($res); dbDisconnect($lnk); return $str; }
function addContact() { $conn = dbConnect(); $name = ''; $email = ''; $mobile = ''; $position = ''; if (isset($_POST['name'])) { $name = $conn->real_escape_string($_POST['name']); } if (isset($_POST['email'])) { $email = $conn->real_escape_string($_POST['email']); } if (isset($_POST['mobile'])) { $mobile = $conn->real_escape_string($_POST['mobile']); } if (isset($_POST['position'])) { $position = $conn->real_escape_string($_POST['position']); } $sql = "INSERT into contactus(name,position,email,mobile) VALUES('{$name}','{$position}','{$email}','{$mobile}')"; $result = $conn->query($sql); dbDisconnect($conn); if ($result) { header("location:../contact.php"); } else { echo "Some error occured..:("; } }
function addTeamMember() { $conn = dbConnect(); $filePath = ''; $name = ''; $category = ''; $title = ''; $long_desc = ''; $short_desc = ''; $fb_link = ''; $l_link = ''; if (isset($_POST['name'])) { $name = $conn->real_escape_string($_POST['name']); } if (isset($_POST['category'])) { $category = $conn->real_escape_string($_POST['category']); } if (isset($_POST['title'])) { $title = $conn->real_escape_string($_POST['title']); } if (isset($_POST['long_desc'])) { $long_desc = $conn->real_escape_string($_POST['long_desc']); } if (isset($_POST['short_desc'])) { $short_desc = $conn->real_escape_string($_POST['short_desc']); } if (isset($_POST['fb_link'])) { $fb_link = $_POST['fb_link']; } if (isset($_POST['l_link'])) { $l_link = $_POST['l_link']; } if (isset($_FILES['file'])) { $target_dir = "../uploads/team/"; $target_file = $target_dir . basename($_FILES["file"]["name"]); if (move_uploaded_file($_FILES["file"]["tmp_name"], $target_file)) { $filePath = 'uploads/team/' . $_FILES["file"]["name"]; } } $description = array('long_desc' => $long_desc, 'short_desc' => $short_desc); $description = json_encode($description); $links = array('fb_link' => $fb_link, 'l_link' => $l_link); $links = json_encode($links); $sql = "INSERT INTO team (name,category,title,description,links,img) VALUES ('" . $name . "','" . $category . "','" . $title . "','" . $description . "','" . $links . "','" . $filePath . "')"; echo $sql; $result = $conn->query($sql); dbDisconnect($conn); if ($result) { header("location:../team.php"); } else { echo "Some error occured..:("; } }
function doLogin($username, $password) { $conn = dbConnect(); $username = $conn->real_escape_string($username); $password = $conn->real_escape_string($password); $sql = "SELECT id,societyName,username,isSuperAdmin FROM society WHERE username='******' AND password='******' LIMIT 1"; $result = $conn->query($sql); if ($result->num_rows > 0) { $_SESSION['user'] = $result->fetch_assoc(); $_SESSION['loggedIn'] = true; return 1; } dbDisconnect($conn); return 0; }
function errorHandler($errno, $errstr, $errfile = NULL, $errline = NULL, $errcontext = NULL) { global $user; if (!ONLINEDEBUG || !checkUserHasPerm('View Debug Information')) { cleanSemaphore(); dbDisconnect(); printHTMLFooter(); exit; } print "Error encountered<br>\n"; switch ($errno) { case E_USER_ERROR: echo "<b>FATAL</b> [{$errno}] {$errstr}<br />\n"; echo " Fatal error in line {$errline} of file {$errfile}"; echo ", PHP " . PHP_VERSION . " (" . PHP_OS . ")<br />\n"; echo "Aborting...<br />\n"; cleanSemaphore(); dbDisconnect(); exit(1); break; case E_USER_WARNING: echo "<b>ERROR</b> [{$errno}] {$errstr}<br />\n"; break; case E_USER_NOTICE: echo "<b>WARNING</b> [{$errno}] {$errstr}<br />\n"; break; default: echo "Unkown error type: [{$errno}] {$errstr}<br />\n"; break; } if (!empty($errfile) && !empty($errline)) { print "Error at {$errline} in {$errfile}<br>\n"; } if (!empty($errcontext)) { print "<pre>\n"; print_r($errcontext); print "</pre>\n"; } print "<br><br><br>\n"; print "<pre>\n"; print getBacktraceString(); print "</pre>\n"; cleanSemaphore(); dbDisconnect(); printHTMLFooter(); exit; }
function errorHandler($errno, $errstr, $errfile = NULL, $errline = NULL, $errcontext = NULL) { global $user; if ($user["adminlevel"] != "developer") { dbDisconnect(); printHTMLFooter(); semUnlock(); exit; } print "Error encountered<br>\n"; switch ($errno) { case E_USER_ERROR: echo "<b>FATAL</b> [{$errno}] {$errstr}<br />\n"; echo " Fatal error in line {$errline} of file {$errfile}"; echo ", PHP " . PHP_VERSION . " (" . PHP_OS . ")<br />\n"; echo "Aborting...<br />\n"; semUnlock(); exit(1); break; case E_USER_WARNING: echo "<b>ERROR</b> [{$errno}] {$errstr}<br />\n"; break; case E_USER_NOTICE: echo "<b>WARNING</b> [{$errno}] {$errstr}<br />\n"; break; default: echo "Unkown error type: [{$errno}] {$errstr}<br />\n"; break; } if (!empty($errfile) && !empty($errline)) { print "Error at {$errline} in {$errfile}<br>\n"; } if (!empty($errcontext)) { print "<pre>\n"; print_r($errcontext); print "</pre>\n"; } print "<br><br><br>\n"; print "<pre>\n"; print getBacktraceString(); print "</pre>\n"; dbDisconnect(); printHTMLFooter(); semUnlock(); exit; }
function addSociety() { $conn = dbConnect(); $society_name = ''; $society_username = ''; $password = ''; if (isset($_POST['society_name'])) { $society_name = $conn->real_escape_string($_POST['society_name']); } if (isset($_POST['society_username'])) { $society_username = $conn->real_escape_string($_POST['society_username']); } if (isset($_POST['password'])) { $password = $conn->real_escape_string($_POST['password']); } $sql = "INSERT into society(societyName,username,password) VALUES('{$society_name}','{$society_username}','{$password}')"; $result = $conn->query($sql); dbDisconnect($conn); if ($result) { header("location:../societies.php"); } else { echo "Some error occured..:("; } }
function executeProcedure($query) { // call the dbConnect function $conn = dbConnect(); try { // execute query and assign results to a PDOStatement object $stmt = $conn->query("EXEC" . $query); $result = $stmt->execute(); //Uncomment these 4 lines to display $results // echo '<pre style="font-size:large">'; // echo 'Result='; // print_r($result); // echo '</pre>'; // die; //call dbDisconnect() method to close the connection dbDisconnect($conn); return $result; } catch (PDOException $e) { //if execution fails dbDisconnect($conn); throw new Exception($e->getMessage(), $e->getCode(), $e); // die ('Query failed: ' . $e->getMessage()); } }
function updateWinner() { $conn = dbConnect(); $event_name = ''; $winner1 = ''; $winner2 = ''; if (isset($_POST['event_name'])) { $event_name = $conn->real_escape_string($_POST['event_name']); } if (isset($_POST['winner1'])) { $winner1 = $conn->real_escape_string($_POST['winner1']); } if (isset($_POST['winner2'])) { $winner2 = $conn->real_escape_string($_POST['winner2']); } $sql = "UPDATE events SET `winner1`='{$winner1}', `winner2`='{$winner2}' WHERE `name`='{$event_name}'"; $result = $conn->query($sql); dbDisconnect($conn); if ($result) { header("location:../winners.php"); } else { echo "Some error occured..:("; } }
function submitCreateImage() { global $submitErr, $user, $viewmode, $HTMLheader, $printedHTMLheader, $mode; if ($mode == 'submitCreateTestProd') { $data = getContinuationVar(); $data["revisionid"] = processInputVar("revisionid", ARG_MULTINUMERIC); # TODO check for valid revisionid } else { $data = processRequestInput(0); $data['length'] = getContinuationVar('length'); } $showrevisions = 0; $subimages = 0; $images = getImages(); $revcount = count($images[$data['imageid']]['imagerevision']); if ($revcount > 1) { $showrevisions = 1; } if ($images[$data['imageid']]['imagemetaid'] != NULL && count($images[$data['imageid']]['subimages'])) { $subimages = 1; foreach ($images[$data['imageid']]['subimages'] as $subimage) { $revcount = count($images[$subimage]['imagerevision']); if ($revcount > 1) { $showrevisions = 1; } } } if ($data["time"] == "now") { $nowArr = getdate(); if ($nowArr["minutes"] == 0) { $subtract = 0; $add = 0; } elseif ($nowArr["minutes"] < 15) { $subtract = $nowArr["minutes"] * 60; $add = 900; } elseif ($nowArr["minutes"] < 30) { $subtract = ($nowArr["minutes"] - 15) * 60; $add = 900; } elseif ($nowArr["minutes"] < 45) { $subtract = ($nowArr["minutes"] - 30) * 60; $add = 900; } elseif ($nowArr["minutes"] < 60) { $subtract = ($nowArr["minutes"] - 45) * 60; $add = 900; } $start = time() - $subtract; $start -= $start % 60; $nowfuture = "now"; } else { $add = 0; $hour = $data["hour"]; if ($data["hour"] == 12) { if ($data["meridian"] == "am") { $hour = 0; } } elseif ($data["meridian"] == "pm") { $hour = $data["hour"] + 12; } $tmp = explode('/', $data["day"]); $start = mktime($hour, $data["minute"], "0", $tmp[0], $tmp[1], $tmp[2]); if ($start < time()) { print $HTMLheader; print "<H2>Create / Update an Image</H2>\n"; print "<font color=\"#ff0000\">The time you requested is in the past."; print " Please select \"Now\" or use a time in the future.</font><br>\n"; $submitErr = 1; createSelectImage(); return; } $nowfuture = "future"; } // FIXME hard code length to 8 hours $data["length"] = 480; $end = $start + $data["length"] * 60 + $add; // get semaphore lock if (!semLock()) { abort(3); } $max = getMaxOverlap($user['id']); if (checkOverlap($start, $end, $max)) { $printedHTMLheader = 1; print $HTMLheader; print "<H2>New Reservation</H2>\n"; if ($max == 0) { print "<font color=\"#ff0000\">The time you requested overlaps with "; print "another reservation you currently have. You are only allowed "; print "to have a single reservation at any given time. Please select "; print "another time to use the application. If you are finished with "; print "an active reservation, click \"Current Reservations\", "; print "then click the \"End\" button of your active reservation."; print "</font><br><br>\n"; } else { print "<font color=\"#ff0000\">The time you requested overlaps with "; print "another reservation you currently have. You are allowed "; print "to have {$max} overlapping reservations at any given time. "; print "Please select another time to use the application. If you are "; print "finished with an active reservation, click \"Current "; print "Reservations\", then click the \"End\" button of your active "; print "reservation.</font><br><br>\n"; } $submitErr = 1; createSelectImage(); return; } // if user is owner of the image and there is a test revision of the image # available, ask user if production or test image desired if ($mode != "submitCreateTestProd" && $showrevisions && $images[$data["imageid"]]["ownerid"] == $user["id"]) { $printedHTMLheader = 1; print $HTMLheader; print "<H2>New Reservation</H2>\n"; if ($subimages) { print "This is a cluster environment. At least one image in the "; print "cluster has more than one revision available. Please select "; print "the revision you desire for each image listed below:<br>\n"; } else { print "There are multiple revisions of this environment available. Please "; print "select the revision you would like to check out:<br>\n"; } print "<FORM action=\"" . BASEURL . SCRIPT . "\" method=post><br>\n"; if (!array_key_exists('subimages', $images[$data['imageid']])) { $images[$data['imageid']]['subimages'] = array(); } array_unshift($images[$data['imageid']]['subimages'], $data['imageid']); foreach ($images[$data['imageid']]['subimages'] as $subimage) { print "{$images[$subimage]['prettyname']}:<br>\n"; print "<table summary=\"lists revisions of the selected environment, one must be selected to continue\">\n"; print " <TR>\n"; print " <TD></TD>\n"; print " <TH>Revision</TH>\n"; print " <TH>Creator</TH>\n"; print " <TH>Created</TH>\n"; print " <TH>Currently in Production</TH>\n"; print " </TR>\n"; foreach ($images[$subimage]['imagerevision'] as $revision) { print " <TR>\n"; if (array_key_exists($subimage, $data['revisionid']) && $data['revisionid'][$subimage] == $revision['id']) { print " <TD align=center><INPUT type=radio name=revisionid[{$subimage}] value={$revision['id']} checked></TD>\n"; } elseif ($revision['production']) { print " <TD align=center><INPUT type=radio name=revisionid[{$subimage}] value={$revision['id']} checked></TD>\n"; } else { print " <TD align=center><INPUT type=radio name=revisionid[{$subimage}] value={$revision['id']}></TD>\n"; } print " <TD align=center>{$revision['revision']}</TD>\n"; print " <TD align=center>{$revision['user']}</TD>\n"; print " <TD align=center>{$revision['prettydate']}</TD>\n"; if ($revision['production']) { print " <TD align=center>Yes</TD>\n"; } else { print " <TD align=center>No</TD>\n"; } print " </TR>\n"; } print "</TABLE>\n"; } addContinuationsEntry('submitCreateImage', array(), SECINDAY, 1, 0); // we add this continuation back // so the currently displayed // page can be reloaded $cont = addContinuationsEntry('submitCreateTestProd', $data); print "<br><INPUT type=hidden name=continuation value=\"{$cont}\">\n"; print "<INPUT type=submit value=Submit>\n"; print "</FORM>\n"; return; } $rc = isAvailable($images, $data["imageid"], $start, $end, $data["os"], 0, 0, 0, 1); if ($rc == -1) { $printedHTMLheader = 1; print $HTMLheader; print "<H2>Create / Update an Image</H2>\n"; print "You have requested an environment that is limited in the number "; print "of concurrent reservations that can be made. No further "; print "reservations for the environment can be made for the time you "; print "have selected. Please select another time to use the "; print "environment.<br>"; } elseif ($rc > 0) { $requestid = addRequest(1, $data['revisionid']); if ($data["time"] == "now") { header("Location: " . BASEURL . SCRIPT . "?mode=viewRequests"); dbDisconnect(); exit; } else { $time = prettyLength($data["length"]); if ($data["minute"] == 0) { $data["minute"] = "00"; } $printedHTMLheader = 1; print $HTMLheader; print "<H2>Create / Update an Image</H2>\n"; print "Your request to use <b>" . $images[$data["imageid"]]["prettyname"]; print "</b> on " . prettyDatetime($start) . " for {$time} has been "; print "accepted.<br><br>\n"; print "When your reservation time has been reached, the "; print "<b>Current Reservations</b> page will give you more "; print "information on connecting to the reserved computer. If you "; print "would like to modify your reservation, you can do that from "; print "the <b>Current Reservations</b> page as well.<br>\n"; } } else { $printedHTMLheader = 1; print $HTMLheader; $cdata = array('imageid' => $data['imageid'], 'length' => $data['length']); $cont = addContinuationsEntry('selectTimeTable', $cdata); print "<H2>Create / Update an Image</H2>\n"; print "The reservation you have requested is not available. You may "; print "<a href=\"" . BASEURL . SCRIPT . "?continuation={$cont}\">"; print "view a timetable</a> of free and reserved times to find "; print "a time that will work for you.<br>\n"; #addLogEntry($nowfuture, unixToDatetime($start), # unixToDatetime($end), 0, $data["imageid"]); } }
function viewRequests() { global $user, $viewmode, $inContinuation, $mode; if ($inContinuation) { $lengthchanged = getContinuationVar('lengthchanged', 0); } else { $lengthchanged = processInputVar('lengthchanged', ARG_NUMERIC, 0); } $incPaneDetails = processInputVar('incdetails', ARG_NUMERIC, 0); $refreqid = processInputVar('reqid', ARG_NUMERIC, 0); $requests = getUserRequests("all"); $images = getImages(); $computers = getComputers(); if ($mode != 'AJviewRequests') { print "<div id=subcontent>\n"; } $refresh = 0; $failed = 0; $connect = 0; $normal = ''; $imaging = ''; $long = ''; if ($count = count($requests)) { $now = time(); for ($i = 0, $noedit = 0, $text = ''; $i < $count; $i++, $noedit = 0, $text = '') { if ($requests[$i]['forcheckout'] == 0 && $requests[$i]['forimaging'] == 0) { continue; } $imageid = $requests[$i]["imageid"]; $text .= " <TR valign=top id=reqrow{$requests[$i]['id']}>\n"; if (requestIsReady($requests[$i])) { $connect = 1; # request is ready, print Connect! and End buttons $cdata = array('requestid' => $requests[$i]['id']); $text .= " <TD>\n"; $text .= " <FORM action=\"" . BASEURL . SCRIPT . "\" method=post>\n"; $cont = addContinuationsEntry('connectRequest', $cdata, SECINDAY); $text .= " <INPUT type=hidden name=continuation value=\"{$cont}\">\n"; $text .= " <INPUT type=submit value=\"Connect!\">\n"; $text .= " </FORM>\n"; $text .= " </TD>\n"; if ($requests[$i]['forimaging']) { # this is the imaging case, need to do sanity check here for if the request # state currstateid or laststateid are "inuse", otherwise disable out the # create image button $noedit = 1; $text .= " <TD>\n"; if ($requests[$i]['currstateid'] == 8 || $requests[$i]['laststateid'] == 8) { # the user has connected successfully so we will allow create image button # to be displayed $text .= " <FORM action=\"" . BASEURL . SCRIPT . "\" method=post>\n"; $cont = addContinuationsEntry('startImage', $cdata); $text .= " <INPUT type=hidden name=continuation value=\"{$cont}\">\n"; $text .= " <INPUT type=submit value=\"Create\nImage\">\n"; $text .= " </FORM>\n"; } $text .= " </TD>\n"; $text .= " <TD>\n"; $text .= " <FORM action=\"" . BASEURL . SCRIPT . "\" method=post>\n"; $cdata = array('requestid' => $requests[$i]['id']); $cont = addContinuationsEntry('confirmDeleteRequest', $cdata, SECINDAY); $text .= " <INPUT type=hidden name=continuation value=\"{$cont}\">\n"; $text .= " <INPUT type=submit value=Cancel>\n"; $text .= " </FORM>\n"; $text .= " </TD>\n"; } else { $text .= " <TD>\n"; $text .= " <FORM action=\"" . BASEURL . SCRIPT . "\" method=post>\n"; $cont = addContinuationsEntry('confirmDeleteRequest', $cdata, SECINDAY); $text .= " <INPUT type=hidden name=continuation value=\"{$cont}\">\n"; $text .= " <INPUT type=submit value=End>\n"; $text .= " </FORM>\n"; $text .= " </TD>\n"; } $startstamp = datetimeToUnix($requests[$i]["start"]); } elseif ($requests[$i]["currstateid"] == 5) { # request has failed $cdata = array('requestid' => $requests[$i]['id']); $text .= " <TD colspan=2 nowrap>\n"; $text .= " <span class=scriptonly>\n"; $text .= " <span class=compstatelink>"; $text .= "<a onClick=\"showResStatusPane({$requests[$i]['id']}); "; $text .= "return false;\" href=\"#\">Reservation failed</a></span>\n"; $text .= " </span>\n"; $text .= " <noscript>\n"; $text .= " <span class=scriptoff>\n"; $text .= " <span class=compstatelink>"; $text .= "Reservation failed</span>\n"; $text .= " </span>\n"; $text .= " </noscript>\n"; $text .= " </TD>\n"; $failed = 1; $noedit = 1; } elseif (datetimeToUnix($requests[$i]["start"]) < $now) { # other cases where the reservation start time has been reached if ($requests[$i]["currstateid"] == 12 && $requests[$i]['laststateid'] == 11 || $requests[$i]["currstateid"] == 11 || $requests[$i]["currstateid"] == 14 && $requests[$i]["laststateid"] == 11) { # request has timed out if ($requests[$i]['forimaging']) { $text .= " <TD colspan=3>\n"; } else { $text .= " <TD colspan=2>\n"; } $text .= " <span class=compstatelink>Reservation has "; $text .= "timed out</span>\n"; $noedit = 1; $text .= " </TD>\n"; } else { # computer is loading, print Pending... and Delete button $remaining = 1; if ($requests[$i]['forimaging']) { $noedit = 1; } if (isComputerLoading($requests[$i], $computers)) { if (datetimeToUnix($requests[$i]["daterequested"]) >= datetimeToUnix($requests[$i]["start"])) { $startload = datetimeToUnix($requests[$i]["daterequested"]); } else { $startload = datetimeToUnix($requests[$i]["start"]); } $imgLoadTime = getImageLoadEstimate($imageid); if ($imgLoadTime == 0) { $imgLoadTime = $images[$imageid]['reloadtime'] * 60; } $tmp = ($imgLoadTime - ($now - $startload)) / 60; $remaining = sprintf("%d", $tmp) + 1; if ($remaining < 1) { $remaining = 1; } } # computer is loading, print Pending... and Delete button if ($requests[$i]['forimaging']) { $text .= " <TD colspan=2>\n"; } else { $text .= " <TD>\n"; } $text .= " <span class=scriptonly>\n"; $text .= " <span class=compstatelink><i>"; $text .= "<a onClick=\"showResStatusPane({$requests[$i]['id']}); "; $text .= "return false;\" href=\"#\">Pending...</a></i></span>"; $text .= " </span>\n"; $text .= " <noscript>\n"; $text .= " <span class=scriptoff>\n"; $text .= " <span class=compstatelink>"; $text .= "<i>Pending...</i></span>\n"; $text .= " </span>\n"; $text .= " </noscript>\n"; $text .= "<br>Est: {$remaining} min remaining\n"; $refresh = 1; $text .= " </TD>\n"; $text .= " <TD>\n"; $text .= " <FORM action=\"" . BASEURL . SCRIPT . "\" method=post>\n"; $cdata = array('requestid' => $requests[$i]['id']); $cont = addContinuationsEntry('confirmDeleteRequest', $cdata, SECINDAY); $text .= " <INPUT type=hidden name=continuation value=\"{$cont}\">\n"; $text .= " <INPUT type=submit value=Delete>\n"; $text .= " </FORM>\n"; $text .= " </TD>\n"; } } else { # reservation is in the future $text .= " <TD></TD>\n"; $text .= " <TD>\n"; $text .= " <FORM action=\"" . BASEURL . SCRIPT . "\" method=post>\n"; $cdata = array('requestid' => $requests[$i]['id']); $cont = addContinuationsEntry('confirmDeleteRequest', $cdata, SECINDAY); $text .= " <INPUT type=hidden name=continuation value=\"{$cont}\">\n"; $text .= " <INPUT type=submit value=Delete>\n"; $text .= " </FORM>\n"; $text .= " </TD>\n"; } if (!$noedit) { # print edit button $text .= " <TD align=right>\n"; $text .= " <FORM action=\"" . BASEURL . SCRIPT . "\" method=post>\n"; $cdata = array('requestid' => $requests[$i]['id']); $cont = addContinuationsEntry('editRequest', $cdata); $text .= " <INPUT type=hidden name=continuation value=\"{$cont}\">\n"; $text .= " <INPUT type=submit value=Edit>\n"; $text .= " </FORM>\n"; $text .= " </TD>\n"; } elseif ($requests[$i]['forimaging'] == 0) { $text .= " <TD></TD>\n"; } # print name of image, add (Testing) if it is the test version of an image $text .= " <TD>" . str_replace("'", "'", $requests[$i]["prettyimage"]); if ($requests[$i]["test"]) { $text .= " (Testing)"; } $text .= "</TD>\n"; # print start time if (datetimeToUnix($requests[$i]["start"]) < datetimeToUnix($requests[$i]["daterequested"])) { $text .= " <TD>" . prettyDatetime($requests[$i]["daterequested"]) . "</TD>\n"; } else { $text .= " <TD>" . prettyDatetime($requests[$i]["start"]) . "</TD>\n"; } # print end time $text .= " <TD>" . prettyDatetime($requests[$i]["end"]) . "</TD>\n"; # print date requested $text .= " <TD>" . prettyDatetime($requests[$i]["daterequested"]) . "</TD>\n"; if ($viewmode == ADMIN_DEVELOPER) { $text .= " <TD align=center>" . $requests[$i]["id"] . "</TD>\n"; $text .= " <TD align=center>" . $requests[$i]["computerid"] . "</TD>\n"; $text .= " <TD>" . $requests[$i]["IPaddress"] . "</TD>\n"; $text .= " <TD align=center>" . $requests[$i]["currstateid"]; $text .= "</TD>\n"; $text .= " <TD align=center>" . $requests[$i]["laststateid"]; $text .= "</TD>\n"; $text .= " <TD align=center>"; $text .= $computers[$requests[$i]["computerid"]]["stateid"] . "</TD>\n"; } $text .= " </TR>\n"; if ($requests[$i]['forimaging']) { $imaging .= $text; } elseif ($requests[$i]['longterm']) { $long .= $text; } else { $normal .= $text; } } } $text = "<H2>Current Reservations</H2>\n"; if (!empty($normal)) { if (!empty($imaging) || !empty($long)) { $text .= "You currently have the following <strong>normal</strong> reservations:<br>\n"; } else { $text .= "You currently have the following normal reservations:<br>\n"; } if ($lengthchanged) { $text .= "<font color=red>NOTE: The maximum allowed reservation "; $text .= "length for one of these reservations was less than the "; $text .= "length you submitted, and the length of that reservation "; $text .= "has been adjusted accordingly.</font>\n"; } $text .= "<table id=reslisttable summary=\"lists reservations you currently have\" cellpadding=5>\n"; $text .= " <TR>\n"; $text .= " <TD colspan=3></TD>\n"; $text .= " <TH>Environment</TH>\n"; $text .= " <TH>Starting</TH>\n"; $text .= " <TH>Ending</TH>\n"; $text .= " <TH>Initially requested</TH>\n"; if ($viewmode == ADMIN_DEVELOPER) { $text .= " <TH>Req ID</TH>\n"; $text .= " <TH>Comp ID</TH>\n"; $text .= " <TH>IP address</TH>\n"; $text .= " <TH>Current State</TH>\n"; $text .= " <TH>Last State</TH>\n"; $text .= " <TH>Computer State</TH>\n"; } $text .= " </TR>\n"; $text .= $normal; $text .= "</table>\n"; } if (!empty($imaging)) { if (!empty($normal)) { $text .= "<hr>\n"; } $text .= "You currently have the following <strong>imaging</strong> reservations:<br>\n"; $text .= "<table id=imgreslisttable summary=\"lists imaging reservations you currently have\" cellpadding=5>\n"; $text .= " <TR>\n"; $text .= " <TD colspan=3></TD>\n"; $text .= " <TH>Environment</TH>\n"; $text .= " <TH>Starting</TH>\n"; $text .= " <TH>Ending</TH>\n"; $text .= " <TH>Initially requested</TH>\n"; $computers = getComputers(); if ($viewmode == ADMIN_DEVELOPER) { $text .= " <TH>Req ID</TH>\n"; $text .= " <TH>Comp ID</TH>\n"; $text .= " <TH>IP address</TH>\n"; $text .= " <TH>Current State</TH>\n"; $text .= " <TH>Last State</TH>\n"; $text .= " <TH>Computer State</TH>\n"; } $text .= " </TR>\n"; $text .= $imaging; $text .= "</table>\n"; } if (!empty($long)) { if (!empty($normal) || !empty($imaging)) { $text .= "<hr>\n"; } $text .= "You currently have the following <strong>long term</strong> reservations:<br>\n"; $text .= "<table id=\"longreslisttable\" summary=\"lists long term reservations you currently have\" cellpadding=5>\n"; $text .= " <TR>\n"; $text .= " <TD colspan=3></TD>\n"; $text .= " <TH>Environment</TH>\n"; $text .= " <TH>Starting</TH>\n"; $text .= " <TH>Ending</TH>\n"; $text .= " <TH>Initially requested</TH>\n"; $computers = getComputers(); if ($viewmode == ADMIN_DEVELOPER) { $text .= " <TH>Req ID</TH>\n"; $text .= " <TH>Comp ID</TH>\n"; $text .= " <TH>IP address</TH>\n"; $text .= " <TH>Current State</TH>\n"; $text .= " <TH>Last State</TH>\n"; $text .= " <TH>Computer State</TH>\n"; } $text .= " </TR>\n"; $text .= $long; $text .= "</table>\n"; } # connect div if ($connect) { $text .= "<br><br>Click the <strong>"; $text .= "Connect!</strong> button to get further "; $text .= "information about connecting to the reserved system. You must "; $text .= "click the button from a web browser running on the same computer "; $text .= "from which you will be connecting to the remote computer; "; $text .= "otherwise, you may be denied access to the machine.\n"; } if ($refresh) { $text .= "<br><br>This page will automatically update "; $text .= "every 20 seconds until the <font color=red><i>Pending...</i>"; #$text .= "</font> reservation is ready.<br></div>\n"; $text .= "</font> reservation is ready.\n"; $cont = addContinuationsEntry('AJviewRequests', $cdata, SECINDAY); $text .= "<INPUT type=hidden id=resRefreshCont value=\"{$cont}\">\n"; } if ($failed) { $text .= "<br><br>An error has occurred that has kept one of your reservations "; $text .= "from being processed. We apologize for any inconvenience "; $text .= "this may have caused.\n"; if (!$refresh) { $cont = addContinuationsEntry('AJviewRequests', $cdata, SECINDAY); $text .= "<INPUT type=hidden id=resRefreshCont value=\"{$cont}\">\n"; } } if (empty($normal) && empty($imaging) && empty($long)) { $text .= "You have no current reservations.<br>\n"; } $text .= "</div>\n"; if ($mode != 'AJviewRequests') { if ($refresh || $failed) { $text .= "<div dojoType=FloatingPane\n"; $text .= " id=resStatusPane\n"; $text .= " constrainToContainer=false\n"; $text .= " hasShadow=true\n"; $text .= " resizable=true\n"; $text .= " windowState=minimized\n"; $text .= " displayMinimizeAction=true\n"; $text .= " style=\"width: 350px; height: 280px; position: absolute; left: 130; top: 0px;\"\n"; $text .= ">\n"; $text .= "<div id=resStatusText></div>\n"; $text .= "<input type=hidden id=detailreqid value=0>\n"; $text .= "</div>\n"; $text .= "<script type=\"text/javascript\">\n"; $text .= "dojo.addOnLoad(showScriptOnly);\n"; $text .= "dojo.byId('resStatusPane').title = \"Detailed Reservation Status\";\n"; $text .= "</script>\n"; } print $text; } else { $text = str_replace("\n", ' ', $text); if ($refresh) { print "refresh_timer = setTimeout(resRefresh, 20000);\n"; } print setAttribute('subcontent', 'innerHTML', $text); print "AJdojoCreate('subcontent');"; if ($incPaneDetails) { $text = detailStatusHTML($refreqid); print setAttribute('resStatusText', 'innerHTML', $text); } dbDisconnect(); exit; } }
function sendHeaders() { global $mode, $user, $authed, $oldmode, $viewmode, $actionFunction, $skin; global $shibauthed; $setwrapreferer = processInputVar('am', ARG_NUMERIC, 0); if (!$authed && $mode == "auth") { header("Location: " . BASEURL . SCRIPT . "?mode=selectauth"); dbDisconnect(); exit; } switch ($mode) { case 'logout': if ($shibauthed) { $shibdata = getShibauthData($shibauthed); if (array_key_exists('Shib-logouturl', $shibdata) && !empty($shibdata['Shib-logouturl'])) { dbDisconnect(); header("Location: {$shibdata['Shib-logouturl']}"); exit; } } case 'shiblogout': setcookie("ITECSAUTH", "", time() - 10, "/", COOKIEDOMAIN); setcookie("VCLAUTH", "", time() - 10, "/", COOKIEDOMAIN); if ($shibauthed) { $msg = ''; $shibdata = getShibauthData($shibauthed); # find and clear shib cookies /*foreach(array_keys($_COOKIE) as $key) { if(preg_match('/^_shibsession[_0-9a-fA-F]+$/', $key)) setcookie($key, "", time() - 10, "/", $_SERVER['SERVER_NAME']); elseif(preg_match('/^_shibstate_/', $key)) setcookie($key, "", time() - 10, "/", $_SERVER['SERVER_NAME']); }*/ doQuery("DELETE FROM shibauth WHERE id = {$shibauthed}", 101); stopSession(); dbDisconnect(); if (array_key_exists('Shib-logouturl', $shibdata) && !empty($shibdata['Shib-logouturl'])) { print "<html>\n"; print " <head>\n"; print " <style type=\"text/css\">\n"; print " .red {\n"; print " color: red;\n"; print " }\n"; print " body{\n"; print " margin:0px; color: red;\n"; print " }\n"; print " </style>\n"; print " </head>\n"; print " <body>\n"; print " <span class=red>Done.</span> <a target=\"_top\" href=\"" . BASEURL . "/\">Return to VCL</a>\n"; print " </body>\n"; print "</html>\n"; } else { print "<html>\n"; print "<head>\n"; print "<META HTTP-EQUIV=REFRESH CONTENT=\"5;url=" . BASEURL . "\">\n"; print "<style type=\"text/css\">\n"; print " .hidden {\n"; print " display: none;\n"; print " }\n"; print "</style>\n"; print "</head>\n"; print "<body>\n"; print "Logging out of VCL..."; print "<iframe src=\"http://{$_SERVER['SERVER_NAME']}/Shibboleth.sso/Logout\" class=hidden>\n"; print "</iframe>\n"; if (array_key_exists('Shib-Identity-Provider', $shibdata) && !empty($shibdata['Shib-Identity-Provider'])) { $tmp = explode('/', $shibdata['Shib-Identity-Provider']); $idp = "{$tmp[0]}//{$tmp[2]}"; print "<iframe src=\"{$idp}/idp/logout.jsp\" class=hidden>\n"; print "</iframe>\n"; } print "</body>\n"; print "</html>\n"; } exit; } header("Location: " . HOMEURL); stopSession(); dbDisconnect(); exit; } if ($mode == "submitviewmode") { $expire = time() + 31536000; //expire in 1 year $newviewmode = processInputVar("viewmode", ARG_NUMERIC); if (!empty($newviewmode) && $newviewmode <= $user['adminlevelid']) { setcookie("VCLVIEWMODE", $newviewmode, $expire, "/", COOKIEDOMAIN); } stopSession(); header("Location: " . BASEURL . SCRIPT); dbDisconnect(); exit; } if ($mode == "statgraphday" || $mode == "statgraphdayconcuruser" || $mode == "statgraphdayconcurblade" || $mode == "statgraphhour") { $actionFunction(); dbDisconnect(); exit; } if ($mode == "viewNodes") { $openNodes = processInputVar("openNodes", ARG_STRING); $activeNode = processInputVar("activeNode", ARG_NUMERIC); if (!empty($openNodes)) { $expire = time() + 31536000; //expire in 1 year setcookie("VCLNODES", $openNodes, $expire, "/", COOKIEDOMAIN); } if (!empty($activeNode)) { $expire = time() + 31536000; //expire in 1 year setcookie("VCLACTIVENODE", $activeNode, $expire, "/", COOKIEDOMAIN); } return; } if ($mode == "submitDeleteNode") { $activeNode = processInputVar("activeNode", ARG_NUMERIC); $nodeinfo = getNodeInfo($activeNode); $expire = time() + 31536000; //expire in 1 year setcookie("VCLACTIVENODE", $nodeinfo["parent"], $expire, "/", COOKIEDOMAIN); } if ($mode == "sendRDPfile") { header("Cache-Control: max-age=5, must-revalidate"); header('Pragma: cache'); } else { header("Cache-Control: no-cache, must-revalidate"); } header("Expires: Sat, 1 Jan 2000 00:00:00 GMT"); }
<td><?php echo $row['username']; ?> </td> <td><?php echo $row['password']; ?> </td> <td><a class='deleteSociety' href="scripts/delete.php?id=<?php echo $row['id']; ?> &type=society">Delete</a></td> </tr> <?php } dbDisconnect($conn); ?> </tbody> </table> </div> <!-- /.table-responsive --> </div> <!-- /.panel-body --> </div> <button class="btn btn-primary btn-lg" data-toggle="modal" data-target="#myModal"> Add Society </button> <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content">
public function create() { if (isset($_SESSION['TournamentId'])) { if (isset($_POST) && sizeof($_POST) == 9) { foreach ($_POST as $key => $value) { echo $key, " => ", $value, "<br />"; switch ($key) { case "name": $this->name = htmlentities($_POST['name'], ENT_QUOTES); break; case "round": $this->round = htmlentities($_POST['round'], ENT_QUOTES); break; case "teamcount": $this->teamcount = htmlentities($_POST['teamcount'], ENT_QUOTES); break; case "link": $this->link = htmlentities($_POST['link'], ENT_QUOTES); break; case "logopath": $this->logopath = htmlentities($_POST['logopath'], ENT_QUOTES); break; case "begin": if (!empty($_POST['begin'])) { $this->begin = htmlentities($_POST['begin'], ENT_QUOTES); } else { $this->begin = date('Y-m-d H:i:s', time()); } break; case "end": if (isset($_POST['end']) && !empty($_POST['end'])) { $this->end = htmlentities($_POST['end'], ENT_QUOTES); } else { $this->withoutend = true; } break; case "bestOfOption": $this->bestOfOption = htmlentities($_POST['bestOfOption'], ENT_QUOTES); break; case "newGroup": break; default: $this->start = false; } } } else { $this->start = false; } if ($this->start) { $this->dbConnect(); $table = "ftm_group"; if ($this->withoutend) { $values = array($this->name, $this->teamcount, $this->link, $this->logopath, $this->begin, $this->bestOfOption); $rows = "name,teamCount,link,logoPath,begin,bestOfOption"; } else { $values = array($this->name, $this->teamcount, $this->link, $this->logopath, $this->begin, $this->end, $this->bestOfOption); $rows = "name,teamCount,link,logoPath,begin,end,bestOfOption"; } if ($this->db->insert($table, $values, $rows)) { // Turnierdaten des neuen Turniers ermitteln (ID) $rows = "*"; $table = "ftm.ftm_group"; $where = "ftm_group.begin='" . $this->begin . "'"; $order = "_ID DESC LIMIT 0,1"; $group = ""; $joins = ""; if ($this->db->select($table, $rows, $where, $order)) { $this_result = $this->db->getResult(); $this->db->clear_results(); $this->id = $this_result['_Id']; // Turnierdaten des neuen Turniers ermitteln (ID) $table = "ftm_tournamentgroups"; $values = array($_SESSION['TournamentId'], $this->id, $this->round); $rows = "tournamentId,groupId,round"; if ($this->db->insert($table, $values, $rows)) { return true; } else { echo "Insert ftm_tournamentgroups Error"; return false; } } else { echo "Select Group Error"; return false; } } else { echo "Insert Group Error"; return false; } dbDisconnect(); } else { echo "No Post"; return false; } } }
function get_prods_urls() { global $sitemapstr, $numlinks, $mycatid, $isFinish; $lnk = dbConnect('', '', ''); $query = "SELECT id as pid,translit as tr FROM ln_product_my WHERE mycat_id={$mycatid}"; $res = exec_query($query); $def = "http://ychebniki.ru/products/getdetails/item/"; while ($rows = fetch_array($res)) { $isFinish = false; $url = $def . $rows['tr']; $sitemapstr .= get_sitemap_url($url, 0.9); $numlinks++; if ($numlinks > 39999) { finish_file(); } } dbDisconnect($lnk); }
function AJsubmitAddResourcePriv() { global $user; $node = processInputVar("activeNode", ARG_NUMERIC); if (!checkUserHasPriv("resourceGrant", $user["id"], $node)) { $text = "You do not have rights to add new resource groups at this node."; print "addUserGroupPaneHide(); "; print "alert('{$text}');"; dbDisconnect(); exit; } $newgroupid = processInputVar("newgroupid", ARG_NUMERIC); # FIXME validate newgroupid $perms = explode(':', processInputVar('perms', ARG_STRING)); $privtypes = array("block", "cascade", "available", "administer", "manageGroup"); $newgroupprivs = array(); foreach ($privtypes as $type) { if (in_array($type, $perms)) { array_push($newgroupprivs, $type); } } if (empty($newgroupprivs) || count($newgroupprivs) == 1 && in_array("cascade", $newgroupprivs)) { $text = "<font color=red>No resource group privileges were specified</font>"; print setAttribute('addResourceGroupPrivStatus', 'innerHTML', $text); dbDisconnect(); exit; } updateResourcePrivs($newgroupid, $node, $newgroupprivs, array()); clearPrivCache(); print "addResourceGroupPaneHide(); "; print "refreshPerms(); "; dbDisconnect(); exit; }
function editEvent() { $conn = dbConnect(); $societyId = -1; $id = -1; $display = 0; $eventTime = ''; $filePath = ''; $event_name = ''; $category = ''; $about = ''; $desc = ''; $prize1 = ''; $prize2 = ''; $contact1 = ''; $contact2 = ''; $link = ''; $rules = array(); if (isset($_POST['event_name'])) { $event_name = $conn->real_escape_string($_POST['event_name']); } if (isset($_POST['category'])) { $category = $conn->real_escape_string($_POST['category']); } if (isset($_POST['about'])) { $about = $_POST['about']; } if (isset($_POST['description'])) { $desc = $_POST['description']; } if (isset($_POST['prize1'])) { $prize1 = $_POST['prize1']; } if (isset($_POST['prize2'])) { $prize2 = $_POST['prize2']; } if (isset($_POST['eventTime'])) { $eventTime = $_POST['eventTime']; } if (isset($_POST['contact1'])) { $contact1 = $_POST['contact1']; } if (isset($_POST['contact2'])) { $contact2 = $_POST['contact2']; } if (isset($_POST['link'])) { $link = $_POST['link']; } if (isset($_POST['rules'])) { $rules = $_POST['rules']; } if (isset($_POST['id'])) { $id = $_POST['id']; } if (isset($_POST['societyId'])) { $societyId = $_POST['societyId']; } if (isset($_POST['filePath']) && $_POST['filePath'] != '') { $filePath = $_POST['filePath']; } if (isset($_POST['display'])) { $display = $_POST['display']; } if (isset($_FILES['file']) && $_FILES['file']['error'] != 4) { $fileNameArray = explode('.', $_FILES["file"]['name']); $_FILES['file']['name'] = $fileNameArray[0] . '' . trim(str_replace(' ', '', $event_name)) . '.' . $fileNameArray[1]; $target_dir = "../uploads/events/"; $target_file = $target_dir . basename($_FILES["file"]["name"]); if (move_uploaded_file($_FILES["file"]["tmp_name"], $target_file)) { $filePath = 'uploads/events/' . $_FILES["file"]["name"]; } } $eventData = array('about' => $about, 'prize1' => $prize1, 'prize2' => $prize2, 'contact1' => $contact1, 'contact2' => $contact2, 'link' => $link, 'rules' => $rules, 'filePath' => $filePath, 'description' => $desc); $eventData = json_encode($eventData); $sql = "UPDATE events SET societyId=" . $societyId . ",eventData='" . $eventData . "',category='" . $category . "',name='" . $event_name . "',display=" . $display . ",eventTime='" . $eventTime . "' WHERE id=" . $id . ""; $result = $conn->query($sql); dbDisconnect($conn); if ($result) { header("location:../events.php"); } else { echo "Some error occured..:("; } }
function writeToLog($name, $id, $ip) { $date = date("d-m-Y", time() + 32400); $datet = date("d-m-Y H:i:s", time() + 32400); $filename = $date . ".txt"; $f = fopen($filename, "a+"); fwrite($f, $ip . " " . $datet . " " . $id . " " . $name . "\n"); fclose($f); $lnk = dbConnect('localhost', 'root', 'lyntik'); $query = "SELECT mycat_id as mycat FROM ln_product_my WHERE id={$id}"; $res = exec_query($query); $mycat = 0; $rows = null; if (mysql_num_rows($res) != 0) { $rows = fetch_array($res); $mycat = $rows['mycat']; } $query = "INSERT INTO buylog (date,fdate,ip,goodid,name,mycat_id) VALUES ('{$date}','{$datet}','{$ip}',{$id},'{$name}',{$mycat})"; $res = exec_query($query); dbDisconnect($lnk); return true; }
function get_prods_urls() { global $sitemapstr, $mycatid, $limit_cnt; echo "Выгружаем товары<br/>"; $sitemapstr .= "<offers>"; $lnk = dbConnect('', '', ''); $query = "SELECT id as pid,price as price,categoryId as cat,picture as pict,producer as vendor,name as pname,description as description,translit as trans FROM ln_product_my WHERE mycat_id={$mycatid}"; $res = exec_query($query); $schet = 0; while ($rows = fetch_array($res)) { $sitemapstr .= get_sitemap_offer_url($rows['pid'], $rows['price'], $rows['cat'], $rows['pict'], $rows['vendor'], $rows['pname'], substr($rows['description'], 0, 255), $rows['trans']); $schet++; if ($limit_cnt != 0 && $schet == $limit_cnt) { break; } } $sitemapstr .= "</offers>"; dbDisconnect($lnk); }
/** * Enter description here... * * @param unknown_type $dir * @param unknown_type $module */ function deleteSql($dir, $module) { $settings = getMagentoDatabaseSettings($dir); $connection = dbConnect($settings); $module = preg_replace('/\\/$/', '', $module); $module = strtolower(substr(strrchr($module, '/'), 1)); $tblPrefix = getTablePrefix($dir); $sql = "DELETE FROM " . $tblPrefix . "core_resource WHERE code = '" . $module . "_setup'"; $delete = mysql_query($sql); $sql = "DROP TABLE " . $tblPrefix . $module; $drop = mysql_query($sql); dbDisconnect($connection); if ($delete and $drop) { return true; } return false; }
{ $title_seo = translit_fromRussian($title_seo); $title_seo = preg_replace("/[^0-9a-zA-Z_]/", '-', $title_seo); $title_seo = preg_replace("/-[-]*-/", '-', $title_seo); return $title_seo; } function translit_fromRussian($s) { $TRAN = array('а' => 'a', 'б' => 'b', 'в' => 'v', 'г' => 'g', 'д' => 'd', 'е' => 'e', 'ё' => 'jo', 'ж' => 'zh', 'з' => 'z', 'и' => 'i', 'й' => 'jj', 'к' => 'k', 'л' => 'l', 'м' => 'm', 'н' => 'n', 'о' => 'o', 'п' => 'p', 'р' => 'r', 'с' => 's', 'т' => 't', 'у' => 'u', 'ф' => 'f', 'х' => 'kh', 'ц' => 'c', 'ч' => 'ch', 'ш' => 'sh', 'щ' => 'shh', 'ъ' => '', 'ы' => 'y', 'ь' => "", 'э' => 'eh', 'ю' => 'yu', 'я' => 'ya', 'А' => 'A', 'Б' => 'B', 'В' => 'V', 'Г' => 'G', 'Д' => 'D', 'Е' => 'E', 'Ё' => 'Jo', 'Ж' => 'Zh', 'З' => 'Z', 'И' => 'I', 'Й' => 'Jj', 'К' => 'K', 'Л' => 'L', 'М' => 'M', 'Н' => 'N', 'О' => 'O', 'П' => 'P', 'Р' => 'R', 'С' => 'S', 'Т' => 'T', 'У' => 'U', 'Ф' => 'F', 'Х' => 'Kh', 'Ц' => 'C', 'Ч' => 'Ch', 'Ш' => 'Sh', 'Щ' => 'Shh', 'Ъ' => '', 'Ы' => 'Y', 'Ь' => "", 'Э' => 'Eh', 'Ю' => 'Yu', 'Я' => 'Ya'); foreach ($TRAN as $ru => $en) { $s = str_replace($ru, $en, $s); } return $s; } function translit_checkExistInProd($str, $num) { $find = $str; $query = "SELECT * FROM ln_product_my WHERE translit='" . $find . "'"; $res = exec_query($query); if (mysql_num_rows($res) > 0) { $num++; $find .= $num; $find = translit_checkExistInProd($find, $num); } return $find; } set_time_limit(0); $lnk = dbConnect('', '', ''); translit_translitProds(); dbDisconnect($lnk);
require_once ".ht-inc/states.php"; require_once '.ht-inc/errors.php'; require_once '.ht-inc/utils.php'; dbConnect(); initGlobals(); $modes = array_keys($actions['mode']); $args = array_keys($actions['args']); $hasArg = 0; if (in_array($mode, $modes)) { $actionFunction = $actions['mode'][$mode]; if (in_array($mode, $args)) { $hasArg = 1; $arg = $actions['args'][$mode]; } } else { $actionFunction = "main"; } checkAccess(); sendHeaders(); printHTMLHeader(); if ($viewmode == ADMIN_DEVELOPER) { set_error_handler("errorHandler"); } if ($hasArg) { $actionFunction($arg); } else { $actionFunction(); } printHTMLFooter(); dbDisconnect(); semUnlock();
function changeLocale() { global $locale; $newlocale = getContinuationVar('locale'); $oldmode = getContinuationVar('oldmode'); $authtype = getContinuationVar('authtype', ''); $locale = $newlocale; setcookie("VCLLOCALE", $locale, time() + 86400 * 31, "/", COOKIEDOMAIN); $extra = ''; if ($oldmode == 'selectauth' && !empty($authtype)) { $extra = "&authtype={$authtype}"; } header("Location: " . BASEURL . SCRIPT . "?mode={$oldmode}{$extra}"); dbDisconnect(); exit; }
function checkExpiredDemoUser($userid, $groups = 0) { global $mode, $skin, $noHTMLwrappers; if ($groups == 0) { $groups = getUsersGroups($userid, 1); } if (count($groups) != 1) { return; } $tmp = array_values($groups); if ($tmp[0] != 'demo') { return; } $query = "SELECT start " . "FROM log " . "WHERE userid = {$userid} " . "AND finalend < NOW() " . "ORDER BY start " . "LIMIT 3"; $qh = doQuery($query, 101); $expire = time() - SECINDAY * 3; $rows = mysql_num_rows($qh); if ($row = mysql_fetch_assoc($qh)) { if ($rows >= 3 || datetimeToUnix($row['start']) < $expire) { if (in_array($mode, $noHTMLwrappers)) { # do a redirect and handle removal on next page load so user can # be notified - doesn't always work, but handles a few extra # cases header("Location: " . BASEURL . SCRIPT); } else { $nodemoid = getUserGroupID('nodemo', getAffiliationID('ITECS')); $query = "DELETE FROM usergroupmembers " . "WHERE userid = {$userid}"; # because updateGroups doesn't # delete from custom groups doQuery($query, 101); updateGroups(array($nodemoid), $userid); checkUpdateServerRequestGroups($groupid); if (empty($skin)) { $skin = 'default'; require_once "themes/{$skin}/page.php"; } $mode = 'expiredemouser'; printHTMLHeader(); print "<h2>Account Expired</h2>\n"; print "The account you are using is a demo account that has now expired. "; print "You cannot make any more reservations. Please contact <a href=\""; print "mailto:" . HELPEMAIL . "\">" . HELPEMAIL . "</a> if you need "; print "further access to VCL.<br>\n"; } cleanSemaphore(); # probably not needed but ensures we do not leave stale entries printHTMLFooter(); dbDisconnect(); exit; } } }
function sendEmail($mail, $id) { $lnk = dbConnect('', '', ''); $query = "SELECT COUNT(orr.id) as cnt\n FROM order_res orr WHERE orr.order_id={$id}"; $res = exec_query($query); $rows = fetch_array($res); $cnt = $rows['cnt']; $query = "SELECT number as num,description as descr FROM orders WHERE id={$id}"; $res = exec_query($query); $rows = fetch_array($res); $desc = $rows['descr']; $num = $rows['num']; $msg = $cnt == 0 ? "К сожалению, товаров, соответствующих вашему запросу не найдено, либо их нет в наличии. Попробуйте сделать заявку попозже. Приносим извинения за неудобства. Вы можете вступить в группу Вконтакте по поиску учебников <a href=\"http://vk.com/y4ebniki\">http://vk.com/y4ebniki</a><br>" : "Чтобы просмотреть результаты поиска, перейдите по ссылке <a href=\"http://ychebniki.ru/zakaznik?stext={$num}\">http://ychebniki.ru/zakaznik?stext={$num}</a> или введите номер Вашей заявки в разделе 'Узнать результат' на странице <a href=\"http://ychebniki.ru/zakaznik.php\">заказника</a>. Приглашаем Вас так же вступить в группу Вконтакте по поиску учебников <a href=\"http://vk.com/y4ebniki\">http://vk.com/y4ebniki</a><br>"; $mesg = "Здравствуйте. Вы оставляли заявку на поиск товара в интернет-магазине ychebniki.ru <br>"; $mesg .= "Если вы этого не делали просто проигнорируйте это письмо и удалите его.<br>"; $mesg .= "Номер Вашей заявки: {$num}<br>"; $mesg .= "Описание заявки: " . $desc . "<br>"; $mesg .= $msg; $mesg .= "Данное письмо сформировано автоматически. По всем вопросам обращаться : info@ychebniki.ru<br>"; $subj = "Поиск товара в интернет-магазине ychebniki.ru<br>"; $mesg .= "С уважением, администрация www.ychebniki.ru<br>"; $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=win-1251\r\n"; $headers .= "From: ychebniki.ru support <*****@*****.**>"; mail($mail, $subj, $mesg, $headers); mail("*****@*****.**", $subj, $mesg, $headers); mysql_free_result($res); dbDisconnect($lnk); return 1; }