Ejemplo n.º 1
0
 static function drawProgressBar($percent)
 {
     static $i = 0;
     if ($percent == 'reset') {
         $i = 0;
         return;
     }
     $max = 80;
     // draw up to percent
     $ret = '';
     $new = (int) (clamp(round($percent, 1), 0.0, 1.0) * 80);
     while ($i <= $new) {
         if ($i == 0) {
             $ret .= '[';
         } elseif ($i == $max) {
             $ret .= "]\n";
         } elseif ($i % ($max / 4) == $max / 4 - 1) {
             $ret .= '|';
         } else {
             $ret .= '=';
         }
         $i++;
     }
     return $ret;
 }
Ejemplo n.º 2
0
function randombg($s, $w, $h, $bounds)
{
    $w *= $s;
    $h *= $s;
    $im = imagecreatetruecolor($w, $h);
    imagecolorallocate($im, 0, 0, 0);
    foreach (range(0, $h, $s) as $y) {
        foreach (range(0, $w, $s) as $x) {
            $color = imagecolorallocate($im, clamp(rand(0, 255), $bounds['r']), clamp(rand(0, 255), $bounds['g']), clamp(rand(0, 255), $bounds['b']));
            imagefilledrectangle($im, $x, $y, $x + $s, $y + $s, $color);
        }
    }
    header('Content-type: image/gif');
    imagegif($im);
    imagedestroy($im);
}
Ejemplo n.º 3
0
/**
 * Normalizes the given value between 0 and 1, based on the ratio between the given value and expected maximum value
 * @param int|float $value
 * @param int|float $upperBound
 * @return int|float
 */
function normalize($value, $upperBound)
{
    return clamp($value / $upperBound, 0, 1);
}
Ejemplo n.º 4
0
function yt_lib_lighten($args)
{
    list($color, $delta) = yt_colorArgs($args);
    $hsl = toHSL($color);
    $hsl[3] = clamp($hsl[3] + $delta, 100);
    return toRGB($hsl);
}
Ejemplo n.º 5
0
 /**
  * HERE WE GET THE LIST OF POOLS.
  *
  * @param \Page $page
  * @param int $pageNumber
  */
 private function list_pools(Page $page, $pageNumber)
 {
     global $config, $database;
     $pageNumber = clamp($pageNumber, 1, null) - 1;
     $poolsPerPage = $config->get_int("poolsListsPerPage");
     $order_by = "";
     $order = $page->get_cookie("ui-order-pool");
     if ($order == "created" || is_null($order)) {
         $order_by = "ORDER BY p.date DESC";
     } elseif ($order == "updated") {
         $order_by = "ORDER BY p.lastupdated DESC";
     } elseif ($order == "name") {
         $order_by = "ORDER BY p.title ASC";
     } elseif ($order == "count") {
         $order_by = "ORDER BY p.posts DESC";
     }
     $pools = $database->get_all("\n\t\t\tSELECT p.id, p.user_id, p.public, p.title, p.description,\n\t\t\t       p.posts, u.name as user_name\n\t\t\tFROM pools AS p\n\t\t\tINNER JOIN users AS u\n\t\t\tON p.user_id = u.id\n\t\t\t{$order_by}\n\t\t\tLIMIT :l OFFSET :o\n\t\t", array("l" => $poolsPerPage, "o" => $pageNumber * $poolsPerPage));
     $totalPages = ceil($database->get_one("SELECT COUNT(*) FROM pools") / $poolsPerPage);
     $this->theme->list_pools($page, $pools, $pageNumber + 1, $totalPages);
 }
Ejemplo n.º 6
0
 /**
  * @param int $current_page
  */
 private function build_page($current_page)
 {
     global $database, $user;
     $where = SPEED_HAX ? "WHERE posted > now() - interval '24 hours'" : "";
     $total_pages = $database->cache->get("comment_pages");
     if (empty($total_pages)) {
         $total_pages = (int) ($database->get_one("\n\t\t\t\tSELECT COUNT(c1)\n\t\t\t\tFROM (SELECT COUNT(image_id) AS c1 FROM comments {$where} GROUP BY image_id) AS s1\n\t\t\t") / 10);
         $database->cache->set("comment_pages", $total_pages, 600);
     }
     $total_pages = max($total_pages, 1);
     $current_page = clamp($current_page, 1, $total_pages);
     $threads_per_page = 10;
     $start = $threads_per_page * ($current_page - 1);
     $result = $database->Execute("\n\t\t\tSELECT image_id,MAX(posted) AS latest\n\t\t\tFROM comments\n\t\t\t{$where}\n\t\t\tGROUP BY image_id\n\t\t\tORDER BY latest DESC\n\t\t\tLIMIT :limit OFFSET :offset\n\t\t", array("limit" => $threads_per_page, "offset" => $start));
     $user_ratings = ext_is_live("Ratings") ? Ratings::get_user_privs($user) : "";
     $images = array();
     while ($row = $result->fetch()) {
         $image = Image::by_id($row["image_id"]);
         if (ext_is_live("Ratings") && !is_null($image) && strpos($user_ratings, $image->rating) === FALSE) {
             $image = null;
             // this is "clever", I may live to regret it
         }
         if (!is_null($image)) {
             $comments = $this->get_comments($image->id);
             $images[] = array($image, $comments);
         }
     }
     $this->theme->display_comment_list($images, $current_page, $total_pages, $user->can("create_comment"));
 }
function blc_latest_comments($num_posts = 5, $num_comments = 6, $hide_pingbacks_and_trackbacks = true, $prefix = "<li class='alternate'>", $postfix = "</li>", $fade_old = true, $range_in_days = 10, $new_col = "#444444", $old_col = "#cccccc")
{
    global $wpdb;
    function clamp($min, $max, $val)
    {
        return max($min, min($max, $val));
    }
    $usetimesince = function_exists('time_since');
    // Work nicely with Dunstan's Time Since plugin (adapted by Michael Heilemann)
    // This is compensating for the lack of subqueries in mysql 3.x
    // The approach used in previous versions needed the user to
    // have database lock and create tmp table priviledges.
    // This uses more queries and manual DISTINCT code, but it works with just select privs.
    if (!$hide_pingbacks_and_trackbacks) {
        $ping = "";
    } else {
        $ping = "AND comment_type<>'pingback' AND comment_type<>'trackback'";
    }
    $posts = $wpdb->get_results("SELECT \r\n\t\tcomment_post_ID, post_title \r\n\t\tFROM ({$wpdb->comments} LEFT JOIN {$wpdb->posts} ON (comment_post_ID = ID))\r\n\t\tWHERE comment_approved = '1' \r\n\t\tAND {$wpdb->posts}.post_status='publish'\r\n\t\t{$ping}\r\n\t\tORDER BY comment_date DESC;");
    $seen = array();
    $num = 0;
    if ($fade_old) {
        $max_time = $range_in_days * 24 * 60 * 60;
        $r_new = hexdec(substr($new_col, 1, 2));
        $r_old = hexdec(substr($old_col, 1, 2));
        //$r_min = min($min, $max);
        //$r_max = max($min, $max);
        $r_range = $r_old - $r_new;
        $g_new = hexdec(substr($new_col, 3, 2));
        $g_old = hexdec(substr($old_col, 3, 2));
        //$g_min = min($min, $max);
        //$g_max = max($min, $max);
        $g_range = $g_old - $g_new;
        $b_new = hexdec(substr($new_col, 5, 2));
        $b_old = hexdec(substr($old_col, 5, 2));
        //$b_min = min($min, $max);
        //$b_max = max($min, $max);
        $b_range = $b_old - $b_new;
    }
    //	print "ranges: $r_range, $g_range, $b_range<br>";
    //	print "r: ".(0.5*$r_range+$r_new)."<br>";
    foreach ($posts as $post) {
        // The following 5 lines is a manual DISTINCT and LIMIT,
        // since mysql 3.x doesn't allow you to control which way a DISTINCT
        // select merges multiple entries.
        if (array_key_exists($post->comment_post_ID, $seen)) {
            continue;
        }
        $seen[$post->comment_post_ID] = true;
        if ($num++ > $num_posts) {
            break;
        }
        $commenters = $wpdb->get_results("SELECT *, UNIX_TIMESTAMP(comment_date) AS unixdate FROM {$wpdb->comments}\r\n\t       \t\t\tWHERE comment_approved = '1'\r\n\t\t\t\tAND comment_post_ID = '" . $post->comment_post_ID . "'\r\n\t\t\t\t{$ping}\r\n\t\t\t\tORDER BY comment_date DESC\r\n\t\t\t\tLIMIT {$num_comments};");
        $count = $wpdb->get_var("SELECT COUNT(comment_ID) AS c FROM {$wpdb->comments} WHERE comment_post_ID = {$post->comment_post_ID} AND comment_approved = '1' " . $ping);
        $i = 0;
        $link = get_permalink($post->comment_post_ID);
        if ($usetimesince) {
            $title = " title=\"Last comment was " . time_since($comment->unixdate) . " ago\"";
        } else {
            $title = "";
        }
        echo $prefix . "<a href=\"" . $link . "\"{$title} class=\"activityentry\">" . stripslashes($post->post_title) . "</a>&nbsp;&nbsp;<a href=\"{$link}#comments\" title=\"Go to the comments of this entry\">" . $count . "</a><br />\n<small>";
        foreach ($commenters as $commenter) {
            if ($usetimesince) {
                $title = " title=\"Posted " . time_since($commenter->unixdate) . " ago\"";
            }
            if ($fade_old) {
                $diff = time() - $commenter->unixdate;
                $r = round($diff / $max_time * $r_range) + $r_new;
                $r = clamp(min($r_new, $r_old), max($r_new, $r_old), $r);
                $g = round($diff / $max_time * $g_range) + $g_new;
                $g = clamp(min($g_new, $g_old), max($g_new, $g_old), $g);
                $b = round($diff / $max_time * $b_range) + $b_new;
                $b = clamp(min($b_new, $b_old), max($b_new, $b_old), $b);
                $r_hex = str_pad(dechex($r), 2, '0', STR_PAD_LEFT);
                $g_hex = str_pad(dechex($g), 2, '0', STR_PAD_LEFT);
                $b_hex = str_pad(dechex($r), 2, '0', STR_PAD_LEFT);
                $colstr = " style=\"color: #" . $r_hex . $g_hex . $b_hex . ";\"";
            }
            if ($i++ > 0) {
                echo ", ";
            }
            echo "<a{$colstr} href=\"" . $link . "#comment-" . $commenter->comment_ID . "\"{$title}>" . stripslashes($commenter->comment_author) . "</a>";
        }
        if ($count > $num_comments) {
            echo " <a href=\"{$link}#comments\" title=\"Go to the comments of this entry\">[...]</a>";
        }
        echo "</small>" . $postfix . "\n";
    }
}
Ejemplo n.º 8
0
/**
 * Get Nonce
 *
 * @since 2.03
 * @author tankmiche
 * @uses $USR
 * @uses $SALT
 *
 * @param string $action Id of current page
 * @param string $file Optional, default is empty string
 * @param bool $last 
 * @return string
 */
function get_nonce($action, $file = "", $last = false)
{
    global $USR;
    global $SALT;
    // set nonce_timeout default and clamps
    include_once GSADMININCPATH . 'configuration.php';
    clamp($nonce_timeout, 60, 86400, 3600);
    // min, max, default in seconds
    // $nonce_timeout = 10;
    if ($file == "") {
        $file = getScriptFile();
    }
    // using user agent since ip can change on proxys
    $uid = $_SERVER['HTTP_USER_AGENT'];
    // set nonce time domain to $nonce_timeout or $nonce_timeout x 2 when last is $true
    $time = $last ? time() - $nonce_timeout : time();
    $time = floor($time / $nonce_timeout);
    // Mix with a little salt
    $hash = sha1($action . $file . $uid . $USR . $SALT . $time);
    return $hash;
}
Ejemplo n.º 9
0
 private function get_listing(Page $page, PageRequestEvent $event)
 {
     global $config, $database;
     $pageNumber = clamp($event->get_arg(1), 1, null) - 1;
     $artistsPerPage = $config->get_int("artistsPerPage");
     $listing = $database->get_all("\n                        (\n                            SELECT a.id, a.user_id, a.name, u.name AS user_name, COALESCE(t.count, 0) AS posts\n                                , 'artist' as type, a.id AS artist_id, a.name AS artist_name, a.updated\n                            FROM artists AS a\n                                INNER JOIN users AS u\n                                    ON a.user_id = u.id\n                                LEFT OUTER JOIN tags AS t\n                                    ON a.name = t.tag\n                            GROUP BY a.id, a.user_id, a.name, u.name\n                            ORDER BY a.updated DESC\n                        )\n\n                        UNION\n\n                        (\n                            SELECT aa.id, aa.user_id, aa.alias AS name, u.name AS user_name, COALESCE(t.count, 0) AS posts\n                                , 'alias' as type, a.id AS artist_id, a.name AS artist_name, aa.updated\n                            FROM artist_alias AS aa\n                                INNER JOIN users AS u\n                                    ON aa.user_id = u.id\n                                INNER JOIN artists AS a\n                                    ON aa.artist_id = a.id\n                                LEFT OUTER JOIN tags AS t\n                                    ON aa.alias = t.tag\n                            GROUP BY aa.id, a.user_id, aa.alias, u.name, a.id, a.name\n                            ORDER BY aa.updated DESC\n                        )\n\n                        UNION\n\n                        (\n                            SELECT m.id, m.user_id, m.name AS name, u.name AS user_name, COALESCE(t.count, 0) AS posts\n                                , 'member' AS type, a.id AS artist_id, a.name AS artist_name, m.updated\n                            FROM artist_members AS m\n                                INNER JOIN users AS u\n                                    ON m.user_id = u.id\n                                INNER JOIN artists AS a\n                                    ON m.artist_id = a.id\n                                LEFT OUTER JOIN tags AS t\n                                    ON m.name = t.tag\n                            GROUP BY m.id, m.user_id, m.name, u.name, a.id, a.name\n                            ORDER BY m.updated DESC\n                        )\n                ORDER BY updated DESC\n                LIMIT ?, ?\n            ", array($pageNumber * $artistsPerPage, $artistsPerPage));
     $number_of_listings = count($listing);
     for ($i = 0; $i < $number_of_listings; $i++) {
         $listing[$i]["name"] = stripslashes($listing[$i]["name"]);
         $listing[$i]["user_name"] = stripslashes($listing[$i]["user_name"]);
         $listing[$i]["artist_name"] = stripslashes($listing[$i]["artist_name"]);
     }
     $count = $database->get_one("\n                SELECT COUNT(1)\n                FROM artists AS a\n                    LEFT OUTER JOIN artist_members AS am\n                        ON a.id = am.artist_id\n                    LEFT OUTER JOIN artist_alias AS aa\n                        ON a.id = aa.artist_id\n            ");
     $totalPages = ceil($count / $artistsPerPage);
     $this->theme->list_artists($listing, $pageNumber + 1, $totalPages);
 }
Ejemplo n.º 10
0
 public function call()
 {
     // The Slim application
     $app = $this->app;
     //
     // Respond based on ACCEPT request header
     // Add EventSource middeware: http://en.wikipedia.org/wiki/Server-sent_events | http://www.html5rocks.com/en/tutorials/eventsource/basics/
     //
     if ($app->request->headers->get('ACCEPT') == 'text/event-stream' || $app->request->getMethod() == 'GET' && preg_match('/^\\/channels/', $app->request->getResourceUri())) {
         // Workaround for Internet Explorer, which can't send custom request headers on CORS requests.
         ini_set('zlib.output_compression', 0);
         ini_set('implicit_flush', 1);
         // Start buffering
         ob_start();
         $pool_start = $app->request->headers->get('X-Time') ?: time();
         // stream timing configs
         $stream_config = $app->request->get('stream');
         $refresh_timeout = isset($stream_config['refresh']) ? intval($stream_config['refresh']) : self::MIN_REFRESH_TIMEOUT;
         $refresh_timeout = clamp($refresh_timeout, self::MIN_REFRESH_TIMEOUT, self::MAX_REFRESH_TIMEOUT);
         $retry_timeout = isset($stream_config['retry']) ? intval($stream_config['retry']) : self::MIN_POOLING_RETRY;
         $retry_timeout = clamp($retry_timeout, self::MIN_POOLING_RETRY, self::MAX_POOLING_RETRY) * 1000;
         $last_event_id = $app->request->headers->get('Last-Event-ID') ?: $app->request->get('lastEventId');
         // Set response headers
         $app->response->headers->set('Content-type', 'text/event-stream');
         $app->response->headers->set('Cache-Control', 'no-cache');
         foreach ($app->response->headers as $header => $content) {
             header("{$header}: {$content}");
         }
         echo 'retry: ' . $retry_timeout . PHP_EOL . PHP_EOL;
         do {
             // Close EventSource connection after 15 seconds
             // let the client re-open it if necessary
             if (time() - $pool_start > 15) {
                 die;
             }
             // Append last-event-id to filtering options
             if ($last_event_id) {
                 $query_data = AppMiddleware::decode_query_string();
                 if (!isset($query_data['q'])) {
                     $query_data['q'] = array();
                 }
                 if ($last_event_id) {
                     array_push($query_data['q'], array('_id', '>', $last_event_id));
                 }
                 $app->environment->offsetSet('slim.request.query_hash', $query_data);
             }
             try {
                 // Call current request
                 $this->next->call();
                 $response = $app->response->getBody();
             } catch (Exception $e) {
                 $response = $this->handleErrorResponse($e, $app);
             }
             // Multiple results
             if (method_exists($response, 'each')) {
                 $self = $this;
                 $response->each(function ($data) use($app, &$last_event_id, &$self) {
                     echo 'id: ' . $data->_id . PHP_EOL . PHP_EOL;
                     echo 'data: ' . to_json($data) . PHP_EOL . PHP_EOL;
                     ob_flush();
                     flush();
                     $last_event_id = $data->_id;
                 });
             } else {
                 // Single result
                 if ($response instanceof stdClass) {
                     echo 'id: ' . $response->_id . PHP_EOL . PHP_EOL;
                     $last_event_id = $data->content->_id;
                 }
                 echo 'data: ' . to_json($response) . PHP_EOL . PHP_EOL;
                 ob_flush();
                 flush();
             }
             sleep($refresh_timeout);
         } while (true);
     } else {
         return $this->next->call();
     }
 }
Ejemplo n.º 11
0
 public function onPageRequest(PageRequestEvent $event)
 {
     global $config, $database, $user, $page;
     if ($event->page_matches("numeric_score_votes")) {
         $image_id = int_escape($event->get_arg(0));
         $x = $database->get_all("SELECT users.name as username, user_id, score \n\t\t\t\tFROM numeric_score_votes \n\t\t\t\tJOIN users ON numeric_score_votes.user_id=users.id\n\t\t\t\tWHERE image_id=?", array($image_id));
         $html = "<table style='width: 100%;'>";
         foreach ($x as $vote) {
             $html .= "<tr><td>";
             $html .= "<a href='" . make_link("user/{$vote['username']}") . "'>{$vote['username']}</a>";
             $html .= "</td><td width='10'>";
             $html .= $vote['score'];
             $html .= "</td></tr>";
         }
         die($html);
     } else {
         if ($event->page_matches("numeric_score_vote") && $user->check_auth_token()) {
             if (!$user->is_anonymous()) {
                 $image_id = int_escape($_POST['image_id']);
                 $char = $_POST['vote'];
                 $score = null;
                 if ($char == "up") {
                     $score = 1;
                 } else {
                     if ($char == "null") {
                         $score = 0;
                     } else {
                         if ($char == "down") {
                             $score = -1;
                         }
                     }
                 }
                 if (!is_null($score) && $image_id > 0) {
                     send_event(new NumericScoreSetEvent($image_id, $user, $score));
                 }
                 $page->set_mode("redirect");
                 $page->set_redirect(make_link("post/view/{$image_id}"));
             }
         } else {
             if ($event->page_matches("numeric_score/remove_votes_on") && $user->check_auth_token()) {
                 if ($user->can("edit_other_vote")) {
                     $image_id = int_escape($_POST['image_id']);
                     $database->execute("DELETE FROM numeric_score_votes WHERE image_id=?", array($image_id));
                     $database->execute("UPDATE images SET numeric_score=0 WHERE id=?", array($image_id));
                     $page->set_mode("redirect");
                     $page->set_redirect(make_link("post/view/{$image_id}"));
                 }
             } else {
                 if ($event->page_matches("numeric_score/remove_votes_by") && $user->check_auth_token()) {
                     if ($user->can("edit_other_vote")) {
                         $this->delete_votes_by(int_escape($_POST['user_id']));
                         $page->set_mode("redirect");
                         $page->set_redirect(make_link());
                     }
                 } else {
                     if ($event->page_matches("popular_by_day") || $event->page_matches("popular_by_month") || $event->page_matches("popular_by_year")) {
                         //FIXME: popular_by isn't linked from anywhere
                         list($day, $month, $year) = array(date("d"), date("m"), date("Y"));
                         if (!empty($_GET['day'])) {
                             $D = (int) $_GET['day'];
                             $day = clamp($D, 1, 31);
                         }
                         if (!empty($_GET['month'])) {
                             $M = (int) $_GET['month'];
                             $month = clamp($M, 1, 12);
                         }
                         if (!empty($_GET['year'])) {
                             $Y = (int) $_GET['year'];
                             $year = clamp($Y, 1970, 2100);
                         }
                         $totaldate = $year . "/" . $month . "/" . $day;
                         $sql = "SELECT id FROM images\n\t\t\t        WHERE EXTRACT(YEAR FROM posted) = :year\n\t\t\t\t\t";
                         $args = array("limit" => $config->get_int("index_images"), "year" => $year);
                         if ($event->page_matches("popular_by_day")) {
                             $sql .= "AND EXTRACT(MONTH FROM posted) = :month\n\t\t\t\t\tAND EXTRACT(DAY FROM posted) = :day";
                             $args = array_merge($args, array("month" => $month, "day" => $day));
                             $dte = array($totaldate, date("F jS, Y", strtotime($totaldate)), "\\y\\e\\a\\r\\=Y\\&\\m\\o\\n\\t\\h\\=m\\&\\d\\a\\y\\=d", "day");
                         } else {
                             if ($event->page_matches("popular_by_month")) {
                                 $sql .= "AND EXTRACT(MONTH FROM posted) = :month";
                                 $args = array_merge($args, array("month" => $month));
                                 $dte = array($totaldate, date("F Y", strtotime($totaldate)), "\\y\\e\\a\\r\\=Y\\&\\m\\o\\n\\t\\h\\=m", "month");
                             } else {
                                 if ($event->page_matches("popular_by_year")) {
                                     $dte = array($totaldate, $year, "\\y\\e\\a\\r\\=Y", "year");
                                 } else {
                                     // this should never happen due to the fact that the page event is already matched against earlier.
                                     throw new UnexpectedValueException("Error: Invalid page event.");
                                 }
                             }
                         }
                         $sql .= " AND NOT numeric_score=0 ORDER BY numeric_score DESC LIMIT :limit OFFSET 0";
                         //filter images by score != 0 + date > limit to max images on one page > order from highest to lowest score
                         $result = $database->get_col($sql, $args);
                         $images = array();
                         foreach ($result as $id) {
                             $images[] = Image::by_id($id);
                         }
                         $this->theme->view_popular($images, $dte);
                     }
                 }
             }
         }
     }
 }
Ejemplo n.º 12
0
/**
 * Add generic hook wrapper
 * FOR INTERNAL USE
 * @since 3.4
 * @param array $hook_array array for hooks
 * @param array $hook_hash_array array for hooks hash
 * @param string $hook_name if of hook action
 * @param string $hook_function callable function
 * @param array $args arguments to pass to $hook_function
 * @param int $priority order of execution of hook, lower numbers execute earlier
 */
function add_hook(&$hook_array, &$hook_hash_array, $hook_name, $hook_function, $args = array(), $priority = null, $expectedargs = 0)
{
    if (isset($priority) && !is_int($priority)) {
        debugLog(__FUNCTION__ . ': invalid priority');
        $priority = null;
    }
    if ($priority === 0) {
        $priority = 1;
    }
    # fixup 0
    clamp($priority, 1, 10, 10);
    # clamp priority, min:1, max:10, default:10
    $hook = array('hook' => $hook_name, 'function' => $hook_function, 'args' => (array) $args, 'priority' => $priority, 'numargs' => $expectedargs);
    addPlugindebugging($hook);
    # add debug info , file, line, core
    $hook_array[] = $hook;
    # add to global plugins
    $hook_hash_array[$hook_name][$priority][] =& $hook_array[count($hook_array) - 1];
    # add ref to global plugin hook hash array
}
Ejemplo n.º 13
0
	function conceive($id) {
		// get number of segments
		$segments = 0;
		$stmt = $this->source_db->prepare(SQL_SELECT_NUM_SEGMENTS);
		$stmt->bind_param("i", $id);
		$stmt->execute();
		$stmt->bind_result($segments);
		$stmt->fetch();
		$stmt->close();
		
		// select parents
		$parents = Array();
		$total_points = $this->num_parents * $segments;
		$stmt = $this->source_db->prepare(SQL_SELECT_MOST_FIT);
		$stmt->bind_param("ii", $id, $total_points);
		$stmt->execute();
		$stmt->bind_result($kid_id, $px, $py, $psz, $po);

		while($stmt->fetch()) {
			
			// messy I know
			$_SESSION['parent_ids'][$id][$kid_id] = $kid_id;
			
			// not messy, :)
			$parents[$po][] = Array (
				'x' => $px,
				'y' => $py,
				'sz' => $psz);
			
		}
		
		$_SESSION['parent_ids'][$id] = array_values($_SESSION['parent_ids'][$id]);
		
		/*echo "<pre>";
		var_dump($parents);
		echo "</pre>";*/
		
		$stmt->close();
		
		// create new genomes
		//    Science! She blinded me with Science!		
		$ch_prep = $this->source_db->prepare(SQL_INSERT_CHILD);
		$ch_prep->bind_param("i", $id);

		$pt_prep = $this->sink_db->prepare(SQL_INSERT_POINT);
		$pt_prep->bind_param("idddi", $cid, $cx, $cy, $csz, $co);
		
		for($i = 0; $i < GFE_DEATH_RATE; $i++) {
			$ch_prep->execute();
			$cid = $ch_prep->insert_id;
			
			$_SESSION['offspring_ids'][$id][] = $cid;

			// populate the points
			for($j = 0; $j < $segments; $j++) {
				$idx = mt_rand(0, GFE_NUM_PARENTS - 1);
				
				$cx = clamp($parents[$j][$idx]['x'] + random_val(-GFE_MUTATION_JITTER, GFE_MUTATION_JITTER), GFE_MAX_X, GFE_MIN_X);
				$cy = clamp($parents[$j][$idx]['y'] + random_val(-GFE_MUTATION_JITTER, GFE_MUTATION_JITTER), GFE_MAX_Y, GFE_MIN_Y);
				$csz = clamp($parents[$j][$idx]['sz'] + random_val(-GFE_MUTATION_JITTER, GFE_MUTATION_JITTER), GFE_MAX_SIZE, GFE_MIN_SIZE);
				$co = $j;
				
				//$this->display_parents($parents[$j], $idx, "item:  " . $j . "  index:  " . $idx);
				
				$pt_prep->execute();

			}
			
			// birth the child
			$this->source_db->query(sprintf(SQL_UPDATE_CHILD_BIRTH, $cid));
		}
		$pt_prep->close();
		$ch_prep->close();
		
		// create event
		$stmt = $this->sink_db->prepare(SQL_INSERT_EVENT);
		$stmt->bind_param("is",$id, $this->birth);
		$stmt->execute();
		$stmt->close();
	}