/**
* Renders the addon author ranking
*
* @return string
*/
public function getTopDevelopersWidgetMarker()
{
$top5 = $this->db->get_results("SELECT *, COUNT( provider_name ) AS counttotal FROM addon WHERE 1=1 " . $this->configuration['addonExcludeClause'] . " GROUP BY provider_name ORDER BY counttotal DESC LIMIT 9");
$counter = 0;
$iconMap = array(1 => 'gold.png', 2 => 'silver.png', 3 => 'bronze.png');
if (is_array($top5) && count($top5)) {
$developers = '';
foreach ($top5 as $top5s) {
$author = cleanupAuthorName($top5s->provider_name);
$counter++;
$icon = 'images/' . (isset($iconMap[$counter]) ? $iconMap[$counter] : $counter . '.png');
$developers .= "<li><img src='{$icon}' height='20' width='20' alt='Rank {$counter}' /><a href='" . createLinkUrl('author', $author) . "' title='Show all addons from this author'> " . substr($author, 0, 15) . " ({$top5s->counttotal} uploads)</a></li>";
}
return $this->makeWidget('Top developers', '<ul class="topDevelopers">' . $developers . '</ul>');
}
return '';
}
function getUserData($secreatCode, $token, $device)
{
if (isset($secreatCode)) {
global $dbhost;
global $dbuser;
global $dbpassword;
global $db;
$deviceId = isset($_POST['deviceId']) ? $_POST['deviceId'] : '';
$code = explode('_', $secreatCode);
$userdb = new ezSQL_mysql($dbuser, $dbpassword, $code[0], $dbhost);
$query = "SELECT * FROM `user_info` WHERE `uniqueCode`= '" . $secreatCode . "'";
$result = $userdb->get_results($query, ARRAY_A);
if (!empty($result)) {
if ($result[0]['deviceId'] == '' && $deviceId !== '') {
$updateDeviceIdQuery = "UPDATE `user_info` SET `deviceId`= '" . $deviceId . "',`token`= '" . $token . "',`devicetype`= '" . $device . "' WHERE `uniqueCode`= '" . $secreatCode . "'";
$userdb->query($updateDeviceIdQuery);
$query1 = "SELECT `contactno` FROM `admin_database_info` WHERE `admindatabase`= '{$code['0']}" . "'";
$result1 = $db->get_results($query1, ARRAY_A);
unset($result[0]['password']);
unset($result[0]['deviceId']);
$data = $result[0];
$data['admin_contactNo'] = $result1[0]['contactno'];
$data['admin_jid'] = $code[0];
$final['data'] = $data;
$final['status'] = TRUE;
echo json_encode($final);
exit;
} elseif ($result[0]['deviceId'] !== '' && $result[0]['deviceId'] == $deviceId) {
$query1 = "SELECT `contactno` FROM `admin_database_info` WHERE `admindatabase`= '{$code['0']}" . "'";
$result1 = $db->get_results($query1, ARRAY_A);
unset($result[0]['password']);
unset($result[0]['deviceId']);
$data = $result[0];
$data['admin_contactNo'] = $result1[0]['contactno'];
$data['admin_jid'] = $code[0];
$final['data'] = $data;
$final['status'] = TRUE;
echo json_encode($final);
exit;
} elseif ($result[0]['deviceId'] !== '' && $result[0]['deviceId'] !== $deviceId) {
$data['status'] = FALSE;
$data['message'] = 'This account is already registered with another device';
echo json_encode($data);
exit;
} else {
$data['status'] = FALSE;
$data['message'] = 'device id not found';
echo json_encode($data);
exit;
}
} else {
$data['status'] = FALSE;
$data['message'] = 'Secret code is invalid!';
echo json_encode($data);
exit;
}
}
}
}
//发送信息
if ($flag == "sendMsg") {
$sql = "INSERT INTO messageinfo(msgContent,msgSender,msgReceiver) VALUES('{$chatMsg}', '{$curuserid}', '{$receiverId}')";
$res = $db->query($sql);
if ($res) {
echo "ok";
} else {
echo "fail";
}
die;
}
//接受信息
if ($flag == "getunreadMsg") {
$sql = "SELECT * FROM messageinfo,userinfo where msgReceiver='" . $curuserid . "' and msgState='unread' and userinfo.id=messageinfo.msgSender";
$res = $db->get_results($sql);
if ($res) {
echo json_encode($res);
} else {
echo "fail";
}
die;
}
//将信息设为已读
if ($flag == "setRead") {
$sql = "UPDATE messageinfo SET msgState='read' WHERE msgReceiver = '" . $curuserid . "' and msgSender='" . $setReadSenderid . "' ";
$res = $db->query($sql);
if ($res) {
echo "ok";
} else {
echo "fail";
Load up Libraries
**/
include_once "../libs/ez_sql_core.php";
include_once "../libs/ez_sql_mysql.php";
include_once "../libs/myfunctions.php";
// MySQL Connection
$mysql_server = $db_host . ":" . $db_port;
// server details
$db = new ezSQL_mysql($db_user, $db_pass, $db_name, $mysql_server);
// Username , password , DB
$debug = false;
// no debug by default.
// Table Checking...
$my_tables = $db->get_results("SHOW TABLES LIKE '%user%'", ARRAY_N);
// query db for user table
if (!$my_tables) {
// We have no tables, better create some....
/**
TABLE DEF:
id = unique user id
tw_at = Twitter Access Token
tw_sec = Twitter Secret Token
tw_account = Array of account info we want/store from Twitter
rs_wh = Rack Space Web Hook (Secret Token)
rs_account = Array of account info we want/store from Rack Space
**/
<?php
// ezSQL
require_once 'libs/ez_sql_core.php';
require_once 'libs/ez_sql_mysql.php';
// Zebra Pagination
require_once 'libs/Zebra_Pagination.php';
$conn = new ezSQL_mysql('root', '', 'jvs_tutoriales');
$total_paises = $conn->get_var('SELECT count(*) FROM paises');
$resultados = 6;
$paginacion = new Zebra_Pagination();
$paginacion->records($total_paises);
$paginacion->records_per_page($resultados);
// Quitar ceros en numeros con 1 digito en paginacion
$paginacion->padding(false);
$paises = $conn->get_results('SELECT * FROM paises LIMIT ' . ($paginacion->get_page() - 1) * $resultados . ', ' . $resultados);
?>
<!DOCTYPE html>
<html lang="es">
<head>
<meta charset="utf-8">
<title>JV Software | Tutorial 14</title>
<link rel="stylesheet" href="http://twitter.github.com/bootstrap/1.4.0/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
<style>
.mostrar-mas {
text-align: center;
background-color: #D9EDF7;
border: 1px solid #BCE8F1;
}
.mostrar-mas a {
$db = new ezSQL_mysql('db_user', 'db_pass', 'db_name');
// Cache expiry
$db->cache_timeout = 24;
// Note: this is hours
// Specify a cache dir. Path is taken from calling script
$db->cache_dir = 'ezsql_cache';
// (1. You must create this dir. first!)
// (2. Might need to do chmod 775)
// Global override setting to turn disc caching off
// (but not on)
$db->use_disk_cache = true;
// By wrapping up queries you can ensure that the default
// is NOT to cache unless specified
$db->cache_queries = true;
// At last.. a query!
$db->get_results("SHOW TABLES");
$db->debug();
// Select * from use
$db->get_results("SELECT * FROM User");
$db->debug();
// This ensures only the above querys are cached
$db->cache_queries = false;
// This query is NOT cached
$db->get_results("SELECT * FROM User LIMIT 0,1");
$db->debug();
/*
Of course, if you want to cache EVERYTHING just do..
$db = new ezSQL_mysql('db_user', 'db_pass', 'db_name');
$db->use_disk_cache = true;
$db->cache_queries = true;
$db->cache_timeout = 24;
<th style="width: 5%;">Dirección</th>
<th style="width: 5%;">Editar</th>
<th style="width: 5%;">Eliminar</th>
</tr>
</thead>
<tbody >
<?php
$conn = new ezSQL_mysql(DB_USER, DB_PASS, DB_NAME);
$total_usuarios = $conn->get_var('SELECT count(*) FROM user');
$resultados = 10;
$paginacion = new Zebra_Pagination();
$paginacion->records($total_usuarios);
$paginacion->records_per_page($resultados);
// Quitar ceros en numeros con 1 digito en paginacion
$paginacion->padding(false);
$usuarios = $conn->get_results('SELECT * FROM user LIMIT ' . ($paginacion->get_page() - 1) * $resultados . ', ' . $resultados);
foreach ($usuarios as $users) {
echo ' <tr >
<td>' . $users->names . '</td>
<td>' . $users->last_names . '</td>
<td>' . $users->email . '</td>
<td>' . $users->cel_phone . '</td>
<td>' . $users->address . '</td>
<td><a href="?view=usuario&mode=edit&id_user='******'" class="btn btn-success" data-toggle="modal" data-target="?view=usuario"><span class="glyphicon glyphicon-pencil"></span></a> </td>
<td> <a href="#" class="btn btn-danger" onclick="DeleteItem(\'¿Está seguro de eliminar este usuario?\',\'?view=usuario&mode=delete&id_user='******'\')"><span class="glyphicon glyphicon-trash"></span></a> </td>
</tr>';
}
?>
} else {
if ($page == 2 or $page == 3) {
if ($param_x == '0') {
$page = 0;
}
} else {
$page = 0;
}
}
}
// Cool, validated parameters exist, this doesn't mean they are truly valid however
if ($page == 1) {
// Start search query page
$playername = $db->escape($param_x);
$sql = "SELECT * FROM " . $config->my_war3source_table . " WHERE lower(concat(name)) like lower('%" . $playername . "%') LIMIT 20";
$result = $db->get_results($sql);
$sql = "SELECT shortname,name FROM " . $config->my_war3sourceraces_table;
$races = $db->get_results($sql);
//$db->debug();
?>
<table class="players_table">
<a href="index.php"><p style="text-align:center">Back to War3 Stats Main Page</p></a> <br />
<tr class="player_row">
<td class="td_name">Name</td>
<td class="td_steam">SteamID</td>
<?php
include_once 'ez_sql_core.php';
include_once 'ez_sql_mysql.php';
$host = $_SERVER['SERVER_NAME'];
$document_root = $_SERVER['DOCUMENT_ROOT'];
$db = new ezSQL_mysql('root', '', 'mymasterstu', 'localhost');
$user_id = 3;
$currentDate = "2015-10-16";
$online_users = array();
$results2 = $db->get_results('select at_id from admin where ad_id=' . $user_id . '');
if ($results2) {
foreach ($results2 as $user2) {
$at_id = $user2->at_id;
//$online_users[]=$at_id;
//echo "id=".$at_id;
}
} else {
}
$results = $db->get_results('select c.ucn_id,c.ucn_from,c.ucn_to from user_connections c where c.ucn_status=1 and ucn_from=' . $user_id . ' and "2015-10-15" in (select ucd_date from user_connection_dates where ucn_id=c.ucn_id and ucd_status=2)');
if ($results) {
foreach ($results as $user) {
$online_users[] = $user->ucn_id;
//$online_users[]=$user->ucn_from;
$online_users[] = $user->ucn_to;
}
} else {
}
$results1 = $db->get_results('select ad_id from admin where ad_id in( select distinct(ucn_to) from user_connections where ucn_from=' . $user_id . ' and ucn_status=1 ) and at_id=' . $at_id . '');
if ($results1) {
foreach ($results1 as $user1) {
<?php
include_once 'lib/ez_sql_core.php';
include_once 'lib/ez_sql_mysql.php';
$db = new ezSQL_mysql('root', '', 'jvs_tutoriales', 'localhost');
$productos = $db->get_results("SELECT * FROM products WHERE productName LIKE '%" . $_POST['query'] . "%'");
echo json_encode($productos);
require_once "_CmsDevCore/Admin_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);
$HTTP = "http://" . $_SERVER['HTTP_HOST'];
$subSite = '';
$Language = 'esp';
$SitemapGenerator = array();
$SitemapGenerator['Wrap_Before'] = "\t\n";
$SitemapGenerator['Wrap_After'] = "\t\n";
$SitemapGenerator['set_Item_Template_Before'] = "<url><loc>" . $HTTP . $subSite . "/[URL]</loc><changefreq>weekly</changefreq></url>";
$SitemapGenerator['set_Item_Template_After'] = "\t\n";
$ShowHidden = " RecycleBin = '0' AND";
// Select all entries from the menu table
$result = $SKTDB->get_results("SELECT ID,Title,Description,URLName,SID,Position\r\n\t\t\t\t\t\t FROM " . DB_PREFIX . "sections\r\n\t\t\t\t\t\t WHERE " . $ShowHidden . " Language = '" . $Language . "' \r\n\t\t\t\t\t\t ORDER BY SID, Position, Title", ARRAY_A);
if ($result) {
// Create a multidimensional array to conatin a list of items and parents
$menu = array('items' => array(), 'parents' => array());
// Builds the array lists with data from the menu table
foreach ($result as $items) {
// Creates entry into items array with current menu item id ie. $menu['items'][1]
$menu['items'][$items['ID']] = $items;
// Creates entry into parents array. Parents array contains a list of all items with children
$menu['parents'][$items['SID']][] = $items['ID'];
}
// Menu builder function, parentId 0 is the root
function class_SitemapGenerator($parent, $menu, $URLNameParent)
{
global $SitemapGenerator;
global $subSite;
$msgContent = isset($_POST["msgContent"]) ? $_POST["msgContent"] : "";
$db_msg = new ezSQL_mysql();
//验证Session信息
if ($flag == "checkSession") {
$sessionid = isset($_SESSION["userid"]) ? $_SESSION["userid"] : "";
if ($sessionid == "") {
echo "outline";
} else {
echo "{$sessionid}";
}
die;
}
//检测是否发来“系统消息”
if ($flag == "checkSysmsg") {
$sql = "select * from messageinfo where msgReceiveId = " . $userId . " and readFlag = 'unread' and msgContent like 'msg_%|%'";
$result = $db_msg->get_results($sql);
if ($result) {
echo json_encode($result);
die;
} else {
die;
}
}
//将处理过的“系统消息”改为已读
if ($flag == "hasreadSysmsg") {
if ($msgFlag != "msg_talk") {
$sql = "update messageinfo set readFlag = 'hasread' where id = " . $msgId . "";
$result = $db_msg->query($sql);
if ($result) {
echo "success";
} else {
$SKTDB = new ezSQL_mysql(DB_USER, DB_PASSWORD, DB_NAME);
// Cache expiry
$SKTDB->cache_timeout = 24;
// Note: this is hours
// Specify a cache dir. Path is taken from calling script
$SKTDB->cache_dir = 'ezsql_cache';
// (1. You must create this dir. first!)
// (2. Might need to do chmod 775)
// Global override setting to turn disc caching off
// (but not on)
$SKTDB->use_disk_cache = true;
// By wrapping up queries you can ensure that the default
// is NOT to cache unless specified
$SKTDB->cache_queries = true;
// At last.. a query!
$SKTDB->get_results("SHOW TABLES");
$SKTDB->debug();
// Select * from use
$SKTDB->get_results("SELECT * FROM v1_content");
$SKTDB->debug();
// This ensures only the above querys are cached
$SKTDB->cache_queries = false;
// This query is NOT cached
$SKTDB->get_results("SELECT * FROM v1_content LIMIT 0,1");
$SKTDB->debug();
/*
Of course, if you want to cache EVERYTHING just do..
$SKTDB = new ezSQL_mysql('db_user', 'db_pass', 'db_name');
$SKTDB->use_disk_cache = true;
<th style="width: 25%;">Descripción</th>
<th style="width: 5%;">Editar</th>
<th style="width: 5%;">Eliminar</th>
</tr>
</thead>
<tbody >
<?php
$conn = new ezSQL_mysql(DB_USER, DB_PASS, DB_NAME);
$total_cursos = $conn->get_var('SELECT count(*) FROM cursos');
$resultados = 10;
$paginacion = new Zebra_Pagination();
$paginacion->records($total_cursos);
$paginacion->records_per_page($resultados);
// Quitar ceros en numeros con 1 digito en paginacion
$paginacion->padding(false);
$lista_cursos = $conn->get_results('SELECT * FROM cursos LIMIT ' . ($paginacion->get_page() - 1) * $resultados . ', ' . $resultados);
foreach ($lista_cursos as $cursos) {
echo '<tr >
<td>' . $cursos->ficha . '</td>
<td>' . $cursos->nombre . '</td>
<td>' . $cursos->descripcion . '</td>
<td><a href="?view=cursos&mode=edit&id_curso=' . $cursos->id_curso . '" class="btn btn-success"><span class="glyphicon glyphicon-pencil"></span></a> </td>
<td> <a href="#" class="btn btn-danger" onclick="DeleteItem(\'¿Está seguro de eliminar este usuario?\',\'?view=cursos&mode=delete&id_curso=' . $cursos->id_curso . '\')"><span class="glyphicon glyphicon-trash"></span></a> </td>
</tr>';
}
?>
// David Martín :: Suki_ :: <david at sukiweb dot net>.
// GNU GENERAL PUBLIC LICENSE
require "config.php";
include_once "inc/ez_sql_core.php";
include_once "inc/ez_sql_mysql.php";
require "inc/functions.php";
require "inc/plugfunctions.php";
require "inc/check_behind_proxy.php";
require "inc/l10n.php";
$db = new ezSQL_mysql($config['db_user'], $config['db_password'], $config['db_database'], $config['db_server']);
load_default_textdomain();
session_start();
if ($_GET["login"] == "logout") {
logea("logout", "LOGOUT", $_SESSION["usuario"]);
$SELECT = "SELECT * FROM usuarios " . "WHERE usuario_login='******'usuario'] . "' " . "AND usuario_id='" . $_SESSION['usuario_id'] . "'";
$result = $db->get_results($SELECT);
$strCookie = base64_encode(join(':', array($result[0]->usuario_login, md5($config['domain'] . $result[0]->usuario_login . $result[0]->usuario_id . $result[0]->usuario_email))));
setcookie("bolsaPHP", $strCookie, time() - 3600);
unset($_SESSION['usuario']);
unset($_SESSION['nombre']);
unset($_SESSION['email']);
unset($_SESSION['url']);
unset($_SESSION['usuario_id']);
header("Cache-Control: no-cache, must-revalidate");
header("Location: index.php");
header("Expires: " . gmdate("r", time() - 3600));
header("ETag: \"logingout" . time() . "\"");
die;
} else {
if ($_POST[login] && $_POST[password]) {
$SELECT = "SELECT * FROM usuarios " . "WHERE usuario_login='******' " . "AND usuario_password='******'";
public function getRecentSession()
{
global $db;
global $dbhost;
global $dbpassword;
global $dbuser;
$adminemail = $admin = $_SESSION['admin_login'];
$getDbName = "select `admindatabase` from `admin_database_info` WHERE `email` = '" . $adminemail . "' AND `is_active`=1";
$daName = $db->get_col($getDbName);
$dbUser = new ezSQL_mysql($dbuser, $dbpassword, $daName[0], $dbhost);
$count = "SELECT user_session_details.email,user_session_details.id,user_session_details.grcid,user_info.name,user_info.company FROM `user_session_details` INNER JOIN `user_info` ON user_session_details.grcid = user_info.uniqueCode ORDER BY id DESC";
$result = $dbUser->get_results($count, ARRAY_A);
return $result;
}
<?php
require_once '../../app/Mage.php';
Mage::app('default');
include_once "../shared/ez_sql_core.php";
include_once "ez_sql_mysql.php";
$db = new ezSQL_mysql('nightingaleuser', 'elagnithgin', 'nightingale', 'localhost');
$authors = $db->get_results("SELECT * FROM Authors");
foreach ($authors as $author) {
$category = Mage::getModel('catalog/category');
$category->setStoreId(0);
//default/all
$subcategory['entity_id'] = 10000 + (int) $author->Author_ID;
$subcategory['name'] = $author->Name;
$subcategory['path'] = "1/4";
$subcategory['description'] = $author->Bio;
$subcategory['meta_title'] = "";
$subcategory['meta_keywords'] = $author->Meta_Keywords;
$subcategory['meta_description'] = $author->Meta_Description;
$subcategory['image'] = $author->Image_Thumbnail;
$subcategory['landing_page'] = "";
$subcategory['display_mode'] = "PRODUCTS";
$subcategory['is_active'] = 1;
$subcategory['is_anchor'] = 1;
$subcategory['url_key'] = "";
$category->addData($subcategory);
try {
$category->save();
echo "<p><strong>" . $category->getName() . " (" . $category->getId() . ")</strong> - Category Added</p>";
} catch (Exception $e) {
echo $e->getMessage() . 'Cat: ';
include_once 'lib/ez_sql_mysql.php';
// db_user / db_password / db_name / db_host
$db = new ezSQL_mysql('root', 'root', $argv[3], 'localhost');
// [
// {
// name,
// children: [
// { player },
// { ... }
// ]
// },
// { ... }
// ]
$output = array();
// Get all teams
$teams = $db->get_results("\n SELECT team\n FROM salaries\n GROUP BY team\n");
foreach ($teams as $team) {
if (!is_null($team->team)) {
$players = $db->get_results("\n SELECT statistics.*,\n salaries.salary\n FROM statistics\n LEFT JOIN salaries\n ON statistics.player = salaries.player\n WHERE statistics.team = '{$team->team}'\n ORDER BY statistics.team\n ");
if (!is_null($players)) {
$foo = new stdClass();
$foo->name = $team->team;
$foo->children = $players;
$output[] = $foo;
}
}
}
$filename = "data.{$argv['1']}-{$argv['2']}.json";
$path = dirname(dirname(dirname(__FILE__))) . '/app/data/' . $filename;
$file = file_put_contents($path, json_encode($output));
if ($file) {
}
$smarty->assign('name', $conf['title']);
$smarty->assign("userId", $userId);
$smarty->assign("userData", $userData);
$smarty->assign("userName", $startUp->session_username);
$smarty->assign("Admin", $isAdmin);
$smarty->assign('userUpload', $userData->upload);
$smarty->assign('userDownload', $userData->download);
if (!isset($_GET["catid"])) {
$_GET["catid"] = 'NULL';
}
$cat_id = $_GET["catid"];
$smarty->assign('getCategoriescollapsed', $startUp->Categories('getlistcollapsed', $cat_id));
$smarty->assign('setError', 'false');
$sql = "SELECT filename FROM plugins WHERE action = '" . $db->escape(1) . "'";
$items = $db->get_results($sql, ARRAY_A);
if ($items) {
foreach ($items as $result_rows) {
$plugins[] = $result_rows['filename'];
}
} else {
$plugins = '';
}
$hook->active_plugins = $plugins;
$hook->set_hooks(array('install', 'action', 'home_page', 'new_page', 'upload_page', 'torrents_page', 'detail_page', 'registration_page', 'login_page', 'account_page', 'edit_account_page', 'user_page', 'admin_action', 'new_admin_page', 'admin_settings_page'));
$hook->load_plugins();
function add_hook($tag, $function, $priority = 10)
{
global $hook;
$hook->add_hook($tag, $function, $priority);
}
<ul class="memberTab">
<li class="memberTabLi selectmemberTabLi">好友</li>
<li class="memberTabLi">群</li>
<li class="memberTabLi">讨论组</li>
</ul>
<ul class="memberTabNew">
<li class="memberTNBox selectmemTNBox">
<ul class="memberTNBU">
<li class="memberTNBULiGroup">
<?php
$sqlN = "SELECT * FROM userinfo,friendsinfo WHERE userinfo.id=friendsinfo.friendid and friendsinfo.userid=" . $_SESSION["userID"];
$onlineHtml = "";
$offlineHtml = "";
$allCount = 0;
$onlineCount = 0;
$resN = $db->get_results($sqlN);
foreach ($resN as $friend) {
//在线
if ($friend->userState == "online") {
$onlineHtml .= "<li class='listItem Ltq Ltqq" . $friend->friendid . "' showchatPanel='false' isshow='false'>";
$onlineHtml .= "<a href='#' class='avatar'>";
$onlineHtml .= "<img src=" . $friend->userHeadImage . ">";
$onlineHtml .= "</a>";
$onlineHtml .= "<p class='memberNick'>" . $friend->friendNoteName . "</p>";
$onlineHtml .= "<p class='memberMsg'>宇</p>";
$onlineHtml .= "</li>";
$onlineCount++;
$allCount++;
} elseif ($friend->userState == "offline") {
//离线
$offlineHtml .= "<li class='listItem Ltq Ltqq" . $friend->friendid . "' showchatPanel='false' isshow='false'>";
/**********************************************************************
* ezSQL initialisation for mySQL
*/
// Include ezSQL core
include_once "../shared/ez_sql_core.php";
// Include ezSQL database specific component
include_once "ez_sql_mysql.php";
// Initialise database object and establish a connection
// at the same time - db_user / db_password / db_name / db_host
$db = new ezSQL_mysql('db_user', 'db_password', 'db_name', 'db_host');
/**********************************************************************
* ezSQL demo for mySQL database
*/
// Demo of getting a single variable from the db
// (and using abstracted function sysdate)
$current_time = $db->get_var("SELECT " . $db->sysdate());
print "ezSQL demo for mySQL database run @ {$current_time}";
// Print out last query and results..
$db->debug();
// Get list of tables from current database..
$my_tables = $db->get_results("SHOW TABLES", ARRAY_N);
// Print out last query and results..
$db->debug();
// Loop through each row of results..
foreach ($my_tables as $table) {
// Get results of DESC table..
$db->get_results("DESC {$table['0']}");
// Print out last query and results..
$db->debug();
}
">
<?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) {
// echo "<script>alert('d')</script>";
foreach ($res as $friend) {
$curid = $friend->friendid;
$curHeadImageUrl = $friend->userHeadImage;
$curuserState = $friend->userState;
$curfriNickname = $friend->friendNoteName;
$curfrishuoshuo = $friend->friendShuoshuo;
if ($curuserState == "online") {
$onlineHtml .= "<li id='friendlitalk{$curid}' talkid='{$curid}' talkname='{$curfriNickname}' class='friendli' isshow='no' isappear='no' friendImg='" . $curHeadImageUrl . "'>\n \t\t\t\t\t\t\t\t\t\t\t\t\t<img src='{$curHeadImageUrl}' class='friHeadImge' />\n \t\t\t\t\t\t\t\t\t\t\t\t\t<div class='Friendxinxi'>\n <div class='FriendXX'>\n <span class='nicheng'>" . $curfriNickname . "</span>\n <span class='friendstate'>[ " . $curuserState . " ]</span>\n </div>\n \t\t\t\t\t\t\t\t\t\t \t\t\t\t<p class='qianming'>" . $curfrishuoshuo . "</p>\n \t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n \t\t\t\t\t\t\t\t \t\t </li>";
} else {
$offlineHtml .= "<li id='friendlitalk{$curid}' talkid='{$curid}' talkname='{$curfriNickname}' class='friendli' isshow='no' isappear='no' friendImg='" . $curHeadImageUrl . "'>\n \t\t\t\t\t\t\t\t\t\t\t\t\t<img src='{$curHeadImageUrl}' class='friHeadImge offlinePic' />\n \t\t\t\t\t\t\t\t\t\t\t\t\t<div class='Friendxinxi'>\n \t\t\t\t\t\t\t\t\t\t \t\t\t\t<div class='FriendXX'>\n <span class='nicheng'>" . $curfriNickname . "</span>\n <span class='friendstate'>[ " . $curuserState . " ]</span>\n </div>\n \t\t\t\t\t\t\t\t\t\t \t\t\t\t <p class='qianming'>" . $curfrishuoshuo . "</p>\n \t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n \t\t\t\t\t\t\t\t\t\t\t\t</li>";
}
