Joomla

From Alessandro's Wiki
Jump to navigation Jump to search

Joomla is a CMS system based on php.


History

  • to get Joomla's version from the filesystem:
egrep '(\$DEV_LEVEL|\$RELEASE)' libraries/joomla/version.php 
  • Mambo 1
  • Joomla 1.0
  • [...]
  • Joomla 1.0.21
  • Joomla 1.5
  • [...]
  • Joomla 1.5.26
  • Joomla 1.6
  • Joomla 2.5

tricks

Themes

  • view site with different template:
http://www.site.com/?template=rhuk_milkyway

plugins

JUpgrade

  • upgrading from 1.5.22 to 1.7: need some dependencies:
    • php5-curl


password recover

  • this will add a user admin2 with password secret , just change it as soon as you log in again into it

SQL code for use with Joomla 1.6.xxTemplate:JVer 2.5.xTemplate:JVer 3.0.xTemplate:JVer

<source lang="sql">INSERT INTO `jos_users`

  (`name`, `username`, `password`, `params`)

VALUES ('Administrator2', 'admin2',

   'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199', );

INSERT INTO `jos_user_usergroup_map` (`user_id`,`group_id`) VALUES (LAST_INSERT_ID(),'8'); </source>

SQL code for use with Joomla 1.5.xxTemplate:JVer

<source lang="sql">INSERT INTO `jos_users`

  (`name`, `username`, `password`, `usertype`, `gid`, `params`)

VALUES ('Administrator2', 'admin2',

   'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199',
   'Super Administrator', 25, );

INSERT INTO `jos_core_acl_aro` VALUES (NULL, 'users', LAST_INSERT_ID(), 0, 'Administrator2', 0); INSERT INTO `jos_core_acl_groups_aro_map` VALUES (25, , LAST_INSERT_ID()); </source>

SQL code for Joomla 1.x passwd: "admin". <source lang="sql"> UPDATE mos_users SET password = '21232f297a57a5a743894a0e4a801fc3' WHERE username='admin'


INSERT INTO `jos_users` VALUES

   (161, 'Administrator3', 'admin3', 'abc@defg', '21232f297a57a5a743894a0e4a801fc3',  
   'Super Administrator', 0, 1, 25, '2005-09-28 00:00:00', '2005-09-28 00:00:00', , );# 1 row affected.

INSERT INTO `jos_core_acl_aro` VALUES (111,'users','161',0,'Administrator3',0);# 1 row affected. INSERT INTO `jos_core_acl_groups_aro_map` VALUES (25,,111);# 1 row affected.

</source>