Changeset 4282 for extensions
- Timestamp:
- Nov 16, 2009, 11:06:18 PM (14 years ago)
- Location:
- extensions/event_cats
- Files:
-
- 1 added
- 5 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/event_cats/admin/evntcats_admin.php
r4276 r4282 90 90 // If no entry exist, default page is 'autolog_new'. 91 91 $page['tab'] = (!($ec_exist_entries = (mysql_num_rows(pwg_query(" 92 SELECT * FROM `".EVNTCATS_ AUTOLOG_TABLE."`92 SELECT * FROM `".EVNTCATS_TABLE."` 93 93 WHERE `code` IS NOT NULL ; 94 94 ")) != 0))) ? 'autolog_new' : 'autolog_entries'; 95 95 96 96 $ec_exist_duplic = ((mysql_num_rows(pwg_query(" 97 SELECT * FROM `".EVNTCATS_DUPLIC_TABLE."` ; 97 SELECT * FROM `".EVNTCATS_TABLE."` 98 WHERE `code` IS NULL 99 AND `arg1` IS NOT NULL 100 AND `arg2` IS NOT NULL ; 98 101 ")) != 0) or 99 102 (read_ec_conf('duplic_gen') != 0) or … … 204 207 205 208 $ec_exist_entries = (mysql_num_rows(pwg_query(" 206 SELECT * FROM `".EVNTCATS_ AUTOLOG_TABLE."`209 SELECT * FROM `".EVNTCATS_TABLE."` 207 210 WHERE `code` IS NOT NULL 208 211 ")) != 0); 209 212 210 213 $ec_exist_duplic = ((mysql_num_rows(pwg_query(" 211 SELECT * FROM `".EVNTCATS_DUPLIC_TABLE."` ; 214 SELECT * FROM `".EVNTCATS_TABLE."` 215 WHERE `code` IS NULL 216 AND `arg1` IS NOT NULL 217 AND `arg2` IS NOT NULL ; 212 218 ")) != 0) or 213 219 (read_ec_conf('duplic_gen') != 0) or -
extensions/event_cats/include/evntcats_admin_funcs.inc.php
r4276 r4282 376 376 " 377 377 SELECT `id` 378 FROM `".EVNTCATS_ AUTOLOG_TABLE."`378 FROM `".EVNTCATS_TABLE."` 379 379 WHERE `code` = '".$ec_code."' 380 380 AND `user_id` ".$ec_user_idp." … … 393 393 $t1 = mysql_fetch_row(pwg_query(" 394 394 SELECT `code` 395 FROM `".EVNTCATS_ AUTOLOG_TABLE."`395 FROM `".EVNTCATS_TABLE."` 396 396 WHERE `id` = ".$_POST['ec_entry_sel'] 397 397 ))) === false … … 399 399 $r = pwg_query(" 400 400 SELECT `id` 401 FROM `".EVNTCATS_ AUTOLOG_TABLE."`401 FROM `".EVNTCATS_TABLE."` 402 402 WHERE `code` = '".$t1[0]."' 403 403 AND `id` <> ".$_POST['ec_entry_sel'] … … 425 425 if ( 426 426 pwg_query(" 427 INSERT INTO `".EVNTCATS_ AUTOLOG_TABLE."` (427 INSERT INTO `".EVNTCATS_TABLE."` ( 428 428 `code`, 429 429 `user_id`, … … 459 459 if ( 460 460 pwg_query(" 461 UPDATE `".EVNTCATS_ AUTOLOG_TABLE."`461 UPDATE `".EVNTCATS_TABLE."` 462 462 SET 463 463 `user_id` = ".$ec_user_id.", … … 493 493 global $page; 494 494 if (!pwg_query(" 495 DELETE FROM `".EVNTCATS_ AUTOLOG_TABLE."`495 DELETE FROM `".EVNTCATS_TABLE."` 496 496 WHERE `id` = ".$ec_id 497 497 )) { -
extensions/event_cats/include/evntcats_main_funcs.inc.php
r4276 r4282 155 155 if ($new_action == '') { 156 156 if (!pwg_query(" 157 UPDATE `".EVNTCATS_ AUTOLOG_TABLE."`157 UPDATE `".EVNTCATS_TABLE."` 158 158 SET `forced` = 'false' 159 159 WHERE `id` = ".$ec_entry['id'] … … 247 247 248 248 $q = pwg_query(" 249 SELECT * FROM `".EVNTCATS_ AUTOLOG_TABLE."`249 SELECT * FROM `".EVNTCATS_TABLE."` 250 250 WHERE `code` IS NOT NULL 251 251 ORDER BY `id` … … 370 370 $groups_granted_ids = order_by_name( 371 371 array_from_query(" 372 SELECT `val` 373 FROM ".EVNTCATS_DUPLIC_TABLE." 374 WHERE `item` = 'grp' 372 SELECT `arg2` 373 FROM ".EVNTCATS_TABLE." 374 WHERE `code` IS NULL 375 AND `arg1` = '1' 376 AND `arg2` IS NOT NULL 375 377 ;", 376 ' val'378 'arg2' 377 379 ), 378 380 $groups … … 382 384 $users_granted_direct_ids = order_by_name( 383 385 array_from_query(" 384 SELECT `val` 385 FROM ".EVNTCATS_DUPLIC_TABLE." 386 WHERE `item` = 'usr' 386 SELECT `arg2` 387 FROM ".EVNTCATS_TABLE." 388 WHERE `code` IS NULL 389 AND `arg1` = '2' 390 AND `arg2` IS NOT NULL 387 391 ;", 388 ' val'392 'arg2' 389 393 ), 390 394 $ec_lists['user_ids'] -
extensions/event_cats/main.inc.php
r4276 r4282 43 43 define('EVNTCATS_INFO_VERSION','1.0.0'); 44 44 define('EVNTCATS_PATH',PHPWG_PLUGINS_PATH.basename(dirname(__FILE__)). '/'); 45 define('EVNTCATS_AUTOLOG_TABLE', $prefixeTable.'event_cats_autolog'); 46 define('EVNTCATS_DUPLIC_TABLE', $prefixeTable.'event_cats_duplic'); 45 define('EVNTCATS_TABLE', $prefixeTable.'event_cats'); 47 46 define('ROOT_URL',get_absolute_root_url()); 48 47 … … 67 66 $obj = new event_cats(); 68 67 68 // Adds the translation of "duplicate" link 69 add_event_handler('loading_lang', 'ec_load_duplic_lang' ); 70 71 function ec_load_duplic_lang() { 72 load_language('duplic.lang', EVNTCATS_PATH); 73 } 74 69 75 // Admin help management 70 76 add_event_handler('get_popup_help_content', 'ec_popup_help_content', … … 268 274 if (isset($lang['Duplicate account'])) 269 275 $lang['Create a new account'] = l10n('Duplicate account'); 270 if (isset($lang[' Register']))276 if (isset($lang['Duplicate'])) 271 277 $lang['Register'] = l10n('Duplicate'); 272 278 } -
extensions/event_cats/maintain.inc.php
r4276 r4282 41 41 42 42 pwg_query("DELETE FROM `".CONFIG_TABLE."` WHERE `param` = 'event_cats' LIMIT 1;"); 43 pwg_query('DROP TABLE IF EXISTS `'.$prefixeTable.'event_cats_duplic`;'); 44 return pwg_query('DROP TABLE IF EXISTS `'.$prefixeTable.'event_cats_autolog`;'); 43 return pwg_query('DROP TABLE IF EXISTS `'.$prefixeTable.'event_cats`;'); 45 44 } 46 45 … … 53 52 // create table for plugin, if it doesn't exist yet 54 53 $r = (pwg_query(" 55 CREATE TABLE `".$prefixeTable."event_cats _autolog` (54 CREATE TABLE `".$prefixeTable."event_cats` ( 56 55 `id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT , 57 56 `code` VARCHAR(32) DEFAULT NULL , … … 136 135 137 136 if ($r) $r = (pwg_query(" 138 CREATE TABLE `".$prefixeTable."event_cats_duplic` (139 `item` VARCHAR(5) NOT NULL ,140 `val` VARCHAR(32) NOT NULL ,141 KEY `item` (`item`),142 KEY `val` (`val`)143 )144 DEFAULT CHARACTER SET utf8;145 ") !== false);146 147 /*148 Explanations on table structure :149 150 item : the code used as "autolog" argument. If thie code provided by the151 visitor does not exist in the table, the administrator can choose152 whether the visitor is redirected to the home page (nothing153 happens) or to the "access denied" page ;154 value : the account concerned in following values ;155 156 */157 158 if ($r) $r = (pwg_query("159 137 INSERT INTO `".CONFIG_TABLE."` (`param`,`value`,`comment`) 160 138 VALUES ('event_cats','0','Paramètres du plugin Event Cats');
Note: See TracChangeset
for help on using the changeset viewer.