예제 #1
0
파일: editTest.php 프로젝트: g7o/sqw
     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");
     break;
 case 22:
     search($connection, "SELECT * FROM notice WHERE title LIKE '%{$textInput}%'", "notice");
     break;
 case 23:
     search($connection, "SELECT * FROM notice WHERE category LIKE '%{$textInput}%' OR UserID LIKE '%{$textInput}%'", "notice");
     break;
 case 24:
     search($connection, "SELECT * FROM notice WHERE UserID LIKE '%{$textInput}%'", "notice");
예제 #2
0
파일: edit.php 프로젝트: g7o/sqw
     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");
     break;
 case 25:
     showEditNoticeForm($id, $active);
     break;
 case 26:
     setActiveNotice($connection, $id, $active);
     break;
 case 30:
     delete($connection, "DELETE FROM rating WHERE ID='{$textInput}'", "rating", "ID", $textInput);