sql — RSS

Loaded Modules core mod_win32 mpm_winnt http_core mod_so mod_php5 mod_actions mod_alias mod_asis
mod_auth_basic mod_authn_default mod_authn_file mod_authz_default mod_authz_groupfile
mod_authz_host mod_authz_user mod_autoindex mod_cgi mod_dir mod_env mod_imagemap
mod_include mod_isapi mod_log_config mod_mime mod_negotiation mod_rewrite mod_setenvif mod_userdir

mysql> SELECT DISTINCT(infant) FROM table; +----------+ | infant | +----------+ | NULL | | A | | B | | C | | U | +----------+ 5 rows in set (0.09 sec)

$rsSearchResults = mysql_query($sql) or die(mysql_error()); $out = ''; $fields = mysql_list_fields('dataprod_a5data_com','canman'); $columns = mysql_num_fields($fields); // Put the name of all fields for ($i = 0; $i < $columns; $i++) { $l=mysql_field_name($fields, $i); $out .= '"'.$l.'",'; } $out .="\n"; // Add all values in the table while ($l = mysql_fetch_array($rsSearchResults)) { for ($i = 0; $i < $columns; $i++) { $out .='"'.$l["$i"].'",'; } $out .="\n"; } // Output to browser with appropriate mime type, you choose ;) //header("Content-type: text/x-csv"); //header("Content-type: text/csv"); header("Content-type: application/csv"); header("Content-Disposition: attachment; filename=search_results.csv"); echo $out; $currentdownloads++; $q2 = mysql_query("UPDATE canman_users SET CurrentDownloads = '".$currentdownloads."' WHERE Username = '".$un."'"); exit;

I can't seem to figure out this problem for the life of me.

The error is this: Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /opt/lampp/htdocs/_projects/medievalbattles/current/v8_r3/httpdocs/access.php on line 139

LIne 139 is: $servername = $row["alt_name"];

Even if I comment out this entire portion of code, the error still exits (even after cleaning my entire browser cache and restarting my computer five times). I've tried cleaning my Smarty template cache, but that didn't help.

// was inevitable to requery this. maybe use memcached?
$count = 1;
$sql = "SELECT alt_name, databasename FROM ".$_MB->db_name.".servers";
$res = mysql_query($sql, $_MB->connection) or die(mysql_error());
while ($row = mysql_fetch_assoc($res))
{
$server_name = $row["alt_name"];
$server_database = $row["databasename"];

$sql2 = "SELECT serverstart, tickstart, serverend, round FROM ".$server_database.".game_info";
$res2 = mysql_query($sql2, $_MB->connection) or die(mysql_error());
$row2 = mysql_fetch_assoc($res2);
$time_data[$server_name]["serverstart"] = $row2["serverstart"];
$time_data[$server_name]["tickstart"] = $row2["tickstart"];
$time_data[$server_name]["serverend"] = $row2["serverend"];
$time_data[$server_name]["round"] = $row2["round"];

$count++;
}

$verifylogin = "yes";
include("header.php");

$sql = "SELECT name, prestige, rank, kills, verified FROM ".$_MB->db_name.".accounts WHERE id = '".$_SESSION["account_id"]."'";
$res = mysql_query($sql, $_MB->connection) or die(mysql_error());
$row = mysql_fetch_assoc($res);
$_SMARTY->assign("account_data", $row);

//if ($user_verified != "y")
//    $_MB->redirectuser("user_validate.php", "");

if ($_SESSION["successful_reg"] == "1")
{
    unset($_SESSION["successful_reg"]);
    unset($_SESSION["msg"]);
    $_SESSION["cdbname"] = $cdbname;
    $_SESSION["cloggedin"] = "yes";
    $_SESSION["loggedin"] = 1;

    header("Refresh: 5; game/overview.php");
    exit();
}
else
{
    $_SMARTY->assign("msg", $_MB->resultmessage());
    unset($_SESSION["msg"]);

    if ($_POST["login"])
    {
        $game = $_POST["game"];
        $_MB->use_db = $_POST["db"];
        $non_bar_clock = date("M d, y - h:ia");
        $clock = $_MB->month." ".$_MB->time;

        $sql = "SELECT id FROM ".$_MB->use_db.".users WHERE accountid = '".$_SESSION["account_id"]."'";
        $res = mysql_query($sql, $_MB->connection) or die(mysql_error());
        if (mysql_num_rows($res))
        {
            $row = mysql_fetch_assoc($res);
            $userid = $row["id"];

            $sql = "SELECT tpw FROM ".$_MB->db_name.".servers WHERE id = '".$game."'";
            $res = mysql_query($sql, $_MB->connection) or die(mysql_error());
            $row = mysql_fetch_assoc($res);
                $ticks_per_week = $row["tpw"];

            $sql = "UPDATE ".$_MB->use_db.".user_aids SET timer = '".$ticks_per_week."' WHERE user_id = '".$userid."'";
            mysql_query($sql, $_MB->connection) or die(mysql_error());

            $sql = "UPDATE ".$_MB->use_db.".users SET online = 'y', lastlogin = '".$clock."' WHERE id = '".$userid."'";
            mysql_query($sql, $_MB->connection) or die(mysql_error());

            $sql = "INSERT INTO ".$_MB->use_db.".user_online (id, userid, time, ip) VALUES ('', '".$userid."', '".$clock."', '".$_SERVER["REMOTE_ADDR"]."')";
            mysql_query($sql, $_MB->connection) or die(mysql_error());

            $_SESSION["cdbname"] = $_MB->use_db;
            $_SESSION["cloggedin"] = "yes";
            redirectuser("game/overview.php", "");
        }
        else
            redirectuser("access.php", "You do not have an empire on that server.");
    }

    if ($_POST["gameregistration"])
    {
        // Empire creation
        $game = $_POST["game"];
        $_MB->use_db = $_POST["db"];
        $sql = "SELECT * FROM ".$_MB->db_name.".servers WHERE id = '".$game."'";
        $res = mysql_query($sql, $_MB->connection) or die(mysql_error());
        if (mysql_num_rows($res))
        {
            $sql = "SELECT * FROM ".$_MB->use_db.".users WHERE accountid = '".$_SESSION["account_id"]."'";
            $res = mysql_query($sql, $_MB->connection) or die(mysql_error());
            if (!mysql_num_rows($res))
            {
                $_SMARTY->assign("create_empire", TRUE);
                $_SMARTY->assign("db", $_MB->use_db);
                $_SMARTY->assign("game", $game);

                $sql = "SELECT id, name FROM ".$_MB->db_name.".races ORDER BY name ASC";
                $res =mysql_query($sql, $_MB->connection) or die(mysql_error());
                $row = mysql_fetch_assoc($res);
                $_SMARTY->assign("races", $row);

                $sql = "SELECT id, name FROM ".$_MB->db_name.".classes ORDER BY name ASC";
                $res =mysql_query($sql, $_MB->connection) or die(mysql_error());
                $row = mysql_fetch_assoc($res);
                $_SMARTY->assign("classes", $row);
            }
            else
                redirectuser("access.php", "You already have an empire on that server.");
        }
    }
    else
    {
        $sql = "SELECT id, alt_name, databasename, gametype FROM ".$_MB->db_name.".servers";
        $res = mysql_query($sql, $_MB->connection) or die(mysql_error());
        $row = mysql_fetch_assoc($res);
        $_SMARTY->assign("server_list", $row);

        // was inevitable to requery this. maybe use memcached?
        $count = 1;
        $sql = "SELECT id, alt_name, databasename, gametype FROM ".$_MB->db_name.".servers";
        $res = mysql_query($sql, $_MB->connection) or die(mysql_error());
        while ($row = mysql_fetch_assoc($res))
        {
            $server_alt_name = $row["alt_name"];
            $_MB->use_db = $row["databasename"];

            $sql2 = "SELECT serveractive FROM ".$_MB->use_db.".game_info";
            $res2 =mysql_query($sql2, $_MB->connection) or die(mysql_error());
            $row2 = mysql_fetch_assoc($res2);
                $server_data[$server_alt_name]["active"] = $row2["serveractive"];

            $sql2 = "SELECT empirename FROM ".$_MB->use_db.".users WHERE accountid = '".$_SESSION["account_id"]."'";
            $res2 =mysql_query($sql2, $_MB->connection) or die(mysql_error());
            $row2 = mysql_fetch_assoc($res2);
                $server_data[$server_alt_name]["empire"] = $row2["empirename"];

`            $count++;
        }

        $_SMARTY->assign("server_loop_max", $count);
        $_SMARTY->assign("server_data", $server_data);
    }

    $sql = "SELECT alt_name, databasename FROM ".$_MB->db_name.".servers";
    $res = mysql_query($sql, $_MB->connection) or die(mysql_error());
    $_SMARTY->assign("server_time", mysql_fetch_assoc($res));

    // was inevitable to requery this. maybe use memcached?
    $count = 1;
    $sql = "SELECT alt_name, databasename FROM ".$_MB->db_name.".servers";
    $res = mysql_query($sql, $_MB->connection) or die(mysql_error());
    while ($row = mysql_fetch_assoc($res))
    {
        $server_name = $row["alt_name"];
        $server_database = $row["databasename"];

        $sql2 = "SELECT serverstart, tickstart, serverend, round FROM ".$server_database.".game_info";
        $res2 = mysql_query($sql2, $_MB->connection) or die(mysql_error());
        $row2 = mysql_fetch_assoc($res2);
            $time_data[$server_name]["serverstart"] = $row2["serverstart"];
            $time_data[$server_name]["tickstart"] = $row2["tickstart"];
            $time_data[$server_name]["serverend"] = $row2["serverend"];
            $time_data[$server_name]["round"] = $row2["round"];

        $count++;
    }

    $_SMARTY->assign("time_loop_max", $count);
    $_SMARTY->assign("time_data", $time_data);
}

$_SMARTY->display("pages/access.tpl");

include("footer.php");
?>

$grabClients = mysql_query("SELECT Client_ID, Client_Company FROM Clients ORDER BY Client_Company ASC") or die(mysql_error()); if (mysql_num_rows($grabClients) == 0) { $clientList = ""; $shippingList = ""; } else { $clientList = ""; $shippingList = ""; while ($loopClients = mysql_fetch_array($grabClients)) { $grabShipping = mysql_query("SELECT Address_ID, Address_Company, Client_ID FROM ShippingAddresses WHERE Client_ID = '$loopClients[Client_ID]' ORDER BY Address_ID ASC") or die(mysql_error()); if (mysql_num_rows($grabShipping) == 0) { $clientList .= ""; } else { $clientList .= ""; $shippingList .= ""; while ($loopShipping = mysql_fetch_array($grabShipping)) { $shippingList .= ""; } $shippingList .= ""; } } }

Как получить деньги?

Как получить деньги?