Пример #1
0
function set_notifyme()
{
    if (!($res = select_w_2('notifyme', 4, array('mno', $_SESSION['mno'], 'plno', $_GET['plno']), 'and'))) {
        insert('notifyme', array('mno', 'plno', 'nsdate'), array($_SESSION['mno'], $_GET['plno'], ''), 'nno');
    } else {
        $del = delete_w_2('notifyme', array('mno', $_SESSION['mno'], 'plno', $_GET['plno']), 'and');
    }
    if (!$res) {
        echo "inserted";
    }
    if ($del) {
        echo "deleted";
    }
}
Пример #2
0
function like_dislike()
{
    if (!empty($_SESSION['mno'])) {
        if (empty($_GET['unlike'])) {
            if (!select_w_2('posted_looks_comments_like_dislike', 1, array('plcno', $_GET['comment_id'], 'mno', $_SESSION['mno']), 'and')) {
                insert('posted_looks_comments_like_dislike', array('plcno', 'mno'), array($_GET['comment_id'], $_SESSION['mno']), 'plcldno');
                $total_like = select('posted_looks_comments_like_dislike', 3, array('plcno', $_GET['comment_id']));
                count_total_like($total_like);
                // echo "Sucesfully like the comment ";
            } else {
                $total_like = select('posted_looks_comments_like_dislike', 3, array('plcno', $_GET['comment_id']));
                count_total_like($total_like);
            }
        } else {
            delete_w_2('posted_looks_comments_like_dislike', array('plcno', $_GET['unlike'], 'mno', $_SESSION['mno']), 'and');
            // echo "Sucesfully unlike the comment";
            $total_like = select('posted_looks_comments_like_dislike', 3, array('plcno', $_GET['unlike']));
            count_total_like($total_like);
        }
    }
}
Пример #3
0
if (empty($_GET["txen"])) {
    $_GET["txen"] = 1;
}
// echo "NEXT = $_GET[txen]";
$_GET['txen'] = $_GET['txen'] - 1;
$start = $_GET['txen'] * 20;
$limit = $start - $start + 20;
// echo "<br>limit $start , $limit ";
// echo"<BR>";
#execute delete
delete_from_postedlooks(634);
delete_from_postedlooks(393);
delete_from_postedlooks(752);
//delete_from_postedlooks(791);
if (!empty($_POST['img'])) {
    $activity_posted_info = select_w_2('activity', 6, array('action', 'Posted', '_table_id', $_POST['img']), 'and');
    //delete_from_activity_action_posted($activity_posted_info[0][1]); //mno
    delete_from_activity_action_posted($activity_posted_info[0][4]);
    //plno
    delete_from_postedlooks($activity_posted_info[0][4]);
    //plno
    delete_from_postlook_a_look_folder($_POST['img']);
    //delete in image folder
}
$activity_posted = select('activity', 6, array('action', 'Posted'), 'order by _table_id desc', array($start, $limit));
// for ($i=0; $i < count($activity_posted); $i++) {
// 	echo $activity_posted[$i][4]."<br>";
// }
// echo "total result is = ".count($activity_posted)."<br>";
for ($i = 0; $i < count($activity_posted); $i++) {
    $i1 = $i + 1;
Пример #4
0
function get_id_look_owner($lookid)
{
    $activity_posted_info = select_w_2('activity', 6, array('action', 'Posted', '_table_id', $lookid), 'and');
    return $activity_posted_info;
}
Пример #5
0
function my_trate_for_look($mno, $plno)
{
    $r = select_w_2('ratings', 5, array('plno', $plno, 'mno', $mno), 'and');
    return intval($r[0][3]);
}
Пример #6
0
function insert_my_like($mno, $plcno)
{
    if (!select_w_2('posted_looks_comments_like_dislike', 1, array('plcno', $plcno, 'mno', $mno), 'and')) {
        insert('posted_looks_comments_like_dislike', array('plcno', 'mno'), array($plcno, $mno), 'plcldno');
    }
}
Пример #7
0
function insert_my_dislike($mno, $plcno)
{
    if (!select_w_2('fs_plcm_dislike', 1, array('plcno', $plcno, 'mno', $mno), 'and')) {
        insert('fs_plcm_dislike', array('plcno', 'mno'), array($plcno, $mno), 'plcmdno');
    }
}