prefix .'art_images'; $row = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM ".$table_name." where galerie_name = %s ORDER BY rand() LIMIT %d ", $galerie, 1 )); if($format == '1'){ $image = $row[0]->thumbnailUrl; $offset = '2'; } if($format == '2'){ $image = $row[0]->mediumUrl; $offset = '1'; } if(!empty($galerieName)){ $galName = '

'. $row[0]->galerie_name.'

'; }else{ $galName = ''; } if(!empty($imgname)){ $bildname = ''. $row[0]->name.''; }else{ $bildname =''; } if(empty($settings['wp_settings_img_details'])){ $out = '

'.$galName.' '.$row[0]->name.'
'.$bildname.'

'; }else{ $out ='

'.$galName.' '.$row[0]->name.'
'.$bildname.'

'; } echo $out; }else{ global $wpdb; $table_name = $wpdb->prefix .'art_images'; $row = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM ".$table_name." ORDER BY rand() LIMIT %d ", 1 )); if($format == '1'){ $image = $row[0]->thumbnailUrl; $offset = '2'; } if($format == '2'){ $image = $row[0]->mediumUrl; $offset = '1'; } if(!empty($galerieName)){ $galName = '

'. $row[0]->galerie_name.'

'; }else{ $galName = ''; } if(!empty($imgname)){ $bildname = ''. $row[0]->name.''; }else{ $bildname =''; } if(empty($settings['wp_settings_img_details'])){ $out = '

'.$galName.' '.$row[0]->name.'
'.$bildname.'

'; }else{ $out ='

'.$galName.' '.$row[0]->name.'
'.$bildname.'

'; } echo $out; } // After widget code, if any echo '
'; echo (isset($after_widget)?$after_widget:''); } function update( $new_instance, $old_instance ) { $instance = $old_instance; $instance['galerieName'] = $new_instance['galerieName']; $instance['galerieAlle'] = $new_instance['galerieAlle']; $instance['galerie'] = $new_instance['galerie']; $instance['format'] = $new_instance['format']; $instance['header'] = $new_instance['header']; $instance['imgname'] = $new_instance['imgname']; return $instance; } function form( $instance ) { $instance = wp_parse_args( (array) $instance, array( 'title' => 'Random Image', ) ); $galerieName = ( isset( $instance['galerieName'] )&& is_numeric( $instance['galerieName'] ) ) ? (int)$instance['galerieName'] : ''; $galerieAlle = ( isset( $instance['galerieAlle'] )&& is_numeric( $instance['galerieAlle'] ) ) ? (int)$instance['galerieAlle'] : ''; $galerie = ( isset( $instance['galerie'] ) && is_string( $instance['galerie'] ) ) ? esc_attr($instance['galerie']) : ''; $header = ( isset( $instance['header'] ) && is_string( $instance['header'] ) ) ? esc_attr($instance['header']) : 'Random Image'; $imgname = ( isset( $instance['imgname'] ) && is_numeric( $instance['imgname'] ) ) ? (int) $instance['imgname'] : ''; $format = ( isset( $instance['format'] ) && is_numeric( $instance['format'] ) ) ? (int) $instance['format'] : 1; ?>

/>

Image Size: >
>

/>

/>