예제 #1
0
// --------------------------------------------
//TODO
$name = "image";
// --------------------------------------------
// ONLY FOR DEBUG PURPOSES
$name = "invitee";
$columns = array("invitee_id", "firstname", "lastname", "comment", "inviteesource_id", "inviteestatus_id", "date_lastchange", "date_created", "date_invited");
$SQL = array_merge($SQL, delete_and_inset($news_db_prefix, $name, $columns, ${$name}));
// --------------------------------------------
$name = "issue";
$columns = array("issue_id", "year", "number", "institute_image", "institute_image_caption", "date_published", "last_preprint_year", "last_preprint_number", "sent_no_subscribers");
$SQL = array_merge($SQL, delete_and_inset($news_db_prefix, $name, $columns, ${$name}));
// --------------------------------------------
// POSSIBLY OBSOLETE
$name = "issue_campaign";
$columns = array("issue_id", "campaign_id");
$SQL = array_merge($SQL, delete_and_inset($news_db_prefix, $name, $columns, ${$name}));
// --------------------------------------------
$name = "issue_upcoming";
$columns = array("issue_id", "event_id");
$SQL = array_merge($SQL, delete_and_inset($news_db_prefix, $name, $columns, ${$name}));
// --------------------------------------------
// ONLY FOR DEBUG PURPOSES
$name = "subscriber";
$columns = array("subscriber_id", "comment", "subscribersource_id", "subscriberstatus_id", "date_lastchange", "date_created");
$SQL = array_merge($SQL, delete_and_inset($news_db_prefix, $name, $columns, ${$name}));
// --------------------------------------------
$name = "template";
$columns = array("template_id", "title", "text", "templatetype_id", "date_lastchange", "date_created", "isdefault", "templatestatus_id");
$SQL = array_merge($SQL, delete_and_inset($news_db_prefix, $name, $columns, ${$name}));
// ==========================================================================
예제 #2
0
// --------------------------------------------
//TODO
$name = "image";
// --------------------------------------------
// ONLY FOR DEBUG PURPOSES
$name = "invitee";
$columns = array("invitee_id", "firstname", "lastname", "comment", "inviteesource_id", "inviteestatus_id", "date_lastchange", "date_created", "date_invited");
$SQL = array_merge($SQL, delete_and_inset($name, $columns, ${$name}));
// --------------------------------------------
$name = "issue";
$columns = array("issue_id", "year", "number", "institute_image", "institute_image_caption", "date_published", "last_preprint_year", "last_preprint_number", "sent_no_subscribers");
$SQL = array_merge($SQL, delete_and_inset($name, $columns, ${$name}));
// --------------------------------------------
// POSSIBLY OBSOLETE
$name = "issue_campaign";
$columns = array("issue_id", "campaign_id");
$SQL = array_merge($SQL, delete_and_inset($name, $columns, ${$name}));
// --------------------------------------------
$name = "issue_upcoming";
$columns = array("issue_id", "event_id");
$SQL = array_merge($SQL, delete_and_inset($name, $columns, ${$name}));
// --------------------------------------------
// ONLY FOR DEBUG PURPOSES
$name = "subscriber";
$columns = array("subscriber_id", "comment", "subscribersource_id", "subscriberstatus_id", "date_lastchange", "date_created");
$SQL = array_merge($SQL, delete_and_inset($name, $columns, ${$name}));
// --------------------------------------------
$name = "template";
$columns = array("template_id", "title", "text", "templatetype_id", "date_lastchange", "date_created", "isdefault", "templatestatus_id");
$SQL = array_merge($SQL, delete_and_inset($name, $columns, ${$name}));
// ==========================================================================