Files

118 lines
3.8 KiB
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?php
class GDSRExport {
function export_t2() {
global $table_prefix;
$sql = sprintf("select section, name, description, elements from %sgdsr_templates where preinstalled = '0'", $table_prefix);
return $sql;
}
function export_t2_full() {
global $wpdb, $table_prefix;
$sql = sprintf("select * from %sgdsr_templates", $table_prefix);
$res = $wpdb->get_results($sql);
$lines = array();
$line = '';
$first = true;
foreach ($res as $row) {
$values = '(';
foreach ($row as $data) $values.= '\''.addslashes($data).'\', ';
$values = substr($values, 0, -2).')';
if ($first) {
$line.= 'INSERT INTO %%T2_TABLE_NAME%% VALUES '.$values;
$first = false;
} else $line.= ', '.$values;
if (strlen($line) > 65536) {
$first = true;
$lines[] = $line.";\r\n";
$line = '';
}
}
if ($line != "") $lines[] = $line.";\r\n";
return $lines;
}
function export_users($user_data = "min", $data_export = "article", $get_data = array()) {
global $table_prefix;
$columns = array();
$select = array();
$where = array();
$tables = array();
$tables[] = $table_prefix."gdsr_votes_log v";
$tables[] = $table_prefix."users u";
$tables[] = $table_prefix."posts p";
$where[] = "v.vote_type = '".$data_export."'";
$where[] = "v.user_id = u.id";
switch ($user_data) {
case "min":
$select[] = "u.id as user_id";
$columns[] = "user_id";
break;
case "nor":
$select[] = "u.id as user_id";
$select[] = "u.display_name";
$select[] = "u.user_email";
$columns[] = "user_id";
$columns[] = "user_name";
$columns[] = "user_email";
break;
}
$select[] = "p.id";
$columns[] = "post_id";
if ($get_data["pt"] == "on") {
$select[] = "p.post_title";
$columns[] = "post_title";
}
if ($get_data["pd"] == "on") {
$select[] = "p.post_date";
$columns[] = "post_date";
}
switch ($data_export) {
case "article":
$where[] = "v.id = p.id";
break;
case "comment":
$select[] = "c.comment_id";
$columns[] = "comment_id";
$tables[] = $table_prefix."comments c";
$where[] = "v.id = c.comment_id";
$where[] = "p.id = c.comment_post_id";
if ($get_data["ca"] == "on") {
$select[] = "c.comment_author";
$columns[] = "comment_author";
}
if ($get_data["cd"] == "on") {
$select[] = "c.comment_date";
$columns[] = "comment_date";
}
break;
}
$select[] = "v.vote";
$select[] = "v.voted";
$columns[] = "vote";
$columns[] = "vote_date";
if ($get_data["ip"] == "on") {
$select[] = "v.ip";
$columns[] = "ip";
}
if ($get_data["ua"] == "on") {
$select[] = "v.user_agent";
$columns[] = "user_agent";
}
echo join(", ", $columns)."\r\n";
$j_select = join(", ", $select);
$j_where = join(" and ", $where);
$j_tables = join(", ", $tables);
return sprintf("select %s from %s where %s order by u.id", $j_select, $j_tables, $j_where);
}
}
?>