all
a
/
b
/
c
/
f
/
h
/
j
/
jp
/
l
/
o
/
q
/
s
/
sw
/
lounge
cgi
up
wiki
Heyuri!
Bulletin Boards
2D Cute
2D Ero
2D Lolikon
3D Girls
Anime/Manga
Flash
Girl Talk
日本語/Japan
Lounge
Oekaki
Off-Topic
Site Discussion
Strange World
Overboard
Heyuri★CGI
Heyuri★CGI
@PartyII
Battle Royale R
Chat
Chinsouki★
Dating
DevChat
Drama Club
Hakoniwa Islands PvE
Hakoniwa Islands PvP
Polls
Slime Breeder
Web Banana
Web Shiritori
Yumemiru Gambler
Kakiko Checker
Other
Anime Nominations
Banners
Cytube
Heyuri Calendar
Heyuri Wiki
MAL Club
Museum
Steam Group
Uploader
[
Settings
]
[
Home
] [
Contact
] [
Catalog
] [
Search
] [
Thread list
] [
Stats
] [
Reports
] [
Watcher
] [
PMs
] [
Banners
] [
Admin
]
Submit board banners here.
Site Discussion@Heyuri
it's the place to be!
[
Return
]
Report a post
Preview
Anonymous
2024/04/18(Thu)20:56:38 ID:VO/4Tqbo
No.
66549
[
Edit
]
[
Report
]
[
Edit
] [
Report
]
▶
>>66548
dont overestimate me, its definitely not good enough for your repo. idk php. ill just explain what i done
in mod_cat
i made a urlparam for the sort type and passed it into fetchThreadList()
in pio.mysqli
fetchThreadList() i made $tmpSQL be dependent on the sort type.
then its just different sql queries to rearrange
like
if($sort="bump") $tmpSQL = 'SELECT no FROM '.$this->tablename.' WHERE resto = 0 ORDER BY '.($isDESC ? 'no' : 'root').' DESC';
elseif($sort = "lastreply") $tmpSQL = 'SELECT resto FROM '.$this->tablename.' WHERE (no, resto) IN (SELECT MAX(no), resto FROM '.$this->tablename.' GROUP BY resto) AND resto != 0 ORDER BY no DESC';
...
i only found 1 place that sets the optional $isDESC in fetchThreadList idk what for
and it's too much trouble to change every pio.DB file
it werks but... meh
im going to try making a json endpoint instead
Post number
No.
66549
Board
Site Discussion@Heyuri
Reason
Optional. Describe what's wrong with it.
Style: