This is part two....
<html>
<head>
<title>EPK Creator</title>
<script language="JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</head>
<style type="text/css">
BODY {
margin-bottom:0;
margin-top:0;
margin-right:0;
margin-left:0;
background-color:black;
scrollbar-face-color:black;
scrollbar-highlight-color:black;
scrollbar-3dlight-color:gray;
scrollbar-darkshadow-color:black;
scrollbar-shadow-color: black;
scrollbar-arrow-color:gray;
scrollbar-track-color:black;
}
</style>
<style type="text/css">
.submit { width: 74px; height: 34px; display:block; }
.image1 { background:url(/bschedule/bsadmin/images/uploadflyer.gif); width: 154px; height: 34px; display:block; }
.image2 { background:url(/bschedule/bsadmin/images/emailclear.gif); width: 74px; height: 34px; display:block; }
</style>
<style>
textarea{
background-image:url(/bschedule/bsadmin/images/showdetailback.jpg); background-attachment: fixed;
color:000000; }
</style>
<style type="text/css">
input {background-image:url(/bschedule/bsadmin/images/textinputback.jpg)}
</style>
<style type="text/css">
SELECT {
{background-image:url(/bschedule/bsadmin/images/textinputback.jpg)
}
</style>
<body bgcolor="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" text="#FFFFFF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="36">
<table width="100%" border="0" background="/bschedule/bsadmin/images/headerback.gif" cellspacing="0" cellpadding="0">
<tr>
<td height="60" width="6%"><img src="/bschedule/bsadmin/images/logosmall.gif" width="181" height="58"></td>
<td height="60" width="94%">
<div align="right"><font face="Arial, Helvetica, sans-serif"><b><font color="#CCCC00">EPK
Creator </font></b></font></div>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="2">
<?php include("header.php") ?>
</tr>
</table>
<div align="center"><?php
$getuid = $_POST['uid'];
$getdate = $_POST['date'];
$getname = $_POST['name'];
$getlocation = $_POST['location'];
$getwebsite = $_POST['website'];
$getemail = $_POST['email'];
$getprimegenre = $_POST['primegenre'];
$getsecondgenre = $_POST['secondgenre'];
$getcontact = $_POST['contact'];
$getstagebio = $_POST['stagebio'];
$getmembers = $_POST['members'];
$getbio = $_POST['bio'];
$getinstrument = $_POST['instrument'];
$getfestconf = $_POST['festconf'];
$getawards = $_POST['awards'];
$getdistribution = $_POST['distribution'];
$getdiscovery = $_POST['discovery'];
$getcompilations = $_POST['agcompilationses'];
$getbroadcasts = $_POST['broadcasts'];
$getsetlist = $_POST['setlist'];
$getcovers = $_POST['covers'];
$getreqsolo = $_POST['reqsolo'];
$getreqband = $_POST['reqband'];
$getlabel = $_POST['pressinfo'];
$getpressinfo = $_POST['pressinfo'];
$stagebio = str_replace("\n","<BR>",$stagebio);
$stagebio = str_replace(" "," ",$stagebio);
$bio = str_replace("\n","<BR>",$bio);
$bio = str_replace(" "," ",$bio);
$setlist = str_replace("\n","<BR>",$setlist);
$setlist = str_replace(" "," ",$setlist);
$members = str_replace("\n","<BR>",$members);
$members = str_replace(" "," ",$members);
$reqsolo = str_replace("\n","<BR>",$reqsolo);
$reqsolo = str_replace(" "," ",$reqsolo);
$reqband = str_replace("\n","<BR>",$reqband);
$reqband = str_replace(" "," ",$reqband);
$pressinfo = str_replace("\n","<BR>",$pressinfo);
$pressinfo = str_replace(" "," ",$pressinfo);
if (1==1) {
//echo $getdate."<br>".$getname."<br>".$getlocation."<br>".$getwebsite."<br>".$getemail."<br>".$getprimegenre."<br>".$getsecondgenre."<br>".$getcontact."<br>".$getstagebio."<br>".$getmembers."<br>".$getbio."<br>".$getinstrument."<br>".$getfestconf."<br>".$getawards."<br>".$getdistribution."<br>".$getdiscovery."<br>".$getcompilations."<br>".$getbroadcasts."<br>".$getsetlist."<br>".$getcovers."<br>".$getreqsolo."<br>".$getreqband."<br>".$getlabel."<br>".$getpressinfo ;
// read in the connection settings
require("dbconnection.txt");
// connect to the RDBMS
$db = mysql_connect("$site","$user","$pass")
or die_now("<h2>Could not connect to database server</h2><p>Check passwords and sockets</p>");
// get data from table
$result=mysql_query("SELECT FROM epk");
// select the database
mysql_select_db("$database",$db)
or die_now("<h2>Could not select database $database</h2><p>Check database name</p>");
$query = "INSERT INTO epk VALUES ($getuid,NOW(),'$name','$location','$website','$email','$primegenre','$secondgenre','$contact','$stagebio','$members','$bio','$songtitle','$songtitletwo','$songtitlethree','$songtitlefour','$songtitlefive','$songlink','$songlinktwo','$songlinkthree','$songlinkfour','$songlinkfive','$instrument','$festconf','$awards','$distribution','$discovery','$compilations','$broadcasts','$setlist','$covers','$reqsolo','$reqband','$label','$pressinfo','$bandpic','$bandlogo','')";
$result = mysql_query($query)or die("Could not do a mysql query. Reason why: ".mysql_error());
echo "Information added. Now add your artist pic and logo and up to 5 songs. The music MUST be in mp3 format.";
$sqlQ = "SELECT * FROM epk WHERE uid = '$getuid'";
$sqlR = mysql_query($sqlQ);
if(mysql_num_rows($sqlR)==1){
$epkinfo = mysql_fetch_assoc($sqlR);
?></div>
<form method="post" enctype="multipart/form-data" action="/bschedule/bsadmin/epkenter3.php">
<?php
echo "<INPUT TYPE=\"hidden\" name=\"id\" value=\"".$epkinfo['id']."\">\n";
} else {
echo "Invalid mySQL result [".mysql_num_rows($sqlR)."]";
}
}
?>
<div align="center">
<input type="hidden" name="action" value="do_upload">
<table width="100%" border="0">
<tr bgcolor="#666666">
<td colspan="4"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><b>Images</b></font></td>
</tr>
<tr>
<td width="15%"><font size="2" face="Arial, Helvetica, sans-serif">Band
Pic:</font> </td>
<td width="35%">
<input type="file" name="userfile">
</td>
<td width="15%">
<div align="right"><font size="2" face="Arial, Helvetica, sans-serif">Band
Logo:</font></div>
</td>
<td width="35%">
<input type="file" name="userfile2">
</td>
</tr>
<tr bgcolor="#666666">
<td colspan="4" height="8"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><b>Music
</b><font color="#CCCCCC" size="1">(Remember music has to be in MP3
format)</font></font> </td>
</tr>
<tr>
<td width="15%"><font size="2" face="Arial, Helvetica, sans-serif">Song
1 Name:</font></td>
<td width="35%">
<input type="text" name="songtitle">
</td>
<td width="15%">
<div align="right"><font size="2" face="Arial, Helvetica, sans-serif">File:</font></div>
</td>
<td width="35%">
<input type="file" name="userfile3">
</td>
</tr>
<tr>
<td width="15%"><font size="2" face="Arial, Helvetica, sans-serif">Song
2 Name:</font></td>
<td width="35%">
<input type="text" name="songtitletwo">
</td>
<td width="15%">
<div align="right"><font size="2" face="Arial, Helvetica, sans-serif">File:</font></div>
</td>
<td width="35%">
<input type="file" name="userfile4">
</td>
</tr>
<tr>
<td width="15%"><font size="2" face="Arial, Helvetica, sans-serif">Song
3 Name:</font></td>
<td width="35%">
<input type="text" name="songtitlethree">
</td>
<td width="15%">
<div align="right"><font size="2" face="Arial, Helvetica, sans-serif">File:</font></div>
</td>
<td width="35%">
<input type="file" name="userfile5">
</td>
</tr>
<tr>
<td width="15%"><font size="2" face="Arial, Helvetica, sans-serif">Song
4 Name:</font></td>
<td width="35%">
<input type="text" name="songtitlefour">
</td>
<td width="15%">
<div align="right"><font size="2" face="Arial, Helvetica, sans-serif">File:</font></div>
</td>
<td width="35%">
<input type="file" name="userfile6">
</td>
</tr>
<tr>
<td width="15%"><font size="2" face="Arial, Helvetica, sans-serif">Song
5 Name:</font></td>
<td width="35%">
<input type="text" name="songtitlefive">
</td>
<td width="15%">
<div align="right"><font size="2" face="Arial, Helvetica, sans-serif">File:</font></div>
</td>
<td width="35%">
<input type="file" name="userfile7">
</td>
</tr>
<tr>
<td colspan="4">
<div align="center">
<input type="submit" name="submit" value="" class="image1">
</div>
</td>
</tr>
</table>
</div>
</form>
</p>
<p> </p>
</body>
</html>
(reply is the rest of it)