Remove exim queue mail in console
After stopped the spam, I need to clear the spam queue in exim
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. Reference: https://github.com/dwinss/ingress-intel-total-conversion/commit/26c7616d0f8e070451e455e70003c47f1bb279a2 Click the Tampermonkey Button at the Top Right of your Google Browser Click
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
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 I run this to solve this problem.
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.
Data from MUFG Capsule in Ingress Read More »