Editing ray

Title / Description

Code
su sqlite3 /data/data/com.android.providers.media/databases/external.db "select _data from files;" | grep "mp3" > /sdcard/log.txt num_strings=`wc -l /sdcard/log.txt` count=0 killall android.process.media killall sqlite3 while read p; do STAT=`stat -c%Y "$p"` p2="${p//\'/\'\'}" QUERY="update files set date_added='$STAT', date_modified='$STAT' where _data like '$p2'" echo "["$count"/"$num_strings"] $p" sqlite3 /data/data/com.android.providers.media/databases/external.db "$QUERY" count=$((count+1)) done < /sdcard/log.txt rm /sdcard/log.txt

Author

Highlight as C C++ CSS Clojure Delphi ERb Groovy (beta) HAML HTML JSON Java JavaScript PHP Plain text Python Ruby SQL XML YAML diff code