keyboard shortcut netbeans php go to symbol

ctrl alt shift O

Find command find latest files

 find . -printf '%T+ %p\n' | sort -r | head

Variable type hinting in Netbeans (PHP)

In NetBeans - type vdoc and press tab to get the following template auto generated. (Source)

/* @var $varName Type_Name */

http://stackoverflow.com/questions/1798477/variable-type-hinting-in-netbeans-php

Mysql Setting Indian TimeZone (Asia/Calcutta)

Problem : 

The following query : 

select count(1) cnt,date_format(from_unixtime(absoluteTime),'%D-%M-%Y') as date1 from a,b where a.id = b.fid and b.col2 = 'xyz' group by date1 order by absoluteTime asc

Gave different results on my local machine as compared to the server hosted on EC2.

When I did : 

mysql> show variables like '%time_zone%

I got : 

+------------------+---------------+

| Variable_name    | Value         |

+------------------+---------------+

| system_time_zone | EST           |

| time_zone        | SYSTEM |

+------------------+---------------+

Which means that mysql is picking the system time zone which is EST(some US time zone).

Solution : 

1. I checked time_zone* tables in mysql db - they were empty. So I did 2.

2. mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql (Source)

3. I edited /etc/my.cnf file and put this line there : default_time_zone=Asia/Calcutta   

now service mysqld restart

installing apc

 yum install pcre-devel

yum -y install php-devel

 pecl install apc

add extension=apc.so to php.ini

php catching fatal errors

Source

register_shutdown_function('handleShutdown');

function handleShutdown() {
        $error = error_get_last();
        if($error !== NULL){
            $info = "[SHUTDOWN] file:".$error['file']." | ln:".$error['line']." | msg:".$error['message'] .PHP_EOL;
            yourPrintOrMailFunction($info);
        }
        else{
            yourPrintOrMailFunction("SHUTDOWN");
        }
    }

Multi tabbed Putty

http://ttyplus.com/multi-tabbed-putty/

FD RD Computation for LIC t.no.75 policy

<?php

$premium = 1000;

$rate = 0.05;

$years = 20;

echo "RD = ".rd($premium,$rate,$years)."\n";

$fd1 = fd(3000,0.05,15);

$fd2 = fd(3000,0.05,10);

$fd3 = fd(3000,0.05,5);

$fd4 = 22000;

echo "FD = ".($fd1+$fd2+$fd3+$fd4)."\n";

function fd($amt,$rate,$years) {

        for($i=0; $i<$years;++$i) {

                $amt = $amt*(1+$rate);

        }

        return $amt;

}

function rd($amt,$rate,$years) {

        $final = 0;

        for($i=0; $i<$years;++$i) {

                $final = ($final + $amt)*(1+$rate);

        }

        return $final;

}

?>

dropbox centos sync

Dropbox CLI for CentOS 5 the easy way

Submitted by Alan Ivey on Thu, 2010-08-12 11:27

Tags: 

• centos
 
• cli
 
• dropbox
 
• Today I Learned...

Dropbox hardly needs any introduction; put files in your Dropbox and they show up everywhere else you have Dropbox installed and dropbox.com. A feature about Dropbox that is probably not as widely known is that free accounts come with 30 days of undo history and Pro accounts can get "Pack Rat" that keeps unlimited history of changes. The history of files, including reverting deleted files, was particularly interesting to me, since I could hook in my latest daily MySQL dumps from AutoMySQLBackup to Dropbox and have 30 days of backups for free available from anywhere dropbox.com is accessible.

The problem is that we use CentOS for our servers and the Dropbox Linux builds are geared for distributions like Ubuntu and Debian that have updated versions of required software like Python, libc, and others, that I did not want to upgrade by hand on my systems and risk the integrity of the system packages. But, I got it to work anyway, read on for how I got Dropbox CLI installed on CentOS without replacing any system files.

1. Download http://www.getdropbox.com/download?plat=lnx.x86 orhttp://www.getdropbox.com/download?plat=lnx.x86_64 (Ref)
2. Extract tar.gz file downloaded and leave in ~ of desired user
3. Run ~/.dropbox-dist/dropboxd to get Dropbox to provide a URL to go to in your browser to link this computer to your Dropbox account
   $ ./dropboxd
This client is not linked to any account...
Please visit https: //www.dropbox.com/cli_link?host_id=xxxxxxxxxxxxxxxxxxxxxxxxxxxx to link this machine.
4. After visiting the URL in a browser to which you've logged into dropbox.com, you'll see the following output:
   /usr/bin/nautilus
cannot open display:
Run 'nautilus --help' to see a full list of available command line options.
5. If you cannot quit the app, open another a shell, get the PID by running $ ps -ef|grep dropbox, and kill PID. The output on your other shell should say:
   Terminated
6. Download the official Dropbox CLI: http://www.dropbox.com/download?dl=packages/dropbox.py (Ref)
7. dropbox.py won't work without Python 2.6, but let's not risk messing up our official RHEL packages. Download ActivePython 2.6 (AS Package) fromhttps://www.activestate.com/activepython/downloads (Ref)
8. As mentioned in the AP documentation (Ref), run the installer with ./install.sh and install where desired. It defaults to /opt/ActivePython-2.6, which is fine because it does not conflcit with the system default python 2.4 install. For my purposes, I had created a user called dropbox that did not have root privileges, so I installed to /home/dropbox/ActivePython-2.6.
9. Edit dropbox.py and change #!/usr/bin/python to the path you just installed AP to. For my installation, it's set to #!/home/dropbox/bin/ActivePython-2.6/bin/python
10. Run dropbox.py without commands to see your available options.

Source

Generating html drop down options with vim

:1,$ s:\(.*\):<option value="\1">\1</option>:g  

If the file contains 

1

2

3

This command will result in 

<option value="1">1</option>

<option value="2">2</option>

<option value="3">3</option>

installing pecl_http on centos

yum install php-pear

yum install gcc

yum install curl-devel

yum install php-devel

pecl channel-update pecl.php.net

/usr/bin/pecl install pecl_http

installing apache and php on centos

yum install httpd mod_ssl

yum install php-common php-gd php-mcrypt php-pear php-pecl-memcache php-mhash php-mysql php-xml

yum install mod_php

nokia e63 reformat

 *#7370#

source : http://discussions.nokia.com/t5/Eseries-and-Communicators/E63-Completely-Erase-All-Data/td-p/484897

Good ebook site

http://wowebook.com

JQuery in place editing with autocomplete (with dummy data)

Pick the corresponding libraries from here : 

http://code.google.com/p/jquery-in-place-editor/

https://github.com/dyve/jquery-autocomplete

Then edit the file named : jquery.editinplace.js like this ; 

(Modify) createEditorElement: function() {

if (-1 === $.inArray(this.settings.field_type, ['autocomplete','text', 'textarea', 'select']))

throw "Unknown field_type <fnord>, supported are 'text', 'autocomplete','textarea' and 'select'";

var editor = null;

if ("select" === this.settings.field_type)

editor = this.createSelectEditor();

else if ("autocomplete" === this.settings.field_type)

editor = this.createAutoCompleteEditor();

else if ("text" === this.settings.field_type)

editor = $('<input type="text" ' + this.inputNameAndClass() 

+ ' size="' + this.settings.text_size  + '" />');

else if ("textarea" === this.settings.field_type)

editor = $('<textarea ' + this.inputNameAndClass() 

+ ' rows="' + this.settings.textarea_rows + '" '

+ ' cols="' + this.settings.textarea_cols + '" />');

return editor;

},

(Add) createAutoCompleteEditor: function() {

var editor = $("<input "+this.inputNameAndClass()+" type=\"text\"/>");

   editor.autocomplete({

        minChars: 1,data: [

            ['apple', 1],

            ['apricot', 2],

            ['pear', 3],

            ['prume', 4],

            ['Doyenné du Comice', 5]

        ]

    });

return editor;

},

Now, modify the dummy data with real data and specify field_type as autocomplete when creating an inPlaceEdit element.

Websockets deployment on a dedicated server

I was able to test a websockets based application perfectly on my localhost but when I tried to deploy it on the production server there were problems.

Here is what I did : 

1. Edit the file : /etc/sysconfig/iptables

and add this line : 

-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 8123 -j ACCEPT

assuming that you want to run your websocket server on port 8123.

2. service iptables restart

3. When you start your websocket server, start it on 0.0.0.0. It will ensure that it's open to connection on all interfaces - be it LAN or external IPs.

4. To test whether it's accepting connection on the above port, do telnet IP Port. If it's successful then you can proceed with your websocket related stuff.

Articles with tags queries : HQL/JPQL/MySql

http://www.sergiy.ca/how-to-write-many-to-many-search-queries-in-mysql-and-hibernate/

How to Write Many-To-Many Search Queries in MySQL and Hibernate

Java MySQL Hibernate

Lets review basic many-to-many relationship between tables and build common search queries in MySQL and Hibernate HQL. We will take this site's database schema which has article-tag many-to-many relationship as an example and will try to build search queries to find articles by specific tags.

Here is our database schema that implements many-to-many relationship using intermediate "article_tag" table:

Corresponding Hibernate mappings:

<hibernate-mapping>
      <class name=ca.sergiy.model.Tag" table="tag">
          <cache usage="read-write"/>
          <id name="id" column="id" type="long">
              <generator class="native"/>
          </id>
        <property name="name" column="name"/>
      </class>
</hibernate-mapping>
  

  <hibernate-mapping>
    <class name="ca.sergiy.model.Article" table="article">
          <cache usage="read-write" />
          <id name="id" column="id" type="long">
              <generator class="native" />
          </id>
        <property name="title" column="title" />
          <set name="tags" table="article_tag" lazy="false">
              <key column="articleid" />
              <many-to-many class="ca.sergiy.model.Tag" column="tagid" />
          </set>
    </class>
  </hibernate-mapping>

#1. Find all articles that are tagged with any of tag₁, tag₂, ..., tag_n

MySQL query to select all articles that have "Java" or "Hibernate" among their assigned tags:

  SELECT DISTINCT a.*
  FROM   `article` a
         INNER JOIN article_tag at
           ON at.articleid = a.id
         INNER JOIN tag t
           ON t.id = at.tagid
  WHERE  t.name IN ("Java", "Hibernate")
  

Corresponding Hibernate HQL:

  String[] tags = {"Java", "Hibernate"};
  String hql = "select distinct a from Article a " +
                  "join a.tags t " +
                  "where t.name in (:tags)";
  Query query = session.createQuery(hql);
  query.setParameterList("tags", tags);
  List<Article> articles = query.list();
  

This query will also work for a single tag (find all articles tagged with "Java")

#2. Find all articles that have no tags assigned

MySQL query:

  SELECT   a.*
  FROM     `article` a
           LEFT JOIN article_tag at
             ON at.articleid = a.id
  GROUP BY a.id
  HAVING   Count(at.tagid) = 0
  

Corresponding Hibernate HQL:

  String hql = "select a from Article a " +
                  "left join a.tags t " +
                  "group by a " +
                  "having count(t)=0";
Query query = session.createQuery(hql);
  List<Article> articles = query.list();
  

Note that this query uses LEFT JOIN.

#3. Find all articles that are tagged with at least tag₁, tag₂, ..., tag_n

MySQL query to select all articles that have at least both "Java" and "Hibernate" among their assigned tags:

  SELECT a.*
  FROM   article a
       INNER JOIN (SELECT   at.articleid
                     FROM     article_tag at
                            INNER JOIN article a
                                ON a.id = at.articleid
                              INNER JOIN tag t
                                ON t.id = at.tagid
                     WHERE    t.name IN ("Java","Hibernate")
                     GROUP BY at.articleid
                     HAVING   Count(at.articleid) = 2) aa
           ON a.id = aa.articleid
  

Hibernate HQL, looks much cleaner:

  String[] tags = {"Java", "Hibernate"};
  String hql = "select a from Article a " +
                  "join a.tags t " +
                  "where t.name in (:tags) " +
                  "group by a " +
                  "having count(t)=:tag_count";
Query query = session.createQuery(hql);
  query.setParameterList("tags", tags);
  query.setInteger("tag_count", tags.length);
  List<Article> articles = query.list();
  

#4. Find all articles that are tagged with exactly tag₁, tag₂, ..., tag_n

MySQL query to select all articles that are tagged with exactly "Java" and "Hibernate" tags (no other tags assigned):

  SELECT a.*
  FROM   article a
       INNER JOIN (SELECT   at.articleid
                     FROM     article_tag at
                   WHERE    at.articleid IN (SELECT   at2.articleid
                                               FROM     article_tag at2
                                                      INNER JOIN article a2
                                                          ON a2.id = at2.articleid
                                               GROUP BY at2.articleid
                                               HAVING   Count(at2.articleid) = 2)
                              AND at.tagid IN (SELECT id
                                               FROM   tag t
                                             WHERE  t.name IN ("Java","Hibernate"))
                     GROUP BY at.articleid
                     HAVING   Count(at.articleid) = 2) aa
           ON a.id = aa.articleid
  

Hibernate HQL:

  String[] tags = {"Java", "Hibernate"};
  String hql = "select a from Article a " +
                  "join a.tags t " +
                  "where t.name in (:tags) " +
                  "and a.id in (" +
                      "select a2.id " +
                      "from Article a2 " +
                      "join a2.tags t2 " +
                      "group by a2 " +
                      "having count(t2)=:tag_count) " +
                  "group by a " +
                  "having count(t)=:tag_count";
Query query = session.createQuery(hql);
  query.setParameterList("tags", tags);
  query.setInteger("tag_count", tags.length);
  List<Article> articles = query.list();
  

Basically it is query #3 with extra condition applied: total number of tags should be n.

Aug 21, 2009

© 2011 Sergiy Kovalchuk | Contact

0.0149
7

php websockets working

https://github.com/Flynsarmy/PHPWebSocket-Chat

Source : http://www.flynsarmy.com/2012/02/php-websocket-chat-application-2-0/

Smartvideo extension for managing youtube videos in your browser

for chrome and firefox.
For e.g.,
1. to save bandwidth set default video quality to 240 for all videos.
2. have different settings for embedded and youtube videos.

Youtube allows face blurring in videos

Apache Shiro Introduction

Super simple application security with Apache Shiro

View more presentations from Marakana Inc.

Tracking monetization of Youtube Videos in Google Adsense

https://www.youtube.com/analytics?vmv=1&feature=mhsn

firebug breakpoints advanced demo

http://getfirebug.com/doc/breakpoints/demo.html

Search public google docs

Source

* [site:docs.google.com/document/d] - find text documents

* [site:docs.google.com/presentation/d] - find presentations

* [site:docs.google.com/drawings/d] - find drawings

* [site:docs.google.com/file/d] - find files: images, videos, PDF files, Microsoft Office documents and more (you should click "repeat the search with the omitted results included" since there are many files with similar titles)

* [site:docs.google.com/folder/d] - find folders (collections of files and other folders)

* [site:docs.google.com/open] - find other documents, folders and files (the links redirect to other URLs)

A wonderful jquery plugin - parallax

http://stephband.info/jparallax/

New features in PHP I didn't know about

Type hinting

Short array syntax

Function array dereferencing

Instance method call

objects as functions

Session Handler Interface

JSON Serializable interface

Mysqlnd

PHP Dev/Debug Tools

Source

Benchmark your webserver with : siege

System calls made by apache(httpd) with : strace

Check inclued hierarchy

callgrind xdebug xhprof

hiphop  for static analysis

Others : 

replace time() with $_SERVER['REQUEST_TIME']
prefer require/include over require_once/include_once

accessing properties file in jsp/jstl using spring

<spring:eval var="itemsPerPage" expression="@browsePageProperties.getProperty('itemsPerPage')" scope="request"/> 

where browsePageProperties is defined in (Application Conext Xml) root-context.xml like this : 

    <util:properties id="browsePageProperties" location="classpath:browsePage.properties"/>  

http://www.finalconcept.com.au/article/view/spring-using-the-value-annotation

vim for eclipse

http://vrapper.sourceforge.net/home/

hibernate many to many query

Thanks Dude !

1. JPA Sucks.

2. HQL works : 

Session session = (Session) entityManager.getDelegate();

Criteria criteria = session.createCriteria(Design.class);

Query query = session.createQuery("select d from Design d join d.tags t where t.name in (:tags) group by d having count(t) =:tag_count");

query.setParameterList("tags",tags);

query.setInteger("tag_count",tags.length);

   List<Design> list = query.list();

3. Hibernate without HQL doesn't work : 

/* int i=0;

   for ( String tagName : tags ) {

       String aliasName = "alias_" + i;

       criteria.createAlias("tags", aliasName, Criteria.INNER_JOIN);

       criteria.add( Restrictions.eq(aliasName+".name",tagName) );

       i++;

   }*/

  // List<Design> list = criteria.list();

4. PHP and MySql Rock.

apache access log images average object size, total requests, total B/W used

cat 19_jun | grep -iE '(.gif|.jpg|.png|.jpeg)' | awk '{SUM += $10;COUNT +=1;} END {print SUM/(1024*1024*1024);print COUNT;print SUM/COUNT;}'

uuencode command not found

yum install sharutils

clear recent project list in netbeans

get hold of user directory from Help->About (menu)

for me it's : C:\Users\admin\.netbeans\7.1.1

 Then go to : c/Users/admin/.netbeans/7.1.1/config/Preferences/org/netbeans/modules

edit file : projectui.properties

remove all lines starting with 'recent'

NetBeans jvi :w problem (colon w)

Tools -> Options -> jVi Config -> Platform

uncheck : ":" Command completion Auto Popup

vim for netbeans

http://jvi.sourceforge.net/

Vim : replacing text with matched text

For e.g. If my input is : 

$this->Lang("abc");

$this->Lang("kkk");

and I want to make it : 

"abc";

"kkk";

then : 

:1,$ s/$this->Lang(\(.*\))/\1/

\1 denotes the text matched between first \( \)

Source

C program for printing all permutations

#include <stdio.h>
void swap(int* a,int i,int j) {
        int tmp = a[i];
        a[i] = a[j];
        a[j] = tmp;
}

void print_array(int* a,int n) {
        int i;
        for(i = 0; i<= n; ++i) {
                printf("%d ",a[i]);
        }
        printf("\n");
}

void permute(int* a, int i, int n) {
        int j;
        if(i == n) print_array(a,n);
        else {
                for(j = i;j <= n; j++) {
                        swap(a,i,j);
                        permute(a,i+1,n);
                        swap(a,i,j);
                }
        }
}

void main() {
        int a[4] = {1,2,3,4};
        permute(a,0,3);
}

rough sketch for generating all permutations

permute(arrayCollection) {

if has only 2 :
AB
BA

else
for ( ith elem in collection) {
 otherThanIth = elems other than ith;
 otherThanIthPermed = permute(otherThanIth);
 prepend(ith, otherThanIthPermed);
}

}

Printing a BST in level order

queue.addAtEnd(root);
queue.addAtEnd(stopper);

while(queue.hasElems() && currNode = queue.popFront()) {\
if(currNode != stopper) {
   print currNode;
   queue.addAtEnd(left) if left not null;
   queue.addAtEnd(right) if right not null;
} else {
  print new line;
  if queue.hasElems()
      addAtEnd(stopper);
}
}

other solutions from leetcode :

With two queues :

void printLevelOrder(BinaryTree *root) {
  if (!root) return;
  queue<BinaryTree*> currentLevel, nextLevel;
  currentLevel.push(root);
  while (!currentLevel.empty()) {
    BinaryTree *currNode = currentLevel.front();
    currentLevel.pop();
    if (currNode) {
      cout << currNode->data << " ";
      nextLevel.push(currNode->left);
      nextLevel.push(currNode->right);
    }
    if (currentLevel.empty()) {
      cout << endl;
      swap(currentLevel, nextLevel);
    }
  }
}


With one queue but counters :
void printLevelOrder(BinaryTree *root) {
 if (!root) return;
 queue<BinaryTree*> nodesQueue;
 int nodesInCurrentLevel = 1;
 int nodesInNextLevel = 0;
 nodesQueue.push(root);
 while (!nodesQueue.empty()) {
   BinaryTree *currNode = nodesQueue.front();
   nodesQueue.pop();
   nodesInCurrentLevel--;
   if (currNode) {
     cout << currNode->data << " ";
     nodesQueue.push(currNode->left);
     nodesQueue.push(currNode->right);
     nodesInNextLevel += 2;
   }
   if (nodesInCurrentLevel == 0) {
     cout << endl;
     nodesInCurrentLevel = nodesInNextLevel;
     nodesInNextLevel = 0;
   }
 }
}

Creating a PrestaShop Module

http://doc.prestashop.com/display/PS14/Creating+a+PrestaShop+module

vtiger sales process

http://www.vtiger-handbuch.de/DocBooks/manual150/spro-ch002.html

vtiger web services tutorial

https://wiki.vtiger.com/index.php/Webservices_tutorials#An_Introduction_to_Vtiger_Webservices

making a field not optional in vtiger

http://forums.vtiger.com/viewtopic.php?t=38291

vtiger Fatal error: Smarty error: unable to write to $compile_dir

solution:

 chmod -R a+rw Smarty/templates_c

vtiger API

http://api.vtiger.com/

vtiger developer guide

ftp://ftp.psu.ac.th/pub/vtiger/vtiger5.x-developer-manual.pdf

vtiger : where are leads/potentials stored?

http://forums.vtiger.com/viewtopic.php?t=8455

netbeans maching brace

ctrl + [

vtiger lead contacts accounts etc explanation

http://forums.vtiger.com/viewtopic.php?t=23694

xampp older version

1. http://sourceforge.net/projects/xampp/files/

2. Details of older xampp versions (for e.g. which version of php etc) : http://code.stephenmorley.org/articles/xampp-version-history-apache-mysql-php/

All the svn changes in a date range

svn log -v -r {2011-05-01}:{2012-02-29}

formatting xml in vim

map <F2> <Esc>:1,$!xmllint --format -<CR>

add the above in .vimrc

maven create eclipse project

mvn eclipse:clean eclipse:eclipse

awk print sum of a column and number of rows

awk '{sum=sum+$3} END {print "sum is ",sum," nr = ",NR}' file1

Maven plugin for eclipse

http://download.eclipse.org/technology/m2e/releases

Clearing AutoFill Form data from Google Chrome

Delete all Autofill entries and saved text

Click the wrench icon on the browser toolbar.
Select Tools.
Select Clear browsing data.
In the dialog that appears, select the "Clear saved Autofill form
data" checkbox.
Use the menu on the top to select the amount of data you want to
delete. Select the beginning of time to clear everything.
Click Clear browsing data.

pig sorting a tuple

grp = foreach recs generate (($0 lt $1) ? $0 : $1), (($0 lt $1) ? $1 : $0); 

Jailbreaking and deploying on iphone3gs using ios5

First jailbreak using latest version of redsnow : 

http://osxdaily.com/2011/12/27/how-to-jailbreak-ios-5-0-1-untethered-with-redsn0w/

Then follow these instructions to run/deploy your app on your iphone : 

stackoverflow.com/questions/246422/how-can-i-deploy-an-iphone-application-from-xcode-to-a-real-iphone-device 

Installing node.js on hostmonster/bluehost

http://rcrisman.net/article/10/installing-nodejs-on-hostmonster-bluehost-accounts

While installing git you many want to get the latest source from http://git-scm.com/download