#
# phpBB Backup Script
# Dump of tables for phpbb303_
# DATE : 29-11-2008 01:04:27 GMT
#
INSERT INTO phpbb303_attachments (attach_id, post_msg_id, topic_id, in_message, poster_id, is_orphan, physical_filename, real_filename, download_count, attach_comment, extension, mimetype, filesize, filetime, thumbnail) VALUES (1, 4, 4, 0, 2, 0, '2_74fcf3f0da8378e69caf35ee41949869', 'Halloween.rar', 2, 'Halloween theme pack', 'rar', 'application/octet-stream', 549637, 1224567573, 0),(2, 5, 4, 0, 2, 0, '2_bed06d3dcb72708040d58d4e3fe2b905', 'Gamer17.rar', 10, 'Gamer17 theme pack', 'rar', 'application/octet-stream', 466090, 1224567989, 0),(3, 6, 4, 0, 2, 0, '2_93f5f09a3b1a9701e80a303e64c7a270', 'EI.rar', 9, 'EI theme pack', 'rar', 'application/octet-stream', 917744, 1224568850, 0),(4, 7, 4, 0, 2, 0, '2_35289af6c6af9939a28aabcf5c155501', 'Quake4.rar', 11, 'Quake4 theme pack', 'rar', 'application/octet-stream', 603004, 1224569185, 0),(5, 8, 4, 0, 2, 0, '2_1977b4b157389cbdb4a119146a6303a7', 'NB-Teal.rar', 12, 'NB_Teal theme pack', 'rar', 'application/octet-stream', 546668, 1224569426, 0),(7, 14, 6, 0, 2, 0, '2_3583f89dc7381635e21863278dc1e3ca', 'azt.rar', 8, '', 'rar', 'application/octet-stream', 1104796, 1226206526, 0);
INSERT INTO phpbb303_forums (forum_id, parent_id, left_id, right_id, forum_parents, forum_name, forum_desc, forum_desc_bitfield, forum_desc_options, forum_desc_uid, forum_link, forum_password, forum_style, forum_image, forum_rules, forum_rules_link, forum_rules_bitfield, forum_rules_options, forum_rules_uid, forum_topics_per_page, forum_type, forum_status, forum_posts, forum_topics, forum_topics_real, forum_last_post_id, forum_last_poster_id, forum_last_post_subject, forum_last_post_time, forum_last_poster_name, forum_last_poster_colour, forum_flags, display_on_index, enable_indexing, enable_icons, enable_prune, prune_next, prune_days, prune_viewed, prune_freq) VALUES (7, 3, 2, 3, 'a:1:{i:3;a:2:{i:0;s:13:\"Announcements\";i:1;i:0;}}', 'General', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 1, 1, 1, 2, 2, 'phpMyBitTorrent V2.0', 1224476927, 'joeroberts', 'AA0000', 32, 0, 1, 0, 0, 0, 7, 7, 1),(5, 0, 13, 22, '', 'Mod\'s', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 48, 0, 1, 0, 0, 0, 7, 7, 1),(6, 0, 23, 26, '', 'Off Topic', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 48, 0, 1, 0, 0, 0, 7, 7, 1),(4, 0, 5, 12, '', 'Bug Reports', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 48, 0, 1, 0, 0, 0, 7, 7, 1),(3, 0, 1, 4, '', 'Announcements', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 48, 0, 1, 0, 0, 0, 7, 7, 1),(8, 4, 6, 7, 'a:1:{i:4;a:2:{i:0;s:11:\"Bug Reports\";i:1;i:0;}}', 'Admin bugs', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 48, 1, 1, 1, 0, 0, 7, 7, 1),(9, 4, 8, 9, 'a:1:{i:4;a:2:{i:0;s:11:\"Bug Reports\";i:1;i:0;}}', 'Moderator Bugs', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 48, 1, 1, 1, 0, 0, 7, 7, 1),(10, 4, 10, 11, 'a:1:{i:4;a:2:{i:0;s:11:\"Bug Reports\";i:1;i:0;}}', 'User Bugs', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 1, 1, 1, 3, 2, 'Image path Wrong', 1224498879, 'joeroberts', 'AA0000', 48, 1, 1, 1, 0, 0, 7, 7, 1),(11, 5, 14, 15, 'a:1:{i:5;a:2:{i:0;s:5:\"Mod\'s\";i:1;i:0;}}', 'Requests', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 3, 1, 1, 17, 101, 'Re: Peer Stats in forum', 1227460939, 'jonez', '', 48, 1, 1, 1, 0, 0, 7, 7, 1),(12, 5, 16, 19, 'a:1:{i:5;a:2:{i:0;s:5:\"Mod\'s\";i:1;i:0;}}', 'Offer a Mod', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 4, 1, 1, 13, 2, 'Re: [Help] AJAX Quick News Edit *uncomlete*', 1225544410, 'joeroberts', 'AA0000', 48, 1, 1, 1, 0, 0, 7, 7, 1),(13, 5, 20, 21, 'a:1:{i:5;a:2:{i:0;s:5:\"Mod\'s\";i:1;i:0;}}', 'Mod Help', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 48, 1, 1, 1, 0, 0, 7, 7, 1),(14, 6, 24, 25, 'a:1:{i:6;a:2:{i:0;s:9:\"Off Topic\";i:1;i:0;}}', 'Any thing you wish', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 48, 1, 1, 1, 0, 0, 7, 7, 1),(15, 12, 17, 18, 'a:2:{i:5;a:2:{i:0;s:5:\"Mod\'s\";i:1;i:0;}i:12;a:2:{i:0;s:11:\"Offer a Mod\";i:1;i:1;}}', 'Styles', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 7, 2, 2, 14, 2, 'acidtech Theme pack', 1226206564, 'joeroberts', 'AA0000', 48, 1, 1, 1, 0, 0, 7, 7, 1);
INSERT INTO phpbb303_posts (post_id, topic_id, forum_id, poster_id, icon_id, poster_ip, post_time, post_approved, post_reported, enable_bbcode, enable_smilies, enable_magic_url, enable_sig, post_username, post_subject, post_text, post_checksum, post_attachment, bbcode_bitfield, bbcode_uid, post_postcount, post_edit_time, post_edit_reason, post_edit_user, post_edit_count, post_edit_locked) VALUES (2, 2, 7, 2, 0, '206.248.41.211', 1224476927, 1, 0, 1, 1, 1, 1, '', 'phpMyBitTorrent V2.0', '[b:2keuqns8]coming soon[/b:2keuqns8]\n[b:2keuqns8][i:2keuqns8][size=150:2keuqns8][color=#FF0000:2keuqns8]phpMyBitTorrentV2.0.0 rc1[/color:2keuqns8][/size:2keuqns8][/i:2keuqns8][/b:2keuqns8]\n\nyou may now down load for beta testing PMBT2.0 beta from sourceforge\nAt This link phpMyBitTorrent-V2.0 Please test and let me know of any error\'s only We well work on changes at a later time and New Themes well come shortly.\nWelcome to phpMyBitTorrent!\n\n\n\nphpMyBitTorrent is the brand new Open Source solution for BitTorrent communities! phpMyBitTorrent is not just a simple tracker like the ones you see around. It has so many amazing features that it cannot be called simply a &quot;Tracker&quot;. In fact, it is a BMS (Bittorrent Management System), something like a BitTorrent-oriented Content Management System.\n\n\nSome points to convince you of phpMyBitTorrent\'s supremacy:\n\n\n\nphpMyBitTorrent is Free Software!\nphpMyBitTorrent is Open Source Software, distributed under the GNU/GPL license. This means that the code is open for scrutiny by anyone, and anybody can join in the development effort.\n\nphpMyBitTorrent is easy!\n\nphpMyBitTorrent is provided with full documentation to help you install it step by step in no time, even if you\'ve never heard of PHP/MySQL.\n\nWhen you start phpMyBitTorrent, you\'ll discover help system based on OverLib and image-popups. Just point the mouse over the &quot;Info&quot; icon and read what the item in question is about, and how to use it.\n\n\n\nphpMyBitTorrent is up-to-date!\n\nphpMyBitTorrent supports all the latest BitTorrent Protocol Extensions, including Compact Announce, MultiScrape, DHT, Peer Count, Tracker ID, Unique Peer ID, Backup Tracker, etc.\n\n\n\nphpMyBitTorrent is not only BitTorrent!\n\nThere are many ways other than BitTorrent to share your files. GNutella, Direct Connect, eDonkey are some of them. ed2k and Magnet URIs are automatically generated for all files in a torrent, and are presented as alternate Links. You can also allow users to submit Magnet and ed2k links without a torrent.\n\n\n\nphpMyBitTorrent has low requirements!\n\nAll you need is some webspace with PHP and a MySQL database to start building your File-Sharing Community.\n\n\n\nphpMyBitTorrent is secure!\n\nStop leechers from downloading more than their share! Choose who can download your files and who can\'t. See who is downloading your Torrent and who is helping you share it. Define rules to avoid annoyance by Download Requests. Choose friends and foes. Keep your anonymity. And that\'s just the tip of the iceberg....\n\n\n\nphpMyBitTorrent is easy on the eye!\n\nYou can choose your personal theme that reflects your style, choose your avatar displayed next to comments you make ..\n\n\n\nphpMyBitTorrent is fast!\n\nphpMyBitTorrent uses the minimum number of code lines required to do all the amazing things it does. Memory usage is low because every single variable is deleted when not needed any more.\n\n\n\nphpMyBitTorrent is easy to m0d!\n\nIf you know some PHP, you will find incredibly easy to add new features to phpMyBitTorrent. Just include the header and footer pages at the beginning and end of your script, and you\'ll be able to access all phpMyBitTorrent incredible code layer with basic functions for theming, database access and Torrent encoding.', 'e2f5353686e8b732d1a8721d0b14e267', 0, 'Zg==', '2keuqns8', 1, 0, '', 0, 0, 0),(3, 3, 10, 2, 2, '206.248.41.211', 1224498879, 1, 0, 1, 1, 1, 1, '', 'Image path Wrong', 'I for got to set the proper forcing of image path in includes/functions_posting.php\nopen said folder and fined\n[code:16wws43i]$forumbase&#46;[/code:16wws43i]\nand replace it with\n[code:16wws43i]$config&#91;\'script_path\'&#93;&#46;[/code:16wws43i]\nand that well do the trick!', '46e3923abb51b0f6c95bb51fb313fc63', 0, 'AIA=', '16wws43i', 1, 0, '', 0, 0, 0),(4, 4, 15, 2, 0, '206.248.41.211', 1224567613, 1, 0, 1, 1, 1, 1, '', 'Theme\'s', 'Halloween theme\n[attachment=0:3peq9nrz]<!-- ia0 -->Halloween.rar<!-- ia0 -->[/attachment:3peq9nrz]', 'edb89bc5a40e449cd6ec9d9f30979e17', 1, 'AAg=', '3peq9nrz', 1, 0, '', 0, 0, 0),(5, 4, 15, 2, 0, '206.248.41.211', 1224568003, 1, 0, 1, 1, 1, 1, '', 'Gamer17', 'Gamer17\n[attachment=0:i8epbcwo]<!-- ia0 -->Gamer17.rar<!-- ia0 -->[/attachment:i8epbcwo]', '31e9c427edecd0f370ab0f07a7bb28e3', 1, 'AAg=', 'i8epbcwo', 1, 0, '', 0, 0, 0),(6, 4, 15, 2, 0, '206.248.41.211', 1224568868, 1, 0, 1, 1, 1, 1, '', 'EI', 'EI theme\n[attachment=0:1zwh9ht0]<!-- ia0 -->EI.rar<!-- ia0 -->[/attachment:1zwh9ht0]', '964a97d82eb256d0b7aaa732621c4913', 1, 'AAg=', '1zwh9ht0', 1, 0, '', 0, 0, 0),(7, 4, 15, 2, 0, '206.248.41.211', 1224569191, 1, 0, 1, 1, 1, 1, '', 'Quake4', 'Quake4 theme\n[attachment=0:1w4zsgh4]<!-- ia0 -->Quake4.rar<!-- ia0 -->[/attachment:1w4zsgh4]', 'b879497f5cd049db7376cc8e944640e1', 1, 'AAg=', '1w4zsgh4', 1, 0, '', 0, 0, 0),(8, 4, 15, 2, 0, '206.248.41.211', 1224569459, 1, 0, 1, 1, 1, 1, '', 'NB Teal', 'NB_Teal theme\n[attachment=0:1k994noe]<!-- ia0 -->NB-Teal.rar<!-- ia0 -->[/attachment:1k994noe]', '50b29e2fa43964c79b6ecf1ba485285e', 1, 'AAg=', '1k994noe', 1, 0, '', 0, 0, 0),(9, 4, 15, 2, 0, '206.248.41.211', 1224569584, 1, 0, 1, 1, 1, 1, '', 'Re: Theme\'s', 'in order to make the quick change work you need to open include/config.php\nfind\n[code:2xt244md]if (isset($btlanguage) AND is_readable(&quot;language/&quot;&#46;$btlanguage&#46;&quot;&#46;php&quot;)) $language = $btlanguage;\n[/code:2xt244md]\nand add be for \n[code:2xt244md]if (isset($theme_change)){\n$bttheme = $theme_change;\nif ($bttheme != &quot;&quot; AND is_dir(&quot;themes/&quot;&#46;$bttheme) AND $bttheme != &quot;CVS&quot;) setcookie(&quot;bttheme&quot;,$bttheme,$session_time,$cookiepath,$cookiedomain,0);\n}\n[/code:2xt244md]\nThis edit is not needed for GOLD release', 'd1e147794bdc90f944de37e9c567cddf', 0, 'AIA=', '2xt244md', 1, 0, '', 0, 0, 0),(10, 5, 12, 95, 0, '84.54.137.102', 1225539767, 1, 0, 1, 1, 1, 1, '', '[Help] AJAX Quick News Edit *uncomlete*', 'This mod has 2 major bugs.\n\nFirst:The only way i could make it work was if it sends the data through the query string(URL) but if it exceeds more than 255 chars it cannot work\nInstead must fix that but cant <!-- s:( --><img src=\"{SMILIES_PATH}/icon_e_sad.gif\" alt=\":(\" title=\"Sad\" /><!-- s:( -->\nSecond bug:If a Russian was using this mod when he presses the button the Ajax displays the edit box but with weird hieroglyphs otherwise i think it can save the data\n\nHere is the AJAX script \n\n[code:2zpkwsvq]function WBGetID(IDName) {\n\n   if(document&#46;getElementById) \n   {\n    return document&#46;getElementById(IDName);\n   }\n   \n   else if(document&#46;all) \n   {\n    return document&#46;all&#91;IDName&#93;;\n   }\n   \n   else if(document&#46;layers) \n   {\n    return document&#46;layers&#91;IDName&#93;;\n   }\n   \n   else \n   {\n   return null;\n   }\n};\n\nfunction ajaxFunction()\n{\n	http_request = false;\n	if (window&#46;XMLHttpRequest)\n	{\n		http_request = new XMLHttpRequest();\n		if (http_request&#46;overrideMimeType)\n		{	\n			http_request&#46;overrideMimeType(\'text/html\');\n		}\n	}\n	else if (window&#46;ActiveXObject)\n	{\n		try\n		{\n			http_request = new ActiveXObject(&quot;Msxml2&#46;XMLHTTP&quot;);\n		}\n		catch (e)\n		{\n			try\n			{\n				http_request = new ActiveXObject(&quot;Microsoft&#46;XMLHTTP&quot;);\n			}\n			catch (e) {}\n		}\n	}\n\n	if (!http_request)\n	{\n		alert(&quot;Your browser broke!&quot;);\n		return false;\n	}\n\n	return http_request;\n};\n\nfunction WBQuickEditPost(GetIDValue,GetRedirectURL) {\n  originalhtml=WBGetID(GetIDValue)&#46;innerHTML;\n  cID=GetIDValue&#46;replace(/post_message_/,&quot;&quot;);\n  originalID=GetIDValue;\n  WBGetID(originalID)&#46;innerHTML=\'&lt;img src=&quot;&#46;&#46;/pic/spinner-big&#46;gif&quot; border=&quot;0&quot; class=&quot;inlineimg&quot;&gt; &lt;strong&gt;Please wait &#46;&#46;&#46;&lt;/strong&gt;\';\n  GETRequest(\'action=edit_post&amp;newsid=\'+cID,\'xmlhttp&#46;php\');\n}\n\nfunction WBQuickEditPostCancel() {\n  WBGetID(originalID)&#46;innerHTML=originalhtml;\n}\n\nfunction createXMLHttpRequest() {\n  xmlHttp=false;\n  try {\n  xmlHttp=new XMLHttpRequest();\n}\n\ncatch(e) {\n  var _ieModelos=new Array(\'MSXML2&#46;XMLHTTP&#46;5&#46;0\',\'MSXML2&#46;XMLHTTP&#46;4&#46;0\',\'MSXML2&#46;XMLHTTP&#46;3&#46;0\',\'MSXML2&#46;XMLHTTP\',\'Microsoft&#46;XMLHTTP\');\n  for(var i=0;i&lt;_ieModelos&#46;length&amp;&amp;!success;i++) {\n  try {\n  xmlHttp=new ActiveXObject(_ieModelos&#91;i&#93;);\n }\ncatch(e) {\n  }\n }\n}\n \nif(!xmlHttp) {\n  alert(&quot;Cannot compute&quot;);\n  return false;\n }\n}\n\nfunction GETRequest(query,filename) {\n  createXMLHttpRequest();\n  var queryString=filename+&quot;?&quot;+query;\n  xmlHttp&#46;onreadystatechange=handleStateChange;\n  xmlHttp&#46;open(&quot;GET&quot;,queryString,true);\n  xmlHttp&#46;send(null);\n}\n\nfunction POSTRequest(query,url) {\n  createXMLHttpRequest();\n  var queryString=url+&quot;?&quot;+query;\n  xmlHttp&#46;open(&quot;POST&quot;,queryString,true);\n  xmlHttp&#46;onreadystatechange=handleStateChangeP;\n  xmlHttp&#46;send(query);\n}\n\nfunction parseResults2() {\n  result=xmlHttp&#46;responseText;\n  if(result&#46;match(/&lt;error&gt;(&#46;*)&lt;\\/error&gt;/)) {\n  message=result&#46;match(/&lt;error&gt;(&#46;*)&lt;\\/error&gt;/);\n  if(!message&#91;1&#93;) {\n  message&#91;1&#93;=&quot;There was a problem with the request&#46; Please report this to administrator&#46;&quot;;\n  }\n  alert(&quot;There was an error&#46;&lt;br&gt;&lt;br&gt;&quot;+message&#91;1&#93;);\n  document&#46;quick_edit_form&#46;submit&#46;value=&quot;Save&quot;;\n  document&#46;quick_edit_form&#46;submit&#46;disabled=false;\n  }\n  else {\n  WBGetID(originalID)&#46;innerHTML=result;\n }\n}\n\nfunction parseResults()\n{\nresult=xmlHttp&#46;responseText;\nif(result&#46;match(/&lt;error&gt;(&#46;*)&lt;\\/error&gt;/))\n{\nmessage=result&#46;match(/&lt;error&gt;(&#46;*)&lt;\\/error&gt;/);\nif(!message&#91;1&#93;)\n{\nmessage&#91;1&#93;=&quot;There was a problem with the request&#46; Please report this to administrator&#46;&quot;;\n}\nalert(&quot;There was an error performing the update&#46;&lt;br&gt;&lt;br&gt;&quot;+message&#91;1&#93;);\nWBQuickEditPostCancel();\n}\nelse\n{\nWBQuickForm=\'&lt;form name=&quot;quick_edit_form&quot; onsubmit=&quot;return false;&quot;&gt;&lt;textarea style=&quot;width&#58; 100%; height&#58; 150px;&quot; name=&quot;newContent&quot;&gt;\'+result+\'&lt;/textarea&gt;&lt;br&gt;&lt;input type=&quot;submit&quot; class=&quot;btn2&quot; name=&quot;submit&quot; value=&quot;Save&quot; onclick=&quot;WBQuickSavePost()&quot;&gt; &lt;input type=&quot;button&quot; class=&quot;btn2&quot; value=&quot;Cancel&quot; onclick=&quot;WBQuickEditPostCancel()&quot;&gt;&lt;/form&gt;\';\noldDiv=WBGetID(originalID);\nnewDiv=document&#46;createElement(oldDiv&#46;tagName);\nnewDiv&#46;id=oldDiv&#46;id;\nnewDiv&#46;className=oldDiv&#46;className;\nnewDiv&#46;innerHTML=WBQuickForm;\noldDiv&#46;parentNode&#46;replaceChild(newDiv,oldDiv);\n}\n}\n\nfunction handleStateChange() {\n  if(xmlHttp&#46;readyState==4) {\n  if(xmlHttp&#46;status==200) {\n  parseResults();\n  }\n }\n}\n\nfunction handleStateChangeP() {\n  if(xmlHttp&#46;readyState==4) {\n  if(xmlHttp&#46;status==200) {\n  parseResults2();\n }\n }\n}\n\nfunction WBQuickSavePost() {\n  var cbobject=document&#46;quick_edit_form&#46;newContent&#46;value;\n	if(cbobject == &quot;&quot; || cbobject == &quot;NULL&quot;)\n	{\n		alert(\'You need to fill in message!\');\n		return;\n	}\n  document&#46;quick_edit_form&#46;submit&#46;value=&quot;Please wait &#46;&#46;&#46;&quot;;\n  document&#46;quick_edit_form&#46;submit&#46;disabled=true;\n  POSTRequest(\'action=edit_post_save&amp;text=\'+encodeURIComponent(cbobject)&#46;replace(/\\+/g, &quot;%2B&quot;)+\'&amp;newsid=\'+cID,\'xmlhttp&#46;php\');\n}[/code:2zpkwsvq]\n\nHere is the news code in index.php  [code:2zpkwsvq]print(&quot;&lt;br&gt;&lt;br&gt;&lt;table border=\\&quot;0\\&quot; cellpadding=\\&quot;5\\&quot; cellspacing=\\&quot;0\\&quot; width=\\&quot;80%\\&quot;&gt;&lt;tr&gt;\n&lt;td class=\\&quot;thead\\&quot; align=\\&quot;center\\&quot;&gt;\n&quot;);\nprint(&quot;&lt;strong&gt;» Recent news&lt;/strong&gt;&quot;);\nif (get_user_class() &gt;= UC_ADMINISTRATOR)\nprint(&quot; - &lt;font class=small&gt;&#91;&lt;a class=altlink href=news&#46;php&gt;&lt;b&gt;News page&lt;/b&gt;&lt;/a&gt;&#93;&lt;/font&gt;&quot;);\nprint(&quot;&lt;/td&gt;&lt;/tr&gt;\n\\n&quot;);\n$res = mysql_query(&quot;SELECT * FROM news WHERE ADDDATE(added, INTERVAL 45 DAY) &gt; NOW() ORDER BY added DESC LIMIT 10&quot;) or sqlerr(__FILE__, __LINE__);\nif (mysql_num_rows($res) &gt; 0)\n{\nprint(&quot;&lt;table width=80% border=1 cellspacing=0 cellpadding=10&gt;\n&lt;tr&gt;&lt;td class=text&gt;\\n&lt;ul&gt;&quot;);\nwhile($array = mysql_fetch_array($res))\n{\n$user = mysql_fetch_assoc(mysql_query(&quot;SELECT username FROM users WHERE id = $array&#91;userid&#93;&quot;)) or sqlerr();\nif ($news_flag == 0) {\n\nprint(&quot;&lt;a href=\\&quot;javascript&#058; klappe_news(\'a&quot;&#46;$array&#91;\'id\'&#93;&#46;&quot;\')\\&quot;&gt;&lt;img border=\\&quot;0\\&quot; src=\\&quot;pic/minus&#46;gif\\&quot; id=\\&quot;pica&quot;&#46;$array&#91;\'id\'&#93;&#46;&quot;\\&quot; alt=\\&quot;Show/Hide\\&quot;&gt; ;;&quot; &#46; gmdate(&quot;d&#46;m&#46;Y&quot;,strtotime($array&#91;\'added\'&#93;)) &#46; &quot; - &quot; &#46;&quot;&lt;b&gt;&quot;&#46; $array&#91;\'title\'&#93; &#46; &quot;&lt;/b&gt;&lt;/a&gt;&quot;);\nprint(&quot;&lt;div id=\\&quot;ka&quot;&#46;$array&#91;\'id\'&#93;&#46;&quot;\\&quot; style=\\&quot;display&#58; block;\\&quot;&gt;&lt;div id=\\&quot;post_message_&quot;&#46;$array&#91;\'id\'&#93;&#46;&quot;\\&quot; style=\\&quot;display&#58; inline;\\&quot;&gt; &quot;&#46;format_comment($array&#91;&quot;body&quot;&#93;,0)&#46;&quot; &lt;/div&gt;&lt;/div&gt;&lt;br&gt; &quot;);\n\n$news_flag = 1;\n}\nelse {\n\nprint(&quot;&lt;a href=\\&quot;javascript&#058; klappe_news(\'a&quot;&#46;$array&#91;\'id\'&#93;&#46;&quot;\')\\&quot;&gt;&lt;br&gt;&lt;img border=\\&quot;0\\&quot; src=\\&quot;pic/plus&#46;gif\\&quot; id=\\&quot;pica&quot;&#46;$array&#91;\'id\'&#93;&#46;&quot;\\&quot; alt=\\&quot;Show/Hide\\&quot;&gt; ;;&quot; &#46; gmdate(&quot;d&#46;m&#46;Y&quot;,strtotime($array&#91;\'added\'&#93;)) &#46; &quot; - &quot; &#46;&quot;&lt;b&gt;&quot;&#46; $array&#91;\'title\'&#93; &#46; &quot;&lt;/b&gt;&lt;/a&gt;&quot;);\nprint(&quot;&lt;div id=\\&quot;ka&quot;&#46;$array&#91;\'id\'&#93;&#46;&quot;\\&quot; style=\\&quot;display&#58; none;\\&quot;&gt;&lt;div id=\\&quot;post_message_&quot;&#46;$array&#91;\'id\'&#93;&#46;&quot;\\&quot; style=\\&quot;display&#58; inline;\\&quot;&gt; &quot;&#46;format_comment($array&#91;&quot;body&quot;&#93;,0)&#46;&quot; &lt;/div&gt;&lt;/div&gt;&lt;br&gt;&lt;br&gt; &quot;);\n}\nif (get_user_class() &gt;= UC_ADMINISTRATOR)\n{\nprint(&quot;&lt;input value=\\&quot;Quick Edit\\&quot; onclick=\\&quot;WBQuickEditPost(\'post_message_&quot;&#46;$array&#91;\'id\'&#93;&#46;&quot;\',\'&quot;&#46;$CURUSER&#91;\'id\'&#93;&#46;&quot;\',\'\');\\&quot; type=\\&quot;button\\&quot; class=\\&quot;btn2\\&quot;&gt; ;;&quot;);\nprint(&quot;&lt;input value=\\&quot;Full Edit\\&quot; onclick=\\&quot;javascript&#058;WinBits&#46;RedirectFullEdit(\'news&#46;php?action=edit&amp;newsid=&quot; &#46; $array&#91;\'id\'&#93; &#46; &quot;&amp;returnto=&quot; &#46; urlencode($_SERVER&#91;\'PHP_SELF\'&#93;) &#46; &quot;\');\\&quot; type=\\&quot;button\\&quot; class=\\&quot;btn2\\&quot;&gt; ;;&quot;);\nprint(&quot;&lt;input value=\\&quot;Delete\\&quot; onclick=\\&quot;javascript&#058;WinBits&#46;deleteNewsItem(&quot; &#46; $array&#91;\'id\'&#93; &#46; &quot;);\\&quot; type=\\&quot;button\\&quot; class=\\&quot;btn2\\&quot;&gt;&quot;);\n}\nprint(&quot;&lt;div id=\\&quot;ka&quot;&#46;$array&#91;\'id\'&#93;&#46;&quot;\\&quot; style=\\&quot;display&#58; none;\\&quot;&gt;&lt;div id=\\&quot;post_message_&quot;&#46;$array&#91;\'id\'&#93;&#46;&quot;\\&quot; style=\\&quot;display&#58; inline;\\&quot;&gt; &quot;&#46;format_comment($array&#91;&quot;body&quot;&#93;,0)&#46;&quot;&lt;/div&gt;&lt;/div&gt;&quot;);\n}\nprint(&quot;&lt;/ul&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;\\n&quot;);\n}[/code:2zpkwsvq]\n\nAnd the file wich processes the data [code:2zpkwsvq]&lt;?\n\ninclude &quot;include/bittorrent&#46;php&quot;;\n\ndbconn();\n\n  function xmlhttp_error($message)\n  {\n\n	// Send our headers&#46;\n	//header(&quot;Content-type&#58; text/xml; charset=WINDOWS-1251&quot;);\n	\n	// Send the error message&#46;\n	echo &quot;&lt;error&gt;&quot;&#46;$message&#46;&quot;&lt;/error&gt;&quot;;\n	\n	// Exit\n	exit;\n  }\n  \n$charset = \'WINDOWS-1251\';\n$action = htmlentities($_GET&#91;&quot;action&quot;&#93;);\n\n\nif ($action == \'edit_post\')\n{\n	\n    if (get_user_class() &lt; UC_MODERATOR)\n	xmlhttp_error(&quot;Permission denied&#46;&quot;);\n	\n	$newsid = (int)$_GET&#91;&quot;newsid&quot;&#93;;\n\n  if (!is_valid_id($newsid))\n  	die(&quot;Invalid news item ID&quot;);\n\n$res = mysql_query(&quot;SELECT * FROM news WHERE id=$newsid&quot;) or sqlerr(__FILE__, __LINE__);\n\n  if (mysql_num_rows($res) != 1)\n    xmlhttp_error(&quot;No news item with that ID&#46;&quot;);\n\n  $arr = mysql_fetch_array($res);\n   print(&quot;&quot;&#46;htmlspecialchars($arr&#91;\'body\'&#93;)&#46;&quot;&quot;);\n}\n\nelseif ($action == \'edit_post_save\')\n{\n	\n    if (get_user_class() &lt; UC_MODERATOR)\n	{\n	  xmlhttp_error(&quot;Permission denied&#46;&quot;);\n	}\n	\n    $text = $_GET&#91;&quot;text&quot;&#93;;\n	$newsid = (int) $_GET&#91;&quot;newsid&quot;&#93;;\n\n     if (!is_valid_id($newsid))\n    {\n   	 xmlhttp_error(&quot;Invalid news item&quot;);\n    }	\n	\n    if (empty($text))\n    {\n      xmlhttp_error(&quot;You must enter some text&quot;);\n    }\n  \n	\n   $res = mysql_query(&quot;SELECT * FROM news WHERE id=$newsid&quot;) or sqlerr(__FILE__, __LINE__);\n\n  if (mysql_num_rows($res) != 1)\n    xmlhttp_error(&quot;No news item with that ID&#46;&quot;);\n\n		\n    if (strtolower (\'WINDOWS-1251\') != \'utf-8\')\n    {\n      if (function_exists (\'iconv\'))\n      {\n        $text = iconv (\'UTF-8\', \'WINDOWS-1251\', $text);\n      }\n      else\n      {\n        if (function_exists (\'mb_convert_encoding\'))\n        {\n          $text = mb_convert_encoding ($text, \'WINDOWS-1251\', \'UTF-8\');\n        }\n        else\n        {\n          if (strtolower (\'WINDOWS-1251\') == \'iso-8859-1\')\n          {\n            $text = utf8_decode ($text);\n          }\n        }\n      }\n    }\n\n   mysql_query(&quot;UPDATE news SET body=&quot;&#46;sqlesc($text)&#46;&quot; WHERE id=&quot;&#46;$newsid&#46;&quot;&quot;);\n   \n   $new = mysql_query(&quot;SELECT body FROM news WHERE id=&quot;&#46;$newsid&#46;&quot;&quot;);\n   while ($newtext = mysql_fetch_array($new)) {\n   echo(&quot;&quot;&#46;format_comment($newtext&#91;\'body\'&#93;)&#46;&quot;&quot;);\n  \n  }\n}\n\n \n\n\n?&gt;[/code:2zpkwsvq]', 'a27baf41e7e97d60d4f2df2b253160e4', 0, 'AIA=', '2zpkwsvq', 1, 0, '', 0, 0, 0),(11, 5, 12, 2, 0, '206.248.41.211', 1225541135, 1, 0, 1, 1, 1, 1, '', 'Re: [Help] AJAX Quick News Edit *uncomlete*', 'ok I well take a look at this', 'c84b9d05624f244971c31c4613bca3dc', 0, '', 's5oe38ts', 1, 0, '', 0, 0, 0),(12, 5, 12, 95, 0, '84.54.137.102', 1225541297, 1, 0, 1, 1, 1, 1, '', 'Re: [Help] AJAX Quick News Edit *uncomlete*', 'I have tryed everything i can even when directly ripped from xam but the only way to work is as it is now but its not good for me or any other', '0b406d1f08285f4860015e43e163bdcc', 0, '', '3tpoyhy8', 1, 0, '', 0, 0, 0),(13, 5, 12, 2, 0, '206.248.41.211', 1225544410, 1, 0, 1, 1, 1, 1, '', 'Re: [Help] AJAX Quick News Edit *uncomlete*', 'My first quistion do you know where the error starts ?\nin ajax or in the php file.', '44ebeb0436b409de8f4e34a134b00dd8', 0, '', '100187bm', 1, 0, '', 0, 0, 0),(14, 6, 15, 2, 0, '206.248.41.211', 1226206564, 1, 0, 1, 1, 1, 1, '', 'acidtech Theme pack', 'this is for both forum and tacker', '7bf2d2009fa82d470798d6c38d1edda0', 1, '', '2sxnvlxa', 1, 0, '', 0, 0, 0),(15, 7, 11, 101, 0, '96.252.83.187', 1227236252, 1, 0, 1, 1, 1, 1, '', 'Peer Stats in forum', 'Hi,\n\nGreat software, i\'m about to open my site with this!\n\nI would like to add user upload/download ratio stats into the user\'s profile in the forum, so that when you post in the forum, under your username is your stats for the tracker.  I see that the stats on the member page is from /blocks/usercp.php, what code should I copy from there?\n\nThanks!', '19c92b178c567b007d2f9c2d47be768c', 0, '', '35of1be5', 1, 0, '', 0, 0, 0),(16, 7, 11, 2, 0, '206.248.41.211', 1227319960, 1, 0, 1, 1, 1, 1, '', 'Re: Peer Stats in forum', 'you well need to create this code I well take a look and see what I can do.', '829a5cc0d6ea8f283113cdc190664833', 0, '', 'd4y7g3i0', 1, 0, '', 0, 0, 0),(17, 7, 11, 101, 0, '96.252.83.187', 1227460939, 1, 0, 1, 1, 1, 1, '', 'Re: Peer Stats in forum', 'Hi, great job, it looks nice!\n\nCan you share the code for this?\n\nThanks!', '4b5bfe3f106a6921d7c9980f30457e6f', 0, '', '2guvbnmh', 1, 0, '', 0, 0, 0);
INSERT INTO phpbb303_topics (topic_id, forum_id, icon_id, topic_attachment, topic_approved, topic_reported, topic_title, topic_poster, topic_time, topic_time_limit, topic_views, topic_replies, topic_replies_real, topic_status, topic_type, topic_first_post_id, topic_first_poster_name, topic_first_poster_colour, topic_last_post_id, topic_last_poster_id, topic_last_poster_name, topic_last_poster_colour, topic_last_post_subject, topic_last_post_time, topic_last_view_time, topic_moved_id, topic_bumped, topic_bumper, poll_title, poll_start, poll_length, poll_max_options, poll_last_vote, poll_vote_change) VALUES (3, 10, 2, 0, 1, 0, 'Image path Wrong', 2, 1224498879, 0, 32, 0, 0, 0, 0, 3, 'joeroberts', 'AA0000', 3, 2, 'joeroberts', 'AA0000', 'Image path Wrong', 1224498879, 1227417509, 0, 0, 0, '', 0, 0, 1, 0, 0),(2, 7, 0, 0, 1, 0, 'phpMyBitTorrent V2.0', 2, 1224476927, 0, 18, 0, 0, 0, 2, 2, 'joeroberts', 'AA0000', 2, 2, 'joeroberts', 'AA0000', 'phpMyBitTorrent V2.0', 1224476927, 1227787659, 0, 0, 0, '', 0, 0, 1, 0, 0),(4, 15, 0, 1, 1, 0, 'Theme\'s', 2, 1224567613, 0, 59, 5, 5, 0, 0, 4, 'joeroberts', 'AA0000', 9, 2, 'joeroberts', 'AA0000', 'Re: Theme\'s', 1224569584, 1227630906, 0, 0, 0, '', 0, 0, 1, 0, 0),(5, 12, 0, 0, 1, 0, '[Help] AJAX Quick News Edit *uncomlete*', 95, 1225539767, 0, 22, 3, 3, 0, 0, 10, 'mcfe', '', 13, 2, 'joeroberts', 'AA0000', 'Re: [Help] AJAX Quick News Edit *uncomlete*', 1225544410, 1227408304, 0, 0, 0, '', 0, 0, 1, 0, 0),(6, 15, 0, 1, 1, 0, 'acidtech Theme pack', 2, 1226206564, 0, 14, 0, 0, 0, 0, 14, 'joeroberts', 'AA0000', 14, 2, 'joeroberts', 'AA0000', 'acidtech Theme pack', 1226206564, 1227408471, 0, 0, 0, '', 0, 0, 1, 0, 0),(7, 11, 0, 0, 1, 0, 'Peer Stats in forum', 101, 1227236252, 0, 20, 2, 2, 0, 0, 15, 'jonez', '', 17, 101, 'jonez', '', 'Re: Peer Stats in forum', 1227460939, 1227689101, 0, 0, 0, '', 0, 0, 1, 0, 0);
INSERT INTO phpbb303_topics_posted (user_id, topic_id, topic_posted) VALUES (2, 1, 1),(2, 2, 1),(2, 3, 1),(2, 4, 1),(95, 5, 1),(2, 5, 1),(2, 6, 1),(101, 7, 1),(2, 7, 1);
