';
if (array_key_exists('id',$_GET) && preg_match('/^[0-9]+$/',$_GET['id'])===1) {
$_GET['id']+=0;
if ($account['Level']=='guest' && !in_array($_GET['id'],$account['Insts']))
muoribene('You can’t edit data for an instance you don’t own.',true);
$res=mysqli_query($link,'SELECT * FROM Instances WHERE ID='.$_GET['id'])
or muoribene(__LINE__.': '.mysqli_error($link),true);
if (mysqli_num_rows($res)!=1)
muoribene(__LINE__.': There is no instance with ID='.$_GET['ID'].'.',true);
$inst=mysqli_fetch_assoc($res);
} else {
muoribene('Malformed input.',true);
}
$dbg.='
'.print_r($inst,1).'
'.N;
function check($row,$col) {
if ($row[$col]>0)
return(' checked');
else
return('');
}
?>
Mastodon Startpage Admin - Editing «» form
...
'.N);
if (!array_key_exists('edavail',$o) || $o['edavail'])
echo(''.N);
if (!array_key_exists('addavail',$o) || $o['addavail'])
echo(''.N);
if (!array_key_exists('remavail',$o) || $o['remavail'])
echo(''.N);
echo('
'.N);
if ($o['multi']) {
echo('
'.$o['dida'].'
'.N);
}
echo('
'.N);
}
selbox(array(
'multi'=>false,
'dispselid'=>'LocalityID',
'instselid'=>$inst['LocalityID'],
'title'=>'Locality',
'searchid'=>'locsearch',
'searchtit'=>'Filter available localities',
'disparr'=>'locselarr',
'regexcbid'=>'locselre',
'dispque'=>'SELECT ID, Name'.$dlang.' FROM Localities ORDER BY NameOrig ASC',
'valcol'=>'ID',
'txtcol'=>'Name'.$dlang));
$o=array(
'multi'=>true,
'dispselid'=>'DispLangs',
'title'=>'Languages',
'searchid'=>'langsearch',
'searchtit'=>'Filter available languages',
'disparr'=>'langselarr',
'regexcbid'=>'langselre',
'dispque'=>'SELECT ID, CONCAT(Name'.$dlang.'," [",Code,"]") AS Txt FROM Languages WHERE ID NOT IN (SELECT OurLangID FROM InstOurLangs WHERE InstID='.$inst['ID'].') ORDER BY Name'.$dlang.' ASC',
'valcol'=>'ID',
'txtcol'=>'Txt',
'dida'=>'Above: available languages; below: chosen languages',
'chosenselid'=>'ChosenLangs[]',
'chosenque'=>'SELECT OurLangID, CONCAT(Name'.$dlang.'," [",Code,"]") AS Txt FROM InstOurLangs LEFT JOIN Languages ON Languages.ID=OurLangID WHERE InstID='.$inst['ID'].' ORDER BY Pos ASC',
'chosenvalcol'=>'OurLangID');
if ($account['Level']=='guest') {
$o['edavail']=false;
$o['addavail']=false;
$o['remavail']=false;
}
selbox($o);
?>
>
true,
'dispselid'=>'DispFinModes',
'title'=>'Financing methods',
'searchid'=>'finsearch',
'searchtit'=>'Filter available financing methods',
'disparr'=>'finselarr',
'regexcbid'=>'finselre',
'dispque'=>'SELECT * FROM Financing WHERE ID NOT IN (SELECT FinID FROM InstFinancing WHERE InstID='.$inst['ID'].') ORDER BY Type ASC',
'valcol'=>'ID',
'txtcol'=>'Type',
'dida'=>'Above: available fin. methods; below: chosen fin. methods',
'chosenselid'=>'ChosenFinModes[]',
'chosenque'=>'SELECT * FROM InstFinancing LEFT JOIN Financing ON Financing.ID=FinID WHERE InstID='.$inst['ID'].' ORDER BY Pos ASC',
'chosenvalcol'=>'FinID'));
selbox(array(
'multi'=>true,
'dispselid'=>'DispPolicies',
'title'=>'Policies',
'searchid'=>'polsearch',
'searchtit'=>'Filter policies',
'disparr'=>'polselarr',
'regexcbid'=>'polselre',
'dispque'=>'SELECT * FROM Policies WHERE ID NOT IN (SELECT PolID FROM InstPolicies WHERE InstID='.$inst['ID'].') ORDER BY Name ASC',
'valcol'=>'ID',
'txtcol'=>'Name',
'dida'=>'Above: available policies; below: chosen policies',
'chosenselid'=>'ChosenPolicies[]',
'chosenque'=>'SELECT * FROM InstPolicies LEFT JOIN Policies ON Policies.ID=PolID WHERE InstID='.$inst['ID'].' ORDER BY Pos ASC',
'chosenvalcol'=>'PolID'));
selbox(array(
'multi'=>true,
'dispselid'=>'DispTags',
'title'=>'Tags',
'searchid'=>'tagsearch',
'searchtit'=>'Filter tags',
'disparr'=>'tagselarr',
'regexcbid'=>'tagselre',
'dispque'=>'SELECT * FROM Tags WHERE ID NOT IN (SELECT TagID FROM InstTags WHERE InstID='.$inst['ID'].') ORDER BY Name ASC',
'valcol'=>'ID',
'txtcol'=>'Name',
'dida'=>'Above: available tags; below: chosen tags',
'chosenselid'=>'ChosenTags[]',
'chosenque'=>'SELECT * FROM InstTags LEFT JOIN Tags ON Tags.ID=TagID WHERE InstID='.$inst['ID'].' ORDER BY Pos ASC',
'chosenvalcol'=>'TagID'));
?>