<?php
session_start();
require_once 'libs/ez_sql_core.php';
require_once 'libs/ez_sql_mysql.php';
$conn = new ezSQL_mysql('root', '', 'jvs_tutoriales');
$usuario = $conn->get_row("SELECT id_usuario, nombre, apellido FROM usuarios WHERE login = '******'login'] . "' AND password = '******'pwd']) . "'");
if ($usuario) {
$_SESSION['usuario_logeado'] = $usuario;
echo json_encode($usuario);
} else {
echo json_encode(array('error' => true));
}
<title>web chat</title>
<link rel="stylesheet" type="text/css" href="login.css">
<script type="text/javascript" src="js/jquery-1.9.1.min.js"></script>
<script type="text/javascript" src="js/jquery-ui.min.js"></script>
<script type="text/javascript" src="js/index.js"></script>
</head>
<body>
<div id="left">
<a href="login.php?logout=yes">return</a>
<ul id="Myinfo" curuserid="<?php
echo $curid;
?>
">
<?php
$db = new ezSQL_mysql();
$res = $db->get_row("select * from userinfo where id={$curid}");
$MyHeadImage = $res->userHeadImage;
$myshuoshuo = $res->myShuoshuo;
echo "\n \t\t\t\t<div class='MyHeadImage'><img src='{$MyHeadImage}' curHeadImageUrl='" . $MyHeadImage . "' class='headImg' /></div>\n \t\t\t <div class='mYXinxi'>\n \t\t\t\t\t <p class='nicheng'>" . $curnicheng . "</p>\n <div class='xinxiA'> \n <span class='qianming'>" . $myshuoshuo . "</span>\n <i class='xiugai'>修改</i>\n </div>\n \t\t\t\t</div>\n \t\t\t";
?>
</ul>
<ul id="friendslist">
<ul id="onlinefriendslist">
<?php
// echo $curid;
$db = new ezSQL_mysql();
$res = $db->get_results("select userinfo.id,userinfo.userNickname,userinfo.userHeadImage,friendsinfo.friendNoteName,friendsinfo.friendid, friendsinfo.friendShuoshuo,userinfo.userState from userinfo,friendsinfo where userinfo.id=friendsinfo.friendid and friendsinfo.userid={$curid} ");
$onlineHtml = "";
$offlineHtml = "";
if ($res) {
session_start();
$curuserid = isset($_SESSION["curuserid"]) ? $_SESSION["curuserid"] : "";
$curusername = isset($_SESSION["curusername"]) ? $_SESSION["curusername"] : "";
$flag = isset($_POST["flag"]) ? $_POST["flag"] : "";
$chatMsg = isset($_POST["chatMsg"]) ? $_POST["chatMsg"] : "";
$chatMsg = str_replace("'", "\\'", $chatMsg);
$receiverId = isset($_POST["receiverId"]) ? $_POST["receiverId"] : "";
$setReadSenderid = isset($_POST["setReadSenderid"]) ? $_POST["setReadSenderid"] : "";
$userid = isset($_POST["userid"]) ? $_POST["userid"] : "";
$userpwd = isset($_POST["userpwd"]) ? $_POST["userpwd"] : "";
//验证登录
if ($flag == "checkUser") {
if ($userid != "" && $userpwd != "") {
$db = new ezSQL_mysql();
$sql = "select * from userinfo where id='" . $userid . "' and userpwd='" . $userpwd . "'";
$res = $db->get_row($sql);
if (!$res) {
echo "fail";
} else {
//echo "success";
$_SESSION["curuserid"] = $userid;
$_SESSION["curusername"] = $res->userNickname;
$changeloginsql = "UPDATE userinfo SET userState = '在线' WHERE id = '" . $userid . "'";
$db->query($changeloginsql);
header("location:../index.php?username="******"sendMsg") {
$result["room"] = $room;
$result["value"] = $value;
$codes = array();
for ($i = 0; $i < $amount; $i++) {
$code = genCode();
$var = $db->get_var("SELECT count(*) FROM goldcode where code='{$code}'");
if (0 == $var) {
$codes[$i] = $code;
$db->query("INSERT INTO goldcode (code,value,game,room) VALUES ('{$code}','{$value}','{$game}','{$room}')");
} else {
$i--;
}
}
$result["codes"] = $codes;
} else {
if ($act = "usecode") {
$row = $db->get_row("SELECT `code`,`value` FROM goldcode where " . " `code`='{$code}' and `valid`=1 and `game`='{$game}' and `room`='{$room}'");
if (null != $row) {
$result["ret"] = "0";
$result["game"] = $game;
$result["room"] = $room;
$result["value"] = $row["value"];
$db->query("UPDATE goldcode set `user` ='{$user}',`usetime`='',`valid`=0 WHERE `code`='{$code}'");
} else {
$result['ret'] = "2";
$result['msg'] = "兑换码不正确，或已使用";
}
} else {
}
}
echo json_encode($result);
<?php
define('DB_USER', '');
define('DB_PASSWORD', '');
define('DB_NAME', '');
define('DB_HOST', 'localhost');
define('PLAYERS_TABLE', 'sauer_players');
require_once 'ez_sql_core.php';
require_once 'ez_sql_mysql.php';
$db = new ezSQL_mysql(DB_USER, DB_PASSWORD, DB_NAME, DB_HOST);
$name = $db->escape($_GET['name']);
$ip = $db->escape($_GET['ip']);
$row = $db->get_row("SELECT * FROM `" . PLAYERS_TABLE . "` WHERE `name` = '{$name}' AND `ip` = '{$ip}'");
if ($row) {
$db->query("UPDATE `" . PLAYERS_TABLE . "` SET `last_connect` = NOW(), `connects` = '" . ($row->connects + 1) . "' WHERE `id` = '{$row->id}'");
} else {
$db->query("INSERT INTO `" . PLAYERS_TABLE . "` (`name`, `ip`, `first_connect`, `last_connect`, `connects`) VALUES('{$name}', '{$ip}', NOW(), NOW(), 1)");
}
echo "Done.";
function class_SitemapGenerator($parent, $menu, $URLNameParent)
{
global $SitemapGenerator;
global $subSite;
global $Language;
$html = "";
$set_Item_Template_Before = $SitemapGenerator['set_Item_Template_Before'];
$set_Item_Template_After = $SitemapGenerator['set_Item_Template_After'];
$PrefixURL = $subSite . $Language . '/';
require_once "db.php";
require_once "_CmsDevCore/Glosary.php";
require_once "_CmsDevCore/SQL/shared/ez_sql_core.php";
// (MYSQL CONNECT)////////////////////////////////////////////////////////////////////////////////////
require_once "_CmsDevCore/SQL/mysql/ez_sql_mysql.php";
$SKTDB = new ezSQL_mysql(DB_USER, DB_PASSWORD, DB_NAME, DB_SERVER);
if (isset($menu['parents'][$parent])) {
$html .= $SitemapGenerator['Wrap_Before'];
foreach ($menu['parents'][$parent] as $itemId) {
if (!isset($menu['parents'][$itemId])) {
$Thisitem = $set_Item_Template_Before;
//$Thisitem = str_replace('[URL]',$PrefixURL.$menu['items'][$itemId]['URLName'],$Thisitem);
$PSID1 = $menu['items'][$itemId]['SID'];
if (isset($PSID1) && $PSID1 != '') {
$ParentURLThisProd = $PSID1 . '/' . $menu['items'][$itemId]['URLName'];
$PSID2 = $SKTDB->get_row("SELECT SID, URLName FROM " . DB_PREFIX . "sections WHERE ID = '{$PSID1}'");
if (isset($PSID2->SID) && $PSID2->SID != '') {
$ParentURLThisProd = $PSID2->URLName . '/' . $PSID1->URLName . '/' . $menu['items'][$itemId]['URLName'];
$PSID3 = $SKTDB->get_row("SELECT SID, URLName FROM " . DB_PREFIX . "sections WHERE ID = '{$PSID2->SID}'");
if (isset($PSID3->SID) && $PSID3->SID != '') {
$ParentURLThisProd = $PSID3->URLName . '/' . $PSID2->URLName . '/' . $PSID1->URLName . '/' . $menu['items'][$itemId]['URLName'];
$PSID4 = $SKTDB->get_row("SELECT SID, URLName FROM " . DB_PREFIX . "sections WHERE ID = '{$PSID3->SID}'");
if (isset($PSID4->SID) && $PSID4->SID != '') {
$ParentURLThisProd = $PSID4->URLName . '/' . $PSID3->URLName . '/' . $PSID2->URLName . '/' . $PSID1->URLName . '/' . $menu['items'][$itemId]['URLName'];
}
}
}
}
$ParentURLThisProd = str_replace('//', '/', $ParentURLThisProd);
$Thisitem = str_replace('[URL]', $PrefixURL . $ParentURLThisProd, $Thisitem);
$html .= $Thisitem . $set_Item_Template_After . " ";
$html = str_replace('Portada/', '', $html);
}
if (isset($menu['parents'][$itemId])) {
$Thisitem = $set_Item_Template_Before;
//$Thisitem = str_replace('[URL]',$PrefixURL.$menu['items'][$itemId]['URLName'],$Thisitem);
$PSID1 = $menu['items'][$itemId]['SID'];
if (isset($PSID1) && $PSID1 != '') {
$ParentURLThisProd = $PSID1 . '/' . $menu['items'][$itemId]['URLName'];
$PSID2 = $SKTDB->get_row("SELECT SID, URLName FROM " . DB_PREFIX . "sections WHERE ID = '{$PSID1}'");
if (isset($PSID2->SID) && $PSID2->SID != '') {
$ParentURLThisProd = $PSID2->URLName . '/' . $PSID1->URLName . '/' . $menu['items'][$itemId]['URLName'];
$PSID3 = $SKTDB->get_row("SELECT SID, URLName FROM " . DB_PREFIX . "sections WHERE ID = '{$PSID2->SID}'");
if (isset($PSID3->SID) && $PSID3->SID != '') {
$ParentURLThisProd = $PSID3->URLName . '/' . $PSID2->URLName . '/' . $PSID1->URLName . '/' . $menu['items'][$itemId]['URLName'];
$PSID4 = $SKTDB->get_row("SELECT SID, URLName FROM " . DB_PREFIX . "sections WHERE ID = '{$PSID3->SID}'");
if (isset($PSID4->SID) && $PSID4->SID != '') {
$ParentURLThisProd = $PSID4->URLName . '/' . $PSID3->URLName . '/' . $PSID2->URLName . '/' . $PSID1->URLName . '/' . $menu['items'][$itemId]['URLName'];
}
}
}
}
$ParentURLThisProd = str_replace('//', '/', $ParentURLThisProd);
$Thisitem = str_replace('[URL]', $PrefixURL . $ParentURLThisProd, $Thisitem);
$html .= $Thisitem . " ";
$html .= class_SitemapGenerator($itemId, $menu, $menu['items'][$itemId]['URLName'] . '/');
$html .= $set_Item_Template_After . " ";
$html = str_replace('Portada/', '', $html);
}
}
$html .= $SitemapGenerator['Wrap_After'] . "";
}
return $html;
}
if ($flag == "hasreadSysmsgtalk") {
//将msg_talk|XXX 改为hasread|msg_talk|XXX
$sql = "update messageinfo set msgContent = concat('hasread|',msgContent) ";
$sql .= "where msgSendId = " . $msgSendId . " and msgReceiveId =" . $msgReceiveId . " ";
$sql .= "and readFlag = 'unread' and msgContent like 'msg_talk|%'";
$result = $db_msg->query($sql);
if ($result) {
echo "success";
} else {
echo "fail";
}
}
//验证登陆信息
if ($flag == "checkUser") {
$sql = "select * from userInfo where userId = " . $userId . " and userPwd = '" . $userpwd . "'";
$result = $db_msg->get_row($sql);
if (!$result) {
echo "fail";
} else {
$_SESSION["userid"] = $result->userId;
$_SESSION["username"] = $result->userName;
$_SESSION["userheadimg"] = $result->userHeadImg;
$_SESSION["usershuo"] = $result->userShuo;
echo "success";
}
die;
}
//清空SESSION
if ($flag == "clearSession") {
$_SESSION["userid"] = "";
unset($_SESSION["username"]);
<?php
require_once 'lib/ez_sql_core.php';
require_once 'lib/ez_sql_mysql.php';
$db = new ezSQL_mysql('root', '', 'jvs_tutoriales');
$lista = $db->get_row("SELECT * FROM opciones WHERE id_opcion = '1'");
?>
<!DOCTYPE html>
<html lang="es">
<head>
<meta charset="UTF-8">
<link href="css/style.css" rel="stylesheet">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.min.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.13/jquery-ui.min.js"></script>
<script>
$(function(){
$('#lista').sortable({
placeholder: 'placeholder',
update: function() {
$.post('ajax.php', $(this).sortable('serialize'));
}
});
});
</script>
<title>JV Software | Tutorial 10</title>
</head>
<body>
<ul id="lista">
<?php
if (!$lista->menu) {
?>
