get_mysql_count() - Code Metrics - BOINC/boinc - Measure and Improve Code Quality continuously with Scrutinizer

get_mysql_count() A
last analyzed 2025-12-01 10:01 UTC

↳ Parent: Project

Complexity

Conditions	1
Paths	1

Size

Total Lines	5
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
eloc	4
nc	1
nop	1
dl	0
loc	5
rs	10
c	0
b	0
f	0

<?php

// This file is part of BOINC.

// http://boinc.berkeley.edu

// Copyright (C) 2008 University of California

//

// BOINC is free software; you can redistribute it and/or modify it

// under the terms of the GNU Lesser General Public License

// as published by the Free Software Foundation,

// either version 3 of the License, or (at your option) any later version.

//

// BOINC is distributed in the hope that it will be useful,

// but WITHOUT ANY WARRANTY; without even the implied warranty of

// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

// See the GNU Lesser General Public License for more details.

//

// You should have received a copy of the GNU Lesser General Public License

// along with BOINC.  If not, see <http://www.gnu.org/licenses/>.

// Show how many unsent results are committed to each HR class

// TODO: convert to use new DB interface

Coding Style Best Practice introduced 2018-10-18 23:16 UTC by

Comments for TODO tasks are often forgotten in the code; it might be better to use a dedicated issue tracker.

// TODO: document in the wiki

Coding Style Best Practice introduced 2018-10-18 23:16 UTC by

Comments for TODO tasks are often forgotten in the code; it might be better to use a dedicated issue tracker.

include_once( "../inc/db.inc" );

include_once( "../inc/util.inc" );

include_once( "../inc/db_ops.inc" );

include_once( "../inc/util_ops.inc" );

include_once( "../inc/prefs.inc" );

$system_string[ 128 ] = "No OS";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[128" but found "[ 128"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "128]" but found "128 ]"

$system_string[ 256 ] = "Linux";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[256" but found "[ 256"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "256]" but found "256 ]"

$system_string[ 384 ] = "Windows";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[384" but found "[ 384"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "384]" but found "384 ]"

$system_string[ 512 ] = "Darwin";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[512" but found "[ 512"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "512]" but found "512 ]"

$system_string[ 640 ] = "FreeBSD";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[640" but found "[ 640"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "640]" but found "640 ]"

$cpu_string[ 0 ]  = "Unspecified";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[0" but found "[ 0"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "0]" but found "0 ]"

$cpu_string[ 1 ]  = "No cpu";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[1" but found "[ 1"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "1]" but found "1 ]"

$cpu_string[ 2 ]  = "Intel";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[2" but found "[ 2"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "2]" but found "2 ]"

$cpu_string[ 3 ]  = "AMD";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[3" but found "[ 3"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "3]" but found "3 ]"

$cpu_string[ 4 ]  = "Macintosh";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[4" but found "[ 4"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "4]" but found "4 ]"

$cpu_string[ 5 ]  = "AMD Athlon";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[5" but found "[ 5"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "5]" but found "5 ]"

$cpu_string[ 6 ]  = "AMD Duron";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[6" but found "[ 6"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "6]" but found "6 ]"

$cpu_string[ 7 ]  = "AMD Sempron";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[7" but found "[ 7"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "7]" but found "7 ]"

$cpu_string[ 8 ]  = "AMD Opteron";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[8" but found "[ 8"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "8]" but found "8 ]"

$cpu_string[ 9 ]  = "AMD Athlon 64";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[9" but found "[ 9"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "9]" but found "9 ]"

$cpu_string[ 10 ] = "AMD Athlon XP";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[10" but found "[ 10"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "10]" but found "10 ]"

$cpu_string[ 11 ] = "Intel Xeon";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[11" but found "[ 11"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "11]" but found "11 ]"

$cpu_string[ 12 ] = "Intel Celeron";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[12" but found "[ 12"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "12]" but found "12 ]"

$cpu_string[ 13 ] = "Intel Pentium";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[13" but found "[ 13"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "13]" but found "13 ]"

$cpu_string[ 14 ] = "Intel Pentium II";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[14" but found "[ 14"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "14]" but found "14 ]"

$cpu_string[ 15 ] = "Intel Pentium III";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[15" but found "[ 15"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "15]" but found "15 ]"

$cpu_string[ 16 ] = "Intel Pentium 4";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[16" but found "[ 16"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "16]" but found "16 ]"

$cpu_string[ 17 ] = "Intel Pentium D";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[17" but found "[ 17"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "17]" but found "17 ]"

$cpu_string[ 18 ] = "Intel Pentium M";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[18" but found "[ 18"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "18]" but found "18 ]"

$cpu_string[ 19 ] = "AMD Athlon MP";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[19" but found "[ 19"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "19]" but found "19 ]"

$cpu_string[ 20 ] = "AMD Turion";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[20" but found "[ 20"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "20]" but found "20 ]"

$cpu_string[ 21 ] = "Intel Core2";

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[21" but found "[ 21"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "21]" but found "21 ]"

$query = "SELECT COUNT(workunit.id) AS count FROM workunit LEFT JOIN result ON workunit.id=result.workunitid WHERE result.server_state=2 AND workunit.hr_class=";

function get_mysql_count($hr_class) {

    $result = _mysql_query("select count(id) as count from workunit where hr_class=" . $hr_class);

    $count = _mysql_fetch_object($result);

    _mysql_free_result($result);

    return $count->count;

function make_reset_url($hr_class) {

    return ("<a href=ops_reset_hrclass.php?hr_class=".$hr_class.">".$hr_class."</a>");

db_init();

$timestr = time_str(time(0));

Unused Code introduced 2018-08-30 19:19 UTC by

The call to time() has too many arguments starting with 0. ( Ignorable by Annotation )

$title = "hr_class summary list at ".$timestr;

admin_page_head($title);

start_table();

table_header(

    "hr_class", "System", "CPU", "# unsent results"

);

$unsentresults = get_mysql_count( 0 );

table_row(

    make_reset_url(0), $system_string[ 128 ], $cpu_string[ 0 ], $unsentresults  );

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[128" but found "[ 128"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "128]" but found "128 ]"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found after square bracket; expected "[0" but found "[ 0"

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before square bracket; expected "0]" but found "0 ]"

for ($system = 2; $system < 6; ++$system ) {

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before closing bracket of FOR loop

    for ($cpu = 1; $cpu < 22; ++$cpu ) {

Coding Style introduced 2018-10-18 23:16 UTC by

Space found before closing bracket of FOR loop

        $hr_class=128*$system+$cpu;

        $unsentresults = get_mysql_count( $hr_class );

        table_row(

            make_reset_url($hr_class),

            $system_string[$system * 128],

            $cpu_string[$cpu],

            $unsentresults

100

);

101

102

103

104

end_table();

105

106

admin_page_tail();

107

108

?>

109

BOINC / boinc

get_mysql_count() A last analyzed 2025-12-01 10:01 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

get_mysql_count() A
last analyzed 2025-12-01 10:01 UTC