Email Cards Checkbox

  1. 2 years ago

    Hello all! I was wondering if there was an option to have the 'email cards' check box automatically ticked when you are dealing with an outgoing trade. I ask this because I recently switched hosts, and my previous host had that box checked all the time. Thank you!

    Hi Emoly,

    You or your host will need to access your eTCG database (this can be done via phpMyAdmin, which most hosts will provide), navigate to the 'trades' table and set the default value for the emailcards field to 1.

    Hope this helps! c:

  2. Bloo

    28 Dec 2015 Administrator Answer kablooey.net

    Hi Emoly,

    You or your host will need to access your eTCG database (this can be done via phpMyAdmin, which most hosts will provide), navigate to the 'trades' table and set the default value for the emailcards field to 1.

    Hope this helps! c:

  3. Edited 2 years ago by Emoly

    Thank you! I'll try this out.

  4. Edited 2 years ago by Emoly

    @Bloo Hi Emoly,

    You or your host will need to access your eTCG database (this can be done via phpMyAdmin, which most hosts will provide), navigate to the 'trades' table and set the default value for the emailcards field to 1.

    Hope this helps! c:

    Hi Bloo, I've attempted this and it is giving me this error:

    2 row(s) inserted.
    Inserted row id: 12
    Warning: #1366 Incorrect integer value: '' for column 'tcg' at row 1
    Warning: #1265 Data truncated for column 'date' at row 1
    Warning: #1366 Incorrect integer value: '' for column 'tcg' at row 2
    Warning: #1265 Data truncated for column 'date' at row 2

    Here is the code that I have now:

    INSERT INTO  `emoly_mysql`.`trades` (
    `id` ,
    `tcg` ,
    `trader` ,
    `email` ,
    `giving` ,
    `givingcat` ,
    `receiving` ,
    `receivingcat` ,
    `emailcards` ,
    `type` ,
    `date`
    )
    VALUES (
    NULL ,  '',  '',  '',  '',  '',  '',  '',  '1',  'outgoing',  ''
    ), (
    NULL ,  '',  '',  '',  '',  '',  '',  '',  '0',  'outgoing',  ''
    );

    The email cards checkbox is still not automatically clicked. Is there something else I need to be doing?

  5. @Emoly Hi Bloo, I've attempted this and it is giving me this error:

    Here is the code that I have now:

    INSERT INTO  `emoly_mysql`.`trades` (
    `id` ,
    `tcg` ,
    `trader` ,
    `email` ,
    `giving` ,
    `givingcat` ,
    `receiving` ,
    `receivingcat` ,
    `emailcards` ,
    `type` ,
    `date`
    )
    VALUES (
    NULL ,  '',  '',  '',  '',  '',  '',  '',  '1',  'outgoing',  ''
    ), (
    NULL ,  '',  '',  '',  '',  '',  '',  '',  '0',  'outgoing',  ''
    );

    The email cards checkbox is still not automatically clicked. Is there something else I need to be doing?

    Disregard this, I found the right place to input it, now I have to figure out what part of this code I inserted to delete. Oops.

  6. And I fixed it. Sorry for the spam! You can delete these last few posts if needed.

or Sign Up to reply!