#!/bin/sh
echo Content-type:text/html
echo ''
# end header

[ -f '/var/db.dat' ] && DB="/var/db.dat"
[ -f './db.dat' ] && DB='./db.dat'
# with calls from jx.js $1 one does not work, and Query_string = '14&uuid=6543743'
GRP_ID=`echo $QUERY_STRING | cut -d \& -f 1`

echo "<option>-----</option>"
sqlite3 $DB "SELECT FavListInfo.ch_id, channelinfo.fullname
               FROM FavGRPInfo JOIN FavListInfo
                 ON FavGRPInfo.id = FavListInfo.grp_id AND FavGRPInfo.id = $GRP_ID JOIN channelinfo
                 ON FavListInfo.ch_id = channelinfo.id
               ORDER BY FavListInfo.seq" | awk 'BEGIN { FS = "|" }; {printf "<option value=\"%s\">%s</option>\n",$1,$2 }'
