디아블로(inven) 댓글 xml을 php로 파싱해서 xe에 insert 하는 방법 - 2

<?xml version="1.0" encoding="utf-8"?>

<resultdata>

<message>1</message>

<cmtcount>7</cmtcount>

<pagecount>100</pagecount>

<lastblock>0</lastblock>

<addcomment>0</addcomment>

<commentlist titlenum='0'>

<item cmtidx="81460" cmtpidx="81460" state="Y" bestBg="0"

adminflag="0" dice="0" chkGuest="0" amaflag="0">

<o_date>2017-11-05 21:55:07</o_date>

<o_name>등껍질</o_name>

<o_icon>0</o_icon>

<o_comment>룬에&nbsp;극확&nbsp;5씩&nbsp;증가시켜주는거&nbsp;있어서&nbsp;극확필요가&nbsp;없어요.

</o_comment>

<o_recommend>0</o_recommend>

<o_notrecommend>0</o_notrecommend>

<o_level>lv50</o_level>

<certuser>1</certuser>

<chkGoodBad>1</chkGoodBad>

<chkReply>1</chkReply>

</item>

<item cmtidx="81461" cmtpidx="81460" state="Y" bestBg="0"

adminflag="0" dice="0" chkGuest="0" amaflag="0">

<o_date>2017-11-05 21:55:43</o_date>

<o_name>김와루</o_name>

<o_icon>0</o_icon>

<o_comment>그게뭐에요?&nbsp;아예&nbsp;그냥&nbsp;대균솔플이건&nbsp;일균솔플이건&nbsp;그냥&nbsp;극확이&nbsp;안필요한거에여?

</o_comment>

<o_recommend>0</o_recommend>

<o_notrecommend>0</o_notrecommend>

<o_level>lv06</o_level>

<certuser>1</certuser>

<chkGoodBad>1</chkGoodBad>

</item>

<item cmtidx="81465" cmtpidx="81465" state="Y" bestBg="0"

adminflag="0" dice="0" chkGuest="0" amaflag="0">

<o_date>2017-11-05 21:59:11</o_date>

<o_name>Symarine</o_name>

<o_icon>0</o_icon>

<o_comment>냉기&nbsp;룬을&nbsp;보시면&nbsp;맞은&nbsp;적이&nbsp;5초간&nbsp;극확&nbsp;5%&nbsp;추가&nbsp;디버프를&nbsp;받는데이&nbsp;효과가&nbsp;극확&nbsp;100까지&nbsp;중첩됩니다.어차피&nbsp;장갑이나&nbsp;성물&nbsp;같은&nbsp;경우&nbsp;극확&nbsp;빼고&nbsp;넣을&nbsp;만한&nbsp;옵션도&nbsp;없어서반지,&nbsp;목걸이&nbsp;정도에서&nbsp;극확을&nbsp;빼면&nbsp;됩니다

</o_comment>

<o_recommend>0</o_recommend>

<o_notrecommend>0</o_notrecommend>

<o_level>lv62</o_level>

<certuser>1</certuser>

<chkGoodBad>1</chkGoodBad>

<chkReply>1</chkReply>

</item>

<item cmtidx="81466" cmtpidx="81465" state="Y" bestBg="0"

adminflag="0" dice="0" chkGuest="0" amaflag="0">

<o_date>2017-11-05 21:59:40</o_date>

<o_name>Symarine</o_name>

<o_icon>0</o_icon>

<o_comment>역병시창&nbsp;반지의경우&nbsp;극피&nbsp;공속&nbsp;재감,목걸이의경우&nbsp;냉피&nbsp;공속&nbsp;극피가&nbsp;졸업옵입니다

</o_comment>

<o_recommend>0</o_recommend>

<o_notrecommend>0</o_notrecommend>

<o_level>lv62</o_level>

<certuser>1</certuser>

<chkGoodBad>1</chkGoodBad>

</item>

<item cmtidx="81467" cmtpidx="81465" state="Y" bestBg="0"

adminflag="0" dice="0" chkGuest="0" amaflag="0">

<o_date>2017-11-05 22:01:26</o_date>

<o_name>김와루</o_name>

<o_icon>0</o_icon>

<o_comment>아하&nbsp;그렇군여&nbsp;감사합니다&nbsp;ㅎㅎ&nbsp;극확을&nbsp;안맞춰도되다니..&nbsp;ㅎㅎ&nbsp;좋네여&nbsp;!

</o_comment>

<o_recommend>0</o_recommend>

<o_notrecommend>0</o_notrecommend>

<o_level>lv06</o_level>

<certuser>1</certuser>

<chkGoodBad>1</chkGoodBad>

</item>

<item cmtidx="81468" cmtpidx="81465" state="Y" bestBg="0"

adminflag="0" dice="0" chkGuest="0" amaflag="0">

<o_date>2017-11-05 22:02:57</o_date>

<o_name>Symarine</o_name>

<o_icon>0</o_icon>

<o_comment>네&nbsp;그리고&nbsp;전체적으로&nbsp;트래때보단&nbsp;재감도&nbsp;높아&nbsp;망땅&nbsp;쿨도&nbsp;빨리&nbsp;돌아오고냉기&nbsp;룬이라&nbsp;그런지&nbsp;시창&nbsp;이펙트가&nbsp;시원시원&nbsp;합니다재밌으실거에요

</o_comment>

<o_recommend>0</o_recommend>

<o_notrecommend>0</o_notrecommend>

<o_level>lv62</o_level>

<certuser>1</certuser>

<chkGoodBad>1</chkGoodBad>

</item>

<item cmtidx="90000" cmtpidx="81468" state="Y" bestBg="0"

adminflag="0" dice="0" chkGuest="0" amaflag="0">

<o_date>2017-11-05 22:03:34</o_date>

<o_name>김와루</o_name>

<o_icon>0</o_icon>

<o_comment>넵&nbsp;지금&nbsp;한지&nbsp;얼마안되서&nbsp;겨우&nbsp;인검&nbsp;역병식으로&nbsp;맞춰놓은&nbsp;정도인데도&nbsp;시원시원하고&nbsp;좋네여&nbsp;ㅎㅎ

</o_comment>

<o_recommend>0</o_recommend>

<o_notrecommend>0</o_notrecommend>

<o_level>lv06</o_level>

<certuser>1</certuser>

<chkGoodBad>1</chkGoodBad>

</item>

<item cmtidx="90001" cmtpidx="90000" state="Y" bestBg="0"

adminflag="0" dice="0" chkGuest="0" amaflag="0">

<o_date>2017-11-05 22:03:34</o_date>

<o_name>김와루</o_name>

<o_icon>0</o_icon>

<o_comment>넵&nbsp;지금&nbsp;한지&nbsp;얼마안되서&nbsp;겨우&nbsp;인검&nbsp;역병식으로&nbsp;맞춰놓은&nbsp;정도인데도&nbsp;시원시원하고&nbsp;좋네여&nbsp;ㅎㅎ

</o_comment>

<o_recommend>0</o_recommend>

<o_notrecommend>0</o_notrecommend>

<o_level>lv06</o_level>

<certuser>1</certuser>

<chkGoodBad>1</chkGoodBad>

</item>

</commentlist>

</resultdata>




<?php



$module_srl=199;

$document_srl=204;

define('__XE__',true);

require_once("../../config/config.inc.php");

$oContext=&Context::getInstance();

$oContext->init();

$oCommentController=&getController('comment');



$url="http://localhost/php_xml/dia.xml";



$response = file_get_contents($url);



$object = simplexml_load_string($response);

//print_r($object);



//echo "cmtcount=".$object->cmtcount;

//echo "\n";



foreach ($object->commentlist->item as $value){

       

    $cmtidx=(string)$value['cmtidx']; //[] 사이에 ''를 넣어줘야 한다.

    echo "cmtidx=".$cmtidx;

    echo "\n";

    $cmtpidx=(string)$value['cmtpidx'];

    echo "cmtpidx=".$cmtpidx;

    echo "\n";

    $o_date=(string)$value->o_date;

    echo "o_date=".$o_date;

    echo "\n";

    $o_name=(string)$value->o_name;

    echo "o_name=".$o_name;

    echo "\n";

    $o_comment=(string)$value->o_comment ;

    echo "o_comment=".$o_comment;

    echo "\n";

    echo "\n";

   

    $parent_srl;

    $parent_srl_before;

    $obj=null;

   

    $comment_srl=getNextSequence();

    echo "comment_srl=".$comment_srl;

    echo "\n";

   

    if($cmtidx==$cmtpidx){

        echo "if\n";

        $parent_srl_flag=false;

        $parent_srl=$comment_srl;

        $cmtidx_old=$cmtidx;

    }else if($cmtidx_old==$cmtpidx){

        echo "elseif\n";

        $parent_srl_flag=true;

        $parent_srl=$parent_srl;

    }else if($cmtidx_before==$cmtpidx){

        $parent_srl_flag=true;

        echo "elseif 2\n";

        $parent_srl=$comment_srl_before;

    }else{

        echo "else\n";

    }

   

    echo "cmtidx_old=".$cmtidx_old;

    echo "\n";

   

    echo "parent_srl=".$parent_srl;

    echo "\n";

   

    $obj->comment_srl=$comment_srl;

    $obj->module_srl=$module_srl;

    $obj->document_srl=$document_srl;

    $obj->nick_name=$o_name;

    $obj->content=$o_comment;   

    if ($parent_srl_flag){

        $obj->parent_srl=$parent_srl;

    }

   

    print_r($obj);

   

    $oCommentController->insertComment($obj,true);

   

    $cmtidx_before=$cmtidx;

    $comment_srl_before=$comment_srl;

   

   

    echo "\n";

    echo "\n";

   

   

}



?>