update_cuts.inc.php

六和投注系统

<?php


function update_sup( $super_agent, $cut_plate, $sign, $cut_num, $unit_limit, $pour_limit )
{
    global $conn;
    $sqlup = mysql_query( "select * from all_agent where super_agent='{$super_agent}'", $conn );
    while ( $rsa = mysql_fetch_array( $sqlup ) )
    {
        $agent = $rsa['user_account'];
        $sqlh = mysql_query( "select * from  agent_cut  where cut_plate='{$cut_plate}' and sign='{$sign}' and user_account='{$agent}'", $conn );
        if ( $cut_num < mysql_result( $sqlh, 0, "cut_num" ) )
        {
            mysql_query( "update agent_cut set cut_num='{$cut_num}' where cut_plate='{$cut_plate}' and sign='{$sign}' and user_account='{$agent}'", $conn );
        }
        if ( trim( $unit_limit ) < trim( mysql_result( $sqlh, 0, "unit_limit" ) ) )
        {
            mysql_query( "update agent_cut set unit_limit='{$unit_limit}' where cut_plate='{$cut_plate}' and sign='{$sign}' and user_account='{$agent}'", $conn );
        }
        if ( trim( $pour_limit ) < trim( mysql_result( $sqlh, 0, "pour_limit" ) ) )
        {
            mysql_query( "update agent_cut set pour_limit='{$pour_limit}' where cut_plate='{$cut_plate}' and sign='{$sign}' and user_account='{$agent}'", $conn );
        }
    }
    $sqlups = mysql_query( "select * from  agent where super_agent='{$super_agent}'", $conn );
    while ( $rsa = mysql_fetch_array( $sqlups ) )
    {
        $agent = $rsa['user_account'];
        $sqlhs = mysql_query( "select * from  agent_cut  where cut_plate='{$cut_plate}' and sign='{$sign}' and user_account='{$agent}'", $conn );
        if ( trim( $cut_num ) < trim( mysql_result( $sqlhs, 0, "cut_num" ) ) )
        {
            mysql_query( "update agent_cut set cut_num='{$cut_num}' where cut_plate='{$cut_plate}' and sign='{$sign}' and user_account='{$agent}'", $conn );
        }
        if ( trim( $unit_limit ) < trim( mysql_result( $sqlhs, 0, "unit_limit" ) ) )
        {
            mysql_query( "update agent_cut set unit_limit='{$unit_limit}' where cut_plate='{$cut_plate}' and sign='{$sign}' and user_account='{$agent}'", $conn );
        }
        if ( trim( $pour_limit ) < trim( mysql_result( $sqlhs, 0, "pour_limit" ) ) )
        {
            mysql_query( "update agent_cut set pour_limit='{$pour_limit}' where cut_plate='{$cut_plate}' and sign='{$sign}' and user_account='{$agent}'", $conn );
        }
    }
    $sqlf = mysql_query( "select * from  member where super_agent='{$super_agent}' and user_plate='{$cut_plate}'", $conn );
    while ( $rsa = mysql_fetch_array( $sqlf ) )
    {
        $member = $rsa['user_account'];
        $sqlu = mysql_query( "select * from  member_cut  where sign='{$sign}' and user_account='{$member}'", $conn );
        if ( trim( $cut_num ) < trim( mysql_result( $sqlu, 0, "cut_num" ) ) )
        {
            mysql_query( "update member_cut set cut_num='{$cut_num}' where  sign='{$sign}' and user_account='{$member}'", $conn );
        }
        if ( trim( $unit_limit ) < trim( mysql_result( $sqlu, 0, "unit_limit" ) ) )
        {
            mysql_query( "update member_cut set unit_limit='{$unit_limit}' where  sign='{$sign}' and user_account='{$member}'", $conn );
        }
        if ( trim( $pour_limit ) < trim( mysql_result( $sqlu, 0, "pour_limit" ) ) )
        {
            mysql_query( "update member_cut set pour_limit='{$pour_limit}' where  sign='{$sign}' and user_account='{$member}'", $conn );
        }
    }
}

function update_all( $all_agent, $cut_plate, $sign, $cut_num, $unit_limit, $pour_limit )
{
    global $conn;
    $sqlup = mysql_query( "select * from  agent where all_agent='{$all_agent}'", $conn );
    while ( $rsa = mysql_fetch_array( $sqlup ) )
    {
        $agent = $rsa['user_account'];
        $sqltt = mysql_query( "select * from  agent_cut  where cut_plate='{$cut_plate}' and sign='{$sign}' and user_account='{$agent}'", $conn );
        if ( trim( $cut_num ) < trim( mysql_result( $sqltt, 0, "cut_num" ) ) )
        {
            mysql_query( "update agent_cut set cut_num='{$cut_num}' where cut_plate='{$cut_plate}' and sign='{$sign}' and user_account='{$agent}'", $conn );
        }
        if ( trim( $unit_limit ) < trim( mysql_result( $sqltt, 0, "unit_limit" ) ) )
        {
            mysql_query( "update agent_cut set unit_limit='{$unit_limit}' where cut_plate='{$cut_plate}' and sign='{$sign}' and user_account='{$agent}'", $conn );
        }
        if ( trim( $pour_limit ) < trim( mysql_result( $sqltt, 0, "pour_limit" ) ) )
        {
            mysql_query( "update agent_cut set pour_limit='{$pour_limit}' where cut_plate='{$cut_plate}' and sign='{$sign}' and user_account='{$agent}'", $conn );
        }
    }
    $sqlf = mysql_query( "select * from  member where all_agent='{$all_agent}' and user_plate='{$cut_plate}'", $conn );
    while ( $rsa = mysql_fetch_array( $sqlf ) )
    {
        $member = $rsa['user_account'];
        $sqlu = mysql_query( "select * from  member_cut  where sign='{$sign}' and user_account='{$member}'", $conn );
        if ( trim( $cut_num ) < trim( mysql_result( $sqlu, 0, "cut_num" ) ) )
        {
            mysql_query( "update member_cut set cut_num='{$cut_num}' where  sign='{$sign}' and user_account='{$member}'", $conn );
        }
        if ( trim( $unit_limit ) < trim( mysql_result( $sqlu, 0, "unit_limit" ) ) )
        {
            mysql_query( "update member_cut set unit_limit='{$unit_limit}'  where  sign='{$sign}' and user_account='{$member}'", $conn );
        }
        if ( trim( $pour_limit ) < trim( mysql_result( $sqlu, 0, "pour_limit" ) ) )
        {
            mysql_query( "update member_cut set pour_limit='{$pour_limit}'  where  sign='{$sign}' and user_account='{$member}'", $conn );
        }
    }
}

function update_agent( $agent, $cut_plate, $sign, $cut_num, $unit_limit, $pour_limit )
{
    global $conn;
    $sqlf = mysql_query( "select * from  member where agent='{$agent}' and user_plate='{$cut_plate}'", $conn );
    while ( $rsa = mysql_fetch_array( $sqlf ) )
    {
        $member = $rsa['user_account'];
        $sqlus = mysql_query( "select * from  member_cut  where sign='{$sign}' and user_account='{$member}'", $conn );
        if ( trim( $cut_num ) < trim( mysql_result( $sqlus, 0, "cut_num" ) ) )
        {
            mysql_query( "update member_cut set cut_num='{$cut_num}' where  sign='{$sign}' and user_account='{$member}'", $conn );
        }
        if ( trim( $unit_limit ) < trim( mysql_result( $sqlus, 0, "unit_limit" ) ) )
        {
            mysql_query( "update member_cut set unit_limit='{$unit_limit}' where  sign='{$sign}' and user_account='{$member}'", $conn );
        }
        if ( trim( $pour_limit ) < trim( mysql_result( $sqlus, 0, "pour_limit" ) ) )
        {
            mysql_query( "update member_cut set pour_limit='{$pour_limit}' where  sign='{$sign}' and user_account='{$member}'", $conn );
        }
    }
}

function unit_pours( $ausers, $n, $sign, $cut_plate )
{
    global $conn;
    switch ( $n )
    {
    case 1 :
        $sqls = mysql_query( "select * from member where user_account='{$ausers}'", $conn );
        $agent = mysql_result( $sqls, 0, "agent" );
        return unit_pour( $agent, $sign, $cut_plate );
        break;
    case 2 :
        $sqls = mysql_query( "select * from agent where user_account='{$ausers}'", $conn );
        $all_agent = mysql_result( $sqls, 0, "all_agent" );
        return unit_pour( $all_agent, $sign, $cut_plate );
        break;
    case 3 :
        $sqls = mysql_query( "select * from all_agent where user_account='{$ausers}'", $conn );
        $super_agent = mysql_result( $sqls, 0, "super_agent" );
        return unit_pour( $super_agent, $sign, $cut_plate );
        break;
    }
}

function unit_pour( $uagent, $sign, $cut_plate )
{
    global $conn;
    $sql = mysql_query( "select * from agent_cut where cut_plate='{$cut_plate}' and sign='{$sign}' and user_account='{$uagent}'", $conn );
    $unit_limit = mysql_result( $sql, 0, "unit_limit" );
    $pour_limit = mysql_result( $sql, 0, "pour_limit" );
    $cut_unit = mysql_result( $sql, 0, "cut_unit" );
    $ups = $unit_limit.",".$pour_limit.",".$cut_unit;
    return $ups;
}

echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n";
echo "\r\n";
?>