Hi,

I am trying to run lotgd r14 on mysql 4.1+ (mysqli) and php5 (using translationtool for cyrillic-bulgarian characters) and I came accross some issues and some ideas about their resolving:

- switching to mysqli is just not enough as in mysqli functions mysqli link resource is the first parameter which is also mandatory. So i did 2 db.mysql.php and db.mysqli.php which are included in dbwrapper.php regarding the db type.
- also common.php has to be modified because of the link we need to supply and as for php5 that link is an object, we can't just put it in the LINK constant so i did $GLOBALS['lotgd_db_link'] which stores the link for mysqli use and dummy LINK for that case
- there is a known error when creating tables in multibyte charset db because the key is too long or when creating the tables in a different collation db there is an error "Illegal mix of collations for operation ' IN '". The second can be resolved by adding "set character set" and "set names" sql statement after connecting to the database thus specifying the correct client connection. Of course, in php.ini and my.cnf should be set the correct character sets and collations.
- the problem when translation is used is within htmlentities function which has to be called with the correct character set parameter (i know it's 4.3+ but ...) and that function is unfortunately used in many scripts and PHP does not allow function overriding. I think that for the sake of translation correcting the call in output.php (function appoencode) is just enough but it has to be tested. Maybe it's good to use a custom htmlentities function which will redirect the call to htmlentities or use some other algorithm.

After these modification I am running successfully LOTGD that can be translated into cyrillic (bulgarian) but i am still testing whether all the functionality is correctly behaving. BTW FYI IMHO lotgd is running quite faster on php5+mysql4.1+ than the other install i've tested with php4+mysql4.1+ (i used zend optimizer on both)

I will attach my modified lotgd files if they are interesing to someone.
You can use and modify them as you like.

I hope this could be useful to someone

Regards,

Unfortunately, at this time lotgd is not going to officially support PHP 5, nor mysqli under MySQL 4.1.

Also, I ask that you please do NOT distribute full copies of the core files, but rather distribute diff files.

This is because those files are in active development and if someone installed your file over a more recent version of the file things would quite likely break badly.

I wasn't objecting to you sharing your work, in fact, I applaud and encourage it.  I'm just trying to prevent future problems where someone has installed your file and then things break because they don't pick up a required piece of core change.  The diff files are fine.


I don't know of any way to remove the attachment from your previous post.  Maybe Talisman can.