%@ language=VBScript %>
<%
' ///////////////////////////////////////////////////////
' // Dimac CMS
' // Copyright 2004-2008 Dimac Development AB, Sweden
' // www.Dimac.net
' //
' // NOTE:
' // You are not allowed to remove this
' // Copyright information without written
' // permission from Dimac Development.
' ///////////////////////////////////////////////////////
If NOT CBool(Session("ValidAdminUser")) Then
Response.Redirect("../LIO/loggin.asp")
End IF
vInField = Request.QueryString("field")
vDocID = Session("DocID")
vLangID = Request.QueryString("lang")
If vLangID <> "" And IsNumeric(vLangID) Then
vLangID = CInt(vLangID)
Else
If Session("contentLanguage") <> "" And IsNumeric(Session("contentLanguage")) Then
vLangID = Session("contentLanguage")
Else
vLangID = -1
End If
End If
If vInField <> "" Then
vLangID = Session("contentLanguage")
Else
Session("contentLanguage") = vLangID
End If
If Request.QueryString("Docid") <> "" Then
vDocID = Request.QueryString("Docid")
End If
vStartPath = "SiteResources/data/MediaArchive/"
vSubFolder = Request.ServerVariables("SCRIPT_NAME")
vSubFolder = Mid(vSubFolder,1, InStr(LCase(vSubFolder),"/cmsadmin/site/doceditcontent.asp"))
' -------------------------------------------------------
Function GetFieldValue(vField)
Set Conn5 = Server.CreateObject("ADODB.Connection")
Set Rs5 = Server.CreateObject("ADODB.Recordset")
Conn5.Open GetConStr ("..\..\SiteResources\Data\")
SQL5 = "SELECT FieldValue FROM DocumentFIELDS WHERE (DocID=" & vDocID & ") AND (Name='" & vField & "') AND (LangId=" & vLangID & ")"
Rs5.Open SQL5, Conn5
If Not Rs5.EOF And Not Rs5.BOF Then
strResult = Rs5("FieldValue").Value
If InStr(strResult, vStartPath) > 0 And InStr(strResult, vSubFolder&vStartPath) < 1 Then
strResult = Replace(strResult, vStartPath, vSubFolder&vStartPath)
End If
Else
strResult = ""
End If
GetFieldValue = strResult
End Function
' -------------------------------------------------------
' --
' -------------------------------------------------------
Function TranslateDocStatus ( x )
SELECT CASE x
Case 1
TranslateDocStatus = langLabelDocStatusInProgress
Case 2
TranslateDocStatus = langLabelDocStatusSentForApp
Case 3
TranslateDocStatus = langLabelDocStatusRejected
Case 4
TranslateDocStatus = langLabelDocStatusApproved
Case 5
TranslateDocStatus = langLabelDocStatusPublished
Case 6
TranslateDocStatus = langLabelDocStatusExpired
End Select
End Function
' -------------------------------------------------------
' -- get owner ID for a document
' -------------------------------------------------------
Function GetDocOwnerID(vDoc)
Dim Conn, Rs1, StrSql
Set Conn = Server.CreateObject("ADODB.Connection")
Set Rs1 = Server.CreateObject("ADODB.Recordset")
Conn.Open GetConStr ("..\..\SiteResources\Data\")
StrSql = "SELECT CreatedBy FROM Documents WHERE DocumentID = " & vDoc
Rs1.Open StrSql , Conn
If not Rs1.EOF Then
GetDocOwnerID = Rs1("CreatedBy").value
Else
GetDocOwnerID = 0
End IF
rs1.Close
Set Rs1 = Nothing
Set Conn = Nothing
End Function
' -------------------------------------------------------
' -- Get user name
' -------------------------------------------------------
Function GetDocOwnerName(vDoc)
Dim Conn, Rs1, StrSql
Set Conn = Server.CreateObject("ADODB.Connection")
Set Rs1 = Server.CreateObject("ADODB.Recordset")
Conn.Open GetConStr ("..\..\SiteResources\Data\")
StrSql = "SELECT FirstName, LastName FROM Users WHERE UserID = " & vDoc
Rs1.Open StrSql , Conn
If not Rs1.EOF Then
GetDocOwnerName = Rs1("FirstName").value & " " & Rs1("LastName").value
Else
GetDocOwnerName = " "
End IF
rs1.Close
Set Rs1 = Nothing
Set Conn = Nothing
End Function
' -------------------------------------------------------
' -- Get languages
' -------------------------------------------------------
Function GetLanguages()
Dim Conn, Rs3, strSQL, strSep, strContents, strThisLang
Set Conn = Server.CreateObject("ADODB.Connection")
Set Rs3 = Server.CreateObject("ADODB.Recordset")
Conn.Open GetConStr ("..\..\SiteResources\Data\")
strSQL = "SELECT ID, Code, Description, MasterLanguage, LCID, Charset, LanguageImage, IsMenuDirty FROM Languages ORDER BY MasterLanguage DESC, ID"
strSep = ""
strContents= ""
strThisLang=""
Rs3.Open strSQL, Conn, 1, 3
While Not Rs3.EOF
If Rs3("LanguageImage") <> "" Then
strThisLang = " "
strThisLang = strThisLang & " " & Rs3("Code").Value
Else
strThisLang = "" & Rs3("Code").Value & ""
End If
If (vLangID <> -1 And vLangID <> Rs3("ID")) Or (vLangID = -1 And strSep <> "") Then
strThisLang = "" & strThisLang & ""
strThisLang = "