function insertCard($card, $set)
{
$db = dbcon();
$cmc = getConvertedCost($card['Cost']);
$isw = $isu = $isb = $isr = $isg = 0;
if (preg_match("/W/", $card['Cost'])) {
$isw = 1;
}
if (preg_match("/U/", $card['Cost'])) {
$isu = 1;
}
if (preg_match("/B/", $card['Cost'])) {
$isb = 1;
}
if (preg_match("/R/", $card['Cost'])) {
$isr = 1;
}
if (preg_match("/G/", $card['Cost'])) {
$isg = 1;
}
# new gatherer - card type is now a . because of unicode
$card['Type'] = str_replace('.', '-', $card['Type']);
$query = "INSERT INTO cards(cost, convertedcost, name, cardset, type,\n\t\tisw, isu, isb, isr, isg) VALUES (\"{$card['Cost']}\", {$cmc},\n\t\t\"{$card['Name']}\", \"{$set}\", \"{$card['Type']}\", {$isw}, {$isu}, \n\t\t{$isb}, {$isr}, {$isg})";
echo "{$query}<br>\n";
mysql_query($query, $db) or die(mysql_error());
mysql_close($db);
}
function setList($set)
{
$db = dbcon();
$query = "SELECT name, isw, isg, isu, isr, isb \n\t\tFROM cards WHERE cardset=\"{$set}\"";
$result = mysql_query($query, $db);
$ret = array();
$n = 0;
while ($row = mysql_fetch_assoc($result)) {
$ret[$n] = $row;
$n++;
}
return $ret;
}
function content()
{
$db = dbcon();
$query = "CREATE TEMPORARY TABLE scores(\n\t\tid BIGINT UNSIGNED, type VARCHAR(40), score BIGINT)";
mysql_query($query, $db) or die(mysql_error());
$query = "SELECT DISTINCT decktype FROM typeinfo";
$result = mysql_query($query, $db) or die(mysql_error());
$decktypes = array();
while ($row = mysql_fetch_assoc($result)) {
$decktypes[] = $row['decktype'];
}
$query = "SELECT dc.deck, d.name, SUM(dc.qty) AS n \n\t\tFROM deckcontents dc, decks d\n\t\tWHERE dc.issideboard=0 AND d.id=dc.deck GROUP BY dc.deck\n\t\tHAVING n > 40";
$result = mysql_query($query, $db) or die(mysql_error());
while ($row = mysql_fetch_assoc($result)) {
$maxscore = -32000;
$type = "Unclassified";
for ($i = 0; $i < sizeof($decktypes); $i++) {
$score = scoredeck($row['deck'], $decktypes[$i], $db);
if ($score > $maxscore) {
$maxscore = $score;
}
if ($score > 31) {
$type = $decktypes[$i];
}
}
$query = "INSERT INTO scores(id, type, score) \n\t\t\tVALUES({$row['deck']}, \"{$type}\", {$maxscore})";
mysql_query($query, $db) or die(mysql_error());
}
$query = "SELECT s.id, s.type, s.score, d.name FROM scores s, decks d WHERE d.id=s.id ORDER BY score DESC";
$result = mysql_query($query, $db);
echo "<table>";
while ($row = mysql_fetch_assoc($result)) {
echo "<tr><td><a href=\"/gatherling/deck.php?mode=view&id={$row['id']}\">";
echo "{$row['name']}</a></td>";
echo "<td>{$row['type']} ({$row['score']})</td></tr>\n";
}
echo "</table>";
}
<tr>
<td colspan="5" class="tdfun"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#6699FF"><font color="#FFFFFF" size="2" face="arial"><b><span class="titulo">Escola
</span></b></font></td>
</tr>
</table> </tr>
<tr>
<td width="4" valign="top"> </td>
<td width="117" id="cbConsultor">Consultor</td>
<td valign="top">
<select name="cbConsultor" class="label_obrigatorio" id="cbConsultor">
<option value="0" selected="selected"></option>
<?php
dbcon();
$SQL = "SELECT idpes, nome FROM pessoa ORDER BY nome";
$result = mysql_query($SQL);
while ($array = mysql_fetch_array($result)) {
?>
<option value="<?php
echo $array["idpes"];
?>
"><?php
echo $array["nome"];
?>
</option>
<?php
}
?>
</select> </td>
<?php
require_once '../lib.php';
$db = dbcon();
header("Content-type: text/plain");
$query = "SELECT name FROM events WHERE start < NOW() ORDER BY series, season DESC, number DESC, name";
$result = mysql_query($query, $db) or die(mysql_error());
$n = 0;
while ($row = mysql_fetch_assoc($result)) {
printf("[trophy]%s[/trophy]", $row['name']);
$n++;
if ($n % 3 == 0) {
echo "\n";
}
}
<head>
<title>Job Details</title>
<!--Import PHP functions-->
<?php
require 'include/functions.inc';
?>
</head>
<?php
sessionTest();
//confirm user logged in
if (isset($_SESSION['userID'])) {
// run a query to see if the job belongs to them
$usr = $_SESSION['userID'];
$job = $_GET['jobID'];
//connect to db
$pdo = dbcon();
//select rows containing this user's ID and the selected JOB id (prevent people from accessing this page without correct privileges)
$query = "\n\t\t\t\t\tSELECT J.JobID,\n\t\t\t\t\t\tJT.JobTypeDesc,\n\t\t\t\t\t\tJ.JobDescription,\n\t\t\t\t\t\tCONCAT(V.FirstName,' ',V.LastName) as 'assignee',\n\t\t\t\t\t\tCONCAT(M.FirstName,' ',M.LastName) as 'creator',\n\t\t\t\t\t\tJ.CreatedTimestamp\n\t\t\t\t\tFROM Jobs J\n\t\t\t\t\t\tINNER JOIN JobType JT on J.JobType = JT.JobTypeID\n\t\t\t\t\t\tLEFT JOIN Users V on J.AssignedUser = V.UserID\n\t\t\t\t\t\tLEFT JOIN Users M on J.CreatedUser = M.UserID\n\t\t\t";
if ($_SESSION['userLevel'] == 2) {
$query .= " WHERE JobID = :job;";
$statement = $pdo->prepare($query);
$statement->bindValue(':job', $job);
} else {
$query .= " WHERE CreatedUser = :usr\n\t\t\t\t\t\t\t\tAND JobID = :job;\n\t\t\t\t";
$statement = $pdo->prepare($query);
$statement->bindValue(':usr', $usr);
$statement->bindValue(':job', $job);
}
$statement->execute();
//echo "statement ran \n";
//echo $statement->rowCount();
