本文整理汇总了PHP中mysql_select_multi函数的典型用法代码示例。如果您正苦于以下问题:PHP mysql_select_multi函数的具体用法?PHP mysql_select_multi怎么用?PHP mysql_select_multi使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysql_select_multi函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: fetch_znote_accounts
function fetch_znote_accounts()
{
$results = mysql_select_multi("SELECT `account_id` FROM `znote_accounts`");
$accounts = array();
foreach ($results as $row) {
$accounts[] = $row['account_id'];
}
return count($accounts) > 0 ? $accounts : false;
}
示例2: guild_list
function guild_list($TFSVersion)
{
$cache = new Cache('engine/cache/guildlist');
if ($cache->hasExpired()) {
if ($TFSVersion != 'TFS_10') {
$guilds = mysql_select_multi("SELECT `t`.`id`, `t`.`name`, `t`.`creationdata`, `motd`, (SELECT count(p.rank_id) FROM players AS p LEFT JOIN guild_ranks AS gr ON gr.id = p.rank_id WHERE gr.guild_id =`t`.`id`) AS `total` FROM `guilds` as `t` ORDER BY `t`.`name`;");
} else {
$guilds = mysql_select_multi("SELECT `id`, `name`, `creationdata`, `motd`, (SELECT COUNT('guild_id') FROM `guild_membership` WHERE `guild_id`=`id`) AS `total` FROM `guilds` ORDER BY `name`;");
}
// Add level data info to guilds
if ($guilds !== false) {
for ($i = 0; $i < count($guilds); $i++) {
$guilds[$i]['level'] = get_guild_level_data($guilds[$i]['id']);
}
}
$cache->setContent($guilds);
$cache->save();
} else {
$guilds = $cache->load();
}
return $guilds;
}
示例3: getValue
<?php
require_once '../../module.php';
// Configure module version number
$response['version']['module'] = 1;
// Fetch number of rows
$rows = getValue($_GET['rows']);
if (!$rows || $rows == 0) {
$rows = 10;
} else {
$rows = (int) $rows;
}
// Show which configuration is used
$response['config']['rows'] = $rows;
// Fetch top 10 players
$players = mysql_select_multi("SELECT `p`.`name`, `p`.`level`, `p`.`experience`, `p`.`vocation`, `p`.`lastlogin`, `z`.`created` FROM `players` AS `p` INNER JOIN `znote_players` AS `z` ON `p`.`id` = `z`.`player_id` WHERE `p`.`group_id`<'2' ORDER BY `p`.`experience` DESC LIMIT {$rows};");
for ($i = 0; $i < count($players); $i++) {
$players[$i]['vocation_name'] = $config['vocations'][$players[$i]['vocation']];
}
$response['data']['players'] = $players;
SendResponse($response);
示例4: mysql_select_multi
<td><a href="?compare=<?php
echo $o['item_id'];
?>
"><button>Compare</button></a></td>
</tr>
<?php
}
?>
</table>
<?php
} else {
// Else You want to compare price
$compare = (int) $compare;
// First list active bids
$offers = mysql_select_multi("SELECT `id`, `sale`, `itemtype` AS `item_id`, `amount`, `price`, `created`, `anonymous`, (SELECT `name` FROM `players` WHERE `id` = `player_id`) AS `player_name` FROM `market_offers` WHERE `itemtype`='{$compare}' ORDER BY `price` ASC;");
$historyOffers = mysql_select_multi("SELECT `id`, `itemtype` AS `item_id`, `amount`, `price`, `inserted`, `expires_at` FROM `market_history` WHERE `itemtype`='{$compare}' AND `state`=255 ORDER BY `price` ASC;");
$buylist = false;
// Markup
?>
<h1>Comparing item</h1>
<a href="market.php"><button>Go back</button></a>
<h2>Active offers</h2>
<table class="table tbl-hover">
<tr class="yellow">
<td>Item name</td>
<td>Item</td>
<td>Count</td>
<td>Price for 1</td>
<td>Added</td>
<td>By</td>
</tr>
示例5: Cache
<div class="sidebar">
<h3>Top 5 players</h3>
<?php
$cache = new Cache('engine/cache/topPlayer');
if ($cache->hasExpired()) {
$players = mysql_select_multi('SELECT `name`, `level`, `experience` FROM `players` WHERE `group_id` < ' . $config['highscore']['ignoreGroupId'] . ' ORDER BY `experience` DESC LIMIT 5;');
$cache->setContent($players);
$cache->save();
} else {
$players = $cache->load();
}
if ($players) {
$count = 1;
foreach ($players as $player) {
echo "{$count} - <a href='characterprofile.php?name=" . $player['name'] . "'>" . $player['name'] . "</a> (" . $player['level'] . ").<br>";
$count++;
}
}
?>
<br>
</div>
示例6: Cache
<textarea rows="7" cols="40" maxlength="254" name="changelogText"><?php
echo $action === 2 ? $old['text'] : '';
?>
</textarea><br>
<input type="submit" value="Add or update changelog">
</form>
<?php
}
}
?>
<h1>Changelog</h1>
<?php
$cache = new Cache('engine/cache/changelog');
if ($updateCache === true) {
$changelogs = mysql_select_multi("SELECT `id`, `text`, `time`, `report_id`, `status` FROM `znote_changelog` ORDER BY `id` DESC;");
$cache->setContent($changelogs);
$cache->save();
} else {
$changelogs = $cache->load();
}
if (isset($changelogs) && !empty($changelogs) && $changelogs !== false) {
?>
<table id="changelogTable">
<tr class="yellow">
<td>Changelogs</td>
<?php
if (user_logged_in()) {
if (is_admin($user_data)) {
echo "<td>Delete</td><td>Update</td>";
}
示例7: mysql_select_multi
<?php
}
}
?>
<form action="" method="post">
<input type="hidden" name="username" value="ADMIN"><br>
<textarea class="forumReply" name="reply_text" style="width: 610px; height: 150px"></textarea><br>
<input name="" type="submit" value="Post Reply" class="btn btn-primary">
</form>
<?php
} else {
?>
<h1>Latest Tickets</h1>
<?php
$tickets = mysql_select_multi("SELECT id,subject,creation,status FROM znote_tickets ORDER BY creation DESC");
if ($tickets !== false) {
?>
<table>
<tr class="yellow">
<td>ID:</td>
<td>Subject:</td>
<td>Creation:</td>
<td>Status:</td>
</tr>
<?php
foreach ($tickets as $ticket) {
echo '<tr class="special">';
echo '<td>' . $ticket['id'] . '</td>';
echo '<td><a href="admin_helpdesk.php?view=' . $ticket['id'] . '">' . $ticket['subject'] . '</a></td>';
echo '<td>' . getClock($ticket['creation'], true) . '</td>';
示例8: protect_page
<?php
require_once 'engine/init.php';
/* PLAYER SKILLS REPAIR SCRIPT IF YOU SOMEHOW DELETE PLAYER SKILLS
---------------------------------------------------------------
Place in root web directory, login to admin account,
and enter site.com/repairSkills.php (with big S).
*/
protect_page();
admin_only($user_data);
$Splayers = 0;
$Salready = 0;
$Sfixed = 0;
$players = mysql_select_multi("SELECT `id` FROM `players`;");
if ($players !== false) {
$Splayers = count($players);
foreach ($players as $char) {
// Check if player have skills
$skills = mysql_select_single("SELECT `value` FROM `player_skills` WHERE `player_id`='" . $char['id'] . "' AND `skillid`='2' LIMIT 1;");
// If he dont have any skills
if ($skills === false) {
$Sfixed++;
// Loop through every skill id and give him default skills.
$query = "INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES ";
for ($i = 0; $i < 7; $i++) {
if ($i != 6) {
$query .= "('" . $char['id'] . "', '{$i}', '10', '0'), ";
} else {
$query .= "('" . $char['id'] . "', '{$i}', '10', '0');";
}
}
示例9: fetch_znote_accounts
function fetch_znote_accounts()
{
return mysql_select_multi("SELECT `account_id` FROM `znote_accounts`");
}
示例10: mysql_select_multi
<li>
<a href='admin_helpdesk.php'>Admin Helpdesk</a>
</li>
<li>
<a href='admin_shop.php'>Admin Shop</a>
</li>
<?php
$new = 0;
$cat = 4;
//Category ID for feedback section
$threads = mysql_select_multi("SELECT `id`, `player_id` FROM `znote_forum_threads` WHERE `forum_id`='{$cat}' AND `closed`='0';");
if ($threads !== false) {
$staffs = mysql_select_multi("SELECT `id` FROM `players` WHERE `group_id` > '1';");
foreach ($threads as $thread) {
$response = false;
$posts = mysql_select_multi("SELECT `id`, `player_id` FROM `znote_forum_posts` WHERE `thread_id`='" . $thread['id'] . "';");
if ($posts !== false) {
foreach ($posts as $post) {
foreach ($staffs as $staff) {
if ($post['player_id'] == $staff['id']) {
$response = true;
}
}
}
}
if (!$response) {
$new++;
}
}
}
?>
示例11: mysql_select_multi
<ul>
<li>Invite guild to war:<br>
<input type="text" name="warinvite" placeholder="Guild name">
<input type="number" min="10" max="999" name="limit">
<input type="submit" value="Invite Guild">
</li>
</ul>
</form>
<style type="text/css">
form {display: inline;}
#btnspace{margin-left:100px;}
</style>
<table id="guildsTable" class="table table-striped table-hover"><tr class="yellow"><th>Aggressor</th><th>Information</th><th>Enemy</th></tr>
<?php
$i = 0;
$wars = mysql_select_multi("SELECT `guild1`, `guild2`, `name1`, `name2`, `started`, (SELECT `limit` FROM `znote_guild_wars` WHERE `znote_guild_wars`.`id` = `guild_wars`.`id`) AS `limit` FROM `guild_wars` WHERE (`guild1` = '{$gid}' OR `guild2` = '{$gid}') AND `status` = 0 ORDER BY `started` DESC");
if (!empty($wars) || $wars !== false) {
foreach ($wars as $war) {
$i++;
echo '<tr><td><a href="guilds.php?name=' . $war['name1'] . '">' . $war['name1'] . '</a></td><td>';
echo '<center><b>Pending invitation</b><br />Invited on ' . getClock($war['started'], true) . '.<br />The frag limit is set to ' . $war['limit'] . ' frags.<br />';
if ($war['guild1'] == $gid) {
echo '<br /><form action="" method="post"><input type="hidden" name="cancel_war_invite" value="' . $war['guild2'] . '" /><input type="submit" value="Cancel Invitation"></form>';
} else {
if ($war['guild2'] == $gid) {
echo '<br><form action="" method="post"><input type="hidden" name="accept_war_invite" value="' . $war['guild1'] . '" /><input type="submit" value="Accept Invitation"></form>';
echo '<form action="" method="post"><input type="hidden" name="reject_war_invite" value="' . $war['guild1'] . '" /><input type="submit" ID="btnspace" value="Reject Invitation"></form>';
}
}
echo '</center></td><td><a href="guilds.php?name=' . $war['name2'] . '">' . $war['name2'] . '</a></td></tr>';
}
示例12: Cache
<?php
require_once 'engine/init.php';
include 'layout/overall/header.php';
// Cache the results
$cache = new Cache('engine/cache/topGuilds');
if ($cache->hasExpired()) {
$guilds = mysql_select_multi("SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, COUNT(`g`.`name`) as `frags` FROM `players` p LEFT JOIN `player_deaths` pd ON `pd`.`killed_by` = `p`.`name` LEFT JOIN `guild_membership` gm ON `p`.`id` = `gm`.`player_id` LEFT JOIN `guilds` g ON `gm`.`guild_id` = `g`.`id` WHERE `pd`.`unjustified` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 0, 10;");
$cache->setContent($guilds);
$cache->save();
} else {
$guilds = $cache->load();
}
$count = 1;
function convert_number_to_words($number)
{
$hyphen = '-';
$conjunction = ' and ';
$separator = ', ';
$negative = 'negative ';
$decimal = ' point ';
$dictionary = array(0 => 'zero', 1 => 'First', 2 => 'Second', 3 => 'Third', 4 => 'Fourth', 5 => 'Fifth', 6 => 'Sixth', 7 => 'Seventh', 8 => 'Eighth', 9 => 'Ninth', 10 => 'Tenth', 11 => 'eleventh', 12 => 'twelve', 13 => 'thirteen', 14 => 'fourteen', 15 => 'fifteen', 16 => 'sixteen', 17 => 'seventeen', 18 => 'eighteen', 19 => 'nineteen', 20 => 'twenty', 30 => 'thirty', 40 => 'fourty', 50 => 'fifty', 60 => 'sixty', 70 => 'seventy', 80 => 'eighty', 90 => 'ninety', 100 => 'hundred', 1000 => 'thousand', 1000000 => 'million', 1000000000 => 'billion', 1000000000000 => 'trillion', 1000000000000000 => 'quadrillion', 1000000000000000000 => 'quintillion');
if (!is_numeric($number)) {
return false;
}
if ($number >= 0 && (int) $number < 0 || (int) $number < 0 - PHP_INT_MAX) {
// overflow
trigger_error('convert_number_to_words only accepts numbers between -' . PHP_INT_MAX . ' and ' . PHP_INT_MAX, E_USER_WARNING);
return false;
}
if ($number < 0) {
示例13: foreach
<?php
if ($guildboard !== false && $guild || $guildboard !== false && $admin) {
//
?>
<table class="table table-striped table-hover znoteTable" id="forumCategoryTable">
<tr class="yellow">
<th>Guild Boards</th>
<?php
foreach ($charData as $char) {
if ($char['guild'] > 0) {
$guild = true;
}
}
if ($admin || $guild) {
if (!isset($guilds)) {
$guilds = mysql_select_multi("SELECT `id`, `name` FROM `guilds` ORDER BY `name`;");
$guilds[] = array('id' => '0', 'name' => 'No guild');
}
$guildName = array();
foreach ($guilds as $guild) {
$guildName[$guild['id']] = $guild['name'];
}
if ($admin) {
?>
<th width="100">Edit</th>
<th width="100">Delete</th>
<?php
}
}
?>
</tr>
示例14: getValue
}
// Stage 1: Fetch name
if (isset($_GET['name'])) {
$name = getValue($_GET['name']);
} else {
$name = false;
}
//if (isset($_POST['name'])) $name = getValue($_POST['name']);
// Stage 2: Fetch user id and skills
$skills = false;
$pid = 0;
if ($name !== false) {
if (user_character_exist($name)) {
$pid = user_character_id($name);
if ($config['TFSVersion'] != 'TFS_10') {
$skills = mysql_select_multi("SELECT `value` FROM `player_skills` WHERE `player_id`='{$pid}' LIMIT 7;");
$player = mysql_select_single("SELECT `maglevel`, `level`, `vocation` FROM `players` WHERE `id`='{$pid}' LIMIT 1;");
$skills[] = array('value' => $player['maglevel']);
$skills[] = array('value' => $player['level']);
$skills[] = array('value' => $player['vocation']);
} else {
$player = mysql_select_single("SELECT `skill_fist`, `skill_club`, `skill_sword`, `skill_axe`, `skill_dist`, `skill_shielding`, `skill_fishing`, `maglevel`, `level`, `vocation` FROM `players` WHERE `id`='{$pid}' LIMIT 1;");
$skills = array(0 => array('value' => $player['skill_fist']), 1 => array('value' => $player['skill_club']), 2 => array('value' => $player['skill_sword']), 3 => array('value' => $player['skill_axe']), 4 => array('value' => $player['skill_dist']), 5 => array('value' => $player['skill_shielding']), 6 => array('value' => $player['skill_fishing']), 7 => array('value' => $player['maglevel']), 8 => array('value' => $player['level']), 9 => array('value' => $player['vocation']));
}
//data_dump($skills, false, "Player skills");
} else {
$name = false;
}
}
?>
<form action="" method="<?php
示例15: Cache
$cache->setContent($killers);
$cache->save();
} else {
$killers = $cache->load();
}
$cache = new Cache('engine/cache/victims');
if ($cache->hasExpired()) {
$victims = fetchLoosers();
$cache->setContent($victims);
$cache->save();
} else {
$victims = $cache->load();
}
$cache = new Cache('engine/cache/lastkillers');
if ($cache->hasExpired()) {
$latests = mysql_select_multi("SELECT `p`.`name` AS `victim`, `d`.`killed_by` as `killed_by`, `d`.`time` as `time` FROM `player_deaths` as `d` INNER JOIN `players` as `p` ON d.player_id = p.id WHERE d.`is_player`='1' ORDER BY `time` DESC LIMIT 20;");
if ($latests !== false) {
$cache->setContent($latests);
$cache->save();
}
} else {
$latests = $cache->load();
}
if ($killers) {
?>
<h1>Biggest Murders</h1>
<table id="killersTable" class="table table-striped">
<tr class="yellow">
<th>Name</th>
<th>Kills</th>
</tr>