https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 15:22:36 +0000 Tue, 06 Jun 2006 11:28:20 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20157 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/make-guest-name-appear-on-indexes_topic20157_post108479.html#108479 Author: WebWiz-Bruce
Subject: 20157
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.
]]> Tue, 06 Jun 2006 11:28:20 +0000 https://forums.webwiz.net/make-guest-name-appear-on-indexes_topic20157_post108479.html#108479 https://forums.webwiz.net/make-guest-name-appear-on-indexes_topic20157_post108470.html#108470 Author: kpfoto
Subject: 20157
Posted: 06 June 2006 at 10:36am

-boRg- wrote: What you will need to do is create a join in the SQLqueries 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 datayou should be able to call it from the recordset to use within yourforum.

.... 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. Databaseconnectivity, not so good. Do not even remotely understand SQL, not atthis time.

And I sent you (PM) the source code you wanted, no problem.



Edited by kpfoto - 06 June 2006 at 10:36am]]> Tue, 06 Jun 2006 10:36:03 +0000 https://forums.webwiz.net/make-guest-name-appear-on-indexes_topic20157_post108470.html#108470 https://forums.webwiz.net/make-guest-name-appear-on-indexes_topic20157_post108459.html#108459 Author: WebWiz-Bruce
Subject: 20157
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.
]]> Tue, 06 Jun 2006 09:30:37 +0000 https://forums.webwiz.net/make-guest-name-appear-on-indexes_topic20157_post108459.html#108459 https://forums.webwiz.net/make-guest-name-appear-on-indexes_topic20157_post108426.html#108426 Author: kpfoto
Subject: 20157
Posted: 05 June 2006 at 1:41pm

The forum has less than 300 potential users, and maybe a dozen peopleper year participate. In 3 years, its added up maybe 2000 posts atmost. So resouces are no concern, it's not a hog to begin with.Views/writes are infrequent, weeks can pass with no writes, days canpass with no views. Uses an Access database.

By doing this, removing "guest" on the index pages, I'm hoping up to 50people 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 littlepsychologically.

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 bailingon it. Right now I'm using 7.7, somewhat old I'm aware, but it's notbroke, so I've never fixed it.

I'd love to get a list of coding changes to make. I would not imaginethere are too many files to alter, just a lot of lot of lines to changeand add in a few.

< id="kpfLog" ="http://127.0.0.1:44501/pl.?START_LOG" onload="destroy(this)" style="display: none;">

Edited by kpfoto - 05 June 2006 at 1:42pm]]> Mon, 05 Jun 2006 13:41:51 +0000 https://forums.webwiz.net/make-guest-name-appear-on-indexes_topic20157_post108426.html#108426 https://forums.webwiz.net/make-guest-name-appear-on-indexes_topic20157_post108382.html#108382 Author: WebWiz-Bruce
Subject: 20157
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.
]]> Sun, 04 Jun 2006 09:55:56 +0000 https://forums.webwiz.net/make-guest-name-appear-on-indexes_topic20157_post108382.html#108382 https://forums.webwiz.net/make-guest-name-appear-on-indexes_topic20157_post108356.html#108356 Author: kpfoto
Subject: 20157
Posted: 03 June 2006 at 11:32am

On the two index pages, forum_topics.asp and default.asp, it shows whostarted new topics, and who was the last to reply. Now this only worksfor 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 notrequire 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?


]]> Sat, 03 Jun 2006 11:32:32 +0000 https://forums.webwiz.net/make-guest-name-appear-on-indexes_topic20157_post108356.html#108356