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; }