Convert Excel Date into Timestamp

Excel stores dates internally as number of days since January 1, 1900. For example: "June 9th, 2011 10:30 AM" would be stored as "40703.4375". 40703 is the number of full days since 01/01/1900 and 0.4375 represents the time (10.5/24 = 0.4375). When you process dates read from an Excel spreadsheet (e.g. using PHPExcel) you often want to convert them into a UNIX timestamp i.e. a number of seconds elapsed since midnight of January 1, 1970 UTC. Here is a PHP code to do that: Although the code above is written in PHP the function should be very similar in any other language e.g. C# or java. If the provided date is earlier than 1/1/1970 then the minimal timestamp value will be returned. Alternative…

Continue Reading

WingIDE Professional 4.1.12 Crack

Today, I’ll talk about how to crack WingIDE Professional 4.1.12. Warning: DO NOT make commercial use of anything. If you believe something on this Site has infringed your intellectual property rights, please contact us. What’s WingIDE ? Wingware's Python IDE is an Integrated Development Environment designed specifically for the Python programming language. Since 1999, Wingware has focused on Python. How to get WingIDE? You can download WingIDE from http://wingide.com/downloads. It’s a cross-platform software and the latest version now is 4.1.12. It has three different versions: WingIDE 101, WingIDE Personal and WingIDE Professional. How to Crack WingIDE Professional 4.1.12? After install Python and WingIDE on your computer, DO NOT run WingIDE first. You should change system time to a month ago.…

Continue Reading

Writing Your First Windows Application with C++

Welcome to the first windows tutorial. In this tutorial I'll give you the basic information on how to code in windows and we'll go over a few important details first. basic windows program has two important functions inside. The first one is the event handler(I'll talk about this one later on) and the second one is the main function(WinMain from now on). WinMain is similar to DOS' main function, in fact WinMain is called from the DOS main function but in windows we don't have access to the DOS main; everything is covered up by windows. Windows introduces us to messages. A message could be easily described as a pile of data that gets sent to the the event handler…

Continue Reading

Utilizing CodeIgniter Resources within Your Library

To access CodeIgniter's native resources within your library use the get_instance() function. This function returns the CodeIgniter super object. Normally from within your controller functions you will call any of the available CodeIgniter functions using the $this construct: $this, however, only works directly within your controllers, your models, or your views. If you would like to use CodeIgniter's classes from within your own custom classes you can do so as follows: First, assign the CodeIgniter object to a variable: Once you've assigned the object to a variable, you'll use that variable instead of $this: You'll notice that the above get_instance() function is being passed by reference: This is very important. Assigning by reference allows you to use the original CodeIgniter object rather than creating a copy of…

Continue Reading

Rename Files During Upload within WordPress Backend

The passage is telling you how to rename the file name automatically by WordPress (without using any plugins). Warning: To apply this hack, you'll have to edit one of WordPress core files. Keep in mind that it is never recommended. This hack should be redone if you upgrade WordPress. open  the wp-admin/includes/files.php file, and go to the line 324 (approximately here). You'll see the following: Change it as following: And the file you upload will automatically renamed as 20130218180064x268c.ext

Continue Reading

Friends of Template Classes

A problem that I have been struggling with for some days one. When I declare a template function as a friend of a template class, I'll get a compile error, such as following: And I'll get a compile error message: undefined reference to 'operator<

Continue Reading
Contact Us
  • SenseTime Research, Shenzhen Bay Eco-Technology Park
  • cshzxie [at] gmail [dot] com