function ex($pytanie)
{
con();
$result = mysql_query($pytanie);
if ($result > 0) {
return 1;
} else {
return 0;
}
}
/**
*
*/
function regMatch($pattern, $str)
{
con(is_string($pattern), "regMatch()", "pattern must be string: ", $pattern);
con(is_string($str), "regMatch()", "str must be string: ", $str);
$retval = preg_match($pattern, $str, $matches);
con($retval !== false, "regMatch()", "preg_match() returned false: ", $str);
$r1 = $retval === 1;
$r2 = $retval !== 0;
$r3 = count($matches) !== 0;
con($r1 === $r2, "regMatch()", "invariance test 1 failed: ", $r1, $r2);
con($r1 === $r3, "regMatch()", "invariance test 2 failed: ", $r1, $r3);
return $r1;
}
function _tpl_act_changes(&$event, $param)
{
global $TEXT;
global $PRE;
global $SUF;
if ('changes' != $event->data) {
return;
}
html_edit($TEXT);
echo '<br id="scroll__here" />';
html_diff(con($PRE, $TEXT, $SUF));
$event->preventDefault();
return;
}
function geraJsonCidades($estadosId)
{
$query = con()->query("Select * from cidades where estado_id = {$estadosId} order by cidade_nome");
$cidades = $query->fetchAll();
$stringJson = "{\"Cidades\":[";
for ($i = 0; $i < count($cidades); $i++) {
$stringJson .= "{\"id\":\"" . $cidades[$i]["cidade_id"] . "\",\"nome\":\"" . utf8_encode($cidades[$i]["cidade_nome"]) . "\"}";
if ($i < count($cidades) - 1) {
$stringJson .= ",";
}
}
$stringJson .= "]}";
return $stringJson;
}
/**
* Handle 'save'
*
* Checks for spam and conflicts and saves the page.
* Does a redirect to show the page afterwards or
* returns a new action.
*
* @author Andreas Gohr <*****@*****.**>
*/
function act_save($act)
{
global $ID;
global $DATE;
global $PRE;
global $TEXT;
global $SUF;
global $SUM;
global $lang;
global $INFO;
//spam check
if (checkwordblock()) {
msg($lang['wordblock'], -1);
return 'edit';
}
//conflict check
if ($DATE != 0 && $INFO['meta']['date']['modified'] > $DATE) {
return 'conflict';
}
//save it
saveWikiText($ID, con($PRE, $TEXT, $SUF, 1), $SUM, $_REQUEST['minor']);
//use pretty mode for con
//unlock it
unlock($ID);
//delete draft
act_draftdel($act);
session_write_close();
// when done, show page
return 'show';
}
function pointsGagne($question, $auteur)
{
$con = con();
$res = mysqli_query($con, "select count(id) from votes where auteur=''");
$row = mysqli_fetch_array($res);
if ($row == NULL) {
return FALSE;
}
return TRUE;
mysqli_close($con);
}
<hr>
<div class="flatlistcontainer">
<?php
$query = "SELECT * FROM `filter` WHERE `display` = '1' AND `userid`='{$userid}'";
$con = con();
$res = $con->query($query);
while ($arr = $res->fetch_array()) {
$id = $arr['id'];
$query2 = "SELECT * FROM `notification` WHERE `sho` = '1' AND `filterid` = '{$id}' AND `userid`='{$userid}' ";
$con2 = con();
$res2 = $con2->query($query2);
while ($arr2 = $res2->fetch_array()) {
$houseid = $arr2['houseid'];
$query3 = "SELECT * FROM `flat` WHERE `id` = '{$houseid}' ";
$con3 = con();
$res3 = $con3->query($query3);
while ($arr3 = $res3->fetch_array()) {
if ($arr2['view'] == '1') {
echo "<div class=\"row flatlist\" style=\"background-color:blue\">";
} else {
echo "<div class=\"row flatlist\" style=\"background-color:white\">";
}
?>
<div class="col-md-12"><a href="modify.php?id=<?php
echo $id;
?>
&idd=<?php
echo $houseid;
?>
<?php
//Connect to multiple addresses using a single file
//useful for cronjobs
//By Thunder33345(twitter.com/thunder33345)
//2016/1/17
$site = array("https://192.168.1.1");
function con($site)
{
if (file_get_contents("{$site}")) {
echo 1;
echo $site;
echo "||";
} else {
echo 0;
echo $site;
echo "||";
}
}
foreach ($site as &$val) {
con($val);
}
unset($val);
<?php
function con()
{
mysql_connect() or die('Could not connect: ' . mysql_error);
mysql_select_db('sloisel_numeric') or die('Could not select db: ' . mysql_error());
}
con();
if (isset($_POST['savedata'])) {
$data = $_POST['savedata'];
if (get_magic_quotes_gpc()) {
$data = stripslashes($data);
}
json_decode($data) or die("json error");
$f = hash('sha256', $data);
if ($f === "") {
exit;
}
$d = mysql_real_escape_string($data);
$q = "insert ignore into blobs value ('{$f}','{$d}')";
$result = mysql_query($q) or die('Could not save script: ' . mysql_error());
header('Location: workshop.php?link=' . $_GET['link']);
exit;
}
?>
WORKSHOPHTML
<script>
<?php
$incs = NULL;
/**
* Hard to generalise together with get_single_row(), because they call different functions.
*/
function get_single_assoc($sql)
{
$query = $this->query($sql);
$row1 = $query->tryGetAssoc();
con(is_array($row1), "get_single_assoc()", "Denne query gav intet resultat.");
$row2 = $query->tryGetAssoc();
con($row2 === false, "get_single_assoc()", "query må kun returneres én row: ", $row1, $row2);
return $row1;
}
function supprVote2($reponse)
{
$con = con();
$stmt = mysqli_prepare($con, "DELETE FROM votes WHERE reponse = ? ");
mysqli_stmt_bind_param($stmt, 'i', $reponse);
mysqli_stmt_execute($stmt);
mysqli_close($con);
}
<?php
session_start();
$id1 = $_SESSION['userid'];
include 'function.php';
$query = "select distinct user1,user2 from messages where user1='{$id1}' OR user2='{$id1}'";
$con = con();
$res = $con->query($query);
while ($arr = $res->fetch_array()) {
if ($id1 == $arr['user1']) {
$user2 = $arr['user2'];
$query1 = "select * from user where id='{$user2}'";
$con1 = con();
$res1 = $con1->query($query1);
while ($arr1 = $res1->fetch_array()) {
echo "<a href=\"chatindex.php?id2=" . $arr['user2'] . "\">" . $arr1['name'] . "</a>";
echo "<br>";
}
} else {
$user1 = $arr['user1'];
$query1 = "select * from user where id='{$user1}'";
$con1 = con();
$res1 = $con1->query($query1);
while ($arr1 = $res1->fetch_array()) {
echo "<a href=\"chatindex.php?id2=" . $arr['user1'] . "\">" . $arr1['name'] . "</a>";
echo "<br>";
}
}
}
?>
</body>
</html>
</div>
</div>
</div>
</div>
<div class="wlistdetails">
<h1 style="font-family: 'PT Sans Narrow', sans-serif;">Wishlist</h1>
<hr>
<div class="wlistcontainer">
<?php
$query7 = "select * from wishlist where buyerid='{$userid}' AND sho='1' ";
$con7 = con();
$res7 = $con7->query($query7);
while ($arr7 = $res7->fetch_array()) {
$sellerid = $arr7['sellerid'];
$houseid = $arr7['houseid'];
$wishid = $arr7['id'];
$query8 = "select * from user where id='{$sellerid}'";
$res8 = $con->query($query8);
while ($arr8 = $res8->fetch_array()) {
$sellername = $arr8['name'];
$sellernum = $arr8['phnno'];
}
$query9 = "select * from flat where id='{$houseid}'";
$res9 = $con->query($query9);
while ($arr9 = $res9->fetch_array()) {
$houseno = $arr9['houseno'];
function qry($sql)
{
$con = con();
$res = mysql_query($sql, $con);
return $res;
}
/**
* Handle 'save'
*
* Checks for spam and conflicts and saves the page.
* Does a redirect to show the page afterwards or
* returns a new action.
*
* @author Andreas Gohr <*****@*****.**>
*/
function act_save($act)
{
global $ID;
global $DATE;
global $PRE;
global $TEXT;
global $SUF;
global $SUM;
//spam check
if (checkwordblock()) {
return 'wordblock';
}
//conflict check //FIXME use INFO
if ($DATE != 0 && @filemtime(wikiFN($ID)) > $DATE) {
return 'conflict';
}
//save it
saveWikiText($ID, con($PRE, $TEXT, $SUF, 1), $SUM, $_REQUEST['minor']);
//use pretty mode for con
//unlock it
unlock($ID);
//delete draft
act_draftdel($act);
session_write_close();
// when done, show page
return 'show';
}
function tpl_content_core()
{
global $ACT;
global $TEXT;
global $PRE;
global $SUF;
global $SUM;
global $IDX;
switch ($ACT) {
case 'show':
html_show();
break;
case 'locked':
html_locked();
case 'edit':
case 'recover':
html_edit();
break;
case 'preview':
html_edit();
html_show($TEXT);
break;
case 'draft':
html_draft();
break;
case 'search':
html_search();
break;
case 'revisions':
$first = isset($_REQUEST['first']) ? intval($_REQUEST['first']) : 0;
html_revisions($first);
break;
case 'diff':
html_diff();
break;
case 'recent':
if (is_array($_REQUEST['first'])) {
$_REQUEST['first'] = array_keys($_REQUEST['first']);
$_REQUEST['first'] = $_REQUEST['first'][0];
}
$first = is_numeric($_REQUEST['first']) ? intval($_REQUEST['first']) : 0;
html_recent($first);
break;
case 'index':
html_index($IDX);
#FIXME can this be pulled from globals? is it sanitized correctly?
break;
case 'backlink':
html_backlinks();
break;
case 'conflict':
html_conflict(con($PRE, $TEXT, $SUF), $SUM);
html_diff(con($PRE, $TEXT, $SUF), false);
break;
case 'login':
html_login();
break;
case 'register':
html_register();
break;
case 'resendpwd':
html_resendpwd();
break;
case 'denied':
print p_locale_xhtml('denied');
break;
case 'profile':
html_updateprofile();
break;
case 'admin':
tpl_admin();
break;
case 'subscribe':
tpl_subscribe();
break;
default:
$evt = new Doku_Event('TPL_ACT_UNKNOWN', $ACT);
if ($evt->advise_before()) {
msg("Failed to handle command: " . hsc($ACT), -1);
}
$evt->advise_after();
unset($evt);
return false;
}
return true;
}
<?php
include 'conn.php';
$os_in = filter_input(INPUT_POST, 'os');
$java_in = filter_input(INPUT_POST, 'java');
$version_in = filter_input(INPUT_POST, 'version');
$log_in = filter_input(INPUT_POST, 'log');
//Find existing bug report
$dbh = con();
//Get connection
$stmt = $dbh->prepare("SELECT * FROM " . table() . " where log = ?");
if ($stmt->execute(array($log_in))) {
while ($row = $stmt->fetch()) {
$foundRow = $row;
break;
}
}
if (empty($foundRow)) {
//New bug report
$count = '1';
$stmt = $dbh->prepare("INSERT INTO " . table() . " (os,java,version,log,count) VALUES (:os, :java, :version, :log, :count)");
$stmt->bindParam(':os', $os_in);
$stmt->bindParam(':java', $java_in);
$stmt->bindParam(':version', $version_in);
$stmt->bindParam(':log', $log_in);
$stmt->bindParam(':count', $count);
$stmt->execute();
$id = $dbh->lastInsertId();
print $id;
$to = '*****@*****.**';
$subject = "New " . name() . " bug report";
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<?php
include 'function.php';
session_start();
$userid = $_SESSION['userid'];
$query = "SELECT * FROM `filter` WHERE `display` = '1' AND `userid` = '{$userid}' ";
$con = con();
$res = $con->query($query);
while ($arr = $res->fetch_array()) {
$id = $arr['id'];
echo $arr['city'];
echo $arr['price'];
echo $arr['bhk'];
echo $arr['plotarea'];
?>
<a href="modifyfilter.php?id=<?php
echo $id;
?>
" role="button">No show</a>
<?php
}
?>
<body>
</body>
</html>
/**
* ask the user about how to handle an exisiting draft
*
* @author Andreas Gohr <*****@*****.**>
*/
function html_draft()
{
global $INFO;
global $ID;
global $lang;
global $conf;
$draft = unserialize(io_readFile($INFO['draft'], false));
$text = cleanText(con($draft['prefix'], $draft['text'], $draft['suffix'], true));
echo p_locale_xhtml('draft');
?>
<form id="dw__editform" method="post" action="<?php
echo script();
?>
"
accept-charset="<?php
echo $lang['encoding'];
?>
"><div class="no">
<input type="hidden" name="id" value="<?php
echo $ID;
?>
" />
<input type="hidden" name="date" value="<?php
echo $draft['date'];
?>
" /></div>
<textarea name="wikitext" id="wiki__text" readonly="readonly" cols="80" rows="10" class="edit"><?php
echo "\n" . formText($text);
?>
</textarea>
<div id="draft__status"><?php
echo $lang['draftdate'] . ' ' . date($conf['dformat'], filemtime($INFO['draft']));
?>
</div>
<input class="button" type="submit" name="do[recover]" value="<?php
echo $lang['btn_recover'];
?>
" tabindex="1" />
<input class="button" type="submit" name="do[draftdel]" value="<?php
echo $lang['btn_draftdel'];
?>
" tabindex="2" />
<input class="button" type="submit" name="do[show]" value="<?php
echo $lang['btn_cancel'];
?>
" tabindex="3" />
</form>
<?php
}
/**
* Default Action of TPL_ACT_RENDER
*
* @return bool
*/
function tpl_content_core()
{
global $ACT;
global $TEXT;
global $PRE;
global $SUF;
global $SUM;
global $IDX;
global $INPUT;
switch ($ACT) {
case 'show':
html_show();
break;
/** @noinspection PhpMissingBreakStatementInspection */
/** @noinspection PhpMissingBreakStatementInspection */
case 'locked':
html_locked();
case 'edit':
case 'recover':
html_edit();
break;
case 'preview':
html_edit();
html_show($TEXT);
break;
case 'draft':
html_draft();
break;
case 'search':
html_search();
break;
case 'revisions':
html_revisions($INPUT->int('first'));
break;
case 'diff':
html_diff();
break;
case 'recent':
html_recent($INPUT->extract('first')->int('first'), $INPUT->str('show_changes'));
break;
case 'index':
html_index($IDX);
#FIXME can this be pulled from globals? is it sanitized correctly?
break;
case 'backlink':
html_backlinks();
break;
case 'conflict':
html_conflict(con($PRE, $TEXT, $SUF), $SUM);
html_diff(con($PRE, $TEXT, $SUF), false);
break;
case 'login':
html_login();
break;
case 'register':
html_register();
break;
case 'resendpwd':
html_resendpwd();
break;
case 'denied':
print p_locale_xhtml('denied');
break;
case 'profile':
html_updateprofile();
break;
case 'admin':
tpl_admin();
break;
case 'subscribe':
tpl_subscribe();
break;
case 'media':
tpl_media();
break;
default:
$evt = new Doku_Event('TPL_ACT_UNKNOWN', $ACT);
if ($evt->advise_before()) {
msg("Failed to handle command: " . hsc($ACT), -1);
}
$evt->advise_after();
unset($evt);
return false;
}
return true;
}
//echo "<img src= '$target_path' >";
//mysql_query($query_upload) or die("error in $query_upload == ----> ".mysql_error());
} else {
exit("Error While uploading image on the server");
}
}
$res = $con->query($query);
$query2 = "SELECT * FROM `filter` WHERE city='{$city}' AND price >= '{$price}' AND bhk='{$bhk}' AND plotarea >= '{$plotarea}' AND userid='{$userid}'";
$con2 = con();
$res2 = $con2->query($query2);
while ($arr2 = $res2->fetch_array()) {
$filterid = $arr2['id'];
$query3 = "SELECT * FROM flat WHERE city='{$city}' AND price <= '{$price}' AND bhk='{$bhk}' AND plotarea <= '{$plotarea}'";
$con3 = con();
$res3 = $con3->query($query3);
while ($arr = $res3->fetch_array()) {
$houseid = $arr['id'];
$query5 = "SELECT * FROM notification WHERE filterid='{$filterid}' AND houseid = '{$houseid}' AND userid = '{$userid}' ";
$con5 = con();
$res5 = $con5->query($query5);
if ($res5->num_rows == 0) {
$query4 = "INSERT INTO `notification` (houseid,filterid,sho,userid) VALUES ('{$houseid}','{$filterid}','1','{$userid}')";
$con4 = con();
$res4 = $con4->query($query4);
}
}
}
header('location:profile.php');
?>
</body>
</html>
/**
* ask the user about how to handle an exisiting draft
*
* @author Andreas Gohr <*****@*****.**>
*/
function html_draft()
{
global $INFO;
global $ID;
global $lang;
global $conf;
$draft = unserialize(io_readFile($INFO['draft'], false));
$text = cleanText(con($draft['prefix'], $draft['text'], $draft['suffix'], true));
print p_locale_xhtml('draft');
$form = new Doku_Form(array('id' => 'dw__editform'));
$form->addHidden('id', $ID);
$form->addHidden('date', $draft['date']);
$form->addElement(form_makeWikiText($text, array('readonly' => 'readonly')));
$form->addElement(form_makeOpenTag('div', array('id' => 'draft__status')));
$form->addElement($lang['draftdate'] . ' ' . dformat(filemtime($INFO['draft'])));
$form->addElement(form_makeCloseTag('div'));
$form->addElement(form_makeButton('submit', 'recover', $lang['btn_recover'], array('tabindex' => '1')));
$form->addElement(form_makeButton('submit', 'draftdel', $lang['btn_draftdel'], array('tabindex' => '2')));
$form->addElement(form_makeButton('submit', 'show', $lang['btn_cancel'], array('tabindex' => '3')));
html_form('draft', $form);
}
<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="content-type" content="text/html" />
<meta name="author" content="shohan" />
<title>Untitled 6</title>
</head>
<body>
<div style="width:200px;height:500px;background-color: aquamarine;">
<p style="text-align: center;"><strong>Product Category</strong></p>
<?php
$lin = con();
$p = "SELECT * FROM categoty";
$re = mysqli_query($lin, $p);
while ($row = mysqli_fetch_array($re)) {
echo "<a href='w.php?id={$row['category_name']} '>{$row['category_name']}</a><br>";
}
?>
</div>
<div style="width:78.5%;height:500px;background-color: green;left:213px;position:absolute;top:16px">
</div>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?php
include 'function.php';
session_start();
$userid = $_SESSION['userid'];
$id = validate($_GET['id']);
$idd = validate($_GET['idd']);
//echo "a".$id."";
$query2 = "UPDATE `notification` SET `view` = '0' WHERE `filterid`='{$id}' AND `houseid`='{$idd}' AND userid='{$userid}'";
$con2 = con();
$res2 = $con2->query($query2);
header('location:flats.php?id=' . $idd);
?>
</body>
</html>
function search_item($arrayIDs)
{
con();
$rs = array();
for ($i = 0; $i < count($arrayIDs); $i++) {
//search every item
$query = "SELECT article_versions.article_versionID, article_versions.articleID, article_versions.title, left(article_versions.article_body, 100) as Summary FROM article_versions WHERE article_versions.articleID = '{$arrayIDs[$i]}'";
//print($query);
$result = mysql_query($query);
if (!$result) {
echo mysql_error();
} else {
while ($row = mysql_fetch_assoc($result)) {
$rs[] = $row;
}
}
}
//print_r($rs);
return $rs;
//return array or results
}
