PHP mysql_select_multi函数代码示例

OGeek|极客世界-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了PHP中mysql_select_multi函数的典型用法代码示例。如果您正苦于以下问题：PHP mysql_select_multi函数的具体用法？PHP mysql_select_multi怎么用？PHP mysql_select_multi使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了mysql_select_multi函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的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;
}

开发者ID:l04d，项目名称:ZnoteAAC，代码行数:9，代码来源:database2znoteaac.php

示例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;
}

开发者ID:l04d，项目名称:ZnoteAAC，代码行数:22，代码来源:guilds.php

示例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);

开发者ID:peonso，项目名称:ZnoteAAC，代码行数:21，代码来源:topExperience.php

示例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>

开发者ID:l04d，项目名称:ZnoteAAC，代码行数:31，代码来源:market.php

示例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>

开发者ID:l04d，项目名称:ZnoteAAC，代码行数:21，代码来源:topplayers.php

示例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>";
        }

开发者ID:l04d，项目名称:ZnoteAAC，代码行数:31，代码来源:changelog.php

示例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>';

开发者ID:peonso，项目名称:ZnoteAAC，代码行数:31，代码来源:admin_helpdesk.php

示例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');";
                }
            }

开发者ID:l04d，项目名称:ZnoteAAC，代码行数:31，代码来源:repairSkills.php

示例9: fetch_znote_accounts

function fetch_znote_accounts()
{
    return mysql_select_multi("SELECT `account_id` FROM `znote_accounts`");
}

开发者ID:niemoralny，项目名称:ZnoteAAC，代码行数:4，代码来源:database2znoteaac.php

示例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++;
        }
    }
}
?>

开发者ID:l04d，项目名称:ZnoteAAC，代码行数:31，代码来源:Wadmin.php

示例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>';
                        }

开发者ID:peonso，项目名称:ZnoteAAC，代码行数:31，代码来源:guilds.php

示例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) {

开发者ID:l04d，项目名称:ZnoteAAC，代码行数:31，代码来源:topguilds.php

示例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>

开发者ID:l04d，项目名称:ZnoteAAC，代码行数:31，代码来源:forum.php

示例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

开发者ID:l04d，项目名称:ZnoteAAC，代码行数:31，代码来源:admin_skills.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>

开发者ID:l04d，项目名称:ZnoteAAC，代码行数:31，代码来源:killers.php

示例16: Securimage

                include_once 'captcha/securimage.php';
                $securimage = new Securimage();
                if ($securimage->check($_POST['captcha_code']) == false) {
                    $errors[] = 'Captcha image verification was submitted wrong.';
                }
            }
            // Reversed this if, so: first check if you need to validate, then validate.
            if ($config['validate_IP'] === true && validate_ip(getIP()) === false) {
                $errors[] = 'Failed to recognize your IP address. (Not a valid IPv4 address).';
            }
        }
    }
    ?>
	<h1>Latest Tickets</h1>
	<?php 
    $tickets = mysql_select_multi("SELECT id,subject,creation,status FROM znote_tickets WHERE owner={$session_user_id} 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="helpdesk.php?view=' . $ticket['id'] . '">' . $ticket['subject'] . '</a></td>';
            echo '<td>' . getClock($ticket['creation'], true) . '</td>';

开发者ID:l04d，项目名称:ZnoteAAC，代码行数:31，代码来源:helpdesk.php

示例17: mysql_select_multi

     echo $config['forum']['closed'], ' ';
 }
 if ($board['hidden'] == 1) {
     echo $config['forum']['hidden'], ' ';
 }
 if ($board['guild_id'] > 0) {
     echo "[" . $board['name'] . "] ";
 }
 echo "<a href=" . $url . ">" . $guildName[$board['guild_id']] . "</a></td>";
 $categoryid = $board['id'];
 $threads = mysql_select_multi("SELECT `id`, `player_name`, `updated` FROM `znote_forum_threads` WHERE `forum_id`={$categoryid} ORDER BY `updated` ASC");
 !empty($threads) ? $threadscount = count($threads) : ($threadscount = 0);
 $replies = 0;
 foreach ($threads as $thread) {
     $threadid = $thread['id'];
     $posts = mysql_select_multi("SELECT `player_name`, `updated` FROM `znote_forum_posts` WHERE `thread_id`={$threadid} ORDER BY `updated` DESC");
     if (!empty($posts)) {
         $newreplies = count($posts);
         foreach ($posts as $post) {
             $lastposter = $post['player_name'];
             $lastpostdate = $post['updated'];
             break;
         }
     } else {
         $lastposter = $thread['player_name'];
         $lastpostdate = $thread['updated'];
         $newreplies = 0;
     }
     $replies = $replies + $newreplies;
 }
 echo "<td>" . $threadscount . "</td>";

开发者ID:peonso，项目名称:ZnoteAAC，代码行数:31，代码来源:forum.php

示例18: online_list

function online_list()
{
    if (config('TFSVersion') == 'TFS_10') {
        return mysql_select_multi("SELECT `o`.`player_id` AS `id`, `p`.`name` as `name`, `p`.`level` as `level`, `p`.`vocation` as `vocation`, `g`.`name` as `gname` FROM `players_online` as `o` INNER JOIN `players` as `p` ON `o`.`player_id` = `p`.`id` LEFT JOIN `guild_membership` gm ON `o`.`player_id` = `gm`.`player_id` LEFT JOIN `guilds` g ON `gm`.`guild_id` = `g`.`id`");
    } else {
        return mysql_select_multi("SELECT `p`.`name` as `name`, `p`.`level` as `level`, `p`.`vocation` as `vocation`, `g`.`name` as `gname` FROM `players` p LEFT JOIN `guild_ranks` gr ON `gr`.`id` = `p`.`rank_id` LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id` WHERE `p`.`online` = '1' ORDER BY `p`.`name` DESC;");
    }
}

开发者ID:peonso，项目名称:ZnoteAAC，代码行数:8，代码来源:general.php

示例19: fetchAllScores

function fetchAllScores($rows, $tfs, $g)
{
    // Return scores ordered by type
    $data = array();
    if ($tfs == 'TFS_10') {
        $data[1] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_club` AS `value` FROM `players` WHERE `group_id` < {$g} ORDER BY `skill_club` DESC LIMIT 0, {$rows};");
        $data[2] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_sword` AS `value` FROM `players` WHERE `group_id` < {$g} ORDER BY `skill_sword` DESC LIMIT 0, {$rows};");
        $data[3] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_axe` AS `value` FROM `players` WHERE `group_id` < {$g} ORDER BY `skill_axe` DESC LIMIT 0, {$rows};");
        $data[4] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_dist` AS `value` FROM `players` WHERE `group_id` < {$g} ORDER BY `skill_dist` DESC LIMIT 0, {$rows};");
        $data[5] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_shielding` AS `value` FROM `players` WHERE `group_id` < {$g} ORDER BY `skill_shielding` DESC LIMIT 0, {$rows};");
        $data[6] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_fishing` AS `value` FROM `players` WHERE `group_id` < {$g} ORDER BY `skill_fishing` DESC LIMIT 0, {$rows};");
        $data[7] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `experience`, `level` AS `value` FROM `players` WHERE `group_id` < {$g} ORDER BY `experience` DESC LIMIT 0, {$rows};");
        $data[8] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `maglevel` AS `value` FROM `players` WHERE `group_id` < {$g} ORDER BY `maglevel` DESC LIMIT 0, {$rows};");
        $data[9] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `skill_fist` AS `value` FROM `players` WHERE `group_id` < {$g} ORDER BY `skill_fist` DESC LIMIT 0, {$rows};");
    } else {
        $data[9] = mysql_select_multi("SELECT `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 0 AND `p`.`group_id` < {$g} ORDER BY `s`.`value` DESC LIMIT 0, {$rows};");
        $data[1] = mysql_select_multi("SELECT `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 1 AND `p`.`group_id` < {$g} ORDER BY `s`.`value` DESC LIMIT 0, {$rows};");
        $data[2] = mysql_select_multi("SELECT `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 2 AND `p`.`group_id` < {$g} ORDER BY `s`.`value` DESC LIMIT 0, {$rows};");
        $data[3] = mysql_select_multi("SELECT `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 3 AND `p`.`group_id` < {$g} ORDER BY `s`.`value` DESC LIMIT 0, {$rows};");
        $data[4] = mysql_select_multi("SELECT `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 4 AND `p`.`group_id` < {$g} ORDER BY `s`.`value` DESC LIMIT 0, {$rows};");
        $data[5] = mysql_select_multi("SELECT `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 5 AND `p`.`group_id` < {$g} ORDER BY `s`.`value` DESC LIMIT 0, {$rows};");
        $data[6] = mysql_select_multi("SELECT `s`.`player_id` AS `id`, `s`.`value` AS `value`, `p`.`name` AS `name`, `p`.`vocation` AS `vocation` FROM `player_skills` AS `s` LEFT JOIN `players` AS `p` ON `s`.`player_id`=`p`.`id` WHERE `s`.`skillid` = 6 AND `p`.`group_id` < {$g} ORDER BY `s`.`value` DESC LIMIT 0, {$rows};");
        $data[7] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `experience`, `level` AS `value` FROM `players` WHERE `group_id` < {$g} ORDER BY `experience` DESC limit 0, {$rows};");
        $data[8] = mysql_select_multi("SELECT `id`, `name`, `vocation`, `maglevel` AS `value` FROM `players` WHERE `group_id` < {$g} ORDER BY `maglevel` DESC limit 0, {$rows};");
    }
    return $data;
}

开发者ID:niemoralny，项目名称:ZnoteAAC，代码行数:27，代码来源:users.php

示例20: mysql_update

     $updatechangelog = false;
     if ($changelog !== false) {
         // Update it
         mysql_update("UPDATE `znote_changelog` SET `text`='{$changelogText}', `time`='{$time}' WHERE `id`='" . $changelog['id'] . "' LIMIT 1;");
         echo "<h2>Changelog message updated!</h2>";
         $updatechangelog = true;
     } else {
         // Create it
         mysql_insert("INSERT INTO `znote_changelog` (`text`, `time`, `report_id`, `status`) \n                VALUES ('{$changelogText}', '{$time}', '{$changelogReportId}', '{$status}');");
         echo "<h2>Changelog message created!</h2>";
         $updatechangelog = true;
     }
     if ($updatechangelog) {
         // Cache changelog
         $cache = new Cache('engine/cache/changelog');
         $cache->setContent(mysql_select_multi("SELECT `id`, `text`, `time`, `report_id`, `status` FROM `znote_changelog` ORDER BY `id` DESC;"));
         $cache->save();
     }
 }
 // If we should give user price
 if ($price > 0) {
     $account = mysql_select_single("SELECT `a`.`id`, `a`.`email` FROM `accounts` AS `a` \n            INNER JOIN `players` AS `p` ON `p`.`account_id` = `a`.`id`\n            WHERE `p`.`name` = '{$playerName}' LIMIT 1;");
     if ($account !== false) {
         // transaction log
         mysql_insert("INSERT INTO `znote_paypal` VALUES ('', '{$reportId}', 'report@admin." . $user_data['name'] . " to " . $account['email'] . "', '" . $account['id'] . "', '0', '" . $price . "')");
         // Process payment
         $data = mysql_select_single("SELECT `points` AS `old_points` FROM `znote_accounts` WHERE `account_id`='" . $account['id'] . "';");
         // Give points to user
         $new_points = $data['old_points'] + $price;
         mysql_update("UPDATE `znote_accounts` SET `points`='{$new_points}' WHERE `account_id`='" . $account['id'] . "'");
         // Remind GM that he sent points to character

开发者ID:peonso，项目名称:ZnoteAAC，代码行数:31，代码来源:admin_reports.php

注：本文中的mysql_select_multi函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP mysql_select_single函数代码示例发布时间：2022-05-15

PHP mysql_select_db函数代码示例发布时间：2022-05-15

bradtraversy/iweather: Ionic 3 mobile we

1 dustinvtran/ml-videos: A collection of v

dustinvtran/ml-videos: A collection of video resources for machine learning

阅读：1287|2022-08-19

2 delphi线程使用

unit untWorkThread;interfaceuses Windows,Classes,SysUtils;type TWorkItem=

阅读：1127|2022-07-22

3 ravikumar001/maven

ravikumar001/maven

阅读：730|2022-08-17

4 更的笔顺,体会更的笔画,理会更的部首

更的笔顺是什么?更的笔顺笔画顺序怎么写？还有更的拼音及意思是什么，好多初学练字者

阅读：633|2022-11-06

5 ceejbot/LOUDBOT: AUTOMATED SHOUTING FOR

ceejbot/LOUDBOT: AUTOMATED SHOUTING FOR MASTODON

阅读：1524|2022-08-18

6 CVE-2022-29834

Improper Limitation of a Pathname to a Restricted Directory ('Path Traversal

阅读：602|2022-07-29

7 kali-docs-cn/kali-linux-web-pentest-cook

kali-docs-cn/kali-linux-web-pentest-cookbook-zh: Kali Linux Web 渗透测试秘籍中

阅读：721|2022-08-15

8 liangtengyu/to_markdown: 一键解析Markdow

liangtengyu/to_markdown: 一键解析Markdown 目前支持: 微信公众号,知乎,知乎专栏,简

阅读：904|2022-08-18

9 win7系统删除资源管理器里我们不想要的图标

win7系统电脑使用过程中有不少朋友表示遇到过win7系统删除资源管理器里我们不想要的图

阅读：629|2022-11-06

10 Delphi按下F1不能出现帮助文档的解决方法

不光是Delphi，Windows里面所有的之所以无法打开.hlp帮助文档的问题都可以使用以下的

阅读：1114|2022-07-18

客服电话

电子邮件

PHP mysql_select_multi函数代码示例

示例1: fetch_znote_accounts

示例2: guild_list

示例3: getValue

示例4: mysql_select_multi

示例5: Cache

示例6: Cache

示例7: mysql_select_multi

示例8: protect_page

示例9: fetch_znote_accounts

示例10: mysql_select_multi

示例11: mysql_select_multi

示例12: Cache

示例13: foreach

示例14: getValue

示例15: Cache

示例16: Securimage

示例17: mysql_select_multi

示例18: online_list

示例19: fetchAllScores

示例20: mysql_update

请发表评论

全部评论

上一篇：

下一篇：

dustinvtran/ml-videos: A collection of v

delphi线程使用

ravikumar001/maven

更的笔顺,体会更的笔画,理会更的部首

ceejbot/LOUDBOT: AUTOMATED SHOUTING FOR

bradtraversy/iweather: Ionic 3 mobile we

joaomh/curso-de-matlab

断牙刷新位置时间（断牙属性及刷新位置介绍

rugk/mastodon-simplified-federation: Sim

小程序自适应布局开发，注意点（待搜索资料

MATLAB和C语言混合编程-----Matlab7.0编译

关于我们

产品与服务

解决方案

139-2527-9053