pertinax napísal/a:
-------------------------------------------------------
> pa3k
>
> ahoj,
>
> mohol by si prosim ta blizsie popisat tie upravy
> pripojenia galerie k clanku?
>
> Uvazujem o takomto pripojeni galerie k clanku, ale
> sam si na to zatial netrufam.
>
> Predpokladam ale, ze jednu galeriu bude mozne
> pripojit k viacerym clankom.
>
> Vdaka
>
>
Ahoj,
úprava spočíva v pridaní poľa id_gallery do tabuľky článkov a v úprave súborov:
trclanek.php:
// dotaz
$dotaz="select c.idc,c.link,c.seo_link,c.titulek,c.uvod,c.text,c.tema,date_format(c.datum,'%d.%m.%Y') as vyslden,c.autor,c.kom,c.visit,c.t_slova,";
$dotaz.="c.visible,c.zdroj,c.skupina_cl,c.znacky,c.typ_clanku,c.sablona,c.level_clanku,c.anketa_cl,l.hodnota as level_hodnota, c.id_gallery ";
$dotaz.="from ".$GLOBALS["rspredpona"]."clanky as c, ".$GLOBALS["rspredpona"]."levely as l ";
$dotaz.="where c.link='".$link."'".$dotaz_where;
.
.
.
case "id_gallery": return $this->clanek["id_gallery"]; break;
search.php:
// sestaveni kompletniho dotazu
if ($GLOBALS['rsvelikost']=='sab'):
$dotaz="SELECT c.idc,c.link,c.seo_link,c.titulek,c.uvod,c.text,c.tema,date_format(c.datum,'%d. %m. %Y') as vyslden,c.autor,c.kom,c.visit,c.t_slova,c.visible,c.zdroj,c.skupina_cl,c.znacky,c.typ_clanku,c.sablona,c.level_clanku,c.anketa_cl,l.hodnota as level_hodnota, c.id_gallery ";
$dotaz.="FROM ".$GLOBALS["rspredpona"]."clanky as c, ".$GLOBALS["rspredpona"]."levely as l WHERE ".$obsah_podminky." c.visible=1 AND c.datum<='".$dnesni_datum."' AND c.level_clanku=l.idl ORDER BY ".$dotaz_tridit." LIMIT ".$limit_start.",".$limit_kolik;
else:
$dotaz="SELECT c.link,c.seo_link,c.titulek,c.uvod,date_format(c.datum,'%d.%m.%Y') as vyslden,c.tema,c.autor,c.znacky ";
$dotaz.="FROM ".$GLOBALS["rspredpona"]."clanky as c, ".$GLOBALS["rspredpona"]."levely as l WHERE ".$obsah_podminky." c.visible=1 AND c.datum<='".$dnesni_datum."' AND c.level_clanku=l.idl ORDER BY ".$dotaz_tridit." LIMIT ".$limit_start.",".$limit_kolik;
endif;
$dotazvysledek=phprs_sql_query($dotaz,$GLOBALS["dbspojeni"]);
$pocetvysledek=phprs_sql_num_rows($dotazvysledek);
endif;
admin/aarticles.php:
function GenerujZoznamGalerii($idgal = 0) {
$sql = 'SELECT ids, nazev FROM '.$GLOBALS["rspredpona"].'imggal_sekce';
$result = phprs_sql_query($sql,$GLOBALS["dbspojeni"]);
$str = '';
while ($row = phprs_sql_fetch_assoc($result)) {
if ($row['ids']==$idgal) {
$str .= '<option value="'.$row['ids'].'" selected>'.$row['nazev'];
} else {
$str .= '<option value="'.$row['ids'].'">'.$row['nazev'];
}
}
return $str;
}
.
.
.
"25\" class=\"textpole\" /><br />".RS_CLA_CL_FORM_DATUM_INFO."</td></tr>
<tr class=\"txt\"><td align=\"left\"><b>Pripojená fotogaléria</b></td>
<td align=\"left\"><select name=\"id_gallery\"><option value=\"0\"> - ".GenerujZoznamGalerii()."</select></td></tr>
<tr class=\"txt\"><td align=\"left\"><b>".RS_CLA_CL_FORM_AUTOR."</b></td>
.
.
.
$GLOBALS["aeskupina"]=phprs_sql_escape_string($GLOBALS["aeskupina"]);
$GLOBALS["id_gallery"]=(int)$GLOBALS["id_gallery"];
$akt_je_admin=$GLOBALS['Uzivatel']->JeAdmin();
.
.
.
// pridani clanku
$dotaz="insert into ".$GLOBALS["rspredpona"]."clanky ";
$dotaz.="values(null,'".$GLOBALS["aelink"]."','".$nast_seo_link."','".$GLOBALS["aetitulek"]."','".$GLOBALS["aeuvod"]."','".$GLOBALS["aetext"]."','".$GLOBALS["aetema"]."',";
$dotaz.="'".$GLOBALS["aedatum"]."','".$GLOBALS["aeautor"]."',".$nast_kom.",".$nast_visit.",'".$GLOBALS["aeslova"]."','".$nast_visible."','".$GLOBALS["aezdroj"]."',";
$dotaz.="'".$GLOBALS["aepriorita"]."','".$GLOBALS["aedatumpl"]."','".$GLOBALS["aeskupina"]."',".$nast_hod.",'".$nast_mn_hod."','".$GLOBALS["aeznacky"]."',";
$dotaz.="'".$GLOBALS["aetypcla"]."','".$GLOBALS["aesablona"]."','".$nast_level."','".$nast_index."','".$GLOBALS["aeanketa"]."','".$GLOBALS["id_gallery"]."')";
@$error=phprs_sql_query($dotaz,$GLOBALS["dbspojeni"]);
článkové šablóny:
// ------------------------------------ [dl. clanek cely] ------------------------------------
echo '
<div class="cla-cely">
<h1 class="cla-nadpis">'.$GLOBALS["clanek"]->Ukaz("titulek").'</h1>
<div class="cla-obsah">
<div class="cla-text">
'.$GLOBALS["clanek"]->Ukaz("uvod").'
<br>
<br>
'.$GLOBALS["clanek"]->Ukaz("text").'
</div>';
$id_gallery = $GLOBALS["clanek"]->Ukaz("id_gallery");
if ($id_gallery != 0) {
$GLOBALS['detail'] = $id_gallery;
include_once("fotky.php");
}
SouvisejiciCl($GLOBALS["clanek"]->Ukaz("link"));
echo '
</div>
</div>';
// -------------------------------- [konec - dl. clanek telo] --------------------------------
nakoniec súbor fotky.php zabezpečí samotný výpis galérie a prehliadanie je pomocou JS - lightbox[roadtrip)