Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- *** jQuery.js ***
- $(document).ready(function() {
- $(".wrench").click(function() {
- var anchor = $(this).attr("id").split("-");
- var span = $("#span-" + anchor[1]);
- var textBox = $("#text-" + anchor[2]);
- var userID = anchor[3];
- var type = anchor[4];
- $.getJSON('../admin_click_update_db.php', {
- 'text': textBox.val(),
- 'UID': userID,
- 'type': type
- }, function(data) {
- if (data.error == false) {
- if (span.text() == 1) {
- span.text(0);
- } else {
- span.text(1);
- }
- } else {
- alert(data.errorMessage);
- }
- });
- });
- $(".textBox").change(function() {
- var id = $(this).attr("id").split("-");
- var val = $(this).val();
- $.getJSON('../admin_field_update_db.php', {
- }
- });
- });
- *** ADMIN_CLICK_UPDATE_DB.PHP ***
- <?PHP
- $data = array(); $data['error'] = false; $data['change'] = false;
- if(isset($_GET['param1']) && isset($_GET['param2']) && isset($_GET['param3'])) {
- $data['change'] = true;
- $UID = mysql_real_escape_string($_GET['UID']);
- $type = mysql_real_escape_string($_GET['type']);
- $text = mysql_real_escape_string($_GET['text']);
- if($type == 0) {
- $new = 1;
- $query = mysql_query("SELECT activated FROM JQtest WHERE ID = '$UID'" );
- if(mysql_result($query,0) == 1){
- $new = 0;
- }
- } elseif($type == 1) {
- $new = 1;
- $query = mysql_query("SELECT disabled FROM JQtest WHERE ID = '$UID'" );
- if(mysql_result($query,0) == 1){
- $new = 0;
- }
- $query = mysql_query("UPDATE `JQtest` SET disabled='$new' WHERE username='$UID' ");
- if(!$query){
- $data['error'] = true;
- $data['errorMessage'] = mysql_error();
- } else {
- $data['error'] = false;
- }
- } else {
- $data['error'] = true;
- }
- echo json_encode($data);
- }
- ?>
Add Comment
Please, Sign In to add comment