Forums » Bugs

Duel stats search function is broken

Sep 11, 2005 roguelazer link
Type Roguelazer in the search box. Press search. It goes to page 12. I'm not on page 12.
Sep 11, 2005 Beolach link
It's been broken for some time now.
http://www.vendetta-online.com/x/msgboard/2/9705

[edit]
Observations: the page number the search goes to is never lower that the page number the searched-for player is actually on, if it doesn't return the correct page it will always be a higher page number (i.e., searching for Roguelazer gives page 12, when Roguelazer is actually on page 10).

There are 50 players on page 1, and searching for any of the top 45 (Dubh and above, at the time of this post) on page 1 gives page 1, while searching for the bottom 5 (Splash and below) gives page 2. On page 2, there are 48 players, and searching for the top 37 (Ruby and above) gives page 2, and searching for the bottom 11 (Defense Ship 4 and below) gives page 3. More than half of the players on pages 5 through 8 are not found correctly by the search, and searching for any player who is on page 9 or higher will return an incorrect page. That means well over half of the players in the duel ranking database cannot be found correctly using search.

There doesn't seem to be a specific number of players on each page:
Page # - Number of players on that page
1 - 50
2 - 48
3 - 50
4 - 48
5 - 47
6 - 49
7 - 47
8 - 50
9 - 50
10 - 49
11 - 50
12 - 49
13 - 48
14 - 50
15 - 49
16 - 50
17 - 50
18 - 49
19 - 50
20 - 50
21 - 50
22 - 12
[/edit]
Sep 12, 2005 a1k0n link
Ah yeah, it's probably being bit by deleted characters again, so the search deteriorated over time... Hmm, if only you could delete from a right outer join in SQL.