"; $result=$CONNREMOTE->query($sql) or DEBUG_S(-3,'Problem ze sql ',$sql,__FILE__, __FUNCTION__, __LINE__) or die1(''); while($h=mysql_fetch_object($result)) { print_r($h); if(strstr($h->DESC, '&ZASOB_ID=')) { echo "
debug38!
\n"; $zas_id_param_out_repl=explode('&ZASOB_ID=', $h->DESC); $zas_id_param_out_repl=explode('#', $zas_id_param_out_repl[1]); $id_zas_oryg_h_DESC=$h->DESC; //oryginalna wartosc opisu $zas_id_param_out_repl_2=explode('&ZASOB_ID=', $h->DESC); $zas_id_param_out_repl_2=explode('&', $zas_id_param_out_repl_2[1]); echo "
debug48! zas_id_param_out_repl
\n"; print_r($zas_id_param_out_repl); echo "
debug50! zas_id_param_out_repl_2
\n"; print_r($zas_id_param_out_repl_2); $sql_to_find_parent="select DST_TABLE_ID from CRM_IMPORT_TRANSLATE where REM_TABLE='CRM_LISTA_ZASOBOW' and SRC_TABLE_ID='".$zas_id_param_out_repl[0]."' ;" ; $res_to_find_parent_param=$CONNREMOTE->query($sql_to_find_parent) or DEBUG_S(-3,'Problem ze sql ',$sql_to_find_parent,__FILE__, __FUNCTION__, __LINE__) or die1(''); //proba 1 dla warunku ID_ZASOB=xxx# while($h_res_to_find_TS=mysql_fetch_object($res_to_find_parent_param)) { $h->DESC=preg_replace('/&ZASOB_ID='.$zas_id_param_out_repl[0].'#/', '&ZASOB_ID='.$h_res_to_find_TS->DST_TABLE_ID.'#', $id_zas_oryg_h_DESC); if(strlen($h->DESC)>0) { $sql_upd="update CRM_LISTA_ZASOBOW set `DESC`='".$CONNREMOTE->_($h->DESC)."' where ID=".$h->ID." ; "; // $CONNREMOTE->query($sql_upd) or die('Error with upd TYPESPECIAL PARAM_OUT line: 709 '); DEBUG_S(-3,'Nadpisuje TYPESPECIAL PARAM_OUT, ktory ma uzyty URL z ID_ZASOB',$sql_upd,__FILE__,__FUNCTION__,__LINE__); } } //proba 2 dla warunku ID_ZASOB=xxx& $res_to_find_parent_param=$CONNREMOTE->query($sql_to_find_parent) or DEBUG_S(-3,'Problem ze sql ',$sql_to_find_parent,__FILE__, __FUNCTION__, __LINE__) or die1(''); //proba 1 dla warunku ID_ZASOB=xxx# while($h_res_to_find_TS=mysql_fetch_object($res_to_find_parent_param)) { $h->DESC=preg_replace('/&ZASOB_ID='.$zas_id_param_out_repl_2[0].'&/', '&ZASOB_ID='.$h_res_to_find_TS->DST_TABLE_ID.'&', $id_zas_oryg_h_DESC); if(strlen($h->DESC)>0) { $sql_upd="update CRM_LISTA_ZASOBOW set `DESC`='".$CONNREMOTE->_($h->DESC)."' where ID=".$h->ID." ; "; // $CONNREMOTE->query($sql_upd) or die('Error with upd TYPESPECIAL PARAM_OUT line: 709 '); DEBUG_S(-3,'Nadpisuje TYPESPECIAL PARAM_OUT, ktory ma uzyty URL z ID_ZASOB',$sql_upd,__FILE__,__FUNCTION__,__LINE__); } } } } echo ""; ?>