Exemplos de código com mysqlquery em PHP

Exemplo n.º 1

0

Exibir arquivo

Arquivo: class_rafl.php Projeto: nadavkav/MoodleTAO

 function get_success_happy_drop_down($arg_success_item_id, $arg_share_id)
 {
     if (strlen($arg_success_item_id)) {
         // Gimme rafl happy results
         $query = "SELECT DISTINCT {$_SESSION['RealS_prefix']}members.mb_firstname, {$_SESSION['RealS_prefix']}members.mb_surmame\r\n\t\t\t\t          FROM {$_SESSION['RealS_prefix']}items\r\n\t\t\t\t          \tINNER JOIN {$_SESSION['RealS_prefix']}webcells ON {$_SESSION['RealS_prefix']}webcells.webcell_id = {$_SESSION['RealS_prefix']}items.item_webcell\r\n\t\t\t\t          \tINNER JOIN {$_SESSION['RealS_prefix']}rafl_res ON {$_SESSION['RealS_prefix']}items.item_id = {$_SESSION['RealS_prefix']}rafl_res.rafl_res_item \r\n\t\t\t\t          \tINNER JOIN {$_SESSION['RealS_prefix']}items AS successes ON successes.item_id = {$_SESSION['RealS_prefix']}items.item_parent_item \r\n\t\t\t\t          \tINNER JOIN {$_SESSION['RealS_prefix']}items AS tasks ON tasks.item_id = successes.item_parent_item \r\n\t\t\t\t          \tINNER JOIN {$_SESSION['RealS_prefix']}items AS units ON units.item_id = tasks.item_parent_item \r\n\t\t\t\t          \tINNER JOIN {$_SESSION['RealS_prefix']}share ON {$_SESSION['RealS_prefix']}share.share_item = units.item_id \r\n\t\t\t\t          \tINNER JOIN {$_SESSION['RealS_prefix']}share_cohort_members ON ({$_SESSION['RealS_prefix']}share_cohort_members.s_c_m_share = {$_SESSION['RealS_prefix']}share.share_id AND {$_SESSION['RealS_prefix']}webcells.webcell_member = {$_SESSION['RealS_prefix']}share_cohort_members.s_c_m_member)\r\n\t\t\t\t          \tINNER JOIN {$_SESSION['RealS_prefix']}members ON {$_SESSION['RealS_prefix']}members.mb_id = {$_SESSION['RealS_prefix']}share_cohort_members.s_c_m_member\r\n\t\t\t\t          WHERE {$_SESSION['RealS_prefix']}items.item_parent_item = " . GetSQLValueString($arg_success_item_id, "int") . "\r\n\t\t\t\t          \tAND {$_SESSION['RealS_prefix']}share.share_id =  " . GetSQLValueString($arg_share_id, 'int') . "\r\n\t\t\t\t          \tAND {$_SESSION['RealS_prefix']}members.mb_type != 'cohort'\r\n\t\t\t\t          \tAND {$_SESSION['RealS_prefix']}items.item_default_type = 6\r\n\t\t\t\t          \tAND rafl_res_rate = 2\r\n\t\t\t\t          ORDER BY {$_SESSION['RealS_prefix']}members.mb_firstname, {$_SESSION['RealS_prefix']}members.mb_surmame";
         // Debugging
         //echo $query;
         $mysql = new mysqlquery();
         $rows = $mysql->getrows($query);
         if (count($rows)) {
             $drop_down = '<select size="1" class="who_is">';
             //$drop_down .= '		<option>who is happy?</option>';
             foreach ($rows as $row) {
                 $drop_down .= '	<option>' . trim($row['mb_firstname'] . ' ' . $row['mb_surmame']) . '</option>';
             }
             $drop_down .= '</select>';
             return $drop_down;
         } else {
             return '&nbsp;';
         }
     } else {
         return '&nbsp;';
     }
 }

Exemplo n.º 2

0

Exibir arquivo

Arquivo: ListError.php Projeto: novnan/meiju

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
require "../" . LoadLang("pub/fun.php");
require "../../data/dbcache/class.php";
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//ehash
$ecms_hashur = hReturnEcmsHashStrAll();
//验证权限
CheckLevel($logininid, $loginin, $classid, "downerror");
//删除单个报告
function DelError($errorid, $userid, $username)
{
    global $empire, $dbtbpre;
    //验证权限
    CheckLevel($userid, $username, $classid, "downerror");
    $errorid = (int) $errorid;
    if (empty($errorid)) {
        printerror("EmptyDelErrorid", "history.go(-1)");

Exemplo n.º 3

0

Exibir arquivo

Arquivo: BqtempClass.php Projeto: novnan/meiju

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//ehash
$ecms_hashur = hReturnEcmsHashStrAll();
//验证权限
CheckLevel($logininid, $loginin, $classid, "template");
$sql = $empire->query("select classid,classname from {$dbtbpre}enewsbqtempclass order by classid desc");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title></title>
<link href="../adminstyle/<?php 
echo $loginadminstyleid;
?>
/adminstyle.css" rel="stylesheet" type="text/css">

Exemplo n.º 4

0

Exibir arquivo

Arquivo: ListMoreport.php Projeto: novnan/meiju

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
require "../" . LoadLang("pub/fun.php");
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//ehash
$ecms_hashur = hReturnEcmsHashStrAll();
//验证权限
CheckLevel($logininid, $loginin, $classid, "moreport");
//增加访问端
function AddMoreport($add, $userid, $username)
{
    global $empire, $dbtbpre;
    if (!$add[pname] || !$add[ppath] || !$add[purl] || !$add[postpass] || !$add[tempgid]) {
        printerror("EmptyMoreport", "history.go(-1)");
    }
    //验证权限
    CheckLevel($userid, $username, $classid, "moreport");
    $add['pname'] = hRepPostStr($add['pname'], 1);

Exemplo n.º 5

0

Exibir arquivo

Arquivo: AddInfoClass.php Projeto: novnan/meiju

<?php

define('EmpireCMSAdmin', '1');
require "../class/connect.php";
require "../class/db_sql.php";
require "../class/functions.php";
require "../data/dbcache/class.php";
$link = db_connect();
$empire = new mysqlquery();
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//ehash
$ecms_hashur = hReturnEcmsHashStrAll();
//验证权限
CheckLevel($logininid, $loginin, $classid, "cj");
//显示无限级结点[增加结点时]
function ShowClass_AddInfoClass($obclassid, $bclassid, $exp, $enews = 0)
{
    global $empire, $dbtbpre;
    if (empty($bclassid)) {
        $bclassid = 0;
        $exp = "|-";
    } else {
        $exp = "&nbsp;&nbsp;" . $exp;
    }
    $sql = $empire->query("select classid,classname,bclassid from {$dbtbpre}enewsinfoclass where bclassid='{$bclassid}' order by classid");

Exemplo n.º 6

0

Exibir arquivo

Arquivo: SearchKey.php Projeto: novnan/meiju

<?php

define('EmpireCMSAdmin', '1');
require "../class/connect.php";
require "../class/db_sql.php";
require "../class/functions.php";
require LoadLang("pub/fun.php");
require "../data/dbcache/class.php";
$link = db_connect();
$empire = new mysqlquery();
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//ehash
$ecms_hashur = hReturnEcmsHashStrAll();
//验证权限
CheckLevel($logininid, $loginin, $classid, "searchkey");
//删除搜索关键字
function DelSearchKey($onclick, $userid, $username)
{
    global $empire, $dbtbpre;
    //验证权限
    CheckLevel($userid, $username, $classid, "searchkey");
    $onclick = (int) $onclick;
    if (empty($onclick)) {
        printerror("EmptySearchOnclick", "history.go(-1)");
    }

Exemplo n.º 7

0

Exibir arquivo

Arquivo: ListMember.php Projeto: novnan/meiju

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
require "../../member/class/user.php";
require "../" . LoadLang("pub/fun.php");
require "../../data/dbcache/MemberLevel.php";
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//ehash
$ecms_hashur = hReturnEcmsHashStrAll();
//验证权限
CheckLevel($logininid, $loginin, $classid, "member");
$addgethtmlpath = "../";
$enews = $_POST['enews'];
if (empty($enews)) {
    $enews = $_GET['enews'];
}
//导入处理会员函数
if ($enews) {
    hCheckEcmsRHash();

Exemplo n.º 8

0

Exibir arquivo

Arquivo: MemberShowFeedback.php Projeto: BGCX261/zjh-dev-svn-to-git

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
require "../../class/user.php";
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//验证权限
CheckLevel($logininid, $loginin, $classid, "spacedata");
$fid = (int) $_GET['fid'];
$r = $empire->fetch1("select fid,name,company,phone,fax,email,address,zip,title,ftext,userid,ip,uid,uname,addtime,userid from {$dbtbpre}enewsmemberfeedback where fid='{$fid}'");
if (!$r['fid']) {
    printerror('ErrorUrl', '', 1);
}
if ($r['uid']) {
    $r['uname'] = "<a href='../../space/?userid={$r['uid']}' target='_blank'>{$r['uname']}</a>";
} else {
    $r['uname'] = '游客';
}
$ur = $empire->fetch1("select " . $user_username . " from " . $user_tablename . " where " . $user_userid . "='{$r['userid']}'");
$username = doUtfAndGbk($ur[$user_username], 1);

Exemplo n.º 9

0

Exibir arquivo

Arquivo: AddBuyGroup.php Projeto: novnan/meiju

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//ehash
$ecms_hashur = hReturnEcmsHashStrAll();
//验证权限
CheckLevel($logininid, $loginin, $classid, "buygroup");
$enews = ehtmlspecialchars($_GET['enews']);
$r[gmoney] = 10;
$r[gfen] = 0;
$r[gdate] = 0;
$url = "<a href=ListBuyGroup.php" . $ecms_hashur['whehref'] . ">管理充值类型</a> &gt; 增加充值类型";
if ($enews == "EditBuyGroup") {
    $id = (int) $_GET['id'];
    $r = $empire->fetch1("select * from {$dbtbpre}enewsbuygroup where id='{$id}' limit 1");
    $url = "<a href=ListBuyGroup.php" . $ecms_hashur['whehref'] . ">管理充值类型</a> &gt; 修改充值类型";
}
//----------会员组

Exemplo n.º 10

0

Exibir arquivo

Arquivo: ListMemberGroup.php Projeto: BGCX261/zjh-dev-svn-to-git

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
require "../../class/user.php";
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//验证权限
CheckLevel($logininid, $loginin, $classid, "member");
$url = "<a href=ListMemberGroup.php>管理会员组</a>";
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>管理会员组</title>
<link href="../adminstyle/<?php 
echo $loginadminstyleid;
?>
/adminstyle.css" rel="stylesheet" type="text/css">
</head>

Exemplo n.º 11

0

Exibir arquivo

Arquivo: player.php Projeto: novnan/meiju

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//ehash
$ecms_hashur = hReturnEcmsHashStrAll();
//验证权限
CheckLevel($logininid, $loginin, $classid, "player");
//验证文件
function CheckPlayerFilename($filename)
{
    if (strstr($filename, "\\") || strstr($filename, "/") || strstr($filename, "..")) {
        printerror("PlayerFileNotExist", "history.go(-1)");
    }
    //文件是否存在
    if (!file_exists("../../DownSys/play/" . $filename)) {
        printerror("PlayerFileNotExist", "history.go(-1)");
    }
}

Exemplo n.º 12

0

Exibir arquivo

Arquivo: MemberGbook.php Projeto: novnan/meiju

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//ehash
$ecms_hashur = hReturnEcmsHashStrAll();
//验证权限
CheckLevel($logininid, $loginin, $classid, "spacedata");
//删除留言
function hDelMemberGbook($add, $userid, $username)
{
    global $empire, $dbtbpre;
    $gid = intval($add['gid']);
    if (!$gid) {
        printerror("NotDelMemberGbookid", "history.go(-1)");
    }
    $sql = $empire->query("delete from {$dbtbpre}enewsmembergbook where gid='{$gid}'");
    if ($sql) {
        //操作日志

Exemplo n.º 13

0

Exibir arquivo

Arquivo: changetable.php Projeto: tanny2015/DataStructure

<?php

require 'global.php';
echo '';
require 'class/connect.php';
require 'class/db_sql.php';
require 'class/functions.php';
$rnd = $lur['rnd'];
$link = db_connect();
$empire = new mysqlquery();
$mydbname = RepPostVar($_GET['mydbname']);
if (empty($mydbname)) {
    printerror('NotChangeDb', 'history.go(-1)');
}
$udb = $empire->query('use `' . $mydbname . '`');
$mypath = $mydbname . '_' . date('YmdHis');
if ($phpsafemod) {
    $mypath = 'safemod';
}
$loadfile = RepPostVar($_GET['savefilename']);
if (strstr($loadfile, '.') || strstr($loadfile, '/') || strstr($loadfile, "\\")) {
    $loadfile = '';
}
if (empty($loadfile)) {
    $loadfile = 'def';
}
$loadfile = 'setsave/' . $loadfile;
@(include $loadfile);
if ($dmypath) {
    $mypath = $dmypath;
}

Exemplo n.º 14

0

Exibir arquivo

Arquivo: index.php Projeto: novnan/meiju

<?php

require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/q_functions.php";
require "../../member/class/user.php";
require "../../data/dbcache/class.php";
require "../../data/dbcache/MemberLevel.php";
require "../class/DownSysFun.php";
eCheckCloseMods('down');
//关闭模块
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
$ecmsreurl = 2;
//验证IP
eCheckAccessDoIp('downinfo');
$id = (int) $_GET['id'];
$pathid = (int) $_GET['pathid'];
$classid = (int) $_GET['classid'];
if (!$classid || empty($class_r[$classid][tbname]) || !$id) {
    echo "<script>alert('此信息不存在');window.close();</script>";
    exit;
}
$mid = $class_r[$classid][modid];
$tbname = $class_r[$classid][tbname];
$query = "select * from {$dbtbpre}ecms_" . $tbname . " where id='{$id}' limit 1";
$r = $empire->fetch1($query);
if (!$r['id'] || $r['classid'] != $classid) {
    echo "<script>alert('此信息不存在');window.close();</script>";
    exit;

Exemplo n.º 15

0

Exibir arquivo

Arquivo: PayApi.php Projeto: BGCX261/zjh-dev-svn-to-git

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//验证权限
CheckLevel($logininid, $loginin, $classid, "pay");
//设置接口
function EditPayApi($add, $userid, $username)
{
    global $empire, $dbtbpre;
    $add[payid] = (int) $add[payid];
    if (empty($add[payname]) || !$add[payid]) {
        printerror("EmptyPayApi", "history.go(-1)");
    }
    $add[isclose] = (int) $add[isclose];
    $add[myorder] = (int) $add[myorder];
    $add[paymethod] = (int) $add[paymethod];
    $sql = $empire->query("update {$dbtbpre}enewspayapi set isclose='{$add['isclose']}',payname='{$add['payname']}',paysay='{$add['paysay']}',payuser='******'payuser']}',paykey='{$add['paykey']}',payfee='{$add['payfee']}',payemail='{$add['payemail']}',myorder='{$add['myorder']}',paymethod='{$add['paymethod']}' where payid='{$add['payid']}'");
    if ($sql) {

Exemplo n.º 16

0

Exibir arquivo

Arquivo: PostUrlData.php Projeto: BGCX261/zjh-dev-svn-to-git

<?php

define('EmpireCMSAdmin', '1');
require "../class/connect.php";
require "../class/db_sql.php";
require "../class/functions.php";
$link = db_connect();
$empire = new mysqlquery();
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//验证权限
CheckLevel($logininid, $loginin, $classid, "postdata");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>远程发布</title>
<link href="adminstyle/<?php 
echo $loginadminstyleid;
?>
/adminstyle.css" rel="stylesheet" type="text/css">
<script>
function CheckAll(form)
  {
  for (var i=0;i<form.elements.length;i++)

Exemplo n.º 17

0

Exibir arquivo

Arquivo: ChangeTable.php Projeto: laiello/netos-cms

<?php

require "class/connect.php";
include "class/config.php";
include "class/db_sql.php";
include "class/functions.php";
$loginin = getcvar('bakusername');
$rnd = getcvar('bakrnd');
islogin($loginin, $rnd);
$link = db_connect();
$empire = new mysqlquery();
$mydbname = RepPostVar($_GET['mydbname']);
if (empty($mydbname)) {
    printerror("NotChangeDb", "history.go(-1)");
}
//选择数据库
$udb = $empire->query("use `" . $mydbname . "`");
//存放目录
$mypath = $mydbname . "_" . date("YmdHis");
if ($phpsafemod) {
    $mypath = "safemod";
}
//导入设置
$loadfile = RepPostVar($_GET['savefilename']);
if (strstr($loadfile, '.') || strstr($loadfile, '/') || strstr($loadfile, "\\")) {
    $loadfile = '';
}
if (empty($loadfile)) {
    $loadfile = 'def';
}
$loadfile = 'setsave/' . $loadfile;

Exemplo n.º 18

0

Exibir arquivo

Arquivo: AddNews.php Projeto: BGCX261/zjh-dev-svn-to-git

<?php

define('EmpireCMSAdmin', '1');
require "../class/connect.php";
require "../class/db_sql.php";
require "../class/functions.php";
require "../data/dbcache/class.php";
$link = db_connect();
$empire = new mysqlquery();
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
$enews = $_GET['enews'];
$classid = (int) $_GET['classid'];
if (empty($class_r[$classid][classid])) {
    printerror("ErrorUrl", "history.go(-1)");
}
//验证权限
$doselfinfo = CheckLevel($logininid, $loginin, $classid, "news");
if (!$class_r[$classid][tbname] || !$class_r[$classid][classid]) {
    printerror("ErrorUrl", "history.go(-1)");
}
//非终极栏目
if (!$class_r[$classid]['islast']) {
    printerror("AddInfoErrorClassid", "history.go(-1)");
}
$fun_r['AdminInfo'] = '管理信息';

Exemplo n.º 19

0

Exibir arquivo

Arquivo: AddTags.php Projeto: BGCX261/zjh-dev-svn-to-git

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//验证权限
CheckLevel($logininid, $loginin, $classid, "tags");
$enews = $_GET['enews'];
$postword = '增加TAGS';
$url = "<a href=ListTags.php>管理TAGS</a> &gt; 增加TAGS";
$fcid = (int) $_GET['fcid'];
//修改
if ($enews == "EditTags") {
    $postword = '修改TAGS';
    $tagid = (int) $_GET['tagid'];
    $r = $empire->fetch1("select tagid,tagname,cid from {$dbtbpre}enewstags where tagid='{$tagid}'");
    $url = "<a href=ListTags.php>管理TAGS</a> -&gt; 修改TAGS：<b>" . $r[tagname] . "</b>";
}
//分类
$csql = $empire->query("select classid,classname from {$dbtbpre}enewstagsclass order by classid");

Exemplo n.º 20

0

Exibir arquivo

Arquivo: index.php Projeto: novnan/meiju

<?php

require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/q_functions.php";
require "../class/user.php";
require "../../data/dbcache/class.php";
require "../" . LoadLang("pub/fun.php");
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
eCheckCloseMods('member');
//关闭模块
//是否登陆
$user = islogin();
$page = (int) $_GET['page'];
$page = RepPIntvar($page);
$start = 0;
$line = 25;
//每页显示条数
$page_line = 10;
//每页显示链接数
$offset = $page * $line;
//总偏移量
$totalquery = "select count(*) as total from {$dbtbpre}enewsdownrecord where userid='{$user['userid']}'";
$num = $empire->gettotal($totalquery);
//取得总条数
$query = "select * from {$dbtbpre}enewsdownrecord where userid='{$user['userid']}'";
$query = $query . " order by truetime desc limit {$offset},{$line}";
$sql = $empire->query($query);
$returnpage = page1($num, $line, $page_line, $start, $page, $search);

Exemplo n.º 21

0

Exibir arquivo

Arquivo: MemberFeedback.php Projeto: BGCX261/zjh-dev-svn-to-git

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//验证权限
CheckLevel($logininid, $loginin, $classid, "spacedata");
//删除反馈
function hDelMemberFeedback($add, $userid, $username)
{
    global $empire, $dbtbpre;
    $fid = intval($add['fid']);
    if (!$fid) {
        printerror("NotDelMemberFeedbackid", "history.go(-1)");
    }
    $sql = $empire->query("delete from {$dbtbpre}enewsmemberfeedback where fid='{$fid}'");
    if ($sql) {
        //操作日志
        insert_dolog("fid=" . $fid);
        printerror("DelMemberFeedbackSuccess", $_SERVER['HTTP_REFERER']);

Exemplo n.º 22

0

Exibir arquivo

Arquivo: index.php Projeto: novnan/meiju

<?php

require "../../class/connect.php";
$id = (int) $_GET['id'];
$classid = (int) $_GET['classid'];
$enews = $_GET['enews'];
if ($id && $classid) {
    include "../../class/db_sql.php";
    include "../../data/dbcache/class.php";
    include "../../class/q_functions.php";
    $link = db_connect();
    $empire = new mysqlquery();
    $editor = 1;
    if (empty($class_r[$classid][tbname]) || InfoIsInTable($class_r[$classid][tbname])) {
        printerror("ErrorUrl", "", 1);
    }
    //下一条记录
    if ($enews == "next") {
        $where = "id>{$id} and classid='{$classid}' order by id";
    } else {
        $where = "id<{$id} and classid='{$classid}' order by id desc";
    }
    $r = $empire->fetch1("select isurl,titleurl,classid,id from {$dbtbpre}ecms_" . $class_r[$classid][tbname] . " where " . $where . " limit 1");
    if (empty($r[id])) {
        printerror("NotNextInfo", "", 1);
    }
    $titleurl = sys_ReturnBqTitleLink($r);
    db_close();
    $empire = null;
    Header("Location:{$titleurl}");
}

Exemplo n.º 23

0

Exibir arquivo

Arquivo: index.php Projeto: BGCX261/zjh-dev-svn-to-git

<?php

require "../../../class/connect.php";
require "../../../class/q_functions.php";
require "../../../class/db_sql.php";
require "../../../class/user.php";
$link = db_connect();
$empire = new mysqlquery();
$editor = 2;
$user = islogin();
$mid = (int) $_GET['mid'];
$out = $_GET['out'];
if (empty($mid)) {
    printerror("HaveNotMsg", "", 1);
}
$r = $empire->fetch1("select mid,title,msgtext,from_userid,from_username,msgtime,haveread,issys from {$dbtbpre}enewsqmsg where mid={$mid} and to_username='******'username']}' limit 1");
if (empty($r[mid])) {
    printerror("HaveNotMsg", "", 1);
}
if ($r['issys']) {
    $r[from_username] = "<b>系统信息</b>";
}
if (!$r['haveread']) {
    $usql = $empire->query("update {$user_tablename} set " . $user_havemsg . "=0 where " . $user_userid . "='{$user['userid']}'");
    $usql = $empire->query("update {$dbtbpre}enewsqmsg set haveread=1 where mid={$mid}");
}
//导入模板
require ECMS_PATH . 'e/template/member/ViewMsg.php';
db_close();
$empire = null;

Exemplo n.º 24

0

Exibir arquivo

Arquivo: AddVotetemp.php Projeto: novnan/meiju

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//ehash
$ecms_hashur = hReturnEcmsHashStrAll();
//验证权限
CheckLevel($logininid, $loginin, $classid, "template");
$gid = (int) $_GET['gid'];
$gname = CheckTempGroup($gid);
$urlgname = $gname . "&nbsp;>&nbsp;";
$enews = ehtmlspecialchars($_GET['enews']);
$url = $urlgname . "<a href=ListVotetemp.php?gid={$gid}" . $ecms_hashur['ehref'] . ">管理投票模板</a>&nbsp;>&nbsp;增加投票模板";
//复制
if ($enews == "AddVoteTemp" && $_GET['docopy']) {
    $tempid = (int) $_GET['tempid'];
    $r = $empire->fetch1("select tempid,tempname,temptext from " . GetDoTemptb("enewsvotetemp", $gid) . " where tempid={$tempid}");
    $url = $urlgname . "<a href=ListVotetemp.php?gid={$gid}" . $ecms_hashur['ehref'] . ">管理投票模板</a>&nbsp;>&nbsp;复制投票模板：<b>" . $r[tempname] . "</b>";
}

Exemplo n.º 25

0

Exibir arquivo

Arquivo: ListSp.php Projeto: BGCX261/zjh-dev-svn-to-git

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
require "../" . LoadLang("pub/fun.php");
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//验证权限
CheckLevel($logininid, $loginin, $classid, "sp");
//返回用户组
function ReturnSpGroup($groupid)
{
    $count = count($groupid);
    if ($count == 0) {
        return '';
    }
    $ids = ',';
    for ($i = 0; $i < $count; $i++) {
        $ids .= $groupid[$i] . ',';
    }
    return $ids;

Exemplo n.º 26

0

Exibir arquivo

Arquivo: ListWfItem.php Projeto: BGCX261/zjh-dev-svn-to-git

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//验证权限
CheckLevel($logininid, $loginin, $classid, "workflow");
//返回用户组
function ReturnWfGroup($groupid)
{
    $count = count($groupid);
    if ($count == 0) {
        return '';
    }
    $ids = ',';
    for ($i = 0; $i < $count; $i++) {
        $ids .= $groupid[$i] . ',';
    }
    return $ids;
}

Exemplo n.º 27

0

Exibir arquivo

Arquivo: AddJstemp.php Projeto: BGCX261/zjh-dev-svn-to-git

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
//验证权限
CheckLevel($logininid, $loginin, $classid, "template");
$gid = (int) $_GET['gid'];
$gname = CheckTempGroup($gid);
$urlgname = $gname . "&nbsp;>&nbsp;";
$cid = $_GET['cid'];
$enews = $_GET['enews'];
$r[showdate] = "[m-d]";
$url = $urlgname . "<a href=ListJstemp.php?gid={$gid}>管理JS模板</a>&nbsp;>&nbsp;增加JS模板";
//复制
if ($enews == "AddJstemp" && $_GET['docopy']) {
    $tempid = (int) $_GET['tempid'];
    $r = $empire->fetch1("select * from " . GetDoTemptb("enewsjstemp", $gid) . " where tempid={$tempid}");
    $url = $urlgname . "<a href=ListJstemp.php?gid={$gid}>管理JS模板</a>&nbsp;>&nbsp;复制JS模板: " . $r[tempname];
}

Exemplo n.º 28

0

Exibir arquivo

Arquivo: ListBind.php Projeto: novnan/meiju

<?php

require "../class/connect.php";
require "../class/db_sql.php";
require "../class/q_functions.php";
require "../member/class/user.php";
$link = db_connect();
$empire = new mysqlquery();
eCheckCloseMods('member');
//关闭模块
eCheckCloseMods('mconnect');
//关闭模块
//是否登陆
$user = islogin();
$query = "select * from {$dbtbpre}enewsmember_connect_app where isclose=0 order by myorder,id";
$sql = $empire->query($query);
//导入模板
require ECMS_PATH . DASHBOARD . '/template/memberconnect/ListBind.php';
db_close();
$empire = null;

Exemplo n.º 29

0

Exibir arquivo

Arquivo: index.php Projeto: novnan/meiju

<?php

require "../class/connect.php";
require "../class/db_sql.php";
require "../class/q_functions.php";
require "../data/dbcache/class.php";
require LoadLang("pub/fun.php");
$link = db_connect();
$empire = new mysqlquery();
eCheckCloseMods('pl');
//关闭模块
//用户名
$lusername = getcvar('mlusername');
$lpassword = '';
if ($lusername) {
    $lusername = RepPostVar($lusername);
    $lpassword = md5($lusername);
}
$id = (int) $_GET['id'];
$classid = (int) $_GET['classid'];
//专题
$doaction = $_GET['doaction'] == 'dozt' ? 'dozt' : '';
$rewritedoaction = 'doinfo';
if ($doaction == 'dozt') {
    $rewritedoaction = 'dozt';
    if (empty($classid)) {
        printerror("ErrorUrl", "history.go(-1)", 1);
    }
    $n_r = $empire->fetch1("select ztid,ztname,intro,ztimg,ztpagekey,restb from {$dbtbpre}enewszt where ztid='{$classid}'");
    if (!$n_r['ztid']) {
        printerror("ErrorUrl", "history.go(-1)", 1);

Exemplo n.º 30

0

Exibir arquivo

Arquivo: ChangeTags.php Projeto: BGCX261/zjh-dev-svn-to-git

<?php

define('EmpireCMSAdmin', '1');
require "../../class/connect.php";
require "../../class/db_sql.php";
require "../../class/functions.php";
require '../' . LoadLang("pub/fun.php");
$link = db_connect();
$empire = new mysqlquery();
$editor = 1;
//验证用户
$lur = is_login();
$logininid = $lur['userid'];
$loginin = $lur['username'];
$loginrnd = $lur['rnd'];
$loginlevel = $lur['groupid'];
$loginadminstyleid = $lur['adminstyleid'];
$page = (int) $_GET['page'];
$start = 0;
$field = $_GET['field'];
$form = $_GET['form'];
$line = 50;
//每页显示条数
$page_line = 12;
//每页显示链接数
$offset = $page * $line;
//总偏移量
//搜索
$search = "&field={$field}&form={$form}";
$add = '';
//推荐

Exemplos de mysqlquery em PHP