Skip to main content ↑ ↓
Importing Started by fritzelly · · Read 4490 times 0 Members and 1 Guest are viewing this topic. previous topic - next topic

Importing

i'm importing a whole load of threads from another forum
issue is they all show at the top of the threads i.e. newer threads started with software are on the last page
i've looked thru the tables but cannot see where they are getting a newer timestamp showing them first

Re: Importing

Reply #1 –

@fritzelly there are several discussions about this: the sorting of topics and posts in elkarte is done using the id of the topic/post, and not with the timestamp. that means that when importing if the import just creates new topics on top of the existing everything will be kind of messed up.

i guess, at that point, your only solution is change the sorting code and make it sort by timestamp instead of id.
i don't have an answer ready, i have to dig a moment in the code.
bugs creator.
features destroyer.
template killer.

Re: Importing

Reply #2 –

i'm searching the code but not having any luck in finding the right routine that affects it.

Re: Importing

Reply #3 –

so narrowed it down to this function in messageindex.subs.php i think
function messageindexsort()

now just need to find the code that is calling it as the poster_time doesn't seem to be part of the columns called.

Re: Importing

Reply #4 –

you can try changing:
Code: [Select]
'first_post' => 't.id_topic',
to:
Code: [Select]
'first_post' => 'mf.poster_time',
i'm not entirely sure, but worth a try.
bugs creator.
features destroyer.
template killer.

Re: Importing

Reply #5 –

that did it but changing last_post so its ordered by last comment

thanks

Re: Importing

Reply #6 –

actually doesn't work - first page and last page ok but any pages in between give this error

unknown column 'mf.poster_time' in 'order clause

Re: Importing

Reply #7 –

okay, yes indeed.

the replacement should be:
Code: [Select]
		'first_post' => 't.id_topic',
		'last_post' => 't.id_last_msg'
to:
Code: [Select]
'first_post' => 'mf.poster_time',
'last_post' => 'ml.poster_time'
and this redefines the sorting order for last message (from message id to last post time) and first message (from topic id to first post time).

and, same file:
Code: [Select]
FROM {db_prefix}topics AS t' . ($sort_by === 'last_poster' ? '
to:
Code: [Select]
FROM {db_prefix}topics AS t' . (in_array($sort_by, array('last_poster', 'last_post') ? '
this should join the messages table (last => ml) for both last_poster and last_post (as modified above).
and:
Code: [Select]
in_array($sort_by, array('starter', 'subject'))
to:
Code: [Select]
in_array($sort_by, array('starter', 'subject', 'first_post'))
to join the message table (first => mf) for all the cases, including the above modified first_post.

again, not tested (i'm working on other stuff and i don't have handy a good place to test)... sorry. :)
bugs creator.
features destroyer.
template killer.

Re: Importing

Reply #8 –

cheers will check it later

Re: Importing

Reply #9 –

that seems to be working fine, thanks emanuele

Re: Importing

Reply #10 –

yw. :)
bugs creator.
features destroyer.
template killer.

Re: Importing

Reply #11 –

don't know if you saw the question about the friendly url stuff you were doing a good while ago.
if it's dead in the water i will have a look at it this weekend, starting to get a grip on the code now and got plenty of experience coding friendly urls - not sure how i write it as an addon  but if i can point out the stuff to add maybe you can do the compiling bit?

Re: Importing

Reply #12 –

nope, where is it?
bugs creator.
features destroyer.
template killer.