
Xtremer360
Members-
Posts
1,444 -
Joined
-
Last visited
About Xtremer360
- Birthday 12/18/1984
Contact Methods
-
AIM
Xtremer360
-
Website URL
http://www.kansasoutlawwrestling.com
-
Yahoo
Xtremer360
Profile Information
-
Gender
Male
-
Location
Basehor, Kansas
Xtremer360's Achievements

Advanced Member (4/5)
0
Reputation
-
i'll try and come up with something
-
The lock_date in the db is 2011-09-05 15:11:08.
-
For some reason when I echo $diff and $time_remaining it ALWAYS echos with values of 3 and 7 and not sure why. $lock_date = $row['lock_date']; $current_time = time(); // Find out if user is locked out of their account if (($lock_date != "0000-00-00 00:00:00") && strtotime($lock_date) < $current_time) { $lock_date = strtotime($lock_date); $diff = $current_time - $lock_date; $diff = floor($diff/6000); // Take minutes and perform tasks if ($diff <= 10) { // Calculate time remaining $time_remaining = 10 - $diff; // Account locked error $errors = true; $message = "Account is locked! Must wait " .$time_remaining." minutes to log in again!"; $output = array('errorsExist' => $errors, 'message' => $message); } else { // Clear the lock $query = "UPDATE users_logins_attempts SET lockDate = NULL, ip_address = NULL, failed_logins = 0 WHERE users_id = '".$users_id."'"; $result = mysqli_query($dbc,$query); // Account locked error $errors = true; $message = "Account is unlocked. You may now try to log in again!"; $output = array('errorsExist' => $errors, 'message' => $message); } }
-
Amazing work. What do you mean format? If you mean what I'm using on client side scripting on my front end it's jquery.
-
That works great thank you however I want to add something to it. I want it to basically before it runs through check to make sure that in that table called handlers that there isn't someone already with that characer as there default_character_id and if there is a match then it kicks it back to my form with an alert since I am also using jquery on my front end.
-
I know via firebug that the correct parameters were passed to my process page and the parameter being passed that in caused issues on the process page is $characterIDList. What's causing the issue is that its not inserting the value into the insert query. The rest of the insert query works fine. process page $characterIDs = explode(',', $_POST['characterIDList']); foreach($characterIDs as $itm){ $id = (int)$itm; } $defaultcharid = (int)$characterIDs[0]; $query = "INSERT INTO `handlers` (username, password, firstname, lastname, email, status_id, isadmin, default_character_id, creator_id, datecreated) VALUES ('$username','$password','$firstname','$lastname','$email','$status','$admin', '$defaultcharid', 1, NOW())";
-
I take that back. The only way the info displays is if the person has a manager and if it doesn't then it says all the variables are undefined. function getWrestling($style, $id) { $id=mysql_real_escape_string($id); if ($style=='singles') { $sql = "SELECT bio.charactername AS manager, ebw.finisher AS finisher, ebw.setup AS setup, ebw.music AS music FROM efed_bio_wrestling AS ebw JOIN efed_bio AS bio ON ( ebw.manager_id = bio.id) WHERE ebw.bio_id = '$id'"; $re = mysql_query($sql); $row = mysql_fetch_assoc($re); extract($row); ?> <h2>Wrestling</h2> <table class="biotable" cellspacing="10px"> <tr class="biotablerowb"> <td class="biotableheadingb">Manager/Valet:</td> <td class="biotabledatab"><?php if (strlen ($manager) < 1) { print "N/A"; } else { print "$manager";}?></td> </tr> <tr class="biotablerowb"> <td class="biotableheadingb">Finisher:</td> <td class="biotabledatab"><?php if (strlen ($finisher) < 1) { print "N/A"; } else { print "$finisher";}?></td> </tr> <tr class="biotablerowb"> <td class="biotableheadingb">Setup:</td> <td class="biotabledatab"><?php if (strlen ($setup) < 1) { print "N/A"; } else { print "$setup";}?></td> </tr> <tr class="biotablerowb"> <td class="biotableheadingb">Entrance Music:</td> <td class="biotabledatab"><?php if (strlen ($music) < 1) { print "N/A"; } else { print "$music";}?></td> </tr> </table> <?php } ?>
-
Finally solved it on my own. I thank everyone who contributed to the thread.
-
Okay so I got something to work. I have it to display the value of the manager_id field. However my coding says that if its value is less than 1 then print N/A but it's not then it needs to take it back to efed_bio and match it up with the id value and then grab that charactername. <td class="biotableheadingb">Manager/Valet:</td> <td class="biotabledatab"><?php if (strlen ($manager) < 1) { print "N/A"; } else { print "$manager";}?></td>
-
Does that help anyone?
-
These are just the parts that don't work. I already have it getting the rest of the information so it has the bio_id of the character and what it's supposed to do when it's inside of the efed_bio_wrestling table is get the manager_id and then take it to the efed_bio table and match that to the same integer and when it finds a match record then get that person's charactername and if there is a 0 for the value inside of manager_id then it says "N/A" efed_bio id charactername efed_bio_wrestling bio_id manager_id
-
Again I spent the better part of the day researching and trying different things and can't seem to come up with a solution. Anyone available to try it from a second brain instead of mine.
-
Anyone have any other suggestions that I could plug in and try because I've about tried everything I can come up with. It just keeps saying its undefined.
-
That didn't work it made all the variables in that area undefined. Not saying you don't understand what I'm trying to attempt here but that way you can get a better understanding. Okay so say i have wrestler 1 that inside the efed_bio_wrestling table has a value of 2 in the manager_id field. I want it to take that value to the efed_bio table and look in the id field with that integer. Then when it finds a match then grab the value inside the charactername field.
-
Does anyone know that can read a few previous posts?