Archive

Archive for August, 2010

Mass-op plugin for Colloquy

August 29th, 2010 Richard Pistole 2 comments

There’s no massop command in Colloquy, so here’s a javascript plugin that does it.

Copy/paste the following as whatever.js in your ~/Application Support/Colloquy/PlugIns/ directory:

function opNick(nick, connection, view)
{
	connection.sendRawMessage("MODE " + view.target() + " +o " + nick);
}
 
function massOp(connection, view)
{
	var members = view.chatMembers();
	var len = members.length;
 
	for (var i = 0; i < len; i++)
	{
		if (!members[i].operator())
		{
			opNick(members[i].nickname(), connection, view);
		}
	}
	return false;
 
}
 
// process the command and return true if you handle it or false to pass on to another plugin
function processUserCommand( command, arguments, connection, view ) {
	// return true if the command was handled or to prevent other plugins or Colloquy from handling it
	if (command == 'mop')
	{
		massOp(connection, view);
		return true;
	}
	return false;
}
Categories: programming Tags:

mysqli driver, prepared statements and geometry types

August 23rd, 2010 Richard Pistole No comments

FYI:

PHP Warning: mysqli_stmt_bind_result(): Server returned unknown type 255. Probably your client library is incompatible with the server version you use!



Probably means you’re selecting a geometry type without calling AsText on it.
Instead of

SELECT
	place.location_point
FROM
	place
WHERE
	place.place_id = ?

do:

SELECT
	AsText(place.location_point)
FROM
	place
WHERE
	place.place_id

Supposedly this is fixed in PHP 5.3. That isn’t really useful information, nor is the snotty svn commit message to use mysqlnd.

See: http://www.mail-archive.com/php-bugs@lists.php.net/msg127837.html

Categories: programming Tags:

A little TextMate black magic

August 19th, 2010 Richard Pistole No comments

I do most of my code editing in TextMate in OSX.

However my current code environment consists of a CentOS VM running under parallels.

I have my linux home directory mounted via SMB in OSX, but I like to do a lot of poking around on the files from the shell on the VM.

So, here’s a shell script to let me open files in TextMate from the VM:

#!/bin/tcsh
set f="`pwd`/$*"
set f="$f:s./home/pistole./Volumes/pistole/."
ssh wrath open -a /Applications/TextMate.app "$f"
Categories: programming, shell scripts Tags: