[Wildthinks]

Originally posted by Logician

Yes new version parses all smilies and bbcodes. It also formats date fields according to page viewer's time settings. But I must say that I liked your approach to convert unix time in MYSQL query. Also it was a nice idea to php include the show.php to another php file (eg. main page). I must confess that I never thought about that before, congratulations!

THX, see this as a nice example for If-Query in Mysql. That's print different Images...
-----------------------
select (sum(betrag)/69) as rest,if(((sum(betrag)/69)<12),repeat("<img src=""minusmax.gif"" alt=""Sponsormeter..."" name=""Sponsormeter"" id=""Sponsormeter"" border=""0"">",(sum(betrag)/69)),repeat("<img src=""plus.gif"" alt=""Sponsormeter..."" name=""Sponsormeter"" id=""Sponsormeter"" border=""0"">",(sum(betrag)/69))) as images from sponsoring
----------------------------

By the way good news: I really added a very nice feature to the new version. It now accepts outside variables from the user and process them inside webtemplates and more importantly in webqueries. So for example you can design a HTML forum which submits info to a webtemplate and the webqueries in this template will be formed dynamically according to the data your form sent. It seems to work fine in the alpha tests but I really need to work on it a little more. It's really a tricky feature but introduces truly amazing number of possibilities that can be done via this hack.

I 'll be waiting for betatest, Sir! :squareeyed: