Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 Random Quote		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

ammar_ggedoN
Starting Member

10 Posts
Posted - 31 March 2003 :  10:13:59  Show Profile  Visit ammar_ggedoN's Homepage
Hi guys (and girls ofcourse),

Is it possible to put a random quote on your forum? It would nice to have a very subtle random quote somewhere above the forum. Everytime you log on a quote would appear. and if you press 'refresh' or something a new quote would appear.

snaayk
Senior Member

USA
1061 Posts
Posted - 31 March 2003 :  11:29:36  Show Profile  Visit snaayk's Homepage  Send snaayk an AOL message  Send snaayk an ICQ Message  Send snaayk a Yahoo! Message
Are you asking for this forum to do it or how to modify your forum to show a random quote?

Theres code that can display any random record out a database table. Basically a query that selects a random at record and displays it. Do you need such code?
Go to Top of Page

PeeWee.Inc
Senior Member

United Kingdom
1893 Posts
Posted - 31 March 2003 :  11:38:53  Show Profile  Visit PeeWee.Inc's Homepage
look on snitzbitz for "random quote"


http://www.snitzbitz.com
De Priofundus Calmo Ad Te Damine
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts
Posted - 31 March 2003 :  11:53:45  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
Take a look at http://www.crashhosting.nl:81/filelibrary.asp
My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page

hayleypink
Junior Member

Haiti
145 Posts
Posted - 16 July 2003 :  08:14:00  Show Profile
does any one have a demo of this? wondering where the quote will show on my forum?
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts
Posted - 16 July 2003 :  08:21:26  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
If you follow the instructions from the readme, it shows up on default.asp like this:



But you can put it almost anywhere you want.
My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page

hayleypink
Junior Member

Haiti
145 Posts
Posted - 16 July 2003 :  10:56:45  Show Profile
UMMM stil thinking about it - not sure my members look at the main page anymore they just go straight to active topics!
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts
Posted - 16 July 2003 :  11:02:11  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
As I said, you can put it almost anywhere, inc_header.asp for example.
My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page

hayleypink
Junior Member

Haiti
145 Posts
Posted - 16 July 2003 :  11:06:26  Show Profile
Yeh I would like to find a way to just show the quote without a box in inc_header so it is transparent over the background between the logo and links
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts
Posted - 29 July 2003 :  08:01:33  Show Profile
Something subtle like what I have on my site? This is a simple javascript that you can insert anywhere you want. I can give you the code if you'd like.
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

dpmcalister
Junior Member

United Kingdom
161 Posts
Posted - 29 July 2003 :  10:23:10  Show Profile  Visit dpmcalister's Homepage
Likewise, I've got a basic ASP version (not connected to the Snitz database that can be put anywhere. The ASP code is:
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};uid=;pwd=; DBQ=" & Server.MapPath("database.mdb")

set rs =server.CreateObject("ADODB.Recordset")
set rs.ActiveConnection = Conn

rs.Open "SELECT * FROM quotes" 
set rsTopNumber=conn.execute("select count(*) from quotes")

intRecordID = rsTopNumber(0)
rsTopNumber.close
set rsTopNumber = nothing

Randomize
numMove = Int(intRecordID * Rnd)

rs.Move numMove
response.write "" & rs("quote_text") & "<br><b>" & rs("quote_film") & ", " & rs("quote_year") & "</b>"

rs.close
Conn.close
set rs = nothing
set Conn = nothing
%>

I think the database make-up is reasonably straightforward, but just shout if you need any help.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.34 seconds. Powered By: Snitz Forums 2000 Version 3.4.07