Notings of Attention™
Acmlmboard 2 Released
Github/GIT | @acmlmboard
Chatting Places
Discord

Affiliates
Super Mario Bros. X | Kuribo64
Views: 8,952,613
Main | FAQ | IRC chat | Memberlist | Active users | Latest posts | Stats | Ranks | Online users | Search
03-28-24 10:06 PM
Guest: Register | Login

0 users currently in AcmlmBoard Developer Zone | 3 bots

Main - AcmlmBoard Developer Zone - Useless fields in the database
Next newer thread | Next older thread


Squiddy
Posted on 02-19-15 09:15 PM Link | ID: 82349
Banned
Unspecificed Cooling Off Period. Be Safe
Bisexual Empress of the Stolen Title?
Level: 142


Posts: 5680/6751
EXP: 34674946
Next: 293483

Since: 07-17-13

Last post: 3179 days
Last view: 3087 days
These are tables that contain columns which should be removed.

Categories
-Minpower (legacy; there is a hidden function or something somewhere in the board software that has the forum editor insert values for the field. This shouldn't be happening)

Forums
-Minpower (legacy; same issue with forum editor as above)
-Minpowerthread (legacy; same forum editor issue)
-Minpowerreply (legacy; same forum editor issue)

Users
-PMblocked (legacy; there's already the Can Create PMs permission)
-Canreport (I have no idea what the hell this is even for)
-Renamethread (legacy; there's already the Rename Own Thread permission)
-Power (legacy)
-Adinfo (While a board owner may want to put ads on their board, why the fuck would anyone use ads, anyway? Just keep a stash of money and put it in your PayPal account or something. Besides, ads suck and people use AdBlock anyway. I guess this could evolve into an errorbanned field of some sort but instead of showing fake errors, it shows fake ads like "Click here to go to Derporama" and it redirects you to the Trolololo YouTube video)

____________________
Sunshine Realm
Welcome to Aqmlm's, the only board with Al-Aq'mlmistrators!

Arisotura
Posted on 02-19-15 09:22 PM (rev. 2 of 02-19-15 09:23 PM by Arisotura) Link | ID: 82350
Developer
pancakes
Level: 83


Posts: 695/1868
EXP: 5395555
Next: 36666

Since: 01-05-12
From: France

Last post: 655 days
Last view: 194 days
I remember recoding the forum editor to work with permissions (and starting from scratch as the old code was trash), so it shouldn't be inserting minpower shit. Weird.


Also, for a while Board2 had an ad at the bottom. With enough traffic, it can be a legit way to gain money, and as long as it's not intrusive I don't mind.

____________________
Kuribo64 - melonDS

want some revolution in your coffee?

Squiddy
Posted on 02-19-15 10:08 PM Link | ID: 82351
Banned
Unspecificed Cooling Off Period. Be Safe
Bisexual Empress of the Stolen Title?
Level: 142


Posts: 5681/6751
EXP: 34674946
Next: 293483

Since: 07-17-13

Last post: 3179 days
Last view: 3087 days
Well, values being inserted into the minpower fields was apparently some silly bug I encountered early on as nothing is inserted into those fields except for the default values.

Relatedly, renaming minpower stuff doesn't bring up any SQL errors when you create/update a category or forum so removing them shouldn't be an issue.

____________________
Sunshine Realm
Welcome to Aqmlm's, the only board with Al-Aq'mlmistrators!

Squiddy
Posted on 02-22-15 10:17 PM Link | ID: 82455
Banned
Unspecificed Cooling Off Period. Be Safe
Bisexual Empress of the Stolen Title?
Level: 142


Posts: 5714/6751
EXP: 34674946
Next: 293483

Since: 07-17-13

Last post: 3179 days
Last view: 3087 days
I have an updated database structure that I can dump and put it into main.sql but I'm not sure if you want me to do that just yet, though.

It has the annoucnenickprefix table removed since it has been merged with the group table, all of the sql updates except for the optional ones such as the second badges table update, the Kirby rankset, and the Sonic rankset, and it has all of the fields mentioned in the first post removed. I would also archive all of the sql updates other than the second badges table update, the Kirby rankset, and the Sonic rankset as mentioned above.

____________________
Sunshine Realm
Welcome to Aqmlm's, the only board with Al-Aq'mlmistrators!

Next newer thread | Next older thread
Main - AcmlmBoard Developer Zone - Useless fields in the database


Acmlmboard v2.5.5 (10/04/2020)
© 2005-2024 Acmlm, Emuz, et al.

Page rendered in 0.038 seconds. (765KB of memory used)
MySQL - queries: 75, rows: 487/520, time: 0.030 seconds.