stm_article_order: Arbitrary sort order for your articles

uli · 2011-03-14 21:46:45

phuture303 wrote:

Is is possible that the “automatic positioning” is the other way round?

Never tried it, but it should be feasible. However, do a MySQL backup of the database before, just in case anything goes awry. There wouldn’t be v0.2.4 of the plugin if I hadn’t backed up my db ;)

Open the plugin in a text editor, go to line 40 (at least it’s 40 in my copy), and find at the end of the line where it says

order by position"); (It’s the sole occurrence.)

Add asc after position so now the line ends

order by position asc");

Press “Save”.
If the results on the front side of your site look south topmost, alter the order value of the Txp tags that are using position from asc to desc and vice versa.

Last edited by uli (2011-03-14 21:48:07)

uli · 2011-03-14 23:32:42

I wrote:

The longer I think about it the more I like the idea of having one tab for sorting everything! And this can probably be extended for sorting categories, too.

jens31 and phuture303, as a response to both your votes: I said the above as a reply to Nora’s/nabrown76’s post #92. Well, rather after reading the post she linked. I think drag’n‘drop sorting of everything became possible with a good portion of thinking out of the box that Nora proved she’s capable of and was kind enough to share.

nabrown78 · 2011-03-15 00:25:00

I will submit the tip to txptips in a more organized fashion soon!

jstubbs · 2011-03-15 02:40:33

@Nora – yes that would be great and very helpful!

hablablow · 2011-03-19 10:10:49

This looks great, thank you uli !
Just curious if this can be done / easily tweaked / on a category basis instead of sections ?
Re-arranging categories ? And why not re-arranging articles within categories ?
Thanks !

uli · 2011-03-19 14:04:40

hablablow wrote:

Re-arranging categories ?

Guilleaume, you you can go ahead and sort categories if you follow Nora’s tip she linked to some posts above (if that’s what you have in mind).

Re your other questions: I can’t tell offhand if replacing sections by categories would work, I’m just another designer “coding”. For me this would mean to maintain two versions of the code, a fact that I consider as not too enticing.

What’d be easily doable, though, is inserting another CSS class for the category an article belongs to, so that you could have e.g. color codes for categories. That’s what I had in mind for the next release, at least if there will be another one.

hablablow · 2011-03-19 14:27:35

Vielen dank für deine Antwort Uli.

In fact yes I would like to re-arrange categories and so replace the built-in section feature…
And so be able to re-arrange categories order.
If you don’t mind, I’ll put my designer’s hands into your code and try to walk through the “categories way”…

If someone wishes to do the same, I’ll be glad to share experience and do this the many brains / many hands way…

Last edited by hablablow (2011-03-19 14:30:52)

Teemu · 2011-05-26 11:30:04

I’m wondering if I have missed something or this plugin has some compatibility issues?

I installed the latest v0.2.4, enabled it and added ‘position asc’ as a sort value to my article tag. However it gives me error in the frontend:

Tag error: <txp:article sort=“position asc” /> -> Textpattern Warning: Unknown column ‘position’ in ‘order clause’

I’m running TXP 4.4.0, MLP and several plugins like adi_menu etc.

Last edited by Teemu (2011-05-26 11:32:24)

uli · 2011-05-26 11:38:10

Did you use the plugin, i.e. pressed the Save button at least once?

Teemu · 2011-05-26 13:43:18

Yes I did, tried a few times. Error remains.

I tried it on another site with TXP 4.2.0, got it working out of the box. Anyone confirmed compatibility with TXP 4.4.0?

Last edited by Teemu (2011-05-26 14:08:53)

GugUser · 2011-05-26 15:34:53

Teemu schrieb:

Anyone confirmed compatibility with TXP 4.4.0?

I don’t have problems with TxP 4.4 and smt_article_order 2.4.

uli · 2011-05-26 16:07:07

GugUser wrote:

I don’t have problems with TxP 4.4 and smt_article_order 2.4.

Me neither. I just deleted the position column, and it got created by simply pushing the Save button. So, have you thought of emptying the cache, Teemu?

Textpattern CMS

Textpattern CMS support forum

#97 2011-03-14 21:46:45

Re: stm_article_order: Arbitrary sort order for your articles

#98 2011-03-14 23:32:42

Re: stm_article_order: Arbitrary sort order for your articles

#99 2011-03-15 00:25:00

Re: stm_article_order: Arbitrary sort order for your articles

#100 2011-03-15 02:40:33

Re: stm_article_order: Arbitrary sort order for your articles

#101 2011-03-19 10:10:49

Re: stm_article_order: Arbitrary sort order for your articles

#102 2011-03-19 14:04:40

Re: stm_article_order: Arbitrary sort order for your articles

#103 2011-03-19 14:27:35

Re: stm_article_order: Arbitrary sort order for your articles

#104 2011-05-26 11:30:04

Re: stm_article_order: Arbitrary sort order for your articles

#105 2011-05-26 11:38:10

Re: stm_article_order: Arbitrary sort order for your articles

#106 2011-05-26 13:43:18

Re: stm_article_order: Arbitrary sort order for your articles

#107 2011-05-26 15:34:53

Re: stm_article_order: Arbitrary sort order for your articles

#108 2011-05-26 16:07:07

Re: stm_article_order: Arbitrary sort order for your articles

Board footer