case "9":
case "10":
global $faction;
$faction = "faction_1.jpg";
break;
}
return $faction;
}
if (isset($_GET['charname'])) {
$cont = new wowheadparser();
$conn = mysql_open($serveraddress, $serveruser, $serverpass);
$sql = "SELECT guid,name,class,level,race,gender FROM `" . $server_cdb . "`.`characters` WHERE name='" . mysql_real_escape_string($_GET["charname"]) . "'";
$num_rows = mysql_num_rows($result);
$result = mysql_query($sql, $conn) or die(mysql_error());
if ($row = mysql_fetch_array($result)) {
$items = show_items($row["guid"]);
$all = array_merge($items);
$html->load('armory', $all);
}
mysql_end($conn);
}
//Get Base stats
function baseStats($charName)
{
include 'configs.php';
mysql_select_db($server_cdb, $connection_setup) or die(mysql_error());
$sql = "SELECT guid,name,class,level,race FROM characters WHERE name='" . $charName . "'";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result);
mysql_select_db($server_wdb, $connection_setup) or die(mysql_error());
$wSql = "SELECT str,agi,sta,inte,spi,basehp as hp, basemana as mana FROM player_levelstats level,\n player_classlevelstats class WHERE level.race='" . $row['race'] . "' AND level.class='" . $row['class'] . "' AND\n level.level='" . $row['level'] . "' AND class.class='" . $row['class'] . "' AND class.level='" . $row['level'] . "'";
$result = mysqli_query($connection, $fetch_category);
while ($row = mysqli_fetch_assoc($result)) {
echo '<a href="controller.php?mode=buy&category=' . $row['category_ID'] . '" class="list-group-item">' . $row['category'] . '</a>';
}
?>
</div>
</div>
<div class="col-md-9">
<?php
$cat = null;
if (isset($_GET['category'])) {
$cat = $_GET['category'];
}
$items = show_items($cat);
if (!empty($items)) {
foreach ($items as $key => $value) {
echo '
<div class="col-sm-3 col-lg-3 col-md-3">
<div class="thumbnail">
<div class= "pict-container">
<img class="pict" src="' . $value[5] . '" alt="pic">
</div>
<div class="caption">
<h4><a href="?mode=item&id=' . $value[0] . '">' . $value[1] . '</a></h4>
</div>
</div>
</div>';
}
} else {
?>
<div class="content-container">
<div class="row">
<div class="small-12 columns">
<div class="content-wrapper">
<h1>Skills Technology</h1>
<p>I have a BS in Pyschology from the University of Pittsburgh, and am currently finishing coursework
to receive a BS in Computer Science from there as well. After completing my CS degree, I plan to enroll
in graduate school to work towards a Masters, or possibly a PhD, in Computer Science.</p>
<p>I'm currently busy doing a lot of ETL work, primarily in Python and through the use and creation
of several RESTFul APIs. I'm also currently developing more front-end skills through my job and
by through classes at the University of Pittsburgh.</p>
<p>I have a big interest in Machine Learning, and am in the early stages of developing tools that
inolve realtime analysis of civic data to provide local citizens, community groups and local government
better insights into what's happening in their area. Please check back to my
<a href="http://localhost/steve/projects.php">projects</a> page for more information on those as they
are developed.</p>
<div class="row" id="languages">
<?php
show_items($langs);
?>
</div>
</div>
</div>
</div>
</div>
<?php
include 'footer.php';
function mysql_open($serveraddress, $serveruser, $serverpass)
{
$conn = mysql_connect($serveraddress, $serveruser, $serverpass) or die(mysql_error());
return $conn;
}
function mysql_end($resc)
{
mysql_close($resc);
}
if (isset($_GET['arenaname'])) {
$cont = new wowheadparser();
$conn = mysql_open($serveraddress, $serveruser, $serverpass);
$sql = "SELECT arenaTeamId,name,captainGuid,type,rating,rank,gender FROM `" . $server_cdb . "`.`arena_team` WHERE name='" . mysql_real_escape_string($_GET["arenaname"]) . "'";
$result = mysql_query($sql, $conn) or die(mysql_error());
if ($row = mysql_fetch_array($result)) {
$items = show_items($row["arenaTeamId"]);
$all = array_merge($items);
$html->load('armory', $all);
}
mysql_end($conn);
} elseif (empty($_POST['search'])) {
} elseif (isset($_POST['search'])) {
$term = $_POST['search'];
$conn = mysql_open($serveraddress, $serveruser, $serverpass);
$sql = "SELECT arenaTeamId,name,captainGuid,type,rating,rank FROM `" . $server_cdb . "`.`arena_team` WHERE name LIKE '%" . mysql_real_escape_string($term) . "%'";
$result = mysql_query($sql, $conn) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
//Arena Type
$ttype = $row["type"];
if ($ttype == 2) {
$type = "2vs2";
echo "</tr>";
} else {
echo "<tr class=\"text\" align=\"left\">\n";
echo "<td colspan=\"4\">keine :P</td>\n";
echo "</tr>";
}
}
echo "</table>";
}
if ($bughunter = check_for_auth()) {
switch ($act) {
case "add":
add();
show_items();
show_menu();
break;
case "delete":
delete_it();
break;
case "change_status":
change_status();
break;
case "view_info":
view_info();
break;
default:
show_items();
show_menu();
break;
}
}
<div class="content-container">
<div class="row">
<div class="large-12 columns">
<div class="content-wrapper">
<h1>Projects</h1>
<h6>I'll continue to post details on current projects as I develop them.
In the meantime you can check out some of my work on
<a target="_blank" href="https://github.com/saylorsd">Github</a>.
</h6>
</div>
</div>
</div>
<div class="row">
<div class="large-12 columns">
<div class="content-wrapper">
<h2>Maps</h2>
<h6>As part of wy work at UCSUR. I've been working on creating maps using
<a target="_blank" href="http://www.cartodb.com">CartoDB</a>. Here's one (selected at random each time the page loads) one from the bunch
that I've made.
</h6>
<?php
show_items($maps);
?>
</div>
</div>
</div>
</div>
<?php
include 'footer.php';
