MySQLi & PHP 5.4

General forum for discussions regarding UTStatsDB
Dragonsys
Posts: 27
Joined: Mon Dec 17, 2007 3:49 pm

MySQLi & PHP 5.4

Postby Dragonsys » Wed Feb 11, 2015 12:39 pm

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/
Last edited by Dragonsys on Tue Jul 28, 2015 3:31 am, edited 1 time in total.

Dragonsys
Posts: 27
Joined: Mon Dec 17, 2007 3:49 pm

Re: MySQLi & PHP 5.4

Postby Dragonsys » Wed Feb 11, 2015 5:20 pm

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
Last edited by Dragonsys on Sun Feb 15, 2015 1:47 pm, edited 4 times in total.

Panther
Site Admin
Posts: 500
Joined: Sat Dec 08, 2007 12:51 am
Contact:

Re: MySQLi & PHP 5.4

Postby Panther » Wed Feb 11, 2015 7:31 pm

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.

Dragonsys
Posts: 27
Joined: Mon Dec 17, 2007 3:49 pm

Re: MySQLi & PHP 5.4

Postby Dragonsys » Wed Feb 11, 2015 10:19 pm

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.
Last edited by Dragonsys on Tue Jul 28, 2015 3:32 am, edited 1 time in total.

Dragonsys
Posts: 27
Joined: Mon Dec 17, 2007 3:49 pm

Re: MySQLi & PHP 5.4

Postby Dragonsys » Sat Feb 14, 2015 7:13 pm

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.

Dragonsys
Posts: 27
Joined: Mon Dec 17, 2007 3:49 pm

Re: MySQLi & PHP 5.4

Postby Dragonsys » Sun Feb 15, 2015 3:46 pm

I have updated the patch file on the link above. I think I have all the breaking bugs worked out.

maat1985
Posts: 3
Joined: Mon Nov 11, 2013 6:17 pm

Re: MySQLi & PHP 5.4

Postby maat1985 » Tue May 26, 2015 12:36 pm

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ñ

Dragonsys
Posts: 27
Joined: Mon Dec 17, 2007 3:49 pm

Re: MySQLi & PHP 5.4

Postby Dragonsys » Sat Jun 20, 2015 8:15 pm

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.

Panther
Site Admin
Posts: 500
Joined: Sat Dec 08, 2007 12:51 am
Contact:

Re: MySQLi & PHP 5.4

Postby Panther » Sat Jun 20, 2015 10:33 pm

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.

Dragonsys
Posts: 27
Joined: Mon Dec 17, 2007 3:49 pm

Re: MySQLi & PHP 5.4

Postby Dragonsys » Wed Jul 15, 2015 9:46 pm

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.


Return to “UTStatsDB”