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

Affiliates
Super Mario Bros. X | Kuribo64
Views: 4,787,072
Main | FAQ | IRC chat | Memberlist | Active users | Latest posts | Calendar | Stats | Ranks | Online users | Search
01-22-18 10:05 PM
Guest: Register | Login

0 users currently in AcmlmBoard Developer Zone | 1 guest

Main - AcmlmBoard Developer Zone - SQL Changes
Next newer thread | Next older thread

Pages: 1 2

Emuz
Posted on 02-01-12 11:20 PM Link | ID: 4821
Acmlmistrator

11 Hit Combo:
Mother's Rosario
Level: 92


Posts: 460/2933
EXP: 7475900
Next: 281037

Since: 12-30-11
From: Akron, Ohio; USA

Last post: 1 hour
Last view: 40 min.
ALTER TABLE `sprites` ADD `rarity` TINYINT NOT NULL DEFAULT '0' AFTER `flavor


The Dynamic Profile Administrator™


"Wastashi Dake ga Inai Boaado"

Emuz
Posted on 02-06-12 05:40 PM (rev. 3 of 12-22-13 03:09 PM by Emuz) Link | ID: 5632
Acmlmistrator

11 Hit Combo:
Mother's Rosario
Level: 92


Posts: 484/2933
EXP: 7475900
Next: 281037

Since: 12-30-11
From: Akron, Ohio; USA

Last post: 1 hour
Last view: 40 min.
ALTER TABLE `users` ADD `displayname` VARCHAR( 32 ) NOT NULL AFTER `name`;
ALTER TABLE `threads` CHANGE `title` `title` VARCHAR( 100 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;

INSERT INTO `x_perm` (`id`, `x_id`, `x_type`, `perm_id`, `permbind_id`, `bindvalue`, `revoke`) VALUES ('198', '2', 'group', 'has-displayname', '', '0', '0');
<- group 10 on live for a test. Than changed to 2 (Staff is 10, 2 is Normal User)


The Dynamic Profile Administrator™


"Wastashi Dake ga Inai Boaado"

Emuz
Posted on 02-14-12 03:49 AM Link | ID: 6418
Acmlmistrator

11 Hit Combo:
Mother's Rosario
Level: 92


Posts: 507/2933
EXP: 7475900
Next: 281037

Since: 12-30-11
From: Akron, Ohio; USA

Last post: 1 hour
Last view: 40 min.
Note: I've made updates to the two sql dumps.

in the home dir of the development account. I made a new development SQL dump: dev-120213.sql.bz2 it's based on the daily backup from last night. This is the one you should use for development.

I've also made a initial install (main.sql) and pushed it into the git. This is untested, and mostly just to have a more updated version of the data structure. In theory the only thing that should be broken is the perms since I did not modify them from the live board.

Also another change is I moved the ip2c able out to it's own file (sql/static/ip2c.sql) in the git. Neither main.sql or dev-* will contain it anymore. If you need it just import it after mail.sql/dev*.sql.

The Dynamic Profile Administrator™


"Wastashi Dake ga Inai Boaado"

Epele
Posted on 02-17-12 01:16 AM Link | ID: 6632
Administrator
The Sorceress.
Totally crushing on a certain french girl.

Level: 191


Posts: 669/16123
EXP: 96307474
Next: 1766619

Since: 01-01-12
From: UK

Last post: 6 hours
Last view: 2 hours
ALTER TABLE `users` ADD `redirtype` INT( 1 ) NOT NULL DEFAULT '0';

You'll need this for the modified redirect code. (Default is old page display.)


The Hero In Every Pretty Pervy Yuri - Thieppy

Epele
Posted on 03-06-12 03:45 PM (rev. 2 of 03-07-12 11:49 AM by Epele) Link | ID: 8565
Administrator
The Sorceress.
Totally crushing on a certain french girl.

Level: 191


Posts: 1082/16123
EXP: 96307474
Next: 1766619

Since: 01-01-12
From: UK

Last post: 6 hours
Last view: 2 hours
INSERT INTO `smilies` VALUES (':x', 'img/smilies/crossmouth.gif');
INSERT INTO `smilies` VALUES (':|', 'img/smilies/slidemouth.gif');
INSERT INTO `smilies` VALUES (':@', 'img/smilies/dropsmile.gif');
INSERT INTO `smilies` VALUES (':-3', 'img/smilies/wobble.gif');
INSERT INTO `smilies` VALUES ('X-D', 'img/smilies/xd.gif');
INSERT INTO `smilies` VALUES ('X-3', 'img/smilies/x3.gif');
INSERT INTO `smilies` VALUES ('X-P', 'img/smilies/xp.gif');

Smilie update.


The Hero In Every Pretty Pervy Yuri - Thieppy

Emuz
Posted on 03-07-12 12:08 PM (rev. 2 of 12-22-13 03:08 PM by Emuz) Link | ID: 8598
Acmlmistrator

11 Hit Combo:
Mother's Rosario
Level: 92


Posts: 584/2933
EXP: 7475900
Next: 281037

Since: 12-30-11
From: Akron, Ohio; USA

Last post: 1 hour
Last view: 40 min.
UPDATE `smilies` SET `text` = ':-3' WHERE `smilies`.`text` = ':3' AND `smilies`.`url` = 'img/smilies/wobble.gif' LIMIT 1 ;


The Dynamic Profile Administrator™


"Wastashi Dake ga Inai Boaado"

Epele
Posted on 03-07-12 08:52 PM Link | ID: 8626
Administrator
The Sorceress.
Totally crushing on a certain french girl.

Level: 191


Posts: 1097/16123
EXP: 96307474
Next: 1766619

Since: 01-01-12
From: UK

Last post: 6 hours
Last view: 2 hours
INSERT INTO `smilies` VALUES (':o', 'img/smilies/dramatic.gif');



The Hero In Every Pretty Pervy Yuri - Thieppy

Emuz
Posted on 03-08-12 11:16 PM Link | ID: 8712
Acmlmistrator

11 Hit Combo:
Mother's Rosario
Level: 92


Posts: 591/2933
EXP: 7475900
Next: 281037

Since: 12-30-11
From: Akron, Ohio; USA

Last post: 1 hour
Last view: 40 min.
INSERT INTO `perm` (
`id` ,
`title` ,
`description` ,
`permcat_id` ,
`permbind_id`
)
VALUES (
'show-as-staff', 'Listed Publicly as Staff', '', '3', 'users'
);

INSERT INTO `x_perm` (
`id` ,
`x_id` ,
`x_type` ,
`perm_id` ,
`permbind_id` ,
`bindvalue` ,
`revoke`
)
VALUES ('221', '6', 'group', 'show-as-staff', '', '0', '0');
INSERT INTO `x_perm` (
`id` ,
`x_id` ,
`x_type` ,
`perm_id` ,
`permbind_id` ,
`bindvalue` ,
`revoke`
)
VALUES ('218', '3', 'group', 'show-as-staff', '', '0', '0');
INSERT INTO `x_perm` (
`id` ,
`x_id` ,
`x_type` ,
`perm_id` ,
`permbind_id` ,
`bindvalue` ,
`revoke`
)
VALUES ('219', '4', 'group', 'show-as-staff', '', '0', '0');
INSERT INTO `x_perm` (
`id` ,
`x_id` ,
`x_type` ,
`perm_id` ,
`permbind_id` ,
`bindvalue` ,
`revoke`
)
VALUES ('220', '8', 'group', 'show-as-staff', '', '0', '0');


phpmyadmin gave it to me with newlines. Oh well.

The Dynamic Profile Administrator™


"Wastashi Dake ga Inai Boaado"

Emuz
Posted on 03-14-12 12:35 AM (rev. 2 of 12-22-13 03:07 PM by Emuz) Link | ID: 9487
Acmlmistrator

11 Hit Combo:
Mother's Rosario
Level: 92


Posts: 606/2933
EXP: 7475900
Next: 281037

Since: 12-30-11
From: Akron, Ohio; USA

Last post: 1 hour
Last view: 40 min.
ALTER TABLE `badges` ADD `effect_variable` VARCHAR( 32 ) NULL DEFAULT NULL AFTER `effect`;
ALTER TABLE `user_badges` ADD `badge_var` VARCHAR( 32 ) NULL DEFAULT NULL AFTER `badge_id`;
ALTER TABLE `user_badges` DROP INDEX `u` ,
ADD INDEX `user_id` ( `user_id` );
ALTER TABLE `user_badges` DROP INDEX `t` ,
ADD INDEX `badge_id` ( `badge_id` );


The Dynamic Profile Administrator™


"Wastashi Dake ga Inai Boaado"

Emuz
Posted on 03-16-12 01:20 AM (rev. 2 of 12-22-13 03:07 PM by Emuz) Link | ID: 9591
Acmlmistrator

11 Hit Combo:
Mother's Rosario
Level: 92


Posts: 609/2933
EXP: 7475900
Next: 281037

Since: 12-30-11
From: Akron, Ohio; USA

Last post: 1 hour
Last view: 40 min.
Ok I am taking a chance on this one. Let me know (via PM) if this starts getting people who are not bots into the bot list.

INSERT INTO `robots` (`bot_name`, `bot_agent`) VALUES ('Generic BOT (any with bot in the agent name)', 'bot'), ('Generic SPIDER (any with spider in the agent name)', 'spider');


The Dynamic Profile Administrator™


"Wastashi Dake ga Inai Boaado"

StapleButter
Posted on 06-19-12 10:35 PM Link | ID: 17377
Developer
Acmlmboard has... side effects
Level: 69


Posts: 247/1548
EXP: 2862710
Next: 7033

Since: 01-05-12
From: France

Last post: 4 days
Last view: 2 days
ALTER TABLE `users` ADD UNIQUE (`name`)

Should prevent duplicates the hard way, in case the PHP-side checks fail again for whatever reason.

____________________
Kuribo64 - we hack shit

Emuz
Posted on 07-01-12 05:06 AM (rev. 2 of 12-22-13 03:06 PM by Emuz) Link | ID: 19197
Acmlmistrator

11 Hit Combo:
Mother's Rosario
Level: 92


Posts: 772/2933
EXP: 7475900
Next: 281037

Since: 12-30-11
From: Akron, Ohio; USA

Last post: 1 hour
Last view: 40 min.
INSERT INTO `perm` (`id`, `title`, `description`, `permcat_id`, `permbind_id`) VALUES ('block-layout', 'Enable Layout Blocking', 'Enables per-user layout blocking', '3', '');

INSERT INTO `x_perm` (
`id` ,
`x_id` ,
`x_type` ,
`perm_id` ,
`permbind_id` ,
`bindvalue` ,
`revoke`
)
VALUES (
'222', '2', 'group', 'block-layout', '', '0', '0'
);


The Dynamic Profile Administrator™


"Wastashi Dake ga Inai Boaado"

Epele
Posted on 07-11-12 12:01 AM Link | ID: 20222
Administrator
The Sorceress.
Totally crushing on a certain french girl.

Level: 191


Posts: 3566/16123
EXP: 96307474
Next: 1766619

Since: 01-01-12
From: UK

Last post: 6 hours
Last view: 2 hours
ALTER TABLE `users` CHANGE `birth` `birth` VARCHAR( 10 ) NOT NULL DEFAULT '-1'



The Hero In Every Pretty Pervy Yuri - Thieppy

Scrydan
Posted on 11-01-12 12:53 PM Link | ID: 28565

Birdo
Scryforce - Wanna test the RPG? Let me know in a PM.
Level: 77


Posts: 1116/2009
EXP: 4041884
Next: 149245

Since: 07-18-12
From: USA

Last post: 906 days
Last view: 889 days
Click here to see all my changes done. Of course, of the late I am a bit behind in the "RPG" side of it but everything else should work fine. There's over 750 lines of SQL code so far. This is what will be used to update Kafuka.

I'll later post a link to the code part in a different thread. I am getting closer to just updating the RPG Branch after a good while of waiting.

Back to my favorite layout!

Emuz
Posted on 03-15-13 02:08 AM (rev. 3 of 12-22-13 03:06 PM by Emuz) Link | ID: 31905
Acmlmistrator

11 Hit Combo:
Mother's Rosario
Level: 92


Posts: 1688/2933
EXP: 7475900
Next: 281037

Since: 12-30-11
From: Akron, Ohio; USA

Last post: 1 hour
Last view: 40 min.
I figure I will mark down the changes I made to 2.5's SQL
INSERT INTO `perm` (
`id` ,
`title` ,
`description` ,
`permcat_id` ,
`permbind_id`
)
VALUES (
'view-allranks', 'Show Hidden Ranks', '', '2', ''
);

UPDATE `x_perm` SET `id` = '253', `x_id` = '10', `perm_id` = 'view-allranks', `bindvalue` = '' WHERE `x_perm`.`id` = 242
INSERT INTO `ranksets` (`id`, `name`) VALUES ('-1', 'Dots (by Xkeeper)');


Does not include the import of the kirby ranks.

The Dynamic Profile Administrator™


"Wastashi Dake ga Inai Boaado"

2spam|!2spam #167
(post deleted) ID: 39339

Emuz
Posted on 12-22-13 02:35 AM (rev. 2 of 12-22-13 03:05 PM by Emuz) Link | ID: 39417
Acmlmistrator

11 Hit Combo:
Mother's Rosario
Level: 92


Posts: 1994/2933
EXP: 7475900
Next: 281037

Since: 12-30-11
From: Akron, Ohio; USA

Last post: 1 hour
Last view: 40 min.
INSERT INTO `robots` (`bot_name`, `bot_agent`) VALUES ('Ezooms', 'Ezooms/1.0');


The Dynamic Profile Administrator™


"Wastashi Dake ga Inai Boaado"

StapleButter
Posted on 12-22-13 11:57 AM Link | ID: 39422
Developer
Acmlmboard has... side effects
Level: 69


Posts: 460/1548
EXP: 2862710
Next: 7033

Since: 01-05-12
From: France

Last post: 4 days
Last view: 2 days
It would be nice to take database names out, so the queries could just be copypasted directly into any PMA interface.

____________________
Kuribo64 - we hack shit

Emuz
Posted on 12-22-13 03:02 PM (rev. 2 of 12-22-13 03:10 PM by Emuz) Link | ID: 39423
Acmlmistrator

11 Hit Combo:
Mother's Rosario
Level: 92


Posts: 1995/2933
EXP: 7475900
Next: 281037

Since: 12-30-11
From: Akron, Ohio; USA

Last post: 1 hour
Last view: 40 min.
Thanks for saying something. I've removed them all so barring any typos.. ;)

The Dynamic Profile Administrator™


"Wastashi Dake ga Inai Boaado"

Emuz
Posted on 12-30-13 10:19 PM Link | ID: 39846
Acmlmistrator

11 Hit Combo:
Mother's Rosario
Level: 92


Posts: 2009/2933
EXP: 7475900
Next: 281037

Since: 12-30-11
From: Akron, Ohio; USA

Last post: 1 hour
Last view: 40 min.
INSERT INTO `perm` (`id`, `title`, `description`, `permcat_id`, `permbind_id`) VALUES
('manage-board', 'Administration Management Panel', '', 3, '');


INSERT INTO `x_perm` (`id`, `x_id`, `x_type`, `perm_id`, `permbind_id`, `bindvalue`, `revoke`) VALUES
(275, 4, 'group', 'manage-board', '', 0, 0);


The Dynamic Profile Administrator™


"Wastashi Dake ga Inai Boaado"
Pages: 1 2


Next newer thread | Next older thread
Main - AcmlmBoard Developer Zone - SQL Changes


Acmlmboard v2.5.3 (1/7/2018)
© 2005-2018 Acmlm, Emuz, et al.

Page rendered in 0.077 seconds. (712KB of memory used)
MySQL - queries: 197, rows: 722/747, time: 0.020 seconds.