";
exec_sql_lines(SQL_DOMAINS, 'pph_domains', $tbl_domains);
//Load the new pphlogger_cache table
$sql = "SELECT COUNT(*) FROM ".$tbl_cache;
$res = mysql_query($sql);
if (!$res) exec_sql_lines(SQL_CACHE, 'pphl_cache', $tbl_cache);
$sql = "ALTER TABLE ".$tbl_users." "
. "ADD conf enum('Y','N') DEFAULT 'N' NOT NULL, "
. "CHANGE date_start date_start DATETIME NOT NULL";
mysql_qry($sql);
$sql = "UPDATE ".$tbl_users." SET conf='Y'";
mysql_qry($sql);
$sql = "SELECT id FROM ".$tbl_users.";";
$res = mysql_query($sql);
while ($row = mysql_fetch_array($res)) {
$id = $row['id'];
$sql = "ALTER TABLE ".$tbl_prefix.$id.$tbl_mpdl." "
. "CHANGE type type enum('mp','dl','kw') DEFAULT 'mp' NOT NULL";
mysql_qry($sql);
$sql = "ALTER TABLE ".$tbl_prefix.$id.$tbl_ipcheck." "
. "ADD hostname varchar(150) NOT NULL AFTER ip;";
mysql_qry($sql);
//load keywords
$sql_del = "DELETE FROM ".$tbl_prefix.$id.$tbl_mpdl." WHERE type = 'kw'";
$res_del = mysql_query($sql_del);
$sql_keyw = "SELECT referer FROM ".$tbl_prefix.$id.$tbl_logs." WHERE referer LIKE '%?%'";
$res_keyw = mysql_query($sql_keyw);
while ($row_keyw = mysql_fetch_array($res_keyw)) {
$keywrd = show_keywords($row_keyw['referer'], $arr_engines);
if ($keywrd[3]) {
insert_mpdl($keywrd[3], 'kw', $tbl_prefix.$id.$tbl_mpdl)."
";
}
}
}
echo $br.$br."Your upgrade to v.2.1.1 was successful!";
echo $br."Now, please run the next upgrade script: upd_2.1.1-2.1.1d.".CFG_PHPEXT."";
?>