File manager - Edit - /home/xfekoga/rooftopcleaners/wp-content/plugins/fluentform/app/Modules/Payments/Migrations/OrderItems.php
Back
<?php namespace FluentForm\App\Modules\Payments\Migrations; if (!defined('ABSPATH')) { exit; // Exit if accessed directly. } class OrderItems { /** * Migrate the table. * * @return void */ public static function migrate() { global $wpdb; $charsetCollate = $wpdb->get_charset_collate(); $table = $wpdb->prefix . 'fluentform_order_items'; if ($wpdb->get_var("SHOW TABLES LIKE '$table'") != $table) { $sql = "CREATE TABLE $table ( id int(11) NOT NULL AUTO_INCREMENT, form_id int(11) NOT NULL, submission_id int(11) NOT NULL, type varchar(255) DEFAULT 'single', parent_holder varchar(255), billing_interval varchar(255), item_name varchar(255), quantity int(11) DEFAULT 1, item_price BIGINT UNSIGNED, line_total BIGINT UNSIGNED, created_at timestamp NULL, updated_at timestamp NULL, PRIMARY KEY (id) ) $charsetCollate;"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); dbDelta($sql); } else { self::maybeAlterColumns(); } } public static function maybeAlterColumns() { global $wpdb; $table = $wpdb->prefix . 'fluentform_order_items'; // find the data types of each column $results = $wpdb->get_results("DESCRIBE $table"); $items = []; foreach ($results as $result) { $items[$result->Field] = $result->Type; } $isBigInItemPrice = strpos($items['item_price'], 'bigint') !== false;; $isBigInitPrice = strpos($items['line_total'], 'bigint') !== false;; // if not big int convert to big int if (!$isBigInItemPrice) { $wpdb->query("ALTER TABLE $table MODIFY item_price BIGINT UNSIGNED"); } if (!$isBigInitPrice) { $wpdb->query("ALTER TABLE $table MODIFY line_total BIGINT UNSIGNED"); } } }
| ver. 1.4 |
Github
|
.
| PHP 8.0.30 | Generation time: 0 |
proxy
|
phpinfo
|
Settings