Follow along with the video below to see how to install our site as a web app on your home screen.
Anmerkung: This feature currently requires accessing the site using the built-in Safari browser.
<?
mysql_query("create temporary table vote (plid int not null,three int not null,two int not null,one int not null)");
mysql_query("insert into vote (plid,three) SELECT threestar, count(*) FROM `starvote` group by threestar");
mysql_query("insert into vote (plid,two) SELECT twostar, count(*) FROM `starvote` group by twostar");
mysql_query("insert into vote (plid,one) SELECT onestar, count(*) FROM `starvote` group by onestar");
$res = mysql_query("select plid, sum(three*3)+sum(two*2)+sum(one) as points, sum(three) as three, sum(two) as two, sum(one) as one from vote group by plid order by points desc limit 3");
?>