· 9 years ago · Oct 12, 2016, 04:38 AM
1<?php
2require('../../../includes/config.php');
3require('../../../structure/database.php');
4require('../../../structure/base.php');
5require('../../../structure/user.php');
6
7$database = new database($db_host, $db_name, $db_user, $db_password);
8$base = new base($database);
9$user = new user($database);
10
11//set some basic vars
12$username = $user->getUsername($_COOKIE['user'], 2);
13$rank = $user->getRank($username);
14?>
15<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
16<html xmlns:IE>
17
18<head>
19 <meta http-equiv="Expires" content="0">
20 <meta http-equiv="Pragma" content="no-cache">
21 <meta http-equiv="Cache-Control" content="no-cache">
22 <meta name="MSSmartTagsPreventParsing" content="TRUE">
23 <meta http-equiv="Content-Type" content="text/html; charset=EUC-JP">
24 <title><?php echo $data['wb_title']; ?></title>
25 <link href="../../../css/basic-3.css" rel="stylesheet" type="text/css" media="all">
26 <link href="../../../css/main/title-5.css" rel="stylesheet" type="text/css" media="all">
27 <script src="http://code.jquery.com/jquery-latest.min.js"></script>
28 <link rel="shortcut icon" href="../../../img/favicon.ico"/>
29 <?php include('../../../includes/google_analytics.html'); ?>
30 <style>
31 fieldset {
32 text-align: left;
33 border: 2px solid #625437;
34 width: 95%;
35 position: relative;
36 margin: 10px;
37 padding-left: 10px;
38 background-color: transparent;
39 }
40
41 legend {
42 color: #625437;
43 font-weight: bold;
44 font-size: 15px;
45 }
46
47 label {
48 display: block;
49 height: 20px;
50 text-align: center;
51 }
52
53 textarea {
54 display: block;
55 width: 200px;
56 height: 100px;
57 }
58
59 </style>
60 <script type="text/javascript">
61 function goBack() {
62 window.history.back();
63 }
64 </script>
65</head>
66
67<div id="body">
68 <?php //$base->getNavBar($username, $path, $rank); ?>
69
70 <div style="text-align: center; background: none;">
71 <div class="titleframe e">
72 <b>Password Support</b><br/>
73 <a href="../../../index">ScapeRune Home</a>
74 </div>
75 </div>
76</div>
77
78<div class="frame e" style="overflow:auto;">
79 <?php
80 //make sure user doesn't already have a recovery request submitted
81 $database->processQuery("SELECT * FROM `tracking` WHERE " . time() . " - `time` < 7200 AND `ip` = ? LIMIT 1", array($_SERVER['REMOTE_ADDR']), false);
82
83 if ($database->getRowCount() >= 1) {
84 echo '<center>Oops! You have already submitted a recovery request.<br /><br /> <a href="../../../index"Main Menu</a></center>';
85
86 } elseif (!isset($_REQUEST['username'])) {
87 ?>
88
89 <form action="recover_password.php" method="POST">
90 <input type="text" name="username" maxlength="12"><input type="submit" value="Continue">
91 </form>
92
93 <?php
94 } elseif (!$user->doesExist($_REQUEST['username'])) {
95 echo 'No user exists with that username!<br /> <input type="button" value="Back" onclick="goBack()" />';
96 } else {
97
98 $questions[] = array();
99 $questions[0] = 'Where was your first vacation?:';
100 $questions[1] = 'Who was your first best friend?:';
101 $questions[2] = 'What was your first pets name?:';
102 $questions[3] = 'Who was your first boyfriend/girlfriend?:';
103 $questions[4] = 'What color was your first bedroom?:';
104 $questions[5] = 'Who is your favorite musical artist?';
105
106 //extract data
107 $data = $database->processQuery("SELECT * FROM `recoveries` WHERE `id` = ? LIMIT 1", array($user->getIdByName($_REQUEST['username'])), false);
108
109 if ($database->getRowCount() == 0 || $user->getUsername($_COOKIE['user'], 2) == $_REQUEST['username']) {
110 echo 'Temporarily disabled! <input type="button" value="Back" onclick="goBack()" />';
111 } elseif (!isset($_POST['answer'])) {
112 ?>
113 <fieldset class="question">
114 <legend>Important Information</legend>
115 This form will allow you to request that a new password is set for the account: <b><?php echo '"'.$_REQUEST['username']. '"'; ?></b>.
116 <br /><br />
117 <img style="float: left" src="/img/title2/lock.gif">
118 <span style="font-weight: bold; color: rgb(255, 187, 34);">Want to be back in game sooner? If you want to get back in game quickly, here are a few tips:</span><br/><br/>
119
120 Please answer all the questions below to confirm that you are the real owner of the account.<br/><br/>
121 Enter the earliest and most specific information about the account that you can.<br/><br/>
122 Take the time to remember as much detail as possible. The more detail you give us, <b>the quicker you
123 can be
124 back in game</b>
125 <br/><br/>
126 If you really don't know the answer to a question, leave the answer box blank.<br/><br/>
127 <b>Remember:</b> The more questions you answer correctly, the sooner you can be back in game!
128 </fieldset>
129 <br/>
130
131 <fieldset class="question">
132 <legend>Answer Recovery Questions</legend>
133 <p style="text-align: center">If you have set these, you must try to answer at least three. Recovery
134 answers
135 have a minimum length of 3 characters.
136 Recovery answers can only contain the characters A-Z, 0-9 and accented characters such as é or
137 ü.
138 Other characters will not count towards the length.</p>
139
140 <label><b>I have not set any recovery questions</b>
141 <input type="checkbox" class="input_control" value="subject"/></label>
142
143 <form action="recover_password.php" method="POST">
144 <input type="hidden" name="username" value="<?php echo $_REQUEST['username']; ?>">
145 <table cellpadding="6" style="margin-left:auto;margin-right:auto;">
146 <?php
147 $i = 0;
148 foreach ($questions as $question) {
149 $i++;
150 ?>
151 <tr>
152 </tr>
153 <tr>
154 <td><?php echo $question; ?> 
155 <input type="text" class="textbox" name="answer[]" maxlength="40"
156 style="display: block;"></td>
157 </tr>
158 <?php
159 }
160 ?>
161 </table>
162 </form>
163 </fieldset>
164 <?php
165 } elseif(!isset($_POST['bypass'])) {
166 ?>
167 <fieldset class="question">
168 <legend>Your New Password</legend>
169 <p style="text-align: center">These must match exactly for the appeal to proceed.<br/>
170 For advice on setting a good password, please click <a style="color: rgb(255, 187, 34);"
171 target="_blank"
172 href="/kbase/viewarticle7564.html?article_id=2087">here</a>
173 (Opens in a new window).</p>
174 <table>
175 <tr>
176 <td style="vertical-align: middle"><b>Enter a new password for your account: <input type="text"
177 name="username"></b>
178 </td>
179 </tr>
180 <tr>
181 <td style="vertical-align: middle"><b>          Please
182 enter it again: <input type="text" name="username"></b></td>
183 </tr>
184 </table>
185 </fieldset>
186
187 <form action="recover_password.php" method="POST">
188 <input type="hidden" name="username" value="<?php echo $_REQUEST['username']; ?>">
189 <input type="hidden" name="bypass">
190 <fieldset class="question">
191 <legend>Other Details</legend>
192 When did you create this account?
193 <table>
194 <tr>
195 <td style="vertical-align: middle">
196 If you have any other details which would help you prove your ownership of this
197 account, please enter them here.<br/>
198 Please <b>do not</b> provide us with any of this following personal information, your full
199 name, home
200 address, email address or telephone number.<br/><br/>
201 <span class='textcounter' id="counter1">You have 300 characters remaining</span>
202 </td>
203 <td>
204 <textarea style="height: 120px; width: 450px;" class="textlimited"
205 data-textcounterid="counter1" maxlength="300" rows="4" cols="50"></textarea><br/>
206 </td>
207 </tr>
208 </table>
209 <input type="submit" value="Submit"/>
210 </form>
211 </fieldset>
212 <?php
213 } else {
214 //validate answers
215 $errors = array();
216 $answers = $_POST['answer'];
217 $i = 0;
218
219 foreach ($answers as $answer) {
220 $i++;
221
222 if (strlen($answer) < 3 || strlen($answer) > 35) {
223 $errors[] = 'Question #' . $i . ' must be at least three characters and no more than 26 characters.';
224 }
225
226 if (preg_match('#[^a-zA-Z0-9$/^[\p{L}-]*$/u ]#', $answer)) {
227 $errors[] = 'Question #' . $i . ' contains illegal characters.';
228 }
229 }
230
231 if (count($errors) >= 1) {
232 //back button
233 ?>
234 <center><input type="button" value="Back" onclick="goBack()"/></center> <?php
235
236 //display errors
237 foreach ($errors as $error) {
238 echo $error . '<br/>';
239 }
240 } else {
241 //generate a tracking ID
242 $rand_hash = $base->randomString(11);
243 $tracking_id = substr($rand_hash, 0, 3) . '-' . substr($rand_hash, 4, 3) . '-' . substr($rand_hash, 7, 3);
244
245 //create the recovery request
246 $database->processQuery("INSERT INTO `tracking` VALUES (null, ?, ?, NOW(), ?, ?, 0, ?, ?, ?, ?, ?, ?)", array($user->getIdByName($_REQUEST['username']), $_SERVER['REMOTE_ADDR'], time(), $tracking_id, $answers[0], $answers[1], $answers[2], $answers[3], $answers[4], $answers[5]), false);
247
248 ?>
249 <fieldset class="question">
250 <legend>Success!</legend>
251 You have successfully submitted an account recovery request. Your request will be
252 reviewed and processed within the next 48 hours. To track your account recovery
253 progress you can use the <b>recovery tracking ID</b>.<br><br> <b>Please make
254 note</b> of the the tracking ID provided to you and store it in a <b>safe</b>,
255 <b>secure</b> location so you don't lose or forget it.</b>
256 </fieldset>
257 <br/>
258 <br/>
259 <b>Tracking ID: <?php echo $tracking_id; ?></b>
260
261 <?php
262 }
263 }
264 }
265 ?>
266 <br/>
267 <br/>
268
269 <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
270 <script type="text/javascript">
271 //checks how many characters are remaining
272 // the selector below will catch the keyup events of elements decorated with class textlimited and have a maxlength
273 $('.textlimited[maxlength]').keyup(function () {
274 //get the fields limit
275 var maxLength = $(this).attr("maxlength");
276
277 // check if the limit is passed
278 if (this.value.length > maxLength) {
279 return false;
280 }
281
282 // find the counter element by the id specified in the source input element
283 var counterElement = $(".textcounter#" + $(this).data("textcounterid"));
284 // update counter 's text
285 counterElement.html("You have " + (maxLength - this.value.length) + " chararacters remaining");
286 });
287
288 //checks if the user has selected no recoveries and disables the textareas
289 $(document).ready(function () {
290 $('.input_control').change(function () {
291 $(".textbox").prop('disabled', this.checked);
292 $(".textarea").prop('disabled', this.checked);
293 });
294 $('.input_control').prop('checked', false);
295 $('.input_control').trigger('change');
296 });
297
298 // for future development
299 var months = [
300 {DaysInMonth: 31, Name: "January"},
301 {DaysInMonth: 31, Name: "February"},
302 {DaysInMonth: 31, Name: "March"},
303 {DaysInMonth: 31, Name: "April"},
304 {DaysInMonth: 31, Name: "May"},
305 {DaysInMonth: 31, Name: "June"},
306 {DaysInMonth: 31, Name: "July"},
307 {DaysInMonth: 31, Name: "August"},
308 {DaysInMonth: 31, Name: "September"},
309 {DaysInMonth: 31, Name: "October"},
310 {DaysInMonth: 31, Name: "November"},
311 {DaysInMonth: 31, Name: "December"}
312 ];
313 $(function () {
314 var monthSelector = $('select[name=month]');
315 $.each(months, function (index, month) {
316 $('<option></option>')
317 .attr('label', month.Name)
318 .attr('value', index)
319 .html(month.DaysInMonth)
320 .appendTo(monthSelector);
321 });
322
323 var yearSelector = $('select[name=ano]');
324 for (var year = 2015; year <= 2016; year++)
325 $('<option></option>')
326 .attr('label', year)
327 .attr('value', year)
328 .html(year)
329 .appendTo(yearSelector);
330 });
331
332 //limits the characters input in the 'other details' text area
333 function charLimit(limitField, limitNum) {
334 if (limitField.value.length > limitNum) {
335 limitField.value = limitField.value.substring(0, limitNum);
336 }
337 }
338 </script>
339 <div style="clear: both;"></div>
340</div>
341</div>
342</div>
343</div>
344
345<div class="tandc"><?php echo $data['wb_foot']; ?></div>
346</div>
347</body>
348</html>