Author Topic: PHP and MySQL compatiblity  (Read 5032 times)

ShadowRaven

  • Guest
PHP and MySQL compatiblity
« on: January 20, 2008, 12:00:41 am »
Heya,
I am testing the 1.1.1.0 DEV and I just read that the requirements for this is PHP 5+ and MySQL 5.x.x.
My server is running PHP 4.4.4 and MySQL 4.1.2 and everything *seems* to be working correctly so far.

Could you tell me what type of things I should be looking for that would indicate that its not going to work with these versions of PHP and MySQL?
I would very much like to use this fork but I really don't want to have to go through the pain in the ass of upgrading my PHP and MySQL right now, but I will if I absolutely have to...

Thanks,
~SR

Nightborn

  • Administrator
  • Sr. Member
  • *****
  • Posts: 320
  • Karma: +20/-0
    • View Profile
    • Shinobilegends
Re: PHP and MySQL compatiblity
« Reply #1 on: January 20, 2008, 04:37:56 pm »
Okay.

I don't recall *all* occurrences, but here are a few:

mysql 4 does not have the column type "varchar" that has MORE than 256 chars. So you are stuck with 256 most likely.

Check your "accounts" table for the field specialmisc. This went from TEXT to VARCHAR(1000). This will most likely be VARCHAR(256) there.

php 5 is not necessary now as I recall, BUT I will use OOP in the battlesystem which is currently revised, and then your server won't be able to use this version, any fight will result in an error page.

I strongly suggest an upgrade in the near future.
It should be fixed, but it won't be easy and it won't be fast. If you want
to help - wonderful. But keep in mind that it will take months of wading
through the ugliest code we have in the tree. If you've got a weak stomach -
stay out. I've been there and it's not a nice place.

   - Al Viro

ShadowRaven

  • Guest
Re: PHP and MySQL compatiblity
« Reply #2 on: January 20, 2008, 08:41:42 pm »
Ok, thats what I needed to know. I could actually deal with the VARCHAR value, but there's no way around the problem that will come up once you start using OOP.
I will definitely look into upgrading soon then.
Thanks for the input :)

Nightborn

  • Administrator
  • Sr. Member
  • *****
  • Posts: 320
  • Karma: +20/-0
    • View Profile
    • Shinobilegends
Re: PHP and MySQL compatiblity
« Reply #3 on: January 21, 2008, 10:31:55 am »
 ;D
no big deal.


I write quite some modules at least partly OOP now where it is due, so you should start looking into it.

http://www.php.net/manual/en/language.oop5.basic.php
It should be fixed, but it won't be easy and it won't be fast. If you want
to help - wonderful. But keep in mind that it will take months of wading
through the ugliest code we have in the tree. If you've got a weak stomach -
stay out. I've been there and it's not a nice place.

   - Al Viro