SQLSTATE[HY000] [1045] Access denied for user 'zambosur_viljimz_root'@'localhost' (using password: YES) : Error
<link rel="apple-touch-icon" sizes="76x76" href="assets/img/vj-icon.png?1">
<link rel="icon" type="image/png" href="assets/img/vj-icon.png?123" />
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
<meta content='width=device-width, initial-scale=1.0, shrink-to-fit=no' name='viewport' />

<link rel="stylesheet" type="text/css" href="assets/demo/material.css" />
<!--<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/latest/css/font-awesome.min.css"> --!-->
<link rel="stylesheet" type="text/css" href="assets/css/font-awesome.min.css" />

<link href="assets/css/material-dashboard.css?v=2.1.2" rel="stylesheet" />

<!--<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-select@1.13.14/dist/css/bootstrap-select.min.css">--!-->
<link rel="stylesheet" href="assets/css/bootstrap-select.min.css">

<!--<script src="https://cdn.jsdelivr.net/npm/bootstrap-select@1.13.14/dist/js/bootstrap-select.min.js"></script>--!-->
<script src="assets/js/bootstrap-select.min.js"></script>

<!--<script src="https://cdn.jsdelivr.net/npm/bootstrap-select@1.13.14/dist/js/i18n/defaults-*.min.js"></script>--!-->


<table id='tab-loading' style='display:none;position:fixed;top:0;left:0;width:100%;height:100%;background:rgba(0,0,0,.8);z-index:99999999999999;' >
	<td valign='center' align='center' >
		<img ondblclick=" location=''; " src='assets/img/loading.gif' class="blinking" style='background:#000; height:50px; width:50px; padding:5px; border-radius:50px; box-shadow:0 0 50px red; border:1px solid red;' />
	</td>
</table>

<script>
    function showLoading(){
		$("#tab-loading").show();
	}
	
	function doneLoading(){
		$("#tab-loading").fadeOut();
	}

  function dataUpdater(table, target_field, target_id, update_field, new_value){
      var url="ajax-data-insert.php?table="+table+"&target_field="+target_field+"&target_id="+target_id+"&update_field="+update_field+"&new_value="+new_value;
      $.ajax({
        url: url,
        context: document.body
      }).done(function(e){
        if(e!=""){
          swal.fire("Error Occured",e,"warning");
        } 
      });
  }

  function SQL(query){
    var url="ajax-data-insert.php?query="+query;
      $.ajax({
        url: url,
        context: document.body
      }).done(function(e){
        if(e!=""){
          return false;
        }else{
          return true;
        }
      });
  }

  function readCookie(name) {
      var nameEQ = name + "=";
      var ca = document.cookie.split(';');
      for(var i=0;i < ca.length;i++) {
          var c = ca[i];
          while (c.charAt(0)==' ') c = c.substring(1,c.length);
          if (c.indexOf(nameEQ) == 0) return c.substring(nameEQ.length,c.length);
      }
      return null;
  }


  function logMeOut(){
    swal.fire({
      title: "Confirm Logout?",
      text: "Do you wish to log-out?",
      icon: "question",
      showCancelButton: true,
      confirmButtonText: 'Yes'
    }).then((result) => {
      if (result.isConfirmed) {
        location="logout";
      }
    });
  }

  function showNotification(from, align, msg, color) {
    $.notify({
      icon: "add_alert",
      message: msg

    }, {
      type: color,
      timer: 1,
      placement: {
        from: from,
        align: align
      }
   });
  }


  

</script>



<style>

    body{background:#fff;}

    .bg-grayed{

        background-color:#eee;

    }

    .bg-white{

        background-color:#fff;

    }



    .text-bold, .text-bold td, .text-bold th{

        font-weight:bold;

    }

    .text-black{

        color:#000;

    }

    .clearfix{ clear:both }



    .blinking{

		animation: blinker 1s linear infinite;

	} 

	@keyframes blinker {

	  50% {

		opacity: .3;

	  }

	}

	.pointer{cursor:pointer;}

  .disabled *{color:#aaa}

  .hover:hover{color:blue !important; font-weight:bold;}



  

  

  .modal-body-custom{

      height: 80vh;

      overflow-y: auto;

  } 



  svg.ct-chart-bar, svg.ct-chart-line{

    overflow: visible;

  }

  .ct-label.ct-label.ct-horizontal.ct-end {

    position: relative;

    justify-content: flex-end;

    text-align: right;

    transform-origin: 100% 0;

    transform: translate(-100%) rotate(-90deg);

    white-space:nowrap;

  }



  .sold-out{

    margin-right:5px;

    padding:3px;

    padding-right:3px;

    width:60px;

    text-align:center;

    float:left;

    border-radius:100px;

    font-weight:bold;

  }





/***** for customized select */



.button-with-dropdown{

  cursor: pointer;

}



.dropdown-content {

  display: none;

  position: absolute;

  background-color: #f6f6f6;

  min-width: 230px;

  overflow: auto;

  border: 1px solid #ddd;

  z-index: 1;

}



.dropdown-content a {

  color: black;

  padding: 12px 16px;

  text-decoration: none;

  display: block;

  background-color: #fefefe;

  border-bottom:1px solid #eee;

}



.dropdown-content a:hover {background-color: #ddd;}



.show {display: block;}



.form-control{

  cursor:pointer;

}



/***** for customized select */









.void{

  opacity:.4;

  background:url('assets/img/void-2.png') center center no-repeat;

  background-size:70%;

}



.agent-tally-button{

  opacity:.4;

}



.agent-tally-button:hover, .agent-tally-button:active{

  opacity:1;

}





.my-numbers{

  margin:5px;

  border:0;

  border-radius:100px;

  padding-left:17px;

  padding-right:17px;

}

.my-numbers:active{

  background:#000 !important;

  color:#fff !important;

}



.td-pl-3 td{

  padding-left:10px;

} 

.td-pr-3 td{

  padding-right:10px;

}





</style>









<style>

    .form-wrapper-outer{

        padding: 40px;

        border-radius: 8px;

        margin: auto;

        width: 460px;

        border: 1px solid #DADCE0;

        margin-top: 7%;

    }



    .form-wrapper-outer .form-logo{

        margin: 0px auto 15px;

        width: 100px;

    }



    .form-wrapper-outer .form-logo img{

        width: 100%;

    }



    .form-greeting{

        text-align: center;

        font-size: 25px;

        margin-bottom: 15px;

    }



    .form-button{

        text-align: right;

    }



    .field-wrapper{

        position: relative;

        margin-bottom: 15px;

    }



    .field-wrapper input{

        border: 1px solid #DADCE0;

        padding: 15px;

        border-radius: 4px;

        width: 100%;

    }



    .field-wrapper .field-placeholder{

        font-size: 16px;

        position: absolute;

        /* background: #fff; */

        bottom: 17px;

        -webkit-box-sizing: border-box;

        box-sizing: border-box;

        color: #80868b;

        left: 8px;

        padding: 0 8px;

        -webkit-transition: transform 150ms cubic-bezier(0.4,0,0.2,1),opacity 150ms cubic-bezier(0.4,0,0.2,1);

        transition: transform 150ms cubic-bezier(0.4,0,0.2,1),opacity 150ms cubic-bezier(0.4,0,0.2,1);

        z-index: 1;



        text-align: left;

        width: 100%;

    }        

    

    .field-wrapper .field-placeholder span{

        background: #ffffff;

        padding: 0px 8px;

    }



    .field-wrapper input:not([disabled]):focus~.field-placeholder

    {

        color:#1A73E8;

    }



    .field-wrapper input:not([disabled]):focus~.field-placeholder,

    .field-wrapper.hasValue input:not([disabled])~.field-placeholder

    {

        -webkit-transform: scale(.75) translateY(-39px) translateX(-60px);

        transform: scale(.75) translateY(-39px) translateX(-60px);

        

    }



    .hover{ opacity:.5; }

    .hover:hover{ opacity:1; }

    



    @media (min-width: 768px) {

      .modal-xl {

        width: 95%;

        max-width:1200px; 

      }

    }



    .doe{

      font-size:10px;

    }



    @page {

        size: auto;

    }



    .close:hover{

        transform: rotate(90deg);

    }

    .close{ transition:transform .5s; }

    .money{text-align:right}





    /* Chrome, Safari, Edge, Opera */

    input::-webkit-outer-spin-button,

    input::-webkit-inner-spin-button {

      -webkit-appearance: none;

      margin: 0;

    }



    /* Firefox */

    input[type=number] {

      -moz-appearance: textfield;

    }



    .active_tr td{

      background:#343a40; color:#fff;

    }

    

    .listbox option:nth-child(even){

      background-color: #ebebeb;

    }

    .tr-no-padding td{
      padding:0 !important;
    }

</style>



<div hidden id='div_hidden' ></div>  

<html lang="en">

<head>

    <title>Administrative Login : Vil-Jimz Marketing </title>  

</head>

<body style="background:#3d3d3d"> 

    <div class="wrapper ">

        <table width=100% height=100%>

            <td width=100% height=100% align=center valign=center style="_background:rgba(0,0,0,.7);">

                <div class="col-lg-3 col-sm-10 col=sm-12">

                    <div class="card">

                        <div class="card-body table-responsive">

                            <div class="row">

                                <div class='col p-4'>

                                    <center><img src="assets/img/logo-2.png" width=80 /></center>

                                    <p>

                                        <h3><strong>Administrative Login</strong></h3>

                                        <hr>

                                    </p>

                                    <br>

                                    <form method=post onsubmit="event.preventDefault(); logMeIn();">

                                    <input type=text class='form-control mb-4' placeholder='User Name' required id="tUserName" />

                                        <input type=password class='form-control mb-5' placeholder='Password' required id="tPassWord" />

                                        

                                        <button class='btn btn-success col h4'><span class='material-icons' style="font-size:30px;" >vpn_key</span> &nbsp; Log-In</button>

                                    </form>

                                </div>

                            </div>

                        </div>

                    </div>

                </div>

            </td> 

        </table>

    </div>



    <div hidden id='div_hidden' ></div>

    <!--   Core JS Files   -->

<script src="assets/js/core/jquery.min.js"></script>

<script src="assets/js/core/popper.min.js"></script>

<script src="assets/js/core/bootstrap-material-design.min.js"></script>

<script src="assets/js/plugins/perfect-scrollbar.jquery.min.js"></script>

<!-- Plugin for the momentJs  -->

<script src="assets/js/plugins/moment.min.js"></script>

<!--  Plugin for Sweet Alert -->

<!--<script src="assets/js/plugins/sweetalert2.js"></script>-->

<script src="//cdn.jsdelivr.net/npm/sweetalert2@10"></script>

<!-- Forms Validations Plugin -->

<script src="assets/js/plugins/jquery.validate.min.js"></script>

<!-- Plugin for the Wizard, full documentation here: https://github.com/VinceG/twitter-bootstrap-wizard -->

<script src="assets/js/plugins/jquery.bootstrap-wizard.js"></script>

<!--	Plugin for Select, full documentation here: http://silviomoreto.github.io/bootstrap-select -->

<script src="assets/js/plugins/bootstrap-selectpicker.js"></script>

<!--  Plugin for the DateTimePicker, full documentation here: https://eonasdan.github.io/bootstrap-datetimepicker/ -->

<script src="assets/js/plugins/bootstrap-datetimepicker.min.js"></script>

<!--  DataTables.net Plugin, full documentation here: https://datatables.net/  -->

<script src="assets/js/plugins/jquery.dataTables.min.js"></script>

<!--	Plugin for Tags, full documentation here: https://github.com/bootstrap-tagsinput/bootstrap-tagsinputs  -->

<script src="assets/js/plugins/bootstrap-tagsinput.js"></script>

<!-- Plugin for Fileupload, full documentation here: http://www.jasny.net/bootstrap/javascript/#fileinput -->

<script src="assets/js/plugins/jasny-bootstrap.min.js"></script>

<!--  Full Calendar Plugin, full documentation here: https://github.com/fullcalendar/fullcalendar    -->

<script src="assets/js/plugins/fullcalendar.min.js"></script>

<!-- Vector Map plugin, full documentation here: http://jvectormap.com/documentation/ -->

<script src="assets/js/plugins/jquery-jvectormap.js"></script>

<!--  Plugin for the Sliders, full documentation here: http://refreshless.com/nouislider/ -->

<script src="assets/js/plugins/nouislider.min.js"></script>

<!-- Include a polyfill for ES6 Promises (optional) for IE11, UC Browser and Android browser support SweetAlert -->

<script src="https://cdnjs.cloudflare.com/ajax/libs/core-js/2.4.1/core.js"></script>

<!-- Library for adding dinamically elements -->

<script src="assets/js/plugins/arrive.min.js"></script>

<!--  Google Maps Plugin    -->

<script src="https://maps.googleapis.com/maps/api/js?key=YOUR_KEY_HERE"></script>

<!-- Chartist JS -->

<script src="assets/js/plugins/chartist.min.js"></script>

<!--  Notifications Plugin    -->

<script src="assets/js/plugins/bootstrap-notify.js"></script>

<!-- Control Center for Material Dashboard: parallax effects, scripts for the example pages etc -->

<script src="assets/js/material-dashboard.js?v=2.1.2" type="text/javascript"></script>



<div class="spinner-grow text-warning"></div>





<script>

    

    $(document).ready(function() {

        var page = "index";

        $("a[href='" + page + "']").parent().addClass("active");

    });



    //********FOR CUSTOMIZED SELECT */

    $(".dropdown-content a").click(function() {

        $('.dropdown-content').toggle();

        $(".button-with-dropdown").html($(this).html());

    });



    $(".button-with-dropdown").click(function() {

        $('.dropdown-content').toggle();

    });

    //********FOR CUSTOMIZED SELECT */

</script>



<script>

    $(document).ready(function() {

        $().ready(function() {

            $sidebar = $('.sidebar');



            $sidebar_img_container = $sidebar.find('.sidebar-background');



            $full_page = $('.full-page');



            $sidebar_responsive = $('body > .navbar-collapse');



            window_width = $(window).width();



            fixed_plugin_open = $('.sidebar .sidebar-wrapper .nav li.active a p').html();



            if (window_width > 767 && fixed_plugin_open == 'Dashboard') {

                if ($('.fixed-plugin .dropdown').hasClass('show-dropdown')) {

                    $('.fixed-plugin .dropdown').addClass('open');

                }



            }



            $('.fixed-plugin a').click(function(event) {

                // Alex if we click on switch, stop propagation of the event, so the dropdown will not be hide, otherwise we set the  section active

                if ($(this).hasClass('switch-trigger')) {

                    if (event.stopPropagation) {

                        event.stopPropagation();

                    } else if (window.event) {

                        window.event.cancelBubble = true;

                    }

                }

            });



            $('.fixed-plugin .active-color span').click(function() {

                $full_page_background = $('.full-page-background');



                $(this).siblings().removeClass('active');

                $(this).addClass('active');



                var new_color = $(this).data('color');



                if ($sidebar.length != 0) {

                    $sidebar.attr('data-color', new_color);

                }



                if ($full_page.length != 0) {

                    $full_page.attr('filter-color', new_color);

                }



                if ($sidebar_responsive.length != 0) {

                    $sidebar_responsive.attr('data-color', new_color);

                }

            });



            $('.fixed-plugin .background-color .badge').click(function() {

                $(this).siblings().removeClass('active');

                $(this).addClass('active');



                var new_color = $(this).data('background-color');



                if ($sidebar.length != 0) {

                    $sidebar.attr('data-background-color', new_color);

                }

            });



            $('.fixed-plugin .img-holder').click(function() {

                $full_page_background = $('.full-page-background');



                $(this).parent('li').siblings().removeClass('active');

                $(this).parent('li').addClass('active');





                var new_image = $(this).find("img").attr('src');



                if ($sidebar_img_container.length != 0 && $('.switch-sidebar-image input:checked').length != 0) {

                    $sidebar_img_container.fadeOut('fast', function() {

                        $sidebar_img_container.css('background-image', 'url("' + new_image + '")');

                        $sidebar_img_container.fadeIn('fast');

                    });

                }



                if ($full_page_background.length != 0 && $('.switch-sidebar-image input:checked').length != 0) {

                    var new_image_full_page = $('.fixed-plugin li.active .img-holder').find('img').data('src');



                    $full_page_background.fadeOut('fast', function() {

                        $full_page_background.css('background-image', 'url("' + new_image_full_page + '")');

                        $full_page_background.fadeIn('fast');

                    });

                }



                if ($('.switch-sidebar-image input:checked').length == 0) {

                    var new_image = $('.fixed-plugin li.active .img-holder').find("img").attr('src');

                    var new_image_full_page = $('.fixed-plugin li.active .img-holder').find('img').data('src');



                    $sidebar_img_container.css('background-image', 'url("' + new_image + '")');

                    $full_page_background.css('background-image', 'url("' + new_image_full_page + '")');

                }



                if ($sidebar_responsive.length != 0) {

                    $sidebar_responsive.css('background-image', 'url("' + new_image + '")');

                }

            });



            $('.switch-sidebar-image input').change(function() {

                $full_page_background = $('.full-page-background');



                $input = $(this);



                if ($input.is(':checked')) {

                    if ($sidebar_img_container.length != 0) {

                        $sidebar_img_container.fadeIn('fast');

                        $sidebar.attr('data-image', '#');

                    }



                    if ($full_page_background.length != 0) {

                        $full_page_background.fadeIn('fast');

                        $full_page.attr('data-image', '#');

                    }



                    background_image = true;

                } else {

                    if ($sidebar_img_container.length != 0) {

                        $sidebar.removeAttr('data-image');

                        $sidebar_img_container.fadeOut('fast');

                    }



                    if ($full_page_background.length != 0) {

                        $full_page.removeAttr('data-image', '#');

                        $full_page_background.fadeOut('fast');

                    }



                    background_image = false;

                }

            });



            $('.switch-sidebar-mini input').change(function() {

                $body = $('body');



                $input = $(this);



                if (md.misc.sidebar_mini_active == true) {

                    $('body').removeClass('sidebar-mini');

                    md.misc.sidebar_mini_active = false;



                    $('.sidebar .sidebar-wrapper, .main-panel').perfectScrollbar();



                } else {



                    $('.sidebar .sidebar-wrapper, .main-panel').perfectScrollbar('destroy');



                    setTimeout(function() {

                        $('body').addClass('sidebar-mini');



                        md.misc.sidebar_mini_active = true;

                    }, 300);

                }



                // we simulate the window Resize so the charts will get updated in realtime.

                var simulateWindowResize = setInterval(function() {

                    window.dispatchEvent(new Event('resize'));

                }, 180);



                // we stop the simulation of Window Resize after the animations are completed

                setTimeout(function() {

                    clearInterval(simulateWindowResize);

                }, 1000);



            });

        });

    });



    function underConstruction() {

        swal.fire('Progress Ongoing!', 'I am still working on this', 'info');

    }





    var table = table = $("#table").DataTable();



    function refreshTableData(id) {

        table.destroy();

        setTimeout(function() {

            table = $("#" + id).DataTable({

                dom: 'Bfrtip',

                buttons: [{

                    extend: 'print',

                    text: 'Print',

                    autoPrint: true,

                    searching: true,

                    scrollX: true,

                    exportOptions: {

                        columns: ':visible',

                    },

                    customize: function(win) {

                        //$(win.document.body).find('table').addClass('display').css('font-size', '9px');

                        $(win.document.body).find('tr:nth-child(odd) td').each(function(index) {

                            $(this).css('background-color', '#D0D0D0');

                        });

                        $(win.document.body).find('h1').css('text-align', 'center');

                    }

                }]

            });

        }, 2000);

    }



    function refreshTableDataNoControl(id) {

        $("#" + id).DataTable().destroy();

        setTimeout(function() {

            table = $("#" + id).DataTable({

                "lengthChange": false,

                "info": false,

                pageLength: 5,

            });

        }, 1000);

    }

</script>



<div class="modal fade" id="divClaim" tabindex="-1" role="dialog" aria-labelledby="divUserModalLabel" aria-hidden="true">

    <div class="modal-dialog modal-dialog-centered modal-md" role="document">

        <div class="modal-content">

            <div class="modal-header">

                <b>Choose A Draw Date</b>

                <button type="button" class="close" data-dismiss="modal" aria-label="Close">

                    <span aria-hidden="true">&times;</span>

                </button>

            </div>

            <div class="modal-body">

                <form method=post onsubmit="event.preventDefault(); getWinningTickets();">

                    <div id="divAgentDrawContainer_">

                        <div id="divAgentDrawContent_">

                            
                            <label>Ticket Number (Leave Empty To Show All):</label>

                            <input type=number id='tTicketNumber' class='form-control' />

                        </div>

                    </div>



                    <button class="btn btn-primary col-md-12 mt-4" id='bSearchWinningTickets'><span class='material-icons'>search</span> Search</button>

                </form>

            </div>

        </div>

    </div>

</div>







<script>

    $(function() {

        $(".field-wrapper .field-placeholder").on("click", function() {

            $(this).closest(".field-wrapper").find("input").focus();

        });

        $(".field-wrapper input").on("keyup", function() {

            var value = $.trim($(this).val());

            if (value) {

                $(this).closest(".field-wrapper").addClass("hasValue");

            } else {

                $(this).closest(".field-wrapper").removeClass("hasValue");

            }

        });

    });





    function clearFields() {

        $('.clearable').val('');



        $('#target-area').html('');

        $('#target-area').val('');

    }



    function DeleteItem(table, target, id, tr) {

        swal.fire({

            title: "Confirm Deletion",

            text: "Delete this info?",

            icon: "question",

            showCancelButton: true,

            confirmButtonText: 'Yes'

        }).then((result) => {

            if (result.isConfirmed) {

                SQL("update " + table + " set status=0 where " + target + "=" + id);

                $('#' + tr + id).remove();

                $('.' + tr + id).remove();

            }

        });

    }



    function DeleteItemForever(table, target, id, tr) {

        swal.fire({

            title: "Confirm Deletion",

            text: "Delete this info?",

            icon: "question",

            showCancelButton: true,

            confirmButtonText: 'Yes'

        }).then((result) => {

            if (result.isConfirmed) {

                SQL("delete from " + table + " where " + target + "=" + id);

                $('#' + tr + id).remove();

                $('.' + tr + id).remove();

            }

        });

    }







    function logMeIn() {

        showLoading();

        $.ajax({

            url: "ajax/log-in.php?username=" + $("#tUserName").val() + "&password=" + $("#tPassWord").val(),

            context: document.body

        }).done(function(e) {

            if (!e.includes("<script>")) {

                doneLoading();

                showNotification('top', 'center', e, 'danger');

                $("#tPassWord").val('');

                $("#tPassWord").focus();

            } else {

                $('#div_hidden').html(e);

                setTimeout(() => {

                    location = "";

                }, 1500);

            }

        });

    }





    $(".close").click(function() {

        clearFields();

    });

    $("button[data-dismiss='modal']").click(function() {

        clearFields();

    });









    var mouseY = 0;

    var startMouseY = 0;

    $('body').on('mousedown', function(ev) {

        mouseY = ev.pageY;

        startMouseY = mouseY;

        $(document).mousemove(function(e) {

            if (e.pageY > mouseY) {

                var d = e.pageY - startMouseY;

                console.log("d: " + d);

                if (d >= 200)

                    location.reload();

                $('body').css('margin-top', d / 4 + 'px');

            } else

                $(document).unbind("mousemove");





        });

    });

    $('body').on('mouseup', function() {

        $('body').css('margin-top', '0px');

        $(document).unbind("mousemove");

    });

    $('body').on('mouseleave', function() {

        $('body').css('margin-top', '0px');

        $(document).unbind("mousemove");

    });

</script>
</body>

</html>



<script>

    function logMeIn(){

        showLoading();

        var url="ajax-log-in.php?username="+$("#tUserName").val()+"&password="+$("#tPassWord").val();

        $.ajax({

          url: url,

          context: document.body

        }).done(function(e){

            if(e.includes("Mismatched")){

                doneLoading();

                showNotification('top','center',e,'danger');

                $("#tPassWord").val('');

                $("#tPassWord").focus();

            }else{

                $('#div_hidden').html(e);

                setTimeout(() => {

                    location="dashboard";

                }, 1500);

            }

        });

    }

</script>