grabLaundry.sh 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899
  1. #!/bin/bash
  2. PATH=$PATH:/home/themusicgod1/tools
  3. BASEDIR=/mnt/disk
  4. DATABASE=/home/themusicgod1/TDL/urls.db
  5. DATESTRING=`date +"%m%d"`
  6. HOME=/home/themusicgod1
  7. date
  8. SELECTSTRING="select url from news where level"
  9. RANDOMME="order by random() limit 1"
  10. # maximum: 420 (+ 42 420) = 462
  11. # NOTE UNTIL SPC HARDWRARE PROBLEMS UNDER CONTROL SPC IS MAX 98 NOT 150. (-1 because sherri thinks i'm addicted) -1 from turboretard and sktfm if they get saliance.
  12. # as of mar 22 2024
  13. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 419 order by random() limit 1" | awk -F' ' '{print $3}'
  14. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 418 order by random() limit 1" | awk -F' ' '{print $3}'
  15. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 417 order by random() limit 1" | awk -F' ' '{print $3}'
  16. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 416 order by random() limit 1" | awk -F' ' '{print $3}'
  17. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 415 order by random() limit 1" | awk -F' ' '{print $3}'
  18. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 414 order by random() limit 1" | awk -F' ' '{print $3}'
  19. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 413 order by random() limit 1" | awk -F' ' '{print $3}'
  20. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 412 order by random() limit 1" | awk -F' ' '{print $3}'
  21. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 411 order by random() limit 1" | awk -F' ' '{print $3}'
  22. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 410 order by random() limit 1" | awk -F' ' '{print $3}'
  23. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 409 order by random() limit 1" | awk -F' ' '{print $3}'
  24. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 408 order by random() limit 1" | awk -F' ' '{print $3}'
  25. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 407 order by random() limit 1" | awk -F' ' '{print $3}'
  26. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 406 order by random() limit 1" | awk -F' ' '{print $3}'
  27. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 405 order by random() limit 1" | awk -F' ' '{print $3}'
  28. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 404 order by random() limit 1" | awk -F' ' '{print $3}'
  29. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 403 order by random() limit 1" | awk -F' ' '{print $3}'
  30. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 402 order by random() limit 1" | awk -F' ' '{print $3}'
  31. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 401 order by random() limit 1" | awk -F' ' '{print $3}'
  32. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 400 order by random() limit 1" | awk -F' ' '{print $3}'
  33. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 399 order by random() limit 1" | awk -F' ' '{print $3}'
  34. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 398 order by random() limit 1" | awk -F' ' '{print $3}'
  35. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 397 order by random() limit 1" | awk -F' ' '{print $3}'
  36. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 396 order by random() limit 1" | awk -F' ' '{print $3}'
  37. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 395 order by random() limit 1" | awk -F' ' '{print $3}'
  38. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 394 order by random() limit 1" | awk -F' ' '{print $3}'
  39. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 393 order by random() limit 1" | awk -F' ' '{print $3}'
  40. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 392 order by random() limit 1" | awk -F' ' '{print $3}'
  41. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 391 order by random() limit 1" | awk -F' ' '{print $3}'
  42. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 390 order by random() limit 1" | awk -F' ' '{print $3}'
  43. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 389 order by random() limit 1" | awk -F' ' '{print $3}'
  44. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 388 order by random() limit 1" | awk -F' ' '{print $3}'
  45. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 387 order by random() limit 1" | awk -F' ' '{print $3}'
  46. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 386 order by random() limit 1" | awk -F' ' '{print $3}'
  47. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 385 order by random() limit 1" | awk -F' ' '{print $3}'
  48. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 384 order by random() limit 1" | awk -F' ' '{print $3}'
  49. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 383 order by random() limit 1" | awk -F' ' '{print $3}'
  50. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 382 order by random() limit 1" | awk -F' ' '{print $3}'
  51. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 381 order by random() limit 1" | awk -F' ' '{print $3}'
  52. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 380 order by random() limit 1" | awk -F' ' '{print $3}'
  53. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 379 order by random() limit 1" | awk -F' ' '{print $3}'
  54. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 378 order by random() limit 1" | awk -F' ' '{print $3}'
  55. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 377 order by random() limit 1" | awk -F' ' '{print $3}'
  56. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 376 order by random() limit 1" | awk -F' ' '{print $3}'
  57. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 375 order by random() limit 1" | awk -F' ' '{print $3}'
  58. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 374 order by random() limit 1" | awk -F' ' '{print $3}'
  59. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 373 order by random() limit 1" | awk -F' ' '{print $3}'
  60. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 372 order by random() limit 1" | awk -F' ' '{print $3}'
  61. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 371 order by random() limit 1" | awk -F' ' '{print $3}'
  62. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 370 order by random() limit 1" | awk -F' ' '{print $3}'
  63. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 369 order by random() limit 1" | awk -F' ' '{print $3}'
  64. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 368 order by random() limit 1" | awk -F' ' '{print $3}'
  65. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 367 order by random() limit 1" | awk -F' ' '{print $3}'
  66. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 366 order by random() limit 1" | awk -F' ' '{print $3}'
  67. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 365 order by random() limit 1" | awk -F' ' '{print $3}'
  68. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 364 order by random() limit 1" | awk -F' ' '{print $3}'
  69. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 363 order by random() limit 1" | awk -F' ' '{print $3}'
  70. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 362 order by random() limit 1" | awk -F' ' '{print $3}'
  71. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 361 order by random() limit 1" | awk -F' ' '{print $3}'
  72. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 360 order by random() limit 1" | awk -F' ' '{print $3}'
  73. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 359 order by random() limit 1" | awk -F' ' '{print $3}'
  74. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 358 order by random() limit 1" | awk -F' ' '{print $3}'
  75. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 357 order by random() limit 1" | awk -F' ' '{print $3}'
  76. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 356 order by random() limit 1" | awk -F' ' '{print $3}'
  77. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 355 order by random() limit 1" | awk -F' ' '{print $3}'
  78. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 354 order by random() limit 1" | awk -F' ' '{print $3}'
  79. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 353 order by random() limit 1" | awk -F' ' '{print $3}'
  80. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 352 order by random() limit 1" | awk -F' ' '{print $3}'
  81. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 351 order by random() limit 1" | awk -F' ' '{print $3}'
  82. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 350 order by random() limit 1" | awk -F' ' '{print $3}'
  83. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 349 order by random() limit 1" | awk -F' ' '{print $3}'
  84. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 348 order by random() limit 1" | awk -F' ' '{print $3}'
  85. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 347 order by random() limit 1" | awk -F' ' '{print $3}'
  86. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 300 order by random() limit 32" | awk -F' ' '{print $3}'
  87. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 291 order by random() limit 11" | awk -F' ' '{print $3}'
  88. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 250 order by random() limit 45" | awk -F' ' '{print $3}'
  89. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 200 order by random() limit 55" | awk -F' ' '{print $3}'
  90. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 100 order by random() limit 100" | awk -F' ' '{print $3}'
  91. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 40 order by random() limit 60" | awk -F' ' '{print $3}'
  92. /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 1 order by random() limit 40" | awk -F' ' '{print $3}'
  93. /usr/bin/sqlite3 -line $DATABASE "select url from news order by random() limit 1" | awk -F' ' '{print $3}'