<?php
                    if(isset($_POST['saves']))
                        {
                            $name = htmlspecialchars($_POST['name']);
                            $logo = htmlspecialchars($_POST['logo']);
                            $web = htmlspecialchars($_POST['web']);
                            $message = htmlspecialchars($_POST['message']);
                            $message2 = htmlspecialchars($_POST['message']);
                            $message3 = htmlspecialchars($_POST['message']);
                            $email = htmlspecialchars($_POST['email']);
                            $skype = htmlspecialchars($_POST['skype']);
                            $phone = htmlspecialchars($_POST['phone']);
                            $username = $_POST['username'];
                            $password = $_POST['password'];
                            $ip = $_POST['ip'];
                            $port = $_POST['port'];
                            $db->query("UPDATE u_settings SET title=:name, name=:name, logo=:logo, web=:web, p_message=:message, p_message2=:message2, p_message3=:message3, email=:email, skype=:skype, phone=:phone,  WHERE vpsid=:vpsid");
                            $db->bind(":name", $name);
                            $db->bind(":logo", $logo);
                            $db->bind(":web", $web);
                            $db->bind(":message", $message);
                            $db->bind(":message2", $message);
                            $db->bind(":message3", $message);
                            $db->bind(":email", $email);
                            $db->bind(":skype", $skype);
                            $db->bind(":phone", $phone);
                            $db->bind(":vpsid", $_SESSION['vps_id']);
                            $db->execute();
                            $db->query("UPDATE vps SET ip=:ip, username=:user, password=:pass, port=:port  WHERE id=:vpsid");
                            $db->bind(":name", $name);
                            $db->bind(":logo", $logo);
                            $db->bind(":web", $web);
                            $db->bind(":message", $message);
                            $db->bind(":message2", $message);
                            $db->bind(":message3", $message);
                            $db->bind(":email", $email);
                            $db->bind(":skype", $skype);
                            $db->bind(":phone", $phone);
                            $db->bind(":username", $username);
                            $db->bind(":password", $password);
                            $db->bind(":ip", $ip);
                            $db->bind(":port", $port);
                            $db->bind(":vpsid", $_SESSION['vps_id']);
                            $db->execute();
                            echo '<script>alert("נשמרו הגדרות חברה");</script>';
                            $page = 'index.php?act=settings';
                            echo '<script>window.location.href="'.$page.'"; </script>';
                        }
                ?>
                <div class="textstart"><span>הגדרות חברה: <?= $usettings->name ?></span></div>
                <div class="vpstext">
                    <div class="form-group">
                        <label for="message-text" class="control-label">שם החברה:</label>
                        <input type="text" name="name" class="form-settings" value="<?= $usettings->name;?>"/>
                    </div>
                    <div class="form-group">
                        <label for="message-text" class="control-label">לוגו החברה:</label>
                        <input type="text" name="logo" class="form-settings" value="<?= $usettings->logo;?>"/>
                    </div>
                    <div class="form-group">
                        <label for="message-text" class="control-label">כתובת האתר:</label>
                        <input type="text" name="web" class="form-settings" value="<?= $usettings->web;?>"/>
                    </div>
                    <div class="form-group">
                        <label for="message-text" class="control-label">הודעה (1):</label>
                        <input type="text" name="message" class="form-settings" value="<?= $usettings->message;?>"/>
                    </div>
                    <div class="form-group">
                        <label for="message-text" class="control-label">הודעה (2):</label>
                        <input type="text" name="message2" class="form-settings" value="<?= $usettings->message2;?>"/>
                    </div>
                    <div class="form-group">
                        <label for="message-text" class="control-label">הודעה (3):</label>
                        <input type="text" name="message3" class="form-settings" value="<?= $usettings->message3;?>"/>
                    </div>
                    <div class="form-group">
                        <label for="message-text" class="control-label">איימיל:</label>
                        <input type="text" name="email" class="form-settings" value="<?= $usettings->email;?>"/>
                    </div>
                    <div class="form-group">
                        <label for="message-text" class="control-label">סקייפ:</label>
                        <input type="text" name="skype" class="form-settings" value="<?= $usettings->skype;?>"/>
                    </div>
                    <div class="form-group">
                        <label for="message-text" class="control-label">פלאפון:</label>
                        <input type="text" name="phone" class="form-settings" value="<?= $usettings->phone;?>"/>
                    </div>
                    <div class="form-group">
                        <label for="message-text" class="control-label">מחיר סלוט שרת משחק:</label>
                        <input type="number" name="gameslot" class="form-settings" min="0" value="<?= $usettings->slot;?>"/>
                    </div>
                    <div class="form-group">
                        <label for="message-text" class="control-label">מחיר סלוט שרת דיבור:</label>
                        <input type="number" name="voiceslot" class="form-settings" min="0" value="<?= $usettings->vslot;?>"/>
                    </div>
                    <hr/>
                    <div class="textstart"><span>פרטי השרת: <?= $vps->hostname ?></span></div>
                    <div class="form-group">
                        <label for="message-text" class="control-label">אייפי השרת המאחסן (VPS):</label>
                        <input type="text" name="vpsip" class="form-settings" value="<?= $vps->ip;?>"/>
                    </div>
                    <div class="form-group">
                        <label for="message-text" class="control-label">משתמש רוט (Root):</label>
                        <input type="text" name="vpsuser" class="form-settings" value="<?= $vps->user;?>"/>
                    </div>
                    <div class="form-group">
                        <label for="message-text" class="control-label">סיסמאת הרוט (Root):</label>
                        <input type="text" name="vpsuser" class="form-settings" value=""/>
                    </div>
                    <div class="form-group">
                        <label for="message-text" class="control-label">חיבור (Port):</label>
                        <input type="number" name="vpsport" class="form-settings" min="10" value="<?= $vps->port;?>"/>
                    </div>
                    <input type="submit" name="saves" onclick="return confirm('האם ברצונך לשמור שינויים אלו?')" class="btn btn-primary" value="שמור"/>
                </div>
            </div>
        </div>