/
manage_kid.php
758 lines (414 loc) · 13.7 KB
/
manage_kid.php
1
<?php$key = 'we chit chat, chit chat, safe chatting, kids chat room, kids chat, teens chat, free chatting for kids, free chatting, manage kid';$des = 'Manage your child/teen on wechitchat.';$title = 'Account - Manage Child';$change = 'false';include('Includes/header.php');$per_page = 10; if(isset($_GET['start'])){$start = $_GET['start'];} else {$start = 0;}$record_count = mysql_num_rows(mysql_query("SELECT * FROM $_GET[name] WHERE name != '$_GET[name]' AND verifed = 'yes' AND maker = 'no'"));$max_pages = $record_count / $per_page;if(!$start){$start = 0;}$per_page2 = 10;if(isset($_GET['start2'])){$start2 = $_GET['start2'];} else {$start2 = 0;}$record_count2 = mysql_num_rows(mysql_query("SELECT * FROM posts WHERE under = '$_GET[name]' AND p_by = '$_GET[name]'"));$max_pages2 = $record_count2 / $per_page2;if(!$start2){$start2 = 0;}$per_page3 = 10;if(isset($_GET['start3'])){$start3 = $_GET['start3'];} else {$start3 = 0;}$record_count3 = mysql_num_rows(mysql_query("SELECT * FROM messages WHERE m_from = '$_GET[name]'"));$max_pages3 = $record_count3 / $per_page3;if(!$start3){$start3 = 0;}if(!(isset($_COOKIE['parent']))){header("Location: index.php");} elseif(isset($_COOKIE['parent'])){$date = date('ymdHi');$sql = "UPDATE users SET last_logged = '$date' WHERE name= '$_COOKIE[parent]'";mysql_query($sql);?><ul id="jsddm"><li><a href="support.php" class="norm" title="Report an Error">Support</a></li><li><a href="signup.php" class="norm" title="Sign Up!">Sign Up</a></li><li><a href="login.php" class="norm" title="Log In">Log In</a></li><li><a href="aboutus.php" class="norm" title="About us">About Us</a></li><li><a href="#" class="iit" id="spec_on">Account</a><ul id="drop_men"><li><a href="index.php" class="dropper">Parental Controls</a></li><li><a href="logout.php" class="bott">Logout</a></li></ul></li></ul></div><div id="Content1"><div id="fleft"><?php$query = "SELECT * FROM users WHERE name = '$_GET[name]' LIMIT 1";$result = mysql_query($query);while($row = mysql_fetch_array($result)){$pic = $row['pic'];$name = $_GET['name'];if($pic === ''){?><a href="people_profile.php?user=<?php echo $name; ?>"><img src="User_Images/none.png" id="user" width="150" height="150" alt=""></a><?php } else { ?><a href="people_profile.php?user=<?php echo $name; ?>"><img src="User_Images/<?php echo $pic; ?>" id="user" width="150" height="150" alt=""></a><?php}}?><div id="LogLinks"><ul><li><a href="index.php" id="onp">Parental Controls</a></li><li><a href="logout.php">Logout</a></li></ul></div></div><div id="fright"><h1 id="prof"><div id="bord">Parental Controls > Mange Child</div></h1><div id="pcontent"><?phpif(isset($errors)){?><div id="errors"><?php echo $errors; ?></div><?php}if(isset($_GET['options2'])){if($_GET['options2'] == 'true'){if(isset($_GET['type'])){if($_GET['type'] == 'Delete'){$sql = "DELETE FROM messages WHERE message = '$_GET[message]' AND id = '$_GET[id]'";mysql_query($sql);header("Location: manage_kid.php?id=".$_GET["id"]."&name=".$_GET["name"]."&password=".$_GET["password"]."");}}}}if(isset($_GET['options'])){if($_GET['options'] == 'true'){if(isset($_GET['type'])){if($_GET['type'] == 'Remove Friend'){$sql = "DELETE FROM $_GET[name2] WHERE name = '$_GET[name]' AND maker = 'no'";mysql_query($sql);$sql2 = "DELETE FROM $_GET[name] WHERE name = '$_GET[name2]' AND maker = 'no'";mysql_query($sql2);header("Location: manage_kid.php?id=".$_GET["id"]."&name=".$_GET["name"]."&password=".$_GET["password"]."");}if($_GET['type'] == 'Delete'){$sql = "DELETE FROM posts WHERE message = '$_GET[message]' AND id = '$_GET[id3]'";mysql_query($sql);header("Location: manage_kid.php?id=".$_GET["id"]."&name=".$_GET["name"]."&password=".$_GET["password"]."");}}}}if(isset($_GET['id']) && isset($_GET['name'])){$query = "SELECT * FROM $_GET[name] WHERE name != '$_GET[name]' AND verifed = 'yes' AND maker = 'no'";$result = mysql_query($query);$num = mysql_num_rows($result);if($num >= 1){?><br /><br /><fieldset><legend><b><?php echo $_GET['name']; ?>'s Fiends</b></legend><div id="utop">Picture</div><div id="utop2">Name</div><div id="utop3">Last On</div><div id="utop4">Option</div><br /><br /><?php} else {?><br /><br /><fieldset><legend><b><?php echo $_GET['name']; ?>'s Fiends</b></legend>Your child has no friends<br /><br /><?php}$query8 = "SELECT * FROM $_GET[name] WHERE name != '$_GET[name]' AND verifed = 'yes' AND maker = 'no' LIMIT $start, $per_page";$result8 = mysql_query($query8);while($row8 = mysql_fetch_array($result8)){$id = $row8['id'];$name = $row8['name'];$verifed = $row8['verifed'];$maker = $row8['maker'];$query = "SELECT * FROM users WHERE name = '$name' ";$result = mysql_query($query);while($row = mysql_fetch_array($result)){$id2 = $row['id'];$name2 = $row['name'];$password2 = $row['password'];$email = $row['email'];$image = $row['image'];$about = $row['about'];$pic = $row['pic'];$last_logged = $row['last_logged'];$joined = $row['joined'];$age = $row['age'];$gender = $row['gender'];$query5 = "SELECT * FROM users WHERE name = '$_GET[name]' AND child = '$_COOKIE[parent]'";$result5 = mysql_query($query5);while($row3 = mysql_fetch_array($result5)){$idb = $row3['id'];$nameb = $row3['name'];$passwordb = $row3['password'];$last_loggedb = $row3['last_logged'];if($pic === ''){?><img src="User_Images/none.png" id="user" width="50" height="50" alt=""><?php } else { ?><img src="User_Images/<?php echo $pic; ?>" id="user" width="50" height="50" alt=""><?php}?><div id="name_par"><?php echo $name; ?></div><div id="name_par2"><?php echo returnMess($last_logged); ?></div><form action="manage_kid.php" method="get"><input type="hidden" name="options" value="true" /><input type="hidden" name="id" value="<?php echo $idb; ?>" /><input type="hidden" name="id2" value="<?php echo $id2; ?>" /><input type="hidden" name="name" value="<?php echo $nameb; ?>" /><input type="hidden" name="name2" value="<?php echo $name2; ?>" /><input type="hidden" name="password" value="<?php echo $passwordb; ?>" /><input type="submit" name="type" id="esubmit176" value="Remove Friend" /></form><?php}}}$number = mysql_num_rows(mysql_query("SELECT * FROM $_GET[name] WHERE name != '$_GET[name]' AND verifed = 'yes' AND maker = 'no'"));if($number > $per_page){ echo '<hr style="border: 1px solid #DDDDDD; width: 100%; float: left;" /> <br /><span class="pag"></span>';$prev = $start - $per_page;$next = $start + $per_page;if(!($start<=0)){echo '<a href="manage_kid.php?start='.$prev.'&id='.$_GET['id'].'&name='.$_GET['name'].'&password='.$_GET['password'].'">Prev</a> ';}$i = 1;for($x=0; $x<$record_count; $x = $x + $per_page){if($start != $x){echo' <a href="manage_kid.php?start='.$x.'&id='.$_GET['id'].'&name='.$_GET['name'].'&password='.$_GET['password'].'">'.$i.'</a> ';} else {echo' <a href="manage_kid.php?start='.$x.'&id='.$_GET['id'].'&name='.$_GET['name'].'&password='.$_GET['password'].'" style="font-size: 20px;"><b>'.$i.'</b></a> ';}$i++;}if(!($start>=$record_count-$per_page)){echo ' <a href="manage_kid.php?start='.$next.'&id='.$_GET['id'].'&name='.$_GET['name'].'&password='.$_GET['password'].'">Next</a>';}}?></fieldset><?php$query = "SELECT * FROM posts WHERE under = '$_GET[name]' AND p_by = '$_GET[name]'";$result = mysql_query($query);$num = mysql_num_rows($result);if($num >= 1){?><br /><br /><fieldset><legend><b><?php echo $_GET['name']; ?>'s Posts</b></legend><div id="etop">Post</div><div id="etop2">Posted</div><div id="etop3">Option</div><br /><br /><?php} else {?><br /><br /><fieldset><legend><b><?php echo $_GET['name']; ?>'s Posts</b></legend>Your child has no posts<?php}$query = "SELECT * FROM users WHERE name = '$_GET[name]'";$result = mysql_query($query);while($row = mysql_fetch_array($result)){$id = $row['id'];$name = $row['name'];$password = $row['password'];$email = $row['email'];$image = $row['image'];$about = $row['about'];$pic = $row['pic'];$last_logged = $row['last_logged'];$joined = $row['joined'];$age = $row['age'];$gender = $row['gender'];$query3 = "SELECT * FROM posts WHERE under = '$_GET[name]' AND p_by = '$_GET[name]' ORDER BY date DESC LIMIT $start2, $per_page2";$result3 = mysql_query($query3);while($row = mysql_fetch_array($result3)){$id3 = $row['id'];$under = $row['under'];$p_by = $row['p_by'];$message = $row['message'];$date = $row['date'];$query11 = "SELECT * FROM users WHERE name = '$_GET[name]' AND child = '$_COOKIE[parent]'";$result11 = mysql_query($query11);while($row11 = mysql_fetch_array($result11)){$idb = $row11['id'];$nameb = $row11['name'];$passwordb = $row11['password'];$last_loggedb = $row11['last_logged'];?><br /><br /><form action="manage_kid.php" method="get"><input type="hidden" name="options" value="true" /><input type="hidden" name="id" value="<?php echo $idb; ?>" /><input type="hidden" name="name" value="<?php echo $nameb; ?>" /><input type="hidden" name="password" value="<?php echo $passwordb; ?>" /><input type="hidden" name="message" value="<?php echo $message; ?>" /><input type="hidden" name="id3" value="<?php echo $id3; ?>" /><input type="submit" name="type" id="esubmit173" value="Delete" /></form><div id="mname_par2"><?php echo returnMess($date); ?></div><div id="mname_par"><?php echo wordwrap($message, 50, '<br />', true); ?></div><?php}}}$number2 = mysql_num_rows(mysql_query("SELECT * FROM posts WHERE under = '$_GET[name]' AND p_by = '$_GET[name]'"));if($number2 > $per_page2){ echo '<hr style="border: 1px solid #DDDDDD; width: 100%; float: left;" /> <br /><span class="pag"></span>';$prev2 = $start2 - $per_page2;$next2 = $start2 + $per_page2;if(!($start2<=0)){echo '<a href="manage_kid.php?start2='.$prev2.'&id='.$_GET['id'].'&name='.$_GET['name'].'&password='.$_GET['password'].'">Prev</a> ';}$i2 = 1;for($x2=0; $x2<$record_count2; $x2 = $x2 + $per_page2){if($start2 != $x2){echo' <a href="manage_kid.php?start2='.$x2.'&id='.$_GET['id'].'&name='.$_GET['name'].'&password='.$_GET['password'].'">'.$i2.'</a> ';} else {echo' <a href="manage_kid.php?start2='.$x2.'&id='.$_GET['id'].'&name='.$_GET['name'].'&password='.$_GET['password'].'" style="font-size: 20px;"><b>'.$i2.'</b></a> ';}$i2++;}if(!($start2>=$record_count2-$per_page2)){echo ' <a href="manage_kid.php?start2='.$next2.'&id='.$_GET['id'].'&name='.$_GET['name'].'&password='.$_GET['password'].'">Next</a>';}}?></fieldset><?php$query = "SELECT * FROM messages WHERE m_from = '$_GET[name]'";$result = mysql_query($query);$num = mysql_num_rows($result);if($num >= 1){?><br /><br /><fieldset><legend><b><?php echo $_GET['name']; ?>'s Messages</b></legend><div id="ytop">To</div><div id="ytop2">Message</div><div id="ytop3">Sent</div><div id="ytop4">Option</div><br /><br /><?php$query3 = "SELECT * FROM messages WHERE m_from = '$_GET[name]' ORDER BY date DESC LIMIT $start3, $per_page3";$result3 = mysql_query($query3);while($row = mysql_fetch_array($result3)){$id = $row['id'];$to = $row['m_to'];$from = $row['m_from'];$message = $row['message'];$date = $row['date'];$query11 = "SELECT * FROM users WHERE name = '$_GET[name]' AND child = '$_COOKIE[parent]'";$result11 = mysql_query($query11);while($row11 = mysql_fetch_array($result11)){$idb = $row11['id'];$nameb = $row11['name'];$passwordb = $row11['password'];$last_loggedb = $row11['last_logged'];?><br /><br /><form action="manage_kid.php" method="get"><input type="hidden" name="options2" value="true" /><input type="hidden" name="id" value="<?php echo $idb; ?>" /><input type="hidden" name="name" value="<?php echo $nameb; ?>" /><input type="hidden" name="password" value="<?php echo $passwordb; ?>" /><input type="hidden" name="message" value="<?php echo $message; ?>" /><input type="hidden" name="id" value="<?php echo $id; ?>" /><input type="submit" name="type" id="esubmit1733" value="Delete" /></form><div id="mename_par2"><?php echo returnMess($date); ?></div><div id="mename_par3"><?php echo $name; ?></div><div id="mename_par"><?php echo wordwrap($message, 40, '<br />', true); ?></div><?php}}$number3 = mysql_num_rows(mysql_query("SELECT * FROM messages WHERE m_from = '$_GET[name]'"));if($number3 > $per_page3){ echo '<hr style="border: 1px solid #DDDDDD; width: 100%; float: left;" /> <br /><span class="pag"></span>';$prev3 = $start3 - $per_page3;$next3 = $start3 + $per_page3;if(!($start3<=0)){echo '<a href="manage_kid.php?start3='.$prev3.'&id='.$_GET['id'].'&name='.$_GET['name'].'&password='.$_GET['password'].'">Prev</a> ';}$i3 = 1;for($x3=0; $x3<$record_count3; $x3 = $x3 + $per_page3){if($start3 != $x3){echo' <a href="manage_kid.php?start3='.$x3.'&id='.$_GET['id'].'&name='.$_GET['name'].'&password='.$_GET['password'].'">'.$i3.'</a> ';} else {echo' <a href="manage_kid.php?start3='.$x3.'&id='.$_GET['id'].'&name='.$_GET['name'].'&password='.$_GET['password'].'" style="font-size: 20px;"><b>'.$i3.'</b></a> ';}$i3++;}if(!($start3>=$record_count3-$per_page3)){echo ' <a href="manage_kid.php?start3='.$next3.'&id='.$_GET['id'].'&name='.$_GET['name'].'&password='.$_GET['password'].'">Next</a>';}}} else {?><br /><br /><fieldset><legend><b><?php echo $_GET['name']; ?>'s Messages</b></legend>Your child has sent no messages<?php}?></fieldset><?php} else {header("Location: index.php");}?></div></div></div><?php} else {echo 'There was an error please report this to us by going to the<a href="support.php">support</a> page';}include('Includes/footer.php');?>