How to Visible in Modules Block with a simple script?

Posted: Sat Aug 20, 2011 5:29 am

Hi Guys. I wonder if if there is a better way to make all your modules visible with a simple script. I do know if you go to ADMINISTRATOR/MODULES/EDIT you can make them visible but what if you have many of them and 100 times u will need to click on edit. Could it be done from phpMyadmin? Question

Any suggestion? Thanks in advance Wink

registered · Posted: Sat Aug 20, 2011 8:09 am

Wow, no-one has every expressed this need before as it is quite unusual for someone to want/need all the modules or have that many.

Since I would assume this to be a one-time exercise, yes, I would suggest just using whatever SQL tool your host provides (most likely phpMyAdmin). The SQL is fairly simple to create with phpMyAdmin's with even a nice user interface.

Posted: Sat Aug 20, 2011 8:15 am

I don't see any tool which my host provides but if you give me some examples o names of any script could do the job. I still want to do that. Thanks montego.

Edited:

Well I found the table who should be edit it but how to make them all active

Table: nuke_modules

This table has the following options

Code:

mid 


title 


custom_title


active   


view    


groups    


inmenu    


mod_group    


admins

If inmenu=0 then is not visible on your block
If inmenu=1 then is shows properly to be visible on your block

Montego, any help will be appriciated. Very Happy

Posted: Sat Aug 20, 2011 8:58 am

I found out how to do it Montego.

I went to phpMyadmin

I delete inmenu table from nuke_modules and I add the following code in

Run SQL query/queries

Code:

ALTER TABLE `nuke_modules` ADD  `inmenu` tinyint(1) DEFAULT '1' AFTER `groups`;

Now all my module in the blocks are visible.

Very Happy

Posted: Sat Aug 20, 2011 1:52 pm

Hmm... glad this issue was raised.. I'll have to keep this in mind when I rework the modules/blocks administration.

Posted: Sun Aug 21, 2011 11:48 am

Well, the following would have been a simple SQL statement to update them all:

Code:




UPDATE nuke_modules SET inmenu = '1'

I haven't looked at the code which inserts new modules, but I suspect it will be overriding the default?

Posted: Sun Aug 21, 2011 4:49 pm

Is is this one gonna do the same as I did? Looks like really easy Montego. xD

Posted: Mon Aug 22, 2011 7:54 pm

unicornio wrote:

Is is this one gonna do the same as I did? Looks like really easy Montego. xD

Have you even verified that a new user on your site has the default set properly using your method? Mine is a one time fix...