One Hat Cyber Team
Your IP :
216.73.216.115
Server IP :
194.44.31.54
Server :
Linux zen.imath.kiev.ua 4.18.0-553.77.1.el8_10.x86_64 #1 SMP Fri Oct 3 14:30:23 UTC 2025 x86_64
Server Software :
Apache/2.4.37 (Rocky Linux) OpenSSL/1.1.1k
PHP Version :
5.6.40
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
home
/
vo
/
umj
/
Edit File:
ojsdiffnew-2
diff -ur ojs-prev/lib/pkp/classes/user/PKPUserDAO.inc.php ojs/lib/pkp/classes/user/PKPUserDAO.inc.php --- ojs-prev/lib/pkp/classes/user/PKPUserDAO.inc.php 2017-12-14 13:01:54.458766874 +0200 +++ ojs/lib/pkp/classes/user/PKPUserDAO.inc.php 2018-05-14 21:28:04.488702918 +0300 @@ -281,6 +281,9 @@ JOIN user_user_groups uug ON (uug.user_id = u.user_id) JOIN user_groups ug ON (ug.user_group_id = uug.user_group_id AND ug.role_id = ? AND ug.context_id = ?) JOIN user_group_stage ugs ON (ugs.user_group_id = ug.user_group_id AND ugs.stage_id = ?) + LEFT JOIN user_settings usf ON (usf.user_id = u.user_id AND usf.setting_name = \'firstName\') + LEFT JOIN user_settings usm ON (usm.user_id = u.user_id AND usm.setting_name = \'middleName\') + LEFT JOIN user_settings usl ON (usl.user_id = u.user_id AND usl.setting_name = \'lastName\') LEFT JOIN review_assignments ras ON (ras.submission_id = ? AND ras.stage_id = ? AND ras.review_round_id = ? AND ras.reviewer_id=u.user_id) LEFT JOIN review_assignments rac ON (rac.reviewer_id = u.user_id AND rac.date_notified IS NOT NULL AND rac.date_completed IS NOT NULL) LEFT JOIN review_assignments raf ON (raf.reviewer_id = u.user_id) @@ -290,7 +293,7 @@ AND ran.review_id IS NULL' . ($reviewRound !== null ? ' AND rac.submission_id = ? AND rac.stage_id = ? AND rac.round < ?':'') . str_repeat(' AND u.user_id IN (SELECT ui.user_id FROM user_interests ui JOIN controlled_vocab_entry_settings cves ON (ui.controlled_vocab_entry_id = cves.controlled_vocab_entry_id) WHERE cves.setting_name = \'interest\' AND LOWER(cves.setting_value) = ?)', count($interests)) . - ($name !== null?' AND (u.first_name LIKE ? OR u.middle_name LIKE ? OR u.last_name LIKE ? OR u.username LIKE ? OR u.email LIKE ?)':'') . ' + ($name !== null?' AND (usf.setting_value LIKE ? OR usm.setting_value LIKE ? OR usl.setting_value LIKE ? OR u.username LIKE ? OR u.email LIKE ?)':'') . ' GROUP BY u.user_id HAVING 1=1' . ($doneMin !== null?' AND COUNT(DISTINCT rac.review_id) >= ?':'') .
Simpan