Forum 

Forum AspNuke.it - Il tuo Portale OpenSource in ASP

mercatino

Autore Messaggio
Sampy

Utente
Utente
99 Discussioni



Profilo - Sampy
03 giugno 2005 alle 22:55:31 Profilo - SampyInvia un messaggio privato Rispondi quotando
ciao a ttt,
ho istallato
questo mod ma mi sembra che non funzioni come dovrebbe.
e mi sembra di ave capito che devo inserire delle categorie con un database!?
chi puo darmi una mano

http://www.sampy.it/mercatino.asp (?)
---------------

http://www.sampy.it
djveleno

Amministratore

Esperto
Esperto
1025 Discussioni



Profilo - djveleno
04 giugno 2005 alle 11:35:02 Profilo - djvelenoInvia un messaggio privato Rispondi quotando
Il mercatino è un programma completo, con tanto di DB accluso, non è un semplice MOD, l'installazione del mercatino è abbastanza semplice, comunque vi è compreso anche un file di testo che spiega dove inserire i vari files.
Il MOD successivo è quello che è stato pubblicato qui, in download, e che serve a visualizzare le ultime 5 inserzioni in home page.
Ciauzz DJ
---------------
A lavare la testa ai somari, ci si rimette l'acqua e il sapone!

http://aspnuke208.somee.com/Default.asp

Sampy

Utente
Utente
99 Discussioni



Profilo - Sampy
06 giugno 2005 alle 19:36:42 Profilo - SampyInvia un messaggio privato Rispondi quotando
...ok
ma da dove devo inserire le categorie?
un'altra cosa in amministrazione nn c'è la voce mercatino
e anche.....insomma mome lo faccio funzinoare?!
---------------

http://www.sampy.it
djveleno

Amministratore

Esperto
Esperto
1025 Discussioni



Profilo - djveleno
06 giugno 2005 alle 19:48:47 Profilo - djvelenoInvia un messaggio privato Rispondi quotando
La voce mercatino, in amministrazione va aggiunta amano, modificando il file CONTROLPANEL.XML.
Una volta creato il link, potrai aggiungere le categorie al mercatino.
Ciauzz DJ
---------------
A lavare la testa ai somari, ci si rimette l'acqua e il sapone!

http://aspnuke208.somee.com/Default.asp

Sampy

Utente
Utente
99 Discussioni



Profilo - Sampy
06 giugno 2005 alle 20:42:55 Profilo - SampyInvia un messaggio privato Rispondi quotando
scusami ma visto che sono un ignorante (nn sbuffare)
come è il codice che devo inserire?...


...poi potresti controlare questo codice è il file "admin_allinfo-inc" mi da dei problemi nella sezione amministrazione

<%
' ************************************************************************
' * ASPNUKE: Free web portal in ASP *
' ************************************************************************
' * ASP-Nuke 2.0 Copyright (c) 2004 by Aspnuke.it Staff *
' * (staff@aspnuke.it) http://www.aspnuke.it *
' * *
' * Re-design by Enrico Musante (c) 2004 (emu@libero.it) *
' * Re-design by Frank Zalabard (c) 2004 (fsarzana@hotmail.com) *
' * Re-Design by Emanuele Libertini (c) 2004 (infoz@searchwarezz.net) *
' * *
' * ASP-Nuke 1.0, 1.1, 1.2 Copyright (c) 2002-2003 by Gaetan Bouveret *
' * (webmaster@asp-nuke.com) http://www.asp-nuke.com *
' * *
' * This program is free software. You can redistribute it and/or modify *
' * it under the terms of the GNU General Public License as published by *
' * the Free Software Foundation; either version 2 of the License, or *
' * (at your option) any later version. *
' * *
' ************************************************************************
%>
<%
' Gives information since the last visit
Sub AllInfo()
Dim oCn, oCn1, oRs, oRs1, rSQL, rSQL1, iLine, sTemp

Set oCn = DBConnexion(DB_MAIN)

Set oCn1 = DBConnexion(DB_MERCATINO)


CreateTable "LastVisit", Replace(GetTranslation("LANG_TITLE_DEFAULT2"), "%1%", Server.HTMLEncode(sPseudo)), Replace(GetTranslation("LANG_LAST_VISIT"), "%1%", GetDateLitteralDDMMYYYYHHMMSS(StringToDate(sLastVisit))), ""


If GLOBAL_NEWS_TOP > 0 Then
' Last news
rSQL = "SELECT nID, nTitle, nAuthor, nDate FROM news where nValid=1 AND nDate > '" & sLastVisit & "' ORDER BY nDate DESC"
Set oRs = DBRecordSet(oCn, rSQL)

If Not oRs.EOF Then
CreateTopTable "LastNews", GetTranslation("LANG_NEWS")
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td>" & GetTranslation("LANG_TITLE") & "</td>" & vbCRLF
Response.Write " <td width=""100"" align=""center"">" & GetTranslation("LANG_AUTHOR") & "</td>" & vbCRLF
Response.Write " <td width=""120"" align=""center"">" & GetTranslation("LANG_DATE") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = 1
iLoop = 0
While Not oRs.EOF And iLoop < 10
Response.Write " <tr class=""tableline" & iLine & """>" & vbCRLF
Response.Write " <td><a href=""" & GLOBAL_SITE_ADMIN_PATH & GLOBAL_SITE_NEWS_PAGE & "?do=view&id=" & oRs("nID") & """>" & CodeMessage(oRs("nTitle"), True) & "</a></td>" & vbCRLF
Response.Write " <td align=""center"">" & Server.HTMLEncode(oRs("nAuthor")) & "</td>" & vbCRLF
Response.Write " <td align=""center"" width=""120"">" & GetDateDDMMYYYY(StringToDate(oRs("nDate"))) & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = ((iLine - 1) XOr 1) + 1
oRs.MoveNext
iLoop = iLoop + 1
Wend
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If

oRs.Close
Set oRs = Nothing

'Invalid news
rSQL = "SELECT nID, nTitle, nAuthor, nDate FROM news where nValid=0 ORDER BY nDate DESC"
Set oRs = DBRecordSet(oCn, rSQL)

If Not oRs.EOF Then
CreateTopTable "InvalidNews", GetTranslation("LANG_NEWS") & " - " & GetTranslation("LANG_TO_VALIDATE")
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td>" & GetTranslation("LANG_TITLE") & "</td>" & vbCRLF
Response.Write " <td width=""100"" align=""center"">" & GetTranslation("LANG_AUTHOR") & "</td>" & vbCRLF
Response.Write " <td width=""120"" align=""center"">" & GetTranslation("LANG_DATE") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = 1
iLoop = 0
While Not oRs.EOF And iLoop < 10
Response.Write " <tr class=""tableline" & iLine & """>" & vbCRLF
Response.Write " <td><a href=""" & GLOBAL_SITE_ADMIN_PATH & GLOBAL_SITE_NEWS_PAGE & "?do=view&id=" & oRs("nID") & """>" & CodeMessage(oRs("nTitle"), True) & "</a></td>" & vbCRLF
Response.Write " <td align=""center"">" & Server.HTMLEncode(oRs("nAuthor")) & "</td>" & vbCRLF
Response.Write " <td align=""center"" width=""120"">" & GetDateDDMMYYYY(StringToDate(oRs("nDate"))) & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = ((iLine - 1) XOr 1) + 1
oRs.MoveNext
iLoop = iLoop + 1
Wend
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If

oRs.Close
Set oRs = Nothing



' Last comments
rSQL = "SELECT cID, cAuthor, cRate, cType, cText FROM comments where cValid=1 AND cDate > '" & sLastVisit & "' ORDER BY cDate DESC"
Set oRs = DBRecordSet(oCn, rSQL)

If Not oRs.EOF Then
CreateTopTable "LastComments", GetTranslation("LANG_COMMENTS")
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td width=""100"">" & GetTranslation("LANG_AUTHOR") & "</td>" & vbCRLF
Response.Write " <td>" & GetTranslation("LANG_TEXT") & "</td>" & vbCRLF
Response.Write " <td width=""120"" align=""center"">" & GetTranslation("LANG_TYPE") & "</td>" & vbCRLF
Response.Write " <td width=""80"" align=""center"">" & GetTranslation("LANG_RATING") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = 1
iLoop = 0
While Not oRs.EOF And iLoop < 10
sTemp = oRs("cText")
Response.Write " <tr class=""tableline" & iLine & """>" & vbCRLF
Response.Write " <td>"
If oRs("cAuthor") = "" Then
Response.Write GetTranslation("LANG_ANONYM")
Else
Response.Write Server.HTMLEncode(oRs("cAuthor"))
End If
Response.Write "</td>" & vbCRLF
Response.Write " <td><a href=""" & GLOBAL_SITE_ADMIN_PATH & GLOBAL_SITE_COMMENTS_PAGE & "?do=view&id=" & oRs("cID") & """>" & CodeMessageEx(sTemp, 40, True, True) & "</a></td>" & vbCRLF
Response.Write " <td align=""center"">"
Select Case oRs("cType")
Case CATEGORY_TYPE_NEWS
Response.Write GetTranslation("LANG_NEWS")
Case CATEGORY_TYPE_DOWNLOADS
Response.Write GetTranslation("LANG_DOWNLOADS")
Case CATEGORY_TYPE_DIRECTORY
Response.Write GetTranslation("LANG_DIRECTORY")
Case CATEGORY_TYPE_IMAGES
Response.Write GetTranslation("LANG_IMAGES")
Case CATEGORY_TYPE_ARTICLES
Response.Write GetTranslation("LANG_ARTICLES")
Case Else
Response.Write "-"
End Select
Response.Write "</td>" & vbCRLF
Response.Write " <td align=""center""><img src=""" & GLOBAL_SITE_IMAGES_PATH & "rate_" & oRs("cRate") & ".gif"" border=""0""></td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = ((iLine - 1) XOr 1) + 1
oRs.MoveNext
iLoop = iLoop + 1
Wend
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If
oRs.Close
Set oRs = Nothing


' Invalid comments
rSQL = "SELECT cID, cAuthor, cRate, cType, cText FROM comments where cValid=0 ORDER BY cDate DESC"
Set oRs = DBRecordSet(oCn, rSQL)

If Not oRs.EOF Then
CreateTopTable "InvalidComments", GetTranslation("LANG_COMMENTS") & " - " & GetTranslation("LANG_TO_VALIDATE")
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td width=""100"">" & GetTranslation("LANG_AUTHOR") & "</td>" & vbCRLF
Response.Write " <td>" & GetTranslation("LANG_TEXT") & "</td>" & vbCRLF
Response.Write " <td width=""120"" align=""center"">" & GetTranslation("LANG_TYPE") & "</td>" & vbCRLF
Response.Write " <td width=""80"" align=""center"">" & GetTranslation("LANG_RATING") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = 1
iLoop = 0
While Not oRs.EOF And iLoop < 10
sTemp = oRs("cText")
Response.Write " <tr class=""tableline" & iLine & """>" & vbCRLF
Response.Write " <td>"
If oRs("cAuthor") = "" Then
Response.Write GetTranslation("LANG_ANONYM")
Else
Response.Write Server.HTMLEncode(oRs("cAuthor"))
End If
Response.Write "</td>" & vbCRLF
Response.Write " <td><a href=""" & GLOBAL_SITE_ADMIN_PATH & GLOBAL_SITE_COMMENTS_PAGE & "?do=view&id=" & oRs("cID") & """>" & CodeMessageEx(sTemp, 40, True, True) & "</a></td>" & vbCRLF
Response.Write " <td align=""center"">"
Select Case oRs("cType")
Case CATEGORY_TYPE_NEWS
Response.Write GetTranslation("LANG_NEWS")
Case CATEGORY_TYPE_DOWNLOADS
Response.Write GetTranslation("LANG_DOWNLOADS")
Case CATEGORY_TYPE_DIRECTORY
Response.Write GetTranslation("LANG_DIRECTORY")
Case CATEGORY_TYPE_IMAGES
Response.Write GetTranslation("LANG_IMAGES")
Case CATEGORY_TYPE_ARTICLES
Response.Write GetTranslation("LANG_ARTICLES")
Case Else
Response.Write "-"
End Select
Response.Write "</td>" & vbCRLF
Response.Write " <td align=""center""><img src=""" & GLOBAL_SITE_IMAGES_PATH & "rate_" & oRs("cRate") & ".gif"" border=""0""></td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = ((iLine - 1) XOr 1) + 1
oRs.MoveNext
iLoop = iLoop + 1
Wend
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If
oRs.Close
Set oRs = Nothing

End If

If GLOBAL_ARTICLES_TOP > 0 Then
' Last articles
rSQL = "SELECT arID, arTitle, arAuthor, arDate FROM articles where arValid=1 AND arDate > '" & sLastVisit & "' ORDER BY arDate DESC"
Set oRs = DBRecordSet(oCn, rSQL)

If Not oRs.EOF Then
CreateTopTable "LastArticles", GetTranslation("LANG_ARTICLES")
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td>" & GetTranslation("LANG_TITLE") & "</td>" & vbCRLF
Response.Write " <td width=""100"" align=""center"">" & GetTranslation("LANG_AUTHOR") & "</td>" & vbCRLF
Response.Write " <td width=""120"" align=""center"">" & GetTranslation("LANG_DATE") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = 1
iLoop = 0
While Not oRs.EOF And iLoop < 10
Response.Write " <tr class=""tableline" & iLine & """>" & vbCRLF
Response.Write " <td><a href=""" & GLOBAL_SITE_ADMIN_PATH & GLOBAL_SITE_ARTICLES_PAGE & "?do=view&id=" & oRs("arID") & """>" & CodeMessage(oRs("arTitle"), True) & "</a></td>" & vbCRLF
Response.Write " <td align=""center"" width=""100"">" & Server.HTMLEncode(oRs("arAuthor")) & "</td>" & vbCRLF
Response.Write " <td align=""center"" width=""120"">" & GetDateDDMMYYYY(StringToDate(oRs("arDate"))) & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = ((iLine - 1) XOr 1) + 1
oRs.MoveNext
iLoop = iLoop + 1
Wend
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If
oRs.Close
Set oRs = Nothing

' Invalid articles
rSQL = "SELECT arID, arTitle, arAuthor, arDate FROM articles where arValid=0 ORDER BY arDate DESC"
Set oRs = DBRecordSet(oCn, rSQL)

If Not oRs.EOF Then
CreateTopTable "InvalidArticles", GetTranslation("LANG_ARTICLES") & " - " & GetTranslation("LANG_TO_VALIDATE")
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td>" & GetTranslation("LANG_TITLE") & "</td>" & vbCRLF
Response.Write " <td width=""100"" align=""center"">" & GetTranslation("LANG_AUTHOR") & "</td>" & vbCRLF
Response.Write " <td width=""120"" align=""center"">" & GetTranslation("LANG_DATE") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = 1
iLoop = 0
While Not oRs.EOF And iLoop < 10
Response.Write " <tr class=""tableline" & iLine & """>" & vbCRLF
Response.Write " <td><a href=""" & GLOBAL_SITE_ADMIN_PATH & GLOBAL_SITE_ARTICLES_PAGE & "?do=view&id=" & oRs("arID") & """>" & CodeMessage(oRs("arTitle"), True) & "</a></td>" & vbCRLF
Response.Write " <td align=""center"" width=""100"">" & Server.HTMLEncode(oRs("arAuthor")) & "</td>" & vbCRLF
Response.Write " <td align=""center"" width=""120"">" & GetDateDDMMYYYY(StringToDate(oRs("arDate"))) & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = ((iLine - 1) XOr 1) + 1
oRs.MoveNext
iLoop = iLoop + 1
Wend
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If
oRs.Close
Set oRs = Nothing
End If

If GLOBAL_DOWNLOADS_TOP > 0 Then
' Last downloads
rSQL = "SELECT dID, dTitle, dHits, cTitle, vCode FROM downloads, categories, versions where dCategory=cID AND dVersion=vID AND dValid=1 AND dDate > '" & sLastVisit & "' ORDER BY dDate DESC"
Set oRs = DBRecordSet(oCn, rSQL)

If Not oRs.EOF Then
CreateTopTable "LastDownloads", GetTranslation("LANG_DOWNLOADS")
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td>" & GetTranslation("LANG_TITLE") & "</td>" & vbCRLF
Response.Write " <td width=""150"" align=""center"">" & GetTranslation("LANG_CATEGORY") & "</td>" & vbCRLF
Response.Write " <td width=""50"" align=""center"">" & GetTranslation("LANG_VERSION") & "</td>" & vbCRLF
Response.Write " <td width=""50"" align=""center"">" & GetTranslation("LANG_HITS") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = 1
iLoop = 0
While Not oRs.EOF And iLoop < 10
Response.Write " <tr class=""tableline" & iLine & """>" & vbCRLF
Response.Write " <td><a href=""" & GLOBAL_SITE_ADMIN_PATH & GLOBAL_SITE_DOWNLOADS_PAGE & "?do=view&id=" & oRs("dID") & """>" & Server.HTMLEncode(oRs("dTitle")) & "</a></td>" & vbCRLF
Response.Write " <td align=""center"">" & Server.HTMLEncode(oRs("cTitle")) & "</td>" & vbCRLF
Response.Write " <td align=""center"">" & Server.HTMLEncode(oRs("vCode")) & "</td>" & vbCRLF
Response.Write " <td align=""center"">" & oRs("dHits") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = ((iLine - 1) XOr 1) + 1
oRs.MoveNext
iLoop = iLoop + 1
Wend
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If
oRs.Close
Set oRs = Nothing
' Invalid downloads
rSQL = "SELECT dID, dTitle, dHits, cTitle, vCode FROM downloads, categories, versions where dCategory=cID AND dVersion=vID AND dValid=0 ORDER BY dDate DESC"
Set oRs = DBRecordSet(oCn, rSQL)

If Not oRs.EOF Then
CreateTopTable "InvalidDownloads", GetTranslation("LANG_DOWNLOADS") & " - " & GetTranslation("LANG_TO_VALIDATE")
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td>" & GetTranslation("LANG_TITLE") & "</td>" & vbCRLF
Response.Write " <td width=""150"" align=""center"">" & GetTranslation("LANG_CATEGORY") & "</td>" & vbCRLF
Response.Write " <td width=""50"" align=""center"">" & GetTranslation("LANG_VERSION") & "</td>" & vbCRLF
Response.Write " <td width=""50"" align=""center"">" & GetTranslation("LANG_HITS") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = 1
iLoop = 0
While Not oRs.EOF And iLoop < 10
Response.Write " <tr class=""tableline" & iLine & """>" & vbCRLF
Response.Write " <td><a href=""" & GLOBAL_SITE_ADMIN_PATH & GLOBAL_SITE_DOWNLOADS_PAGE & "?do=view&id=" & oRs("dID") & """>" & Server.HTMLEncode(oRs("dTitle")) & "</a></td>" & vbCRLF
Response.Write " <td align=""center"">" & Server.HTMLEncode(oRs("cTitle")) & "</td>" & vbCRLF
Response.Write " <td align=""center"">" & Server.HTMLEncode(oRs("vCode")) & "</td>" & vbCRLF
Response.Write " <td align=""center"">" & oRs("dHits") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = ((iLine - 1) XOr 1) + 1
oRs.MoveNext
iLoop = iLoop + 1
Wend
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If
oRs.Close
Set oRs = Nothing
End If

If GLOBAL_DIRECTORY_TOP > 0 Then
' Last websites in directory
rSQL = "SELECT dID, dTitle, dURL, dValid, dCategory, vCode, cTitle FROM directory, versions, categories WHERE dCategory=cID AND dVersion=vID AND dValid=1 AND dDate > '" & sLastVisit & "' ORDER BY dDate DESC"
Set oRs = DBRecordSet(oCn, rSQL)

If Not oRs.EOF Then
CreateTopTable "LastWebsites", GetTranslation("LANG_DIRECTORY")
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td width=""100"">" & GetTranslation("LANG_TITLE") & "</td>" & vbCRLF
Response.Write " <td>" & GetTranslation("LANG_URL") & "</td>" & vbCRLF
Response.Write " <td width=""150"" align=""center"">" & GetTranslation("LANG_CATEGORY") & "</td>" & vbCRLF
Response.Write " <td width=""50"" align=""center"">" & GetTranslation("LANG_VERSION") & "</td>" & vbCRLF
Response.Write " <td width=""50"" align=""center"">" & GetTranslation("LANG_VALID") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = 1
iLoop = 0
While Not oRs.EOF And iLoop < 10
Response.Write " <tr class=""tableline" & iLine & """>" & vbCRLF
Response.Write " <td><a href=""" & GLOBAL_SITE_ADMIN_PATH & GLOBAL_SITE_DIRECTORY_PAGE & "?do=view&id=" & oRs("dID") & "&cat=" & oRs("dCategory") & """>" & Server.HTMLEncode(oRs("dTitle")) & "</a></td>" & vbCRLF
Response.Write " <td><a href=""" & Server.HTMLEncode(oRs("dURL")) & """ target=_""blank"">" & Server.HTMLEncode(oRs("dURL")) & "</a></td>" & vbCRLF
Response.Write " <td width=""150"" align=""center"">" & Server.HTMLEncode(oRs("cTitle")) & "</td>" & vbCRLF
Response.Write " <td width=""50"" align=""center"">" & Server.HTMLEncode(oRs("vCode")) & "</td>" & vbCRLF
Response.Write " <td width=""50"" align=""center"">" & oRs("dValid") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = ((iLine - 1) XOr 1) + 1
oRs.MoveNext
iLoop = iLoop + 1
Wend
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If
oRs.Close
Set oRs = Nothing

' Invalid websites in directory
rSQL = "SELECT dID, dTitle, dURL, dValid, dCategory, vCode, cTitle FROM directory, versions, categories WHERE dCategory=cID AND dVersion=vID AND dValid=0 ORDER BY dDate DESC"
Set oRs = DBRecordSet(oCn, rSQL)

If Not oRs.EOF Then
CreateTopTable "IvalidWebsites", GetTranslation("LANG_DIRECTORY") & " - " & GetTranslation("LANG_TO_VALIDATE")
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td width=""100"">" & GetTranslation("LANG_TITLE") & "</td>" & vbCRLF
Response.Write " <td>" & GetTranslation("LANG_URL") & "</td>" & vbCRLF
Response.Write " <td width=""150"" align=""center"">" & GetTranslation("LANG_CATEGORY") & "</td>" & vbCRLF
Response.Write " <td width=""50"" align=""center"">" & GetTranslation("LANG_VERSION") & "</td>" & vbCRLF
Response.Write " <td width=""50"" align=""center"">" & GetTranslation("LANG_VALID") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = 1
iLoop = 0
While Not oRs.EOF And iLoop < 10
Response.Write " <tr class=""tableline" & iLine & """>" & vbCRLF
Response.Write " <td><a href=""" & GLOBAL_SITE_ADMIN_PATH & GLOBAL_SITE_DIRECTORY_PAGE & "?do=view&id=" & oRs("dID") & "&cat=" & oRs("dCategory") & """>" & Server.HTMLEncode(oRs("dTitle")) & "</a></td>" & vbCRLF
Response.Write " <td><a href=""" & Server.HTMLEncode(oRs("dURL")) & """ target=_""blank"">" & Server.HTMLEncode(oRs("dURL")) & "</a></td>" & vbCRLF
Response.Write " <td width=""150"" align=""center"">" & Server.HTMLEncode(oRs("cTitle")) & "</td>" & vbCRLF
Response.Write " <td width=""50"" align=""center"">" & Server.HTMLEncode(oRs("vCode")) & "</td>" & vbCRLF
Response.Write " <td width=""50"" align=""center"">" & oRs("dValid") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = ((iLine - 1) XOr 1) + 1
oRs.MoveNext
iLoop = iLoop + 1
Wend
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If
oRs.Close
Set oRs = Nothing
End If

If GLOBAL_IMAGES_TOP > 0 Then
' Last images
rSQL = "SELECT iID, iTitle, iHits, cTitle, vCode FROM images, categories, versions where iCategory=cID AND iVersion=vID AND iValid=1 AND iDate > '" & sLastVisit & "' ORDER BY iDate DESC"
Set oRs = DBRecordSet(oCn, rSQL)

If Not oRs.EOF Then
CreateTopTable "LastImages", GetTranslation("LANG_IMAGES")
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td>" & GetTranslation("LANG_TITLE") & "</td>" & vbCRLF
Response.Write " <td width=""150"" align=""center"">" & GetTranslation("LANG_CATEGORY") & "</td>" & vbCRLF
Response.Write " <td width=""50"" align=""center"">" & GetTranslation("LANG_VERSION") & "</td>" & vbCRLF
Response.Write " <td width=""50"" align=""center"">" & GetTranslation("LANG_HITS") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = 1
iLoop = 0
While Not oRs.EOF And iLoop < 10
Response.Write " <tr class=""tableline" & iLine & """>" & vbCRLF
Response.Write " <td><a href=""" & GLOBAL_SITE_ADMIN_PATH & GLOBAL_SITE_IMAGES_PAGE & "?do=view&id=" & oRs("iID") & """>" & Server.HTMLEncode(oRs("iTitle")) & "</a></td>" & vbCRLF
Response.Write " <td align=""center"">" & Server.HTMLEncode(oRs("cTitle")) & "</td>" & vbCRLF
Response.Write " <td align=""center"">" & Server.HTMLEncode(oRs("vCode")) & "</td>" & vbCRLF
Response.Write " <td align=""center"">" & oRs("iHits") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = ((iLine - 1) XOr 1) + 1
oRs.MoveNext
iLoop = iLoop + 1
Wend
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If
oRs.Close
Set oRs = Nothing
' Invalid images
rSQL = "SELECT iID, iTitle, iHits, cTitle, vCode FROM images, categories, versions where iCategory=cID AND iVersion=vID AND iValid=0 ORDER BY iDate DESC"
Set oRs = DBRecordSet(oCn, rSQL)

If Not oRs.EOF Then
CreateTopTable "InvalidImages", GetTranslation("LANG_IMAGES") & " - " & GetTranslation("LANG_TO_VALIDATE")
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td>" & GetTranslation("LANG_TITLE") & "</td>" & vbCRLF
Response.Write " <td width=""150"" align=""center"">" & GetTranslation("LANG_CATEGORY") & "</td>" & vbCRLF
Response.Write " <td width=""50"" align=""center"">" & GetTranslation("LANG_VERSION") & "</td>" & vbCRLF
Response.Write " <td width=""50"" align=""center"">" & GetTranslation("LANG_HITS") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = 1
iLoop = 0
While Not oRs.EOF And iLoop < 10
Response.Write " <tr class=""tableline" & iLine & """>" & vbCRLF
Response.Write " <td><a href=""" & GLOBAL_SITE_ADMIN_PATH & GLOBAL_SITE_IMAGES_PAGE & "?do=view&id=" & oRs("iID") & """>" & Server.HTMLEncode(oRs("iTitle")) & "</a></td>" & vbCRLF
Response.Write " <td align=""center"">" & Server.HTMLEncode(oRs("cTitle")) & "</td>" & vbCRLF
Response.Write " <td align=""center"">" & Server.HTMLEncode(oRs("vCode")) & "</td>" & vbCRLF
Response.Write " <td align=""center"">" & oRs("iHits") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = ((iLine - 1) XOr 1) + 1
oRs.MoveNext
iLoop = iLoop + 1
Wend
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If
oRs.Close
Set oRs = Nothing
End If

If GLOBAL_POLLS_TOP > 0 Then
' Last polls
rSQL = "SELECT pID, pDateBegin, pDateEnd, pTitle FROM polls where pValid=1 AND pDateBegin > '" & sLastVisit & "' AND pValid=1 ORDER BY pDateBegin DESC, pDateEnd DESC"
Set oRs = DBRecordSet(oCn, rSQL)

If Not oRs.EOF Then
CreateTopTable "LastPolls", GetTranslation("LANG_POLLS")
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td>" & GetTranslation("LANG_TITLE") & "</td>" & vbCRLF
Response.Write " <td width=""100"" align=""center"">" & GetTranslation("LANG_DATE_BEGIN") & "</td>" & vbCRLF
Response.Write " <td width=""100"" align=""center"">" & GetTranslation("LANG_DATE_END") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = 1
iLoop = 0
While Not oRs.EOF And iLoop < 10
Response.Write " <tr class=""tableline" & iLine & """>" & vbCRLF
Response.Write " <td><a href=""" & GLOBAL_SITE_ADMIN_PATH & GLOBAL_SITE_POLLS_PAGE & "?do=view&id=" & oRs("pID") & """>" & Server.HTMLEncode(oRs("pTitle")) & "</a></td>" & vbCRLF
Response.Write " <td align=""center"">" & StringToDate(oRs("pDateBegin")) & "</td>" & vbCRLF
Response.Write " <td align=""center"">" & StringToDate(oRs("pDateEnd")) & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = ((iLine - 1) XOr 1) + 1
oRs.MoveNext
iLoop = iLoop + 1
Wend
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If
oRs.Close
Set oRs = Nothing
' Invalid polls
rSQL = "SELECT pID, pDateBegin, pDateEnd, pTitle FROM polls where pValid=0 ORDER BY pDateBegin DESC, pDateEnd DESC"
Set oRs = DBRecordSet(oCn, rSQL)

If Not oRs.EOF Then
CreateTopTable "InvalidPolls", GetTranslation("LANG_POLLS") & " - " & GetTranslation("LANG_TO_VALIDATE")
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td>" & GetTranslation("LANG_TITLE") & "</td>" & vbCRLF
Response.Write " <td width=""100"" align=""center"">" & GetTranslation("LANG_DATE_BEGIN") & "</td>" & vbCRLF
Response.Write " <td width=""100"" align=""center"">" & GetTranslation("LANG_DATE_END") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = 1
iLoop = 0
While Not oRs.EOF And iLoop < 10
Response.Write " <tr class=""tableline" & iLine & """>" & vbCRLF
Response.Write " <td><a href=""" & GLOBAL_SITE_ADMIN_PATH & GLOBAL_SITE_POLLS_PAGE & "?do=view&id=" & oRs("pID") & """>" & Server.HTMLEncode(oRs("pTitle")) & "</a></td>" & vbCRLF
Response.Write " <td align=""center"">" & StringToDate(oRs("pDateBegin")) & "</td>" & vbCRLF
Response.Write " <td align=""center"">" & StringToDate(oRs("pDateEnd")) & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = ((iLine - 1) XOr 1) + 1
oRs.MoveNext
iLoop = iLoop + 1
Wend
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If
oRs.Close
Set oRs = Nothing
End If

' Last accounts
rSQL = "SELECT uLogin, uEMail, uURL, rTitle FROM users, roles where uRole=rID AND uDate > '" & sLastVisit & "' AND uValid=1 ORDER BY uDate DESC"
Set oRs = DBRecordSet(oCn, rSQL)

If Not oRs.EOF Then
CreateTopTable "LastAccounts", GetTranslation("LANG_ACCOUNTS")
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td>" & GetTranslation("LANG_LOGIN") & "</td>" & vbCRLF
Response.Write " <td width=""150"">" & GetTranslation("LANG_EMAIL") & "</td>" & vbCRLF
Response.Write " <td width=""250"">" & GetTranslation("LANG_SITE") & "</td>" & vbCRLF
Response.Write " <td width=""100"" align=""center"">" & GetTranslation("LANG_ROLE") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = 1
iLoop = 0
While Not oRs.EOF And iLoop < 10
sTemp = "" & oRs("uURL")
If sTemp <> "" Then
If Left(LCase(sTemp), 7) <> "http://" Then
sTemp = "http://" & sTemp
End If
End If
Response.Write " <tr class=""tableline" & iLine & """>" & vbCRLF
Response.Write " <td><a href=""" & GLOBAL_SITE_ADMIN_PATH & GLOBAL_SITE_ACCOUNTS_PAGE & "?do=view&id=" & oRs("uLogin") & """>" & Server.HTMLEncode(oRs("uLogin")) & "</a></td>" & vbCRLF
Response.Write " <td><a href=""" & GLOBAL_SITE_ADMIN_PATH & GLOBAL_SITE_MAIL_PAGE & "?to=" & Server.HTMLEncode(oRs("uEmail")) & """>" & Server.HTMLEncode(oRs("uEmail")) & "</a></td>" & vbCRLF
Response.Write " <td><a href=""" & Server.HTMLEncode(CStr(sTemp)) & """ target=""_blank"">" & Server.HTMLEncode(CStr(sTemp)) & "</a></td>" & vbCRLF
Response.Write " <td align=""center"">" & Server.HTMLEncode(oRs("rTitle")) & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = ((iLine - 1) XOr 1) + 1
oRs.MoveNext
iLoop = iLoop + 1
Wend
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If
' Invalid accounts
rSQL = "SELECT uLogin, uEMail, uURL, rTitle FROM users, roles where uRole=rID AND uValid=0 ORDER BY uDate DESC"
Set oRs = DBRecordSet(oCn, rSQL)

If Not oRs.EOF Then
CreateTopTable "InvalidAccounts", GetTranslation("LANG_ACCOUNTS") & " - " & GetTranslation("LANG_TO_VALIDATE")
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td>" & GetTranslation("LANG_LOGIN") & "</td>" & vbCRLF
Response.Write " <td width=""150"">" & GetTranslation("LANG_EMAIL") & "</td>" & vbCRLF
Response.Write " <td width=""250"">" & GetTranslation("LANG_SITE") & "</td>" & vbCRLF
Response.Write " <td width=""100"" align=""center"">" & GetTranslation("LANG_ROLE") & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = 1
iLoop = 0
While Not oRs.EOF
sTemp = "" & oRs("uURL")
If sTemp <> "" Then
If Left(LCase(sTemp), 7) <> "http://" Then
sTemp = "http://" & sTemp
End If
End If
Response.Write " <tr class=""tableline" & iLine & """>" & vbCRLF
Response.Write " <td><a href=""" & GLOBAL_SITE_ADMIN_PATH & GLOBAL_SITE_ACCOUNTS_PAGE & "?do=view&id=" & oRs("uLogin") & """>" & Server.HTMLEncode(oRs("uLogin")) & "</a></td>" & vbCRLF
Response.Write " <td><a href=""" & GLOBAL_SITE_ADMIN_PATH & GLOBAL_SITE_MAIL_PAGE & "?to=" & Server.HTMLEncode(oRs("uEmail")) & """>" & Server.HTMLEncode(oRs("uEmail")) & "</a></td>" & vbCRLF
Response.Write " <td><a href=""" & Server.HTMLEncode(CStr(sTemp)) & """ target=""_blank"">" & Server.HTMLEncode(CStr(sTemp)) & "</a></td>" & vbCRLF
Response.Write " <td align=""center"">" & Server.HTMLEncode(oRs("rTitle")) & "</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = ((iLine - 1) XOr 1) + 1
oRs.MoveNext
Wend
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If

oRs.Close
Set oRs = Nothing
oCn.Close
Set oCn = Nothing

if bUseCalendar then
'Last events in Calendar
Set oCn = DBConnexion(DB_CALENDAR)
rSql = "SELECT author, data_evento, luogo_evento, orario_evento, categoria_evento, cat_descr, titolo_evento, dettagli_evento FROM calendar_events, calendar_eventscat WHERE data_inserimento > '" & sLastVisit & "' AND categoria_evento=cat_id AND eValid=1 ORDER BY data_evento DESC"
Set oRs = DBRecordSet(oCn, rSQL)
If Not oRs.EOF Then
CreateTopTable "LastEvents", GetTranslation("LANG_CALENDAR")
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td width=""5%"" align=""center""></td>" & vbCRLF
Response.Write " <td width=""10%"" align=""center"">" & GetTranslation("LANG_DATE") & ":</td>" & vbCRLF
Response.Write " <td width=""35%"" align=""center"">" & GetTranslation("CALENDAR_EVENTWHERE") & ":</td>" & vbCRLF
Response.Write " <td width=""50%"" align=""left"">" & GetTranslation("CALENDAR_EVENTDETAILS") & ":</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF
While not oRs.EOF
Response.Write " <tr class=""tableline1"">" & vbCRLF
Response.Write " <td align=""center"" valign=""middle""><img src=""" & GLOBAL_SITE_IMAGES_PATH & "calendar_" & oRs("categoria_evento") & ".jpg"" alt=""" & oRs("cat_descr") & """ border=""1"" widht=""50"" height=""50""></td>" & vbCRLF
Response.Write " <td align=""center"" valign=""middle"">" & StringToDate(oRs("data_evento").Value) & "<br>" & oRs("orario_evento") & "</td>" & vbCRLF
Response.Write " <td align=""center"" valign=""middle"">" & oRs("luogo_evento") & "</td>" & vbCRLF
Response.Write " <td align=""left"" valign=""top""><p><strong>" & oRs("titolo_evento") & "</strong></p><div align=""justify"">" & CodeMessageEx(oRs("dettagli_evento"),0,False,False) & "</div>" & vbCRLF
Response.Write " </td>" & vbCRLF
Response.Write " </tr>" & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td colspan=""2""><div class=""big"" align=""left"">" & GetTranslation("LANG_AUTHOR") & ": " & oRs("author") & "</div>" & vbCRLF
Response.Write " </td>" & vbCRLF
Response.Write " <td colspan=""2""> </td>" & vbCRLF
Response.Write " </tr>" & vbCRLF
oRs.MoveNext
Wend
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If

'Unpublished events
rSql = "SELECT author, data_evento, luogo_evento, orario_evento, categoria_evento, cat_descr, titolo_evento, dettagli_evento FROM calendar_events, calendar_eventscat WHERE data_inserimento > '" & sLastVisit & "' AND categoria_evento=cat_id AND eValid=0 ORDER BY data_evento DESC"
Set oRs = DBRecordSet(oCn, rSQL)
If Not oRs.EOF Then
CreateTopTable "InvalidEvents", GetTranslation("LANG_CALENDAR") & " - " & GetTranslation("LANG_TO_VALIDATE")
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td width=""5%"" align=""center""></td>" & vbCRLF
Response.Write " <td width=""10%"" align=""center"">" & GetTranslation("LANG_DATE") & ":</td>" & vbCRLF
Response.Write " <td width=""35%"" align=""center"">" & GetTranslation("CALENDAR_EVENTWHERE") & ":</td>" & vbCRLF
Response.Write " <td width=""50%"" align=""left"">" & GetTranslation("CALENDAR_EVENTDETAILS") & ":</td>" & vbCRLF
Response.Write " </tr>" & vbCRLF
While not oRs.EOF
Response.Write " <tr class=""tableline1"">" & vbCRLF
Response.Write " <td align=""center"" valign=""middle""><img src=""" & GLOBAL_SITE_IMAGES_PATH & "calendar_" & oRs("categoria_evento")&".jpg"" alt=""" & oRs("cat_descr") & """ border=""1"" widht=""50"" height=""50""></td>" & vbCRLF
Response.Write " <td align=""center"" valign=""middle"">" & StringToDate(oRs("data_evento").Value) & "<br>" & oRs("orario_evento") & "</td>" & vbCRLF
Response.Write " <td align=""center"" valign=""middle"">" & oRs("luogo_evento") & "</td>" & vbCRLF
Response.Write " <td align=""left"" valign=""top""><p><strong>" & oRs("titolo_evento") & "</strong></p><div align=""justify"">" & CodeMessageEx(oRs("dettagli_evento"),0,False,False) & "</div>" & vbCRLF
Response.Write " </td>" & vbCRLF
Response.Write " </tr>" & vbCRLF
Response.Write " <tr class=""tablelinemain"">" & vbCRLF
Response.Write " <td colspan=""2""><div class=""big"" align=""left"">" & GetTranslation("LANG_AUTHOR") & ": " & oRs("author") & "</div>" & vbCRLF
Response.Write " </td>" & vbCRLF
Response.Write " <td colspan=""2""> </td>" & vbCRLF
Response.Write " </tr>" & vbCRLF
oRs.MoveNext
Wend
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If
oRs.Close
Set oRs = Nothing
oCn.Close
Set oCn = Nothing
End If

if bUseForum then
'Last posts in Forum
Set oCn = DBConnexion(DB_FORUM)
rSql = "SELECT PostID, PostParent, PostUser, PostDate, PostTitle, PostMessage, PostSection, PostSmileys, SectionForum, SectionName, ForumName FROM posts, sections, forums WHERE PostSection=SectionID AND PostValid=1 AND SectionForum=ForumID AND NOT (ForumLevel > 1 OR SectionLevel > 1) AND PostDate > '" & sLastVisit & "' ORDER BY PostDate DESC"
Set oRs = DBRecordSet(oCn, rSQL)
If Not oRs.EOF Then
CreateTopTable "TopPosts_valid", GetTranslation("LANG_FORUM")
iLine = 1
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
While Not oRs.EOF
bSmileys = oRs("PostSmileys").Value
Response.Write " <tr class=""tableline" & iLine & """>" & vbCRLF
Response.Write " <td align=""left"" valign=""top"" width=""20%""><a href=""" & GLOBAL_SITE_FORUM_PATH & GLOBAL_SITE_FORUM_PAGE & "?forum=" & oRs("SectionForum") & "&section=" & oRs("PostSection") & "&post=" & oRs("PostParent") & "&page=last"">" & CodeMessageEx(oRs("PostTitle"), 0, True, bSmileys) & "</a></td>" & vbCRLF
Response.Write " <td>" & vbCRLF
Response.Write " <b>" & Server.HTMLEncode(oRs("ForumName")) & "</b> - <span class=""small"">" & Server.HTMLEncode(oRs("SectionName")) & "</span><br>" & vbCRLF
Response.Write " <b>" & Server.HTMLEncode(oRs("PostUser")) & "</b> - <span class=""small"">" & GetDateDDMMYYHHMMSS(StringToDate(oRs("PostDate"))) & "</span><br><br>" & vbCRLF
Response.Write " " & CodeMessageEx(oRs("PostMessage"), 0, True, bSmileys) & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = 1 + ((iLine-1) XOR 1)
oRs.MoveNext
WEnd
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If

'Unpublished posts
Set oCn = DBConnexion(DB_FORUM)
rSql = "SELECT PostID, PostParent, PostUser, PostDate, PostTitle, PostMessage, PostSection, PostSmileys, SectionForum, SectionName, ForumName FROM posts, sections, forums WHERE PostSection=SectionID AND PostValid=0 AND SectionForum=ForumID AND NOT (ForumLevel > 1 OR SectionLevel > 1) ORDER BY PostDate DESC"
Set oRs = DBRecordSet(oCn, rSQL)
If Not oRs.EOF Then
CreateTopTable "TopPosts_invalid", GetTranslation("LANG_FORUM") & " - " & GetTranslation("LANG_TO_VALIDATE")
iLine = 1
Response.Write GLOBAL_SITE_SUBTABLE & vbCRLF
While Not oRs.EOF
bSmileys = oRs("PostSmileys").Value
Response.Write " <tr class=""tableline" & iLine & """>" & vbCRLF
Response.Write " <td align=""left"" valign=""top"" width=""20%""><a href=""" & GLOBAL_SITE_FORUM_PATH & GLOBAL_SITE_FORUM_PAGE & "?forum=" & oRs("SectionForum") & "&section=" & oRs("PostSection") & "&post=" & oRs("PostParent") & "&page=last"">" & CodeMessageEx(oRs("PostTitle"), 0, True, bSmileys) & "</a></td>" & vbCRLF
Response.Write " <td>" & vbCRLF
Response.Write " <b>" & Server.HTMLEncode(oRs("ForumName")) & "</b> - <span class=""small"">" & Server.HTMLEncode(oRs("SectionName")) & "</span><br>" & vbCRLF
Response.Write " <b>" & Server.HTMLEncode(oRs("PostUser")) & "</b> - <span class=""small"">" & GetDateDDMMYYHHMMSS(StringToDate(oRs("PostDate"))) & "</span><br><br>" & vbCRLF
Response.Write " " & CodeMessageEx(oRs("PostMessage"), 0, True, bSmileys) & vbCRLF
Response.Write " </tr>" & vbCRLF

iLine = 1 + ((iLine-1) XOR 1)
oRs.MoveNext
WEnd
Response.Write "</table>" & vbCRLF
CreateBottomTable ""
End If

' Mercatino - Articoli da validare
rSQL1 = "SELECT COUNT(id) as t FROM mercatino_annuncio WHERE valido=False"
Set oRs1 = DBRecordSet (oCn1, rSQL1)


CreateTopTable "Mercatino", "Mercatino - Articoli da verificare"
Response.Write " <tr class=""tableline1"">" & vbCRLF
If oRs1("t").Value >=1 then
Response.Write "<td align=""left""><b>"&iif(oRs1("t").Value=1,"E' presente "&oRs1("t").Value&" annuncio da verificare","Sono presenti "&oRs1("t").Value&" annunci da verificare")&" - <a href="""&GLOBAL_SITE_URL & GLOBAL_SITE_PATH&"admin/mercatino.asp"" title=""Verifica gli annunci presenti"">VERIFICALI ADESSO !</a></b></td>" & vbCRLF
Else
Response.Write "<td align=""left""><b>Tutti gli annunci sono già stati verificati !</b></td>" & vbCRLF
End If
Response.Write " </tr>" & vbCRLF
CreateBottomTable ""

oCn1.Close
Set oCn1 = Nothing
Set oRs1 = Nothing


oRs.Close
Set oRs = Nothing
oCn.Close
Set oCn = Nothing
End If

'here we could test last guestbook and forum entries
End Sub
%>



---------------

http://www.sampy.it
Sampy

Utente
Utente
99 Discussioni



Profilo - Sampy
06 giugno 2005 alle 20:45:23 Profilo - SampyInvia un messaggio privato Rispondi quotando
si lo so sono un rompi balle ed il codice è un tantino lunghetto ma le mie modifiche sono alla fine 8)
---------------

http://www.sampy.it
djveleno

Amministratore

Esperto
Esperto
1025 Discussioni



Profilo - djveleno
06 giugno 2005 alle 20:52:19 Profilo - djvelenoInvia un messaggio privato Rispondi quotando
Il codice per il link te lo posso tranquillamente inserire:
<element>
<text>Mercatino</text>
<link type="instruction">GLOBAL_SITE_ADMIN_PATH & "mercatino.asp"</link>
<target></target>
<bullet></bullet>
<role type="instruction">ROLE_ADMINISTRATOR</role>
<flag></flag>
</element>
ma per la modifica non saprei che dirti, mi sembra che non ti sia attenuto al file originale, che prevede la visualizzazione degli annunci subito, all'apertura della pagina di amministrazione.
Ciauzz DJ
---------------
A lavare la testa ai somari, ci si rimette l'acqua e il sapone!

http://aspnuke208.somee.com/Default.asp

Sampy

Utente
Utente
99 Discussioni



Profilo - Sampy
06 giugno 2005 alle 22:37:36 Profilo - SampyInvia un messaggio privato Rispondi quotando
ok ok ok grazie di ttt.
ora visto che sto impazzendo ed il mio socio nn è contento se impazzisco non è che potresti farmelo tu il codice di admin_allinfo-inc per il mercatino ho assolutamente bisogno del tuo aiuto!!!!
---------------

http://www.sampy.it
Sampy

Utente
Utente
99 Discussioni



Profilo - Sampy
07 giugno 2005 alle 19:12:16 Profilo - SampyInvia un messaggio privato Rispondi quotando
dai dj nn fare cosi aiutami tu ci metti 5 sec. io nn ho capito dove va inserito lo script!!! :~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~(:~( :~( :~( :~( :~( :~( :~( :~( :~(
---------------

http://www.sampy.it
djveleno

Amministratore

Esperto
Esperto
1025 Discussioni



Profilo - djveleno
07 giugno 2005 alle 19:44:27 Profilo - djvelenoInvia un messaggio privato Rispondi quotando
A parte gli scherzi, nel file TXT accluso al mercatino.zip V2.0.4a, vi sono tutte le spiegazioni per l'implementazione del programma, compreso la modifica al file admin_allinfo-inc.asp, la modifica va inserita all'inizio del file, seguendo le istruzioni, non capisco perchè tu abbia inserito altro. Se leggi attentamente il file TXT, ti accorgerai che è veramente semplice.
Ora, prendi il file admin_allinfo-inc.asp dallo zip originale e, esegui le modifiche, poi, trasferiscilo via FTP nel tuo portale.
Tutti gli utenti che hanno installato il mercatino ci sono riusciti, perchè tu non dovresti?
Ciauzz Dj
---------------
A lavare la testa ai somari, ci si rimette l'acqua e il sapone!

http://aspnuke208.somee.com/Default.asp

 1  2  >>

Log in

Login
Password
Memorizza i tuoi dati:

Cerca

 

Sostieni AspNuke

Un piccolo gesto per aiutarci a mantenere AspNuke.it online

Promo

MusicWebItalia.it
Video Testi Traduzioni Spot Colonne sonore Accordi e Spartiti gratis.

Visitatori

Visitatori Correnti : 109
Membri : 0 offline Anna

Iscritti

 Utenti: 18940
Ultimo iscritto : glauco
Lista iscritti
Messaggi privati: 3373 Commenti: 2210 Immagini: 39 Downloads: 144 Articoli: 49 Pagine: 101 Siti web: 558 Notizie: 180 Sondaggi: 11 Preferiti: 5685294 Post sui forum: 51195 Libro degli ospiti: 4 Eventi: 7

Versioni

Temi