芝麻web文件管理V1.00

编辑当前文件:/home/prismawe/www/blog/wp-content/plugins/xml-google-maps/xmlgooglemaps_dbfunctions.php

<?php
/*
 * Diese Klasse enth�lt s�mtliche DB Funktionen
 */
class xmlgooglemaps_dbfunctions {

}
	
	//Installiert Datenbank Version 1 war bis und mit Version 1.11 des Plugins aktuell
	function update001($charset_collate) {
		global $wpdb;
		$ret = true;
		if (($ret !== false) && !xmlgooglemaps_dbfunctions::tableExists($wpdb->xmlgooglemapsdb)) {
			$create_sql = "CREATE TABLE $wpdb->xmlgooglemapsdb (".
				"xml_id BIGINT(20) NOT NULL auto_increment,".
				"xml_path TEXT NOT NULL ,".			
				"PRIMARY KEY (xml_id)) $charset_collate;";
			$ret = $wpdb->query($wpdb->prepare($create_sql));
		}
		if (($ret !== false) && !xmlgooglemaps_dbfunctions::columnExists($wpdb->xmlgooglemapsdb,"xml_varstring")) {
			$column_sql = "ALTER TABLE $wpdb->xmlgooglemapsdb ADD COLUMN xml_varstring TEXT NOT NULL;";
			$ret = $wpdb->query($wpdb->prepare($column_sql));
		}
		if (($ret !== false) && xmlgooglemaps_dbfunctions::columnExists($wpdb->xmlgooglemapsdb,"xml_path_resolved")) {
			$column_sql = "ALTER TABLE $wpdb->xmlgooglemapsdb DROP xml_path_resolved;";
			$ret = $wpdb->query($wpdb->prepare($column_sql));
		}
		if (($ret !== false) && !xmlgooglemaps_dbfunctions::tableExists($wpdb->xmlgooglemapsdbcache)) {
			$create_sql = "CREATE TABLE $wpdb->xmlgooglemapsdbcache (".
				"xml_id BIGINT(20) NOT NULL,".
				"xml_cache_key VARCHAR(20) NOT NULL ,".
				"xml_cache_lastupdated DATETIME NOT NULL ,".
				"xml_cache_content LONGTEXT NOT NULL ,".
				"PRIMARY KEY (xml_id, xml_cache_key)) $charset_collate;";
			$ret = $wpdb->query($wpdb->prepare($create_sql));
		}
		if (($ret !== false) && strtolower(xmlgooglemaps_dbfunctions::columnType($wpdb->xmlgooglemapsdbcache,"xml_cache_content")) == "text") {
			$column_sql = "ALTER TABLE $wpdb->xmlgooglemapsdbcache CHANGE xml_cache_content xml_cache_content LONGTEXT NOT NULL";
			$ret = $wpdb->query($wpdb->prepare($column_sql));
			if ($ret !== false) { xmlgooglemaps_dbfunctions::cacheClearAll(); }
		}
		if (($ret !== false) && (get_option(key_xmlgm_current_db_version)<1)) { update_option(key_xmlgm_current_db_version, 1); }
		return $ret;			
	}
	
	//Installiert Datenbank Version 2
	function update002($charset_collate) {
		global $wpdb;
		$ret = true;
		if (($ret !== false) && strtolower(xmlgooglemaps_dbfunctions::columnType($wpdb->xmlgooglemapsdbcache,"xml_id")) == "int(11)") {
			$column_sql = "ALTER TABLE $wpdb->xmlgooglemapsdbcache CHANGE xml_id xml_id BIGINT NOT NULL auto_increment";
			$ret = $wpdb->query($wpdb->prepare($column_sql));		
		}
		if (($ret !== false) && strtolower(xmlgooglemaps_dbfunctions::columnType($wpdb->xmlgooglemapsdb,"xml_id")) == "int(11)") {
			$column_sql = "ALTER TABLE $wpdb->xmlgooglemapsdb CHANGE xml_id xml_id BIGINT NOT NULL auto_increment";
			$ret = $wpdb->query($wpdb->prepare($column_sql));			
		}

if (($ret !== false) && !xmlgooglemaps_dbfunctions::tableExists($wpdb->xmlgooglemapsdbgpxfile)) {
			$create_sql = "CREATE TABLE $wpdb->xmlgooglemapsdbgpxfile (".
  						"`gpxfile_id` bigint(20) NOT NULL AUTO_INCREMENT,".
  						"`filepath` text NOT NULL,".
  						"`fileupdatetime` datetime NOT NULL,".
  						"`maxlat` double DEFAULT NULL,".
  						"`maxlon` double DEFAULT NULL,".
  						"`minlat` double DEFAULT NULL,".
  						"`minlon` double DEFAULT NULL,".
  						"PRIMARY KEY (`gpxfile_id`)) $charset_collate";
			$ret = $wpdb->query($wpdb->prepare($create_sql));
		}
		
		if (($ret !== false) && !xmlgooglemaps_dbfunctions::tableExists($wpdb->xmlgooglemapsdbgpxfileitem)) {
			$create_sql = "CREATE TABLE $wpdb->xmlgooglemapsdbgpxfileitem (".
					  "`item_id` bigint(20) NOT NULL AUTO_INCREMENT,".
					  "`item_nr` bigint(20) NOT NULL,".
					  "`gpxfile_id` bigint(20) NOT NULL,".
					  "`element` ENUM( 'RTE', 'RTEPT', 'TRK', 'TRKPT', 'WPT' ),".
					  "`parent_item_id` int(11) DEFAULT NULL,".
					  "`name` text,".
					  "`description` text,".
					  "`symbol` text,".
					  "`link` text,".
					  "`time` datetime DEFAULT NULL,".
					  "`lat` double DEFAULT NULL,".
					  "`lon` double DEFAULT NULL,".
					  "`ele` double DEFAULT NULL,".
					  "`heartrate` double DEFAULT NULL,".
					  "PRIMARY KEY (`item_id`)) $charset_collate";
			$ret = $wpdb->query($wpdb->prepare($create_sql));
		}		
		if (($ret !== false) && (get_option(key_xmlgm_current_db_version)<2)) { 
			update_option(key_xmlgm_current_db_version, 2);
			xmlgooglemaps_dbfunctions::gpxClearAll();
		}
		return $ret;
	}

function tableExists($tablename) {
		global $wpdb;
		foreach ($wpdb->get_col("SHOW TABLES",0) as $table ) {
			if ($table == $tablename) {
				return true;
			}
		}
		return false;
	}

function xmlGetId($path, $varstring) {
		global $wpdb;
		// Check IP From IP Logging Database
		$ret = $wpdb->get_var($wpdb->prepare("SELECT xml_id FROM $wpdb->xmlgooglemapsdb WHERE xml_path = %s AND xml_varstring = %s",$path,$varstring));
		if ($ret == 0) {
			$wpdb->query($wpdb->prepare("INSERT INTO $wpdb->xmlgooglemapsdb (xml_path, xml_varstring) VALUES (%s,%s)",$path,$varstring));
			$ret = xmlgooglemaps_dbfunctions::xmlGetId($path, $varstring);
		}
		return intval($ret);
	}

function xmlGetPath($id) {
		global $wpdb;
		// Check IP From IP Logging Database
		$ret = $wpdb->get_var($wpdb->prepare("SELECT xml_path FROM $wpdb->xmlgooglemapsdb WHERE xml_id = %d",$id));
		return $ret;
	}