PHP nv_news_fix_playlist Exemples

Exemple #1

Fichier : content.php Projet : webvangvn/nv4_module_videos

 }
 //Playlist
 $id_playlist_content_new = $rowcontent['mode'] == 'edit' ? array_diff($id_playlist_content_post, $id_playlist_content) : $id_playlist_content_post;
 $id_playlist_content_del = $rowcontent['mode'] == 'edit' ? array_diff($id_playlist_content, $id_playlist_content_post) : array();
 $array_playlist_fix = array();
 foreach ($id_playlist_content_new as $playlist_id_i) {
     $db->query('INSERT INTO ' . NV_PREFIXLANG . '_' . $module_data . '_playlist (playlist_id, id, playlist_sort) VALUES (' . $playlist_id_i . ', ' . $rowcontent['id'] . ', 0)');
     $array_playlist_fix[] = $playlist_id_i;
 }
 foreach ($id_playlist_content_del as $playlist_id_i) {
     $db->query('DELETE FROM ' . NV_PREFIXLANG . '_' . $module_data . '_playlist WHERE id = ' . $rowcontent['id'] . ' AND playlist_id = ' . $playlist_id_i);
     $array_playlist_fix[] = $playlist_id_i;
 }
 $array_playlist_fix = array_unique($array_playlist_fix);
 foreach ($array_playlist_fix as $playlist_id_i) {
     nv_news_fix_playlist($playlist_id_i, false);
 }
 if ($rowcontent['keywords'] != $rowcontent['keywords_old']) {
     $keywords = explode(',', $rowcontent['keywords']);
     $keywords = array_map('strip_punctuation', $keywords);
     $keywords = array_map('trim', $keywords);
     $keywords = array_diff($keywords, array(''));
     $keywords = array_unique($keywords);
     foreach ($keywords as $keyword) {
         if (!in_array($keyword, $array_keywords_old)) {
             $alias_i = $module_config[$module_name]['tags_alias'] ? change_alias($keyword) : str_replace(' ', '-', $keyword);
             $alias_i = nv_strtolower($alias_i);
             $sth = $db->prepare('SELECT tid, alias, description, keywords FROM ' . NV_PREFIXLANG . '_' . $module_data . '_tags where alias= :alias OR FIND_IN_SET(:keyword, keywords)>0');
             $sth->bindParam(':alias', $alias_i, PDO::PARAM_STR);
             $sth->bindParam(':keyword', $keyword, PDO::PARAM_STR);
             $sth->execute();

Exemple #2

Fichier : change_playlist.php Projet : hongoctrien/module-videos

    } elseif ($id > 0) {
        list($playlist_id, $id) = $db->query("SELECT playlist_id, id FROM " . NV_PREFIXLANG . "_" . $module_data . "_playlist WHERE playlist_id=" . intval($playlist_id) . " AND id=" . intval($id))->fetch(3);
        if ($playlist_id > 0 and $id > 0) {
            if ($mod == "playlist_sort" and $new_vid > 0) {
                $query = "SELECT id FROM " . NV_PREFIXLANG . "_" . $module_data . "_playlist WHERE playlist_id=" . $playlist_id . " AND id!=" . $id . " ORDER BY playlist_sort ASC";
                $result = $db->query($query);
                $playlist_sort = 0;
                while ($row = $result->fetch()) {
                    ++$playlist_sort;
                    if ($playlist_sort == $new_vid) {
                        ++$playlist_sort;
                    }
                    $sql = "UPDATE " . NV_PREFIXLANG . "_" . $module_data . "_playlist SET playlist_sort=" . $playlist_sort . " WHERE playlist_id=" . $playlist_id . " AND id=" . intval($row['id']);
                    $db->query($sql);
                }
                $result->closeCursor();
                $sql = "UPDATE " . NV_PREFIXLANG . "_" . $module_data . "_playlist SET playlist_sort=" . $new_vid . " WHERE playlist_id=" . $playlist_id . " AND id=" . intval($id);
                $db->query($sql);
                $content = "OK_" . $playlist_id;
            } elseif ($mod == "delete") {
                $db->query("DELETE FROM " . NV_PREFIXLANG . "_" . $module_data . "_playlist WHERE playlist_id=" . $playlist_id . " AND id=" . intval($id));
                $content = "OK_" . $playlist_id;
            }
        }
    }
    nv_news_fix_playlist($playlist_id);
    nv_del_moduleCache($module_name);
}
include NV_ROOTDIR . '/includes/header.php';
echo $content;
include NV_ROOTDIR . '/includes/footer.php';