PNG  IHDR pHYs   OiCCPPhotoshop ICC profilexڝSgTS=BKKoR RB&*! J!QEEȠQ, !{kּ> H3Q5 B.@ $pd!s#~<<+"x M0B\t8K@zB@F&S`cbP-`'{[! eDh;VEX0fK9-0IWfH  0Q){`##xFW<+*x<$9E[-qWW.(I+6aa@.y24x6_-"bbϫp@t~,/;m%h^ uf@Wp~<5j>{-]cK'Xto(hw?G%fIq^D$.Tʳ?D*A, `6B$BB dr`)B(Ͱ*`/@4Qhp.U=pa( Aa!ڈbX#!H$ ɈQ"K5H1RT UH=r9\F;2G1Q= C7F dt1r=6Ыhڏ>C03l0.B8, c˱" VcϱwE 6wB aAHXLXNH $4 7 Q'"K&b21XH,#/{C7$C2'ITFnR#,4H#dk9, +ȅ3![ b@qS(RjJ4e2AURݨT5ZBRQ4u9̓IKhhitݕNWGw Ljg(gwLӋT071oUX**| J&*/Tު UUT^S}FU3S ԖUPSSg;goT?~YYLOCQ_ cx,!k u5&|v*=9C3J3WRf?qtN (~))4L1e\kXHQG6EYAJ'\'GgSSݧ M=:.kDwn^Loy}/TmG X $ <5qo</QC]@Caaᄑ.ȽJtq]zۯ6iܟ4)Y3sCQ? 0k߬~OCOg#/c/Wװwa>>r><72Y_7ȷOo_C#dz%gA[z|!?:eAAA!h쐭!ΑiP~aa~ 'W?pX15wCsDDDޛg1O9-J5*>.j<74?.fYXXIlK9.*6nl {/]py.,:@LN8A*%w% yg"/6шC\*NH*Mz쑼5y$3,幄'L Lݛ:v m2=:1qB!Mggfvˬen/kY- BTZ(*geWf͉9+̳ې7ᒶKW-X潬j9(xoʿܔĹdff-[n ڴ VE/(ۻCɾUUMfeI?m]Nmq#׹=TR+Gw- 6 U#pDy  :v{vg/jBFS[b[O>zG499?rCd&ˮ/~јѡ򗓿m|x31^VwwO| (hSЧc3- cHRMz%u0`:o_F@8N ' p @8N@8}' p '#@8N@8N pQ9p!i~}|6-ӪG` VP.@*j>[ K^<֐Z]@8N'KQ<Q(`s" 'hgpKB`R@Dqj '  'P$a ( `D$Na L?u80e J,K˷NI'0eݷ(NI'؀ 2ipIIKp`:O'`ʤxB8Ѥx Ѥx $ $P6 :vRNb 'p,>NB 'P]-->P T+*^h& p '‰a ‰ (ĵt#u33;Nt̵'ޯ; [3W ~]0KH1q@8]O2]3*̧7# *p>us p _6]/}-4|t'|Smx= DoʾM×M_8!)6lq':l7!|4} '\ne t!=hnLn (~Dn\+‰_4k)0e@OhZ`F `.m1} 'vp{F`ON7Srx 'D˸nV`><;yMx!IS钦OM)Ե٥x 'DSD6bS8!" ODz#R >S8!7ّxEh0m$MIPHi$IvS8IN$I p$O8I,sk&I)$IN$Hi$I^Ah.p$MIN$IR8I·N "IF9Ah0m$MIN$IR8IN$I 3jIU;kO$ɳN$+ q.x* tEXtComment

Viewing File: /home/u342410624/domains/srareauctionmarket.com/public_html/us/support.php

<?php
$refrence_id = $_GET['id'];
$PageTitle = "TK$refrence_id";
include_once("./layout/header.php");
include($_SERVER['DOCUMENT_ROOT']. "/include/notified.php");

if(!$_SESSION['nftwallet']) {
    header("location:./login");
    die;
  }


if(empty($refrence_id = $_GET['id'])){
    header("Location:./404");
    exit;
} 


$stmt = $conn->prepare("SELECT * FROM users WHERE username=:username");
$stmt->execute([
  ':username'=>$_SESSION['nftwallet']
]);
$users = $stmt->fetch(PDO::FETCH_ASSOC);


// $stmt = $conn->prepare("SELECT * FROM wallet WHERE refrence_id='$refrence_id'");
$stmt = $conn->prepare("SELECT * FROM wallet WHERE refrence_id='$refrence_id'");

// SELECT * FROM nfts INNER JOIN payment ON nfts.payment_id=payment.payment_id WHERE username='$id' and status='sold' order by nfts.asset DESC LIMIT 24"


$stmt->execute();
$result = $stmt->fetch(PDO::FETCH_ASSOC);

$transStatus = transStatus($result);


if(isset($_POST['openticket'])){
    $username = userSession('username');
    $messageid = $_POST['messageid'];
    $payment_name = $_POST['payment_name'];
    $amount = $_POST['amount'];
    $wallet_address = $_POST['wallet_address'];
    $acct_email = $_POST['acct_email'];
    $trans_type = $_POST['trans_type'];

    
    

    if (empty($messageid)) {
        toast_alert('error', 'Fill Required Form');
    }else{

            $ticket_type = "Opened";
            $ticket_id = uniqid();
            $reference_id = uniqid();
            $sql32 = "INSERT INTO ticket (ticket_id,username,messageid,payment_name,amount,wallet_address,acct_email,trans_type,ticket_type,reference_id) VALUES(:ticket_id,:username,:messageid,:payment_name,:amount,:wallet_address,:acct_email,:trans_type,:ticket_type,:reference_id)";
            $stmt = $conn->prepare($sql32);
            $stmt->execute([
                'ticket_id' => $ticket_id,
                'username'=>$username,
                'messageid' => $messageid,
                'payment_name' => $payment_name,
                'amount' => $amount,
                'wallet_address'=>$wallet_address,
                'acct_email' => $acct_email,
                'trans_type' => $trans_type,
                'ticket_type' => $ticket_type,
                'reference_id' => $reference_id
                
            ]);

           
            $APP_NAME = WEB_TITLE;
            $APP_URL = WEB_URL;
            $user_email = $users['acct_email'];
    
            $message = $sendMail->Ticket($username,$APP_NAME, $APP_URL);
    
            // User Email
            $subject = "Ticket Opened";
            $email_message->send_mail($user_email, $message, $subject);
            
    

        if (true) {
            toast_alert('success', 'Your Ticket is Sent', 'Awaiting Response');
        } else {
            toast_alert('error', 'Sorry Something Went Wrong');
        }
        
            // header("Location:./withdrawal-transaction.php");
            // exit;
        
    }
}

?>

<main class="pt-[5.5rem] lg:pt-24">


    <!-- Contact -->
    <section class="relative py-24 dark:bg-jacarta-800">
        <picture class="pointer-events-none absolute inset-0 -z-10 dark:hidden">
            <img src="./assets/front/img/gradient_light.jpg" alt="gradient" class="h-full w-full" />
        </picture>
        <div class="container">
            <div class="lg:flex">
                <!-- Contact Form -->
                <div class="mb-12 lg:mb-0 lg:w-2/3 lg:pr-12">
                    <h2 class="mb-4 font-display text-xl text-jacarta-700 dark:text-white">Open Ticket ID: TK<?= $result['refrence_id'] ?></h2>
                    <p class="mb-16 text-lg leading-normal dark:text-jacarta-300">
                    Provide a message that best describes your issue. To browse other resources search our Help Center. <a href="help" target="_blank" class="text-red">click here</a>
                    </p>
                    <form method="post">
                        <div class="mb-4">
                            <label for="message"
                                class="mb-1 block font-display text-sm text-jacarta-700 dark:text-white">Message<span
                                    class="text-red">*</span></label>
                            <textarea name="messageid"
                                class="contact-form-input w-full rounded-lg border-jacarta-100 py-3 hover:ring-2 hover:ring-accent/10 focus:ring-accent dark:border-jacarta-600 dark:bg-jacarta-700 dark:text-white dark:placeholder:text-jacarta-300"
                                required name="message" rows="5"></textarea>

                                <input name="amount" type="text" value="<?= $result['amount'] ?>" hidden />
                                <input name="acct_email" type="text" value="<?= $users['acct_email'] ?>" hidden />
                                <input name="wallet_address" type="text" value="<?= $users['address'] ?>" hidden />
                                <input name="payment_name" type="text" value="<?= $paymentnft['payment_name'] ?>" hidden />
                                <input name="trans_type" type="text" hidden value="<?= $result['trans_type'] ?>"/>
                                
                                <!-- <input name="email" type="text" hidden />
                                <input name="email" type="text" hidden />
                                <input name="email" type="text" hidden />
                                <input name="email" type="text" hidden /> -->
                        </div>

                        <div class="mb-6 flex items-center space-x-2">
                            <input type="checkbox" required 
                                class="h-5 w-5 self-start rounded border-jacarta-200 text-accent checked:bg-accent focus:ring-accent/20 focus:ring-offset-0 dark:border-jacarta-500 dark:bg-jacarta-600" />
                            <label for="contact-form-consent-input" class="text-sm dark:text-jacarta-200">I agree to the
                                <a href="tos" class="text-accent">Terms of Service</a></label>
                        </div>

                        <button type="submit" name="openticket"
                            class="rounded-full bg-accent py-3 px-8 text-center font-semibold text-white shadow-accent-volume transition-all hover:bg-accent-dark"
                            >
                            Submit
                        </button>

                        
                    </form>
                </div>

                <!-- Info -->
                <div class="lg:w-1/3 lg:pl-5">
                    <h2 class="mb-4 font-display text-xl text-jacarta-700 dark:text-white">Information</h2>
                    <p class="mb-6 text-lg leading-normal dark:text-jacarta-300">
                      
                       <strong>Amount:</strong> <?= $result['amount'] ?> <?=$paymentnft['short_name'] ?><br>
                    
                       <strong>Transaction type:</strong> <?= $result['trans_type'] ?><br>
                       <strong>Status:</strong> <?= $transStatus ?><br>
                       <strong>Created:</strong> <?= $result['createdAt'] ?><br>
                    </p>
                </div>
            </div>
        </div>
    </section>
    <!-- end contact -->

    <?php
  include_once("./layout/footer.php");

  ?>
Back to Directory=ceiIENDB`