After stopped the spam, I need to clear the spam queue in exim exim -bp | awk ‘/^ *[0-9]+[mhd]/{print “exim -Mrm ” $3}’ | bash
Yearly Archives: 2015
Remove WordPress Malware using Linux Shell Console
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 Continue reading “Optimize MySQL order by RAND()”
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. – 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 Continue reading “ERROR: IITC failed to extract the required parameters from the intel site”
How to rename rename *.png.png to *.png in Mac OS terminal
I always use this way to rename *.png.png to *.png find ./ -name ‘*.png.png’ -type f \ -exec sh -c ‘mv {} ./$(basename -s .png.png {}).png’ \;
exit code of #128 fatal: unable to connect to github.com
I follow the Quickstart guide from FoundationPress and it display this error 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 github.com: github.com[0: Continue reading “exit code of #128 fatal: unable to connect to github.com”
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 Continue reading “libpng error: IDAT: CRC error”
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 Continue reading “Data from SoftBank Ultra Link in Ingress”
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. { “result”: [ [“72e55d5658db455db78093b6f0682c67.5”, 1434910286425, { “moniker”: { “differentiator”: “D6F55A77” }, “resource”: { “resourceType”: Continue reading “Data from MUFG Capsule in Ingress”