Page Comparison

...

1. Access the primary X-Changer DB through MSSQL.

2. Generate a new query using the following commands, replacing ‘CARDNUMBERHERE’ with the 12-digit attendant card number requested:

   1. Note the number of cards that can be removed does not matter, just make sure the last card added does not have the ‘OR’ operator at the end.
      

      Code Block
      language sql
      SELECT TOP (200) CardNumber, UserName, UserType, Balance, Bonus, CardStatus FROM Card WHERE (UserType > 0) AND (CardNumber = CARDNUMBERHERE) OR (UserType > 0) AND (CardNumber = CARDNUMBERHERE) OR (UserType > 0) AND (CardNumber = CARDNUMBERHERE) OR (UserType > 0) AND (CardNumber = CARDNUMBERHERE) OR (UserType > 0) AND (CardNumber = CARDNUMBERHERE) OR (UserType > 0) AND (CardNumber = CARDNUMBERHERE) OR (UserType > 0) AND (CardNumber = CARDNUMBERHERE) ORDER BY CardNumber

3. Execute the above query once all card numbers have been filled in.

   1. If you do receive an error after execution, be sure to read over it entirely and fix as needed.

4. Verify the cards have been removed successfully from the Hours Editor menu.

   1. The attendant accounts may be present in the Hours Editor dropdown menu, but will not be selectable.

5. Accessing the Cards > Search function, search for the attendant cards you removed and complete the following in their respective card details pages:

   1. Zero out the card balance and bonus.

   2. Zero out any discounts applied.

   3. Set card type to Customer.

   4. Set card status to Invalid.

📌 Related Jiras

\uD83D\uDCCB Related articles

...