Jerome's Blog

splitting strings with mysql

2019-03-20T09:27:00.004+05:30

SELECT
SUBSTRING_INDEX(email, '@', 1) ,
SUBSTRING_INDEX(email, '@', -1)
FROM listings

mysql date difference

2019-03-13T08:42:00.000+05:30

SELECT * FROM myTable
WHERE dateCol >= DATE_SUB(NOW(),INTERVAL 1 YEAR) LIMIT 0,1

SELECT * FROM myTable
WHERE dateCol >= DATE_SUB(NOW(),INTERVAL 5 YEAR) LIMIT 0,1

SELECT * FROM myTable
WHERE dateCol >= DATE_SUB(NOW(),INTERVAL 1 MONTH) LIMIT 0,1

SELECT * FROM myTable
WHERE dateCol >= DATE_SUB(NOW(),INTERVAL 40 DAY) LIMIT 0,1

SELECT * FROM myTable
WHERE dateCol >= DATE_SUB(NOW(),INTERVAL 1 HOUR) LIMIT 0,1

SELECT * FROM myTable
WHERE dateCol >= DATE_SUB(NOW(),INTERVAL 15 MINUTE) LIMIT 0,1

SELECT * FROM myTable
WHERE dateCol >= DATE_SUB(NOW(),INTERVAL 600 SECOND) LIMIT 0,1

cpanel cronjob to delete files older than 7 days

2019-01-09T11:15:00.001+05:30

find /home/jerome/public_html/uploads/* -mtime +6 -type f -delete

create empty file in windows via cmd

2017-12-27T10:47:00.002+05:30

copy NUL EMptyFile.txt

copy /b NUL EmptyFile.txt ## binary file

Quote of the day

2017-11-12T07:24:00.001+05:30

The future belongs to those who prepare for it today. Malcolm X ~ American Activist 1925-May 19th - 1965-Feb-21st

yii getBaseUrl and getHomeUrl

2016-02-01T15:36:00.001+05:30

Yii::app()->getBaseUrl(true);   // => http://localhost/yii_projectsYii::app()->getHomeUrl();       // => /yii_projects/index.php
Yii::app()->getBaseUrl(false);  // => /yii_projects

Image Thumbnails Using PHP

2016-02-01T15:14:00.002+05:30

function make_thumb($src, $dest, $desired_width) {

 /* read the source image */
 $source_image = imagecreatefromjpeg($src);
 $width = imagesx($source_image);
 $height = imagesy($source_image);
 
 /* find the "desired height" of this thumbnail, relative to the desired width  */
 $desired_height = floor($height * ($desired_width / $width));
 
 /* create a new, "virtual" image */
 $virtual_image = imagecreatetruecolor($desired_width, $desired_height);
 
 /* copy source image at a resized size */
 imagecopyresampled($virtual_image, $source_image, 0, 0, 0, 0, $desired_width, $desired_height, $width, $height);
 
 /* create the physical thumbnail image to its destination */
 imagejpeg($virtual_image, $dest);
}

Yuor Barin Can Raed Tihs

2016-01-11T18:37:00.000+05:30

S1M1L4RLY, Y0UR M1ND 15 R34D1NG 7H15 4U70M471C4LLY W17H0U7 3V3N 7H1NK1NG 4B0U7 17

YouTube video generated images -- for thumbnails

2015-12-04T12:05:00.004+05:30

http://img.youtube.com/vi//default.jpg
http://img.youtube.com/vi//hqdefault.jpg
http://img.youtube.com/vi//mqdefault.jpg
http://img.youtube.com/vi//sddefault.jpg
http://img.youtube.com/vi//maxresdefault.jpg

source: http://stackoverflow.com/questions/2068344/how-do-i-get-a-youtube-video-thumbnail-from-the-youtube-api

magento block types

2015-11-22T01:22:00.002+05:30

For understanding more about magento block types following are some built-in block types which are widely used in layout.

core/template: This block renders a template defined by its template attribute. The majority of blocks defined in the layout are of type or subtype of core/template.
page/html: This is a subtype of core/template and defines the root block. All other blocks are child blocks of this block.
page/html_head: Defines the HTML head section of the page which contains elements for including JavaScript, CSS etc.
page/html_header: Defines the header part of the page which contains the site logo, top links, etc.
page/template_links: This block is used to create a list of links. Links visible in the footer and header area use this block type.
core/text_list: Some blocks like content, left, right etc. are of type core/text_list. When these blocks are rendered, all their child blocks are rendered automatically without the need to call thegetChildHtml() method.
page/html_wrapper: This block is used to create a wrapper block which renders its child blocks inside an HTML tag set by the action setHtmlTagName. The default tag is if no element is set.
page/html_breadcrumbs: This block defines breadcrumbs on the page.
page/html_footer: Defines footer area of page which contains footer links, copyright message etc.
core/messages: This block renders error/success/notice messages.
page/switch: This block can be used for the language or store switcher.

This is a list of only commonly used block types. There are many other block types which are used in advanced theme implementations.

14 Monitors on a Single Windows 8 PC with USB Graphics Adapters

2015-10-17T22:51:00.001+05:30

Parrot Blue Bebop with SkyController Dual Band WiFi RC Drone

2015-09-30T21:58:00.003+05:30

http://www.hobbytron.com/ParrotBlueBebopwithSkyControllerDualBandWiFiRCDrone.html

Join Tanki Online

2015-07-05T16:50:00.001+05:30

Join Tanki Online

Yii 1.1 path

2015-06-23T15:05:00.002+05:30

Yii::app()->getBaseUrl(true); // => http://localhost/sample
Yii::app()->getHomeUrl(); // => /sample/index.php
Yii::app()->getBaseUrl(false); // => /sample

Yii::app()->request->baseUrl // => /sample

Yii::app()->theme->baseUrl //=> sample/themes/bluetheme

Composer Yii 2.0 update

2015-05-21T18:54:00.000+05:30

set the path to php.exe

A:\>
A:\>cd xampp
A:\xampp>cd php
A:\xampp\php>
A:\xampp\php>PATH="A:\xampp\php"

check the php version; should be greater than 5.4

A:\xampp\php>php -v
PHP 5.6.3 (cli) (built: Nov 12 2014 17:18:08)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2014 Zend Technologies

i copied the composer files from C:\Users\jerome\AppData\Local\ComposerSetup\bin
composer, composer.bat, composer.phar
i think only phar file is needed, anyways copied all the files into xampp/php folder

A:\xampp\php>dir
Volume in drive A is Data
Volume Serial Number is C629-A5C0

Directory of A:\xampp\php

05/17/2015 03:22 PM .
05/17/2015 03:22 PM ..
06/18/2013 02:04 PM cfg
05/16/2015 10:18 PM 587 composer
10/16/2013 06:21 PM 38 composer.bat
05/16/2015 10:18 PM 1,103,875 composer.phar

follow the instructions from
http://www.yiiframework.com/download/
--install the composer asset plugin

A:\xampp\php>php composer.phar global require "fxp/composer-asset-plugin:1.0.0"
Changed current directory to C:/Users/jlabs/AppData/Roaming/Composer
./composer.json has been updated
Loading composer repositories with package information
Updating dependencies (including require-dev)
Nothing to install or update
Generating autoload files

install the project files

A:\xampp\php>php composer.phar create-project yiisoft/yii2-app-advanced ../htdocs/advanced 2.0.4
Installing yiisoft/yii2-app-advanced (2.0.4)
- Installing yiisoft/yii2-app-advanced (2.0.4)
Loading from cache

Created project in ../htdocs/advanced
Loading composer repositories with package information
Installing dependencies (including require-dev)
- Installing yiisoft/yii2-composer (2.0.3)
Loading from cache

- Installing ezyang/htmlpurifier (v4.6.0)
Loading from cache

- Installing cebe/markdown (1.1.0)
Loading from cache

- Installing bower-asset/jquery (2.1.4)
Loading from cache

- Installing bower-asset/jquery.inputmask (3.1.63)
Loading from cache

- Installing bower-asset/punycode (v1.3.2)
Loading from cache

- Installing bower-asset/yii2-pjax (v2.0.4)
Loading from cache

- Installing yiisoft/yii2 (2.0.4)
Loading from cache

- Installing swiftmailer/swiftmailer (v5.4.0)
Loading from cache

- Installing yiisoft/yii2-swiftmailer (2.0.4)
Loading from cache

- Installing yiisoft/yii2-codeception (2.0.4)
Loading from cache

- Installing bower-asset/bootstrap (v3.3.4)
Loading from cache

- Installing yiisoft/yii2-bootstrap (2.0.4)
Loading from cache

- Installing yiisoft/yii2-debug (2.0.4)
Loading from cache

- Installing bower-asset/typeahead.js (v0.10.5)
Loading from cache

- Installing phpspec/php-diff (v1.0.2)
Loading from cache

- Installing yiisoft/yii2-gii (2.0.4)
Loading from cache

- Installing fzaninotto/faker (v1.4.0)
Loading from cache

- Installing yiisoft/yii2-faker (2.0.3)
Loading from cache

Writing lock file
Generating autoload files

change the default jdk path in netbeans 8.0.2

2015-05-21T17:55:00.003+05:30

i have installed netbeans in
A:\Program Files\NetBeans 8.0.2\

go to
A:\Program Files\NetBeans 8.0.2\etc

edit
netbeans.conf

change line 57

netbeans_jdkhome="A:\Program Files\Java\jdk1.8.0_31"

netbeans_jdkhome="A:\Program Files\Java\jdk1.8.0_45"

Yii redirect to referrer URL

2015-05-13T08:33:00.002+05:30

$this->redirect(Yii::app()->request->urlReferrer);

Magento : Get Base Url , Skin Url , Media Url , Js Url , Store Url and Current Url

2015-04-15T08:03:00.000+05:30

Get Url in phtml files

1. Get Base Url :

Mage::getBaseUrl();

2. Get Skin Url :

Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_SKIN);

(a) Unsecure Skin Url :

$this->getSkinUrl('images/imagename.jpg');

(b) Secure Skin Url :

$this->getSkinUrl('images/imagename.gif', array('_secure'=>true));

3. Get Media Url :

Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_MEDIA);

4. Get Js Url :

Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_JS);

5. Get Store Url :

Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_WEB);

6. Get Current Url

Mage::helper('core/url')->getCurrentUrl();

Get Url in cms pages or static blocks

1. Get Base Url :

{{store url=""}}

2. Get Skin Url :

{{skin url='images/imagename.jpg'}}

3. Get Media Url :

{{media url='/imagename.jpg'}}

4. Get Store Url :

{{store url='mypage.html'}}

A.D. The Bible Continues - Faith Video (Promo)

2015-04-04T22:16:00.001+05:30

Enable Disabled Buttons in Windows

2015-03-04T15:23:00.000+05:30

https://www.raymond.cc/blog/download/did/851/

the program must 10 years old, still works. click to enable, youll see the "on"

paletton.com ! Website Color Scheme

2015-03-04T14:54:00.001+05:30

http://paletton.com/#uid=20Q0B0k35z+9St27hv44xrP5hp6

No Admin User for Windows 7 :) Manage to get back the admin

2015-03-04T14:44:00.000+05:30

i wanted the CTRL + ALT + DEL login for window 7 Enterprise

playing around with the registry have to be careful, with no usb and windows dvd

i manage to remove the 4GB limit in my 32 bit windows 7 installation, its using all 10GB have to some more test and see :)

HKEY_LOCAL_MACHINE\
SOFTWARE\
Microsoft\
Windows NT\
CurrentVersion\
Winlogon\
SpecialAccounts\
UserList

i add the last two key

select the "UserList" key on the right side add user name as DWORD (32bit) Value

the "user" was a admin account, i couldnt logged into from command prompt or runas. it was like doomsday well not quite.

i tried to login into recovery mode "Repair Your Computer" option when you press F8

chose the command prompt option in the "System Recovery Options" menu

* i was to login using the admin account user

net user Administrator /active:yes simple or capital didnt work

type regedt32.exe

in registry tool click
HKEY_LOCAL_MACHINE or HKLM

then click File -> Load Hive option

go to your windows drive, note the drive letters may be different

Windows\System32\config

click the SOFTWARE file and load it

add name u want myHive

goto

HKEY_LOCAL_MACHINE\
myHive\
Microsoft\
Windows NT\
CurrentVersion\
Winlogon\
SpecialAccounts\
UserList

delete the entries and make the value to 1

thats it.

SQL Injection Cheat Sheet

2015-01-29T09:50:00.000+05:30

http://ferruh.mavituna.com/sql-injection-cheatsheet-oku/#AboutMySQLandPHP

15 Cool Things About PHP That Most People Overlook

2015-01-29T09:47:00.003+05:30

http://www.ioreader.com/2007/08/17/11-cool-things-about-php-that-most-people-overlook/

wireframe.cc website wireframe tool

2015-01-29T09:46:00.001+05:30

wireframe.cc