Notings of Attention™
Acmlmboard 2 Released
Github/GIT | @acmlmboard | IRC: #abdev
Chatting Places
IRC: #kafuka | Discord | Mastodon

Affiliates
Super Mario Bros. X | Kuribo64
Views: 6,522,671
Main | FAQ | IRC chat | Memberlist | Active users | Latest posts | Stats | Ranks | Online users | Search
01-19-20 07:57 AM
Guest: Register | Login

Main - Posts by Arisotura

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87

Arisotura
Posted on 05-30-15 12:36 AM, in May KCS Rankings (5/31 - If you manage to render Lili unable to eat, you've done everything right.) Link | ID: 85213
Developer
pancakes
Level: 76


Posts: 763/1729
EXP: 3895331
Next: 110729

Since: 01-05-12
From: France

Last post: 1 day
Last view: 18 hours
Not like everything is bad, either :)

Don't focus on the bad things, enjoy life!

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Arisotura
Posted on 06-04-15 02:14 PM, in Emoji shit Link | ID: 85284
Developer
pancakes
Level: 76


Posts: 764/1729
EXP: 3895331
Next: 110729

Since: 01-05-12
From: France

Last post: 1 day
Last view: 18 hours
Trying to post emoji on these boards results in the string getting cut off before the emoji character. This is an issue with database encoding.


AB2.5 sets DB encoding to latin1, which isn't right considering we're storing UTF8.


But even when setting the encoding to UTF8, the aforementioned bug still happens. Because UTF8 support in MySQL is a pile of hacks and doesn't support characters with more than 3 bytes.


When setting encoding to utf8mb4, emoji characters are handled fine. Maybe seems like a lot of work for something minor (letting people post emoji crap), but on the other hand, there's the possibility that someone writes a big post with emoji crap at the beginning, and there it goes.


'a lot of work' because changing encoding on an existing database isn't magic. You'd need to change it on every varchar/text field because MySQL is dumb like that. And also modify the board to specify the right encoding when connecting to MySQL.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Arisotura
Posted on 06-04-15 03:32 PM, in Emoji shit (rev. 3 of 06-04-15 05:36 PM by Arisotura) Link | ID: 85287
Developer
pancakes
Level: 76


Posts: 765/1729
EXP: 3895331
Next: 110729

Since: 01-05-12
From: France

Last post: 1 day
Last view: 18 hours
I just converted K64's database to utf8mb4, everything went allright so far. Could hand you the .sql file I used as a base.


Thing is, K64's database was already UTF8 before that, so it went smoothly. Going from latin1 to UTF8 is more involved, you need some trickery to keep MySQL from trying to convert the already-UTF8 data into UTF8. A solution may be creating a new empty database with proper UTF8 fields, exporting the old one and reimporting. I've been dealing with that shit before too, but I don't remember the details.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Arisotura
Posted on 06-09-15 10:49 PM, in the thread has farted Link | ID: 85418
Developer
pancakes
Level: 76


Posts: 768/1729
EXP: 3895331
Next: 110729

Since: 01-05-12
From: France

Last post: 1 day
Last view: 18 hours
Posted by Squiddy
Do you think et al should become RVlution's Admin? ;)

Oh, and do you think that once I give in my work to the NSMB2/U editor, I should help dedicate it to Taryn? :P

7. Definitely not. I know that guy enough to tell you that he's not a good admin.

18. Why dedicate a NSMB2/U editor to her? The board was dedicated to her because she's been an active and good member of Acmlm's Board for so long. There isn't really a link between her and such an editor, though.


Posted by Dani
Why are little kitty cats so cute? Aww ^_^

It's a cruel trap! They're silently devising a huge plan to take over the world.


Posted by Tierage
Can you even? Cause I can't.

I can more than you.


Posted by Squiddy
How fitting is it that this is my 6400th post? :P

640 is a lame number!


Posted by Dani
Skarmory, Altaria, or Flygon for my team?

Whichever has the coolest name!

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Arisotura
Posted on 06-09-15 11:00 PM, in the thread has farted Link | ID: 85422
Developer
pancakes
Level: 76


Posts: 769/1729
EXP: 3895331
Next: 110729

Since: 01-05-12
From: France

Last post: 1 day
Last view: 18 hours
It's not 'big' or 'not big', it's the link between the person and the dedication. Dunno.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Arisotura
Posted on 06-10-15 08:03 PM, in the thread has farted Link | ID: 85473
Developer
pancakes
Level: 76


Posts: 770/1729
EXP: 3895331
Next: 110729

Since: 01-05-12
From: France

Last post: 1 day
Last view: 18 hours
Posted by Squiddy
KuriBot, Jarvis

What? KuriBot is Jarvis!

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Arisotura
Posted on 06-10-15 08:08 PM, in the milennium starts at 2020, because there's no year 0 Link | ID: 85475
Developer
pancakes
Level: 76


Posts: 771/1729
EXP: 3895331
Next: 110729

Since: 01-05-12
From: France

Last post: 1 day
Last view: 18 hours
The functionality would be cool to have in KuriBot. How much would it cost?

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Arisotura
Posted on 06-12-15 12:26 AM, in the thread has farted Link | ID: 85631
Developer
pancakes
Level: 76


Posts: 773/1729
EXP: 3895331
Next: 110729

Since: 01-05-12
From: France

Last post: 1 day
Last view: 18 hours
Maybe, but I'd rather get original shit. It's like Mario and 'save Princess Peach for the 8464227th time'.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Arisotura
Posted on 06-12-15 12:28 AM, in What are you wearing at the moment? Link | ID: 85632
Developer
pancakes
Level: 76


Posts: 774/1729
EXP: 3895331
Next: 110729

Since: 01-05-12
From: France

Last post: 1 day
Last view: 18 hours
I'm wearing kinda crapo clothes since I'm at home. Plain standard T-shirt and shorts.

I also have shorter shorts, though.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Arisotura
Posted on 06-12-15 01:16 AM, in the thread has farted Link | ID: 85638
Developer
pancakes
Level: 76


Posts: 775/1729
EXP: 3895331
Next: 110729

Since: 01-05-12
From: France

Last post: 1 day
Last view: 18 hours
acmlmboard mario

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Arisotura
Posted on 06-12-15 12:16 PM, in What should I code? Link | ID: 85648
Developer
pancakes
Level: 76


Posts: 778/1729
EXP: 3895331
Next: 110729

Since: 01-05-12
From: France

Last post: 1 day
Last view: 18 hours
Posted by Squiddy
So, why not code a texture editor?

Rather much code a converter for weird proprietary formats, so they can be edited in existing image editors. After all, why reinvent the wheel? :P

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Arisotura
Posted on 06-13-15 09:12 PM, in the milennium starts at 2020, because there's no year 0 Link | ID: 85677
Developer
pancakes
Level: 76


Posts: 779/1729
EXP: 3895331
Next: 110729

Since: 01-05-12
From: France

Last post: 1 day
Last view: 18 hours
why the fuck does Squiddy gloat about her anger issues

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Arisotura
Posted on 06-14-15 12:18 AM, in June KCS Rankings (6/30 - Maybe the wait is over..?) Link | ID: 85687
Developer
pancakes
Level: 76


Posts: 780/1729
EXP: 3895331
Next: 110729

Since: 01-05-12
From: France

Last post: 1 day
Last view: 18 hours
Common male things apparently.


Dunno. I have weird fat distribution that gives me big thighs and butt. I see no problem with that.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?
Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87


Main - Posts by Arisotura


Acmlmboard v2.5.4 (03/13/2019)
© 2005-2020 Acmlm, Emuz, et al.

Page rendered in 0.119 seconds. (689KB of memory used)
MySQL - queries: 148, rows: 493/524, time: 0.063 seconds.