Author |
Topic |
soxc
New Member
53 Posts |
Posted - 13 November 2003 : 16:30:33
|
quote: Originally posted by EvilRick
How do I get the "portal.asp" to work outside the forum?
I love the layout of your UK MKIVS site and would like to have the similar layout, but as my homepage.
Any help/guidance would be greatly appreciated.
TIA
I just made my portal page the main page for my site with a redirect from the root [www.soxc.org]. The page just resides in the forum directory. If you look at David's site he has done the same thing.
|
|
|
soxc
New Member
53 Posts |
Posted - 13 November 2003 : 16:32:50
|
quote: Originally posted by kep
Please help.
When i open my sites homepage after installing your mod i get: Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'FORUM_CMS_CONTENT.CONT_ID ='. /portal.asp, line 201 Ofcourse i'm not able tot open the portal config under admin section.
You should be able to open the forum admin page. It should not be affected by the mod. |
|
|
kep
Starting Member
2 Posts |
Posted - 13 November 2003 : 16:47:20
|
quote: Originally posted by soxc
quote: Originally posted by kep
Please help.
When i open my sites homepage after installing your mod i get: Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'FORUM_CMS_CONTENT.CONT_ID ='. /portal.asp, line 201 Ofcourse i'm not able tot open the portal config under admin section.
You should be able to open the forum admin page. It should not be affected by the mod.
I can indeed, but i'm missing the portal stuff (it should be on the right, above the other options but it is not.
B.T.W. Thanks anyway |
Edited by - kep on 13 November 2003 16:51:50 |
|
|
soxc
New Member
53 Posts |
Posted - 13 November 2003 : 17:09:01
|
Did you add it to the admin_home.asp page? You can also just try and hit the page: admin_cms_home.asp
|
|
|
dhutten
New Member
Netherlands
66 Posts |
Posted - 30 November 2003 : 15:53:34
|
great mod, i get this error when using: Links Manager 3 Integration
Latest Links Microsoft JET Database Engine error '80040e37'
The Microsoft Jet database engine cannot find the input table or query 'FORUM_LINKS'. Make sure it exists and that its name is spelled correctly.
/portal.asp, line 374
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 01 December 2003 : 08:21:14
|
Do you have Links Manager 3 installed? |
The UK MkIVs Forum |
|
|
aspwiz
Junior Member
250 Posts |
Posted - 03 December 2003 : 16:59:06
|
I cant download this...
The site has an error:-
Cant Create Application.
Does anyone have a mirror of this mod? |
|
|
aspwiz
Junior Member
250 Posts |
Posted - 04 December 2003 : 08:38:03
|
Ignore the above post... it started working!
A few people have asked this:-
How can we get our homepage looking like yours? (http://www.uk-mkivs.net/forum/uk_home.asp)
Specifically I want the login box at the top left, and the Active Topics at the top Right!!! I also want the search google box!!
So far, no-one has said how this is possible.
Any chance of getting the code for this?
Can someone PLEASE help, coz this is driving me CRAZY!
The code for UK_Home.asp would help! |
Edited by - aspwiz on 04 December 2003 08:38:57 |
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 04 December 2003 : 16:49:20
|
Add this code above sub StartTable(byval Width, byval Heading)
sub DisplayGoogleSearch(byval Width)
call StartTable(Width, "Search Google")
Response.Write " <form method=""get"" action=""myowngoogle.asp"" onSubmit=""if (this.q.value != ''){return true}else{return false}"">" &vbCrLf &_
" <input type=""text"" name=""q"" style=""width:100%""><br>" &vbCrLf &_
" <input type=""hidden"" name=""page"" value=""1"">" & vbNewLine & _
" <input type=""submit"" value=""Search"" id=1 name=1><br>" &vbCrLf &_
" <div align=""center"">powered by <a href=""http://www.google.com/"" target=""_blank"">Google</a></div>" & vbNewLine & _
" </form>" &vbCrLf
call EndTable()
end sub
sub DisplayLogin(byval Width)
call StartTable(Width, "Login")
Response.Write " <form method=""post"" action="""& sThisPage &""" id=form1 name=form1>" &vbCrLf &_
" <input type=""hidden"" name=""Method_Type"" value=""login"">" & vbNewLine & _
" <input type=""text"" name=""Name"" style=""width:100%""><br>" &vbCrLf &_
" <input type=""password"" name=""Password"" style=""width:100%""><br>" &vbCrLf &_
" <input type=""checkbox"" class=""checkbox"" name=""SavePassWord"" value=""true"" tabindex=""-1"" CHECKED>Save password<br>" &vbCrLf &_
" <input type=""submit"" name=""btnSubmit"" value=""Login"">" &vbCrLf &_
" </form>" &vbCrLf
Call EndTable()
end sub
sub DisplayActiveTopics(byval Width, byval Count)
dim strSql
dim rsActive
Call StartTable(Width, "Active Topics")
strSql = "SELECT"
strSql = strSql & " T.TOPIC_ID,"
strSql = strSql & " T.T_SUBJECT"
strSql = strSql & " FROM " & strTablePrefix & "TOPICS T," & strTablePrefix & "FORUM F"
strSql = strSql & " WHERE T.FORUM_ID = F.FORUM_ID"
strSql = strSql & " AND F.F_PRIVATEFORUMS = 0"
strSql = strSql & " AND T.T_STATUS = 1"
strSql = strSql & " ORDER BY T_LAST_POST DESC"
Set rsActive = my_conn.Execute(TopSQL(strSql, Count))
If NOT rsActive.EOF Then
Do While NOT rsActive.EOF
Response.Write("<a href=""topic.asp?TOPIC_ID="& rsActive.fields("TOPIC_ID").value &""">"& rsActive.fields("T_SUBJECT").value & "</a><br><br>")
rsActive.MoveNext
Loop
End If
rsActive.Close
Set rsActive = Nothing
Response.Write " <a href=""active.asp"">more active topics</a>" &vbCrLf
Call EndTable()
end sub
add the appropriate sub calls within the Main() sub |
The UK MkIVs Forum |
|
|
aspwiz
Junior Member
250 Posts |
Posted - 05 December 2003 : 05:17:57
|
Thats soooo helpful.
Thanks David. |
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 05 December 2003 : 16:17:32
|
No probs, i'll put all this together as v1.1 over the weekend |
The UK MkIVs Forum |
|
|
aspwiz
Junior Member
250 Posts |
Posted - 07 December 2003 : 10:37:46
|
Hi David....
The real annoying thing is, that I would expect that you could have some control over the order of articles within a category.
Is it possible for you to build this in to version 1.1?
I have an 'Information' Category with 3 articles in it... That category, has to be ordered the opposite way to the others... Ie... first in, first displayed.
Ideally, if we could specify on a per category basis whether or not we want content ordered by latest first, then I truly believe this mod would be much more useful.
Even if it were ordered by the last edited article, that would give us a way to order stuff (allbeit a long winded way)
At the same time, I love the mod, and if you cant implement these changes, then no worries...
I am grateful in any event! |
Edited by - aspwiz on 07 December 2003 10:48:23 |
|
|
aspwiz
Junior Member
250 Posts |
Posted - 07 December 2003 : 10:55:51
|
Apologies.... It seems I can order stuff by date last edited Descending (I changed the code)...
Should be included in the Mod though, I think.... along with an option to hide certain articles from the navigation. |
|
|
Uzzio
Starting Member
46 Posts |
Posted - 23 December 2003 : 12:52:55
|
Hello! Im having this problem with this mod and MySQL. It worked perfectly in acces but then I converted the db in MySQL (everything works correctly and tables exist) but I am having this problem : Microsoft VBScript runtime error '800a01ca'
Variable uses an Automation type not supported in VBScript
/forum/portal.asp, line 169
How can I wourk around this? thank you!
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
|
Topic |
|