Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var msg_area = $('.msg_area');
- msg_area.scrollTop(msg_area.prop("scrollHeight"));
- $('#send_rep').submit(function (e) {
- e.preventDefault();
- var $form = $(this), url = $form.attr('action');
- var posting = $.post(url, {rep_msg: $('#rep_msg').val(), hash: $('#hash').val()});
- posting.done(function (data) {
- alert('success');
- });
- });
- require_once ("db.php");
- $db = new MyDB();
- session_start();
- if (isset($_POST['rep_msg']) && !empty($_POST['rep_msg']) || isset($_POST['hash']) && !empty($_POST['hash']))
- {
- $hash = (int)$_GET['hash'];
- $my_id = $_SESSION['log_id'];
- $rep_msg = $_POST['rep_msg'];
- $hash = $_POST['hash'];
- $rsql = <<<EOF
- INSERT INTO messager (message, group_hash, from_id) VALUES('$rep_msg', '$hash', '$my_id');
- EOF;
- $rret = $db->exec($rsql);
- $ursql = <<<EOF
- SELECT * FROM User WHERE ID = '$my_id';
- EOF;
- $urret = $db->query($ursql);
- while ($urrow = $urret->fetchArray(SQLITE3_ASSOC)) {
- $from_fname = $urrow['fname'];
- $from_img = $urrow['image'];
- header('Location: user_msg.php?hash=' . $hash);
- }
- }
- require_once ("db.php");
- $db = new MyDB();
- session_start();
- if (isset($_GET['hash']) && !empty($_GET['hash']))
- {
- $hash = (int)$_GET['hash'];
- $us_id = $_SESSION['log_id'];
- $mesql =<<<EOF
- SELECT from_id, message FROM messager WHERE group_hash = '$hash';
- EOF;
- $meret = $db->query($mesql);
- while ($merow = $meret->fetchArray(SQLITE3_ASSOC))
- {
- $from_id = $merow['from_id'];
- $messages = $merow['message'];
- $usql =<<<EOF
- SELECT * FROM User WHERE ID = '$from_id';
- EOF;
- $uret = $db->query($usql);
- while ($urow = $uret->fetchArray(SQLITE3_ASSOC)) {
- $from_fname = $urow['fname'];
- $from_img = $urow['image'];
- if ($from_id != $_SESSION['log_id']) {
- echo "
- <div class='from_bubble'><div class='from_img'><img src='$from_img'></div><div class='from_txt'><p>$messages</p></div></div>";
- } else {
- echo "
- <div class='rep_bubble'><div class='rep_img'><img src='$from_img'></div><div class='rep_txt'><p>$messages</p></div></div>";
- }
- }
- echo "<input style='display: none' type='text' class='hash' name='hash' value='$hash' id='hash'>";
- }
- }
- setInterval(function() {
- $('.msg_area').load("get_msg.php");
- }, 2000);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement