TELBOXES=test;
require("icon/superedit-inventory.frm");
$zapSQL="select T_TELBOX_NAME from TELBOXES where T_TELBOX_BUILDING_IN='".$_SESSION[BUILDINGS_COLUMN][EDITRECORD][S_ADDRESS_STREET]."' and A_ADM_COMPANY like '".$_SESSION[ADM_COMPANY]."%';" ;
$conn=mysql_pconnect($INTERFACE_ADDR,$SQL_USER,$SQL_USER_PASS);
mysql_select_db($SQL_DATABASE) or die("ERROR podczas wyboru bazy R50!");
$result = mysql_query($zapSQL,$conn) or die("Blad zapytania2!\n$zapSQL");
$num_rows = mysql_num_rows($result);
if($num_rows > 0 ) {
echo "
";
while ($h=mysql_fetch_row($result)) {
BUILDING_SHOW_INVENTORY(T_TELBOX_NAME,$h[0]);
if(!$TEMP_B_INVENTORY_DATE) { $TEMP_B_INVENTORY_DATE="and ( T_TELBOX_ADDRESS not like '$h[0]' ";
} else { $TEMP_B_INVENTORY_DATE=$TEMP_B_INVENTORY_DATE . " or T_TELBOX_ADDRESS not like '$h[0]'";
}
}
echo "
";
$TEMP_B_INVENTORY_DATE=$TEMP_B_INVENTORY_DATE . " )";
}
$zapSQL="select S_ADDRESS_STREET, A_STATUS from USERS2 where A_ADM_COMPANY like '".$_SESSION[ADM_COMPANY]."' $TEMP_B_INVENTORY_DATE and S_ADDRESS_STREET like '".$_SESSION[BUILDINGS_COLUMN][EDITRECORD][S_ADDRESS_STREET]."%' and T_NETWORK_SERVER='".$_SESSION[BUILDINGS_COLUMN][EDITRECORD][T_NETWORK_SERVER]."'";
$result = mysql_query($zapSQL,$conn) or die("Blad zapytania2!\n$zapSQL");
$num_rows = mysql_num_rows($result);
if($num_rows > 0) { echo "UWAGA! Podejrzani, nie przyporzadkowani do szafek abonenci:($num_rows): ";
while ($h=mysql_fetch_row($result)) {
echo "($h[0] $h[1] [............] ) ";
}
}
echo "
