Tips Blog

Welcome to our technical tips blog – solutions and answers for numerous Joomla, Wordpress, Magento, Linux, MySQL and other problems.
 

Add admin user to wordpress using MySQL?

INSERT INTO `wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES (‘3’, ‘USERNAME’, MD5(‘PASSWORD’), ‘NAME’, ‘EMAIL@HOST.COM’, ‘https://www.startnet.co.uk/’, ‘2013-06-07 00:00:00’, ”, ‘0’, ‘NAME’);   INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, ‘3’, ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’);   INSERT INTO

read more

Allow duplicate email addresses in Joomla 2.5 user logins

To remove the duplicate e-mail address check in Joomla 2.5 – though beware of password resetting functions. Edit file: libraries/joomla/database/table/user.php Comment out the lines below: Line: 238 if ($xid && $xid != intval($this->id))        {        // XXX ALLOW DUPLICATE

read more

Getting font-face to work on ALL browsers – Chrome, Firefox and IE

Usage : use CSS declarations like below – this should work on Chrome, Firefox, IE7, IE8, IE9 on PC and Apple Mac – iphone/ipad : @font-face { font-family: ‘newbaskervillestd-italic-webfont’; src: url(‘/includes/js/fonts/newbaskervillestd-italic-webfont.eot’); /* IE9 Compat Modes */ src: url(‘/includes/js/fonts/newbaskervillestd-italic-webfont.eot?#iefix’) format(’embedded-opentype’); /*

read more

Allow access to MYSQL database for a specific user only

To grant full permissions : mysql> grant all privileges on database_name.* to ‘username’@’localhost’; Query OK, 0 rows affected (0.09 sec) mysql> flush privileges;Query OK, 0 rows affected (0.09 sec)mysql -uusername -p mysql> show databases… To Revoke all permissions : mysql>

read more

Recursively download entire website all files

To download all files on a website using ‘wget’ use: wget -r -nH –cut-dirs=1 –no-parent -e robots=off pawie.amiciscemi.org/temp/ -r = recursive -nH =–no-host-directories – remove www.site.com from saved folder–cut-dirs=1 = remove /folder from saved folder–no-parent = do not go above

read more

Quickly get copyable list of links from Google about a site

Type into Google:  link:https://www.startnet.co.uk this will list all the links from startnet.co.uk Save the page as “page.html” edit and paste this at the end, then redisplay in your web browser. <script src=”http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js”></script> <script>$(‘span.st,.s’).remove();$(‘h3’).css(‘overflow’,’visible’);$(‘h3 a’).each(function(e) {var t=$(this).attr(‘href’);$(this).text(t);});</script> Done