Blog
Developers
Careers
Support
Contact
Gossamer Threads
Solutions
Results
About
Mailing Lists
Resource Centre
Forum
Tools
Home
Who's Online
Tags
Favourites
Login
Forum Search
(
Advanced Search
)
This forum
This category
All forums
for
Home
:
Products
:
Gossamer Links
:
Development, Plugins and Globals
:
[NEW PLUGIN] SearchByDate
(Page 2 of 2)
1 of 2
2 of 2
View All
1
2
Previous Thread
Next Thread
Print Thread
View Threaded
Nov 3, 2011, 1:37 AM
MJ_
User
(242 posts)
Nov 3, 2011, 1:37 AM
Post #26 of 30
Views: 3652
Shortcut
Re: [Andy] [NEW PLUGIN] SearchByDate
In reply to
Hi Andy,
> simply the linkID, catIDs and date)
With "date", it be possible?
Thanks!
Mick
Nov 3, 2011, 1:43 AM
Andy
Veteran
/ Moderator
(18441 posts)
Nov 3, 2011, 1:43 AM
Post #27 of 30
Views: 3618
Shortcut
Re: [MJ_] [NEW PLUGIN] SearchByDate
In reply to
Hi,
In searchdata.cgi, you could try changing: (around line 128)
Code:
my $tbl = $DB->table('DateSearch');
..to:
Code:
my $tbl = $DB->table('DateSearch');
$tbl->select_options('ORDER BY Date ASC');
I'm a little suprised that code wasn't in there already (cos atm, it was just sorting by the default field - the LinkID)
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my
Amazon Wish List
GLinks ULTRA Package
|
GLinks ULTRA Package PRO
Links SQL Plugins
|
Website Design and SEO
|
UltraNerds
|
ULTRAGLobals Plugin
|
Pre-Made Template Sets
|
FREE GLinks Plugins!
Nov 3, 2011, 9:02 AM
MJ_
User
(242 posts)
Nov 3, 2011, 9:02 AM
Post #28 of 30
Views: 3414
Shortcut
Re: [Andy] [NEW PLUGIN] SearchByDate
In reply to
Hi Andy,
I tested several times, but there is no change.
Code:
my $tbl = $DB->table('DateSearch');
$tbl->select_options('ORDER BY Date DESC');
my $totalrows;
my $cond = new GT::SQL::Condition;
my $sth;
Do You have a suggestion?
Thanks!
Mick
Nov 3, 2011, 10:02 AM
Andy
Veteran
/ Moderator
(18441 posts)
Nov 3, 2011, 10:02 AM
Post #29 of 30
Views: 3490
Shortcut
Re: [MJ_] [NEW PLUGIN] SearchByDate
In reply to
Hi,
Sorry, you probably need to also edit this:
Code:
if (defined $limit) {
$tbl->select_options("LIMIT $limit,$hits_per_page");
}
..to:
Code:
if (defined $limit) {
$tbl->select_options("ORDER BY Add_Date DESC LIMIT $limit,$hits_per_page");
} else {
$tbl->select_options("ORDER BY Add_Date DESC");
}
Hopefully that'll work
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my
Amazon Wish List
GLinks ULTRA Package
|
GLinks ULTRA Package PRO
Links SQL Plugins
|
Website Design and SEO
|
UltraNerds
|
ULTRAGLobals Plugin
|
Pre-Made Template Sets
|
FREE GLinks Plugins!
Nov 3, 2011, 11:12 AM
MJ_
User
(242 posts)
Nov 3, 2011, 11:12 AM
Post #30 of 30
Views: 3433
Shortcut
Re: [Andy] [NEW PLUGIN] SearchByDate
In reply to
Hi Andy,
It is perfect ! Thanks again. :)
Mick
1 of 2
2 of 2
View All
1
2
Previous Thread
Next Thread
Print Thread
View Threaded