Skip to main content
Topic: BoardIndex be hungry! Yarr!! (Read 2148 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

BoardIndex be hungry! Yarr!!

Sample data:
Code: [Select]
INSERT INTO [icode]elkarte_boards[/icode] ([icode]id_board[/icode], [icode]id_cat[/icode], [icode]child_level[/icode], [icode]id_parent[/icode], [icode]board_order[/icode], [icode]id_last_msg[/icode], [icode]id_msg_updated[/icode], [icode]member_groups[/icode], [icode]id_profile[/icode], [icode]name[/icode], [icode]description[/icode], [icode]num_topics[/icode], [icode]num_posts[/icode], [icode]count_posts[/icode], [icode]id_theme[/icode], [icode]override_theme[/icode], [icode]unapproved_posts[/icode], [icode]unapproved_topics[/icode], [icode]redirect[/icode], [icode]deny_member_groups[/icode]) VALUES
(1, 1, 0, 0, 26, 762054, 762054, '-1,0,2', 1, 'General Discussion', 'Feel free to talk about anything and everything in this board.', 159, 30216, 0, 0, 0, 0, 0, '', ''),
(2, 6, 0, 0, 2, 762013, 762013, '', 1, 'Board Number 2', 'lorem ipsum placerat libero aptent, suscipit donec.', 185, 30347, 0, 0, 0, 0, 0, '', ''),
(3, 1, 1, 1, 27, 762059, 762059, '', 1, 'Board Number 3', 'lorem ipsum fusce magna lorem volutpat praesent suscipit, volutpat tortor at aenean cubilia.', 208, 30603, 0, 0, 0, 0, 0, '', ''),
(4, 1, 3, 5, 33, 762053, 762053, '', 1, 'Board Number 4', 'lorem ipsum enim eleifend nostra volutpat congue, curabitur lacinia odio augue.', 174, 30855, 0, 0, 0, 0, 0, '', ''),
(5, 1, 2, 3, 31, 762043, 762043, '', 1, 'Board Number 5', 'lorem ipsum suscipit hac et odio blandit feugiat vestibulum viverra, turpis justo non elit vehicula dapibus vivamus dapibus. risus rutrum enim augue non, metus porttitor.', 184, 30591, 0, 0, 0, 0, 0, '', ''),
(6, 2, 0, 0, 14, 762049, 762049, '', 1, 'Board Number 6', 'lorem ipsum mollis consectetur donec fermentum praesent, amet in nullam euismod tellus, sed duis elit enim donec.', 167, 30424, 0, 0, 0, 0, 0, '', ''),
(7, 4, 0, 0, 9, 762057, 762057, '', 1, 'Board Number 7', 'lorem ipsum tempus dictum morbi erat himenaeos blandit, euismod faucibus odio quis eu maecenas, dictumst nisi et quis turpis et. vulputate feugiat leo habitasse, potenti etiam.', 206, 30566, 0, 0, 0, 0, 0, '', ''),
(8, 1, 1, 1, 36, 762058, 762058, '', 1, 'Board Number 8', 'lorem ipsum orci nulla massa gravida vitae tellus inceptos, tincidunt aenean lacus dapibus sodales curae aenean.', 164, 30570, 0, 0, 0, 0, 0, '', ''),
(9, 4, 2, 12, 11, 762255, 762255, '', 1, 'Board Number 9', 'lorem ipsum etiam sapien et purus pulvinar morbi elit, eros tempus malesuada cubilia sodales quis pretium.', 166, 30693, 0, 0, 0, 0, 0, '', ''),
(10, 2, 0, 0, 12, 762039, 762039, '', 1, 'Board Number 10', 'lorem ipsum varius ornare sapien quis luctus purus commodo a, enim vivamus fames ut dictum primis sagittis vivamus, taciti nostra sem scelerisque quisque proin donec phasellus.', 153, 30386, 0, 0, 0, 0, 0, '', ''),
(11, 6, 1, 2, 3, 762048, 762048, '', 1, 'Board Number 11', 'lorem ipsum risus habitant turpis molestie potenti, curabitur maecenas auctor quisque commodo posuere himenaeos, hendrerit tempor semper blandit inceptos. porta quis massa eu, iaculis nisl.', 168, 30169, 0, 0, 0, 0, 0, '', ''),
(12, 4, 1, 7, 10, 762055, 762255, '', 1, 'Board Number 12', 'lorem ipsum porttitor diam fames porttitor mauris, eu feugiat senectus suscipit. nam viverra sagittis cursus, ac nibh.', 172, 30652, 0, 0, 0, 0, 0, '', ''),
(13, 1, 0, 0, 17, 762032, 762032, '', 1, 'Board Number 13', 'lorem ipsum et ad litora phasellus dapibus metus ipsum laoreet, fusce pellentesque odio sapien at fermentum nulla.', 172, 30584, 0, 0, 0, 0, 0, '', ''),
(14, 6, 0, 0, 1, 762008, 762008, '', 1, 'Board Number 14', 'lorem ipsum et vitae, morbi amet ipsum, iaculis libero.', 208, 30553, 0, 0, 0, 0, 0, '', ''),
(15, 1, 1, 1, 37, 762025, 762025, '', 1, 'Board Number 15', 'lorem ipsum hac vitae vivamus duis ut faucibus bibendum nostra, hendrerit sodales aptent primis scelerisque pharetra dapibus fringilla.', 173, 30584, 0, 0, 0, 0, 0, '', ''),
(16, 2, 1, 10, 13, 762050, 762050, '', 1, 'Board Number 16', 'lorem ipsum posuere sodales hendrerit pulvinar aenean, justo turpis donec aptent rutrum suscipit placerat, primis faucibus egestas lorem egestas. sit posuere aliquam diam, commodo.', 171, 30401, 0, 0, 0, 0, 0, '', ''),
(17, 1, 3, 5, 19, 762010, 762010, '', 1, 'Board Number 17', 'lorem ipsum fringilla quam, turpis.', 183, 30655, 0, 0, 0, 0, 0, '', ''),
(18, 4, 0, 0, 7, 762060, 762060, '', 1, 'Board Number 18', 'lorem ipsum orci vulputate dictumst inceptos, id hac nostra.', 164, 30425, 0, 0, 0, 0, 0, '', ''),
(19, 2, 1, 6, 15, 762041, 762041, '', 1, 'Board Number 19', 'lorem ipsum arcu quam velit ante dui lorem consectetur ullamcorper, scelerisque vitae mattis auctor consectetur felis tellus nisl malesuada quisque, netus ipsum pretium purus a interdum convallis scelerisque.', 176, 30550, 0, 0, 0, 0, 0, '', ''),
(20, 4, 0, 0, 6, 762020, 762020, '', 1, 'Board Number 20', 'lorem ipsum volutpat ornare condimentum eleifend feugiat tristique posuere id, etiam viverra consequat mattis a eu class. nulla ultricies faucibus tempor, diam tempus.', 179, 30117, 0, 0, 0, 0, 0, '', ''),
(21, 2, 1, 6, 16, 761982, 761982, '', 1, 'Board Number 21', 'lorem ipsum condimentum etiam ipsum id elit litora magna aenean ultrices, cras luctus accumsan per dictum rutrum massa mauris. habitasse neque inceptos sapien eros, fusce libero.', 155, 30152, 0, 0, 0, 0, 0, '', ''),
(22, 5, 0, 0, 4, 761985, 761985, '', 1, 'Board Number 22', 'lorem ipsum nec consectetur, molestie.', 170, 30294, 0, 0, 0, 0, 0, '', ''),
(23, 4, 0, 0, 5, 761972, 761972, '', 1, 'Board Number 23', 'lorem ipsum pretium sagittis, aenean praesent.', 164, 30382, 0, 0, 0, 0, 0, '', ''),
(24, 1, 1, 1, 35, 762028, 762028, '', 1, 'Board Number 24', 'lorem ipsum ligula fermentum, nostra.', 170, 30530, 0, 0, 0, 0, 0, '', ''),
(25, 1, 3, 5, 32, 762045, 762045, '', 1, 'Board Number 25', 'lorem ipsum erat ac iaculis, ut in.', 166, 30763, 0, 0, 0, 0, 0, '', '');
COMMIT;

Re: BoardIndex be hungry! Yarr!!

Reply #1

Technically, the order_id are wrong.
Did you create the boards by yourself or... maybe by the populator?
Bugs creator.
Features destroyer.
Template killer.

Re: BoardIndex be hungry! Yarr!!

Reply #2

the populaor, then I used the admin interface to change some board ordering and nesting.

Doesn't the populator use createBaard()?
LiveGallery - Simple gallery addon for ElkArte

Re: BoardIndex be hungry! Yarr!!

Reply #3

Dunno, but anyway board_order is enforced by the controller, not by createBoard.
In your export the board 5 has order 31, while board 17 has order 19, this is the source of the confusion. board 17 should have an order higher than 5 (like board 4 (33) and 25 (32)).
I feel like changing the code in BoardsList.class to ignore the ordering and create parents before they are found is not possible, because we would not know which one is the grandparent... actually, it may be possible using extensively classes (i.e. instead of using an array, create a class for each board and then use references to link them, since each board can have only 1 parent, insert a new parent at any level should be safe), but I'm not entirely sure it is worth in this scenario.
It should be easier to fix populator or create a maintenance task to fix the ordering... well, that may not be so easy...
Bugs creator.
Features destroyer.
Template killer.

Re: BoardIndex be hungry! Yarr!!

Reply #4

I think I figured it out. Drag a board that has subs below another board and witness said subs not get their order updated, thus having a low number.

Suggest fix: uses a custom query to update all boards in xmlhtttp using a CASE WHEN... END.
LiveGallery - Simple gallery addon for ElkArte

Re: BoardIndex be hungry! Yarr!!

Reply #5

Does the "normal" moving work? (i.e. not the D&D one, the "click and click and click")
Bugs creator.
Features destroyer.
Template killer.


Re: BoardIndex be hungry! Yarr!!

Reply #7

 emanuele is innocent!
Bugs creator.
Features destroyer.
Template killer.