williamjacksn

select
    user_id,
    user_type,
    username,
    timestamp with time zone 'epoch' + user_regdate * interval '1 second' as registration_date,
    timestamp with time zone 'epoch' + user_lastvisit * interval '1 second' as last_visit,
    user_posts,
    radio_inactive
from
    phpbb_users

williamjacksn

select
  max(sid),
  song_filename
from
  rw_songs
where 
  song_verified is true
group by
  song_filename
having

williamjacksn

select
  case rw_songs.sid
    when 1 then 'Game'
    when 2 then 'OCReMix'
    when 3 then 'Covers'
    when 4 then 'Chiptune'
    else 'All'
  end as "Channel",
  album_id as "Album ID",
  album_name as "Album Title",

williamjacksn

select
    min(rw_songs.sid) as "Channel ID",
    min(album_id) as "Album ID",
    min(album_name) as "Album Title",
    song_id as "Song ID",
    min(song_title) as "Song Title",
    array_agg(artist_name) as "Artist",
    oac_name as "Cooldown Group",
    min(song_rating_avg) as "Average Rating",
    timestamp with time zone 'epoch' + min(song_addedon) * interval '1 second' as "Song Added On"

williamjacksn

delete from
  r4_song_ratings
where
  ctid in (
    select
      min(ctid)
    from
      r4_song_ratings
    where
      user_id = %s and

williamjacksn

' BitLocker Status Script by William Jackson ([email protected])
' Useful as an Absolute Manage Custom Information Field (CIF)

cif = ""

Set s = CreateObject("WScript.Shell")
Set e = s.Exec("manage-bde -status")
Set status = e.StdOut

Do While status.AtEndOfStream <> True

williamjacksn

select
    rw_albums.sid,
    album_name,
    count(song_id) as num_songs,
    sum(song_secondslong) as total_song_length
from
    rw_albums
        join
    rw_songs using (album_id)
where

williamjacksn

select
	rw_songs.sid,
	album_name,
	song_title,
	song_rating,
	case when f.user_id = 9575 then true else false end as fav
from
	rw_songratings
		join
	rw_songs using (song_id)

williamjacksn

select
	song_title,
	album_name,
	song_totalrequests,
	song_rating_avg,
	rw_songs.sid
from
	rw_songs
		join
	rw_albums using (album_id)

williamjacksn

$app_name = "*flash player*"
$app_ver = "10.3.183.5"
$reg_uninstall_keys = "hklm:software\wow6432node\microsoft\windows\currentversion\uninstall", "hklm:\software\microsoft\windows\currentversion\uninstall"
[array]$compliant = (
    $reg_uninstall_keys | foreach-object {
        if (test-path $_) {
            get-childitem $_ | get-itemproperty | select-object displayname, displayversion
        }
    }
) | where-object {$_.displayname -like $app_name -and $_.displayversion -eq $application_version}