Twitter SMFHacks Facebook SMFHacks SMFHacks.com
** Home Forum Index Hacks Products Login Register Search
Welcome, Guest. Please login or register.
September 15, 2014, 07:50:53 pm

Login with username, password and session length
Members
Total Members: 11329
Latest: stramonium
Stats
Total Posts: 35583
Total Topics: 5956
Online Today: 97
Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Users: 0
Guests: 44
Total: 44
+ 
|-+ 
| |-+ 
| | |-+ 
| | | |-+ 
| | | | |-+ 
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Print
Author Topic: [1.3.9] order products by ID_ITEM DESC  (Read 2329 times)
Vincent Volmer
Community Suite Customer
Hero Member
******
Offline Offline

Posts: 500


SMF 2.0.1


View Profile WWW
« on: May 27, 2010, 02:25:11 pm »

Hello SMFHacks,

I have changed a bit of the code in Store2.template.php to let it order products by ID_ITEM DESC

find (line 79 in Store2.template.php)
Code:
ORDER BY i.itemorder DESC LIMIT $context[start]," . $modSettings['store_set_items_per_page']);

replace with
Code:
ORDER BY i.ID_ITEM DESC LIMIT $context[start]," . $modSettings['store_set_items_per_page']);

I don't know what itemorder does but it shuffles the items instead of the newest items in first place.

Thanks,
Vincent
Logged

SMFHacks
Administrator
Hero Member
*****
Offline Offline

Posts: 12195


View Profile
« Reply #1 on: May 27, 2010, 02:33:49 pm »

It is used if you want to have a custom order for your products instead of the latest so you can use the up/down on an item to reorder it.
Logged

Get your Forum Ranked! at http://www.forumrankings.net - find out how your forum compares with others! Also contests/promotions for verified sites.
Vincent Volmer
Community Suite Customer
Hero Member
******
Offline Offline

Posts: 500


SMF 2.0.1


View Profile WWW
« Reply #2 on: May 27, 2010, 02:35:58 pm »

It is used if you want to have a custom order for your products instead of the latest so you can use the up/down on an item to reorder it.

Oh, okay....thanks for your explanation! Maybe you can make it an option? Order by ID or custom order?
Logged

Pages: [1] Go Up Print 
« previous next »
Jump to:  

Recent
[Today at 01:33:11 pm]

[September 14, 2014, 07:19:50 pm]

[September 14, 2014, 02:57:10 pm]

[September 14, 2014, 11:17:58 am]

[September 14, 2014, 11:05:10 am]

[September 14, 2014, 11:04:35 am]

[September 14, 2014, 09:46:47 am]

[September 13, 2014, 06:56:02 pm]

[September 13, 2014, 03:06:03 pm]

[September 13, 2014, 03:00:13 pm]
Random Picture
Donate to SMFHacks.com
Help Support the SMFHacks.com mod making.
Powered by SMF 1.1.19 | SMF © 2013, Simple Machines
TinyPortal v0.9.7 © Bloc
SMF and SimpleMachines are registered trademarks of Simple Machines. SMFHacks.com is not affiliated with nor endorsed by Simple Machines.
Page created in 1.264 seconds with 20 queries.