123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899 |
- #!/bin/bash
- PATH=$PATH:/home/themusicgod1/tools
- BASEDIR=/mnt/disk
- DATABASE=/home/themusicgod1/TDL/urls.db
- DATESTRING=`date +"%m%d"`
- HOME=/home/themusicgod1
- date
- SELECTSTRING="select url from news where level"
- RANDOMME="order by random() limit 1"
- # maximum: 420 (+ 42 420) = 462
- # 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.
- # as of mar 22 2024
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 419 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 418 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 417 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 416 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 415 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 414 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 413 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 412 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 411 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 410 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 409 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 408 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 407 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 406 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 405 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 404 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 403 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 402 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 401 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 400 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 399 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 398 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 397 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 396 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 395 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 394 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 393 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 392 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 391 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 390 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 389 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 388 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 387 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 386 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 385 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 384 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 383 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 382 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 381 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 380 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 379 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 378 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 377 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 376 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 375 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 374 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 373 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 372 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 371 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 370 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 369 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 368 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 367 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 366 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 365 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 364 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 363 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 362 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 361 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 360 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 359 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 358 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 357 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 356 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 355 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 354 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 353 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 352 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 351 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 350 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 349 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 348 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 347 order by random() limit 1" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 300 order by random() limit 32" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 291 order by random() limit 11" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 250 order by random() limit 45" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 200 order by random() limit 55" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 100 order by random() limit 100" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 40 order by random() limit 60" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "SELECT URL FROM NEWS WHERE LEVEL > 1 order by random() limit 40" | awk -F' ' '{print $3}'
- /usr/bin/sqlite3 -line $DATABASE "select url from news order by random() limit 1" | awk -F' ' '{print $3}'
|