Yearly archives: 2007

 

 

192

MySQL dates

PhpBB stores dates in INT fields in Unix time format, meaning the integer value equals to the number of seconds since 1/1/1970. To view the date in standard format, use FROM_UNIXTIME(field) function. select user_id, username, FROM_UNIXTIME(user_regdate) as d from phpbb_users To select a time interval, we need to use FROM_UNIXTIME( ) function with a DATE_ADD() [...]

 

159

More reasons why Microsoft sucks

From their API site: What is the API user access key? The API user access key is a unique alphanumeric value (string) that, together with the user name and password, is used to validate any calls to the API. This unique key is issued to individual users at signup and provides more security (authentication) than [...]

 

 

100

Why Microsoft's Hotmail Sucks

I am one happy Gmail user and I hate Microsoft’s Hotmail. I don’t really remember the reason I registered with them, but the thing is I haven’t been using it lately at all. But the other day my mom, who sighed up as Microsoft’s Trade Partner in Kazakhstan asked me to subscribe her company for [...]

 

195

CSS borders in Firefox and IE

FF will display borders OUTSIDE of a div element, adding the border width to the element widget. IE will squeeze borders INSIDE and the total width stays the same. Workaround for this which makes FF behave like IE: * { -moz-box-sizing: border-box; } (* applies it to all elements, if you don’t need that, add [...]

 

146

Dates in MySQL

PhpBB stores dates in INT fields in Unix time format, meaning the integer value equals to the number of seconds since 1/1/1970. To view the date in standard format, use FROM_UNIXTIME(field) function: select user_id, username, FROM_UNIXTIME(user_regdate) as d from phpbb_users To select a time interval, we need to use FROM_UNIXTIME( ) function with a DATE_ADD() [...]

 

86

Wscript settings

In command line type: wscript //H:cscript or wscript //H:wscript This registers either Cscript.exe or Wscript.exe as the default script host for running scripts. If neither is specified, the default is Wscript.exe. More info

 

 

 

94

XSL: Several XML files into one file

We have a lot of separate files and want to put them together into one. Step 1: Create a list of all filenames as XML file <files> <file>file1.xml</file> <file>file2.xml</file> <file>file3.xml</file> </files> Step 2: Create an XSL transform <xsl:template match="//files"> <Root> <xsl:for-each select="file"> <xsl:copy-of select="document(.)"/> </xsl:for-each> </Root> </xsl:template> Note the use of “copy-of” – it will [...]