Untitled



String url = pageContext.getServletContext().getInitParameter("url");//"jdbc:mysql://localhost:3306/";
String driver = "com.mysql.jdbc.Driver";
String db = pageContext.getServletContext().getInitParameter("db");
String user = pageContext.getServletContext().getInitParameter("user");
String password = pageContext.getServletContext().getInitParameter("password");
String fullurl = url+db+"?useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8";
String rootURL = pageContext.getServletContext().getInitParameter("rootURL");
Connection con = null;
String dbB = pageContext.getServletContext().getInitParameter("dbb");
String fullurlB = url+dbB+"?useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8";

Connection conB = null;
try {
    Class.forName(driver).newInstance();
    con = DriverManager.getConnection(fullurl, user, password);
    conB = DriverManager.getConnection(fullurlB, user, password);
    request.setAttribute("ConB", conB);

    request.setAttribute("Con", con);

    if(request.getParameter("createnewarcade")!=null){
        String name = request.getParameter("name");
        String address = request.getParameter("address");
        ArcadeWriter.write(con,name, address, url, driver, db, user, password);
    }

    %>
    <style type="text/css" media="all">@IMPORT url("css/adminlayout.css");</style>
    <!--Header --><jsp:include page="adminsrc/header.jsp" />
    <script>
    function showLoading(){
        $("#loading").hide();
    }
    </script>
</head>
<body onLoad="showLoading();">
    <div class="hideonprint">
    <div id="loading" style="width: 100%;position: fixed;height: 100%;background-color: rgba(0,0,0,0.5); z-index: 999;">Prosím vyčkejte, strana se načítá</div>

    <%
    if (session.getAttribute("nicknameAX")!=null){
        %>

        <div class="mainMenu">
            <div class="b brb at_top bpos"><a href="?page=customers&customers=open&customersall=open">Hráči</a><span></span></div>
            <div class="b brb at_top bpos"><a href="?page=arcades&arcades=open">Herny</a><span></span></div>
            <div class="b brb at_top bpos"><a href="?page=users&users=open">Uživatelé</a><span></span></div>
            <div class="b brb at_top bpos"><a href="?page=checknote&newchecknote=open">Poznámky info panelu</a><span></span></div>
            <div class="b brb at_top bpos"><a href="?page=stop&stop=open">STOP</a><span></span></div>
            <div class="b brb at_top bpos"><a href="?page=competition&competition=open">Soutěž</a><span></span></div>
            <div class="b brb at_top bpos"><a href="?page=bonuscard-find&bcfind=open">Vyhledání štístka</a><span></span></div>
            <!--
            <div class="b brb at_top bpos"><a href="?page=customer-registration&customerRegistration=open">Registrace</a><span></span></div>
            <div class="b brb at_top bpos"><a href="?page=limitprice&limitprice=open">Hotovost za štístka</a><span></span></div>
            <div class="b brb at_top bpos"><a href="?page=limitlotteryDay&limitLotteryday=open">Šťastný den</a><span></span></div>
             -->
            <%if((Integer)session.getAttribute("permissionAX")==0){ %>
                <div class="b brb at_top bpos"><a href="?page=stats&stats=open">Statistiky</a><span></span></div>
                <div class="b brb at_top bpos"><a href="?page=aabb&acceptedandborrowedbonusses=open">Sestavy</a><span></span></div>
                <div class="b brb at_top bpos"><a href="?page=smsp&smspayouts=open">SMS Sestavy</a><span></span></div>
            <%}else{ %>

            <%} %>
            <div class="b brb at_top bpos"><a href="?page=smscompetition&smscompetition=open">SMS Soutěž</a><span></span></div>
            <div class="b brb at_top bpos"><a href="?page=smsgateway&smsgateway=open">SMS Brána</a><span></span></div>
            <div class="b brb at_top bpos"><a href="?page=items&items=open">Položky</a><span></span></div>
            <div class="b brb at_top bpos"><a href="?page=bugs&reviewbug=open">Poruchy</a><span></span></div>
            <div style="position: absolute;right: 0px;"><div class="b  brb at_top bpos"><a href="?logout=logout">Odhlášení</a><span></span></div></div>
        </div>
        <%
        if("items".equals(request.getParameter("page"))){
            %>
            <div class="subMenu">
                <div class="b brb at_top bpos"><a href="?page=items&newitem=add">Přidat nové zboží</a><span></span></div>
            </div>
            <%
        }
        %>
        <!-- <div class="subMenu">

        </div> -->
        </div>
        <div class="wrapper">
            <div class="content">
                <div class="hideonprint">

                <!--BUGS --><jsp:include page="src/rightpanel/bugs/main.jsp" />
                <!--PICKUPS--><jsp:include page="adminsrc/admin/arcades/pickup.jsp" />
                <!--SMS Customer SEND Core--><jsp:include page="adminsrc/admin/arcades/smspayouts.jsp" />
                <!--SMS Customer SEND Core--><jsp:include page="adminsrc/admin/customerSMSSend/core.jsp" />
                <!--SMS Competition CUSTOMER ADD[CHECK--><jsp:include page="adminsrc/admin/smscompetition/smscompetitionuseraddcore.jsp" />
                <!--SMS Competition ADD--><jsp:include page="adminsrc/admin/smscompetition/smscompetitionadd.jsp" />

                <!--INCOME BONUS REVIEW--><jsp:include page="adminsrc/admin/incomeBonus.jsp" />
                <!--ITEMS--><jsp:include page="adminsrc/admin/sales/item.jsp" />
                <!--MENUS--><jsp:include page="adminsrc/admin/sales/menu.jsp" />
                <!--SMS GATEWAY--><jsp:include page="adminsrc/admin/smsgateway.jsp" />
                <!--STATS--><jsp:include page="adminsrc/admin/stats.jsp" />
                <!--STOP--><jsp:include page="src/rightpanel/stop/stop.jsp" />
                    <!--STOP DETAIL--><jsp:include page="src/rightpanel/stop/stopDetail.jsp" />
                <!-- CUSTOMER REGISTRATION --><jsp:include page="src/customerRegistration.jsp" />
                <!-- CUSTOMER REGISTRATION OK--><jsp:include page="src/customerRegistrationOK.jsp" />
                <!--ARCADE TOP --><jsp:include page="adminsrc/admin/arcades/top.jsp" />
                <!--BONUSCARD FIND --><jsp:include page="adminsrc/admin/bonuscard/find.jsp" />
                <!--SHIFTS --><jsp:include page="src/rightpanel/bar/shifts/allShifts.jsp" />
                    <!--SHIFT DETAIL--><jsp:include page="src/rightpanel/bar/shifts/shiftDetail.jsp" />
                <!--COMPETITION MENU ETC.--><jsp:include page="adminsrc/admin/competition/competition.jsp" />
                    <!--COMPETITION DETAIL--><jsp:include page="adminsrc/admin/competition/competitionAll.jsp" />
                <!--FILE UPLOAD--><jsp:include page="adminsrc/admin/fileup.jsp" />
                <!--STOP --><jsp:include page="adminsrc/admin/stop.jsp" />
                <!--CHECKNOTES ARCADE--><jsp:include page="adminsrc/admin/checknotes/arcadeChecknote.jsp" />
                <!--CHECKNOTES USERS--><jsp:include page="adminsrc/admin/checknotes/userChecknote.jsp" />
                <!--USERS --><jsp:include page="adminsrc/users.jsp" />
                <!--CUSTOMERS --><jsp:include page="adminsrc/customers.jsp" />
                    <!--CUSTOMER FIND--><jsp:include page="src/rightpanel/bar/customerFind.jsp" />
                <!--SETUP LIMIT FOR PRICE FOR BONUS--><jsp:include page="adminsrc/admin/limitprice/setup.jsp" />
                <!--SETUP LIMITS FOR LoteryDay--><jsp:include page="adminsrc/admin/lotteryDayLimits/setup.jsp" />
                <!--ARCADES --><jsp:include page="adminsrc/arcades.jsp" />
                    <!--ARCADE EDIT --><jsp:include page="adminsrc/admin/arcades/edit.jsp" />
                    <!--ARCADE NOTES LIST--><jsp:include page="src/rightpanel/bar/notes/notesList.jsp" />
                    <!--ARCADE TIME RESET--><jsp:include page="adminsrc/admin/arcades/timereset.jsp" />

                </div>

                    <!--BONUS REVIEW--><jsp:include page="adminsrc/admin/arcades/bonuses.jsp" />

            </div>
        </div>


        <%
    }else{
        %>
            <form  autocomplete='off' method="post" action="admin.jsp">
                <div class="loginWindowN">
                    <div class="loginHeadN oswald" >
                        PŘIHLÁŠENÍ DO SYSTÉMU
                    </div>
                    <div class="loginMiddleN">
                    Uživatelské jméno:
                    <input type="text" name="username" value="" class='inputTextN'/>
                    Heslo:
                    <input type="password" name="password"  value="" class='inputTextN'/>
                    </div>
                    <div class="loginBottomN">
                        Registrační systém herních středisek.
                        <input type="submit" name="login" value="Přihlásit" class='loginButtonN oswald'/>

                    </div>
                </div>
                <div class="loginShadowN"></div>
            </form>
            <!--
            <div class='window1 center'>
                <form  autocomplete='off' method="post" action="index.jsp">

                    Heslo:
                    <input type="password" name="password" value="" class='inputText2'/>

                    <input type="submit" name="login" value="Přihlásit" class='buttonMainForm center'/>
                </form>
            </div>
             -->
            <%

    }
} catch (Exception e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
}finally {
    if (con != null) {
        try{
           con.close();
        }catch (SQLException e) { /*ignored*/ }
    }
    if (conB != null) {
        try{
           conB.close();
        }catch (SQLException e) { /*ignored*/ }
    }
}