Installazione

Installazione


Files inclusi nell'archivio:
admin_config_order.asp
leggimi.txt
catforumsort.dbs
catforumsort2.dbs
mod_dbsetup.asp (database setup utility)


Inserire nella directory del proprio forum questi file:

admin_config_order.asp
catforumsort.dbs
catforumsort2.dbs
mod_dbsetup.asp


###############################################
ATTENZIONE: # 
Il numero delle righe nella spigazione #
passo per passo corrispondono a le righe dello#
snitz forum dispoibile su WebMaster Point #
senza nessuna modifica, inoltre le modifiche #
in ogni singolo file andranno fatte nel ordine#
proposto, dato che se questo non viene #
rispettato il numero delle righe potrebbe #
non tornare #
###############################################


###############################################
Cambiamenti da fare nel file: ADMIN_HOME.ASP #
###############################################
Alla linea #97

Inserire questa riga:

 

  • Configurazione Ordine Categorie/Forum


  • ###############################################
    Fine: ADMIN_HOME.ASP #
    ###############################################


    Poi


    ###############################################
    Cambiamenti da fare nel file: DEFAULT.ASP #
    ###############################################
    Alla linea #91

    Troverai questo codice:



'## Forum_SQL - Get all Forums From DB
strSql = "SELECT " & strTablePrefix & "CATEGORY.CAT_ID, " & strTablePrefix & "CATEGORY.CAT_STATUS, " 
strSql = strSql & strTablePrefix & "CATEGORY.CAT_NAME "
strSql = strSql & " FROM " & strTablePrefix & "CATEGORY "
strSql = strSql & ";"



Rimpiazzalo con questo codice:

'## Forum_SQL - Get all Forums From DB
strSql = "SELECT " & strTablePrefix & "CATEGORY.CAT_ID, " & strTablePrefix & "CATEGORY.CAT_STATUS, " 
strSql = strSql & strTablePrefix & "CATEGORY.CAT_NAME, " & strTablePrefix & "CATEGORY.CAT_ORDER "
strSql = strSql & " FROM " & strTablePrefix & "CATEGORY "
strSql = strSql & " ORDER BY " & strTablePrefix & "CATEGORY.CAT_ORDER ASC"
strSql = strSql & " , " & strTablePrefix & "CATEGORY.CAT_NAME ASC;"



###############################################
Alla linea #178

Troverai questo codice:

'## Forum_SQL - Build SQL to get forums via category
strSql = "SELECT " & strTablePrefix & "FORUM.FORUM_ID, " 
strSql = strSql & strTablePrefix & "FORUM.F_STATUS, " 
strSql = strSql & strTablePrefix & "FORUM.CAT_ID, " 
strSql = strSql & strTablePrefix & "FORUM.F_SUBJECT, " 
strSql = strSql & strTablePrefix & "FORUM.F_URL, " 
strSql = strSql & strTablePrefix & "FORUM.F_DESCRIPTION, " 
strSql = strSql & strTablePrefix & "FORUM.CAT_ID, " 
strSql = strSql & strTablePrefix & "FORUM.F_TOPICS, " 
strSql = strSql & strTablePrefix & "FORUM.F_COUNT, " 
strSql = strSql & strTablePrefix & "FORUM.F_LAST_POST, " 
strSql = strSql & strTablePrefix & "FORUM.F_STATUS, " 
strSql = strSql & strTablePrefix & "FORUM.F_TYPE, " 
strSql = strSql & strTablePrefix & "FORUM.F_PRIVATEFORUMS, " 
strSql = strSql & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " 
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_NAME " 
strSql = strSql & "FROM " & strTablePrefix & "FORUM " 
strSql = strSql & "LEFT JOIN " & strMemberTablePrefix & "MEMBERS ON "
strSql = strSql & strTablePrefix & "FORUM.F_LAST_POST_AUTHOR = "
strSql = strSql & strMemberTablePrefix & "MEMBERS.MEMBER_ID "
strSql = strSql & " WHERE " & strTablePrefix & "FORUM.CAT_ID = " & rs("CAT_ID") & " "
strSql = strSql & " ORDER BY " & strTablePrefix & "FORUM.F_SUBJECT ASC;"


Rimpiazzalo con questo codice:

'## Forum_SQL - Build SQL to get forums via category
strSql = "SELECT " & strTablePrefix & "FORUM.FORUM_ID, " 
strSql = strSql & strTablePrefix & "FORUM.F_STATUS, " 
strSql = strSql & strTablePrefix & "FORUM.CAT_ID, " 
strSql = strSql & strTablePrefix & "FORUM.F_SUBJECT, " 
strSql = strSql & strTablePrefix & "FORUM.F_URL, " 
strSql = strSql & strTablePrefix & "FORUM.F_DESCRIPTION, " 
strSql = strSql & strTablePrefix & "FORUM.CAT_ID, " 
strSql = strSql & strTablePrefix & "FORUM.F_TOPICS, " 
strSql = strSql & strTablePrefix & "FORUM.F_COUNT, " 
strSql = strSql & strTablePrefix & "FORUM.F_LAST_POST, " 
strSql = strSql & strTablePrefix & "FORUM.F_STATUS, " 
strSql = strSql & strTablePrefix & "FORUM.F_TYPE, " 
strSql = strSql & strTablePrefix & "FORUM.F_PRIVATEFORUMS, " 
strSql = strSql & strTablePrefix & "FORUM.FORUM_ORDER, " 
strSql = strSql & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " 
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_NAME " 
strSql = strSql & "FROM " & strTablePrefix & "FORUM " 
strSql = strSql & "LEFT JOIN " & strMemberTablePrefix & "MEMBERS ON "
strSql = strSql & strTablePrefix & "FORUM.F_LAST_POST_AUTHOR = "
strSql = strSql & strMemberTablePrefix & "MEMBERS.MEMBER_ID "
strSql = strSql & " WHERE " & strTablePrefix & "FORUM.CAT_ID = " & rs("CAT_ID") & " "
strSql = strSql & " ORDER BY " & strTablePrefix & "FORUM.FORUM_ORDER ASC"
strSql = strSql & " , " & strTablePrefix & "FORUM.F_SUBJECT ASC;"



###############################################
Fine: DEFAULT.ASP #
###############################################



###############################################
Cambiamenti da fare nel file: INC_JUMP_TO.ASP#
###############################################
Alla linea #58

Troverai questo codice:

'## Get all Forum Categories From DB
strSql = "SELECT " & strTablePrefix & "CATEGORY.CAT_ID, " & strTablePrefix & "CATEGORY.CAT_NAME "
strSql = strSql & " FROM " & strTablePrefix & "CATEGORY"

set rsCat = my_conn.Execute (strSql)

do until rsCat.eof '## Grab the Categories.

'## Build SQL to get forums via category
'## Forum_SQL
strSql = "SELECT " & strTablePrefix & "FORUM.FORUM_ID, " & strTablePrefix & "FORUM.F_TYPE, " & strTablePrefix & "FORUM.F_SUBJECT, " & strTablePrefix & "FORUM.F_URL, " & strTablePrefix & "FORUM.CAT_ID "
strSql = strSql & " FROM " & strTablePrefix & "FORUM "
strSql = strSql & " WHERE " & strTablePrefix & "FORUM.CAT_ID = " & rsCat("CAT_ID")
strSql = strSql & " ORDER BY " & strTablePrefix & "FORUM.F_SUBJECT ASC;"




Rimpiazzalo con questo codice:

'## Get all Forum Categories From DB
strSql = "SELECT " & strTablePrefix & "CATEGORY.CAT_ID, " & strTablePrefix & "CATEGORY.CAT_NAME, "
strSql = strSql & strTablePrefix & "CATEGORY.CAT_ORDER "
strSql = strSql & " FROM " & strTablePrefix & "CATEGORY"
strSql = strSql & " ORDER BY " & strTablePrefix & "CATEGORY.CAT_ORDER ASC"
strSql = strSql & " , " & strTablePrefix & "CATEGORY.CAT_NAME ASC;"

set rsCat = my_conn.Execute (strSql)

do until rsCat.eof '## Grab the Categories.

'## Build SQL to get forums via category
'## Forum_SQL
strSql = "SELECT " & strTablePrefix & "FORUM.FORUM_ID, " & strTablePrefix & "FORUM.F_TYPE, " & strTablePrefix & "FORUM.F_SUBJECT, "
strSql = strSql & strTablePrefix & "FORUM.F_URL, " & strTablePrefix & "FORUM.CAT_ID, " & strTablePrefix & "FORUM.FORUM_ORDER "
strSql = strSql & " FROM " & strTablePrefix & "FORUM "
strSql = strSql & " WHERE " & strTablePrefix & "FORUM.CAT_ID = " & rsCat("CAT_ID")
strSql = strSql & " ORDER BY " & strTablePrefix & "FORUM.FORUM_ORDER ASC"
strSql = strSql & " , " & strTablePrefix & "FORUM.F_SUBJECT ASC;"



###############################################
Fine: INC_JUMP_TO.ASP #
###############################################

Per implementare questo Mod dovrai andare con il tuo Browser preferito nella cartella dove risiede il tuo Forum

Esempio se il tuo Snitz Forum risiede nella cartella /forum :

http://www.yyyyyy.tt/forum/mod_dbsetup.asp

Scegliere il Mod dal menù a tendina e aggiornare il Database con il Tasto "Aggiorna"
Se utilizzi la versione Access 2000 Secegli:

Category/Forum Sorting Mod (Default)

Se utilizzi la versione Access 97 Scegli:

Category/Forum Sorting Mod for Access97 Connectstring

Una volta fatto fare l'aggiornamento del database, cliccando su Invia,
il file mod_dbsetup.asp può anche essere rimosso.

 



Ti potrebbe interessare anche

commenta la notizia

C'è 1 commento
Graziano
Hai qualche domanda da fare?