// LIBRARY include "../../../../inc/c.php"; // MVC SYSTEM // -- Functions and extended classes // @param -- c.php and m.php // VARS $eid = mysql_real_escape_string($_GET['eid']); $libraryid = mysql_real_escape_string($_GET['libraryid']); $date = date("Y-m-d H:i:s"); $ip = $_SERVER['REMOTE_ADDR']; $globalHTML = ""; // DB // -- GLOBAL VARS SUCH AS COREMETRICS ETC $email_list = mysql_query("SELECT * FROM `" . $dnm . "`.`emails` WHERE `eid`='" . $eid . "'"); while ($row = mysql_fetch_array($email_list)) { $email_facia = ucfirst($getFaciaName = getFaciaName($row["faciaid"])); $email_name = str_replace(" ", "", $row["name"]); $email_launch_date = $row["launch_date"]; $email_coremetrics_tag = "" . $row["launch_date"] . "-" . $email_name . "-" . $email_facia . ""; $email_currency = getFaciaCurrency($row["faciaid"]); } // SQL MODEL // THINGS DO GET UGLY // -- Order: // Header, Nav and logo // Delivery tab if any // Content spots and links // Footer and brands. // Wings v1 // HEADER HTML $globalHTML .= '
<?php while ($row = mysql_fetch_array($email_list)) { ?> <?php // VARS $dateLaunch = new DateTime($row["launch_date"]); $campaignDate = str_replace('-', '.', $dateLaunch->format('Y-m-d')); ?> <tr> <td><?php echo $row["eid"]; ?> </td> <td> [<?php echo ucfirst($getFaciaName = getFaciaName($row["faciaid"])); ?> ] <?php echo $row["name"]; ?> - <?php echo $campaignDate; ?> <br /> <small>Last modified: <?php echo $row["last_mod"]; ?> </small> </td> <td><?php echo ucfirst($getUserName = getUserName($row["uid"]));