100 lines
3.1 KiB
PHP
100 lines
3.1 KiB
PHP
<?php
|
|
@define('PLUGIN_OEMBED_DATABASEVERSION_CONFIG', "oembed_version");
|
|
@define('PLUGIN_OEMBED_DATABASEVNAME', "oembeds");
|
|
|
|
class OEmbedDatabase {
|
|
|
|
static function save_oembed($url, $oembed) {
|
|
if (empty($url) || !isset($oembed)) return false;
|
|
if (isset($oembed->html)) {
|
|
$oembed->html = OEmbedDatabase::cleanup_html($oembed->html);
|
|
}
|
|
$save = array();
|
|
$save['urlmd5'] = md5($url);
|
|
$save['url'] = $url;
|
|
$save['oetype'] = $oembed->type;
|
|
$save['oeobj'] = serialize($oembed);
|
|
serendipity_db_insert( PLUGIN_OEMBED_DATABASEVNAME, $save );
|
|
return $oembed;
|
|
}
|
|
|
|
static function load_oembed($url) {
|
|
global $serendipity;
|
|
if (empty($url)) return null;
|
|
|
|
$urlmd5 = md5($url);
|
|
$query = "select oeobj from {$serendipity['dbPrefix']}" . PLUGIN_OEMBED_DATABASEVNAME . " where urlmd5='$urlmd5'";
|
|
|
|
$rows = serendipity_db_query($query);
|
|
if (!is_array($rows)) { // fresh search
|
|
return null;
|
|
}
|
|
else {
|
|
$oeobj = null;
|
|
foreach ($rows as $row) {
|
|
$oeobj = $row['oeobj'];
|
|
if (!empty($oeobj)) break;
|
|
}
|
|
if (!empty($oeobj)) {
|
|
return unserialize($oeobj);
|
|
}
|
|
|
|
}
|
|
return null;
|
|
}
|
|
|
|
static function clear_cache() {
|
|
global $serendipity;
|
|
$q = "delete from {$serendipity['dbPrefix']}" . PLUGIN_OEMBED_DATABASEVNAME;
|
|
serendipity_db_schema_import($q);
|
|
}
|
|
|
|
static function install(&$obj) {
|
|
global $serendipity;
|
|
|
|
if (!OEmbedDatabase::table_created(PLUGIN_OEMBED_DATABASEVNAME)) {
|
|
$md5test = md5("test");
|
|
$md5len = strlen($md5test);
|
|
$q = "create table {$serendipity['dbPrefix']}" . PLUGIN_OEMBED_DATABASEVNAME. " (" .
|
|
"urlmd5 char($md5len) not null, " .
|
|
"url varchar(3000) not null, " .
|
|
"oetype varchar(20) not null, " .
|
|
"oeobj text not null, " .
|
|
"primary key (urlmd5)" .
|
|
")";
|
|
|
|
$result = serendipity_db_schema_import($q);
|
|
|
|
if ($result !== true) {
|
|
return;
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
static function table_created($table = PLUGIN_OEMBED_DATABASEVNAME) {
|
|
global $serendipity;
|
|
|
|
$q = "select count(*) from {$serendipity['dbPrefix']}" . $table;
|
|
$row = serendipity_db_query($q, true, 'num');
|
|
|
|
if (!is_numeric($row[0])) { // if the response we got back was an SQL error.. :P
|
|
return false;
|
|
} else {
|
|
return true;
|
|
}
|
|
}
|
|
|
|
static function cleanup_html( $str ) {
|
|
$str = trim($str);
|
|
// Clear unicode stuff
|
|
$str=str_ireplace("\u003C","<",$str);
|
|
$str=str_ireplace("\u003E",">",$str);
|
|
// Clear CDATA Trash.
|
|
$str = preg_replace("@^<!\[CDATA\[(.*)\]\]>$@", '$1', $str);
|
|
$str = preg_replace("@^<!\[CDATA\[(.*)@", '$1', $str);
|
|
$str = preg_replace("@(.*)\]\]>$@", '$1', $str);
|
|
return $str;
|
|
}
|
|
|
|
} |