PwN3d 3v3ryTh1ng!

Openoffice.org- Play starwars galaxy easter egg OpenOffice Spreadsheet

2010-06-01T23:36:00.003+08:00

If you are working with OpenOffice and you need a break, do this ;).

Lets start :

Open OpenOffice Spreadsheet application, then in a blank cell put this

=GAME("StarWars")

Screenshot

Click thumbnails to enlarge image

Original post:
http://www.unixmen.com/gaming-on-linux/618-openofficeorg-play-starwars-galaxy-easter-egg-in-calc
http://wiki.services.openoffice.org/wiki/Easter_Eggs

Finding Duplicates with SQL

2010-05-27T11:12:00.003+08:00

Here's a query for finding duplicates in a table.

SELECT id_company,
  COUNT(id_company) AS occurrences
FROM company
GROUP BY id_company
HAVING ( COUNT(id_company) > 1 )

You could also use this technique to find rows that occur exactly once as bellow

SELECT id_company
FROM company
GROUP BY id_company
HAVING ( COUNT(id_company) = 1 )

How to Create Auto Increment Columns in Oracle

2010-05-24T13:27:00.003+08:00

CREATE TABLE test_table
(
ID NUMBER NOT NULL,
ID_COMPANY VARCHAR2(20 BYTE)
)

Table created.

CREATE SEQUENCE test_sequence
START WITH 1
INCREMENT BY 1;

Sequence created.

CREATE OR REPLACE TRIGGER test_trigger
BEFORE INSERT
ON test_table
REFERENCING NEW AS NEW
FOR EACH ROW
BEGIN
SELECT test_sequence.nextval INTO :NEW.ID FROM dual;
END;
/

Trigger created.

Now, test adding sample data

SQL> INSERT INTO test (ID_COMPANY) VALUES ('ABC123');

1 row created.

ps : Oracle is sucks. MySQL is sexy!

Port Scanner

2010-05-05T13:15:00.001+08:00

File list

1) Scar.jar
2) scan.sh (runner for linux)
3) scan.bat (runner for windows)
4) README (RTFM)

ps : This is very simple port scanner, does not support proxy and no error handler, but still can be used. I just spend less than an hour for this, if there is any bug, please let me know.

Download here

Ping Specific port in JAVA

2010-05-05T11:12:00.003+08:00

This class is for testing the connectivity to a database. Very useful to avoid data missing during db server is down. Data can be save in file or store in another db server temporarily.

package com.blogspot.lxnx;

import java.io.*;
import java.net.*;


public class Pinger {
  public static void main(String args[]) {
    try {
      InetAddress addr = InetAddress.getByName("localhost"); 
      int port = 3306; 
      SocketAddress sockaddr = new InetSocketAddress(addr, port); 
      
      // Create an unbound socket 
      Socket sock = new Socket(); 
      // This method will block no more than timeoutMs. 
      // If the timeout occurs, SocketTimeoutException is thrown. 
      int timeoutMs = 2000; // 2 seconds 
      sock.connect(sockaddr, timeoutMs); 
      System.out.println("Alive!");
    } catch (UnknownHostException e) {
      System.err.println("Unable to lookup");
    } catch (SocketTimeoutException e) {
      System.err.println("Connection timeout");
    } catch (IOException e) { 
      System.err.println("Unable to reach");
    } 
  
   }
}

credit to http://www.exampledepot.com/egs/java.net/CreateClientSocket.html

Find Developers who Grok Coding

2010-04-15T20:35:00.002+08:00

I just read, a post about this FizzBuzz thing, here then go to the original post. Then, i write the code in Java just for poc.

Here is my code

public class FizzBuzz {
  public static void main(String[] args) {
    for(int i = 1; i < 101; i++) {
      if (i % 3== 0 || i % 5 == 0) {
        if (i % 3 == 0)
        System.out.print("Fizz");
        if (i % 5 == 0)
        System.out.print("Buzz");
      }
      else
      System.out.print(i);
      System.out.println("");
    }
  }
}

How to reset ROOT password for MySQL Server 5.0

2010-03-18T16:24:00.003+08:00

Stop my sql server

 Start Menu -> Control Panel -> Administrative Tools -> Services

Find mysql, right click and select stop

Open Command Prompt

 Run -> type "cmd"

Execute the following command in the command prompt

 cd C:\Program Files\MySQL\MySQL Server 5.0\bin  
 mysqld-nt.exe -u root --skip-grant-tables

Leave the current command prompt as it is, and open a command prompt window.
Execute the following command in the command prompt in the second command prompt.

 cd C:\Program Files\MySQL\MySQL Server 5.0\bin  
 mysql

 C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql  
 Welcome to the MySQL monitor. Commands end with ; or \g.  
 Your MySQL connection id is 1  
 Server version: 5.0.67-community-nt MySQL Community Edition (GPL)  
 Type 'help;' or '\h' for help. Type '\c' to clear the buffer.  
 mysql>

Execute the following command to update the password in the sql command windows.

 UPDATE user SET Password = PASSWORD('NEW_PASSWORD') WHERE User = 'root';

After you are finished close the first command prompt and type "exit;" in the second command prompt windows to disconnect successfully. You can now start the MySQL service.

*Note for Haslyn : Sorry, I just forgot mysql pass in your PC, so i write this for u.*

Funny Code

2010-03-12T16:45:00.001+08:00

Once I had a junior programmer writing VB code that needed to know the day of the week. He decided to write his own code, and read something like:

if (day = 1) or (day = 8) or (day = 15) or (day = 22) or (day = 29) then
weekday = "Monday"
elseif (day = 2) or (day = 9) or (day = 16) or (day = 23) or (day = 30) then
weekday = "Tuesday"
...

Trying to be educational I asked him for his opinion about his own code, and he said that he would simply modify it every month.

– PedroChan

Java Joke

2010-03-12T16:16:00.002+08:00

A group of computer science majors were listening to a lecture about Java programming at a university. After the lecture one of the men leaned over and grabbed a women's breast.

Woman: "Hey! That's private, OK!?"

The man hesitated for a second looking confused.

Man: "But I thought we were in the same class?"

10 Reasons Why You Need Java Now by Red1 (ADempire)

2010-03-10T08:10:00.001+08:00

10 Reasons Why You Need Java Now

1. The world will end in 2012. You got to live life to the fullest.
Dying without knowing Java is like never experiencing sex.

2. Java is the defacto matured ironman of programming languages. I use
to say to my 9 year-old prodigy - If C is the mother of all languages,
then Java is its dad.

3. Java developers fetch higher pay. J2EE architects sleep on business
class flights.

4. If you are more idiot and dumb than my 9 yr-old son then u can
download from www.alice.org and learn the concepts real fast.

5. You can say this to the other gurus, "Heh.. sorry.. I am only good in
Java".

6. Top SourceForge projects such as ADempiere are prorgammed in Java.

7. Java has lots of API Libraries that are matured for the serious
industries.

8. IBM uses Java.

9. Even Sun dies after giving birth to Java. And Oracle is willing to
take over the biological son.

10. The world has only 10,000 certified Java holders. It is still a
murky blue ocean, not as saturated and cluttered as Python's 50,000 strong.

Taken from OSDC.MY mailing list.

How to TAR/UNTAR

2009-11-21T13:56:00.000+08:00

TAR is used to create a Tape ARchive (tarball). It's pretty much the same concept as a ZIP/RAR file.

To get the files out of a tarball, *.tar :

tar xvf filename.tar

If the tarball has also been gzipped (compressed), *.tar.gz :

tar xvfz filename.tar.gz

Extract only certain directories from the tarball, do this:

tar xvzf filenameg.tar.gz */wanted.dir/*

For file *.tar.bz2, use the following command :

tar yxf filename.tar.bz2

To tar up a file in the current directory into a tarball called filename.tar.gz :

tar cfz filename.tar.gz *.db

To see a list of the files within a tarball :

tar -tzf filename.tar.gz

Hello, World

2009-09-11T13:09:00.003+08:00

 public class HelloWorld {  
      public static void main(String[] args) {  
        System.out.println("SalamX");  
        System.out.println("Hello, World!");  
        System.out.println("Please wait for the next post..");  
   }  
 }