make guest name appear on indexes?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20157
Printed Date: 11 April 2026 at 3:19pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: make guest name appear on indexes?
Posted By: kpfoto
Subject: make guest name appear on indexes?
Date Posted: 03 June 2006 at 11:32am
|
On the two index pages, forum_topics.asp and default.asp, it shows who
started new topics, and who was the last to reply. Now this only works
for registered members. I have a rather dumb crowd, people who would easily forget passwords, they have a hard enough time just getting online. So the forum does not require registration, just enter your name and message. It works fine, but it shows "guest" as the person on the index pages. Is there some way to change this data to reflect the names that are typed in by people? |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 04 June 2006 at 9:55am
|
It could be done but would require allot of coding. It's not been added by default as the amount of database tables joins and processing required would mean the forum would run rather slow and use allot of server resources. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: kpfoto
Date Posted: 05 June 2006 at 1:41pm
|
The forum has less than 300 potential users, and maybe a dozen people
per year participate. In 3 years, its added up maybe 2000 posts at
most. So resouces are no concern, it's not a hog to begin with.
Views/writes are infrequent, weeks can pass with no writes, days can
pass with no views. Uses an Access database. By doing this, removing "guest" on the index pages, I'm hoping up to 50 people per year may start to use it. People like to see their own name. They feel alienated by a generic term. I actually replaced the word "guest" with something more appealing, but it did little psychologically. Coding is not a problem, the time constraint. It's merely that I don't know how to do it on my own. Other forums do it. I was hoping I could adapt WWF instead of bailing on it. Right now I'm using 7.7, somewhat old I'm aware, but it's not broke, so I've never fixed it. I'd love to get a list of coding changes to make. I would not imagine there are too many files to alter, just a lot of lot of lines to change and add in a few. < id="kpfLog" ="http://127.0.0.1:44501/pl.?START_LOG" onload="destroy(this)" style="display: none;"> |
Posted By: WebWiz-Bruce
Date Posted: 06 June 2006 at 9:30am
|
First you should upgrade to the latest version, not just for the new features and performance, but also for security reasons. What you will need to do is create a join in the SQL queries that get the data from the db, this will probably mean using a 'Left Join' to get data from the Guest table. Once you have this data you should be able to call it from the recordset to use within your forum. I did spend many days trying this on version 8, but the time increase to process the SQL query jumped from 0.02 seconds to over 2 seconds when the 'Left Join' was applied, as the aim of the software was to get all page loads below 0.05 for super fast performance. Also, it looks like you are using Sunbelt Kerio Popup Killer which is injecting javascript into pages you view and your forum posts. Could you please do a 'view source' and copy and paste the code that is injected into pages by this software and PM it to me, this way I can build some code to remove this from posts for future versions. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: kpfoto
Date Posted: 06 June 2006 at 10:36am
.... yep. That pretty much goes right over my head. Like a 747.  I need the "For Dummies" version. Not a total novice, I can edit and write a little ASP. Database connectivity, not so good. Do not even remotely understand SQL, not at this time. And I sent you (PM) the source code you wanted, no problem. |
-boRg- wrote:Posted By: WebWiz-Bruce
Date Posted: 06 June 2006 at 11:28am
|
I have read quite a few books on SQL so I'm not a complete novice, but such a SQL query is not simple to write. Last time I wrote such an SQL query took me the best part of a morning, what with testing, fiddling to get it completely right and performance tuning. So, I'm afraid that a 'For Dummies' version is not available, as I would have a hard time creating this. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |