@@ -155,11 +155,11 @@ discard block |
||
| 155 | 155 | * |
| 156 | 156 | */ |
| 157 | 157 | function XoopsFormSpin($caption, $name, $value = 0, |
| 158 | - $min = 0, $max=100, |
|
| 159 | - $smallIncrement = 1, $largeIncrement = 10, |
|
| 160 | - $size = 5, $unite='', $imgFolder='default', |
|
| 161 | - $styleText = '', $styleBordure = '', |
|
| 162 | - $minMaxVisible = true) |
|
| 158 | + $min = 0, $max=100, |
|
| 159 | + $smallIncrement = 1, $largeIncrement = 10, |
|
| 160 | + $size = 5, $unite='', $imgFolder='default', |
|
| 161 | + $styleText = '', $styleBordure = '', |
|
| 162 | + $minMaxVisible = true) |
|
| 163 | 163 | { |
| 164 | 164 | $this->setName($name); |
| 165 | 165 | $this->setCaption($caption); |
@@ -192,7 +192,7 @@ discard block |
||
| 192 | 192 | */ |
| 193 | 193 | function setValue($value) |
| 194 | 194 | { |
| 195 | - $this->_value = $value; |
|
| 195 | + $this->_value = $value; |
|
| 196 | 196 | } |
| 197 | 197 | |
| 198 | 198 | /*-----------------------------------------------------------------*/ |
@@ -392,83 +392,83 @@ discard block |
||
| 392 | 392 | */ |
| 393 | 393 | function render() |
| 394 | 394 | { |
| 395 | - $sSpinFolder = $this->getFolder(); |
|
| 396 | - $sFolderImg = "{$sSpinFolder}/images/{$this->getImgFolder()}/"; |
|
| 395 | + $sSpinFolder = $this->getFolder(); |
|
| 396 | + $sFolderImg = "{$sSpinFolder}/images/{$this->getImgFolder()}/"; |
|
| 397 | 397 | |
| 398 | 398 | |
| 399 | - $prefixe = $this->getName(); |
|
| 400 | - $prefixe2 = 'spin'.$prefixe; |
|
| 399 | + $prefixe = $this->getName(); |
|
| 400 | + $prefixe2 = 'spin'.$prefixe; |
|
| 401 | 401 | |
| 402 | - $smallIncrement = $this->getSmallIncrement(); |
|
| 403 | - $largeIncrement = $this->getLargeIncrement(); |
|
| 402 | + $smallIncrement = $this->getSmallIncrement(); |
|
| 403 | + $largeIncrement = $this->getLargeIncrement(); |
|
| 404 | 404 | |
| 405 | - /*----------------------------------------------*/ |
|
| 406 | - $delai = 200; |
|
| 407 | - $onMouseDown1 = "spinStart(\"{$prefixe}\", \"{$prefixe2}\", {$smallIncrement}, {$largeIncrement}, {$delai}, \"{$sFolderImg}spinUp1.gif\");"; |
|
| 408 | - $onMouseDown2 = "spinStart(\"{$prefixe}\", \"{$prefixe2}\", -{$smallIncrement}, -{$largeIncrement}, {$delai}, \"{$sFolderImg}spinDown1.gif\");"; |
|
| 409 | - |
|
| 410 | - $onMouseUp = "spinStop();"; |
|
| 411 | - //---------------------------------------------------------------- |
|
| 412 | - $styleBordure = $this->htmlAddAttribut ('style', $this->getStyleBordure()); |
|
| 413 | - $styleText = $this->htmlAddAttribut ('style', $this->getStyleText()); |
|
| 414 | - $styleArrow = "style=\"display: table-cell;vertical-align: middle; text-align: center; line-height: 100%; font-size: 7 pt; margin-top: 0; margin-bottom: 0; padding: 0\""; |
|
| 415 | - //---------------------------------------------------------------- |
|
| 416 | - $t = array(); |
|
| 405 | + /*----------------------------------------------*/ |
|
| 406 | + $delai = 200; |
|
| 407 | + $onMouseDown1 = "spinStart(\"{$prefixe}\", \"{$prefixe2}\", {$smallIncrement}, {$largeIncrement}, {$delai}, \"{$sFolderImg}spinUp1.gif\");"; |
|
| 408 | + $onMouseDown2 = "spinStart(\"{$prefixe}\", \"{$prefixe2}\", -{$smallIncrement}, -{$largeIncrement}, {$delai}, \"{$sFolderImg}spinDown1.gif\");"; |
|
| 409 | + |
|
| 410 | + $onMouseUp = "spinStop();"; |
|
| 411 | + //---------------------------------------------------------------- |
|
| 412 | + $styleBordure = $this->htmlAddAttribut ('style', $this->getStyleBordure()); |
|
| 413 | + $styleText = $this->htmlAddAttribut ('style', $this->getStyleText()); |
|
| 414 | + $styleArrow = "style=\"display: table-cell;vertical-align: middle; text-align: center; line-height: 100%; font-size: 7 pt; margin-top: 0; margin-bottom: 0; padding: 0\""; |
|
| 415 | + //---------------------------------------------------------------- |
|
| 416 | + $t = array(); |
|
| 417 | 417 | |
| 418 | 418 | |
| 419 | - if ($this->_loadJS) { |
|
| 419 | + if ($this->_loadJS) { |
|
| 420 | 420 | $js = $sSpinFolder . "/js/spin.js"; |
| 421 | 421 | $t[] = "<script src='{$js}' type='text/javascript'></script>"; |
| 422 | - } |
|
| 422 | + } |
|
| 423 | 423 | |
| 424 | - $t[] = "<div STYLE='width:50px'>"; |
|
| 425 | - //$t[] = "<table border='0' width='8%' cellpadding='0' cellspacing='0'>"; |
|
| 426 | - $t[] = "<table border='0' width='8%' cellpadding='0' cellspacing='0' {$styleBordure}>"; |
|
| 427 | - $t[] = " <tr>"; |
|
| 428 | - //$t[] = " <td width='60%'>{$Caption}</td>"; |
|
| 429 | - $t[] = " <td width='60%'>"; |
|
| 430 | - $t[] = " <INPUT TYPE='hidden' NAME='{$prefixe2}_min' VALUE='{$this->getMin()}'>"; |
|
| 431 | - $t[] = " <INPUT TYPE='hidden' NAME='{$prefixe2}_max' VALUE='{$this->getMax()}'>"; |
|
| 432 | - $t[] = " <INPUT TYPE='hidden' NAME='{$prefixe2}_smallIncrement' VALUE='{$this->_smallIncrement}' style='text-align: right'>"; |
|
| 433 | - $t[] = " <input type='text' name='{$prefixe}' size='{$this->GetSize()}' value='{$this->getValue()}' {$styleText}>"; |
|
| 434 | - $t[] = " </td>"; |
|
| 424 | + $t[] = "<div STYLE='width:50px'>"; |
|
| 425 | + //$t[] = "<table border='0' width='8%' cellpadding='0' cellspacing='0'>"; |
|
| 426 | + $t[] = "<table border='0' width='8%' cellpadding='0' cellspacing='0' {$styleBordure}>"; |
|
| 427 | + $t[] = " <tr>"; |
|
| 428 | + //$t[] = " <td width='60%'>{$Caption}</td>"; |
|
| 429 | + $t[] = " <td width='60%'>"; |
|
| 430 | + $t[] = " <INPUT TYPE='hidden' NAME='{$prefixe2}_min' VALUE='{$this->getMin()}'>"; |
|
| 431 | + $t[] = " <INPUT TYPE='hidden' NAME='{$prefixe2}_max' VALUE='{$this->getMax()}'>"; |
|
| 432 | + $t[] = " <INPUT TYPE='hidden' NAME='{$prefixe2}_smallIncrement' VALUE='{$this->_smallIncrement}' style='text-align: right'>"; |
|
| 433 | + $t[] = " <input type='text' name='{$prefixe}' size='{$this->GetSize()}' value='{$this->getValue()}' {$styleText}>"; |
|
| 434 | + $t[] = " </td>"; |
|
| 435 | 435 | |
| 436 | - $unite = $this->getUnite(); |
|
| 437 | - if ($unite <> ''){ |
|
| 436 | + $unite = $this->getUnite(); |
|
| 437 | + if ($unite <> ''){ |
|
| 438 | 438 | $t[] = " <td style='display: table-cell;vertical-align: middle; '> {$unite} </td>"; |
| 439 | - } |
|
| 440 | - //------------------------------------------------------- |
|
| 441 | - if ($this->getMinMaxVisible()){ |
|
| 439 | + } |
|
| 440 | + //------------------------------------------------------- |
|
| 441 | + if ($this->getMinMaxVisible()){ |
|
| 442 | 442 | $onMouseDownMin = "spinSetValue(\"{$prefixe}\", \"{$prefixe2}\", \"Min\", {$this->getMin()}, {$delai}, \"{$sFolderImg}spinMin1.gif\");"; |
| 443 | 443 | $t[] = " <td width='63%' align='center' {$styleArrow}>"; |
| 444 | 444 | $t[] = " <img border='0' name='{$prefixe2}_imgMin' src='{$sFolderImg}spinMin0.gif' onmousedown='{$onMouseDownMin}'><br>"; |
| 445 | 445 | $t[] = " </td>"; |
| 446 | - } |
|
| 447 | - //------------------------------------------------------- |
|
| 448 | - $t[] = " <td width='63%' align='center' {$styleArrow}>"; |
|
| 446 | + } |
|
| 447 | + //------------------------------------------------------- |
|
| 448 | + $t[] = " <td width='63%' align='center' {$styleArrow}>"; |
|
| 449 | 449 | |
| 450 | - $t[] = " <img border='0' name='{$prefixe2}_img0' src='{$sFolderImg}spinUp0.gif' onmousedown='{$onMouseDown1}' onmouseup='{$onMouseUp}' onmouseout='{$onMouseUp}'><br>"; |
|
| 451 | - $t[] = " <img border='0' name='{$prefixe2}_img1' src='{$sFolderImg}spinDown0.gif' onmousedown='{$onMouseDown2}' onmouseup='{$onMouseUp}' onmouseout='{$onMouseUp}'>"; |
|
| 450 | + $t[] = " <img border='0' name='{$prefixe2}_img0' src='{$sFolderImg}spinUp0.gif' onmousedown='{$onMouseDown1}' onmouseup='{$onMouseUp}' onmouseout='{$onMouseUp}'><br>"; |
|
| 451 | + $t[] = " <img border='0' name='{$prefixe2}_img1' src='{$sFolderImg}spinDown0.gif' onmousedown='{$onMouseDown2}' onmouseup='{$onMouseUp}' onmouseout='{$onMouseUp}'>"; |
|
| 452 | 452 | |
| 453 | - $t[] = " </td>"; |
|
| 453 | + $t[] = " </td>"; |
|
| 454 | 454 | |
| 455 | - //------------------------------------------------------- |
|
| 456 | - if ($this->getMinMaxVisible()){ |
|
| 455 | + //------------------------------------------------------- |
|
| 456 | + if ($this->getMinMaxVisible()){ |
|
| 457 | 457 | $onMouseDownMax = "spinSetValue(\"{$prefixe}\", \"{$prefixe2}\", \"Max\", {$this->getMax()}, {$delai}, \"{$sFolderImg}spinMax1.gif\");"; |
| 458 | 458 | $t[] = " <td width='63%' align='center' {$styleArrow}>"; |
| 459 | 459 | $t[] = " <img border='0' name='{$prefixe2}_imgMax' src='{$sFolderImg}spinMax0.gif' onmousedown='{$onMouseDownMax}'><br>"; |
| 460 | 460 | $t[] = " </td>"; |
| 461 | - } |
|
| 462 | - //------------------------------------------------------- |
|
| 461 | + } |
|
| 462 | + //------------------------------------------------------- |
|
| 463 | 463 | |
| 464 | 464 | |
| 465 | - $t[] = " </tr>"; |
|
| 466 | - $t[] = "</table>"."\n"; |
|
| 467 | - $t[] = "</div>"; |
|
| 468 | - //------------------------------------------- |
|
| 469 | - $html = implode ("\n", $t); |
|
| 465 | + $t[] = " </tr>"; |
|
| 466 | + $t[] = "</table>"."\n"; |
|
| 467 | + $t[] = "</div>"; |
|
| 468 | + //------------------------------------------- |
|
| 469 | + $html = implode ("\n", $t); |
|
| 470 | 470 | |
| 471 | - return $html; |
|
| 471 | + return $html; |
|
| 472 | 472 | |
| 473 | 473 | } |
| 474 | 474 | |
@@ -487,17 +487,17 @@ discard block |
||
| 487 | 487 | *********************************************************************/ |
| 488 | 488 | function htmlAddAttribut($attribut, $value, $default = ''){ |
| 489 | 489 | |
| 490 | - if ($value == ''){$value = $default;} |
|
| 490 | + if ($value == ''){$value = $default;} |
|
| 491 | 491 | |
| 492 | - if ($value <> ""){ |
|
| 492 | + if ($value <> ""){ |
|
| 493 | 493 | if (substr($value,0,strlen($attribut)) <> $attribut){ |
| 494 | - $r ="{$attribut}=\"{$value}\""; |
|
| 494 | + $r ="{$attribut}=\"{$value}\""; |
|
| 495 | 495 | } |
| 496 | - }else{ |
|
| 496 | + }else{ |
|
| 497 | 497 | $r = ''; |
| 498 | - } |
|
| 498 | + } |
|
| 499 | 499 | |
| 500 | - return $r; |
|
| 500 | + return $r; |
|
| 501 | 501 | |
| 502 | 502 | } |
| 503 | 503 | |
@@ -33,7 +33,7 @@ discard block |
||
| 33 | 33 | /*----------------------------------------------------------*/ |
| 34 | 34 | /* set here the folder of the clas relative at the root */ |
| 35 | 35 | /*----------------------------------------------------------*/ |
| 36 | -define('_SPIN_FOLDER','/class/xoopsform/spin/'); |
|
| 36 | +define('_SPIN_FOLDER', '/class/xoopsform/spin/'); |
|
| 37 | 37 | /*----------------------------------------------------------*/ |
| 38 | 38 | |
| 39 | 39 | class XoopsFormSpin extends XoopsFormElement |
@@ -109,7 +109,7 @@ discard block |
||
| 109 | 109 | * @var integer |
| 110 | 110 | * @access private |
| 111 | 111 | */ |
| 112 | - var $_minMaxVisible= true; |
|
| 112 | + var $_minMaxVisible = true; |
|
| 113 | 113 | |
| 114 | 114 | /** |
| 115 | 115 | * tyleBordure ; style CSS of frame control |
@@ -155,9 +155,9 @@ discard block |
||
| 155 | 155 | * |
| 156 | 156 | */ |
| 157 | 157 | function XoopsFormSpin($caption, $name, $value = 0, |
| 158 | - $min = 0, $max=100, |
|
| 158 | + $min = 0, $max = 100, |
|
| 159 | 159 | $smallIncrement = 1, $largeIncrement = 10, |
| 160 | - $size = 5, $unite='', $imgFolder='default', |
|
| 160 | + $size = 5, $unite = '', $imgFolder = 'default', |
|
| 161 | 161 | $styleText = '', $styleBordure = '', |
| 162 | 162 | $minMaxVisible = true) |
| 163 | 163 | { |
@@ -250,7 +250,7 @@ discard block |
||
| 250 | 250 | function setSmallIncrement($smallIncrement) |
| 251 | 251 | { |
| 252 | 252 | $this->_smallIncrement = intval($smallIncrement); |
| 253 | - if ($this->_smallIncrement == 0) $this->_smallIncrement =1; |
|
| 253 | + if ($this->_smallIncrement == 0) $this->_smallIncrement = 1; |
|
| 254 | 254 | } |
| 255 | 255 | |
| 256 | 256 | /*-----------------------------------------------------------------*/ |
@@ -309,7 +309,7 @@ discard block |
||
| 309 | 309 | */ |
| 310 | 310 | function setImgFolder($folder) |
| 311 | 311 | { |
| 312 | - if ($folder <> '' ) $this->_imgFolder = $folder; |
|
| 312 | + if ($folder <> '') $this->_imgFolder = $folder; |
|
| 313 | 313 | } |
| 314 | 314 | /*-----------------------------------------------------------------*/ |
| 315 | 315 | /** |
@@ -393,11 +393,11 @@ discard block |
||
| 393 | 393 | function render() |
| 394 | 394 | { |
| 395 | 395 | $sSpinFolder = $this->getFolder(); |
| 396 | - $sFolderImg = "{$sSpinFolder}/images/{$this->getImgFolder()}/"; |
|
| 396 | + $sFolderImg = "{$sSpinFolder}/images/{$this->getImgFolder()}/"; |
|
| 397 | 397 | |
| 398 | 398 | |
| 399 | 399 | $prefixe = $this->getName(); |
| 400 | - $prefixe2 = 'spin'.$prefixe; |
|
| 400 | + $prefixe2 = 'spin' . $prefixe; |
|
| 401 | 401 | |
| 402 | 402 | $smallIncrement = $this->getSmallIncrement(); |
| 403 | 403 | $largeIncrement = $this->getLargeIncrement(); |
@@ -409,8 +409,8 @@ discard block |
||
| 409 | 409 | |
| 410 | 410 | $onMouseUp = "spinStop();"; |
| 411 | 411 | //---------------------------------------------------------------- |
| 412 | - $styleBordure = $this->htmlAddAttribut ('style', $this->getStyleBordure()); |
|
| 413 | - $styleText = $this->htmlAddAttribut ('style', $this->getStyleText()); |
|
| 412 | + $styleBordure = $this->htmlAddAttribut('style', $this->getStyleBordure()); |
|
| 413 | + $styleText = $this->htmlAddAttribut('style', $this->getStyleText()); |
|
| 414 | 414 | $styleArrow = "style=\"display: table-cell;vertical-align: middle; text-align: center; line-height: 100%; font-size: 7 pt; margin-top: 0; margin-bottom: 0; padding: 0\""; |
| 415 | 415 | //---------------------------------------------------------------- |
| 416 | 416 | $t = array(); |
@@ -434,11 +434,11 @@ discard block |
||
| 434 | 434 | $t[] = " </td>"; |
| 435 | 435 | |
| 436 | 436 | $unite = $this->getUnite(); |
| 437 | - if ($unite <> ''){ |
|
| 437 | + if ($unite <> '') { |
|
| 438 | 438 | $t[] = " <td style='display: table-cell;vertical-align: middle; '> {$unite} </td>"; |
| 439 | 439 | } |
| 440 | 440 | //------------------------------------------------------- |
| 441 | - if ($this->getMinMaxVisible()){ |
|
| 441 | + if ($this->getMinMaxVisible()) { |
|
| 442 | 442 | $onMouseDownMin = "spinSetValue(\"{$prefixe}\", \"{$prefixe2}\", \"Min\", {$this->getMin()}, {$delai}, \"{$sFolderImg}spinMin1.gif\");"; |
| 443 | 443 | $t[] = " <td width='63%' align='center' {$styleArrow}>"; |
| 444 | 444 | $t[] = " <img border='0' name='{$prefixe2}_imgMin' src='{$sFolderImg}spinMin0.gif' onmousedown='{$onMouseDownMin}'><br>"; |
@@ -453,7 +453,7 @@ discard block |
||
| 453 | 453 | $t[] = " </td>"; |
| 454 | 454 | |
| 455 | 455 | //------------------------------------------------------- |
| 456 | - if ($this->getMinMaxVisible()){ |
|
| 456 | + if ($this->getMinMaxVisible()) { |
|
| 457 | 457 | $onMouseDownMax = "spinSetValue(\"{$prefixe}\", \"{$prefixe2}\", \"Max\", {$this->getMax()}, {$delai}, \"{$sFolderImg}spinMax1.gif\");"; |
| 458 | 458 | $t[] = " <td width='63%' align='center' {$styleArrow}>"; |
| 459 | 459 | $t[] = " <img border='0' name='{$prefixe2}_imgMax' src='{$sFolderImg}spinMax0.gif' onmousedown='{$onMouseDownMax}'><br>"; |
@@ -463,10 +463,10 @@ discard block |
||
| 463 | 463 | |
| 464 | 464 | |
| 465 | 465 | $t[] = " </tr>"; |
| 466 | - $t[] = "</table>"."\n"; |
|
| 466 | + $t[] = "</table>" . "\n"; |
|
| 467 | 467 | $t[] = "</div>"; |
| 468 | 468 | //------------------------------------------- |
| 469 | - $html = implode ("\n", $t); |
|
| 469 | + $html = implode("\n", $t); |
|
| 470 | 470 | |
| 471 | 471 | return $html; |
| 472 | 472 | |
@@ -475,7 +475,7 @@ discard block |
||
| 475 | 475 | /************************************************************************** |
| 476 | 476 | * calcul du dossier du composant |
| 477 | 477 | *************************************************************************/ |
| 478 | -function getFolder (){ |
|
| 478 | +function getFolder() { |
|
| 479 | 479 | |
| 480 | 480 | $sSpinFolder = XOOPS_URL . _SPIN_FOLDER; |
| 481 | 481 | |
@@ -485,15 +485,15 @@ discard block |
||
| 485 | 485 | /******************************************************************** |
| 486 | 486 | * |
| 487 | 487 | *********************************************************************/ |
| 488 | -function htmlAddAttribut($attribut, $value, $default = ''){ |
|
| 488 | +function htmlAddAttribut($attribut, $value, $default = '') { |
|
| 489 | 489 | |
| 490 | - if ($value == ''){$value = $default;} |
|
| 490 | + if ($value == '') {$value = $default; } |
|
| 491 | 491 | |
| 492 | - if ($value <> ""){ |
|
| 493 | - if (substr($value,0,strlen($attribut)) <> $attribut){ |
|
| 494 | - $r ="{$attribut}=\"{$value}\""; |
|
| 492 | + if ($value <> "") { |
|
| 493 | + if (substr($value, 0, strlen($attribut)) <> $attribut) { |
|
| 494 | + $r = "{$attribut}=\"{$value}\""; |
|
| 495 | 495 | } |
| 496 | - }else{ |
|
| 496 | + } else { |
|
| 497 | 497 | $r = ''; |
| 498 | 498 | } |
| 499 | 499 | |
@@ -31,17 +31,17 @@ |
||
| 31 | 31 | global $xoopsDB; |
| 32 | 32 | |
| 33 | 33 | // Create eXtcal upload directory if don't exist |
| 34 | - $dir = XOOPS_ROOT_PATH."/uploads/extcal"; |
|
| 34 | + $dir = XOOPS_ROOT_PATH . "/uploads/extcal"; |
|
| 35 | 35 | if (!is_dir($dir)) { |
| 36 | 36 | mkdir($dir); |
| 37 | 37 | |
| 38 | 38 | // Copy index.html files on uploads folders |
| 39 | - $indexFile = XOOPS_ROOT_PATH."/modules/extcal/include/index.html"; |
|
| 40 | - copy($indexFile, XOOPS_ROOT_PATH."/uploads/extcal/index.html"); |
|
| 39 | + $indexFile = XOOPS_ROOT_PATH . "/modules/extcal/include/index.html"; |
|
| 40 | + copy($indexFile, XOOPS_ROOT_PATH . "/uploads/extcal/index.html"); |
|
| 41 | 41 | } |
| 42 | 42 | |
| 43 | 43 | // Create who's not going table to fix bug. If the table exist, the query will faile |
| 44 | - $sql = "CREATE TABLE `".$xoopsDB->prefix('extcal_eventnotmember')."` (`eventnotmember_id` int(11) NOT NULL auto_increment,`event_id` int(11) NOT NULL default '0',`uid` int(11) NOT NULL default '0',PRIMARY KEY (`eventnotmember_id`),UNIQUE KEY `eventnotmember` (`event_id`,`uid`)) COMMENT='eXtcal By Zoullou' ;"; |
|
| 44 | + $sql = "CREATE TABLE `" . $xoopsDB->prefix('extcal_eventnotmember') . "` (`eventnotmember_id` int(11) NOT NULL auto_increment,`event_id` int(11) NOT NULL default '0',`uid` int(11) NOT NULL default '0',PRIMARY KEY (`eventnotmember_id`),UNIQUE KEY `eventnotmember` (`event_id`,`uid`)) COMMENT='eXtcal By Zoullou' ;"; |
|
| 45 | 45 | $xoopsDB->query($sql); |
| 46 | 46 | |
| 47 | 47 | } |
@@ -30,21 +30,21 @@ |
||
| 30 | 30 | { |
| 31 | 31 | global $xoopsDB; |
| 32 | 32 | |
| 33 | - $this->alterTable_etablissement(); |
|
| 33 | + $this->alterTable_etablissement(); |
|
| 34 | 34 | |
| 35 | 35 | } |
| 36 | 36 | //---------------------------------------------------- |
| 37 | 37 | function alterTable_etablissement() |
| 38 | 38 | { |
| 39 | 39 | global $xoopsDB; |
| 40 | - $tbl = $xoopsDB->prefix('extcal_etablissement'); |
|
| 40 | + $tbl = $xoopsDB->prefix('extcal_etablissement'); |
|
| 41 | 41 | |
| 42 | 42 | $sql = <<<__sql__ |
| 43 | 43 | ALTER TABLE `{$tbl}` |
| 44 | 44 | CHANGE `desc` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL; |
| 45 | 45 | __sql__; |
| 46 | 46 | |
| 47 | - $xoopsDB->queryF($sql); |
|
| 47 | + $xoopsDB->queryF($sql); |
|
| 48 | 48 | //echo "<hr>{$sql}<hr>"; |
| 49 | 49 | } |
| 50 | 50 | //---------------------------------------------------- |
@@ -31,27 +31,27 @@ |
||
| 31 | 31 | global $xoopsDB; |
| 32 | 32 | |
| 33 | 33 | //$xoopsDB =& Database::getInstance(); |
| 34 | - $xoopsDB =& XoopsDatabaseFactory::getDatabaseConnection(); |
|
| 34 | + $xoopsDB = & XoopsDatabaseFactory::getDatabaseConnection(); |
|
| 35 | 35 | |
| 36 | - $sql = "ALTER TABLE `".$xoopsDB->prefix('extcal_event')."` CHANGE `event_approved` `event_approved` TINYINT( 1 ) NOT NULL DEFAULT '0' ;"; |
|
| 36 | + $sql = "ALTER TABLE `" . $xoopsDB->prefix('extcal_event') . "` CHANGE `event_approved` `event_approved` TINYINT( 1 ) NOT NULL DEFAULT '0' ;"; |
|
| 37 | 37 | $xoopsDB->query($sql); |
| 38 | 38 | |
| 39 | - $sql = "ALTER TABLE `".$xoopsDB->prefix('extcal_event')."` ADD `event_isrecur` TINYINT( 1 ) NOT NULL AFTER `event_nbmember` ;"; |
|
| 39 | + $sql = "ALTER TABLE `" . $xoopsDB->prefix('extcal_event') . "` ADD `event_isrecur` TINYINT( 1 ) NOT NULL AFTER `event_nbmember` ;"; |
|
| 40 | 40 | $xoopsDB->query($sql); |
| 41 | 41 | |
| 42 | - $sql = "ALTER TABLE `".$xoopsDB->prefix('extcal_event')."` ADD `event_recur_rules` VARCHAR( 255 ) NOT NULL AFTER `event_isrecur` "; |
|
| 42 | + $sql = "ALTER TABLE `" . $xoopsDB->prefix('extcal_event') . "` ADD `event_recur_rules` VARCHAR( 255 ) NOT NULL AFTER `event_isrecur` "; |
|
| 43 | 43 | $xoopsDB->query($sql); |
| 44 | 44 | |
| 45 | - $sql = "ALTER TABLE `".$xoopsDB->prefix('extcal_event')."` ADD `event_recur_start` INT( 11 ) NOT NULL AFTER `event_recur_rules` ;"; |
|
| 45 | + $sql = "ALTER TABLE `" . $xoopsDB->prefix('extcal_event') . "` ADD `event_recur_start` INT( 11 ) NOT NULL AFTER `event_recur_rules` ;"; |
|
| 46 | 46 | $xoopsDB->query($sql); |
| 47 | 47 | |
| 48 | - $sql = "ALTER TABLE `".$xoopsDB->prefix('extcal_event')."` ADD `event_recur_end` INT( 11 ) NOT NULL AFTER `event_recur_start` ;"; |
|
| 48 | + $sql = "ALTER TABLE `" . $xoopsDB->prefix('extcal_event') . "` ADD `event_recur_end` INT( 11 ) NOT NULL AFTER `event_recur_start` ;"; |
|
| 49 | 49 | $xoopsDB->query($sql); |
| 50 | 50 | |
| 51 | - $sql = "CREATE TABLE `".$xoopsDB->prefix('extcal_event')."` (`eventnotmember_id` int(11) NOT NULL auto_increment,`event_id` int(11) NOT NULL default '0',`uid` int(11) NOT NULL default '0',PRIMARY KEY (`eventnotmember_id`),UNIQUE KEY `eventnotmember` (`event_id`,`uid`)) COMMENT='eXtcal By Zoullou' ;"; |
|
| 51 | + $sql = "CREATE TABLE `" . $xoopsDB->prefix('extcal_event') . "` (`eventnotmember_id` int(11) NOT NULL auto_increment,`event_id` int(11) NOT NULL default '0',`uid` int(11) NOT NULL default '0',PRIMARY KEY (`eventnotmember_id`),UNIQUE KEY `eventnotmember` (`event_id`,`uid`)) COMMENT='eXtcal By Zoullou' ;"; |
|
| 52 | 52 | $xoopsDB->query($sql); |
| 53 | 53 | |
| 54 | - $sql = "CREATE TABLE `".$xoopsDB->prefix('extcal_file')."` (`file_id` int(11) NOT NULL auto_increment,`file_name` varchar(255) NOT NULL,`file_nicename` varchar(255) NOT NULL,`file_mimetype` varchar(255) NOT NULL,`file_size` int(11) NOT NULL,`file_download` int(11) NOT NULL,`file_date` int(11) NOT NULL,`file_approved` tinyint(1) NOT NULL,`event_id` int(11) NOT NULL,`uid` int(11) NOT NULL,PRIMARY KEY (`file_id`)) COMMENT='eXtcal By Zoullou' ;"; |
|
| 54 | + $sql = "CREATE TABLE `" . $xoopsDB->prefix('extcal_file') . "` (`file_id` int(11) NOT NULL auto_increment,`file_name` varchar(255) NOT NULL,`file_nicename` varchar(255) NOT NULL,`file_mimetype` varchar(255) NOT NULL,`file_size` int(11) NOT NULL,`file_download` int(11) NOT NULL,`file_date` int(11) NOT NULL,`file_approved` tinyint(1) NOT NULL,`event_id` int(11) NOT NULL,`uid` int(11) NOT NULL,PRIMARY KEY (`file_id`)) COMMENT='eXtcal By Zoullou' ;"; |
|
| 55 | 55 | $xoopsDB->query($sql); |
| 56 | 56 | |
| 57 | 57 | } |
@@ -30,8 +30,8 @@ discard block |
||
| 30 | 30 | { |
| 31 | 31 | global $xoopsDB; |
| 32 | 32 | |
| 33 | - $this->addTable_etablissement(); |
|
| 34 | - $this->alterTable_event(); |
|
| 33 | + $this->addTable_etablissement(); |
|
| 34 | + $this->alterTable_event(); |
|
| 35 | 35 | |
| 36 | 36 | } |
| 37 | 37 | //---------------------------------------------------- |
@@ -39,7 +39,7 @@ discard block |
||
| 39 | 39 | { |
| 40 | 40 | global $xoopsDB; |
| 41 | 41 | |
| 42 | - $tbl = $xoopsDB->prefix('extcal_event'); |
|
| 42 | + $tbl = $xoopsDB->prefix('extcal_event'); |
|
| 43 | 43 | |
| 44 | 44 | $sql = <<<__sql__ |
| 45 | 45 | ALTER TABLE `{$tbl}` |
@@ -50,7 +50,7 @@ discard block |
||
| 50 | 50 | add `event_etablissement` int(5) NOT NULL DEFAULT '1'; |
| 51 | 51 | __sql__; |
| 52 | 52 | |
| 53 | - $xoopsDB->queryF($sql); |
|
| 53 | + $xoopsDB->queryF($sql); |
|
| 54 | 54 | |
| 55 | 55 | } |
| 56 | 56 | |
@@ -59,7 +59,7 @@ discard block |
||
| 59 | 59 | { |
| 60 | 60 | global $xoopsDB; |
| 61 | 61 | |
| 62 | - $tbl = $xoopsDB->prefix('extcal_etablissement'); |
|
| 62 | + $tbl = $xoopsDB->prefix('extcal_etablissement'); |
|
| 63 | 63 | |
| 64 | 64 | $sql = <<<__sql__ |
| 65 | 65 | CREATE TABLE `{$tbl}` ( |
@@ -85,7 +85,7 @@ discard block |
||
| 85 | 85 | ) ENGINE = MYISAM ; |
| 86 | 86 | __sql__; |
| 87 | 87 | |
| 88 | - $xoopsDB->queryF($sql); |
|
| 88 | + $xoopsDB->queryF($sql); |
|
| 89 | 89 | //--------------------------------------------------- |
| 90 | 90 | |
| 91 | 91 | } |
@@ -30,21 +30,21 @@ |
||
| 30 | 30 | { |
| 31 | 31 | global $xoopsDB; |
| 32 | 32 | |
| 33 | - $this->alterTable_event(); |
|
| 33 | + $this->alterTable_event(); |
|
| 34 | 34 | |
| 35 | 35 | } |
| 36 | 36 | //---------------------------------------------------- |
| 37 | 37 | function alterTable_event() |
| 38 | 38 | { |
| 39 | 39 | global $xoopsDB; |
| 40 | - $tbl = $xoopsDB->prefix('extcal_event'); |
|
| 40 | + $tbl = $xoopsDB->prefix('extcal_event'); |
|
| 41 | 41 | |
| 42 | 42 | $sql = <<<__sql__ |
| 43 | 43 | ALTER TABLE `{$tbl}` |
| 44 | 44 | CHANGE `event_etablissement` `event_etablissement` INT( 5 ) NOT NULL DEFAULT '0'; |
| 45 | 45 | __sql__; |
| 46 | 46 | |
| 47 | - $xoopsDB->queryF($sql); |
|
| 47 | + $xoopsDB->queryF($sql); |
|
| 48 | 48 | |
| 49 | 49 | } |
| 50 | 50 | |
@@ -30,7 +30,7 @@ |
||
| 30 | 30 | { |
| 31 | 31 | global $xoopsDB; |
| 32 | 32 | |
| 33 | - $sql = "ALTER TABLE `".$xoopsDB->prefix('extcal_event')."` ADD `event_nbmember` tinyint(4) NOT NULL default '0' AFTER `event_submitdate` ;"; |
|
| 33 | + $sql = "ALTER TABLE `" . $xoopsDB->prefix('extcal_event') . "` ADD `event_nbmember` tinyint(4) NOT NULL default '0' AFTER `event_submitdate` ;"; |
|
| 34 | 34 | $xoopsDB->query($sql); |
| 35 | 35 | |
| 36 | 36 | } |
@@ -30,36 +30,36 @@ |
||
| 30 | 30 | { |
| 31 | 31 | global $xoopsDB; |
| 32 | 32 | |
| 33 | - $this->alterTable_cat(); |
|
| 34 | - $this->alterTable_eventmember(); |
|
| 33 | + $this->alterTable_cat(); |
|
| 34 | + $this->alterTable_eventmember(); |
|
| 35 | 35 | |
| 36 | 36 | } |
| 37 | 37 | //---------------------------------------------------- |
| 38 | 38 | function alterTable_cat() |
| 39 | 39 | { |
| 40 | 40 | global $xoopsDB; |
| 41 | - $tbl = $xoopsDB->prefix('extcal_cat'); |
|
| 41 | + $tbl = $xoopsDB->prefix('extcal_cat'); |
|
| 42 | 42 | |
| 43 | 43 | $sql = <<<__sql__ |
| 44 | 44 | ALTER TABLE `{$tbl}` |
| 45 | 45 | ADD `cat_weight` INT NOT NULL DEFAULT '0'; |
| 46 | 46 | __sql__; |
| 47 | 47 | |
| 48 | - $xoopsDB->queryF($sql); |
|
| 48 | + $xoopsDB->queryF($sql); |
|
| 49 | 49 | |
| 50 | 50 | } |
| 51 | 51 | //---------------------------------------------------- |
| 52 | 52 | function alterTable_eventmember() |
| 53 | 53 | { |
| 54 | 54 | global $xoopsDB; |
| 55 | - $tbl = $xoopsDB->prefix('eventmember'); |
|
| 55 | + $tbl = $xoopsDB->prefix('eventmember'); |
|
| 56 | 56 | |
| 57 | 57 | $sql = <<<__sql__ |
| 58 | 58 | ALTER TABLE `{$tbl}` |
| 59 | 59 | ADD `status` INT NOT NULL DEFAULT '0'; |
| 60 | 60 | __sql__; |
| 61 | 61 | |
| 62 | - $xoopsDB->queryF($sql); |
|
| 62 | + $xoopsDB->queryF($sql); |
|
| 63 | 63 | |
| 64 | 64 | } |
| 65 | 65 | |
@@ -30,21 +30,21 @@ discard block |
||
| 30 | 30 | { |
| 31 | 31 | global $xoopsDB; |
| 32 | 32 | |
| 33 | - $this->alterTable_event(); |
|
| 34 | - $this->alterTable_cat(); |
|
| 33 | + $this->alterTable_event(); |
|
| 34 | + $this->alterTable_cat(); |
|
| 35 | 35 | |
| 36 | 36 | } |
| 37 | 37 | //---------------------------------------------------- |
| 38 | 38 | function alterTable_event() |
| 39 | 39 | { |
| 40 | 40 | global $xoopsDB; |
| 41 | - $tbl = $xoopsDB->prefix('extcal_event'); |
|
| 41 | + $tbl = $xoopsDB->prefix('extcal_event'); |
|
| 42 | 42 | |
| 43 | 43 | $sql = <<<__sql__ |
| 44 | 44 | ALTER TABLE `{$tbl}` ADD `event_icone` VARCHAR(50) NOT NULL; |
| 45 | 45 | __sql__; |
| 46 | 46 | |
| 47 | - $xoopsDB->queryF($sql); |
|
| 47 | + $xoopsDB->queryF($sql); |
|
| 48 | 48 | } |
| 49 | 49 | |
| 50 | 50 | //----------------------------------------------------------------- |
@@ -52,13 +52,13 @@ discard block |
||
| 52 | 52 | function alterTable_cat() |
| 53 | 53 | { |
| 54 | 54 | global $xoopsDB; |
| 55 | - $tbl = $xoopsDB->prefix('extcal_cat'); |
|
| 55 | + $tbl = $xoopsDB->prefix('extcal_cat'); |
|
| 56 | 56 | |
| 57 | 57 | $sql = <<<__sql__ |
| 58 | 58 | ALTER TABLE `{$tbl}` ADD `cat_icone` VARCHAR(50) NOT NULL ; |
| 59 | 59 | __sql__; |
| 60 | 60 | |
| 61 | - $xoopsDB->queryF($sql); |
|
| 61 | + $xoopsDB->queryF($sql); |
|
| 62 | 62 | |
| 63 | 63 | } |
| 64 | 64 | |