$extattr .= "AND cast(ausg_product_price.price AS DECIMAL(10,2)) BETWEEN '{$_POST['product_price_from']}' AND '{$_POST['product_price_to']}'";
}
//Filter Status
if (isset($_POST['product_status']) && $_POST['product_status'] != "") {
    $extattr .= " AND " . POST . ".status = '{$_POST['product_status']}'";
}
$rs_vw = "SELECT " . POST . ".slno AS pid FROM  " . POST . "," . POST_CATEGORY . " WHERE \n        " . POST . ".slno=" . POST_CATEGORY . ".post_id AND\n        " . POST . ".status!='deleted' {$extattr}  GROUP BY " . POST . ".slno";
$resd = mysql_query($rs_vw);
$resultu = mysql_query($rs_vw . " LIMIT {$_POST['iDisplayStart']},{$_POST['iDisplayLength']}");
?>
{"aaData":[

<?php 
$i = 1;
while ($data1 = mysql_fetch_array($resultu)) {
    $data = get_the_post($data1['pid']);
    $views = $data['views'];
    $comments = $data['comments'];
    $catarr = get_cat_arr_name($data['slno']);
    $catstr = implode(", ", $catarr);
    if ($i != 1) {
        echo ",";
    }
    ?>
[
"<input type='checkbox' name='id[]' value='<?php 
    echo $data['slno'];
    ?>
'>",
<?php 
    echo $data['slno'];
<?php

include "config/config.php";
include "admin/include/function.php";
include "include/post-templete.php";
sleep(1);
$start = $_GET["start"];
$limit = $_GET["limit"];
$extsql = "";
if ($_GET["category"] != "0") {
    $extsql .= " AND `" . POST . "`.`slno`=`" . POST_CATEGORY . "`.`post_id` ";
    $extsql .= " AND `" . POST_CATEGORY . "`.`category_id`='{$_GET['category']}'";
}
if ($_GET["search"] != "0") {
    $extsql .= " AND `" . POST . "`.`name` LIKE '%{$_GET['search']}%'";
}
$sql = "SELECT `" . POST . "`.`slno` AS 'slno' FROM `" . POST . "`,`mchp_post_to_categories` \n     WHERE `" . POST . "`.`status`='publish' AND `" . POST . "`.`verified`='yes' {$extsql}\n     GROUP BY `" . POST . "`.`slno` \n     ORDER BY `" . POST . "`.`slno` DESC \n     LIMIT {$start},{$limit}";
$result = mysql_query($sql);
while ($data = mysql_fetch_array($result)) {
    $posrarr = get_the_post($data["slno"]);
    show_post($data["slno"]);
}
if (!mysql_num_rows($result)) {
    echo "0";
}
Пример #3
0
													
													<div class="col-md-12">
                                                                                                           <?php 
$products = explode(",", $productarr['suggestive_products']);
?>
                                                                                                            <select multiple="multiple" class="multi-select" id="my_multi_select11" name="my_multi_select11[]" onchange="selectval()" >
                                                                                                                            <?php 
$catsxarr = array();
$resultxx = mysql_query("SELECT * FROM `" . POST_CATEGORY . "` WHERE `post_id`='{$_GET['id']}'");
while ($datax1 = mysql_fetch_array($resultxx)) {
    array_push($catsxarr, $datax1['category_id']);
}
$catsxarr = implode(",", $catsxarr);
$result = mysql_query("SELECT " . POST_CATEGORY . ".post_id AS pid  FROM " . POST . "," . POST_CATEGORY . " WHERE " . POST . ".slno=" . POST_CATEGORY . ".post_id AND  " . POST_CATEGORY . ".category_id IN ({$catsxarr}) AND " . POST . ".slno='{$_GET['id']}' GROUP BY " . POST_CATEGORY . ".post_id");
while ($data = mysql_fetch_array($result)) {
    $parrx = get_the_post($data['pid']);
    ?>
                                                                                                                            <option value="<?php 
    echo $parrx['slno'];
    ?>
"  <?php 
    if (in_array($parrx['slno'], $products)) {
        echo "selected";
    }
    ?>
><?php 
    echo $parrx['name'];
    ?>
</option>
                                                                                                                            <?php 
}
Пример #4
0
        $format = "2";
    }
    if (isset($_GET["format3"])) {
        $format = "3";
    }
    if (isset($_GET["format4"])) {
        $format = "4";
    }
    if (isset($_GET["format5"])) {
        $format = "5";
    }
} else {
    $format = "1";
}
if (isset($_GET["edit"])) {
    $editpostarr = get_the_post($_GET["edit"]);
    if ($editpostarr["type"] == "standard") {
        $format = "1";
    }
    if ($editpostarr["type"] == "link") {
        $format = "5";
    }
    if ($editpostarr["type"] == "video") {
        $format = "2";
    }
    if ($editpostarr["type"] == "gallery") {
        $format = "3";
    }
}
$fedit = isset($_GET["edit"]) ? TRUE : FALSE;
if (isset($_POST['post_gallery'])) {
Пример #5
0
function savePosts($status)
{
    $dataSet = array();
    while (have_posts()) {
        the_post();
        $text = get_the_excerpt();
        $htmlText = $text == "" ? get_the_post() : $text;
        $singleData = new stdClass();
        $singleData->status = $status;
        $singleData->title = get_the_title();
        $singleData->htmlText = $htmlText;
        $singleData->url = get_the_permalink();
        $singleData->hasUrl = true;
        $singleData->imageLocation = "img/cd-icon-location.svg";
        $dataSet['id' . get_the_ID()] = $singleData;
    }
    return $dataSet;
}
Пример #6
0
include "config/config.php";
include "admin/include/function.php";
include "include/common-scripts.php";
global $postid;
$postid = post_name_to_id($_GET["post"]);
$posturl = (isset($_SERVER['HTTPS']) ? "https" : "http") . "://{$_SERVER['HTTP_HOST']}{$_SERVER['REQUEST_URI']}";
if (isset($_POST["add_comment"])) {
    $name = mysql_real_escape_string(stripcslashes($_POST["name"]));
    $email = mysql_real_escape_string(stripcslashes($_POST["email"]));
    $message = mysql_real_escape_string(stripcslashes($_POST["message"]));
    $parent = mysql_real_escape_string(stripcslashes($_POST["parent"]));
    $form_data = array('post_id' => $postid, 'parent' => $parent, 'user_id' => $_SESSION["userid"], 'name' => $name, 'email' => $email, 'message' => $message, 'date' => date("Y-m-d H:i:s"), 'status' => "active");
    InsertData(POST_COMMENT, $form_data);
    header("location:{$posturl}?success");
}
$posrarr = get_the_post($postid);
$postuser = get_the_user($posrarr["userid"]);
html("START");
?>
<!-- BEGIN HEAD -->
<head>
<?php 
common_head("META");
put_seo(array("title" => $posrarr["name"], "desc" => "", "author" => "", "keywords" => "", "image" => ""));
common_style("MANDATORY_STYLES");
page_style("POST");
common_style("THEME_STYLES");
common_head("FAVICON");
?>
    
<?php 
Пример #7
0
function show_post($postid)
{
    $posrarr = get_the_post($postid);
    $postuser = get_the_user($posrarr["userid"]);
    //$posrarr["type"]="rss";
    ?>
<!--Post Header Start----> 
<div class="portlet light ">
    <?php 
    if ($posrarr["type"] != "rss") {
        ?>
    <div class="portlet-title">
            <div class="caption custom-caption-1">
                    <span class="caption-subject bold font-grey-gallery ">
                        
                        <img class="user-pic border-radius-100" src="<?php 
        echo BASEURL;
        ?>
croplive.php?url=<?php 
        echo get_user_thumb($posrarr["userid"]);
        ?>
&size=41">    
                        <?php 
        echo get_user_meta($posrarr["userid"], "display_name");
        ?>
                        <small><br><?php 
        echo get_user_meta($posrarr["userid"], "occupation");
        ?>
</small>
                        
                    </span>

            </div>
            <div class="tools">
                <?php 
        if ($posrarr["userid"] != $_SESSION["userid"]) {
            ?>
                <button 
                    type="button" 
                    class="btn btn-circle btn-default custom-button-1 tooltips"
                    href="ajax-send-msg-html.php?from=<?php 
            echo $_SESSION["userid"];
            ?>
&to=<?php 
            echo $posrarr["userid"];
            ?>
" 
                    data-target="#model_send_msg" 
                    data-toggle="modal"
                    >
                    <i class="icon-envelope"></i>
                    <span>Send Message</span>
                </button>
                <?php 
            if (!is_follow($_SESSION["userid"], $posrarr["userid"])) {
                ?>
                <button type="button" class="btn btn-circle btn-default custom-button-1 tooltips" onclick="dofollow(<?php 
                echo $_SESSION["userid"];
                ?>
,<?php 
                echo $posrarr["userid"];
                ?>
,$(this))"><i class="icon-user-follow"></i><span>Follow <?php 
                echo get_user_meta($posrarr["userid"], "display_name");
                ?>
</span></button>
                <?php 
            } else {
                ?>
                <button type="button" class="btn btn-circle btn-default custom-button-1 tooltips" onclick="dofollow(<?php 
                echo $_SESSION["userid"];
                ?>
,<?php 
                echo $posrarr["userid"];
                ?>
,$(this))"><i class="icon-user-following"></i><span>Follow <?php 
                echo get_user_meta($posrarr["userid"], "display_name");
                ?>
</span></button>
                <?php 
            }
            ?>
                
                
               
                <?php 
        } else {
            ?>
                <div class="btn-group hidden">
                        <button class="btn btn-circle green-haze btn-sm dropdown-toggle" type="button" data-toggle="dropdown" data-hover="dropdown" data-close-others="true">
                        Actions <i class="fa fa-angle-down"></i>
                        </button>
                        <ul class="dropdown-menu pull-right" role="menu">
                                <li>
                                        <a href="javascript:;">Unpublish </a>
                                </li>
                                <li>
                                        <a href="javascript:;">Edit Post </a>
                                </li>
                                <li>
                                        <a href="javascript:;">Delete Psot </a>
                                </li>
                        </ul>
                </div>
                <?php 
        }
        ?>
            </div>
    </div>
    <?php 
    }
    ?>
    <div class="portlet-body blog-<?php 
    echo $posrarr["type"];
    ?>
">
        <div class="row">
<!--Post Header End---->     
    
<?php 
    if ($posrarr["type"] == "standard") {
        ?>
 
<!--Starndard post start----> 

            <div class="col-md-5 blog-img blog-tag-data">
                    <img src="<?php 
        echo BASEURL;
        ?>
images/featured_image/<?php 
        echo $posrarr["image"];
        ?>
" alt="" class="img-responsive">

            </div>
            <div class="col-md-7 blog-article">
                    <h3>
                    <a href="<?php 
        echo BASEURL;
        ?>
post/<?php 
        echo $posrarr["parmalink"];
        ?>
"  class="substr">
                    <?php 
        echo $posrarr["name"];
        ?>
</a>
                    </h3>
                    <p>
                      <?php 
        if (trim($posrarr["short_description"]) == "") {
            echo string_sorter(strip_tags($posrarr["description"]), 460);
        } else {
            echo nl2br(string_sorter(strip_tags($posrarr["short_description"]), 460));
        }
        ?>
                    </p>
            </div>
            
<!--Starndard post end---->    
<?php 
    }
    if ($posrarr["type"] == "video") {
        ?>
 
<!--Video post start----> 
            <div class="col-md-12 col-sm-8 col-md-offset-0 col-sm-offset-2 blog-img blog-tag-data">
                    <img src="<?php 
        echo $posrarr["image"];
        ?>
" alt="" class="img-responsive">
                    <div class="videofrm">
                        <img src="<?php 
        echo BASEURL;
        ?>
images/play_icon.png" />
                    </div>
            </div>
            <div class="col-md-12 blog-article">
                    <h3>
                    <a href="<?php 
        echo BASEURL;
        ?>
post/<?php 
        echo $posrarr["parmalink"];
        ?>
"  class="substr">
                    <?php 
        echo $posrarr["name"];
        ?>
</a>
                    </h3>
                    <p>
                      <?php 
        if (trim($posrarr["short_description"]) == "") {
            echo string_sorter(strip_tags($posrarr["description"]), 460);
        } else {
            echo nl2br(string_sorter(strip_tags($posrarr["short_description"]), 460));
        }
        ?>
                    </p>
            </div>
            
<!--Video post end---->    
<?php 
    }
    if ($posrarr["type"] == "link") {
        ?>
 
<!--Link post start----> 
    <div class="col-md-12 newscover">
        <div class="row">
            <?php 
        $desccol = 12;
        if (trim($posrarr["image"]) != "") {
            ?>
            <div class="col-md-5 col-sm-5 col-xs-5 blog-img blog-tag-data">
                    <img src="<?php 
            echo $posrarr["image"];
            ?>
" alt="" class="img-responsive">

            </div>
            <?php 
            $desccol = 7;
        }
        ?>
            <div class="col-md-<?php 
        echo $desccol;
        ?>
 col-sm-<?php 
        echo $desccol;
        ?>
 col-xs-<?php 
        echo $desccol;
        ?>
 blog-article">
                    <h3>
                    <a href="<?php 
        echo BASEURL;
        ?>
post/<?php 
        echo $posrarr["parmalink"];
        ?>
"  class="substr">
                    <?php 
        echo $posrarr["name"];
        ?>
</a>
                    </h3>
                    <p>
                      <?php 
        if (trim($posrarr["short_description"]) == "") {
            echo string_sorter(strip_tags($posrarr["description"]), 160);
        } else {
            echo nl2br(string_sorter(strip_tags($posrarr["short_description"]), 160));
        }
        ?>
                    </p>
                    <p class="font-grey-cascade">
                        <?php 
        $imgmeta = get_post_meta($postid, "source_url");
        $urlarr = parse_url($imgmeta);
        echo $urlarr["host"];
        ?>
                    </p>
            </div>
        </div>
    </div>
<!--Link post end---->      
<?php 
    }
    if ($posrarr["type"] == "gallery") {
        ?>
 
<!--Gallery post start----> 
            <div class="col-md-2 col-sm-2 col-xs-2 text-center">
                    <a class="btn btn-circle btn-default control-left" href="#blog-gallery<?php 
        echo $postid;
        ?>
" role="button" data-slide="prev">
                      <i class="fa fa-angle-left"></i>
                    </a>
            </div>
            <div class="col-md-8 col-sm-8 col-xs-8 blog-img blog-tag-data">
                
                
                
                    <div id="blog-gallery<?php 
        echo $postid;
        ?>
" class="carousel slide" data-ride="carousel">
                        <!-- Wrapper for slides -->
                        <div class="carousel-inner" role="listbox">
                          <?php 
        $imgmeta = get_post_meta($postid, "imgdata");
        $imgmetaarr = explode("[/]", $imgmeta);
        $arr1 = explode("[:]", $imgmetaarr[0]);
        $arr2 = explode("[:]", $imgmetaarr[1]);
        $arr3 = explode("[:]", $imgmetaarr[2]);
        ?>
  
                          <?php 
        for ($i = 0; $i < count($arr1); $i++) {
            ?>
  
                          <div class="item <?php 
            if (!$i) {
                echo "active";
            }
            ?>
">
                            <img src="<?php 
            echo BASEURL;
            ?>
croplive.php?url=images/gallery_post/<?php 
            echo $arr1[$i];
            ?>
&size=500" alt="...">
                            <div class="carousel-caption">
                                <h2><?php 
            echo $arr2[$i];
            ?>
</h2>
                                <p><?php 
            echo string_sorter($arr3[$i], 130);
            ?>
</p>
                            </div>
                          </div>
                          <?php 
        }
        ?>
                        </div>
                      </div>
            </div>
            <div class="col-md-2 col-sm-2 col-xs-2 text-center">
                 <a class="btn btn-circle btn-default control-right" href="#blog-gallery<?php 
        echo $postid;
        ?>
" role="button" data-slide="next">
                     <i class="fa fa-angle-right"></i>
                </a>  
            </div>
            <div class="col-md-12 blog-article">
                    <h3>
                    <a href="<?php 
        echo BASEURL;
        ?>
post/<?php 
        echo $posrarr["parmalink"];
        ?>
"  class="substr">
                    <?php 
        echo $posrarr["name"];
        ?>
</a>
                    </h3>
                    <p>
                      <?php 
        if (trim($posrarr["short_description"]) == "") {
            echo substr(strip_tags($posrarr["description"]), 0, 460);
        } else {
            echo nl2br(substr(strip_tags($posrarr["short_description"]), 0, 460));
        }
        ?>
                    </p>
            </div>
<!--Gallery post end---->    
<?php 
    }
    if ($posrarr["type"] == "rss") {
        ?>
<!--RSS post start----> 
<div class="col-md-12 margin-bottom-10 ">
    <div class="rss-news clearfix">
      <h2 class="no-margin"><?php 
        echo $posrarr["name"];
        ?>
</h2>
      <div class="feeds-div scroller">
      <?php 
        $resfeed = mysql_query("SELECT * FROM `" . POST_META . "` WHERE `post_id`='{$postid}' AND `meta_name`='feed'");
        while ($feed = mysql_fetch_array($resfeed)) {
            $feeddata = $feed["meta_desc"];
            $feedarr = explode("[:]", $feeddata);
            ?>
      <div class="media media-feed list-group-item">
            <a class="pull-left" href="javascript:;">
                <img class="media-object" src="<?php 
            echo $feedarr[3];
            ?>
" style="width: 80px; height: auto;"/>
            </a>
            <div class="media-body">
                    <h4 class="media-heading"><a href="<?php 
            echo $feedarr[1];
            ?>
" target="_blank"><?php 
            echo $feedarr[0];
            ?>
</a></h4>
                    <?php 
            echo string_sorter($feedarr[2], 155);
            ?>
<br>
            </div>
        </div>
      <?php 
        }
        ?>
      </div>
    </div>
</div>

<!--RSS post start----> 
<?php 
    }
    ?>
<div class="col-md-12">
    <?php 
    if ($posrarr["type"] != "rss") {
        ?>
                <ul class="list-inline font-grey-cascade">
                        <li> 
                              
                              <?php 
        if (!post_like_check($_SESSION["userid"], $postid)) {
            ?>
                              <a href="javascript:void()" onclick="dolike(<?php 
            echo $postid;
            ?>
,<?php 
            echo $_SESSION["userid"];
            ?>
,$(this))"  >Like</a>
                              <?php 
        } else {
            ?>
                              <a href="javascript:void()" onclick="dounlike(<?php 
            echo $postid;
            ?>
,<?php 
            echo $_SESSION["userid"];
            ?>
,$(this))"  >Unlike</a>
                              <?php 
        }
        ?>
                              <i class="fa fa-circle" style="font-size: 4px;  vertical-align: text-bottom;"></i>
                              <a href="<?php 
        echo BASEURL;
        ?>
post/<?php 
        echo $posrarr["parmalink"];
        ?>
#postcomment">
                                  Comment
                              </a>
                              &nbsp;&nbsp;
                        </li>
                        
                        <li title="<?php 
        echo date("F j, Y, g:i a", strtotime($posrarr["last_update"]));
        ?>
">
                                <i class="fa fa-calendar"></i><?php 
        echo dateDiff($posrarr["last_update"]);
        ?>
 ago
                        </li>
                        <li>
                                <i class="fa fa-eye"></i> <?php 
        echo count_post_viewer($postid);
        ?>
 Views
                        </li>
                        <li>
                                <i class="fa fa-comments"></i>
                                
                                <?php 
        echo count_post_comment($postid);
        ?>
 Comments </a>
                        </li>
                        <li>
                              <i class="fa fa-thumbs-up"></i> <span id="like<?php 
        echo $postid;
        ?>
"><?php 
        echo count_post_like($postid);
        ?>
</span> Likes
                        </li>
                </ul>
    <?php 
    } else {
        $rsslink = get_post_meta($postid, "rss_link");
        ?>
    <p class="font-grey-cascade no-margin">
        <i class="fa fa-rss"></i> <?php 
        echo $posrarr["name"];
        ?>
 &nbsp;&nbsp;
        <i class="fa fa-calendar"></i> <?php 
        echo dateDiff($posrarr["last_update"]);
        ?>
        <span class="pull-right"><a href="<?php 
        echo $rsslink;
        ?>
">See More</a></span>
    </p>
    <?php 
    }
    ?>
            </div> 
    </div>
</div>
</div>
<?php 
}