'new' script for automatic game insertion into database
[perl/schtarr.git] / new
1 #!/bin/sh
2
3 cd /var/log/pvpgn/reports
4 ls -tgG | head -n 5 | tail -n 4
5 read -ep 'report: ' report
6 if [ ! "$report" ]; then
7         report=$(ls -t | head -n 1)
8         echo "Report file unspecified; using $report"
9 fi
10 if [ ! -r "$report" ]; then
11         echo "Report file $report not found"
12 fi
13 cd - > /dev/null
14 echo
15
16 read -p 'replay name: ' name
17 if [ ! "$name" ]; then name=1x2; fi
18 case "$name" in
19 [1-9]x[1-9])
20         name=$(date +%Y%m%d)"bn$name"
21         echo "Only postfix specified; using $name"
22         ;;
23 esac
24 echo
25
26 REPLAYPSET='shiar@shiar.demon.nl:sc.rep/replays/'
27 echo $REPLAYPSET
28 read -p 'replay location: ' replay
29 case "$replay" in
30 *.rep) ;;
31 1 | '')
32         replay="$REPLAYPSET/$name.rep"
33         echo "Using preset replay location $replay"
34         ;;
35 *)
36         replay="$replay/$name.rep"
37         echo Not ending in .rep; using $replay
38         ;;
39 esac
40 echo
41
42 cp -ip "/var/log/pvpgn/reports/$report" "../replay/$name.txt" || exit 1
43 case "$replay" in
44 http:*)
45         wget "$replay" -O "../replay/$name.rep"
46         ;;
47 *@* | *:*)
48         scp -p "$replay" "../replay/$name.rep" || exit 1
49         ;;
50 *)
51         cp -p "$replay" "../replay/$name.rep" || exit 1
52         ;;
53 esac
54
55 ./pvpgnreport ../replay/$name
56 ./screpextract ../replay/$name.rep | ./screp -a ../replay/$name.apm
57 read -p 'retype replay id? ' gameid
58 ./screpextract ../replay/$name.rep | ./screp -d $gameid
59
60 # UPDATE game SET speed = frames*.042 / extract('epoch' FROM COALESCE(duration, durationguess - '15 sec'));
61