PHP SmrMySqlDatabase::nf方法代码示例

    $file .= addbyte(sqrt($db->f("num_sec")));
}
//planet definitions (num of, [size of name, name])
$file .= addbyte(2);
$file .= addbyte(8);
$file .= "Friendly";
$file .= addbyte(5);
$file .= "Enemy";
//done with all header info
$db2 = new SmrMySqlDatabase();
$db3 = new SmrMySqlDatabase();
$db->query("SELECT * FROM sector WHERE game_id = {$game_id} ORDER BY sector_id");
while ($db->next_record()) {
    $sector_id = $db->f("sector_id");
    $db2->query("SELECT * FROM player_visited_sector WHERE sector_id = {$sector_id} AND game_id = {$game_id} AND account_id = {$player->account_id} LIMIT 1");
    if ($db2->nf() > 0) {
        $CurrByte = 3;
        $up = $db->f("link_up");
        $db2->query("SELECT * FROM player_visited_sector WHERE sector_id = {$up} AND game_id = {$game_id} AND account_id = {$player->account_id} LIMIT 1");
        if ($db2->nf() == 0 && $up != 0) {
            $CurrByte += 128;
        }
        $right = $db->f("link_right");
        $db2->query("SELECT * FROM player_visited_sector WHERE sector_id = {$right} AND game_id = {$game_id} AND account_id = {$player->account_id} LIMIT 1");
        if ($db2->nf() == 0 && $right != 0) {
            $CurrByte += 64;
        }
        $down = $db->f("link_down");
        $db2->query("SELECT * FROM player_visited_sector WHERE sector_id = {$down} AND game_id = {$game_id} AND account_id = {$player->account_id} LIMIT 1");
        if ($db2->nf() == 0 && $down != 0) {
            $CurrByte += 32;

 if ($db->f("link_left") > 0) {
     $CurrByte += 16;
 }
 //do we have a planet here?
 $db2->query("SELECT * FROM planet WHERE game_id = {$game_id} AND sector_id = {$sector_id}");
 if ($db2->next_record()) {
     $CurrByte += 8;
 }
 //do we have a port here?
 $db2->query("SELECT * FROM port WHERE game_id = {$game_id} AND sector_id = {$sector_id}");
 if ($db2->next_record()) {
     $CurrByte += 4;
 }
 //sector friendliness
 $db2->query("SELECT * FROM sector_has_forces WHERE sector_id = {$sector_id} AND mines > 0 AND owner_id IN {$alliance}");
 if ($db2->nf() > 0) {
     //we want a green "friendly" sector
     $CurrByte += 1;
 } else {
     //we want a blue "neutral" sector
     $CurrByte += 0;
 }
 $file .= addbyte($CurrByte);
 $db2->query("SELECT * FROM port WHERE game_id = {$game_id} AND sector_id = {$sector_id}");
 $race = 0;
 $has_port = FALSE;
 if ($db2->next_record()) {
     $has_port = TRUE;
     $race = $db2->f("race_id");
     if ($race == 1) {
         $race = 9;

include get_file_loc("council.inc");
include get_file_loc('menue.inc');
print_topic("RULING COUNCIL OF {$player->race_name}");
print_council_menue($player->race_id, getPresident($player->race_id));
print "<table border=\"0\" class=\"standard\" cellspacing=\"0\" align=\"center\" width=\"50%\">";
print "<tr>";
print "<th>Race</th>";
print "<th>Treaty</th>";
print "</tr>";
$db2 = new SmrMySqlDatabase();
$db->query("SELECT * FROM race " . "WHERE race_id != {$player->race_id} AND " . "race_id > 1");
while ($db->next_record()) {
    $race_id = $db->f("race_id");
    $race_name = $db->f("race_name");
    $db2->query("SELECT * FROM race_has_voting " . "WHERE game_id = {$player->game_id} AND " . "race_id_1 = {$player->race_id} AND " . "race_id_2 = {$race_id}");
    if ($db2->nf() > 0) {
        continue;
    }
    print "<tr>";
    print "<td align=\"center\">" . $player->get_colored_race($race_id) . "</td>";
    $container = array();
    $container["url"] = "council_embassy_processing.php";
    $container["race_id"] = $race_id;
    print_form($container);
    print "<td align=\"center\">";
    print_submit("Peace");
    print "&nbsp;";
    print_submit("War");
    print "</td>";
    print "</form>";
    print "</tr>";

        }
        print "<td nowrap=\"nowrap\" align=\"center\">";
        if ($voted_for == "YES") {
            print_submit_style("Yes", "background-color:green;");
        } else {
            print_submit("Yes");
        }
        print "&nbsp;";
        if ($voted_for == "NO") {
            print_submit_style("No", "background-color:green;");
        } else {
            print_submit("No");
        }
        if ($president->account_id == $player->account_id) {
            print "&nbsp;";
            print_submit("Veto");
        }
        print "</td>";
        // get 'yes' votes
        $db2->query("SELECT * FROM player_votes_pact " . "WHERE game_id = {$player->game_id} AND " . "race_id_1 = {$player->race_id} AND " . "race_id_2 = {$race_id_2} AND " . "vote = 'YES'");
        $yes_votes = $db2->nf();
        // get 'no' votes
        $db2->query("SELECT * FROM player_votes_pact " . "WHERE game_id = {$player->game_id} AND " . "race_id_1 = {$player->race_id} AND " . "race_id_2 = {$race_id_2} AND " . "vote = 'NO'");
        $no_votes = $db2->nf();
        print "<td align=\"center\">{$yes_votes} / {$no_votes}</td>";
        print "<td nowrap=\"nowrap\"align=\"center\">" . date("n/j/Y", $end_time) . "<br>" . date("g:i:s A", $end_time) . "</td>";
        print "</form>";
        print "</tr>";
    }
    print "</table>";
}

    $db->query("SELECT * FROM alliance WHERE game_id = {$player->game_id} ORDER BY alliance_kills DESC, alliance_name LIMIT 5");
    while ($db->next_record()) {
        $alliance_vs[] = $db->f("alliance_id");
    }
    //print("emtpy $alliancer");
} else {
    $alliance_vs = $alliancer;
}
$alliance_vs[] = 0;
foreach ($alliance_vs as $key => $id) {
    // get current alliance
    $curr_alliance_id = $id;
    if ($id > 0) {
        $curr_alliance = new SMR_ALLIANCE($id, SmrSession::$game_id);
        $db2->query("SELECT * FROM player WHERE alliance_id = {$id} AND game_id = " . SmrSession::$game_id);
        if ($db2->nf() == 0) {
            $out = TRUE;
        } else {
            $out = FALSE;
        }
        print "<td width=15% valign=\"top\"";
        if ($player->alliance_id == $curr_alliance_id) {
            print " style=\"font-weight:bold;\"";
        }
        print ">";
        /*$container = array();
        		$container["url"]             = "skeleton.php";
        		$container["body"]             = "alliance_roster.php";
        		$container["alliance_id"]    = $curr_alliance_id;
        		print_link($container, "$curr_alliance->alliance_name");*/
        print "<select name=alliancer[] style=width:105>";

<?php

$db = new SmrMySqlDatabase();
$db->query("SELECT * FROM account, announcement " . "WHERE account_id = " . SmrSession::$old_account_id . " AND " . "last_login < time");
$container = array();
// do we have announcements?
if ($db->nf() != 0) {
    $container["url"] = "skeleton.php";
    $container["body"] = "announcements.php";
} else {
    $container["url"] = "logged_in.php";
}
forward($container);

 print_link(create_container("skeleton.php", "galactic_post_view_article.php"), "View the articles");
 print "<br>";
 print_link(create_container("skeleton.php", "galactic_post_make_paper.php"), "Make a paper");
 print "<br>";
 print_link(create_container("skeleton.php", "galactic_post_view_members.php"), "View Members");
 print "<br>";
 $db->query("SELECT * FROM galactic_post_paper WHERE game_id = {$player->game_id}");
 if ($db->nf()) {
     print "The following papers are already made (note papers must have 3-8 articles to go to the press)";
 }
 while ($db->next_record()) {
     $paper_name = $db->f("title");
     $paper_id = $db->f("paper_id");
     print "<font color=red>***</font><i>{$paper_name}</i>";
     $db2->query("SELECT * FROM galactic_post_paper_content WHERE paper_id = {$paper_id} AND game_id = {$player->game_id}");
     print " which contains <font color=red> " . $db2->nf() . " </font>articles. ";
     if ($db2->nf() > 2 && $db2->nf() < 9) {
         $container = array();
         $container["url"] = "galactic_post_make_current.php";
         $container["id"] = $paper_id;
         print_link($container, "<b>HIT THE PRESS!</b>");
     }
     print "<br>";
     $container = array();
     $container["url"] = "skeleton.php";
     $container["body"] = "galactic_post_delete_confirm.php";
     $container["paper"] = "yes";
     $container["id"] = $paper_id;
     print_link($container, "Delete {$paper_name}");
     print "<br>";
     $container = array();

if (!isset($var["folder_id"])) {
    print_topic("VIEW MESSAGES");
    include get_file_loc('menue.inc');
    print_message_menue();
    print "<p>Please choose your Message folder!</p>";
    print "<p>";
    print "<table border=\"0\" class=\"standard\" cellspacing=\"0\" cellpadding=\"3\">";
    print "<tr>";
    print "<th>Folder</th>";
    print "<th>Messages</th>";
    print "<th>&nbsp;</th>";
    print "</tr>";
    $db2 = new SmrMySqlDatabase();
    include get_file_loc("council.inc");
    $db2->query("SELECT * FROM message WHERE account_id = {$player->account_id} AND message_type_id = " . MSG_POLITICAL . " AND game_id = {$player->game_id}");
    if (onCouncil($player->race_id) || $db2->nf()) {
        $db->query("SELECT * FROM message_type " . "WHERE message_type_id < 8 " . "ORDER BY message_type_id");
    } else {
        $db->query("SELECT * FROM message_type " . "WHERE message_type_id != 5 " . "ORDER BY message_type_id");
    }
    while ($db->next_record()) {
        $message_type_id = $db->f("message_type_id");
        $message_type_name = $db->f("message_type_name");
        // do we have unread msges in that folder?
        $db2->query("SELECT * FROM message " . "WHERE account_id = " . SmrSession::$old_account_id . " AND " . "game_id = " . SmrSession::$game_id . " AND " . "message_type_id = {$message_type_id} AND " . "msg_read = 'FALSE'");
        $msg_read = $db2->nf();
        // get number of msges
        $db2->query("SELECT count(message_id) as message_count FROM message " . "WHERE account_id = " . SmrSession::$old_account_id . " AND " . "game_id = " . SmrSession::$game_id . " AND " . "message_type_id = {$message_type_id}");
        if ($db2->next_record()) {
            $message_count = $db2->f("message_count");
        }

print_bar_menue();
$db = new SmrMySqlDatabase();
$db->query("SELECT message_id FROM bar_wall WHERE sector_id = {$sector->sector_id} AND game_id = " . SmrSession::$game_id . " ORDER BY message_id DESC");
if ($db->next_record()) {
    $amount = $db->f("message_id") + 1;
} else {
    $amount = 1;
}
$time_now = time();
$db2 = new SmrMySqlDatabase();
$wall = $_REQUEST['wall'];
if (isset($wall)) {
    $db2->query("INSERT INTO bar_wall (sector_id, game_id, message_id, message, time) VALUES ({$sector->sector_id}, " . SmrSession::$game_id . ", {$amount},  " . format_string($wall, true) . " , {$time_now})");
}
$db->query("SELECT * FROM bar_wall WHERE game_id = {$player->game_id} AND sector_id = {$player->sector_id} ORDER BY time DESC");
if ($db->nf()) {
    print "<table cellspacing=\"0\" cellpadding=\"3\" border=\"0\" class=\"standard\">";
    print "<tr>";
    print "<th align=\"center\">Time written</th>";
    print "<th align=\"center\">Message</th>";
    print "</tr>";
    while ($db->next_record()) {
        $time = $db->f("time");
        $message_on_wall = stripslashes($db->f("message"));
        print "<tr>";
        print "<td align=\"center\"><b> " . date("n/j/Y g:i:s A", $time) . " </b></td>";
        print "<td align=\"center\"><b>{$message_on_wall}</b></td>";
        print "</tr>";
    }
    print "</table>";
}

print_topic("GALACTIC POST");
$db2 = new SmrMySqlDatabase();
$db3 = new SmrMySqlDatabase();
$db->query("SELECT * FROM galactic_post_online WHERE game_id = {$player->game_id}");
if ($db->nf()) {
    $db->next_record();
    $paper_id = $db->f("paper_id");
    $db2->query("SELECT * FROM galactic_post_paper WHERE game_id = {$player->game_id} AND paper_id = {$paper_id}");
    $db2->next_record();
    $paper_name = stripslashes($db2->f("title"));
    print_topic("READING <i>GALACTIC POST</i> EDITION : {$paper_name}");
    include get_file_loc('menue.inc');
    print_galactic_post_menue();
    $db2->query("SELECT * FROM galactic_post_paper_content WHERE paper_id = {$paper_id} AND game_id = {$player->game_id}");
    if (floor($db2->nf() / 2) == $db2->nf() / 2) {
        $even = "yes";
    } else {
        $even = "no";
    }
    $curr_position = 0;
    print "<table align=\"center\" spacepadding=\"20\" cellspacing=\"20\">";
    if ($even == "yes") {
        $amount = $db2->nf();
    } else {
        $amount = $db2->nf() + 1;
    }
    while ($curr_position + 1 <= $amount) {
        $curr_position += 1;
        if ($db2->nf() + 1 == $curr_position && $even != "yes") {
            print "<td>&nbsp;</td>";