090720.php
1.76 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
<?php
/** @deprecated 100325 @f
* Hinfällig da default mäßig die Funktionen bei einem update neu geschrieben werden @
*
*/
//$var_query = 'DROP FUNCTION IF EXISTS removeMTextFromClipboard';
//
//echo "\t".$var_query.";\t";
//$Resource = $DB->PDO_query($var_query);
//if($Resource) {
// echo "OK \n";
//} else {
// echo "FEHLER \n";
//}
//
//
//$var_query = 'CREATE FUNCTION removeMTextFromClipboard(param_RequestProfileID int, param_PartOfID int, param_AttachID int, param_PartOfObjVar varchar(128), param_CategoryName varchar(128))
// RETURNS INT
// DETERMINISTIC
// BEGIN
// DECLARE var_PartOfObjVarID INT;
// DECLARE var_tmp_ID INT;
// DECLARE var_CategoryID INT;
// set var_PartOfObjVarID=(select PartOfObjVarID from losp_BasisClipboard_objvar where PartOfObjVar=param_PartOfObjVar);
// set var_CategoryID=(select CategoryID from losp_BasisClipboard_category where CategoryName=param_CategoryName);
// call checkBEAuth(param_PartOfID,param_RequestProfileID,@r,@var_Profile_PartOf_w);
// call checkBEAuth(param_AttachID,param_RequestProfileID,@r,@var_Profile_Attach_w);
//
// IF (@var_Profile_PartOf_w || @var_Profile_Attach_w) THEN
// set var_tmp_ID=(select PartOfID from losp_BasisClipboard WHERE PartOfID=param_PartOfID and AttachID=param_AttachID and PartOfObjVarID=var_PartOfObjVarID and CategoryID=var_CategoryID);
// IF (var_tmp_ID>=0) THEN
// DELETE FROM losp_BasisClipboard
// WHERE PartOfID=param_PartOfID
// and AttachID=param_AttachID
// and CategoryID=var_CategoryID
// and PartOfObjVarID=var_PartOfObjVarID;
// return 1;
// END IF;
// END IF;
// return 0;
// END';
//
//echo "\t".substr($var_query, 0, 100)." ...;\t";
//$Resource = $DB->PDO_query($var_query);
//if($Resource) {
// echo "OK \n";
//} else {
// echo "FEHLER \n";
//}
?>