Echo "open data base, and select records/N ";
$ Dmsdbinfo = cmsdbinfoconfig ();
$ Infopro = new cinfoprovider;
$ Infopro-> setadoconnectionptr ($ dmsdbinfo );
//
$ Searchmd5 = "select ";
$ Searchmd5. = "*";
$ Searchmd5. = "from ";
$ Searchmd5. = fun2_post_xml_map_tbl;
$ Searchmd5. = "where ";
$ Searchmd5. = "(";
$ Searchmd5. = fun2_pxm_md5;
$ Searchmd5. = "= '";
$ Searchmd5. = $ MD5;
$ Searchmd5. = "'";
$ Searchmd5. = ")";
$ Searchmd5. = "and ";
$ Searchmd5. = "(";
$ Searchmd5. = fun2_pxm_state;
$ Searchmd5. = "= ";
$ Searchmd5. = fun2_pxm_state_enable_query;
$ Searchmd5. = ")";
If (fun2_err_success! = $ Infopro-> Search ($ searchmd5 ))
{
Echo "DB failed/N ";
$ Strret. = fun2_err_failed;
}
Else
{
If ($ infopro-> movefirst ())
{
$ Record = $ infopro-> getrecordsetptr ();
If (null! = $ Record)
{
Echo $ record. "=> md5-find it/N ";
$ Strret. = 1;
}
Else
{
$ Strret. = fun2_err_param;
}
}
Else
{
$ Strret. = fun2_err_failed;
}
}
// Update records if you have known primary key
$ Sqlcommand = "Update ";
$ Sqlcommand. = fun2_uevt_veh_map_table;
$ Sqlcommand. = "set ";
$ Sqlcommand. = fun2_uev_status;
$ Sqlcommand. = "= '";
$ Sqlcommand. = $ handleres;
$ Sqlcommand. = "'";
$ Sqlcommand. = "where ";
$ Sqlcommand. = fun2_uev_vhc_id;
$ Sqlcommand. = "in (";
Foreach ($ carids as $ carid)
{
$ Sqlcommand. = "'";
$ Sqlcommand. = $ carid;
$ Sqlcommand. = "',";
}
$ Sqlcommand = substr ($ sqlcommand, 0, strlen ($ sqlcommand)-1 );
$ Sqlcommand. = ")";
$ Sqlcommand. = "and ";
$ Sqlcommand. = fun2_uev_evt;
$ Sqlcommand. = "= '";
$ Sqlcommand. = $ eventid;
$ Sqlcommand. = "'";
$ Sqlcommand. = "and ";
$ Sqlcommand. = fun2_uev_status;
$ Sqlcommand. = "= '";
$ Sqlcommand. = fun2_uev_status_acknowledged;
$ Sqlcommand. = "'";
$ Cmsdbinfo = cmsdbinfoconfig ();
$ Db = new cmysqlconnect;
$ Db-> setdbinfo ($ cmsdbinfo );
$ Ret = $ db-> connent ();
If (! $ RET)
{
$ Strret. = fun2_err_failed;
Goto err;
}
$ Result = mysql_query ($ sqlcommand );
If (false = $ result)
{
$ Strret. = fun2_err_failed;
Goto err;
}
Else
{
$ Strret. = fun2_err_success;
}