motherjones/ncu

Name: ncu

Owner: Mother Jones

Description: Overhaul of UI for the NCU

Created: 2018-02-22 00:15:01.0

Updated: 2018-05-22 20:28:13.0

Pushed: 2018-05-22 20:28:12.0

Homepage: null

Size: 3699

Language: PHP

GitHub Committers

User	Most Recent Commit	# Commits

Other Committers

User	Email	Most Recent Commit	# Commits

README

Newsletter Curation Utility [NCU] (Previously known as Sir Simian)

NCU: an online tool to make html newsletters

Structure of NCU

• index.php: Main entry file. Contains input boxes for all newsletter elements
• Individual newsletter template files: Each contain newsletter specific code
  • econundrum-template.php
  • food-redesign-template.php (2016 redesigned version)
  • food-template.php (old version)
  • inthemix-template.php
  • politics-template.php
  • breaking-news-template.php
• process_headlines.php: Contains code common to all newsletters plus functions to write temp files & place finished newsletters into the archives directory
• styles_includes.php: CSS code for inline insertion into HTML code in PHP variables.
• headlines_ajax_functions.php: Code for writing out input boxes for each newsletter in the index.php page.
• headlines_script.js: Contains AJAX functions that fire off server side code in the headlines_ajax_functions.php file.
• head_main.css: NCU site CSS. Not for newsletter HTML code.
• archives/index.php: Code to control display & view of the archives section of Sir Simian.

Directories and files not included in the repo that is necessary for Sir Simian function

• temp: This directory stores temporary files (snapshots) of newsletters in case of errors.
• images: NCU website images.
• ckeditor: CKEditor wysiwyg app directory.
• credentials.inc: Necessary for DB operations.

Structure of the database

------------------------+
bles_in_headlines       |
------------------------+
eaking_news             |
onundrums_new           |
od_for_thought_redesign |
adlines                 |
_the_mix_new            |
litical_mojo_new        |
umpocracy               |
------------------------+

Structure of breaking_news table

--------------+--------------+------+-----+---------+----------------+
eld           | Type         | Null | Key | Default | Extra          |
--------------+--------------+------+-----+---------+----------------+
              | int(11)      | NO   | PRI | NULL    | auto_increment |
d_date        | date         | YES  |     | NULL    |                |
bject_line    | varchar(255) | YES  |     | NULL    |                |
eaking        | text         | YES  |     | NULL    |                |
eaking_url    | text         | YES  |     | NULL    |                |
in_text       | text         | YES  |     | NULL    |                |
re_news_1     | text         | YES  |     | NULL    |                |
re_news_1_url | text         | YES  |     | NULL    |                |
re_news_2     | text         | YES  |     | NULL    |                |
re_news_2_url | text         | YES  |     | NULL    |                |
re_news_3     | text         | YES  |     | NULL    |                |
re_news_3_url | text         | YES  |     | NULL    |                |
xel_tracker   | text         | YES  |     | NULL    |                |
xel_tracker2  | text         | YES  |     | NULL    |                |
ft_note       | text         | YES  |     | NULL    |                |
--------------+--------------+------+-----+---------+----------------+

Structure of econundrums_new table

-----------------+--------------+------+-----+---------+----------------+
eld              | Type         | Null | Key | Default | Extra          |
-----------------+--------------+------+-----+---------+----------------+
                 | int(11)      | NO   | PRI | NULL    | auto_increment |
d_date           | date         | YES  |     | NULL    |                |
nundrum_hed      | varchar(255) | YES  |     | NULL    |                |
nundrum_url      | text         | YES  |     | NULL    |                |
nundrum_dek      | text         | YES  |     | NULL    |                |
virohealth1_hed  | varchar(255) | YES  |     | NULL    |                |
virohealth1_url  | text         | YES  |     | NULL    |                |
virohealth2_hed  | varchar(255) | YES  |     | NULL    |                |
virohealth2_url  | text         | YES  |     | NULL    |                |
virohealth3_hed  | varchar(255) | YES  |     | NULL    |                |
virohealth3_url  | text         | YES  |     | NULL    |                |
virohealth4_hed  | varchar(255) | YES  |     | NULL    |                |
virohealth4_url  | text         | YES  |     | NULL    |                |
virohealth5_hed  | varchar(255) | YES  |     | NULL    |                |
virohealth5_url  | text         | YES  |     | NULL    |                |
remojo_hed       | varchar(255) | YES  |     | NULL    |                |
remojo_url       | text         | YES  |     | NULL    |                |
remojo2_hed      | varchar(255) | YES  |     | NULL    |                |
remojo2_url      | text         | YES  |     | NULL    |                |
remojo3_hed      | varchar(255) | YES  |     | NULL    |                |
remojo3_url      | text         | YES  |     | NULL    |                |
remojo4_hed      | varchar(255) | YES  |     | NULL    |                |
remojo4_url      | text         | YES  |     | NULL    |                |
remojo5_hed      | varchar(255) | YES  |     | NULL    |                |
remojo5_url      | text         | YES  |     | NULL    |                |
_link_bill       | text         | YES  |     | NULL    |                |
_billboard       | text         | YES  |     | NULL    |                |
_link_banner     | text         | YES  |     | NULL    |                |
_banner          | text         | YES  |     | NULL    |                |
_name            | varchar(255) | YES  |     | NULL    |                |
bject_line       | varchar(255) | YES  |     | NULL    |                |
_name2           | varchar(255) | YES  |     | NULL    |                |
xt_ad_dek        | text         | YES  |     | NULL    |                |
nundrum_lead     | text         | YES  |     | NULL    |                |
is_week          | varchar(255) | YES  |     | NULL    |                |
virohealth_title | varchar(255) | YES  |     | NULL    |                |
remojo_title     | varchar(255) | YES  |     | NULL    |                |
b_url            | text         | YES  |     | NULL    |                |
b_image          | text         | YES  |     | NULL    |                |
b_text           | varchar(255) | YES  |     | NULL    |                |
b_code           | text         | YES  |     | NULL    |                |
ft_note          | text         | YES  |     | NULL    |                |
xel_tracker      | text         | YES  |     | NULL    |                |
xel_tracker2     | text         | YES  |     | NULL    |                |
-----------------+--------------+------+-----+---------+----------------+

Structure of food_for_thought_redesign table

-----------------+--------------+------+-----+---------+----------------+
eld              | Type         | Null | Key | Default | Extra          |
-----------------+--------------+------+-----+---------+----------------+
                 | int(11)      | NO   | PRI | NULL    | auto_increment |
d_date           | date         | YES  |     | NULL    |                |
t_main_hed       | varchar(255) | YES  |     | NULL    |                |
t_main_hed_url   | text         | YES  |     | NULL    |                |
t_main_img       | text         | YES  |     | NULL    |                |
t_main_img_url   | text         | YES  |     | NULL    |                |
t_article_1      | text         | YES  |     | NULL    |                |
t_a1_source      | varchar(255) | YES  |     | NULL    |                |
t_a1_ital        | tinyint(1)   | YES  |     | NULL    |                |
t_a1_url         | text         | YES  |     | NULL    |                |
t_article_2      | text         | YES  |     | NULL    |                |
t_a2_source      | varchar(255) | YES  |     | NULL    |                |
t_a2_ital        | tinyint(1)   | YES  |     | NULL    |                |
t_a2_url         | text         | YES  |     | NULL    |                |
t_article_3      | text         | YES  |     | NULL    |                |
t_a3_source      | varchar(255) | YES  |     | NULL    |                |
t_a3_ital        | tinyint(1)   | YES  |     | NULL    |                |
t_a3_url         | text         | YES  |     | NULL    |                |
t_article_4      | text         | YES  |     | NULL    |                |
t_a4_source      | varchar(255) | YES  |     | NULL    |                |
t_a4_ital        | tinyint(1)   | YES  |     | NULL    |                |
t_a4_url         | text         | YES  |     | NULL    |                |
t_article_5      | text         | YES  |     | NULL    |                |
t_a5_source      | varchar(255) | YES  |     | NULL    |                |
t_a5_ital        | tinyint(1)   | YES  |     | NULL    |                |
t_a5_url         | text         | YES  |     | NULL    |                |
t_article_6      | text         | YES  |     | NULL    |                |
t_a6_source      | varchar(255) | YES  |     | NULL    |                |
t_a6_ital        | tinyint(1)   | YES  |     | NULL    |                |
t_a6_url         | text         | YES  |     | NULL    |                |
ack_box          | varchar(255) | YES  |     | NULL    |                |
t_snack_box      | text         | YES  |     | NULL    |                |
t_sb_image       | text         | YES  |     | NULL    |                |
t_sb_attr        | varchar(255) | YES  |     | NULL    |                |
_our_ears        | varchar(255) | YES  |     | NULL    |                |
t_ioe_type       | int(11)      | YES  |     | NULL    |                |
t_ioe_item1      | text         | YES  |     | NULL    |                |
t_ioe1_source    | varchar(255) | YES  |     | NULL    |                |
t_ioe1_ital      | tinyint(1)   | YES  |     | NULL    |                |
t_ioe1_url       | text         | YES  |     | NULL    |                |
t_bite_add       | text         | YES  |     | NULL    |                |
t_bite_link      | text         | YES  |     | NULL    |                |
t_ioe_item2      | text         | YES  |     | NULL    |                |
t_ioe2_source    | varchar(255) | YES  |     | NULL    |                |
t_ioe2_ital      | tinyint(1)   | YES  |     | NULL    |                |
t_ioe2_url       | text         | YES  |     | NULL    |                |
t_ioe_item3      | text         | YES  |     | NULL    |                |
t_ioe3_source    | varchar(255) | YES  |     | NULL    |                |
t_ioe3_ital      | tinyint(1)   | YES  |     | NULL    |                |
t_ioe3_url       | text         | YES  |     | NULL    |                |
dden_kitchen     | varchar(255) | YES  |     | NULL    |                |
t_hk_leadin      | text         | YES  |     | NULL    |                |
t_hk_hed         | varchar(255) | YES  |     | NULL    |                |
t_hidden_kitchen | text         | YES  |     | NULL    |                |
bject_line       | varchar(255) | YES  |     | NULL    |                |
_name            | varchar(255) | YES  |     | NULL    |                |
_billboard       | text         | YES  |     | NULL    |                |
_link_bill       | text         | YES  |     | NULL    |                |
_name2           | varchar(255) | YES  |     | NULL    |                |
_link_banner     | text         | YES  |     | NULL    |                |
_banner          | text         | YES  |     | NULL    |                |
b_url            | text         | YES  |     | NULL    |                |
b_image          | text         | YES  |     | NULL    |                |
b_text           | text         | YES  |     | NULL    |                |
b_code           | text         | YES  |     | NULL    |                |
mbership_slot    | text         | YES  |     | NULL    |                |
ft_note          | text         | YES  |     | NULL    |                |
xel_tracker      | text         | YES  |     | NULL    |                |
xel_tracker2     | text         | YES  |     | NULL    |                |
-----------------+--------------+------+-----+---------+----------------+

Structure of in_the_mix_new

----------------+--------------+------+-----+---------+----------------+
eld             | Type         | Null | Key | Default | Extra          |
----------------+--------------+------+-----+---------+----------------+
                | int(11)      | NO   | PRI | NULL    | auto_increment |
d_date          | date         | YES  |     | NULL    |                |
mustread_hed    | varchar(255) | YES  |     | NULL    |                |
mustread_url    | text         | YES  |     | NULL    |                |
mustread_dek    | text         | YES  |     | NULL    |                |
mustread_title  | varchar(255) | YES  |     | NULL    |                |
refrommix1_hed  | varchar(255) | YES  |     | NULL    |                |
refrommix1_url  | text         | YES  |     | NULL    |                |
refrommix2_hed  | varchar(255) | YES  |     | NULL    |                |
refrommix2_url  | text         | YES  |     | NULL    |                |
refrommix3_hed  | varchar(255) | YES  |     | NULL    |                |
refrommix3_url  | text         | YES  |     | NULL    |                |
refrommix4_hed  | varchar(255) | YES  |     | NULL    |                |
refrommix4_url  | text         | YES  |     | NULL    |                |
refrommix5_hed  | varchar(255) | YES  |     | NULL    |                |
refrommix5_url  | text         | YES  |     | NULL    |                |
refrommix_title | varchar(255) | YES  |     | NULL    |                |
omarchive1_hed  | varchar(255) | YES  |     | NULL    |                |
omarchive1_url  | text         | YES  |     | NULL    |                |
omarchive2_hed  | varchar(255) | YES  |     | NULL    |                |
omarchive2_url  | text         | YES  |     | NULL    |                |
omarchive3_hed  | varchar(255) | YES  |     | NULL    |                |
omarchive3_url  | text         | YES  |     | NULL    |                |
omarchive4_hed  | varchar(255) | YES  |     | NULL    |                |
omarchive4_url  | text         | YES  |     | NULL    |                |
omarchive5_hed  | varchar(255) | YES  |     | NULL    |                |
omarchive5_url  | text         | YES  |     | NULL    |                |
omarchive_title | varchar(255) | YES  |     | NULL    |                |
_name           | varchar(255) | YES  |     | NULL    |                |
_link_bill      | text         | YES  |     | NULL    |                |
_billboard      | text         | YES  |     | NULL    |                |
_name2          | varchar(255) | YES  |     | NULL    |                |
_link_banner    | text         | YES  |     | NULL    |                |
_banner         | text         | YES  |     | NULL    |                |
xt_ad_dek       | text         | YES  |     | NULL    |                |
bject_line      | varchar(255) | YES  |     | NULL    |                |
b_url           | text         | YES  |     | NULL    |                |
b_image         | text         | YES  |     | NULL    |                |
b_text          | varchar(255) | YES  |     | NULL    |                |
mustread_lead   | text         | YES  |     | NULL    |                |
b_code          | text         | YES  |     | NULL    |                |
ft_note         | text         | YES  |     | NULL    |                |
xel_tracker     | text         | YES  |     | NULL    |                |
xel_tracker2    | text         | YES  |     | NULL    |                |
----------------+--------------+------+-----+---------+----------------+

Structure of political_mojo_new

----------------+--------------+------+-----+---------+----------------+
eld             | Type         | Null | Key | Default | Extra          |
----------------+--------------+------+-----+---------+----------------+
                | int(11)      | NO   | PRI | NULL    | auto_increment |
d_date          | date         | YES  |     | NULL    |                |
pstory_hed      | varchar(255) | YES  |     | NULL    |                |
pstory_url      | text         | YES  |     | NULL    |                |
pstory_dek      | text         | YES  |     | NULL    |                |
pstory_byline   | text         | YES  |     | NULL    |                |
pstory_title    | varchar(255) | YES  |     | NULL    |                |
othernews_hed   | varchar(255) | YES  |     | NULL    |                |
othernews_url   | text         | YES  |     | NULL    |                |
othernews2_hed  | varchar(255) | YES  |     | NULL    |                |
othernews2_url  | text         | YES  |     | NULL    |                |
othernews3_hed  | varchar(255) | YES  |     | NULL    |                |
othernews3_url  | text         | YES  |     | NULL    |                |
othernews4_hed  | varchar(255) | YES  |     | NULL    |                |
othernews4_url  | text         | YES  |     | NULL    |                |
othernews5_hed  | varchar(255) | YES  |     | NULL    |                |
othernews5_url  | text         | YES  |     | NULL    |                |
othernews_title | varchar(255) | YES  |     | NULL    |                |
stread1_hed     | varchar(255) | YES  |     | NULL    |                |
stread1_url     | text         | YES  |     | NULL    |                |
stread2_hed     | varchar(255) | YES  |     | NULL    |                |
stread2_url     | text         | YES  |     | NULL    |                |
stread3_hed     | varchar(255) | YES  |     | NULL    |                |
stread3_url     | text         | YES  |     | NULL    |                |
stread4_hed     | varchar(255) | YES  |     | NULL    |                |
stread4_url     | text         | YES  |     | NULL    |                |
stread5_hed     | varchar(255) | YES  |     | NULL    |                |
stread5_url     | text         | YES  |     | NULL    |                |
stread_title    | varchar(255) | YES  |     | NULL    |                |
_link_bill      | text         | YES  |     | NULL    |                |
_billboard      | text         | YES  |     | NULL    |                |
_link_banner    | text         | YES  |     | NULL    |                |
_banner         | text         | YES  |     | NULL    |                |
_name           | varchar(255) | YES  |     | NULL    |                |
_name2          | varchar(255) | YES  |     | NULL    |                |
xt_ad_dek       | text         | YES  |     | NULL    |                |
bject_line      | varchar(255) | YES  |     | NULL    |                |
b_url           | text         | YES  |     | NULL    |                |
b_image         | text         | YES  |     | NULL    |                |
b_text          | varchar(255) | YES  |     | NULL    |                |
pstory_lead     | text         | YES  |     | NULL    |                |
b_code          | text         | YES  |     | NULL    |                |
ft_note         | text         | YES  |     | NULL    |                |
xel_tracker     | text         | YES  |     | NULL    |                |
xel_tracker2    | text         | YES  |     | NULL    |                |
----------------+--------------+------+-----+---------+----------------+

Structure of trumpocracy (for The Russian Connection)

-----------------+--------------+------+-----+---------+----------------+
eld              | Type         | Null | Key | Default | Extra          |
-----------------+--------------+------+-----+---------+----------------+
                 | int(11)      | NO   | PRI | NULL    | auto_increment |
d_date           | date         | YES  |     | NULL    |                |
bject_line       | varchar(255) | YES  |     | NULL    |                |
ump_main_hed     | varchar(255) | YES  |     | NULL    |                |
um_main_url      | text         | YES  |     | NULL    |                |
um_main_dek      | text         | YES  |     | NULL    |                |
ump_main_img     | text         | YES  |     | NULL    |                |
ump_main_source  | varchar(255) | YES  |     | NULL    |                |
ump_main_ital    | tinyint(1)   | YES  |     | NULL    |                |
ump_main2_hed    | varchar(255) | YES  |     | NULL    |                |
ump_main2_url    | text         | YES  |     | NULL    |                |
ump_main2_img    | text         | YES  |     | NULL    |                |
ump_main2_dek    | text         | YES  |     | NULL    |                |
ump_main2_source | varchar(255) | YES  |     | NULL    |                |
ump_main2_ital   | varchar(255) | YES  |     | NULL    |                |
pnews_title      | varchar(255) | YES  |     | NULL    |                |
pnews1_dek       | text         | YES  |     | NULL    |                |
pnews1_source    | varchar(255) | YES  |     | NULL    |                |
pnews1_ital      | tinyint(1)   | YES  |     | NULL    |                |
pnews1_url       | text         | YES  |     | NULL    |                |
pnews2_dek       | text         | YES  |     | NULL    |                |
pnews2_source    | varchar(255) | YES  |     | NULL    |                |
pnews2_ital      | tinyint(1)   | YES  |     | NULL    |                |
pnews2_url       | text         | YES  |     | NULL    |                |
pnews3_dek       | text         | YES  |     | NULL    |                |
pnews3_source    | varchar(255) | YES  |     | NULL    |                |
pnews3_ital      | tinyint(1)   | YES  |     | NULL    |                |
pnews3_url       | text         | YES  |     | NULL    |                |
pnews4_dek       | text         | YES  |     | NULL    |                |
pnews4_source    | varchar(255) | YES  |     | NULL    |                |
pnews4_ital      | tinyint(1)   | YES  |     | NULL    |                |
pnews4_url       | text         | YES  |     | NULL    |                |
pnews5_dek       | text         | YES  |     | NULL    |                |
pnews5_source    | varchar(255) | YES  |     | NULL    |                |
pnews5_ital      | tinyint(1)   | YES  |     | NULL    |                |
pnews5_url       | text         | YES  |     | NULL    |                |
rs_title         | varchar(255) | YES  |     | NULL    |                |
rs1_dek          | text         | YES  |     | NULL    |                |
rs1_source       | varchar(255) | YES  |     | NULL    |                |
rs1_ital         | tinyint(1)   | YES  |     | NULL    |                |
rs1_url          | text         | YES  |     | NULL    |                |
rs2_dek          | text         | YES  |     | NULL    |                |
rs2_source       | varchar(255) | YES  |     | NULL    |                |
rs2_ital         | tinyint(1)   | YES  |     | NULL    |                |
rs2_url          | text         | YES  |     | NULL    |                |
rs3_dek          | text         | YES  |     | NULL    |                |
rs3_source       | varchar(255) | YES  |     | NULL    |                |
rs3_ital         | tinyint(1)   | YES  |     | NULL    |                |
rs3_url          | text         | YES  |     | NULL    |                |
rs4_dek          | text         | YES  |     | NULL    |                |
rs4_source       | varchar(255) | YES  |     | NULL    |                |
rs4_ital         | tinyint(1)   | YES  |     | NULL    |                |
rs4_url          | text         | YES  |     | NULL    |                |
_name            | varchar(255) | YES  |     | NULL    |                |
_billboard       | text         | YES  |     | NULL    |                |
_link_bill       | text         | YES  |     | NULL    |                |
_name2           | varchar(255) | YES  |     | NULL    |                |
_link_banner     | text         | YES  |     | NULL    |                |
_banner          | text         | YES  |     | NULL    |                |
b_url            | text         | YES  |     | NULL    |                |
b_image          | text         | YES  |     | NULL    |                |
b_text           | text         | YES  |     | NULL    |                |
b_code           | text         | YES  |     | NULL    |                |
mbership_slot    | text         | YES  |     | NULL    |                |
ft_note          | text         | YES  |     | NULL    |                |
xel_tracker      | text         | YES  |     | NULL    |                |
xel_tracker2     | text         | YES  |     | NULL    |                |
-----------------+--------------+------+-----+---------+----------------+