Clan Themes, We Make Clans Look Good!

www.clan-themes.co.uk :: View topic - Change initial sort order on clan roster 1.7

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.

Change initial sort order on clan roster 1.7

6 Replies / 749 Views


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

BlackheartBouvi
Reputation: 70.7
votes: 1
Local time: 10:30 AM

Status: Offline
0.02 posts per day
Medals: 0

Joined: Jan 24, 2008
Last Visit: 27 Feb 2008
Posts: 5
Points: 250

Change initial sort order on clan roster 1.7 Posted: Fri Jan 25, 2008 2:49 pm
Shop Purchases:Clan Roster v1.7 Php Nuke Module

Thanks Ped for letting me know to start a new thread.

I am wanting to change the sort order so that it sorts by rank instead of member name on the list. Is there an easy way to do it? I just cannot find the ORDER call that does it.

Thanks,

BlackheartBouvi

DoC
Reputation: 168.1
votes: 4
Local time: 5:30 PM
Location: Wiltshire, UK

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

Very Important Person

Joined: Feb 07, 2007
Last Visit: 29 Nov 2008
Posts: 373
Points: 400

Change initial sort order on clan roster 1.7 Posted: Fri Jan 25, 2008 3:28 pm
Shop Purchases:Clan Roster v1.7 Php Nuke Module · Clan Roster 2.0

Hi there BlackheartBouvi,

Go to: modules/Clan_Roster/files/index.php

Highlight line: 48 - 51

Change what you have there to this:

Code:

$sql = "SELECT * FROM ".$prefix."_croster_members ORDER BY rid ASC";
}else{
$sql = "SELECT * FROM ".$prefix."_croster_members WHERE active = '1' ORDER BY rid ASC";
}

That will sort your Active members by rank. Devil

DoC

Play EVE Online? Go To: www.go-pdi.com & Join The Best Corp In The Universe!

BlackheartBouvi
Reputation: 70.7
votes: 1
Local time: 10:30 AM

Status: Offline
0.02 posts per day
Medals: 0

Joined: Jan 24, 2008
Last Visit: 27 Feb 2008
Posts: 5
Points: 250

Change initial sort order on clan roster 1.7 Posted: Fri Jan 25, 2008 3:34 pm
Shop Purchases:Clan Roster v1.7 Php Nuke Module

Worked like a charm. Thanks. :)

DoC
Reputation: 168.1
votes: 4
Local time: 5:30 PM
Location: Wiltshire, UK

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

Very Important Person

Joined: Feb 07, 2007
Last Visit: 29 Nov 2008
Posts: 373
Points: 400

Change initial sort order on clan roster 1.7 Posted: Fri Jan 25, 2008 3:43 pm
Shop Purchases:Clan Roster v1.7 Php Nuke Module · Clan Roster 2.0

no problem mate any time Rolling Eyes

LORAXX
Reputation: 6.6
Local time: 11:30 AM

Status: Offline
0.18 posts per day
Medals: 0

Joined: Jan 17, 2008
Last Visit: 25 Jul 2008
Posts: 58
Points: 712

Re: Change initial sort order on clan roster 1.7 Posted: Mon Jan 28, 2008 12:23 pm
Shop Purchases:Multi Gaming (Warrior) Theme · Clan Roster v1.7 Php Nuke Module

DoC wrote:

Hi there BlackheartBouvi,

Go to: modules/Clan_Roster/files/index.php

Highlight line: 48 - 51

Change what you have there to this:

Code:

$sql = "SELECT * FROM ".$prefix."_croster_members ORDER BY rid ASC";
}else{
$sql = "SELECT * FROM ".$prefix."_croster_members WHERE active = '1' ORDER BY rid ASC";
}

That will sort your Active members by rank. Devil

DoC

Hi DoC,

I too would like to change the default sorting. I went to my index file as indicated using crison editor but the syntax on the lines indicated did not seem right. Could you please provide the syntax that needs to be replaced instead of the line numbers. Thanks

DoC
Reputation: 168.1
votes: 4
Local time: 5:30 PM
Location: Wiltshire, UK

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

Very Important Person

Joined: Feb 07, 2007
Last Visit: 29 Nov 2008
Posts: 373
Points: 400

Change initial sort order on clan roster 1.7 Posted: Mon Jan 28, 2008 1:08 pm
Shop Purchases:Clan Roster v1.7 Php Nuke Module · Clan Roster 2.0

Hey Loraxx,

All you have to do is search for:

Code:

$sql = "SELECT * FROM ".$prefix."_croster_members ORDER BY

Then make sure that it looks like this below:

Code:

$sql = "SELECT * FROM ".$prefix."_croster_members ORDER BY rid ASC";
}else{
$sql = "SELECT * FROM ".$prefix."_croster_members WHERE active = '1' ORDER BY rid ASC";
}

The only thing you are changing from what is currently there is "rid" & "ASC"

rid = rank

ASC = Ascending Order

I can't remember what the original coding is, but it is identical apart from the last 2 words. (rid, ASC)

I think it was originally:

Code:

$sql = "SELECT * FROM ".$prefix."_croster_members ORDER BY mid DEC";
}else{
$sql = "SELECT * FROM ".$prefix."_croster_members WHERE active = '1' ORDER BY mid DEC";
}

Which is sort by MemberID (mid) and Descending (DEC) but dont quote me on this LMAO

DoC

Amazon.co.uk Widgets

LORAXX
Reputation: 6.6
Local time: 11:30 AM

Status: Offline
0.18 posts per day
Medals: 0

Joined: Jan 17, 2008
Last Visit: 25 Jul 2008
Posts: 58
Points: 712

Change initial sort order on clan roster 1.7 Posted: Mon Jan 28, 2008 6:04 pm
Shop Purchases:Multi Gaming (Warrior) Theme · Clan Roster v1.7 Php Nuke Module

Thanks.

www.clan-themes.co.uk Forum Index » General PhpNuke

6 Replies / 749 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.43 Seconds