";
$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
";
//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 ("Could Not Upload ".$userfilename. "
");
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//end of uploading
?>
";
$numofrows = mysql_num_rows($result);
//echo $numofrows;
if ($numofrows > 0) return true;
else return false;
}
?>
Enter New Series Name
";
echo "
";
}
?>
".$name."
";
$url = "?series=".urlencode($_GET['series'])."&addnewcharacter=false";
//$url = "?series=".$_GET['series']."&addnewcharacter=false";
echo "
Click here to return to character list.
";
echo " Family names are what we normally consider \"last names\". Please be sure on the order. If you are not sure, consult wikipedia.
";
}
?>
\n";
if ($currentLetter !== $previous)
{
echo "".$nameofseries[0]."
";
}
$previous = $currentLetter;
echo "";
echo "$nameofseries";
echo "
\n";
// echo "";
echo "![](\"".$picturePath."\")
";
echo "\n";
//echo "\n";
echo "
";
echo "\n\n\n";
}
}
?>
Trying To See if Any People Match
";
$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 "People Were Found. Continuing with Search
";
$people_found = true;
}
//else echo "No People Were Found
";
/////////////////////////Add others in here
//**Now Check For A Series
if ($people_found === false)
{
//echo "searching for series $enteredstring
";
$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
";
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 "Did Not Find Any Characters With that Japanese Name
";
$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 "All Characters Played By ".$vafirstname." ".$valastname."
";
$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 "";
}
$previousseries = $series;
$pathtopicture = "picturescharacters/".$picname;
echo $nameofcharacter."
";
echo "![](\"$pathtopicture\")
";
}
}
/////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
";
}
}//end of people_found == true
}//end of function
?>
";
$result = mysql_query($getpeoplequery) or die ("Could Not Select Characters");
return $result;
}
?>
All Characters Played By ".$vafirstname." ".$valastname."
";
$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 "";
}
$previousseries = $series;
$pathtopicture = "picturescharacters/".$picname;
echo $nameofcharacter."
";
echo "
";
}
}
?>
".$nameofseries."
";
$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 "".$name."
";
echo "";
echo "(".$vafirstname.", ".$valastname.") <-- Japanese
";
if ($printEnglish === "true")
{
echo "";
echo "(".$engfirst.", ".$englast.") <-- English ";
echo "
";
}
echo "![](\"$picPath\")
";
echo "
";
echo "
";
}
}
else
{
//echo "No Series By That Name Was Found.
";
}
}
}
return $numrows;
?>
";
}
else
{
//all fields were completed
//echo "Adding new character to ".$_GET['series'] ."
";
//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 "Picture Upload Not Successful
Please Tell Webmaster To Check Path.
";
$tmpSeries = $_GET['series'];
//echo $tmpSeries."
";
$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."
";
$resultfrompeople = mysql_query($query) or die("Could Not Check To See If Person Exists");
$numberofrows = mysql_num_rows($resultfrompeople);
//echo $numberofrows." \$numberofrows
";
if ($numberofrows <= 0)
{
$query = "INSERT INTO people(firstname,lastname) VALUES('$vafirstname','$valastname')";
mysql_query($query) or die ("Could Not Add New Person To Database");
}
}
}
?>