Gecko [ nbspublicschool.com ]

Name	Size	Permission
images	[ DIR ]	drwxr-xr-x
lang	[ DIR ]	drwxr-xr-x
php53	[ DIR ]	drwxr-xr-x
php56	[ DIR ]	drwxr-xr-x
php71	[ DIR ]	drwxr-xr-x
php81	[ DIR ]	drwxr-xr-x
php82	[ DIR ]	drwxr-xr-x
clone.php	3.76 KB	-rw-r--r--
config.inc.php	2.06 KB	-rw-r--r--
edit.php	5.06 KB	-rw-r--r--
edit.xml	433 B	-rw-r--r--
fileindex.php	690 B	-rw-r--r--
import.php	3.07 KB	-rw-r--r--
info.xml	1.96 KB	-rw-r--r--
install.js	921 B	-rw-r--r--
install.php	7.79 KB	-rw-r--r--
install.xml	1.22 KB	-rw-r--r--
md5	4.54 KB	-rw-r--r--
notes.txt	1.23 KB	-rw-r--r--
update_pass.php	228 B	-rw-r--r--

Code Editor : notes.txt

1. PHP REQUIREMENT LINK : https://www.rosariosis.org/technical-specifications/
2. Move all procedures/triggers to the end in sql.
3. Update '//' to '$$' in DELIMITER in sql.
4. Change "config_value" of "LOGIN" to "Yes" in "config" table to avoid password reset page after login.
5. Go "Users" > "User info" to update login username.
6. Remove DEFINER=`root`@`localhost` from sql.
7. Keep mysql 8 restriction in info.xml as it throws error i.e Could not make the query numbered : 182. MySQL Error No : 1064. MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank, (select count(*) from student_mp_stats sgm4 ' at line 14. Check if it works in next version on mysql 8 and remove restriction accordingly in info.xml.
8. While adding any new language in install.xml make sure you check locale/REFERENCE.md file to check it's percentage of translation . Add only if it's >= 80 percent. 
9. Important : Copy rosariosis_es.sql, rosariosis_fr.sql and rosariosis_pt_BR.sql from original package to our /lang/ folder in every version. These are needed, since we import them to translate database to spanish, brazilian portuguese and french respectively.(On vendor request)

${this.title}

Code Editor : notes.txt