Overview
The “blurb” text is a section on the Student login screen displayed on the right-hand side of the login fields.
Removing the “Blurb” Text From the Login Screen
To remove the “blurb” text from the Student login screen entirely, the message needs to be updated to empty, non-visible text. A typical example is to change the message to &nbsbp;
, a non-breaking space. To suppress the “blurb” text, take the following steps:
- Copy the SQL below into an editor
- Update the following values:
@message
: Set this to
@languageCode
: Replace[language code]
the language code representing the language of the message text (e.g. ENU, ESN, HAW)@clientName
: Set this to SBAC for production environemnts or SBAC_PT for other environments
- Execute the SQL against your database
- Flush the redis cache
SQL For Removing the “Blurb” Text
USE configs;
SET @message = ' ';
SET @languageCode = '[language code]';
SET @clientName = '[SBAC for production assessments, SBAC_PT for practice assessments]';
START TRANSACTION;
DELETE
mt
FROM
configs.client_messagetranslation mt
JOIN
configs.tds_coremessageobject cmo
ON mt._fk_coremessageobject = cmo._key
WHERE
cmo.appkey = 'StaticContent.Label.PTIntroText'
AND cmo.`contexttype` = 'ServerSide'
AND mt.`language` = @languageCode;
INSERT configs.client_messagetranslation(_fk_coremessageobject, `client`, message, `language`, grade, `subject`, _key, datealtered)
SELECT
cmo._key,
@clientName,
@message,
@languageCode,
'--ANY--',
'--ANY--',
UNHEX(REPLACE(UUID(), '-', '')),
NOW()
FROM
configs.tds_coremessageobject cmo
JOIN
configs.client_messagetranslation mt
ON (mt._fk_coremessageobject = cmo._key)
WHERE
cmo.appkey = 'StaticContent.Label.PTIntroText'
AND cmo.contexttype = 'ServerSide'
GROUP BY
cmo._key;
UPDATE
configs.tds_coremessageobject
SET
message = @message,
datealtered = NOW()
WHERE
appkey = 'StaticContent.Label.PTIntroText'
AND contextType = 'ServerSide';
COMMIT;
START TRANSACTION;
DELETE FROM __appmessages;
DELETE FROM __appmessagecontexts;
COMMIT;
Changing the “Blurb” Text on the Login Screen
For the “blurb” text and container to properly render on the Student loging screen, the desired message text must be in the following format:
<div class="blurb">[Your message text goes here. Can be any valid HTML (e.g. link, list, etc)]</div>
Example:
<div class="blurb">Click <a href="http://link/to/somewhere">here</a> if you are a California student.</div>
To change the “blurb” text message in the Student login screen, take the following steps:
- Copy the SQL below into an editor
- Update the following values:
@message
: Replace[Message text goes here. Message text can be any HTML]
with the desired text@languageCode
: Replace[language code]
the language code representing the language of the message text (e.g. ENU, ESN, HAW)@clientName
: Set this to SBAC for production environemnts or SBAC_PT for other environments
- Execute the SQL against your database
- Flush the redis cache
SQL For Changing the “Blurb” Text
USE configs;
SET @message = '<div class="blurb">[Message text goes here. Message text can be any HTML]</div>';
SET @languageCode = '[language code]';
SET @clientName = '[SBAC for production assessments, SBAC_PT for practice assessments]';
START TRANSACTION;
DELETE
mt
FROM
configs.client_messagetranslation mt
JOIN
configs.tds_coremessageobject cmo
ON mt._fk_coremessageobject = cmo._key
WHERE
cmo.appkey = 'StaticContent.Label.PTIntroText'
AND cmo.`contexttype` = 'ServerSide'
AND mt.`language` = @languageCode;
INSERT configs.client_messagetranslation(_fk_coremessageobject, `client`, message, `language`, grade, `subject`, _key, datealtered)
SELECT
cmo._key,
@clientName,
@message,
@languageCode,
'--ANY--',
'--ANY--',
UNHEX(REPLACE(UUID(), '-', '')),
NOW()
FROM
configs.tds_coremessageobject cmo
JOIN
configs.client_messagetranslation mt
ON (mt._fk_coremessageobject = cmo._key)
WHERE
cmo.appkey = 'StaticContent.Label.PTIntroText'
AND cmo.contexttype = 'ServerSide'
GROUP BY
cmo._key;
UPDATE
configs.tds_coremessageobject
SET
message = @message,
datealtered = NOW()
WHERE
appkey = 'StaticContent.Label.PTIntroText'
AND contextType = 'ServerSide';
COMMIT;
START TRANSACTION;
DELETE FROM __appmessages;
DELETE FROM __appmessagecontexts;
COMMIT;