More efficient script
http://www.pixelpuppy.net/otherfiles/adoptables26.zip
The file I've linked to is basically the Rusnak PHP Adoptables script, only more optimized. functions.php is more organized and uses less queries, the beginning and end of each page is much more adaptable to mods and other changes to the script, and there's also something which shows you how many queries each page is taking.
It uses (right now) the exact same database as the current version, and I don't think there are any bugs. If you find any, please tell me and I'll fix them right away.
All existing mods should work with it, as long as they are put between the START SCRIPT and OUTPUT PAGE comments. The exception is that every occurring mysql_query() should be replaced with runquery() for the number of queries to be documented.
Right now I'm working on cleaning input better, as well as integrating some of my existing mods into it. When I update the best thing to do would be to re-download the whole rar as some things (for example, removing redundancies or errors which were made on lots of pages) require lots of files to be edited. :)
Currently I don't have the credit to Bmr on every page, because I don't know what exactly I should put there yet, especially because it seems as if the new version will have lots of people editing it. As soon as I know what to put there, I'll add it.
Edit, 23rd of December: Today I made the script use a few less queries, fixed some previous glitches, and also introduced a debug mode which shows the queries which have been made at the bottom of the page. (Debug mode will be turned off in the final release, of course.) If you have any feedback on what I can do better please do - my next goals are to add the gender, money and styleswitcher systems.
Edit, 26th of December: Over the last few days I made a few more changes. Now not only is the gender script completely working, but I've worked a bit more on themes and done the styleswitcher. I'm currently working on adding all the features of V1.1 to this, but please do download and tell me if you find any glitches. Just run stuff.sql and once you've registered, change your group to 1 using phpmyadmin if you'd like to look at the admin panel.
|