This is an alias script I made a while ago and released so that people could learn more about using SQLite and solve any potential problem they may have with their current alias command.
Intro:
This is an example script that demonstrates how to use SQLite as well as a couple of other functions. I encountered a problem with my previous alias script in that the maximum character limit for PrivMessage is 180, anything after that is not properly visible, and anything over (250? I think) will crash the server. 180 characters is often not enough to fit all aliases in though, so I had to make a way to split up the result into a few messages instead of one. These commands do that, it currently gives the option of splitting the result into 3 messages, but once you get the hang of it you can add as many as you like. I also check for duplicates, read the alias function to understand why there might be duplicates.
The download links is here:
http://www.sendspace.com/file/lghp6aCommands included: ipalias, subnetalias, getip, (oipalias, osubnetalias - offline irc extras)