Server : Apache System : Linux webd348.cluster026.gra.hosting.ovh.net 5.15.148-ovh-vps-grsec-zfs-classid #1 SMP Thu Feb 8 09:41:04 UTC 2024 x86_64 User : hednacluml ( 122243) PHP Version : 8.3.9 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl Directory :  /home/hednacluml/edition/wp-content/plugins/leadup/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

global $leads_dynamicform, $table_prefix, $wpdb;
$leads_dynamicform = $table_prefix . "leads_dynamicform";
if ($wpdb->get_var("show tables like \"$leads_dynamicform\" ") != $leads_dynamicform) {
    $dsql = "CREATE TABLE " . $leads_dynamicform . " (
id mediumint(10) NOT NULL AUTO_INCREMENT,
name varchar(255) NOT NULL,
leadform1 TEXT NOT NULL,
leadform2 TEXT NOT NULL,
leadform3 TEXT NOT NULL,
leadform4 TEXT NOT NULL,
leadform5 TEXT NOT NULL,
leadform6 TEXT NOT NULL,
leadform7 TEXT NOT NULL,
leadform8 TEXT NOT NULL,
leadform9 TEXT NOT NULL,
date	date	NOT NULL,
rand_value int(10) NOT NULL,
UNIQUE KEY id (id)
);";
    $wpdb->query($dsql);
}
global $leads_dynamic_index;
$leads_dynamic_index = $table_prefix . "leads_dynamic_index";
if ($wpdb->get_var("show tables like \"$leads_dynamic_index\"") != $leads_dynamic_index) {
    $disql = "CREATE TABLE " . $leads_dynamic_index . " (
id mediumint(10) NOT NULL AUTO_INCREMENT,
lead_name varchar(255) NOT NULL,
UNIQUE KEY id (id)
);";
    $wpdb->query($disql);
    $wpdb->insert($leads_dynamic_index, array('lead_name' => 'Name'));
    $wpdb->insert($leads_dynamic_index, array('lead_name' => 'Email'));
    $wpdb->insert($leads_dynamic_index, array('lead_name' => 'Number'));
    $wpdb->insert($leads_dynamic_index, array('lead_name' => 'Message'));
    $wpdb->insert($leads_dynamic_index, array('lead_name' => 'Label1'));
    $wpdb->insert($leads_dynamic_index, array('lead_name' => 'Label2'));
    $wpdb->insert($leads_dynamic_index, array('lead_name' => 'Label3'));
    $wpdb->insert($leads_dynamic_index, array('lead_name' => 'Label4'));
    $wpdb->insert($leads_dynamic_index, array('lead_name' => 'Label5'));
    $wpdb->insert($leads_dynamic_index, array('lead_name' => 'Label6'));
}
global $lead_field_count;
$lead_field_count = $table_prefix . "lead_field_count";
if ($wpdb->get_var("show tables like \"$lead_field_count\" ") != $lead_field_count) {
    $fcsql = "CREATE TABLE " . $lead_field_count . " (
ID mediumint(10) NOT NULL AUTO_INCREMENT,
text_name varchar(255) NOT NULL,
text_value varchar(255) NOT NULL,
text_label varchar(255) NOT NULL,
required varchar(255) NOT NULL,
randvalue int(10) NOT NULL,
PRIMARY KEY ID (ID)
);";
    $wpdb->query($fcsql);

    $wpdb->insert($lead_field_count, array(
        'text_name' => 'text',
        'text_value' => 'Name',
        'text_label' => 'Name',
        'randvalue' => '1',
    ));
    $wpdb->insert($lead_field_count, array(
        'text_name' => 'text',
        'text_value' => 'Email',
        'text_label' => 'Email',
        'randvalue' => '2',
    ));
    $wpdb->insert($lead_field_count, array(
        'text_name' => 'number',
        'text_value' => 'Number',
        'text_label' => 'Number',
        'randvalue' => '3',
    ));
    $wpdb->insert($lead_field_count, array(
        'text_name' => 'textarea',
        'text_value' => 'Message',
        'text_label' => 'Message',
        'randvalue' => '4',
    ));
}
//Adding required column
$column_required = $wpdb->get_var("SHOW COLUMNS FROM $lead_field_count LIKE 'required'");
if (!isset($column_required)) {
    $wpdb->query("ALTER TABLE $lead_field_count  ADD `required` VARCHAR(100) NOT NULL AFTER `text_label`");
}
global $lead_select_field;
$lead_select_field = $table_prefix . "lead_select_field";
if ($wpdb->get_var("show tables like \"$lead_select_field\" ") != $lead_select_field) {
    $sfsql = "CREATE TABLE " . $lead_select_field . " (
ID mediumint(10) NOT NULL AUTO_INCREMENT,
text_value varchar(255) NOT NULL,
randvalue int(10) NOT NULL,
PRIMARY KEY ID (ID)
);";
    $wpdb->query($sfsql);
}
global $lead_field_table;
$lead_field_table = $table_prefix . "lead_field_table";
if ($wpdb->get_var("show tables like \"$lead_field_table\" ") != $lead_field_table) {
    $ftsql = "CREATE TABLE " . $lead_field_table . " (
PID mediumint(10) NOT NULL AUTO_INCREMENT,
ID mediumint(10) NOT NULL,
field_name varchar(255) NOT NULL,
text_name varchar(255) NOT NULL,
field_id varchar(255) NOT NULL,
randvalue int(10) NOT NULL,
PRIMARY KEY PID (PID)
);";
    $wpdb->query($ftsql);
}
if (!get_option('leads-heading')) {
    add_option('leads-heading', __('Marketing Secrets Highly Profitable Online Small Secret Bonus', 'leadcapture'));
}
if (!get_option('leads-email')) {
    add_option('leads-email', 'xyz@live.com, abc@live.com');
}
if (!get_option('leads-captcha')) {
    add_option('leads-captcha', 'off');
}
if (!get_option('leads-color')) {
    add_option('leads-color', 'black');
}