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

/phplist/admin/commonlib/pages/attributes.php

https://github.com/radicaldesigns/amp
PHP | 368 lines | 289 code | 20 blank | 59 comment | 82 complexity | eed46325d71a73f6624bc974adce905c MD5 | raw file
Possible License(s): LGPL-2.1, GPL-2.0, BSD-3-Clause, LGPL-2.0, CC-BY-SA-3.0, AGPL-1.0 
    

  1. <?
    2. 

  2. $types = array('textline','checkbox','checkboxgroup','radio','select',"hidden","textarea","date");
    3. 

  3. $formtable_exists = Sql_Table_exists("formfield");
    4. 

  4. 

  5. ob_end_flush();
    6. 

  6. #foreach ($_POST as $key => $val) {
    7. 

  7. #  print "$key = ".print_r($val)."<br/>";
    8. 

  8. #}
    9. 

  9. #return;
    10. 

  10. 

  11. print '<script language="Javascript" src="js/progressbar.js" type="text/javascript"></script>';
    12. 

  12. if (isset($_POST["action"])) {
    13. 

  13.   if (isset($_POST["name"])) {
    14. 

  14.     print '<script language="Javascript" type="text/javascript"> document.write(progressmeter); start();</script>';flush();
    15. 

  15.     while (list($id,$val) = each ($_POST["name"])) {
    16. 

  16.       if (!$id && isset($_POST["name"][0]) && $_POST["name"][0] != "") {
    17. 

  17.         # it is a new one
    18. 

  18.         $lc_name = getNewAttributeTablename($_POST["name"][0]);        
    19. 

  19.         if ($lc_name == "email") { print Warn($GLOBALS['I18N']->get('warnemailattribute')); }
    20. 

  20. 

  21.         #print "New attribute: ".$_POST["name"][0]."<br/>";
    22. 

  22.         $query = sprintf('insert into %s (name,type,listorder,default_value,required,tablename) values("%s","%s",%d,"%s",%d,"%s")',
    23. 

  23.         $tables["attribute"],addslashes($_POST["name"][0]),$_POST["type"][0],$_POST["listorder"][0],addslashes($_POST["default"][0]),$_POST["required"][0],$lc_name);
    24. 

  24.         Sql_Query($query);
    25. 

  25.         $insertid = Sql_Insert_id();
    26. 

  26. 

  27.         # text boxes and hidden fields do not have their own table
    28. 

  28.         if ($_POST["type"][$id] != "textline" && $_POST["type"]["id"] != "hidden") {
    29. 

  29.           $query = "create table $table_prefix"."listattr_$lc_name (id integer not null primary key auto_increment, name varchar(255) unique,listorder integer default 0)";
    30. 

  30.           Sql_Query($query);
    31. 

  31.         } else {
    32. 

  32.           # and they cannot currently be required, changed 29/08/01, insert javascript to require them, except for hidden ones :-)
    33. 

  33.           if ($_POST["type"]["id"] == "hidden")
    34. 

  34.             Sql_Query("update {$tables['attribute']} set required = 0 where id = $insertid");
    35. 

  35.         }
    36. 

  36.         if ($_POST["type"][$id] == "checkbox") {
    37. 

  37.           # with a checkbox we know the values
    38. 

  38. #          Sql_Query('insert into '.$table_prefix.'listattr_'.$lc_name.' (name) values("Checked")');
    39. 

  39. #          Sql_Query('insert into '.$table_prefix.'listattr_'.$lc_name.' (name) values("Unchecked")');
    40. 

  40.           # we cannot "require" checkboxes, that does not make sense
    41. 

  41.           Sql_Query("update {$tables['attribute']} set required = 0 where id = $insertid");
    42. 

  42.         }
    43. 

  43.         if ($_POST["type"][$id] == "checkboxgroup")
    44. 

  44.           Sql_Query("update {$tables['attribute']} set required = 0 where id = $insertid");
    45. 

  45. 

  46.         # fix all existing users to have a record for this attribute, even with empty data
    47. 

  47.         $req = Sql_Query("select id from {$tables["user"]}");
    48. 

  48.         while ($row = Sql_Fetch_Row($req)) {
    49. 

  49.           Sql_Query(sprintf('insert ignore into %s (attributeid,userid) values(%d,%d)',
    50. 

  50.             $tables["user_attribute"],$insertid,$row[0]));
    51. 

  51.         }
    52. 

  52.       } elseif ($_POST["name"][$id] != "") {
    53. 

  53.         # it is a change
    54. 

  54.         # get the original type
    55. 

  55. 

  56.         $req = Sql_Fetch_Row_Query("select type,tablename from {$tables['attribute']} where id = $id");
    57. 

  57.         $existingtype = $req[0];
    58. 

  58.         #print "Existing attribute: ".$_POST["name"][$id]." new type:".$_POST["type"][$id]." existing type: ".$req[0]."<br/>";
    59. 

  59. 

  60.         if ($_POST["type"][$id] != $existingtype)
    61. 

  61.         switch ($existingtype) {
    62. 

  62.           case "textline":case "hidden":case "date":
    63. 

  63.           	 print "Converting ".$_POST["name"][$id]." from $existingtype to ".$_POST["type"][$id]."<br/>";
    64. 

  64.              switch ($_POST["type"][$id]) {
    65. 

  65.             	case "radio":
    66. 

  66.               case "checkboxgroup":
    67. 

  67.               case "select":
    68. 

  68.                 $lc_name = getNewAttributeTablename($req[1]);
    69. 

  69.                 Sql_Query("create table $table_prefix"."listattr_$lc_name (id integer not null primary key auto_increment, name varchar(255) unique,listorder integer default 0)");
    70. 

  70.                 $attreq = Sql_Query("select distinct value from {$tables['user_attribute']} where attributeid = $id");
    71. 

  71.                 while ($row = Sql_Fetch_Row($attreq)) {
    72. 

  72.                   $attindexreq = Sql_Query("select id from $table_prefix"."listattr_$lc_name where name = \"$row[0]\"");
    73. 

  73.                   if (!Sql_Affected_Rows()) {
    74. 

  74.                     Sql_Query("insert into $table_prefix"."listattr_$lc_name (name) values(\"$row[0]\")");
    75. 

  75.                     $attid = Sql_Insert_Id();
    76. 

  76.                   } else {
    77. 

  77.                     $attindex = Sql_Fetch_Row($attindexreq);
    78. 

  78.                     $attid = $attindex[0];
    79. 

  79.                   }
    80. 

  80.                   Sql_Query("update {$tables['user_attribute']} set value = $attid where attributeid = $id and value = \"$row[0]\"");
    81. 

  81.                 }
    82. 

  82.                 break;
    83. 

  83.               case "checkbox":
    84. 

  84.               # in case of checkbox we just need to set the value to "on"
    85. 

  85.                 Sql_Query("update {$tables['user_attribute']} set value = \"off\" where attributeid = $id and (value = 0 or value = \"off\")");
    86. 

  86.                 Sql_Query("update {$tables['user_attribute']} set value = \"on\" where attributeid = $id and (value = 1 or value = \"on\") ");
    87. 

  87.               case "date":
    88. 

  88.               	$attreq = Sql_Query("select * from {$tables['user_attribute']} where attributeid = $id");
    89. 

  89.                 while ($row = Sql_Fetch_Array($attreq)) {
    90. 

  90. #                	if (strlen($row["value"] > 5)) {
    91. 

  91.                   	Sql_Query(sprintf('update %s set value = "%s" where attributeid = %d and userid = %d',$tables["user_attribute"],parseDate($row["value"]),$row["attributeid"],$row["userid"]));
    92. 

  92. #                  }
    93. 

  93.                 }
    94. 

  94.                 break;
    95. 

  95.             }
    96. 

  96.             break;
    97. 

  97.           case "radio":case "select": case "checkbox":
    98. 

  98.             if ($_POST["type"][$id] != "date" && $_POST["type"][$id] != "hidden" && $_POST["type"][$id] != "textline") break;
    99. 

  99.           	print "Converting ".$_POST["name"][$id]." from $existingtype to ".$_POST["type"][$id]."<br/>";
    100. 

  100.             # we are turning a radio,select or checkbox into a hidden or textline field
    101. 

  101.             $valuereq = Sql_Query("select id,name from $table_prefix"."listattr_$req[1]");
    102. 

  102.             while ($row = Sql_Fetch_Row($valuereq))
    103. 

  103.               Sql_Query("update {$tables['user_attribute']} set value = \"$row[1]\" where attributeid = $id and value=\"$row[0]\"");
    104. 

  104.             Sql_Query("drop table $table_prefix"."listattr_$req[1]");
    105. 

  105.             break;
    106. 

  106.           case "checkboxgroup":
    107. 

  107.             if ($_POST["type"][$id] == "hidden" || $_POST["type"][$id] == "textline") {
    108. 

  108. 		         	 print $GLOBALS['I18N']->get('converting')." ".$_POST["name"][$id]." ".$GLOBALS['I18N']->get('from')." $existingtype ".$GLOBALS['I18N']->get('to')." ".$_POST["type"][$id]."<br/>";
    109. 

  109.             	# we are changing a checkbox group into a hidden or textline
    110. 

  110.               # take the first value!
    111. 

  111.               $valuereq = Sql_Query("select id,name from $table_prefix"."listattr_$req[1]");
    112. 

  112.               while ($row = Sql_Fetch_Row($valuereq))
    113. 

  113.                 Sql_Query("update {$tables['user_attribute']} set value = \"$row[1]\" where attributeid = $id and value like \"$row[0]%\"");
    114. 

  114. 	            Sql_Query("drop table if exists $table_prefix"."listattr_$req[1]");
    115. 

  115.             } elseif ($_POST["type"][$id] == "radio" || $_POST["type"][$id] == "select") {
    116. 

  116.               $valuereq = Sql_Query("select userid,value from {$tables["user_attribute"]} where attributeid = $id");
    117. 

  117.               # take the first value!
    118. 

  118.               while ($row = Sql_Fetch_Row($valuereq)) {
    119. 

  119.               	$values = split(",",$row[1]);
    120. 

  120.                 Sql_Query("update {$tables['user_attribute']} set value = \"$values[0]\" where attributeid = $id and userid = \"$row[0]\"");
    121. 

  121.               }
    122. 

  122.             }
    123. 

  123.             break;
    124. 

  124.         }
    125. 

  125.         $query = sprintf('update %s set name = "%s" ,type = "%s" ,listorder = %d,default_value = "%s" ,required = %d where id = %d',
    126. 

  126.         $tables["attribute"],addslashes($_POST["name"][$id]),$_POST["type"][$id],$listorder[$id],$default[$id],$required[$id],$id);
    127. 

  127.         Sql_Query($query);
    128. 

  128.       }
    129. 

  129.     }
    130. 

  130.     print '<script language="Javascript" type="text/javascript"> finish();</script>';flush();
    131. 

  131.   }
    132. 

  132. } elseif (isset($_POST["tagaction"]) && is_array($_POST["tag"])) {
    133. 

  133. 	ksort($_POST["tag"]);
    134. 

  134.   if ($_POST["tagaction"] == $GLOBALS['I18N']->get('delete')) {
    135. 

  135.     while (list($k,$id) = each ($_POST["tag"])) {
    136. 

  136.       # check for dependencies
    137. 

  137.       if ($formtable_exists) {
    138. 

  138.         $req = Sql_Query("select * from formfield where attribute = $id");
    139. 

  139.         $candelete = !Sql_Affected_Rows();
    140. 

  140.       } else {
    141. 

  141.         $candelete = 1;
    142. 

  142.       }
    143. 

  143.       if ($candelete) {
    144. 

  144.         print $GLOBALS['I18N']->get('deleting')." $id<br/>";
    145. 

  145.         $row = Sql_Fetch_Row_Query("select tablename,type from {$tables['attribute']} where id = $id");
    146. 

  146.         Sql_Query("drop table if exists $table_prefix"."listattr_$row[0]");
    147. 

  147.         Sql_Query("delete from {$tables['attribute']} where id = $id");
    148. 

  148.         # delete all user attributes as well
    149. 

  149.         Sql_Query("delete from {$tables['user_attribute']} where attributeid = $id");
    150. 

  150.       } else {
    151. 

  151.         print Error($GLOBALS['I18N']->get('cannotdelete')."<br/>");
    152. 

  152.         while ($row = Sql_Fetch_Array($req)) {
    153. 

  153.           print PageLink2("editelements&id=".$row["form"]."&option=edit_elements&pi=formbuilder","form ".$row["form"]."")."<br/>\n";
    154. 

  154.         }
    155. 

  155.       }
    156. 

  156.     }
    157. 

  157.  	} elseif ($_POST["tagaction"] == $GLOBALS['I18N']->get('merge')) {
    158. 

  158.     $first = array_shift($_POST["tag"]);
    159. 

  159.     $firstdata = Sql_Fetch_Array_Query(sprintf('select * from %s where id = %d',$tables["attribute"],$first));
    160. 

  160.     if (!sizeof($_POST["tag"])) {
    161. 

  161.     	print Error($GLOBALS['I18N']->get('cannotmergeone'));
    162. 

  162.     } else {
    163. 

  163.     	$cbg_initiated = 0;
    164. 

  164.     	foreach ($_POST["tag"] as $attid) {
    165. 

  165.       	print $GLOBALS['I18N']->get('merging')." $attid ".$GLOBALS['I18N']->get('into')." $first<br/>";
    166. 

  166.         
    167. 

  167. 		    $attdata = Sql_Fetch_Array_Query(sprintf('select * from %s where id = %d',$tables["attribute"],$attid));
    168. 

  168.         if ($attdata["type"] != $firstdata["type"]) {
    169. 

  169.         	print Error($GLOBALS['I18N']->get('notsametype'));
    170. 

  170.         } else {
    171. 

  171.           # debugging: check values for every user. This is very memory demanding, so you'll need to
    172. 

  172.           # add loads of memory to actually use it.
    173. 

  173. /*
    174. 

  174.           $before = array();
    175. 

  175.           $second = array();
    176. 

  176.           $after = array();
    177. 

  177.           $req = Sql_Query(sprintf('select * from %s where attributeid = %d',$tables["user_attribute"],$first));
    178. 

  178.           while ($row = Sql_Fetch_Array($req)) {
    179. 

  179.             $before[$row["userid"]] = $row["value"];
    180. 

  180.           }
    181. 

  181.           $req = Sql_Query(sprintf('select * from %s where attributeid = %d',$tables["user_attribute"],$attid));
    182. 

  182.           while ($row = Sql_Fetch_Array($req)) {
    183. 

  183.             $second[$row["userid"]] = $row["value"];
    184. 

  184.           }
    185. 

  185. */
    186. 

  186.           $valuestable = sprintf('%slistattr_%s',$table_prefix,$firstdata["tablename"]);
    187. 

  187.         	if ($firstdata["type"] == "checkbox" && !$cbg_initiated) {
    188. 

  188.             # checkboxes are merged into a checkbox group
    189. 

  189.             # set that up first
    190. 

  190.             Sql_query(sprintf('create table %s
    191. 

  191.             (id integer not null primary key auto_increment, name varchar(255) unique,
    192. 

  192.             listorder integer default 0)',$valuestable),1);
    193. 

  193.             Sql_query(sprintf('insert into %s (name) values("%s")',$valuestable,$firstdata["name"]));
    194. 

  194.             $val = Sql_Insert_Id();
    195. 

  195.             Sql_query(sprintf('update %s set value="%s" where attributeid = %d',
    196. 

  196.               $tables["user_attribute"],$val,$first));
    197. 

  197.             Sql_query(sprintf('update %s set type="checkboxgroup" where id = %d',
    198. 

  198.               $tables["attribute"],$first));
    199. 

  199.             $cbg_initiated = 1;
    200. 

  200. 					}
    201. 

  201.         	switch ($firstdata["type"]) {
    202. 

  202.           	case "textline":
    203. 

  203.             case "hidden":
    204. 

  204.             case "textarea":
    205. 

  205.             case "date":
    206. 

  206. 			        Sql_query(sprintf('delete from %s where attributeid = %d and value = ""',$tables["user_attribute"],$first));
    207. 

  207.             	# we can just keep the data and mark it as the first attribute
    208. 

  208.               Sql_query(sprintf('update ignore %s set attributeid = %d where attributeid = %d',
    209. 

  209.                 $tables["user_attribute"],$first,$attid),1);
    210. 

  210.               # delete the ones that didn't copy across, because there was a value already
    211. 

  211.               Sql_query(sprintf('delete from %s where id = %d',
    212. 

  212.                 $tables["attribute"],$attid));
    213. 

  213.               # mark forms to use the merged attribute
    214. 

  214.               if ($formtable_exists)
    215. 

  215.                 Sql_Query(sprintf('update formfield set attribute = %d where attribute = %d',$first,$attid),1);
    216. 

  216.               break;
    217. 

  217.             case "radio":
    218. 

  218.             case "select":
    219. 

  219.             	# merge user values
    220. 

  220. 			        Sql_Query(sprintf('delete from %s where attributeid = %d and value = ""',$tables["user_attribute"],$first));
    221. 

  221.               $req = Sql_Query(sprintf('select * from %s',
    222. 

  222.               	$table_prefix."listattr_".$attdata["tablename"]));
    223. 

  223.               while ($val = Sql_Fetch_Array($req)) {
    224. 

  224.               	# check if it already exists
    225. 

  225.                 $exists = Sql_Fetch_row_Query(sprintf('select id from %s where name = "%s"',
    226. 

  226.                 	$valuestable,$val["name"]));
    227. 

  227.                 if (!$exists[0]) {
    228. 

  228.                   Sql_Query(sprintf('insert into %s (name) values("%s")',
    229. 

  229.                     $valuestable,$val["name"]));
    230. 

  230.                   $val_index = Sql_Insert_id();
    231. 

  231.                 } else {
    232. 

  232.                 	$val_index = $exists[0];
    233. 

  233.                 }
    234. 

  234.                 Sql_Query(sprintf('update %s set value = %d where attributeid = %d',
    235. 

  235.                   $tables["user_attribute"],$val_index,$attid));
    236. 

  236.               }
    237. 

  237.               Sql_Query(sprintf('update %s set attributeid = %d where attributeid = %d',
    238. 

  238.                 $tables["user_attribute"],$first,$attid),1);
    239. 

  239.               Sql_Query(sprintf('drop table %s',$table_prefix."listattr_".$attdata["tablename"]),1);
    240. 

  240.               Sql_Query(sprintf('delete from %s where id = %d',
    241. 

  241.                 $tables["attribute"],$attid));
    242. 

  242.               # mark forms to use the merged attribute
    243. 

  243.               if ($formtable_exists)
    244. 

  244.                 Sql_Query(sprintf('update formfield set attribute = %d where attribute = %d',$first,$attid),1);
    245. 

  245.               break;
    246. 

  246.             case "checkbox":
    247. 

  247.               $exists = Sql_Fetch_row_Query(sprintf('select id from %s where name = "%s"',
    248. 

  248.                 $valuestable,$attdata["name"]));
    249. 

  249.               if (!$exists[0]) {
    250. 

  250.                 Sql_Query(sprintf('insert into %s (name) values("%s")',
    251. 

  251.                   $valuestable,$attdata["name"]));
    252. 

  252.                 $val_index = Sql_Insert_id();
    253. 

  253.               } else {
    254. 

  254.                 $val_index = $exists[0];
    255. 

  255.               }
    256. 

  256.               Sql_Query(sprintf('update %s set value = concat(value,",","%s") where attributeid = %d and (value != 0 or value != "off") ',
    257. 

  257.                 $tables["user_attribute"],$val_index,$first));
    258. 

  258.               Sql_Query(sprintf('delete from %s where id = %d',
    259. 

  259.                 $tables["attribute"],$attid));
    260. 

  260.               # mark forms to use the merged attribute
    261. 

  261.               if ($formtable_exists)
    262. 

  262.                 Sql_Query(sprintf('update formfield set attribute = %d where attribute = %d',$first,$attid),1);
    263. 

  263.               break;
    264. 

  264.             case "checkboxgroup":
    265. 

  265.             	# hmm, this is a tricky one.
    266. 

  266.              	print Error($GLOBALS['I18N']->get('sorrymergingcbgroupnotimplemented'));
    267. 

  267.               break;
    268. 

  268.          	}
    269. 

  269. 

  270. /*
    271. 

  271.           $req = Sql_Query(sprintf('select * from %s where attributeid = %d',$tables["user_attribute"],$first));
    272. 

  272.           while ($row = Sql_Fetch_Array($req)) {
    273. 

  273.             $after[$row["userid"]] = $row["value"];
    274. 

  274.           }
    275. 

  275.           foreach ($before as $userid => $value) {
    276. 

  276.             printf("\n".'<br/>%d before -> %s and %s<br/>after ->%s',$userid,$value,$second[$userid],$after[$userid]);
    277. 

  277.           }
    278. 

  278. */
    279. 

  279. 

  280.         }
    281. 

  281.       }
    282. 

  282.     }
    283. 

  283. 	}
    284. 

  284. }
    285. 

  285. Sql_Query("update {$tables['attribute']} set required = 0 where type = \"checkbox\" or type = \"checkboxgroup\" or type = \"hidden\"");
    286. 

  286. 

  287. ?>
    288. 

  288. 

  289. <script language="Javascript" type="text/javascript">
    290. 

  290. var warned = 0;
    291. 

  291. function warn() {
    292. 

  292.   if (!warned)
    293. 

  293.     alert("<?php echo $GLOBALS['I18N']->get('warninglongtime')?>");
    294. 

  294.   warned = 1;
    295. 

  295. }
    296. 

  296. </script>
    297. 

  297. <?=formStart()?>
    298. 

  298. <?
    299. 

  299. print $GLOBALS['I18N']->get('loadfrom')." ".PageLink2("defaults",$GLOBALS['I18N']->get('defaults')).'<br />';
    300. 

  300. 

  301. $res = Sql_Query("select * from {$tables['attribute']} order by listorder");
    302. 

  302. if (Sql_Affected_Rows()) 
    303. 

  303.   print $GLOBALS['I18N']->get('existing').":<p>";
    304. 

  304. else {
    305. 

  305.   print $GLOBALS['I18N']->get('noattributesdefined').'<br />';
    306. 

  306. }
    307. 

  307. $c= 0;
    308. 

  308. while ($row = Sql_Fetch_array($res)) {
    309. 

  309. 	$c++;
    310. 

  310.   print '<table border=1><tr><td colspan=2>'.
    311. 

  311.   $GLOBALS['I18N']->get('attribute').':'. $row["id"];
    312. 

  312.   if ($formtable_exists) {
    313. 

  313.     sql_query("select * from formfield where attribute = ".$row["id"]);
    314. 

  314.     print "  (".$GLOBALS['I18N']->get('usedin').' '.Sql_affected_rows().' '.$GLOBALS['I18N']->get('forms');
    315. 

  315.   }
    316. 

  316.     
    317. 

  317.   print '</td><td colspan=2>'.$GLOBALS['I18N']->get('tag').' <input type="checkbox" name="tag['.$c.']" value="'.$row["id"].'"></td></tr>';
    318. 

  318.     
    319. 

  319.   print '<tr><td colspan=2>'.$GLOBALS['I18N']->get('name').': </td><td colspan=2><input type=text name="name['.$row["id"].']" value="'.htmlspecialchars(stripslashes($row["name"])).'" size=40></td></tr>';
    320. 

  320.   print '<tr><td colspan=2>'.$GLOBALS['I18N']->get('type').': </td><td colspan=2><!--input type=hidden name="type['.$row["id"].']" value="'.$row["type"].'">'.$row["type"].'-->';
    321. 

  321. 

  322.   print '<select name="type['.$row["id"].']" onChange="warn();">';
    323. 

  323.   foreach($types as $key => $val) {
    324. 

  324.     printf('<option value="%s" %s>%s</option>',$val,$val == $row["type"] ? "selected": "",$GLOBALS['I18N']->get($val));
    325. 

  325.   }
    326. 

  326.   print ' 
    327. 

  327.    </select>';
    328. 

    329. 

  329.   print '</td></tr>';
    330. 

  330.   print '<tr><td colspan=2>'.$GLOBALS['I18N']->get('defaultvalue').': </td><td colspan=2><input type=text name="default['.$row["id"].']" value="'.htmlspecialchars(stripslashes($row["default_value"])).'" size=40></td></tr>';
    331. 

  331.   print '<tr><td>'.$GLOBALS['I18N']->get('orderoflisting').': </td><td><input type=text name="listorder['.$row["id"].']" value="'.$row["listorder"].'" size=5></td>';
    332. 

  332.   print '<td>'.$GLOBALS['I18N']->get('isrequired').': </td><td><input type=checkbox name="required['.$row["id"].']" value="1" ';
    333. 

  333.   print $row["required"] ? "checked": "";
    334. 

  334.   print  '></td></tr>';
    335. 

  335.   print '</table><hr>';
    336. 

  336.  } 
    337. 

  337.  printf('<input type=submit name="action" value="%s">',$GLOBALS['I18N']->get('savechanges'));
    338. 

  338. 

  339. print '<br/><br/>
    340. 

  340. <script language="Javascript" src="js/jslib.js" type="text/javascript"></script>';
    341. 

    342. 

  342. if ($c) {
    343. 

  343.   printf('<i>%s: </i><br/>',$GLOBALS['I18N']->get('withtagged'));
    344. 

  344.   printf('<input type=submit name="tagaction" value="%s">&nbsp;
    345. 

  345.   <input type=submit name="tagaction" value="%s"> &nbsp;&nbsp;%s<br/>
    346. 

  346.   <p><hr/></p>',$GLOBALS['I18N']->get('delete'),$GLOBALS['I18N']->get('merge'),Help("mergeattributes"));
    347. 

  347. }
    348. 

  348. 

  349. print '
    350. 

  350. <a name="new"></a>
    351. 

  351. <h3>'.$GLOBALS['I18N']->get('addnew').':</h3>
    352. 

  352. <table border=1>
    353. 

  353. <tr><td colspan=2>'.$GLOBALS['I18N']->get('name').': </td><td colspan=2><input type=text name="name[0]" value="" size=40></td></tr>
    354. 

  354. <tr><td colspan=2>'.$GLOBALS['I18N']->get('type').': </td><td colspan=2><select name="type[0]">';
    355. 

  355. foreach($types as $key => $val) {
    356. 

  356.   printf('<option value="%s" %s>%s</option>',$val,"",$GLOBALS['I18N']->get($val));
    357. 

  357. }
    358. 

  358. print'
    359. 

  359. </select></td></tr>
    360. 

  360. <tr><td colspan=2>'.$GLOBALS['I18N']->get('defaultvalue').': </td><td colspan=2><input type=text name="default[0]" value="" size=40></td></tr>
    361. 

  361. <tr><td>'.$GLOBALS['I18N']->get('orderoflisting').': </td><td><input type=text name="listorder[0]" value="" size=5></td>
    362. 

  362. <td>'.$GLOBALS['I18N']->get('isrequired').': </td><td><input type=checkbox name="required[0]" value="1" checked></td></tr>
    363. 

  363. </table><hr>
    364. 

  364. 

  365. <input type=submit name="action" value="'.$GLOBALS['I18N']->get('savechanges').'">
    366. 

  366. </form>
    367. 

  367. 

  368. ';
    369.