<?
function uploadSeries()
{
echo "Uploading Picture<br/>";
$uploadDirectory = "/var/www/localhost/htdocs/seiyuu/pictures/";
$fileName = $_FILES['userfile']['name'];
$tmpName = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$userfilename = $_POST['picturename'];
$seriesname = $_POST['seriesname'];
if ($userfilename == "") $userfilename = $fileName;
$filepath = $uploadDirectory.$fileName;
$moveresult = move_uploaded_file($tmpName,$filepath);
if (!$moveresult) echo "Error Moving File<br/>";
//read and open the file using C statements 0.o
//$content now holds the "mediumblob" data
if (!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
}
$tmpPath = "pictures/".$fileName;
$query = "INSERT INTO series(name, picname, picSize, picType, picPath) ".
"VALUES('$seriesname', '$userfilename', '$fileSize', '$fileType', '$tmpPath')";
mysql_query($query) or die ("<b>Could Not Upload ".$userfilename. " <br/>");
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//end of uploading
?>
<?
function checkForSeries($series)
{
$query = "SELECT name FROM series WHERE name=\"$series\"";
$result = mysql_query($query) or die ("Could Not Select Series (02)");
//echo $query."<br/>";
$numofrows = mysql_num_rows($result);
//echo $numofrows;
if ($numofrows > 0) return true;
else return false;
}
?>
<?
function DisplaySeriesInput()
{
echo "<h4>Enter New Series Name</h4><br/>";
echo "
<form action=\"newseriespage.php\" method=\"post\" enctype=\"multipart/form-data\">
Name of Series: <input type=\"text\" name=\"seriesname\"/><br/><br/>
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"20000000\">
Series Logo: <input name='userfile' type='file'>
<input type=\"hidden\" name='fileselected' value='false'>
<br/>
<input type=\"submit\" name =\"upload\" value=\"Submit\"/>
</form>
";
}
?>
<?
function DisplayCharacterInput()
{
$name = $_GET['series'];
echo "<h3>".$name."</h3><br/>";
$url = "?series=".urlencode($_GET['series'])."&addnewcharacter=false";
//$url = "?series=".$_GET['series']."&addnewcharacter=false";
echo "
<form action=\"addcharacter.php?series=$name\" method=\"post\" enctype=\"multipart/form-data\">
Character Name<input type='text' name='charactername'><br/>\n
<b>Japanese Voice Actor/Actress</b><br/>
Name<input type='text' name='japanesename'><br/>\n
<!--Last (Family) Name<input type='text' name='valastname'><br/>-->\n
<b>English Voice Actor/Actress</b><br/>\n
Name<input type='text' name='englishname'><br/>\n
<!-- Last Name<input type='text' name='englishlastname'><br/>-->\n
<input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"20000000\">\n
Picture of Character (read this) <input type='file' name='userfile'><br/>\n
<input type='submit' name='upload' value='Submit'>
</form>
<br/>
Click <a href=$url> here </a> to return to character list.<br/>
<br/>
<br/>
";
echo "<i> Family names are what we normally consider \"last names\". Please be sure on the order. If you are not sure, consult wikipedia.</i><br/>";
}
?>
<?
function DisplaySeries()
{
$query = "SELECT name, picPath FROM series ORDER BY name";
$result = mysql_query($query) or die ("Could Not Select Data");
$currentLetter = "A";
$previous = "";
while ( list($nameofseries, $picturePath) = mysql_fetch_array($result) )
{
$currentLetter = $nameofseries[0];
echo "<div class=\"flashybox\">\n";
if ($currentLetter !== $previous)
{
echo "<b>".$nameofseries[0]."</b><br/>";
}
$previous = $currentLetter;
echo "<a href=\"addcharacter.php?series=$nameofseries&addnewcharacter=false\">";
echo "$nameofseries";
echo "<br/>\n";
// echo "<span>";
echo "<img src=\"".$picturePath."\">";
echo "</a>\n";
//echo "</span></a>\n";
echo "<br/>";
echo "</div>\n\n\n";
}
}
?>
<?
//search function
function displayResults()
{
$enteredstring = $_POST['searchterm'];
///////////////////////////////////////////////
/* SEARCH BY NAME*/
//////////////////////////////////////////////
$namePieces = explode(" ", $enteredstring);
$firstname = $namePieces[0];
$lastname = $namePieces[1];
//echo "<b>Trying To See if Any People Match<br/></b>";
$query = "SELECT * FROM people WHERE firstname=\"$firstname\" AND lastname=\"$lastname\"";
$result_from_people = mysql_query($query) or die ("Could Not Try To Find People");
$num = mysql_num_rows($result_from_people);
//default variables
$people_found = false;
$found_series = false;
$found_characters = false;
if ($num >= 1)
{
echo "<i>People Were Found. Continuing with Search<br/></i>";
$people_found = true;
}
//else echo "No People Were Found<br/>";
/////////////////////////Add others in here
//**Now Check For A Series
if ($people_found === false)
{
//echo "searching for series $enteredstring<br/>";
$query = "SELECT name, picname FROM series WHERE name=\"$enteredstring\"";
$result = mysql_query($query);
$numfound = mysql_num_rows($result);
echo $numfound;
if (!$result) echo "Could Not Search for Characters<br/>";
if (mysql_num_rows($result) > 0)
{
$found_series = true;
while ( list($name,$picname) = mysql_fetch_array($result))
{
$location ="Location: ./addcharacter.php?series=$name&addcharacter=false";
header($location);
}
}
}
if ($people_found === true)
{
$query = "SELECT * FROM characters WHERE vafirstname=\"$firstname\" AND valastname=\"$lastname\"";
$result_from_characters = mysql_query($query) or die ("Could Not Try To Find Characters");
$num = mysql_num_rows($result_from_characters);
$found_characters = true;
if ($num <= 0)
{
//Look for English VAs
echo "<b>Did Not Find Any Characters With that Japanese Name <br/></b>";
$query = "SELECT * FROM characters WHERE englishfirstname=\"$firstname\" AND englishlastname=\"$lastname\"";
$result_from_characters = mysql_query($query) or die ("Could Not Try To Find Characters");
$num = mysql_num_rows($result_from_characters);
$found_characters = true;
}
//should have found someone by now
//CHARACTER PRINTING
if ($found_characters === true AND $people_found === true)
{
//print out characters here
$vafirstname = $firstname;
$valastname = $lastname;
$getpeoplequery = "SELECT name, series, picname FROM characters WHERE (vafirstname=\"$firstname\" OR valastname=\"$lastname\")
OR ( englishfirstname=\"$firstname\" OR englishlastname=\"$lastname\") ORDER BY series";
$result = mysql_query($getpeoplequery) or die ("Did Not Select Any Characters");
echo "<h2>All Characters Played By ".$vafirstname." ".$valastname."</h2><br/><br/>";
$people = $result;
$count = 0;
$previousseries= "";
while ( list($nameofcharacter, $series, $picname) = mysql_fetch_array($people) )
{
if ($previousseries != $series)
{
//print out series name
//$series = urlencode($series);
echo "<h3><a href=\"addcharacter.php?series=$series&addnewcharacter=false\">".$series."</a></h3>";
}
$previousseries = $series;
$pathtopicture = "picturescharacters/".$picname;
echo $nameofcharacter."<br/>";
echo "<img src=\"$pathtopicture\"><br/>";
}
}
/////end of character printing code
////SERIES PRINTING
if ($found_series == true AND $people_found == false)
{
}
////CHARACTER PRINTING (Individual basis/searching)
if ($found_characters == true AND $people_found == false)
{
}
if ($found_characters == false AND $people_found == false AND $found_series == false)
{
echo "No Results Were Found<br/>";
}
}//end of people_found == true
}//end of function
?>
<?
function getCharacters()
{
$firstname = $_GET['vafirstname'];
$lastname = $_GET['valastname'];
$getpeoplequery = "SELECT name, series, picname FROM characters WHERE (vafirstname=\"$firstname\" AND valastname=\"$lastname\")
OR ( englishfirstname=\"$firstname\" AND englishlastname=\"$lastname\") ORDER BY series";
//echo $getpeoplequery."<br/>";
$result = mysql_query($getpeoplequery) or die ("Could Not Select Characters");
return $result;
}
?>
<?
function showCharactersFromSeries()
{
$vafirstname = $_GET['vafirstname'];
$valastname = $_GET['valastname'];
echo "<h3>All Characters Played By ".$vafirstname." ".$valastname."</h3><br/>";
$people = getCharacters();
$count = 0;
$previousseries= "";
while ( list($nameofcharacter, $series, $picname) = mysql_fetch_array($people) )
{
if ($previousseries != $series)
{
//print out series name
//$series = urlencode($series);
echo "<h3><a href=\"addcharacter.php?series=$series&addnewcharacter=false\">".$series."</a></h3>";
}
$previousseries = $series;
$pathtopicture = "picturescharacters/".$picname;
echo $nameofcharacter."<br/>";
echo "<img src=\"$pathtopicture\"><br/>";
}
}
?>
<?
function displayCharacters()
{
$nameofseries = $_GET['series'];
$nameofseries = stripslashes($nameofseries);
echo "<h2>".$nameofseries."</h2><br/>";
$printEnglish = "true";
if ($_GET['addnewcharacter'] !== "true" OR !isset($_GET['addnewcharacter']))
{
$query = "SELECT name,series, picname, vafirstname, valastname, englishfirstname, englishlastname FROM characters WHERE series=\"".$_GET['series']."\" ORDER BY name";
$result = mysql_query($query) or die ("Could Not Select Characters");
$numrows = mysql_num_rows($result);
if ($numrows > 0)
{
while ( list($name,$series,$picName,$vafirstname,$valastname, $engfirst, $englast) = mysql_fetch_row($result) )
{
if ($engfirst === "None" OR $engfirst === "none" OR $englast === "None" OR $englast === "none")
{
$printEnglish = "false";
echo "was false";
}
else $printEnglish = "true";
$picPath = "picturescharacters/".$picName;
echo "<h4>".$name."</h4>";
echo "<a href=\"showcharacters.php?showcharacters=true&vafirstname=$vafirstname&valastname=$valastname\">";
echo "(".$vafirstname.", ".$valastname.")</a> <-- Japanese <br/>";
if ($printEnglish === "true")
{
echo "<a href=\"showcharacters.php?showcharacters=true&vafirstname=$engfirst&valastname=$englast\">";
echo "(".$engfirst.", ".$englast.")</a> <-- English ";
echo "<br/>";
}
echo "<img src=\"$picPath\">";
echo "<br/>";
echo "<br/><br/>";
}
}
else
{
//echo "No Series By That Name Was Found.<br/>";
}
}
}
return $numrows;
?>
<?
function uploadCharacter()
{
if ( ( $_POST['vafirstname'] === '') OR ( $_POST['valastname'] === '') OR ( $_POST['charactername'] === '') OR ( $_POST['userfile'] === '') )
{
echo "Not All Fields Were Completed...<br/>";
}
else
{
//all fields were completed
//echo "Adding new character to ".$_GET['series'] ."<br/>";
//code for getting ready to insert into MySQL server
$startlogicdirectory = "/home/users/web/b2919/sl.bobber205/public_html";
$uploadDirectory = "/var/www/localhost/htdocs/seiyuu/picturescharacters/";
$fileName = $_FILES['userfile']['name'];
$tmpName = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$eng = $_POST['englishname'];
$japan = $_POST['japanesename'];
$eng = explode(" ", $eng);
$japan = explode(" ", $japan);
$charactername = $_POST['charactername'];
$vafirstname = $japan[0];
$englishfirst = $eng[0];
if ( count($eng) > 2)
{
$englishlast = $eng[1]." ".$eng[2];
}
else $englishlast = $eng[1];
if (count($japan) > 2)
{
$valastname = $japan[1]." ".$japan[2];
}
else $valastname = $japan[1];
$filepath = $uploadDirectory.$fileName;
$moveresult = move_uploaded_file($tmpName,$filepath);
if (!$moveresult) echo "<b>Picture Upload Not Successful</b><br/>Please Tell Webmaster To Check Path.<br/>";
$tmpSeries = $_GET['series'];
//echo $tmpSeries."<br/>";
$query = "INSERT INTO characters(name,series,vafirstname,valastname,englishfirstname,englishlastname,picname,picType,picSize,picPath)" ."VALUES('$charactername','$tmpSeries','$vafirstname','$valastname', '$englishfirst','$englishlast','$fileName','$fileType','$fileSize','$filepath')";
mysql_query($query) or die ("Could Not Add New Character");
//make sure person isn't already in there. :)
$query = "SELECT * FROM people WHERE (firstname=\"$vafirstname\" AND lastname=\"$valastname\") OR (firstname=\"$englishfirst\" AND lastname=\"$englishlast\")" ;
//echo $query."<br/>";
$resultfrompeople = mysql_query($query) or die("Could Not Check To See If Person Exists");
$numberofrows = mysql_num_rows($resultfrompeople);
//echo $numberofrows." \$numberofrows<br/>";
if ($numberofrows <= 0)
{
$query = "INSERT INTO people(firstname,lastname) VALUES('$vafirstname','$valastname')";
mysql_query($query) or die ("Could Not Add New Person To Database");
}
}
}
?>