Drupal module order

List your sites activated modules.

SELECT `name` , `status` , `weight` FROM `system` WHERE `type` = 'module' AND `status` =1 ORDER BY weight ASC LIMIT 0 , 200

Compare your sites activated modules with an other sites modules list in the same database.


SELECT com.name , com.status , com.weight,   bas.name , bas.status , bas.weight FROM `biogaia_system` as com left join basicsite.system as bas on com.name=bas.name WHERE com.`type` = 'module' AND com.`status` =1 ORDER BY com.weight ASC LIMIT 0 , 200 

SELECT com.name , com.status , com.weight,   bas.name , bas.status , bas.weight FROM basicsite.system as bas left join biogaia_com.`biogaia_system` as com on com.name=bas.name WHERE bas.`type` = 'module' AND bas.`status` =1 ORDER BY bas.weight ASC LIMIT 0 , 200

What is missing

SELECT bas.name , bas.status , bas.weight, com.name , com.status , com.weight FROM basicsite.system as bas left join biogaia_com.`biogaia_system` as com on com.name=bas.name WHERE bas.`type` = 'module' AND bas.`status` =1 and com.name IS NULL

Below you find a link to an instruction to manipulate your module to end up in the right order according to other modules.

Knowledge keywords: