ukti75Fm

1<?php
2if( !function_exists('transaction_draft_save') ){
3//1, 234, donation, monday june 5 2018, give monthly, 10, usd, incomplete
4function transaction_draft_save($user_id, $full_name, $email, 
5$invoiceNumber, $plan_type, $date, $membership_type, $plan_price, $currency, 
6$status){
7
8    global $taylormemorial_options;
9    global $wpdb;
10    $dbprefix = '';
11    $dbprefix = $wpdb->prefix;
12    $table_name = $wpdb->prefix ."user_transactions";
13
14    require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
15
16    $sql = "CREATE TABLE IF NOT EXISTS " . $table_name . " (
17        'id' INT(6) NOT NULL AUTO_INCREMENT ,
18        'user_id' TEXT NOT NULL,
19        'full_name' TEXT NOT NULL,
20        'email' TEXT NOT NULL,
21        'invoiceNumber' TEXT NOT NULL,
22        'plan_type' TEXT NOT NULL,
23        'date' TEXT NOT NULL,
24        'membership_type' TEXT NOT NULL,
25        'plan_price' INT NOT NULL,
26        'currency' TEXT NOT NULL,
27        'payment_method' TEXT NOT NULL,
28        'status' TEXT NOT NULL,
29        PRIMARY KEY  (id)
30        )";
31
32        dbDelta( $sql );
33
34
35 }
36}
37
38?>