Beiträge von nature225

echo '<div class="wrap">          
            <table class="wp-list-table widefat fixed striped posts"> <br />';
    echo '<thead>';
    echo '<tr>';
    echo '<th>Firma</th>';
    echo '<th>Straße</th>';
    echo '<th>Ort</th>';
    echo '<th>USt-ID</th>';
    echo '<th>Anrede</th>';
    echo '<th>Name</th>';
    echo '<th>Telefone</th>';
    echo '<th>Handy</th>';
    echo '<th>Fax</th>';
    echo '<th>E-Mail</th>';
    echo '<th>Registrierungs Datum</th>';
    echo '<th>Send Aktivierungs E-Mail</th>';
    echo '</tr>';
    echo "</thead>";


    echo "<tbody id='the-list'>";
    foreach ($results as $data) {
        echo "<tr>";
        echo "<td style='padding: 8px 10px;' class='manage-column column-cb check-column'>" . $data->company ."</td>";
        echo "<td style='padding: 8px 10px;' class='manage-column column-cb check-column'>" . $data->street ."</td>";    
        echo "<td style='padding: 8px 10px;' class='manage-column column-cb check-column'>" . $data->zipcode . " " . $data->city .  "</td>";
        echo "<td style='padding: 8px 10px;' class='manage-column column-cb check-column'>" . $data->ustid ."</td>";
        echo "<td style='padding: 8px 10px;' class='manage-column column-cb check-column'>" . $data->salutation ."</td>";
        echo "<td style='padding: 8px 10px;' class='manage-column column-cb check-column'>" . $data->first_name . " " . $data->last_name . "</td>";
        echo "<td style='padding: 8px 10px;' class='manage-column column-cb check-column'>" . $data->telephone . "</td>";
        echo "<td style='padding: 8px 10px;' class='manage-column column-cb check-column'>" . $data->mobile . "</td>";
        echo "<td style='padding: 8px 10px;' class='manage-column column-cb check-column'>" . $data->fax . "</td>";
        echo "<td style='padding: 8px 10px;' class='manage-column column-cb check-column'>" . $data->email . "</td>";
        echo "<td style='padding: 8px 10px;' class='manage-column column-cb check-column'>" .  date("d.m.Y  H:i:s", strtotime($data->date) ) . "</td>";
        echo "<td style='padding: 8px 10px;' class='manage-column column-cb check-column'><a mailto:".$data->email.">Aktivierung senden</a></td>";
        echo "</tr>";


    }
echo "</table></div>";

if ( $news_exists->news_id > 0 ){               
                echo "News ".$news_id." existiert!<hr><br>";               
            }
            else{
                $wpdb->insert(
                    'news',
                    array(                       
                        'title' => $title,
                        'docdate'   => $docdate,
                        'subtitle'  => $subtitle,
                        'abstract'  => $abstract,
                        'text'  => $text,
                        'image'     => $image,
                        'news_id'   => $news_id
                        
                    ),
                    array( 
                        '%s',
                        '%s',
                        '%s',
                        '%s',
                        '%s',
                        '%s',
                        '%s',
                        '%d'
                      
  
                    )
                );               
              
                echo "<h2>News: ".$title." - ".$docdate."</h2>";   
                echo "<hr>News ".$news_id." wurde hinzugefügt!<hr><br>";


                $new_post = array(
                    'post_title' => $title,
                    'post_content'  => $text,
                    'post_excerpt'  => $abstract,
                    'post_status'   => 'publish'
                );
                $postId = wp_insert_post($new_post);


                if ( !function_exists('media_handle_upload') ) {
                    require_once(ABSPATH . 'wp-admin/includes/media.php');
                    require_once(ABSPATH . 'wp-admin/includes/file.php');
                    require_once(ABSPATH . 'wp-admin/includes/image.php');
                }
                
                $attachment_id = media_sideload_image( $image_src, $postId );
                set_post_thumbnail( $postId, $attachment_id );       
                
            }

$update = $wpdb->query($wpdb->prepare(
                        "UPDATE immobilien
                        SET
                        'title'     => $title,
                        'zipcode' => $zipcode,
                        'city'  => $city,
                        'street'   => $street,
                        'object_art' => $object_art,
                        'expose_img_count'    => $expose_img_count,
                        'added' => $added,
                        'processed'    => $processed,
                        'purchase_price'    => $purchase_price,
                        'rental_price'    => $rental_price,
                        'room'  => $room,
                        'bedroom'    => 2,
                        'bathroom'    => 2,
                        'living_area'   => $living_area,
                        'usable_area'   => $usable_area,
                        'construction_year'    => $construction_year,
                        'energy_pass'    => $energy_pass,
                        'buyer_prov'    => $buyer_prov,
                        'object_categorie'    => $object_categorie,
                        'description'    => $description,
                        'img_path_list' => $img_path_list,
                        'land_area'     => $land_area,
                        'free_at'          => $free_at,
                        'power_consumption' => $power_consumption,
                        'energy_efficiency_support' => $energy_efficiency_support
                        WHERE online_number = $online_number"
                    ));

function hook_javascript() {
    ?>


    <meta name="description" content="Custom Description"/>


  <?php


}
add_action('wp_head', 'hook_javascript');

function financial_calculator_func()
{
    $financial_calculator_options = get_option('financial_calculator_settings');
    $financial_calculator = $financial_calculator_options['financial_calculator'];


    $checked = ($financial_calculator == 'true' ? ' checked="checked"' : '');


?>
       <label for="financial_calculator">
        <input name='financial_calculator_settings[financial_calculator]' type="checkbox" id="financial_calculator" value="true" checked=<?php echo $checked ?>>
       Finanzierungsrechner anzeigen?</label>


    <?php