Joomla: Difference between revisions

From Alessandro's Wiki
No edit summary
No edit summary
Line 29: Line 29:
* upgrading from 1.5.22 to 1.7: need some dependencies:
* upgrading from 1.5.22 to 1.7: need some dependencies:
**  php5-curl
**  php5-curl
== password recover ==
'''SQL code for use with Joomla 1.6.xx{{JVer|1.6}} 2.5.x{{JVer|2.5}} 3.0.x{{JVer|3.0}} '''
<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.xx{{JVer|1.5}}'''
<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>

Revision as of 16:29, 26 November 2012

Joomla is a CMS system based on [1].



History

  • Mambo 1
  • Joomla 1.0
  • [...]
  • Joomla 1.0.21
  • Joomla 1.5
  • [...]
  • Joomla 1.5.22


  • Joomla 1.6


plugins

JUpgrade

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


password recover

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>