Forum d'entraide PHPFrance

Venez poser vos questions PHP, MySQL, HTML5, CSS, Javascript, Gestion de serveurs à la communauté PHPfrance
https://forum.phpfrance.com/

n'autoriser que 30 catégories sur l'index de ma gallerie

https://forum.phpfrance.com/viewtopic.php?f=8&t=261441

Page 1 sur 1

n'autoriser que 30 catégories sur l'index de ma gallerie

Posté : 28 nov. 2011, 20:33
par Stefan-allen
Bonjour
l'index de ma gallerie index toute mes catégories
mon problème : Si j'ai 500 catégorie mon index donnera alors les 500 catégorie sur une seul page
mon ambition : n'afficher que 30 catégories par pages sur plusieurs page

Voici mon code 
<?php 
// -------------------------------------------------------------------------//
// Nuked-KlaN - PHP Portal                                                  //
// http://www.nuked-klan.org                                                //
// -------------------------------------------------------------------------//
// This program is free software. you can redistribute it and/or modify     //
// it under the terms of the GNU General Public License as published by     //
// the Free Software Foundation; either version 2 of the License.           //
// -------------------------------------------------------------------------//
if (!defined("INDEX_CHECK"))
{
    die ("<div style=\"text-align: center;\">You cannot open this page directly</div>");
} 

global $nuked, $language, $user;
translate("modules/Gallery/lang/" . $language . ".lang.php");
include("modules/Gallery/config.php");

if (!$user)
{
    $visiteur = 0;
} 
else
{
    $visiteur = $user[1];
} 
$ModName = basename(dirname(__FILE__));
$level_access = nivo_mod($ModName);
if ($visiteur >= $level_access && $level_access > -1)
{
    compteur("Gallery");

    function view_screen($sid)
    {
        global $nuked;

        $sql = mysql_query("SELECT titre, url FROM " . GALLERY_TABLE . " WHERE sid = '" . $sid . "'");
        list($titre, $url) = mysql_fetch_array($sql);
        $titre = stripslashes($titre);
        $titre = htmlentities($titre);

        $name = strrchr($url, '/');
        $name = substr($name, 1);
        $name_enc = rawurlencode($name);
        $url = str_replace($name, $name_enc, $url);

    echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Strict//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\">\n"
    . "<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"fr\">\n"
    . "<head><title>" . $titre . "</title>\n"
    . "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\" />\n"
    . "<meta http-equiv=\"content-style-type\" content=\"text/css\" />\n"
    . "<link title=\"style\" type=\"text/css\" rel=\"stylesheet\" href=\"themes/" . $theme . "/style.css\" /></head>\n"
    . "<body style=\"background: " . $bgcolor2 . ";margin-top: 0px;margin-bottom: 0px;margin-left: 0px;margin-right: 0px;\">\n"
    . "<div style=\"text-align: center;\"><a href=\"javascript: self.close()\"><img style=\"border: 0;\" src=\"" . $url . "\" alt=\"\" title=\"" . _CLICTOCLOSE . "\" /></a></div></body></html>";

    } 

    function cat($cat)
    {
        global $nuked, $bgcolor1, $bgcolor2, $bgcolor3, $img_cat, $img_none, $image_resize, $image_gd;

        $counter = 0;

        $sql = mysql_query("SELECT cid, titre, description FROM " . GALLERY_CAT_TABLE . " WHERE parentid = '" . $cat . "'");
	$nb_subcat = mysql_num_rows($sql);

        if ($nb_subcat > 0)
        {
            echo "<table width=\"100%\" cellspacing=\"5\" cellpadding=\"0\" border=\"0\">\n";

            $sql = mysql_query("SELECT cid, titre, description FROM " . GALLERY_CAT_TABLE . " WHERE parentid = '" . $cat . "' ORDER BY position, titre");
            while (list($catid, $parentcat, $parentdesc) = mysql_fetch_array($sql))
            {
                $parentcat = stripslashes($parentcat);
                $parentdesc = stripslashes($parentdesc);

                $parentcat = htmlentities($parentcat);
                $parentdesc = htmlentities($parentdesc);

                $parentdesc = BBcode($parentdesc);
                $parentdesc = icon($parentdesc);

                $sql_img = mysql_query("SELECT sid, url, url2, date FROM " . GALLERY_TABLE . " WHERE cat = '" . $catid . "' ORDER BY sid DESC");
                $nb_imgcat = mysql_num_rows($sql_img);
                list($sid, $url, $url2, $date) = mysql_fetch_array($sql_img);

                if ($url2 != "" && $url2 != "http://")
                {
                    $image = $url2;
                } 
				else if ($url2 == "" && $image_gd == "on" && @extension_loaded('gd') && !eregi("http://", $url) && is_file($url))
				{			
					$org = $rep_img;
					$dest = $rep_img_gd;
					$name = str_replace ($org,'',$url);
					
					// instanciation de l'objet
					$thb = new thb;
					// appel du constructeur
					// nim de la source: image.jpeg
					// chemin source: ./ (dossier courant)
					// destianation: ./ (dossier courant)
					$thb->doImg($name, $org, $dest);
					// Config des parametres
					// prefix
					// taille du + grd coté
					// qualité
					$thb->SetParam('_tmb', $img_screen1, 90);
					// pour connaitre le nom et chemin de l'image réduite
					// résultat: ./image_thb.jpeg
					$thumb = $thb->GetThbName();
					// pour connaitre le nom et chemin de l'image d'origine
					// résultat: ./image.jpeg
					$source = $thb->GetOrigine();
					// Lance le redimensionenemt
					$thb->doThb();
					if ($thumb) $sql_insert = mysql_query ("UPDATE " . $nuked['prefix'] . "_gallery SET url2 = '" . $thumb . "' WHERE sid = '" . $sid . "'");
					$image = $thumb;			
				} 
                if (!$image) $image = $url; 

                $name = strrchr($image, '/');
                $name = substr($name, 1);
                $name_enc = rawurlencode($name);
                $image = str_replace($name, $name_enc, $image);

                if ($date)
                {
                    $date = strftime("%x", $date);
                    $last_date = _LASTADD . "&nbsp;" . $date;
                } 
                else
		{
                    $last_date = "";
		}

                if ($catid != $last_catid)
                {
                    $counter++;

                    if ($counter == 1)
                    {
                        echo "<tr>";
                    } 

                    echo "<td style=\"width: 50%;\" valign=\"top\">\n"
                    . "<table style=\"background: " . $bgcolor1 . ";border: 1px solid " . $bgcolor3 . ";\" width=\"100%\" cellspacing=\"1\" cellpadding=\"5\" border=\"0\">\n"
                    . "<tr><td colspan=\"2\"><a href=\"index.php?file=Gallery&op=categorie&cat=" . $catid . "\"><b>" . $parentcat . "</b></a></td></tr>\n"
                    . "<tr><td style=\"width: 50px;background: " . $bgcolor2 . ";\" align=\"center\" valign=\"middle\">";

                    if ($image != "")
                    {
                        echo "<a href=\"index.php?file=Gallery&op=categorie&cat=" . $catid . "\">" . img_size($image, $img_cat, $parentcat, $image_resize) . "</a>";
                    } 
                    else
                    {
                        echo "<a href=\"index.php?file=Gallery&op=categorie&cat=" . $catid . "\">" . img_size($img_none, $img_cat, $parentcat, $image_resize) . "</a>";
                    } 

                    echo "</td><td style=\"height: 100%;background: " . $bgcolor2 . ";\">\n"
                    . "<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n";

                    if ($parentdesc != "") echo "<tr><td>" . $parentdesc . "</td></tr>\n";

                    echo "<tr><td>" . $nb_imgcat . "&nbsp;" . _SCREENINDB;

                    if ($last_date != "") echo "<br />" . $last_date;

                    echo "</td></tr></table></td></tr></table></td>\n";

                    if ($counter == 2)
                    {
                        $counter = 0;
                        echo "</tr>";
                    } 

                    $last_catid = $catid;
                } 
            } 

            if ($counter == 1) echo "<td style=\"width: 50%;border: 1px solid " . $bgcolor3 . ";\">&nbsp;</td></tr>\n";

            echo "</table>\n";
        } 
    } 


    function categorie($cat)
    {
        global $nuked;

        opentable();

        if ($nuked['gallery_title'] != "")
        {
            $title = $nuked['gallery_title'];
        } 
        else
        {
            $title = _GALLERY;
        } 

        $sql = mysql_query("SELECT titre, description, parentid FROM " . GALLERY_CAT_TABLE . " WHERE cid = '" . $cat . "'");
        list($cat_titre, $cat_desc, $parentid) = mysql_fetch_array($sql);
        $cat_titre = stripslashes($cat_titre);
        $cat_desc = stripslashes($cat_desc);

        $cat_titre = htmlentities($cat_titre);
        $cat_desc = htmlentities($cat_desc);

        $cat_desc = BBcode($cat_desc);
        $cat_desc = icon($cat_desc);

        if ($parentid > 0)
        {
            $sql_parent = mysql_query("SELECT titre FROM " . GALLERY_CAT_TABLE . " WHERE cid = '" . $parentid . "'");
            list($parent_titre) = mysql_fetch_array($sql_parent);
            $parent_titre = stripslashes($parent_titre);
            $parent_titre = htmlentities($parent_titre);

            echo "<br /><div style=\"text-align: center;\"><a href=\"index.php?file=Gallery\" style=\"text-decoration:none\"><big><b>" . $title . "</b></big></a> > <a href=\"index.php?file=Gallery&op=categorie&cat=" . $parentid . "\" style=\"text-decoration:none\"><big><b>" . $parent_titre . "</b></big></a> > <big><b>" . $cat_titre . "</b></big></div><br />\n";
        } 
        else
        {
            echo "<br /><div style=\"text-align: center;\"><a href=\"index.php?file=Gallery\" style=\"text-decoration:none\"><big><b>" . $title . "</b></big></a> > <big><b>" . $cat_titre . "</b></big></div><br />\n";
        } 

        if ($cat_desc != "")
        {
            echo "<div style=\"text-align: center;\">" . $cat_desc . "</div><br />\n";
        } 
		
        cat($cat);
        classe($cat);
        
        closetable();
    } 

    function description($sid)
    {
        global $nuked, $user, $visiteur, $orderby, $bgcolor1, $bgcolor2, $bgcolor3, $img_width, $image_resize;

        if ($nuked['gallery_title'] != "")
        {
            $title = $nuked['gallery_title'];
        } 
        else
        {
            $title = _GALLERY;
        } 

        opentable();

        $upd = mysql_query("UPDATE " . GALLERY_TABLE . " SET count = count + 1 WHERE sid = '" . $sid . "'");

        $sql = mysql_query("SELECT cat, titre, description, autor, url, url_file, date, count FROM " . GALLERY_TABLE . " WHERE sid = '" . $sid . "'");
        list($cat, $titre, $description, $autor, $url, $url_file, $date, $count) = mysql_fetch_array($sql);
        $titre = stripslashes($titre);
        $description = stripslashes($description);
        $autor = stripslashes($autor);

        $titre = htmlentities($titre);
        $description = htmlentities($description);
        $autor = htmlentities($autor);

        $name = strrchr($url, '/');
        $name = substr($name, 1);
        $name_enc = rawurlencode($name);
        $url = str_replace($name, $name_enc, $url);

        if (!$name) $name = "N/A";

        if ($date) $date = strftime("%x %H:%M", $date);
        else $date = "N/A";

        if ($url_file != "")
        {
            $button = "<br /><div style=\"text-align: center;\"><input type=\"button\" value=\"" . _DOWNFILE . "\" onclick=\"window.open('" . $url_file . "')\" /><div><br />\n";
        } 
        else
        {
            $button = "<br />\n";
        } 

        $sql2 = mysql_query("SELECT titre, parentid FROM " . GALLERY_CAT_TABLE . " WHERE cid = '" . $cat . "'");
        list($cat_name, $parentid) = mysql_fetch_array($sql2);
        $cat_name = stripslashes($cat_name);
        $cat_name = htmlentities($cat_name);

        if ($cat == 0)
        {
            $category = _NONE;
        } 
        else if ($parentid > 0)
        {
            $sql3 = mysql_query("SELECT titre FROM " . GALLERY_CAT_TABLE . " WHERE cid = '" . $parentid . "'");
            list($parent_name) = mysql_fetch_array($sql3);
            $parent_name = stripslashes($parent_name);
            $parent_name = htmlentities($parent_name);

            $category = "<a href=\"index.php?file=Gallery&op=categorie&cat=" . $parentid . "\">" . $parent_name . "</a> -> <a href=\"index.php?file=Gallery&op=categorie&cat=" . $cat . "\">" . $cat_name . "</a>";
        } 
        else
        {
            $category = "<a href=\"index.php?file=Gallery&op=categorie&cat=" . $cat . "\">" . $cat_name . "</a>";
        } 

		
        if ($orderby == "name")
        {
            $sql_next = mysql_query("SELECT sid FROM " . GALLERY_TABLE . " WHERE cat = '" . $cat . "' AND titre > '" . $titre . "' ORDER BY titre LIMIT 0, 1");
            list($nextid) = mysql_fetch_array($sql_next);

            $sql_last = mysql_query("SELECT sid FROM " . GALLERY_TABLE . " WHERE cat = '" . $cat . "' AND titre < '" . $titre . "' ORDER BY titre DESC LIMIT 0, 1");
            list($lastid) = mysql_fetch_array($sql_last);
        } 
        else if ($orderby == "count")
        {
            $sql_next = mysql_query("SELECT sid FROM " . GALLERY_TABLE . " WHERE cat = '" . $cat . "' AND count < '" . $count . "' ORDER BY count DESC LIMIT 0, 1");
            list($nextid) = mysql_fetch_array($sql_next);

            $sql_last = mysql_query("SELECT sid FROM " . GALLERY_TABLE . " WHERE cat = '" . $cat . "' AND count > '" . $count . "' ORDER BY count LIMIT 0, 1");
            list($lastid) = mysql_fetch_array($sql_last);
        } 
        else if ($orderby == "note")
        {
            $sql_note = mysql_query("SELECT AVG(vote) FROM " . VOTE_TABLE . " WHERE vid = '" . $sid . "' AND module = 'Gallery'");
            list($note) = mysql_fetch_array($sql_note);

            $sql_next = mysql_query("SELECT L.sid, AVG(V.vote) AS note FROM " . GALLERY_TABLE . " AS L LEFT JOIN " . VOTE_TABLE . " AS V ON L.sid = V.vid AND V.module = 'Gallery' WHERE L.cat = '" . $cat . "' GROUP BY L.sid HAVING note < '" . $note . "' ORDER BY note DESC LIMIT 0, 1");
            list($nextid) = mysql_fetch_array($sql_next);

            $sql_last = mysql_query("SELECT L.sid, AVG(V.vote) AS note FROM " . GALLERY_TABLE . " AS L LEFT JOIN " . VOTE_TABLE . " AS V ON L.sid = V.vid AND V.module = 'Gallery' WHERE L.cat = '" . $cat . "' GROUP BY L.sid HAVING note > '" . $note . "' ORDER BY note LIMIT 0, 1");
            list($lastid) = mysql_fetch_array($sql_last);
        } 
        else
        {
            $orderby = "news";

            $sql_next = mysql_query("SELECT sid FROM " . GALLERY_TABLE . " WHERE cat = '" . $cat . "' AND sid < '" . $sid . "' ORDER BY sid DESC LIMIT 0, 1");
            list($nextid) = mysql_fetch_array($sql_next);

            $sql_last = mysql_query("SELECT sid FROM " . GALLERY_TABLE . " WHERE cat = '" . $cat . "' AND sid > '" . $sid . "' ORDER BY sid LIMIT 0, 1");
            list($lastid) = mysql_fetch_array($sql_last);
        } 


        if ($nextid != "")
        {
            $next = "<a href=\"index.php?file=Gallery&op=description&sid=" . $nextid . "&orderby=" . $orderby . "\">" . $img . "<img src=\"images/next.gif\" alt=\"\" //\</a> ";

        } 


        if ($lastid != "")
        {
            $prev = "<small>< <a href=\"index.php?file=Gallery&op=description&sid=" . $lastid . "&orderby=" . $orderby . "\">" . $img . "<img src=\"images/previous.gif\" alt=\"\" //\</a> ";
        } 

        echo "<br />\n";

        if ($visiteur >= admin_mod("Gallery"))
        {
            echo"<script type=\"text/javascript\">\n"
            ."<!--\n"
            ."\n"
            . "function delimg(titre, id)\n"
            . "{\n"
            . "if (confirm('" . _SCREENDELETE  . " '+titre+' ! " . _CONFIRM . "'))\n"
            . "{document.location.href = 'index.php?file=Gallery&page=admin&op=del_screen&sid='+id;}\n"
            . "}\n"
            . "\n"
            . "// -->\n"
            . "</script>\n";

            echo "<div style=\"text-align: right;\"><a href=\"index.php?file=Gallery&page=admin&op=edit_screen&sid=" . $sid . "\"><img style=\"border: 0;\" src=\"images/edition.gif\" alt=\"\" title=\"" . _EDIT . "\" /></a>"
            . "&nbsp;<a href=\"javascript:delimg('" . addslashes($titre) . "', '" . $sid . "');\"><img style=\"border: 0;\" src=\"images/delete.gif\" alt=\"\" title=\"" . _DEL . "\" /></a></div>\n";
        } 

        echo "<br /><div style=\"text-align: center;\"><a href=\"index.php?file=Gallery\" style=\"text-decoration:none\"><big><b>" . $title . "</b></big></a></div><br />\n"
	. "<table style=\"margin-left: auto;margin-right: auto;text-align: left;\" cellpadding=\"20\" cellspacing=\"0\" border=\"0\">\n"
	. "<tr style=\"background: " . $bgcolor1 . ";\"><td style=\"border: 1px dashed " . $bgcolor3 . ";\">"
	.  "<a href=\"" . $url . "\" class=\"thickbox\" title=\"" . $titre . "\">"
	. img_size($url, $img_width, _CLICTOSCREEN, $image_resize) . "</a></td></tr></table><br />\n"
	. "<table style=\"margin-left: auto;margin-right: auto;text-align: left;\" width=\"90%\" cellpadding=\"3\" cellspacing=\"0\">\n"
	. "<tr><td align=\"left\">" . $prev . "</td><td align=\"right\">" . $next . "</td></tr></table>\n"
	. "<table style=\"margin-left: auto;margin-right: auto;text-align: left;background: " . $bgcolor2 . ";\" width=\"90%\" cellpadding=\"3\" cellspacing=\"3\" border=\"0\">\n"
	. "<tr style=\"background: " . $bgcolor2 . ";\"><td style=\"border: 1px solid " . $bgcolor3 . ";\" align=\"center\"><big><b>" . $titre . "</b></big></td></tr>\n";

        if ($description != "")
        {
            $description = BBcode($description);
            $description = icon($description);

            echo "<tr style=\"background: " . $bgcolor1 . ";\"><td style=\"border: 1px dashed " . $bgcolor3 . ";\">" . $description . "</td></tr>\n"
            . "<tr style=\"background: " . $bgcolor2 . ";\"><td>&nbsp;</td></tr>";
        } 

        echo "<tr style=\"background: " . $bgcolor1 . ";\"><td style=\"border: 1px dashed " . $bgcolor3 . ";\"><b>" . _CAT . " :</b> " . $category . "</td></tr>\n";

        if ($autor != "")
        {
            echo "<tr style=\"background: " . $bgcolor1 . ";\"><td style=\"border: 1px dashed " . $bgcolor3 . ";\"><b>" . _AUTHOR . " :</b>  " . $autor . "</td></tr>\n";
	}

        echo "<tr style=\"background: " . $bgcolor1 . ";\"><td style=\"border: 1px dashed " . $bgcolor3 . ";\"><b>" . _ADDTHE . " :</b>  " . $date . "</td></tr>\n"
	. "<tr style=\"background: " . $bgcolor1 . ";\"><td style=\"border: 1px dashed " . $bgcolor3 . ";\"><b>" . _FILENAME . " :</b> " . $name . "</td></tr>\n"
	. "<tr style=\"background: " . $bgcolor1 . ";\"><td style=\"border: 1px dashed " . $bgcolor3 . ";\"><b>" . _SEEN . " :</b> " . $count . "&nbsp;" . _TIMES . "</td></tr>\n"
	. "<tr style=\"background: " . $bgcolor1 . ";\"><td style=\"border: 1px dashed " . $bgcolor3 . ";\">";

        include ("modules/Comment/index.php");
        com_index("Gallery", $sid);

        echo "</td></tr><tr style=\"background: " . $bgcolor1 . ";\"><td style=\"border: 1px dashed " . $bgcolor3 . ";\">";

        include ("modules/Vote/index.php");
        vote_index("Gallery", $sid);

        echo "</td></tr></table>" . $button;

        closetable();
    } 

    function index()
    {
        global $nuked, $bgcolor1, $bgcolor2, $bgcolor3, $nb_subcat, $orderby, $p;

        if ($nuked['gallery_title'] != "")
        {
            $title = $nuked['gallery_title'];
        } 
        else
        {
            $title = _GALLERY;
        } 

        opentable();

        echo "<br /><div style=\"text-align: center;\"><big><b>" . $title . "</b></big></div>\n"
        . "<div style=\"text-align: center;\"><br />\n"
        . "[  " . _INDEXGALLERY . " | "
	. "<a href=\"index.php?file=Gallery&op=classe&orderby=news\" style=\"text-decoration: underline\">" . _NEWSIMG . "</a> | "
	. "<a href=\"index.php?file=Gallery&op=classe&orderby=count\" style=\"text-decoration: underline\">" . _TOPIMG . "</a> | "
	. "<a href=\"index.php?file=Suggest&module=Gallery\" style=\"text-decoration: underline\">" . _SUGGESTIMG . "</a> ]</div><br />\n";

        $sql_nbimages = mysql_query("SELECT sid FROM " . GALLERY_TABLE . "");
        $nb_images = mysql_num_rows($sql_nbimages);

        $sql_nbcat = mysql_query("SELECT cid FROM " . GALLERY_CAT_TABLE . "");
        $nb_cat = mysql_num_rows($sql_nbcat);

        if ($nb_cat > 0)
        {
            echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\"><tr><td>";

            $sql_cat = mysql_query("SELECT cid, titre, description FROM " . GALLERY_CAT_TABLE . " WHERE parentid = '0' ORDER BY cid DESC");  
            while (list($cid, $titre, $description) = mysql_fetch_array($sql_cat))
            {
                $titre = stripslashes($titre);
                $description = stripslashes($description);

                $titre = htmlentities($titre);
                $description = htmlentities($description);

                $description = BBcode($description);
                $description = icon($description);

                $sql_img = mysql_query("SELECT sid, date FROM " . GALLERY_TABLE . " WHERE cat = '" . $cid . "' ORDER BY sid DESC LIMIT 0, 1");
                $nb_imgcat = mysql_num_rows($sql_img);
                list($sid, $date) = mysql_fetch_row($sql_img);

                $sql_img_tt = mysql_query("SELECT sid FROM " . GALLERY_TABLE . ", " . GALLERY_CAT_TABLE . " WHERE cat = cid AND (parentid = '" . $cid . "' OR cid = '" . $cid . "')");
                $nb_imgcat_tt = mysql_num_rows($sql_img_tt);

                $sql_nbcat = mysql_query("SELECT cid FROM " . GALLERY_CAT_TABLE . " WHERE parentid = '" . $cid . "'");
                $nb_nbcat = mysql_num_rows($sql_nbcat);

                if ($date != "")
                {
                    $date = strftime("%x", $date);
                    $last_date = "" . _LASTADD . " $date";
                } 
                else
                {
                    $last_date = "";
                } 

                echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" style=\"border: 1px solid " . $bgcolor3 . ";\"><tr><td>\n"
                . "<table style=\"background: " . $bgcolor2 . ";\" width=\"100%\" cellspacing=\"1\" cellpadding=\"5\" border=\"0\">\n"
                . "<tr><td style=\"width: 80%;background: " . $bgcolor1 . ";\"><a href=\"index.php?file=Gallery&op=categorie&cat=" . $cid . "\"><big><b>" . $titre . "</b></big></a></td>\n"
                . "<td style=\"width: 10%;background: " . $bgcolor1 . ";\">" . $nb_imgcat_tt . "&nbsp;" . _SCREENINDB . "</td>\n";

                if ($nb_nbcat)
                {
                    echo "<td style=\"width: 10%;background: " . $bgcolor1 . ";\">" . $nb_nbcat . "&nbsp;" . _NBCAT . "</td>";
                } 

                echo "</tr></table></td></tr><tr><td>";

                if ($nb_nbcat == 0)
                {
                    echo "<table width=\"100%\"><tr><td>&nbsp;</td></tr><tr><td align=\"center\">" . $description . "</td></tr><tr><td>&nbsp;</td></tr></table>\n";
                } 
                else
                {
                    cat($cid);
                } 

                echo "</td></tr></table><br />\n";
            } 

            echo "</td></tr></table>\n";
        }
        else
	{
            echo "<br />";
	}

        classe("0");
         
        if ($nb_cat > 0 || $nb_images > 0) echo "<br /><div style=\"text-align: center;\"><small>( <i>" . _THEREIS . "&nbsp;" . $nb_images . "&nbsp;" . _SCREENINDB . " & " . $nb_cat . "&nbsp;" . _NBCAT . "&nbsp;" . _INDATABASE . "</i> )</small></div><br /><br />\n";
        else echo "<div style=\"text-align: center;\">" . _NOSCREENINDB . "</div><br /><br />\n";

        closetable();
    } 
    
    function classe($cat)
    {
    global $nuked, $p, $bgcolor1, $bgcolor2, $bgcolor3, $op, $orderby, $img_screen1, $img_screen2, $img_screen3, $image_resize;
    
	$nb_img_guest = $nuked['max_img'];
	$nb_img_line = $nuked['max_img_line'];
	
	if ($cat > 0)
	{
            $sql = mysql_query("SELECT cid FROM " . GALLERY_CAT_TABLE . " WHERE parentid = '" . $cat . "'");
            $nb_subcat = mysql_num_rows($sql);
	}
	else
	{
            $nb_subcat = 0;
	}
        
        if ($op == "classe")
        {
	
            if ($nuked['gallery_title'] != "")
            {
                $title = $nuked['gallery_title'];
            } 
            else
            {
                $title = _GALLERY;
            } 

            echo "<br /><div style=\"text-align: center;\"><big><b>" . $title . "</b></big></div>\n"
            . "<div style=\"text-align: center;\"><br />\n"
            . "[ <a href=\"index.php?file=Gallery\" style=\"text-decoration: underline\">" . _INDEXGALLERY . "</a> | ";

            if ($orderby == "news")
            {
                echo _NEWSIMG . " | ";
            } 
            else
            {
                echo "<a href=\"index.php?file=Gallery&op=classe&orderby=news\" style=\"text-decoration: underline\">" . _NEWSIMG . "</a> | ";
            } 

            if ($orderby == "count")
            {
                echo _TOPIMG . " | ";
            } 
            else
            {
                echo "<a href=\"index.php?file=Gallery&op=classe&orderby=count\" style=\"text-decoration: underline\">" . _TOPIMG . "</a> | ";
            } 

            echo "<a href=\"index.php?file=Suggest&module=Gallery\" style=\"text-decoration: underline\">" . _SUGGESTIMG . "</a> ]</div><br />\n";
        } 
        
        if ($cat != "") $where = "WHERE L.cat = '" . $cat . "'";
	else $where = "";


        if ($orderby == "name")
        {
            $order = "ORDER BY L.titre";
        } 

        else if ($orderby == "count")
        {
            $order = "ORDER BY L.count DESC";
        }
 
        else if ($orderby == "note")
        {
            $order = "ORDER BY note DESC";
        } 

        else
        {
            $orderby = "news";
            $order = "ORDER BY L.sid DESC";
        } 

        $sql = mysql_query("SELECT L.sid, L.titre, L.url, L.url2, L.date, AVG(V.vote) AS note  FROM " . GALLERY_TABLE . " AS L LEFT JOIN " . VOTE_TABLE . " AS V ON L.sid = V.vid AND V.module = 'Gallery' " . $where . " GROUP BY L.sid " . $order);
        $count = mysql_num_rows($sql);

        if ($count > 1 && $cat != "")
        {
            echo "<table style=\"margin-left: auto;margin-right: auto;text-align: left;\" width=\"90%\">\n"
            . "<tr><td align=\"right\"><small>" . _ORDERBY . " : ";

            if ($orderby == "news")
            {
                echo "<b>" . _DATE . "</b> | ";
            } 
            else
            {
                echo "<a href=\"index.php?file=Gallery&op=" . $op . "&orderby=news&cat=" . $cat . "\">" . _DATE . "</a> | ";
            }

            if ($orderby == "name")
            {
                echo "<b>" . _NAME . "</b> | ";
            } 

            else
            {
                echo "<a href=\"index.php?file=Gallery&op=" . $op . "&orderby=name&cat=" . $cat . "\">" . _NAME . "</a> | ";
            }

            if ($orderby == "count")
            {
                echo "<b>" . _TOPFILE . "</b> | ";
            } 
            else
            {
                echo "<a href=\"index.php?file=Gallery&op=" . $op . "&orderby=count&cat=" . $cat . "\">" . _TOPFILE . "</a> | ";
            }

            if ($orderby == "note")
            {
                echo "<b>" . _NOTE . "</b>&nbsp;";
            }
            else
            {
                echo "<a href=\"index.php?file=Gallery&op=" . $op . "&orderby=note&cat=" . $cat . "\">" . _NOTE . "</a>&nbsp;";
            }

            echo "</small></td></tr></table>\n";
        } 


        if ($count > 0)
        {
            if (!$p) $p = 1;
            $start = $p * $nb_img_guest - $nb_img_guest;

            echo "<table style=\"margin-left: auto;margin-right: auto;text-align: left;\" width=\"90%\" cellspacing=\"5\" cellpadding=\"10\" border=\"0\">\n"
            . "<tr><td  style=\"background: " . $bgcolor1 . ";border: 1px solid " . $bgcolor3 . ";\" colspan=\"" . $nb_img_line . "\">";

            if ($count > $nb_img_guest)
            {
                $url_page = "index.php?file=Gallery&op=" . $op . "&cat=" . $cat . "&orderby=" . $orderby;
                number($count, $nb_img_guest, $url_page);
            } 
            else
            {
                echo "&nbsp;";
            }

            echo "</td></tr>\n";

            $l = 0;
            $pourcent = 100 / $nb_img_line;
            $seek = mysql_data_seek($sql, $start);
            for($i = 0;$i < $nb_img_guest;$i++)
            {
                if (list($sid, $titre, $url, $url2, $date) = mysql_fetch_row($sql))
                {

                    if ($url2 != "" && $url2 != "http://")
                    {
                        $img = $url2;
                    } 
                    else
                    {
                        $img = $url;
                    } 

                    if ($nb_img_line > 4)
                    {
                        $img_w = $img_screen3;
                    } 
                    else if ($nb_img_line > 3)
                    {
                        $img_w = $img_screen2;
                    } 
                    else
                    {
                        $img_w = $img_screen1;
                    } 

                    $name = strrchr($img, '/');
                    $name = substr($name, 1);
                    $name_enc = rawurlencode($name);
                    $img = str_replace($name, $name_enc, $img);

                    $titre = stripslashes($titre);
                    $titre = htmlentities($titre);

                    if ($date != "") $alt = _ADDTHE . "&nbsp;" . strftime("%x %H:%M", $date);
                    else $alt = $titre;

                    if ($sid != $last_sid)
                    {
                        $l++;
                        if ($l == 1)
                        {
                            echo "<tr>";
                        } 

                        echo "<td style=\"width: " . $pourcent . "%;background: " . $bgcolor1 . ";border: 1px solid $bgcolor3;\" align=\"center\">"               
                        . "<a href=\"index.php?file=Gallery&op=description&sid=" . $sid . "&orderby=" . $orderby . "\">" . img_size($img, $img_w, $alt, $image_resize) . "</a><br />\n"
                        . "<a href=\"index.php?file=Gallery&op=description&sid=" . $sid . "&orderby=" . $orderby . "\"><b>" . $titre . "</b></a></td>\n";

                        if ($l == $nb_img_line)
                        {
                            $l = 0;
                            echo "</tr>";
                        } 

                        $last_sid = $sid;
                    }
                } 
            } 

            if ($l > 0)
            {
                for ($j = $l;$j < $nb_img_line;$j++)
                {
                    echo "<td style=\"width: " . $pourcent . "%;background: " . $bgcolor1 . ";border: 1px solid $bgcolor3;\">&nbsp;</td>\n";
                } 

                echo "</tr>\n";
            } 

            if ($nb_subcat == 0 && $count == 0) echo "<tr><td align=\"center\" colspan=\"$nb_img_line\">" . _NOSCREEN . "</td></tr>\n";

            echo "<tr><td style=\"background: " . $bgcolor1 . ";border: 1px solid $bgcolor3;\" colspan=\"$nb_img_line\">";

            if ($count > $nb_img_guest)
            {
                $url_page = "index.php?file=Gallery&op=" . $op . "&cat=" . $cat . "&orderby=" . $orderby;
                number($count, $nb_img_guest, $url_page);
            } 
            else
            {		 
                echo "&nbsp;";
            }

            echo "</td></tr></table><br />\n";

        } 
        else
        {
             if ($nb_subcat == 0 && $cat > 0) echo "<div style=\"text-align: center;\"><br />" . _NOSCREEN . "</div><br /><br />\n";
             if ($op == "classe") echo "<div style=\"text-align: center;\"><br />" . _NOSCREENINDB . "</div><br /><br />\n";
        } 
    
    }

    function img_size($image, $largeur, $title, $image_resize)
    {
		if ($image_resize == "off") $test = 0;
		else if (eregi("http://", $image) && $image_resize == "local") $test = 0;
		else  $test = 1;

		if ($test == 1) $style = "style=\"border: 1px solid #000000; overflow: auto; max-width: " . $largeur . "px;  width: expression(this.scrollWidth >= " . $largeur . "? '" . $largeur . "px' : 'auto');\"";
		else $style = "style=\"border: 1px solid #000000;\"";
		
		$image_resize = "<img " . $style . " src=\"" . checkimg($image) . "\" alt=\"\" title=\"" . $title . "\" />";
		return($image_resize);
    }

    switch ($op)
    {
        case "view_screen":
            view_screen($sid);
            break;

        case "description":
            description($sid);
            break;

        case "categorie":
            categorie($cat);
            break;
            
        case "classe":
            opentable();
            classe($cat);
            closetable();
            break;

        default:
            index();
            break;
    } 

} 
else if ($level_access == -1)
{
    opentable();
    echo "<br /><br /><div style=\"text-align: center;\">" . _MODULEOFF . "<br /><br /><a href=\"javascript:history.back()\"><b>" . _BACK . "</b></a><br /><br /></div>";
    closetable();
} 
else if ($level_access == 1 && $visiteur == 0)
{
    opentable();
    echo "<br /><br /><div style=\"text-align: center;\">" . _USERENTRANCE . "<br /><br /><b><a href=\"index.php?file=User&op=login_screen\">" . _LOGINUSER . "</a> | <a href=\"index.php?file=User&op=reg_screen\">" . _REGISTERUSER . "</a></b><br /><br /></div>";
    closetable();
} 
else
{
    opentable();
    echo "<br /><br /><div style=\"text-align: center;\">" . _NOENTRANCE . "<br /><br /><a href=\"javascript:history.back()\"><b>" . _BACK . "</b></a><br /><br /></div>";
    closetable();
} 

?>

Re: n'autoriser que 30 catégories sur l'index de ma gallerie

Posté : 28 nov. 2011, 20:46
par xTG
Sans plus de questions je me permet de te rediriger vers un tutorial : http://www.phpdebutant.org/article84.php

Re: n'autoriser que 30 catégories sur l'index de ma gallerie

Posté : 28 nov. 2011, 21:35
par Stefan-allen
Merci ,
Désolé, mai je n’arrive pas mettre en œuvre l'exercice.
Je sais que ma modification doit être ainsi :
mes je n’arrive pas a crée un lien page suivante a droite et une page précédent a gauche du titre
(les pointiller ( ----- ) encadre la partie modifier de mon code)

Code : Tout sélectionner

opentable(); echo "<br /><div style=\"text-align: center;\"><big><b>" . $title . "</b></big></div>\n" . "<div style=\"text-align: center;\"><br />\n" . "[ " . _INDEXGALLERY . " | " . "<a href=\"index.php?file=Gallery&op=classe&orderby=news\" style=\"text-decoration: underline\">" . _NEWSIMG . "</a> | " . "<a href=\"index.php?file=Gallery&op=classe&orderby=count\" style=\"text-decoration: underline\">" . _TOPIMG . "</a> | " . "<a href=\"index.php?file=Suggest&module=Gallery\" style=\"text-decoration: underline\">" . _SUGGESTIMG . "</a> ]</div><br />\n"; $sql_nbimages = mysql_query("SELECT sid FROM " . GALLERY_TABLE . ""); $nb_images = mysql_num_rows($sql_nbimages); $sql_nbcat = mysql_query("SELECT cid FROM " . GALLERY_CAT_TABLE . ""); $nb_cat = mysql_num_rows($sql_nbcat); if ($nb_cat > 0) { echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\"><tr><td>"; ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- $sql_cat = mysql_query("SELECT cid, titre, description FROM " . GALLERY_CAT_TABLE . " WHERE parentid = '0' ORDER BY sid DESC LIMIT 0, 30"); if ( isset ( $_REQUEST['p'] ) && $_REQUEST['p'] > 0 ) { $limit_max = $_REQUEST['p'] * 30; // si p = 2, limite = 60 |si p = 3, limite = 90 | etc $limit_min = ( $_REQUEST['p'] * 30 ) - 30; // si p = 2, limite = 30 |si p = 3, limite = 60 | etc $sql_cat = mysql_query("SELECT cid, titre, description FROM " . GALLERY_CAT_TABLE . " WHERE parentid = '0' ORDER BY sid DESC LIMIT '" . $limit_min . "', '" . $limit_max . "'"); -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Re: n'autoriser que 30 catégories sur l'index de ma gallerie

Posté : 28 nov. 2011, 21:43
par xTG
Il suffit de faire un lien vers la page courante en précisant le paramètre p incrémenté de 1 ou décrémenté de 1. :)
C'est expliqué dans l'article, cela se trouve en milieu de page sous le titre "Calcul de la nouvelle limite d'affichage" pour l'initialisation et un peu plus bas "Affichage du lien précedent si besoin" pour le lien.

Re: n'autoriser que 30 catégories sur l'index de ma gallerie

Posté : 28 nov. 2011, 21:54
par Stefan-allen
Il suffit de faire un lien vers la page courante en précisant le paramètre p incrémenté de 1 ou décrémenté de 1. :)
C'est expliqué dans l'article, cela se trouve en milieu de page sous le titre "Calcul de la nouvelle limite d'affichage" pour l'initialisation et un peu plus bas "Affichage du lien précédent si besoin" pour le lien.
Justement c'est sa que je n’arrive pas a faire a chaque foi que je tente quelque chose dreamweaver m'indique une erreur ...

Re: n'autoriser que 30 catégories sur l'index de ma gallerie

Posté : 29 nov. 2011, 07:53
par xTG
Montres nous ce que tu as essayé. :)
Heures au format UTC+02:00
Page 1 sur 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/