$date = getval("date", date("Y-m-d H:i:s"));
$title = getvalescaped("title", 0);
$body = getvalescaped("body", 0);
# get ref value from database, unless it is set to new
if (getval("ref", "") == "new") {
$createnews = true;
} else {
$news = get_news($ref, "", "");
$createnews = false;
}
if (getval("save", "") != "") {
# Save news
if ($createnews) {
add_news($date, $title, $body);
} else {
update_news($ref, $date, $title, $body);
}
redirect("plugins/news/pages/news_edit.php?findtext=" . $findtext . "&offset=" . $offset);
}
# Fetch news data
$news = get_news($ref, "", "");
include dirname(__FILE__) . "/../../../include/header.php";
?>
<p><a href="news_edit.php?offset=<?php
echo $offset;
?>
&findtext=<?php
echo $findtext;
?>
">< <?php
$px = @GetImageSize($_FILES['fb']['tmp_name']);
if ($px[0] == 470 && $px[1] == 247) {
$rand = rand(100, 99999);
$name = time() . '_' . $rand;
$fb_sql = date('Y-m') . '/' . $name . '.jpg';
$imgdir = '../img/uploads/news/fb/' . $fb_sql;
move_uploaded_file($_FILES['fb']['tmp_name'], $imgdir);
} else {
$error[0] = "Facebook ფოტოს ზომა: 470x247";
}
}
}
}
if (empty($error[0])) {
if ($_POST['update'] == 1) {
if (update_news(['user' => $user_id, 'cat' => $cat, 'title' => $title, 'title_short' => $title_short, 'youtube' => $youtube, 'chpu' => $chpu, 'meta_desc' => $meta_desc, 'meta_key' => $meta_key, 'color' => $color, 'info' => $info, 'test' => $victorina, 'date' => $date, 'time' => $tm, 'style' => $style, 'text_short' => $text_short, 'text' => $text, 'phg' => $phg, 'sponsored' => $sponsored, 'copy' => $copy, 'slide' => $slide, 'slide_type' => $slide_type, 'thumbs' => $totalpath, 'img' => $read_sql, 'fb' => $fb_sql], $id)) {
$response['photop'] = !empty($totalpath) ? $totalpath : '';
$response['desimg'] = !empty($read_sql) ? $read_sql : '';
$response['facebook'] = !empty($fb_sql) ? $fb_sql : '';
$response['slide'] = json_encode(unserialize(base64_decode($slide)));
$response['body'] = stripslashes($text);
echo json_encode($response);
}
}
if ($_POST['add'] == 1) {
if (!empty($title) && !empty($cat)) {
$test_chpu = $DB->getOne("SELECT count(#__news.id) FROM `#__news` WHERE `chpu`='{$chpu}'");
if ($test_chpu > 0) {
$chpu = rand(100, 9999) . '_' . $chpu;
}
$result = add_news(['user' => $user_id, 'cat' => $cat, 'title' => $title, 'chpu' => $chpu, 'title_short' => $title_short, 'youtube' => $youtube, 'info' => $info, 'date' => $date, 'time' => $tm, 'slide' => $slide, 'slide_type' => $slide_type, 'text_short' => $text_short, 'text' => $text, 'phg' => $phg, 'sponsored' => $sponsored, 'copy' => $copy, 'moderate' => 2]);
$app->get('/noticia/nova', $authenticate($app), function () use($app) {
$app->render('noticia_nova.php', array('pageTitle' => _('Adicionar') . ' ' . get_setting('noticia_singular')));
});
// Guardar noticia
$app->post('/noticia/nova', $authenticate($app), function () use($app) {
$news = $app->request()->post('news');
save_news($news);
$app->redirect('/backoffice/noticias');
});
$app->get('/noticia/editar/:id', $authenticate($app), function ($id) use($app) {
$news = get_news_id($id);
$app->render('noticia_editar.php', array('news' => $news, 'pageTitle' => _('Editar') . ' ' . get_setting('noticia_singular')));
});
$app->post('/noticia/editar', $authenticate($app), function () use($app) {
$news = $app->request()->post('news');
update_news($news);
$app->redirect('/backoffice/noticias');
});
$app->get('/eventos', $authenticate($app), function () use($app) {
$events = get_events();
$app->render('eventos.php', array('events' => $events, 'pageTitle' => get_setting('evento_singular')));
});
//Obtem uma lista de todos os eventos
$app->get('/evento/novo', $authenticate($app), function () use($app) {
$app->render('evento_novo.php', array('pageTitle' => _('Adicionar') . ' ' . get_setting('evento_singular')));
});
$app->post('/evento/novo', $authenticate($app), function () use($app) {
$values = $app->request()->post('event');
save_event($values);
$app->redirect('/backoffice/eventos');
});
}
// ban entries
function import_bans()
{
global $site;
global $connection;
$query = 'SELECT `id`, `raw_announcement` from `bans`';
if (!($result = @$site->execute_query($db_to_be_imported, 'bans', $query, $connection))) {
// query was bad, error message was already given in $site->execute_query(...)
$site->dieAndEndPage('');
}
while ($row = mysql_fetch_array($result)) {
// skip empty entries
if (!(strcmp($row['raw_announcement'], '') === 0)) {
$query = 'UPDATE `bans` SET `announcement`=' . sqlSafeStringQuotes($site->bbcode($row['raw_announcement'])) . ' WHERE `id`=' . sqlSafeStringQuotes($row['id']) . ' LIMIT 1';
// execute query, ignore result
@$site->execute_query('news', $query, $connection);
}
}
}
// now convert the entries using the available functions
update_players();
update_teams();
update_news();
update_bans();
// done
?>
<p>Updating all database entries involving BBCode finished!</p>
</div>
</body>
</html>
<?php
set_time_limit(0);
require_once '../includes/init.php';
//get_news('http://www.51766.com/xinwen/11019/1101981792.html', 616);
$news = $db->get_all("SELECT * FROM {$prefix}article WHERE article_id > 20607");
foreach ($news as $index => $new) {
update_news($new['from_url'], $new['article_id']);
if (0 !== $index && 0 === $index % 10) {
flush();
}
}
function update_news($url, $article_id)
{
global $db, $prefix;
$news = array();
$html = @file_get_contents($url);
$news['pub_date'] = get_content($html, ' ', '.0');
$news['content'] = get_tag_contents($html, 'div', '<div id="fontZoom">');
$db->update($prefix . 'article', $news, array('article_id' => $article_id));
//print_r($news);
echo $url . ' 入库完毕<br />';
//die();
}
//echo get_tag_contents($html, 'div', '<div class="block12">');
function get_tag_contents($html, $tag, $start_str, $tag_pos = 0, $length = 0)
{
if (!empty($start_str)) {
$html = end(explode($start_str, $html));
}
$tag_pos = stripos($html, '<' . $tag, $tag_pos);
