Ishkur

[Ruby] On brute-force password cracker

2008-10-11T02:36:31-07:00

Hmmm, I certainly can't speak for everyone here (nor do I care to, for that matter), but um... wtfm8?

I just don't see that as the greatest idea. And also, why Ruby?

[Java] On Java IRC Bot

2008-09-14T00:19:11-07:00

I decided to refactor it myself and ended up recoding it. I took a slightly different approach this second time. I created a class for the Bot and its functions, and then implemented it in the Main class and controlled the Bot functionality with Regex.

## Main.java 
package ircbot;

/**
 * JavaBot (version 1.2)
 * 
 * MIT License, dydx (Josh Sandlin) <dydx@thenullbyte.org>
 *   
 */

import java.io.*;
import java.net.*;
import java.util.regex.*;
import java.util.Date;
import java.util.Random;

public class Main
{   
    public static void main( String[] args ) throws IOException
    {
        //connection variables
        String server = args[0]; //irc.snappeh.com
        String nick = args[1]; //JavaBot
        String address = "thenullbyte.org";
        String channel = "#"+args[2]; //#enigmagroup
        int port = 6667;
        
        //for security
        String owner = "dydx";
        
        try {
            
            //our socket we're connected with
            Socket irc = new Socket( server, port );
            //out output stream
            BufferedWriter bw = new BufferedWriter( new OutputStreamWriter( irc.getOutputStream() ) );
            //our input stream
            BufferedReader br = new BufferedReader( new InputStreamReader( irc.getInputStream() ) );
            
            //create a new instance of the JavaBot
            Bot JavaBot = new Bot( bw, channel);
            
            //authenticate the JavaBot with the server
            JavaBot.login( nick, address );
            
            String currLine = null;
            while( ( currLine = br.readLine() ) != null )
            {
                
                //compile a regex to check and see if the person calling commands is the owner
                Pattern checkOwner = Pattern.compile( "^:"+owner, Pattern.CASE_INSENSITIVE );
                Matcher ownership = checkOwner.matcher( currLine );
                
                //constantly check for PING's, if the bot sees one, it replies with a PONG
                Pattern pingRegex = Pattern.compile( "^PING", Pattern.CASE_INSENSITIVE );
                Matcher ping = pingRegex.matcher( currLine );
                if( ping.find() )
                {
                    JavaBot.pong();
                }
                
                //check to see if the owner has given the !exit command
                Pattern exitRegex = Pattern.compile( "!exit", Pattern.CASE_INSENSITIVE );
                Matcher exit = exitRegex.matcher( currLine );
                if( exit.find() && ownership.find() )
                {
                    JavaBot.say( "I'm tired, bye yall" );
                    JavaBot.quit();
                }
                
                //parts one room and joins another, gives a nice little going away speech as well
                Pattern joinRegex = Pattern.compile( "!join", Pattern.CASE_INSENSITIVE );
                Matcher join = joinRegex.matcher( currLine );
                if( join.find() && ownership.find() )
                {
                    String[] token = currLine.split( " " );
                    JavaBot.say( "I'm going to go over to " + token[4] + " and see what they're up to over there. Cya." );
                    JavaBot.part();
                    channel = token[4];
                    JavaBot.join( channel );
                    JavaBot.say( "Hey guys!" );
                }
                
                //we should be polite every now and then, this introduces the bot
                Pattern sayhiRegex = Pattern.compile( "!sayhi", Pattern.CASE_INSENSITIVE );
                Matcher sayhi = sayhiRegex.matcher( currLine );
                if( sayhi.find() && ownership.find() )
                {
                    JavaBot.say( "Hi, I'm a JavaBot. I was written by dydx in Java!" );
                }
                
                //more or less a PoC, just returns the current date/time to the IRC channel
                Pattern timeRegex = Pattern.compile( "!time", Pattern.CASE_INSENSITIVE );
                Matcher time = timeRegex.matcher( currLine );
                if( time.find() )
                {
                    Date d = new Date();
                    String message = "The date is " + d ;
                    JavaBot.say( message );
                }
            }
        } catch ( UnknownHostException e ) {
            System.err.println( "No such host" );
        } catch ( IOException e ) {
            System.err.println( "There was an error connecting to the host" );
        } 
    }
}

## Bot.Java
package ircbot;

import java.io.*;

/**
 * The skeleton of the IRC Bot. 
 * 
 * @author dydx
 */
public class Bot
{
    BufferedWriter bw;
    String channel;
    
    /**
     * Bot class constructor, set the defaults for the output stream and the channel
     * @param writer
     * @param chan
     * @param own
     */
    Bot( BufferedWriter writer, String chan )
    {
        bw = writer;
        channel = chan;
    }
    
    /**
     * This is the main part of the bot, it replies to PING's
     * @throws java.io.IOException
     */
    public void pong() throws IOException
    {
        bw.write( "PONG " + channel + "\n" );
        bw.flush();
    }
    
    /**
     * General purpose method for inputting into the channel at hand
     * @param message
     * @throws java.io.IOException
     */
    public void say( String message ) throws IOException
    {
        bw.write( "PRIVMSG " + channel + " :" + message + "\n" );
        bw.flush();
    }
    
    /**
     * Joins a specified IRC channel and sets this.channel accordingly
     * @param channel
     * @throws java.io.IOException
     */
    public void join( String chan ) throws IOException
    {
        bw.write( "JOIN " + chan + "\n" );
        bw.flush();
        
        //we're doing this so that there's no confusion
        //as to which channel the bot is in
        channel = chan;
    }
    
    /**
     * Leave the curent channel
     * @throws java.io.IOException
     */
    public void part() throws IOException
    {
        bw.write( "PART " + channel + "\n" );
        bw.flush();
    }
    
    /**
     * Quit the current IRC session
     * @param reason
     * @throws java.io.IOException
     */
    public void quit() throws IOException
    {
        bw.write( "QUIT " + channel + "\n" );
        bw.flush();
    }
    
    /**
     * Class method used to authenticate the Bot with the IRC server
     * @param nick
     * @param address
     * @throws java.io.IOException
     */
    public void login( String nick, String address ) throws IOException
    {
        bw.write( "NICK " + nick + "\n" );
        bw.write( "USER " + nick + " " + address + ": Java Bot\n" );
        bw.flush();
        
        bw.write( "JOIN " + channel + "\n" );
        bw.flush();
    }
    
    /**
     * General method for yelling at users, might not need to use it after all
     * @param message
     * @throws java.io.IOException
     */
    public void yell( String message ) throws IOException
    {
        say( message );
    }
    
    /**
     * Will eventually be used to search for crap on Wikipedia
     * @throws java.io.IOException
     */
    public void wiki() throws IOException
    {
        say( "Sorry folks, but that feature isn't working just yet." );
    }
}

[Java] Java IRC Bot

2008-09-13T06:04:15-07:00

I've been working on this for a few days, and I finally have it to where it actually works like I want it to. I'm new to Java, so I know this isn't the best way I could have coded it, and I'm curious to see how anyone would improve upon it.

package ircbot;

/**
 * JavaBot (version 1.2)
 * 
 * MIT License, dydx (Josh Sandlin) <dydx@thenullbyte.org>
 *  
 */

import java.io.*;
import java.net.*;
import java.util.regex.*;
import java.util.Date;

public class Main
{   
    public static void main( String[] args ) throws IOException
    {
        //connection variables
        String server = "irc.snappeh.com";
        String nick = "JavaBot";
        String login = "JavaBot";
        String channel = "#bots";
        int port = 6667;
        
        //for security
        String owner = "dydx";
        
        try {
            
            //our socket we're connected with
            Socket irc = new Socket( server, port );
            //out output stream
            BufferedWriter bw = new BufferedWriter( new OutputStreamWriter( irc.getOutputStream() ) );
            //our input stream
            BufferedReader br = new BufferedReader( new InputStreamReader( irc.getInputStream() ) );
            
            //authenticate with the server
            bw.write( "NICK " + nick + "\n" );
            bw.write( "USER " + login + " thenullbyte.org JB: Java Bot\n" );
            bw.flush();
            
            //join a channel
            bw.write( "JOIN " + channel + "\n" );
            bw.write( "PRIVMSG " + channel + " :Whats up everybody?\n" );
            bw.flush();
            System.out.println( "Successfully connected to IRC" );
            
            String currLine = null;
            while( ( currLine = br.readLine() ) != null )
            {
                //checks for PING, if one is found; return a PONG
                Pattern pingRegex = Pattern.compile( "^PING", Pattern.CASE_INSENSITIVE ); 
                Matcher ping = pingRegex.matcher( currLine );
                if( ping.find() )
                {
                    bw.write( "PONG " + channel + "\n" );
                    bw.flush();
                }
                
                
                //check for ownership
                Pattern checkOwner = Pattern.compile( "^:"+owner, Pattern.CASE_INSENSITIVE );
                Matcher ownership = checkOwner.matcher( currLine );
                
                //!exit - quit current irc room
                Pattern exitRegex = Pattern.compile( "!exit", Pattern.CASE_INSENSITIVE );
                Matcher exit = exitRegex.matcher( currLine );
                if( exit.find() && ownership.find() )
                {
                    bw.write( "PRIVMSG " + channel + " :Bye Bye\n" );
                    bw.write( "PART " + channel + "\n" );
                    bw.flush();
                    irc.close();
                }
                
                //!time - return current time
                Pattern timeRegex = Pattern.compile( "!time", Pattern.CASE_INSENSITIVE );
                Matcher time = timeRegex.matcher( currLine );
                if( time.find()  && ownership.find() )
                {
                    Date d = new Date();
                    bw.write( "PRIVMSG " + channel + " :" + d +"\n" );
                    bw.flush();
                }
                
                //!sayhi - shows a little message saying hello
                Pattern helloRegex = Pattern.compile( "!sayhi", Pattern.CASE_INSENSITIVE );
                Matcher hello = helloRegex.matcher( currLine );
                if( hello.find()  && ownership.find() )
                {
                    bw.write( "PRIVMSG " + channel + " :Hello, I'm a JavaBot. I was coded by dydx in Java!\n");
                    bw.flush();
                }
                
                //!join <room> - changes to a new room and sets the variables accordingly
                Pattern joinRegex = Pattern.compile( "!join", Pattern.CASE_INSENSITIVE );
                Matcher join = joinRegex.matcher( currLine );
                if( join.find()  && ownership.find() )
                {
                    String[] token = currLine.split( " " );
                    bw.write( "PRIVMSG " + channel + " :Im going over to " + token[4] + "\n" );
                    bw.write( "PART " + channel + "\n" );
                    channel = token[4];
                    bw.write( "JOIN " + channel + "\n" );
                    bw.flush();
                }
            }
        } catch ( UnknownHostException e ) {
            System.err.println( "No such host" );
        } catch ( IOException e ) {
            System.err.println( "There was an error connecting to the host" );
        } 
    }
}

[Java] Processing / Java

2008-09-11T04:07:46-07:00

I'm trying to move out of Processing's PDE and into a more standard IDE (NetBeans). So far everything has gone fairly well. Importing the core.jar is about all it takes to get going with Processing in a normal Java environment. My issue lies with a if...else in my draw() method.

What my script does is plot an ellipse along an increasing orbit. Depending on what you set as the orbit gain, the speed, and if you have acceleration, it can turn out at somewhat interesting.

I tried to add coloration to the script.
if( diameter == 5 ) fill( green );
if( diameter == 10) fill( pink );
etc.

In the PDE this type of thing works fine, but for some reason regular old Java doesnt like this. I don't get any errors, I just dont get anything at all. If I could see how the PDE interprets what I put in there, then I might be able to figure out what I'm doing wrong... but until I can figure that out, does anyone have any ideas?

package spirals;
import processing.core.*;

public class Main extends PApplet
{
    float x;
    float y;
    int i = 1;
    int dia = 1;
    
    float angle = 0.0f;
    float speed = 0.05f;
    float orbit = 0f;
    
    //color palette
    int gray = 0x0444444;
    int blue = 0x07cb5f7;
    int pink = 0x0f77cb5;
    int green = 0x0b5f77c;
    
    public Main(){}
    
    public static void main( String[] args )
    {
        PApplet.main( new String[] { "spirals.Main" } );
    }
    
    public void setup()
    {
        background( gray );
        size( 400, 400 );
        fill( gray );
        stroke( gray );
        strokeWeight( 4 );
        smooth();
    }
    
    public void draw()
    {   
        //take the mod of i and decide what to
        //set as the fill color
        if( i % 11 == 0 )
            fill( green );
        else if( i % 13 == 0 )
            fill( blue );
        else if( i % 15 == 0 )
            fill( pink );
        else if( i % 17 == 0 )
            fill( gray );
        
        orbit += 0.1f; //ever so slightly increase the orbit
        //speed += 0.00001f; acceleration
        angle += speed % ( width * height );
        
        float sinval = sin( angle );
        float cosval = cos( angle );
        
        //calculate the (x, y) to produce an orbit
        x = ( width / 2 ) + ( cosval * orbit );
        y = ( height / 2 ) + ( sinval * orbit );
        
        dia %= 11; //keep the diameter within bounds.
        ellipse( x, y, dia, dia );
        dia++;
        i++;
    }
}

[PHP] On model loader

2008-08-24T04:01:00-07:00

Very interesting ways of going about this, but I think I like the __autoload() approach a little more. I removed the loop (only because I have but one path I want to specify), but other than that it seems to work perfectly.

The problem with the other methods is that they mess up the inheritance of the model. getAll() is extended from a parent controller, and so when you simple 'return new $model();', it interferes with that for some reason, but the __autoload() seems to keep my inheritance in tact.

But still, thanks everyone!

[PHP] On model loader

2008-08-22T20:07:44-07:00

Wow, that refactoring is nifty. I have PHP 5.2.4 at the moment, and I'm working on installing 5.3. Hopefully I'll get something put together soon. Thanks a million for the input.

[PHP] model loader

2008-08-21T14:16:51-07:00

I'm doing a lot of work with BareBonesMVC lately, and I've begun to see a need to add some more meat to it. One of the thing's that I'm trying to add is a method for loading models. The method itself is fairly straight forward, and works, but not the way I would really like for it to.

## code
<?php
function loadModel($model)
{
	$exclude = array (
		'.',
		'..',
		'index.html'
	);
	
	$handle = opendir(APPPATH.'models/');
	while(false !== ($files = readdir($handle)))
	{
		if(!in_array($file, $exclude))
			$modelArray[] = $files;
	}
	closedir($handle);
	
	if(in_array($model.EXT, $modelArray))
	{
		require_once(APPPATH.'models/'.$model.EXT);
	} else {
		throw new Exception('Attempting to call unknown Model');
	}
}
?>
## usage
<?php
//...
loadModel('blog');//Load blog model
$posts = blog_model::getRecent;
//...
?>
## what  I really want to be able to do
<?php

	//...
	$blogObject = loadModel('blog'); //assign object to a variable
	$posts = $blogObject::getRecent();
	//...

?>
## sidenotes [plain_text]
So far i've managed to get errors about my use of extraneous double colons,
so im betting that php doesnt let me call methods statically like that. Any
thoughts would be helpful.

[PHP] On Universal File Download Class

2008-08-19T18:41:04-07:00

In your function 'public function cc_wget_file($url)', you're passing the string through exec(). Thats fine, but PHP allows you to pass cli strings via backticks (http://www.php.net/language.operators.execution). Might help, might not, ymmv.

[PHP] On Getter and Setter

2008-08-14T14:54:26-07:00

Note: the above refactoring doesnt seem to really work, but it does outline an *example* of how to use PHP5's magic methods __set() and __get().

[PHP] On MySQL original PHP 5 wrapper class

2008-08-05T05:39:01-07:00

I've taken to liking your database wrapper, a lot. Among a few minor tweaks, I've added a method to it that you might (or might not) like, check this out:

## getWhere() method [php]
<?php
	/**
	 * $page = page::getWhere(array('PageID' => 125));
	 */
	protected static function getWhere($class, $table, $where = array())
	{
		if(!self::$dbconnected)
			self::connect();
		$etu = array();
		//process WHERE statement
		$txt_query = 'SELECT * FROM '.$table;
		$i = 0;
		foreach($where as $key => $value)
		{
			if($i == 0)
				$txt_query .= ' WHERE ';
			else
				$txt_query .= ' AND ';
				
			$txt_value = self::quote_smart($value);
			if(is_numeric($value))
				$txt_query .= "$key = $value";
			elseif(is_null($value))
				$txt_query .= "$key = NULL";
			else
				$txt_query .= "$key = '$txt_value'";
			$i++;
		}
		
		$txt_query .= ';';
		if(($result = @mysql_query($txt_query)) === false)
			throw new Exception('Impossible to retrieve desired items of '.$table);
		while($d = @mysql_fetch_object($result))
		{
			$e = new $class;
			foreach(get_object_vars($d) as $var => $value)
				$e->$var = $value;
			//this returns an array, which makes us have to foreach the return.
			//might want to make some sort of checking to see if the result
			//is more than 1 row it returns an array, and if only just 1 row returns,
			//it sets it as a singular object (such as if you were selecting pages
			//from a database with like Categories, you'd need an array to loop through,
			//but if you were selecting a single user, that loop would be an unnecessary 
			//hassle)... something to work on later i guess
			$etu[] = $e;
		}
		return $etu;
	}
?>

## child class usage [php]
<?php

	public static function getWhere($where)
	{
		return parent::getWhere(__CLASS__, self::$_table, $where);
	}

?>

## Final Usage [php]
<?php

//include required files
require_once('inc/classes/db.class.php');
require_once('inc/models/page.class.php');

//some generic scenario where
//you would needa WHERE clause
$login = array(
	'username' => "$_POST['username']",
	'password' => "$_POST['password']"
);

//fetch user records from database
$user = user::getWhere($login);

//...
//process login	
//...

?>

[PHP] On MySQL original PHP 5 wrapper class

2008-08-02T19:14:22-07:00

Can you elaborate some more as to why you dont? do you run a custom error handling mechanism, or do you just not handle extraneous errors ?

[PHP] On MySQL original PHP 5 wrapper class

2008-08-02T03:04:08-07:00

There seem to be a lot of these ideas floating around (myself included), and maybe its just me seeing the light (or lackthereof), but I've started using CoughPHP ORM. But your methods looks rather interesting.

And as for your disconnect();

<?php

	//...
	/**
	 * this refactoring might be asinine,
	 * but I think it's important to cover
	 * your ass just in case. 
	 */
	public static function disconnect()
	{
		if(self::$db_link === false)
			throw new Exception('no connection present');
		@mysql_close(self::$db_link);	
	}
	//...

?>

[PHP] On Object with Field names as resources

2008-07-31T06:45:21-07:00

Going with that the previous guy mentioned, I look around at ORM solutions that would fit the bill. Just about everything I could find was entirely oversized and just added so much overhead it was terrifying. So i looked for a more lightweight solution and found some rather good software (http://coughphp.com/). CoughPHP seems to do what I want decently, so I'm going to see where that gets me.

[PHP] On Object with Field names as resources

2008-07-28T20:16:02-07:00

Sorry, I mixed up my terms. I am trying to map over to an object.

Below is sort of getting me closer, to where I was aiming at.

And Prengel, I'll look at that. Thank you.

<?php

class ParentClass
{
	protected $database;
	protected $tables;
	//...
	
	public function __construct($table)
	{
		//get an instance of my own database class
		//and use it in this one.
		$this->database = DB::GetInstance();
		
		//set table name to query
		$this->table = $table;
	}
	
	//...
	//some magic
	//...
}

class User extends ParentClass
{
	public function __construct()
	{
		parent::__construct('users');
	}
}

$bob = new User();
$bob->username = 'bob';
//...
//insert new row with whatever specs
//i defined with $bob->[var] = [val].
$bob->create();

?>

[PHP] Object with Field names as resources

2008-07-28T19:35:54-07:00

What I am trying to do is a little hard to explain, but basically I want to map database fieldnames to an object, corresponding to table name.

So `users` would be used in a class called Users, etc.

I've managed to query the database and stick the fieldnames into an associative array with the code below, but how I'm going to create the object is slightly above me right now.

As of now I have a parent class that im trying to get to handle the querying of field names, and im extending it to create the different classes.

## Table [plain_text]
+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| user_id  | int(11)     | NO   | PRI | NULL    | auto_increment | 
| username | varchar(20) | YES  |     | NULL    |                | 
| password | varchar(32) | YES  |     | NULL    |                | 
| email    | varchar(50) | YES  |     | NULL    |                | 
+----------+-------------+------+-----+---------+----------------+

## Query [php]
<?php

	$db = mysql_connect('localhost', 'root', 'rootpass');
	mysql_select_db('dname', $db);	
	
	$query = "SHOW COLUMNS FROM users;";
	$result = mysql_query($query, $db);
	while($row = mysql_fetch_assoc($result))
	{
		$fields[] = $row['Field'];
	}
	var_dump($fields);

?>

## Result Array [plain_text]
array(4) {
  [0]=>
  string(7) "user_id"
  [1]=>
  string(8) "username"
  [2]=>
  string(8) "password"
  [3]=>
  string(5) "email"
}

## Overall Goal [php]
//dynamically made class
class user {
	public $user_id;
	public $username;
	public $password;
	public $email;
}

[PHP] On PHP5 Database Clas

2008-07-22T03:36:44-07:00

Well if I wanted to go that route I could just as well use PDO and be done with the whole class, but thats not really what I want. And to be completely honest I dont really like Pear, it just feels like there's so much overhead. I just sorta wanted the transactional functions to work.... the child methods themselves work, thats not an issue, but the constructor method is whats killing me.

[PHP] PHP5 Database Clas

2008-07-21T16:33:50-07:00

For the most part, this class does everything I need. I've been updating it to PHP5, and have noticed a really rather big issue with my Transaction support: it simple doesnt work.

I've explained the issue in comments in the code.

<?php

class DB {
	
	//connection variables
	protected $dbhost = 'localhost';
	protected $dbuser = 'root';
	protected $dbpass = '';
	protected $dbname = 'dbname';
	
	//normal global resources
	protected $db = null;
	protected static $instance = null;
	
	/**
	 * Singleton pattern for instantiating the DB class
	 */
	public static function GetInstance()
	{
		if(!self::$instance)
		{
			self::$instance = new DB;
		}
		return self::$instance;
	}
	
	protected function __construct()
	{
		if(($db = @mysql_connect($this->dbhost, $this->dbuser, $this->dbpass)) === false)
		{
			trigger_error('There was an error connecting to the server.');
			exit;
		}
		
		if((@mysql_select_db($this->dbname, $db)) === false)
		{
			trigger_error('There was an error selecting the database.');
			exit;
		}
		$this->db = $db;
	}
	
	/**
	 * simple method for sanitizing SQL query strings.
	 */
	public function Clean($string)
	{
		if(get_magic_quotes_gpc())
		{
			$string = stripslashes($string);
		}
		return mysql_real_escape_string($string);
	}
	
	/**
	 * DB class method call to the Query child class.
	 * SELECT queries only
	 * Returns an object.
	 */
	public function Query($statement)
	{
		return new Query($statement, $this->db);
	}
	
	/**
	 * DB class method call to the Execute child class.
	 * INSERT/UPDATE/DELETE queries only
	 * Returns number of rows affected.
	 */
	public function Execute($statement)
	{
		return new Execute($statement, $this->db);
	}
	
	/**
	 * Used to get the last inserted record
	 */
	public function InsertID()
	{
		return mysql_insert_id($this->link);
	}
	
	/**
	 * The transactional functions are giving me more of a headache than
	 * I sould care to have. The general idea behind what I want to do
	 * with them is be able to pass an array of SQL queries into one
	 * main method call, which in turn calls its child methods.
	 *
	 * The issue I have with this is that there are instances where I
	 * dont want to base a Commit / Rollback on whether or not the
	 * queries succeed or fail, but perhaps the time of day, or the
	 * privelage level of the user running the queries, etc.
	 */
	public function Transaction($queryArray)
	{
		/**
		 * this method call will return a new instance of the
		 * Transaction CLass. Operations are documented within
		 * the Transaction Class.
		 */
		 return new Transaction($queryArray, $this->db);
	}
	
	public function __destruct()
	{
		@mysql_close($this->db);
	}
	
}

/**
 * These are separate classes for the reason that I would like
 * to be able to edit them with as little distruption to the 
 * flow of the parent class as possible. 
 */

/**
 * Query child class. Used for running SELECT queries.
 * Called exclusively by the DB parent class in the Query method
 */
class Query
{
	protected $result;
	
	public function __construct($statement, $link)
	{
		if(($this->result = mysql_query($statement, $link)) === false)
		{
			trigger_error('There was an error in processing the Query method: '. mysql_error());
			exit;
		}
	}
	
	public function Fetch($class = null)
	{
		return @mysql_fetch_object($this->result);
	}
	
	public function __destruct()
	{
		@mysql_free_result($this->result);
	}
}

/**
 * Execute child class. Used for running INSERT/UPDATE/DELETE queries.
 * Called exclusively by the DB parent class in the Execute method
 */
class Execute
{
	public function __construct($statement, $link)
	{
		if((@mysql_query($statement, $link)) == false)
		{
			trigger_error('There was an error processing the Execute method: '. mysql_error());
			exit;
		}
		return @mysql_affected_rows($link);
	}
}

/**
 * Transaction child class. Used for transactional queries.
 * Called exclusively by the DB parent class in the Transaction method
 */
class Transaction
{
	public function __construct($queryArray, $link)
	{
		/**
		 * This is not working at all the way I want it to.
		 * 
		 * Essentially what it is doing, is running the first
		 * query, then basing the Commit / Rollback on the
		 * outcome of that single query. That's no good.
		 *
		 * I can see _why_ its not working, but that doesn't
		 * really help me to fix it. 
		 *
		 * $hold is set to 1 as its starting value, and as
		 * the loop progresses it either changes that or 
		 * doesnt, depending on the outcome. What it seems
		 * to be doing is running it once, and deciding
		 * "Hey! the query worked!, lets commit changes!".
		 */
		$hold = 1;
		$this->Begin();
		foreach($queryArray as $query) {
			@mysql_query($query, $link);
			if(@mysql_affected_rows($link) == 0)
			{
				$hold = 0;
			}
		}
		if($hold == 0)
		{
			$this->Rollback();
			return false;
		} else {
			$this->Commit();
			return true;
		}
	}
	
	private function Begin()
	{
		@mysql_query('BEGIN', $link);
	}
	
	private function Commit()
	{
		@mysql_query('COMMIT', $link);
	}
	
	private function Rollback()
	{
		@mysql_query('ROLLBACK', $link);
	}
}

?>

[PHP] On Database Class

2008-07-11T00:46:54-07:00

I've got a sourceforge project dealing with this same sort of thing. And from my experience in coding that I might be able to offer a few tips on how to make it better.

1.)Since you're clearly using PHP5 for this, why not go ahead and add access control to the global vars and methods. You dont want just anyone to be able to call out your data anywhere they want. you need a defined entry point and a defined access point.

2.) going along with that PHP5 thing I was talking about, you can also use the __construct() method to define some of your global vars like the username, the password, the host, and the database name. Doing that will save you a lot of coding work and processing time later.

3.) A lot of your global vars dont look like they need to be initiated as a global var. try to make them as narrow in scope as possible.

4.) and just a little (and by little, i mean little) advice on making your loops faster. ++$i is faster than $i++.

For reference on another way of going about this task, you can look at my DB class: http://jsandlin.org/null_dbw/source.php

[PHP] On Interfacing Tor with cURL

2008-06-29T02:03:14-07:00

Well, what I was going for was being able to set parameters and being able to call them back out later. But thanks, I wasn't aware of that naming convention clash i was doing. I did plan however, on setting some of these methods to be private because a few of them aren't really meant to be set by hand.

EDIT: I took Joe's advice and redid my code accordingly. I fixed my naming conventions as well as condensed all of my 'get''s into a single method returning an array.

I also moved all of the cURL into its own method, and I've updated the status of most of the methods and set them to private.

I have not however, had a chance to test it; though it should work just as before.

I think that it a little better, but im sure more can be done.

<?php

/**
 * PHP5 class for interfacing with the Tor network
 * by Josh Sandlin <josh@thenullbyte.org>
 * 
 * Licensed: MIT/X11
 * 
 * NOTE: The proxy host is configurable by the user, 
 * so therefore one i not limited to only the Tor
 * network. The default setting however is to run
 * all data through the Tor/Privoxy network.
 * 
 */

class Tor
{
    private $url;
    private $userAgent;
    private $timeout;
    private $proxy;
    private $vector;
    private $payload;
    private $returnData;

    public function Tor()
    {
        $this->url = null;
        $this->userAgent = null;
        $this->timeout = 300;
        $this->proxy = '127.0.0.1:9050';
        $this->vector = null;
        $this->payload = null;
        $this->returnData = null;
    }

    private function setUrl($url)
    {
        $this->url = $url;
    }

    private function setUserAgent()
    {
        //list of browsers
        $agentBrowser = array(
                'Firefox',
                'Safari',
                'Opera',
                'Flock',
                'Internet Explorer',
                'Seamonkey',
                'Konqueror',
                'GoogleBot'
        );
        //list of operating systems
        $agentOS = array(
                'Windows 3.1',
                'Windows 95',
                'Windows 98',
                'Windows 2000',
                'Windows NT',
                'Windows XP',
                'Windows Vista',
                'Redhat Linux',
                'Ubuntu',
                'Fedora',
                'AmigaOS',
                'OS 10.5'
        );
        //randomly generate UserAgent
        $this->userAgent = $agentBrowser[rand(0,7)].'/'.rand(1,8).'.'.rand(0,9).' (' .$agentOS[rand(0,11)].' '.rand(1,7).'.'.rand(0,9).'; en-US;)';
    }

    private function setTimeout($timeout)
    {
        $this->timeout = $timeout;
    }

    public function setProxy($ip, $port)
    {
        $this->proxy = $ip .":". $port;
    }

    private function setVector($vector)
    {
        $this->vector = $vector;
    }

    private function setCurl()
    {
        $action = curl_init();
        curl_setopt($action, CURLOPT_PROXY, $this->proxy);
        curl_setopt($action, CURLOPT_URL, $this->payload);
        curl_setopt($action, CURLOPT_HEADER, 1);
        curl_setopt($action, CURLOPT_USERAGENT, $this->userAgent);
        curl_setopt($action, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($action, CURLOPT_FOLLOLOCATION, 1);
        curl_setopt($action, CURLOPT_TIMEOUT, $this->timeout);
        $this->returnData = curl_exec($action);
        curl_close($action);
    }
    
    private function setPayload()
    {
        $this->payload = $this->url . $this->vector;
    }

    public function launch($url, $vector, $timeout = null)
    {
        //set parameters
        $this->setUrl($url);
        $this->setVector($vector);
        $this->setUserAgent();
            
        //set payload
        $this->setPayload();
            
        //if a timeout is set in the args, use it
        if(isset($timeout))
        {
            $this->setTimeout($timeout);
        }
            
        //run cURL action against url
        $this->setCurl();
    }

    public function getTorData()
    {
        return array(
                'url' => $this->url,
                'userAgent' => $this->userAgent,
                'timeout' => $this->timeout,
                'proxy' => $this->proxy,
                'payload' => $this->payload,
                'return' => $this->returnData
        );
    }
}

?>

[PHP] Interfacing Tor with cURL

2008-06-28T20:29:39-07:00

I found a php function that does this, but I didnt like it. So, I recoded it as a class. I'm rather new to classes and OOP, so I'm sure there's a better way I could have gone about this. Any ideas on making my code more efficient will be appreciated.

<?php

/**
 * PHP Class for interfacing with the Tor Network
 */

class Tor
{
	var $url;
	var $userAgent;
	var $timeout;
	var $host;
	var $vector;
	var $payload;
	var $returnData;

	/**
	 * Tor Clas Constructor
	 */
	function Tor()
	{
		$this->url = null;
		$this->userAgent = null;
		$this->timeout = 300;
		$this->host = '127.0.0.1:9050';
		$this->vector = null;
	}

	/**
	 * set url
	 */
	function setUrl($url)
	{
		$this->url = $url;
	}

	/**
	 * read url
	 */
	function readUrl()
	{
		return $this->url;
	}

	/**
	 * set useragent
	 */
	function setUserAgent()
	{
		//list of browsers
		$agentBrowser = array(
				'Firefox',
				'Safari',
				'Opera',
				'Flock',
				'Internet Explorer',
				'Seamonkey',
				'Konqueror',
				'GoogleBot'
				);
				//list of operating systems
				$agentOS = array(
				'Windows 3.1',
				'Windows 95',
				'Windows 98',
				'Windows 2000',
				'Windows NT',
				'Windows XP',
				'Windows Vista',
				'Redhat Linux',
				'Ubuntu',
				'Fedora',
				'AmigaOS',
				'OS 10.5'
				);
				//randomly generate UserAgent
				$this->userAgent = $agentBrowser[rand(0,7)].'/'.rand(1,8).'.'.rand(0,9).' (' .$agentOS[rand(0,11)].' '.rand(1,7).'.'.rand(0,9).'; en-US;)';
	}

	/**
	 * read useragent
	 */
	function readUserAgent()
	{
		return $this->userAgent;
	}

	/**
	 * set timeout
	 */
	function setTimeout($timeout)
	{
		$this->timeout = $timeout;
	}

	/**
	 * read timeout
	 */
	function readTimeout()
	{
		return $this->timeout;
	}

	/**
	 * set host
	 */
	function setHost($ip, $port)
	{
		$this->host = $ip . ":" . $port;
	}

	/**
	 * read host
	 */
	function readHost()
	{
		return $this->host;
	}

	/**
	 * set vector
	 */
	function setVector($vector)
	{
		$this->vector = $vector;
	}

	/**
	 * read vector
	 */
	function readVector()
	{
		return $this->vector;
	}

	/**
	 * launch payload
	 */
	function launchPayload()
	{
		//set randomized parameters
		$this->setUserAgent();
			
		//concatinate url
		$this->payload = $this->url . $this->vector;
			
		//run curl action against url
		$action = curl_init();
		curl_setopt($action, CURLOPT_PROXY, $this->host);
		curl_setopt($action, CURLOPT_URL, $this->payload);
		curl_setopt($action, CURLOPT_HEADER, 1);
		curl_setopt($action, CURLOPT_USERAGENT, $this->userAgent);
		curl_setopt($action, CURLOPT_RETURNTRANSFER, 1);
		curl_setopt($action, CURLOPT_FOLLOWLOCATION, 1);
		curl_setopt($action, CURLOPT_TIMEOUT, $this->timeout);
		$this->returnData = curl_exec($action);
		curl_close($action);
	}

	function viewReturn()
	{
		return $this->returnData;
	}
}

?>