本文整理汇总了PHP中getdata函数的典型用法代码示例。如果您正苦于以下问题：PHP getdata函数的具体用法？PHP getdata怎么用？PHP getdata使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了getdata函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: getmeasures
function getmeasures($typeid)
{
$measures = getdata('http://www.weather.com.cn/data/alarminfo/' . $typeid . '.html');
$measures = parsejsjson($measures);
$measures = explode('<br>', $measures[3]);
return $measures;
}
开发者ID:2947721120，项目名称:php-weather-info-cn，代码行数:7，代码来源:alarm.php
示例2: email_send
function email_send($to, $sub, $msg, $cc = '', $bcc = '', $attach = '') {
$CI = get_instance();
$email_conf = getdata('*', 'email_config', array('active' => 1));
$config = Array(
'protocol' => 'smtp',
'smtp_host' => $email_conf[0]['host'],
'smtp_port' => $email_conf[0]['port'],
'smtp_user' => $email_conf[0]['username'], // change it to yours
'smtp_pass' => $email_conf[0]['password'], // change it to yours
'mailtype' => 'html',
'charset' => 'iso-8859-1',
'wordwrap' => TRUE);
$CI->load->library('email', $config);
$CI->email->from($email_conf[0]['from']);
$CI->email->to($to);
$CI->email->subject($sub);
$CI->email->message($msg);
if ($attach != "") {
$CI->email->attach($attach);
}
if ($cc != "") {
$CI->email->cc($cc);
}
if ($bcc != "") {
$CI->email->bcc($bcc);
}
if (!$CI->email->send()) {
echo $CI->email->print_debugger();
}
}
开发者ID:khushbu-soni，项目名称:server，代码行数:33，代码来源:general_helper.php
示例3: getFirstResult
public function getFirstResult($search, $filename)
{
//print "http://www.chartlyrics.com/search.aspx?q=".replace_space($search);
$getdata_source = getdata("http://www.chartlyrics.com/search.aspx?q=" . replace_space($search), $curl);
$getdata = explode('<th style="width: auto">', $getdata_source);
$getdata = explode('[END] Page', $getdata[1]);
$getdata = explode('<a href="', $getdata[0]);
$achou = false;
if (count($getdata) > 1) {
$pecah = $getdata[1];
//foreach($getdata as $pecah){
$data = explode('</a>', $pecah);
$data = explode('<td>', $data[0]);
$data = array_unique(explode('</th>', $data[0]));
//$gay = $data[0];
foreach ($data as $gay) {
$gay = explode('">', $gay);
if (!strpos($gay[0], "add.aspx")) {
if (isset($gay[1])) {
$string = $gay[0] . ":" . $gay[1] . ":" . str_replace(".php", "", str_replace("_", ".", $filename));
//echo "<center><a href='?lyrics=".encode_url($string, 'encode')."'>$gay[1]</a><br /></center>";
//print encode_url($string, 'encode');
$achou = true;
$this->get_result(encode_url($string, 'encode'));
}
}
}
//}
}
if (!$achou) {
echo "0";
}
}
开发者ID:augustogava，项目名称:lyrics-parser，代码行数:33，代码来源:chartlyrics_com.php
示例4: update_datos
function update_datos($screenname, $update_id)
{
global $code_app, $cont_access_token;
shuffle($code_app);
echo '<br>Twitter user: ' . $code_app[$cont_access_token]['user'];
//include("../config/config_cronjob.php");
//Fetch Data From Twitter
$url = "https://api.twitter.com/1.1/users/lookup.json";
$parameters1 = "screen_name=" . $screenname;
$retdata = getdata($url, $parameters1);
if ($retdata) {
$twdatas = json_decode($retdata, true);
foreach ($twdatas as $twdata) {
if ($twdata[0]["message"]) {
} else {
$hfflag = 0;
$twitter_id = $twdata["id"];
$twitter_name = $twdata["name"];
$screen_name = $twdata["screen_name"];
$profile_image_url = mysql_real_escape_string($twdata["profile_image_url"]);
$description = mysql_real_escape_string($twdata["description"]);
$location = mysql_real_escape_string($twdata["location"]);
$timezone = mysql_real_escape_string($twdata["time_zone"]);
$creationdate = $twdata["created_at"];
$lang = mysql_real_escape_string($twdata["lang"]);
$verified = $twdata["verified"];
$followers_count = $twdata["followers_count"];
$following_count = $twdata["friends_count"];
$tweetcount = $twdata["statuses_count"];
$listedcount = $twdata["listed_count"];
$qry = "";
$qry = "Update owloo_user_master Set ";
$qry = $qry . " owloo_user_twitter_id = '" . $twitter_id . "',";
$qry = $qry . " owloo_user_name = '" . $twitter_name . "',";
$qry = $qry . " owloo_screen_name = '" . $screen_name . "',";
$qry = $qry . " owloo_user_photo = '" . $profile_image_url . "',";
$qry = $qry . " owloo_user_description = '" . $description . "',";
$qry = $qry . " owloo_user_location = '" . $location . "',";
$qry = $qry . " owloo_user_language = '" . $lang . "',";
$qry = $qry . " owloo_user_verified_account = '" . $verified . "',";
$qry = $qry . " owloo_user_timezone = '" . $timezone . "',";
$qry = $qry . " owloo_user_created_on = '" . $creationdate . "',";
$qry = $qry . " owloo_followers_count = '" . $followers_count . "',";
$qry = $qry . " owloo_following_count = '" . $following_count . "',";
$qry = $qry . " owloo_tweetcount = '" . $tweetcount . "',";
$qry = $qry . " owloo_listed_count = '" . $listedcount . "',";
$qry = $qry . " owloo_updated_on = '" . Date("Y-m-d") . "'";
$qry = $qry . " Where owloo_user_twitter_id = '" . $twitter_id . "'";
$qry = $qry . " AND owloo_screen_name = '" . $screen_name . "'";
echo '<br>SQL 3: ' . $qry . '<br>';
mysql_query($qry);
update_tweets($update_id, $screen_name, $tweetcount);
}
}
}
}
开发者ID:newbacknew，项目名称:owloo.com，代码行数:56，代码来源:cronjob_profile.php
示例5: get_result
public function get_result($request)
{
$request = encode_url($request, "decode");
$getname = explode(':', $request);
$url = replace_space("http://www.chartlyrics.com" . $getname[0]);
$getlyrics = getdata("{$url}", $curl);
$getlyrics = explode('alt="" title="', $getlyrics);
$getlyrics = explode('" />', $getlyrics[1]);
$getlyrics = explode('<div id="adlyric">', $getlyrics[1]);
echo "<center><br><font size=60><b>{$getname['1']}</b></font><br><br>{$getlyrics['0']}</center>";
}
开发者ID:laiello，项目名称:php-lyrics-finder，代码行数:11，代码来源:chartlyrics_com.php
示例6: get_result
public function get_result($request)
{
$request = encode_url($request, "decode");
$getname = explode(':', $request);
$url = replace_space("http://www.lyrics007.com" . $getname[0]);
$getlyrics = getdata("{$url}", $curl);
$getlyrics = explode('display:block;float:left;padding-top:5px;', $getlyrics);
$getlyrics = explode('/print.php?id=TWpnNE1qVTE', $getlyrics[1]);
$getlyrics = explode('</fb:like>', $getlyrics[0]);
$getlyrics = explode('<script type="text/javascript">', $getlyrics[1]);
echo "<center><br><font size=60><b>{$getname['1']}</b></font><br><br>{$getlyrics['0']}</center>";
}
开发者ID:laiello，项目名称:php-lyrics-finder，代码行数:12，代码来源:lyrics007_com.php
示例7: phase1
function phase1($db)
{
global $PHPSEA_ERROR;
echo "<H2> 实例 1 - 将上一步的数组写入csv文件</H2>";
$db->new_rows = getdata();
$db->append();
if ($db->write_csv(false, true)) {
// Write database to file forcing overwrite/ file creation
echo "<pre>";
$cf = "{$db->dir}/{$db->data_file}";
readfile($cf);
echo "</pre>";
echo "将一个二维数组写入文件，并读出显示。<br />\n";
echo "<a href='{$PHP_SELF}?phase=0' > 上一步</a>\n ";
echo "<a href='{$PHP_SELF}?phase=2' > 下一步</a>\n";
} else {
echo "<Hr>" . $PHPSEA_ERROR['FileCsv_Error'];
}
endpage();
}
开发者ID:chaobj001，项目名称:tt，代码行数:20，代码来源:test_filecsv.php
示例8: getdata
<?php
require 'inc/config_w.php';
require 'inc/data_w.php';
$type = $_GET['type'];
$first = (int) $_GET['first'];
$eid = (int) $_GET['eid'];
if (!$first) {
$first = 0;
}
$con = getdata($type, $first, "", $eid);
$c = count($con);
$str = '[';
if ($c) {
for ($i = 0; $i < $c; ++$i) {
$con[$i]['title'] = str_replace("\n", '\\n', addslashes(htmlspecialchars($con[$i]['title'], ENT_QUOTES)));
$con[$i]['des'] = str_replace("\n", '\\n', addslashes(htmlspecialchars($con[$i]['des'], ENT_QUOTES)));
$str .= '{"id":"' . $con[$i]['id'] . '","type":"' . $con[$i]['type'] . '","lou":"' . $con[$i]['lou'] . '","view":"' . $con[$i]['click'] . '","comc":"' . $con[$i]['comc'] . '","title":"' . $con[$i]['title'] . '","timey":"' . date('Y年', $con[$i]['time']) . '","timem":"' . date('m', $con[$i]['time']) . '","timed":"' . date('d', $con[$i]['time']) . '","week":"' . date('D', $con[$i]['time']) . '","time":"' . date('H:i', $con[$i]['time']) . '","des":"' . $con[$i]['des'] . '","color":"' . $con[$i]['color'] . '","ext":"' . ($i + $first + 1) . '"},';
}
$str .= '"' . mysql_errno() . '"]';
} else {
$str .= '"' . mysql_errno() . '"]';
}
echo $str;
开发者ID:JermingFan，项目名称:wechatTreeHole，代码行数:24，代码来源:json_w.php
示例9: mysqli_query
<?php
include 'db.php';
include 'fetchproduct.php';
include 'head.php';
$package = $_REQUEST["package"];
if (isset($_COOKIE["eshop"])) {
$user = $_COOKIE["eshop"];
$result = mysqli_query($con, "select * from delivery where byuser='{$user}' and package='{$package}' order by id desc");
while ($row = mysqli_fetch_array($result)) {
echo "\n\t<script>\n\t\$(document).ready(function()\n\t{\n\t\$('.meter').hide().fadeIn(1000);\n\t});\n\t</script>\n\n";
echo "<img height=\"10%\" width=\"10%\" src='images/" . getdata($row["productid"], "imgurl") . '\'> - <h3>' . getdata($row["productid"], "name");
echo "<br /></h3>Order Placed Item Packed Item Shipped Delivered Item Order Completed <br />";
if ($row["deliverystatus"] == "Order Placed Successfully") {
echo "<div class='meter'><img src='blinkon.png' height='2%' width='2%'> <img height='2%' width='2%' src='blinkoff.png'> <img height='2%' width='2%' src='blinkoff.png'> <img height='2%' width='2%' src='blinkoff.png'> <img height='2%' width='2%' src='blinkoff.png'>";
}
if ($row["deliverystatus"] == "Item is Packed") {
echo "<div class='meter'><img src='blinkon.png' height='2%' width='2%'> <img height='2%' width='2%' src='blinkon.png'> <img height='2%' width='2%' src='blinkoff.png'> <img height='2%' width='2%' src='blinkoff.png'> <img src='blinkoff.png'>";
}
if ($row["deliverystatus"] == "Item is Shipped") {
echo "<div class='meter'><img src='blinkon.png' height='2%' width='2%'> <img src='blinkon.png' height='2%' width='2%'> <img height='2%' width='2%' src='blinkon.png'> <img height='2%' width='2%' src='blinkoff.png'> <img height='2%' width='2%' src='blinkoff.png'>";
}
if ($row["deliverystatus"] == "Item is Delivered") {
echo "<div class='meter'><img src='blinkon.png' height='2%' width='2%'> <img height='2%' width='2%'src='blinkon.png'> <img height='2%' width='2%' src='blinkon.png'> <img height='2%' width='2%' src='blinkon.png'> <img height='2%' width='2%' src='blinkon.png'>";
}
echo "</div><hr />";
}
} else {
}
开发者ID:akshatjoshi2001，项目名称:E-Commerce-Website-On-PHP-and-Python，代码行数:29，代码来源:trackit.php
示例10: array
<header class="header">
<div><a href="javascript:history.back();"><i class="icon-arrow-back"></i></a></div>
<h1>散货发布</h1>
<div><a href="index.php"><i class="icon-home"></i></a></div>
</header>
<?php
//$dump_array=$wood->dumpposition; lj-
if (isset($_SESSION['user'])) {
//用户或管理员登录后才可以发表信息
$cdkey = $_GET["cdkey"];
$dump = array();
if ($cdkey != "") {
$isnew = 0;
$sqlstr = "select userid,kindid,stuffid,productlen,diameterlen,wide,thinckness," . "tolerance,widerange,thincknessrange,refcapacity,timber," . "dry,newold,timbertype,knob,blue,worm,decay,climb,slash,ring,oil,black" . ",dumpposition,part,device,fromid,portid,publishtime," . "updatetime,goodtype,cdkey,content,contact,contactphone from t_product where cdkey='" . $cdkey . "'";
$mydump = getdata($sqlstr);
if (!is_array($mydump)) {
echo "<p>对不起，没有查找到您要查找的内容！</p>";
return;
} else {
$dump = $mydump[0];
}
} else {
$isnew = 1;
$dump = array("refcapacity" => "", "refnum" => "", "refwight" => "", "contact" => "", "contactphone" => "", "diameterlen" => "0", "thinckness" => "", "price" => "", "wide" => "", "device" => "", "worm" => "", "decay" => "", "widerange" => "", "thincknessrange" => "", "xielie" => "", "huanlie" => "", "chouyou" => "", "heixin" => "", "content" => "", "display" => "0", "stuffid" => "0", "kindid" => "0", "productlen" => "0", "dumpposition" => "0", "timber" => "0", "timbertype" => "0", "tolerance" => "-99", "knob" => "0", "climb" => "0", "part" => "0", "dry" => "0", "newold" => "0", "blue" => "0", "slash" => "0", "oil" => "0", "black" => "0", "ring" => "0", "fromid" => "0");
}
?>
<form class="onoff" id="submitform">
<ul class="list">
<li>
<ul class="upImg-display">
开发者ID:shihang1228，项目名称:mcr_new，代码行数:30，代码来源:wxdumprelease.php
示例11: smarty_yzblog
$yzblog = new smarty_yzblog();
$yzblog->setTemplateDir('../tpl/w/');
$type = $_GET['type'];
$id = (int) $_GET['id'];
$con = getdata($type, 0, $id);
$text = nl2br(htmlspecialchars($con[0]['content']));
#ubb放在这之后
if ($con[0]['type'] == "article") {
$text = straddubb($text);
}
$link = mysql_connect(HOST . ':' . PORT, USER, PASSWORD);
if ($link) {
mysql_select_db(DATABASE, $link);
mysql_query('UPDATE ' . WALL . ' SET click=' . ($con[0]['click'] + 1) . ' where id=' . $con[0]['id']);
}
$comment = getdata('comment', 0, "", $id);
$c = count($comment);
if ($c) {
for ($i = 0; $i < $c; ++$i) {
$comment[$i]['title'] = htmlspecialchars($comment[$i]['title'], ENT_QUOTES);
$comment[$i]['des'] = htmlspecialchars($comment[$i]['des'], ENT_QUOTES);
$a = 'div';
$view = '';
$str .= '<' . $a . ' class="item" style="background:' . $comment[$i]['color'] . ';" href="article.php?id=' . $comment[$i]['id'] . '"><img class="point" src="../img/point.png" /><div class="num none">' . ($i + $first + 1) . '</div><div class="view left">#' . $comment[$i]['lou'] . '</div>' . $view . '<div class="time right"><span class="timed">' . date('d', $comment[$i]['time']) . '</span>日<span class="timem">' . date('m', $comment[$i]['time']) . '</span>月' . date('Y年 D H:i', $comment[$i]['time']) . '</div><div class="des feeling">' . $comment[$i]['des'] . '</div><h1 class="title">' . $comment[$i]['title'] . '</h1></' . $a . '>';
}
} else {
$note = '没有评论，来一条吧～';
}
$tttt = CLASS_1;
if ($con[0]['class'] == 1001) {
$tttt = CLASS_2;
开发者ID:JermingFan，项目名称:wechatTreeHole，代码行数:31，代码来源:article.php
示例12: mysql_query
<th class="col-md-1 text-center">No</th>
<th class="col-md-2 text-center">Program / Instansi</th>
<th class="col-md-2 text-center">Jurusan</th>
<th class="col-md-2 text-center">Topik/Referensi</th>
<th class="col-md-2 text-center">Periode</th>
<th class="text-center">Status</th>
<th class="col-md-1 text-center">Aksi</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
$q = mysql_query("select * from internship_registration where USER_DETAIL_ID='" . $_SESSION['iddetail'] . "'");
while ($d = mysql_fetch_array($q)) {
$idins = getdata('user_education', "USER_DETAIL_ID='" . $_SESSION['iddetail'] . "'", 'INSTITUTE_ID');
$idmajor = getdata('user_education', "USER_DETAIL_ID='" . $_SESSION['iddetail'] . "'", 'MAJOR_ID');
?>
<tr>
<td class="text-center"><?php
echo $i;
?>
</td>
<td class="text-center"><?php
echo ambildata($d['EDUCATION_LEVEL_ID'], 'education_level', 'EDUCATION_LEVEL_NAME');
?>
/ <?php
echo ambildata($idins, 'institute', 'INSTITUTE_NAME');
?>
</td>
<td class="text-center"><?php
echo ambildata($idmajor, 'major', 'MAJOR_NAME');
开发者ID:aa-azizah，项目名称:skrps，代码行数:31，代码来源:inside_default.php
示例13: switch
<?php
if (isset($_GET['act'])) {
$act = $_GET['act'];
switch ($act) {
case 'addnew':
// UNIT_ID
$unitid = ambildata($_SESSION['iddetail'], 'user_detail', 'UNIT_ID');
// UNIT_NAME
$unitname = ambildata($unitid, 'unit', 'UNIT_NAME');
// INTERNSHIP ID
$internid = getdata('internship_registration', "USER_DETAIL_ID='" . $_SESSION['iddetail'] . "' and STATUS!='REJECTED' and STATUS!='PENDING'", 'GUID');
if (isset($_POST['judul'])) {
/*/ UNIT_ID
$unitid = ambildata($_SESSION['iddetail'],'user_detail','UNIT_ID');
// UNIT_NAME
$unitname = ambildata($unitid,'unit','UNIT_NAME');*/
$judul = mysql_real_escape_string($_POST['judul']);
$pesan = mysql_real_escape_string($_POST['pesan']);
$quid = mysql_query("select uuid() as uuid");
$duid = mysql_fetch_array($quid);
$uuid = $duid['uuid'];
$q = mysql_query("insert into message(GUID,UNIT_ID,INTERN_ID,TITLE,SENDER_ID,MESSAGE_ID,MESSAGE,DTMCRT,STATUS) values('{$uuid}','{$unitid}','{$internid}','{$judul}','" . $_SESSION['iddetail'] . "','{$uuid}','{$pesan}',now(),'Waiting reply')");
if ($q) {
eksyen('', 'inside.php#comment');
} else {
eksyen('Error!', 'inside.php#comment');
}
}
?>
<br><h1>Kirim Pesan Baru <small>| <a href="inside.php#comment">kembali</a></small></h1>
开发者ID:aa-azizah，项目名称:skrps，代码行数:31，代码来源:message.php
示例14: featuredList
function featuredList() {
//echo FEATURED_LIST; exit;
$result = getdata(FEATURED_LIST);
if (count($result) > 0) {
return $result;
} else {
return false;
}
}
开发者ID:anandcyberlinks，项目名称:cyberlinks-demo，代码行数:9，代码来源:constant.php
示例15: array
$product = array("refcapacity" => "", "refnum" => "", "refwight" => "", "contact" => "", "contactphone" => "", "diameterlen" => "0", "thinckness" => "", "price" => "", "wide" => "", "device" => "", "worm" => "", "decay" => "", "widerange" => "", "thincknessrange" => "", "xielie" => "", "huanlie" => "", "chouyou" => "", "heixin" => "", "content" => "", "display" => "0");
}
//判断修改权限
if ($ismgr == 1 or $isowner == 1 or $isnew == 1) {
$modifyright = 1;
}
?>
<!--以下是自动把手机号输出到文件的代码-->
<?php
$phone_arr = array();
$chged = getdata('select phonechg from t_cs where sn=1');
//手机号是否被更新
if (is_array($chged)) {
$phoneadd = $chged[0];
if ($phoneadd["phonechg"] != 2) {
$phone_arr = getdata('select contactphone from t_ownphone order by contactphone');
//echo json_encode( $json_arr );
$phonestr = "";
$phone_array = array();
$i = 0;
//生成文件内容
foreach ($phone_arr as $row) {
$phonestr .= $row["contactphone"];
$phone_array[$i] = $row["contactphone"];
$i++;
}
if ($phonestr != "") {
$phonestr = "[" . $phonestr . "]";
$phonestr = str_replace(",]", "]", $phonestr);
}
}
开发者ID:shihang1228，项目名称:mcr_new，代码行数:31，代码来源:wxrelease.php
示例16: getdata
$params[$item[0]] = $item[1];
}
return $params;
}
for ($i = 957; $i < 1541;) {
$data = getdata("http://www.flipkart.com/home-kitchen/pr?p%5B%5D=sort%3Dprice_desc&sid=j9e&layout=grid&start=" . $i . "&ajax=true");
$data = str_replace("<textarea id='ajax'>", "", $data);
$data = str_replace("</textarea>", "", $data);
$data = html_entity_decode($data);
$html = str_get_html($data);
foreach ($html->find('.fk-anchor-link') as $element) {
$link = 'http://www.flipkart.com' . $element->href;
if ($url = parse_url($link)) {
$urlquery = convertUrlQuery($url['query']);
$url = $url['scheme'] . '://' . $url['host'] . $url['path'] . '?pid=' . $urlquery['pid'];
// put all your logic here
$itemdata = getdata($url);
$product_url = (string) $url;
//sqlite save command
scraperwiki::sqliteexecute("insert into flipkart_home_and_kitchen_dump values (?,?)", array($product_url, $itemdata));
//sqlite save command
scraperwiki::sqlitecommit();
}
}
// ending for loop
if ($i > 20) {
$i = $i + 20;
} else {
$i = $i + 21;
}
}
开发者ID:flyeven，项目名称:scraperwiki-scraper-vault，代码行数:31，代码来源:flipkart_sitemap_1.php
示例17: UDTasksAdmin
function UDTasksAdmin()
{
global $Administrator, $cxn, $unexpectederrormessage, $writeerrormessage;
if (!isset($_POST['TheUserID'])) {
echo '<html><head><title>No User ID specified</title><body>Error: This page does not appear to have been called in the correct fashion; no User ID is specified in the _POST array.</body></html>';
die('');
}
$EscapedUserID = (int) $_POST['TheUserID'];
$EscapedNewUserName = clean(@$_POST['NewUserName']);
$EscapedNewUserName = htmlspecialchars($EscapedNewUserName);
$URow = getdata($cxn, 1, 'SELECT `Administrator` FROM `User` WHERE `UserID` = ' . $EscapedUserID) or die($readerrormessage);
if ($URow === 'NONE') {
die($unexpectederrormessage);
} else {
if ($URow['Administrator'] == 2 and $Administrator == 1) {
$QueryResult = mysqli_query($cxn, 'UPDATE `User` SET `Administrator` = 0, `Banned` = 1, `LockPS` = 1 WHERE `UserID` = ' . $_SESSION['MyUserID']) or die($readerrormessage);
$subject = 'An Administrator attempted to alter your account and was de-admin\'d and banned';
$thetime = date('Y-m-d H:i:s', strtotime(now));
$body = 'At ' . $thetime . ', Administrator ' . $_SESSION['MyUserName'] . ' (User ID ' . $_SESSION['MyUserID'] . ') attempted to alter your account and was de-admin\'d and banned.';
// send_email($subject,$body,???????????????????,null);
die('lol i dont think so. owned scrub.');
} else {
if ($Administrator) {
if (strlen($EscapedNewUserName) > 20 and $_POST['ChangeUsername']) {
echo '<html><head><title>New user name too long</title><body>Error: New user name is too long.<p>Click <a href="index.php">here</a> to return to the Main Page.</body></html>';
die;
}
if (strlen($EscapedNewUserName) < 3 and $_POST['ChangeUsername']) {
echo '<html><head><title>New user name too short</title><body>Error: New user name is too short.<p>Click <a href="index.php">here</a> to return to the Main Page.</body></html>';
die;
}
if (@$_POST['BanUser']) {
$QueryResult = mysqli_query($cxn, 'UPDATE User SET Banned = 1 WHERE UserID = ' . $EscapedUserID) or die($writeerrormessage);
}
if (@$_POST['UnbanUser']) {
$QueryResult = mysqli_query($cxn, 'UPDATE User SET Banned = 0 WHERE UserID = ' . $EscapedUserID) or die($writeerrormessage);
}
if (@$_POST['LockPS']) {
$QueryResult = mysqli_query($cxn, 'UPDATE User SET LockPS = 1 WHERE UserID = ' . $EscapedUserID) or die($writeerrormessage);
}
if (@$_POST['UnlockPS']) {
$QueryResult = mysqli_query($cxn, 'UPDATE User SET LockPS = 0 WHERE UserID = ' . $EscapedUserID) or die($writeerrormessage);
}
if (@$_POST['ClearPS']) {
$QueryResult = mysqli_query($cxn, 'UPDATE User SET PersonalStatement = \'</i></b>\' WHERE UserID = ' . $EscapedUserID) or die($writeerrormessage);
}
/* if ( @$_POST['AllKick'] ) {
$QueryResult = getdata ($cxn,0,'SELECT Game.*, UserR.UserID AS UserIDR, UserR.Name AS NameR, UserR.Pronoun AS PronounR, UserR.Email AS EmailR, UserR.EmailPrompt AS EmailPromptR, UserR.EmailPromptAgain AS EmailPromptAgainR, UserR.HasBeenEmailed AS HasBeenEmailedR, UserY.UserID AS UserIDY, UserY.Name AS NameY, UserY.Pronoun AS PronounY, UserY.Email AS EmailY, UserY.EmailPrompt AS EmailPromptY, UserY.EmailPromptAgain AS EmailPromptAgainY, UserY.HasBeenEmailed AS HasBeenEmailedY, UserG.UserID AS UserIDG, UserG.Name AS NameG, UserG.Pronoun AS PronounG, UserG.Email AS EmailG, UserG.EmailPrompt AS EmailPromptG, UserG.EmailPromptAgain AS EmailPromptAgainG, UserG.HasBeenEmailed AS HasBeenEmailedG, UserP.UserID AS UserIDP, UserP.Name AS NameP, UserP.Pronoun AS PronounP, UserP.Email AS EmailP, UserP.EmailPrompt AS EmailPromptP, UserP.EmailPromptAgain AS EmailPromptAgainP, UserP.HasBeenEmailed AS HasBeenEmailedP, UserF.UserID AS UserIDF, UserF.Name AS NameF, UserF.Pronoun AS PronounF, UserF.Email AS EmailF, UserF.EmailPrompt AS EmailPromptF, UserF.EmailPromptAgain AS EmailPromptAgainF, UserF.HasBeenEmailed AS HasBeenEmailedF FROM Game LEFT JOIN User AS UserR ON Game.UserR = UserR.UserID LEFT JOIN User AS UserY ON Game.UserY = UserY.UserID LEFT JOIN User AS UserG ON Game.UserG = UserG.UserID LEFT JOIN User AS UserP ON Game.UserP = UserP.UserID LEFT JOIN User AS UserF ON Game.UserF = UserF.UserID WHERE ( UserR = '.$EscapedUserID.' OR UserY = '.$EscapedUserID.' OR UserG = '.$EscapedUserID.' OR UserP = '.$EscapedUserID.' OR UserF = '.$EscapedUserID.' ) AND Game.GameStatus = \'In Progress\'');
if ( $QueryResult != 'NONE' ) {
require(HIDDEN_FILES_PATH.'getgamedata.php');
require(HIDDEN_FILES_PATH.'kraftwerk.php');
while ( $row = mysqli_fetch_assoc( $QueryResult ) ) {
$row[GameTicker] = '';
extract(providegamedata($row,0));
for ($i=0;$i<5;$i++) {
if ( $PlayerUserID[$i] == $EscapedUserID ) { $ThePlayerToKick = $i; }
if ( $ThePlayerToKick == $PlayerToMove ) { $Delayed = 0; }
else { $Delayed = 1; }
}
KickPlayer($ThePlayerToKick,1,1,$Delayed);
dbformatgamedata();
}
}
} This is really outdated and should be redone. */
if (@$_POST[AllRemove]) {
$QueryResult = mysqli_query($cxn, 'UPDATE `Game` SET `GameStatus` = \'Cancelled\' WHERE `GameCreator` = ' . $EscapedUserID . ' AND GameStatus = \'Recruiting\'') or die($writeerrormessage);
$QueryResult = getdata($cxn, 0, 'SELECT GameID, PlayerExists, UserR, UserY, UserG, UserP, UserF FROM Game WHERE ( UserR = ' . $EscapedUserID . ' OR UserY = ' . $EscapedUserID . ' OR UserG = ' . $EscapedUserID . ' OR UserP = ' . $EscapedUserID . ' OR UserF = ' . $EscapedUserID . ' ) AND GameStatus = \'Recruiting\'');
if ($QueryResult != 'NONE') {
while ($row = mysqli_fetch_assoc($QueryResult)) {
$PlayerExists = explode('|', $row[PlayerExists]);
if ($row[UserR] == $EscapedUserID) {
$PlayerExists[0] = 0;
$ColourLetter = 'R';
}
if ($row[UserY] == $EscapedUserID) {
$PlayerExists[1] = 0;
$ColourLetter = 'Y';
}
if ($row[UserG] == $EscapedUserID) {
$PlayerExists[2] = 0;
$ColourLetter = 'G';
}
if ($row[UserP] == $EscapedUserID) {
$PlayerExists[3] = 0;
$ColourLetter = 'P';
}
if ($row[UserF] == $EscapedUserID) {
$PlayerExists[4] = 0;
$ColourLetter = 'F';
}
$PlayerExists = implode('|', $PlayerExists);
$QueryResult = mysqli_query($cxn, 'UPDATE Game SET PlayerExists = \'' . $PlayerExists . '\', User' . $ColourLetter . ' = NULL, CurrentPlayers = CurrentPlayers - 1 WHERE GameID = ' . $row[GameID]) or die($writeerrormessage);
}
}
}
if (@$_POST[ClearMsgs]) {
$QueryResult = mysqli_query($cxn, 'UPDATE Message SET DeletedByAdmin = 1 WHERE User = ' . $EscapedUserID) or die($writeerrormessage);
$QueryResult = mysqli_query($cxn, 'UPDATE Thread SET TitleDeletedByAdmin = 1 WHERE OriginalPoster = ' . $EscapedUserID) or die($writeerrormessage);
$QueryResult = mysqli_query($cxn, 'UPDATE Game SET GTitleDeletedByAdmin = 1 WHERE GameCreator = ' . $EscapedUserID) or die($writeerrormessage);
}
//.........这里部分代码省略.........
开发者ID:hdp，项目名称:brass，代码行数:101，代码来源:udtasksadmin.php
示例18: current_date
//date variable user to select a date for arrivals to do
break;
case "arrivals":
$sql = "Select guests.guestid,concat_ws(' ',guests.firstname,guests.middlename,guests.lastname) as guest,guests.pp_no,\n\t\tguests.idno,guests.address,guests.town,guests.postal_code,guests.phone,\n\t\tguests.email,guests.mobilephone,countries.country,reservation.reserve_checkindate\n\t\t\tFrom guests\n\t\t\tInner Join countries ON guests.countrycode = countries.countrycode\n\t\t\tInner Join reservation ON guests.guestid = reservation.guestid\n\t\t\tWhere reservation.reserve_checkindate >= current_date()";
break;
case "departures":
$sql = "Select guests.guestid,concat_ws(' ',guests.firstname,guests.middlename,guests.lastname) as guest,guests.pp_no,\n\t\tguests.idno,guests.address,guests.town,guests.postal_code,guests.phone,\n\t\tguests.email,guests.mobilephone,countries.country\n\t\t\tFrom guests\n\t\t\tInner Join countries ON guests.countrycode = countries.countrycode\n\t\t\tInner Join booking ON guests.guestid = booking.guestid\n\t\t\tWhere booking.checkout_date=current_date()";
guestslist($sql);
break;
case "dep_summ":
$sql = "Select rooms.roomno as RoomNo,transactions.doc_no as DocNo,transactions.doc_type,concat_ws(' ',guests.firstname,guests.middlename,guests.lastname) AS Name,\n\t\ttransactions.dr as Debit,transactions.cr as Credit,details.item as Remarks,transactions.doc_date as DocDate\n\t\t\tFrom transactions\n\t\t\tleft Join details ON transactions.details = details.itemid\n\t\t\tleft Join bills ON transactions.billno = bills.billno\n\t\t\tInner Join booking ON bills.book_id = booking.book_id\n\t\t\tInner Join guests ON booking.guestid = guests.guestid\n\t\t\tInner Join rooms ON booking.roomid = rooms.roomid";
//Where transactions.details = '$details' and transactions.doc_date = '$date'
echo "<table>\n\t\t<tr><td><h2>Departmental Summary Control Sheet</h2></td></tr>\n\t\t<tr>\n\t\t<td>Department: <select name=\"itemid\" id=\"itemid\"\">\n\t\t<option value=\"All\" >All</option>";
populate_select("details", "itemid", "item", $details);
echo "</select></td>\n\t\t<td>Date:<input name=\"date\" id=\"date\" type=\"text\" size=\"10\" readonly=\"true\">\n\t\t<small><a href=\"javascript:showCal('Calendar8')\"> <img src=\"images/ew_calendar.gif\" width=\"16\&q
|
客服电话
APP下载
官方微信
请发表评论