title: single quote in database values breaks import
body: <p>Hello and sorry I've seen alot of problems like this but no direct answer for me,</p>
  
  <p>First let me say this is a WordPress problem the retards are not escaping single quotes when there saved in the database so I now have the problem that I have an exported database I have to restore but can't,</p>
  
  <p>This is an Example of my Problem</p>
  
  <pre><code>INSERT INTO `demo` VALUES(1, 'wordpress\'s developers are stupid');
  </code></pre>
  
  <p>Now as for why WordPress doesn't run there database inserts though <code>mysql_real_escape_string</code> is beyond me but I'm using notepad++ to fix the issue so I need a REGEX way to keep the string and replace the ' mark out of the string</p>
  
  <p>So I've managed to get one working that converts the HTML tags:</p>
  
  <pre><code>   Find: =\\\'([^']*)\\\'
     Replace: =\"\1\"
  </code></pre>
  
  <p>So I need to find '(quote open) \'(random quote) ',(quote close with , after for next value in query) or ');(quote close at end of query)</p>
  
  <p>So I need to change the random quote to <code>&amp;#39;</code></p>
  
  <p>For my file I'm getting a this exact error</p>
  
  <pre><code>SQL query:
  
  INSERT INTO `wp_options` VALUES (787,0,'_transient_feed_9d5a2d683089079967601880d493887f','a:4:{s:5:\"child\";a:1:{s:0:\"\";a:1:{s:3:\"rss\";a:1:{i:0;a:6:{s:4:\"data\";s:4:\"\n \n\";s:7:\"attribs\";a:1:{s:0:\"\";a:1:{s:7:\"version\";s:3:\"2.0\";}}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:1:{s:0:\"\";a:1:{s:7:\"channel\";a:1:{i:0;a:6:{s:4:\"data\";s:83:\"\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:2:{s:0:\"\";a:4:{s:5:\"title\";a:1:{i:0;a:5:{s:4:\"data\";s:48:\"link:http://www.agressousergroup.co.uk/ - Google Blog Search\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"link\";a:1:{i:0;a:5:{s:4:\"data\";s:85:\"http://www.google.com/search?ie=utf-8&amp;q=link:http://www.agressousergroup.co.uk[...]
  
  MySQL said: 
  
  #1366 - Incorrect string value: '\x85 item...' for column 'option_value' at row 1  
  </code></pre>
  
  <p>The really annoying thing is that when I search the script im using for "x85 item" there are no results (I'm using notepad++)</p>
  
  <p>Exact Query:</p>
  
  <pre><code>INSERT INTO `wp_options` VALUES (787,0,'_transient_feed_9d5a2d683089079967601880d493887f','a:4:{s:5:\"child\";a:1:{s:0:\"\";a:1:{s:3:\"rss\";a:1:{i:0;a:6:{s:4:\"data\";s:4:\"\n  \n\";s:7:\"attribs\";a:1:{s:0:\"\";a:1:{s:7:\"version\";s:3:\"2.0\";}}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:1:{s:0:\"\";a:1:{s:7:\"channel\";a:1:{i:0;a:6:{s:4:\"data\";s:83:\"\n    \n    \n    \n    \n    \n    \n    \n    \n    \n    \n    \n    \n    \n    \n    \n    \n  \";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:2:{s:0:\"\";a:4:{s:5:\"title\";a:1:{i:0;a:5:{s:4:\"data\";s:48:\"link:http://www.agressousergroup.co.uk/ - Google Blog Search\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"link\";a:1:{i:0;a:5:{s:4:\"data\";s:85:\"http://www.google.com/search?ie=utf-8&amp;q=link:http://www.agressousergroup.co.uk/&amp;tbm=blg&amp;tbs=sbd:1\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:11:\"description\";a:1:{i:0;a:5:{s:4:\"data\";s:88:\"Results &lt;b&gt;1&lt;/b&gt; - &lt;b&gt;10&lt;/b&gt; of about &lt;b&gt;117&lt;/b&gt; for &lt;b&gt;link:http://www.agressousergroup.co.uk/&lt;/b&gt;.\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"item\";a:10:{i:0;a:6:{s:4:\"data\";s:47:\"\n      \n      \n      \n      \n      \n      \n    \";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:2:{s:0:\"\";a:3:{s:5:\"title\";a:1:{i:0;a:5:{s:4:\"data\";s:67:\"SCOM 2007 R2 Event Log Alerting and Monitoring for Azure &lt;b&gt;...&lt;/b&gt;\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"link\";a:1:{i:0;a:5:{s:4:\"data\";s:125:\"http://blogs.msdn.com/b/walterm/archive/2011/08/19/scom-2007-r2-event-log-alerting-and-monitoring-for-azure-applications.aspx\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:11:\"description\";a:1:{i:0;a:5:{s:4:\"data\";s:543:\"For this first part of setting up rules, I am essentially following guidance which can be found on TechNet at &lt;em&gt;http&lt;/em&gt;://technet.microsoft.com/en-us/library/gg508734.aspx. To begin, we will launch &lt;b&gt;...&lt;/b&gt; this series of documents. From the Actions pane on the far right, select the New &lt;em&gt;link&lt;/em&gt;, and then from the popup menu, select the Custom Rule… item. &lt;b&gt;....&lt;/b&gt; Below is my successful telnet session that was launched from the command line with the command telnet &lt;em&gt;localhost&lt;/em&gt; 25. You can use anything for &lt;b&gt;...&lt;/b&gt;\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}s:32:\"http://purl.org/dc/elements/1.1/\";a:3:{s:9:\"publisher\";a:1:{i:0;a:5:{s:4:\"data\";s:53:\"Thoughts on ALM, Azure, and Agile by Walter Myers III\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:7:\"creator\";a:1:{i:0;a:5:{s:4:\"data\";s:16:\"Walter Myers III\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"date\";a:1:{i:0;a:5:{s:4:\"data\";s:29:\"Fri, 19 Aug 2011 01:02:14 GMT\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}}}i:1;a:6:{s:4:\"data\";s:47:\"\n      \n      \n      \n      \n      \n      \n    \";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:2:{s:0:\"\";a:3:{s:5:\"title\";a:1:{i:0;a:5:{s:4:\"data\";s:73:\"HowTo install the Brother DCP-&lt;b&gt;7065DN&lt;/b&gt; in a Linux network &lt;b&gt;...&lt;/b&gt;\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"link\";a:1:{i:0;a:5:{s:4:\"data\";s:91:\"http://bleedux.wordpress.com/2011/08/01/brother-dcp-7065dn-receiving-data-but-not-printing/\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:11:\"description\";a:1:{i:0;a:5:{s:4:\"data\";s:320:\"Result: none available for the DCP-&lt;em&gt;7065DN&lt;/em&gt;. &lt;b&gt;...&lt;/b&gt; emacs PathToTemporaryDir/usr/local/Brother/Printer/&lt;em&gt;DCP7065DN&lt;/em&gt;/cupswrapper/&lt;em&gt;cupswrapperDCP7065DN&lt;/em&gt;-2.0.4 &lt;b&gt;...&lt;/b&gt; If you now return to &lt;em&gt;http&lt;/em&gt;://&lt;em&gt;localhost&lt;/em&gt;:631/ &lt;b&gt;...&lt;/b&gt; &lt;em&gt;Link&lt;/em&gt; the files in the following way: &lt;b&gt;...&lt;/b&gt;\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}s:32:\"http://purl.org/dc/elements/1.1/\";a:3:{s:9:\"publisher\";a:1:{i:0;a:5:{s:4:\"data\";s:17:\"The Bleeding Edge\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:7:\"creator\";a:1:{i:0;a:5:{s:4:\"data\";s:12:\"M. Marschall\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"date\";a:1:{i:0;a:5:{s:4:\"data\";s:29:\"Mon, 01 Aug 2011 00:33:11 GMT\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}}}i:2;a:6:{s:4:\"data\";s:47:\"\n      \n      \n      \n      \n      \n      \n    \";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:2:{s:0:\"\";a:3:{s:5:\"title\";a:1:{i:0;a:5:{s:4:\"data\";s:74:\"Outlook Web Access Web Administration Tool - The page cannot be &lt;b&gt;...&lt;/b&gt;\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"link\";a:1:{i:0;a:5:{s:4:\"data\";s:112:\"http://community.spiceworks.com/topic/141270-outlook-web-access-web-administration-tool-the-page-cannot-be-found\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:11:\"description\";a:1:{i:0;a:5:{s:4:\"data\";s:551:\"I downloaded the Outlook Web Access Web Administration Tool from: &lt;em&gt;http&lt;/em&gt;://www.microsoft.com/downloads/en/details.aspx? &lt;b&gt;...&lt;/b&gt; FamilyID=&lt;em&gt;4bbe7065&lt;/em&gt;-a04e-43ca-8220-859212411e10&amp;amp;displaylang=en &lt;b&gt;...&lt;/b&gt; server itself, it has been a while since had a 2003 server, but I recall similiar issues. I don&amp;#39;t have a fix, but I do remember always RDP&amp;#39;ing into the server and accessing the Web admin tool locally. Here is a helpful &lt;em&gt;link&lt;/em&gt;. &lt;em&gt;http&lt;/em&gt;://technet.microsoft.com/en-us/library/bb508837(EXCHG.65).aspx &lt;b&gt;...&lt;/b&gt;\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}s:32:\"http://purl.org/dc/elements/1.1/\";a:3:{s:9:\"publisher\";a:1:{i:0;a:5:{s:4:\"data\";s:20:\"Spiceworks Community\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:7:\"creator\";a:1:{i:0;a:5:{s:4:\"data\";s:7:\"Reg1145\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"date\";a:1:{i:0;a:5:{s:4:\"data\";s:29:\"Thu, 26 May 2011 14:45:38 GMT\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}}}i:3;a:6:{s:4:\"data\";s:47:\"\n      \n      \n      \n      \n      \n      \n    \";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:2:{s:0:\"\";a:3:{s:5:\"title\";a:1:{i:0;a:5:{s:4:\"data\";s:70:\"Transmittal Letter No. 661 Volume I To: Heads of Government &lt;b&gt;...&lt;/b&gt;\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"link\";a:1:{i:0;a:5:{s:4:\"data\";s:46:\"http://www.fms.treas.gov/tfm/vol1/v1p4c210.pdf\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:11:\"description\";a:1:{i:0;a:5:{s:4:\"data\";s:520:\"&lt;em&gt;http&lt;/em&gt;://www.paymentaccuracy. gov used to post specified improper payment information submitted by agencies, consist- ent with the requirements of. Executive Order 13520, § 2.(b). This official Web site also is used to collect from the public &lt;b&gt;...&lt;/b&gt; changes, and &lt;em&gt;links&lt;/em&gt; to additional resources and information otherwise available on the. Internet. The timelines for agencies to submit required improper payments information for posting on the PaymentAccuracy.gov. Web site are discussed in &lt;b&gt;...&lt;/b&gt;\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}s:32:\"http://purl.org/dc/elements/1.1/\";a:3:{s:9:\"publisher\";a:1:{i:0;a:5:{s:4:\"data\";s:16:\"FMS Publications\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:7:\"creator\";a:1:{i:0;a:5:{s:4:\"data\";s:7:\"unknown\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"date\";a:1:{i:0;a:5:{s:4:\"data\";s:29:\"Thu, 14 Apr 2011 19:34:56 GMT\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}}}i:4;a:6:{s:4:\"data\";s:47:\"\n      \n      \n      \n      \n      \n      \n    \";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:2:{s:0:\"\";a:3:{s:5:\"title\";a:1:{i:0;a:5:{s:4:\"data\";s:21:\"????? - ????\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"link\";a:1:{i:0;a:5:{s:4:\"data\";s:41:\"http://toos-iran.blogfa.com/post-171.aspx\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:11:\"description\";a:1:{i:0;a:5:{s:4:\"data\";s:781:\"?????? ???? d-&lt;em&gt;link&lt;/em&gt; 300t ???? adsl ??????? (---) 6295. &lt;b&gt;....&lt;/b&gt; ??? &lt;em&gt;localhost&lt;/em&gt; ????? 127.0.0.1 ????? 6421. &lt;b&gt;....&lt;/b&gt; ??? ???? ???? ? ???? ?? ???? ???? ?????? (TP-&lt;em&gt;Link&lt;/em&gt; TD-W8901G) 6541. &lt;b&gt;....&lt;/b&gt; ??????? ???????? ??? ????? ?? &lt;em&gt;http&lt;/em&gt;://www.demonoid.com/ 6830. &lt;b&gt;....&lt;/b&gt; &lt;em&gt;7065&lt;/em&gt;. ?? chat ???? 7066. ?????? ???? ???? ADSL 7067. ???? ???? ?? ??????? wireless ???? 7068. ????? ????? ?? ??? ????? ??? ???? ???? 7069. ????? ??????? ???? ????? ?? ??? 2003 7070. ???? ???? ??????? 7071. ???? ** ?????? 7072. ?????? &lt;b&gt;...&lt;/b&gt;\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}s:32:\"http://purl.org/dc/elements/1.1/\";a:3:{s:9:\"publisher\";a:1:{i:0;a:5:{s:4:\"data\";s:10:\"?????\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:7:\"creator\";a:1:{i:0;a:5:{s:4:\"data\";s:9:\"toos-iran\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"date\";a:1:{i:0;a:5:{s:4:\"data\";s:29:\"Wed, 23 Mar 2011 07:00:00 GMT\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}}}i:5;a:6:{s:4:\"data\";s:47:\"\n      \n      \n      \n      \n      \n      \n    \";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:2:{s:0:\"\";a:3:{s:5:\"title\";a:1:{i:0;a:5:{s:4:\"data\";s:52:\"Learning Ruby: Expert Advice for Advanced Developers\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"link\";a:1:{i:0;a:5:{s:4:\"data\";s:50:\"http://mashable.com/2011/02/02/advanced-ruby-code/\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:11:\"description\";a:1:{i:0;a:5:{s:4:\"data\";s:324:\"&lt;em&gt;http&lt;/em&gt;://&lt;em&gt;localhost&lt;/em&gt;:9292/to_a -&amp;gt; 123. # &lt;em&gt;http&lt;/em&gt;://&lt;em&gt;localhost&lt;/em&gt;:9292/pop -&amp;gt; 3. # &lt;em&gt;http&lt;/em&gt;://&lt;em&gt;localhost&lt;/em&gt;:9292/shift -&amp;gt; 1. # Implementations in other languages (thanks guys!): # Node.js: &lt;em&gt;https&lt;/em&gt;://gist.github.com/700995. # Groovy: https://gist.github.com/702337 &lt;b&gt;...&lt;/b&gt;\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}s:32:\"http://purl.org/dc/elements/1.1/\";a:3:{s:9:\"publisher\";a:1:{i:0;a:5:{s:4:\"data\";s:9:\"Mashable!\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:7:\"creator\";a:1:{i:0;a:5:{s:4:\"data\";s:12:\"Jolie O\'Dell\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"date\";a:1:{i:0;a:5:{s:4:\"data\";s:29:\"Wed, 02 Feb 2011 13:40:03 GMT\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}}}i:6;a:6:{s:4:\"data\";s:47:\"\n      \n      \n      \n      \n      \n      \n    \";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:2:{s:0:\"\";a:3:{s:5:\"title\";a:1:{i:0;a:5:{s:4:\"data\";s:69:\"Sending Email Alert for Application Current State « Middleware Magic\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"link\";a:1:{i:0;a:5:{s:4:\"data\";s:43:\"http://middlewaremagic.com/weblogic/?p=7042\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:11:\"description\";a:1:{i:0;a:5:{s:4:\"data\";s:535:\"If you see an Empty Classpath even after running the “setWLSEnv.sh” then please refer to the Note mentioned at Step3) in the Following post: &lt;em&gt;http&lt;/em&gt;://middlewaremagic.com/weblogic/?page_id=1492 Step-5) Now run the WLST Script in the same &lt;b&gt;...&lt;/b&gt; total.number.of.servers=3. server.name.1=AdminServer server.url.1=t3://&lt;em&gt;localhost&lt;/em&gt;:7001. server.name.2=MS-1 server.url.2=t3://&lt;em&gt;localhost&lt;/em&gt;:5001. server.name.3=MS-2 server.url.3=t3://&lt;em&gt;localhost&lt;/em&gt;:6001. # Check Server State At following interval in &lt;b&gt;...&lt;/b&gt;\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}s:32:\"http://purl.org/dc/elements/1.1/\";a:3:{s:9:\"publisher\";a:1:{i:0;a:5:{s:4:\"data\";s:16:\"Middleware Magic\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:7:\"creator\";a:1:{i:0;a:5:{s:4:\"data\";s:11:\"Ravish Mody\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"date\";a:1:{i:0;a:5:{s:4:\"data\";s:29:\"Thu, 07 Jul 2011 12:38:30 GMT\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}}}i:7;a:6:{s:4:\"data\";s:47:\"\n      \n      \n      \n      \n      \n      \n    \";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:2:{s:0:\"\";a:3:{s:5:\"title\";a:1:{i:0;a:5:{s:4:\"data\";s:54:\"Server Kurulumu : Hatalar , Sorunlar , Bilmedikleriniz\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"link\";a:1:{i:0;a:5:{s:4:\"data\";s:89:\"http://pvp-serverler.forumclan.com/t2019-server-kurulumu-hatalar-sorunlar-bilmedikleriniz\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:11:\"description\";a:1:{i:0;a:5:{s:4:\"data\";s:644:\"Host:HamachiIp.100// &lt;em&gt;Localhost&lt;/em&gt; // 192.168.2.100. Port:3306[Mysql Port] ID:Root PW:123456[Degistirmediyseniz] &lt;b&gt;....&lt;/b&gt; pc . give_item2 ( &amp;quot;&lt;em&gt;7065&lt;/em&gt;&amp;quot; , 1 ) pc . give_item2 ( &amp;quot;11835&amp;quot; , 1 ) pc . give_item2 ( &amp;quot;12645&amp;quot; , 1 ) pc . give_item2 ( &amp;quot;13025&amp;quot; , 1 ) pc . give_item2 ( &amp;quot;14105&amp;quot; , 1 ) pc . give_item2 ( &amp;quot;15089&amp;quot; , 1 ) pc . give_item2 ( &amp;quot;16105&amp;quot; , 1 ) pc . give_item2 ( &amp;quot;17105&amp;quot; , 1 ) say_reward ( &amp;quot;Du erhielst Super Eline Saglk . Schamiset!&amp;quot; ) end &lt;b&gt;...&lt;/b&gt; Kullanici profilini gör &lt;em&gt;http&lt;/em&gt;://pvp-serverler.forumclan.com &lt;b&gt;...&lt;/b&gt;\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}s:32:\"http://purl.org/dc/elements/1.1/\";a:3:{s:9:\"publisher\";a:1:{i:0;a:5:{s:4:\"data\";s:71:\"Metin2 PVP Serverler l Private Serverler l Knight Private Serverler l :\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:7:\"creator\";a:1:{i:0;a:5:{s:4:\"data\";s:10:\"MrLeqandry\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"date\";a:1:{i:0;a:5:{s:4:\"data\";s:29:\"Thu, 06 Jan 2011 15:59:17 GMT\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}}}i:8;a:6:{s:4:\"data\";s:47:\"\n      \n      \n      \n      \n      \n      \n    \";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:2:{s:0:\"\";a:3:{s:5:\"title\";a:1:{i:0;a:5:{s:4:\"data\";s:51:\"CARA SPYWARE MENGINFEKSI KOMPUTER « Lombok_Creck84\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"link\";a:1:{i:0;a:5:{s:4:\"data\";s:74:\"http://creck84.wordpress.com/2010/12/28/cara-spyware-menginfeksi-komputer/\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:11:\"description\";a:1:{i:0;a:5:{s:4:\"data\";s:522:\"Seorang penyerang remote bisa membuat &lt;em&gt;link&lt;/em&gt; URL dibuat menggunakan Objek Data Tag akan dieksekusi di web browser&amp;#39;s korban dalam konteks keamanan dari situs hosting, setelah &lt;em&gt;link&lt;/em&gt; diklik. Para penyerang memanfaatkan &lt;b&gt;...&lt;/b&gt; &lt;em&gt;HTTP&lt;/em&gt; / 1.1 200 OK Tanggal: Mon, 18 April 2005 12: 27: 30 GMTServer: Apache / 1.3.33 (Unix) mod_deflate / 1.0.21 Koneksi: tutup Transfer - Encoding: chunked Content - Type: application / HTA script &amp;lt; bahasa =&amp;gt; JScript try { . Diri moveTo (5000, 5000); &lt;b&gt;...&lt;/b&gt;\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}s:32:\"http://purl.org/dc/elements/1.1/\";a:3:{s:9:\"publisher\";a:1:{i:0;a:5:{s:4:\"data\";s:14:\"Lombok_Creck84\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:7:\"creator\";a:1:{i:0;a:5:{s:4:\"data\";s:14:\"Lombok_Creck84\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"date\";a:1:{i:0;a:5:{s:4:\"data\";s:29:\"Tue, 28 Dec 2010 04:51:11 GMT\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}}}i:9;a:6:{s:4:\"data\";s:47:\"\n      \n      \n      \n      \n      \n      \n    \";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:2:{s:0:\"\";a:3:{s:5:\"title\";a:1:{i:0;a:5:{s:4:\"data\";s:42:\"???????? ? telnet - ZABBIX Forums\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"link\";a:1:{i:0;a:5:{s:4:\"data\";s:50:\"http://www.zabbix.com/forum/showthread.php?t=20387\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:11:\"description\";a:1:{i:0;a:5:{s:4:\"data\";s:553:\"&lt;em&gt;http&lt;/em&gt;://www.zabbix.com/documentation/...l/config/items &lt;b&gt;...&lt;/b&gt; [root@&lt;em&gt;localhost&lt;/em&gt; ~]# /usr/sbin/tcpdump -i eth0 -s 0 -X &amp;quot;host 192.168.1.52 and tcp port 10010&amp;quot; tcpdump: verbose output suppressed, use -v or -vv for full protocol decode listening on eth0, &lt;em&gt;link&lt;/em&gt; -type EN10MB (Ethernet), capture size 65535 bytes &lt;b&gt;...&lt;/b&gt; command&amp;gt;&amp;quot;.fo 0x00a0: 7220 696e 666f 726d 6174 696f 6e20 6f6e r.information.on 0x00b0: 2061 2073 &lt;em&gt;7065&lt;/em&gt; 6369 6669 6320 636f 6d6d .a.specific.comm 0x00c0: 616e 642e 0a0d and. &lt;b&gt;...&lt;/b&gt;\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}s:32:\"http://purl.org/dc/elements/1.1/\";a:3:{s:9:\"publisher\";a:1:{i:0;a:5:{s:4:\"data\";s:13:\"ZABBIX Forums\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:7:\"creator\";a:1:{i:0;a:5:{s:4:\"data\";s:5:\"angro\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"date\";a:1:{i:0;a:5:{s:4:\"data\";s:29:\"Mon, 27 Dec 2010 23:11:53 GMT\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}}}}}s:36:\"http://a9.com/-/spec/opensearch/1.1/\";a:3:{s:12:\"totalResults\";a:1:{i:0;a:5:{s:4:\"data\";s:3:\"117\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:10:\"startIndex\";a:1:{i:0;a:5:{s:4:\"data\";s:1:\"1\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:12:\"itemsPerPage\";a:1:{i:0;a:5:{s:4:\"data\";s:2:\"10\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}}}}}}}}}}}s:4:\"type\";i:128;s:7:\"headers\";a:7:{s:12:\"content-type\";s:28:\"text/xml; charset=ISO-8859-1\";s:4:\"date\";s:29:\"Tue, 11 Oct 2011 09:59:27 GMT\";s:7:\"expires\";s:2:\"-1\";s:13:\"cache-control\";s:18:\"private, max-age=0\";s:10:\"set-cookie\";a:2:{i:0;s:143:\"PREF=ID=f20c4b1c78116086:FF=0:TM=1318327167:LM=1318327168:S=JmwTN04g_cBBkXlQ; expires=Thu, 10-Oct-2013 09:59:28 GMT; path=/; domain=.google.com\";i:1;s:212:\"NID=51=kumBg-YqiVjIylrlQZnAp1IHv6-PAK1TIMAXdUBv4d9njuL-S5g35y0ZJYHQQxUJrc3rG8i2vRNHvkb_Ydpag_xqTuIEihrf2G0LM2c6pTZ6imb8lozQWVJOKQoEV4gm; expires=Wed, 11-Apr-2012 09:59:28 GMT; path=/; domain=.google.com; HttpOnly\";}s:6:\"server\";s:3:\"gws\";s:16:\"x-xss-protection\";s:13:\"1; mode=block\";}s:5:\"build\";s:14:\"20090627192103\";}','no');
  </code></pre>