<?php
// generate template preview
include "/nfslocal/www/include/db/dbconnect.php";
//get vars
$campaign = $_REQUEST["c"];
$uid = $_REQUEST["u"];
$output = build_instance($uid, $campaign);
echo !isset($output["error"]) ? stripslashes($output["copy"]) : $output["error"];
///////////////////////////////////////////////////////////////////////////////////////////////////////
function build_instance($uid, $campaign)
{
// get user details
$campaignemail = $campaign . "_email";
$csql = mysql_query("SELECT * FROM {$campaignemail} WHERE uid = '{$uid}'");
$c = mysql_fetch_array($csql);
$temp_inst = $c["template"];
$part = "html";
// get client and campaign/tempalte tables
$sql = "SELECT client.company, campaign.trackopen FROM campaign INNER JOIN `client` ON campaign.client_id = client.client_id WHERE campaign.reference ='{$campaign}';";
$getcomp = mysql_query($sql);
$company = mysql_fetch_array($getcomp);
$template_table = $company[0] . "_template";
$section_table = $company[0] . "_section";
$ti_table = $company[0] . "_template_instance";
$si_table = $company[0] . "_section_instance";
$rules = $company[0] . "_rules";
$trackopen = $company[1];
// get template from temp instance
$tisql = mysql_query("SELECT * FROM {$ti_table} WHERE template_instance_id = '{$temp_inst}'");
if (mysql_num_rows($tisql) < 1) {
exit;
}
if (isset($_GET["stop-instance"])) {
stop_instance();
exit;
}
if (isset($_GET["restart-instance"])) {
restart_instance();
exit;
}
if (isset($_GET["restart-instance-silent"])) {
restart_instance_silent();
exit;
}
if (isset($_GET["build-instance"])) {
build_instance();
exit;
}
if (isset($_GET["reload-all-instances"])) {
reload_all_instances();
exit;
}
if (isset($_GET["main-status"])) {
status();
exit;
}
if (isset($_GET["global-status"])) {
global_status();
exit;
}
if (isset($_GET["global-stats"])) {
