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) {