Changeset 3265798
- Timestamp:
- 04/02/2025 04:57:19 PM (12 months ago)
- Location:
- emarksheet
- Files:
-
- 6 edited
-
tags/5.4.4/menu-pages/emark_add_class.php (modified) (3 diffs)
-
tags/5.4.4/menu-pages/emark_add_marks.php (modified) (4 diffs)
-
tags/5.4.4/menu-pages/uninstall.php (modified) (1 diff)
-
trunk/menu-pages/emark_add_class.php (modified) (3 diffs)
-
trunk/menu-pages/emark_add_marks.php (modified) (4 diffs)
-
trunk/menu-pages/uninstall.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
emarksheet/tags/5.4.4/menu-pages/emark_add_class.php
r3265698 r3265798 4 4 $nonce = wp_create_nonce( 'my-nonce' ); 5 5 if(isset($_POST['addsubject'])){ 6 $nonce1 = $_REQUEST['_wpnonce'];6 $nonce1 = wp_unslash($_REQUEST['_wpnonce']); 7 7 8 8 if ( ! wp_verify_nonce( $nonce1, 'my-nonce' ) ) { … … 14 14 if(isset($_POST['addsubject'])) 15 15 { 16 $subname = wp_ strip_all_tags($_POST['name']);16 $subname = wp_unslash($_POST['name']); 17 17 $wpdb->query($wpdb->prepare("insert into `emarksheet_class`(`id`,`class_name`) values('','$subname')")); 18 18 echo "<div class='alert alert-success'>Class Name Added Successfully</div>"; 19 19 } 20 21 22 } 23 } 20 24 if(isset($_POST['update_name'])) 21 25 { 22 $up_su_n = wp_ strip_all_tags($_POST['up_su_n']);23 $up_su_id = wp_ strip_all_tags($_POST['up_id']);26 $up_su_n = wp_unslash($_POST['up_su_n']); 27 $up_su_id = wp_unslash($_POST['up_id']); 24 28 $wpdb->query($wpdb->prepare("update `emarksheet_class` set `class_name`='$up_su_n' where `id`='$up_su_id'")); 25 29 echo "<div class='alert alert-success'>Class Name Updated Successfully</div>"; … … 49 53 <?php 50 54 }} 51 }52 }53 54 55 ?> 55 56 <script type="text/javascript"> -
emarksheet/tags/5.4.4/menu-pages/emark_add_marks.php
r3265698 r3265798 9 9 10 10 $selectd_row1 = $wpdb->get_results($wpdb->prepare("select * from `emarksheet_subject` where `class`='$su_n'")); 11 $selectd_rowm = $wpdb->get_results($wpdb->prepare("select * from `emarksheet_marks` where `student_id`='$id'")); 12 //print_r($selectd_rowm); 13 if(isset($selectd_rowm[0])) 14 $text = "Update Marks !!!"; 15 else 16 $text = "Add Marks !!!"; 11 17 ?> 12 18 <form action='<?php echo esc_url(admin_url("admin.php?page=eMarksheet-add-marks&action_new=add_marks_final&class_id=$su_n")); ?>' method='post'> … … 18 24 foreach($selectd_row1 as $selectd_row1) 19 25 { 20 echo "<tr><td>".esc_html($i)."</td><td>".esc_html(ucfirst($selectd_row1->sub_name))."</td><td><input type='text' name='tm_".esc_html($i)."' value='".esc_html($selectd_row1->total_marks)."' readonly='readonly' style='width:60px;' ></td><td><input type='text' name='mm_".esc_html($i)."' value='".esc_html($selectd_row1->min_pass)."' readonly='readonly' style='width:60px;' ></td><td> <input type='text' name='om_".esc_html($i)."' style='width:60px;'/></td></tr>"; 26 if(isset($selectd_rowm[0]->marks)) 27 { 28 $select_marks = unserialize($selectd_rowm[0]->marks); 29 $ob_mks = $select_marks["om_".$i]; 30 } 31 else 32 $ob_mks = " "; 33 echo "<tr><td>".esc_html($i)."</td><td>".esc_html(ucfirst($selectd_row1->sub_name))."</td><td><input type='text' name='tm_".esc_html($i)."' value='".esc_html($selectd_row1->total_marks)."' readonly='readonly' style='width:60px;' ></td><td><input type='text' name='mm_".esc_html($i)."' value='".esc_html($selectd_row1->min_pass)."' readonly='readonly' style='width:60px;' ></td><td> <input type='text' name='om_".esc_html($i)."' style='width:60px;' value='".esc_html($ob_mks)."'/></td></tr>"; 21 34 $i++; 22 35 } 23 36 ?> 24 <tr><td colspan='5'><center><button type="submit" class='btn btn-info'> Add Marks Now !!!</button></center></td>37 <tr><td colspan='5'><center><button type="submit" class='btn btn-info'><?php echo esc_html($text); ?></button></center></td> 25 38 </table> 26 39 <?php … … 63 76 foreach($select_data2 as $select_data2) 64 77 { 78 $selectd_rowm = $wpdb->get_results($wpdb->prepare("select * from `emarksheet_marks` where `student_id`='$select_data2->id'")); 79 //print_r($selectd_rowm); 80 if(isset($selectd_rowm[0])) 81 $text = "Update Marks !!!"; 82 else 83 $text = "Add Marks !!!"; 65 84 ?> 66 85 <tr><td> … … 68 87 echo esc_html($i); 69 88 ?> 70 </td><td><?php echo esc_html($select_data2->roll_no)."</td><td>".esc_html($select_data2->first_n)." ".esc_html($select_data2->last_n)."</td><td>".esc_html($select_data2->father_n)."</td><td>".esc_html($select_data2->mother_n)."</td><td>".esc_html($select_data2->dob_date)."-".esc_html($select_data2->dob_month)."-".esc_html($select_data2->dob_year)."</td><td><a href='".esc_url(admin_url("admin.php?page=eMarksheet-add-marks&action=add_marks&id=$select_data2->id"))."' class='btn btn-danger'><i class='icon-white icon-plus'></i> Add Marks</a></td></tr>";89 </td><td><?php echo esc_html($select_data2->roll_no)."</td><td>".esc_html($select_data2->first_n)." ".esc_html($select_data2->last_n)."</td><td>".esc_html($select_data2->father_n)."</td><td>".esc_html($select_data2->mother_n)."</td><td>".esc_html($select_data2->dob_date)."-".esc_html($select_data2->dob_month)."-".esc_html($select_data2->dob_year)."</td><td><a href='".esc_url(admin_url("admin.php?page=eMarksheet-add-marks&action=add_marks&id=$select_data2->id"))."' class='btn btn-danger'><i class='icon-white icon-plus'></i> ". esc_html($text)."</a></td></tr>"; 71 90 $i++; 72 91 } -
emarksheet/tags/5.4.4/menu-pages/uninstall.php
r3265698 r3265798 3 3 { 4 4 global $wpdb; 5 $wpdb->query("DROP table `emarksheet_class`"); 5 $wpdb->query("DROP table `emarksheet_class`"); //db call ok; no-cache ok 6 6 7 $wpdb->query("DROP table `emarksheet_marks`"); 7 $wpdb->query("DROP table `emarksheet_marks`"); //db call ok; no-cache ok 8 8 9 $wpdb->query("DROP table `emarksheet_setting`"); 9 $wpdb->query("DROP table `emarksheet_setting`"); //db call ok; no-cache ok 10 10 11 $wpdb->query("DROP table `emarksheet_student`"); 11 $wpdb->query("DROP table `emarksheet_student`"); //db call ok; no-cache ok 12 12 13 $wpdb->query("DROP table `emarksheet_subject`"); 13 $wpdb->query("DROP table `emarksheet_subject`"); //db call ok; no-cache ok 14 14 15 15 $plugin = "eMarksheet/emarksheet.php"; -
emarksheet/trunk/menu-pages/emark_add_class.php
r3265698 r3265798 4 4 $nonce = wp_create_nonce( 'my-nonce' ); 5 5 if(isset($_POST['addsubject'])){ 6 $nonce1 = $_REQUEST['_wpnonce'];6 $nonce1 = wp_unslash($_REQUEST['_wpnonce']); 7 7 8 8 if ( ! wp_verify_nonce( $nonce1, 'my-nonce' ) ) { … … 14 14 if(isset($_POST['addsubject'])) 15 15 { 16 $subname = wp_ strip_all_tags($_POST['name']);16 $subname = wp_unslash($_POST['name']); 17 17 $wpdb->query($wpdb->prepare("insert into `emarksheet_class`(`id`,`class_name`) values('','$subname')")); 18 18 echo "<div class='alert alert-success'>Class Name Added Successfully</div>"; 19 19 } 20 21 22 } 23 } 20 24 if(isset($_POST['update_name'])) 21 25 { 22 $up_su_n = wp_ strip_all_tags($_POST['up_su_n']);23 $up_su_id = wp_ strip_all_tags($_POST['up_id']);26 $up_su_n = wp_unslash($_POST['up_su_n']); 27 $up_su_id = wp_unslash($_POST['up_id']); 24 28 $wpdb->query($wpdb->prepare("update `emarksheet_class` set `class_name`='$up_su_n' where `id`='$up_su_id'")); 25 29 echo "<div class='alert alert-success'>Class Name Updated Successfully</div>"; … … 49 53 <?php 50 54 }} 51 }52 }53 54 55 ?> 55 56 <script type="text/javascript"> -
emarksheet/trunk/menu-pages/emark_add_marks.php
r3265698 r3265798 9 9 10 10 $selectd_row1 = $wpdb->get_results($wpdb->prepare("select * from `emarksheet_subject` where `class`='$su_n'")); 11 $selectd_rowm = $wpdb->get_results($wpdb->prepare("select * from `emarksheet_marks` where `student_id`='$id'")); 12 //print_r($selectd_rowm); 13 if(isset($selectd_rowm[0])) 14 $text = "Update Marks !!!"; 15 else 16 $text = "Add Marks !!!"; 11 17 ?> 12 18 <form action='<?php echo esc_url(admin_url("admin.php?page=eMarksheet-add-marks&action_new=add_marks_final&class_id=$su_n")); ?>' method='post'> … … 18 24 foreach($selectd_row1 as $selectd_row1) 19 25 { 20 echo "<tr><td>".esc_html($i)."</td><td>".esc_html(ucfirst($selectd_row1->sub_name))."</td><td><input type='text' name='tm_".esc_html($i)."' value='".esc_html($selectd_row1->total_marks)."' readonly='readonly' style='width:60px;' ></td><td><input type='text' name='mm_".esc_html($i)."' value='".esc_html($selectd_row1->min_pass)."' readonly='readonly' style='width:60px;' ></td><td> <input type='text' name='om_".esc_html($i)."' style='width:60px;'/></td></tr>"; 26 if(isset($selectd_rowm[0]->marks)) 27 { 28 $select_marks = unserialize($selectd_rowm[0]->marks); 29 $ob_mks = $select_marks["om_".$i]; 30 } 31 else 32 $ob_mks = " "; 33 echo "<tr><td>".esc_html($i)."</td><td>".esc_html(ucfirst($selectd_row1->sub_name))."</td><td><input type='text' name='tm_".esc_html($i)."' value='".esc_html($selectd_row1->total_marks)."' readonly='readonly' style='width:60px;' ></td><td><input type='text' name='mm_".esc_html($i)."' value='".esc_html($selectd_row1->min_pass)."' readonly='readonly' style='width:60px;' ></td><td> <input type='text' name='om_".esc_html($i)."' style='width:60px;' value='".esc_html($ob_mks)."'/></td></tr>"; 21 34 $i++; 22 35 } 23 36 ?> 24 <tr><td colspan='5'><center><button type="submit" class='btn btn-info'> Add Marks Now !!!</button></center></td>37 <tr><td colspan='5'><center><button type="submit" class='btn btn-info'><?php echo esc_html($text); ?></button></center></td> 25 38 </table> 26 39 <?php … … 63 76 foreach($select_data2 as $select_data2) 64 77 { 78 $selectd_rowm = $wpdb->get_results($wpdb->prepare("select * from `emarksheet_marks` where `student_id`='$select_data2->id'")); 79 //print_r($selectd_rowm); 80 if(isset($selectd_rowm[0])) 81 $text = "Update Marks !!!"; 82 else 83 $text = "Add Marks !!!"; 65 84 ?> 66 85 <tr><td> … … 68 87 echo esc_html($i); 69 88 ?> 70 </td><td><?php echo esc_html($select_data2->roll_no)."</td><td>".esc_html($select_data2->first_n)." ".esc_html($select_data2->last_n)."</td><td>".esc_html($select_data2->father_n)."</td><td>".esc_html($select_data2->mother_n)."</td><td>".esc_html($select_data2->dob_date)."-".esc_html($select_data2->dob_month)."-".esc_html($select_data2->dob_year)."</td><td><a href='".esc_url(admin_url("admin.php?page=eMarksheet-add-marks&action=add_marks&id=$select_data2->id"))."' class='btn btn-danger'><i class='icon-white icon-plus'></i> Add Marks</a></td></tr>";89 </td><td><?php echo esc_html($select_data2->roll_no)."</td><td>".esc_html($select_data2->first_n)." ".esc_html($select_data2->last_n)."</td><td>".esc_html($select_data2->father_n)."</td><td>".esc_html($select_data2->mother_n)."</td><td>".esc_html($select_data2->dob_date)."-".esc_html($select_data2->dob_month)."-".esc_html($select_data2->dob_year)."</td><td><a href='".esc_url(admin_url("admin.php?page=eMarksheet-add-marks&action=add_marks&id=$select_data2->id"))."' class='btn btn-danger'><i class='icon-white icon-plus'></i> ". esc_html($text)."</a></td></tr>"; 71 90 $i++; 72 91 } -
emarksheet/trunk/menu-pages/uninstall.php
r3265698 r3265798 3 3 { 4 4 global $wpdb; 5 $wpdb->query("DROP table `emarksheet_class`"); 5 $wpdb->query("DROP table `emarksheet_class`"); //db call ok; no-cache ok 6 6 7 $wpdb->query("DROP table `emarksheet_marks`"); 7 $wpdb->query("DROP table `emarksheet_marks`"); //db call ok; no-cache ok 8 8 9 $wpdb->query("DROP table `emarksheet_setting`"); 9 $wpdb->query("DROP table `emarksheet_setting`"); //db call ok; no-cache ok 10 10 11 $wpdb->query("DROP table `emarksheet_student`"); 11 $wpdb->query("DROP table `emarksheet_student`"); //db call ok; no-cache ok 12 12 13 $wpdb->query("DROP table `emarksheet_subject`"); 13 $wpdb->query("DROP table `emarksheet_subject`"); //db call ok; no-cache ok 14 14 15 15 $plugin = "eMarksheet/emarksheet.php";
Note: See TracChangeset
for help on using the changeset viewer.