ZZC24139A BEGIN
user=www host=singapore-webuzo-4gb ob=/www/wwwroot/167.172.95.167/:/tmp/

##### TREE /www/wwwroot/167.172.95.167/keluaranbwg77/chat #####
F 98       logout.php
F 145      index.php
D 4096     app
D 4096     app/ajax
F 1403     app/ajax/search.php
F 1941     app/ajax/getMessage.php
F 1365     app/ajax/insert.php
F 427      app/ajax/update_last_seen.php
D 4096     app/http
F 2083     app/http/auth.php
F 3997     app/http/signup.php
D 4096     app/helpers
F 403      app/helpers/opened.php
F 1435     app/helpers/conversations.php
F 736      app/helpers/timeAgo.php
F 307      app/helpers/chat.php
F 306      app/helpers/user.php
F 441      app/helpers/last_chat.php
F 456      app/db.conn.php
D 4096     uploads
F 31940    uploads/eka.png
F 44392    uploads/ekram.jpg
F 5310     uploads/rendy.jpg
F 2801     uploads/user-default.png
F 41972    uploads/ibro.png
F 6276     uploads/john.jpg
F 31940    uploads/abas.png
F 13667    uploads/elias.jpg
F 1677     error_log
F 268      README.md
F 50       chat03March2022.txt
F 2569     signup.php
D 4096     css
F 949      css/style.css
D 4096     img
F 3366     img/logo.png
D 4096     .db
F 2567     .db/chat_app_db.sql
F 6101     chat.php

##### TREE /www/wwwroot/167.172.95.167/keluaranbwg77/adminpage #####
D 4096     scss
D 4096     scss/vertical-layout-light
F 163      scss/vertical-layout-light/style.scss
F 6947     scss/vertical-layout-light/_sidebar.scss
F 9896     scss/vertical-layout-light/_layouts.scss
F 6648     scss/vertical-layout-light/_settings-panel.scss
F 2435     scss/vertical-layout-light/_variables.scss
F 13945    scss/vertical-layout-light/_navbar.scss
F 959      scss/vertical-layout-light/_vertical-wrapper.scss
D 4096     scss/common
D 4096     scss/common/light
F 3975     scss/common/light/_fonts.scss
F 5005     scss/common/light/common.scss
D 4096     scss/common/light/landing-screens
F 1443     scss/common/light/landing-screens/_auth.scss
F 209      scss/common/light/_background.scss
F 6252     scss/common/light/_demo.scss
F 1820     scss/common/light/_reset.scss
F 97       scss/common/light/_functions.scss
F 1647     scss/common/light/_typography.scss
F 1497     scss/common/light/_utilities.scss
D 4096     scss/common/light/components
F 2122     scss/common/light/components/_lists.scss
F 823      scss/common/light/components/_icons.scss
F 2508     scss/common/light/components/_preview.scss
D 4096     scss/common/light/components/plugin-overrides
F 199      scss/common/light/components/plugin-overrides/_icheck.scss
F 1152     scss/common/light/components/plugin-overrides/_x-editable.scss
F 2558     scss/common/light/components/plugin-overrides/_avgrund.scss
F 583      scss/common/light/components/plugin-overrides/_jquery-file-upload.scss
F 1145     scss/common/light/components/plugin-overrides/_typeahead.scss
F 338      scss/common/light/components/plugin-overrides/_toast.scss
F 143      scss/common/light/components/plugin-overrides/_quill.scss
F 3194     scss/common/light/components/plugin-overrides/_wysieditor.scss
F 242      scss/common/light/components/plugin-overrides/_ace.scss
F 190      scss/common/light/components/plugin-overrides/_codemirror.scss
F 318      scss/common/light/components/plugin-overrides/_tags.scss
F 1407     scss/common/light/components/plugin-overrides/_select2.scss
F 106      scss/common/light/components/plugin-overrides/_tinymce.scss
F 127      scss/common/light/components/plugin-overrides/_progressbar-js.scss
F 152      scss/common/light/components/plugin-overrides/_summernote.scss
F 3074     scss/common/light/components/plugin-overrides/_pws-tabs.scss
F 646      scss/common/light/components/_tables.scss
F 611      scss/common/light/components/_tooltips.scss
F 5214     scss/common/light/components/_checkbox-radio.scss
F 1075     scss/common/light/components/_toggle-switch.scss
F 694      scss/common/light/components/_dropdown.scss
F 5071     scss/common/light/components/_accordions.scss
F 1812     scss/common/light/components/_cards.scss
D 4096     scss/common/light/components/loaders
F 330      scss/common/light/components/loaders/_loaders.scss
F 849      scss/common/light/components/loaders/_moving-square-loader.scss
F 1219     scss/common/light/components/loaders/_pixel-loader.scss
F 905      scss/common/light/components/loaders/_circle-loader.scss
F 2811     scss/common/light/components/loaders/_colored-balls.scss
F 1486     scss/common/light/components/loaders/_square-path-loader.scss
F 762      scss/common/light/components/loaders/_dot-opacity-loader.scss
F 873      scss/common/light/components/loaders/_bar-loader.scss
F 1562     scss/common/light/components/loaders/_square-box.scss
F 1025     scss/common/light/components/loaders/_jumping-dots-loader.scss
F 689      scss/common/light/components/loaders/_flip-square-loader.scss
F 174      scss/common/light/components/loaders/_variables.scss
F 2285     scss/common/light/components/loaders/_glowing-ball.scss
F 1506     scss/common/light/components/_buttons.scss
F 333      scss/common/light/components/_badges.scss
F 1615     scss/common/light/components/_portfolio.scss
F 1166     scss/common/light/components/_forms.scss
F 2012     scss/common/light/components/_breadcrumbs.scss
F 2087     scss/common/light/components/_pagination.scss
F 2052     scss/common/light/components/_popover.scss
F 1431     scss/common/light/components/_todo-list.scss
D 4096     scss/common/light/mixins
F 314      scss/common/light/mixins/_no-ui-slider.scss
F 125      scss/common/light/mixins/_blockqoute.scss
F 537      scss/common/light/mixins/_tooltips.scss
F 643      scss/common/light/mixins/_popovers.scss
F 1123     scss/common/light/mixins/_animation.scss
F 137      scss/common/light/mixins/_cards.scss
F 1238     scss/common/light/mixins/_buttons.scss
F 131      scss/common/light/mixins/_badges.scss
F 1322     scss/common/light/mixins/_misc.scss
F 643      scss/common/light/mixins/_breadcrumbs.scss
F 328      scss/common/light/mixins/_pagination.scss
F 695      scss/common/light/_footer.scss
F 1502     scss/common/light/_misc.scss
F 7991     scss/common/light/_variables.scss
F 2463     miniprag.php
F 182      koneksi.php
F 5856     utama.php
F 3302     login.php
F 1767     samping.php
F 1590     package.json
F 1318     loginpage.php
F 5812     adminpage_demoslot.php
D 4096     js
F 3264     js/ion-range-slider.js
F 4746     js/maps.js
F 4837     js/mapael_example_2.js
F 185      js/jquery-file-upload.js
F 10218    js/flot-chart.js
F 116      js/dropzone.js
F 821      js/data-table.js
F 812      js/dragula.js
F 2404     js/owl-carousel.js
F 914      js/avgrund.js
F 168      js/profile-demo.js
F 238      js/ace.js
F 21812    js/db.js
F 802      js/bt-maxLength.js
F 4482     js/morris.js
F 6998     js/no-ui-slider.js
F 298432   js/mapael_example_1.js
F 1421     js/form-repeater.js
F 3408     js/just-gage.js
F 5043     js/x-editable.js
F 4891     js/js-grid.js
F 174      js/mapael.js
F 3146     js/form-validation.js
F 974      js/tabs.js
F 3681     js/codeEditor.js
F 1929     js/typeahead.js
F 5764     js/c3.js
F 5925     js/progress-bar.js
F 6460     js/editorDemo.js
F 243      js/tablesorter.js
F 3739     js/template.js
F 237      js/select2.js
F 3619     js/form-addons.js
F 1565     js/codemirror.js
F 1733     js/bootstrap-table.js
F 223      js/clipboard.js
F 69       js/dropify.js
F 225      js/demo.js
F 491      js/paginate.js
F 397      js/light-gallery.js
F 4944     js/chartist.js
F 1877     js/desktop-notification.js
F 806      js/hoverable-collapse.js
F 176      js/tight-grid.js
F 46587    js/dashboard.js
F 5099     js/google-charts.js
F 1917     js/sparkline.js
F 2476     js/toastDemo.js
F 158      js/listify.js
F 1365     js/wizard.js
F 15639    js/google-maps.js
F 809      js/tooltips.js
F 8010     js/chart.js
F 6778     js/rickshaw.js
F 2954     js/settings.js
F 398      js/file-upload.js
F 3203     js/jq.tablesort.js
F 636      js/modal-demo.js
F 310      js/circle-progress.js
F 5077     js/context-menu.js
F 970      js/todolist.js
F 998      js/formpickers.js
F 185      js/off-canvas.js
F 807      js/popover.js
F 2457     js/alerts.js
F 1840     js/calendar.js
F 3859     index.php
D 4096     images
D 4096     images/auth
F 212664   images/auth/lockscreen-bg.jpg
F 165567   images/auth/login-bg.jpg
F 275426   images/auth/register-bg.jpg
D 4096     images/faces
F 9885     images/faces/face21.jpg
F 11728    images/faces/face4.jpg
F 14222    images/faces/face13.jpg
F 12433    images/faces/face10.jpg
F 9311     images/faces/face27.jpg
F 9230     images/faces/face19.jpg
F 14465    images/faces/face25.jpg
F 10400    images/faces/face7.jpg
F 15062    images/faces/face8.jpg
F 15195    images/faces/face20.jpg
F 11141    images/faces/face11.jpg
F 10109    images/faces/face24.jpg
F 10862    images/faces/face5.jpg
F 15550    images/faces/face3.jpg
F 11746    images/faces/face9.jpg
F 12174    images/faces/face22.jpg
F 9283     images/faces/face18.jpg
F 13446    images/faces/face26.jpg
F 13908    images/faces/face15.jpg
F 12977    images/faces/face1.jpg
F 10063    images/faces/face12.jpg
F 9180     images/faces/face17.jpg
F 12222    images/faces/face6.jpg
F 13581    images/faces/face23.jpg
F 9317     images/faces/face16.jpg
F 13360    images/faces/face2.jpg
F 11393    images/faces/face14.jpg
F 1544     images/default.svg
D 4096     images/demo
F 461955   images/demo/boxed-layout.jpg
F 795940   images/demo/portfolio.jpg
F 552573   images/demo/toggle-overlay-menu.jpg
F 629615   images/demo/login.jpg
F 607597   images/demo/dark-sidebar.jpg
F 540698   images/demo/horizontal-menu-light.jpg
F 596499   images/demo/email.jpg
F 535827   images/demo/vertical-dark.jpg
F 573858   images/demo/icon-menu.jpg
F 578585   images/demo/compact-menu.jpg
F 520360   images/demo/pricing.jpg
F 483969   images/demo/horizontal-menu-dark.jpg
F 498334   images/demo/toggle-menu.jpg
F 627939   images/demo/fixed-menu.jpg
F 368027   images/demo/calendar.jpg
F 628053   images/demo/vertical-default.jpg
F 6675     images/logo.png
D 4096     images/lightbox
F 84329    images/lightbox/thumb-v-v-2.jpg
F 101969   images/lightbox/thumb-v-y-2.jpg
F 78634    images/lightbox/thumb-v-v-1.jpg
F 1754     images/lightbox/play-button.png
F 79637    images/lightbox/thumb-v-y-1.jpg
D 4096     images/carousel
F 50263    images/carousel/banner_12.jpg
F 108690   images/carousel/banner_11.jpg
F 182174   images/carousel/banner_1.jpg
F 339889   images/carousel/banner_9.jpg
F 111673   images/carousel/banner_5.jpg
F 128987   images/carousel/banner_8.jpg
F 88608    images/carousel/banner_3.jpg
F 82888    images/carousel/banner_2.jpg
F 77585    images/carousel/banner_7.jpg
F 229448   images/carousel/banner_4.jpg
F 89246    images/carousel/banner_6.jpg
F 140444   images/carousel/banner_10.jpg
D 4096     images/samples
D 4096     images/samples/1280x768
F 138707   images/samples/1280x768/5.jpg
F 95424    images/samples/1280x768/7.jpg
F 83895    images/samples/1280x768/3.jpg
F 297374   images/samples/1280x768/15.jpg
F 316673   images/samples/1280x768/1.jpg
F 215102   images/samples/1280x768/13.jpg
F 242422   images/samples/1280x768/11.jpg
F 139219   images/samples/1280x768/6.jpg
F 340860   images/samples/1280x768/4.jpg
F 230263   images/samples/1280x768/8.jpg
F 213507   images/samples/1280x768/14.jpg
F 102431   images/samples/1280x768/9.jpg
F 244193   images/samples/1280x768/12.jpg
F 95609    images/samples/1280x768/10.jpg
F 347801   images/samples/1280x768/2.jpg
D 4096     images/samples/300x300
F 24560    images/samples/300x300/5.jpg
F 17456    images/samples/300x300/7.jpg
F 14469    images/samples/300x300/3.jpg
F 33549    images/samples/300x300/15.jpg
F 41960    images/samples/300x300/1.jpg
F 85814    images/samples/300x300/13.jpg
F 36801    images/samples/300x300/11.jpg
F 22933    images/samples/300x300/6.jpg
F 44395    images/samples/300x300/4.jpg
F 30738    images/samples/300x300/8.jpg
F 27415    images/samples/300x300/14.jpg
F 21243    images/samples/300x300/9.jpg
F 28701    images/samples/300x300/12.jpg
F 18563    images/samples/300x300/10.jpg
F 43006    images/samples/300x300/2.jpg
F 6933     images/logo-dark.svg
F 710      images/favicon.png
D 4096     images/sprites
F 3044     images/sprites/blue.png
F 3104     images/sprites/dark.png
F 400      images/sprites/flag.png
F 3080     images/sprites/red.png
F 3040     images/sprites/yellow.png
F 2874     images/sprites/jsgrid-icons.png
F 3037     images/sprites/green.png
D 4096     images/file-icons
D 4096     images/file-icons/256
F 1735     images/file-icons/256/008-archive.png
F 2355     images/file-icons/256/006-record.png
F 1857     images/file-icons/256/002-tool.png
F 2342     images/file-icons/256/003-interface.png
F 7977     images/file-icons/256/005-database.png
F 3139     images/file-icons/256/007-folder.png
F 2975     images/file-icons/256/004-folder-1.png
F 3239     images/file-icons/256/001-interface-1.png
D 4096     images/file-icons/512
F 3369     images/file-icons/512/008-archive.png
F 5527     images/file-icons/512/006-record.png
F 3635     images/file-icons/512/002-tool.png
F 4507     images/file-icons/512/003-interface.png
F 17184    images/file-icons/512/005-database.png
F 6513     images/file-icons/512/007-folder.png
F 6778     images/file-icons/512/004-folder-1.png
F 7138     images/file-icons/512/001-interface-1.png
D 4096     images/file-icons/128
F 966      images/file-icons/128/008-archive.png
F 1448     images/file-icons/128/006-record.png
F 933      images/file-icons/128/002-tool.png
F 1420     images/file-icons/128/003-interface.png
F 4184     images/file-icons/128/005-database.png
F 1737     images/file-icons/128/007-folder.png
F 1654     images/file-icons/128/004-folder-1.png
F 1968     images/file-icons/128/001-interface-1.png
D 4096     images/file-icons/64
F 659      images/file-icons/64/008-archive.png
F 858      images/file-icons/64/006-record.png
F 581      images/file-icons/64/002-tool.png
F 862      images/file-icons/64/003-interface.png
F 2224     images/file-icons/64/005-database.png
F 1207     images/file-icons/64/007-folder.png
F 982      images/file-icons/64/004-folder-1.png
F 1193     images/file-icons/64/001-interface-1.png
D 4096     images/file-icons/flag
F 3409     images/file-icons/flag/flag.png
F 6883     images/logo.svg
F 4054     images/logo-mini.svg
D 4096     partials
F 6831     partials/_navbar.html
F 781      partials/_footer.html
F 5317     partials/_sidebar.html
F 8081     partials/_settings-panel.html
F 2092     home.php
F 4406     head.php
F 5396     adminpage-editdemoslot.php
F 10045    gulpfile.js
F 3598     register.php
F 4133     adminpage_prediksi.php
F 1932     minipgsoft.php
D 4096     vendors
D 4096     vendors/tinymce
F 1683599  vendors/tinymce/tinymce.jquery.min.js
F 2511     vendors/tinymce/readme.md
F 1683591  vendors/tinymce/tinymce.jquery.js
F 4274     vendors/tinymce/jquery.tinymce.js
F 1683512  vendors/tinymce/tinymce.js
D 4096     vendors/tinymce/themes
D 4096     vendors/tinymce/themes/inlite
F 55552    vendors/tinymce/themes/inlite/theme.js
F 17027    vendors/tinymce/themes/inlite/theme.min.js
F 198      vendors/tinymce/themes/inlite/index.js
D 4096     vendors/tinymce/themes/modern
F 44914    vendors/tinymce/themes/modern/theme.js
F 14360    vendors/tinymce/themes/modern/theme.min.js
F 198      vendors/tinymce/themes/modern/index.js
F 1061     vendors/tinymce/package.json
F 68532    vendors/tinymce/changelog.txt
D 4096     vendors/tinymce/plugins
D 4096     vendors/tinymce/plugins/table
F 141801   vendors/tinymce/plugins/table/plugin.js
F 199      vendors/tinymce/plugins/table/index.js
F 47683    vendors/tinymce/plugins/table/plugin.min.js
D 4096     vendors/tinymce/plugins/nonbreaking
F 4452     vendors/tinymce/plugins/nonbreaking/plugin.js
F 217      vendors/tinymce/plugins/nonbreaking/index.js
F 1530     vendors/tinymce/plugins/nonbreaking/plugin.min.js
D 4096     vendors/tinymce/plugins/lists
F 44817    vendors/tinymce/plugins/lists/plugin.js
F 199      vendors/tinymce/plugins/lists/index.js
F 14999    vendors/tinymce/plugins/lists/plugin.min.js
D 4096     vendors/tinymce/plugins/anchor
F 6131     vendors/tinymce/plugins/anchor/plugin.js
F 202      vendors/tinymce/plugins/anchor/index.js
F 2109     vendors/tinymce/plugins/anchor/plugin.min.js
D 4096     vendors/tinymce/plugins/save
F 6856     vendors/tinymce/plugins/save/plugin.js
F 196      vendors/tinymce/plugins/save/index.js
F 2201     vendors/tinymce/plugins/save/plugin.min.js
D 4096     vendors/tinymce/plugins/wordcount
F 23593    vendors/tinymce/plugins/wordcount/plugin.js
F 211      vendors/tinymce/plugins/wordcount/index.js
F 12126    vendors/tinymce/plugins/wordcount/plugin.min.js
D 4096     vendors/tinymce/plugins/textpattern
F 15806    vendors/tinymce/plugins/textpattern/plugin.js
F 217      vendors/tinymce/plugins/textpattern/index.js
F 4950     vendors/tinymce/plugins/textpattern/plugin.min.js
D 4096     vendors/tinymce/plugins/directionality
F 5223     vendors/tinymce/plugins/directionality/plugin.js
F 226      vendors/tinymce/plugins/directionality/index.js
F 1652     vendors/tinymce/plugins/directionality/plugin.min.js
D 4096     vendors/tinymce/plugins/charmap
F 18241    vendors/tinymce/plugins/charmap/plugin.js
F 205      vendors/tinymce/plugins/charmap/index.js
F 9163     vendors/tinymce/plugins/charmap/plugin.min.js
D 4096     vendors/tinymce/plugins/tabfocus
F 8323     vendors/tinymce/plugins/tabfocus/plugin.js
F 208      vendors/tinymce/plugins/tabfocus/index.js
F 2367     vendors/tinymce/plugins/tabfocus/plugin.min.js
D 4096     vendors/tinymce/plugins/visualblocks
F 5527     vendors/tinymce/plugins/visualblocks/plugin.js
D 4096     vendors/tinymce/plugins/visualblocks/css
F 5473     vendors/tinymce/plugins/visualblocks/css/visualblocks.css
F 220      vendors/tinymce/plugins/visualblocks/index.js
F 2028     vendors/tinymce/plugins/visualblocks/plugin.min.js
D 4096     vendors/tinymce/plugins/print
F 3719     vendors/tinymce/plugins/print/plugin.js
F 199      vendors/tinymce/plugins/print/index.js
F 1168     vendors/tinymce/plugins/print/plugin.min.js
D 4096     vendors/tinymce/plugins/codesample
F 42898    vendors/tinymce/plugins/codesample/plugin.js
...truncated

##### CHAT PHP SOURCES (<=40KB each) #####

== FILE /www/wwwroot/167.172.95.167/keluaranbwg77/chat/logout.php (98) ==
<?php 
session_start();

session_unset();
session_destroy();

header("Location: index.php");
exit;

== FILE /www/wwwroot/167.172.95.167/keluaranbwg77/chat/index.php (145) ==
<?php 
  session_start();

  if (!isset($_SESSION['username'])) {
	$_SESSION['username'] = session_id();
  }

  header("Location: chat.php");
 ?>

== FILE /www/wwwroot/167.172.95.167/keluaranbwg77/chat/app/ajax/search.php (1403) ==
<?php

session_start();

# check if the user is logged in
if (isset($_SESSION['username'])) {
    # check if the key is submitted
    if(isset($_POST['key'])){
       # database connection file
	   include '../db.conn.php';

	   # creating simple search algorithm :) 
	   $key = "%{$_POST['key']}%";
     
	   $sql = "SELECT * FROM users
	           WHERE username
	           LIKE ? OR name LIKE ?";
       $stmt = $conn->prepare($sql);
       $stmt->execute([$key, $key]);

       if($stmt->rowCount() > 0){ 
         $users = $stmt->fetchAll();

         foreach ($users as $user) {
         	if ($user['user_id'] == $_SESSION['user_id']) continue;
       ?>
       <li class="list-group-item">
		<a href="chat.php?user=<?=$user['username']?>"
		   class="d-flex
		          justify-content-between
		          align-items-center p-2">
			<div class="d-flex
			            align-items-center">

			    <img src="uploads/<?=$user['p_p']?>"
			         class="w-10 rounded-circle">

			    <h3 class="fs-xs m-2">
			    	<?=$user['name']?>
			    </h3>            	
			</div>
		 </a>
	   </li>
       <?php } }else { ?>
         <div class="alert alert-info 
    				 text-center">
		   <i class="fa fa-user-times d-block fs-big"></i>
           The user "<?=htmlspecialchars($_POST['key'])?>"
           is  not found.
		</div>
    <?php }
    }

}else {
	header("Location: ../../index.php");
	exit;
}

== FILE /www/wwwroot/167.172.95.167/keluaranbwg77/chat/app/ajax/getMessage.php (1941) ==
<?php 

session_start();



# check if the user is logged in
if (isset($_SESSION['username'])) {

	# database connection file
	include '../db.conn.php';

	$id_1  = $_SESSION['username'];
	$opend = 0;

	$sql = "SELECT * FROM chats ORDER BY created_at ASC";
	
	$stmt = $conn->prepare($sql);
	$stmt->execute();



	$totalMessage = $_SESSION['totalMessage'];
	echo "<script>console.log('$totalMessage');</script>";

	if ($stmt->rowCount() > 0) {
		
	    $chats = $stmt->fetchAll();

		$len = count($chats);
		// echo "<script>console.log('$len')</script>";

		
		// echo "<script>console.log('total message: $totalMessage - len: $len')</script>";
		

		if(!isset($_SESSION['totalMessage']) || $_SESSION['totalMessage'] != $len) {
			// echo "<script>console.log('masuk')</script>";

			$totalNew = count($chats);
			
			if(isset($_SESSION['totalMessage'])) {
				array_splice($chats, 0, $_SESSION['totalMessage']);	
			}

			$newLen = count($chats);
			$_SESSION['totalMessage'] = $totalNew;

	    # looping through the chats
	    foreach ($chats as $chat) {
			$msg = $chat['message'];

				if($chat['username'] != $_SESSION['username']){
	            ?>
					<div class="pt-2 px-3 border w-100"> 
							 <div class="row" style="flex-wrap: inherit;">
								 <div class="h-100 d-flex justify-content-center" style="width: 100px;">
										<img src="uploads/user-default.png" height="50px" width="50px" alt="Profile" style="border-radius: 8px">
								 </div>
								 <div class="col-10 p-0">
								 <p class="mb-0 w-100">
								<p class="text-secondary mb-0" style="font-weight: bold;">
								Anonymous
						 </p>
						    <p><?=$chat['message']?> </p>
   
								 </div>
							 </div>
	
							 <small class="d-block">
						    	<?=$chat['created_at']?>
						    </small>   
						</div>

							<script>scrollDown();</script>

	            		<?php
					}
				}
	    	}
	    }

 } else {
	 header('location: index.php');
 }



== FILE /www/wwwroot/167.172.95.167/keluaranbwg77/chat/app/ajax/insert.php (1365) ==
<?php 

session_start();

# check if the user is logged in
if (isset($_SESSION['username'])) {

	if (isset($_POST['message'])) {
	
	# database connection file
	include '../db.conn.php';

	# get data from XHR request and store them in var
	$message = $_POST['message'];

	# get the logged in user's username from the SESSION
	$from_id = $_SESSION['username'];

	$sql = "INSERT INTO 
	       chats (username, message) 
	       VALUES (?, ?)";
	$stmt = $conn->prepare($sql);
	$res  = $stmt->execute([$from_id, $message]);

	    // setting up the time Zone
		// It Depends on your location or your P.c settings
		define('TIMEZONE', 'Africa/Addis_Ababa');
		date_default_timezone_set(TIMEZONE);

		$time = date("Y-m-d h:i:s");

		?>
			<div class="pt-2 px-3 border w-100"> 
					<div class="row" style="flex-wrap: inherit;">
						<div class="h-100 d-flex justify-content-center" style="width: 100px;">
							<img src="uploads/user-default.png" height="50px" width="50px" alt="Profile" style="border-radius: 8px">
						</div>
						<div class="col-10 p-0">
						<p class="mb-0 w-100">
					<p class="text-primary mb-0" style="font-weight: bold;">
					Anonymous
				</p>
				<p><?=$message?> </p>

						</div>
					</div>

					<small class="d-block">
					<?=$time?>
				</small>   
			</div>


    <?php 

  }
}else {
	header("Location: ../../index.php");
	exit;
}

== FILE /www/wwwroot/167.172.95.167/keluaranbwg77/chat/app/ajax/update_last_seen.php (427) ==
<?php  

session_start();

# check if the user is logged in
if (isset($_SESSION['username'])) {
	
	# database connection file
	include '../db.conn.php';

	# get the logged in user's username from SESSION
	$id = $_SESSION['user_id'];

	$sql = "UPDATE users
	        SET last_seen = NOW() 
	        WHERE user_id = ?";
	$stmt = $conn->prepare($sql);
	$stmt->execute([$id]);

}else {
	header("Location: ../../index.php");
	exit;
}

== FILE /www/wwwroot/167.172.95.167/keluaranbwg77/chat/app/http/auth.php (2083) ==
<?php  
session_start();

# check if username & password  submitted
if(isset($_POST['username']) &&
   isset($_POST['password'])){

   # database connection file
   include '../db.conn.php';
   
   # get data from POST request and store them in var
   $password = $_POST['password'];
   $username = $_POST['username'];
   
   #simple form Validation
   if(empty($username)){
      # error message
      $em = "Username is required";

      # redirect to 'index.php' and passing error message
      header("Location: ../../index.php?error=$em");
   }else if(empty($password)){
      # error message
      $em = "Password is required";

      # redirect to 'index.php' and passing error message
      header("Location: ../../index.php?error=$em");
   }else {
      $sql  = "SELECT * FROM 
               users WHERE username=?";
      $stmt = $conn->prepare($sql);
      $stmt->execute([$username]);

      # if the username is exist
      if($stmt->rowCount() === 1){
        # fetching user data
        $user = $stmt->fetch();

        # if both username's are strictly equal
        if ($user['username'] === $username) {
           
           # verifying the encrypted password
          if (password_verify($password, $user['password'])) {

            # successfully logged in
            # creating the SESSION
            $_SESSION['username'] = $user['username'];
            $_SESSION['name'] = $user['name'];
            $_SESSION['user_id'] = $user['user_id'];

            # redirect to 'home.php'
            header("Location: ../../chat.php");

          }else {
            # error message
            $em = "Incorect Username or password";

            # redirect to 'index.php' and passing error message
            header("Location: ../../index.php?error=$em");
          }
        }else {
          # error message
          $em = "Incorect Username or password";

          # redirect to 'index.php' and passing error message
          header("Location: ../../index.php?error=$em");
        }
      }
   }
}else {
  header("Location: ../../index.php");
  exit;
}

== FILE /www/wwwroot/167.172.95.167/keluaranbwg77/chat/app/http/signup.php (3997) ==
<?php  

# check if username, password, name submitted
if(isset($_POST['username']) &&
   isset($_POST['password']) &&
   isset($_POST['name'])){

   # database connection file
   include '../db.conn.php';
   
   # get data from POST request and store them in var
   $name = $_POST['name'];
   $password = $_POST['password'];
   $username = $_POST['username'];

   # making URL data format
   $data = 'name='.$name.'&username='.$username;

   #simple form Validation
   if (empty($name)) {
   	  # error message
   	  $em = "Name is required";

   	  # redirect to 'signup.php' and passing error message
   	  header("Location: ../../signup.php?error=$em");
   	  exit;
   }else if(empty($username)){
      # error message
   	  $em = "Username is required";

   	  /*
    	redirect to 'signup.php' and 
    	passing error message and data
      */
   	  header("Location: ../../signup.php?error=$em&$data");
   	  exit;
   }else if(empty($password)){
   	  # error message
   	  $em = "Password is required";

   	  /*
    	redirect to 'signup.php' and 
    	passing error message and data
      */
   	  header("Location: ../../signup.php?error=$em&$data");
   	  exit;
   }else {
   	  # checking the database if the username is taken
   	  $sql = "SELECT username 
   	          FROM users
   	          WHERE username=?";
      $stmt = $conn->prepare($sql);
      $stmt->execute([$username]);

      if($stmt->rowCount() > 0){
      	$em = "The username ($username) is taken";
      	header("Location: ../../signup.php?error=$em&$data");
   	    exit;
      }else {
      	# Profile Picture Uploading
      	if (isset($_FILES['pp'])) {
      		# get data and store them in var
      		$img_name  = $_FILES['pp']['name'];
      		$tmp_name  = $_FILES['pp']['tmp_name'];
      		$error  = $_FILES['pp']['error'];

      		# if there is not error occurred while uploading
      		if($error === 0){
               
               # get image extension store it in var
      		   $img_ex = pathinfo($img_name, PATHINFO_EXTENSION);

               /** 
				convert the image extension into lower case 
				and store it in var 
				**/
				$img_ex_lc = strtolower($img_ex);

				/** 
				crating array that stores allowed
				to upload image extension.
				**/
				$allowed_exs = array("jpg", "jpeg", "png");

				/** 
				check if the the image extension 
				is present in $allowed_exs array
				**/
				if (in_array($img_ex_lc, $allowed_exs)) {
					/** 
					 renaming the image with user's username
					 like: username.$img_ex_lc
					**/
					$new_img_name = $username. '.'.$img_ex_lc;

					# crating upload path on root directory
					$img_upload_path = '../../uploads/'.$new_img_name;

					# move uploaded image to ./upload folder
                    move_uploaded_file($tmp_name, $img_upload_path);
				}else {
					$em = "You can't upload files of this type";
			      	header("Location: ../../signup.php?error=$em&$data");
			   	    exit;
				}

      		}
      	}

      	// password hashing
      	$password = password_hash($password, PASSWORD_DEFAULT);

      	# if the user upload Profile Picture
      	if (isset($new_img_name)) {

      		# inserting data into database
            $sql = "INSERT INTO users
                    (name, username, password, p_p)
                    VALUES (?,?,?,?)";
            $stmt = $conn->prepare($sql);
            $stmt->execute([$name, $username, $password, $new_img_name]);
      	}else {
            # inserting data into database
            $sql = "INSERT INTO users
                    (name, username, password)
                    VALUES (?,?,?)";
            $stmt = $conn->prepare($sql);
            $stmt->execute([$name, $username, $password]);
      	}

      	# success message
      	$sm = "Account created successfully";

      	# redirect to 'index.php' and passing success message
      	header("Location: ../../index.php?success=$sm");
     	exit;
      }

   }
}else {
	header("Location: ../../signup.php");
   	exit;
}

== FILE /www/wwwroot/167.172.95.167/keluaranbwg77/chat/app/helpers/opened.php (403) ==
<?php 

function opened($id_1, $conn, $chats){
    foreach ($chats as $chat) {
    	if ($chat['opened'] == 0) {
    		$opened = 1;
    		$chat_id = $chat['chat_id'];

    		$sql = "UPDATE chats
    		        SET   opened = ?
    		        WHERE from_id=? 
    		        AND   chat_id = ?";
            $stmt = $conn->prepare($sql);
            $stmt->execute([$opened, $id_1, $chat_id]);

    	}
    }
}

== FILE /www/wwwroot/167.172.95.167/keluaranbwg77/chat/app/helpers/conversations.php (1435) ==
<?php 

function getConversation($user_id, $conn){
    /**
      Getting all the conversations 
      for current (logged in) user
    **/
    $sql = "SELECT * FROM conversations
            WHERE user_1=? OR user_2=?
            ORDER BY conversation_id DESC";

    $stmt = $conn->prepare($sql);
    $stmt->execute([$user_id, $user_id]);

    if($stmt->rowCount() > 0){
        $conversations = $stmt->fetchAll();

        /**
          creating empty array to 
          store the user conversation
        **/
        $user_data = [];
        
        # looping through the conversations
        foreach($conversations as $conversation){
            # if conversations user_1 row equal to user_id
            if ($conversation['user_1'] == $user_id) {
            	$sql2  = "SELECT *
            	          FROM users WHERE user_id=?";
            	$stmt2 = $conn->prepare($sql2);
            	$stmt2->execute([$conversation['user_2']]);
            }else {
            	$sql2  = "SELECT *
            	          FROM users WHERE user_id=?";
            	$stmt2 = $conn->prepare($sql2);
            	$stmt2->execute([$conversation['user_1']]);
            }

            $allConversations = $stmt2->fetchAll();

            # pushing the data into the array 
            array_push($user_data, $allConversations[0]);
        }

        return $user_data;

    }else {
    	$conversations = [];
    	return $conversations;
    }  

}

== FILE /www/wwwroot/167.172.95.167/keluaranbwg77/chat/app/helpers/timeAgo.php (736) ==
<?php

// setting up the time Zone
// It Depends on your location or your P.c settings
define('TIMEZONE', 'Africa/Addis_Ababa');
date_default_timezone_set(TIMEZONE);

function last_seen($date_time){

   $timestamp = strtotime($date_time);	
   
   $strTime = array("second", "minute", "hour", "day", "month", "year");
   $length = array("60","60","24","30","12","10");

   $currentTime = time();
   if($currentTime >= $timestamp) {
		$diff     = time()- $timestamp;
		for($i = 0; $diff >= $length[$i] && $i < count($length)-1; $i++) {
		$diff = $diff / $length[$i];
		}

		$diff = round($diff);
		if ($diff < 59 && $strTime[$i] == "second") {
			return 'Active';
		}else {
			return $diff . " " . $strTime[$i] . "(s) ago ";
		}
		
   }
}

== FILE /www/wwwroot/167.172.95.167/keluaranbwg77/chat/app/helpers/chat.php (307) ==
<?php 

function getChats($id_1, $id_2, $conn){
   
   $sql = "SELECT * FROM chats ORDER BY chat_id ASC";
    $stmt = $conn->prepare($sql);
    $stmt->execute();

    if ($stmt->rowCount() > 0) {
    	$chats = $stmt->fetchAll();
    	return $chats;
    }else {
    	$chats = [];
    	return $chats;
    }

}

== FILE /www/wwwroot/167.172.95.167/keluaranbwg77/chat/app/helpers/user.php (306) ==
<?php  

function getUser($username, $conn){
   $sql = "SELECT * FROM users 
           WHERE username=?";
   $stmt = $conn->prepare($sql);
   $stmt->execute([$username]);

   if ($stmt->rowCount() === 1) {
   	 $user = $stmt->fetch();
   	 return $user;
   }else {
   	$user = [];
   	return $user;
   }
}

== FILE /www/wwwroot/167.172.95.167/keluaranbwg77/chat/app/helpers/last_chat.php (441) ==
<?php 

function lastChat($id_1, $id_2, $conn){
   
   $sql = "SELECT * FROM chats
           WHERE (from_id=? AND to_id=?)
           OR    (to_id=? AND from_id=?)
           ORDER BY chat_id DESC LIMIT 1";
    $stmt = $conn->prepare($sql);
    $stmt->execute([$id_1, $id_2, $id_1, $id_2]);

    if ($stmt->rowCount() > 0) {
    	$chat = $stmt->fetch();
    	return $chat['message'];
    }else {
    	$chat = '';
    	return $chat;
    }

}

== FILE /www/wwwroot/167.172.95.167/keluaranbwg77/chat/app/db.conn.php (456) ==
<?php 

# server name
$sName = "localhost";
$uName = "makelar";
$pass = "!Rd%(6.r";
$db_name = "chat";

/* 
$uName = "rendy_test";
$pass = "Eternal12**";
$db_name = "rendy_chat"; */

#creating database connection
try {
    $conn = new PDO("mysql:host=$sName;dbname=$db_name", 
                    $uName, $pass);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}catch(PDOException $e){
  echo "Connection failed : ". $e->getMessage();
}

== FILE /www/wwwroot/167.172.95.167/keluaranbwg77/chat/chat03March2022.txt (50) ==
<span>null</span>ghjfdghj'
<span>null</span>gkjhg


== FILE /www/wwwroot/167.172.95.167/keluaranbwg77/chat/signup.php (2569) ==
<?php 
  session_start();

  if (!isset($_SESSION['username'])) {
?>

<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<title>Chat App - Sign Up</title>
	<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.1/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-+0n0xVW2eSR5OomGNYDnhzAbDsOXxcvSN1TPprVMTNDbiYZCxYbOOl7+AMvyTG2x" crossorigin="anonymous">
	<link rel="stylesheet" 
	      href="css/style.css">
	<link rel="icon" href="img/logo.png">
</head>
<body class="d-flex
             justify-content-center
             align-items-center
             vh-100">
	 <div class="w-400 p-5 shadow rounded">
	 	<form method="post" 
	 	      action="app/http/signup.php"
	 	      enctype="multipart/form-data">
	 		<div class="d-flex
	 		            justify-content-center
	 		            align-items-center
	 		            flex-column">

	 		<img src="img/logo.png" 
	 		     class="w-25">
	 		<h3 class="display-4 fs-1 
	 		           text-center">
	 			       Sign Up</h3>   
	 		</div>

	 		<?php if (isset($_GET['error'])) { ?>
	 		<div class="alert alert-warning" role="alert">
			  <?php echo htmlspecialchars($_GET['error']);?>
			</div>
			<?php } 
              
              if (isset($_GET['name'])) {
              	$name = $_GET['name'];
              }else $name = '';

              if (isset($_GET['username'])) {
              	$username = $_GET['username'];
              }else $username = '';
			?>

	 	  <div class="mb-3">
		    <label class="form-label">
		           Name</label>
		    <input type="text"
		           name="name"
		           value="<?=$name?>" 
		           class="form-control">
		  </div>

		  <div class="mb-3">
		    <label class="form-label">
		           User name</label>
		    <input type="text" 
		           class="form-control"
		           value="<?=$username?>" 
		           name="username">
		  </div>


		  <div class="mb-3">
		    <label class="form-label">
		           Password</label>
		    <input type="password" 
		           class="form-control"
		           name="password">
		  </div>

		  <div class="mb-3">
		    <label class="form-label">
		           Profile Picture</label>
		    <input type="file" 
		           class="form-control"
		           name="pp">
		  </div>
		  
		  <button type="submit" 
		          class="btn btn-primary">
		          Sign Up</button>
		  <a href="index.php">Login</a>
		</form>
	 </div>
</body>
</html>
<?php
  }else{
  	header("Location: chat.php");
   	exit;
  }
 ?>

== FILE /www/wwwroot/167.172.95.167/keluaranbwg77/chat/chat.php (6101) ==
<?php 
  session_start();

  if (isset($_SESSION['username'])) {
  	# database connection file
  	include 'app/db.conn.php';

  	include 'app/helpers/user.php';
  	include 'app/helpers/chat.php';


  	include 'app/helpers/timeAgo.php';

  	if (!isset($_GET['user'])) {
		$_GET['user'] = 'public';

  		// header("Location: home.php");
  		// exit;
  	}

  	# Getting User data data
  	$chatWith = getUser($_GET['user'], $conn);

  	// if (empty($chatWith)) {
  	// 	header("Location: home.php");
  	// 	exit;
  	// }

  	$chats = getChats($_SESSION['username'], $chatWith['username'], $conn);

?>
<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<title>Chat App</title>
	<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.1/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-+0n0xVW2eSR5OomGNYDnhzAbDsOXxcvSN1TPprVMTNDbiYZCxYbOOl7+AMvyTG2x" crossorigin="anonymous">
	<link rel="stylesheet" 
	      href="css/style.css">
	<link rel="icon" href="img/logo.png">
	<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
</head>
<body onload="scrollDown();" class="d-flex

             h-100">
    <div class="w-400 shadow rounded">
    	<!-- <a href="home.php"
    	   class="fs-4 link-dark">&#8592;</a> -->


    	   <div class="d-flex align-items-center bg-primary px-2 py-3 shadow">
               <h3 class="display-4 fs-sm m-2" style="font-weight: bold; color: white">
			   Makelar303
               	  <div class="d-flex
               	              align-items-center"
               	        title="online">

               	  </div>
               </h3>
    	   </div>

    	   <div class="shadow rounded
    	               d-flex flex-column
    	               chat-box"
    	        id="chatBox">
    	        <?php 
                     if (!empty($chats)) {
                     foreach($chats as $chat){
                     	if($chat['username'] == $_SESSION['username'])
                     	{ ?>
						 <div class="pt-2 px-3 border w-100"> 
							 <div class="row" style="flex-wrap: inherit;">
								 <div class="h-100 d-flex justify-content-center" style="width: 100px;">
										<img src="uploads/user-default.png" height="50px" width="50px" alt="Profile" style="border-radius: 8px">
								 </div>
								 <div class="col-10 p-0">
								 <p class="mb-0 w-100">
								<p class="text-primary mb-0" style="font-weight: bold;">
								Anonymous
						 </p>
						    <p><?=$chat['message']?> </p>
   
								 </div>
							 </div>
	
							 <small class="d-block">
						    	<?=$chat['created_at']?>
						    </small>   
						</div>
                    <?php }else{ ?>
						<div class="pt-2 px-3 border w-100"> 
							 <div class="row" style="flex-wrap: inherit;">
								 <div class="h-100 d-flex justify-content-center" style="width: 100px;">
										<img src="uploads/user-default.png" height="50px" width="50px" alt="Profile" style="border-radius: 8px">
								 </div>
								 <div class="col-10 p-0">
								 <p class="mb-0 w-100">
								<p class="text-secondary mb-0" style="font-weight: bold;">
								Anonymous
						 </p>
						    <p><?=$chat['message']?> </p>
   
								 </div>
							 </div>
	
							 <small class="d-block">
						    	<?=$chat['created_at']?>
						    </small>   
						</div>
                    <?php } 
                     }	
    	        }else{ ?>
               <div class="alert alert-info 
    				            text-center">
				   <i class="fa fa-comments d-block fs-big"></i>
	               No messages yet, Start the conversation
			   </div>
    	   	<?php } ?>
    	   </div>
					

    	   <div class="input-group align-self-end">
    	   	   <textarea 
				placeholder="Silahkan masukan pesan anda ^^"
				  cols="3"
    	   	             id="message"
    	   	             class="form-control"></textarea>
    	   	   <button class="btn btn-primary"
    	   	           id="sendBtn" style="border-radius: 0px;">
    	   	   	  <i class="fa fa-paper-plane"></i>
    	   	   </button>
    	   </div>

    </div>
 

 <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>

<script>
	var scrollDown = function(){
        let chatBox = document.getElementById('chatBox');
        chatBox.scrollTop = chatBox.scrollHeight;

		console.log("scrolldown");
	}
	

	$('#message').keydown(function (e){
		if(e.keyCode == 13){
			send();
		}
	});

	function send() {
		message = $("#message").val();
      	if (message == "") return;

      	$.post("app/ajax/insert.php",
      		   {
      		   	message: message,
      		   },
      		   function(data, status){
                  $("#message").val("");
                  $("#chatBox").append(data);
                  scrollDown();
      		   });

		scrollDown();
	}

	// Execute a function when the user releases a key on the keyboard


	$(document).ready(function(){
	

      $("#sendBtn").on('click', function(){
		send();
      });

      /** 
      auto update last seen 
      for logged in user
      **/
      let lastSeenUpdate = function(){
      	$.get("app/ajax/update_last_seen.php");
      }
      lastSeenUpdate();
      /** 
      auto update last seen 
      every 10 sec
      **/
      setInterval(lastSeenUpdate, 10000);



      // auto refresh / reload
      let fechData = function(){
      	$.post("app/ajax/getMessage.php", 
      		   {},
      		   function(data, status){
                  $("#chatBox").append(data);
                //   if (data != "") scrollDown();
      		    });
      }

      fechData();
      /** 
      auto update last seen 
      every 0.5 sec
      **/
      setInterval(fechData, 500);
    
    });
</script>
 </body>
 </html>
<?php
  }else{
  	header("Location: index.php");
   	exit;
  }
 ?>

##### GREP keluaranbwg77 for bridge keywords #####
bridge_hits=0
##### END #####