Page 1 of 1

MySQLi & PHP 5.4

Posted: Wed Feb 11, 2015 12:39 pm
by Dragonsys
I am working on making this script work with MySQLi & PHP v5.4. I will create a patch based on the current download version, unless you have another version you would like me to patch.

I also have a few mods which I will release as well, such as random images in the sidebar.

You can view my demo site here - http://dragonsys.noip.me/utstatsdb/

Re: MySQLi & PHP 5.4

Posted: Wed Feb 11, 2015 5:20 pm
by Dragonsys
Mods:
  • Selectable Layouts - 100%
  • Friendly Layout Names - 100%
  • Downloads - 75%: descriptions require a manual file edit (simple text edit)
  • All Demorec Files Listing - 75%: descriptions require a manual file edit (simple text edit)
  • Random UT Logo (top of Sidebar) - 100%
  • Random AI player image (bottom of sidebar) - 100%
  • Customizable iFrame (requires file edits) - See UT2004 Admin link on demo - 65%: links require a manual file edit (php edit)
  • Added Stats Admin to iFrame, this allows for the sidebar to be visible while in the Admin Section - 100%
  • Added Cumulative Totals by Game Type to front page - 100%
  • Change to MySQLi - 80%: Need to update .sql files for Table creation
  • Make compatible with PHP 5.4/5.5 - 95%: still 1 generic error, can be safely hidden

Re: MySQLi & PHP 5.4

Posted: Wed Feb 11, 2015 7:31 pm
by Panther
Looks nice, I'll check it out more as soon as I have some time. Perhaps we can stick some of your mods in the official release. Unfortunately, I'd left off some time ago while making some major changes to the way some things are stored for better flexibility and need to figure out where I left off in order to continue development.

Re: MySQLi & PHP 5.4

Posted: Wed Feb 11, 2015 10:19 pm
by Dragonsys
cool. I have a patch file here http://dragonsys.noip.me/utstatsdb/inde ... =downloads
The patch file includes the MySQLi & PHP 5.4 updates, as well as all my mods. I will break this all out, but this will give you a start if you want/have the time. There is also a RAR file containing the binary files added in support of my changes.

This is the exact version running on my site.

Re: MySQLi & PHP 5.4

Posted: Sat Feb 14, 2015 7:13 pm
by Dragonsys
In case I forgot to mention, this patch still has a few bugs and should not be used on a live site, unless you are familiar with PHP and SQL cmds.
I found a bug in the Main Config, which hide most of the Text Fields. I have corrected this, but it is not in the current patch. I will try and get it added to the patch this weekend.

Re: MySQLi & PHP 5.4

Posted: Sun Feb 15, 2015 3:46 pm
by Dragonsys
I have updated the patch file on the link above. I think I have all the breaking bugs worked out.

Re: MySQLi & PHP 5.4

Posted: Tue May 26, 2015 12:36 pm
by maat1985
Hi, i know you posted this a couple of months ago but i was having trouble getting my database to work..
Error creating tables... i think your update maybe a solution.. however your link does not seem to work... can you repost a new download linkñ

Re: MySQLi & PHP 5.4

Posted: Sat Jun 20, 2015 8:15 pm
by Dragonsys
Hi, i know you posted this a couple of months ago but i was having trouble getting my database to work..
Error creating tables... i think your update maybe a solution.. however your link does not seem to work... can you repost a new download linkñ

Sorry, I have been moving over the last several weeks. Once I get my computer back up and running at the new house, the links will start working again. I will put the files on a better host once I am able to access them.

Re: MySQLi & PHP 5.4

Posted: Sat Jun 20, 2015 10:33 pm
by Panther
The error is probably caused by the MySQL files using the deprecated TYPE parameter instead of ENGINE. I've uploaded an update to the file section. Just extract that to your tables/mysql directory.

Re: MySQLi & PHP 5.4

Posted: Wed Jul 15, 2015 9:46 pm
by Dragonsys
ok, my site is back up and running, so the above links should all work again.. sorry it took me so long, but my computers were horribly damaged in the move, and I had to replace them.