// Method put on each input component to unregister
  // itself from the form
  detachFromForm: function detachFromForm(component) {
    var componentPos = this.inputs.indexOf(component);

    if (componentPos !== -1) {
      this.inputs = this.inputs.slice(0, componentPos).concat(this.inputs.slice(componentPos + 1));
    }

    this.validateForm();
  },

oh boy

By Anonymous, 2017-12-21 10:48:00
// Number 1:

onClipEvent(load){
   risespeed = 8;
   waittime = _root.framerate * 7.5;
   count = _root.framerate * 1;
   groundwaittime = _root.framerate * 1;
}

// Number 2:

gotoAndStop(Math.round(frame) * 1 / 1);

// Number 3:

_root.DoorTrasition = function(doorplace)
{
   if(doorplace == "XY")
   {
      _root.Course.Char._x = _root.WarpPipeX + _root.Course.BackGFX._x;
      _root.Course.Char._y = _root.WarpPipeY + _root.Course.BackGFX._y;
      _root.Course.Char.attack = false;
      _root.attachMovie("StarIn","Transition",_root.getNextHighestDepth(),{_x:_root.screensizeX / 2,_y:_root.screensizeY / 2});
   }
   else if(doorplace == "inCastle")
   {
      _root.StartInsideofCastle();
   }
   else if(doorplace == "outCastle")
   {
      _root.RemoveCourse();
      _root.gotoAndStop("Courseframe");
      _root.StartChar("Castle",0,50,0,50,150,_root.CurrentPlayer,_root.Fluddpow,"StarIn",true);
      _root.onEnterFrame = function()
      {
         _root.CharCode();
      };
   }
   else if(doorplace == "C-MR")
   {
      _root.changecourse("StarIn","C-4-SC1",-674,-60,-674,-60);
   }
   else if(doorplace == "C-MR-back")
   {
      _root.changecourse("StarIn","C-4",1260,0,1260,0);
   }
   else if(doorplace == "C-1-1")
   {
      _root.changecourse("StarIn","C-1",0,0,0,0);
   }
   else if(doorplace == "Castle-02")
   {
      _root.changecourse("StarIn","Castle",1400,390,1400,390,true);
   }
   else if(doorplace == "C-1-2")
   {
      _root.changecourse("StarIn","C-1",-550,-60,-550,-60);
   }
   else if(doorplace == "C-1-3")
   {
      _root.changecourse("StarIn","C-1",550,-60,550,-60);
   }
   else if(doorplace == "C-1-4")
   {
      _root.changecourse("StarIn","C-1",0,-195,0,-195);
   }
   else if(doorplace == "C-1-5")
   {
      _root.changecourse("StarIn","C-1",160,0,160,0);
   }
   else if(doorplace == "C-1-6")
   {
      _root.changecourse("StarIn","C-1",-160,0,-160,0);
   }
   else if(doorplace == "C-1-7")
   {
      _root.changecourse("StarIn","C-1",460,-200,460,-200);
   }
   else if(doorplace == "C-1-8")
   {
      _root.changecourse("StarIn","C-1",-460,-200,-460,-200);
   }
   else if(doorplace == "C-1-9")
   {
      _root.changecourse("StarIn","C-1",-390,-16,-390,-16);
   }
   else if(doorplace == "C-1-10")
   {
      _root.changecourse("StarIn","C-1",390,-16,390,-16);
   }
   else if(doorplace == "C-2-1")
   {
      _root.changecourse("StarIn","C-2",0,0,0,0);
   }
   else if(doorplace == "C-2-2")
   {
      _root.changecourse("StarIn","C-2-2",0,0,0,0);
   }
   else if(doorplace == "C-3-1")
   {
      _root.changecourse("StarIn","C-3",0,0,0,0);
   }
   else if(doorplace == "C-3-2")
   {
      _root.changecourse("StarIn","C-3-2",0,0,0,0);
   }
   else if(doorplace == "C-4-1")
   {
      _root.changecourse("StarIn","C-4",0,0,0,0);
   }
   else if(doorplace == "C-4-2")
   {
      _root.changecourse("StarIn","C-4",-846,-406,-846,-400);
   }
   else if(doorplace == "C-4-L")
   {
      if(_root.CurrentPlayer !== "Luigi")
      {
         _root.CurrentPlayer = "Luigi";
      }
      else
      {
         _root.CurrentPlayer = "Mario";
      }
      _root.changecourse("StarIn","C-4",1100,0,1100,0);
   }
   else if(doorplace == "C-4H-1")
   {
      _root.changecourse("StarIn","C-4H",0,0,0,0);
   }
   else if(doorplace == "C-4H-2")
   {
      _root.changecourse("StarIn","C-4H",0,0,382,-85);
   }
   else if(doorplace == "C-4H-sd")
   {
      _root.changecourse("StarIn","C-4H",400,-365,400,-365);
   }
   else if(doorplace == "C-4H-3")
   {
      _root.changecourse("StarIn","C-4H",0,-300,20,-575);
   }
   else if(doorplace == "C-5-1")
   {
      _root.changecourse("StarIn","C-5",0,0,0,0);
   }
   else if(doorplace == "C-6-1")
   {
      _root.changecourse("StarIn","C-6",250,0,250,0);
   }
   else if(doorplace == "C-6-2")
   {
      _root.changecourse("StarIn","C-6",-250,0,-250,0);
   }
   else if(doorplace == "C-6-3")
   {
      _root.changecourse("StarIn","C-6",0,-95,0,-95,true);
   }
   else if(doorplace == "C-6-4")
   {
      _root.changecourse("StarIn","C-6",0,80,0,80);
   }
   else if(doorplace == "C-7-1")
   {
      _root.changecourse("StarIn","C-7",0,0,0,0);
   }
   else if(doorplace == "C-7-2")
   {
      _root.changecourse("StarIn","C-7",-820,12,-820,12);
   }
   else if(doorplace == "C-7-3")
   {
      _root.changecourse("StarIn","C-7",610,40,610,40);
   }
   else if(doorplace == "C-8-1")
   {
      _root.changecourse("StarIn","C-8",0,0,0,0);
   }
   else if(doorplace == "C-8-2")
   {
      _root.changecourse("StarIn","C-8",784,-16,784,-16);
   }
   else if(doorplace == "C-8-3")
   {
      _root.changecourse("StarIn","C-8",1201,45,1201,45,true);
   }
   else if(doorplace == "C-9-1")
   {
      _root.changecourse("StarIn","C-9",0,0,0,0);
   }
   else if(doorplace == "C-9-2")
   {
      _root.changecourse("StarIn","C-9",300,-185,300,-185);
   }
   else if(doorplace == "C-10-1")
   {
      _root.changecourse("StarIn","C-10",0,0,0,0);
   }
   else if(doorplace == "C-10-2")
   {
      _root.changecourse("StarIn","C-10",-223,0,-223,0);
   }
   else if(doorplace == "C-10-3")
   {
      _root.changecourse("StarIn","C-10",720,-185,720,-185);
   }
   else if(doorplace == "C-10-sd")
   {
      _root.changecourse("StarIn","C-10",-235,-575,-235,-575);
   }
   else if(doorplace == "C-10-D3")
   {
      _root.changecourse("StarIn","C-10",-170,-512,-170,-512,true);
   }
   else if(doorplace == "C-10-D2")
   {
      _root.changecourse("StarIn","C-10",-235,-512,-235,0);
   }
   else if(doorplace == "C-10-D1")
   {
      _root.changecourse("StarIn","C-10",-297,-512,-297,0);
   }
   else if(doorplace == "C-11-1")
   {
      _root.changecourse("StarIn","C-11",0,0,0,0);
   }
   else if(doorplace == "C-12-1")
   {
      _root.changecourse("StarIn","C-12",0,0,0,0);
   }
   else if(doorplace == "C-12-2")
   {
      _root.changecourse("StarIn","C-12",80,-250,80,-250);
   }
   else if(doorplace == "C-13-1")
   {
      _root.changecourse("StarIn","C-13",0,0,0,0);
   }
   else if(doorplace == "C-O-1")
   {
      _root.changecourse("StarIn","C-O",0,0,0,0,true);
   }
   else if(doorplace == "C-O-2")
   {
      _root.changecourse("StarIn","C-O",300,0,-950,-363,true);
   }
   else if(doorplace == "C-Opening")
   {
      if(_root.Star[39] == true)
      {
         _root.changecourse("righttransition2","Castle",-1300,100,-1300,100);
      }
      else
      {
         _root.bgsong.stop();
         _root.gotoAndStop("Intro2");
         _root.RemoveCourse();
      }
   }
   else if(doorplace == "4-1-1")
   {
      _root.changecourse("StarIn","4-1",610,150,610,150);
   }
   else if(doorplace == "4-1-2")
   {
      _root.changecourse("StarIn","4-1",-315,200,-315,200);
   }
   else if(doorplace == "4-1-3")
   {
      _root.changecourse("StarIn","4-1",610,-810,610,-810);
   }
   else if(doorplace == "4-1-4")
   {
      _root.changecourse("StarIn","4-1",245,-1010,245,-1010);
   }
   else if(doorplace == "4-1-5")
   {
      _root.changecourse("StarIn","4-1",610,-1305,610,-1305);
   }
   else if(doorplace == "4-2-1")
   {
      _root.changecourse("StarIn","4-2",0,0,0,0);
   }
   else if(doorplace == "4-2-2")
   {
      _root.changecourse("StarIn","4-2",-400,0,-400,0);
   }
   else if(doorplace == "4-2-3")
   {
      _root.changecourse("StarIn","4-2",-250,0,-250,0);
   }
   else if(doorplace == "4-2-4")
   {
      _root.changecourse("StarIn","4-2",250,0,250,0);
   }
   else if(doorplace == "4-2-5")
   {
      _root.changecourse("StarIn","4-2",400,0,400,0);
   }
   else if(doorplace == "4-2-6")
   {
      _root.changecourse("StarIn","4-2",-400,-375,-400,-375);
   }
   else if(doorplace == "4-2-7")
   {
      _root.changecourse("StarIn","4-2",-250,-375,-250,-375);
   }
   else if(doorplace == "4-2-8")
   {
      _root.changecourse("StarIn","4-2",250,-375,250,-375);
   }
   else if(doorplace == "4-2-9")
   {
      _root.changecourse("StarIn","4-2",400,-375,400,-375);
   }
   else if(doorplace == "4-2-10")
   {
      _root.changecourse("StarIn","4-2",0,-610,0,-610);
   }
   else if(doorplace == "4-3-1")
   {
      _root.changecourse("StarIn","4-3",0,20,0,20);
   }
   else if(doorplace == "4-3-2")
   {
      _root.changecourse("StarIn","4-3",1300,20,1300,20);
   }
   else if(doorplace == "4-3-3")
   {
      _root.changecourse("StarIn","4-3",0,-780,0,-780);
   }
   else if(doorplace == "4-3-4")
   {
      _root.changecourse("StarIn","4-3",100,-1776,100,-1776);
   }
   else if(doorplace == "4-4-1")
   {
      _root.changecourse("StarIn","4-4",0,20,0,20);
   }
   else if(doorplace == "4-4-2")
   {
      _root.changecourse("StarIn","4-4",-1300,20,-1300,20);
   }
   else if(doorplace == "4-4-3")
   {
      _root.changecourse("StarIn","4-4",0,-780,0,-780);
   }
   else if(doorplace == "4-4-4")
   {
      _root.changecourse("StarIn","4-4",200,-1776,200,-1776);
   }
   else if(doorplace == "4-5-1")
   {
      _root.changecourse("StarIn","4-5",-1300,20,-1300,20);
   }
   else if(doorplace == "4-5-2")
   {
      _root.changecourse("StarIn","4-5",1300,20,1300,20);
   }
   else if(doorplace == "4-6-1")
   {
      _root.changecourse("StarIn","4-6",0,0,0,0);
   }
   else if(doorplace == "4-6-2")
   {
      _root.changecourse("StarIn","4-6",0,-480,0,-480);
   }
   else if(doorplace == "4-7-1")
   {
      _root.changecourse("StarIn","4-7",0,0,0,0);
   }
   else if(doorplace == "4-7-2")
   {
      _root.changecourse("StarIn","4-7",-150,-400,-150,-400);
   }
   else if(doorplace == "4-8-1")
   {
      _root.changecourse("StarIn","4-8",-1350,100,-1350,100);
   }
   else if(doorplace == "4-8-2")
   {
      _root.changecourse("StarIn","4-8",-800,100,-800,100);
   }
   else if(doorplace == "4-8-3")
   {
      _root.changecourse("StarIn","4-8",0,0,0,0);
   }
   else if(doorplace == "4-8-4")
   {
      _root.changecourse("StarIn","4-8",1200,100,1200,100);
   }
   else if(doorplace == "4-8-5")
   {
      _root.changecourse("StarIn","4-8",800,100,800,100);
   }
   else if(doorplace == "4-9-1")
   {
      _root.changecourse("StarIn","4-9",0,0,0,0);
   }
   else if(doorplace == "4-9-2")
   {
      _root.changecourse("StarIn","4-9",-1450,0,-1450,0);
   }
   else if(doorplace == "4-9-3")
   {
      _root.changecourse("StarIn","4-9",0,-1055,0,-1055);
   }
   else if(doorplace == "4-10-1")
   {
      _root.changecourse("StarIn","4-10",-3090,-630,-3090,-630);
   }
   else if(doorplace == "4-11-1")
   {
      _root.changecourse("StarIn","4-11",0,0,0,0,true);
   }
   else if(doorplace == "5-1-1")
   {
      _root.changecourse("StarIn","5-1",620,150,620,150);
   }
   else if(doorplace == "5-1-2")
   {
      _root.changecourse("StarIn","5-1",2980,-50,2980,-50);
   }
   else if(doorplace == "5-5")
   {
      _root.changecourse("StarIn","5-5",0,0,0,0);
   }
   else if(doorplace == "5-7-1")
   {
      _root.changecourse("StarIn","5-7",0,0,0,0);
   }
   else if(doorplace == "5-8-1")
   {
      _root.changecourse("StarIn","5-8",0,0,0,0);
   }
   else if(doorplace == "6-5")
   {
      _root.changecourse("StarIn","6-5",500,500,-600,666,true);
   }
   else if(doorplace == "7-6")
   {
      _root.changecourse("StarIn","7-6",0,0,0,0,true);
   }
   else if(doorplace == "8-1-2")
   {
      _root.changecourse("StarIn","8-1",4128,-10,4128,-10);
   }
   else if(doorplace == "8-2-1")
   {
      _root.changecourse("StarIn","8-2",0,0,0,0);
   }
   else if(doorplace == "8-2-bleft")
   {
      _root.changecourse("StarIn","8-2",-812,-114,-812,-114);
   }
   else if(doorplace == "8-2-bright")
   {
      _root.changecourse("StarIn","8-2",760,-114,760,-114);
   }
   else if(doorplace == "8-2-uleft")
   {
      _root.changecourse("StarIn","8-2",-1350,-420,-1350,-420,true);
   }
   else if(doorplace == "8-2-uright")
   {
      _root.changecourse("StarIn","8-2",830,-420,830,-420);
   }
   else if(doorplace == "8-2-top")
   {
      _root.changecourse("StarIn","8-2",0,-1090,0,-1090);
   }
   else if(doorplace == "8-3")
   {
      _root.changecourse("StarIn","8-3",0,95,0,95);
   }
   else if(doorplace == "8-4")
   {
      _root.changecourse("StarIn","8-4",0,95,0,95);
   }
   else if(doorplace == "8-5")
   {
      _root.changecourse("StarIn","8-5",0,0,0,0,true);
   }
   else if(doorplace == "8-6")
   {
      _root.changecourse("StarIn","8-6",0,0,0,0);
   }
   else if(doorplace == "8-7")
   {
      _root.changecourse("StarIn","8-7",0,0,0,0);
   }
   else if(doorplace == "8-7bleft")
   {
      _root.changecourse("StarIn","8-7",-468,20,-468,20);
   }
   else if(doorplace == "8-7bright")
   {
      _root.changecourse("StarIn","8-7",468,20,468,20);
   }
   else if(doorplace == "8-7uleft")
   {
      _root.changecourse("StarIn","8-7",-556,-577,-556,-577);
   }
   else if(doorplace == "8-7uright")
   {
      _root.changecourse("StarIn","8-7",556,-577,556,-577);
   }
   else if(doorplace == "8-7utop")
   {
      _root.changecourse("StarIn","8-7",0,-582,0,-582);
   }
   else if(doorplace == "8-8")
   {
      _root.changecourse("StarIn","8-8",0,0,0,0);
   }
   else if(doorplace == "8-8u")
   {
      _root.changecourse("StarIn","8-8",-656,-2620,-656,-2620);
   }
   else if(doorplace == "8-9")
   {
      _root.changecourse("StarIn","8-9",0,0,0,0);
   }
   else if(doorplace == "8-9u")
   {
      _root.changecourse("StarIn","8-9",0,0,0,0);
   }
   else if(doorplace == "8-10")
   {
      _root.changecourse("StarIn","8-10",-290,0,-290,0);
   }
   else if(doorplace == "8-10-b")
   {
      _root.changecourse("StarIn","8-10-b",-547,-1470,-547,-1470,true);
   }
   else if(doorplace == "8-10u")
   {
      _root.changecourse("StarIn","8-10-b",-575,-1470,-575,-1470,true);
   }
   else if(doorplace == "8-11")
   {
      _root.changecourse("StarIn","8-11",-170,30,-170,30,true);
   }
   else if(doorplace == "8-11u")
   {
      _root.changecourse("StarIn","8-11",0,-820,0,-820,true);
   }
   else if(doorplace == "8-12")
   {
      _root.changecourse("StarIn","8-12",0,0,0,0);
   }
   else if(doorplace == "8-12-Warp")
   {
      _root.Fluddpow = "";
      _root.StopBGsong();
      _root.lvl8keyA = false;
      _root.lvl8keyB = false;
      _root.lvl8keyC = false;
      _root.lvl8keyD = false;
      _root.lvl8keyE = true;
      _root.Playinglevel = 8;
      _root.SongIntro = "BowserTrapIntro";
      _root.SongRepeat = "BowserTrapRepeat";
      _root.PlayMusicAndIntro();
      _root.changecourse("StarIn","8-12",-192,-52,-192,-52);
   }
   else if(doorplace == "C-13-Warp")
   {
      _root.Fluddpow = "";
      _root.StopBGsong();
      _root.lvl8keyA = false;
      _root.lvl8keyB = false;
      _root.lvl8keyC = false;
      _root.lvl8keyD = false;
      _root.lvl8keyE = true;
      _root.Playinglevel = 0;
      _root.SongIntro = "None";
      _root.SongRepeat = "InsidetheCastleWalls";
      _root.StartNewMusicAndIntroNoVar("BowserPlan-Intro","BowserPlan-Repeat");
      _root.changecourse("StarIn","C-13",1066,-215,1066,-215);
   }
   else if(doorplace == "8-E2-2")
   {
      _root.Fluddpow = "";
      _root.changecourse("StarIn","8-E2-2",0,-200,0,-200,true);
   }
   else if(doorplace == "8-13")
   {
      _root.changecourse("StarIn","8-13",0,0,0,0,true);
   }
   else if(doorplace == "8-E3-1")
   {
      _root.changecourse("StarIn","8-E3-1",0,0,0,0,true);
   }
   else if(doorplace == "8-E5-1")
   {
      _root.Fluddpow = "";
      _root.changecourse("StarIn","8-E5-1",-1693,-60,-1693,-60,true);
   }
   else if(doorplace == "8-E5-1-1")
   {
      _root.Fluddpow = "";
      _root.changecourse("StarIn","8-E5-1",-212,-25,-212,-25,true);
   }
   else if(doorplace == "9-02")
   {
      _root.Restartcoins();
      _root.Fluddpow = "";
      _root.changecourse("StarIn","9-02",0,0,0,0,true);
   }
   else if(doorplace == "9-04")
   {
      _root.Restartcoins();
      _root.Fluddpow = "";
      _root.changecourse("StarIn","9-04",0,0,0,0,true);
   }
   else if(doorplace == "9-06")
   {
      _root.Restartcoins();
      _root.Fluddpow = "";
      _root.changecourse("StarIn","9-06",0,0,0,0,true);
   }
   else if(doorplace == "M1-2")
   {
      _root.changecourse("StarIn","M1-2",-1465,-320,-1465,-320,true);
   }
   else if(doorplace == "M2-1-1")
   {
      _root.changecourse("StarIn","M2-1",795,125,795,125);
   }
   else if(doorplace == "M2-2-1")
   {
      _root.changecourse("StarIn","M2-2",0,0,0,0);
   }
   else if(doorplace == "BC-0")
   {
      _root.gotoAndStop("BowserBattle3");
      _root.RemoveCourse();
   }
   else if(doorplace == "BC-1")
   {
      _root.changecourse("StarIn","BC-1",0,0,0,0);
   }
   else if(doorplace == "C-4-SC1")
   {
      _root.changecourse("StarIn","C-4-SC1",0,0,0,0);
   }
   else if(doorplace == "C-4-SC2")
   {
      _root.changecourse("StarIn","C-4-SC1",0,-260,0,-260);
   }
   else if(doorplace == "C-4-SC1-back")
   {
      _root.changecourse("StarIn","C-4",1164,0,1164,0);
   }
   else if(doorplace == "C-4-SC1-back2")
   {
      _root.changecourse("StarIn","C-4",1036,0,1036,0);
   }
   else if(doorplace == "level1")
   {
      _root.changecourse("StarIn","level1",0,0,0,0);
   }
   else
   {
      _root.changecourse("StarIn","C-1",0,0,0,0);
   }
};

This is taken from a Flash game, where speed and efficiency is fairly important. 1: used in 1 place 2: used in quite a lot of places 3: the door mapping must have changed during development...

By Anonymous, 2018-11-10 09:51:41
if (code === null) {
    return null;
} else {
    return code;
}
By crossthedev, 2018-11-19 15:33:47
#335 SQL +31
		CREATE OR REPLACE FUNCTION melodious.query_flags(user_name varchar(32), chan_name varchar(32), igroup_name varchar(32), iflag_name varchar(32), flagcheck bool)
		RETURNS TABLE (
			group_holders jsonb [],
			flag_id int4,
			flag_name varchar(32),
			flag jsonb
		)
		LANGUAGE plpgsql
		AS $$
		DECLARE
			uid int4 := NULL;
			cid int4 := NULL;
			gid int4 := NULL;
		BEGIN
			IF user_name <> '' THEN
				SELECT id INTO uid FROM melodious.accounts WHERE username=user_name;
				IF uid IS NULL THEN
					RAISE EXCEPTION 'no such user';
				END IF;
			END IF;
			IF chan_name <> '' THEN
				SELECT id INTO cid FROM melodious.channels WHERE name=chan_name;
				IF cid IS NULL THEN
					RAISE EXCEPTION 'no such channel';
				END IF;
			END IF;
			IF igroup_name <> '' THEN
				SELECT id INTO gid FROM melodious.groups WHERE name=igroup_name;
				IF gid IS NULL THEN
					RAISE EXCEPTION 'go such group';
				END IF;
			END IF;

			IF igroup_name = '' THEN
				IF iflag_name = '' THEN
					IF user_name = '' AND chan_name = '' THEN
						RETURN QUERY SELECT
							ARRAY_AGG(JSONB_SET(ROW_TO_JSON(gh)::JSONB, '{group_name}'::TEXT[], TO_JSONB((SELECT name FROM melodious.groups WHERE id=gh.group_id LIMIT 1)))) AS group_holders,
							gf.id flag_id,
							gf.name flag_name,
							gf.flag flag
						FROM melodious.group_holders gh
						INNER JOIN melodious.group_flags gf
						ON gh.group_id = gf.group_id
						WHERE (NOT flagcheck) OR (flagcheck AND gh.user_id IS NULL AND gh.channel_id IS NULL)
						GROUP BY gf.id, gf.name;
					ELSIF user_name <> '' AND chan_name <> '' THEN
						RETURN QUERY SELECT
							ARRAY_AGG(JSONB_SET(ROW_TO_JSON(gh)::JSONB, '{group_name}'::TEXT[], TO_JSONB((SELECT name FROM melodious.groups WHERE id=gh.group_id LIMIT 1)))) AS group_holders,
							gf.id flag_id,
							gf.name flag_name,
							gf.flag flag
						FROM melodious.group_holders gh
						INNER JOIN melodious.group_flags gf
						ON gh.group_id = gf.group_id
						WHERE (gh.user_id = uid AND gh.channel_id = cid)
							 OR (flagcheck AND gh.user_id = uid AND gh.channel_id IS NULL)
							 OR (flagcheck AND gh.user_id IS NULL AND gh.channel_id = cid)
							 OR (flagcheck AND gh.user_id IS NULL AND gh.channel_id IS NULL)
						GROUP BY gf.id, gf.name;
					ELSIF user_name <> '' AND chan_name = '' THEN
						RETURN QUERY SELECT
							ARRAY_AGG(JSONB_SET(ROW_TO_JSON(gh)::JSONB, '{group_name}'::TEXT[], TO_JSONB((SELECT name FROM melodious.groups WHERE id=gh.group_id LIMIT 1)))) AS group_holders,
							gf.id flag_id,
							gf.name flag_name,
							gf.flag flag
						FROM melodious.group_holders gh
						INNER JOIN melodious.group_flags gf
						ON gh.group_id = gf.group_id
						WHERE (NOT flagcheck AND gh.user_id = uid)
							 OR (flagcheck AND gh.user_id = uid AND gh.channel_id IS NULL)
							 OR (flagcheck AND gh.user_id IS NULL AND gh.channel_id IS NULL)
						GROUP BY gf.id, gf.name;
					ELSIF user_name = '' AND chan_name <> '' THEN
						RETURN QUERY SELECT
							ARRAY_AGG(JSONB_SET(ROW_TO_JSON(gh)::JSONB, '{group_name}'::TEXT[], TO_JSONB((SELECT name FROM melodious.groups WHERE id=gh.group_id LIMIT 1)))) AS group_holders,
							gf.id flag_id,
							gf.name flag_name,
							gf.flag flag
						FROM melodious.group_holders gh
						INNER JOIN melodious.group_flags gf
						ON gh.group_id = gf.group_id
						WHERE (NOT flagcheck AND gh.channel_id = cid)
							 OR (flagcheck AND gh.user_id IS NULL AND gh.channel_id = cid)
							 OR (flagcheck AND gh.user_id IS NULL AND gh.channel_id IS NULL)
						GROUP BY gf.id, gf.name;
					END IF;
				ELSE
					IF user_name = '' AND chan_name = '' THEN
						RETURN QUERY SELECT
							ARRAY_AGG(JSONB_SET(ROW_TO_JSON(gh)::JSONB, '{group_name}'::TEXT[], TO_JSONB((SELECT name FROM melodious.groups WHERE id=gh.group_id LIMIT 1)))) AS group_holders,
							gf.id flag_id,
							gf.name flag_name,
							gf.flag flag
						FROM melodious.group_holders gh
						INNER JOIN melodious.group_flags gf
						ON gh.group_id = gf.group_id
						WHERE (gf.name = iflag_name)
							AND (
								(NOT flagcheck)
								OR (flagcheck AND gh.user_id IS NULL AND gh.channel_id IS NULL)
							)
						GROUP BY gf.id, gf.name;
					ELSIF user_name <> '' AND chan_name <> '' THEN
						RETURN QUERY SELECT
							ARRAY_AGG(JSONB_SET(ROW_TO_JSON(gh)::JSONB, '{group_name}'::TEXT[], TO_JSONB((SELECT name FROM melodious.groups WHERE id=gh.group_id LIMIT 1)))) AS group_holders,
							gf.id flag_id,
							gf.name flag_name,
							gf.flag flag
						FROM melodious.group_holders gh
						INNER JOIN melodious.group_flags gf
						ON gh.group_id = gf.group_id
						WHERE gf.name = iflag_name
						  AND (
								(gh.user_id = uid AND gh.channel_id = cid)
							 	OR (flagcheck AND gh.user_id = uid AND gh.channel_id IS NULL)
								OR (flagcheck AND gh.user_id IS NULL AND gh.channel_id = cid)
								OR (flagcheck AND gh.user_id IS NULL AND gh.channel_id IS NULL)
							)
						GROUP BY gf.id, gf.name;
					ELSIF user_name <> '' AND chan_name = '' THEN
						RETURN QUERY SELECT
							ARRAY_AGG(JSONB_SET(ROW_TO_JSON(gh)::JSONB, '{group_name}'::TEXT[], TO_JSONB((SELECT name FROM melodious.groups WHERE id=gh.group_id LIMIT 1)))) AS group_holders,
							gf.id flag_id,
							gf.name flag_name,
							gf.flag flag
						FROM melodious.group_holders gh
						INNER JOIN melodious.group_flags gf
						ON gh.group_id = gf.group_id
						WHERE gf.name = iflag_name
							AND (
								(NOT flagcheck AND gh.user_id = uid)
								OR (flagcheck AND gh.user_id = uid AND gh.channel_id IS NULL)
								OR (flagcheck AND gh.user_id IS NULL AND gh.channel_id IS NULL)
							)
						GROUP BY gf.id, gf.name;
					ELSIF user_name = '' AND chan_name <> '' THEN
						RETURN QUERY SELECT
							ARRAY_AGG(JSONB_SET(ROW_TO_JSON(gh)::JSONB, '{group_name}'::TEXT[], TO_JSONB((SELECT name FROM melodious.groups WHERE id=gh.group_id LIMIT 1)))) AS group_holders,
							gf.id flag_id,
							gf.name flag_name,
							gf.flag flag
						FROM melodious.group_holders gh
						INNER JOIN melodious.group_flags gf
						ON gh.group_id = gf.group_id
						WHERE gf.name = iflag_name
							AND (
								(NOT flagcheck AND gh.channel_id = cid)
								OR (flagcheck AND gh.channel_id = cid AND gh.user_id IS NULL)
								OR (flagcheck AND gh.channel_id IS NULL AND gh.user_id IS NULL)
							)
						GROUP BY gf.id, gf.name;
					END IF;
				END IF;
			ELSE
				IF iflag_name = '' THEN
					IF user_name = '' AND chan_name = '' THEN
						RETURN QUERY SELECT
							ARRAY_AGG(JSONB_SET(ROW_TO_JSON(gh)::JSONB, '{group_name}'::TEXT[], TO_JSONB(igroup_name))) AS group_holders,
							gf.id flag_id,
							gf.name flag_name,
							gf.flag flag
						FROM melodious.group_holders gh
						INNER JOIN melodious.group_flags gf
						ON gh.group_id = gf.group_id
						WHERE gh.group_id = gid
							AND (
								(NOT flagcheck)
								OR (flagcheck AND gh.user_id IS NULL AND gh.channel_id IS NULL)
							)
						GROUP BY gf.id, gf.name;
					ELSIF user_name <> '' AND chan_name <> '' THEN
						RETURN QUERY SELECT
							ARRAY_AGG(JSONB_SET(ROW_TO_JSON(gh)::JSONB, '{group_name}'::TEXT[], TO_JSONB(igroup_name))) AS group_holders,
							gf.id flag_id,
							gf.name flag_name,
							gf.flag flag
						FROM melodious.group_holders gh
						INNER JOIN melodious.group_flags gf
						ON gh.group_id = gf.group_id
						WHERE gh.group_id = gid
							AND (
								(gh.channel_id = cid AND gh.user_id = uid)
								OR (flagcheck AND gh.channel_id = cid AND gh.user_id IS NULL)
								OR (flagcheck AND gh.channel_id IS NULL AND gh.user_id = uid)
								OR (flagcheck AND gh.channel_id IS NULL AND gh.user_id IS NULL)
							)
						GROUP BY gf.id, gf.name;
					ELSIF user_name <> '' AND chan_name = '' THEN
						RETURN QUERY SELECT
							ARRAY_AGG(JSONB_SET(ROW_TO_JSON(gh)::JSONB, '{group_name}'::TEXT[], TO_JSONB(igroup_name))) AS group_holders,
							gf.id flag_id,
							gf.name flag_name,
							gf.flag flag
						FROM melodious.group_holders gh
						INNER JOIN melodious.group_flags gf
						ON gh.group_id = gf.group_id
						WHERE gh.group_id = gid
							AND (
								(NOT flagcheck AND gh.user_id = uid)
								OR (flagcheck AND gh.user_id = uid AND gh.channel_id IS NULL)
								OR (flagcheck AND gh.user_id IS NULL AND gh.channel_id IS NULL)
							)
						GROUP BY gf.id, gf.name;
					ELSIF user_name = '' AND chan_name <> '' THEN
						RETURN QUERY SELECT
							ARRAY_AGG(JSONB_SET(ROW_TO_JSON(gh)::JSONB, '{group_name}'::TEXT[], TO_JSONB(igroup_name))) AS group_holders,
							gf.id flag_id,
							gf.name flag_name,
							gf.flag flag
						FROM melodious.group_holders gh
						INNER JOIN melodious.group_flags gf
						ON gh.group_id = gf.group_id
						WHERE gh.group_id = gid
							AND (
								(NOT flagcheck AND gh.channel_id = cid)
								OR (flagcheck AND gh.channel_id = cid AND gh.user_id IS NULL)
								OR (flagcheck AND gh.channel_id IS NULL AND gh.user_id IS NULL) 
							)
						GROUP BY gf.id, gf.name;
					END IF;
				ELSE
					IF user_name = '' AND chan_name = '' THEN
						RETURN QUERY SELECT
							ARRAY_AGG(JSONB_SET(ROW_TO_JSON(gh)::JSONB, '{group_name}'::TEXT[], TO_JSONB(igroup_name))) AS group_holders,
							gf.id flag_id,
							gf.name flag_name,
							gf.flag flag
						FROM melodious.group_holders gh
						INNER JOIN melodious.group_flags gf
						ON gh.group_id = gf.group_id
						INNER JOIN melodious.groups g
						ON g.id = gh.group_id
						WHERE (gf.name = iflag_name AND gh.group_id = gid)
							AND (
								(NOT flagcheck)
								OR (flagcheck AND gh.channel_id IS NULL AND gh.user_id IS NULL)
							)
						GROUP BY gf.id, gf.name;
					ELSIF user_name <> '' AND chan_name <> '' THEN
						RETURN QUERY SELECT
							ARRAY_AGG(JSONB_SET(ROW_TO_JSON(gh)::JSONB, '{group_name}'::TEXT[], TO_JSONB(igroup_name))) AS group_holders,
							gf.id flag_id,
							gf.name flag_name,
							gf.flag flag
						FROM melodious.group_holders gh
						INNER JOIN melodious.group_flags gf
						ON gh.group_id = gf.group_id
						WHERE (gf.name = iflag_name AND gh.group_id = gid)
							AND (
								(gh.user_id = uid AND gh.channel_id = cid)
								OR (flagcheck AND gh.user_id = uid AND gh.channel_id IS NULL)
								OR (flagcheck AND gh.user_id IS NULL AND gh.channel_id = cid)
								OR (flagcheck AND gh.user_id IS NULL AND gh.channel_id IS NULL)
							)
						GROUP BY gf.id, gf.name;
					ELSIF user_name <> '' AND chan_name = '' THEN
						RETURN QUERY SELECT
							ARRAY_AGG(JSONB_SET(ROW_TO_JSON(gh)::JSONB, '{group_name}'::TEXT[], TO_JSONB(igroup_name))) AS group_holders,
							gf.id flag_id,
							gf.name flag_name,
							gf.flag flag
						FROM melodious.group_holders gh
						INNER JOIN melodious.group_flags gf
						ON gh.group_id = gf.group_id
						WHERE (gh.group_id = gid AND gf.name = iflag_name)
							AND (
								(NOT flagcheck AND gh.user_id = uid)
								OR (flagcheck AND gh.user_id = uid AND gh.channel_id IS NULL)
								OR (flagcheck AND gh.user_id IS NULL AND gh.channel_id IS NULL)
							)
						GROUP BY gf.id, gf.name;
					ELSIF user_name = '' AND chan_name <> '' THEN
						RETURN QUERY SELECT
							ARRAY_AGG(JSONB_SET(ROW_TO_JSON(gh)::JSONB, '{group_name}'::TEXT[], TO_JSONB(igroup_name))) AS group_holders,
							gf.id flag_id,
							gf.name flag_name,
							gf.flag flag
						FROM melodious.group_holders gh
						INNER JOIN melodious.group_flags gf
						ON gh.group_id = gf.group_id
						WHERE (gf.name = iflag_name AND gh.group_id = gid)
							AND (
								(NOT flagcheck AND gh.channel_id = cid)
								OR (flagcheck AND gh.channel_id = cid AND gh.user_id IS NULL)
								OR (flagcheck AND gh.channel_id IS NULL AND gh.user_id IS NULL)
							)
						GROUP BY gf.id, gf.name;
					END IF;
				END IF;
			END IF;
		END;
		$$;
By Anonymous, 2019-02-05 15:36:52
if ( variable )
{
    
}
else
{
    Console.WriteLine("Wrong")
}

He doesn't know what "Not" is it :|

By Manoochehr Mojgani, 2017-12-13 17:05:36
public boolean logout(String token)
{
    LogedUser user = logedUsers.remove(token);
    return (user != null) ? true : false;
}
By Slacki, 2015-11-17 17:58:53
boolean darkModeSelected = (!darkModeSelected ? true : false);
By Anonymous, 2017-12-13 09:40:59
var doc = (Parent as Doc);
doc.Name = (doc != null) ? "" : doc.Name
By MSx, 2020-01-16 12:39:39

string date = user.RegistrationDate.ToShortDateString().ToString();
By Anonymous, 2019-02-13 14:51:41
Double value = item.getPrice() * loyaltyPointMultiplier;
String[] s = String.split(value.toString(), "\\.");
points = Integer.parseInt(s[0]);
if(Integer.parseInt(s[1]) > 0) {
    points++;
}
    
return points;

Want to round up? Math.ceil() uses too little memory! Use this instead!

By phytyca, 2017-12-12 05:02:48
//Говорящие названия - такие говорящие!
    function asdfasdf (WebAPI_Entity $screenshot_dictionary)
    {
        $result = array();
        foreach ($screenshot_dictionary->getEntities () as $scr)
        {
            $result [] = $scr->toObject ();
        }
        usort($result, array ($this, 'sortScreenshots'));
        return $this->prepare_screenshots ($result);
    }
    
// вставляем остальные скриншоты
$elements = $this->asdfasdf ($screenshot_dictionary);
By C.H., 2019-10-07 16:47:29
if (i === 1 || i === 2 || i === 3 || i === 4 || i === 5 || i === 6 || i === 7 || i === 8 || i === 9 || i === 10){
 return true;
}
By foxy, 2017-12-13 23:25:17
http://localhost:52108/Trade/Details/1953452?class=pull-left
By Anonymous, 2018-01-05 10:23:21
#265 PHP +28
if((strtotime(date("Y-m-d"))-strtotime(date("Y-m-d", filemtime($filename))))/(3600)<=$config->hourDiff) return true; else return false;

please notice the brackets around 3600

By Anonymous, 2018-03-13 21:56:00
    UIButton * btn = [UIButton new];
    [btn addTarget:target action:action forControlEvents:UIControlEventTouchUpInside];
    
    //May god have mercy of me
    [[btn titleLabel] setFont:[UIFont systemFontOfSize:14 weight:UIFontWeightMedium]];
    [btn setTitle:[NSString stringWithFormat:@"  %@  ", btnTxt] forState:UIControlStateNormal];
    [btn sizeToFit];
    [btn setTitle:btnTxt forState:UIControlStateNormal];

Why keep playing with label padding or insets when you can add spaces?

By Shy developer, 2017-12-12 14:32:37