Register - Login
Views: 99393326
 Main - Memberlist - Active users - Calendar - Wiki - IRC Chat - Online users
Ranks - Rules/FAQ - Stats - Latest Posts - Color Chart - Smilies		 04-24-22 10:24:08 AM
Jul - Meta - announcements bug New poll - New thread - Thread closed
Next newer thread | Next older thread
skyu

Level: 21


Posts: 28/96
EXP: 43537
For next: 6406

Since: 06-11-16

From: a grave

Since last post: 3.2 years
Last activity: 3.8 years
Posted on 08-11-16 04:40:57 PM Link
alright, so in all forums, if I click on Xkeeper's userlink from the announcement bar, it takes me to user profile 34, not 1. said profile doesn't exist anymore, so I don't know who's it is.

anyone else receiving this problem?

____________________
Arisotura
Member
Level: 49


Posts: 321/614
EXP: 880012
For next: 3871

Since: 02-24-13

From: your dreams

Since last post: 93 days
Last activity: 51 days
Posted on 08-11-16 04:44:08 PM Link
looks like it's picking the announcement ID instead of the user ID. good old 'id' confusion.

____________________
Kuribo64 -- NSMB2 hacking and other crap
Cuber456

Fuzzy
Don't mind me. Just passing through.
Level: 56


Posts: 683/776
EXP: 1317936
For next: 80240

Since: 02-19-12

From: Everywhere at once.

Since last post: 4.2 years
Last activity: 122 days
Posted on 08-11-16 08:54:44 PM Link
Honestly, I wouldn't worry about it.

It makes sense. Not sure how JUL does it but I'd guess that every time a user signs up, their ID is +1 greater from the previous user. Hence, all IDs are unique. For whatever reason, the admins got rid of or blocked ID 1 and so forth but kept using the same algorithm to assign IDs.

____________________
Zero Time Dilemma is Out!!!
Xkeeper

Level: 263


Posts: 21808/25343
EXP: 296722322
For next: 2238131

Since: 07-03-07

Pronouns: they/them/????????

Since last post: 9 days
Last activity: 3 days
Posted on 08-11-16 09:03:25 PM Link
You're misunderstanding the problem; the announcement link is using the wrong ID number (the announcement ID) when it should be using the member ID.

It's probably a dumb typo somewhere. It's been a known bug forever but patching bugs is suffering.

Maybe someone should report it on the github repo

____________________
(Testing: 21808 posts, level 230, 185774782 EXP)
Arisotura
Member
Level: 49


Posts: 322/614
EXP: 880012
For next: 3871

Since: 02-24-13

From: your dreams

Since last post: 93 days
Last activity: 51 days
Posted on 08-11-16 09:07:40 PM Link
you're right there, but they didn't get rid of ID 1. Xkeeper is still ID 1.

the following query is used to retrieve the last announcement and its associated metadata:

SELECT announcements.id,user,date,announcements.title,name,sex,powerlevel FROM announcements,users WHERE forum=0 AND user=users.id ORDER BY date DESC LIMIT 1

so you get an array with the following fields:

id -> announcement ID
user -> user ID
date -> date it was posted at
title -> announcement title
name -> user name
sex -> user sex
powerlevel -> user powerlevel

the data is passed to getuserlink() to get the userlink that is displayed. That function expects the 'id' field to be the user ID.

____________________
Kuribo64 -- NSMB2 hacking and other crap
Cuber456

Fuzzy
Don't mind me. Just passing through.
Level: 56


Posts: 685/776
EXP: 1317936
For next: 80240

Since: 02-19-12

From: Everywhere at once.

Since last post: 4.2 years
Last activity: 122 days
Posted on 08-11-16 09:23:10 PM Link
Whoops. I'm like half asleep right now.

____________________
Zero Time Dilemma is Out!!!
Octangula

Level: 10


Posts: 6/17
EXP: 3221
For next: 1193

Since: 07-12-16

Pronouns: they/them

Since last post: 4.2 years
Last activity: 3.5 years
Posted on 08-13-16 12:08:00 AM Link
I hate to admit it, but even with my experience with computers, SQL still feels effing terrifyingly like a language that makes less sense than English (which, like Java, is a language of exceptions)...

(And talking of language, is there a policy on swearing here? I usually wouldn't censor myself there, but feels better to ask before putting my foot in it...)
skyu

Level: 21


Posts: 37/96
EXP: 43537
For next: 6406

Since: 06-11-16

From: a grave

Since last post: 3.2 years
Last activity: 3.8 years
Posted on 08-13-16 01:01:51 AM Link
there's no policy on swearing, no

just.. look at old posts from 2007

____________________
Arisotura
Member
Level: 49


Posts: 327/614
EXP: 880012
For next: 3871

Since: 02-24-13

From: your dreams

Since last post: 93 days
Last activity: 51 days
Posted on 08-13-16 06:57:51 AM Link
anyway, either swear openly or don't swear at all-- self-censoring looks dumb imo


on a more on-topic note, I sent a pull request for this matter... wait until it's merged in, I guess

____________________
Kuribo64 -- NSMB2 hacking and other crap
Xkeeper

Level: 263


Posts: 21890/25343
EXP: 296722322
For next: 2238131

Since: 07-03-07

Pronouns: they/them/????????

Since last post: 9 days
Last activity: 3 days
Posted on 12-23-16 02:34:18 AM Link
It is merged in. It only took a few months.

____________________
(Lv 232 with 190528049 EXP)
Next newer thread | Next older thread
Jul - Meta - announcements bug New poll - New thread - Thread closed


Rusted Logic
Acmlmboard - commit 47be4dc [2021-08-23]
©2000-2022 Acmlm, Xkeeper, Kaito Sinclaire, et al.

29 database queries, 4 query cache hits.
Query execution time:  0.106510 seconds
Script execution time:  0.014945 seconds
Total render time:  0.121455 seconds


TidyHTML vomit below
line 1 column 1 - Warning: missing <!DOCTYPE> declaration
line 119 column 11 - Warning: <form> isn't allowed in <table> elements
line 118 column 10 - Info: <table> previously mentioned
line 120 column 11 - Warning: missing <tr>
line 120 column 119 - Warning: missing </font> before </td>
line 124 column 16 - Warning: plain text isn't allowed in <tr> elements
line 120 column 11 - Info: <tr> previously mentioned
line 125 column 68 - Warning: missing </nobr> before </td>
line 141 column 68 - Warning: missing </nobr> before <tr>
line 147 column 35 - Warning: missing <tr>
line 147 column 50 - Warning: missing </font> before </td>
line 148 column 37 - Warning: unescaped & or unknown entity "&id"
line 147 column 170 - Warning: missing </font> before </table>
line 149 column 35 - Warning: missing <tr>
line 149 column 50 - Warning: missing </font> before </td>
line 149 column 91 - Warning: missing </font> before </table>
line 156 column 9 - Warning: <div> isn't allowed in <table> elements
line 152 column 17 - Info: <table> previously mentioned
line 158 column 9 - Warning: missing <tr>
line 176 column 13 - Warning: missing <tr>
line 184 column 9 - Warning: <div> isn't allowed in <table> elements
line 152 column 17 - Info: <table> previously mentioned
line 186 column 9 - Warning: missing <tr>
line 204 column 13 - Warning: missing <tr>
line 207 column 74 - Warning: <style> isn't allowed in <td> elements
line 207 column 9 - Info: <td> previously mentioned
line 210 column 9 - Warning: <div> isn't allowed in <table> elements
line 152 column 17 - Info: <table> previously mentioned
line 212 column 9 - Warning: missing <tr>
line 230 column 13 - Warning: missing <tr>
line 238 column 9 - Warning: <div> isn't allowed in <table> elements
line 152 column 17 - Info: <table> previously mentioned
line 240 column 9 - Warning: missing <tr>
line 258 column 13 - Warning: missing <tr>
line 261 column 74 - Warning: <style> isn't allowed in <td> elements
line 261 column 9 - Info: <td> previously mentioned
line 268 column 9 - Warning: <div> isn't allowed in <table> elements
line 152 column 17 - Info: <table> previously mentioned
line 270 column 9 - Warning: missing <tr>
line 288 column 13 - Warning: missing <tr>
line 291 column 74 - Warning: <style> isn't allowed in <td> elements
line 291 column 9 - Info: <td> previously mentioned
line 310 column 9 - Warning: <div> isn't allowed in <table> elements
line 152 column 17 - Info: <table> previously mentioned
line 312 column 9 - Warning: missing <tr>
line 330 column 13 - Warning: missing <tr>
line 336 column 9 - Warning: <div> isn't allowed in <table> elements
line 152 column 17 - Info: <table> previously mentioned
line 338 column 9 - Warning: missing <tr>
line 356 column 13 - Warning: missing <tr>
line 364 column 9 - Warning: <div> isn't allowed in <table> elements
line 152 column 17 - Info: <table> previously mentioned
line 366 column 9 - Warning: missing <tr>
line 384 column 13 - Warning: missing <tr>
line 392 column 9 - Warning: <div> isn't allowed in <table> elements
line 152 column 17 - Info: <table> previously mentioned
line 394 column 9 - Warning: missing <tr>
line 412 column 13 - Warning: missing <tr>
line 415 column 74 - Warning: <style> isn't allowed in <td> elements
line 415 column 9 - Info: <td> previously mentioned
line 421 column 9 - Warning: <div> isn't allowed in <table> elements
line 152 column 17 - Info: <table> previously mentioned
line 423 column 9 - Warning: missing <tr>
line 441 column 13 - Warning: missing <tr>
line 444 column 74 - Warning: <style> isn't allowed in <td> elements
line 444 column 9 - Info: <td> previously mentioned
line 447 column 17 - Warning: missing <tr>
line 447 column 17 - Warning: discarding unexpected <table>
line 450 column 35 - Warning: missing <tr>
line 450 column 50 - Warning: missing </font> before </td>
line 450 column 91 - Warning: missing </font> before </table>
line 452 column 35 - Warning: missing <tr>
line 452 column 50 - Warning: missing </font> before </td>
line 453 column 37 - Warning: unescaped & or unknown entity "&id"
line 452 column 170 - Warning: missing </font> before </table>
line 454 column 17 - Warning: discarding unexpected </textarea>
line 454 column 28 - Warning: discarding unexpected </form>
line 454 column 35 - Warning: discarding unexpected </embed>
line 454 column 43 - Warning: discarding unexpected </noembed>
line 454 column 53 - Warning: discarding unexpected </noscript>
line 454 column 64 - Warning: discarding unexpected </noembed>
line 454 column 74 - Warning: discarding unexpected </embed>
line 454 column 82 - Warning: discarding unexpected </table>
line 454 column 90 - Warning: discarding unexpected </table>
line 456 column 9 - Warning: missing </font> before <table>
line 468 column 25 - Warning: discarding unexpected </font>
line 477 column 57 - Warning: discarding unexpected </font>
line 455 column 1 - Warning: missing </center>
line 120 column 63 - Warning: <img> lacks "alt" attribute
line 125 column 19 - Warning: <td> attribute "width" has invalid value "120px"
line 125 column 93 - Warning: <img> lacks "alt" attribute
line 141 column 19 - Warning: <td> attribute "width" has invalid value "120px"
line 141 column 98 - Warning: <img> lacks "alt" attribute
line 148 column 44 - Warning: <img> proprietary attribute value "absmiddle"
line 148 column 142 - Warning: <img> proprietary attribute value "absmiddle"
line 148 column 216 - Warning: <img> proprietary attribute value "absmiddle"
line 160 column 11 - Warning: <img> lacks "alt" attribute
line 161 column 22 - Warning: <img> lacks "alt" attribute
line 161 column 63 - Warning: <img> lacks "alt" attribute
line 161 column 112 - Warning: <img> lacks "alt" attribute
line 161 column 162 - Warning: <img> lacks "alt" attribute
line 172 column 15 - Warning: <img> lacks "alt" attribute
line 189 column 22 - Warning: <img> lacks "alt" attribute
line 189 column 63 - Warning: <img> lacks "alt" attribute
line 189 column 112 - Warning: <img> lacks "alt" attribute
line 189 column 161 - Warning: <img> lacks "alt" attribute
line 190 column 11 - Warning: <img> lacks "alt" attribute
line 200 column 15 - Warning: <img> lacks "alt" attribute
line 214 column 11 - Warning: <img> lacks "alt" attribute
line 215 column 22 - Warning: <img> lacks "alt" attribute
line 215 column 63 - Warning: <img> lacks "alt" attribute
line 215 column 111 - Warning: <img> lacks "alt" attribute
line 215 column 161 - Warning: <img> lacks "alt" attribute
line 216 column 11 - Warning: <img> lacks "alt" attribute
line 226 column 15 - Warning: <img> lacks "alt" attribute
line 243 column 23 - Warning: <img> lacks "alt" attribute
line 243 column 64 - Warning: <img> lacks "alt" attribute
line 243 column 113 - Warning: <img> lacks "alt" attribute
line 243 column 163 - Warning: <img> lacks "alt" attribute
line 244 column 11 - Warning: <img> lacks "alt" attribute
line 254 column 15 - Warning: <img> lacks "alt" attribute
line 265 column 1294 - Warning: <img> proprietary attribute value "absmiddle"
line 265 column 1294 - Warning: <img> lacks "alt" attribute
line 273 column 22 - Warning: <img> lacks "alt" attribute
line 273 column 63 - Warning: <img> lacks "alt" attribute
line 273 column 112 - Warning: <img> lacks "alt" attribute
line 273 column 161 - Warning: <img> lacks "alt" attribute
line 274 column 11 - Warning: <img> lacks "alt" attribute
line 284 column 15 - Warning: <img> lacks "alt" attribute
line 314 column 11 - Warning: <img> lacks "alt" attribute
line 315 column 22 - Warning: <img> lacks "alt" attribute
line 315 column 63 - Warning: <img> lacks "alt" attribute
line 315 column 111 - Warning: <img> lacks "alt" attribute
line 315 column 161 - Warning: <img> lacks "alt" attribute
line 316 column 11 - Warning: <img> lacks "alt" attribute
line 326 column 15 - Warning: <img> lacks "alt" attribute
line 340 column 11 - Warning: <img> lacks "alt" attribute
line 341 column 22 - Warning: <img> lacks "alt" attribute
line 341 column 63 - Warning: <img> lacks "alt" attribute
line 341 column 111 - Warning: <img> lacks "alt" attribute
line 341 column 161 - Warning: <img> lacks "alt" attribute
line 352 column 15 - Warning: <img> lacks "alt" attribute
line 368 column 11 - Warning: <img> lacks "alt" attribute
line 369 column 22 - Warning: <img> lacks "alt" attribute
line 369 column 63 - Warning: <img> lacks "alt" attribute
line 369 column 112 - Warning: <img> lacks "alt" attribute
line 369 column 162 - Warning: <img> lacks "alt" attribute
line 380 column 15 - Warning: <img> lacks "alt" attribute
line 389 column 301 - Warning: <img> proprietary attribute value "absmiddle"
line 389 column 301 - Warning: <img> lacks "alt" attribute
line 389 column 357 - Warning: <img> proprietary attribute value "absmiddle"
line 389 column 357 - Warning: <img> lacks "alt" attribute
line 397 column 22 - Warning: <img> lacks "alt" attribute
line 397 column 63 - Warning: <img> lacks "alt" attribute
line 397 column 112 - Warning: <img> lacks "alt" attribute
line 397 column 161 - Warning: <img> lacks "alt" attribute
line 398 column 11 - Warning: <img> lacks "alt" attribute
line 408 column 15 - Warning: <img> lacks "alt" attribute
line 426 column 23 - Warning: <img> lacks "alt" attribute
line 426 column 64 - Warning: <img> lacks "alt" attribute
line 426 column 113 - Warning: <img> lacks "alt" attribute
line 426 column 163 - Warning: <img> lacks "alt" attribute
line 427 column 11 - Warning: <img> lacks "alt" attribute
line 437 column 15 - Warning: <img> lacks "alt" attribute
line 444 column 901 - Warning: <div> anchor "xklayout" already defined
line 453 column 44 - Warning: <img> proprietary attribute value "absmiddle"
line 453 column 142 - Warning: <img> proprietary attribute value "absmiddle"
line 453 column 216 - Warning: <img> proprietary attribute value "absmiddle"
line 462 column 25 - Warning: <img> lacks "alt" attribute
line 467 column 267 - Warning: <img> lacks "alt" attribute
line 149 column 50 - Warning: trimming empty <font>
line 447 column 17 - Warning: trimming empty <tr>
line 450 column 50 - Warning: trimming empty <font>
line 125 column 68 - Warning: <nobr> is not approved by W3C
line 141 column 68 - Warning: <nobr> is not approved by W3C
line 177 column 27 - Warning: <nobr> is not approved by W3C
line 205 column 27 - Warning: <nobr> is not approved by W3C
line 231 column 27 - Warning: <nobr> is not approved by W3C
line 259 column 27 - Warning: <nobr> is not approved by W3C
line 289 column 27 - Warning: <nobr> is not approved by W3C
line 331 column 27 - Warning: <nobr> is not approved by W3C
line 357 column 27 - Warning: <nobr> is not approved by W3C
line 385 column 27 - Warning: <nobr> is not approved by W3C
line 413 column 27 - Warning: <nobr> is not approved by W3C
line 442 column 27 - Warning: <nobr> is not approved by W3C
Info: Document content looks like HTML5
Info: No system identifier in emitted doctype
Tidy found 168 warnings and 0 errors!


The alt attribute should be used to give a short description
of an image; longer descriptions should be given with the
longdesc attribute which takes a URL linked to the description.
These measures are needed for people using non-graphical browsers.

For further advice on how to make your pages accessible
see http://www.w3.org/WAI/GL.
You are recommended to use CSS to specify the font and
properties such as its size and color. This will reduce
the size of HTML files and make them easier to maintain
compared with using <FONT> elements.

You are recommended to use CSS to control line wrapping.
Use "white-space: nowrap" to inhibit wrapping in place
of inserting <NOBR>...</NOBR> into the markup.

About HTML Tidy: https://github.com/htacg/tidy-html5
Bug reports and comments: https://github.com/htacg/tidy-html5/issues
Official mailing list: https://lists.w3.org/Archives/Public/public-htacg/
Latest HTML specification: http://dev.w3.org/html5/spec-author-view/
Validate your HTML documents: http://validator.w3.org/nu/
Lobby your company to join the W3C: http://www.w3.org/Consortium

Do you speak a language other than English, or a different variant of
English? Consider helping us to localize HTML Tidy. For details please see
https://github.com/htacg/tidy-html5/blob/master/README/LOCALIZE.md