function setUp()
{
parent::setUp();
require_code('news');
$this->news_id = add_news($title = 'Today', $news = "hiiiiiiiiiii", $author = 'rolly', $validated = 1, $allow_rating = 1, $allow_comments = 1, $allow_trackbacks = 1, $notes = '', $news_article = 'test article', $main_news_category = 5, $news_category = NULL, $time = '1262671781', $submitter = NULL, $views = 0, $edit_date = NULL, $id = NULL, $image = '');
// Test the forum was actually created
$this->assertTrue('Today' == get_translated_text($GLOBALS['SITE_DB']->query_value('news', 'title ', array('id' => $this->news_id))));
}
function get_news_section($full = false)
{
$test = file_get_html('tmpResult.html');
$results = $test->find('tr[class=watch_title]');
$continue = false || $full;
if (count($results) == 0) {
$continue = false;
}
foreach ($results as $res) {
$tmp = analyse_news($res);
if ($tmp == NULL) {
continue;
}
if (is_new_news($tmp) == true) {
create_news_details_file($tmp);
add_news($tmp);
$continue = true;
}
}
return $continue;
}
/**
* The actualiser to import wordpress blog
*
* @return tempcode The UI
*/
function _import_wordpress()
{
check_specific_permission('mass_import', NULL, NULL, 'cms_news');
$title = get_page_title('IMPORT_WP_DB');
require_code('rss');
require_code('news');
require_code('news2');
$GLOBALS['LAX_COMCODE'] = true;
require_code('uploads');
is_swf_upload(true);
$is_validated = post_param_integer('wp_auto_validate', 0);
$to_own_account = post_param_integer('wp_add_to_own', 0);
//Wordpress post xml file importing method
if (get_param('method') == 'xml') {
$rss_url = post_param('xml_url', NULL);
if (array_key_exists('file_novalidate', $_FILES)) {
if (is_swf_upload(true) && array_key_exists('file_novalidate', $_FILES) || array_key_exists('file_novalidate', $_FILES) && is_uploaded_file($_FILES['file_novalidate']['tmp_name'])) {
$rss_url = $_FILES['file_novalidate']['tmp_name'];
} else {
warn_exit(do_lang_tempcode('IMPROPERLY_FILLED_IN'));
}
} else {
warn_exit(do_lang_tempcode('IMPROPERLY_FILLED_IN'));
}
$rss = new rss($rss_url, true);
if (!is_null($rss->error)) {
warn_exit($rss->error);
}
$cat_id = NULL;
$NEWS_CATS = $GLOBALS['SITE_DB']->query_select('news_categories', array('*'), array('nc_owner' => NULL));
$NEWS_CATS = list_to_map('id', $NEWS_CATS);
$extra_post_data = array();
foreach ($rss->gleamed_items as $item) {
if (!array_key_exists('category', $item)) {
$item['category'] = do_lang('NC_general');
}
$extra_post_data[] = $item;
foreach ($NEWS_CATS as $_cat => $news_cat) {
if (get_translated_text($news_cat['nc_title']) == $item['category']) {
$cat_id = $_cat;
}
}
//Check for existing owner categories, if not create blog category for creator
if ($to_own_account == 0) {
$creator = $item['author'];
$submitter_id = $GLOBALS['FORUM_DRIVER']->get_member_from_username($creator);
} else {
$submitter_id = get_member();
}
//if(is_null($submitter_id)) continue; //Skip importing posts of nonexisting users
$owner_category_id = $GLOBALS['SITE_DB']->query_value_null_ok('news_categories', 'id', array('nc_owner' => $submitter_id));
if (is_null($cat_id)) {
$cat_id = add_news_category($item['category'], 'newscats/general', '', NULL);
$NEWS_CATS = $GLOBALS['SITE_DB']->query_select('news_categories', array('*'), array('nc_owner' => NULL));
$NEWS_CATS = list_to_map('id', $NEWS_CATS);
}
// Add news
add_news($item['title'], html_to_comcode($item['news']), NULL, $is_validated, 1, 1, 1, '', array_key_exists('news_article', $item) ? html_to_comcode($item['news_article']) : '', $owner_category_id, array($cat_id), NULL, $submitter_id, 0, time(), NULL, '');
}
if (url_is_local($rss_url)) {
// Means it is a temp file
@unlink($rss_url);
}
} elseif (get_param('method') == 'db') {
import_wordpress_db();
}
breadcrumb_set_parents(array(array('_SELF:_SELF:misc', do_lang_tempcode('MANAGE_BLOGS')), array('_SELF:_SELF:import_wordpress', do_lang_tempcode('IMPORT_WORDPRESS'))));
breadcrumb_set_self(do_lang_tempcode('DONE'));
return inform_screen($title, do_lang_tempcode('IMPORT_WORDPRESS_DONE'));
}
/*
END PRIMARY DEFENDER CALCS
--------------------------
*/
while ($defend[$i]["id"] > 0) {
$l_infinitys = round(round($d_infinitys2 - $d_infinitys) * $defend[$i]["p_infinitys"]);
$l_wraiths = round(round($d_wraiths2 - $d_wraiths) * $defend[$i]["p_wraiths"]);
$l_warfrigs = round(round($d_warfrigs2 - $d_warfrigs) * $defend[$i]["p_warfrigs"]);
$l_destroyers = round(round($d_destroyers2 - $d_destroyers) * $defend[$i]["p_destroyers"]);
$l_astropods = round(round($d_astropods2 - $d_astropods) * $defend[$i]["p_astropods"]);
# if ($attack[$i]["astropods"]-$l_astropods-$roidscapped<0) $l_astropods = 0; else $l_astropods = $l_astropods+$roidscapped;
$l_scorpions = round(round($d_scorpions2 - $d_scorpions) * $defend[$i]["p_scorpions"]);
$l_cobras = round(round($d_cobras2 - $d_cobras) * $defend[$i]["p_cobras"]);
$salvm = round($salvagem * $defend[$i]["p_sum"]);
$salvc = round($salvagec * $defend[$i]["p_sum"]);
add_news("Combat report", "<table border=\"1\" bordercolor=\"black\"><td>Defender(s) ({$nick} #{$id}):</td><td>Total:</td><td>Lost:</td><tr>\n\n<td>Infinitys:</td><td>{$d_infinitys2}</td><td>" . number_format($d_infinitys2 - $d_infinitys, 0) . "<tr>\n\n<td>Wraiths:</td><td>{$d_wraiths2}</td><td>" . number_format($d_wraiths2 - $d_wraiths, 0) . "<tr>\n\n<td>Warfrigs:</td><td>{$d_warfrigs2}</td><td>" . number_format($d_warfrigs2 - $d_warfrigs, 0) . "<tr>\n\n<td>Destroyer:</td><td>{$d_destroyers2}</td><td>" . number_format($d_destroyers2 - $d_destroyers, 0) . "<tr>\n\n<td>Cobras:</td><td>{$d_cobras2}</td><td>" . number_format($d_cobras2 - $d_cobras, 0) . "<tr>\n\n<td>Astropods:</td><td>{$d_astropods2}</td><td>" . number_format($d_astropods2 - $d_astropods, 0) . "<tr>\n\n<td>Scorpions:</td><td>{$d_scorpions2}</td><td>" . number_format($d_scorpions2 - $d_scorpions, 0) . "<tr>\n\n<td>Reaper cannons:</td><td>{$d_rcannons2}</td><td>" . number_format($d_rcannons2 - $d_rcannons, 0) . "<tr>\n\n<td>Avengers:</td><td>{$d_avengers2}</td><td>" . number_format($d_avengers2 - $d_avengers, 0) . "<tr>\n\n<td>Lucius stalkers:</td><td>{$d_lstalkers2}</td><td>" . number_format($d_lstalkers2 - $d_lstalkers, 0) . "<tr>\n\n<td>Attacker(s):</td><tr>\n\n<td>Infinitys:</td><td>{$infinitys2}</td><td>" . number_format($infinitys2 - $infinitys, 0) . "<tr>\n\n<td>Wraiths:</td><td>{$wraiths2}</td><td>" . number_format($wraiths2 - $wraiths, 0) . "<tr>\n\n<td>Warfrigs:</td><td>{$warfrigs2}</td><td>" . number_format($warfrigs2 - $warfrigs, 0) . "<tr>\n\n<td>Destroyers:</td><td>{$destroyers2}</td><td>" . number_format($destroyers2 - $destroyers, 0) . "<tr>\n\n<td>Astropods:</td><td>{$astropods2} ({$t_block} blocked)</td><td>" . number_format($astropods2 - $astropods, 0) . "<tr>\n\n<td>Scorpions:</td><td>{$scorpions2}</td><td>" . number_format($scorpions2 - $scorpions, 0) . "<tr>\n\n<td>Yours:</td><tr>\n\n<td>Infinitys:</td><td>" . $defend[$i]["infinitys"] . "</td><td>{$l_infinitys}<tr>\n\n<td>Wraiths:</td><td>" . $defend[$i]["wraiths"] . "</td><td>{$l_wraiths}<tr>\n\n<td>Warfrigs:</td><td>" . $defend[$i]["warfrigs"] . "</td><td>{$l_warfrigs}<tr>\n\n<td>Destroyers:</td><td>" . $defend[$i]["destroyers"] . "</td><td>{$l_destroyers}<tr>\n\n<td>Cobras:</td><td>" . $defend[$i]["cobras"] . "</td><td>{$l_cobras}<tr>\n\n<td>Astropods:</td><td>" . $defend[$i]["astropods"] . "</td><td>{$l_astropods}<tr>\n\n<td>Scorpions:</td><td>" . $defend[$i]["scorpions"] . "</td><td>{$l_scorpions}<tr>\n\n<tr>\n<td>Metal salvage:</td><td>{$salvm}</td><tr>\n<td>Crystal salvage:</td><td>{$salvc}</td><tr>\n</table>\n\n", $defend[$i]["id"]);
$result3 = mysql_query("UPDATE " . $PA["table"] . " SET infinitys=infinitys-{$l_infinitys},wraiths=wraiths-{$l_wraiths},warfrigs=warfrigs-{$l_warfrigs},destroyers=destroyers-{$l_destroyers},astropods=astropods-{$l_astropods},scorpions=scorpions-{$l_scorpions},cobras=cobras-{$l_cobras},crystal=crystal+{$salvc},metal=metal+{$salvm} WHERE id=" . $defend[$i]["id"], $db);
dbr(mysql_error());
$i++;
}
}
$result2 = mysql_query("UPDATE " . $PA["table"] . " SET size='{$roids}',rank={$rank} WHERE id={$id}", $db);
dbr(mysql_error());
$rank++;
}
$result3 = mysql_query("UPDATE " . $PA["table"] . " SET score=(crystal+metal)/200+size*1500+infinitys*200+wraiths*2000+warfrigs*3000+astropods*1600+cobras*3000+destroyers*5000+scorpions*7000+rcannons*800+avengers*1400+lstalkers*6000");
?>
Tick done!
<?php
if ($os == "windows") {
echo "<meta HTTP-EQUIV=\"Refresh\" content=\"{$tickertime}\">";
}
//проверяем чтоб общее кол-во страниц не было < 1, еслипользователь введет несуществующую категорию.
//минимум 1 страница должна быть
if ($page > $pages_count) {
$page = $pages_count;
}
//если пользователь в адресную строку введет число большее чем реальное кол-во страниц
$start_position = ($page - 1) * $perpage;
//начальная позиция вывода товара (для запроса)
$all_news = get_all_news($start_position, $perpage);
break;
case 'add_news':
//добавление новости
if ($_POST) {
//проверяем были ли переданы данные из формы
if (add_news()) {
redirect('?view=news');
} else {
redirect();
}
//иначе редирект на эту же стр, откуда пришли
}
break;
case 'edit_news':
//редактирование новости
$news_id = (int) $_GET['news_id'];
$get_news = get_news($news_id);
if ($_POST) {
//проверяем были ли переданы данные из формы
if (edit_news($news_id)) {
redirect('?view=news');
function route($action)
{
global $html_main_content, $title;
show_err();
switch ($action) {
case '':
main();
break;
case 'user_show':
$title = print_lg('Show all users', $_SESSION['lang']);
user_show();
break;
case 'user_info':
$title = print_lg('User info', $_SESSION['lang']);
user_info();
break;
case 'show_news':
show_news();
break;
case 'logout':
logout();
break;
case 'add_news':
$title = print_lg('Add news', $_SESSION['lang']);
add_news();
break;
case 'registration':
$title = print_lg('Registration', $_SESSION['lang']);
registration();
break;
case 'delete_news':
delete_news();
break;
case 'edit_news':
$title = print_lg('Edit news', $_SESSION['lang']);
edit_news();
break;
case 'pages':
main();
break;
case 'profileview':
$title = print_lg('You information', $_SESSION['lang']);
profileview();
break;
case 'delete_user':
delete_user();
break;
case 'user_delete':
user_delete();
break;
case 'user_edit':
$title = print_lg('Edit user', $_SESSION['lang']);
user_edit();
break;
case 'edit_language':
$title = print_lg('Edit language', $_SESSION['lang']);
edit_language();
break;
case 'delete_comments':
delete_comments();
break;
case 'delete_vote':
delete_vote();
break;
default:
$html_main_content .= print_lg('Page not found', $_SESSION['lang']);
break;
}
}
function do_work()
{
$num_wanted = 100000;
require_code('config2');
set_option('post_history_days', '0');
// Needed for a little sanity in recent post retrieval
set_value('disable_sunk', '1');
// members (remember to test the username autocompleter, and birthdays)
// authors (remember to check author autocompleter and popup author list)
// lots of people getting notifications on a forum
// lots of people getting notifications on a topic
require_code('authors');
require_code('ocf_members_action');
require_code('notifications');
for ($i = $GLOBALS['FORUM_DB']->query_value('f_members', 'COUNT(*)'); $i < $num_wanted; $i++) {
$member_id = ocf_make_member(uniqid('', true), uniqid('', true), uniqid('', true) . '@example.com', array(), intval(date('d')), intval(date('m')), intval(date('Y')), array(), NULL, NULL, 1, NULL, NULL, '', NULL, '', 0, 0, 1, '', '', '', 1, 1, NULL, 1, 1, '', NULL, '', false);
add_author(random_line(), '', $member_id, random_text(), random_text());
enable_notifications('ocf_topic', 'forum:' . strval(db_get_first_id()), $member_id);
enable_notifications('ocf_topic', strval(db_get_first_id()), $member_id);
// number of friends to a single member
$GLOBALS['SITE_DB']->query_insert('chat_buddies', array('member_likes' => $member_id, 'member_liked' => db_get_first_id() + 1, 'date_and_time' => time()), false, true);
}
$member_id = db_get_first_id() + 2;
// point earn list / gift points to a single member
require_code('points2');
for ($j = $GLOBALS['SITE_DB']->query_value('gifts', 'COUNT(*)'); $j < $num_wanted; $j++) {
give_points(10, $member_id, mt_rand(db_get_first_id(), min(100, $num_wanted - 1)), random_line(), false, false);
}
// number of friends of a single member
for ($j = intval(floatval($GLOBALS['SITE_DB']->query_value('chat_buddies', 'COUNT(*)')) / 2.0); $j < $num_wanted; $j++) {
$GLOBALS['SITE_DB']->query_insert('chat_buddies', array('member_likes' => $member_id, 'member_liked' => $j + db_get_first_id(), 'date_and_time' => time()), false, true);
}
echo 'done member/authors/points/notifications/friends stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
// banners
require_code('banners2');
for ($i = $GLOBALS['SITE_DB']->query_value('banners', 'COUNT(*)'); $i < $num_wanted; $i++) {
add_banner(uniqid('', true), get_logo_url(), random_line(), random_text(), 100, get_base_url(), 3, '', db_get_first_id(), NULL, db_get_first_id() + 1, 1);
}
echo 'done banner stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
// comcode pages
require_code('files');
require_code('files2');
for ($i = $GLOBALS['SITE_DB']->query_value('comcode_pages', 'COUNT(*)'); $i < $num_wanted; $i++) {
$file = uniqid('', true);
/*$path=get_custom_file_base().'/site/pages/comcode_custom/'.fallback_lang().'/'.$file.'.txt';
$myfile=fopen($path,'wt');
fwrite($myfile,random_text());
fclose($myfile);
sync_file($path);
fix_permissions($path);*/
$GLOBALS['SITE_DB']->query_insert('comcode_pages', array('the_zone' => 'site', 'the_page' => $file, 'p_parent_page' => '', 'p_validated' => 1, 'p_edit_date' => NULL, 'p_add_date' => time(), 'p_submitter' => db_get_first_id(), 'p_show_as_edit' => 0));
}
echo 'done comcode stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
// zones
require_code('zones2');
require_code('abstract_file_manager');
for ($i = $GLOBALS['SITE_DB']->query_value('zones', 'COUNT(*)'); $i < min($num_wanted, 1000); $i++) {
actual_add_zone(uniqid('', true), random_line(), 'start', random_line(), 'default', 0, 0, 0);
}
echo 'done zone stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
// calendar events
require_code('calendar2');
for ($i = $GLOBALS['SITE_DB']->query_value('calendar_events', 'COUNT(*)'); $i < $num_wanted; $i++) {
add_calendar_event(db_get_first_id(), '', NULL, 0, random_line(), random_text(), 1, 1, intval(date('Y')), intval(date('m')), intval(date('d')), 0, 0);
}
echo 'done event stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
// chat rooms
require_code('chat2');
require_code('chat');
for ($i = $GLOBALS['SITE_DB']->query_value('chat_rooms', 'COUNT(*)'); $i < $num_wanted; $i++) {
$room_id = add_chatroom(random_text(), random_line(), mt_rand(db_get_first_id() + 1, $num_wanted - 1), strval(db_get_first_id() + 1), '', '', '', fallback_lang());
}
$room_id = db_get_first_id() + 1;
// messages in chat room
for ($j = $GLOBALS['SITE_DB']->query_value('chat_messages', 'COUNT(*)'); $j < $num_wanted; $j++) {
$_message_parsed = insert_lang_comcode(random_text(), 4);
$GLOBALS['SITE_DB']->query_insert('chat_messages', array('system_message' => 0, 'ip_address' => '', 'room_id' => $room_id, 'user_id' => db_get_first_id(), 'date_and_time' => time(), 'the_message' => $_message_parsed, 'text_colour' => get_option('chat_default_post_colour'), 'font_name' => get_option('chat_default_post_font')));
}
echo 'done chat stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
// download categories under a subcategory
require_code('downloads2');
$subcat_id = add_download_category(random_line(), db_get_first_id(), random_text(), '');
for ($i = $GLOBALS['SITE_DB']->query_value('download_categories', 'COUNT(*)'); $i < $num_wanted; $i++) {
add_download_category(random_line(), $subcat_id, random_text(), '');
}
// downloads (remember to test content by the single author)
require_code('downloads2');
require_code('awards');
$time = time();
for ($i = $GLOBALS['SITE_DB']->query_value('download_downloads', 'COUNT(*)'); $i < $num_wanted; $i++) {
$content_id = add_download(db_get_first_id(), random_line(), get_logo_url(), random_text(), 'admin', random_text(), NULL, 1, 1, 1, 1, '', uniqid('', true) . '.jpg', 100, 110, 1);
give_award(db_get_first_id(), strval($content_id), $time - $i);
}
$content_id = db_get_first_id();
$content_url = build_url(array('page' => 'downloads', 'type' => 'entry', 'id' => $content_id), 'site');
for ($j = $GLOBALS['SITE_DB']->query_value('trackbacks', 'COUNT(*)'); $j < $num_wanted; $j++) {
// trackbacks
$GLOBALS['SITE_DB']->query_insert('trackbacks', array('trackback_for_type' => 'downloads', 'trackback_for_id' => $content_id, 'trackback_ip' => '', 'trackback_time' => time(), 'trackback_url' => '', 'trackback_title' => random_line(), 'trackback_excerpt' => random_text(), 'trackback_name' => random_line()));
// ratings
$GLOBALS['SITE_DB']->query_insert('rating', array('rating_for_type' => 'downloads', 'rating_for_id' => $content_id, 'rating_member' => $j + 1, 'rating_ip' => '', 'rating_time' => time(), 'rating' => 3));
// posts in a comment topic
$GLOBALS['FORUM_DRIVER']->make_post_forum_topic(get_option('comments_forum_name'), 'downloads_' . strval($content_id), get_member(), random_text(), random_line(), '', do_lang('COMMENT'), $content_url->evaluate(), NULL, NULL, 1, 1);
}
echo 'done download stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
// forums under a forum (don't test it can display, just make sure the main index still works)
require_code('ocf_forums_action');
for ($i = $GLOBALS['FORUM_DB']->query_value('f_forums', 'COUNT(*)'); $i < $num_wanted; $i++) {
ocf_make_forum(random_line(), random_text(), db_get_first_id(), array(), db_get_first_id() + 3);
}
// forum topics
require_code('ocf_topics_action');
require_code('ocf_posts_action');
require_code('ocf_forums');
require_code('ocf_topics');
for ($i = intval(floatval($GLOBALS['FORUM_DB']->query_value('f_topics', 'COUNT(*)')) / 2.0); $i < $num_wanted; $i++) {
$topic_id = ocf_make_topic(db_get_first_id(), '', '', NULL, 1, 0, 0, 0, NULL, NULL, false);
ocf_make_post($topic_id, random_line(), random_text(), 0, true, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, false);
}
// forum posts in a topic
require_code('ocf_topics_action');
require_code('ocf_posts_action');
$topic_id = ocf_make_topic(db_get_first_id() + 1, '', '', NULL, 1, 0, 0, 0, NULL, NULL, false);
for ($i = intval(floatval($GLOBALS['FORUM_DB']->query_value('f_posts', 'COUNT(*)')) / 3.0); $i < $num_wanted; $i++) {
ocf_make_post($topic_id, random_line(), random_text(), 0, true, 0, 0, NULL, NULL, NULL, mt_rand(db_get_first_id(), $num_wanted - 1), NULL, NULL, NULL, false, false);
}
echo 'done forum stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
// clubs
require_code('ocf_groups_action');
require_code('ocf_groups');
for ($i = $GLOBALS['FORUM_DB']->query_value('f_groups', 'COUNT(*)'); $i < $num_wanted; $i++) {
ocf_make_group(random_line(), 0, 0, 0, random_line(), '', NULL, NULL, NULL, 5, 0, 70, 50, 100, 100, 30000, 700, 25, 1, 0, 0, 0, $i, 1, 0, 1);
}
echo 'done club stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
// galleries under a subcategory
require_code('galleries2');
$xsubcat_id = uniqid('', true);
add_gallery($xsubcat_id, random_line(), random_text(), '', '', 'root');
for ($i = $GLOBALS['SITE_DB']->query_value('galleries', 'COUNT(*)'); $i < $num_wanted; $i++) {
add_gallery(uniqid('', true), random_line(), random_text(), '', '', $xsubcat_id);
}
// images
require_code('galleries2');
for ($i = $GLOBALS['SITE_DB']->query_value('images', 'COUNT(*)'); $i < $num_wanted; $i++) {
add_image('', 'root', random_text(), get_logo_url(), get_logo_url(), 1, 1, 1, 1, '');
}
// videos / validation queue
require_code('galleries2');
for ($i = $GLOBALS['SITE_DB']->query_value('videos', 'COUNT(*)'); $i < $num_wanted; $i++) {
add_video('', 'root', random_text(), get_logo_url(), get_logo_url(), 0, 1, 1, 1, '', 0, 0, 0);
}
echo 'done galleries stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
// newsletter subscribers
require_code('newsletter');
for ($i = $GLOBALS['SITE_DB']->query_value('newsletter', 'COUNT(*)'); $i < $num_wanted; $i++) {
basic_newsletter_join(uniqid('', true) . '@example.com');
}
echo 'done newsletter stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
// polls (remember to test poll archive)
require_code('polls');
for ($i = $GLOBALS['SITE_DB']->query_value('poll', 'COUNT(*)'); $i < $num_wanted; $i++) {
$poll_id = add_poll(random_line(), random_line(), random_line(), random_line(), random_line(), random_line(), random_line(), random_line(), random_line(), random_line(), random_line(), 10, 0, 0, 0, 0, '');
}
// votes on a poll
$poll_id = db_get_first_id();
for ($j = $GLOBALS['SITE_DB']->query_value('poll_votes', 'COUNT(*)'); $j < $num_wanted; $j++) {
$cast = mt_rand(1, 6);
$ip = uniqid('', true);
$GLOBALS['SITE_DB']->query_insert('poll_votes', array('v_poll_id' => $poll_id, 'v_voter_id' => 2, 'v_voter_ip' => $ip, 'v_vote_for' => $cast));
}
echo 'done polls stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
// quizzes
require_code('quiz');
for ($i = $GLOBALS['SITE_DB']->query_value('quizzes', 'COUNT(*)'); $i < $num_wanted; $i++) {
add_quiz(random_line(), 0, random_text(), random_text(), random_text(), '', 0, time(), NULL, 3, 300, 'SURVEY', 1, '1) Some question');
}
echo 'done quizzes stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
// successful searches (to test the search recommender)
// ACTUALLY: I have manually verified the code, it is an isolated portion
// cedi pages (do a long descendant tree for some, and orphans for others)
// cedi posts (remember to test cedi changes screen)
require_code('cedi');
for ($i = $GLOBALS['SITE_DB']->query_value('seedy_pages', 'COUNT(*)'); $i < $num_wanted; $i++) {
$page_id = cedi_add_page(random_line(), random_text(), '', 1);
cedi_add_post($page_id, random_text(), 1, NULL, false);
}
echo 'done cedi stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
// iotds
require_code('iotds');
for ($i = $GLOBALS['SITE_DB']->query_value('iotd', 'COUNT(*)'); $i < $num_wanted; $i++) {
add_iotd(get_logo_url(), random_line(), random_text(), get_logo_url(), 1, 0, 0, 0, '');
}
echo 'done iotd stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
// logged hack attempts
for ($i = $GLOBALS['SITE_DB']->query_value('hackattack', 'COUNT(*)'); $i < $num_wanted; $i++) {
$GLOBALS['SITE_DB']->query_insert('hackattack', array('url' => get_base_url(), 'data_post' => '', 'user_agent' => '', 'referer' => '', 'user_os' => '', 'the_user' => db_get_first_id(), 'date_and_time' => time(), 'ip' => uniqid('', true), 'reason' => 'ASCII_ENTITY_URL_HACK', 'reason_param_a' => '', 'reason_param_b' => ''));
}
// logged hits in one day
require_code('site');
for ($i = $GLOBALS['SITE_DB']->query_value('stats', 'COUNT(*)'); $i < $num_wanted; $i++) {
log_stats('/testing' . uniqid('', true), mt_rand(100, 2000));
}
echo 'done logs stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
// blogs and news entries (remember to test both blogs [categories] list, and a list of all news entries)
require_code('news');
for ($i = $GLOBALS['SITE_DB']->query_value('news', 'COUNT(*)'); $i < $num_wanted; $i++) {
add_news(random_line(), random_text(), 'admin', 1, 1, 1, 1, '', random_text(), NULL, NULL, NULL, db_get_first_id() + $i);
}
echo 'done news stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
// support tickets
require_code('tickets');
require_code('tickets2');
for ($i = intval(floatval($GLOBALS['FORUM_DB']->query_value('f_topics', 'COUNT(*)')) / 2.0); $i < $num_wanted; $i++) {
ticket_add_post(mt_rand(db_get_first_id(), $num_wanted - 1), uniqid('', true), db_get_first_id(), random_line(), random_text(), '', '');
}
echo 'done tickets stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
// catalogues
require_code('catalogues2');
$root_id = db_get_first_id();
for ($i = $GLOBALS['SITE_DB']->query_value('catalogues', 'COUNT(*)'); $i < $num_wanted; $i++) {
$catalogue_name = uniqid('', true);
$root_id = actual_add_catalogue($catalogue_name, random_line(), random_text(), mt_rand(0, 3), 1, '', 30);
}
// catalogue categories under a subcategory (remember to test all catalogue views: atoz, index, and root cat)
$catalogue_name = 'products';
$subcat_id = actual_add_catalogue_category($catalogue_name, random_line(), random_text(), '', $root_id);
for ($j = $GLOBALS['SITE_DB']->query_value('catalogue_categories', 'COUNT(*)'); $j < $num_wanted; $j++) {
actual_add_catalogue_category($catalogue_name, random_line(), random_text(), '', $subcat_id);
}
echo 'done catalogue stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
// items in ecommerce store
require_code('catalogues2');
$cat_id = $GLOBALS['SITE_DB']->query_value('catalogue_categories', 'MIN(id)', array('c_name' => 'products'));
$fields = collapse_1d_complexity('id', $GLOBALS['SITE_DB']->query_select('catalogue_fields', array('id'), array('c_name' => 'products')));
for ($i = $GLOBALS['SITE_DB']->query_value('catalogue_entries', 'COUNT(*)'); $i < $num_wanted; $i++) {
$map = array($fields[0] => random_line(), $fields[1] => uniqid('', true), $fields[2] => '1.0', $fields[3] => '1', $fields[4] => '0', $fields[5] => '1', $fields[6] => '0%', $fields[7] => get_logo_url(), $fields[8] => '2.0', $fields[9] => random_text());
$pid = actual_add_catalogue_entry($cat_id, 1, '', 1, 1, 1, $map);
unset($map);
}
// outstanding ecommerce orders
$pid = $GLOBALS['SITE_DB']->query_value('catalogue_entries', 'MIN(id)', array('c_name' => 'products'));
require_code('shopping');
for ($j = $GLOBALS['SITE_DB']->query_value('shopping_cart', 'COUNT(*)'); $j < $num_wanted; $j++) {
$product_det = array('product_id' => $pid, 'product_name' => $fields[0], 'product_code' => $fields[1], 'price' => $fields[2], 'tax' => preg_replace('#[^\\d\\.]#', '', $fields[6]), 'description' => $fields[9], 'quantity' => mt_rand(1, 20), 'product_type' => 'catalogue_items', 'product_weight' => $fields[8]);
$GLOBALS['SITE_DB']->query_insert('shopping_cart', array('session_id' => mt_rand(0, 1000000), 'ordered_by' => mt_rand(db_get_first_id() + 1, $num_wanted - 1), 'product_id' => $product_det['product_id'], 'product_name' => $product_det['product_name'], 'product_code' => $product_det['product_code'], 'quantity' => $product_det['quantity'], 'price' => round(floatval($product_det['price']), 2), 'price_pre_tax' => $product_det['tax'], 'product_description' => $product_det['description'], 'product_type' => $product_det['product_type'], 'product_weight' => $product_det['product_weight'], 'is_deleted' => 0));
}
for ($j = $GLOBALS['SITE_DB']->query_value('shopping_order', 'COUNT(*)'); $j < $num_wanted; $j++) {
$order_id = $GLOBALS['SITE_DB']->query_insert('shopping_order', array('c_member' => mt_rand(db_get_first_id() + 1, $num_wanted - 1), 'session_id' => mt_rand(0, 1000000), 'add_date' => time(), 'tot_price' => '123.00', 'order_status' => 'ORDER_STATUS_awaiting_payment', 'notes' => '', 'purchase_through' => 'purchase_module', 'transaction_id' => '', 'tax_opted_out' => 0), true);
$GLOBALS['SITE_DB']->query_insert('shopping_order_details', array('p_id' => 123, 'p_name' => random_line(), 'p_code' => 123, 'p_type' => 'catalogue_items', 'p_quantity' => 1, 'p_price' => '12.00', 'order_id' => $order_id, 'dispatch_status' => '', 'included_tax' => '1.00'));
}
echo 'done store stuff' . chr(10);
if (function_exists('gc_collect_cycles')) {
gc_enable();
}
echo '{{DONE}}' . chr(10);
}
/**
* Standard import function.
*
* @param object The DB connection to import from
* @param string The table prefix the target prefix is using
* @param PATH The base directory we are importing from
*/
function import_news_and_categories($db, $table_prefix, $file_base)
{
require_code('news');
$rows = $db->query('SELECT * FROM ' . $table_prefix . 'news_categories ORDER BY id', NULL, NULL, true);
if (is_null($rows)) {
return;
}
$on_same_msn = $this->on_same_msn($file_base);
foreach ($rows as $row) {
if (import_check_if_imported('news_category', strval($row['id']))) {
continue;
}
$owner = $on_same_msn ? $row['nc_owner'] : import_id_remap_get('member', $row['nc_owner'], true);
$id = get_param_integer('keep_preserve_ids', 0) == 0 ? NULL : $row['id'];
$id_new = add_news_category($this->get_lang_string($db, $row['nc_title']), $row['nc_img'], $row['notes'], $owner, $id);
import_id_remap_put('news_category', strval($row['id']), $id_new);
}
$this->_import_catalogue_entry_linkage($db, $table_prefix, 'news_category', 'news_category');
$rows = $db->query('SELECT * FROM ' . $table_prefix . 'news ORDER BY id');
foreach ($rows as $row) {
if (import_check_if_imported('news', strval($row['id']))) {
continue;
}
$news_category = array();
$rows2 = $db->query('SELECT news_entry_category FROM ' . $table_prefix . 'news_category_entries WHERE news_entry=' . strval((int) $row['id']));
foreach ($rows2 as $row2) {
$next = import_id_remap_get('news_category', strval($row2['news_entry_category']), true);
if (!is_null($next)) {
$news_category[] = $next;
}
}
$submitter = $on_same_msn ? $row['submitter'] : import_id_remap_get('member', $row['submitter'], true);
if (is_null($submitter)) {
$submitter = $GLOBALS['FORUM_DRIVER']->get_guest_id();
}
$id = get_param_integer('keep_preserve_ids', 0) == 0 ? NULL : $row['id'];
$main_news_category = $row['news_category'];
$main_news_category = import_id_remap_get('news_category', strval($main_news_category), true);
if (is_null($main_news_category)) {
$main_news_category = db_get_first_id();
}
$id_new = add_news($this->get_lang_string($db, $row['title']), $this->get_lang_string($db, $row['news']), $row['author'], $row['validated'], $row['allow_rating'], $row['allow_comments'], $row['allow_trackbacks'], $row['notes'], $this->get_lang_string($db, $row['news_article']), $main_news_category, $news_category, $row['date_and_time'], $submitter, $row['news_views'], $row['edit_date'], $id, $row['news_image']);
import_id_remap_put('news', strval($row['id']), $id_new);
}
$this->_import_review_supplement($db, $table_prefix, 'news', 'news');
$this->_import_catalogue_entry_linkage($db, $table_prefix, 'news', 'news');
$rows = $db->query('SELECT * FROM ' . $table_prefix . 'news_rss_cloud', NULL, NULL, true);
if (!is_null($rows)) {
foreach ($rows as $row) {
unset($row['id']);
$GLOBALS['SITE_DB']->query_insert('news_rss_cloud', $row);
}
}
}
$limit = get_number_limit($pageparam, 1, $CONFIG['quote_list_limit']);
switch ($page[0]) {
case 'add':
if (isset($CONFIG['login_required']) && $CONFIG['login_required'] == 1 && !isset($_SESSION['logged_in'])) {
break;
}
add_quote($page[1]);
break;
case 'edit_news':
if (isset($_SESSION['logged_in']) && $_SESSION['level'] <= USER_ADMIN) {
edit_news($page[1], $page[2]);
}
break;
case 'add_news':
if (isset($_SESSION['logged_in']) && $_SESSION['level'] <= USER_ADMIN) {
add_news($page[1]);
}
break;
case 'add_user':
if (isset($_SESSION['logged_in']) && $_SESSION['level'] <= USER_SUPERUSER) {
add_user($page[1]);
}
break;
case 'register':
if (isset($CONFIG['login_required']) && $CONFIG['login_required'] == 1) {
register_user($page[1]);
}
break;
case 'login':
if (isset($CONFIG['login_required']) && $CONFIG['login_required'] == 1) {
if (isset($_SESSION['logged_in'])) {
/**
* The actualiser to import news
*
* @return tempcode The UI
*/
function _import_news()
{
check_specific_permission('mass_import');
$title = get_page_title('IMPORT_NEWS');
require_code('rss');
require_code('news');
require_code('files');
$GLOBALS['LAX_COMCODE'] = true;
disable_php_memory_limit();
$rss_url = post_param('rss_feed_url', NULL);
require_code('uploads');
if (is_swf_upload(true) && array_key_exists('file_novalidate', $_FILES) || array_key_exists('file_novalidate', $_FILES) && is_uploaded_file($_FILES['file_novalidate']['tmp_name'])) {
$rss_url = $_FILES['file_novalidate']['tmp_name'];
}
if (is_null($rss_url)) {
warn_exit(do_lang_tempcode('IMPROPERLY_FILLED_IN'));
}
$is_validated = post_param_integer('auto_validate', 0);
$download_images = post_param_integer('download_images', 0);
$rss = new rss($rss_url, true);
if (!is_null($rss->error)) {
warn_exit($rss->error);
}
$submitter = get_member();
$NEWS_CATS = $GLOBALS['SITE_DB']->query_select('news_categories', array('*'), array('nc_owner' => NULL));
$NEWS_CATS = list_to_map('id', $NEWS_CATS);
$extra_post_data = array();
foreach ($rss->gleamed_items as $i => $item) {
if (!array_key_exists('category', $item)) {
$item['category'] = do_lang('NC_general');
}
$extra_post_data[] = $item;
$cats_to_process = array($item['category']);
if (array_key_exists('extra_categories', $item)) {
$cats_to_process = array_merge($cats_to_process, $item['extra_categories']);
}
$cat_id = mixed();
$extra_categories = array();
foreach ($cats_to_process as $j => $cat) {
$_cat_id = mixed();
foreach ($NEWS_CATS as $_cat => $news_cat) {
if (get_translated_text($news_cat['nc_title']) == $cat) {
$_cat_id = $_cat;
}
}
if (is_null($_cat_id)) {
$_cat_id = add_news_category($cat, 'newscats/general', '', NULL);
// Need to reload now
$NEWS_CATS = $GLOBALS['SITE_DB']->query_select('news_categories', array('*'), array('nc_owner' => NULL));
$NEWS_CATS = list_to_map('id', $NEWS_CATS);
}
if ($j == 0) {
$cat_id = $_cat_id;
} else {
$extra_categories[] = $_cat_id;
}
}
$rep_image = '';
if (array_key_exists('rep_image', $item)) {
$rep_image = $item['rep_image'];
if ($download_images == 1) {
$stem = 'uploads/grepimages/' . basename(urldecode($rep_image));
$target_path = get_custom_file_base() . '/' . $stem;
$rep_image = 'uploads/grepimages/' . basename($rep_image);
while (file_exists($target_path)) {
$uniqid = uniqid('');
$stem = 'uploads/grepimages/' . $uniqid . '_' . basename(urldecode($rep_image));
$target_path = get_custom_file_base() . '/' . $stem;
$rep_image = 'uploads/grepimages/' . $uniqid . '_' . basename($rep_image);
}
$target_handle = fopen($target_path, 'wb') or intelligent_write_error($target_path);
$result = http_download_file($item['rep_image'], NULL, false, false, 'ocPortal', NULL, NULL, NULL, NULL, NULL, $target_handle);
fclose($target_handle);
}
}
// Add news
$ts = array_key_exists('clean_add_date', $item) ? $item['clean_add_date'] : (array_key_exists('add_date', $item) ? strtotime($item['add_date']) : time());
if ($ts === false) {
$ts = time();
}
// Seen in error email, it's if the add date won't parse by PHP
$edit_date = array_key_exists('clean_edit_date', $item) ? $item['clean_edit_date'] : (array_key_exists('edit_date', $item) ? strtotime($item['edit_date']) : NULL);
if ($edit_date === false) {
$edit_date = NULL;
}
$news = array_key_exists('news', $item) ? html_to_comcode($item['news']) : '';
$news_article = array_key_exists('news_article', $item) ? html_to_comcode($item['news_article']) : '';
$news_id = add_news($item['title'], $news, array_key_exists('author', $item) ? $item['author'] : $GLOBALS['FORUM_DRIVER']->get_username(get_member()), $is_validated, 1, 1, 1, '', $news_article, $cat_id, $extra_categories, $ts, $submitter, 0, $edit_date, NULL, $rep_image);
$rss->gleamed_items[$i]['import_id'] = $news_id;
$rss->gleamed_items[$i]['import__news'] = $news;
$rss->gleamed_items[$i]['import__news_article'] = $news_article;
}
foreach ($rss->gleamed_items as $i => $item) {
$news = $item['import__news'];
$news_article = $item['import__news_article'];
$this->_grab_images_and_fix_links($download_images == 1, $news, $rss->gleamed_items);
$this->_grab_images_and_fix_links($download_images == 1, $news_article, $rss->gleamed_items);
lang_remap_comcode($GLOBALS['SITE_DB']->query_value('news', 'news', array('id' => $item['import_id'])), $news);
lang_remap_comcode($GLOBALS['SITE_DB']->query_value('news', 'news_article', array('id' => $item['import_id'])), $news_article);
}
breadcrumb_set_parents(array(array('_SELF:_SELF:misc', do_lang_tempcode('MANAGE_NEWS')), array('_SELF:_SELF:import', do_lang_tempcode('IMPORT_NEWS'))));
breadcrumb_set_self(do_lang_tempcode('DONE'));
if (url_is_local($rss_url)) {
// Means it is a temp file
@unlink($rss_url);
}
return inform_screen($title, do_lang_tempcode('IMPORT_NEWS_DONE'));
}
<?php
require_once 'dbproc.php';
if (is_ajax()) {
if (isset($_POST["action"]) && !empty($_POST["action"])) {
$action = $_POST["action"];
switch ($action) {
case "openNews":
open_news($_POST["id"]);
break;
case "delNews":
del_news($_POST["id"]);
break;
case "addNews":
add_news();
break;
}
}
}
function is_ajax()
{
return isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest';
}
function open_news($id)
{
$news = DBProc::get_news_by_id($id);
$tags = "";
while (!empty($news["tags"])) {
$tags = $tags . "#" . array_shift($news["tags"]);
}
$ret['new_content'] = '<div class="page-header">
<?php
include "admin/functions.php";
// Si l'url ".../index.php?page=" est vide, alors on redirige sur la bonne url.
if (empty($page)) {
$page = 'index';
}
if (!empty($_GET)) {
$page = htmlentities($_GET["p"]);
}
// --- AJOUT D'UNE NEWS
if (!empty($_POST) && isset($_POST["add_news"]) && $_POST["add_news"] == "1") {
$message = addslashes($_POST["message"]);
$dateMessage = $_POST["dateMessage"];
$author = $_POST["author"];
add_news($db, $message, $dateMessage, $author);
}
// --- SUPPRESSION D'UNE NEWS
if (!empty($_POST) && isset($_POST["delete_news"]) && $_POST["delete_news"] == "1") {
$id = $_POST["id"];
delete($db, $id, "news");
}
?>
<!DOCTYPE html>
<html lang="fr">
<head>
<meta charset="utf-8">
<?php
include $_SERVER['DOCUMENT_ROOT'] . '/config.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/lib/db.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/lib/session.php';
sec_session_start();
global $table_prefix;
global $dbh;
switch ($_POST['option']) {
case 1:
add_comment($dbh, $table_prefix);
break;
case 2:
add_news($dbh, $table_prefix);
break;
case 3:
remove_news($dbh, $table_prefix);
break;
case 4:
send_message($dbh, $table_prefix);
break;
case 5:
reply_message($dbh, $table_prefix);
break;
case 6:
get_massage($dbh, $table_prefix);
break;
}
function add_comment($dbh1, $table_prefix)
{
if ($stmt = $dbh1->prepare("INSERT INTO " . $table_prefix . "_comments (project_id, user_id, comment) VALUES (?, ?, ?)")) {
/**
* Standard import function.
*
* @param object The DB connection to import from
* @param string The table prefix the target prefix is using
* @param PATH The base directory we are importing from
*/
function import_news_and_categories($db, $table_prefix, $old_base_dir)
{
require_code('news');
$fields = collapse_1d_complexity('id', $GLOBALS['SITE_DB']->query_select('catalogue_fields', array('id'), array('c_name' => 'news')));
$categories = $db->query("SELECT id,title,description,image FROM " . $table_prefix . "sections WHERE title='News'");
foreach ($categories as $category) {
$title = $category['title'];
$cat_id = $GLOBALS['SITE_DB']->query_select('news_categories', array('id'), array('nc_title' => $title), '', 1);
if (count($cat_id) == 0) {
$cat_title = $category['title'];
$category_id = $GLOBALS['SITE_DB']->query("SELECT N.id FROM " . $GLOBALS['SITE_DB']->get_table_prefix() . "translate AS T INNER JOIN " . $GLOBALS['SITE_DB']->get_table_prefix() . "news_categories AS N ON T.id=N.nc_title AND " . db_string_equal_to('T.text_original', $cat_title));
if (count($category_id) == 0) {
$desc = html_to_comcode($category['description']);
$id = add_news_category($category['title'], $category['image'], $desc, NULL, NULL);
} else {
$id = $category_id[0]['id'];
}
} else {
$id = $cat_id[0]['id'];
}
$rows = $db->query('SELECT * FROM ' . $table_prefix . 'content WHERE sectionid=' . strval($category['id']));
foreach ($rows as $row) {
$val = $row['title'];
$news_id = $GLOBALS['SITE_DB']->query("SELECT N.id FROM " . $GLOBALS['SITE_DB']->get_table_prefix() . "translate AS T INNER JOIN " . $GLOBALS['SITE_DB']->get_table_prefix() . "news AS N ON T.id=N.title AND " . db_string_equal_to('T.text_original', $val) . " AND news_category=" . strval($id) . " AND news_category<>''");
if (count($news_id) == 0) {
$title = $row['title'];
$news = html_to_comcode($row['introtext']);
$author = $db->query_value_null_ok('users', 'name', array('id' => $row['created_by']));
if (is_null($author)) {
$author = do_lang('UNKNOWN');
}
$access = $row['access'];
if ($access == 0) {
$validated = 1;
} else {
$validated = 0;
}
$allow_rating = 1;
$allow_comments = 1;
$allow_trackbacks = 1;
$notes = '';
$news_article = '';
$main_news_category = $id;
$news_category = NULL;
$datetimearr = explode(' ', $row['created']);
$datearr = explode('-', $datetimearr[0]);
$timearr = explode(':', $datetimearr[1]);
$date = intval($datearr[2]);
$month = intval($datearr[1]);
$year = intval($datearr[0]);
$hour = intval($timearr[0]);
$min = intval($timearr[1]);
$sec = intval($timearr[2]);
$time = mktime($hour, $min, $sec, $month, $date, $year);
$submitter = import_id_remap_get('member', strval($row['created_by']));
$views = $row['hits'];
$datetimearr = explode(' ', $row['modified']);
$datearr = explode('-', $datetimearr[0]);
$timearr = explode(':', $datetimearr[1]);
$date = intval($datearr[2]);
$month = intval($datearr[1]);
$year = intval($datearr[0]);
$hour = intval($timearr[0]);
$min = intval($timearr[1]);
$sec = intval($timearr[2]);
$edit_date = mktime($hour, $min, $sec, $month, $date, $year);
$nid = NULL;
$image = 'newscats/' . preg_replace('#\\..*$#', '', $row['images']);
@mkdir(get_custom_file_base() . '/themes/default/images_custom/newscats', 0777);
fix_permissions(get_custom_file_base() . '/themes/default/images_custom/newscats', 0777);
sync_file(get_custom_file_base() . '/themes/default/images_custom/newscats');
$newimagepath = get_custom_file_base() . '/themes/default/images_custom/newscats/' . rawurldecode($row['images']);
$oldimagepath = $old_base_dir . "/images/stories/" . rawurldecode($row['images']);
@copy($oldimagepath, $newimagepath);
fix_permissions($newimagepath);
sync_file($newimagepath);
add_news($title, $news, $author, $validated, $allow_rating, $allow_comments, $allow_trackbacks, $notes, $news_article, $main_news_category, $news_category, $time, $submitter, $views, $edit_date, $nid, $image);
}
}
}
}
/**
* Standard import function.
*
* @param object The DB connection to import from
* @param string The table prefix the target prefix is using
* @param PATH The base directory we are importing from
*/
function import_news_and_categories($db, $table_prefix, $old_base_dir)
{
require_code('news');
require_code('news2');
// Can we comment the news?
$rows = $db->query('SELECT articlecomm FROM ' . $table_prefix . 'config');
$com = $rows[0]['articlecomm'];
$forum_name = get_option('comments_forum_name');
$forum_id = $GLOBALS['FORUM_DRIVER']->forum_id_from_name($forum_name);
// Reviews (imports into 'technology')
$rows = $db->query('SELECT * FROM ' . $table_prefix . 'reviews');
foreach ($rows as $i => $row) {
$rows[$i]['validated'] = 1;
}
$rows2 = $db->query('SELECT * FROM ' . $table_prefix . 'reviews_add');
foreach ($rows2 as $i => $row) {
$rows2[$i]['validated'] = 0;
$rows2[$i]['hits'] = 0;
}
$rows = array_merge($rows, $rows2);
foreach ($rows as $row) {
$cat_id = $this->get_news_category_id(do_lang('NC_community'), 'community');
$new_id = add_news($row['title'], $row['cover'] . chr(10) . $row['url'] . chr(10) . $row['score'], $row['reviewer'], $row['validated'], $com, 1, 1, '', html_to_comcode($row['text']), $cat_id, array(), $this->mysql_time_to_timestamp($row['date']), get_member(), $row['hits']);
// Comments
$comments = $db->query('SELECT * FROM ' . $table_prefix . 'reviews_comments WHERE rid=' . strval($row['id']) . ' ORDER BY date');
if (!is_null($forum_id)) {
foreach ($comments as $comment) {
$member = $GLOBALS['FORUM_DRIVER']->get_member_from_username($comment['userid']);
if (is_null($member)) {
$member = $GLOBALS['FORUM_DRIVER']->get_guest_id();
}
$title = '';
$post = $comment['comment'];
$content_url = build_url(array('page' => 'news', 'id' => $new_id, 'type' => 'view'), get_module_zone('news'));
$GLOBALS['FORUM_DRIVER']->make_post_forum_topic($forum_name, 'news_' . strval($new_id), $member, $title, '[html]' . $post . '[/html]', $row['title'], do_lang('COMMENT'), $content_url->evaluate(), $this->mysql_time_to_timestamp($comment['date']));
}
}
}
// Journals (imports into community for author)
$rows = $db->query('SELECT * FROM ' . $table_prefix . 'journal');
foreach ($rows as $row) {
$cat_id = $this->get_news_category_id(do_lang('JOURNAL_OF', $row['aid']), 'community');
$new_id = add_news($row['title'], $row['cover'] . chr(10) . $row['mood'] . chr(10) . $row['status'], $row['aid'], 1, $com, 1, 1, '', html_to_comcode($row['bodytext']), $cat_id, array(), strtotime($row['pdate'] . ' ' . $row['ptime']), get_member());
// Comments
$comments = $db->query('SELECT * FROM ' . $table_prefix . 'journal_comments WHERE rid=' . $row['rid'] . ' ORDER BY date');
if (!is_null($forum_id)) {
foreach ($comments as $comment) {
$member = $GLOBALS['FORUM_DRIVER']->get_member_from_username($comment['aid']);
if (is_null($member)) {
$member = $GLOBALS['FORUM_DRIVER']->get_guest_id();
}
$title = '';
$post = $comment['comment'];
$content_url = build_url(array('page' => 'news', 'id' => $new_id, 'type' => 'view'), get_module_zone('news'));
$GLOBALS['FORUM_DRIVER']->make_post_forum_topic($forum_name, 'news_' . strval($new_id), $member, $title, '[html]' . $post . '[/html]', $row['title'], do_lang('COMMENT'), $content_url->evaluate(), $this->mysql_time_to_timestamp($comment['date']));
}
}
}
// Stories (creates categories). NB: Dunno what stories_cat's are, but topic's are the way to go
$cats = $db->query('SELECT * FROM ' . $table_prefix . 'topics');
$cat_id = array();
foreach ($cats as $cat) {
$image = $cat['topicimage'];
$dot_pos = strrpos($image, '.');
if ($dot_pos === false) {
$dot_pos = strlen($image);
}
$image = substr($image, 0, $dot_pos);
$cat_id[$cat['topicid']] = $this->get_news_category_id($cat['topictext'], $image);
}
$rows = $db->query('SELECT * FROM ' . $table_prefix . 'stories');
foreach ($rows as $i => $row) {
$rows[$i]['validated'] = 1;
}
$rows2 = $db->query('SELECT * FROM ' . $table_prefix . 'autonews');
foreach ($rows2 as $i => $row) {
$rows2[$i]['validated'] = 0;
$rows2[$i]['ratings'] = 0;
$rows2[$i]['haspoll'] = 0;
}
$rows = array_merge($rows, $rows2);
foreach ($rows as $row) {
$append = '';
if ($row['haspoll'] == 1) {
$poll_rows = $db->query('SELECT pollTitle FROM ' . $table_prefix . 'poll_desc WHERE pollID=' . $row['pollID']);
$poll_title = $poll_rows[0]['pollTitle'];
$poll_id = $GLOBALS['SITE_DB']->query_value_null_ok('poll p LEFT JOIN ' . get_table_prefix() . 'translate t ON p.question=t.id', 'p.id', array('text_original' => $poll_title));
if (is_null($poll_id)) {
$poll_id = 1;
}
// We couldn't find it (we should have imported polls first)
$append = chr(10) . '[block="' . $poll_id . '"][/block]';
}
$topic = array_key_exists($row['topic'], $cat_id) ? $cat_id[$row['topic']] : db_get_first_id();
$new_id = add_news($row['title'], $row['hometext'], $row['aid'], $row['validated'], $com, 1, 1, $row['notes'], html_to_comcode($row['bodytext']) . $append, $topic, array(), $this->mysql_time_to_timestamp($row['time']), get_member(), $row['counter']);
// Comments
$comments = $db->query('SELECT * FROM ' . $table_prefix . 'comments WHERE sid=' . $row['sid'] . ' ORDER BY date');
if (!is_null($forum_id)) {
foreach ($comments as $comment) {
$member = $GLOBALS['FORUM_DRIVER']->get_member_from_username($comment['name']);
if (is_null($member)) {
$member = $GLOBALS['FORUM_DRIVER']->get_guest_id();
}
$title = $comment['subject'];
$post = $comment['comment'];
$content_url = build_url(array('page' => 'news', 'id' => $new_id, 'type' => 'view'), get_module_zone('news'));
$GLOBALS['FORUM_DRIVER']->make_post_forum_topic($forum_name, 'news_' . strval($new_id), $member, $title, '[html]' . $post . '[/html]', $row['title'], do_lang('COMMENT'), $content_url->evaluate(), $this->mysql_time_to_timestamp($comment['date']));
}
}
// Rating
if ($row['ratings'] != 0) {
$real_rating = $row['score'];
// Same scale as ocPortal :)
$GLOBALS['SITE_DB']->query_insert('rating', array('rating_for_type' => 'news', 'rating_for_id' => strval($new_id), 'rating_member' => get_member(), 'rating_ip' => '127.0.0.1', 'rating_time' => time(), 'rating' => $real_rating));
}
}
}
function check_news_page($pagename, $description, $new)
{
$col = 'title';
$table = 'news';
if (!check_url($table, $col, $pagename)) {
return "This page already exists in Latest News";
} else {
return add_news($pagename, $description, $new);
}
}
if ($image) {
$info = new SplFileInfo($image['name']);
$image_id = add_image(array('name' => $image['name'], 'type' => $info->getExtension()));
if ($image_id) {
$uploads_dir = '../img/news-img/';
$uploadfile = $uploads_dir . basename($image_id) . '.' . $info->getExtension();
move_uploaded_file($image['tmp_name'], $uploadfile);
}
}
$data['date_create'] = date('Y-m-d', time());
$data['image_id'] = $image_id;
$article_id = add_article($data);
unset($data);
$data['article_id'] = $article_id;
$data['title'] = $_POST['title'];
$data['addedby'] = $_POST['name'];
$data['full_text'] = $_POST['article'];
$lang_id = '';
$lang = get_lang();
$langradio = $_POST['languages'];
foreach ($lang as $lk => $lv) {
if ($lv['lang'] == $langradio) {
$lang_id = $lv['id'];
}
}
if ($lang_id) {
$data['lang_id'] = $lang_id;
}
add_news($data);
}
require_once 'templates/add_news.template.php';
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]);
if ($result > 0) {
$response['body'] = stripslashes($text);
$response['id'] = $result;
echo json_encode($response);
}
} else {
echo 1;
}
}
} else {
//$response['ajerror'] = "Facebook ფოტოს ზომა: 470x247";
echo 0;
}
}
if ($_POST['action'] == 'get_images_from_dir') {
/**
* Standard import function.
*
* @param object The DB connection to import from
* @param string The table prefix the target prefix is using
* @param PATH The base directory we are importing from
*/
function import_news_and_categories($db, $table_prefix, $old_base_dir)
{
require_code('news');
require_code('galleries2');
//check is the comment forum configured in ocPortal
$this->test_for_comments_forum();
// Can we comment the news?
$com = 1;
$forum_name = get_option('comments_forum_name');
ocf_over_msn();
//used to fixed the correct forum prefix
$forum_id = $GLOBALS['FORUM_DRIVER']->forum_id_from_name($forum_name);
ocf_over_local();
//used to fixed the correct forum prefix
/* old import reviews code, as part of the news. NOTE: now they are imported as catalogues entries
// Reviews (imports into 'community')
$rows=$db->query('SELECT r.id AS review_id, r.title AS review_title, r.description AS review_description, r.field1 AS rf1, r.field2 AS rf2, r.field3 AS rf3, r.field4 AS rf4, r.field5 AS rf5, r.field6 AS rf6, r.field7 AS rf7, r.*, rc.title AS rc_title, rc.description AS rc_description, rc.field1 AS rcf1, rc.field2 AS rcf2, rc.field3 AS rcf3, rc.field4 AS rcf4, rc.field5 AS rcf5, rc.field6 AS rcf6, rc.field7 AS rcf7, rc.* FROM '.$table_prefix.'reviews r LEFT JOIN '.$table_prefix.'reviews_sections rc ON r.id_cat=rc.id');
foreach ($rows as $row)
{
$cat_id=$this->get_news_category_id($row['review_title'],'community');
$review_description=$row['review_description'];
for ($i=1;$i<=7;$i++)
{
if (strlen($row[strval('rcf'.$i)])>0)
{
$review_description.=chr(10).$row[strval('rcf'.$i)].': '.$row[strval('rf'.$i)];
}
}
$review_description.=chr(10).'Views: '.strval(intval($row['click']));
ocf_over_msn(); //used to fixed the correct forum prefix
$new_id=add_news($row['review_title'],html_to_comcode($review_description),$row['idauth'],$row['validate'],$com,1,1,'',html_to_comcode($row['review']),$cat_id,array(),$row['date'],get_member(),$row['click']);
ocf_over_local(); //used to fixed the correct forum prefix
// Comments
$comments=$db->query('SELECT * FROM '.$table_prefix.'reviews_comments WHERE id='.strval($row['review_id']).' ORDER BY data');
if (!is_null($forum_id))
{
foreach ($comments as $comment)
{
$member=$comment['id_autore']; //$GLOBALS['FORUM_DRIVER']->get_member_from_username($comment['userid']);
ocf_over_msn(); //used to fixed the correct forum prefix
if (is_null($member)) $member=$GLOBALS['FORUM_DRIVER']->get_guest_id();
ocf_over_local(); //used to fixed the correct forum prefix
$title='';
$post=$comment['testo'];
$content_url=build_url(array('page'=>'news','id'=>$new_id,'type'=>'view'),get_module_zone('news'));
ocf_over_msn(); //used to fixed the correct forum prefix
$GLOBALS['FORUM_DRIVER']->make_post_forum_topic(
$forum_name,
'news_'.strval($new_id),
$member,
$title,
html_to_comcode($post),
$row['title'],
do_lang('COMMENT'),
$content_url->evaluate()
);
ocf_over_local(); //used to fixed the correct forum prefix
}
}
} end of old import reviews code */
// Blogs (imports into community for author)
$rows = $db->query('SELECT * FROM ' . $table_prefix . 'blog');
foreach ($rows as $row) {
$blog_cat_id = $GLOBALS['SITE_DB']->query_value_null_ok('news_categories', 'id', array('nc_owner' => $row['creato']));
$row['titolo'] = @html_entity_decode($row['titolo'], ENT_QUOTES, get_charset());
ocf_over_msn();
//used to fixed the correct forum prefix
$submitting_member_id = $GLOBALS['FORUM_DRIVER']->get_member_from_username($row['autore']);
if (is_null($submitting_member_id)) {
$submitting_member_id = $GLOBALS['FORUM_DRIVER']->get_guest_id();
}
ocf_over_local();
//used to fixed the correct forum prefix
if (is_null($blog_cat_id)) {
ocf_over_msn();
//used to fixed the correct forum prefix
$p_nc_title = insert_lang($row['titolo'], 2);
ocf_over_local();
//used to fixed the correct forum prefix
$blog_cat_id = $GLOBALS['SITE_DB']->query_insert('news_categories', array('nc_title' => $p_nc_title, 'nc_img' => 'newscats/community', 'notes' => '', 'nc_owner' => $submitting_member_id), true);
ocf_over_msn();
//used to fixed the correct forum prefix
$groups = $GLOBALS['FORUM_DRIVER']->get_usergroup_list(false, true);
ocf_over_local();
//used to fixed the correct forum prefix
foreach (array_keys($groups) as $group_id) {
$GLOBALS['SITE_DB']->query_insert('group_category_access', array('module_the_name' => 'news', 'category_name' => strval($blog_cat_id), 'group_id' => $group_id));
}
}
// Blog description goes to first post in blog
ocf_over_msn();
//used to fixed the correct forum prefix
$new_id = add_news($row['titolo'], '', $row['autore'], $row['validate'], 1, $com, 1, '', html_to_comcode($row['descrizione']), $blog_cat_id, array(), $row['creato'], $submitting_member_id);
ocf_over_local();
//used to fixed the correct forum prefix
$blog_posts = $db->query('SELECT * FROM ' . $table_prefix . 'blog_post WHERE id_blog=' . strval($row['id']));
foreach ($blog_posts as $blog_post) {
if (import_check_if_imported('blog_post', strval($blog_post['id']))) {
continue;
}
ocf_over_msn();
//used to fixed the correct forum prefix
$new_id = add_news($row['titolo'], '', $row['autore'], $row['validate'], 1, $com, 1, '', html_to_comcode($blog_post['post']), $blog_cat_id, array(), $blog_post['data'], $submitting_member_id);
ocf_over_local();
//used to fixed the correct forum prefix
import_id_remap_put('blog_post', strval($blog_post['id']), $new_id);
//import blog rating too
$this->_import_ratings($db, 'news', $row['id'], $new_id, $row['rate'], $table_prefix);
// Comments
$comments = $db->query('SELECT * FROM ' . $table_prefix . 'blog_commenti WHERE id_blog=' . strval($blog_post['id']) . ' ORDER BY data');
if (!is_null($forum_id)) {
foreach ($comments as $comment) {
ocf_over_msn();
//used to fixed the correct forum prefix
$member = $GLOBALS['FORUM_DRIVER']->get_member_from_username($comment['autore']);
if (is_null($member)) {
$member = $GLOBALS['FORUM_DRIVER']->get_guest_id();
}
ocf_over_local();
//used to fixed the correct forum prefix
$title = '';
$post = $comment['commento'];
$content_url = build_url(array('page' => 'news', 'id' => $new_id, 'type' => 'view'), get_module_zone('news'));
ocf_over_msn();
//used to fixed the correct forum prefix
$GLOBALS['FORUM_DRIVER']->make_post_forum_topic($forum_name, 'news_' . strval($new_id), $member, $title, html_to_comcode($post), $row['titolo'], do_lang('COMMENT'), $content_url->evaluate());
ocf_over_local();
//used to fixed the correct forum prefix
}
}
}
//import blog images in personal galleries or in synch onces
if (addon_installed('galleries')) {
$blog_pimages = $db->query('SELECT * FROM ' . $table_prefix . 'blog_pimages WHERE iduser='******'SITE_DB']->query_value_null_ok('galleries', 'name', array('is_member_synched' => 1));
$root_gallery = is_null($pcc_gallery) ? 'root' : $pcc_gallery;
$ocp_path = get_custom_file_base();
//copy watermark image, to insure it is copied
$save_filename = $old_base_dir . 'mkportal/modules/gallery/wt.png';
//NOTE: this is the default watermark image in MKPortal, if customer needs to use another image, he/she needs to overwite it
$watermark_image = '';
if (file_exists($save_filename)) {
$copy_destination = $ocp_path . '/uploads/watermarks/wt.png';
@copy($save_filename, $copy_destination);
fix_permissions($copy_destination);
sync_file($copy_destination);
$watermark_image = get_custom_base_url() . '/uploads/watermarks/wt.png';
}
//now we need to get MKPortal settings for the watermark images
$conf_rows = $db->query('SELECT * FROM ' . $table_prefix . 'config WHERE ' . db_string_equal_to('chiave', 'watermark_pos') . ' OR ' . db_string_equal_to('chiave', 'watermark_enable'));
$watermark_pos = 2;
//Possible values: 0 - Top-right; 1 - Center; 2 - Bottom-right (default for MKPortal)
$watermark_enable = 0;
//by default it is disabled
foreach ($conf_rows as $conf_row) {
if (isset($conf_row['chiave']) && $conf_row['chiave'] == 'watermark_pos') {
$watermark_pos = $conf_row['valore'];
if ($watermark_pos == 1) {
$watermark_pos = 2;
//ocPortal doesn't have watermark center position, so we will use the mkPortal default position: Bottom-right
}
continue;
}
if (isset($conf_row['chiave']) && $conf_row['chiave'] == 'watermark_enable') {
$watermark_enable = $conf_row['valore'];
continue;
}
}
//add blog gallery if not added
$test = $GLOBALS['SITE_DB']->query_value_null_ok('galleries', 'name', array('name' => $row['autore'] . '_blog'));
if (is_null($test)) {
$rep_image = '';
//set default values for the watermark positions
$watermark_top_left = '';
$watermark_top_right = '';
$watermark_bottom_left = '';
$watermark_bottom_right = '';
if ($watermark_enable == 1 && strlen($watermark_image) > 0 && file_exists($watermark_image)) {
//$watermark_pos=2; //Possible values: 0 - Top-right; 1 - Center; 2 - Bottom-right (default for MKPortal)
if ($watermark_pos == 2) {
$watermark_top_right = $watermark_image;
} else {
$watermark_bottom_right = $watermark_image;
}
}
$add_date = $row['creato'];
ocf_over_msn();
add_gallery($row['autore'] . '_blog', $row['titolo'], html_to_comcode($row['descrizione']), '', '', $root_gallery, 1, 0, 0, 0, $rep_image, $watermark_top_left, $watermark_top_right, $watermark_bottom_left, $watermark_bottom_right, 1, 1, false, $add_date);
ocf_over_local();
}
$gal_idname = $row['autore'] . '_blog';
foreach ($blog_pimages as $blog_pimage) {
if (import_check_if_imported('blog_image', strval($blog_pimage['id']))) {
continue;
}
$submitter = $blog_pimage['iduser'];
ocf_over_msn();
//used to fixed the correct forum prefix
if (is_null($submitter)) {
$submitter = $GLOBALS['FORUM_DRIVER']->get_guest_id();
}
ocf_over_local();
//used to fixed the correct forum prefix
$id = get_param_integer('keep_preserve_ids', 0) == 0 ? NULL : $blog_pimage['id'];
$cat_name = $row['autore'] . '_blog';
ocf_over_msn();
$comment_text = $row['titolo'] . ' ' . html_to_comcode($row['descrizione']);
ocf_over_local();
//copy image and thumbnail and apply urls
$url = '';
$thumb_url = '';
//image source and destination
$save_filename = $old_base_dir . '/mkportal/blog/images/' . strval($blog_pimage['file']);
$copy_destination = $ocp_path . '/uploads/galleries/' . $blog_pimage['file'];
copy($save_filename, $copy_destination);
fix_permissions($copy_destination);
sync_file($copy_destination);
$url = get_custom_base_url() . '/uploads/galleries/' . $blog_pimage['file'];
$thumb_url = '';
$id_new = add_image('', $cat_name, $comment_text, $url, $url, $row['validate'], 1, 1, 1, '', $submitter, $row['creato'], $row['creato'], $row['click'], $id);
import_id_remap_put('blog_image', strval($blog_pimage['id']), $id_new);
}
}
}
//end import blog images
}
//end blog import
// Stories categories, story items, and comments
$cats = $db->query('SELECT * FROM ' . $table_prefix . 'news_sections');
$cat_id = array();
$image = 'general';
foreach ($cats as $cat) {
$cat_id[$cat['id']] = $this->get_news_category_id($cat['titolo'], $image);
}
$pinned_news_cat_id = $this->get_news_category_id(do_lang('PINNED_NEWS'), $image);
$rows = $db->query('SELECT * FROM ' . $table_prefix . 'news');
foreach ($rows as $row) {
if (import_check_if_imported('news', strval($row['id']))) {
continue;
}
$topic = array_key_exists($row['idcategoria'], $cat_id) ? $cat_id[$row['idcategoria']] : db_get_first_id();
$row['titolo'] = @html_entity_decode($row['titolo'], ENT_QUOTES, get_charset());
ocf_over_msn();
//used to fixed the correct forum prefix
if ($row['pinned'] == 1) {
$new_id = add_news($row['titolo'], '', $row['autore'], $row['validate'], 1, $com, 1, '', html_to_comcode($row['testo']), $topic, array($pinned_news_cat_id), $row['data'], $row['idautore']);
} else {
$new_id = add_news($row['titolo'], '', $row['autore'], $row['validate'], 1, $com, 1, '', html_to_comcode($row['testo']), $topic, array(), $row['data'], $row['idautore']);
}
ocf_over_local();
//used to fixed the correct forum prefix
import_id_remap_put('news', strval($row['id']), $new_id);
// Comments
$comments = $db->query('SELECT * FROM ' . $table_prefix . 'news_comments WHERE identry=' . strval($row['id']) . ' ORDER BY data');
if (!is_null($forum_id)) {
foreach ($comments as $comment) {
ocf_over_msn();
//used to fixed the correct forum prefix
$member = $GLOBALS['FORUM_DRIVER']->get_member_from_username($comment['autore']);
if (is_null($member)) {
$member = $GLOBALS['FORUM_DRIVER']->get_guest_id();
}
ocf_over_local();
//used to fixed the correct forum prefix
$title = '';
$post = $comment['testo'];
$content_url = build_url(array('page' => 'news', 'id' => $new_id, 'type' => 'view'), get_module_zone('news'));
ocf_over_msn();
//used to fixed the correct forum prefix
$GLOBALS['FORUM_DRIVER']->make_post_forum_topic($forum_name, 'news_' . strval($new_id), $member, $title, html_to_comcode($post), $row['titolo'], do_lang('COMMENT'), $content_url->evaluate());
ocf_over_local();
//used to fixed the correct forum prefix
}
}
}
}
}
$sco = round($d_scorpions2 - $d_scorpions);
if ($sco < 0) {
$sco = 0;
}
$cob = round($d_cobras2 - $d_cobras);
if ($cob < 0) {
$cob = 0;
}
if ($salvm < 0) {
$salvm = 0;
}
if ($salvc < 0) {
$salvc = 0;
}
add_news("Combat report", "<table border=\"1\" bordercolor=\"black\"><td>Defender(s) ({$nick} #{$id}):</td><td>Total:</td><td>Lost:</td><tr>\n\n<td>Soldiers:</td><td>{$d_infinitys2}</td><td>" . number_format($d_infinitys2 - $d_infinitys, 0) . "<tr>\n\n<td>Navy seal:</td><td>{$d_wraiths2}</td><td>" . number_format($d_wraiths2 - $d_wraiths, 0) . "<tr>\n\n<td>Warfrigates:</td><td>{$d_warfrigs2}</td><td>" . number_format($d_warfrigs2 - $d_warfrigs, 0) . "<tr>\n\n<td>Destroyers:</td><td>{$d_destroyers2}</td><td>" . number_format($d_destroyers2 - $d_destroyers, 0) . "<tr>\n\n<td>Anti thiefs:</td><td>{$d_cobras2}</td><td>" . number_format($d_cobras2 - $d_cobras, 0) . "<tr>\n\n<td>Thiefs:</td><td>{$d_astropods2}</td><td>" . number_format($d_astropods2 - $d_astropods, 0) . "<tr>\n\n<td>Scorpion:</td><td>{$d_scorpions2}</td><td>" . number_format($d_scorpions2 - $d_scorpions, 0) . "<tr>\n\n<td>Attacker(s):</td><tr>\n\n<td>Soldiers:</td><td>{$infinitys2}</td><td>" . number_format($infinitys2 - $infinitys, 0) . "<tr>\n\n<td>Navy seals:</td><td>{$wraiths2}</td><td>" . number_format($wraiths2 - $wraiths, 0) . "<tr>\n\n<td>Warfrigates:</td><td>{$warfrigs2}</td><td>" . number_format($warfrigs2 - $warfrigs, 0) . "<tr>\n\n<td>Destroyers:</td><td>{$destroyers2}</td><td>" . number_format($destroyers2 - $destroyers, 0) . "<tr>\n\n<td>Thiefs:</td><td>{$astropods2} ({$t_block} blocked)</td><td>" . number_format($astropods2 - $astropods, 0) . "<tr>\n\n<td>Scorpion:</td><td>{$scorpions2}</td><td>" . number_format($scorpions2 - $scorpions, 0) . "<tr>\n\n<td>Yours:</td><tr>\n\n<td>Soldiers:</td><td>" . $defend[$i]["infinitys"] . "</td><td>{$l_infinitys}<tr>\n\n<td>Navy seals:</td><td>" . $defend[$i]["wraiths"] . "</td><td>{$l_wraiths}<tr>\n\n<td>Warfrigates:</td><td>" . $defend[$i]["warfrigs"] . "</td><td>{$l_warfrigs}<tr>\n\n<td>Destroyers:</td><td>" . $defend[$i]["destroyers"] . "</td><td>{$l_destroyers}<tr>\n\n<td>Anti thief:</td><td>" . $defend[$i]["cobras"] . "</td><td>{$l_cobras}<tr>\n\n<td>Thiefs:</td><td>" . $defend[$i]["astropods"] . "</td><td>{$l_astropods}<tr>\n\n<td>Scorpion:</td><td>" . $defend[$i]["scorpions"] . "</td><td>{$l_scorpions}<tr>\n\n<td>Light cannons:</td><td>{$d_rcannons2}</td><td>" . number_format($d_rcannons2 - $d_rcannons, 0) . "<tr>\n\n<td>Advanced cannons:</td><td>{$d_avengers2}</td><td>" . number_format($d_avengers2 - $d_avengers, 0) . "<tr>\n\n<td>Hyper cannons:</td><td>{$d_lstalkers2}</td><td>" . number_format($d_lstalkers2 - $d_lstalkers, 0) . "<tr>\n\n<tr>\n<td>Silver salvage:</td><td>{$salvm}</td><tr>\n<td>Gold salvage:</td><td>{$salvc}</td><tr>\n<td>Roids loss:</td><tr>\n<td>Silver roids:</td><td>" . ($d_metalroid2 - $d_metalroid) . "/{$d_metalroid}</td><tr>\n<td>Gold roids:</td><td>" . ($d_crystalroid2 - $d_crystalroid) . "/{$d_crystalroid}</td><tr>\n<td>Undeveloped:</td><td>" . ($d_ui_roids2 - $d_ui_roids) . "/{$d_ui_roids}</td><tr>\n</table>\n\n", $defend[$i]["id"]);
/* $result3 = mysql_query("UPDATE ".$PA["table"]." SET infinitys=infinitys-$l_infinitys,wraiths=wraiths-$l_wraiths,warfrigs=warfrigs-$l_warfrigs,destroyers=destroyers-$l_destroyers,astropods=astropods-$l_astropods,scorpions=scorpions-$l_scorpions,cobras=cobras-$l_cobras,rcannons=rcannons-$l_rcannons,avengers=avengers-$l_avengers,lstalkers=lstalkers-$l_lstalkers,crystal=crystal+$salvc,metal=metal+$salvm WHERE id=".$defend[$i]["id"],$db); dbr(mysql_error());
$result3 = mysql_query("UPDATE ".$PA["table"]." SET infinitys=infinitys-$inf,wraiths=wraiths-$wra,warfrigs=warfrigs-$war,destroyers=destroyers-$des,astropods=astropods-$ast,scorpions=scorpions-$sco,cobras=cobras-$cob,rcannons=rcannons-$l_rcannons,avengers=avengers-$l_avengers,lstalkers=lstalkers-$l_lstalkers,crystal=crystal+$salvc,metal=metal+$salvm WHERE id=".$defend[$i]["id"],$db); dbr(mysql_error());*/
$result3 = mysql_query("UPDATE " . $PA["table"] . " SET infinitys=infinitys-{$l_infinitys},wraiths=wraiths-{$l_wraiths},warfrigs=warfrigs-{$l_warfrigs},destroyers=destroyers-{$l_destroyers},astropods=astropods-{$l_astropods},scorpions=scorpions-{$l_scorpions},cobras=cobras-{$l_cobras},crystal=crystal+{$salvc},metal=metal+{$salvm} WHERE id=" . $defend[$i]["id"], $db);
dbr(mysql_error());
$result3 = mysql_query("UPDATE " . $PA["table"] . " SET infinitys_base=infinitys_base-{$inf},wraiths_base=wraiths_base-{$wra},warfrigs_base=warfrigs_base-{$war},destroyers_base=destroyers_base-{$des},astropods_base=astropods_base-{$ast},scorpions_base=scorpions_base-{$sco} WHERE id=" . $defend[0]["id"], $db);
dbr(mysql_error());
/*$result3 = mysql_query("UPDATE ".$PA["table"]." SET infinitys_base=infinitys_base-$l_infinitys,wraiths_base=wraiths_base-$l_wraiths,warfrigs_base=warfrigs_base-$l_warfrigs,destroyers_base=destroyers_base-$l_destroyers,astropods_base=astropods_base-$l_astropods,scorpions_base=scorpions-$l_scorpions WHERE id=".$defend[$i]["id"],$db); dbr(mysql_error());*/
$result3 = mysql_query("UPDATE " . $PA["table"] . " SET infinitys_base=0 where infinitys_base < 0 AND id=" . $defend[$i]["id"], $db);
dbr(mysql_error());
$result3 = mysql_query("UPDATE " . $PA["table"] . " SET cobras=0 where cobras < 0 AND id=" . $defend[$i]["id"], $db);
dbr(mysql_error());
$result3 = mysql_query("UPDATE " . $PA["table"] . " SET wraiths=0 where wraiths < 0 AND id=" . $defend[$i]["id"], $db);
dbr(mysql_error());
$result3 = mysql_query("UPDATE " . $PA["table"] . " SET wraiths_base=0 where wraiths_base < 0 AND id=" . $defend[$i]["id"], $db);
/**
* Import wordpress db
*/
function import_wordpress_db()
{
disable_php_memory_limit();
$data = get_wordpress_data();
$is_validated = post_param_integer('wp_auto_validate', 0);
$to_own_account = post_param_integer('wp_add_to_own', 0);
// Create members
require_code('ocf_members_action');
require_code('ocf_groups');
$def_grp_id = get_first_default_group();
$cat_id = array();
$NEWS_CATS = $GLOBALS['SITE_DB']->query_select('news_categories', array('*'), array('nc_owner' => NULL));
$NEWS_CATS = list_to_map('id', $NEWS_CATS);
foreach ($data as $values) {
if (get_forum_type() == 'ocf') {
$member_id = $GLOBALS['FORUM_DB']->query_value_null_ok('f_members', 'id', array('m_username' => $values['user_login']));
if (is_null($member_id)) {
if (post_param_integer('wp_import_wordpress_users', 0) == 1) {
$member_id = ocf_make_member($values['user_login'], $values['user_pass'], '', NULL, NULL, NULL, NULL, array(), NULL, $def_grp_id, 1, time(), time(), '', NULL, '', 0, 0, 1, '', '', '', 1, 0, '', 1, 1, '', NULL, '', false, 'wordpress');
} else {
$member_id = $GLOBALS['FORUM_DRIVER']->get_member_from_username('admin');
// Set admin as owner
if (is_null($member_id)) {
$member_id = $GLOBALS['FORUM_DRIVER']->get_guest_id() + 1;
}
}
}
} else {
$member_id = $GLOBALS['FORUM_DRIVER']->get_guest_id();
}
// Guest user
// If post should go to own account
if ($to_own_account == 1) {
$member_id = get_member();
}
if (array_key_exists('POSTS', $values)) {
// Create posts in blog
foreach ($values['POSTS'] as $post_id => $post) {
if (array_key_exists('category', $post)) {
$cat_id = array();
foreach ($post['category'] as $cat_code => $category) {
$cat_code = NULL;
if ($category == 'Uncategorized') {
continue;
}
// Skip blank category creation
foreach ($NEWS_CATS as $id => $existing_cat) {
if (get_translated_text($existing_cat['nc_title']) == $category) {
$cat_code = $id;
}
}
if (is_null($cat_code)) {
$cat_code = add_news_category($category, 'newscats/community', $category);
$NEWS_CATS = $GLOBALS['SITE_DB']->query_select('news_categories', array('*'));
$NEWS_CATS = list_to_map('id', $NEWS_CATS);
}
$cat_id = array_merge($cat_id, array($cat_code));
}
}
$owner_category_id = $GLOBALS['SITE_DB']->query_value_null_ok('news_categories', 'id', array('nc_owner' => $member_id));
if ($post['post_type'] == 'post') {
$id = add_news($post['post_title'], html_to_comcode($post['post_content']), NULL, $is_validated, 1, $post['comment_status'] == 'closed' ? 0 : 1, 1, '', html_to_comcode($post['post_content']), $owner_category_id, $cat_id, NULL, $member_id, 0, time(), NULL, '');
} elseif ($post['post_type'] == 'page') {
// If dont have permission to write comcode page, skip the post
if (!has_submit_permission('high', get_member(), get_ip_address(), NULL, NULL)) {
continue;
}
require_code('comcode');
// Save articles as new comcode pages
$zone = filter_naughty(post_param('zone', 'site'));
$lang = filter_naughty(post_param('lang', 'EN'));
$file = preg_replace('/[^A-Za-z0-9]/', '_', $post['post_title']);
// Filter non alphanumeric charactors
$parent_page = post_param('parent_page', '');
$fullpath = zone_black_magic_filterer(get_custom_file_base() . '/' . $zone . '/pages/comcode_custom/' . $lang . '/' . $file . '.txt');
// Check existancy of new page
$submiter = $GLOBALS['SITE_DB']->query_value_null_ok('comcode_pages', 'p_submitter', array('the_zone' => $zone, 'the_page' => $file));
if (!is_null($submiter)) {
continue;
}
// Skip existing titled articles - may need change
require_code('submit');
give_submit_points('COMCODE_PAGE_ADD');
if (!addon_installed('unvalidated')) {
$is_validated = 1;
}
$GLOBALS['SITE_DB']->query_insert('comcode_pages', array('the_zone' => $zone, 'the_page' => $file, 'p_parent_page' => $parent_page, 'p_validated' => $is_validated, 'p_edit_date' => NULL, 'p_add_date' => strtotime($post['post_date']), 'p_submitter' => $member_id, 'p_show_as_edit' => 0));
if (!file_exists($fullpath)) {
$_content = html_to_comcode($post['post_content']);
$myfile = @fopen($fullpath, 'wt');
if ($myfile === false) {
intelligent_write_error($fullpath);
}
if (fwrite($myfile, $_content) < strlen($_content)) {
warn_exit(do_lang_tempcode('COULD_NOT_SAVE_FILE'));
}
fclose($myfile);
sync_file($fullpath);
}
require_code('seo2');
seo_meta_set_for_explicit('comcode_page', $zone . ':' . $file, post_param('meta_keywords', ''), post_param('meta_description', ''));
require_code('permissions2');
set_page_permissions_from_environment($zone, $file);
}
$content_url = build_url(array('page' => 'news', 'type' => 'view', 'id' => $id), get_module_zone('news'), NULL, false, false, true);
$content_title = $post['post_title'];
// Add comments
if (post_param_integer('wp_import_blog_comments', 0) == 1) {
if (array_key_exists('COMMENTS', $post)) {
$submitter = NULL;
foreach ($post['COMMENTS'] as $comment) {
$submitter = $GLOBALS['FORUM_DB']->query_value_null_ok('f_members', 'id', array('m_username' => $comment['comment_author']));
if (is_null($submitter)) {
$submitter = $GLOBALS['FORUM_DRIVER']->get_guest_id();
}
// If comment is made by a non-member, assign comment to guest account
$forum = is_null(get_value('comment_forum__news')) ? get_option('comments_forum_name') : get_value('comment_forum__news');
$result = $GLOBALS['FORUM_DRIVER']->make_post_forum_topic($forum, 'news_' . strval($id), $submitter, $post['post_title'], $comment['comment_content'], $content_title, do_lang('COMMENT'), $content_url, NULL, NULL, 1, 1, false);
}
}
}
}
}
}
}
/**
* Standard import function.
*
* @param object The DB connection to import from
* @param string The table prefix the target prefix is using
* @param PATH The base directory we are importing from
*/
function import_news_and_categories($db, $table_prefix, $old_base_dir)
{
require_code('news');
$com = 0;
// we cannot comment the news
//get AEF news
$rows = $db->query('SELECT * FROM ' . $table_prefix . 'news');
foreach ($rows as $row) {
$author_data = $db->query('SELECT username FROM ' . $table_prefix . 'users WHERE id=' . strval($row['uid']));
$author_name = isset($author_data[0]['username']) && $author_data[0]['username'] != '' ? $author_data[0]['username'] : '';
$append = '';
$topic = db_get_first_id();
//there is no news topic/category specified in AEF
ocf_over_msn();
//set the proper forum driver FORUM_DB
$news = html_to_comcode($row['news']) . $append;
ocf_over_local();
//return the OCF FORUM_DB
$new_id = add_news($row['title'], $row['news'], $author_name, $row['approved'], $com, 1, 1, 'Full story: ' . $row['fullstorylink'], $news, $topic, array(), $row['time'], get_member(), 0, NULL, NULL, $row['image']);
}
}
if (isset($_GET['token']) && $_GET['token'] == $_SESSION['token']) {
echo manage($pdo);
}
}
break;
case 'add_source':
if (isset($_SESSION['login']) && isset($_SESSION['permission']) && $_SESSION['permission'] == 'admin' && validRequest()) {
if (isset($_GET['token']) && $_GET['token'] == $_SESSION['token']) {
echo add_source();
}
}
break;
case 'add_news':
if (isset($_SESSION['login']) && isset($_SESSION['permission']) && $_SESSION['permission'] == 'admin' && validRequest()) {
if (isset($_GET['token']) && $_GET['token'] == $_SESSION['token']) {
echo add_news($pdo);
}
}
break;
case 'save_source':
if (isset($_SESSION['login']) && isset($_SESSION['permission']) && $_SESSION['permission'] == 'admin' && validRequest()) {
if (isset($_GET['token']) && $_GET['token'] == $_SESSION['token']) {
save_source($pdo);
}
}
break;
case 'edit_source':
if (isset($_SESSION['login']) && isset($_SESSION['permission']) && $_SESSION['permission'] == 'admin' && validRequest()) {
if (isset($_GET['token']) && $_GET['token'] == $_SESSION['token']) {
echo edit_source($pdo);
}
$offset = getvalescaped("offset", 0);
$findtext = getvalescaped("findtext", "");
$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;
$ref=getvalescaped("ref","",true);
$offset=getvalescaped("offset",0);
$findtext=getvalescaped("findtext","");
$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);}
header("location:".$baseurl."/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 echo $lang["news_manage"]?></a></p>
<div class="BasicsBox">
<h1><?php echo $lang["news_edit"]?></h1>
<form method=post id="mainform">
