JUNK REPORT

Tips n' Trik Open Office 3.0

noreply@blogger.com (IT STUFF) — Wed, 04 Mar 2009 01:44:00 +0000

Tips n' Trik Open Office 3.0

Sebenernyanya seh jarang pake n lom explore OO3 na, tapi gara2 ada yg nanya, ywd coba ngoprek...

No. 1 :
Menghilangkan Dialog Box Saat Delete Cell Contents di Open Office 3.0 Calc (Seperti di Microsoft Office Excel)

Di Open Office 3.0 kalau Delete isinya pake tuts Delete hasil seperti gambar dibawah ini :

Sebenernya lebih tepat judulnya membuat fungsi delete di open office 3 seperti di microsoft office excel.

Langkah 1 :
Buka Open Office Calc 3.0 nya.

Langkah 2 :
Klik Tools >> pilih Costumize

Langkah 3 :
Sesusah langkah 2 muncul dialog dibawah ini.

klik tab Keyboard

Tempatkan kursor pada :
Pada Shortkeys blok pada Delete
Pada Functions>>Category>>Edit
Pada Functions>>Function>>Delete Contents (yg pertama)
Functions>>Keys>>Backspace trus klik Modify
Nah muncul deh dibawah Backspace>>Delete (liat gambar)
Klik Ok deh...
Job Done...

Ket : pada Shortkeys pada Delete default nya kosong, digambar sudah masuk

by : mossy
thx to : om Fajar

VPN Server on Ubuntu 7.04 Server

noreply@blogger.com (IT STUFF) — Wed, 14 Jan 2009 03:54:00 +0000

OS: Ubuntu Server 7.04

Applikasi : PPTPD, IPTABLES(untuk share koneksi internet)

Step by step:

1. Install service pptpd

Code:
# sudo apt-get install pptpd

2. Edit konfigurasinya (tentukan localip & remoteip)
(Ilustrasi disini hanya sekedar contoh, Anda bisa menggantinya dengan IP-private yang lain)

Code:
# sudo nano /etc/pptpd.conf
localip 192.168.1.1
remoteip 192.168.1.100-120

3. File konfigurasi yang utama pptpd

Code:
# sudo nano /etc/ppp/pptpd-options

# === aktifkan / enable baris-baris berikut, defaultnya disable, === #
# caranya hilangkan tanda pagar di awal baris/paragraf: === #

Code:
name Nama_VPN
refuse-pap
refuse-chap
refuse-mschap
require-mschap-v2
require-mppe-128

ms-dns 192.168.1.1
## ms-dns isi dengan ip dns untuk share internet

proxyarp
nodefaultroute
lock
nobsdcomp
noipx
mtu 1490
mru 1490

4. Buat user yang diperbolehkan mengakses VPN Server dengan format:

client -> server -> secret -> IP addresses -> = tekan tab

Code:
# sudo nano /etc/ppp/chap-secrets

# client server secret IP addresses
user * password *

5. Restart PPTP service

Code:
# sudo /etc/init.d/pptpd restart

VPN Server Setting SELESAI

Selanjutnya kita lakukan ipforward (supaya bisa numpang akses internet via VPN server) dengan IPTABLES:

Code:
# sudo iptables -F; iptables -t nat -F; iptables -t mangle -F
# sudo echo 1 > /proc/sys/net/ipv4/ip_forward
# sudo iptables -t nat -A POSTROUTING -o eth0 -j MASQUERADE

SELESAI

Silahkan konek ke vpn server (Via LAN atau Internet)
- Via LAN (VPN server Menggunakan IP Private)
- Via Internet (VPN server menggunakan IP Public)

By : 0x99
Source : www.yogyafree.net/forum2

Tweak Friendster With JS Part 4

noreply@blogger.com (IT STUFF) — Mon, 13 Oct 2008 10:36:00 +0000

Ok sekarang kita lanjut ke JS untuk fungsi tambahan seperti jam,mp3 flash..dll
Kita mulai :
Seperti biasa gunakan notepad karna dengan notepad semuanya bisa kita lakukan :
1. Stand alone addBox (membuat tampilan box baru baik itu di kiri/kanan profile FS kalian).
Pertama kita harus menggunakan script addBox dari Marfillaster. Disini aku sudah buatkan 3 bagian yaitu ; A, B, C. Itu adalah posisi dimana kalian bisa menempatkan semua JS kalian (apabila kalian menggunakan JS lain).
Ini dia scriptnya :
BAGIAN A

//onload handler
function onProfileLoad() {
//addboxes here

BAGIAN B

}
if (!attachOnLoadHandler(function(){onProfileLoad()})) window.onload = function(){onProfileLoad()};
function addBox (type,head,htm,id,sibling) {
//by marfillaster

//type "LEFT" | "RIGHT"
//head header string
//htm innerHTML string
//id css_id string
//sibling css_id_insertbefore string | null
/* Available default Siblings
LEFT
0 = controlpanel
1 = photos
13 = blogs
12 = reviews
6 = moreabout
18 = publiccomments
10 = scrapbook
RIGHT
15 = meettrail
2 = friends
14 = googleads
7 = fan
8 = groups
null - appends to last
*/

try {
var li=document.createElement("li");
} catch(e) {
var li=document.createElement("

");
}
if(type=="LEFT") {
var ul=document.getElementById("0").parentNode.parentNode;
htm="

"+htm+"

";
}
else var ul=document.getElementById("2").parentNode.parentNode;

li.innerHTML="

"+
"

"+head+"

"+
"

"+
htm+
"

"+
"

";

if(sibling==null) ul.appendChild(li);
else {
sibling=document.getElementById(sibling).parentNode;
ul.insertBefore(li,sibling);
}
}

BAGIAN C

Nah script di atas adalah script inti buat membuat fs kalian beda kyk punya wa tof…...

by : Feri Wiliandi Pradana

TestDisk, Data Recovery

noreply@blogger.com (IT STUFF) — Fri, 03 Oct 2008 08:39:00 +0000

TestDisk, Data Recovery

TestDisk is OpenSource software and is licensed under the terms of the GNU Public License (GPL).

TestDisk is a powerful free data recovery software! It was primarily designed to help recover lost partitions and/or make non-booting disks bootable again when these symptoms are caused by faulty software, certain types of viruses or human error (such as accidentally deleting a Partition Table). Partition table recovery using TestDisk is really easy.

TestDisk can

* Fix partition table, recover deleted partition
* Recover FAT32 boot sector from its backup
* Rebuild FAT12/FAT16/FAT32 boot sector
* Fix FAT tables
* Rebuild NTFS boot sector
* Recover NTFS boot sector from its backup
* Fix MFT using MFT mirror
* Locate ext2/ext3 Backup SuperBlock
* Undelete files from FAT filesystem
* Copy files from deleted FAT, NTFS and ext2/ext3 partitions.

TestDisk has features for both novices and experts. For those who know little or nothing about data recovery techniques, TestDisk can be used to collect detailed information about a non-booting drive which can then be sent to a tech for further analysis. Those more familiar with such procedures should find TestDisk a handy tool in performing onsite recovery.
Operating systems

TestDisk can run under

* DOS (either real or in a Windows 9x DOS-box),
* Windows (NT4, 2000, XP, 2003, Vista),
* Linux,
* FreeBSD, NetBSD, OpenBSD,
* SunOS and
* MacOS

Source files and precompiled binary executables are available for DOS, Win32, MacOSX and Linux from the download page
Filesystems

TestDisk can find lost partitions for all of these file systems:

* BeFS ( BeOS )
* BSD disklabel ( FreeBSD/OpenBSD/NetBSD )
* CramFS, Compressed File System
* DOS/Windows FAT12, FAT16 and FAT32
* HFS, HFS+ and HFSX, Hierarchical File System
* JFS, IBM's Journaled File System
* Linux ext2 and ext3
* Linux LUKS encrypted partition
* Linux RAID md 0.9/1.0/1.1/1.2
o RAID 1: mirroring
o RAID 4: striped array with parity device
o RAID 5: striped array with distributed parity information
o RAID 6: striped array with distributed dual redundancy information
* Linux Swap (versions 1 and 2)
* LVM and LVM2, Linux Logical Volume Manager
* Mac partition map
* Novell Storage Services NSS
* NTFS ( Windows NT/2000/XP/2003/Vista/2008 )
* ReiserFS 3.5, 3.6 and 4
* Sun Solaris i386 disklabel
* Unix File System UFS and UFS2 (Sun/BSD/...)
* XFS, SGI's Journaled File System

visit this link.

Damn Small Linux 4.4.4

noreply@blogger.com (IT STUFF) — Fri, 03 Oct 2008 08:06:00 +0000

Damn Small is a very versatile 50MB mini desktop oriented Linux distribution. DSL was originally developed as an experiment to see how many usable desktop applications can fit inside a 50MB live CD. It was at first just a personal tool/toy. But over time Damn Small Linux grew into a community project with hundreds of development hours put into refinements including a fully automated remote and local application installation system and a very versatile backup and restore system which may be used with any writable media including a hard drive, a floppy drive, or a USB device.

DSL has a nearly complete desktop, and many command line tools. All applications are chosen with the best balance of functionality, size and speed. Damn Small also has the ability to act as an SSH/FTP/HTTPD server right off of a live CD. In our quest to save space and have a fully functional desktop we've made many GUI administration tools which are fast yet still easy to use. What does DSL have?

XMMS (MP3, CD Music, and MPEG), FTP client, Dillo web browser, Netrik web browser, FireFox, spreadsheet, Sylpheed email, spellcheck (US English), a word-processor (Ted), three editors (Beaver, Vim, and Nano [Pico clone]), graphics editing and viewing (Xpaint, and xzgv), Xpdf (PDF Viewer), emelFM (file manager), Naim (AIM, ICQ, IRC), VNCviwer, Rdesktop, SSH/SCP server and client, DHCP client, PPP, PPPoE (ADSL), a web server, calculator, generic and GhostScript printer support, NFS, Fluxbox and JWM window managers, games, system monitoring apps, a host of command line tools, USB support, and pcmcia support, some wireless support.

Damn Small is small enough and smart enough to do the following things:

• Boot from a business card CD as a live linux distribution (LiveCD)
• Boot from a USB pen drive
• Boot from within a host operating system (that's right, it can run *inside* Windows)
• Run very nicely from an IDE Compact Flash drive via a method we call "frugal install"
• Transform into a Debian OS with a traditional hard drive install
• Run light enough to power a 486DX with 16MB of Ram
• Run fully in RAM with as little as 128MB (you will be amazed at how fast your computer can be!)
• Modularly grow -- DSL is highly extendable without the need to customize

Change in DSL v4.4:

* New Lua/Fltk refactored for enhanced performance.
* New Fltk library now available for C/C++ programs.
* New fldiff - File Diff GUI Viewer.
* Update to rsync to v3.0.2
* Updated mydslBrowser - new feature "Download Only"
* Modified "X Window Snapshot" to save image file with date.
* Added dfm association for easy display of "X Window Snapshot" images.
* Updated .torsmorc for more consistent "used/free/total"
* Restored Firefox default search engines.
* New low resource background & theme.
* New font added smoothansi - used in jwm menu.
* New .luafltkrc for Lua/Fltk theme and defaults.
* Updated dmix.
* Updated man script, new -o -b options and site.
* Fixed permissions on fusermount.
* Fixed cpanel bug to turn off ssh daemon.
* Modified nfs-common to also start portmap when needed.
* Patched kbdconfig to properly select keymaps.
* Modified .bash_profile to eliminate an extra login shell.
* Updated cgi example test.lua to call proper cgi.lua
* Removed stray line in Fluxbox menu.
* Updated "Getting Started" document with Wiki link and wireless info link.

DOWNLOAD 1
DOWNLOAD 2

from : Astalavista.Ms Forum

About IPSwicth WhatsUpGold Release Notes v11.0.3

noreply@blogger.com (IT STUFF) — Mon, 29 Sep 2008 02:24:00 +0000

About IPSwicth WhatsUpGold Release Notes v11.0.3

just visit that link...

More About Knoppix

noreply@blogger.com (IT STUFF) — Sat, 27 Sep 2008 04:45:00 +0000

Starting out with Knoppix

The easiest way to begin your own use of Knoppix is with a vended CD-ROM. Almost a score of distributors in Northern Europe, the United States, and Australia process orders for Knoppix CDs, including betas.

If you have bandwidth to burn, you can download the nearly 700-MB Knoppix ISO image, available at no charge through the Knoppix download/order page (see Resources). Mirrors are abundant around the world. Remember that you can burn a CD-ROM from any operating system; you don't need Linux to create a Knoppix CD.

With a standard Knoppix CD-ROM in hand, you've almost reached Linuxland. All you need is a capable PC-class machine: 80486 or later, at least 20 MB of RAM (although with anything less than 128 MB, you'll have to give up office products and perhaps the desktop manager or even X11 server), standard SVGA, and a means to boot. Even without these, it's often possible to use Knoppix. Look first, though, at a conventional situation:

* If the PC boots from CD-ROM, slide in the Knoppix CD and you should have a recognizable, useful Linux two minutes later. Many BIOSes have the capability to boot from CD-ROM but aren't configured for it. In this case, you might need to restart the PC and enter "BIOS setup" or "BIOS features" by pressing Delete or another hardware-specific key on startup. When you configure the boot medium, remember that it doesn't have to be the CD-ROM exclusively, or even first; it's fine to sequence a floppy drive before the CD-ROM. All you need is to ensure that the CD-ROM is present as a recognized boot source. Save the new configuration, and you should be ready to start.
* An alternative is to boot from a floppy disk that recognizes the CD-ROM and passes off boot control to the latter. These are often called "startup diskettes." The Knoppix image includes a "rawrite" program, which prepares such diskettes.

If Knoppix works well for you, it's natural that your next instinct will be to change it. While customization of Knoppix isn't a secret, most effort on the project has gone to making the standard installation "bullet-proof." Among the several distinct ways to alter Knoppix, the one likely to be of broadest interest is remastering, during which you can substitute your own software for a portion of that on the standard Knoppix CD-ROM. Toward the end of 2002, Jubal John prepared an authoritative "How to remaster ..." document, listed in Resources. This process is a rather delicate one, and too involved to abbreviate here. The main difficulty is that low-level management of disk partitions risks system integrity, if anything goes wrong.

Knoppix alternatives

I'm enthusiastic about Knoppix, and I'm far from alone. I've heard from dozens of administrators and network managers with such affection for Knoppix that they "wouldn't leave home without it." Any Linux professional or hobbyist operating in an environment that's at all dynamic -- even just an occasional need to run on others' equipment -- should try out a copy of Knoppix. The cost to do so is vanishingly low, and the potential benefits and convenience are quite high.

Knoppix has also proven friendly to business initiatives. Knopper relates that "there are many Knoppix derivates around; some have been published by the purchasers, and some are used only internally inside a company. It is the customer's decision whether or not to publish the free software product he purchased, since the GPL does not require you to publish or give away a customized version, and does not even force you to include only free software on the same media. So, some companies use Knoppix as a platform for their free, or also proprietary, software, in order to show a demo version of their product to potential customers without the hassle of an installation on hard disk before they can use it."

Be aware, though, that there are specific applications of Knoppix where alternatives might serve you better. The Resources section shows a few of these. If you work much with older equipment, for instance, Knoppix probably isn't practical. Knoppix's standard configuration demands too much memory -- 32 MB isn't enough. That's a case where projects such as muLinux are more likely to help.

Knoppix can also be viewed as a "least common denominator": its purpose is to get the computer running with as little delay or human assistance as possible. Among other consequences, this means that standard Knoppix gives users no chance to configure exotic video or network settings before KDE comes up.

Products like SuSE's Live Eval take a different approach. Live Eval aims to mimic as much of a full SuSE distribution as possible from a single CD-ROM. In particular, it expects user interaction for its boot sequence and configuration. This gives more flexibility, but even an experienced SuSE engineer told me it takes around seven minutes to boot to the point Knoppix typically arrives at in under two. On the other hand, a Live Eval session affords a more accurate glimpse of what it's like to use a full-blown Linux distribution in a standard working environment.

Pascal Scheffers, a programmer with Erasmus University, described still another situation where Knoppix and vendor products provide different solutions. Suppose you need to test the installation of a product. If the tool at hand is Knoppix, you might dedicate one host to installation tests, and perhaps use Ghost (or Ghost-for-Unix) to help automate the installations. Knoppix gives a standard starting point for use of the host.

For this sort of problem, Scheffers likes to use VMware and its "non-persistent" option. VMware can host an operating system within a particular session, exercise an installation, then roll back all changes to their initial state.

DOWNLOAD KNOPPIX

Knoppix boots Linux

noreply@blogger.com (IT STUFF) — Sat, 27 Sep 2008 04:36:00 +0000

Knoppix is a bootable CD. Although it's certainly not unique in that, the organization and content of a Knoppix CD are distinctive. Consider a few scenarios. Suppose you're an instructor. You meet your students in a training room, with only half an hour to check out all the hardware and prepare configurations for them. The result is inevitable: halfway through class, some of your demonstrations won't work, because at least a few of the student machines will have inconsistent Service Pack installations, or hardware that's never been exercised, or an environment customized by a subtle neurotic.

Or perhaps you have piles of commodity hardware. No one particularly cares about all that computing capacity -- except on the few days of the year around the Super Bowl, or Tax Day, or perhaps when your organization runs its quarterly massive simulations of the weather patterns over the North Pacific. How do you bring all those heterogeneous hosts into effective teamwork, without investing too much of your own time in tedious configuration "burn-in"?

Maybe you're just a mobile person; you move around and would happily use whatever desktops are available, but in practice you find they rarely have the software you consider necessary for a minimal working environment. You might want a quick way to set up a security scanner, a well-equipped office automation desktop on a firewalled interior network, or a secure server. Or perhaps you're often called to check out consumer-grade machines with mysterious symptoms. If you could simply exercise a consistent set of diagnostics, you wouldn't have to rely so much on end-user speculation such as, "the modem has a virus, doesn't it?".

These are just a few of the occasions when Knoppix solves simply what otherwise can be thorny problems. Knoppix's inventor, Klaus Knopper, is himself a trainer who launched the Knoppix project "in between 1999-2000," in his recollection, as an educational project and to meet his own requirements.

As 2003 begins, the main Knoppix product is an open source CD-ROM that boots into GNU/Linux, is remarkably effective and swift at detecting hardware and installing correct drivers, and cleverly uses on-the-fly decompression to make room for almost 2 GB of applications and data. Moreover, as Knopper tells it, one of Knoppix's main features is "the GPL license for the software collection as well as all scripts and tools written by me, which allows the recipients to modify, distribute, and sell the CD on their own."

Still, this simple description hides plenty. While Linux adepts often experiment with bootable media, and many applications rely on data compression, Knoppix shows a singular level of polish. It's simple, only because Knopper and a few other project contributors took so much care in constructing it to be simple.

FRAMEWORK

noreply@blogger.com (IT STUFF) — Fri, 26 Sep 2008 07:43:00 +0000

The Microsoft .NET Framework version 2.0 redistributable package installs the .NET Framework runtime and associated files required to run applications developed to target the .NET Framework v2.0.

The .NET Framework version 2.0 improves scalability and performance of applications with improved caching, application deployment and updating with ClickOnce, support for the broadest array of browsers and devices with ASP.NET 2.0 controls and services. For more information on the .NET Framework 2.0

System Requirements

* Supported Operating Systems: Windows 2000 Service Pack 3; Windows 98; Windows 98 Second Edition; Windows ME; Windows Server 2003; Windows XP Service Pack 2

* Required Software:

o Windows Installer 3.0 (except for Windows 98/ME, which require Windows Installer 2.0 or later). Windows Installer 3.1 or later is recommended.
o IE 5.01 or later: You must also be running Microsoft Internet Explorer 5.01 or later for all installations of the .NET Framework.
* Disk Space Requirements: 280 MB (x86), 610 MB (x64)

Instructions

1. Important: Make sure you have the latest service pack and critical updates for the version of Windows that you are running. To find recent security updates, visit Windows Update.
2. Click the Download button on this page to start the download
3. Do one of the following:
* To start the installation immediately, click Run.
* To save the download to your computer for installation at a later time, click Save.
* To cancel the installation, click Cancel.

IMPORTANT: If you have installed previous pre-release versions of .NET Framework v2.0, such as Beta 1, Beta 2 or Community Technical Preview (CTP) builds, then you must uninstall these versions via Add/Remove Programs in Control Panel before installing this final release version.

* Download 2.0 SP1 x86 here.
*Download 2.0 SP1 x64 here.
*Download 3.0 SP1 here.

MySql Tutor

noreply@blogger.com (IT STUFF) — Wed, 24 Sep 2008 09:23:00 +0000

GROUP BY (Aggregate) Functions

Name Description
AVG() Return the average value of the argument
BIT_AND() Return bitwise and
BIT_OR() Return bitwise or
BIT_XOR()(v4.1.1) Return bitwise xor
COUNT(DISTINCT) Return the count of a number of different values
COUNT() Return a count of the number of rows returned
GROUP_CONCAT()(v4.1) Return a concatenated string
MAX() Return the maximum value
MIN() Return the minimum value
STD() Return the population standard deviation
STDDEV_POP()(v5.0.3) Return the population standard deviation
STDDEV_SAMP()(v5.0.3) Return the sample standard deviation
STDDEV() Return the population standard deviation
SUM() Return the sum
VAR_POP()(v5.0.3) Return the population standard variance
VAR_SAMP()(v5.0.3) Return the sample variance
VARIANCE()(v4.1) Return the population standard variance

This section describes group (aggregate) functions that operate on sets of values. Unless otherwise stated, group functions ignore NULL values.

If you use a group function in a statement containing no GROUP BY clause, it is equivalent to grouping on all rows.

For numeric arguments, the variance and standard deviation functions return a DOUBLE value. The SUM() and AVG() functions return a DECIMAL value for exact-value arguments (integer or DECIMAL), and a DOUBLE value for approximate-value arguments (FLOAT or DOUBLE). (Before MySQL 5.0.3, SUM() and AVG() return DOUBLE for all numeric arguments.)

The SUM() and AVG() aggregate functions do not work with temporal values. (They convert the values to numbers, losing everything after the first non-numeric character.) To work around this problem, you can convert to numeric units, perform the aggregate operation, and convert back to a temporal value. Examples:

SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(time_col))) FROM tbl_name;
SELECT FROM_DAYS(SUM(TO_DAYS(date_col))) FROM tbl_name;

Functions such as SUM() or AVG() that expect a numeric argument cast the argument to a number if necessary. For SET or ENUM values, the cast operation causes the underlying numeric value to be used.

*

AVG([DISTINCT] expr)

Returns the average value of expr. The DISTINCT option can be used as of MySQL 5.0.3 to return the average of the distinct values of expr.

AVG() returns NULL if there were no matching rows.

mysql> SELECT student_name, AVG(test_score)
-> FROM student
-> GROUP BY student_name;

*

BIT_AND(expr)

Returns the bitwise AND of all bits in expr. The calculation is performed with 64-bit (BIGINT) precision.

This function returns 18446744073709551615 if there were no matching rows. (This is the value of an unsigned BIGINT value with all bits set to 1.)
*

BIT_OR(expr)

Returns the bitwise OR of all bits in expr. The calculation is performed with 64-bit (BIGINT) precision.

This function returns 0 if there were no matching rows.
*

BIT_XOR(expr)

Returns the bitwise XOR of all bits in expr. The calculation is performed with 64-bit (BIGINT) precision.

This function returns 0 if there were no matching rows.
*

COUNT(expr)

Returns a count of the number of non-NULL values of expr in the rows retrieved by a SELECT statement. The result is a BIGINT value.

COUNT() returns 0 if there were no matching rows.

mysql> SELECT student.student_name,COUNT(*)
-> FROM student,course
-> WHERE student.student_id=course.student_id
-> GROUP BY student_name;

COUNT(*) is somewhat different in that it returns a count of the number of rows retrieved, whether or not they contain NULL values.

COUNT(*) is optimized to return very quickly if the SELECT retrieves from one table, no other columns are retrieved, and there is no WHERE clause. For example:

mysql> SELECT COUNT(*) FROM student;

This optimization applies only to MyISAM tables only, because an exact row count is stored for this storage engine and can be accessed very quickly. For transactional storage engines such as InnoDB and BDB, storing an exact row count is more problematic because multiple transactions may be occurring, each of which may affect the count.
*

COUNT(DISTINCT expr,[expr...])

Returns a count of the number of different non-NULL values.

COUNT(DISTINCT) returns 0 if there were no matching rows.

mysql> SELECT COUNT(DISTINCT results) FROM student;

In MySQL, you can obtain the number of distinct expression combinations that do not contain NULL by giving a list of expressions. In standard SQL, you would have to do a concatenation of all expressions inside COUNT(DISTINCT ...).
*

GROUP_CONCAT(expr)

This function returns a string result with the concatenated non-NULL values from a group. It returns NULL if there are no non-NULL values. The full syntax is as follows:

GROUP_CONCAT([DISTINCT] expr [,expr ...]
[ORDER BY {unsigned_integer | col_name | expr}
[ASC | DESC] [,col_name ...]]
[SEPARATOR str_val])

mysql> SELECT student_name,
-> GROUP_CONCAT(test_score)
-> FROM student
-> GROUP BY student_name;

Or:

mysql> SELECT student_name,
-> GROUP_CONCAT(DISTINCT test_score
-> ORDER BY test_score DESC SEPARATOR ' ')
-> FROM student
-> GROUP BY student_name;

In MySQL, you can get the concatenated values of expression combinations. You can eliminate duplicate values by using DISTINCT. If you want to sort values in the result, you should use ORDER BY clause. To sort in reverse order, add the DESC (descending) keyword to the name of the column you are sorting by in the ORDER BY clause. The default is ascending order; this may be specified explicitly using the ASC keyword. SEPARATOR is followed by the string value that should be inserted between values of result. The default is a comma (“,”). You can eliminate the separator altogether by specifying SEPARATOR ''.

The result is truncated to the maximum length that is given by the group_concat_max_len system variable, which has a default value of 1024. The value can be set higher, although the effective maximum length of the return value is constrained by the value of max_allowed_packet. The syntax to change the value of group_concat_max_len at runtime is as follows, where val is an unsigned integer:

SET [SESSION | GLOBAL] group_concat_max_len = val;

Beginning with MySQL 5.0.19, the type returned by GROUP_CONCAT() is always VARCHAR unless group_concat_max_len is greater than 512, in which case, it returns a BLOB. (Previously, it returned a BLOB with group_concat_max_len greater than 512 only if the query included an ORDER BY clause.)

See also CONCAT() and CONCAT_WS(): Section 11.4, “String Functions”.
*

MAX([DISTINCT] expr)

Returns the maximum value of expr. MAX() may take a string argument; in such cases, it returns the maximum string value. See Section 7.4.5, “How MySQL Uses Indexes”. The DISTINCT keyword can be used to find the maximum of the distinct values of expr, however, this produces the same result as omitting DISTINCT.

MAX() returns NULL if there were no matching rows.

mysql> SELECT student_name, MIN(test_score), MAX(test_score)
-> FROM student
-> GROUP BY student_name;

For MAX(), MySQL currently compares ENUM and SET columns by their string value rather than by the string's relative position in the set. This differs from how ORDER BY compares them. This is expected to be rectified in a future MySQL release.
*

MIN([DISTINCT] expr)

Returns the minimum value of expr. MIN() may take a string argument; in such cases, it returns the minimum string value. See Section 7.4.5, “How MySQL Uses Indexes”. The DISTINCT keyword can be used to find the minimum of the distinct values of expr, however, this produces the same result as omitting DISTINCT.

MIN() returns NULL if there were no matching rows.

mysql> SELECT student_name, MIN(test_score), MAX(test_score)
-> FROM student
-> GROUP BY student_name;

For MIN(), MySQL currently compares ENUM and SET columns by their string value rather than by the string's relative position in the set. This differs from how ORDER BY compares them. This is expected to be rectified in a future MySQL release.
*

STD(expr)

Returns the population standard deviation of expr. This is an extension to standard SQL. As of MySQL 5.0.3, the standard SQL function STDDEV_POP() can be used instead.

This function returns NULL if there were no matching rows.
*

STDDEV(expr)

Returns the population standard deviation of expr. This function is provided for compatibility with Oracle. As of MySQL 5.0.3, the standard SQL function STDDEV_POP() can be used instead.

This function returns NULL if there were no matching rows.
*

STDDEV_POP(expr)

Returns the population standard deviation of expr (the square root of VAR_POP()). This function was added in MySQL 5.0.3. Before 5.0.3, you can use STD() or STDDEV(), which are equivalent but not standard SQL.

STDDEV_POP() returns NULL if there were no matching rows.
*

STDDEV_SAMP(expr)

Returns the sample standard deviation of expr (the square root of VAR_SAMP(). This function was added in MySQL 5.0.3.

STDDEV_SAMP() returns NULL if there were no matching rows.
*

SUM([DISTINCT] expr)

Returns the sum of expr. If the return set has no rows, SUM() returns NULL. The DISTINCT keyword can be used in MySQL 5.0 to sum only the distinct values of expr.

SUM() returns NULL if there were no matching rows.
*

VAR_POP(expr)

Returns the population standard variance of expr. It considers rows as the whole population, not as a sample, so it has the number of rows as the denominator. This function was added in MySQL 5.0.3. Before 5.0.3, you can use VARIANCE(), which is equivalent but is not standard SQL.

VAR_POP() returns NULL if there were no matching rows.
*

VAR_SAMP(expr)

Returns the sample variance of expr. That is, the denominator is the number of rows minus one. This function was added in MySQL 5.0.3.

VAR_SAMP() returns NULL if there were no matching rows.
*

VARIANCE(expr)

Returns the population standard variance of expr. This is an extension to standard SQL. As of MySQL 5.0.3, the standard SQL function VAR_POP() can be used instead.

VARIANCE() returns NULL if there were no matching rows.

Safe from Hacker

noreply@blogger.com (IT STUFF) — Wed, 24 Sep 2008 08:46:00 +0000

According to a survey commissioned by F-Secure in January, only 7 percent of Americans are confident that they can open e-mail attachments without infecting their computers with malware built by hackers. However, 95 percent of respondents had security software installed on their computers. Needless to say, computer users have little confidence in their computing actions and the security suites meant to defend them.

Ron Teixeira, executive director of the National Cyber Security Alliance, agrees. “You can’t just leave the security software program running and expect yourself to be safe from hackers and malicious attacks. People have started to figure that out,” he said. Teixeira isn’t suggesting that security software doesn’t work. Users just need to be aware of the latest threats and take an active role in protecting their systems and ultimately their identities. He offered the advice of “actively defending your system. For example, users can make sure their security software has all the most recent updates.”
Think Beyond the Security Suite

Other experts argue that the average computer user can do much more to take security action. Mugzzi told us, “What doesn’t break you makes you stronger,” and she learned directly from her hacking experience. “Now, I have specific security programs running on my computer to defend against all types of threats,” she said. Mugzzi uses Keylogger Pro to protect against keylogging attacks (a hacker’s method of capturing and recording user keyboard keystrokes), and she uses IdentityLock to safeguard her passwords. Because Mugzzi does business online she also invested in a corporate software and hardware firewall solution called SonicWall.

If you asked Ryan Russell of El Cerrito, Calif., who is a security researcher and author of Hack Proofing Your Network, what he thought of Mugzzi’s efforts, he would say that she won’t know for sure that her network and PC are safe until she tries to hack herself. His attitude has been that in order to understand attacks and vulnerabilities, you have to understand “how to hack.” He is a believer in “hacking yourself” because if you don’t, the hackers will. “I have received a lot of criticism over the years for providing hacking tips, but it is a solid way to understand how hackers work and how secure your system really is. People learn by doing,” he said.

Russell shared with LAPTOP three simple ways to invade your own computer. The tools he instructed us to use through each of the hacks are publicly available and are used by real hackers. Note: We only encourage the use of these tools on your own PC. If you use any of these tools on a computer or network where you don’t have explicit permission to do so, you could be potentially committing a crime.

Hack Yourself to Save Yourself

download : HackersaVeZipp

Knowledge is Power

Meningkatkan Kecepatan Browser Firefox3

noreply@blogger.com (IT STUFF) — Tue, 23 Sep 2008 01:54:00 +0000

Jika Anda menggunakan koneksi internet jenis broadband, Anda dapat menggunakan feature pipelining untuk meningkatkan kecepatan firefox. hasilnya program firefox yang anda gunakan dapat membuka halaman website lebih cepat secara simultan dan tentunya menghemat waktu yang Anda miliki.

Untuk meningkatkan kecepatan firefox ini, pertama-tama buka program firefox dan ketik "about:config" di dalam address bar lalu "Enter".
Anda akan masuk ke area konfigurasi yang menyajikan bbrp list "Preference Name".
Selajutnya, ketikan "Network.http" pada kolom filter dan tekan "Enter" kembali.

Cari baris "Network.http.pipelining" dam "Network.http.proxy.pipelining" di dalam "Preference Name"

Klik ganda baris "network.http.pipelining" dan "network.http.proxy.pipelining" sehingga kondisi "value" berubah menjadi "True"

Langkah berikutnya, klik ganda baris "Network.http.pipelining.maxrequests". Pada window "Enter integer value" masukkan nilai sebesar 30, lalu tekan "OK".

Terakhir tutup area konfigurasi dan silakan masukan bbrp alamat website yg ingin di jelajah

penulis : Eko.Lanunueardy@chip.co.id
ditulis kembali dari Majalah Chip Edisi 09/2008 halaman 183

http://www.forummikrotik.com/chit-chat/3264-firefox3-meningkatkan-kecepatan-browser.html#post30989

Tweak Friendster With JS Part 3

noreply@blogger.com (IT STUFF) — Tue, 16 Sep 2008 11:17:00 +0000

11. menghilangkan sesuatu........(ntah apa lah namanya)

A) Hide boxes:
=blogs & review:
Code:
.blogsreviews { display:none;}
.blogs {display:none;}
.reviews { display:none;}
=fan of:
Code:
.myfans {display:none;}
.fanof {display:none;}
=groups:
Code:
.groups {display:none;}
=friends:
Code:
.friends{display:none;}
=photo gallery:
Code:
.photos {display:none;}
=media box:
Code:
.scrapbook{display:none;background:transparent;}
b)add ons:
=menghilangkan "recent updates":
Code:
.user_tracker {
display:none;
}
= code menghilangkan logo,search,dll:
Code:
/* FriendsterMagic - remove top banner */
.banner_ad_fix{display:none;}

/* FriendsterMagic - remove logo */
#logo {display:none;background:transparent;}

/* FriendsterMagic remove search form*/
#search {display:none;background:transparent;}
#search form {display:none;background:transparent;}

/* FriendsterMagic - hide the connection box */
.meettrail{display:none;background:transparent;}

/* FriendsterMagic - hide google ads */
#content_14 {display:none!important;}

/* FriendsterMagic - hide report abuse */
#reportabuse{display:none;}

/* FriendsterMagic - remove featured sponsor */
#marketing_bg{display:none;background:transparent;}
= remove footer:
Code:
#footer_container {
display: none;
}

#footer {
display: none;
}
=hide main navigation,sub navigation.(tombol home,profil,logout,dll):
Code:
#subnav {
display: none;
}

#mainnav, #mainnav .left, #mainnav .right {
display: none;
}

#navdivider {
display: none;
}

#navigation{
dispaly: none;
}
= customize main navigation:
Code:
/* FriendsterMagic - main navigation*/
#mainnav {
margin:0 0 10px 0;
padding:0 0 2px 0;
width:100%;
font-size:9px;
font-weight:bold;
background: url(URL_OF_IMAGE) fixed no-repeat center; #000000;}
=hide main navigations
Code:
#mainnav div.links a:link, #mainnav div.links a:visited, #mainnav div.links a:active { color:#FF0000; text-decoration:none; }
}
#mainnav .left {display:none;}
#mainnav .right {display:none;}
#navdivider {display:none;background:transparent;}
#subnav {display:none;}
*klo navigasi kmu hidden, jangan kmu pake lagi code "costomize main navigation" nya...
percuma..............hauhauhauua

= fiend list dibuat satu colom:
Code:
/* FriendsterMagic - one column friends list */
.friends div.boxcontent{width:100%;text-align:center;}
.friends.flogrid75{text-align:center;width:75px;}
.friends div.viewall a{text-align:center;width:100%;padding-left:20px;}
=image effect:
ada banyak image effect, tapi akoe kasi satu aja dolo ya??
Code:
/* EMOKIDD IMAGE EFFECT*/
img { opacity:.50;filter:alpha(opacity=50) }
a:hover img { opacity:.50;filter:alpha(opacity=50, style=1) }
or u can try dis one:
Code:
/*KHER IMAGE EFFECT*/
a:hover img { filter:alpha(Opacity=100,FinishOpacity=0,Style=2); }
A:hover img{filter:alpha(finishopacity=0, style=2)}
12.dan lain lain
=merubah tampilan foto prymary menjadi gif image
Code:
div.imgblock200 {
background:url(URL_GIF_IMAGE);
background-position: center center;
background-repeat: no-repeat;
height:128px;
width:170px;
}
div.imgblock200 img {display:none !important}
=bullet/icon/emoticon in control panel data:
Code:
.controlpanel .q {background: url(URL) background-attachment: fixed;
background-position:center;
background-position: center left;
background-repeat: no-repeat;}
=bullet/icon/emoticon in control panel buttons:
Code:
#controlPanelButtons a, #controlPanelButtons a:link, #controlPanelButtons a:visited {
background-image: url( URL);
background-attachment: fixed;
background-position: center left;
background-repeat: no-repeat;
background-color: transparent;}
=background di master headers:
Code:
.commonbox h1, .commonbox h2 {
background-color: transparent;
background-image: url(IMG URL HERE);
background-attachment: fixed;
background-position:center;
background-position: center center;
background-repeat: repeat;
text-align:center;}

by : Feri Wiliandi Pradana

Puppy Linux

noreply@blogger.com (IT STUFF) — Thu, 11 Sep 2008 07:51:00 +0000

What is Puppy Linux?

Basics

Okay, let's get the basics out the way first. If you just want to get on and see Puppy in action for yourself head off to the Manual for instructions on downloading, burning and booting ISOs. Or, if you're actually wondering what on earth an operating system actually is, or what Linux is, or what makes Puppy different, or what it might be able to do for you, read on...

Operating Systems, Linux and little Puppies

Puppy Linux is an operating system, which means it is that which makes a computer able to function at all, it is that which allows all the hardware on a computer to talk to each other and that which enables applications to run. Other famous operating systems are Microsoft Windows, Apple's OSX and MSDOS. Puppy takes its ancestory from Linux and so, like most other Linux-based operating systems, it is a completely free and open source.

There are a number of things that make Puppy different from other Linux derivatives, but the most significant is its small size, around 80MB! This lends itself to some very useful and unique features;

* 'Live' booting from CDs, USB sticks and other portable media.
* Ability to run entirely from RAM, making it unusually fast and particularly relevant to modern PCs with solid state CF drives, such as Wyse & HP/Compaq 'thin clients' and the ASUS EeePC & similar 'next generation' hand-helds.
* Very low minimum system requirements, runs happily on old Pentiums with as little as 32Mb RAM.
* Sub-60 second boot times.

Usability and Compatibility

Though Puppy is small, it's still able to offer the complete range of a applications you'd expect to see on any average computer, like wordprocessors, spreadsheets, internet browsers, games and image editors. Extra software comes in the form of dotpets and dotpups and there are a number of methods to find and install them. There is a Puppy Software Installer (for Puppy 2, for Puppy 3) that offers repository searches and automatic installations, or this website offers the ability to browse and search repositories -- the Puppy forum is also a good place to find newer or rarer applications and drivers.

Puppy is aimed to be as easy to use as possible and very little technical knowledge is assumed. As much hardware is automatically detected as possible, you will often find that, whereas on other operating systems you had to install extra driver software to get your particular device functioning, Puppy will succesfully detect and install the driver without user prompting.

Download New Puppy Linux

Tree view in linux

noreply@blogger.com (IT STUFF) — Mon, 11 Aug 2008 04:59:00 +0000

By Sandeep_Vaniya
http://www.sandeep-vaniya.blogspot.com

Keterangan :
Skrip ini dibuat untuk display tree view direktori di Linux (seperti tree command di DOS. Itu menscan direktori secara berulang dan kemudian display tree view-nya. Penggunaan argumen "-width" di tree view dapat di-compressed dan diperluas. Untuk men-dislay bagaimana cara memberikan argumen ke tipe skrip "perl tree.pl" pada linux terminal. Ikutilah display intruksi pada Help. Kita harus mempunyai perl paket yang diinstal pada sistem untuk menjalankan skrip ini. Default $expand_size=5 dan $max_width=10. expand_size memutuskan berapa banyak ruang antara + dan "nama direktori atau file. max_width adalah nilai maksimum dari expand_size. Pemakai dapat meningkatkan default expand_size dan max_width dengan mengedit tree.pl.

Download Source Files

Tweak Friendster With JS Part 2

noreply@blogger.com (IT STUFF) — Mon, 11 Aug 2008 04:02:00 +0000

Biasanya kita edit profil kita di kotak css yg ada di coztumize profil yg ada di fs dengan cara mengcopy lalu paste semua code css……tapi untuk trik ini berbeda karena ada beberapa code yg dilarang fs untuk kita gunakan dalam fs kita
Maka hanya beberapa kodenya saja yg jalan. Sebagai contoh Kode untuk menghilangkan Google Ads atau navigasi tidak akan jalan.

Oleh sebab itu, di sini kita akan menggunakan CSS linker.

Sebelumnya, kamu register dulu di ripway.com
Langsung saja ke sini Sign Up Ripway Account

Setelah kamu register.
Klik My Files.

Kemudian Upload Files css yg sudah kalian buat di notepad tadi.

Setelah itu, kamu browse file CSS yang kamu edit di Notepad tadi.

Dan klik Upload.

Setelah itu kamu akan melihat file terserah.css tadi yg sudah terupload.

Note:
Jika kamu ingin mengedit atau menambahkan kode2 CSS lagi.
Kamu tinggal klik Edit Text.

Setelah berhasil mengupload file CSS tadi.
Kamu copy URL CSS kamu.

Dan untuk menginjeksi file CSS kamu tadi. (external CSS)
Kamu pakai yang namanya CSS linker.

Css linker adalah code yg berguna untuk me redirect semua kode yg km buat untuk km gunakan di fs kalian.
Ini CSS LINKER yg biasa wa gunakan

Caranya masukan url css yg sudah di upload tadi ke dalam linker css di atas

Contoh:

Lalu masukan ke media box yang ada di coztumize profil maka dengan otomatis akan me redirect kode css kalian

Tentunya kmu sudah memiliki basic css code di css box kamu..

Setelah itu baru kita rombak abis fs kmu dengan beberapa code magic berikut ini:

1. wellcome alert (peringatan selamat datang)
Code:
/* Welcome Alert Box*/
body {
height:expr/**/ession(
function welcome()
{alert('haI '+parent.pageViewerFName+' !! jaNgN lUPa NinGgaLin TEsTi yaH!!!');}
window.onload=welcome);
}
2. goodbye alert
Code:
/* Goodbye Alert Box*/
body{left:expression(
function goodbye()
{alert('mO KmaNa '+pageViewerFName+'! daH dI adD LuM!!!');}
window.onunload=goodbye);}
kedua code diatas hanya bekerja di IE

3. membuat logo sendiri
Code:
/* FriendsterMagic - personalize logo */
#navigation {
background: #000000;
border: 5px solid #ce4424;
margin:10px 0 30px 0;
padding:260px 0 0 0;
background-image: url(URL GAMBAR);
background-attachment:scroll;
background-repeat: no-repeat;
background-position: center center;
}
4. menghilangkan "more about me" link pada control panel box
Code:
/* FriendsterMagic - remove more about me link */
.controlpanel a.more {display:none;}

5. transparan "shout out"
Code:
/*Transparent Shoutout*/

{transparent shoutout}
.controlpanel .so { margin: 0 -20px 10px 0; width: 257px; position: relative; background:url() repeat-y top left; color: #ce4424; font-weight: bold; }
.controlpanel .so a { color: #ce4424; }
.controlpanel .so div#cpShoutoutBox, .controlpanel .so div#cpShoutoutEditBox { padding: 7px 7px 5px 7px; margin: 0; }
.controlpanel .so div#cpShoutoutEditBox { display: none; }
.controlpanel .sol { position: absolute; left: -5px; top: 8px; width: 6px; height: 11px; background:url() no-repeat; }
.controlpanel .sob { width: 257px; height: 2px; background:url() no-repeat; line-height: 0; font-size: 0; }
6. no klik kanan dengan message (window bergetar)
Code:
body {right:expr/**/ession(function ephemeralshake(){if (event.button==2){
self.resizeTo(1024,768)
self.moveBy(15,17)
self.moveBy(-13,-17)
self.moveBy(13,19)
self.moveBy(-14,-16)
self.moveBy(14,23)
self.moveBy(-25,-20)
self.moveBy(24,22)
self.moveBy(-20,-17)
self.moveBy(24,16)
self.moveBy(-13,-20)
self.moveBy(20,20)
self.moveBy(-26,-27)
self.moveBy(15,17)
self.moveBy(-13,-17)
self.moveBy(13,19)
self.moveBy(-14,-16)
self.moveBy(14,23)
self.moveBy(-25,-20)
self.moveBy(24,22)
self.moveBy(-20,-17)
self.moveBy(24,16)
self.moveBy(-13,-20)
self.moveBy(20,20)
self.moveBy(-26,-27)
self.moveBy(15,17)
self.moveBy(-13,-17)
self.moveBy(13,19)
self.moveBy(-14,-16)
self.moveBy(14,23)
self.moveBy(-25,-20)
self.moveBy(24,22)
self.moveBy(-20,-17)
self.moveBy(24,16)
self.moveBy(-13,-20)
self.moveBy(20,20)
self.moveBy(-26,-27)
self.moveBy(15,17)
self.moveBy(-13,-17)
self.moveBy(13,19)
self.moveBy(-14,-16)
self.moveBy(14,23)
self.moveBy(-25,-20)
self.moveBy(24,22)
self.moveBy(14,23)
self.moveBy(-25,-20)
self.moveBy(24,22)
self.moveBy(-20,-17)
self.moveBy(24,16)
self.moveBy(-13,-20)
self.moveBy(20,20)
self.moveBy(-26,-27)
self.moveBy(15,17)
self.moveBy(-13,-17)
self.moveBy(13,19)
self.moveBy(-14,-16)
self.moveBy(14,23)
self.moveBy(-25,-20)
self.moveBy(24,22)
self.moveBy(-20,-17)
self.moveBy(24,16)
self.moveBy(-13,-20)
self.moveBy(20,20)
self.moveBy(-26,-27)
self.moveBy(15,17)
self.moveBy(-13,-17)
self.moveBy(13,19)
self.moveBy(-14,-16)
self.moveBy(14,23)
self.moveBy(-25,-20)
self.moveBy(24,22)
self.moveBy(-20,-17)
self.moveBy(24,16)
self.moveBy(-13,-20)
self.moveBy(20,20)
self.moveBy(-26,-27)
self.moveBy(15,17)
self.moveBy(-13,-17)
self.moveBy(13,19)
self.moveBy(-14,-16)
self.moveBy(14,23)
self.moveBy(-25,-20)
self.moveBy(24,22)
self.moveBy(-20,-17)
self.moveBy(-13,-20)
self.moveBy(20,20)
self.moveBy(-26,-27)
self.moveBy(28,17)
self.moveBy(0, 0)
alert("mO NgaPaIn seEh!!");}}
document.onmousedown=ephemeralshake);}
*ganti kata²nya doank

7. border untuk page kmu
Code:
/* FLOATING PAGE EFFECT - FRIENDSTER-TWEAKERS.COM */body {border-style: groove; border-top-color: #ce4424;border-bottom-color: #ce4424; border-left-color: #ce4424;border-right-color: #ce4424; border-top-width: 25px;border-bottom-width: 25px; border-left-width: 25px;border-right-width: 25px;}
*ganti HEX COLOR(#xxxxxx) sesuka hati

8. center profil, text, serta content
Code:
/* CENTER PROFILE TEXT AND CONTENTS */
body,td,tr,div,p {
text-align: center;
}
9. scrolling box

= more about me:
Code:
/* SCROLLING MORE ABOUT ME BOX */
.content_moreabout_1_5 {
padding: 2px 2px 2px 2px;
overflow: auto;
width: 510PX;
height: 250px;
background-image: url();
background-attachment: fixed;
background-position: center;
background-repeat:repeat;
}
= comment box:
Code:
/* SCROLLING PUBLICCOMMENTS BOX */
#content_18 {
padding: 2px 2px 2px 2px;
overflow: auto;
width: 510px;
height: 250px;
background-image: url();
background-attachment: fixed;
background-position: center;
background-repeat:repeat;
background-color: transparent;
}
= scrolling testimonial (text comment yang dikirim teman)
Code:
/* PUBLICCOMMENTS CONTENT SCROLLINGBOX */
.publiccomments div div .dtd {
width: 100%;
}
.publiccomments div div .dtd ul {
padding: 2px 2px 2px 2px;
overflow: auto;
border: 2px dashed #ce4424;
width:380px;
height: 100px;
background-color:transparent;
background-image: url();
background-position: center;
background-repeat: repeat;
}
*kmu bisa pakai keduanya klo mau, biar lebih hemat tempat di page kmu,so tidak terlalu panjang ke bawah dia..

= media box
Code:
/* SCROLLING SCRAPBOOK BOX */
#content_10 {
padding: 2px 2px 2px 2px;
overflow: auto;
width: 100%;
height: 250px;
background-image: url();
background-attachment: fixed;
background-position: center;
background-repeat:repeat;
}
= friends box
Code:
/* SCROLLING FRIENDS BOX */
#content_2 {
padding: 2px 2px 2px 2px;
overflow: auto;
width: 100%;
height: 250px;
background-image: url();
background-attachment: fixed;
background-position: center;
background-repeat:repeat;
}
=custom scrollbar
Code:
/* CUSTOM SCROLLBARS */
body {
scrollbar-face-color: #ffffff;
scrollbar-highlight-color: #000000;
scrollbar-shadow-color: #000000;
scrollbar-3dlight-color: #ffffff;
scrollbar-arrow-color: #ffffff;
scrollbar-track-color: #000000;
scrollbar-darkshadow-color: #000000;
}
= scrollbar di sebelah kiri:
Code:
body {direction: rtl;}
#flo_wrapper{direction:ltr}
bole diganti hex colornya sesuka hati

10. custom status bar & tittle bar
= status bar:
Code:
/* CUSTOM STATUS BAR MESSAGE - FRIENDSTER-TWEAKERS.COM */
body{bottom:expr/**/ession(
function fstweakersstatus()
{window.status='KATA KATA KAMU'}
if (document.layers)
document.captureEvents(Event.mouseover)
document.onmouseover=fstweakersstatus);}
=tittle bar:
Code:
/* CUSTOM PAGE TITLE - FRIENDSTER-TWEAKERS.COM */
body{top:expr/**/ession(fstweakerspagetitle()
function fstweakerspagetitle(){
document.title = 'KATA KATA KAMU';
});}

bersambung...

by : Feri Wiliandi Pradana

Using AWE Memory in SQL Server 2000

noreply@blogger.com (IT STUFF) — Thu, 31 Jul 2008 07:23:00 +0000

Using AWE Memory in SQL Server 2000
By : Brad McGehee
May 31, 2003

If you are using SQL Server 2000 Standard Edition under Windows NT 4.0 or Windows 2000 (any version), or are running SQL Server 2000 Enterprise Edition under Windows NT 4.0 or Windows 2000 Server, or if your server has 4GB or less of RAM, the "awe enabled" option should always be left to the default value of 0, which means that AWE memory is not being used.

The AWE (Advanced Windowing Extensions) API allows applications (that are written to use the AWE API) to run under Windows 2000 Advanced Server or Windows 2000 Datacenter Server to access more than 4GB of RAM. SQL Server 2000 Enterprise Edition (not SQL Server 2000 Standard Edition) is AWE-enabled and can take advantage of RAM in a server over 4GB. If the operating system is Windows 2000 Advanced Server, SQL Server 2000 Enterprise Edition can us up to 8GB of RAM. If the operating system is Windows 2000 Datacenter Server, SQL Server 2000 Enterprise can use up to 64GB of RAM.

By default, if a physical server has more than 4GB of RAM, Windows 2000 (Advanced and Datacenter), along with SQL Server 2000 Enterprise Edition, cannot access any RAM greater than 4GB. In order for the operating system and SQL Server 2000 Enterprise Edition to take advantage of the additional RAM, two steps must be completed.

Exactly how you configure AWE memory support depends on how much RAM your server has. To configure Windows 2000 (Advanced or Datacenter), you must enter one of the following switches in the boot line of the boot.ini file, and reboot the server:

* 4GB RAM: /3GB (AWE support is not used)
* 8GB RAM: /3GB /PAE
* 16GB RAM: /3GB /PAE
* 16GB + RAM: /PAE

The /3GB switch is used to tell SQL Server to take advantage of 3GB out of the base 4GB of RAM that Windows 2000 supports natively. If you don't specify this option, then SQL Server will only take advantage of 2GB of the first 4GB of RAM in the server, essentially wasting 1GB of RAM.

AWE memory technology is used only for the RAM that exceeds the base 4GB of RAM, that's why the /3GB switch is needed to use as much of the RAM in your server as possible. If your server has 16GB or less of RAM, then using the /3GB switch is important. But if your server has more than 16GB of RAM, then you must not use the /3GB switch. The reason for this is because the 1GB of additional RAM provided by adding the /3GB switch is needed by the operating system in order to take advantage of all of the extra AWE memory. In other words, the operating system needs 2GB of RAM itself to mange the AWE memory if your server has more than 16GB of RAM. If 16GB or less of RAM is in a server, then the operating system only needs 1GB of RAM, allowing the other 1GB of RAM for use by SQL Server.

Once this step is done, the next step is to set the "awe enabled" option to 1 within SQL Server Enterprise Edition, and then restart the SQL Server service. Only at this point will SQL Server be able to use the additional RAM in the server.

One caution about using the "awe enabled" setting is that after turning it on, SQL Server no longer dynamically manages memory. Instead, it takes all of the available RAM (except about 128MB which is left for the operating system). If you want to prevent SQL Server from taking all of the RAM, you must set the "max server memory" option (described in more detail later in this article) to a figure that limits SQL Server to the amount or RAM you specify.

Tweak Friendster With JS Part 1

noreply@blogger.com (IT STUFF) — Tue, 29 Jul 2008 08:49:00 +0000

Ini adalah cara mentweak fs kita ato bisa di bilang edit fs sesuka lo.

Ok…mari kita mulai…..tapi baca dengan seksama…jika di longkap2 pasti pusing deh.

Pertama yg harus kalian tau adalah CSS dan JS.

CSS = Cascading Style Sheet .
Sebuah dokument yang digunakan untuk mendesain atau mengatur tampilan tata letak sebuah halaman web, CSS ini bersifat embeded pada tag HTML yang artinya menempel atau melekat pada tag HTML.

Sebagai Contoh embeded seperti di bawah ini :

/* MASTER HEADERS */

.commonbox h1, .commonbox h2 {

color: #ffffff;

}

Dengan CSS, kita bisa mengontrol/mengatur seluruh tampilan halaman web dengan hanya sebuah dokument CSS, biasanya ekstensi untuk file CSS adalah .css (dot css).

Jadi pada dasarnya CSS itu untuk desain tampilan layout profile kamu.
Misalnya : BackGround (BG) image, warna font, jenis font, warna border, dll.

JS=JavaScript.
JavaScript adalah bahasa pemrograman yang khusus untuk halaman web agar halaman web menjadi lebih hidup. Kalau dilihat dari suku katanya terdiri dari dua suku kata, yaitu Java dan Script. Java adalah Bahasa pemrograman berorientasi objek, sedangkan Script adalah serangkaian instruksi program.

JS bisa ditambahkan ke tweak FS kamu jika ingin menambah beberapa macam fungsi, spt mp3 player, whos viewed me (wvm), slideshow, guestbook, IP tracker, chatbox, dll. (Banyak sekali JS dengan berbagai fungsi yg bisa ditemukan di ftalk dan FTI).

Langkah-Langkah Mentweak FSmu dengan CSS.

Untuk lebih gampangnya silahkan buka Notepad kamu.

Untuk kode dasar CSS.
Kamu bisa ke profile editor di bawah ini :
Edit Friendster
Friendster-Tweakers

Di sana kamu akan dapat basic CSS kode.
Dimana navigation bar, google ads, dan hal2 lain masih akan nongol di profile kamu.
Jika tidak ditambahkan kode2 CSS lain.

Copy semua code yang kamu dapat setelah generate di editor itu ke Notepad-nya.

Contoh kode yg kamu dapat setelah digenerate:

/* michael's friendster profile editor v4.1 */

/* http://www.editfriendster.com */

/* PAGE BACKGROUND */

body {

  background-image: url(http://images.friendster.com/

images/homebg.gif);

  background-attachment: fixed;

  background-repeat: no-repeat;

  background-color: #ffffff;

  cursor: ;

/* MASTER BOXES */

.commonbox {

  border-color: #ffffff;

  background-color: #000000;

/* MASTER HEADERS */

.commonbox h1, .commonbox h2 {

  color: #ffffff;

/* CONTROL PANEL: BOX */

.controlpanel {

  background-color: #000000;

/* CONTROL PANEL: USER PHOTO */

.controlpanel .imgblock200 {

  border-color: #ffffff;

/* CONTROL PANEL: DATA */

.data a {

  text-decoration: ;

/* CONTROL PANEL: MORE ABOUT ME LINK */

a.more {

  text-decoration: ;

/* CONTROL PANEL: BUTTONS */

#controlPanelButtons a, #controlPanelButtons a:link,

#controlPanelButtons a:visited {

  font-family: Arial, Sans-serif;

  text-decoration: ;

#controlPanelButtons a:hover {

  font-family: Arial, Sans-serif;

  text-decoration: ;

Ini hanya contoh.

Setelah itu save dengan nama sesuka hati kamu, misalnya : terserah.css Format filenya harus *.css.

Ini baru penjelasan dari css.......belum inti dari tweak fs yg saya maksud, tunggu part berikutnya.

by : Feri Wiliandi Pradana

Cara Membobol Password dan Solusi Menangkalnya

noreply@blogger.com (IT STUFF) — Tue, 29 Jul 2008 08:29:00 +0000

Pengalaman pribadi mengajarkan saya untuk lebih hati-hati.

Jaman sekarang yang namanya hacker atau cracker semakin kreatif, dengan berbagai cara mereka berusaha menembus email Anda, friendster, rekening online, web site, bahkan blog.Anda tidak mau kan, kalau suatu saat profile Anda di friendster diubah oleh orang? Atau web site Anda tiba-tiba di ganti tampilannya oleh hacker / cracker ?

Salah satu cara hacker menembus account kita adalah dengan cara menebak password. Hacker menggunakan script yang dapat memasukkan puluhan password tiap detik untuk mencoba masuk ke dalam account kita.

Cara hacker menebak password kita antara lain dengan:

1. Brute force attack, yaitu dengan mencoba semua kombinasi, mulai dari aaaa sampai zzzz, sampai beberapa karakter.
2. Dictionary attack, yaitu dengan menebak menggunakan kata-kata dalam kamus, dan dikombinasikan dengan angka-angka atau karakter.
3. Personal information attack, dengan cara memasukkan data-data pribadi seperti nomor telepon, tanggal lahir, nama pacar, kode pos, dan sebagainya.

Password yang sangat lemah akan sangat mudah dibobol hacker dengan cara ini. Contoh password yang sangat lemah misalnya:

* 123456, qwerty, asdf, ini karena mudah sekali orang mengetik kombinasi ini di keyboard.
* password, mypassword, dan lain-lain yang menggunakan kata-kata dalam kamus (semua bahasa).
* tanggal lahir, nama pacar, dan lainnya yang merupakan data diri orang tersebut.

Password yang lemah, bisa dibobol dalam waktu yang lebih cepat, misalnya:

* menggunakan semua huruf kecil.
* menggunakan kombinasi kata dan angka, misalnya buku10, teroris80.
* mengganti huruf dengan karakter, misalnya c1nt@

Bagaimana password yang kuat dan sulit ditembus hacker?

1. Merupakan kombinasi dari huruf besar, huruf kecil, nomor, dan karakter.
2. Panjang lebih dari 10 karakter.
3. Tidak menyertakan kata-kata dalam kamus.

Password yang kuat harus mudah diingat oleh pemiliknya.

Contoh password yang kuat: 1mAu$100Ribu

Cara mengingatnya:

* 1 = kata “saya” diterjemahkan dalam bahasa Inggris (I).
* mAu = mau
* $ = uang
* 100Ribu = 100 ribu

Contoh password kuat yang lain: ninG->0+1Gul

Cara mengingatnya:

* ninG = misalnya nama orang sepesial buat Anda: Naning
* -> = panah identik dengan adalah
* 0+ = lambang cewek
* 1 =berarti nomor satu atau paling
* Gul = gula itu manis

Beberapa tips:

1. Jangan menggunakan password yang sama untuk berbagai macam layanan, misalnya password email Anda sama dengan password friendster. Ini berarti:
* seseorang yang dapat menjebol password friendster Anda, bisa juga menjebol password email Anda. Sementara di mata hacker menjebol password friendster lebih mudah daripada menjebol email Yahoo.
* admin atau “orang dalam” friendster tahu password Anda, dia juga bisa memasukkan password tersebut ke email Anda.
2. Jangan mengklik link di email yang menyatakan Anda harus memverifikasi password Anda. Email ini dikirim oleh hacker.
3. Jangan memasukkan password disitus selain yang memberikan layanan. Misalnya jangan memasukkan password yahoo di situs friendster untuk alasan apapun (misalnya import address book).
4. Sebelum login ke email atau yang lain, pastikan URL di browser Anda benar. Misalnya mail.yahoo.com bukan mail.yahoo-ltd.com atau yahoo-verify.com atau yang lain.
5. Untuk rekening online seperti e-gold, klik BCA, paypal, sebaiknya Anda tidak mengetik password Anda lewat keyboard (karena hacker bisa membaca keyboard Anda dengan program keylogger). Gunakan On Screen Keyboard, Charakter Map, atau copy paste dari huruf acak.

Okey begitulah tips-tips agar password kita sulit dibobol hacker. Semoga dengan tips ini account kita aman dan terhindar dari kebobolan.

Penulis: Oka Mahendra
Sumber :http://dedenthea.wordpress.com/

About Ping

noreply@blogger.com (IT STUFF) — Tue, 29 Jul 2008 04:52:00 +0000

“About PING”

Sebagai contoh, ada 2 host yang berbeda network seperti gambar dibawah:

Host A ——————– Lab A ———————— Host B

# (192.168.0.1)

(192.168.0.7) (192.168.10.3)

Ping (singkatan dari Packet Internet Groper) adalah sebuah program utilitas yang digunakan untuk memeriksa konektivitas jaringan berbasis teknologi Transmission Control Protocol/Internet Protocol (TCP/IP). Dengan menggunakan utilitas ini, dapat diuji apakah sebuah komputer terhubung dengan komputer lainnya. Hal ini dilakukan dengan cara mengirim sebuah paket kepada alamat IP yang hendak diujicoba konektivitasnya dan menunggu respons darinya. Nama “ping” datang dari sonar sebuah kapal selam yang sedang aktif, yang sering mengeluarkan bunyi ping ketika menemukan sebuah objek.

Apabila utilitas ping menunjukkan hasil yang positif maka kedua komputer tersebut saling terhubung di dalam sebuah jaringan. Hasil statistik keadaan koneksi ditampilkan dibagian akhir. Kualitas koneksi dapat dilihat dari besarnya waktu pergi-pulang (roundtrip) dan besarnya jumlah paket yang hilang (packet loss). Semakin kecil kedua angka tersebut, semakin bagus kualitas koneksinya. (id.wikipedia.org)

Pada contoh ini, seorang user di Host A melakukan ping ke alamat IP Host B. Mari kita cermati langkah demi langkah perjalanan datanya:

1. Internet Control Message Protocol (ICMP) menciptakan sebuah payload (data) pemintaan echo (di mana isinya hanya abjad di field data).
2. ICMP menyerahkan payload tersebut ke Internet Protocol (IP), yang lalu menciptakansebuah paket. Paling sedikit, paket ini berisi sebuah alamat asal IP, sebuah alamat tujuan IP, dan sebuah field protocol dengan nilai 01h (ingat bahwa Cisco suka menggunakan 0x di depan karakter heksadesimal , jadi di router mungkin terlihat seperti 0×01). Semua itu memberitahukan kepada host penerima tentang kepada siapa host penerima harus menyerahkan payload ketika network tujuan telah dicapai – pada contoh ini host menyerahkan payload kepada protocol ICMP.
3. Setelah paket dibuat, IP akan menentukan apakah alamat IP tujuan ada di network local atau network remote.
4. Karena IP menentukan bahwa ini adalah permintaan untuk network remote, maka paket perlu dikirimkan ke default gateway agar paket dapat di route ke network remote. Registry di Windows dibaca untuk mencari default gateway yang telah di konfigurasi.
5. Default gateway dari host 192.168.0.7 (Host A) dikonfigurasi ke 192.168.0.1. Untuk dapat mengirimkan paket ini ke default gateway, harus diketahui dulu alamat hardware dari interface Ethernet 0 dari router (yang dikonfigurasi dengan alamat IP 192.168.0.1tersebut) Mengapa demikian? Agar paket dapat diserahkan ke layer data link,lalu dienkapsulasi menjadi frame, dan dikirimkan ke interface router yang terhubung ke network 192.168.0.0. Host berkomunikasi hanya dengan alamat hardware pada LAN local. Penting untuk memahami bahwa Host A, agar dapat berkomunikasi dengan Host B, harus mengirimkan paket ke alamat MAC (alamat hardware) dari default gateway di network local.
6. Setelah itu, cache ARP dicek untuk melihat apakah alamat IP dari default gateway sudah pernah di resolved (diterjemahkan) ke sebuah alamat hardware:
* Jika sudah, paket akan diserahkan ke layer data link untuk dijadikan frame (alamat hardaware dari host tujuan diserahkan bersama tersebut).
* Jika alamat hardware tidak tersedia di cache ARP dari host, sebuah broadcast ARP akan dikirimkan ke network local untuk mencari alamat hardware dari 192.168.0.1. Router melakukan respon pada permintaan tersebut dan menyerahkan alamat hardware dari Ethernet 0, dan host akan menyimpan (cache) alamat ini. Router juga akan melakukan cache alamat hardware dari host A di cache ARP nya.
7. Setelah paket dan alamat hardware tujuan diserahkan ke layer data link, maka driver LAN akan digunakan untuk menyediakan akses media melalui jenis LAN yang digunakan (pada contoh ini adalah Ethernet). Sebuah frame dibuat, dienkapsulasi dengan informasi pengendali. Di dalam frame ini alamat hardware dari host asal dan tujuan, dalam kasus ini juga ditambah dengan field EtherType yang menggambarkan protocol layer network apa yang menyerahkan paket tersebut ke layer data link- dalam kasus ini, protocol itu adalah IP. Pada akhir dari frame itu terdapat sebuah field bernama Frame Check Sequence (FCS) yang menjadi tempat penyimpanan dari hasil perhitungan Cyclic Redundancy Check (CRC).
8. Setelah frame selesai dibuat, frame tersebut diserahkan ke layer Physical untuk ditempatkan di media fisik ( pada contoh ini adalah kabel twisted-pair )dalam bentuk bit-bit, yang dikirim saru per satu.
9. Semua alat di collision domain menerima bit-bit ini dan membuat frame dari bit-bit ini. Mereka masing-masing melakukan CRC dan mengecek jawaban di field FCS. Jika jawabannya tidak cocok, frame akan dibuang.

* Jika CRC cocok, maka alamat hardware tujuan akan di cek untuk melihat apakah alamat tersebut cocok juga (pada contoh ini, dicek apakah cocok dengan interface Ethernet 0 dari router).
* Jika alamat hardware cocok, maka field Ether-Type dicek untuk mencari protocol yang digunakan di layer Network.

1. Paket ditarik dari frame, dan apa yang tertinggal di frame akan dibuang. Paket lalu diserahkan ke protocol yang tercatat di field Ether-Type—pada contoh ini adalah IP.
2. IP menerima paket dan mengecek alamat tujuan IP. Karena alamat tujuan dari paket tidak sesuai dengan semua alamat yang dikonfigurasi di router penerima itu sendiri, maka router penerima akan melihat pada alamat IP network tujuan di routing tablenya.
3. Routing table harus memiliki sebuah entri di network 192.168.10.0, jika tidak paket akan dibuang dengan segera dan sebuah pesan ICMP akan dikirimkan kembali ke alamat pengirim dengan sebuah pesan “destination network unreachable” (network tujuan tidak tercapai)
4. Jika router menemukan sebuah entri untuk network tujuan di tabelnya, paket akan dialihkan ke interface keluar (exit interface)—pada contoh, interface keluar ini adalah interface Ethernet 1.
5. Router akan melakuakan pengalihan paket ke buffer Ethernet 1.
6. Buffer Ethernet 1 perlu mengetahui alamat hardware dari host tujuan dan pertama kali ia akan mengecek cache ARP-nya.

* Jika alamat hardware dari Host B sudah ditemukan, paket dan alamat hardware tersebut akan diserahkan ke layer data link untuk dibuat menjadi frame.
* Jika alamat hardware tidak pernah diterjemahkan atau di resolved oleh ARP (sehingga tidak dicatat di cache ARP), router akan mengirimkan sebuah permintaan ARP keluar dari interface E1 untuk alamat hardware 192.168.10.3.

Host B melakukan respon dengan alamat hardwarenya, dan paket beserta alamat hardware tujuan akan dikirimkan ke layer data link untuk dijadikan frame.

1. Layer data link membuat sebuah frame dengan alamat hardware tujuan dan asal , field Ether-Type, dan field FCS di akhir dari frame. Frame diserahkan ke layer Physical untuk dikirimkan keluar pada medium fisik dalam bentuk bit yang dikirimkan satu per satu.
2. Host B menerima frame dan segera melakuakan CRC. Jika hasil CRC sesuai dengan apa yang ada di field FCS, maka alamat hardware tujuan akan dicek. Jika alamat host juga cocok, field Ether-Type akan di cek untuk menentukan protocol yang akan diserahi paket tersebut di layer Network—Pada contoh ini, protocol tersebut adalah IP.

Download ASP.NET Maker

noreply@blogger.com (IT STUFF) — Tue, 29 Jul 2008 04:15:00 +0000



ASP.Net Maker ver.3.2.1 \| 9,42 MB ASPMaker is a powerful ASP code generator that can generate a full set of ASP (Active Server Pages) quickly from a Microsoft Access Database, SQL Server or any Data Source that supports ADO. Using ASPMaker, you can instantly create Web sites that allow users to view, edit, search, add and delete records on the Web. ASPMaker is designed for high flexibility, it offers numerous options for you to generate ASP applications that best suits your needs. The generated codes are clean, straightforward and easy-to-customize. ASPMaker can save you tons of time and is suitable for both beginners and experienced developers alike. Highlights * Advanced Security * User registration system * Export to CSV/HTML/Excel/Word/XML * File uploading to database or folder * Multiple Master/Detail * Custom View * Report * Customizable template * Database re-synchronization From : Forum Astalavista Download

Tip export data dengan SQL Server

noreply@blogger.com (IT STUFF) — Thu, 24 Jul 2008 13:23:00 +0000

Ada beberapa cara untuk melakukan export dan import data tetapi disini kami itkomputer ingin menerangkan sedikit tips singkat dengan memakai perintah transact SQL untuk melakukan proses export data dari database engine MS SQL Server ke Excel

INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:coba.xls;',

'SELECT [No Urut] FROM [Sheet1$]')

SELECT [No Urut] FROM dispatche

sebelum melakukan export sebaiknya anda mempunyai fileyang bernama coba.xls pada directory c:\coba.xls

sumber :

http://www.itkomputer.com/

Membuat User SQL Server

noreply@blogger.com (IT STUFF) — Thu, 24 Jul 2008 13:00:00 +0000

Membuat User SQL Server

SQL Server and Windows, merupakan seting default saat instalasi. Dengan konfigurasi ini maka akses koneksi ke SQL server dapat dilakukan menggunakan account Windows atau dengan account login SQL Server (tidak berhubungan dengan account Windows). Sekarang kita akan mempelajari bagai mana membuat user untuk sql server. Untuk membuat account user di SQL Server, buka folder Security dan klik kanan Login lalu pilih New Login

Pada dialog property pilih SQL Server user, artinya Anda membuat user di SQL Server yang terpisah dari account Windows. Masukkan nama user misalnya aspnetuser, lalu pilih default database yaitu ASPNET. Artinya user tersebut diberikan hak akses ke database ASPNET. Selain itu juga dimasukkan password untuk user tersebut.

Kemudian buka tab Database Access, dan tetapkan aspnetuser sebagai database owner untuk ASPNET. Karena user ini ditetapkan sebagai owner maka memilki hak penuh untuk merubah, membuat, dan menghapus obyek di dalam database ASPNET.

Setelah pembuatan user selesai maka jika Anda membuka database ASPNET dan masuk ke ikon user akan terlihat bahwa user aspnetuser tersebut telah menjadi anggota di dalam database ASPNET.

sumber :

http://www.itkomputer.com/

Tutorial Mikrotik VPN : EoIP

noreply@blogger.com (IT STUFF) — Mon, 21 Jul 2008 06:16:00 +0000

Ethernet over IP (EoIP) Tunneling is a MikroTik RouterOS protocol that creates an Ethernet tunnel between two routers on top of an IP connection. The EoIP interface appears as an Ethernet interface. When the bridging function of the router is enabled, all Ethernet level traffic (all Ethernet protocols) will be bridged just as if there where a physical Ethernet interface and cable between the two routers (with bridging enabled). This protocol makes multiple network schemes possible.

Network setups with EoIP interfaces:

* Possibility to bridge LANs over the Internet
* Possibility to bridge LANs over encrypted tunnels
* Possibility to bridge LANs over 802.11b 'ad-hoc' wireless networks

An EoIP interface should be configured on two routers that have the possibility for an IP level connection. The EoIP tunnel may run over an IPIP tunnel, a PPTP 128bit encrypted tunnel, a PPPoE connection, or any connection that transports IP.

Specific Properties:

* Each EoIP tunnel interface can connect with one remote router which has a corresponding interface configured with the same 'Tunnel ID'.
* The EoIP interface appears as an Ethernet interface under the interface list.

* This interface supports all features of and Ethernet interface. IP addresses and other tunnels may be run over the interface.
* The EoIP protocol encapsulates Ethernet frames in GRE (IP protocol number 47) packets (just like PPTP) and sends them to the remote side of the EoIP tunnel.
* Maximal count of EoIP tunnels is 65536.

This is how to set up EoIP to bridge two (or more) Mikrotik routers for central PPPoE authentication

Using 2 routers called R1 and R2 that have an IP connection between them and R2 has 2 ethernet ports, i.e. you can ping rB from R1 and R1 from R2 where the R1 facing eth port is called eth1 and its other port is called eth2.

1. create a new EoIP tunnel on R1.
2. create a new EoIP tunnel on R2, where the tunnel ID is the same as the one on R1 but the MAC addreses are different.
4. create a new bridge on R1 and R2
3. add a PPPoE server to the Bridge on R1.
4. on R2 and add eth2 and the EoIP tunnel to the bridge.
5. put an IP address onto eth2 (any address seems to work, but it maybe better to use a different subnet for routing purposes).

Now you should be able to establish a PPPoE connection from a PC plugged into the eth2 port on router R2, this PPPoE connection will terminate on router R1.

This is not the most efficient method of using the available bandwidth on a network, but is perhaps easier than having a PPPoE A/C on every Mikrotik router and using RADIUS as you can just have PPP secrets setup on one router.