WordPress.org
Get WordPress

Plugin Directory

Changeset 2668949


Ignore:
Timestamp:
01/29/2022 06:21:06 PM (4 years ago)
Author:
ioss
Message:

remove headers already sent warning

File:
1 edited

Legend:

Unmodified
Added
Removed

  • wp-mlm/trunk/core_functions/wp-mlm-db-functions.php

    r2460751 r2668949  
    88    $charset_collate = $wpdb->get_charset_collate();
    99
    10     $sql = "CREATE TABLE $table_name            (
     10    $sql = "CREATE TABLE IF NOT EXISTS $table_name(
    1111    `user_id` int(11) NOT NULL AUTO_INCREMENT,
    1212    `user_ref_id` int(11) NOT NULL DEFAULT '0',
    … …  
    4040    `user_detail_facebook` varchar(250) CHARACTER SET utf8 NOT NULL DEFAULT 'http://facebook.com',
    4141    `user_detail_twitter` varchar(250) CHARACTER SET utf8 NOT NULL DEFAULT 'http://twitter.com',
    42     PRIMARY KEY (`user_id`)
    43                           ) $charset_collate AUTO_INCREMENT=1";
    44 
     42    PRIMARY KEY (`user_id`) ) $charset_collate AUTO_INCREMENT=1";
    4543      require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
    4644      dbDelta($sql);
    … …  
    5452    $sql = "SELECT * FROM {$table_prefix}users where `ID`='$id' ";
    5553    $results = $wpdb->get_row($sql);
    56 
    57 
    5854    $rowcount = $wpdb->get_var("SELECT COUNT(*) FROM {$table_prefix}wpmlm_users");
    59 
    60 
    61 
    6255    if ($rowcount == 0) {
    63 
    64 
    6556        $user_details = array(
    6657            'user_ref_id' => $results->ID,
    … …  
    7162            'join_date' => date("Y-m-d H:i:s")
    7263        );
    73 
    74 
    7564        $table_name = $wpdb->prefix . "wpmlm_users";
    7665        $result = $wpdb->insert($table_name, $user_details);
    77 
    78 
    7966
    8067        //$tran_pass = wpmlm_getRandTransPasscode(8);
    … …  
    9481    $table_prefix=$wpdb->prefix;
    9582    $table_name = $wpdb->prefix . "wpmlm_users";
    96     $sql = "SELECT user_ref_id FROM {$table_name} WHERE user_ref_id NOT IN (SELECT MIN(user_ref_id) FROM {$table_name}) ORDER BY user_id DESC ";
    97 
    98     $results = $wpdb->get_results($sql);
    99     $user_id = '';
    100 
    101     foreach ($results as $row) {
    102         $user_id .= $row->user_ref_id . ",";
     83    $usr_count = "SELECT COUNT(user_ref_id) as count FROM {$table_name}";
     84    $count_result = $wpdb->get_results($usr_count);
     85    foreach($count_result as $number){
     86        $count_total = $number->count;
    10387    }
    104     $user_id = substr($user_id, 0, -1);
    105 
    106     $wpdb->query("DELETE FROM {$table_prefix}users WHERE ID IN ($user_id)");
    107     $wpdb->query("DELETE FROM {$table_prefix}usermeta WHERE user_id IN ($user_id)");
     88    if($count_total > 1){
     89        $sql = "SELECT user_ref_id FROM {$table_name} WHERE user_ref_id NOT IN (SELECT MIN(user_ref_id) FROM {$table_name}) ORDER BY user_id DESC ";
     90        $results = $wpdb->get_results($sql);
     91        $user_id = '';
     92
     93        foreach ($results as $row) {
     94            $user_id .= $row->user_ref_id . ",";
     95        }
     96        $user_id = substr($user_id, 0, -1);
     97
     98        $wpdb->query("DELETE FROM {$table_prefix}users WHERE ID IN ($user_id)");
     99        $wpdb->query("DELETE FROM {$table_prefix}usermeta WHERE user_id IN ($user_id)");
     100    }
    108101}
    109102
    … …  
    134127    $table_prefix = $wpdb->prefix;
    135128    $charset_collate = $wpdb->get_charset_collate();
    136     $sql = "CREATE TABLE {$table_prefix}wpmlm_country
     129    $sql = "CREATE TABLE IF NOT EXISTS {$table_prefix}wpmlm_country
    137130                        (
    138131                                id BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    … …  
    152145    $table_prefix = $wpdb->prefix;
    153146    $charset_collate = $wpdb->get_charset_collate();
    154     $sql = "CREATE TABLE {$table_prefix}wpmlm_registration_packages (
     147    $sql = "CREATE TABLE IF NOT EXISTS {$table_prefix}wpmlm_registration_packages (
    155148    `id` int(11) NOT NULL AUTO_INCREMENT,
    156149    `package_name` varchar(200) NOT NULL,
    … …  
    168161    $table_prefix = $wpdb->prefix;
    169162    $charset_collate = $wpdb->get_charset_collate();
    170     $sql = "CREATE TABLE {$table_prefix}wpmlm_level_commission (
     163    $sql = "CREATE TABLE IF NOT EXISTS {$table_prefix}wpmlm_level_commission (
    171164    `id` int(12) NOT NULL AUTO_INCREMENT,
    172165    `level_no` int(12) NOT NULL DEFAULT '0',
    … …  
    249242}
    250243
    251 
    252 
    253244function insert_wpmlm_paypal_data() {
    254245    global $wpdb;
    … …  
    261252    );   
    262253    $result = $wpdb->insert($table_name, $data);
    263    
    264 }
    265 
    266 
    267 
     254}
    268255
    269256function create_wpmlm_general_information_table() {
    … …  
    292279    dbDelta($sql);
    293280}
    294 
    295 
    296 
    297281
    298282function create_wpmlm_configuration_table() {
    … …  
    518502function insert_wpmlm_country_data() {
    519503    global $wpdb;
    520     $table_prefix = $wpdb->prefix;
    521     $charset_collate = $wpdb->get_charset_collate();
    522 
    523     $sql = "INSERT INTO {$table_prefix}wpmlm_country (`id`, `iso`, `name`, `iso3`, `numcode`) VALUES
     504    $table_name = $wpdb->prefix."wpmlm_country";
     505    $charset_collate = $wpdb->get_charset_collate();
     506    $rowcount = "SELECT COUNT(*) FROM {$table_name}";
     507    $num = $wpdb->get_var($rowcount);
     508    if($num<1){
     509    $sql = "INSERT INTO $table_name (`id`, `iso`, `name`, `iso3`, `numcode`) VALUES
    524510                (1, 'AF', 'Afghanistan', 'AFG', 4),
    525511                (2, 'AL', 'Albania', 'ALB', 8),
    … …  
    762748                (239, 'ZW', 'Zimbabwe', 'ZWE', 716)";
    763749    $wpdb->query($sql);
    764 }
     750    }
     751}
Note: See TracChangeset for help on using the changeset viewer.