function CreateGroup($user) { if (isset($_POST["group_title"])) { $title = escape($_POST["group_title"]); $body = escape($_POST["group_body"]); if (isset($_POST["group_private"])) { $is_private = 1; } else { $is_private = 0; } $time = time(); $query = "INSERT INTO groups (group_name,description,owner_id,time,is_private)"; $query .= " VALUES ('{$title}','{$body}',{$user},{$time},{$is_private})"; query($query); //tag processor $tags = escape($_POST["group_tags"]); if (!empty($tags)) { $query = "SELECT group_id FROM groups WHERE time= {$time}"; //getting id of last added post $result = query($query); $row = mysqli_fetch_array($result); AddTag($tags, $row["group_id"], "group"); } ?> <div class="alert alert-success alert-dismissible fade in"> <button type="button" class="close" data-dismiss="alert">×</button> <span class="glyphicon glyphicon-ok glyphicon-pad"></span> Group successfully created! </div> <?php } }
/** * Copy URL to TAGS */ function CopyUrlToTags($f_iUrlId, $f_szTags = "") { if (empty($f_szTags)) { exit('No tags, no copy!'); } global $db; $arrTags = unaliasTags(explode(" ", str_replace('/', ' ', str_replace('+', ' ', valid_tags($f_szTags))))); $iUrlId = (int) $f_iUrlId; $iAdded = 0; foreach ($arrTags as $szTag) { // Add tag $iTagId = AddTag($szTag); // Insert relation $arrInsert = array('url_id' => $iUrlId, 'tag_id' => $iTagId, 'utc_added' => time()); try { $iAdded += (int) $db->insert('l_links', $arrInsert); } catch (db_exception $ex) { } } exit('OK' . $iAdded); }
/** * Add a LINK between TAGS and a URL */ function _AddLink($f_szUrl, $f_szTitle, $f_szTags) { global $db; $szUrl = trim($f_szUrl); $arrTags = unaliasTags(explode(' ', str_replace('/', ' ', valid_tags($f_szTags)))); $szTitle = trim($f_szTitle); if (!$arrTags || !$szUrl) { return 'ERROR:' . __LINE__; } // Add url $iUrlId = AddUrl($szUrl, $szTitle); foreach ($arrTags as $szTag) { // Add tag $iTagId = AddTag($szTag); // Insert relation try { $db->insert('l_links', array('url_id' => $iUrlId, 'tag_id' => $iTagId, 'utc_added' => time())); } catch (db_exception $ex) { } } return 'OK'; }
<?php require_once "../../includes/header.php"; ?> <div class="container"> <h1 class="page-header"><span class="glyphicon glyphicon-sort-by-alphabet glyphicon-pad"></span> Survey Format</h1> <?php require_once "../../includes/breadcrumb.php"; $title = $_POST["survey_title"]; $body = $_POST["survey_body"]; $time = time(); $query = "INSERT INTO survey VALUES (NULL,'{$title}','{$body}',{$USERID},{$time},0)"; query($query); $survey_key = GetDbId(); //tag processor $tags = $_POST["survey_tags"]; AddTag($tags, $survey_key, "survey"); ?> <div class="row clearfix"> <div class="col-lg-10 col-lg-offset-1 col-md-10 col-md-offset-1 col-sm-10 col-sm-offset-1"> <form action="/survey/create/content/?id=<?php echo $survey_key; ?> " method="post" class="form-horizontal"> <div class="form-group"> <label for="survey_mcq_no" class="col-sm-2 control-label">MCQ(s)</label> <div class="col-sm-10"> <input type="number" class="form-control" name="survey_mcq_no" id="survey_mcq_no" min="1" placeholder="4"> </div> </div> <div class="form-group"> <label for="survey_option_no" class="col-sm-2 control-label">Options per MCQ</label>
function ExportPosts() { global $wpdb, $from; $urlmap = turlmap::i(); $urlmap->lock(); $posts = tposts::i(); $posts->lock(); if (dbversion) { $r = $wpdb->get_results("SELECT max(ID) as autoid FROM {$wpdb->posts} "); $autoid = (int) $r[0]->autoid; echo "{$autoid} = auto id posts\n"; $posts->db->exec(sprintf('ALTER TABLE %s AUTO_INCREMENT = %d', $posts->thistable, $autoid)); } $categories = tcategories::i(); $categories->loadall(); $categories->lock(); $tags = ttags::i(); $tags->loadall(); $tags->lock(); if ($from == 0) { echo "import categories\n"; ExportCategories(); echo "import pages\n"; ExportPages(); } $cron = tcron::i(); $cron->disableadd = true; //$list = $wpdb->get_results("SELECT * FROM $wpdb->posts WHERE post_type = 'post'"); $list = $wpdb->get_results("SELECT ID FROM {$wpdb->posts} \r\nWHERE post_type = 'post'\r\nand ID > {$from}\r\nlimit 500\r\n"); echo count($list), " = countposts\n"; foreach ($list as $index => $idresult) { //$itemres= $wpdb->get_results("SELECT * FROM $wpdb->posts WHERE ID = $idresult"); $itemres = $wpdb->get_results("SELECT * FROM {$wpdb->posts} WHERE ID = {$idresult->ID}"); $item =& $itemres[0]; $post = new tpost(); $post->id = (int) $item->ID; echo $post->id, " = id post\n"; $post->posted = strtotime(mysql2date('Ymd\\TH:i:s', $item->post_date)); $post->title = $item->post_title; $post->categories = wp_get_post_categories($item->ID); $taglist = array(); $wptags = wp_get_post_tags($item->ID); foreach ($wptags as $wptag) { AddTag($tags, (int) $wptag->term_id, 0, $wptag->name, get_tag_link($wptag->term_id)); $taglist[] = (int) $wptag->term_id; } $post->tags = $taglist; $UrlArray = parse_url(@get_permalink($item->ID)); $url = $UrlArray['path']; if (!empty($UrlArray['query'])) { $url .= '?' . $UrlArray['query']; } $post->url = $url; $post->idurl = litepublisher::$urlmap->add($post->url, get_class($post), $post->id); $post->content = $item->post_content; $post->commentsenabled = 'open' == $item->comment_status; $post->pingenabled = 'open' == $item->ping_status; $post->password = $item->post_password; $post->status = $item->post_status == 'publish' ? 'published' : 'draft'; savepost($post); $categories->itemsposts->setitems($post->id, $post->categories); $tags->itemsposts->setitems($post->id, $post->tags); ExportComments($post); $post->free(); } $cron->unlock(); //$CommentManager->SubscribtionEnabled = true; //$CommentManager->NotifyModerator = true; $tags->unlock(); $categories->unlock(); $posts->UpdateArchives(); $posts->addrevision(); $posts->unlock(); $urlmap->clearcache(); $arch = tarchives::i(); $arch->postschanged(); $urlmap->unlock(); if (count($list) < 500) { return false; } return $item->ID; }
$db->rollback(); exit('<pre>' . $ex . '</pre>'); } } $db->commit(); header('Location: aliases.php?_' . rand(0, 999)); } exit; } else { if (isset($_POST['from'], $_POST['to'])) { $from = $_POST['from']; $to = $_POST['to']; $message = ''; $fromTagId = $db->select_one('l_tags', 'id', array('tag' => $from)); if ($fromTagId) { $toTagId = AddTag($to); $db->begin(); try { // Copy links $db->execute('INSERT INTO l_links SELECT url_id, ?, `utc_added` FROM l_links l WHERE tag_id = ? AND NOT EXISTS (SELECT * FROM l_links WHERE url_id = l.url_id AND tag_id = ?)', array($toTagId, $fromTagId, $toTagId)); $movedTags = $db->affected_rows(); // Delete old links $db->execute('DELETE FROM l_links WHERE tag_id = ?', array($fromTagId)); // Delete old tag $db->execute('DELETE FROM l_tags WHERE id = ?', array($fromTagId)); $db->commit(); $message = 'Moved+' . $movedTags . '+tags'; // Add alias try { $db->insert('l_aliases', array('alias' => $from, 'tag_id' => $toTagId)); } catch (db_exception $ex) {