Changeset 1330580
- Timestamp:
- 01/18/2016 02:45:53 PM (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
data-storage/tags/2.5.3/ghazale-data-storage-main.php
r1330315 r1330580 177 177 $table_name = $wpdb->prefix . "ghazale_ds_"; 178 178 $tables= $wpdb->get_results("SHOW TABLES LIKE "."'" .$table_name."%_fields'",ARRAY_A); 179 // 180 // $table_name_prefix = $wpdb->prefix . "ghazale_ds_"; 181 // $input_tables= $wpdb->get_results("SHOW TABLES LIKE "."'" .$table_name_prefix."%_inputs'"); 182 // $order = 0; 183 // foreach($input_tables as $input_table){ 184 // foreach($input_table as $table){ 185 // $column_exists = $wpdb-> query("SHOW COLUMNS FROM `".$table."` LIKE 'input_order'"); 186 // if(!$column_exists){ 187 // $add_column = "ALTER TABLE ". $table. " ADD input_order INT(10) NOT NULL AFTER field_id"; 188 // $wpdb->query($add_column); 189 // $last_field_id = "SELECT MAX(field_id) FROM ".$table. " LIMIT 1"; 190 // $max_field_id_query = $wpdb-> get_var($last_field_id); 191 // $inputs_field_id = "SELECT id,field_id,input_order FROM ".$table. " ORDER BY id ASC"; 192 // $inputs_field_id_query = $wpdb->get_results($inputs_field_id,ARRAY_A); 193 // var_dump($inputs_field_id_query); 194 // foreach($inputs_field_id_query as $input){ 195 // if( $input['field_id'] <= $max_field_id_query ){ 196 // $wpdb->query('UPDATE '. $table.' SET input_order='.($order+1).' WHERE id='.$input['id']); 197 // } 198 // if( $input['field_id']== $max_field_id_query){ 199 // $order = $input['input_order']; 200 // } 201 // } 202 // } 203 // } 204 // } 179 205 180 ?> 206 181 <form action="" method="post" id="ghazale_ds_add_fields">
Note: See TracChangeset
for help on using the changeset viewer.