I wrote this to just display simple news on the front page.
Run the DBS or execute this query against your forums database. You may need to change the table name to reflect your table name struct you should leave the news part of the table alone. This does not effect any other table in your database.
Just copy these files into your forums directory insert into default.asp around line 43 <!--#INCLUDE FILE="inc_news_body.asp" --> after <!--#INCLUDE FILE="inc_top.asp" -->
Insert this into admin_home.asp <LI><a href="admin_newspost.asp">Add News</a></LI> around line 70 where you will find this: <LI><a href="admin_config_badwords.asp">Bad Word Feature Configuration</a></LI>
Also, in this archive is a copy of HuwR's (Huw Reddick) admin_mod_dbsetup.asp YOU DO NOT NEED TO COPY THIS FILE IF YOU DON'T WANT TO!!!!! YOU DO NOT NEED TO COPY THIS FILE IF YOU DON'T WANT TO!!!!! Very minor change for MySQL support Check around line number 228 strSql = "CREATE TABLE " & TablePrefix & strTableName & "( " Added a space at &" ( " to make it comliant with MySQL CREATE TABLE spec
I am providing this mod without any real support. I wrote it quick and dirty to give me quick news on the front page.
I wrote this to just display simple news on the front page.
Run the DBS or execute this query against your forums database you may need to change the table name to reflect your table name struct you should leave the news part of the table alone
Just copy these files into your forums directory insert into default.asp around line 43 <!--#INCLUDE FILE="inc_news_body.asp" --> after <!--#INCLUDE FILE="inc_top.asp" -->
Insert this into admin_home.asp <LI><a href="admin_newspost.asp">Add News</a></LI> around line 70 where you will find this: <LI><a href="admin_config_badwords.asp">Bad Word Feature Configuration</a></LI>
Insert CODE TO PASTE into inc_functions.asp at around line 2093 between End Function and before this sub call Sub WriteFooter() %> <!--#INCLUDE FILE="inc_footer.asp"--> <% end sub %>
CODE TO PASTE:
'news poster Function WriteNews(fVariable) WriteNews = "added" dim ndate ndate = year(now())&"-"&month(now())&"-"&day(now())&" "&hour(now())&":"&minute(now())&":"&second(now()) my_conn.execute ( "INSERT INTO " & strTablePrefix & "news (n_text,n_date,member_id) VALUES ('" & fVariable & "','"&ndate&"',1)")
End function 'end news poster
function SQLparse(s) '********************************************* '* This just does a charater replacement on my '* insert and update sections '* so I don't blow up the database. '* Wes Brown '********************************************* dim tmp
Also, in this archive is a copy of HuwR's (Huw Reddick) admin_mod_dbsetup.asp YOU DO NOT NEED TO COPY THIS FILE IF YOU DON'T WANT TO!!!!! YOU DO NOT NEED TO COPY THIS FILE IF YOU DON'T WANT TO!!!!! Very minor change for MySQL support Check around line number 228 strSql = "CREATE TABLE " & TablePrefix & strTableName & "( " Added a space at &" ( " to make it comliant with MySQL CREATE TABLE spec
I am providing this mod without any real support. I wrote it quick and dirty to give me quick news on the front page.
Topic Locked
Posted - 13 July 2002 : 20:02:29
