- my $query = $dbh->prepare(q{SELECT DISTINCT ON(rid) tick,category,name,amount
- FROM planet_data pd JOIN planet_data_types pdt ON pd.rid = pdt.id
- WHERE pd.id = $1 ORDER BY rid,tick DESC
- });
- $query->execute($id);
- $c->stash(planetdata => $query->fetchall_arrayref({}) );
+ $c->stash(planetscan => $dbh->selectrow_hashref(q{SELECT *
+ FROM current_planet_scans WHERE planet = $1},undef,$id));
+ $c->stash(structurescan => $dbh->selectrow_hashref(q{SELECT *
+ FROM current_structure_scans WHERE planet = $1},undef,$id));
+ $c->stash(techscan => $dbh->selectrow_hashref(q{SELECT *
+ FROM current_tech_scans WHERE planet = $1},undef,$id));