Tonight I was trying to convert the old custom quote system I used for #arc to qdb just for fun. I was trying to find out the code used by qdb.us/bash.org but came across this peice of code called OSQDB.

Here’s an exerpt of code called whenever a new quote is added.

$get = mysql_query("SELECT * FROM quotes ORDER BY id DESC LIMIT 1");


while ($count = mysqlfetcharray($get)) {
    $tempid = $count["id"];
}
/* Increment the id */
$newid = $tempid+1;
$sql = mysql_query("INSERT INTO quotes SET id = '$newid'");

New Version of MTLJPost 1.9.2

Apparently there is confusion all over, so here's an email from the mailing list:

Okay, i thought i got all references to the extra files in the docs, but
i didn't, and its a little late for me to try and rewrite the docs tonight.

Installation is just:
plugins/MTLJPost/MTLJPost.pl

Everything else is linked from the main interface using the new 3.x
plugin interface.

If you goto a specific blog, you can set that one up.

I removed all the extra files to make installation simpler, little did i
know everything was opposite ;)

PS, my archiving script broke, so there was a bad version of the files
up there up until about 5 minutes ago, so i suggest everyone redownload.

Gavin

I'm still trying to work out a new MT plugin to do podcasts cleanly for HiSciFi (and smile like a donut).
The current MTEnclosures works, but its sorta too general purpose to work cleanly, Jevon wants me to add itunes rss tags to the feed, and I can't do that with the current plugin.

Just trying to figure out how I want to do things. This CMSEnhancer plugin looks pretty cool, I could make this into a REALLY cool plugin if I did it that way, or a less interactive one and depends more on parsing the post otherwise.

We'll see won't we.

I still have to get thier new template finished and installed. Wonder which is more important. Probably the template as enclosures do work, just not well enough yet.

I can never remember what version of website it is, doesn't actually matter, just that I now am using kodepost, which is my new web site software which is only for "blogging". Doesn't have all the other pages like halkpost attempted to, or anything like that, just is straight forward, has templates, comments, and trackbacks.

Unfortuatly its not 100% done, the posting interface needs alot of work, some of the templates totally suck (might notice May 2005 on just about every entry page), few other things like that.

But 'm very happy that people can comment now (not that I actually expect any, but now the ability isn't broken).

To fix in the immediate future.
* Archive links.
* Trackback discovery when posting
* Comment / Trackback notification

whoo, its good to code again.

Man do I love Open Source Web Designs. If i didn't use that site for at least the base, my sites would look as crappy as they did back in '95 :)

Anyways new look, I'm quite happy with it, still needs some tweaking, but much better than the previous all white one.

Starting to work on this code again. Slowly working on migrating my entire site over to the new codebase.

Part of the reason people probably havn't been noticing any updates that have happened on this server was the rss file was always linking to the wrong one, so i've finally fixed it so people are getting the correct information now. WHEEE.

Yea.

We've moved now. We'll I've moved now. Living with an awesome roommate. You can see us on cam at /cam/. Well its more the living room cam. It all started as just good fun, now its sorta stuck and we are used to it :D

Yep.

On Tue, Apr 13, 2004 at 09:20:06PM -0700, Gavin Mogan wrote:
> any way you could add access to defaultpicurl please?

Done; in the 0.11 release - I've attached that version. Taken from the docs:
$lj->DefaultPicURL()
Returns the URL of the default picture used by the user.
Note that if the LiveJournal object was created with
either "pics" set to "0" or with "fast" set to "1" then
this function will always return an error.

Example code:
print $lj->DefaultPicURL(),"\n";

Took a total of.. well i emailed last night, got a reply this morning.

Stuff to work on with the next version of MTLJPost.. but this makes things easier..

From: Lisa [lisa@lisa-jill.com]
To: 'Gavin Mogan' [halkeye@halkeye.net]
Subject: RE: A quick surpise for you.. another plugin
Date: Sat, 10 Apr 2004 15:15:10 -0400

Gavin,I have got to hand it to you. I wasn't quite sure how well that thelivejournal stuff would work, but my god.

http://www.lisa-jill.com/archives/2004/04/the-trip-to-dc.php
http://lisajill.livejournal.com/

Absolutely brilliant. I owe you big time. Thank you *so much*.
--------------
-----Original Message-----
> From: Gavin [mailto:halkeye@halkeye.net]
> Sent: Friday, April 09, 2004 1:26 PM
> To: Lisa
> Subject: A quick surpise for you.. another plugin
>
> Got a surprise for you :)
>
>
> I've been meaning to finish it.
>
> http://www.halkeye.net/files/?file=MTLJTag.1.2.tgz
>
> Seemless <lj user= and <lj comm= integration
>
> Gavin
> --
> Gavin Mogan
> halkeye@halkeye.net
> (604) 505-8034

Yea Yea, if this works, then MTLJPost 1.6 Is ready to go.
1.7 will follow quite quickly.. but I want to make a clean realease of this before i move on.

Download Version 1.6.

This comes with MANY improvements, as the other one died most of the time.

Simple Install Instructions
> .pl goes to mt/plugins/
> .pm goes to mt/extlib/MT/Plugins/
> .tmpl goes to mt/tmpl/mtljpost/
> .cgi goes to mt/ (or whever you have your other cgi files)

Its kinda exciting.

The javascript on the login information page is NIIIICE.

Update: added Instructions and submitted to mt-plugins.org

Update: Download Version 1.6.5.

Update: Download Version 1.7.1.

Yea. Really lacking in interesting content lately, mainly due to working hard to complete projects and just.. working.

Yea, I've start back into trying to code alot, Its something I really like doing whenever I can. Last week I devoted myself to learning and expeanding my knowledge of php, postgresql, and OO PHP. And I can say I really enjoyed it.

This week I'm falling in love with mod_perl. I will be unveiling a project soon, its getting near completion. Its really quite simple, but It will make creating a linux jukebox alot easier.

I am quite excited about it. Its one of my old projects, back when I knew nothing about perl, so its quite enjoyable to redo it. And the performance over straight cgi perl is so... I can actually hear/feel it, much faster, computer doesn't grind/etc.

Yea.

So stay tuned (If there are any who are paying attention to this anyways).

(watch out for a new layout soon too. 'Cause I've finally started to realize how crappy this one is)