# HG changeset patch # User Matti Hamalainen # Date 1386141093 -7200 # Node ID 0ae6d3fb568868b0fe7a6a0bd23e4765b77f92cc # Parent 0c7b301742bd2ab0f36e4346809b73a52d09fdfd Interface improvements. diff -r 0c7b301742bd -r 0ae6d3fb5688 admajax.php --- a/admajax.php Tue Dec 03 21:09:48 2013 +0200 +++ b/admajax.php Wed Dec 04 09:11:33 2013 +0200 @@ -360,6 +360,10 @@ $nenabled = stFetchSQLColumn("SELECT COUNT(*) FROM compos WHERE visible=0 AND voting<>0"); if ($nenabled > 0) echo "
  • ".$nenabled." competitions that are NOT visible, but are enabled for voting?
  • \n"; + + $entries = stFetchSQL("SELECT COUNT(*) AS nentries, COUNT(DISTINCT compo_id) AS ncompos FROM entries"); + if ($entries !== FALSE) + echo "
  • ".$entries["nentries"]." compo entries in system in ".$entries["ncompos"]." compos.
  • \n"; if ($errors == 0) echo "
  • No errors/warnings detected.
  • \n"; @@ -649,8 +653,11 @@ $id = intval(stGetRequestItem("id", 0)); if (($compo = stFetchSQL("SELECT * FROM compos WHERE id=".$id)) !== false) { + $nentries = stFetchSQLColumn("SELECT COUNT(*) FROM entries WHERE compo_id=".$id); + $prefix = "ne"; echo - "

    #".$id." - ".chentities($compo["name"])."

    \n". + "

    #".$id." - ".chentities($compo["name"]). + " (".$nentries." entries)

    \n". "
    \n". " \n". " \n". @@ -660,7 +667,17 @@ " \n". " \n". " \n". - " \n"; + " \n". + " \n". + " \n". + " \n". + " \n". + " \n". +// " \n". + " \n". + " \n". + " \n". + " \n"; foreach (stExecSQL("SELECT * FROM entries WHERE compo_id=".$id) as $entry) { @@ -670,17 +687,7 @@ " \n"; } - $prefix = "ne"; echo - " \n". - " \n". - " \n". - " \n". - " \n". -// " \n". - " \n". - " \n". - " \n". "
    FilenameInfoActions
    ".stGetFormTextInput(20, SET_LEN_ENTRY_NAME, "name", $id, $prefix, "")."".stGetFormTextInput(15, SET_LEN_ENTRY_AUTHOR, "author", $id, $prefix, "")."".stGetFormTextInput(20, SET_LEN_ENTRY_FILENAME, "filename", $id, $prefix, "")."".stGetFormTextInput(20, SET_LEN_ENTRY_INFO, "info", $id, $prefix, "")."".stGetFormTextArea(2, 30, "info", $id, $prefix, "")."".stGetFormButtonInput("add", $id, $prefix, "Add new", "addEntry(".$id.")")."

    ".stGetFormTextInput(20, SET_LEN_ENTRY_NAME, "name", $id, $prefix, "")."".stGetFormTextInput(15, SET_LEN_ENTRY_AUTHOR, "author", $id, $prefix, "")."".stGetFormTextInput(20, SET_LEN_ENTRY_FILENAME, "filename", $id, $prefix, "")."".stGetFormTextInput(20, SET_LEN_ENTRY_INFO, "info", $id, $prefix, "")."".stGetFormTextArea(2, 30, "info", $id, $prefix, "")."".stGetFormButtonInput("add", $id, $prefix, "Add new", "addEntry(".$id.")")."
    \n". "
    \n"; }