Xoogu

[...] .rgt AND parent.id = 16) GROUP BY images.id ORDER BY images.id ASC LIMIT 0,30 #Number of runs: 76 Avg time taken: 0.0015269329673366 SELECT images.id, images.Headline, images.filename, images.Rating, [...]

[...] images.Rating ASC, images.id DESC #Number of runs: 97 Avg time taken: 0.035095794913695 SELECT DISTINCT images.id, images.Headline, images.filename, images.Rating, images.url_name FROM images WHERE [...]

[...] different query tested, along with the number of tests of that query and the average speed: SELECT images.id, images.Headline, images.filename, images.Rating, images.url_name FROM images WHERE images. [...]

[...] BETWEEN parent.lft AND parent.rgt AND parent.id = 22) AS x ) ORDER BY images.Rating ASC, images.id DESC LIMIT 0,30 #Number of runs: 82 Avg time taken: 0.0047898786823924 SELECT images.id, images. [...]

[...] parent.rgt AND parent.id = 16 AND img_categories.img_id=images.id) GROUP BY images.id ORDER BY images.Rating ASC, images.id DESC #Number of runs: 97 Avg time taken: 0.035095794913695 SELECT DISTINCT [...]

[...] WHERE node.lft BETWEEN parent.lft AND parent.rgt AND parent.id = 22) GROUP BY images.id ORDER BY images.id ASC #Number of runs: 71 Avg time taken: 0.027030031446 SELECT images.id, images.Headline, [...]

[...] . Windows Linux / Mac The above script will take all .jpg or .jpeg files in the current directory, resize to 500px on the longest edge, and add an overlay style watermark to the bottom [...]

[...] commands: That will first do a case insensitive search for .jpg files, starting in the current directory, and drilling down to all subdirectories, and putting each file it finds through jpegtran. I [...]

[...] windows and linux shell scripts is quite different, but I also had a problem other than syntax differences. After modifying the script to use linux syntax (e.g. proper loops instead of labels and [...]

[...] post about using scripts created in Windows on Linux, here are some comparisons to show the syntax differences between Windows batch scripts and bash scripts. Comments For loop through files in [...]

[...] The post SVG Image fallback for old browsers appeared first on xoogu. In the process of updating an old site to be [...]

[...] to an image using the composite command: (Click image to view actual image output) If using an SVG image as the watermark you need to add -background none to the command to stop a white background [...]