Nie mogę sobie poradzić z jednym skryptem, który pobiera rekordy z bazy danych w liczbie dwóch.
$Get = mysql_query("SELECT s.name as SIP_CALLING, c.client as CLIENT, c.max_channel AS MAX_CHANNEL_CLIENT, c.max_channel_drop as MAX_CHANNEL_CLIENT_DROP, c.operator AS ROUTING, o.name as CARRIER , o.max_channel as MAX_CHANNEL, ca.active as ACTIVE_CHANNEL, cac.active AS REALTIME_CALL_CLIENT, o.number_valid as NUMBER_VALUE, nc.clip as CALLERID, dnc.default_number as DEFAULT_CALLERID_CARRIER_FOR_CLIENT, rc.priorytet from sipusers s LEFT JOIN clients c ON s.id_client = c.id_sip LEFT JOIN route_clients rc ON c.operator = rc.dialplan_name LEFT JOIN operators o ON o.id = rc.id_operators LEFT JOIN channel_active ca ON rc.id_operators = ca.id_operator LEFT JOIN channel_active_client cac ON cac.id_client = s.id_client LEFT JOIN numbers_clients nc ON nc.id_client = s.id_client LEFT JOIN default_number_clients dnc ON dnc.id_operators = o.id where s.name = 'RCC1001' order by rc.priorytet"); { mysql_query("UPDATE channel_active_client SET active = (active+1) where id_client = ".$put->ID_CLIENT); $LICZNIK = $put->REALTIME_CALL_CLIENT +1; if($LICZNIK > $put->MAX_CHANNEL_CLIENT_DROP) { echo("KLIENT $put->CLIENT PRZEKROZYŁ KRYTYCZNIE DOSTĘPNA ILOŚC SZCZELIN ($put->REALTIME_CALL_CLIENT) "); } elseif($LICZNIK > $put->MAX_CHANNEL_CLIENT) { } if($Put->CALLERID != $CALLERIDNAME) { } if($put->ACTIVE_CHANNEL > $put->MAX_CHANNEL) { if($STATUS == 'CANCELED') { } } else { if($STATUS == 'CANCEL') { } } }
Odpowiedź z SQL:
SIP_CALLING CLIENT MAX_CHANNEL_CLIENT MAX_CHANNEL_CLIENT_DROP ROUTING CARRIER MAX_CHANNEL ACTIVE_CHANNEL REALTIME_CALL_CLIENT NUMBER_VALUE CALLERID DEFAULT_CALLERID_CARRIER_FOR_CLIENT priorytet Rosnąco 1 RCC1001 tell 10 20 Premium Lovo 300 10 10 no 911111 947215555 1 1 RCC1001 tell 10 20 Premium Netia 10 0 10 yes 9111111 947211111 2
Efekt chcę uzyskać taki, że :
Pierw skrypt wykonuje się według priorytety 1
sprawda wszystkie warunki gdy jest status CANCELED to powinien wykonać priorytet drugi to samo zachowanie gdy status będzie miał CANCEL
Próbowałem to na wiele razy zrobić, ale być może nie umiem po prostu i ktoś może mi pomóc ?