Артур Нойманн (Все сообщения пользователя)

$arUsValue = CSaleOrderUserPropsValue::GetList(($b="SORT"), ($o="ASC"), Array("USER_PROPS_ID"=>$arResult["PROFILE_ID"]));
while ($arUsValues = $arUsValue->Fetch())
{
  $AllUsValue .= "<b>".strlen($arUsValues["USER_VALUE_NAME"])."</b>: ".$arUsValues["VALUE"]."<br>";
}

$db_orderprop = CSaleOrderPropsValue::GetList(
            array("SORT" => "ASC"),
            array("ORDER_ID" => $arResult["ORDER_ID"])
        );
      $i = 0;
      while ($arVals = $db_orderprop->Fetch()){
        $customerProps[$i]["NAME"]= $arVals["NAME"];
        $customerProps[$i]["VALUE"]= $arVals["VALUE"];
        $i++;
      }
        // если заказ от физ. лица
        if (intval($arResult["PERSON_TYPE"]) == 1){
           $tel = $customerProps[17]["VALUE"];
           $adress = $customerProps[5]["VALUE"];
           }
        // если заказ от юр. лица
        if (intval($arResult["PERSON_TYPE"]) == 2){
           $tel = $customerProps[11]["VALUE"];
           $adress = $customerProps[8]["VALUE"];
        }

$arOrder = Array("ID" => "DESC", "DATE_CREATE" => "DESC");
$arFilter = Array("POST_ID"=>$arParams["ID"]);

$arSelectedFields = Array("ID", "BLOG_ID", "POST_ID", "PARENT_ID", "AUTHOR_ID", "AUTHOR_NAME", "AUTHOR_EMAIL", "AUTHOR_IP", "AUTHOR_IP1", "TITLE", "POST_TEXT", "DATE_CREATE", "PUBLISH_STATUS");
$dbComment = CBlogComment::GetList($arOrder, $arFilter, false, false, $arSelectedFields);

MySQL Query Error: INSERT INTO b_blog_post(`ENABLE_COMMENTS`, `ENABLE_TRACKBACK`, `CATEGORY_ID`, `PUBLISH_STATUS`, `DATE_PUBLISH`, `DETAIL_TEXT_TYPE`, `DETAIL_TEXT`, `PREVIEW_TEXT_TYPE`, `AUTHOR_ID`, `BLOG_ID`, `TITLE`, DATE_CREATE) VALUES('Y', 'N', NULL , 'P', '2011-01-11 00:00:00', 'text', 'gdfgdfgfdgdfgfdgd fd', 'text', '95', '18', 'Стена vgd43', 11.01.2011)[You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.2011)' at line 1]

DB query error.
Please try later.

function OnAfterUserRegisterHandler(&$arFields)
  {
     global $USER;
     $rsUser = CUser::GetByID(IntVal($GLOBALS["USER"]->GetID()));
   $arUser = $rsUser->Fetch();
   if ($arFields["USER_ID"]>0 && CModule::IncludeModule("blog") && CModule::IncludeModule("socialnetwork"))
   {
            $polya = array(
             "NAME" => 'Блог '.$arFields["LOGIN"],
             "ACTIVE" => "Y",
             "DESCRIPTION" => 'пользователя '.$arFields["LOGIN"],
             "GROUP_ID" => '9',
             "ENABLE_IMG_VERIF" => 'Y',
             "DATE_CREATE" => ConvertTimeStamp(),
             "EMAIL_NOTIFY" => 'N',
             "ENABLE_RSS" => "Y",
             "URL" => "wall-".$arUser["ID"],
           "ACTIVE" => "Y",
           "OWNER_ID" => $arUser["ID"]);

           $newID = CBlog::Add($polya);

          $arBlog = CBlog::GetByOwnerID($arUser["ID"]);
       if ($arBlog["ID"]>0){
       $CATEGORY_ID = CBlogCategory::Add(array("BLOG_ID" => $arBlog["ID"],"NAME" => 'Категория '.$arBlog["ID"]));
           $polya2 = array(
             "TITLE" => 'Стена '.$arFields["LOGIN"],
               "DETAIL_TEXT" => 'gdfgdfgfdgdfgfdgd fsd',
             "BLOG_ID" => $arBlog["ID"],
             "AUTHOR_ID" => $arUser["ID"],
            "=DATE_CREATE" => ConvertTimeStamp(),
             "DATE_PUBLISH" => ConvertTimeStamp(),
             "PUBLISH_STATUS" => BLOG_PUBLISH_STATUS_PUBLISH,
             "ENABLE_TRACKBACK" => 'N',
             "ENABLE_COMMENTS" => 'Y',
             "CATEGORY_ID" => $CATEGORY_ID,
             "PERMS_P" => Array("8" => BLOG_PERMS_READ, "3" => BLOG_PERMS_READ),
             "PERMS_C" => Array("8" => BLOG_PERMS_WRITE, "3" => BLOG_PERMS_WRITE)
                 );
           $newID = CBlogPost::Add($polya2);
    }
   }
  }

AddEventHandler("main", "OnBeforeUserRegister", "OnBeforeUserRegisterHandler");

function OnBeforeUserRegisterHandler($arFields)
  {
   if ($arFields["USER_ID"]>0 && CModule::IncludeModule("blog") && CModule::IncludeModule("socialnetwork"))
   {
            $arFields = array(
             "NAME" => 'Блог'.$arFields["LOGIN"],
             "DESCRIPTION" => 'Стена пользователя'.$arFields["LOGIN"],
             "GROUP_ID" => '9',
             "ENABLE_IMG_VERIF" => 'Y',
             "EMAIL_NOTIFY" => 'N',
             "ENABLE_RSS" => "Y",
             "URL" => "wall-".$USER->GetID(),
           "ACTIVE" => "Y",
           "OWNER_ID" => $USER->GetID());
   }
   $newID = CBlog::Add($arFields);
  }