- its apparently still possible to DDOS the forum by searching Posts and Messages with a single wildcard * (put some limits on that query or optimize it so it actually works)
- some forum ids cant be searched. include them in the queries
eg v2 scripts & functions search.php?keywords=*&terms=any&author=&fid%5B%5D=83&sc=1&sf=titleonly&sr=topics&sk=t&sd=d&st=7&ch=300&t=0&submit=Search
fix the advanced search SQL backend
fix the advanced search SQL backend
Re: fix the advanced search SQL backend
@tank
Perhaps we could also give this "Sphinx" search backend a try? apparently is it much faster...
Perhaps we could also give this "Sphinx" search backend a try? apparently is it much faster...
Windows 10 x64 Professional, Intel i5-8500, NVIDIA GTX 1060 6GB, 2x16GB Kingston FURY Beast - DDR4 3200 MHz | [About Me] | [About the AHK Foundation] | [Courses on AutoHotkey]
[ASPDM - StdLib Distribution] | [Qonsole - Quake-like console emulator] | [LibCon - Autohotkey Console Library]
Re: fix the advanced search SQL backend
I'll send tank a direct message and ask him again.
Windows 10 x64 Professional, Intel i5-8500, NVIDIA GTX 1060 6GB, 2x16GB Kingston FURY Beast - DDR4 3200 MHz | [About Me] | [About the AHK Foundation] | [Courses on AutoHotkey]
[ASPDM - StdLib Distribution] | [Qonsole - Quake-like console emulator] | [LibCon - Autohotkey Console Library]
Re: fix the advanced search SQL backend
i dunno what you mean by DDOS with a single wildcard. Yes YOUR session will become unusable during the course but it would take many such sessions occuring at the same time to DDOS and there are other mechinisms in place to account for that
We are troubled on every side‚ yet not distressed; we are perplexed‚
but not in despair; Persecuted‚ but not forsaken; cast down‚ but not destroyed;
Telegram is the best way to reach me
https://t.me/ttnnkkrr
If you have forum suggestions please submit a
Check Out WebWriter
but not in despair; Persecuted‚ but not forsaken; cast down‚ but not destroyed;
Telegram is the best way to reach me
https://t.me/ttnnkkrr
If you have forum suggestions please submit a
Check Out WebWriter
Re: fix the advanced search SQL backend
ah ok, i dont see whats going on with the rest of the forum in the background once i lock myself out. i just get a cloudflare page so i assumed everybody did
then maybe reduce the query timeout down to like 5 mins. i just retested it and it locked me out for about an hour
then maybe reduce the query timeout down to like 5 mins. i just retested it and it locked me out for about an hour
Re: fix the advanced search SQL backend
It looks like sphinx could be the fastest option, but no guarantee and it does require some setup with possible significant space usage/overhead
Windows 10 x64 Professional, Intel i5-8500, NVIDIA GTX 1060 6GB, 2x16GB Kingston FURY Beast - DDR4 3200 MHz | [About Me] | [About the AHK Foundation] | [Courses on AutoHotkey]
[ASPDM - StdLib Distribution] | [Qonsole - Quake-like console emulator] | [LibCon - Autohotkey Console Library]