ezPortal

[vbgamer45]

I guess my next question does the built in ezPortal SMF Gallery Block not do what you need it to do? If we are just showing images?

[mickjav]

No The built in blocks only deal with pictures not the galleries themselves, Not sure what I've done     

[vbgamer45]

Can't it be done with these settings? Or do you need something more. There is a category id option


Still a little confused then. When you say galleries? What do you want to show? If not pictures from inside the gallery category?

[mickjav]

Not seen that one I'll look see if I can find it thanks

[mickjav]

These are the blocks I have plus the standard html

I'm on 5.1 2.0.19 Will upgrading sort it??

You cannot view this attachment.

[vbgamer45]

It might if you never upgraded before strange might be an issue with the transfer from createaforum.

[mickjav]

It might if you never upgraded before strange might be an issue with the transfer from createaforum.

I'll Upgrade to 5.5 After work tomorrow I do remember you having to add the php Block as was disabled on the createaforum

I'm using the latest version of gallery pro 9.0.1

[mickjav]

Just Checked the DB Blocks table against my test Sites Db there are a number missing from my db, Can I just copy missing rows from test db??

All the best mick

[vbgamer45]

I would not since the id's from the tables would probably be off and cause other issues.

[mickjav]

OK do the IDs need to match any code elements as could export table with missing data and adjust ids???

[mickjav]

Got It working Final Code below.

Code Select Expand

global $txt, $smcFunc, $scripturl;

//Get the latest 4 Galleries
$dbquery = $smcFunc['db_query']('', '
    SELECT c.id_cat, c.image, c.id_parent
    FROM {db_prefix}gallery_cat AS c
    WHERE c.id_parent = 35
ORDER BY c.id_cat DESC
LIMIT 4');
 
if ($smcFunc['db_affected_rows']() != 0)
    {
echo '<table border="0" Width="100%"><tbody><tr>';

while($row = $smcFunc['db_fetch_assoc']($dbquery))
{
//Get Each Row
$cat_url = $scripturl . '?action=gallery;cat=' . $row['id_cat'];
echo  '<td  style="text-align: center;"><a href="' . $cat_url . '"><img src="' . $row['image'] . '" alt="" /></a></td>';

}

echo '</tr></tbody></table>';
}
$smcFunc['db_free_result']($dbquery);
To Say I was happy to get it working was putting it mildly     

Because I had spliced it together from another mod I had built I made a simple mistake in that I have 2 $dbquery for query and another vartible for the loop lol, live and learn 

[vbgamer45]

Glad you have it working. What you made here is not possible with an ezblock since it is just displaying the custom category icon for each gallery.

[mickjav]

I've now completed works on this block to where I need it for music & charts site should anybody wish to make use of this block
I've posted the code to my code library

Moving on to next block 

[Shades.]

I've now completed works on this block to where I need it for music & charts site should anybody wish to make use of this block
I've posted the code to my code library

Moving on to next block 

Do ya have a screenshot?

[mickjav]

There you go but am trying to edit the sql without much luck

I want to make sure there is a images

Code Select Expand

WHERE c.id_parent = 35 AND c.image <> ''
You cannot view this attachment.

[mickjav]

I've updated my latest galleries block so that is wont display categories without a image

https://www.databasedreams.co.uk/support/index.php?action=showcases;sa=view;id=55

[mickjav]

Just upgraded to 2.1 And loving the New blocks Latest Downloads, Random Pictures & Select Theme plus others

https://www.databasedreams.co.uk/charts/index.php

Got to say thanks to @Diego Andrés for upgrading.

I have a issue with the latest version of EZ Portal 5.5

All My blocks work on left, Middle but the right side wont display on the right but shows at bottom.

The paypal and blocks below should display on right
You cannot view this attachment.

The only time I could get the blocks to display on right was if I disabled all blocks on left

You cannot view this attachment.

I did think it was a problem with a block but after diableing them one at a time I could not correct it

[vbgamer45]

I think it is due to too many images in random pictures block which pushes it down "Random Pictures" try less images across.

[mickjav]

Disabled that block but no luck, the problem is not limited to the portal but covers the whole forum for all pages it is set to display on.

[vbgamer45]

Confirmed have to see what changed/happened.