We know what you are talking about...

Talk about just about anything else that is non-gaming here, but keep it clean
Curlypaul
Next-Gen
Posts: 1693
Joined: Tue Sep 18, 2007 4:25 pm
Location: UK - Dudley

We know what you are talking about...

Post by Curlypaul »

Not sure if the mods have noticed but the topics from mods only board show up on the front page.

They make for interesting reading but maybe you would like to hide them really.
User avatar
equalsign
Next-Gen
Posts: 1119
Joined: Sat Mar 22, 2008 4:34 am

Re: We know what you are talking about...

Post by equalsign »

This topic has come up before. The mods are aware that this happens. They said they were investigating a way to hide these threads from appearing on the front page, but weren't optimistic. I can only assume by the frequency which I get that "You are not authorized to read this forum" slap in the face that they haven't yet been able to figure out a way to do this.
Looking for Animal Crossing e Reader cards! - link
superlarz
128-bit
Posts: 770
Joined: Tue Nov 11, 2008 8:01 pm
Location: San Diego
Contact:

Re: We know what you are talking about...

Post by superlarz »

yeah, this happens to me all the time too
owned: Atari VCS, Intellivision, ColecoVision, NES, NES2, Sega Master System, Turbografx-16, Genesis/Sega CD Model 1, Genesis/Sega CD Model 2/32x, SNES, Atari Jaguar, Virtual Boy, GBA, 3DO, Saturn, Playstation, PSone, N64, Dreamcast, PS2, Gamecube, Xbox, PSP, Xbox 360, Wii, PS3
wanted: Cd-I, Neo Geo AES
User avatar
PharmaceuticalCowboy
64-bit
Posts: 463
Joined: Fri Sep 21, 2007 2:22 pm
Location: Columbus, Ohio

Re: We know what you are talking about...

Post by PharmaceuticalCowboy »

Anyone know why it never happened in the past but is happening now?
User avatar
MrPopo
Moderator
Posts: 24201
Joined: Tue Aug 26, 2008 1:01 pm
Location: Orange County, CA

Re: We know what you are talking about...

Post by MrPopo »

In the past we never had a mod's forum. Also, that forum is generally not too active, so posts don't show up often in the most recent topics list.
Blizzard Entertainment Software Developer - All comments and views are my own and not representative of the company.
User avatar
Dakinggamer87
Next-Gen
Posts: 4532
Joined: Thu Apr 24, 2008 7:13 pm
Location: Silicon Valley, CA
Contact:

Re: We know what you are talking about...

Post by Dakinggamer87 »

superlarz wrote:yeah, this happens to me all the time too
Yeah, I noticed this too.. 8)
Odyssey,Vectrex,Atari 2600,5200,7800,Intellivision,Colecovision,NES,Master System,SNES,Genesis,32X,CD,CDX,Virtual Boy,TG-16,Neo-Geo AES,Jaguar+CD,PSX,PSOne,Saturn,3DO,N64,DC,PS2,Xbox,GCN,Wii,Xbox 360,PS3,GB,GB Pocket,GBC,Lynx,Game Gear,Nomad,NGPC,GBA,GBA SP,GB Micro,DS,PSP,PSP Slim,WS,WS Color,3DS,Vita,PC,iPhone,WiiU
A/V:55" Samsung 3D LED TV, Onkyo 7.1 TX-SR605 HTS
My gaming collection
User avatar
Mozgus
Next-Gen
Posts: 6624
Joined: Sat May 13, 2006 10:31 pm
Contact:

Re: We know what you are talking about...

Post by Mozgus »

Last time this was mentioned, I thought racket had it fixed within hours, but apparently it's back again. No clues on my end, as I've never dealt with whatever blog software he runs here.
Curlypaul
Next-Gen
Posts: 1693
Joined: Tue Sep 18, 2007 4:25 pm
Location: UK - Dudley

Re: We know what you are talking about...

Post by Curlypaul »

It should be a simple change to the sql that populates the list, but if you havnt got the source then it might get tricky.
User avatar
MrPopo
Moderator
Posts: 24201
Joined: Tue Aug 26, 2008 1:01 pm
Location: Orange County, CA

Re: We know what you are talking about...

Post by MrPopo »

select topic_name from (select topic_name from threads where forum != modforumid order by last_updated) where rownum < 11; is probably how I'd craft it. Then again, I can't remember if the order by gets applied before rownum or not, as rownum is always a little tricky. Plus, that's all Oracle, while I'm sure the forum runs on MySQL.
Blizzard Entertainment Software Developer - All comments and views are my own and not representative of the company.
User avatar
marurun
Moderator
Posts: 12413
Joined: Sat May 06, 2006 8:51 am
Location: Cleveland, OH
Contact:

Re: We know what you are talking about...

Post by marurun »

MrPopo wrote:select topic_name from (select topic_name from threads where forum != modforumid order by last_updated) where rownum < 11; is probably how I'd craft it. Then again, I can't remember if the order by gets applied before rownum or not, as rownum is always a little tricky. Plus, that's all Oracle, while I'm sure the forum runs on MySQL.
While different databases often do have varied implementations of SQL, the language should, by and large, be pretty generic and fairly universal.
Post Reply