I was looking for the meanings of some songs recently I noticed there are virtually no sites out their with song means like lyrics sites. It’s probably due to lyrics being a lot more readily available and popular than meanins but I see a gap for a potential new website there. With that in mind I set about thinking how I can adapt my existing lyrics database to do it.
What I would normally do to list artists and albums, etc would be to use distinct. But that would mean I could only get one column out of the database and I need to check to see if there is anything in the meanings column as for most of the songs in the lyrics database, there won’t be. The problem is that distinct check all columns listed not just the first.
On looking around for the answer, the best thing I could find is located here, on the SitePoint Forums. I am hoping it will do what I want – select everything from the database but only where there is a unqiue artist name.
select * from yourtable where lastnamein ( select lastname from yourtable group by lastname having count(*) > 1 )
Looks crazy to be but I am willing to give it a go. I will keep you posted on how it turns out.
Crazy McCrazySon. Now there is a guy who knew about stuff. But anyway let’s get on with this post. Last night (and to an extent this morning) I was watching Coyote Ugly on ITV1. I regret my decision to video Law & Order: Special Victims unit instead of it but I guess this way I can justify buying it on DVD :D.
I spent some quality time writing reviews for the movie. You can see the first one I did on Review Machine movies and the second one I did is splashed over the Emo Movies homepage – yep, that’s right, I actually updated Emo Movies. For only the second time in history lol.
Maybe I can catch it on video next time it’s on. This isn’t the first time ITV1 have shown it, they had it on a few months ago, but I missed it last time. Oh well, I needed to spin out a final paragraph which I think worked out well ;). Cool movie.
Nerd Federation is on the grow :). Not only do we have posts and everything now but also this post marks the first one in August – we now have an archives section for July! Oh yes, these are the days people, these are the days. And speaking for today it has been pretty good even if I didn’t get up until 10. Though I do regret last night’s video choices – more on that some other time.
The end result of the activities from last night anyway is that I ended up in imdb.com, looking through the filmography of John Goodman. He has done loads of voices but perhaps his most famous roll was in the Flintstones. One other film I fould he was in was a 1984 release called Revenge of the Nerds. With a title like that I just had to find out more.
The basic plot summary seems to be that a bunch of nerds are getting picked on and bullied and so form their own fraternity to fight back against the jocks with high tech weaponry and tactics. Kind of like in Malcolm in the Middle where the geeks guild that pie slinging thing with Stevie’s telescrope.
I headed onto Play.com to have a look for it and discovered there is a sequel too – £10 will score you Revenge of the Nerds 1 & 2. If you want to buy me a copy it’s available from Play.com and Amazon.
Well now, it seems that certain things are going fairly well. Sure it is raining outside and I am hungy but there are more important issues at hand – for instance, last night I burned Book of Vegans: Blair Wiccan II and the original Blair Wiccan Projectto a special boxset style DVD featuring all 3 commentaries. The only thing that was left off was the Blair Wiccan Project commentary, deleted scenes and outtakes which I shall try to find today.
Even above that though is the development on Frinks. This new web portal will take over from M World / Rawice as the central portal for Worfolk Online like MSN is to Microsoft and drawing all Worfolk Online’s content together, in one place with static type content to maximize our traffic from search engines. The news and weather sections are already complete.
Worfolk News is also getting a make over so that it can have a white background rather than the bright orange one it has covering the entire page at the moment. I would like to see Worfolk News in Google News some time this summer so I think as well as plenty of news we need a site that looks presentable. I want to launch that some time in August.
Tommorow after all is August – which means that from tommorow, posts on Nerd Federation will be archived under August 2004, instead of July 2004 . We will have ourselfs a real archive! I think it is an exciting day for all of us.
I think, to a certain extent, I am waiting for the inevitable. When will we get bored of posting on Nerd Federation and simply go off and do something else? Although the word “we” is probably a bit strong. Other than my posts, the total count for everyone else numbers up to the high about of one. Still, maybe more life will be pumped in if the forums ever return.
Still I would like to think Nerd Federation can keep going for a while. If it can be sustained for a month or two, at least then it cannot be classed as a phase, it will be more of a long term project. But the most important thing is the archives building up as each new month adds a link to the list on the left of the homepage. And isn’t having a cool archives list what all websites are about.
Sustainabilty is a big issue for my web development at the moment, though. My new Michelle Branch Planet website will hopefully begin to gain traffic thanks to several new bits of information being published each day. However this constant updating needs to be sustained if I am to make the site really popular.
It is the same for Maze Radio also. I can see nobody else is really that bothered so there is little chance the show can be made daily. But weekly is the very limit of what we need if the site is to ever become popular. And considering they are only 15 minute shows I’m not sure that will be enough. I need a new project, TV Forge perhaps.
Well well, it is only 15 minutes until the new series of Law & Order that has been totally ruined by a new theme tune, opening sequence and random changing of cast. Oh well at least I can catch the last 15 minutes of Friends on E4 plus 1. Meh, I am still longing for the next episode of One Tree Hill but that is still 6 days away! How can anyone wait that long? I haven’t felt this way since the O.C.
So anyway my plan for today was to head into Crossgates and search for some recordable media. But as my order didn’t get dispatched until quite late it was too late by then and I didn’t want to go until it had been. Still it has now so hopefully it will arrive tommorow and I can spend the afternoon getting the media. That or sleeping, sleeping is good too.
Ok, what else can I complain about? I am working on Frinks yet again with Frinks mark 5 the versions just keep coming hu? I am moving Frinks and Worfolk Online over to a new server although I am having problems making remote connections to the server. Plus I still need some of my databases restored on the old server. Bah!
I have been searching for some ways to get RSS feeds. After ignoring the technology for quite a while, I finally decided I should delve into the world of RSS, I am a nerd after alll. So I headed off to a number of sources including SitePoint and CNet to get some information, software and other such things that I would need.
Having tried one though I destroyed Firefox with it refusing to open when I tried to run the application. Not the best start. I was also going to try the Firefox favourites type plugin although it is only available for 0.7 and 0.8. I am running 0.9 so I didn’t want to risk it. My third alternative was Sharp Reader or something, which required the .net framework which has never ended well when I previously installed it.
The reason I really got started with it as I noticed Yahoo Groups were now offering RSS feeds. I had noticed it before but now I actually wanted to use them to allow me to get access to all the latest Michelle Branch news and discussions for my new site, Branch Planet.
Still, I am sure a solution will randomly turn up. I was tempted by the one that is intergrated with Outlook Express although I always find that place depressing and can never keep on top of all the emails I get.
Stuff is happening. Stuff is going on. So the only real thing to do is to talk through it on Nerd Federation. My experiances with Firefox continue, I noticed that even when I backspace, the scroll bar on this editing page extends. Also, when I close a tab it jumps to the one on the right rather than the one on the left. I also miss the new tab button on the left of the tab row.
But anyway so there are things set in motion. Last night I managed to get hold of a .asf converted to mp3 so now I can convert the radio stations from Grand Theft Auto: Vice City to mp3 and listen to them outside of the game! Last night and this morning (now in fact) I am listening to VCPR and I also plan to listen to K Chat. Talk radio stations rule :D.
Also today is the date of a gathering. Hopefully we can finally get some Maze Radio done today and last night, myself and Ceon were also exploring the possibility of doing a new movie. We need to find someway to fund it though so if you have a spare grand ;). We will give you an advanced copy and everything.
Also hopefully my DVD rewriter will be ordered this morning. It has a 5 day order on demand from eBuyer.com where I am getting it from then so it is probably going to be a week or two before it appears. Still I need the time to save up for money to buy some DVD+R’s anyway lol.
Hurray! After finishing up with the Cherry Popper Ice Cream Factory I completed another asset and so unlocked the final missions. I had done it before, I got up to 104 deliveries one time but nobody told me to get out of the van so I didn’t realise and got myself busted. Oh well I did it, so anyway the final missions were unlocked – cap the collectors and keep your friends close…
So after stopping off at sunshine autos (it’s the one place that seems to provide a hiding place inside) I drove up to the mansion and headed inside. After the cut sequence I began to chase down the collectors and ran them over somewhere near Washington Beach. I then headed to the bridge to stop the next two and took them out near the Malibu. Then the final ones were taken out on the bridge to downtown. Mission complete.
So back to sunshine autos and heading back to my mansion. I pulled out that big rail gun thing and gunned a load of matia down, followed by Lance and finally Sunny. I noticed some cool limo’s outside but by the time I had answered all the phone calls and saved they were gone. Anyway I am missing a large chunk out here. The credits went on for ages and I couldn’t skip them. I presume everyone was in the same situation.
Anyway so the ending sequence was really good I thought, it was edging on emo which I liked. I can see why people can live out their fantasies as it really dragged me into the storyline and I can see how other people could be too. Is there any recorded news of inspired violence? Comments people!
To conclude, the game is finished pretty much the only other things I have to do is finish off the film studio and sunshine autos and do stuff like the minor details as I only have about 8 hidden packages lol. Anyway, I might do them I will probably try but I finished the main bit and thats the most important thing. So yay!
It’s the site you have all been waiting for. I can’t remember if I mentioned it before, I think I did in the addictions post where I said I would keep you posted. Well consider yourselves posted as here is the latest update – the site is now officially open. Check it out at BranchPlanet.com. Hmm, this editor doesn’t work so well with Firefox when it comes to inserting URLs.
Anyway the site is basically going to be a news portal, that way I can update it like every day which should bring plenty of visitors in or so I hope. The great thing about doing a niche site like a fansite or a site about Chinese / Albanian hamster hybrids is that you can really make a good site, maybe even the best site on the subject as there isn’t the huge competition. That is my aim here.
Hopefully the site should get crawled pretty soon. Google Visited Gamer Forge within 24 hours of submission, possibly due to the link from Worfolk Online’s homepage which I have given to Branch Planet too so if it is that, the robots should be hoping along nicely.
Oh well I guess only time will tell for what will happen to the site. The most important thing is that whatever happens, it should provide some material for some new posts on Nerd Federation. I am still chasing down the old forum database so hopefully, I will recover that soon. Of course, that is a completely unrelated topic but that is what Nerd Federation is about.