PageRenderTime 51ms CodeModel.GetById 20ms RepoModel.GetById 0ms app.codeStats 0ms

/appLms/modules/link/link.php

https://github.com/wanadli75/cocalms
PHP | 495 lines | 397 code | 68 blank | 30 comment | 21 complexity | 647e30cc9fe65783460f5a4c051f3ad3 MD5 | raw file
Possible License(s): GPL-2.0, CC-BY-3.0 
    

  1. <?php defined("IN_FORMA") or die('Direct access is forbidden.');

    2. 

  2. 

    3. 

  3. /* ======================================================================== \

    4. 

  4. |   FORMA - The E-Learning Suite                                            |

    5. 

  5. |                                                                           |

    6. 

  6. |   Copyright (c) 2013 (Forma)                                              |

    7. 

  7. |   http://www.formalms.org                                                 |

    8. 

  8. |   License  http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt           |

    9. 

  9. |                                                                           |

    10. 

  10. |   from docebo 4.0.5 CE 2008-2012 (c) docebo                               |

    11. 

  11. |   License http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt            |

    12. 

  12. \ ======================================================================== */

    13. 

  13. 

    14. 

  14. if(!Docebo::user()->isAnonymous()) {

    15. 

  15. 

    16. 

  16. // XXX: modlinkgui

    17. 

  17. function modlinkgui( $object_link ) {

    18. 

  18. 	checkPerm('view', false, 'storage');

    19. 

  19. 	$lang =& DoceboLanguage::createInstance('link');

    20. 

  20. 	

    21. 

  21. 	require_once(_base_.'/lib/lib.table.php');

    22. 

  22. 	$del_perm = checkPerm('view', false, 'storage');

    23. 

  23. 	

    24. 

  24. 	$back_coded = htmlentities(urlencode($object_link->back_url));

    25. 

  25. 	

    26. 

  26. 	$textQuery = "

    27. 

  27. 	SELECT idLink, title, link_address, sequence 

    28. 

  28. 	FROM ".$GLOBALS['prefix_lms']."_link 

    29. 

  29. 	WHERE idCategory = '".$object_link->getId()."' 

    30. 

  30. 	ORDER BY sequence";

    31. 

  31. 	$result = sql_query($textQuery);

    32. 

  32. 	$num_link = mysql_num_rows($result);

    33. 

  33. 	

    34. 

  34. 	list($title_cat) = sql_fetch_row(sql_query("

    35. 

  35. 	SELECT title

    36. 

  36. 	FROM ".$GLOBALS['prefix_lms']."_link_cat 

    37. 

  37. 	WHERE idCategory = '".$object_link->getId()."'"));

    38. 

  38. 	

    39. 

  39. 	$GLOBALS['page']->add(getTitleArea($lang->def('_SECT_LINK'), 'link')

    40. 

  40. 		.'<div class="std_block">'		

    41. 

  41. 		.getBackUi( Util::str_replace_once('&', '&amp;', $object_link->back_url).'&amp;mod_result=0', $lang->def('_BACK') )

    42. 

  42. 		

    43. 

  43. 		.'<b>'.$lang->def('_TITLE').' : '.$title_cat.'</b><br /><br />'

    44. 

  44. 		.'<div class="mod_container">'

    45. 

  45. 		.'<a href="index.php?modname=link&amp;op=modlinkcat&amp;idCategory='.$object_link->getId()

    46. 

  46. 			.'&amp;back_url='.$back_coded.'" title="'.$lang->def('_MOD_TITLE').'">'

    47. 

  47. 		.'<img src="'.getPathImage().'standard/edit.png" alt="'.$lang->def('_MOD').'" /> '.$lang->def('_MOD_TITLE').'</a>'

    48. 

  48. 		.'</div><br />', 'content');

    49. 

  49. 	$tableCat = new Table(0, '', $lang->def('_SUMMARY_LINK'));

    50. 

  50. 	

    51. 

  51. 	$contentH = array($lang->def('_QUESTION'), $lang->def('_URL'), 

    52. 

  52. 		'<img src="'.getPathImage().'standard/down.png" alt="'.$lang->def('_DOWN').'" title="'.$lang->def('_MOVE_DOWN').'" />',

    53. 

  53. 		'<img src="'.getPathImage().'standard/up.png" alt="'.$lang->def('_UP').'" title="'.$lang->def('_MOVE_UP').'" />',

    54. 

  54. 		'<img src="'.getPathImage().'standard/edit.png" alt="'.$lang->def('_MOD').'" title="'.$lang->def('_MOD').'" />',

    55. 

  55. 		'<img src="'.getPathImage().'standard/delete.png" alt="'.$lang->def('_DEL').'" title="'.$lang->def('_DEL').'" />');

    56. 

  56. 	$typeH = array('', 'image', 'image', 'image', 'image', 'image');

    57. 

  57. 	$tableCat->setColsStyle($typeH);

    58. 

  58. 	$tableCat->addHead($contentH);

    59. 

  59. 	

    60. 

  60. 	$i = 1;

    61. 

  61. 	while(list($idLink, $title, $link_address, $seq) = sql_fetch_row($result)) {

    62. 

  62. 		$rowContent = array($seq.') '.$title, $link_address);

    63. 

  63. 		if($i != $num_link) {

    64. 

  64. 			$rowContent[] = '<a href="index.php?modname=link&amp;op=movedown&amp;idLink='

    65. 

  65. 				.$idLink.'&amp;back_url='.$back_coded.'">'

    66. 

  66. 				.'<img src="'.getPathImage().'standard/down.png" alt="'.$lang->def('_DOWN').'" title="'.$lang->def('_MOVE_DOWN').'" /></a>';

    67. 

  67. 		}

    68. 

  68. 		else $rowContent[] = '&nbsp;';

    69. 

  69. 		if($i != 1){

    70. 

  70. 			$rowContent[] = '<a href="index.php?modname=link&amp;op=moveup&amp;idLink='

    71. 

  71. 				.$idLink.'&amp;back_url='.$back_coded.'">'

    72. 

  72. 				.'<img src="'.getPathImage().'standard/up.png" alt="'.$lang->def('_UP').'" title="'.$lang->def('_MOVE_UP').'" /></a>';

    73. 

  73. 		}

    74. 

  74. 		else $rowContent[] = '&nbsp;';

    75. 

  75. 		$rowContent[] = '<a href="index.php?modname=link&amp;op=modlink&amp;idLink='

    76. 

  76. 			.$idLink.'&amp;back_url='.$back_coded.'">'

    77. 

  77. 			.'<img src="'.getPathImage().'standard/edit.png" alt="'.$lang->def('_MOD').'" title="'.$lang->def('_MOD').'" /></a>';

    78. 

  78. 		$rowContent[] = '<a href="index.php?modname=link&amp;op=dellink&amp;idLink='

    79. 

  79. 				.$idLink.'&amp;back_url='.$back_coded.'">'

    80. 

  80. 				.'<img src="'.getPathImage().'standard/delete.png" alt="'.$lang->def('_DEL').'" title="'.$lang->def('_DEL').'" /></a>';

    81. 

  81. 		

    82. 

  82. 		$tableCat->addBody($rowContent);

    83. 

  83. 		++$i;

    84. 

  84. 	}

    85. 

  85. 	

    86. 

  86. 	$tableCat->addActionAdd('<a href="index.php?modname=link&amp;op=newlink&amp;idCategory='

    87. 

  87. 			.$object_link->getId().'&amp;back_url='.$back_coded.'" title="'.$lang->def('_ADDLINKT').'">'

    88. 

  88. 			.'<img src="'.getPathImage().'standard/add.png" alt="'.$lang->def('_ADD').'" /> '.$lang->def('_ADDLINK').'</a>');

    89. 

  89. 	

    90. 

  90. 	$GLOBALS['page']->add($tableCat->getTable()

    91. 

  91. 		.'<span class="text_bold text_little">[ '

    92. 

  92. 		.'<a href="index.php?modname=link&amp;op=fixsequence&amp;idCategory='.$object_link->getId()

    93. 

  93. 			.'&amp;back_url='.$back_coded.'">'.$lang->def('_FIX_SEQUENCE').'</a>'

    94. 

  94. 		.' ]</span>'

    95. 

  95. 		.'</div>', 'content');

    96. 

  96. }

    97. 

  97. 

    98. 

  98. // XXX: addlinkcat

    99. 

  99. function addlinkcat( $object_link ) {

    100. 

  100. 	checkPerm('view', false, 'storage');

    101. 

  101. 	$lang =& DoceboLanguage::createInstance('link');

    102. 

  102. 	require_once(_base_.'/lib/lib.form.php');

    103. 

  103. 	$GLOBALS['page']->add(getTitleArea($lang->def('_SECT_LINK'), 'link')

    104. 

  104. 		.'<div class="std_block">'

    105. 

  105. 		.Form::openForm('faqform', 'index.php?modname=link&amp;op=inslinkcat')

    106. 

  106. 		.Form::openElementSpace()

    107. 

  107. 		.Form::getHidden('back_url', 'back_url', htmlentities(urlencode($object_link->back_url)))

    108. 

  108. 		

    109. 

  109. 		.Form::getTextfield($lang->def('_TITLE'), 'title', 'title', 255, $lang->def('_TITLE'))

    110. 

  110. 		.Form::getTextarea($lang->def('_DESCRIPTION'), 'description', 'description', $lang->def('_DESCRIPTION'))

    111. 

  111. 		.Form::closeElementSpace()

    112. 

  112. 		.Form::openButtonSpace()

    113. 

  113. 		.Form::getButton('addlinkcat', 'addlinkcat', $lang->def('_INSERT'))

    114. 

  114. 		.Form::closeButtonSpace()

    115. 

  115. 		.Form::closeForm()

    116. 

  116. 		.'</div>', 'content');

    117. 

  117. }

    118. 

  118. 

    119. 

  119. // XXX: inslinkcat

    120. 

  120. function inslinkcat() {

    121. 

  121. 	checkPerm('view', false, 'storage');

    122. 

  122. 	$lang =& DoceboLanguage::createInstance('link');

    123. 

  123. 	

    124. 

  124. 	$back_url = urldecode($_POST['back_url']);

    125. 

  125. 	

    126. 

  126. 	$query_ins = "

    127. 

  127. 	INSERT INTO ".$GLOBALS['prefix_lms']."_link_cat

    128. 

  128. 	SET title = '".( (trim($_POST['title']) == '') ? $lang->def('_NOTITLE') : $_POST['title'])."',

    129. 

  129. 		description = '".$_POST['description']."',

    130. 

  130. 		author = '".(int)getLogUserId()."'";

    131. 

  131. 	if(!sql_query($query_ins)) {

    132. 

  132. 		$_SESSION['last_error'] = $lang->def('_OPERATION_FAILURE');

    133. 

  133. 		Util::jump_to( ''.$back_url.'&create_result=0');

    134. 

  134. 	}

    135. 

  135. 	list($idLink) = sql_fetch_row(sql_query("SELECT LAST_INSERT_ID()"));

    136. 

  136. 	Util::jump_to( ''.$back_url.'&id_lo='.$idLink.'&create_result=1');

    137. 

  137. }

    138. 

  138. 

    139. 

  139. // XXX: modlinkcat

    140. 

  140. function modlinkcat() {

    141. 

  141. 	checkPerm('view', false, 'storage');

    142. 

  142. 	$lang =& DoceboLanguage::createInstance('link');

    143. 

  143. 	require_once(_base_.'/lib/lib.form.php');

    144. 

  144. 	$idCategory = importVar('idCategory', true, 0);

    145. 

  145. 	$back_url = urldecode(importVar('back_url'));

    146. 

  146. 	$back_coded = htmlentities(urlencode($back_url));

    147. 

  147. 	

    148. 

  148. 	list($title, $descr) = sql_fetch_row(sql_query("

    149. 

  149. 	SELECT title, description

    150. 

  150. 	FROM ".$GLOBALS['prefix_lms']."_link_cat 

    151. 

  151. 	WHERE idCategory = '".$idCategory."'"));

    152. 

  152. 	

    153. 

  153. 	$GLOBALS['page']->add(getTitleArea($lang->def('_SECT_LINK'), 'link')

    154. 

  154. 		.'<div class="std_block">'

    155. 

  155. 		.getBackUi( 'index.php?modname=link&amp;op=modlinkgui&amp;idCategory='

    156. 

  156. 			.$idCategory.'&amp;back_url='.$back_coded, $lang->def('_BACK'))

    157. 

  157. 		

    158. 

  158. 		.Form::openForm('faqform', 'index.php?modname=link&amp;op=uplinkcat')

    159. 

  159. 		.Form::openElementSpace()

    160. 

  160. 		.Form::getHidden('idCategory', 'idCategory', $idCategory)

    161. 

  161. 		.Form::getHidden('back_url', 'back_url', $back_coded)

    162. 

  162. 		

    163. 

  163. 		.Form::getTextfield($lang->def('_TITLE'), 'title', 'title', 255, $title)

    164. 

  164. 		.Form::getTextarea($lang->def('_DESCRIPTION'), 'description', 'description', $descr)

    165. 

  165. 		.Form::closeElementSpace()

    166. 

  166. 		.Form::openButtonSpace()

    167. 

  167. 		.Form::getButton('addlinkcat', 'addlinkcat', $lang->def('_SAVE'))

    168. 

  168. 		.Form::closeButtonSpace()

    169. 

  169. 		.Form::closeForm()

    170. 

  170. 		.'</div>', 'content');

    171. 

  171. }

    172. 

  172. 

    173. 

  173. // XXX: uplinkcat

    174. 

  174. function uplinkcat() {

    175. 

  175. 	checkPerm('view', false, 'storage');

    176. 

  176. 	$lang =& DoceboLanguage::createInstance('link');

    177. 

  177. 	

    178. 

  178. 	$back_url = urldecode(importVar('back_url'));

    179. 

  179. 	$back_coded = htmlentities(urlencode($back_url));

    180. 

  180. 	

    181. 

  181. 	$query_ins = "

    182. 

  182. 	UPDATE ".$GLOBALS['prefix_lms']."_link_cat

    183. 

  183. 	SET title = '".( (trim($_POST['title']) == '') ? $lang->def('_NOTITLE') : $_POST['title'])."',

    184. 

  184. 		description = '".$_POST['description']."' 

    185. 

  185. 	WHERE idCategory = '".(int)$_POST['idCategory']."'";

    186. 

  186. 	if(!sql_query($query_ins)) {

    187. 

  187. 		$GLOBALS['page']->add(getErrorUi($lang->def('_OPERATION_FAILURE')

    188. 

  188. 						.getBackUi('index.php?modname=link&op=modlinkgui&idCategory='

    189. 

  189. 						.(int)$_POST['idCategory'].'&back_url='.$back_coded, $lang->def('_BACK'))), 'content');

    190. 

  190. 		return;

    191. 

  191. 	}

    192. 

  192. 	

    193. 

  193. 	require_once($GLOBALS['where_lms'].'/class.module/track.object.php');

    194. 

  194. 	Track_Object::updateObjectTitle($_POST['idCategory'], 'link', $_POST['title']);

    195. 

  195. 	

    196. 

  196. 	Util::jump_to( 'index.php?modname=link&op=modlinkgui&idCategory='.(int)$_POST['idCategory'].'&back_url='.$back_coded);

    197. 

  197. }

    198. 

  198. 

    199. 

  199. // XXX: movelink

    200. 

  200. function movelink($direction) {

    201. 

  201. 	checkPerm('view', false, 'storage');

    202. 

  202. 	

    203. 

  203. 	$back_url = urldecode( $_GET['back_url'] );

    204. 

  204. 	$back_coded = htmlentities(urlencode( $back_url ));

    205. 

  205. 	

    206. 

  206. 	list($idCategory, $seq) = sql_fetch_row(sql_query("

    207. 

  207. 	SELECT idCategory, sequence

    208. 

  208. 	FROM ".$GLOBALS['prefix_lms']."_link 

    209. 

  209. 	WHERE idLink = '".(int)$_GET['idLink']."'"));

    210. 

  210. 	

    211. 

  211. 	if($direction == 'up') {

    212. 

  212. 		if($seq == 0) return;

    213. 

  213. 		sql_query("

    214. 

  214. 		UPDATE ".$GLOBALS['prefix_lms']."_link 

    215. 

  215. 		SET sequence = '$seq' 

    216. 

  216. 		WHERE idCategory = '".$idCategory."' AND sequence = '".($seq - 1)."'");

    217. 

  217. 		sql_query("

    218. 

  218. 		UPDATE ".$GLOBALS['prefix_lms']."_link 

    219. 

  219. 		SET sequence = sequence - 1 

    220. 

  220. 		WHERE idLink = '".(int)$_GET['idLink']."'");

    221. 

  221. 		

    222. 

  222. 	}

    223. 

  223. 	if($direction == 'down') {

    224. 

  224. 		sql_query("

    225. 

  225. 		UPDATE ".$GLOBALS['prefix_lms']."_link 

    226. 

  226. 		SET sequence = '$seq' 

    227. 

  227. 		WHERE idCategory = '".$idCategory."' AND sequence = '".($seq + 1)."'");

    228. 

  228. 		sql_query("

    229. 

  229. 		UPDATE ".$GLOBALS['prefix_lms']."_link 

    230. 

  230. 		SET sequence = '".($seq + 1)."' 

    231. 

  231. 		WHERE idLink = '".(int)$_GET['idLink']."'");

    232. 

  232. 	}

    233. 

  233. 	Util::jump_to( 'index.php?modname=link&op=modlinkgui&idCategory='.$idCategory.'&back_url='.$back_coded);

    234. 

  234. }

    235. 

  235. 

    236. 

  236. // XXX: fixsequence

    237. 

  237. function fixsequence() {

    238. 

  238. 	checkPerm('view', false, 'storage');

    239. 

  239. 	

    240. 

  240. 	$back_url = urldecode( $_GET['back_url'] );

    241. 

  241. 	$back_coded = htmlentities(urlencode( $back_url ));

    242. 

  242. 	

    243. 

  243. 	$reQuest = sql_query("

    244. 

  244. 	SELECT idLink

    245. 

  245. 	FROM ".$GLOBALS['prefix_lms']."_link 

    246. 

  246. 	WHERE idCategory = '".(int)$_GET['idCategory']."'

    247. 

  247. 	ORDER BY sequence");

    248. 

  248. 	

    249. 

  249. 	$i = 1;

    250. 

  250. 	while(list($idLink) = sql_fetch_row($reQuest)) {

    251. 

  251. 		sql_query("

    252. 

  252. 		UPDATE ".$GLOBALS['prefix_lms']."_link 

    253. 

  253. 		SET sequence = '".($i++)."' 

    254. 

  254. 		WHERE idLink = '$idLink'");

    255. 

  255. 	}

    256. 

  256. 	

    257. 

  257. 	Util::jump_to( 'index.php?modname=link&op=modlinkgui&idCategory='.$_GET['idCategory'].'&back_url='.$back_coded);

    258. 

  258. }

    259. 

  259. 

    260. 

  260. // XXX: newlink

    261. 

  261. function newlink() {

    262. 

  262. 	checkPerm('view', false, 'storage');

    263. 

  263. 	$lang =& DoceboLanguage::createInstance('link');

    264. 

  264. 	

    265. 

  265. 	require_once(_base_.'/lib/lib.form.php');

    266. 

  266. 	

    267. 

  267. 	$idCategory = importVar('idCategory', true, 0);

    268. 

  268. 	$back_url = urldecode(importVar('back_url'));

    269. 

  269. 	$back_coded = htmlentities(urlencode($back_url));

    270. 

  270. 	

    271. 

  271. 	

    272. 

  272. 	$GLOBALS['page']->add(getTitleArea($lang->def('_SECT_LINK'), 'link')

    273. 

  273. 		.'<div class="std_block">'

    274. 

  274. 		.getBackUi('index.php?modname=link&op=modlinkgui&idCategory='

    275. 

  275. 			.$idCategory.'&back_url='.$back_coded, $lang->def('_BACK'))

    276. 

  276. 		

    277. 

  277. 		.Form::openForm('faqform', 'index.php?modname=link&amp;op=inslink')

    278. 

  278. 		.Form::openElementSpace()

    279. 

  279. 		.Form::getHidden('idCategory', 'idCategory', $idCategory)

    280. 

  280. 		.Form::getHidden('back_url', 'back_url', $back_coded)

    281. 

  281. 		

    282. 

  282. 		.Form::getTextfield($lang->def('_TITLE'), 'title', 'title', 255, $lang->def('_TITLE'))

    283. 

  283. 		.Form::getTextfield($lang->def('_LINK_ADDRESS'), 'link_a', 'link_a', 255, 'http://')

    284. 

  284. 		.Form::getSimpleTextarea($lang->def('_KEYWORD'), 'keyword', 'keyword', $lang->def('_KEYWORD'))

    285. 

  285. 		.Form::getTextarea($lang->def('_DESCRIPTION'), 'description', 'description', $lang->def('_DESCRIPTION'))

    286. 

  286. 		.Form::closeElementSpace()

    287. 

  287. 		.Form::openButtonSpace()

    288. 

  288. 		.Form::getButton('addlink', 'addlink', $lang->def('_INSERT'))

    289. 

  289. 		.Form::closeButtonSpace()

    290. 

  290. 		.Form::closeForm()

    291. 

  291. 		.'</div>', 'content');

    292. 

  292. }

    293. 

  293. 

    294. 

  294. // XXX: inslink

    295. 

  295. function inslink() {

    296. 

  296. 	checkPerm('view', false, 'storage');

    297. 

  297. 	$lang =& DoceboLanguage::createInstance('link');

    298. 

  298. 	

    299. 

  299. 	$idCategory = importVar('idCategory', true, 0);

    300. 

  300. 	$back_url = urldecode(importVar('back_url'));

    301. 

  301. 	$back_coded = htmlentities(urlencode($back_url));

    302. 

  302. 	

    303. 

  303. 	list($seq) = sql_fetch_row(sql_query("

    304. 

  304. 	SELECT MAX(sequence)

    305. 

  305. 	FROM ".$GLOBALS['prefix_lms']."_link 

    306. 

  306. 	WHERE idCategory = '".$idCategory."'"));

    307. 

  307. 	

    308. 

  308. 	$query_ins = "

    309. 

  309. 	INSERT INTO ".$GLOBALS['prefix_lms']."_link

    310. 

  310. 	SET idCategory = '".$idCategory."',

    311. 

  311. 		title = '".$_POST['title']."',

    312. 

  312. 		link_address = '".$_POST['link_a']."',

    313. 

  313. 		keyword = '".$_POST['keyword']."',

    314. 

  314. 		description = '".$_POST['description']."',

    315. 

  315. 		sequence = '".($seq + 1)."'";

    316. 

  316. 	if(!sql_query($query_ins)) {

    317. 

  317. 		$GLOBALS['page']->add(getErrorUi($lang->def('_OPERATION_FAILURE')

    318. 

  318. 			.getBackUi('index.php?modname=link&op=modlinkgui&idCategory='

    319. 

  319. 			.$idCategory.'&back_url='.$back_coded, $lang->def('_BACK'))), 'content');

    320. 

  320. 		return;

    321. 

  321. 	}

    322. 

  322. 	Util::jump_to( 'index.php?modname=link&op=modlinkgui&idCategory='.$idCategory.'&back_url='.$back_coded);

    323. 

  323. }

    324. 

  324. //DEBUG: arrivato qui

    325. 

  325. // XXX: modlink

    326. 

  326. function modlink() {

    327. 

  327. 	checkPerm('view', false, 'storage');

    328. 

  328. 	$lang =& DoceboLanguage::createInstance('link');

    329. 

  329. 	require_once(_base_.'/lib/lib.form.php');

    330. 

  330. 	$back_url = urldecode($_GET['back_url']);

    331. 

  331. 	$back_coded = htmlentities(urlencode( $back_url ));

    332. 

  332. 	

    333. 

  333. 	list($idCategory, $title, $link_a, $keyword, $description) = sql_fetch_row(sql_query("

    334. 

  334. 	SELECT idCategory, title, link_address, keyword, description 

    335. 

  335. 	FROM ".$GLOBALS['prefix_lms']."_link 

    336. 

  336. 	WHERE idLink = '".(int)$_GET['idLink']."'"));

    337. 

  337. 	

    338. 

  338. 	$GLOBALS['page']->add(getTitleArea($lang->def('_SECT_LINK'), 'link')

    339. 

  339. 		.'<div class="std_block">'

    340. 

  340. 		.getBackUi('index.php?modname=link&op=modlinkgui&idCategory='

    341. 

  341. 			.$idCategory.'&back_url='.$back_coded, $lang->def('_BACK'))

    342. 

  342. 		

    343. 

  343. 		.Form::openForm('faqform', 'index.php?modname=link&amp;op=uplink')

    344. 

  344. 		.Form::openElementSpace()

    345. 

  345. 		.Form::getHidden('idLink', 'idLink', $_GET['idLink'])

    346. 

  346. 		.Form::getHidden('back_url', 'back_url', $back_coded)

    347. 

  347. 		

    348. 

  348. 		.Form::getTextfield($lang->def('_TITLE'), 'title', 'title', 255, $title)

    349. 

  349. 		.Form::getTextfield($lang->def('_LINK_ADDRESS'), 'link_a', 'link_a', 255, $link_a)

    350. 

  350. 		.Form::getSimpleTextarea($lang->def('_KEYWORD'), 'keyword', 'keyword', $keyword)

    351. 

  351. 		.Form::getTextarea($lang->def('_DESCRIPTION'), 'description', 'description', $description)

    352. 

  352. 		.Form::closeElementSpace()

    353. 

  353. 		.Form::openButtonSpace()

    354. 

  354. 		.Form::getButton('modlink', 'modlink', $lang->def('_SAVE'))

    355. 

  355. 		.Form::closeButtonSpace()

    356. 

  356. 		.Form::closeForm()

    357. 

  357. 		.'</div>', 'content');

    358. 

  358. }

    359. 

  359. 

    360. 

  360. // XXX: uplink

    361. 

  361. function uplink() {

    362. 

  362. 	checkPerm('view', false, 'storage');

    363. 

  363. 	$lang =& DoceboLanguage::createInstance('link');

    364. 

  364. 	

    365. 

  365. 	$back_url = urldecode($_POST['back_url']);

    366. 

  366. 	$back_coded = htmlentities(urlencode( $back_url ));	

    367. 

  367. 	

    368. 

  368. 	list($idCategory) = sql_fetch_row(sql_query("

    369. 

  369. 	SELECT idCategory 

    370. 

  370. 	FROM ".$GLOBALS['prefix_lms']."_link 

    371. 

  371. 	WHERE idLink = '".(int)$_POST['idLink']."'"));

    372. 

  372. 	

    373. 

  373. 	$query_ins = "

    374. 

  374. 	UPDATE ".$GLOBALS['prefix_lms']."_link

    375. 

  375. 	SET title = '".$_POST['title']."',

    376. 

  376. 		link_address = '".$_POST['link_a']."',

    377. 

  377. 		keyword = '".$_POST['keyword']."',

    378. 

  378. 		description = '".$_POST['description']."'

    379. 

  379. 	WHERE idLink = '".(int)$_POST['idLink']."'";

    380. 

  380. 	if(!sql_query($query_ins)) {

    381. 

  381. 		$GLOBALS['page']->add(getErrorUi($lang->def('_OPERATION_FAILURE')

    382. 

  382. 			.getBackUi('index.php?modname=link&op=modlinkgui&idCategory='

    383. 

  383. 			.$idCategory.'&back_url='.$back_coded, $lang->def('_BACK'))), 'content');

    384. 

  384. 		return;

    385. 

  385. 	}

    386. 

  386. 	Util::jump_to( 'index.php?modname=link&op=modlinkgui&idCategory='.$idCategory.'&back_url='.$back_coded);

    387. 

  387. }

    388. 

  388. 

    389. 

  389. // XXX: dellink

    390. 

  390. function dellink() {

    391. 

  391. 	checkPerm('view', false, 'storage');

    392. 

  392. 	$lang =& DoceboLanguage::createInstance('link');

    393. 

  393. 	

    394. 

  394. 	$back_url = urldecode($_GET['back_url']);

    395. 

  395. 	$back_coded = htmlentities(urlencode( $back_url ));	

    396. 

  396. 	

    397. 

  397. 	$GLOBALS['page']->add(getTitleArea($lang->def('_SECT_LINK'), 'link'), 'content');

    398. 

  398. 	if( isset($_GET['confirm']) ) {

    399. 

  399. 		list($idCategory, $seq) = sql_fetch_row(sql_query("

    400. 

  400. 		SELECT idCategory, sequence

    401. 

  401. 		FROM ".$GLOBALS['prefix_lms']."_link 

    402. 

  402. 		WHERE idLink = '".(int)$_GET['idLink']."'"));

    403. 

  403. 		

    404. 

  404. 		if(!sql_query("

    405. 

  405. 		DELETE FROM ".$GLOBALS['prefix_lms']."_link 

    406. 

  406. 		WHERE idLink  = '".(int)$_GET['idLink']."'")) {

    407. 

  407. 			$GLOBALS['page']->add(getErrorUi($lang->def('_OPERATION_FAILURELINK').getBackUi('index.php?modname=link&op=modlinkgui&idCategory='

    408. 

  408. 				.$idCategory.'&back_url='.$back_coded, $lang->def('_BACK'))), 'content');

    409. 

  409. 			return;

    410. 

  410. 		}

    411. 

  411. 		sql_query("

    412. 

  412. 		UPDATE ".$GLOBALS['prefix_lms']."_link 

    413. 

  413. 		SET sequence = sequence -1

    414. 

  414. 		WHERE sequence > '".$seq."'");

    415. 

  415. 		

    416. 

  416. 		Util::jump_to( 'index.php?modname=link&op=modlinkgui&idCategory='.$idCategory.'&back_url='.$back_coded);

    417. 

  417. 	}

    418. 

  418. 	else {

    419. 

  419. 		list($idCategory, $title, $link_a, $description) = sql_fetch_row(sql_query("

    420. 

  420. 		SELECT idCategory, title, link_address, description 

    421. 

  421. 		FROM ".$GLOBALS['prefix_lms']."_link 

    422. 

  422. 		WHERE idLink = '".(int)$_GET['idLink']."'"));

    423. 

  423. 		

    424. 

  424. 		$GLOBALS['page']->add('<div class="std_block">'

    425. 

  425. 			.getDeleteUi(	$lang->def('_AREYOUSURE'),

    426. 

  426. 							'<span>'.$lang->def('_TITLE').' : </span>'.$title.'<br />'

    427. 

  427. 								.'<span>'.$lang->def('_URL').' : </span>'.$link_a.'<br />'

    428. 

  428. 								.'<span>'.$lang->def('_DESCRIPTION').' : </span>'.$description, 

    429. 

  429. 							true, 

    430. 

  430. 							'index.php?modname=link&amp;op=dellink&amp;idLink='.$_GET['idLink'].'&amp;back_url='

    431. 

  431. 								.$back_coded.'&amp;confirm=1', 

    432. 

  432. 							'index.php?modname=link&amp;op=modlinkgui&amp;idCategory='.$idCategory.'&amp;back_url='

    433. 

  433. 								.$back_coded.''

    434. 

  434. 						)

    435. 

  435. 			.'</div>'

    436. 

  436. 			.'</div>', 'content');

    437. 

  437. 	}

    438. 

  438. }

    439. 

  439. 

    440. 

  440. // XXX: switch

    441. 

  441. if(isset($GLOBALS['op'])) switch($GLOBALS['op']) {

    442. 

  442. 	case "modlinkgui" : {

    443. 

  443. 		$idCategory = importVar('idCategory', true, 0);

    444. 

  444. 		$back_url = importVar('back_url');

    445. 

  445. 		

    446. 

  446. 		$object_link= createLO( 'link', $idCategory );

    447. 

  447. 		$object_link->edit( $idCategory, urldecode( $back_url ) );

    448. 

  448. 	};break;

    449. 

  449. 	//add category

    450. 

  450. 	case "addlinkcat" : {

    451. 

  451. 		addlinkcat();

    452. 

  452. 	};break;

    453. 

  453. 	case "inslinkcat" : {

    454. 

  454. 		inslinkcat();

    455. 

  455. 	};break;

    456. 

  456. 	//mod category

    457. 

  457. 	case "modlinkcat" : {

    458. 

  458. 		modlinkcat();

    459. 

  459. 	};break;

    460. 

  460. 	case "uplinkcat" : {

    461. 

  461. 		uplinkcat();

    462. 

  462. 	};break;

    463. 

  463. 	//mod

    464. 

  464. 	case "movedown" : {

    465. 

  465. 		movelink('down');

    466. 

  466. 	};break;

    467. 

  467. 	case "moveup" : {

    468. 

  468. 		movelink('up');

    469. 

  469. 	};break;

    470. 

  470. 	case "fixsequence" : {

    471. 

  471. 		fixsequence();

    472. 

  472. 	};break;

    473. 

  473. 	//add link

    474. 

  474. 	case "newlink" : {

    475. 

  475. 		newlink();

    476. 

  476. 	};break;

    477. 

  477. 	case "inslink" : {

    478. 

  478. 		inslink();

    479. 

  479. 	};break;

    480. 

  480. 	//mod link

    481. 

  481. 	case "modlink" : {

    482. 

  482. 		modlink();

    483. 

  483. 	};break;

    484. 

  484. 	case "uplink" : {

    485. 

  485. 		uplink();

    486. 

  486. 	};break;

    487. 

  487. 	//del link

    488. 

  488. 	case "dellink" : {

    489. 

  489. 		dellink();

    490. 

  490. 	};break;

    491. 

  491. }

    492. 

  492. 

    493. 

  493. }

    494. 

  494. 

    495. 

  495. ?>

    496. 

  496.