Status: offline

ronack

Forum User
Full Member
Registered: 05/27/03
Posts: 612
I have a lot of topics and decided I wanted to give them bigger sort numbers leaving room between the numbers for other things and some topics I always wanted on the bottom. Like General or Site News. So I tried to give them a sort number of 999 or 800 but it always revierted back to 127. Normally this isn't a problem for small sites but if you eve want a number over 127 then your screwed, or are you?

I don't know if you want to change this or just leave it as a hack. I went into mysql and changed the Topic Sort Number from a data type of TinyINT to SmallINT. TinyINT limits you to 127 where SmallINT is much much larger. Something like 62767.

Now I can sort my topics by 10's or 100's if I want to leave room topics in between. And I can set General to 999 so that it's always on the bottom. Doesn't seem to hurt the performance any either.

Status: Banned

machinari

Forum User
Full Member
Registered: 03/22/04
Posts: 1512

this really seems unnecessary. if you want topics in the middle, just use a middle number and the rest of your topics will accomodate that. If you use a number already in use, not to worry, the other topics will still accommodate that.

Or are you suggesting that you may actually put more than 127 topics on your page?