Hackosis

PHP and MySQL are one of the most used technologies on the web today. By using about 7 different script files we can add, update, and delete rows from a MySQL table.

Example of completed project:

Download the Simple PHP MySQL Table Editor.

Lets get started. I will explain each section of the script files so you have an understanding of how it works. You can download the project in a zip file above. The download also includes the example MySQL schema structure so you can test the script right away.

All examples in this post assume that you have already typed the php opening and closing tags. I cannot inlcude them on my page due to Wordpress plugins that I am running.

ALSO, because my PHP color coder sometimes runs off the page, you may have to click “show plain code” to view all typed PHP code.

HEADER.PHP:

Header.php stores the HTML header that include the title, etc. I am not going into detail since this is not a HTML tutorial.

I always start my PHP files with comments to indicate the purpose of the script and give contact details in case anyone has questions. Comments in PHP are indicated with ‘//’ for single lines and ‘/*’, ‘*/’ for multiple line comments:
Read the rest of this entry …

Have you ever changed or forgotten your Windows password? Fear not because I have the solution for you – and its completely free.

The following method works on Windows XP and Vista.

All you need is a Linux live CD (that auto mounts Windows partitions – ex. Ubuntu, Backtrack, Fedora, openSUSE).

Save the .iso and burn it to a disc.

Boot from the CD and follow these simple instructions – these instructions are assuming your are using backtrack, but should be similar for other Linux distributions:

1. Open a Linux terminal and enter the following commands:
2. cd /mnt
3. ls (Take note of the folders listed here. You might need them in the next step.)
4. cd sda1/Windows/System32/ (If this didn’t work you might have the wrong hard drive, try replacing ’sda1′ with sda2, hda1, or hda2)
5. mv utilman.exe utilman.old && cp cmd.exe utilman.exe
6. reboot (and remove the CD)
7. Once rebooted, at Vista or XP log in screen, Press Windows key + U to run CMD with system privileges. Replace username below with the one of your choice – it must not already exist!
8. c:\>net user username mypassword /add
9. c:\>net localgroup administrators username /add
10. Log in with the new admin account!

After completing don’t forget to copy the utilman.old back to utilman.exe or you will leave your system vulnerable – this is very important!!

I hope this helped in regaining access into your XP or Vista PC and if you know of any other tips like this please let us know in the comments.

UPDATE: Here is a backtrack video tutorial that covers the instructions.

Nothing is better than a 3D game, but when you haven’t installed a GUI and have a quick need to play for a bit, here are 4 text based Linux games for CLI:

1. Bastet – Tetris clone:

Bastet ("bastard tetris") is an ncurses Tetris clone which is harder than every other tetris released. It is based on a heuristics engine which tries to detect which block you need or don’t need, and then gives you the blocks that you don’t need. For instance, if you usually play by leaving long "canyons" one square wide and then waiting for the long "I" block, you’ll have to wait till eternity before you see it. The heuristics have been worked on for some time and are quite nasty.

Install Bastet on Ubuntu:

2. Ninvaders – Space Invaders Clone:

nInvaders project is a Space Invaders clone for ncurses.

Ever wanted to play space invaders when you can’t find a GUI? Now you can!

Install Ninvaders on Ubuntu:

3. Moon-buggy – drive on the moon:

Moon-buggy is a simple character graphics game, where you drive some kind of car across the moon’s surface. Unfortunately there are dangerous craters there. Fortunately your car can jump over them!

Install Moon-buggy on Ubuntu:

4. Greed – a puzzle game:

The strategy game of Greed. Try to eat as much as possible of the board before munching yourself into a corner.

Install Greed on Ubuntu:

Hope you enjoy playing these simple, but fun Linux based CLI games. You can play any of these games by entering “/usr/games/xxxxx” with the Xs being the name of the game.

Do you know of any other fun CLI based games for Linux? Let us know in the comments. [via mellowd.co.uk]

Got to get this t-shirt:

Get your t-shirt here.

MySQL is an excellent open source database system. Replication is a great way to keep data redundant in case of a server crash. However, replication should not take the place of backups in case of data corruption or mis-entered data – as this data will also be replicated to the slave.

MySQL replication takes place in a master-slave configuration. Be aware that by using the configuration – only changes made on the master are replicated to the slave. Any changes on the slave will not be replicated to the master.

Following the steps below, you can have MySQL replication setup in no time at all.

Source: MySQL Dev Site
Read the rest of this entry …

Freenet is a relatively new P2P project in which members act similar to that of a cluster, donating hard drive space and bandwidth. It is similar to the Tor network in the fact that connections are encrypted and re-routed through other members of the network.

What’s different about Freenet is that you also dedicate parts of your hard drive for file storage. What is even more interesting is that you have no control over what is stored in your ‘data store’. Less popular files are deleted to make room for more popular files. The files are encrypted so that you ‘might’ not be held responsible for what lies within your data store.

Freenet is not only for storing files, but also allows you to create Freenet websites called ‘Freesites’. Also usenet, email, and more is possible on the Freenet.

Freenet is open source and runs anywhere Java runs. Windows, Linux, or Mac should work fine. After installing the interface is accessible through a web browser. Remember, Freenet is still in alpha stage so there may be some bugs.

Read more and download at the Free Network Project website.

Open source, cross platform Vidalia is a Tor GUI that runs on Windows, Linux, and Mac.

Simply put, Vidalia makes it really easy to setup, configure, turn on and off, and configure relays for the Tor network. Complete with bandwidth graphs and network maps, Vidalia should have everything you need to get started and stay on the Tor network.

After installing Vidalia, it is as simple as pointing your browser’s proxy setting to 127.0.0.1:8118 to start using the Tor network.

You can even choose which country to originate your connection from. Don’t get too frisky now. ;)

Vidalia Homepage | Vidalia Downloads | Vidalia Screenshots | Vidalia Support

Monitoring your website on a shared host is vital to the well being of your existence on the internet. There are several online services that will do this for you in exchange for a small price. While they may be a bit more accurate, I would like to share with you how to use RRDTool to monitor your website’s response time yourself.

image via rrdwiki (didn’t use mine because it hasn’t completed a full cycle yet.)

NOTE: I am using Ubuntu based Linux Mint. This process should be the same on other Debian based distributions. If you are not running a Debian based distribution, you may have to modify some paths to the rrdtool executable. Some of this procedure has been taken from the rrdwiki.

The first step is to install RRDTool:

sudo apt-get install rrdtool

Read the rest of this entry …

pdftk is an open source, cross platform PDF super manipulator. This goody allows you to split, merge, rotate, decrypt, encrypt, watermark, change metadata, attach files, detach files, repair, and more.

From the site:

“If PDF is electronic paper, then pdftk is an electronic staple-remover, hole-punch, binder, secret-decoder-ring, and X-Ray-glasses. Pdftk is a simple tool for doing everyday things with PDF documents.”

pdftk is command line only, so you might want to check out the examples for syntax. If you aren’t into command line, there are some GUIs available.

Get the full scoop along with package installers at the pdftk site.

Dear Vyatta,

During the past couple of months I have been attempting to replace my Cisco 7500 with your routing software. The Vyatta product looked very promising and supported all the protocols and features that I needed including BGP, Bandwidth Management (through the kernel), VRRP, in addition to standard routing with TCP/IP.

I have run into many issues with the Vyatta software. Just to name a few — VRRP limitations, BGP Routing Policy limitations, static routing bugs, not being able to delete static routes and policy configurations, and more.

I am sad to say, good bye Vyatta. I have enjoyed the past two months getting to know you. You have what seems a wonderful team of individuals working towards the better. I would like to send a thanks to the support group and everyone on the mailing list, they were wonderful.

I will continue to support what the Vyatta team is trying to do. Unfortunately, the software is still premature. I, however, am looking forward to the next release so I can give it another try.

I am sure I could force the software to work, but I would hardly be confident with that procedure. That being said — Vyatta cannot replace my Cisco 7500 core router.

Farewell,

Shane