Advertisement
Guest User

some script

a guest
May 22nd, 2019
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. my %stv=qw();
  2. sub getst;1;
  3. sub getst {
  4. my ($esr)=@_;
  5. my $esr0 = substr($esr,0,5);
  6. if($stv{$esr}) {
  7. print " ST $esr already loaded\n";
  8. return;
  9. }
  10. my $url=$base."/free_car/proc_n.php?p_sop=".$esr0;
  11. my $pg=get $url,"gioc_st$esr0";
  12. $stv{$esr} = 1;
  13. my ($esr1, $name) = $pg=~m#size=2>(\d+)\s*(.*?)<#;
  14. if (!$name) {
  15. print " station $esr not found!\n";
  16. return;
  17. }
  18. print " ST [$esr1] [$name]\n";
  19. die "OOPS" if $esr1 ne $esr0;
  20. $dbh->do("INSERT INTO gioc_st (esr,name) VALUES ('$esr','$name')") unless $noact;
  21. }
  22.  
  23. system "mkdir -p cache";
  24. dbinit;
  25.  
  26. my $sth = $dbh->prepare("SELECT esr FROM stations WHERE region_id IN (SELECT id FROM regions WHERE country='Украина')");
  27. $sth->execute;
  28. while (my ($esr) = $sth->fetchrow_array) {
  29. getst $esr;
  30. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement