Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $groupid=0;
- $groupid=$_POST['group_id'];
- $groupname=$_POST['group_name'];
- $groupgrade=$_POST['group_grade'];
- $groupformat=$_POST['group_format'];
- $groupprivatecomment=$_POST['group_prv_comment'];
- $grouppubliccomment=$_POST['group_pub_comment'];
- $assignmentname=$_POST['assignment-name'];
- echo "you have entered" ;
- echo $groupid.$groupname;
- $link = mysql_connect('HOST_ADDRESS', 'USERNAME', 'PASSWORD');
- if (!$link) {
- die('Could not connect: ' . mysql_error());
- }
- echo '<br>The Grades are being entered .Please check for the confirmation message below<br>';
- $db_selected = mysql_select_db('u671706493_upuVy', $link);
- if (!$db_selected) {
- die ('Can\'t use wordpress : ' . mysql_error());
- }
- echo "<br>database selected sucessfully<br>";
- if ($groupid==0) {
- $sql2 = " SELECT id FROM wp_bp_groups WHERE name='$groupname'";
- $groupi= mysql_query($sql2);
- if (!$groupi) {
- echo "Could not successfully run query ($sql2) from DB: " . mysql_error();
- exit;
- }
- $groupid = mysql_result($groupi,0,0);
- echo $groupid ;
- }
- $sql = "SELECT user_id FROM `wp_bp_groups_members` WHERE group_id=$groupid AND user_title !=\"Group Admin\"";
- $result1 = mysql_query($sql);
- if (!$result1) {
- echo "Could not successfully run query ($sql) from DB: " . mysql_error();
- exit;
- }
- $row = mysql_fetch_assoc($result1);
- print_r ($row);
- echo '<br>'2;
- $sql3 = "SELECT ID FROM `wp_posts` WHERE post_title = '$assignmentname' ";
- $result2 = mysql_query($sql3);
- if (!$result2) {
- echo "Could not successfully run query ($sql3) from DB: " . mysql_error();
- exit;
- }
- $parent_post = mysql_result($result2,0,0);
- $sql4 = "SELECT ID FROM `wp_posts` WHERE post_parent = $parent_post AND post_type='gradebook' ";
- $result4 = mysql_query($sql4);
- if (!$result4) {
- echo "Could not successfully run query ($sql4) from DB: " . mysql_error();
- exit;
- }
- $post_id = mysql_result($result4,0,0);
- echo "post id is $post_id <br>";
- if (mysql_num_rows($result1) == 0) {
- echo "No rows found, nothing to print so am exiting";
- exit;
- }
- $sql7 = "SELECT meta_id FROM wp_postmeta where meta_key='grade' AND post_id = $post_id";
- $result7 = mysql_query($sql7);
- while ($row = mysql_fetch_assoc($result1) && $row2 = mysql_fetch_assoc($result7)) {
- echo $row2["meta_id"], ' => ', $row["user_id"];
- $new = "[grade uid=\"{$row["user_id"]}\" value=\"{$groupgrade}\" format=\"{$groupformat}\" prv_comment=\"{$groupprivatecomment}\" pub_comment=\"{$grouppubliccomment}\"] ";
- $sqq = "UPDATE wp_postmeta SET meta_value='$new' WHERE meta_key='grade' AND post_id= $post_id AND meta_id = {$row2["meta_id"]}";
- $result = mysql_query($sqq);
- echo "grade has been updated";
- }
- mysql_close($link);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement