Create joomla 1.5 admin

This is something I do often enough to not want to google it .. Step 1 Create the new Joomla! User REPLACE INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES (’60’, ‘Admin2’, ‘admin2’, ‘user@usersemailaddress’, ‘21232f297a57a5a743894a0e4a801fc3:abcdefghijklmnopqrstuvwxyz012345’, ‘Super Administrator’, ‘0’, ‘0’, ’25’, ‘2000-01-01 00:00:00’, ‘0000-00-00 00:00:00’, ”, ”); The
Continue reading: Create joomla 1.5 admin

moving data in sql

So after searching around the web looking for code to get data from one table intop another I found this example posted on the mysl dev forum mysql> INSERT INTO orders (customer_cust_id, orderdatetime, message, taxrate, shippingprice) -> SELECT ‘1’, NOW(), null, taxrate, shippingprice FROM customer -> WHERE cust_id=’1′; Query OK, 1 row affected (0.01 sec)
Continue reading: moving data in sql