mikebuchanon

select le.COURSE_ID, a.LoginName, qdq.sequence [question_number], 
replace(replace(replace(replace(cast(qq.question_text as nvarchar(max)),'<div>',''),'</div>',''),'<b>',''),'</b>','') [question_text], 
case when qpa.value = '1' then 'Strongly Agree'
	when qpa.value = '2' then 'Agree'
	when qpa.value = '3' then 'Neutral'
	when qpa.value = '4' then 'Disagree'
	when qpa.value = '5' then 'Strongly Disagree'
	else qpa.value
end as [response],
qpa.lastModified [last_modified]

mikebuchanon

clear
$regpath = "HKCU:\Software\SimonTatham\PuTTY\Sessions"
$sessions = gci -path $regpath
foreach($session in $sessions){
    $fixedsession = $session -replace 'HKEY_CURRENT_USER','HKCU:'
    $sessionname = Split-Path $fixedsession -Leaf
    Write-Host $($sessionname -replace 'RS:|%20|.public.','')  `t`t    $(Get-ItemProperty -path $fixedsession).HostName
    }

mikebuchanon

<link href="//content.learntoday.info/javascript/smartModal/jquery.smartModal.css" rel="stylesheet" />
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script src="//content.learntoday.info/javascript/smartModal/jquery.smartModal.min.js"></script>
<script src="//content.learntoday.info/javascript/smartModal/jquery.cookie.js"></script>
<script>
$(function() {
  $.smartModal({ overlayDelay: 300, hideDelay: 200, cookieExpires: 365 });
});
</script>
<div class="smartmodal auto once">Exciting Modal window that only shows once.<br>We've updated some stuff!  It's really neat!

mikebuchanon

SELECT c.COURSE_ID,
       lo2.TITLE [folder], lo.TITLE [forum_name],
       dp.AuthorDisplayName,
       dp.Subject,
       CASE
           WHEN dp.PostLevel = 0 THEN 'Post'
           ELSE 'Reply'
       END [post_type]
FROM DiscussionPost dp (nolock)
JOIN DiscussionForum df (nolock) ON df.ForumId=dp.ForumId

mikebuchanon

<script type="text/javascript">// <![CDATA[
var breadcrumb = document.getElementsByClassName('breadcrumb');
var li = document.createElement('li');
var a = document.createElement('a');
var linkText = document.createTextNode("my title text");
var sep = document.createElement('span');
var septext = document.createTextNode("/");

sep.appendChild(septext);
sep.className = "divider";

mikebuchanon

select mb.name as badgename,
mu.username,
to_timestamp(mbi.dateissued) as dateissued
from mdl_badge_issued mbi
join mdl_badge mb on mbi.badgeid=mb.id
join mdl_user mu on mu.id=mbi.userid
order by to_timestamp(mbi.dateissued);

mikebuchanon

select  dl.coursecontext [course_id],
        a.LoginName [user_who_deleted_post], 
        dl.actiondate [date_post_deleted], 
        a2.loginname [user_who_made_post], 
        dp.PostDate [date_posted], 
        dp.Subject [post subject], 
        dp.Body [post] 
from DiscussionLog dl (nolock)
join ACCOUNTS a (nolock) on a.USERNAME=dl.UserId
join DiscussionPost dp (nolock) on dp.PostId=dl.PostId

mikebuchanon

SQLVAR: $course_id$ = [?Enter the Course ID in question]
SQLVAR: $login_name$ = [?Enter the loginname of the student in question]
SQLVAR: $filter$ = [?Enter a filter %quiz 02%, %02%, etc or % for all]
select ll.course_id, a.loginname, lo.TITLE, lo.OBJECT_TYPE, ll.access_date
from LSN_LOGS ll (nolock)
join LSN_OBJECTS lo (nolock) on lo.OBJECT_ID=ll.OBJECT_ID
join ACCOUNTS a on ll.USER_ID=a.USERNAME
where ll.COURSE_ID = $course_id$
and a.LoginName = $login_name$
and lo.TITLE like $filter$

mikebuchanon

-- This script finds a specific user in a specific course
SQLVAR: $COURSE_ID$ = [?Enter a course id]
SQLVAR: $USER_ID$ = [?Enter a user id]
--Execute the script
SELECT * FROM dbo.COURSE_ROSTER WHERE COURSE_ID LIKE $COURSE_ID$ AND USER_ID LIKE $USER_ID$

mikebuchanon

REM Enable Statis File Compression on IIS6 Web Server
REM Requires that adsutil.vbs be installed in c:\inetpub\adminscripts
REM Enable Static File Compression
cscript.exe c:\inetpub\adminscripts\adsutil.vbs set w3svc/filters/compression/parameters/HcDoStaticCompression true

REM Tell server to only use 1G of Space
cscript.exe c:\inetpub\adminscripts\adsutil.vbs set w3svc/filters/compression/parameters/HcDoDiskSpaceLimiting true
cscript.exe c:\inetpub\adminscripts\adsutil.vbs set w3svc/filters/compression/parameters/HcMaxDiskSpaceUsage 1073741824

REM Support got GZIP and DEFLATE for the files with the following extensions