Forums

ASP

This topic is locked

Chat?!?!

Posted 09 Aug 2001 09:50:48
1
has voted
09 Aug 2001 09:50:48 Viktor Farcic posted:
I need to implement chat in one of the sites I'm working on. It's not like usual chats, but rether something for communication between administrator and visitor. Take a look at this ChatLive 121 - www.click121.com/products.html

It should be something like this. Any idea?

Replies

Replied 09 Aug 2001 14:45:32
09 Aug 2001 14:45:32 Joel Martinez replied:
well, I don't know of any extensions for this, but I know of a couple of articles on 4guys about this, they might help:

www.4guysfromrolla.com/webtech/032200-1.shtml
www.4guysfromrolla.com/webtech/041000-1.shtml

hope it helps

Joel Martinez

----------
set rs = conn.execute("SELECT answer FROM brain WHERE question = "& forumPost &"
Replied 30 Aug 2001 02:47:10
30 Aug 2001 02:47:10 Andrew Watson replied:
Im Just starting a very similar adventure for myself in ASP and although its probably a very, very rough and simple solution it seems to be working fine so far <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle> ......


A Database with three tables,
tblPosts
tblUsers
tblAdministrators

tblPosts contains,
postid
postedby
postedto
message
timestamp

tblUser
id
username

tblAdministrators is just as above (could be the same, but i have a password field in this one)

<b>The User (visitor) application</b>
create a one field registration page which is identicle to a one field (username) login page. these both take the visitor to a personal 'chatroom' page with their username pulled through. This chatroom is a frameset made up of two frames, the page in which ive called Propmt and Chatwindow.

Prompt simply has a record insert form which allows the visitor to ONLY add a text message. this and their username(postedby) and a preset default value 'i.e. salesman' (postedto) are appended to the tblposts in the db.

This form insert this record to the db.
The lower frame contains a page which simply has a repeated recordset of posts either by that username or to him, and perhaps within a date range or session or something. this page refreshes automatically every ?10? seconds.

An main adminpage is used to display all posts to the default value {above} i.e incoming messages.
Their usernames are linked to a detail page, chatroom frameset, which is almost identicle to the visitors one above. This one however has the postedto field set to the requested username and the postedby field set to the above default value, the second frame again displays the posted messages involved in this conversation and refreshes automatically.

This is the bare bones of what im attempting, i hope you followed it! and it can be improved massively, hell, im new to this and Its the best i came up with!

<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Cheers
Leed

Replied 30 Aug 2001 09:40:30
30 Aug 2001 09:40:30 Viktor Farcic replied:
What I see as problem in application you're building is DB. Inserting input data into DB will slow down everything.

Replied 30 Aug 2001 09:54:36
30 Aug 2001 09:54:36 Andrew Watson replied:
This has occured to me but how else could it be done? Would it be application variables??

Replied 30 Aug 2001 15:43:57
30 Aug 2001 15:43:57 Joel Martinez replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>This has occured to me but how else could it be done? Would it be application variables??<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>Read my post above... 4guys has what you need <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Joel Martinez [ ]
----------
set rs = conn.execute("SELECT answer FROM brain WHERE question = "& forumPost &"
'2nd place is just 1st Loser

Reply to this topic