Clan Themes, We Make Clans Look Good!

www.clan-themes.co.uk :: View topic - Member of the week block

Welcome To Clan Themes
	As the board grows please remember the Search Option and we hope you find our community useful. We also monitor Private Messages to stop members from abusing our sites system. If you are asking for assistance please provide your site link and nuke version, Thanks.

Member of the week block

4 Replies / 376 Views


www.clan-themes.co.uk Forum Index » Blocks	View previous topic :: View next topic

Zepherion
Reputation: 0.6
Local time: 11:49 PM

Status: Offline
0.16 posts per day
Medals: 0

Joined: Jul 27, 2008
Last Visit: 21 Aug 2008
Posts: 20
Points: 600

Member of the week block Posted: Sun Aug 03, 2008 11:12 am

Hi guys,

I downloaded, installed and setup the members of the week block. No problems there.
But when I calculate the Member of the Week (after setting up the points etc etc.) it shows me 'Anonymous' as member of the week !!

Any ideas how to not include anonymous in the calculation or how to fix this problem? Anonymous is assigned as the 'username' for visitors browsing the site...

Thx for reading this anyways ;)

floppy
Reputation: 1794.6
votes: 10
Local time: 5:49 PM
Location: Jackson Mississippi

Status: Offline
2.77 posts per day
Medals: 1 (View more...)

Clan Themes Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 01 Dec 2008
Posts: 2074
Points: 4343

Re: Member of the week block Posted: Sun Aug 03, 2008 3:57 pm
Shop Purchases:Clan Roster 2.0

Ha, that is kinky. I need to have a look at it lmao.

floppy
Reputation: 1794.6
votes: 10
Local time: 5:49 PM
Location: Jackson Mississippi

Status: Offline
2.77 posts per day
Medals: 1 (View more...)

Clan Themes Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 01 Dec 2008
Posts: 2074
Points: 4343

Re: Member of the week block Posted: Sun Aug 03, 2008 4:03 pm
Shop Purchases:Clan Roster 2.0

In the file block-Mem_Week_Side.php
Find

Code:

$result5 = mysql_query("select username,user_avatar,points, points_change FROM nuke_users ORDER BY points_change DESC LIMIT 1")
or die(mysql_error());

Change To

Code:

$result5 = mysql_query("select username,user_avatar,points, points_change FROM nuke_users WHERE user_id != '1' ORDER BY points_change DESC LIMIT 1")
or die(mysql_error());

I am sure other files are similar. Hope that helps.

Zepherion
Reputation: 0.6
Local time: 11:49 PM

Status: Offline
0.16 posts per day
Medals: 0

Joined: Jul 27, 2008
Last Visit: 21 Aug 2008
Posts: 20
Points: 600

Member of the week block Posted: Mon Aug 04, 2008 6:57 pm

Thanks a lot for that, works like a charm now !!

Zepherion
Reputation: 0.6
Local time: 11:49 PM

Status: Offline
0.16 posts per day
Medals: 0

Joined: Jul 27, 2008
Last Visit: 21 Aug 2008
Posts: 20
Points: 600

Member of the week block Posted: Thu Aug 07, 2008 5:26 pm

Just an extra question...

Would it mess up the site if I'd delete the very first user called anonymous in the database?

www.clan-themes.co.uk Forum Index » Blocks

4 Replies / 376 Views
Page 1 of 1
All times are GMT

Display posts from previous:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum

Distributed by Raven PHP Scripts

Page Generation: 1.41 Seconds