Pages

Monday, 27 April 2015

Drupal install by drush command

E:\xampp\htdocs\drupal>cd\

E:\>cd xampp

E:\xampp>mysql
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: N
O)

E:\xampp>mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.1.41 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database newdrupal;
Query OK, 1 row affected (0.00 sec)

mysql> ;
ERROR:
No query specified

mysql> exit;
Bye

E:\xampp>cd htdocs

E:\xampp\htdocs>cd drupal

E:\xampp\htdocs\drupal>drush si standard --account-name=admin --account-pass=adm
in --db-url=mysql://root:@localhost/newdrupal


You are about to create a sites/default/files directory and create a sites/defau
lt/settings.php file and DROP all tables in your 'newdrupal' database. Do you wa
nt to continue? (y/n): y
No tables to drop.                                                          [ok]

Starting Drupal installation. This takes a few seconds ...                  [ok]

Installation complete.  User name: admin  User password: admin              [ok]


E:\xampp\htdocs\drupal>


si = SITE-INSTALL
standard = INSTALLATION mode (second is manual)
account-name=admin
account-pass=admin
db-url=mysql://root:@localhost/newdrupal
 

Saturday, 25 April 2015

SQL syntax for each of the SQL commands

Select Statement

SELECT "column_name" FROM "table_name"


Distinct
SELECT DISTINCT "column_name" FROM "table_name"


Where
SELECT "column_name" FROM "table_name" WHERE "condition"


And/or
SELECT "column_name" FROM "table_name" WHERE "simple condition" {[AND|OR] "simple condition"}


In
SELECT "column_name"
FROM "table_name"
WHERE "column_name" IN ('value1', 'value2', ...)


Between
SELECT "column_name"
FROM "table_name"
WHERE "column_name" BETWEEN 'value1' AND 'value2'


Like
SELECT "column_name"
FROM "table_name"
WHERE "column_name" LIKE {PATTERN}


Order By
SELECT "column_name"
FROM "table_name"
[WHERE "condition"]
ORDER BY "column_name" [ASC, DESC]


Count
SELECT COUNT("column_name")
FROM "table_name"


Group By
SELECT "column_name1", SUM("column_name2")
FROM "table_name"
GROUP BY "column_name1"


Having
SELECT "column_name1", SUM("column_name2") FROM "table_name" GROUP BY "column_name1" HAVING (arithmetic function condition)


Create Table Statement
CREATE TABLE "table_name" ("column 1" "data_type_for_column_1", "column 2" "data_type_for_column_2",... )


Drop Table Statement
DROP TABLE "table_name"


Truncate Table Statement
TRUNCATE TABLE "table_name"


Insert Into Statement
INSERT INTO "table_name" ("column1", "column2", ...) VALUES ("value1", "value2", ...)


Update Statement
UPDATE "table_name" SET "column_1" = [new value] WHERE {condition}



Delete From Statement
DELETE FROM "table_name" WHERE {condition}



Copy only the structure of an existing table into new table:

SELECT * INTO tbl_new FROM tbl_old WHERE 1=2;

Copy the structure and data of an existing table into new table:

SELECT * INTO tbl_new FROM tbl_old;

Friday, 27 April 2012

FB EMOTICONS..

Animated Emoticons Codes for Facebook Chat :
[[126236287388324]] – Love Code
[[126125527399400]] – Muaaach Kissing :*
[[126134560731830]] – Hoam Ngantuk Rek
[[126261164052503]] – Hula Hula
[[126221767389776]] – Spin Heart
[[126214010723885]] – Stroke
[[126386227373330]] – Oversleep Insomnia
[[389448181885]] – Week
[[126539730695178]] – Love Shame
[[126540207361797]] – Love Smail
[[126232017388751]] – Broken heart
[[126229700722316]] – Pikachu
[[126392380706048]] – ready sleep
[[126276450717641]] – blast love ..tiupan cinta
[[126391564039463]] – Stress
[[110566632320002]] – Cat listening to music
[[126230590722227]] – Super Mario
[[126213110723975]] – Hello Ketty
[[126227960722490]] – kiss
[[126230880722198]] – Green Worm Ani
[[126229327389020]] – Rose Red Ani
[[127868980561350]] – Heart beat
[[126220920723194]] – Santa
[[126216480723638]] – butterfly blue
[[126132024065417]] – Heart rotate ani
[[126278187384134]] – O Yeah Hippo
[126217194056900]] – i ? u
[[389449726885]] – i love you
[[126540207361797]] – Smileys Inlove
[[398699314236]] – Teddy n ?
[[110780922298250]] – Heart on Fire
[[127878643893717]] – hand Clap
[[398570519236]] – mickey at Sleep
[[394930959230]] – Smileys Zzzz
[[126398717372810]] – Converse
[[110563818986950]] – Wew
[[110566395653359]] – cat licking screen
"Copy/Paste these code in chat"............

Friday, 20 April 2012

VLC 2.0 download

VLC 2.0 ready for download

here to download -http://www.videolan.org/vlc/

Features

VIDEO

Rewritten video output core and modules, allowing subpicture blending in GPU.

Shader support in the OpenGL output, for colorspace conversion, including 10bits.

New video outputs for Windows 7, Android, iOS and OS/2.

AUDIO
  • New resamplers for higher quality audio.
  • New dynamic range compressor and karaoke filters.
  • Simplification of the audio core for faster processing.
  • New audio outputs for iOS, Android and OS/2.
FORMATS
  • Multi-threaded decoding for H.264, MPEG-4/Xvid and WebM.
  • Support for 10bits codecs, WMV image and some other codecs.
  • Rewritten support for images, including jpeg, png, xcf, bmp…
  • Important changes in RealVideo and Real Format support.
  • CrystalHD cards and Android OpenMAX support for hardware decoding.