MySQL event scheduler

Attention: event_scheduler is supported after 5.1

Check if event_scheduler is on, execute:

SHOW VARIABLES LIKE 'event_scheduler';

To set event_scheduler on:

SET GLOBAL event_scheduler = ON;
or SET @@global.event_scheduler = ON;
or SET GLOBAL event_scheduler = 1;
or SET @@global.event_scheduler = 1;

To turn off is

SET GLOBAL event_scheduler = OFF;
or SET @@global.event_scheduler = OFF;
or SET GLOBAL event_scheduler = 0;
or SET @@global.event_scheduler = 0;

To create event:

CREATE EVENT [IF NOT EXISTS] event_name
  ON SCHEDULE schedule
  [ON COMPLETION [NOT] PRESERVE]
  [ENABLE | DISABLE]
  [COMMENT 'comment']
  DO sql_statement;

param

schedule:
  AT TIMESTAMP [+ INTERVAL INTERVAL]
                              | EVERY INTERVAL [STARTS TIMESTAMP] [ENDS TIMESTAMP]
INTERVAL:
  quantity {YEAR | QUARTER | MONTH | DAY | HOUR | MINUTE |
                   WEEK | SECOND | YEAR_MONTH | DAY_HOUR | DAY_MINUTE |
                   DAY_SECOND | HOUR_MINUTE | HOUR_SECOND | MINUTE_SECOND}

Customize your blogger: ads and page type

Customize your ads' position.
<!-- show Ad if you set ads to show in your blogger -->
<b:if cond='data:post.includeAd'>
<div class='inline-ad'>
<data:adCode/>
</div>
</b:if>

<!-- show only when it is static page or item(post page) -->
<b:if cond='data:blog.pageType in {&quot;static_page&quot;,&quot;item&quot;}'>
<!-- your code -->
</b:if>

<!-- show only when it is index page -->
<b:if cond='data:blog.pageType == &quot;index&quot;'>
<!-- your code -->
</b:if>

<!-- show only when device is mobile -->
<b:if cond='data:blog.isMobile'>
<!-- your code -->
</b:if>

Drag & drop file code sample

Make a div for dropping.

$("#id").on("drop dragover", function(e) {
 var fm = document.getElementById('form');
 var fd = new FormData(fm);
 e.preventDefault();
 if (e.type === "drop") {
  var files = e.originalEvent.dataTransfer.files;
  console.log(files);
  if (files.length > 0) {
   fd.append("file", files[0]);
   // do something
  }
 }
 return false;
});

html part:

<form action="upload.php" enctype="multipart/form-data" id="form" method="post">
  <input name="mode" type="hidden" value="upload" />
  <input id="formFile" name="file" type="file" />
</form>

Create array in array

1:
var myArray = [[]];
2:
var myArray1 = new Array();
myArray.push(new Array());

myArray[i]= myArray1;
3:
var myArray1 = new Array({name: "name", value: "value"});
myArray.push({name: "name", value: "value"});

Set back function with toolbar

Set:

getSupportActionBar().setDisplayHomeAsUpEnabled(true);

Action:

onBackPressed();