I’ve spent some time searching and I’ve finally found a good tool for auto-formatting SQL! Simply paste in your fugly code, make any configuration tweaks, post and *bam*. Beautiful SQL.
Great for those ColdFusion dumps.
There’s also a desktop version, but I didn’t check it out.
Half-Life is the game of choice at work, and sadly I’m terrible at it. I thought I’d try to write a little game using gosu to try and help me improve my accuracy. I just reached a good stopping point and I thought I’d share.
It’s really simple, the idea is to shoot little 20 x 20 “targets” (I’m artistically challenged) before they expire. Missing or letting 10 targets expire will end the game. Next version will include sound, improved visuals and maybe even a couple other fun features if your lucky.
The code is a bit over-engineered but I plan on incorporating parts into some “core extensions” that I’m working on that will hopefully make it a lot easier for me to bang stuff like this out. Finally, as I doubt anyone will ever download this, I didn’t bother to pack it up so you’ll have to have Ruby and gosu installed in order to enjoy it.
PS: I’ve been a Photoshop user for many years, but I used GIMP to make these images and I didn’t even hate it!
I’ve made a small date to my interpretation of Conway’s Game of Life yet again. Now instead of generating a random graph you can actually click on tiles to turn them “on” or “off”.
Here’s the code and here’s how it do.
You can find the older versions of the files here: http://joezack.com/index.php/tag/game-of-life/
I wrote up a basic model for a 52 card deck of playing cards in JavaScript (using beloved Prototype. I plan on using it to make some very simple card games in the near future. I thought it’d be interesting to post this before I actually used it anywhere so I could take a look at how much it changed after I actually implemented it.
There’s not much to see at the moment. You can just shuffle and get a card dump:
JavaScript Deck of Cards
Download the code!
JavaScript Deck of Cards V1
Current Version
I was working on implementing a ColdFusion payment processor for Chase Paymentech, but I kept running into the same error (which I’ve formatted so nicely using my ruby clipboard format utility!)
<?xml version='1.0' encoding='UTF-8'?>
<Response>
<QuickResp>
<ProcStatus>05</ProcStatus>
<StatusMsg>PTI43,TEXT/XML; CHARSET=UTF-8 is not supported</StatusMsg>
</QuickResp>
</Response>
I knew that PTI43 was part of the MIME Header Content-Type I was passing, so I did a little bit of poking around in the docs and came upon this. Apparently setting a cfhttpparam type of “xml” “identifies the request as having a content-type of text/xml.”.
In order to send a valid message to chase you have to specify a particular MIME header setting “Content-Type”, which ColdFusion was garbling. Thankfully all I had to do to fix it was switch the cfhttpparam type attribute to “body” in order to fix it.
<cffunction name="Authorize" output="no">
<cfargument name="vars" required="yes"/>
<cfset var cfhttp = ""/>
<cfset var i = ""/>
<cfheader name="POST /AUTHORIZE HTTP/1.1">
<cfhttp url="#GetURL()#" port="#GetPort()#" method="POST">
<cfloop collection="#arguments.vars#" item="i">
<!--- header variables --->
<cfif i NEQ "XML">
<cfhttpparam
type="header"
name="#i#"
value="#arguments.vars[i]#"
/>
</cfif>
</cfloop>
<!--- set the type to "body" NOT "xml"!!! --->
<cfhttpparam
type="body"
value="#arguments.vars["XML"]#"
/>
</cfhttp>
<cfreturn cfhttp/>
</cffunction>
I hadn’t run into this problem before, so I thought I’d share!
There’s a legacy app I work on that currently requires adding 4 columns and a couple rows (in different tables) every time you add a row to another table. It doesn’t happen often and it would be a nightmare to refactor so I wrote little script that would search the database for any columns named ‘x’ as well as any fields with a value of ‘x’ and return an array of the offending tables.
I cleaned it up a little bit and cfc-ized it in case I ever have to do anything similar. I haven’t tested it at all aside from the one time I ran it today so use it at your own risk. It’s really simple to use, you just need to pass in the ColdFusion datasource name and the search term.
Example Usage:
Looking for column #search_term#
Looking for value #search_term#
Download ColdFusion MySQL Search Utility!
PS: it won’t search numeric columns if you aren’t searching for a number.
During a brief period in elementary school drawing these things was quite the cool thing to do. I’ve been messing around with the GD2 module a bit lately and I thought it’d be fun and easy to write a little script to generate one.
It was.
The drawing algorithm
@nodes.times do |i|
adjustment = i * @node_size
pen.move_to adjustment, 0
pen.line_to 0, @size - adjustment
end
Example Usage:
#takes in the output image size and the number of nodes
c = Curve.new 180, 30
c.draw
c.export "test.gif"
*Note: If your output size doesn’t divide evenly by the number of nodes then the image will actually reduce the size of the output image.
Came across an interesting list of “promising” free CMS solutions that are a bit off the beaten path. Enjoy!
I wanted to demo an ad rotator the other day at work and I wanted to load up a bunch of images of various sizes to make it look legit. It would have taken forever to do it ad by ad, so I wrote a little ruby script to automatically resize all the images in a directory. Then I used my directory listing utility to copy the files into my clipboard. Pasted into the database from there!
(Requires GD2)
Usage:
r = Resizer.new input_path, output_path, width, height
r.crop_files
I was tinkering a bit while watching the tube tonight and I thought it might be fun to make a simple JavaScript tile puzzle. Might look terrible in other browsers.
First step was to write a little ruby script (using the GD Graphics Library) to read in a file and cut it up into individual tiles. (Photoshop is for wussies)
if __file__ = $0
#pass the image name, tile size through the command line
t = Tile_Cropper.new ARGV[0], ARGV[1].to_i
t.crop_tiles
end
Then I used a slightly modified method I read about in Ben Nadel’s blog to scramble the tiles.
A little bit of CSS magic:
#puzzle {
width: 500px;
margin: 0px;
padding: 0px;
}
.piece {
list-style: none;
display: inline;
margin: 0px;
padding: 0px;
}
img {
border: 1px solid gray;
}
And finally I used scriptaculous and prototype for the obnoxious drag-and-drop sorting. Not that I’m complaining. the Sortable methods weren’t intended to be used for something like this.
function init() {
Sortable.create('puzzle');
}
Complete the puzzle to find out what I was watching!. Here, I’ll give you a hint. It’s Dexter.