RevCMS applications page [HELP]

[Joshie]

How do I make one of these?
Staff Application page

 

[Decellor]

@Joshia

You must be registered for see links

and run this query in your database

DROP TABLE IF EXISTS `staffapps`;CREATE TABLE `staffapps` (
  `AppID` int(11) NOT NULL AUTO_INCREMENT,
  `RealName` varchar(75) NOT NULL,
  `UserName` varchar(75) DEFAULT NULL,
  `Age` int(2) DEFAULT NULL,
  `Timezone` varchar(10) DEFAULT NULL,
  `Experience` longtext,
  `Why` longtext,
  `What` longtext,
  `TimeStamp` int(11) DEFAULT NULL,
  `IP` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`AppID`)

) ENGINE=InnoDB AUTO_INCREMENT=685 DEFAULT CHARSET=utf8;

Make sure you edit db.php and index.php

 

[Joshie]

Where exactly do these go in the skin?

 

[Decellor]

its not too hard to figure out surely ://

 

[iGlenn]

or if u have a google account use google docs to make your staff apps form then make a tab on your hotel to link to it, i think this is much easier. you don't even have to use google docs just search on google "application form creator" or something. here is one you can use? jotform.com

 

[Janzeer]

Lmfao, the code @liam5062 gave is supposed to be executed in the database. You have to code out the page yourself and link it with the database, however if you want to be spoon-fed look for revcms staff application page on google.

 

[n4te]

I'll code one for you , so you don't have to go through the troubles of setting up whatever the fuck that is above. Just shoot me a PM.

 

[Joe]

I have the page from an old CMS, not sure whether this helps or not.

Spoiler: apps.php

<div id="container">
            <div id="content" style="position: relative" class="clearfix">
                <div class="alert alert-success" style="margin-bottom: 6px;width:730px;">
<strong>Are you the one?</strong> {hotelname} is looking for new t-mod's be sure to apply!
</div>
<div id="column1" class="column">
<div class="habblet-container " style="float:left; width: 460px;">
<div class="cbb clearfix red ">
<h2 class="title"><span style="float: left;">Staff Applications</span></h2>
<div style="padding: 5px" align="left">

<?php
            $sql = mysql_query("SELECT user FROM apps WHERE user = '".$_SESSION['user']['username']."'");
                if(isset($_POST['submit']))
                {
                    if (empty($_POST['real']) || empty($_POST['location']) || empty($_POST['age']) || empty($_POST['why']) || empty($_POST['dif']) || empty($_POST['agree']))
                    {
                        echo '<div class="error_red">Please fill in all fields!</div><br/>';
                    }
                    else
                    {
                    if(mysql_num_rows($sql) < 1){
                        mysql_query("INSERT INTO `apps` (user,`real`,location,age,why,dif,additional,agree) VALUES ('".$_SESSION['user']['username']."', '".filter($_POST["real"])."', '".filter($_POST["location"])."', '".filter($_POST["age"])."', '".filter($_POST["why"])."', '".filter($_POST["dif"])."', '".filter($_POST["additional"])."', '".filter($_POST["agree"])."')") or die(mysql_error());
                        echo '<div class="error_green"><b>Thank you!</b> Your application has been submitted and is awaiting to be reviewed by staff!</div><br/>';
                    }else{
                        echo '<div class="error_red">You have already applied, please wait for a reply.</div><br />';
                        }
                    }   
                }
                ?>

<form method="post">                           
                           
                        <b>Username:</b><br />
                        <input disabled="disabled" value="{username}">
                                       
                        <br /><br />
                                           
                        <b>Real Name:</b><br />
                        <input type="text" name="real">
                        <br><br>
                                           
                        <b>Location: (country, city)</b><br />
                        <input type="text" name="location">
                        <br><br>
                                           
                        <b>Age:</b><br>
                        <select name="age">
                            <?php for ($i = 13; $i <= 100; $i++) : ?>
                                <option value="<?php echo $i; ?>"><?php echo $i; ?></option>
                            <?php endfor; ?>
                        </select>
                        <br><br>
                                           
                        <b>Why should we hire you?</b><br>
                        <textarea name="why" rows="4" cols="40"></textarea>
                        <br><br>
                                           
                        <b>Why are you different from the rest?</b><br>
                        <textarea name="dif" rows="4" cols="40"></textarea>
                        <br><br>
                                           
                        <b>Additional Information: (not required)</b><br>
                        <textarea name="additional" rows="4" cols="40"></textarea>
                        <br><br>
                                           
                        <input type="checkbox" value="1" name="agree"> I agree to be active on the hotel even before we select (if we) you as an Trial Moderator
                                           
                        <br><br>
                                           
                        <div style="float:right;padding: 5px;">
                        <input type="submit" value="Apply" name="submit"/>
                        </div>
                        <div style="float:left;"><a href="/me">Cancel</a></div>
                                   
                    </form>
                   
</div>
</div>
</div>
</div>
<div id="column2" class="column">
<div class="habblet-container " style="float:right; width: 310px;">
<div class="cbb clearfix settings  ">
<h2 class="title"><span style="float: left;">What is this?</span></h2>
<div style="padding: 5px" align="l">
<img src="/swfs/c_images/album1584/ADM90.gif" align="right">
Interested in applying for a staff position at {hotelName} Hotel? You will be required to be online for at least 3 hours per day and 6-7 days a week, unless you can provide a valid excuse. All staff applicants must be able to keep the community happy and also be mature, and also remember not to abuse their powers. Applicants must also be 13+ years.
</div>
</div>
</div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
        </div>
    </div>
</div>
                           
    <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>       
           
        </div>
       
        <!--[if lt IE 7]>
            <script type="text/javascript">
                Pngfix.doPngImageFix();
            </script>
        <![endif]-->
       
<br>
            <?php include('includes/footer.php'); ?>
            <?php include('includes/checktheban.php'); ?>

    </div>
    </body>
</html>

 

[Decellor]

Lmfao, the code @liam5062 gave is supposed to be executed in the database. You have to code out the page yourself and link it with the database, however if you want to be spoon-fed look for revcms staff application page on google.

Are you stupid? i also left a download link for the pages and i said to run it in db.