projects
/
Pman.Core
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
fix #8131 - chinese translations
[Pman.Core]
/
mysql
/
core_translate_lookup.sql
1
2
DROP FUNCTION IF EXISTS core_translate_lookup;
3
4
DELIMITER $$
5
CREATE FUNCTION core_translate_lookup(
6
in_ontable VARCHAR(128),
7
in_onid INT(11),
8
in_col VARCHAR(128),
9
in_lang VARCHAR(8),
10
in_default TEXT
11
)
12
RETURNS TEXT NOT DETERMINISTIC READS SQL DATA
13
BEGIN
14
15
DECLARE v_ret TEXT;
16
DECLARE v_id INT(11);
17
18
SET v_id = 0;
19
20
SELECT
21
id , txt
22
INTO
23
v_id, v_ret
24
FROM
25
core_templatestr
26
WHERE
27
on_id = in_onid
28
AND
29
on_table = in_ontable
30
AND
31
on_col = in_col
32
AND
33
lang = in_lang
34
AND
35
active = 1
36
LIMIT 1;
37
38
IF v_id < 1 OR LENGTH(v_ret) < 1 THEN
39
RETURN in_default;
40
END IF;
41
42
RETURN v_ret;
43
44
END $$
45
46
DELIMITER ;