Vincenzo Amoruso IT Lab

word press update count

2017-01-08T06:43:00.001-08:00

UPDATE wpyn_term_taxonomy SET count = (
SELECT COUNT(*) FROM wp_term_relationships rel 
    LEFT JOIN wpyn_posts po ON (po.ID = rel.object_id)

    WHERE 
        rel.term_taxonomy_id = wpyn_term_taxonomy.term_taxonomy_id

        AND 
        wpyn_term_taxonomy.taxonomy NOT IN ('link_category')

        AND 
        po.post_status IN ('publish', 'future')
)

crafty javascript game engine

2014-07-13T09:02:00.002-07:00

http://craftyjs.com/

Image library effects

2014-07-13T08:12:00.000-07:00

The glfx.js library make effects on photo.

http://evanw.github.io/glfx.js/demo/

New translator landed

2014-06-06T22:50:00.001-07:00

Available on itunes

xcode phonegap linker error libCordoba.a

2014-03-03T10:26:00.001-08:00

Problem when build for appstore app that use Phonegap?
Here how to fix linker error in xcode

Cordova admob together on ios

2014-01-06T09:47:00.003-08:00

Cordova admob together on ios

Phonegap/cordova setup windows

2014-01-05T04:58:00.000-08:00

From docs.phonegap.com

Follow these steps

Download and Install node.js from http://nodejs.org/
Run the command npm install -g phonegap (in case of phonegap installation) or run the command npm install -g cordova (in case of Cordova installation).

As the installation gets completed you can notice this:

C:\Users\binaryuser\AppData\Roaming\npm\cordova -> C:\Users\binaryuser\AppData\Roaming\npm\node_modules\cordova\bin\cordova
cordova@3.0.9 C:\Users\binaryuser\AppData\Roaming\npm\node_modules\cordova
├── ncallbacks@1.0.0
├── open@0.0.3
├── colors@0.6.2
├── semver@1.1.0
├── shelljs@0.1.2
├── follow-redirects@0.0.3 (underscore@1.5.2)
├── elementtree@0.1.3 (sax@0.3.5)
├── optimist@0.6.0 (wordwrap@0.0.2, minimist@0.0.2)
├── xcode@0.5.1 (node-uuid@1.3.3, pegjs@0.6.2)
├── glob@3.2.6 (inherits@2.0.1, minimatch@0.2.12)
├── plist@0.4.3 (xmlbuilder@0.4.2, xmldom@0.1.16)
├── tar@0.1.18 (inherits@2.0.1, block-stream@0.0.7, fstream@0.1.24)
├── prompt@0.2.7 (revalidator@0.1.5, pkginfo@0.3.0, read@1.0.5, utile@0.1.7, winston@0.6.2)
├── request@2.22.0 (json-stringify-safe@4.0.0, aws-sign@0.3.0, qs@0.6.5, oauth-sign@0.3.0, forever-agent@0.5.0, cookie-jar@0.3.0, tunnel-agent@0.3.0, mime@1.2.11, node-uuid@1.4.1, http-signature@0.10.0, hawk@0.13.1, form-data@0.0.8)
├── express@3.0.0 (methods@0.0.1, fresh@0.1.0, range-parser@0.0.4, crc@0.2.0, cookie@0.0.4, commander@0.6.1, debug@0.7.2, mkdirp@0.3.3, send@0.1.0, connect@2.6.0)
├── ripple-emulator@0.9.18 (connect-xcors@0.5.2, colors@0.6.0-1, accounting@0.3.2, request@2.12.0, moment@1.7.2, express@3.1.0)
├── npm@1.3.11
└── plugman@0.11.0 (ncallbacks@1.1.0, osenv@0.0.3, bplist-parser@0.0.4, underscore@1.4.4, semver@2.0.11, dep-graph@1.1.0, elementtree@0.1.5, xcode@0.6.1, nopt@1.0.10, rc@0.3.0, tar.gz@0.1.1, npm@1.3.4)

Notice the above line you can see the path were the file is mentioned. Copy that path. In my case it is C:\Users\binaryuser\AppData\Roaming\npm\cordova so use cd C:\Users\binaryuser\AppData\Roaming\npm\ and type cordova. There it is, it finally works.

obect c on eclipse

2013-11-17T01:10:00.001-08:00

http://wirecode.blogspot.it/2007/11/objective-c-and-eclipse.html?m=1

php read doc

2013-10-20T10:09:00.001-07:00

good article here

http://mayankpatel10487.blogspot.it/2012/06/php-script-to-read-doc-file.html?m=1

GCM mysql php step by step

2013-10-17T05:09:00.000-07:00

GCM mysql php step by step

Ajax web chat with powered by php mysql

2013-10-10T21:08:00.004-07:00

Interesting article and code on tutorialzine

google web designer htm5

2013-10-07T11:48:00.001-07:00

http://download.html.it/blog/2013/10/01/google-web-designer/?utm_source=newsletter&utm_medium=email&utm_campaign=Newsletter%3A%20Download.HTML.it&utm_content=05-10-2013%20google-web-designer-nuovo-tool-per-sviluppare-in-html-5

android socket programming

2013-10-05T12:44:00.001-07:00

http://www.edumobile.org/android/android-development/socket-programming/

Updated XMPP Client for Android

2013-10-02T04:41:00.003-07:00

Good article here : Updated XMPP Client for Android

Link Samsung simple android chat application

2013-10-02T04:32:00.001-07:00

Link Samsung simple android chat application

android chat example

2013-09-29T07:30:00.001-07:00

https://code.google.com/p/simple-android-instant-messaging-application/source/browse/#svn%2Ftrunk%2FServer

determine android market

2013-09-02T09:56:00.001-07:00

http://stackoverflow.com/questions/14413912/how-to-determine-at-runtime-if-app-is-installed-via-amazon-appstore-or-google-pl

PhoneGap Tutorial: A Cross-Platform Zombie App

2013-08-27T10:57:00.001-07:00

PhoneGap Tutorial: A Cross-Platform Zombie App

PhoneGap Legends – A Sample Game App | ANDREW TRICE

2013-08-27T10:54:00.001-07:00

PhoneGap Legends – A Sample Game App | ANDREW TRICE

change language programmatically on android

2013-08-21T11:24:00.001-07:00

http://snowpard-android.blogspot.it/2013/03/programmatically-change-language-in.html?m=1

Sikuli automate screenshoot

2013-08-19T04:52:00.002-07:00

Sikuli automates anything you see on the screen. It uses image recognition to identify and control GUI components. It is useful when there is no easy access to a GUI's internal or source code. http://www.sikuli.org/

Android Test case

2013-08-19T04:49:00.001-07:00

Good article for automating tests on device. http://www.jimmycollins.org/blog/?p=633

android change language

2013-08-18T10:14:00.001-07:00

http://stackoverflow.com/questions/12908289/how-change-language-of-app-on-user-select-language

phonegap game engine

2013-08-18T10:10:00.001-07:00

http://stackoverflow.com/questions/7648941/using-phonegap-for-game-development

Stretch row vertically - android layut

2013-07-28T07:25:00.001-07:00

http://stackoverflow.com/questions/6007033/android-how-to-stretch-vertically-one-row-in-tablelayout