hi amiga
ist es möglich beim album stats dass die bilder
in den persönlichen gallerien nicht angezeigt werden ???
wenn ja wie mache ich as ???
bitte um antwort
Could not obtain last pic data
DEBUG MODE
SQL Error : 1054 Unknown column 'cat_user_id' in 'field list'
SELECT pic_id, pic_title, pic_time, pic_desc, cat_user_id, pic_username, pic_user_id FROM phpbb_album WHERE pic_approval = 1 AND pic_lock = 0 # Don't show if picture locked AND cat_user_id = 0 # Don't show personal gallery pictures ORDER BY pic_time DESC LIMIT 1
Line : 1123
File : portal.php
#
#----------[ FIND ]-------------------------------------
#
$sql = "SELECT pic_id, pic_title, pic_time, pic_desc, pic_username, pic_user_id FROM " . ALBUM_TABLE . "
WHERE pic_approval = 1
AND pic_lock = 0 # Don't show if picture locked
ORDER BY pic_time DESC
LIMIT 1";
#
#----------[ REPLACE WITH ]-----------------------------
#
$sql = "SELECT p.pic_id, p.pic_title, p.pic_time, p.pic_desc, p.pic_username, p.pic_user_id, p.pic_cat_id, c.cat_id, c.cat_user_id
FROM " . ALBUM_TABLE . " AS p, " . ALBUM_CAT_TABLE . " AS c
WHERE p.pic_approval = 1
AND p.pic_lock = 0 # Don't show if picture locked
AND c.cat_id = p.pic_cat_id
AND c.cat_user_id = 0 # Don't show personal gallery pictures
ORDER BY p.pic_time DESC
LIMIT 1";
Mitglieder in diesem Forum: 0 Mitglieder und 0 Gäste