function GetBoardColor2($colorNumber)
{
$colorNumber = ltrim($colorNumber, "#");
$colorNumber = chunk_split($colorNumber, 2, ':');
$color = explode(":", $colorNumber);
$colorRed = hexdec($color[0]);
$colorGreen = hexdec($color[1]);
$colorBlue = hexdec($color[2]);
$colorRed = AddValue($colorRed, "24");
$colorGreen = AddValue($colorGreen, "24");
$colorBlue = AddValue($colorBlue, "24");
$colorRed = dechex($colorRed);
$colorGreen = dechex($colorGreen);
$colorBlue = dechex($colorBlue);
if (strlen($colorRed) < 2) {
$colorRed = "0{$colorRed}";
}
if (strlen($colorGreen) < 2) {
$colorGreen = "0{$colorGreeen}";
}
if (strlen($colorBlue) < 2) {
$colorBlue = "0{$colorBlue}";
}
$colorNumber = "#{$colorRed}{$colorGreen}{$colorBlue}";
//echo "GetBoardColors.php colorNumber: $colorNumber";
return $colorNumber;
}
$responseList = implode(",", $responseURLArray);
}
// if
$count = 0;
// Related video code
$commaseparatedURL = "";
$relatedURLArray = array();
if ($video->relatedURL) {
$type = "Related:" . $ytID_in;
$relatedFeed = simplexml_load_file($video->relatedURL);
foreach ($relatedFeed->entry as $related) {
$video_in = parseVideoEntry($related);
$timestamp_in = time();
echo "Related Video Title" . "\n";
echo $video_in->title;
$queryRelated = AddValue($oTableName_in, $video_in, $qid_in, $timestamp_in, $today_in, $relatedURLArray, $count, $type, $dbh);
echo "Related Query:" . "\n";
$result = mysql_query($queryRelated) or mysql_error();
}
$commaseparatedURL = implode(",", $relatedURLArray);
}
// if
// Start formualting the Query
$query = "INSERT INTO {$oTableName_in} ";
$query = $query . "VALUES('','{$qid_in}','{$ytID_in}','{$timestamp}','','','{$today_in}','{$typeMain}'";
$dquery = "SHOW COLUMNS FROM {$oTableName_in}";
$result = mysql_query($dquery) or mysql_error();
$queryRelated = array();
while ($line = mysql_fetch_assoc($result)) {
$fieldName = $line['Field'];
switch ($fieldName) {
