|
||||||
|
Views:
11,030,474 |
   
Main
| FAQ
| IRC chat
| Memberlist
| Active users
| Latest posts
| Stats
| Ranks
| Online users
| Search
|
11-21-24 11:45 AM |
||||
| Guest: Register | Login | ||||||
| 0 users currently in AcmlmBoard Developer Zone | 4 bots |
| Main - AcmlmBoard Developer Zone - Useless fields in the database |
| Squiddy |
| ||
|
Banned
Unspecificed Cooling Off Period. Be Safe Bisexual Empress of the Stolen Title? Level: 143    
Posts: 5680/6751 EXP: 35713413 Next: 118395 Since: 07-17-13 Last post: 3417 days Last view: 3324 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 |
| ||
|
Developer
pancakes Level: 84
Posts: 695/1870 EXP: 5546092 Next: 115860 Since: 01-05-12 From: France Last post: 37 days Last view: 37 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 |
| ||
|
Banned
Unspecificed Cooling Off Period. Be Safe Bisexual Empress of the Stolen Title? Level: 143
Posts: 5681/6751 EXP: 35713413 Next: 118395 Since: 07-17-13 Last post: 3417 days Last view: 3324 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 |
| ||
|
Banned
Unspecificed Cooling Off Period. Be Safe Bisexual Empress of the Stolen Title? Level: 143
Posts: 5714/6751 EXP: 35713413 Next: 118395 Since: 07-17-13 Last post: 3417 days Last view: 3324 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! |
| Main - AcmlmBoard Developer Zone - Useless fields in the database |
 Acmlmboard v2.5.6 (06/11/2024) © 2005-2024 Acmlm, Emuz, et al. |
|
MySQL - queries: 79, rows: 491/524, time: 6.954 seconds. |
