Category Posts Count is a plugin for Wordpress 2.0 (not tested for earlier versions) that lets you count the number of posts in a category, using a newly created function. It uses moderately complex SQL constructs. The only function generates a number, if you give the category name as a parameter.
Read the rest of this entry »
Hi all,
A rather big update today. We can sit down in our halls now! As the block administration was already finished the seat administration begin ready now, you can add as many seats to your blocks as you wish, but you should not decept your users by putting more seats in a block that has only a limited width…
Read the rest of this entry »
Some very good news today! I’ve worked really hard and have lots of things to show you, but I’ll wait some more to show screen shots, just for fun 
Read the rest of this entry »
I worked on phpres a lot this afternoon too, I’ve got 2515 lines of code, both templates and PHP code.
Read the rest of this entry »
I really got the hang again for phpReservation.
The category system is in development now. I’ve implemented some simple AJAX request scripts, for more dynamic pages, but I’m doubting if this is a good way. I’ll finish it sometime this week, got more classes to attend (maybe that’s more important? hmmm 
)
Read the rest of this entry »
Well, it’s been a long time again since I updated the website. Since that day, Drupal has been replaced by Wordpress, a whole lot easier to maintain.
Read the rest of this entry »
Today I was working on the new blog a bit and stumbled upon a limitation common to many free webhosting companies: no smtp and thus a disabled mail() function.
Of course, user registration fails totally without being able to send emails.
So for those who don’t really like editing php code (as they can’t or don’t dare), here are a few solutions to your problems.
Read the rest of this entry »
It’s been a while since the last update, mainly for enjoying my ever
so short vacation. Today I added user administration. You can now
edit and list the registered users. Deletion will only be included
after all modules (like category, seat and reservation) are finished
to make sure the database stays consistent at all times.
A little side note: I am not using InnoDb (the transactional variant
for MySQL), although I would need transactions to keep the database
safe and up to date at all times, I may add this transactional support
later on, but don’t count on it. This IS a consistency issue, and
should be resolved, for it may corrupt your data, like e.g. deleting
an event (for archiving purposes) and not deleting the reservations
for that event, which creates bogus entries from the user’s point of
view.
I will also have updated the website somewhat today, can’t seem to
bend drupal to my needs
Cheeryo
Imagine: you work (yeah I know it’s rather hard to imagina yourself working, but try anyway). Then imagine you work in a team (wow, here come your social skills). Not everyone can be available at all times, and you would like to know who is and who isn’t, organised: easily viewable, non-redundantly updatable, and everyone needs to edit his own time out.
Read the rest of this entry »
Studying is over now, so I can focus a bit more on phpres. One
important feature added today is event adding. I am still
busy figuring out what to do next. The most important thing in
these kind of database applications is to keep integrity up at
all times. This means that deleting of anything is not yet
implemented. Because deleting an event, may require deleting
some reservations, which might delete customers and users, which
of course we don’t want. I have to think that part through.
First of all, I am going to try to upload my sql dump, and
scripts, to see if it works on a remote server.
Well, the uploading and adjusting was kind of crappy, with database
usernames / prefixes, which by the way are fixed now.
I think I’m gonna sleep over this a while :p
