Andhik Ampuh Yunanto

Kerentanan SQL injection masih menjadi ancaman serius dalam pengembangan aplikasi web dengan tingkat prevalensi mencapai 23% dari seluruh kerentanan kritis aplikasi web di tahun 2024. Penelitian ini bertujuan menganalisis efektivitas implementasi parameterized queries sebagai mekanisme pencegahan serangan SQL injection pada sistem autentikasi berbasis PHP. Metodologi penelitian menggunakan pendekatan eksperimental dengan membandingkan dua implementasi sistem login: versi rentan yang menggunakan string concatenation dan versi aman yang menerapkan prepared statements melalui PHP Data Objects (PDO). Pengujian dilakukan menggunakan 15 payload SQL injection yang berbeda untuk mengevaluasi tingkat keberhasilan bypass pada masing-masing implementasi. Hasil penelitian menunjukkan bahwa implementasi parameterized queries berhasil mencegah 100% serangan SQL injection yang diuji, sementara implementasi rentan mengalami tingkat keberhasilan bypass sebesar 93.3%. Analisis performa menunjukkan bahwa parameterized queries memberikan peningkatan kecepatan eksekusi sebesar 23% untuk operasi berulang dibandingkan dengan string concatenation. Temuan ini membuktikan bahwa penerapan parameterized queries tidak hanya memberikan jaminan keamanan maksimal tetapi juga mengoptimalkan performa aplikasi web.

Residents of Gebang Putih, Surabaya, often face challenges in accessing administrative information, such as procedures for creating ID cards, updating family data, and registering for marriage. To address these issues, a chatbot based on Dialogflow was developed and integrated with the Telegram platform and a mobile application called Kagapi. This study included data collection from official government websites, interviews with local office staff, and dataset preparation for chatbot training. The results showed that the chatbot achieved a 92% accuracy rate in understanding and responding to user queries, with an average response time of 2-3 seconds. Integration with the mobile application expanded service features, including online queue management. Testing and evaluation by local office staff and residents indicated that the chatbot improved information accessibility and service efficiency by up to 80%. This chatbot demonstrates the potential to serve as an innovative solution in enhancing public service transparency and accessibility.

Chicken and duck eggs are highly nutritious food products that are popular among the Indonesian community. However, their perishable nature leads to a decline in quality if not further processed. The salting process is a simple preservation method that can also enhance the flavor of salted egg products. To produce salted egg products with high organoleptic quality preference, a combination of Analytical Hierarchy Process (AHP) and Simple Additive Weighting (SAW) is implemented as a quality decision-making method based on: (1) the experts viewpoints on the importance level of organoleptic criteria, and (2) the scores of organoleptic tests for the criteria of texture, taste, and appearance. In this study, chicken and duck eggs were processed into salted eggs using a salting mixture made of a blend of scouring ash and table salt with a mass ratio of 5:4 and 5:6, resulting in product combinations coded as CE-5/4, CE-5/6, DE-5/4, and DE-5/6. Data processing results on the importance level from the experts viewpoints using the AHP method resulted that the criteria for texture, taste, and aroma had final priority weights of 0.244, 0.617, and 0.139, respectively. Final decision-making using the SAW method indicated that the highest to lowest final preference scores were obtained by products CE-5/4, DE-5/4, DE-5/6, and CE-5/6, with the final preference scores of 0.979, 0.963, 0.931, and 0.906, respectively. The results demonstrated that AHP and SAW were successfully implemented to assist in making decisions regarding the quality of salted egg products based on their organoleptic characteristics. Keywords: salted egg, organoleptic, decision-making, AHP, SAW

Industri permainan telah mengalami perkembangan pesat dalam beberapa tahun terakhir, ditandai dengan munculnya berbagai jenis permainan yang menarik dan inovatif. Salah satu tren yang sedang meningkat adalah popularitas game midcore yang berhasil menarik perhatian pemain dari berbagai kelompok. Karena daya tariknya, banyak studio game beralih ke pengembangan game midcore untuk mengeksplorasi potensi pasar yang luas dan mencapai kesuksesan yang lebih besar. Salah satu tantangan utama yang dihadapi dalam pengembangan game midcore oleh perusahaan adalah perancangan dan pembuatan komponen antarmuka pengguna (UI) yang efektif. Bagian UI merupakan aspek kritis dalam permainan karena secara langsung mempengaruhi pengalaman bermain dan keterlibatan pemain. Di samping itu, pada saat ini belum ada standar universal atau framework yang sepenuhnya mendukung pengembangan UI pada game midcore. Kurangnya alat bantu yang efisien dapat menyebabkan penundaan dan peningkatan beban kerja pada tim pengembang, yang akhirnya dapat berdampak pada keseluruhan pengalaman bermain dan kualitas produk. Dalam menghadapi tantangan pengembangan UI pada game midcore, penelitian ini menyajikan solusi dengan menerapkan design pattern untuk mengembangkan komponen UI game yang akan menjadi framework pada Unity Engine. Hasil validasi menunjukkan bahwa penggunaan framework ini menyebabkan efisiensi pada waktu pengembangan dan interaction cost. Efisiensi interaction cost sebesar 10% hingga 66% dan waktu pengembangan sebesar 28% hingga 91%. Selain itu, dari hasil survei pelanggan menggunakan metode perhitungan Customer Satisfaction Score (CSAT), diperoleh tingkat kepuasan pelanggan sebesar 78%. Nilai 78% dalam skala CSAT dianggap sebagai tingkat kepuasan "excellent response," yang menyiratkan bahwa menurut pelanggan, framework ini telah memiliki performa yang sangat baik.

In today's technological developments, there are many applications and systems that have been used by the community, both children and adults. This impact causes the technological era to continue to develop rapidly so that the existence of applications has become a basic need for the community. One of the emerging technologies today is an application that can help learn for its users. However, in the market, educational applications still have less attractive elements and features. So, this study aims to develop applications with the theme of education by utilizing the UX Design and Gamification approach. This approach aims to make users more interested and in accordance with user needs. The case study used in this research is English grammar because this knowledge is an important knowledge base that must be possessed by everyone. The test is carried out on users who are students because they are respondents who are in accordance with the grammar level. The test results show that the NPS value given has an average of 59%. This indicates that the application has been accepted by the user. So that by developing this application, it is hoped that it can help users in learning English grammar interactively.

Sebagai bentuk pemerintahan terkecil RT melakukan berbagai fungsi tersebut seperti pelayanan administrasi keuangan dan pendataan kependudukan, Kekayaan RT dan data kependudukan warga harus dikelola secara tertib, transparan, tercatat dan dapat dipertanggung jawabkan. Karena manajemen keuangan masih menggunakan cara pencatatan manual Warga Desa Plosorejo Blitar tidak bisa me-monitoring keuangan secara langsung dan mengalami keresahan jika buku keuangan tersebut mengalami kerusakan. Selain itu tidak efektif nya pengolahan data warga oleh ketua RT karena sering berkeliling desa untuk meminta data warga. Solusi dari permasalahan di atas adalah Membuat website sistem informasi manajemen keuangan dan pendataan warga Desa Plosorejo Blitar,agar mengurangi keresahan warga dan pihak ketua RT jika mengalami kehilangan atau rusaknya catatan keuangan desa,dan juga mengefektifkan,mempercepat sekaligus meringankan tugas ketua RT dalam mengolah data warga. Metode pengujian proyek akhir ini menggunakan black box testing untuk menguji fungsionalitas aplikasi dan skala likert untuk menghitung persentasi kuesioner.

Software Testing plays an important role in making high quality products and the right time. The process of testing done manually is often inaccurate, unreliable, and needed more than automatic testing. This research proposes a new framework for automation testing. This framework will help developers to create applications with better quality and shorten testing time. This framework offers a solution for developers so that the testing process is carried out easily and quickly. Our proposed concept consists of an automated test script based on Serenity Framework and can be done as a background process using Jenkins. Input of the system is a testing scenario, then mapped into Java Programming Language. Output of this system are test reports that represent the scenario that has been carried out. the results of implementation system prove that developers are helped by this framework in the software testing process. So that in this study it can be concluded that the automated testing framework that has been developed can improve the quality of application products through effective and efficient work methods.

Ekspansi Pemasaran dan Pembuatan Sistem Manajemen Keuangan pada UMKM Makanan Ringan UD Bawang Mas Berbasis Teknologi Informasi