I’m a big fan of Stack Overflow and I tend to contribute regularly (am currently in the top 0.X%). In this category (stackoverflow) of posts I will will be posting my top rated questions and answers. This, btw, is allowed as explained in the meta thread here.

My question was:

Is there a function which would return true of false based on if the DELETE SQL statement succeded or not? For example something like this:

<?php
    $sql = "DELETE FROM table WHERE id=123";
    $result = pg_query($sql);

    if **function**($result)
        return true;
    else
        return false;
?>

The answer, by LolCoder, was:

Use mysql_affected_rows() to get number of affected rows in mysql.

Similary for postgres, it will be pg_affected_rows.

edit (18.06.2015): Nowdays I’m using PM2, and here’s my post that explains how to use PM2.

Nodemon is a utility that will monitor for any changes in your source and automatically restart your server.  Install with npm:

npm install -g nodemon

Forever is a simple CLI tool for ensuring that a given script runs continuously (i.e. forever). Install with npm:

npm install -g forever

Forever & Nodemon running together:

forever start nodemon --exitcrash app.js

edit (24.02.2015):

If you get an error like this:

error:   Cannot start forever
error:   script /home/nikola/nodemon does not exist.

Try to run nodemon with the full path:

forever start /usr/bin/nodemon --exitcrash app.js

You can find out the path to nodemon by executing:

which nodemon

I’m a big fan of Stack Overflow and I tend to contribute regularly (am currently in the top 0.X%). In this category (stackoverflow) of posts I will will be posting my top rated questions and answers. This, btw, is allowed as explained in the meta thread here.

My question was:

I have a situation where I would have to query the database for some data which is the same for all users and changes daily, so I figured I could make a file in which I would save this data (once per day) and then load it from that file each time a user visits my site.

Now, I know that this is a common practice (caching) when the requests from database are big but the data I’m about to write to the file is a simple 3 digit number, so my question is should this still be faster or is it just an overkill and I should stick with the database query?

 The answer, by Dukeling, was:

Caching, when done right, is always faster.

It depends how long storing and retrieving data from the file takes and how long requests to the database takes.

If the database query to get the number takes long, then caching may be a good idea, since the data is small.

If you were to do a search (e.g. sequential) in a file with lots of cached data (which doesn’t seem to be the case), it would take long.

Disk I/O could be slower than database I/O (which is unlikely, unless it’s a local DB).

Bottom line – benchmark.

For your scenario, caching is probably a good idea, but if it’s only a single 3-digit number for all users then I’d just try to stick it in RAM rather than in a file.

Redis is an open source, BSD licensed, advanced key-value cache and store. It is often referred to as a data structure server since keys can contain strings, hashes, lists, sets, sorted sets, bitmaps and hyperloglogs.

Comparison with Memcache and Memcached can be found here, and the naming distinction can be found here.

You can download the installation zip file here (I used the Windows version), and extract it to C:\redis. To run the Redis server (in order to be able to save to it and query it) you have to execute the redis-server.exe from this directory.

To use Redis with Node.js you have install the redis module:

npm install redis

A simple usage example:

var redis = require("redis"),
    client = redis.createClient();

// if you'd like to select database 3, instead of 0 (default), call
// client.select(3, function() { /* ... */ });

client.on("error", function (err) {
    console.log("Error " + err);
});

client.set("string key", "string val", redis.print);
client.hset("hash key", "hashtest 1", "some value", redis.print);
client.hset(["hash key", "hashtest 2", "some other value"], redis.print);
client.hkeys("hash key", function (err, replies) {
    console.log(replies.length + " replies:");
    replies.forEach(function (reply, i) {
        console.log("    " + i + ": " + reply);
    });
    client.quit();
});

A lot more examples here.

Here’s I’m going to show you steps on how to share your data between scenes in Unity3D

1. In the starting scene make a new empty object and name it GameData.
2. Add a script named GameController with the following content:

   #pragma strict
   
   private var data : Array;
   
   function Awake () {
   	DontDestroyOnLoad (this);
   }
   
   function Start () {
   	data = new Array();
   	
   	GetNewResults();
   }
   
   function GetNewResults(){
   	var www : WWW = new WWW ("http://localhost/check");
   	
   	yield www;// Wait for download to complete
   	
   	var dataJson = JSON.Parse(www.data);
   	var novi = dataJson["data"].Value;
   	data = dataJson["someMoreData"];
   	
   	if (novi == "true"){	
   		Application.LoadLevel(Application.loadedLevel + 1);
   	}
   	else{
   		Debug.Log("false");
   	}
   }
   
   public function getData(){
   	return data;
   }

   The most important part is DontDestroyOnLoad(this) which does not destroy this object once a new scene is loaded.

3. Then, in another scene, in some script do the following to fetch the data:

   var data = GameObject.Find("GameData").GetComponent(GameController).getData();

    

In Ionic framework you can use the

ionic resources

command to automatically generate icons and splash screen of different sizes and for optionally different platforms (iOS, Android).

All you have to do is place the icon.png and splash.png in the resources folder in the root of the application and execute the aforementioned command. Ionic will generate the needed configuration in the config.xml file. More about it on the official blog post.

In this post I’m going to show you how to use custom fonts in Unity3D.

1. Create a new project
2. Save scene (CTRL + s) and name it whatever you wish
3. Download some free font from the web (I used Texas Grunge from dafont.com):
   
4. Create a new folder called Fonts in the Assets folder and drag the .ttf  file inside
   
5. Adjust the size of the Camera to 8:
   
6. Hierarchy->Create->UI->Text
7. Click on Canvas in Hierarchy and set the Render Mode and select your Render Camera:
8. Click on Text and change the settings (Rect Transform – resize the text to match the canvas size and drag the anchors in all 4 corners, Text, Font, Best Fit, Max Size):
   

I’m a big fan of Stack Overflow and I tend to contribute regularly (am currently in the top 0.X%). In this category (stackoverflow) of posts I will will be posting my top rated questions and answers. This, btw, is allowed as explained in the meta thread here.

My question was:

I’m using datatables plugin for jquery to show my data on the page. I have this selector when someone clicks on a row:

$('#myTable tr[class !="tableHeader"]').click(function(){
    alert("clicked!");
}

and everything is OK until I click on the “Next page” which shows me next 10 results – then this click function doesn’t show “clicked” message box anymore no matter which row I click.

I’m guessing that the problem is in a way how these new results (rows in the table) are shown, so please give me some ideas on how to solve this.

 The answer, by ghayes, was:

Use jQuery’s Live function. Live will apply to all elements on the page, even ones that don’t exist yet (I assume this is your issue). Thus, your new rows will be clickable when they are created and added to the DOM.

$('#myTable tr[class !="tableHeader"]').live('click',function(){
  alert("clicked!");
});

In this post I’m going to show you how to create a countdown timer and show current time in Unity3D.

1. Create a new 2D project:
   
2. Optionally download some background image (I used this one) and drag it to the Assets folder:
   
3. Drag the background image to the Hierarchy:
   
   
4. Adjust the size of the Camera to 8:
   
5. Hierarchy->Create->UI->Text:
   
6. Click on Canvas in Hierarchy and set the Render mode:
   
7. Click on Text and change the settings (Positions, Width, Height, Text, Font Site):
   
8. Rename the Text to TimerText
9. Duplicate the TimerText and rename to TimeText:
   
10. Change y position of TimeText to -200:
11. Hierarchy -> Create -> Create Empty:
    
12. Rename it to GameController
13. Inspector -> Add Component -> New Script (name it Timer and select JavaScript):
    
14. Paste the following code:

    #pragma strict
     
     var timer: float = 70;
     var isFinishedLevel : boolean = false;
     public var displayText : UnityEngine.UI.Text;
     public var timeText : UnityEngine.UI.Text;
     
     var minsDisplay : String;
     var secsDisplay : String;
     
     var mySeconds : int = 0;
     
     private var oldTimer : float;
     
     function Start(){
         oldTimer = timer;
     }
     
     function Update()
     {
         if (!isFinishedLevel) {
             timer -= Time.deltaTime;
         } 
         
         CurrentTime();
     }
     
     function CurrentTime() { 
         var dt : System.DateTime = System.DateTime.Now;
         var h : int = dt.Hour; 
         var m : int = dt.Minute; 
         var s : int = dt.Second;
     
         timeText.text = h + ":" + m + ":" + s;
         
         if(mySeconds != s)
         {
             mySeconds = s;
             Timing();
         }
         
     }
     
     function Timing()
     {
         if (timer > 0) {
             //var minsDisplay : String = parseInt( timer / 60 ).ToString();
             minsDisplay = parseInt( timer / 60 ).ToString();
             
             //var secsDisplay : String = parseInt( timer ).ToString();
             secsDisplay = parseInt( timer ).ToString();
              
             if ( (timer - ( parseInt(minsDisplay) * 60)) > 10 ) {
                  secsDisplay = parseInt( timer - ( parseInt(minsDisplay) * 60) ).ToString();
             } 
             else {
                 secsDisplay = "0" + parseInt( timer - ( parseInt(minsDisplay) * 60) ).ToString();
             }
             
             //displayText.text = minsDisplay + " : " + secsDisplay;
         } 
         else {
              timer += oldTimer;
         }
         displayText.text = minsDisplay + " : " + secsDisplay;
     }

15. Drag TimerText and TimeText to the script from Hierarchy:
    
16. [le problems] – Run the program, and you’ll run into few issues:
    1. If you open up any other window you will notice that the timer will stop, and continue counting once you return to the Unity window [edit: this seems to be expected behavior and in order to “fix” this, you have to set the “Edit -> Project Settings -> Player -> Run In Background” option (from here)]
    2. TimerText and TimeText are not “ticking off” at the same time [edit: this is now also fixed and the code is updated with the fix]
17. If someone has info on how to solve this, please comment and I’ll update the post once the solution is found [edit: both issues have been resolved thanks to Unity Answers, I’m just leaving them here for some future reference].

I’m a big fan of Stack Overflow and I tend to contribute regularly (am currently in the top 0.X%). In this category (stackoverflow) of posts I will will be posting my top rated questions and answers. This, btw, is allowed as explained in the meta thread here.

My question was:

Given this example here: http://jqueryui.com/selectable/#display-grid I would like to make a selection without the “selection box” that appears when you click ‘n drag. Namely, when I click on number 5 and drag to number 6 and then to 10 I get this:

where in fact what i would like to is drag from 5 to 6 to 10 and have only them selected without 9.

I searched the docs and couldn’t find that option, and my google skills didn’t bring me any luck, and I thought this must have been already done it’s just so happens I can’t grasp it on my own or find an existing solution, so any help here is appreciated (not saying you should do the research for me, am just hoping someone dealt with this before so he can point me to the right direction).

It also could be I’m missing the point in trying to accomplish this with jquery UI but this was the first such example I found that fits (kind of) what I want to accomplish.

 The rather extensive answer, by Dom, was:

First, you might want to hide .ui-selectable-helper or change the CSS:

.ui-selectable-helper{display:none;}

Next, do something like this:

$(function(){var _mousedown =false;
    $('#selectable').selectable({
        start:function(event,ui){
            _mousedown=true;},
        stop:function(event,ui){
            _mousedown=false;
            $('.ui-selected').removeClass('ui-selected');
            $('.selecting').addClass('ui-selected');},
        selecting:function(event,ui){if($('.ui-selecting').length ==1)
                $(ui.selecting).addClass('selecting');

            $('.ui-selecting').removeClass('ui-selecting');
            $('.selecting').addClass('ui-selecting');},
        unselecting:function(event,ui){if($(ui.unselecting).hasClass('selecting'))
                $(ui.unselecting).removeClass('selecting');}});

    $('#selectable').on('mouseenter','.ui-selectee',function(){if(_mousedown)
            $(this).addClass('selecting');});});

DEMO: http://jsfiddle.net/dirtyd77/7UVNS/5/ (HELPER HIDDEN)

http://jsfiddle.net/dirtyd77/7UVNS/6/ (HELPER VISIBLE)

Let me know if you have any questions!

---

***UPDATE:***

.selectable() is not able to do what you are looking for. However, here is something I created. Hope it helps!

JAVASCRIPT:

$(function(){var _mousedown =false,
        _last=null;    
    $('#selectable li').mousedown(function(){
        _mousedown =true;
        $('.ui-selected').removeClass('ui-selected');
        $('#selectable li').attr('unselectable','on').css('user-select','none');
        $(this).addClass('ui-selecting');}).mouseup(function(){
        _mousedown=false;  
        $('.ui-selecting').addClass('ui-selected').removeClass('ui-selecting');
        $('#selectable li').removeAttr('unselectable style');}).mouseenter(function(){if(_mousedown){if($(this).hasClass('ui-selecting'))
                $(_last).removeClass('ui-selecting');

            $(this).addClass('ui-selecting')}}).mouseleave(function(){if(_mousedown){
            _last =  $(this)[0];
            $(this).addClass('ui-selecting');}});});

DEMO: http://jsfiddle.net/dirtyd77/7UVNS/9/

---

***UPDATE #2:***

If you want to use this on a mobile device, I recommend changing up the format entirely to avoid any possible pitfalls. Here is how I would go about it:

JAVASCRIPT:

$(function(){var _clicked =false;
    $('#btn_select').click(function(){
        _clicked =false;
        $(this).hide();
        $('#selectable li').removeAttr('unselectable style');
        $('.ui-selecting').addClass('ui-selected').removeClass('ui-selecting');});
    $('#selectable li').click(function(){if(!_clicked){
            _clicked =true;
            $('.ui-selected').removeClass('ui-selected');
            $('#selectable li').attr('unselectable','on').css('user-select','none');
            $('#btn_select').show();}if($(this).hasClass('ui-selecting')){
            $(this).removeClass('ui-selecting');}else{
            $(this).addClass('ui-selecting');}});});

*NOTE: you might want a $('body').click() to act as the end_selection button.

DEMO: http://jsfiddle.net/dirtyd77/7UVNS/13/