MODS.DB9.DK

[cmisker]

Huh?

I do the db_update.php in the mass-user PM and I get this:

Code: Select all

This list is a result of the SQL queries needed for this Mod


Yellow Card Mod
[Added/Updated] line: 1 , ALTER TABLE fcforum_forums ADD auth_ban TINYINT (2)not null DEFAULT "3"
[Added/Updated] line: 2 , ALTER TABLE fcforum_auth_access ADD auth_ban TINYINT (1) not null DEFAULT "0"
[Added/Updated] line: 3 , INSERT INTO fcforum_config (config_name, config_value) VALUES ("max_user_bancard", "10")
[Added/Updated] line: 4 , ALTER TABLE fcforum_forums ADD auth_greencard TINYINT (2)not null DEFAULT "5"
[Added/Updated] line: 5 , ALTER TABLE fcforum_forums ADD auth_bluecard TINYINT (2)not null DEFAULT "1"
[Added/Updated] line: 6 , ALTER TABLE fcforum_auth_access ADD auth_greencard TINYINT (1)not null DEFAULT "0"
[Added/Updated] line: 7 , ALTER TABLE fcforum_auth_access ADD auth_bluecard TINYINT (1) not null DEFAULT "0"
[Added/Updated] line: 8 , INSERT INTO fcforum_config (config_name, config_value) VALUES ("bluecard_limit", "3")
[Added/Updated] line: 9 , INSERT INTO fcforum_config (config_name, config_value) VALUES ("bluecard_limit_2", "1")
[Added/Updated] line: 10 , ALTER TABLE fcforum_posts ADD post_bluecard TINYINT (1)



Oops?! How do I remove them again? (Which columns do I need to remove?) You might want to update your zip file too.

[Niels]

...

that was bad...

here are the SQL's to the DB_update.php file, witch wil reverse the added SQL's - I asume you are not using the yellow card mod

Code: Select all

$sql=array(
'ALTER TABLE '.FORUMS_TABLE.' DROP auth_ban ',
'ALTER TABLE '.AUTH_ACCESS_TABLE.' DROP auth_ban' ,
'DELETE FROM '.CONFIG_TABLE.' WHERE config_name="max_user_bancard"',
'ALTER TABLE '.FORUMS_TABLE.' DROP auth_greencard' ,
'ALTER TABLE '.FORUMS_TABLE.' DROP auth_bluecard',
'ALTER TABLE '.AUTH_ACCESS_TABLE.' DROP auth_greencard',
'ALTER TABLE '.AUTH_ACCESS_TABLE.' DROP auth_bluecard',
'DELETE FROM '.CONFIG_TABLE.' WHERE config_name="bluecard_limit"',
'DELETE FROM '.CONFIG_TABLE.' WHERE config_name="bluecard_limit_2"',
'ALTER TABLE '.POSTS_TABLE.' DROP post_bluecard');

thanks for reporting this

[Niels]

I have now updated the zip, with the rigth db_update.php...

[cmisker]

I have now updated the zip, with the rigth db_update.php...

Thanks.

I was just messing with a new forum, so don't worry about it. I even downloaded the zip file about... 4 times, to make sure I didn't download the wrong file...

Very nice mods, btw!