function easycontactforms_uninstall()
{
global $wpdb;
$sqls[] = "DROP TABLE IF EXISTS #wp__easycontactforms_applicationsettings;";
$sqls[] = "DROP TABLE IF EXISTS #wp__easycontactforms_contacttypes;";
$sqls[] = "DROP TABLE IF EXISTS #wp__easycontactforms_customformentryfiles;";
$sqls[] = "DROP TABLE IF EXISTS #wp__easycontactforms_customformentrystatistics;";
$sqls[] = "DROP TABLE IF EXISTS #wp__easycontactforms_customformfields;";
$sqls[] = "DROP TABLE IF EXISTS #wp__easycontactforms_customformfieldtypes;";
$sqls[] = "DROP TABLE IF EXISTS #wp__easycontactforms_customforms;";
$sqls[] = "DROP TABLE IF EXISTS #wp__easycontactforms_customforms_mailinglists;";
$sqls[] = "DROP TABLE IF EXISTS #wp__easycontactforms_customformsentries;";
$sqls[] = "DROP TABLE IF EXISTS #wp__easycontactforms_files;";
$sqls[] = "DROP TABLE IF EXISTS #wp__easycontactforms_options;";
$sqls[] = "DROP TABLE IF EXISTS #wp__easycontactforms_roles;";
$sqls[] = "DROP TABLE IF EXISTS #wp__easycontactforms_users;";
$sqls[] = "DROP TABLE IF EXISTS #wp__easycontactforms_acl;";
$sqls[] = "DROP TABLE IF EXISTS #wp__easycontactforms_sessions;";
require_once dirName(__FILE__) . DIRECTORY_SEPARATOR . 'easy-contact-forms-database.php';
foreach ($sqls as $sql) {
$sql = EasyContactFormsDB::wptn($sql);
$wpdb->query($sql);
}
}
/**
* insert
*
* insert new object data
*
* @param array $valuemap
* values to insert
* @param string $type
* inserted object type
*
* @return int
* inserted object id
*/
function insert($valuemap, $type)
{
if (count($valuemap) == 0) {
return;
}
$names = '';
$values = '';
$comma = '';
foreach ($valuemap as $key => $value) {
if (is_null($value)) {
continue;
}
$names .= $comma . '' . $key . '';
$values .= $comma . " '" . $value . "'";
$comma = ', ';
}
$obj = EasyContactFormsClassLoader::getObject($type);
$dbtable = $obj->getTableName();
$dbtable = EasyContactFormsDB::wptn($dbtable);
$query = 'INSERT INTO ' . $dbtable . '(' . $names . ') VALUES (' . $values . ')';
EasyContactFormsDB::query($query);
global $wpdb;
return $wpdb->insert_id;
}
/**
* setSessionValue
*
* @param $key
*
* @param $value
*
* @param $sid
*
*
* @return
*
*/
function setSessionValue($key, $value, $sid = NULL)
{
if (is_array($sid) && isset($sid['sid'])) {
$sessid = addslashes($sid['sid']);
if ($sessid != $sid['sid']) {
return NULL;
}
if (strlen($sessid) != 32) {
return NULL;
}
$sid = $sessid;
} else {
return NULL;
}
$dbtable = EasyContactFormsDB::wptn('#wp__easycontactforms_sessions');
$query = "SELECT id, value FROM {$dbtable} WHERE sid=%s";
global $wpdb;
$query = $wpdb->prepare($query, $sid);
$row = EasyContactFormsDB::getObjects($query);
if (count($row) == 0) {
return NULL;
}
$row = $row[0];
$rid = $row->id;
$xml = simplexml_load_string($row->value);
$xml->{$key} = $value;
$svalue = $xml->asXML();
$query = "UPDATE {$dbtable} SET value=%s WHERE id=%d";
global $wpdb;
$query = $wpdb->prepare($query, $svalue, $rid);
EasyContactFormsDB::query($query);
return $sid;
}
