"; 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.""; ?>