public function __construct(Ure_Lib $lib)
{
global $wpdb;
$this->lib = $lib;
$this->user_meta_key = $wpdb->prefix . 'ure_allow_gravity_forms';
$this->form_table_name = GFFormsModel::get_form_table_name();
$this->form_from_key = "FROM {$this->form_table_name}";
// GF, v. 1.8.5: forms_model.php, line 223, function get_form_count()
$this->count_forms_query = "\n SELECT\n (SELECT count(0) FROM {$this->form_table_name} WHERE is_trash = 0) as total,\n (SELECT count(0) FROM {$this->form_table_name} WHERE is_active=1 AND is_trash = 0 ) as active,\n (SELECT count(0) FROM {$this->form_table_name} WHERE is_active=0 AND is_trash = 0 ) as inactive,\n (SELECT count(0) FROM {$this->form_table_name} WHERE is_trash=1) as trash\n ";
add_action('edit_user_profile', array(&$this, 'edit_user_allowed_forms_list'), 10, 2);
add_action('profile_update', array(&$this, 'save_user_allowed_forms_list'), 10);
add_action('admin_head', array(&$this, 'prohibited_links_redirect'));
//add_action( 'admin_enqueue_scripts', array( &$this, 'load_js' ) );
add_action('admin_init', array(&$this, 'set_final_hooks'));
}
public static function is_valid_table($table_name)
{
global $wpdb;
$tables = array(GFFormsModel::get_form_table_name(), GFFormsModel::get_form_view_table_name(), GFFormsModel::get_meta_table_name(), GFFormsModel::get_lead_table_name(), GFFormsModel::get_lead_notes_table_name(), GFFormsModel::get_lead_details_table_name(), GFFormsModel::get_lead_details_long_table_name(), GFFormsModel::get_lead_meta_table_name(), GFFormsModel::get_incomplete_submissions_table_name(), "{$wpdb->prefix}gf_addon_feed", "{$wpdb->prefix}gf_addon_payment_transaction", "{$wpdb->prefix}gf_addon_payment_callback");
return in_array($table_name, $tables);
}
/**
* Private.
*
* @since 1.8
* @access private
* @static
* @ignore
*/
public static function form_id_exists($form_id)
{
global $wpdb;
$form_table_name = GFFormsModel::get_form_table_name();
$form_id = intval($form_id);
$result = $wpdb->get_var($wpdb->prepare(" SELECT count(id) FROM {$form_table_name}\n WHERE id=%d", $form_id));
$result = intval($result);
return $result > 0;
}
public function get_old_feeds()
{
global $wpdb;
$table_name = $wpdb->prefix . 'rg_paypal';
if (!$this->table_exists($table_name)) {
return false;
}
$form_table_name = GFFormsModel::get_form_table_name();
$sql = "SELECT s.id, s.is_active, s.form_id, s.meta, f.title as form_title\n\t\t\t\t\tFROM {$table_name} s\n\t\t\t\t\tINNER JOIN {$form_table_name} f ON s.form_id = f.id";
$this->log_debug(__METHOD__ . "(): getting old feeds: {$sql}");
$results = $wpdb->get_results($sql, ARRAY_A);
$this->log_debug(__METHOD__ . "(): error?: {$wpdb->last_error}");
$count = sizeof($results);
$this->log_debug(__METHOD__ . "(): count: {$count}");
for ($i = 0; $i < $count; $i++) {
$results[$i]['meta'] = maybe_unserialize($results[$i]['meta']);
}
return $results;
}
public function get_old_feeds()
{
global $wpdb;
$table_name = $wpdb->prefix . 'rg_mailchimp';
$form_table_name = GFFormsModel::get_form_table_name();
$sql = "SELECT s.id, s.is_active, s.form_id, s.meta, f.title as form_title\r\n\t\t\t\t\tFROM {$table_name} s\r\n\t\t\t\t\tINNER JOIN {$form_table_name} f ON s.form_id = f.id";
$results = $wpdb->get_results($sql, ARRAY_A);
$count = sizeof($results);
for ($i = 0; $i < $count; $i++) {
$results[$i]['meta'] = maybe_unserialize($results[$i]['meta']);
}
return $results;
}
/**
* Retrieve any old feeds which need migrating to the framework,
*
* @return bool|array
*/
public function get_old_feeds()
{
global $wpdb;
$table_name = $wpdb->prefix . 'rg_paypalpaymentspro';
if (!$this->table_exists($table_name)) {
return false;
}
$form_table_name = GFFormsModel::get_form_table_name();
$sql = "SELECT s.id, s.is_active, s.form_id, s.meta, f.title as form_title\r\n\t\t\t\t\tFROM {$table_name} s\r\n\t\t\t\t\tINNER JOIN {$form_table_name} f ON s.form_id = f.id";
$results = $wpdb->get_results($sql, ARRAY_A);
$count = sizeof($results);
$this->log_debug(__METHOD__ . '(): ' . $count . ' feed(s) found to copy.');
for ($i = 0; $i < $count; $i++) {
$results[$i]['meta'] = maybe_unserialize($results[$i]['meta']);
}
return $results;
}
