Recent Topics

1 Dec 06, 2006 18:28    

Sorry if I'm asking a very basic question...

I've just added another blog in the list and now the new blog is given ID number as '5'...

http://static.flickr.com/115/315795148_76495099db.jpg

now I want to change the 'New weblog' ID to '4' and change the 'Linkblog' to '5' (last in the list)

how?

thank you...

2 Dec 06, 2006 20:03

This is not possible, without editing the database directly.
Of course the "Blog ID" gets used in other tables (e.g. "evo_coll_user_perms" for user permissions), so it needs to get changed there as well. See http://doc.b2evolution.net/DB_schema/b2evo_1_8.png for the DB relations.

I'd not recommend to change it.

In fact, this is rather a feature request to have something like a "sort_order" field for the evo_blogs database.

The best solution is probably to hack/change the part where the order is important for you.

The medium clean solution would be to add a "my_sort_order" column into the evo_blogs table and add an "ORDER BY my_sort_order" where the list gets generated with SQL.

I hope this helps, at least a bit.. :)

3 Dec 07, 2006 00:58

blueyed wrote:

This is not possible, without editing the database directly.
Of course the "Blog ID" gets used in other tables (e.g. "evo_coll_user_perms" for user permissions), so it needs to get changed there as well. See http://doc.b2evolution.net/DB_schema/b2evo_1_8.png for the DB relations.

I'd not recommend to change it.

In fact, this is rather a feature request to have something like a "sort_order" field for the evo_blogs database.

The best solution is probably to hack/change the part where the order is important for you.

The medium clean solution would be to add a "my_sort_order" column into the evo_blogs table and add an "ORDER BY my_sort_order" where the list gets generated with SQL.

I hope this helps, at least a bit.. :)

to edit the database directly is not an easy task for me...

so I think I need to do it the hard way.... re-organize the database manually... need some creativity.....

thanx anyway my friend...


Form is loading...