Esempio n. 1
0
File: editTest.php Progetto: g7o/sqw
     search($connection, "SELECT * FROM users WHERE username LIKE '%{$textInput}%' OR mail LIKE '%{$textInput}%'", "users");
     break;
 case 12:
     search($connection, "SELECT * FROM users WHERE username LIKE '%{$textInput}%'", "users");
     break;
 case 13:
     search($connection, "SELECT * FROM users WHERE mail LIKE '%{$textInput}%'", "users");
     break;
 case 14:
     changePassword($connection, $textInput, $password);
     break;
 case 15:
     setActive($connection, $textInput);
     break;
 case 16:
     upgradeAccount($connection, $textInput);
     break;
 case 17:
     addUser($connection, $firstname, $sirname, $username, $sex, $password, $tel, $mail, $geb, $plz, $country, $city, $street, $housenr, $picture, $isActivated, $isRetailer, $maximum);
     break;
 case 18:
     editUser($connection, $username, $mail);
     break;
 case 19:
     contactUser($connection, $firstname, $mail);
     break;
 case 20:
     delete($connection, "DELETE FROM notice WHERE ID='{$textInput}'", "notice", "ID", $textInput);
     break;
 case 21:
     search($connection, "SELECT * FROM notice WHERE title LIKE '%{$textInput}%' OR category LIKE '%{$textInput}%' OR UserID LIKE '%{$textInput}%'", "notice");
Esempio n. 2
0
File: edit.php Progetto: g7o/sqw
     delete($connection, "DELETE FROM users WHERE username='******'");
     break;
 case 11:
     search($connection, "SELECT * FROM users WHERE username LIKE '%{$textInput}%' OR mail LIKE '%{$textInput}%'", "users");
     break;
 case 12:
     changeUserNew($connection, $username, $mail, $active, $type, $maximum);
     break;
 case 14:
     changePassword($connection, $textInput, $password);
     break;
 case 15:
     setActive($connection, $username, $active);
     break;
 case 16:
     upgradeAccount($connection, $username, $type);
     break;
 case 17:
     updateMaximum($connection, $username, $maximum);
     break;
 case 18:
     editUser($connection, $username, $mail);
     break;
 case 19:
     contactUser($connection, $mail, $textInput, $subject);
     break;
 case 20:
     delete($connection, "DELETE FROM notice WHERE ID='{$textInput}'", "notice", "ID", $textInput);
     break;
 case 21:
     search($connection, "SELECT * FROM notice WHERE title LIKE '%{$textInput}%' OR category LIKE '%{$textInput}%' OR UserID LIKE '%{$textInput}%' or location LIKE '%{$textInput}%'", "notice");