Update Process

Note: Before Update Take Backup of All Files And Database. Make .zip file and download all file, Go To phpmyadmin and select your database and export it.

Copy All files and paste to you folder replace file. Only be careful when replace files in public folder, don't copy .env file. Any user customize design and code please do not update. For database don not import all tables.

Update Version 2.2

2.1 Version Required then Copy All files of folder and paste to you folder and replace files, only be careful when replace files in public folder, don't copy .env file.Any user customize design and code please do not update.

After replacing the files successfully login with admin goto yourdomain.com/ota/update. If your domain contain public then goto yourdomain.com/public/ota/update. Read update pre-notes and FAQ properly, then check the agreement box and click on update. After the update completion you will be redirected to yourdomain with a successful update message.

Once the process is complete you will see a successful message on your home page.

You successfully upgraded to version 2.2.

Update Version 2.1

2.0 Update Required then Copy All files of folder and paste to you folder and replace files, only be careful when replace files in public folder, don't copy .env file. Database old is work fine but need some columns and tables.

1. Create New Table watch_courses.
Note: You Can Import Table From Database -> Old Users Update eclassupdate_2.1.sql.
2. Add aws_upload column in course_classes table. Make it varchar(255), Default NULL.
Note: You Can not Import Columns, You need to create it Manually.
3. Add rating, chapter_id column in assignments table. Make it int(11), Default NULL.
Note: You Can not Import Columns, You need to create it Manually.
4. Add aws_enable, device_control, assignment_enable, appointment_enable, certificate_enable, ipblock_enable column in settings table. Make it boolean, Default 0.
Add ipblock column in settings table. Make it longtext, Default NULL.
Note: You Can not Import Columns, You need to create it Manually.

Add these variable to .evn file

	
AWS_ACCESS_KEY_ID=

AWS_SECRET_ACCESS_KEY=

AWS_DEFAULT_REGION=

AWS_BUCKET=

AWS_URL=
	

Update Version 2.0

1.9 Update Required then Copy All files of folder and paste to you folder and replace files, only be careful when replace files in public folder, don't copy .env file. Database old is work fine but need some columns and tables.

1. Create New Table assignments, appointments.
Note: You Can Import Table From Database -> Old Users Update eclassupdate_2.0.sql.
2. Add linkedin_id, twitter_id column in users table. Make it varchar(255), Default NULL.
Note: You Can not Import Columns, You need to create it Manually.
3. Add audio column in course_classes table. Make it varchar(255), Default NULL.
Add position column in course_classes table. Make it int(11), Default NULL.
Add detail column in course_classes table. Make it longtext, Default NULL.
Note: You Can not Import Columns, You need to create it Manually.
4. Add link_by column in meetings table. Make it varchar(255), Default NULL.
Add course_id column in meetings table. Make it int(11), Default NULL.
Note: You Can not Import Columns, You need to create it Manually.
5. Edit swift_code, ifcs_code column in bank_transfers table. Make it Default NULL.
Note: You Can not Import Columns, You need to create it Manually.
6. Add course_id column in bigbluemeetings table. Make it int(11), Default NULL.
Add link_by column in bigbluemeetings table. Make it varchar(255), Default NULL.
Add is_ended column in bigbluemeetings table. Make it boolean, Default (0).
Note: You Can not Import Columns, You need to create it Manually.
7. Add contact_image, promo_link, map_api column in settings table. Make it varchar(255), Default NULL.
Add mobile_enable, promo_enable, linkedin_enable, twitter_enable column in settings table. Make it tinyint(1), Default (0).
Add promo_text column in settings table. Make it longtext, Default NULL.
Note: You Can not Import Columns, You need to create it Manually.

Add these variable to .evn file

	
LINKEDIN_CLIENT_ID=

LINKEDIN_CLIENT_SECRET=

LINKEDIN_CALLBACK_URL=

TWITTER_CLIENT_ID=

TWITTER_CLIENT_SECRET=

TWITTER_CALLBACK_URL=
	

Update Version 1.9

1.8 Update Required then Copy All files of folder and paste to you folder and replace files, only be careful when replace files in public folder, don't copy .env file. Database old is work fine but need some columns and tables.

1. Create New Table course_progress, adsenses, bigbluemeetings.
Note: You Can Import Table From Database -> Old Users Update eclassupdate_1.9.sql.
2. Add proof column in orders table. Make it varchar(255), Default NULL.
Note: You Can not Import Columns, You need to create it Manually.
3. Add bbl_enable column in settings table. Make it >boolean, Default (0).
Add map_lat, map_long column in settings table. Make it varchar(255).
Note: You Can not Import Columns, You need to create it Manually.
4. Edit due_days column in quiz_topics table. Make it Default NULL.
Note: You Can not Import Columns, You need to create it Manually.
5. Add text_one, text_two, text_three, link_one, link_two, link_three, link_four column in abouts table. Make it varchar(255).
Note: You Can not Import Columns, You need to create it Manually.

Add these variable to .evn file

	
BBB_SECURITY_SALT=
BBB_SERVER_BASE_URL=
	

Update Version 1.8

1.7 Update Required then Copy All files of folder and paste to you folder replace file, only be careful when replace files in public folder, don't copy .env file. Database old is work fine but need some columns and tables.

1. Create New Table bundle_courses.
Note: You Can Import Table From Database -> Old Users Update eclassupdate_1.8.sql.
2. Add captcha_enable, amazon_enable column in settings table. Make it boolean, Default 0.
Note: You Can not Import Columns, You need to create it Manually.
3. Edit price, offer_price column in carts table. Make it type double
Note: You Can not Import Columns, You need to create it Manually.
4. Add bundle_id column in orders table. Make it int(191), Default NULL.
Add bundle_course_id column in orders table. Make it varchar(191), Default NULL.
Edit course_id column in orders table. Default NULL.
Note: You Can not Import Columns, You need to create it Manually.
5. Add bundle_id column in carts table. Make it int(11), Default NULL.
Add type column in carts table. Make it boolean, Default NULL.
Edit course_id column in carts table. Default NULL.
Note: You Can not Import Columns, You need to create it Manually.

Update Version 1.7

1.6 Update Required then Copy All files of folder and paste to you folder replace file, only be careful when replace files in public folder, don't copy .env file. Database old is work fine but need some columns and tables.

1. Create New Table pending_payouts, completed_payouts, instructor_settings, meetings.
Note: You Can Import Table From Database -> Old Users Update eclassupdate_1.7.sql.
2. Add google_id, gitlab_id, facebook_id, prefer_pay_method, paypal_email, paytm_mobile, bank_acc_name, bank_acc_no, ifsc_code, bank_name, zoom_email column in users table. Make it varchar(255), Default NULL.
Add jwt_token column in users table. Make it longtext, Default NULL.
Note: You Can not Import Columns, You need to create it Manually.
3. Add order_id column in orders table. Make it varchar(255), Default NULL.
Add instructor_revenue column in orders table. Make it Int(255), Default NULL.
Note: You Can not Import Columns, You need to create it Manually.
4. Add preloader_enable column in settings table. Make it boolean, Default 1.
Add zoom_enable column in settings table. Make it boolean, Default 0.
Note: You Can not Import Columns, You need to create it Manually.
5. Add date_time column in course_classes table. Make it datetime, Default NULL.
Note: You Can not Import Columns, You need to create it Manually.
6. Add due_date column in quiz_topics table. Make it int(11), Default NULL.
Add quiz_again column in quiz_topics table. Make it boolean, Default 1.
Note: You Can not Import Columns, You need to create it Manually.
7. Add bank_enable column in bank_transfers table. Make it boolean, Default 1.
Note: You Can not Import Columns, You need to create it Manually.

Update Version 1.6

1.5 Update Required then Copy All files of folder and paste to you folder replace file, only be careful when replace files in public folder, don't copy .env file. Database old is work fine but need some columns and tables.

1. Create New Table jobs, feature_courses, feature_payments.
Note: You Can Import Table From Database -> Old Users Update eclassupdate_1.6.sql.
2. Add feature_amount column in settings table. Make it int(11), Default NULL.
Note: You Can not Import Columns, You need to create it Manually.
3. Add duration column in courses table. Make it int(11), Default NULL.
Note: You Can not Import Columns, You need to create it Manually.
4. Add duration column in orders table. Make it int(11), Default NULL.
Add enroll_start, enroll_expire column in orders table. Make it date, Default NULL.
Note: You Can not Import Columns, You need to create it Manually.

Update Version 1.5

1.4 Update Required then Copy All files of folder and paste to you folder replace file, only be careful when replace files in public folder, don't copy .env file. Database old is work fine but need some columns and tables.

1. Create New Table question_reports.
Note: You Can Import Table From Database -> Old Users Update eclassupdate_1.5.sql.
2. Add position column in categories table. Make it int(11), Default NULL.
Note: You Can not Import Columns, You need to create it Manually.
3. Add position column in sliders table. Make it int(11), Default NULL.
Note: You Can not Import Columns, You need to create it Manually.
4. Add download column in player_settings table. Make it int(11), Default 0.
Note: You Can not Import Columns, You need to create it Manually.
5. Add preview_video, preview_url, preview_type column in course_classes table. Make it varchar(255), Default NULL.
Note: You Can not Import Columns, You need to create it Manually.

Update Version 1.4

1.3 Update Required then Copy All files of folder and paste to you folder replace file, only be careful when replace files in public folder, don't copy .env file. Database old is work fine but need some columns and tables.

1. Create New Table quiz_questions, quiz_topics, quiz_answers.
Note: You Can Import Table From Database -> Old Users Update eclassupdate_1.4.sql.
2. Add autoplay column in player_settings table. Make it Integer, Default 0.
Note: You Can not Import Columns, You need to create it Manually.

Update Version 1.3

1.2 Update Required then Copy All files of folder and paste to you folder replace file, only be careful when replace files in public folder, don't copy .env file. Database old is work fine but need some columns and tables.

1. Create New Table player_settings, ads.
Note: You Can Import Table From Database -> Old Users Update eclassupdate_1.3.sql.
2. Add verify_enable, cat_enable column in setings table. Make it Integer, Default 0.
Note: You Can not Import Columns, You need to create it Manually.

Update Version 1.2

1.1 Update Required then Copy All files of folder and paste to you folder replace file, only be careful when replace files in public folder, don't copy .env file. Database old is work fine but need some columns and tables.

1. Edit fb_url, twitter_url, youtube_url, linkedin_urlcolumn in users table. Default NULL..

Update Version 1.1

Copy All files of folder and paste to you folder replace file, only be careful when replace files in public folder, don't copy .env file. Database old is work fine but need some columns and tables.

1. Create New Table bank_transfers.
Note: You Can Import Table From Database -> Old Users Update eclassupdate_1.1.sql.
2. Add instructor_id column in orders table. Make it Integer, Default NULL.
Add status column in order table. Make it Integer, Default 1.
Note: You Can not Import Columns, You need to create it Manually.
3. Add instructor_id column in questions table. Make it Integer, Default NULL.
Note: You Can not Import Columns, You need to create it Manually.
4. Add instructor_id column in answers table. Make it Integer, Default NULL.
Note: You Can not Import Columns, You need to create it Manually.
5. Add iframe_url column in course_classes table. Make it longtext, Default NULL.
Note: You Can not Import Columns, You need to create it Manually.