Scribd
Upload
5 views6 pages

Guide

The document provides instructions for updating files and databases, emphasizing the importance of backing up files and databases before proceeding. It outlines two methods for updating files and details necessary changes to the .env file and SQL queries to be executed in the database. Additionally, it includes a list of translation entries for different languages that need to be inserted into the database.

Uploaded by

lawcorners
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
5 views6 pages

Guide

The document provides instructions for updating files and databases, emphasizing the importance of backing up files and databases before proceeding. It outlines two methods for updating files and details necessary changes to the .env file and SQL queries to be executed in the database. Additionally, it includes a list of translation entries for different languages that need to be inserted into the database.

Uploaded by

lawcorners
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 6

IMPORTANT

——————————————————————————————————————
Please make sure to always back up your files before updating. I am not responsible
for any update going wrong and messing / losing your previous or actual files.

FILE CHANGES
——————————————————————————————————————
1. THE EASIEST WAY

Upload update.zip and extract it to the main folder

2. THE ADVANCED WAY

Note: please check the path properly before replacing any file

- replace assets folder from root\assets


- replace app folder from root\script\app
- replace bootstrap folder from root\script\bootstrap
- replace config folder from root\script\config
- replace database folder from root\script\database
- replace resources folder from root\script\resources
- replace routes folder from root\script\routes
- replace storage folder from root\script\storage
- replace tests folder from root\script\tests
- replace vendor folder from root\script\vendor
- replace composer.lock file from root\script\composer.lock
- replace composer.json file from root\script\composer.json

EDIT FILES
——————————————————————————————————————
1. Update The .env File

- Go to root\script\.env and add this lines : ( !! Make sure not to leave space !!)

DEFAULT_LANGUAGE=en
RECAPTCHA_SITE_KEY=
RECAPTCHA_SECRET_KEY=

and save the file

DATABASE CHANGES
——————————————————————————————————————
IMPORTANT: MAKE SURE YOU BACKUP YOUR DATABASE JUST TO BE SAFE.

You will have to run the following queries into your database.

You can run those with PhpMyAdmin -> selecting the database -> going to the SQL tab
and running the following mysql queries:

INSERT INTO `settings` (`id`, `key`, `value`, `created_at`, `updated_at`)


VALUES (NULL, 'lang', 'en', NULL, NULL) , (NULL, 'google_tag_manager', NULL, NULL,
NULL),
(NULL, 'RECAPTCHA_SECRET_KEY', NULL, NULL, NULL), (NULL, 'RECAPTCHA_SITE_KEY',
NULL, NULL, NULL);
CREATE TABLE `languages` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`rtl` int(11) NOT NULL DEFAULT 0,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `languages` (`id`, `name`, `code`, `rtl`, `created_at`, `updated_at`)


VALUES
(1, 'EN', 'en', 0, NULL, NULL),
(2, 'AR', 'ar', 1, NULL, NULL);

ALTER TABLE `languages`


ADD PRIMARY KEY (`id`);

ALTER TABLE `languages`


MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

DROP TABLE `translates`;

CREATE TABLE `translates` (


`id` int(10) UNSIGNED NOT NULL,
`lang` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`value` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `translates` (`id`, `lang`, `key`, `value`, `created_at`, `updated_at`)


VALUES
(1, 'en', 'Mailbox Small Title', 'Your Temporary Email Address', NULL, '2021-09-13
21:25:59'),
(2, 'en', 'Mailbox Description', 'Forget about spam, advertising mailings, hacking
and attacking robots. Keep your real mailbox clean and secure. Temp Mail provides
temporary, secure, anonymous, free, disposable email address.', NULL, '2021-09-13
21:25:59'),
(3, 'en', 'Refresh', 'Refresh', NULL, '2021-09-13 21:25:59'),
(4, 'en', 'Change', 'Change', NULL, '2021-09-13 21:25:59'),
(5, 'en', 'Delete', 'Delete', NULL, '2021-09-13 21:25:59'),
(6, 'en', 'Sender', 'Sender', NULL, '2021-09-13 21:25:59'),
(7, 'en', 'Subject', 'Subject', NULL, '2021-09-13 21:25:59'),
(8, 'en', 'View', 'View', NULL, '2021-09-13 21:25:59'),
(9, 'en', 'Your inbox is empty', 'Your inbox is empty', NULL, '2021-09-13
21:25:59'),
(10, 'en', 'Waiting for incoming emails', 'Waiting for incoming emails', NULL,
'2021-09-13 21:25:59'),
(11, 'en', 'Awesome Features', 'Awesome Features', NULL, '2021-09-13 21:25:59'),
(12, 'en', 'Features Description', 'Disposable temporary email protects your real
email address from spam, advertising mailings, malwares.', NULL, '2021-09-13
21:25:59'),
(13, 'en', 'Popular Posts', 'Popular Posts', NULL, '2021-09-13 21:25:59'),
(14, 'en', 'Back To List', 'Back To List', NULL, '2021-09-13 21:25:59'),
(15, 'en', 'Attachments', 'Attachments', NULL, '2021-09-13 21:25:59'),
(16, 'en', 'Copyright', 'Copyright ©2021 - TrashMails', NULL, '2021-09-13
21:25:59'),
(17, 'en', 'Blog', 'Blog', NULL, '2021-09-13 21:25:59'),
(18, 'en', 'Categories', 'Categories', NULL, '2021-09-13 21:26:00'),
(19, 'en', 'Leave a Reply', 'Leave a Reply', NULL, '2021-09-13 21:26:00'),
(20, 'en', 'Change E-mail Address', 'Change E-mail Address', NULL, '2021-09-13
21:26:00'),
(21, 'en', 'Change Description', '<b>Trash Mails</b> provides the ability to change
your temporary email address on this page. <br> <br> To change or recover the email
address, please enter the desired E-mail address and choose domain.', NULL, '2021-
09-13 21:26:00'),
(22, 'en', 'Contact Us', 'Contact Us', NULL, '2021-09-13 21:26:00'),
(23, 'en', 'Contact Description', 'We’re here to help and answer any question you
might have. <br> We look forward to hearing from you 🙂', NULL, '2021-09-13
21:26:00'),
(24, 'en', 'Emails Created', 'Emails Created', NULL, '2021-09-13 21:26:00'),
(25, 'en', 'Messages Received', 'Messages Received', NULL, '2021-09-13 21:26:00'),
(26, 'en', 'Cookie Message', 'Your experience on this site will be improved by
allowing cookies.', NULL, '2021-09-13 21:26:00'),
(27, 'en', 'Cookie Button', 'Allow cookies', NULL, '2021-09-13 21:26:00'),
(28, 'en', 'Homepage Title', 'Trash Mails', NULL, '2021-09-13 21:26:00'),
(29, 'en', 'Change Email', 'Change Email', '2021-09-13 22:33:28', '2021-09-13
22:34:44'),
(30, 'en', 'INBOX', 'INBOX', '2021-09-16 17:41:58', '2021-09-16 17:41:58'),
(31, 'en', 'We will add a contact from as soon as possible', 'We will add a contact
from as soon as possible', '2021-09-16 17:42:47', '2021-09-16 17:42:47'),
(32, 'en', 'Enter Your Mail!', 'Enter Your Mail!', '2021-09-16 17:43:09', '2021-09-
16 17:43:09'),
(33, 'en', 'Published in', 'Published in', '2021-09-16 17:44:40', '2021-09-16
17:44:40'),
(34, 'en', 'Date', 'Date', '2021-09-16 17:45:57', '2021-09-16 17:45:57'),
(35, 'en', 'The address you have chosen is already in use. Please choose a
different one.', 'The address you have chosen is already in use. Please choose a
different one.', '2021-09-16 17:51:41', '2021-09-16 17:51:41'),
(36, 'en', 'Your Name', 'Your Name', '2021-09-16 17:57:24', '2021-09-16 17:57:24'),
(37, 'en', 'Your Email', 'Your Email', '2021-09-16 17:57:24', '2021-09-16
17:57:24'),
(38, 'en', 'Your Phone', 'Your Phone', '2021-09-16 17:57:24', '2021-09-16
17:57:24'),
(39, 'en', 'Your Message', 'Your Message', '2021-09-16 17:57:24', '2021-09-16
17:57:24'),
(40, 'en', 'Send Message', 'Send Message', '2021-09-16 17:57:24', '2021-09-16
17:57:24'),
(41, 'en', 'We have received your message and would like to thank you for writing
to us.', 'We have received your message and would like to thank you for writing to
us.', '2021-09-16 17:57:56', '2021-09-16 17:57:56'),
(42, 'en', 'Not Found', 'Not Found', '2021-09-16 18:24:13', '2021-09-16 18:24:13'),
(43, 'en', 'Page Not Found', 'Page Not Found', '2021-09-16 18:24:13', '2021-09-16
18:24:13'),
(44, 'en', 'We are sorry but the page you are looking for was not found', 'We are
sorry but the page you are looking for was not found', '2021-09-16 18:24:13',
'2021-09-16 18:24:13'),
(45, 'en', 'Back to Home', 'Back to Home', '2021-09-16 18:24:13', '2021-09-16
18:24:13'),
(46, 'en', 'Unauthorised', 'Unauthorised', '2021-09-16 18:24:38', '2021-09-16
18:24:38'),
(47, 'en', 'Forbidden', 'Forbidden', '2021-09-16 18:24:50', '2021-09-16 18:24:50'),
(48, 'en', 'Method Not Allowed', 'Method Not Allowed', '2021-09-16 18:25:00',
'2021-09-16 18:25:00'),
(49, 'en', 'Something is broken. Please let us know what you were doing when this
error occurred. We will fix it as soon as possible. Sorry for any inconvenience
caused.', 'Something is broken. Please let us know what you were doing when this
error occurred. We will fix it as soon as possible. Sorry for any inconvenience
caused.', '2021-09-16 18:25:00', '2021-09-16 18:25:00'),
(50, 'en', 'Page Expired', 'Page Expired', '2021-09-16 18:25:11', '2021-09-16
18:25:11'),
(51, 'en', 'Too Many Requests', 'Too Many Requests', '2021-09-16 18:25:16', '2021-
09-16 18:25:16'),
(52, 'en', 'Internal Server Error', 'Internal Server Error', '2021-09-16 18:25:25',
'2021-09-16 18:25:25'),
(53, 'en', 'Oops… You just found an error page', 'Oops… You just found an error
page', '2021-09-16 18:25:25', '2021-09-16 18:25:25'),
(54, 'en', 'We are sorry but our server encountered an internal error', 'We are
sorry but our server encountered an internal error', '2021-09-16 18:25:25', '2021-
09-16 18:25:25'),
(55, 'en', 'Service Unavailable', 'Service Unavailable', '2021-09-16 18:25:36',
'2021-09-16 18:25:36'),
(56, 'ar', 'Mailbox Small Title', ','18:41:04 16-09-2021' ,'‫بريدك الإلكتروني المؤقت‬
18:56:02 16-09-2021''),
(57, 'ar', 'Mailbox Description', ' ‫تخلص الآن من الرسائل المتطفلة ورسائل االعالنات و‬
‫ أبقى صندوق البريد الخاص بك نظيفا وآمنا‬.‫االختراقات والهجوم الآلي‬. Temp Mail ‫يزودك‬
-2021' ,'‫بعنوان بريد الكتروني آمن ومؤقت ومجاني ومجهول ويمكنك التخلص منه في أي وقت‬
18:56:02 16-09-2021' ,'18:41:04 16-09'),
(58, 'ar', 'Refresh', '18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'‫)'تحديث‬,
(59, 'ar', 'Change', '18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'‫)'تغيير‬,
(60, 'ar', 'Delete', '18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'‫)'إحذف‬,
(61, 'ar', 'Sender', '18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'‫)'المرسل‬,
(62, 'ar', 'Subject', '18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'‫)'الموضوع‬,
(63, 'ar', 'View', '18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'‫)'مشاهدة‬,
(64, 'ar', 'Your inbox is empty', '16-09-2021' ,'‫صندوق الوارد الخاص بك فارغ‬
18:56:02 16-09-2021' ,'18:41:04'),
(65, 'ar', 'Waiting for incoming emails', ' ‫في انتظار رسائل البريد الإلكتروني‬
18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'‫)'الواردة‬,
(66, 'ar', 'Awesome Features', '16-09-2021' ,'18:41:04 16-09-2021' ,'‫ميزات رائعة‬
18:56:02'),
(67, 'ar', 'Features Description', '‫يحمي البريد الإلكتروني المؤقت الذي يمكن التخلص‬
‫منه عنوان بريدك الإلكتروني الحقيقي من البريد العشوائي والمراسالت الإعالنية والبرامج‬
18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'.‫)'الضارة‬,
(68, 'ar', 'Popular Posts', '16-09-2021' ,'18:41:04 16-09-2021' ,'‫مقاالت شائعة‬
18:56:02'),
(69, 'ar', 'Back To List', '16-09-2021' ,'18:41:04 16-09-2021' ,'‫الرجوع للقائمة‬
18:56:02'),
(70, 'ar', 'Attachments', '18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'‫)'مرفقات‬,
(71, 'ar', 'Copyright', '2021 ‫ جميع الحقوق محفوضة‬- TrashMails', '2021-09-16
18:41:04', '2021-09-16 18:56:02'),
(72, 'ar', 'Blog', '18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'‫)'مدونة‬,
(73, 'ar', 'Categories', '18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'‫)'االقسام‬,
(74, 'ar', 'Leave a Reply', '16-09-2021' ,'18:41:04 16-09-2021' ,'‫اترك تعليقا‬
18:56:02'),
(75, 'ar', 'Change E-mail Address', '16-09-2021' ,'‫قم بتغير البريد االلكتروني‬
18:56:02 16-09-2021' ,'18:41:04'),
(76, 'ar', 'Change Description', ' ‫ يرجى ادخال عنوان‬،‫لتغير عنوان البريد الإلكتروني‬
-2021' ,'18:41:04 16-09-2021' ,'.‫البريد االلكتروني الذي ترغب به ومن ثم أنقر على حفظ‬
18:56:02 16-09'),
(77, 'ar', 'Contact Us', '18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'‫)'اتصل بنا‬,
(78, 'ar', 'Contact Description', ' ‫نحن هنا للمساعدة والإجابة على أي سؤال قد يكون‬
18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'.‫)'لديك‬,
(79, 'ar', 'Emails Created', '-2021' ,'18:41:04 16-09-2021' ,'‫عدد الإيميالت المؤقتة‬
18:56:02 16-09'),
(80, 'ar', 'Messages Received', '' ,'18:41:04 16-09-2021' ,'‫عدد الرسائل المستقبلة‬
18:56:02 16-09-2021'),
(81, 'ar', 'Cookie Message', ' ‫سيتم تحسين تجربتك على هذا الموقع من خالل السماح‬
18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'.‫)'بملفات تعريف االرتباط‬,
(82, 'ar', 'Cookie Button', '16-09-2021' ,'18:41:04 16-09-2021' ,'‫السماح‬
18:56:02'),
(83, 'ar', 'Homepage Title', ' ‫البريد االلكتروني المجهول أو خدمات البريد االلكتروني‬
18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'‫)'المجاني‬,
(84, 'ar', 'Change Email', '18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'‫)'تغيير‬,
(85, 'ar', 'INBOX', '16-09-2021' ,'18:41:04 16-09-2021' ,'‫صندوق الواردات‬
18:56:02'),
(86, 'ar', 'We will add a contact from as soon as possible', '‫سوف نضيف وسائل االتصال‬
18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'‫)'في اقرب وقت ممكن‬,
(87, 'ar', 'Enter Your Mail!', '16-09-2021' ,'18:41:04 16-09-2021' ,'‫اسم الذي تريده‬
18:56:02'),
(88, 'ar', 'Published in', '18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'‫)'نشر في‬,
(89, 'ar', 'Date', '18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'‫)'تاريخ‬,
(90, 'ar', 'The address you have chosen is already in use. Please choose a
different one.', '' ,'‫ الرجاء استخدم عنوان مختلف‬, ‫االسم الذي اذخلته مستعمل من قبل‬
18:56:02 16-09-2021' ,'18:41:04 16-09-2021'),
(91, 'ar', 'Your Name', '16-09-2021' ,'18:41:04 16-09-2021' ,'‫االسم الكامل‬
18:56:02'),
(92, 'ar', 'Your Email', '16-09-2021' ,'18:41:04 16-09-2021' ,'‫بريدك االلكتوني‬
18:56:02'),
(93, 'ar', 'Your Phone', '16-09-2021' ,'18:41:04 16-09-2021' ,'‫رقم الهاتف‬
18:56:02'),
(94, 'ar', 'Your Message', '16-09-2021' ,'18:41:04 16-09-2021' ,'‫الرسالة‬
18:56:02'),
(95, 'ar', 'Send Message', '18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'‫)'ارسل‬,
(96, 'ar', 'We have received your message and would like to thank you for writing
to us.', '' ,'18:41:04 16-09-2021' ,'.‫لقد تلقينا رسالتك ونود أن نشكرك على مراسلتنا‬
18:56:02 16-09-2021'),
(97, 'ar', 'Not Found', '16-09-2021' ,'18:41:04 16-09-2021' ,'‫الصفحة غير موجودة‬
18:56:02'),
(98, 'ar', 'Page Not Found', '-09-2021' ,'18:41:04 16-09-2021' ,'‫الصفحة غير موجودة‬
18:56:02 16'),
(99, 'ar', 'We are sorry but the page you are looking for was not found', ' ‫نحن‬
' ,'18:41:04 16-09-2021' ,'‫آسفون ولكن الصفحة التي تبحث عنها لم يتم العثور عليها‬
18:56:02 16-09-2021'),
(100, 'ar', 'Back to Home', '-09-2021' ,'18:41:04 16-09-2021' ,'‫العودة إلى الرئسية‬
18:56:02 16'),
(101, 'ar', 'Unauthorised', '16-09-2021' ,'18:41:04 16-09-2021' ,'‫غير مصرح‬
18:56:02'),
(102, 'ar', 'Forbidden', '' ,'18:41:04 16-09-2021' ,'‫ممنوع الذخول الى هده الصفحة‬
18:56:02 16-09-2021'),
(103, 'ar', 'Method Not Allowed', '-2021' ,'18:41:04 16-09-2021' ,'‫طريقة غير مسموحة‬
18:56:02 16-09'),
(104, 'ar', 'Something is broken. Please let us know what you were doing when this
error occurred. We will fix it as soon as possible. Sorry for any inconvenience
caused.', ' ‫ ونحن‬.‫ الرجاء إخبارنا بما كنت تفعله عندما حدث هذا الخطأ‬.‫شيء ما مكسور‬
' ,'18:41:04 16-09-2021' ,'.‫ اعتذر على أي ازعاج حدث‬.‫سوف إصالحه في أقرب وقت ممكن‬
18:56:02 16-09-2021'),
(105, 'ar', 'Page Expired', '-09-2021' ,'18:41:04 16-09-2021' ,'‫انتهت صالحية الرابط‬
18:56:02 16'),
(106, 'ar', 'Too Many Requests', '-2021' ,'18:41:04 16-09-2021' ,'‫طلبات كثيرة جدا‬
18:56:02 16-09'),
(107, 'ar', 'Internal Server Error', '16-09-2021' ,'‫خطأ في الخادم الداخلي‬
18:56:02 16-09-2021' ,'18:41:04'),
(108, 'ar', 'Oops… You just found an error page', ' ‫ لقد عثرت للتو على صفحة‬... ‫عفًوا‬
18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'‫)'خطأ‬,
(109, 'ar', 'We are sorry but our server encountered an internal error', '‫نحن آسفون‬
18:56:02 16-09-2021' ,'18:41:04 16-09-2021' ,'‫)'ولكن خادمنا واجه خطأ داخلي‬,
(110, 'ar', 'Service Unavailable', '' ,'18:41:04 16-09-2021' ,'‫الخدمة غير متوفرة‬
18:56:02 16-09-2021');

ALTER TABLE `translates`


ADD PRIMARY KEY (`id`);

ALTER TABLE `translates`


MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=111;
COMMIT;

ALTER TABLE `features` ADD `lang` VARCHAR(255) NOT NULL AFTER `description`;
UPDATE `features` SET `lang`="en" WHERE 1;

INSERT INTO `features` (`id`, `icon`, `title`, `description`, `lang`, `created_at`,


`updated_at`) VALUES
(NULL, '<i class=\"fas fa-envelope-open-text\"></i>', ' ‫ 'أنشئ رسائل‬,'‫بسيط ومجاني‬
‫'بريد إلكتروني مؤقتة بخطوات بسيطة وسريعة ومجانية دائًما‬, 'ar', '2021-09-16
19:38:39', '2021-09-16 20:44:04'),
(NULL, '<i class=\"fas fa-globe-europe\"></i>', '‫ 'يستخدمه المحترفون في جميع‬,'‫عالمي‬
‫ جربه الآن‬، ‫'أنحاء العالم‬, 'ar', '2021-09-16 20:42:46', '2021-09-18 13:50:27'),
(NULL, '<i class=\"fas fa-envelope-open-text\"></i>', '100% ‫ 'حماية خصوصيتك و‬,'‫أمان‬
‫'عدم السماح للبريد العشوائي في صندوق الوارد الشخصي‬, 'ar', '2021-09-16 20:43:58',
'2021-09-18 13:52:39');

LAST STEP
——————————————————————————————————————
Clear the Cache and Cookies in Your Browser

You might also like