}
//
if ($channel != "-1" && !empty($name) && !empty($twitter_id) && !empty($handle)) {
if (!checkForNameDuplicate($name)) {
$sql = $connect->query("INSERT INTO `shows` VALUES('', '{$name}', '{$channel}', '{$handle}', '{$twitter_id}', '{$dayOfWeek}', '{$time}', '{$runTime}', '{$newEpisodes}', '{$inSyndication}', '{$afterbuzz}', '{$showPageNetworkLink}', '{$seasonCode}', '{$youtubePageLink}', '{$facebookPageLink}', '')");
if ($sql) {
echo "{$name} was added successfully";
} else {
echo "Error Occured";
}
} else {
//add to other table if passes validation
if (!checkSecondaryTable($name, $channel)) {
require 'classes.php';
$classes = new topic();
$mainChannel = $classes->getChannelIdFromShowName($name);
if ($mainChannel != $channel) {
$sql = $connect->query("INSERT INTO `secondaryChannels` VALUES('', '{$name}', '{$mainChannel}', '{$channel}')");
if ($sql) {
echo "success";
} else {
echo "error occured";
}
} else {
echo "Show already exists on this channel";
}
} else {
echo "show already exists on this channel";
}
}
} else {
