Difference between revisions of "Joomla"
From Alessandro's Wiki
(2 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
Joomla is a CMS system based on [http://www.php.net | Joomla is a CMS system based on [http://www.php.net php]. | ||
Line 17: | Line 15: | ||
* Joomla 1.6 | * Joomla 1.6 | ||
* Joomla 2.5 | * Joomla 2.5 | ||
== tricks == | |||
=== Themes === | |||
* view site with different template: | |||
http://www.site.com/?template=rhuk_milkyway | |||
== plugins == | == plugins == | ||
Line 40: | Line 43: | ||
VALUES (LAST_INSERT_ID(),'8'); | VALUES (LAST_INSERT_ID(),'8'); | ||
</source> | </source> | ||
'''SQL code for use with Joomla 1.5.xx{{JVer|1.5}}''' | '''SQL code for use with Joomla 1.5.xx{{JVer|1.5}}''' | ||
Line 53: | Line 55: | ||
INSERT INTO `jos_core_acl_groups_aro_map` | INSERT INTO `jos_core_acl_groups_aro_map` | ||
VALUES (25, '', LAST_INSERT_ID()); | 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> | </source> |
Latest revision as of 13:51, 23 January 2013
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
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');
SQL code for use with Joomla 1.5.xxTemplate:JVer
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());
SQL code for Joomla 1.x passwd: "admin".
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.