<?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_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);
    }
}

?>