Not Reviewed
Show More
Add another comment
| @@ -62,7 +62,7 function savetranscript( &$strip ) { | |||
|
|
62 | 62 | $dbConnection->beginTransaction(); |
|
|
63 | 63 | |
|
|
64 | 64 | //remove any old transcript data - it's being replaced |
|
|
65 |
$dbConnection->executeUpdate('DELETE FROM transcript WHERE transcript.strip = ?', array($strip->id)) |
|
|
|
65 | $dbConnection->executeUpdate('DELETE FROM transcript WHERE transcript.strip = ?', array($strip->id)); | |
|
|
66 | 66 | |
|
|
67 | 67 | if( $strip->transcript_posted ) { |
|
|
68 | 68 | $inserter = 'INSERT INTO transcript (strip, panel, line, speaker, speech, search) VALUES (?, ?, ?, ?, ?, ?)'; |
| @@ -63,7 +63,7 adminmenu(); | |||
|
|
63 | 63 | <h2>Recent Strips</h2> |
|
|
64 | 64 | <ul class="historic"> |
|
|
65 | 65 | <?php |
|
|
66 |
$strips = $dbConnection->fetchAll('SELECT |
|
|
|
66 | $strips = $dbConnection->fetchAll('SELECT id, title, UNIX_TIMESTAMP(published) as date FROM strip WHERE published <= NOW() order by id DESC LIMIT 5'); | |
|
|
67 | 67 | |
|
|
68 | 68 | foreach($strips as $k=>$v) { |
|
|
69 | 69 | printf( '<li>%d: <a href="%s/index.php?strip_id=%d">%s</a>, %s ago</li>', $v->id, SITE_HOST . SITE_PATH, $v->id, htmlspecialchars($v->title), human_time_diff($v->date) ); |
| @@ -74,7 +74,7 foreach($strips as $k=>$v) { | |||
|
|
74 | 74 | <h2>Upcoming Strips</h2> |
|
|
75 | 75 | <ul class="historic"> |
|
|
76 | 76 | <?php |
|
|
77 |
$strips = $dbConnection->fetchAll('SELECT |
|
|
|
77 | $strips = $dbConnection->fetchAll('SELECT id, title, UNIX_TIMESTAMP(published) as date FROM strip WHERE published > NOW() order by id ASC LIMIT 5'); | |
|
|
78 | 78 | |
|
|
79 | 79 | foreach($strips as $k=>$v) { |
|
|
80 | 80 | printf( '<li>%d: <a href="%s/edit-comic.php?strip_id=%d">%s</a>, in %s</li>', $v->id, SITE_HOST . SITE_PATH . '/' . SITE_ADMIN, $v->id, htmlspecialchars($v->title), human_time_diff($v->date) ); |
| @@ -85,7 +85,7 foreach($strips as $k=>$v) { | |||
|
|
85 | 85 | <h2>Recent Published Rants</h2> |
|
|
86 | 86 | <ul class="historic"> |
|
|
87 | 87 | <?php |
|
|
88 |
$rants = $dbConnection->fetchAll('SELECT |
|
|
|
88 | $rants = $dbConnection->fetchAll('SELECT rant.id,UNIX_TIMESTAMP(rant.published) as date,rant.title,contributor.name from rant,contributor where rant.author=contributor.id AND rant.status=\'published\' ORDER BY rant.published DESC limit 5'); | |
|
|
89 | 89 | |
|
|
90 | 90 | foreach($rants as $k=>$v) { |
|
|
91 | 91 | printf( '<li>%d: <a href="%s/index.php?rant_id=%d">%s</a> by %s, %s ago</li>', $v->id, SITE_HOST . SITE_PATH, $v->id, htmlspecialchars($v->title), htmlspecialchars($v->name), human_time_diff($v->date) ); |
| @@ -96,7 +96,7 foreach($rants as $k=>$v) { | |||
|
|
96 | 96 | <h2>Recent Draft Rants</h2> |
|
|
97 | 97 | <ul class="historic"> |
|
|
98 | 98 | <?php |
|
|
99 |
$rants = $dbConnection->fetchAll('SELECT |
|
|
|
99 | $rants = $dbConnection->fetchAll('SELECT rant.id,UNIX_TIMESTAMP(rant.published) as date,rant.title,contributor.name from rant,contributor where rant.author=contributor.id AND rant.status=\'draft\' ORDER BY rant.published DESC limit 5'); | |
|
|
100 | 100 | |
|
|
101 | 101 | foreach($rants as $k=>$v) { |
|
|
102 | 102 | printf( '<li>%d: <a href="%s/edit-rant.php?rant_id=%d">%s</a> by %s, %s ago</li>', $v->id, SITE_HOST . ADMIN_PATH, $v->id, htmlspecialchars($v->title), htmlspecialchars($v->name), human_time_diff($v->date) ); |
| @@ -47,7 +47,7 switch( $_REQUEST['action'] ) { | |||
|
|
47 | 47 | <title>Megatokyo Admin › Login</title> |
|
|
48 | 48 | <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> |
|
|
49 | 49 | <meta name="generator" content="Alan J Castonguay, Robert Sherby, Jeremy Wagner-Kaiser, Shawn Morford (!! nathanbp, jrl !!)" /> |
|
|
50 | <link rel="stylesheet" href="wp-admin.css" type="text/css" /> | |
|
|
50 | <link rel="stylesheet" href="styles/wp-admin.css" type="text/css" /> | |
|
|
51 | 51 | <!--[if IE]><style type="text/css">#login h1 a { margin-top: 35px; } #login ul { padding-bottom: 65px; }</style><![endif]--><!-- Curse you, IE! --> |
|
|
52 | 52 | <script type="text/javascript"> |
|
|
53 | 53 | function focusit() { |
| @@ -7,7 +7,7 auth_redirect(); // Require logged in user to access this page. | |||
|
|
7 | 7 | if( isset($_POST['action']) && $_POST['action'] == 'new' ) { |
|
|
8 | 8 | check_nonce('new-twitter-user'); |
|
|
9 | 9 | |
|
|
10 | if(! $dbConnection->executeUpdate('INSERT INTO twitter_user (username) VALUES (?)', array(md5( microtime() ) )) { | |
|
|
10 | if(! $dbConnection->executeUpdate('INSERT INTO twitter_user (username) VALUES (?)', array(md5( microtime() ) ))) { | |
|
|
11 | 11 | adminlog("Error on insertion of new twitter user.", MTS_TWITTER, MTA_INSERT, E_WARNING); |
|
|
12 | 12 | mtdie("Error on insertion of new twitter user: ". $dbConnection->errorCode(), 'SQL Error'); |
|
|
13 | 13 | } else { |
| @@ -337,7 +337,7 form#upload #post_content { | |||
|
|
337 | 337 | } |
|
|
338 | 338 | |
|
|
339 | 339 | .submit input, .submit input:focus, .button, .button:focus { |
|
|
340 | background: url( images/fade-butt.png ); | |
|
|
340 | background: url( ../images/fade-butt.png ); | |
|
|
341 | 341 | border: 3px double $button-down-border; |
|
|
342 | 342 | border-left-color: $button-normal-border; |
|
|
343 | 343 | border-top-color: $button-normal-border; |
| @@ -408,7 +408,7 form#upload #post_content { | |||
|
|
408 | 408 | } |
|
|
409 | 409 | |
|
|
410 | 410 | .updated, .confirm { |
|
|
411 | background: #CFEBF7 url(images/notice.gif) no-repeat 1em; | |
|
|
411 | background: #CFEBF7 url(../images/notice.gif) no-repeat 1em; | |
|
|
412 | 412 | border: 1px solid #2580B2; |
|
|
413 | 413 | margin: 1em 5% 10px; |
|
|
414 | 414 | padding: 0 1em 0 3em; |
| @@ -604,7 +604,7 input.delete:hover { | |||
|
|
604 | 604 | } |
|
|
605 | 605 | |
|
|
606 | 606 | #ed_toolbar input { |
|
|
607 | background: #fff url( images/fade-butt.png ) repeat-x 0px -2px; | |
|
|
607 | background: #fff url( ../images/fade-butt.png ) repeat-x 0px -2px; | |
|
|
608 | 608 | margin: 3px 2px 2px; |
|
|
609 | 609 | } |
|
|
610 | 610 | |
| @@ -680,7 +680,7 input.delete:hover { | |||
|
|
680 | 680 | |
|
|
681 | 681 | #login { |
|
|
682 | 682 | position: relative; |
|
|
683 | background: url('images/login-bkg-tile.gif') no-repeat top center; | |
|
|
683 | background: url('../images/login-bkg-tile.gif') no-repeat top center; | |
|
|
684 | 684 | color: #fff; |
|
|
685 | 685 | margin: 5em auto 1em; |
|
|
686 | 686 | padding: 20px 0 0; |
| @@ -688,7 +688,7 input.delete:hover { | |||
|
|
688 | 688 | } |
|
|
689 | 689 | |
|
|
690 | 690 | #login form { |
|
|
691 | background: url('images/login-bkg-bottom.gif') no-repeat bottom center; | |
|
|
691 | background: url('../images/login-bkg-bottom.gif') no-repeat bottom center; | |
|
|
692 | 692 | padding: 0 50px 25px; |
|
|
693 | 693 | } |
|
|
694 | 694 | |
| @@ -1120,13 +1120,13 overall, dbx-box is best left as visually unstyled as possible | |||
|
|
1120 | 1120 | } |
|
|
1121 | 1121 | |
|
|
1122 | 1122 | #moremeta .dbx-content { |
|
|
1123 | background: url(images/box-butt.gif) no-repeat bottom right; | |
|
|
1123 | background: url(../images/box-butt.gif) no-repeat bottom right; | |
|
|
1124 | 1124 | padding-bottom: 10px; |
|
|
1125 | 1125 | padding-right: 2px; |
|
|
1126 | 1126 | } |
|
|
1127 | 1127 | |
|
|
1128 | 1128 | #moremeta fieldset.dbx-box-closed { |
|
|
1129 | background: url(images/box-butt.gif) no-repeat bottom; | |
|
|
1129 | background: url(../images/box-butt.gif) no-repeat bottom; | |
|
|
1130 | 1130 | padding-bottom: 9px; |
|
|
1131 | 1131 | } |
|
|
1132 | 1132 | |
| @@ -1143,11 +1143,11 overall, dbx-box is best left as visually unstyled as possible | |||
|
|
1143 | 1143 | #moremeta .dbx-handle { |
|
|
1144 | 1144 | padding: 6px 1em 2px; |
|
|
1145 | 1145 | font-size: 12px; |
|
|
1146 | background: #2685af url(images/box-head.gif) no-repeat right; | |
|
|
1146 | background: #2685af url(../images/box-head.gif) no-repeat right; | |
|
|
1147 | 1147 | } |
|
|
1148 | 1148 | |
|
|
1149 | 1149 | #moremeta .dbx-box { |
|
|
1150 | background: url(images/box-bg.gif) repeat-y right; | |
|
|
1150 | background: url(../images/box-bg.gif) repeat-y right; | |
|
|
1151 | 1151 | } |
|
|
1152 | 1152 | |
|
|
1153 | 1153 | #advancedstuff h3.dbx-handle { |
| @@ -1156,17 +1156,17 overall, dbx-box is best left as visually unstyled as possible | |||
|
|
1156 | 1156 | padding: 6px 1em 0 3px; |
|
|
1157 | 1157 | height: 19px; |
|
|
1158 | 1158 | font-size: 12px; |
|
|
1159 | background: #2685af url(images/box-head-right.gif) no-repeat top right; | |
|
|
1159 | background: #2685af url(../images/box-head-right.gif) no-repeat top right; | |
|
|
1160 | 1160 | } |
|
|
1161 | 1161 | |
|
|
1162 | 1162 | #advancedstuff div.dbx-handle-wrapper { |
|
|
1163 | 1163 | margin: 0 0 0 -7px; |
|
|
1164 | background: #fff url(images/box-head-left.gif) no-repeat top left; | |
|
|
1164 | background: #fff url(../images/box-head-left.gif) no-repeat top left; | |
|
|
1165 | 1165 | } |
|
|
1166 | 1166 | |
|
|
1167 | 1167 | #advancedstuff div.dbx-content { |
|
|
1168 | 1168 | margin-left: 8px; |
|
|
1169 | background: url(images/box-bg-right.gif) repeat-y right; | |
|
|
1169 | background: url(../images/box-bg-right.gif) repeat-y right; | |
|
|
1170 | 1170 | padding: 10px 10px 15px 0px; |
|
|
1171 | 1171 | } |
|
|
1172 | 1172 | |
| @@ -1178,26 +1178,26 overall, dbx-box is best left as visually unstyled as possible | |||
|
|
1178 | 1178 | #advancedstuff div.dbx-content-wrapper { |
|
|
1179 | 1179 | margin-left: -7px; |
|
|
1180 | 1180 | margin-right: 0; |
|
|
1181 | background: url(images/box-bg-left.gif) repeat-y left; | |
|
|
1181 | background: url(../images/box-bg-left.gif) repeat-y left; | |
|
|
1182 | 1182 | } |
|
|
1183 | 1183 | |
|
|
1184 | 1184 | #advancedstuff fieldset.dbx-box { |
|
|
1185 | 1185 | padding-bottom: 9px; |
|
|
1186 | 1186 | margin-left: 6px; |
|
|
1187 | background: url(images/box-butt-right.gif) no-repeat bottom right; | |
|
|
1187 | background: url(../images/box-butt-right.gif) no-repeat bottom right; | |
|
|
1188 | 1188 | } |
|
|
1189 | 1189 | |
|
|
1190 | 1190 | #advancedstuff div.dbx-box-wrapper { |
|
|
1191 | background: url(images/box-butt-left.gif) no-repeat bottom left; | |
|
|
1191 | background: url(../images/box-butt-left.gif) no-repeat bottom left; | |
|
|
1192 | 1192 | } |
|
|
1193 | 1193 | |
|
|
1194 | 1194 | #advancedstuff .dbx-box-closed div.dbx-content-wrapper { |
|
|
1195 | 1195 | padding-bottom: 2px; |
|
|
1196 | background: url(images/box-butt-left.gif) no-repeat bottom left; | |
|
|
1196 | background: url(../images/box-butt-left.gif) no-repeat bottom left; | |
|
|
1197 | 1197 | } |
|
|
1198 | 1198 | |
|
|
1199 | 1199 | #advancedstuff .dbx-box { |
|
|
1200 | background: url(images/box-butt-right.gif) no-repeat bottom right; | |
|
|
1200 | background: url(../images/box-butt-right.gif) no-repeat bottom right; | |
|
|
1201 | 1201 | } |
|
|
1202 | 1202 | |
|
|
1203 | 1203 | |
| @@ -1210,7 +1210,7 overall, dbx-box is best left as visually unstyled as possible | |||
|
|
1210 | 1210 | a.dbx-toggle, a.dbx-toggle:visited { |
|
|
1211 | 1211 | display:block; |
|
|
1212 | 1212 | overflow: hidden; |
|
|
1213 | background-image: url( images/toggle.gif ); | |
|
|
1213 | background-image: url( ../images/toggle.gif ); | |
|
|
1214 | 1214 | position: absolute; |
|
|
1215 | 1215 | top: 0px; |
|
|
1216 | 1216 | right: 0px; |
| @@ -1315,7 +1315,7 input #catadd { | |||
|
|
1315 | 1315 | } |
|
|
1316 | 1316 | |
|
|
1317 | 1317 | #edButtons input.edButtonBack, #edButtons input.edButtonBack:active { |
|
|
1318 | background: #fff url( images/fade-butt.png ) repeat-x 0px 15px; | |
|
|
1318 | background: #fff url( ../images/fade-butt.png ) repeat-x 0px 15px; | |
|
|
1319 | 1319 | border-bottom: 1px solid #ccc; |
|
|
1320 | 1320 | } |
|
|
1321 | 1321 | |
Comments 0
You need to be logged in to leave comments.
Login now