Category Archives: MySql

MySql Order By Own Values

While working on my game site I had to order related games by relevance where I had game ids as string in needed order. If I do regular mysql query

SELECT  * FROM games WHERE id IN(1,3,2);

I get result as 1,2,3. To get result in 1,3,2 custom order mysql query should be as following.

SELECT * FROM games
WHERE id IN (1,3,2)
ORDER BY FIELD(id, 1,3,2);

Wallpaper script v1.2.1 released

This version of script fixes 2 bugs related to some hosting providers.

wallpaper script v1.2.1 Wallpaper script v1.2.1 released

  1. Removed all short tags as it was reported some web hosts do not allow to switch it on by changing php.ini. So all php hort tags like <?= and <? replaced with <?php echo tags. This issue is pointed out thanks to Dudeist
  2. Bulk upload required ParseCsv.php helper to be loaded manually in some servers. Added loading this helper to script. Thanks to dn3 for solving this issue.

These 2 problems fixed in new version of script 1.2.1 which can be downloaded from wallpaper script page.

Free Wallpaper Script 1.2 released – includes bulk upload

New version of Free wallpaper script ready to download. After getting useful feedback from our users we added new features, improvements and fixed some minor bugs.

Here are main changes to script:

  • Bulk upload: Now you can upload thousands wallpapers at once via ftp and insert them to your database via Admin panel in few steps.
  • Improved install script to detect server compatibleness so new users will know why their script is not installing. Even if we write system requirements some users may not know their system configuration.
  • Added localization option to translate and use script in other language. Turkish translation in included.

wallpaper script v1.2 Free Wallpaper Script 1.2 released includes bulk upload

Free Wallpaper Script 1.1 coming soon

It has been a year since first release of Free Wallpaper Script. With more than 3000 downloads we got lots of requests and how to questions during past period. Most requested features were bulk upload and localization of script. So we decided add those features in version 1.1 (no release date yet) .

This release also will fix problem that occurs on installation regarding folder permission and php version detection.

We opened a discussion forum for questions and suggestions regarding free wallpaper script. This way questions and solutions will be available to all and be more useful.

Thank you for your response and suggestions that help to develop wallpaper script further.
free wallpaper script v1.1 Free Wallpaper Script 1.1 coming soon

UPDATE: New version number is 1.2 as I forgot that I was already using version number 1.1.