
A quick update on stuff I’m working on, if anything this is for my own benefit as I’ve just sat coding a whole heap of sql queries to realise I’ve called the wrong name of my mysql class, least I caught it early’ish
So here goes, and for most, here’s a heap of stuff they never even knew I was working on :p
- Anope – Usual, bug-finding, fixing, need to finish some modules.
- lethalitys-inspircd – Need to move this from Gitorious to Github as it’s where InspIRCd’s main repo is now hosted, luckily I already have an account. lethalitys-inspircd is basically my fork of inspircd-2.0.5, adding some stuff and fixing others, including updating documentation, as inspircds, especially 2.1′s is extremely out of date. Sidenote- InspIRCd should scrap 2.1 and start again from 2.0, it’s actually not worth fixing/reverting all of the changes and fail.
- WatchTower – This is my phpBot, name needs to be finalized, it started as a version I was going to release, for people who wanted functionality similar to UKCB’s Gateway, only problem is the variety of websites and database systems that people use, as opposed to UKCB’s which is all custom-coded, make this an annoying task. (I’m not writing one version for Joomla, another for e107, another for phpNuke, etc etc), solution: lose some of the functions.
- IRC-Heaven - I WILL start this properly soon, it will be a source of everything IRC related, it’s a task I just don’t have time for at the moment
A number of people have discussed the beginnings of UKCB, most versions lack facts, so here’s mine, using various sources and my own knowledge.
Bobby Amlani (30), (nick alias: Blaster) founded UKChatterbox whilst studying at the Anglia Ruskin University, along with his brother Parul, aka Paz. This year marks it’s 10th anniversary, during which time, the service has seen a lot of changes, users, staff members and problems. What follows is an in-depth history of UKChatterbox (UKCB) from it’s beginning as a small IRC network, upto the present day, the largest moderated UK based chatrooms provider with ~2 million registered users.
Firstly, UKChatterbox didn’t first appear on the net as “UKChatterbox”, it’s beginning dates back to 2001. A website called gasbubbles.com created by Bobby, provided chat targeted at university students. Profiles had more details then the current UKCB, with users allowed to post contact details for IM (AOL, MSN).
UKCB’s predecessor; Gasbubbles
Gasbubbles was a laid-back service, few rules and regulations. In time the website-side of it would fade as UKChatterbox grew, although for a large time UKCB’s chat rooms were on the same server as GasBubbles, eventually these would merge.
Mid-2002 saw the first appearance of UKChatterbox, this was accompanied by UKStudentChat and UKTeenChatrooms, all with their own sites, although seemingly all sharing the same database, little-known fact, ukstudentchat.co.uk will, to this day take you to ukchatterbox.
UKChatterbox was aimed at both users in the UK, and users from outside, who just wanted to talk … Read the rest
So this has got me ranting enough that I need to type, well done do-gooders! If you’re reading this you’ll probably already know what MySQL(i) is, it’s a database management system, most sites will use mysql, it’s “improved extension” mysqli, sqlite or mssql for Windows users ![]()
PHP has long has a MySQL extension, this was fine for most. Then along came MySQLi, the i meaning “improved” this was faster, and allowed other stuff like prepared statements, multiple statements and better debugging. PHP have announced they’ll soon drop support for the old MySQL interface, forcing people to get with the programme, and use MySQLi or PDO, now what is PDO?
PDO (PHP Data Objects) is basically a database abstraction API that works with different types of remote databases, eg. you can create code, one line defines the database driver you’re using, be it mysql, sqlite, etc, you can then switch between drivers without editing your actual queries, that’s the main benefit, along with prepared statements and OOP.
So my rant is this, the difference going from mysql to mysqli is marginal, the step to PDO is a much larger one, don’t get bullied by people in the trade into using PDO just because it’s “hip”. I’m about to start building a new site, and renovate another, I will be using mysqli as I have no intention of ever switching databases so this suits me fine. If you’re building for other people and/or are in the trade, PDO would be useful to … Read the rest








