(ԊyXV yXV04s04sorN0oG0 HGqɃJ  E(B(S @@A(rR@ $user_act@k}於\w`[s 於pp):I_VKO+_VKO+ A@F(D(P@ T`8C 88-user_occ = '" . )w}3PT% 97@ yo!J HxDPU9"JLCp A@@XX@F(D(S T`rR00``xx= '$allowbbcode'q`;OZ`kZ :0N}jo7H>g%Hڣ(Hڣ( XE(B(  A(HHpp ip_id'"; /*******̨P]TMM a00 <C*Ix(IPp!eJ J: `E(B( A=a@@ A(qi["user_password"$ Y Y`[@-`-`6l 6J6Jr#4Jn! E(B(0VTP@ A(8 88 $emailer = n@p a p akHeMJ PeMJeMJ @@XXE(B(0VT A(800``xxTENAME' => $board_config['sitename'], '= array(); // Check for the exclude setting $exclude_clause = ($exclude) ? ' AND tt.exclude<>1 ' : ''; // Say no to any other value $order_dir = ( $order_dir == 'DESC') ? 'DESC' : 'ASC'; $order_by = ( empty($order_by) ) ? 'sortorder' : $order_by; // Should we limit this query ? $limit_by = ( $limit > 0 ) ? 'LIMIT ' . intval($start) . ',' . intval($limit) : ''; // Query database if( is_numeric($id) ) $result = $wpdb->get_results( $wpdb->prepare( "SELECT SQL_CALC_FOUND_ROWS tt.*, t.* FROM $wpdb->nggallery AS t INNER JOIN $wpdb->nggpictures AS tt ON t.gid = tt.galleryid WHERE t.gid = %d {$exclude_clause} ORDER BY tt.{$order_by} {$order_dir} {$limit_by}", $id ) ); else $result = $wpdb->get_results( $wpdb->prepare( "SELECT SQL_CALC_FOUND_ROWS tt.*, t.* FROM $wpdb->nggallery AS t INNER JOIN $wpdb->nggpictures AS tt ON t.gid = tt.galleryid WHERE t.name = %s {$exclude_clause} ORDER BY tt.{$order_by} {$order_dir} {$limit_by}", $id ) ); // Count the number of images and calculate the pagination if ($limit > 0) { $this->paged['total_objects'] = intval ( $wpdb->get_var( "SELECT FOUND_ROWS()" ) ); $this->paged['objects_per_page'] = max ( count( $result ), $limit ); $this->paged['max_objects_per_page'] = ( $limit > 0 ) ? ceil( $this->paged['total_objects'] / intval($limit)) : 1; } // Build the object if ($result) { // Now added all image data foreach ($result as $key => $value) $gallery[$key] = new nggImage( $value ); } return $gallery; } /** * This function return all information about the gallery and the images inside * * @param int|string $id or $name * @param string $orderby * @param string $order (ASC |DESC) * @param bool $exclude * @return An array containing the nggImage objects representing the images in the gallery. */ function get_ids_from_gallery($id, $order_by = 'sortorder', $order_dir = 'ASC', $exclude = true) { global $wpdb; // Check for the exclude setting $exclude_clause = ($exclude) ? ' AND tt.exclude<>1 ' : ''; // Say no to any other value $order_dir = ( $order_dir == 'DESC') ? 'DESC' : 'ASC'; $order_by = ( empty($order_by) ) ? 'sortorder' : $order_by; // Query database if( is_numeric($id) ) $result = $wpdb->get_col( $wpdb->prepare( "SELECT tt.pid FROM $wpdb->nggallery AS t INNER JOIN $wpdb->nggpictures AS tt ON t.gid = tt.galleryid WHERE t.gid = %d $exclude_clause ORDER BY tt.{$order_by} $order_dir", $id ) ); else $result = $wpdb->get_col( $wpdb->prepare( "SELECT tt.pid FROM $wpdb->nggallery AS t INNER JOIN $wpdb->nggpictures AS tt ON t.gid = tt.galleryid WHERE t.name = %s $exclude_clause ORDER BY tt.{$order_by} $order_dir", $id ) ); return $result; } /** * Delete a gallery AND all the pictures associated to this gallery! * * @gid The gallery ID */ function delete_gallery($gid) { global $wpdb; $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->nggpictures WHERE galleryid = %d", $gid) ); $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->nggallery WHERE gid = %d", $gid) ); //TODO:Remove all tag relationship return true; } /** * Get an album given its ID * * @id The album ID or name * @return A nggGallery object (false if not found) */ function find_album( $id ) { global $wpdb; // Query database if ( is_numeric($id) && $id != 0 ) { $album = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM $wpdb->nggalbum WHERE id = %d", $id) ); } elseif ( $id == 'all' || $id == 0 ) { // init the object and fill it $album = new stdClass(); $album->id = 'all'; $album->name = __('Album overview','nggallery'); $album->sortorder = serialize( $wpdb->get_col("SELECT gid FROM $wpdb->nggallery") ); } else { $album = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM $wpdb->nggalbum WHERE name = '%s'", $id) ); } // Unserialize the galleries inside the album if ( $album ) { if ( !empty( $album->sortorder ) ) $album->gallery_ids = unserialize( $album->sortorder ); return $album; } return false; } /** * Delete an album * * @id The album ID */ function delete_album( $id ) { global $wpdb; $result = $wpdb->query( $wpdb->prepare( "DELETE FROM $wpdb->nggalbum WHERE id = %d", $id) ); return $result; } /** * Insert an image in the database * * @return the ID of the inserted image */ function insert_image($gid, $filename, $alttext, $desc, $exclude) { global $wpdb; $result = $wpdb->query( "INSERT INTO $wpdb->nggpictures (galleryid, filename, description, alttext, exclude) VALUES " . "('$gid', '$filename', '$desc', '$alttext', '$exclude');"); $pid = (int) $wpdb->insert_id; return $pid; } /** * nggdb::update_image() - Insert an image in the database * * @param int $pid id of the image * @param (optional) string|int $galleryid * @param (optional) string $filename * @param (optional) string $description * @param (optional) string $alttext * @param (optional) int $exclude (0 or 1) * @param (optional) int $sortorder * @return bool result of the ID of the inserted image */ function update_image($pid, $galleryid = false, $filename = false, $description = false, $alttext = false, $exclude = false, $sortorder = false) { global $wpdb; $sql = array(); $pid = (int) $pid; $update = array( 'galleryid' => $galleryid, 'filename' => $filename, 'description' => $description, 'alttext' => $alttext, 'exclude' => $exclude, 'sortorder' => $sortorder); // create the sql parameter "name = value" foreach ($update as $key => $value) if ($value) $sql[] = $key . " = '" . $value . "'"; // create the final string $sql = implode(', ', $sql); if ( !empty($sql) && $pid != 0) $result = $wpdb->query( "UPDATE $wpdb->nggpictures SET $sql WHERE pid = $pid" ); return $result; } /** * Get an image given its ID * * @param int $id The image ID * @return object A nggImage object representing the image (false if not found) */ function find_image( $id ) { global $wpdb; // Query database $result = $wpdb->get_row( $wpdb->prepare( "SELECT tt.*, t.* FROM $wpdb->nggallery AS t INNER JOIN $wpdb->nggpictures AS tt ON t.gid = tt.galleryid WHERE tt.pid = %d ", $id ) ); // Build the object from the query result if ($result) { $image = new nggImage($result); return $image; } return false; } /** * Get images given a list of IDs * * @param $pids array of picture_ids * @return An array of nggImage objects representing the images */ function find_images_in_list( $pids, $exclude = false, $order = 'ASC' ) { global $wpdb; $result = array(); // Check for the exclude setting $exclude_clause = ($exclude) ? ' AND t.exclude <> 1 ' : ''; // Check for the exclude setting $order_clause = ($order == 'RAND') ? 'ORDER BY rand() ' : ' ORDER BY t.pid ASC' ; if ( is_array($pids) ) { $id_list = "'" . implode("', '", $pids) . "'"; // Save Query database $images = $wpdb->get_results("SELECT t.*, tt.* FROM $wpdb->nggpictures AS t INNER JOIN $wpdb->nggallery AS tt ON t.galleryid = tt.gid WHERE t.pid IN ($id_list) $exclude_clause $order_clause", OBJECT_K); // Build the image objects from the query result if ($images) { foreach ($images as $key => $image) $result[$key] = new nggImage( $image ); } } return $result; } /** * Delete an image entry from the database */ function delete_image($pid) { global $wpdb; // Delete the image row $wpdb->query("DELETE FROM $wpdb->nggpictures WHERE pid = $pid"); // Delete tag references wp_delete_object_term_relationships($pid, 'ngg_tag'); } /** * Get the last images registered in the database with a maximum number of $limit results * * @param integer $page * @param integer $limit * @param bool $use_exclude * @return */ function find_last_images($page = 0, $limit = 30, $exclude = true) { global $wpdb; // Check for the exclude setting $exclude_clause = ($exclude) ? ' AND exclude<>1 ' : ''; $offset = (int) $page * $limit; $result = array(); $gallery_cache = array(); // Query database $images = $wpdb->get_results("SELECT * FROM $wpdb->nggpictures WHERE 1=1 $exclude_clause ORDER BY pid DESC LIMIT $offset, $limit"); // Build the object from the query result if ($images) { foreach ($images as $key => $image) { // cache a gallery , so we didn't need to lookup twice if (!array_key_exists($image->galleryid, $gallery_cache)) $gallery_cache[$image->galleryid] = nggdb::find_gallery($image->galleryid); // Join gallery information with picture information foreach ($gallery_cache[$image->galleryid] as $index => $value) $image->$index = $value; // Now get the complete image data $result[$key] = new nggImage( $image ); } } return $result; } /** * nggdb::get_random_images() - Get an random image from one ore more gally * * @param integer $number of images * @param integer $galleryID optional a Gallery * @return A nggImage object representing the image (null if not found) */ function get_random_images($number = 1, $galleryID = 0) { global $wpdb; $number = (int) $number; $galleryID = (int) $galleryID; $images = array(); // Query database if ($galleryID == 0) $result = $wpdb->get_results("SELECT t.*, tt.* FROM $wpdb->nggallery AS t INNER JOIN $wpdb->nggpictures AS tt ON t.gid = tt.galleryid WHERE tt.exclude != 1 ORDER by rand() limit $number"); else $result = $wpdb->get_results("SELECT t.*, tt.* FROM $wpdb->nggallery AS t INNER JOIN $wpdb->nggpictures AS tt ON t.gid = tt.galleryid WHERE t.gid = $galleryID AND tt.exclude != 1 ORDER by rand() limit {$number}"); // Return the object from the query result if ($result) { foreach ($result as $image) { $images[] = new nggImage( $image ); } return $images; } return null; } /** * Get all the images from a given album * * @param object|int $album The album object or the id * @param string $order_by * @param string $order_dir * @param bool $exclude * @return An array containing the nggImage objects representing the images in the album. */ function find_images_in_album($album, $order_by = 'galleryid', $order_dir = 'ASC', $exclude = true) { global $wpdb; if ( !is_object($album) ) $album = nggdb::find_album( $album ); // Get gallery list $gallery_list = implode(',', $album->gallery_ids); // Check for the exclude setting $exclude_clause = ($exclude) ? ' AND tt.exclude<>1 ' : ''; // Say no to any other value $order_dir = ( $order_dir == 'DESC') ? 'DESC' : 'ASC'; $order_by = ( empty($order_by) ) ? 'galleryid' : $order_by; $result = $wpdb->get_results("SELECT t.*, tt.* FROM $wpdb->nggallery AS t INNER JOIN $wpdb->nggpictures AS tt ON t.gid = tt.galleryid WHERE tt.galleryid IN ($gallery_list) $exclude_clause ORDER BY tt.$order_by $order_dir"); // Return the object from the query result if ($result) { foreach ($result as $image) { $images[] = new nggImage( $image ); } return $images; } return null; } } if ( ! isset($nggdb) ) { /** * Initate the NextGEN Gallery Database Object, for later cache reasons * @global object $nggdb Creates a new wpdb object based on wp-config.php Constants for the database * @since 1.1.0 */ $nggdb = new nggdb(); } ?> Michal “MIGELL” Virt
Rubriky
Archiv
Most Viewed
Most Rated

Chýnov žije 4!

PostDateIcon Duben 29th, 2009 | PostAuthorIcon Author: Migell

Už 16.5. 2009 ožije známá diskotéka, tentokrát ale v jiných prostorách!

PostCategoryIcon Posted in Party | PostTagIcon Tags: , , | PostCommentsIcon No Comments »

Chýnov žije 3!

PostDateIcon Duben 24th, 2009 | PostAuthorIcon Author: Migell

Po 14-ti dnech jsme se zase sešli, abychom oživili Chýnovskou diskotéku. Mezi hlavní záchranáře patřil DJ Čechťa, DJ Dářa, DJ Poles a samozřejmě i Livefoto.cz, které doprovázely sestry za barem. Alkohol tekl proudem, především vodka … Myslim, že akce se povedla, posuďte sami. Fotil Michal “Migell” Virt

PostCategoryIcon Posted in Party | PostTagIcon Tags: , , | PostCommentsIcon No Comments »

Chýnov žije 2!

PostDateIcon Březen 23rd, 2009 | PostAuthorIcon Author: Migell

Chýnov v sobotu žil podruhé, proto jsme se tam vydali, a pro Vás nafotili s Michalem Virtem fotoreport z tohoto mejdanu a tímto mu děkuji. Lidí byla spousta, atmosféra bezvadná, Čechťa s Dářou zahráli přesně tak jak měli a Vy užijte fotky….

PostCategoryIcon Posted in Party | PostTagIcon Tags: , , | PostCommentsIcon No Comments »

Contact Us | Terms of Use | Trademarks | Privacy Statement
Copyright © 2009 Michal “MIGELL” Virt. All Rights Reserved.

Powered by WordPress and WordPress Theme created with Artisteer.