Topics

User Functions

Events

There are no upcoming events

What's New

Stories last 2 weeks

No new stories

Comments last 2 weeks

No new comments

Trackbacks last 2 weeks

No new trackback comments

Links last 2 weeks

No recent new links

NEW FILES last 14 days

No new files

Welcome to Geeklog Friday, April 18 2014 @ 11:45 AM EDT


 Forum Index > Development & Coding > Geeklog New Topic Post Reply
 FYI - Media Gallery - Random Image block not available
   
MartinD
 02/21/13 09:07AM (Read 765 times)  
+----
Newbie

Status: offline


Registered: 01/15/13
Posts: 11
When you install Media Gallery in GL2 it works fine but the Random Image block will not be available.
The following install script will fail due to the new Topic feature (Multiple) as the Tid column is gone from new block structure. It's easy to fix by changing the insert statement to remove the tid and value ("all"Wink from the script (BLOCK insert) and by manually adding a record to the (your table prefix)topic_assignments table.

install script

PHP Formatted Code

    DB_query("INSERT INTO {$_TABLES['blocks']} (is_enabled, name, type, title, [b]tid[/b], blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, help, group_id, owner_id, perm_owner, perm_group, perm_members,perm_anon) VALUES (0, 'mgrandom', 'phpblock', '" . $LANG_MG00['mg_block_header'] . "', 'all', 0, '', '', 0, 1, 'phpblock_mg_randommedia','', 4, 2, 3, 3, 2, 2);",1);

    DB_query("INSERT INTO {$_TABLES['blocks']} (is_enabled, name, type, title, [b]tid[/b], blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, help, group_id, owner_id, perm_owner, perm_group, perm_members,perm_anon) VALUES (0, 'mgenroll', 'phpblock', '" . $LANG_MG00['mg_enroll_header'] . "', 'all', 0, '', '', 0, 1, 'phpblock_mg_maenroll','', 4, 2, 3, 3, 2, 0);",1);
 

my BLOCK insert statement
PHP Formatted Code

INSERT INTO cgc_blocks (is_enabled, name, type, title,  blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, help, group_id, owner_id, perm_owner, perm_group, perm_members,perm_anon) VALUES (1, 'mgrandom', 'phpblock', 'Random Image', 0, '', '', 0, 1, 'phpblock_mg_randommedia','', 4, 2, 3, 3, 2, 2);

INSERT INTO cgc_blocks (is_enabled, name, type, title,  blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, help, group_id, owner_id, perm_owner, perm_group, perm_members,perm_anon) VALUES (0, 'mgenroll', 'phpblock', 'Album Enrollment', 0, '', '', 0, 1, 'phpblock_mg_maenroll','', 4, 2, 3, 3, 2, 0);
 

my TOPIC_ASSIGMENTS insert
PHP Formatted Code

INSERT INTO cgc_topic_assignments (`tid` ,`type` ,`id` ,`inherit` ,`tdefault` ) VALUES ('All', 'block', '16', '0', '0'),

INSERT INTO cgc_topic_assignments (`tid` ,`type` ,`id` ,`inherit` ,`tdefault` ) VALUES ('All', 'block', '18', '0', '0');
 

(16 & 18 are the block ids from the BLOCK table)


Hope this Helps (someone)

 
Profile Email
 Quote
Laugh
 02/22/13 10:17AM  
AAAAA
Admin

Status: offline


Registered: 09/27/05
Posts: 998
Thanks for the fix MartinD.

I know the Media Gallery is being worked on at the moment so hopefully in the near future it will be released with the fix and some new features.

 
Profile Email Website
 Quote
Content generated in: 1.00 seconds
New Topic Post Reply

Normal Topic Normal Topic
Sticky Topic Sticky Topic
Locked Topic Locked Topic
New Post New Post
Sticky Topic W/ New Post Sticky Topic W/ New Post
Locked Topic W/ New Post Locked Topic W/ New Post
View Anonymous Posts 
Able to post 
Filtered HTML Allowed 
Censored Content