Remove exim queue mail in console
After stopped the spam, I need to clear the spam queue in exim [code lang="shell"] exim -bp | awk ‘/^ *[0-9]+[mhd]/{print "exim -Mrm " $3}’ | bash [/code]
Remove exim queue mail in console Read More »
2015
Remove WordPress Malware using Linux Shell Console
I’ve a lot of wordpress sites, recently few of my old sites infected malware, and those spammer using few of my sites to spam email. I would like to share the way I fix this. Most of the spammer look for the 777 path, most properly in /wp-content/uploads/ So I try to scan all the php files that they upload there with date. find ./public_html/wp-content/uploads/ -type f -name ‘*.php’ -printf ‘%TY-%Tm-%Td %TT %p\n’ | sort Then I found these 2015-10-16 12:25:01 ./wp-content/uploads/2013/05/blog84.p[…]
Remove WordPress Malware using Linux Shell Console Read More »
Optimize MySQL order by RAND()
It is not recommended to use ORDER BY RAND() only, it will slow for query large database like over 50,000 rows. The easiest way to optimize existing code, just add RAND()< (SELECT ((1/COUNT())10) FROM Table_name) after the WHERE before the ORDER, this sub query will speed up the select random from the table. Using this
Optimize MySQL order by RAND() Read More »
ERROR: IITC failed to extract the required parameters from the intel site
I’ve got the error by using IITC for Ingress today IITC failed to extract the required parameters from the intel site This can happen after Niantic update the standard intel site. A fix will be needed from the IITC developers. [code lang="javascript"] var reVersion = new RegExp(‘[a-z]=[a-z].getData();[a-z].v="([a-f0-9]{40})";’); var reVersion = new RegExp(‘[a-z].v="([a-f0-9]{40})";’); var minified =
ERROR: IITC failed to extract the required parameters from the intel site Read More »
How to rename rename *.png.png to *.png in Mac OS terminal
I always use this way to rename .png.png to .png [code lang="shell"] find ./ -name ‘*.png.png’ -type f \ -exec sh -c ‘mv {} ./$(basename -s .png.png {}).png’ \; [/code]
How to rename rename *.png.png to *.png in Mac OS terminal Read More »
exit code of #128 fatal: unable to connect to github.com
I follow the Quickstart guide from FoundationPress and it display this error [code lang="bash"] bower install && grunt build bower foundation# not-cached git://github.com/zurb/bower-foundation.git# bower foundation# resolve git://github.com/zurb/bower-foundation.git# bower fontawesome#~4.3.0 not-cached git://github.com/FortAwesome/Font-Awesome.git#~4.3.0 bower fontawesome#~4.3.0 resolve git://github.com/FortAwesome/Font-Awesome.git#~4.3.0 bower fontawesome#~4.3.0 ECMDERR Failed to execute "git ls-remote –tags –heads git://github.com/FortAwesome/Font-Awesome.git", exit code of #128 fatal: unable to connect to
exit code of #128 fatal: unable to connect to github.com Read More »
libpng error: IDAT: CRC error
I receive this error message while using wkhtmltoimage. In Mac, it it not allow you to use Preview to save to other format. It will display cannot write, or enable to save. The fastest way to solve this problem, can be done in Automator, you can use Photo -> Flip Image -> Flip Image then
libpng error: IDAT: CRC error Read More »
Data from SoftBank Ultra Link in Ingress
I’ve pull out the date from the game Ingress, the Mod SoftBank Ultra Link. So confirm that it added 8 out going links, and increate the range multiplier, and do not have stickiness, and increase the link defense boost. If you do not have any link, then the defense boost does not apply. Very Rare
Data from SoftBank Ultra Link in Ingress Read More »
Data from MUFG Capsule in Ingress
I farm out the MUFG Capsule I’ve trace out the data from the game Ingress by Google, maybe can find out some reference data from here. I’ve put Jarvis, ADA, Very Rare Heat Sink, Very Rare Multi-Hack into the MUFG Capsule. [code lang="js"] { "result": [ ["72e55d5658db455db78093b6f0682c67.5", 1434910286425, { "moniker": { "differentiator": "D6F55A77" }, "resource":
Data from MUFG Capsule in Ingress Read More »