197 lines
10 KiB
PHP
197 lines
10 KiB
PHP
|
|
<?php
|
||
|
|
|
||
|
|
class GDSRImport {
|
||
|
|
function table_exists($table_name) {
|
||
|
|
global $wpdb, $table_prefix;
|
||
|
|
|
||
|
|
return $wpdb->get_var(sprintf("SHOW TABLES LIKE '%s%s'", $table_prefix, $table_name)) == $table_prefix.$table_name;
|
||
|
|
}
|
||
|
|
|
||
|
|
function import_check($import_exists) {
|
||
|
|
if ($import_exists) {
|
||
|
|
_e("Data not imported.", "gd-star-rating");
|
||
|
|
return true;
|
||
|
|
}
|
||
|
|
else {
|
||
|
|
_e("Plugin not available for import.", "gd-star-rating");
|
||
|
|
return false;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
// import star rating for review
|
||
|
|
function import_srfr($review_rating = 5, $max_value = 5, $meta_key = 'rating', $import_try = 'B') {
|
||
|
|
if ($import_try == 'B' || $import_try == 'M')
|
||
|
|
GDSRImport::import_srfr_meta($review_rating, $max_value, $meta_key);
|
||
|
|
if ($import_try == 'B' || $import_try == 'P')
|
||
|
|
GDSRImport::import_srfr_post($review_rating, $max_value);
|
||
|
|
}
|
||
|
|
|
||
|
|
function import_srfr_meta($review_rating = 5, $max_value = 5, $meta_key = 'rating') {
|
||
|
|
global $table_prefix;
|
||
|
|
$sql = sprintf("SELECT p.ID, trim(m.meta_value) as rating, p.post_type FROM %spostmeta m inner join %sposts p on p.ID = m.post_id where m.meta_key = '%s' and p.post_status = 'publish'",
|
||
|
|
$table_prefix, $table_prefix, $meta_key);
|
||
|
|
GDSRImport::import_srfr_execute($sql, $review_rating, $max_value);
|
||
|
|
}
|
||
|
|
|
||
|
|
function import_srfr_post($review_rating = 5, $max_value = 5) {
|
||
|
|
global $table_prefix;
|
||
|
|
$sql = sprintf("SELECT ID, trim(substring(substring_index(substring_index(post_content, '[rating:', 2), ']', 1), 9)) as rating, post_type FROM %sposts where post_content like '%s' and post_status = 'publish'",
|
||
|
|
$table_prefix, '%[rating:%');
|
||
|
|
GDSRImport::import_srfr_execute($sql, $review_rating, $max_value);
|
||
|
|
}
|
||
|
|
|
||
|
|
function import_srfr_execute($sql, $review_rating = 5, $max_value = 5) {
|
||
|
|
global $wpdb, $table_prefix;
|
||
|
|
$data = $wpdb->get_results($sql);
|
||
|
|
foreach ($data as $row) {
|
||
|
|
$id = $row->ID;
|
||
|
|
$is_page = $row->post_type == 'page' ? '1' : '0';
|
||
|
|
$old_rating = $row->rating;
|
||
|
|
$rating = number_format($old_rating * ($review_rating / $max_value), 1);
|
||
|
|
$sql_update = sprintf("update %sgdsr_data_article set review = '%s' where post_id = %s",
|
||
|
|
$table_prefix, $rating, $id);
|
||
|
|
$wpdb->query($sql_update);
|
||
|
|
if ($wpdb->rows_affected == 0) {
|
||
|
|
GDSRDatabase::add_default_vote($id, $is_page, $rating);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
function import_srfr_check($import_status) {
|
||
|
|
if ($import_status == 1) {
|
||
|
|
_e("Data imported.", "gd-star-rating");
|
||
|
|
return false;
|
||
|
|
}
|
||
|
|
else return GDSRImport::import_check(true);
|
||
|
|
}
|
||
|
|
// import star rating for review
|
||
|
|
|
||
|
|
// import post star rating
|
||
|
|
function import_psr() {
|
||
|
|
GDSRImport::import_psr_article();
|
||
|
|
GDSRImport::import_psr_log();
|
||
|
|
GDSRImport::import_psr_trend();
|
||
|
|
}
|
||
|
|
|
||
|
|
function import_psr_check($import_status) {
|
||
|
|
if ($import_status == 0) {
|
||
|
|
return GDSRImport::import_check(GDSRImport::table_exists("psr_post") && GDSRImport::table_exists("psr_user"));
|
||
|
|
}
|
||
|
|
else {
|
||
|
|
_e("Data imported.", "gd-star-rating");
|
||
|
|
return false;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
function import_psr_article() {
|
||
|
|
global $wpdb, $table_prefix;
|
||
|
|
|
||
|
|
$sql = sprintf("select distinct id from %spsr_post", $table_prefix);
|
||
|
|
$ids = $wpdb->get_results($sql);
|
||
|
|
$idx = array();
|
||
|
|
foreach ($ids as $id) $idx[] = $id->id;
|
||
|
|
$idlist = join(", ", $idx);
|
||
|
|
|
||
|
|
$sql = sprintf("UPDATE %sgdsr_data_article a INNER JOIN %spsr_post p ON p.id = a.post_id set a.visitor_voters = a.visitor_voters + p.votes, a.visitor_votes = a.visitor_votes + p.points WHERE a.post_id in (%s)",
|
||
|
|
$table_prefix, $table_prefix, $idlist);
|
||
|
|
$wpdb->query($sql);
|
||
|
|
|
||
|
|
$sql = sprintf("select post_id from %sgdsr_data_article where post_id in (%s)", $table_prefix, $idlist);
|
||
|
|
$idr = $wpdb->get_results($sql);
|
||
|
|
$idm = array();
|
||
|
|
foreach ($idr as $id) $idm[] = $id->post_id;
|
||
|
|
$idn = array();
|
||
|
|
foreach ($ids as $id) {
|
||
|
|
if (!in_array($id->id, $idm))
|
||
|
|
$idn[] = $id->id;
|
||
|
|
}
|
||
|
|
if (count($idn) > 0) {
|
||
|
|
$inlist = join(", ", $idn);
|
||
|
|
$sql = sprintf("INSERT INTO %sgdsr_data_article SELECT p.id, 'A', 'A', 'N', 'N', if (strcmp(w.post_type, 'page'), '0', '1'), 0, 0, p.votes, p.points, -1, '', 0, 0, 0, 0, 0, 'N', '', null FROM %spsr_post p INNER JOIN %sposts w ON p.id = w.id WHERE p.id in (%s) ORDER BY p.id",
|
||
|
|
$table_prefix, $table_prefix, $table_prefix, $inlist
|
||
|
|
);
|
||
|
|
$wpdb->query($sql);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
function import_psr_log() {
|
||
|
|
global $wpdb, $table_prefix;
|
||
|
|
$sql = sprintf("INSERT INTO %sgdsr_votes_log SELECT null, post, 'article', 0, 0, points, '', vote_date, ip, '', 0 FROM %spsr_user ORDER BY vote_date", $table_prefix, $table_prefix);
|
||
|
|
$wpdb->query($sql);
|
||
|
|
}
|
||
|
|
|
||
|
|
function import_psr_trend() {
|
||
|
|
global $wpdb, $table_prefix;
|
||
|
|
$sql = sprintf("INSERT INTO %sgdsr_votes_trend SELECT post, 'article', 0, 0, count(points), sum(points), DATE_FORMAT(vote_date, '%s') FROM %spsr_user GROUP BY post, DATE_FORMAT(vote_date, '%s') ORDER BY DATE_FORMAT(vote_date, '%s') asc, post asc", $table_prefix, '%Y-%m-%d', $table_prefix, '%Y-%m-%d', '%Y-%m-%d');
|
||
|
|
$wpdb->query($sql);
|
||
|
|
}
|
||
|
|
// import post star rating
|
||
|
|
|
||
|
|
// improt wp post rating
|
||
|
|
function import_wpr() {
|
||
|
|
GDSRImport::import_wpr_log();
|
||
|
|
GDSRImport::import_wpr_trend_articles();
|
||
|
|
}
|
||
|
|
|
||
|
|
function import_wpr_check($import_status) {
|
||
|
|
if ($import_status == 0) {
|
||
|
|
return GDSRImport::import_check(GDSRImport::table_exists("ratings"));
|
||
|
|
}
|
||
|
|
else {
|
||
|
|
_e("Data imported.", "gd-star-rating");
|
||
|
|
return false;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
function import_wpr_log() {
|
||
|
|
global $wpdb, $table_prefix;
|
||
|
|
$sql = sprintf("INSERT INTO %sgdsr_votes_log SELECT null, rating_postid, 'article', 0, rating_userid, rating_rating, '', FROM_UNIXTIME(rating_timestamp), rating_ip, '', 0 FROM %sratings ORDER BY rating_timestamp asc", $table_prefix, $table_prefix);
|
||
|
|
$wpdb->query($sql);
|
||
|
|
}
|
||
|
|
|
||
|
|
function import_wpr_trend_articles() {
|
||
|
|
global $wpdb, $table_prefix;
|
||
|
|
$sql = sprintf("select distinct rating_postid from %sratings", $table_prefix);
|
||
|
|
$ids = $wpdb->get_results($sql);
|
||
|
|
$idx = array();
|
||
|
|
foreach ($ids as $id) $idx[] = $id->rating_postid;
|
||
|
|
$idlist = join(", ", $idx);
|
||
|
|
$sql = sprintf("select post_id from %sgdsr_data_article where post_id in (%s)", $table_prefix, $idlist);
|
||
|
|
$idr = $wpdb->get_results($sql);
|
||
|
|
$idm = array();
|
||
|
|
foreach ($idr as $id) $idm[] = $id->post_id;
|
||
|
|
$idn = array();
|
||
|
|
foreach ($ids as $id) {
|
||
|
|
if (!in_array($id->rating_postid, $idm))
|
||
|
|
$idn[] = $id->rating_postid;
|
||
|
|
}
|
||
|
|
$sqlFull = sprintf("CREATE TABLE %sgdsrtemp (id INTEGER(11) DEFAULT NULL, vote_type VARCHAR(10) DEFAULT NULL, user_voters INTEGER(11) DEFAULT NULL, user_votes INTEGER(11) DEFAULT NULL, visitor_voters INTEGER(11) DEFAULT NULL, visitor_votes INTEGER(11) DEFAULT NULL, vote_date VARCHAR(10) DEFAULT NULL)", $table_prefix);
|
||
|
|
$wpdb->query($sqlFull);
|
||
|
|
$sqlFull = sprintf("CREATE TABLE %sgdsrjoin (id INTEGER(11) DEFAULT NULL, vote_type VARCHAR(10) DEFAULT NULL, user_voters INTEGER(11) DEFAULT NULL, user_votes INTEGER(11) DEFAULT NULL, visitor_voters INTEGER(11) DEFAULT NULL, visitor_votes INTEGER(11) DEFAULT NULL, vote_date VARCHAR(10) DEFAULT NULL)", $table_prefix);
|
||
|
|
$wpdb->query($sqlFull);
|
||
|
|
$sqlFull = sprintf("INSERT INTO %sgdsrtemp SELECT rating_postid, 'article', 0, 0, count(rating_rating), sum(rating_rating), DATE_FORMAT(FROM_UNIXTIME(rating_timestamp), '%s') FROM %sratings where rating_userid = 0 group by rating_postid, DATE_FORMAT(FROM_UNIXTIME(rating_timestamp), '%s') ORDER BY rating_timestamp asc", $table_prefix, "%Y-%m-%d", $table_prefix, "%Y-%m-%d");
|
||
|
|
$wpdb->query($sqlFull);
|
||
|
|
$sqlFull = sprintf("INSERT INTO %sgdsrtemp SELECT rating_postid, 'article', count(rating_rating), sum(rating_rating), 0, 0, DATE_FORMAT(FROM_UNIXTIME(rating_timestamp), '%s') FROM %sratings where rating_userid > 0 group by rating_postid, DATE_FORMAT(FROM_UNIXTIME(rating_timestamp), '%s') ORDER BY rating_timestamp asc", $table_prefix, "%Y-%m-%d", $table_prefix, "%Y-%m-%d");
|
||
|
|
$wpdb->query($sqlFull);
|
||
|
|
$sqlFull = sprintf("INSERT INTO %sgdsrjoin SELECT id, 'article', sum(user_voters), sum(user_votes), sum(visitor_voters), sum(visitor_votes), vote_date FROM %sgdsrtemp group by id", $table_prefix, $table_prefix);
|
||
|
|
$wpdb->query($sqlFull);
|
||
|
|
$sqlFull = sprintf("INSERT INTO %sgdsr_votes_trend SELECT * FROM %sgdsrjoin; ", $table_prefix, $table_prefix);
|
||
|
|
$wpdb->query($sqlFull);
|
||
|
|
$sqlFull = sprintf("UPDATE %sgdsr_data_article a INNER JOIN %sgdsrjoin p ON p.id = a.post_id set a.visitor_voters = a.visitor_voters + p.visitor_voters, a.visitor_votes = a.visitor_votes + p.visitor_votes, a.user_voters = a.user_voters + p.user_voters, a.user_votes = a.user_votes + p.user_votes WHERE a.post_id in (%s)",
|
||
|
|
$table_prefix, $table_prefix, $idlist);
|
||
|
|
$wpdb->query($sqlFull);
|
||
|
|
|
||
|
|
if (count($idn) > 0) {
|
||
|
|
$inlist = join(", ", $idn);
|
||
|
|
$sqlFull = sprintf("INSERT INTO %sgdsr_data_article SELECT p.id, 'A', 'A', 'N', 'N', 'A', 'A', 'N', 'N', if (strcmp(w.post_type, 'page'), '0', '1'), p.user_voters, p.user_votes, p.visitor_voters, p.visitor_votes, -1, '', 0, 0, 0, 0, 0, 'N', '', 'N', '', null, null, 'I', 'I', 0 FROM %sgdsrjoin p INNER JOIN %sposts w ON p.id = w.id WHERE p.id in (%s) ORDER BY p.id",
|
||
|
|
$table_prefix, $table_prefix, $table_prefix, $inlist);
|
||
|
|
$wpdb->query($sqlFull);
|
||
|
|
}
|
||
|
|
|
||
|
|
$wpdb->query(sprintf("DROP TABLE %sgdsrtemp", $table_prefix));
|
||
|
|
$wpdb->query(sprintf("DROP TABLE %sgdsrjoin", $table_prefix));
|
||
|
|
}
|
||
|
|
// improt wp post rating
|
||
|
|
}
|
||
|
|
|
||
|
|
?>
|