G2A Many GEOs
SHARE
TWEET

Untitled

a guest Feb 2nd, 2013 70 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # Fri Feb  1 22:08:21 2013
  2. # Query_time: 1.325976  Lock_time: 0.201210 Rows_sent: 1  Rows_examined: 1
  3. use fromthe4_vbulletin;
  4. SET timestamp=1359781701;
  5. SELECT *
  6.   FROM session
  7.   WHERE sessionhash = '1e7378bb44a77a95c45ca112dd934bdd'
  8.   AND lastactivity > 1359780800
  9.   AND idhash = '2ab243aed1a4b003c89d76d0779fa53d'
  10.  
  11. # Fri Feb  1 22:09:43 2013
  12. # Query_time: 1.322730  Lock_time: 0.001621 Rows_sent: 1  Rows_examined: 1
  13. use fromthe4_vbulletin;
  14. SET timestamp=1359781783;
  15. SELECT styleid, dateline, title
  16.         FROM style
  17.         WHERE styleid = 3
  18.         ORDER BY styleid ASC
  19.         LIMIT 1
  20.  
  21. # Fri Feb  1 22:09:43 2013
  22. # Query_time: 1.371226  Lock_time: 0.000159 Rows_sent: 20  Rows_examined: 20
  23. use fromthe4_vbulletin;
  24. SET timestamp=1359781783;
  25. SELECT title, template
  26.   FROM template
  27.   WHERE templateid IN (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1076,1078,0,1077,1079,0,0,0,0,0,1278,1275,1279,1280,0,0,0,0,0,0,0,0,0,0,0,0,0,1283,1149,0,1150,1151,1152,0,0,0,0,1288,1163,0,0,0,0,0,0,1299,1302,0,1090,1092,0,0,137,0,0,0,0,0,0,0,0)
  28.  
  29. # Fri Feb  1 22:11:10 2013
  30. # Query_time: 9.258520  Lock_time: 0.848776 Rows_sent: 20  Rows_examined: 20
  31. use fromthe4_vbulletin;
  32. SET timestamp=1359781870;
  33. SELECT *
  34.   FROM datastore
  35.   WHERE title IN ('userstats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue','activeblocks','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream')
  36.  
  37. # Fri Feb  1 22:11:10 2013
  38. # Query_time: 8.976917  Lock_time: 0.565765 Rows_sent: 30  Rows_examined: 30
  39. use fromthe4_vbulletin;
  40. SET timestamp=1359781870;
  41. SELECT *
  42.   FROM datastore
  43.   WHERE title IN ('adv_modules','adv_portal_cale','adv_portal_home','adv_portal_opts','adv_portal_page','adv_portal_pars','adv_portal_stat','attachmentcache','bbcodecache','birthdaycache','eventcache','iconcache','maxloggedin','prefixcache','ranks','tagcloud','smiliecache','userstats','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream')
  44.  
  45. # Fri Feb  1 22:11:10 2013
  46. # Query_time: 8.748777  Lock_time: 6.233629 Rows_sent: 0  Rows_examined: 1
  47. use fromthe4_vbulletin;
  48. SET timestamp=1359781870;
  49. UPDATE user SET
  50.   profilevisits = profilevisits + 1
  51.   WHERE userid = 85
  52.  
  53. # Fri Feb  1 22:11:15 2013
  54. # Query_time: 4.634023  Lock_time: 0.000190 Rows_sent: 0  Rows_examined: 0
  55. use fromthe4_vbulletin;
  56. SET timestamp=1359781875;
  57. SELECT user.userid, user.username, user.usergroupid, user.displaygroupid, profilevisitor.visible, user.infractiongroupid
  58.   FROM profilevisitor AS profilevisitor
  59.   INNER JOIN user AS user ON (user.userid = profilevisitor.visitorid)
  60.   WHERE profilevisitor.userid = 85
  61.   AND (visible = 1 OR profilevisitor.visitorid = 0)
  62.   ORDER BY profilevisitor.dateline DESC
  63.   LIMIT 10
  64.  
  65. # Fri Feb  1 22:11:22 2013
  66. # Query_time: 6.809637  Lock_time: 4.571400 Rows_sent: 0  Rows_examined: 0
  67. use fromthe4_vbulletin;
  68. SET timestamp=1359781882;
  69. SELECT SQL_CALC_FOUND_ROWS
  70.   visitormessage.*, user.*, visitormessage.ipaddress AS messageipaddress
  71.   ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom
  72.   FROM visitormessage AS visitormessage
  73.   LEFT JOIN user AS user ON (visitormessage.postuserid = user.userid)
  74.   LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
  75.   WHERE visitormessage.userid = 85
  76.   AND (visitormessage.state IN ('visible'))
  77.   ORDER BY visitormessage.dateline DESC
  78.   LIMIT 0, 10
  79.  
  80. # Fri Feb  1 22:11:22 2013
  81. # Query_time: 7.003034  Lock_time: 4.764543 Rows_sent: 1  Rows_examined: 1
  82. use fromthe4_vbulletin;
  83. SET timestamp=1359781882;
  84. SELECT *
  85.   FROM session
  86.   WHERE sessionhash = 'bb24d78895251695610637e02933ed74'
  87.   AND lastactivity > 1359780961
  88.   AND idhash = 'd0ec91f347e0227c7f1602f1df2e987e'
  89.  
  90. # Fri Feb  1 22:16:50 2013
  91. # Query_time: 5.855891  Lock_time: 0.000090 Rows_sent: 0  Rows_examined: 0
  92. use fromthe4_vbulletin;
  93. SET timestamp=1359782210;
  94. INSERT INTO threadviews (threadid)
  95.                 VALUES (112)
  96.  
  97. # Fri Feb  1 22:17:07 2013
  98. # Query_time: 6.748324  Lock_time: 0.000133 Rows_sent: 0  Rows_examined: 1
  99. use fromthe4_vbulletin;
  100. SET timestamp=1359782227;
  101. UPDATE user SET
  102.   profilevisits = profilevisits + 1
  103.   WHERE userid = 36
  104.  
  105. # Fri Feb  1 22:17:07 2013
  106. # Query_time: 19.293604  Lock_time: 0.000180 Rows_sent: 0  Rows_examined: 0
  107. SET timestamp=1359782227;
  108. REPLACE INTO searchlog
  109.   (userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,completed,criteria,results)
  110.   VALUES
  111.   (0,'173.199.119.59','384a06dcfef763177b2ae800669101c4','','asc',0,1359782206,0,'O:18:\"vB_Search_Criteria\":15:{s:28:\"\0vB_Search_Criteria\0keywords\";a:0:{}s:32:\"\0vB_Search_Criteria\0raw_keywords\";s:0:\"\";s:29:\"\0vB_Search_Criteria\0titleonly\";b:0;s:27:\"\0vB_Search_Criteria\0filters\";a:1:{s:3:\"tag\";a:1:{s:2:\"eq\";s:3:\"118\";}}s:24:\"\0vB_Search_Criteria\0sort\";a:2:{i:0;s:0:\"\";i:1;s:3:\"asc\";}s:27:\"\0vB_Search_Criteria\0grouped\";i:3;s:31:\"\0vB_Search_Criteria\0searchterms\";N;s:32:\"\0vB_Search_Criteria\0criteria_set\";b:1;s:35:\"\0vB_Search_Criteria\0advanced_typeid\";b:0;s:35:\"\0vB_Search_Criteria\0display_strings\";a:1:{s:3:\"tag\";s:24:\"Tag: <b><u>daily</u></b>\";}s:32:\"\0vB_Search_Criteria\0common_words\";a:0:{}s:30:\"\0vB_Search_Criteria\0highlights\";a:0:{}s:33:\"\0vB_Search_Criteria\0search_string\";N;s:26:\"\0vB_Search_Criteria\0errors\";a:0:{}s:11:\"search_type\";s:3:\"tag\";}','')
  112.  
  113. # Fri Feb  1 22:17:07 2013
  114. # Query_time: 6.872487  Lock_time: 4.452621 Rows_sent: 1  Rows_examined: 1
  115. use fromthe4_vbulletin;
  116. SET timestamp=1359782227;
  117. SELECT
  118.   userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
  119.   IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight, usercsscache.cachedcss, IF(usercsscache.cachedcss IS NULL, 0, 1) AS hascachedcss, usercsscache.buildpermissions AS cssbuildpermissions
  120.   , bu.bloguserid, bu.entries, bu.options AS blog_options, bu.subscribeown AS blog_subscribeown, bu.memberids, bu.memberblogids,
  121.                 bu.subscribeothers AS blog_subscribeothers, bu.title AS blog_title, bu.description AS blog_description, bu.allowsmilie AS blog_allowsmilie, bu.draft AS blog_draft, bu.pending AS blog_pending, bu.options_member, bu.options_guest, bu.options_buddy, bu.options_ignore, bu.uncatentries, bu.moderation AS blog_moderation, bu.deleted AS blog_deleted, bu.akismet_key AS blog_akismet_key, isblogmoderator, bu.comments_moderation AS blog_comments_moderation, bu.lastblog, bu.lastblogid, bu.lastblogtitle, bu.categorycache, bu.tagcloud, bu.sidebar, bu.custompages, bu.customblocks, blockparsed.blocktext, 3 AS blogstyleid, blog_usercsscache.csscolors AS blog_csscolors, blog_usercsscache.cachedcss AS blog_cachedcss, IF(blog_usercsscache.cachedcss IS NULL, 0, 1) AS blog_hascachedcss, blog_usercsscache.buildpermissions AS blog_cssbuildpermissions, IF(blog_subscribeuser.blogsubscribeuserid, 1, 0) AS blogsubscribed
  122.                 FROM user AS user
  123.                 LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
  124.                 LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) LEFT JOIN sigpic AS sigpic ON (user.userid = sigpic.userid) LEFT JOIN usercsscache AS usercsscache ON (user.userid = usercsscache.userid)
  125.   LEFT JOIN blog_user AS bu ON (bu.bloguserid = user.userid)
  126. LEFT JOIN blog_custom_block_parsed AS blockparsed ON (blockparsed.userid = user.userid AND blockparsed.styleid = 3 AND blockparsed.languageid = 1)
  127. LEFT JOIN blog_subscribeuser AS blog_subscribeuser ON (user.userid = blog_subscribeuser.bloguserid AND blog_subscribeuser.userid = 576)
  128. LEFT JOIN blog_usercsscache AS blog_usercsscache ON (user.userid = blog_usercsscache.userid)
  129.                 WHERE user.userid = 576
  130.  
  131. # Fri Feb  1 22:17:12 2013
  132. # Query_time: 4.247638  Lock_time: 0.000085 Rows_sent: 0  Rows_examined: 1
  133. use fromthe4_vbulletin;
  134. SET timestamp=1359782232;
  135. UPDATE user SET
  136.   profilevisits = profilevisits + 1
  137.   WHERE userid = 576
  138.  
  139. # Fri Feb  1 22:17:17 2013
  140. # Query_time: 6.722248  Lock_time: 0.000044 Rows_sent: 0  Rows_examined: 1
  141. use fromthe4_vbulletin;
  142. SET timestamp=1359782237;
  143. UPDATE cron
  144.                 SET nextrun = 1359782280
  145.                 WHERE cronid = 32 AND nextrun = 1359782220
  146.  
  147. # Fri Feb  1 22:17:17 2013
  148. # Query_time: 9.453801  Lock_time: 0.000067 Rows_sent: 0  Rows_examined: 0
  149. SET timestamp=1359782237;
  150. INSERT INTO tagsearch (tagid, dateline)
  151.   VALUES (118, 1359782206)
  152.  
  153. # Fri Feb  1 22:17:19 2013
  154. # Query_time: 2.232975  Lock_time: 0.000233 Rows_sent: 1  Rows_examined: 1
  155. use fromthe4_vbulletin;
  156. SET timestamp=1359782239;
  157. SELECT thread.*,post.pagetext AS preview,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, user.avatarrevision,
  158.   customavatar.dateline AS avatardateline, customavatar.width AS width, customavatar.height AS height,
  159.   customavatar.height_thumb AS height_thumb, customavatar.width_thumb AS width_thumb, customavatar.filedata_thumb,
  160.   first_user.avatarrevision AS first_avatarrevision, first_avatar.avatarpath AS first_avatarpath,
  161.   NOT ISNULL(first_customavatar.userid) AS first_hascustomavatar, first_customavatar.dateline AS first_avatardateline,
  162.   first_customavatar.width AS first_width, first_customavatar.height AS first_height, first_customavatar.height_thumb
  163.   AS first_height_thumb, first_customavatar.width_thumb AS first_width_thumb, first_customavatar.filedata_thumb AS
  164.   first_filedata_thumb,lastpost.lastposttime
  165.   FROM thread AS thread
  166.   LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
  167. LEFT JOIN user AS user ON (user.userid = thread.lastposterid)
  168. LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
  169. LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)
  170. LEFT JOIN user AS first_user ON (first_user.userid = thread.postuserid)
  171. LEFT JOIN avatar AS first_avatar ON (first_avatar.avatarid = first_user.avatarid)
  172. LEFT JOIN customavatar AS first_customavatar ON (first_customavatar.userid = first_user.userid)
  173. LEFT JOIN (
  174.   SELECT threadid, MAX(dateline) AS lastposttime
  175.   FROM post
  176.   WHERE threadid IN (58)
  177.   AND userid = 0
  178.   GROUP BY threadid
  179.   ) AS lastpost ON (lastpost.threadid = thread.threadid)
  180.   WHERE thread.threadid IN (58)
  181.  
  182. # Fri Feb  1 22:17:21 2013
  183. # Query_time: 4.501765  Lock_time: 0.000056 Rows_sent: 0  Rows_examined: 0
  184. use fromthe4_vbulletin;
  185. SET timestamp=1359782241;
  186. REPLACE INTO datastore
  187.   (title, data, unserialize)
  188.   VALUES
  189.   ('cron', '1359782280', 0)
  190.  
  191. # Fri Feb  1 22:17:23 2013
  192. # Query_time: 4.494606  Lock_time: 0.000167 Rows_sent: 0  Rows_examined: 1
  193. use fromthe4_vbulletin;
  194. SET timestamp=1359782243;
  195. UPDATE searchlog
  196.   SET results = 'a:4:{i:0;a:1:{i:0;a:3:{i:0;s:1:\"2\";i:1;s:2:\"58\";i:2;s:2:\"58\";}}i:1;i:0;i:2;a:1:{i:2;a:1:{i:0;s:2:\"58\";}}i:3;a:1:{i:2;a:0:{}}}'
  197.   WHERE searchlogid = 6809
  198.  
  199. # Fri Feb  1 22:17:26 2013
  200. # Query_time: 4.476793  Lock_time: 0.000411 Rows_sent: 0  Rows_examined: 0
  201. use fromthe4_vbulletin;
  202. SET timestamp=1359782246;
  203. REPLACE INTO datastore
  204.   (title, data, unserialize)
  205.   VALUES
  206.   ('options', 'a:831:{s:15:\"templateversion\";s:5:\"4.2.0\";s:21:\"default_route_segment\";s:7:\"content\";s:19:\"subscriptionmethods\";i:0;s:10:\"attachfile\";s:1:\"2\";s:7:\"hv_type\";s:1:\"0\";s:22:\"hv_recaptcha_publickey\";s:0:\"\";s:23:\"hv_recaptcha_privatekey\";s:0:\"\";s:18:\"hv_recaptcha_theme\";s:5:\"white\";s:12:\"regimagetype\";s:5:\"GDttf\";s:10:\"attachpath\";s:44:\"/home4/fromthe4/public_html/elvine/files/att\";s:14:\"regimageoption\";i:15;s:13:\"usefileavatar\";i:1;s:10:\"avatarpath\";s:44:\"/home4/fromthe4/public_html/elvine/files/ava\";s:9:\"avatarurl\";s:30:\"http://elvinelol.com/files/ava\";s:14:\"profilepicpath\";s:19:\"./customprofilepics\";s:13:\"profilepicurl\";s:17:\"customprofilepics\";s:10:\"sigpicpath\";s:15:\"./signaturepics\";s:9:\"sigpicurl\";s:13:\"signaturepics\";s:20:\"searchimplementation\";s:15:\"vBDBSearch_Core\";s:13:\"album_dataloc\";s:2:\"db\";s:13:\"album_picpath\";s:0:\"\";s:15:\"album_thumbpath\";s:0:\"\";s:14:\"album_thumburl\";s:0:\"\";s:16:\"usefilegroupicon\";i:0;s:13:\"groupiconpath\";s:18:\"./customgroupicons\";s:12:\"groupiconurl\";s:16:\"customgroupicons\";s:6:\"apikey\";s:0:\"\";s:8:\"bbactive\";i:1;s:14:\"bbclosedreason\";s:125:\"<p>Sorry, the board is unavailable at the moment while we are testing some functionality.</p>\r\n<p>We will be back soon...</p>\";s:7:\"bbtitle\";s:38:\"Elvine - World of Warcraft Gold Making\";s:5:\"bburl\";s:31:\"http://www.elvinelol.com/forums\";s:14:\"bburl_basepath\";i:1;s:11:\"vbforum_url\";s:0:\"\";s:18:\"redirect_whitelist\";s:74:\"http://www.elvinelol.com\r\nhttp://elvinelol.com\r\nhttp://elvinelol.com/forum\";s:26:\"redirect_whitelist_disable\";i:0;s:6:\"bbmenu\";i:0;s:9:\"hometitle\";s:0:\"\";s:7:\"homeurl\";s:20:\"http://elvinelol.com\";s:13:\"contactuslink\";s:15:\"sendmessage.php\";s:13:\"contactustype\";i:1;s:16:\"contactusoptions\";s:35:\"Site Feedback\r\nRegistration Problem\";s:14:\"contactusother\";i:1;s:14:\"webmasteremail\";s:19:\"admin@elvinelol.com\";s:14:\"contactusemail\";s:19:\"admin@elvinelol.com\";s:10:\"privacyurl\";s:0:\"\";s:6:\"tosurl\";s:0:\"\";s:13:\"copyrighttext\";s:0:\"\";s:11:\"companyname\";s:0:\"\";s:9:\"faxnumber\";s:0:\"\";s:7:\"address\";s:0:\"\";s:8:\"keywords\";s:115:\"WoW,Gold,Gold Making,Elvine,Elvinelol,Elvinemod,Transmog,Flipping,Professions Guides,World of Warcraft Gold Making,\";s:11:\"description\";s:57:\"Elvine\'s Free World of Warcraft Gold Making Guides & Tips\";s:12:\"useforumjump\";i:1;s:12:\"pagenavpages\";i:3;s:8:\"pagenavs\";s:18:\"10 50 100 500 1000\";s:12:\"enableaccess\";i:1;s:15:\"addtemplatename\";i:0;s:15:\"usestrikesystem\";i:1;s:12:\"forumleaders\";i:1;s:16:\"allowedreferrers\";s:0:\"\";s:13:\"threadmarking\";s:1:\"0\";s:12:\"markinglimit\";i:10;s:12:\"disable_ajax\";i:0;s:21:\"enable_inlinemod_auth\";i:1;s:16:\"facebooksslcheck\";s:0:\"\";s:21:\"enablefacebookconnect\";i:0;s:13:\"facebookappid\";s:0:\"\";s:14:\"facebooksecret\";s:0:\"\";s:19:\"facebookusergroupid\";i:0;s:20:\"facebookautoregister\";i:0;s:20:\"facebookfeedimageurl\";s:0:\"\";s:15:\"fbfeednewthread\";i:0;s:15:\"fbfeedpostreply\";i:0;s:15:\"fbfeedblogentry\";i:0;s:17:\"fbfeedblogcomment\";i:0;s:16:\"fbfeednewarticle\";i:0;s:20:\"fbfeedarticlecomment\";i:0;s:19:\"facebooklikethreads\";i:0;s:23:\"facebooklikeblogentries\";i:0;s:23:\"facebooklikecmsarticles\";i:0;s:22:\"fb_userfield_biography\";s:6:\"field1\";s:21:\"fb_userfield_location\";s:6:\"field2\";s:22:\"fb_userfield_interests\";s:6:\"field3\";s:23:\"fb_userfield_occupation\";s:6:\"field4\";s:21:\"fb_userfield_birthday\";i:1;s:9:\"imagetype\";s:2:\"GD\";s:10:\"magickpath\";s:0:\"\";s:7:\"hvcheck\";i:27;s:8:\"yestoday\";i:1;s:10:\"timeoffset\";i:0;s:8:\"dstonoff\";i:0;s:10:\"dateformat\";s:5:\"m-d-Y\";s:10:\"timeformat\";s:5:\"h:i A\";s:20:\"registereddateformat\";s:3:\"M Y\";s:10:\"calformat1\";s:6:\"F j, Y\";s:10:\"calformat2\";s:3:\"F j\";s:13:\"logdateformat\";s:11:\"H:i, jS M Y\";s:13:\"cookietimeout\";i:900;s:10:\"cookiepath\";s:1:\"/\";s:12:\"cookiedomain\";s:0:\"\";s:10:\"gzipoutput\";i:1;s:9:\"gziplevel\";i:1;s:10:\"addheaders\";i:0;s:14:\"nocacheheaders\";i:0;s:17:\"useheaderredirect\";i:1;s:8:\"forceie8\";i:0;s:12:\"allowphpinfo\";i:0;s:11:\"cachemaxage\";i:7;s:15:\"threadviewslive\";i:0;s:19:\"attachmentviewslive\";i:0;s:9:\"loadlimit\";i:0;s:16:\"recheckfrequency\";i:60;s:10:\"safeupload\";i:0;s:7:\"tmppath\";s:4:\"/tmp\";s:13:\"copypostindex\";i:1;s:7:\"ipcheck\";i:1;s:9:\"remoteyui\";i:0;s:14:\"customyui_path\";s:0:\"\";s:19:\"customyui_combopath\";s:0:\"\";s:12:\"remotejquery\";i:1;s:17:\"customjquery_path\";s:0:\"\";s:7:\"nocache\";i:0;s:7:\"flcache\";i:180;s:10:\"ajaxheader\";i:2;s:21:\"contentread_cleandays\";i:180;s:11:\"friendlyurl\";s:1:\"1\";s:21:\"friendlyurl_canonical\";s:1:\"1\";s:32:\"friendlyurl_canonical_registered\";i:1;s:19:\"friendlyurl_unicode\";s:1:\"0\";s:21:\"friendlyurl_ncrencode\";s:1:\"0\";s:16:\"route_requestvar\";s:1:\"r\";s:10:\"languageid\";i:1;s:7:\"styleid\";i:3;s:19:\"mobilestyleid_basic\";i:2;s:22:\"mobilestyleid_advanced\";i:2;s:17:\"allowchangestyles\";i:1;s:11:\"cleargifurl\";s:9:\"clear.gif\";s:14:\"storecssasfile\";i:0;s:6:\"cssurl\";s:0:\"\";s:9:\"usepopups\";i:1;s:13:\"legacypostbit\";i:1;s:11:\"showimicons\";i:1;s:21:\"searchenginereferrers\";s:32:\".google.\r\n.live.\r\n.msn.\r\n.yahoo.\";s:12:\"skypeweb_gfx\";i:1;s:9:\"as_expire\";i:30;s:10:\"as_content\";i:0;s:10:\"as_refresh\";i:1;s:10:\"as_perpage\";i:30;s:10:\"as_snippet\";i:150;s:12:\"enablecensor\";i:1;s:10:\"censorchar\";s:1:\"*\";s:11:\"censorwords\";s:0:\"\";s:15:\"blankasciistrip\";s:31:\"160 173 u8205 u8204 u8237 u8238\";s:11:\"enableemail\";i:1;s:13:\"displayemails\";i:1;s:11:\"secureemail\";i:1;s:14:\"emailfloodtime\";i:60;s:12:\"usemailqueue\";i:1;s:9:\"mailqueue\";i:1;s:12:\"emailsendnum\";i:50;s:10:\"mail_delay\";i:0;s:11:\"bounceemail\";s:0:\"\";s:13:\"needfromemail\";i:0;s:13:\"usebulkheader\";i:0;s:10:\"utf8encode\";i:0;s:8:\"use_smtp\";i:0;s:9:\"smtp_host\";s:0:\"\";s:9:\"smtp_port\";i:25;s:9:\"smtp_user\";s:0:\"\";s:9:\"smtp_pass\";s:0:\"\";s:8:\"smtp_tls\";s:4:\"none\";s:17:\"allowregistration\";i:1;s:8:\"usecoppa\";i:0;s:10:\"checkcoppa\";i:1;s:18:\"moderatenewmembers\";i:0;s:11:\"welcomemail\";i:1;s:9:\"welcomepm\";s:1:\"0\";s:12:\"newuseremail\";s:0:\"\";s:14:\"allowmultiregs\";i:0;s:11:\"verifyemail\";i:1;s:18:\"requireuniqueemail\";i:1;s:13:\"minuserlength\";i:3;s:13:\"maxuserlength\";i:25;s:16:\"illegalusernames\";s:0:\"\";s:13:\"usernameregex\";s:16:\"^[A-Za-z0-9_ ]+$\";s:11:\"usereferrer\";i:1;s:17:\"defaultregoptions\";i:46631049;s:18:\"usernamereusedelay\";i:365;s:9:\"uiforumid\";i:0;s:9:\"uimessage\";i:1;s:9:\"rpforumid\";i:0;s:8:\"rpuserid\";s:1:\"0\";s:7:\"rpemail\";i:1;s:6:\"socnet\";i:127;s:11:\"reqbirthday\";i:0;s:13:\"ctCensorWords\";s:38:\"admin forum moderator vbulletin leader\";s:11:\"ctCensorMod\";i:1;s:10:\"ctMaxChars\";i:25;s:18:\"minifriends_amount\";i:6;s:16:\"friends_per_page\";i:10;s:18:\"profilemaxvisitors\";i:10;s:15:\"profilelastpost\";i:0;s:14:\"profileprivacy\";i:1;s:18:\"softlinebreakchars\";i:90;s:10:\"ignoremods\";i:0;s:19:\"member_rep_comments\";i:10;s:21:\"usercss_allowed_fonts\";s:446:\"arial|Arial, Helvetica, sans-serif\r\ntimes_new_roman|\'Times New Roman\', Times, serif\r\ncourier_new|\'Courier New\', Courier, monospace\r\ngeorgia|Georgia, \'Times New Roman\', Times, serif\r\nverdana|Verdana, Arial, Helvetica, sans-serif\r\ntahoma|Tahoma, Verdana, Arial, Helvetica, sans-serif\r\ngeneva|Geneva, Arial, Helvetica, sans-serif\r\ntrebuchet_ms|\'Trebuchet MS\', Arial, Helvetica, sans-serif\r\ncomic_sans_ms|\'Comic Sans MS\', Arial, Helvetica, sans-serif\";s:26:\"usercss_allowed_font_sizes\";s:107:\"xx-small|xxsmall\r\nx-small|xsmall\r\nsmall|small\r\nmedium|medium\r\nlarge|large\r\nx-large|xlarge\r\nxx-large|xxlarge\";s:14:\"albums_perpage\";i:10;s:22:\"album_pictures_perpage\";i:25;s:20:\"profile_album_amount\";i:2;s:26:\"albums_pictures_moderation\";i:0;s:23:\"album_captionpreviewlen\";i:150;s:21:\"album_maxpicsperalbum\";i:60;s:21:\"album_recentalbumdays\";i:7;s:10:\"pc_enabled\";i:1;s:13:\"pc_moderation\";i:0;s:10:\"pc_perpage\";i:10;s:13:\"pc_maxperpage\";i:50;s:17:\"pc_allowed_bbcode\";i:9283;s:11:\"vm_maxchars\";i:1000;s:10:\"vm_perpage\";i:10;s:13:\"vm_maxperpage\";i:50;s:13:\"vm_moderation\";i:0;s:17:\"vm_allowed_bbcode\";i:9283;s:16:\"sg_name_maxchars\";i:100;s:17:\"social_moderation\";i:0;s:25:\"socnet_groups_msg_enabled\";i:1;s:11:\"gm_maxchars\";i:1000;s:10:\"sg_perpage\";i:10;s:13:\"sg_maxperpage\";i:50;s:10:\"gm_perpage\";i:10;s:13:\"gm_maxperpage\";i:50;s:22:\"sg_maxdescriptionchars\";i:1000;s:14:\"sgd_maxperpage\";i:50;s:11:\"sgd_perpage\";i:10;s:21:\"sg_allow_join_to_view\";i:0;s:26:\"groups_pictures_moderation\";i:0;s:30:\"socnet_groups_pictures_enabled\";i:1;s:24:\"sg_allow_owner_mod_queue\";i:0;s:32:\"sg_enable_owner_only_discussions\";s:1:\"0\";s:17:\"sg_allowed_bbcode\";i:9283;s:27:\"sg_allow_delete_empty_group\";i:1;s:25:\"sg_enablesocialgroupicons\";i:1;s:18:\"sg_newgroups_count\";i:15;s:22:\"sg_category_cloud_size\";i:40;s:13:\"avatarenabled\";i:1;s:17:\"numavatarsperpage\";i:50;s:17:\"profilepicenabled\";i:1;s:16:\"reputationenable\";i:1;s:11:\"newrepcount\";i:1;s:17:\"reputationdefault\";i:10;s:19:\"reputationundefined\";s:16:\"is off the scale\";s:13:\"showuserrates\";i:10;s:10:\"adminpower\";i:5;s:7:\"rdpower\";i:365;s:7:\"pcpower\";i:1000;s:7:\"kppower\";i:100;s:17:\"minreputationpost\";i:5;s:18:\"minreputationcount\";i:10;s:19:\"maxreputationperday\";i:20;s:16:\"reputationrepeat\";i:0;s:13:\"needposreason\";i:0;s:13:\"neednegreason\";i:1;s:12:\"showrepinown\";i:0;s:13:\"reputationcap\";i:0;s:13:\"unallowvbcode\";i:1;s:14:\"unallowsmilies\";i:1;s:10:\"unallowimg\";i:1;s:12:\"unallowvideo\";i:1;s:11:\"unallowhtml\";i:0;s:16:\"enablememberlist\";i:1;s:15:\"memberlistposts\";i:0;s:16:\"memberlistfields\";i:216;s:17:\"memberlistperpage\";i:30;s:22:\"usememberlistadvsearch\";i:1;s:13:\"enablebanning\";i:1;s:5:\"banip\";s:29:\"24.251.142.159\r\n184.98.252.64\";s:8:\"banemail\";s:0:\"\";s:18:\"aggressiveemailban\";i:0;s:20:\"allowkeepbannedemail\";i:1;s:12:\"globalignore\";s:0:\"\";s:14:\"allowedbbcodes\";i:1023;s:12:\"codemaxlines\";i:30;s:11:\"allowbbcode\";i:1;s:12:\"allowsmilies\";i:1;s:16:\"allowbbimagecode\";i:0;s:16:\"allowbbvideocode\";i:1;s:9:\"allowhtml\";i:0;s:12:\"url_nofollow\";i:0;s:22:\"url_nofollow_whitelist\";s:0:\"\";s:19:\"bbcode_video_scrape\";i:3;s:12:\"player_wmode\";s:6:\"opaque\";s:10:\"quickreply\";i:1;s:9:\"quickedit\";i:1;s:10:\"multiquote\";s:1:\"1\";s:7:\"mqlimit\";i:0;s:12:\"postminchars\";i:3;s:12:\"postmaxchars\";i:10000;s:13:\"titlemaxchars\";i:85;s:16:\"ignorequotechars\";i:1;s:10:\"quotetitle\";i:0;s:9:\"maximages\";i:0;s:9:\"maxvideos\";i:0;s:12:\"stopshouting\";i:2;s:14:\"floodchecktime\";i:30;s:20:\"editthreadtitlelimit\";i:5;s:14:\"addpolltimeout\";i:0;s:13:\"edittimelimit\";i:0;s:14:\"noeditedbytime\";i:2;s:5:\"logip\";i:1;s:15:\"postedithistory\";i:1;s:12:\"postautosave\";i:60;s:11:\"editormodes\";s:45:\"a:3:{s:2:\"fe\";i:1;s:2:\"qr\";i:1;s:2:\"qe\";i:1;}\";s:7:\"smtotal\";i:15;s:9:\"smcolumns\";i:3;s:15:\"wysiwyg_smtotal\";i:15;s:11:\"dp_timespan\";i:240;s:7:\"dp_bump\";i:1;s:10:\"dp_ipcheck\";i:1;s:9:\"dp_spacer\";s:1:\"3\";s:7:\"dp_text\";s:19:\"- - - - - - - - - -\";s:8:\"dp_color\";s:3:\"red\";s:16:\"attachtotalspace\";i:0;s:11:\"attachlimit\";i:5;s:14:\"attachboxcount\";i:1;s:14:\"attachurlcount\";i:1;s:14:\"allowattachdel\";i:1;s:20:\"allowclosedattachdel\";i:0;s:15:\"allowduplicates\";i:1;s:12:\"attachresize\";i:0;s:18:\"viewattachedimages\";i:1;s:12:\"attachthumbs\";i:1;s:16:\"attachthumbssize\";i:400;s:12:\"thumbquality\";i:75;s:9:\"attachrow\";i:5;s:10:\"thumbcolor\";s:7:\"#000000\";s:15:\"lightboxenabled\";i:1;s:14:\"vbasset_enable\";i:1;s:15:\"vbasset_perpage\";i:20;s:20:\"advimagepopup_enable\";i:1;s:14:\"maxpolloptions\";i:10;s:13:\"maxpolllength\";i:100;s:14:\"updatelastpost\";i:0;s:9:\"showvotes\";i:1;s:10:\"votechange\";i:0;s:14:\"enablesearches\";i:1;s:18:\"searchqueueupdates\";i:0;s:15:\"searchfloodtime\";i:0;s:13:\"searchperpage\";i:25;s:10:\"maxresults\";i:500;s:15:\"minsearchlength\";i:4;s:15:\"maxsearchlength\";i:20;s:14:\"allowwildcards\";i:1;s:19:\"similarthreadsearch\";i:0;s:9:\"goodwords\";s:14:\"vb vbb php sql\";s:8:\"badwords\";s:0:\"\";s:13:\"threadtagging\";i:1;s:9:\"tagminlen\";i:3;s:9:\"tagmaxlen\";i:25;s:11:\"tagbadwords\";s:0:\"\";s:12:\"taggoodwords\";s:0:\"\";s:12:\"tagdelimiter\";s:0:\"\";s:12:\"tagmaxthread\";i:25;s:13:\"tagmaxstarter\";i:5;s:10:\"tagmaxuser\";i:2;s:13:\"tagforcelower\";i:1;s:13:\"tagcloud_tags\";i:70;s:15:\"tagcloud_levels\";i:5;s:18:\"tagcloud_cachetime\";i:30;s:21:\"tagcloud_usagehistory\";i:365;s:18:\"tagcloud_usergroup\";i:2;s:20:\"tagcloud_searchcloud\";i:1;s:22:\"tagcloud_searchhistory\";i:30;s:9:\"forumhome\";s:5:\"forum\";s:15:\"displayloggedin\";i:1;s:13:\"showbirthdays\";i:1;s:10:\"showevents\";i:1;s:12:\"showholidays\";i:1;s:13:\"showeventtype\";i:0;s:16:\"activememberdays\";i:30;s:19:\"activememberoptions\";i:3;s:11:\"wgo_members\";i:0;s:17:\"wgo_members_names\";i:1;s:14:\"wgo_members_24\";i:0;s:16:\"wgo_members_most\";i:0;s:20:\"wgo_members_collapse\";i:0;s:14:\"forumhomedepth\";i:2;s:17:\"forumdisplaydepth\";i:2;s:13:\"subforumdepth\";i:1;s:20:\"showforumdescription\";i:1;s:17:\"showprivateforums\";s:1:\"0\";s:9:\"showlocks\";i:0;s:15:\"lastthreadchars\";i:30;s:19:\"showmoderatorcolumn\";i:0;s:18:\"showprefixlastpost\";i:2;s:14:\"showforumusers\";i:0;s:10:\"maxthreads\";i:20;s:12:\"showstickies\";i:1;s:8:\"showdots\";i:1;s:13:\"usehotthreads\";i:1;s:14:\"hotnumberviews\";i:150;s:14:\"hotnumberposts\";i:15;s:11:\"linktopages\";i:1;s:12:\"maxmultipage\";i:3;s:13:\"threadpreview\";i:150;s:11:\"oneannounce\";i:1;s:13:\"enablesidebar\";i:1;s:15:\"sidebarposition\";i:1;s:17:\"disableblockcache\";i:0;s:15:\"showthreadusers\";i:0;s:8:\"maxposts\";i:10;s:12:\"usermaxposts\";s:13:\"5,10,20,30,40\";s:11:\"showdeficon\";s:0:\"\";s:8:\"wordwrap\";i:50;s:11:\"threadvoted\";i:0;s:16:\"threadsubscribed\";i:1;s:18:\"showsimilarthreads\";i:1;s:12:\"postelements\";i:0;s:15:\"socialbookmarks\";i:0;s:13:\"nextprevlinks\";i:0;s:8:\"who_read\";i:1;s:8:\"wrtlimit\";i:0;s:11:\"wrtcollapse\";i:0;s:10:\"wrtreaders\";i:1;s:9:\"wrtauthor\";i:0;s:17:\"allowthreadedmode\";i:1;s:12:\"threadedmode\";i:0;s:18:\"threaded_listdepth\";i:5;s:17:\"threaded_maxcache\";i:40;s:18:\"threaded_trimtitle\";i:30;s:9:\"enablepms\";i:1;s:10:\"checknewpm\";i:1;s:10:\"pmmaxchars\";i:5000;s:11:\"pmfloodtime\";i:60;s:16:\"pmthrottleperiod\";i:0;s:9:\"pmperpage\";i:50;s:12:\"pmmaxperpage\";i:100;s:14:\"privallowicons\";i:1;s:15:\"privallowbbcode\";i:1;s:16:\"privallowsmilies\";i:1;s:20:\"privallowbbimagecode\";i:1;s:20:\"privallowbbvideocode\";i:1;s:13:\"privallowhtml\";i:0;s:9:\"WOLenable\";i:1;s:10:\"WOLrefresh\";i:60;s:9:\"WOLguests\";i:1;s:10:\"WOLresolve\";i:0;s:13:\"enablespiders\";i:0;s:14:\"archiveenabled\";i:1;s:18:\"archive_threadtype\";i:1;s:22:\"archive_threadsperpage\";i:250;s:20:\"archive_postsperpage\";i:250;s:13:\"cpstylefolder\";s:18:\"vBulletin_3_Silver\";s:19:\"timeoutcontrolpanel\";i:0;s:15:\"adminquickstats\";i:0;s:18:\"cp_collapse_forums\";i:0;s:18:\"cp_usereditcolumns\";i:2;s:10:\"externaljs\";i:0;s:11:\"externalrss\";i:1;s:10:\"rsspodcast\";i:1;s:11:\"externalxml\";i:1;s:14:\"externalcutoff\";i:30;s:13:\"externalcache\";i:60;s:13:\"externalcount\";i:15;s:16:\"errorlogdatabase\";s:0:\"\";s:16:\"errorlogsecurity\";s:0:\"\";s:11:\"errorlogphp\";s:0:\"\";s:13:\"errorlogemail\";s:0:\"\";s:15:\"errorlogmaxsize\";i:1048576;s:17:\"disableerroremail\";i:0;s:11:\"enablehooks\";i:1;s:12:\"paymentemail\";s:19:\"elvinelol@gmail.com\";s:16:\"vb_antispam_type\";i:0;s:15:\"vb_antispam_key\";s:0:\"\";s:17:\"vb_antispam_posts\";i:0;s:14:\"postlog_maxage\";i:7;s:19:\"sitemap_cron_enable\";i:1;s:22:\"sitemap_cron_frequency\";i:14;s:16:\"sitemap_priority\";d:0.5;s:17:\"sitemap_se_submit\";i:31;s:12:\"sitemap_path\";s:15:\"./store_sitemap\";s:19:\"sitemap_url_perpage\";i:30000;s:9:\"enableapi\";i:0;s:12:\"enableapilog\";i:0;s:15:\"apilogpostparam\";i:0;s:15:\"apipostidmanage\";s:90:\"a:4:{s:6:\"enable\";s:1:\"0\";s:6:\"iphone\";s:0:\"\";s:7:\"android\";s:0:\"\";s:8:\"facebook\";s:0:\"\";}\";s:18:\"mobilehomemaxitems\";i:10;s:23:\"mobilehomethreaddatecut\";i:30;s:24:\"mobilehomethreadforumids\";s:0:\"\";s:21:\"mobilehomeblogdatecut\";i:60;s:20:\"mobilehomeblogcatids\";s:0:\"\";s:21:\"mobilehomebloguserids\";s:0:\"\";s:24:\"mobilehomearticledatecut\";i:60;s:23:\"mobilehomearticlecatids\";s:0:\"\";s:27:\"mobilehomearticlesectionids\";s:0:\"\";s:10:\"vbblog_url\";s:0:\"\";s:12:\"vbblog_style\";i:0;s:16:\"vbblog_trackback\";i:0;s:15:\"vbblog_pingback\";i:0;s:18:\"vbblog_notifylinks\";i:3;s:21:\"vbblog_defaultoptions\";i:124493;s:14:\"vbblog_snippet\";i:500;s:17:\"vbblog_ratinguser\";i:10;s:17:\"blog_catusertotal\";i:20;s:13:\"blog_wordwrap\";i:25;s:22:\"vbblog_commentmaxchars\";i:10000;s:19:\"vbblog_usermaxchars\";i:2000;s:23:\"vbblog_commentmaximages\";i:4;s:23:\"vbblog_commentmaxvideos\";i:1;s:20:\"vbblog_usermaximages\";i:4;s:20:\"vbblog_usermaxvideos\";i:1;s:18:\"vbblog_stat_cutoff\";i:30;s:13:\"vbblog_blocks\";i:127;s:20:\"vbblog_blockmaxchars\";i:2500;s:21:\"vbblog_blockmaximages\";i:10;s:21:\"vbblog_blockmaxvideos\";i:1;s:19:\"vbblog_pagemaxchars\";i:7500;s:20:\"vbblog_pagemaximages\";i:10;s:20:\"vbblog_pagemaxvideos\";i:1;s:19:\"vbblog_blogthispost\";i:1;s:20:\"vbblog_nextprevlinks\";i:0;s:20:\"blog_commentsperpage\";i:20;s:17:\"vbblog_ratingpost\";i:2;s:28:\"vbblog_usercss_allowed_fonts\";s:446:\"arial|Arial, Helvetica, sans-serif\r\ntimes_new_roman|\'Times New Roman\', Times, serif\r\ncourier_new|\'Courier New\', Courier, monospace\r\ngeorgia|Georgia, \'Times New Roman\', Times, serif\r\nverdana|Verdana, Arial, Helvetica, sans-serif\r\ntahoma|Tahoma, Verdana, Arial, Helvetica, sans-serif\r\ngeneva|Geneva, Arial, Helvetica, sans-serif\r\ntrebuchet_ms|\'Trebuchet MS\', Arial, Helvetica, sans-serif\r\ncomic_sans_ms|\'Comic Sans MS\', Arial, Helvetica, sans-serif\";s:33:\"vbblog_usercss_allowed_font_sizes\";s:39:\"small|small\r\nmedium|medium\r\nlarge|large\";s:36:\"vbblog_usercss_allowed_border_widths\";s:32:\"small|1px\r\nmedium|2px\r\nlarge|3px\";s:30:\"vbblog_usercss_allowed_padding\";s:80:\"none|0px\r\ntiny|1px\r\nsmall|2px\r\nmedium|3px\r\nlarge|6px\r\nhuge|10px\r\ngargantuan|20px\";s:21:\"vbblog_postmoderation\";i:0;s:24:\"vbblog_commentmoderation\";i:0;s:17:\"blog_catpostlimit\";i:5;s:20:\"vbblog_entrymaxchars\";i:10000;s:21:\"vbblog_entrymaximages\";i:10;s:21:\"vbblog_entrymaxvideos\";i:1;s:14:\"vbblog_pending\";i:20;s:12:\"vbblog_draft\";i:15;s:17:\"vbblog_maxperpage\";i:15;s:14:\"vbblog_perpage\";i:5;s:24:\"vbblog_recententrycutoff\";s:2:\"1m\";s:26:\"vbblog_recentcommentcutoff\";s:2:\"1w\";s:19:\"vbblog_maxratedblog\";s:2:\"10\";s:20:\"vbblog_maxratedentry\";s:2:\"10\";s:23:\"vbblog_maxrecentcomment\";s:2:\"10\";s:21:\"vbblog_maxrecententry\";s:2:\"10\";s:14:\"vbblog_tagging\";i:1;s:16:\"vbblog_tagminlen\";i:3;s:16:\"vbblog_tagmaxlen\";i:25;s:13:\"vbblog_maxtag\";i:25;s:20:\"vbblog_maxtagstarter\";i:5;s:17:\"vbblog_maxtaguser\";i:2;s:20:\"vbblog_tagforcelower\";s:1:\"1\";s:20:\"vbblog_tagcloud_tags\";i:70;s:22:\"vbblog_tagcloud_levels\";i:5;s:25:\"vbblog_tagcloud_cachetime\";i:30;s:28:\"vbblog_tagcloud_usagehistory\";i:365;s:25:\"vbblog_tagcloud_cachetype\";s:1:\"2\";s:27:\"vbblog_tagcloud_searchcloud\";i:1;s:29:\"vbblog_tagcloud_searchhistory\";i:30;s:14:\"blogattachfile\";i:0;s:14:\"blogattachpath\";s:34:\"/path/to/your/attachment/directory\";s:12:\"vbcmsforumid\";i:3;s:9:\"vbcms_url\";s:0:\"\";s:14:\"thumb_override\";i:1;s:12:\"default_page\";s:7:\"1-Index\";s:12:\"cms_as_index\";s:1:\"0\";s:8:\"cmstitle\";s:0:\"\";s:12:\"site_tab_url\";s:11:\"content.php\";s:17:\"cms_preview_thumb\";i:1;s:25:\"default_cms_previewlength\";i:120;s:14:\"skimlinks_salt\";s:32:\"cd568ab2e05dd9eaf113e4d3aa8487b7\";s:17:\"skimlinks_enabled\";i:0;s:16:\"skimlinks_pub_id\";s:0:\"\";s:28:\"skimlinks_allow_user_disable\";i:0;s:34:\"skimlinks_user_disable_description\";s:178:\"We use a product called Skimlinks to help us pay the bills for this forum. If you don\'t want these links to be enabled while you browse the site, you may disable the system here.\";s:24:\"skimlinks_disable_groups\";s:2:\"[]\";s:30:\"skimlinks_disable_groups_parse\";s:2:\"[]\";s:24:\"skimlinks_disable_forums\";s:2:\"[]\";s:24:\"skimwords_disable_groups\";s:2:\"[]\";s:30:\"skimwords_disable_groups_parse\";s:2:\"[]\";s:24:\"skimwords_disable_forums\";s:2:\"[]\";s:26:\"skimlinks_thread_age_limit\";i:0;s:26:\"skimwords_thread_age_limit\";i:0;s:26:\"forumrunner_redirect_onoff\";i:1;s:21:\"forumrunner_cms_onoff\";i:0;s:23:\"forumrunner_cms_section\";i:1;s:19:\"forumrunner_exclude\";s:0:\"\";s:30:\"forumrunner_branding_navbar_bg\";s:0:\"\";s:21:\"forumrunner_signature\";i:1;s:31:\"forumrunner_enable_registration\";i:1;s:31:\"forumrunner_google_analytics_id\";s:0:\"\";s:27:\"forumrunner_googleads_onoff\";i:0;s:32:\"forumrunner_googleads_threadlist\";i:0;s:31:\"forumrunner_googleads_topthread\";i:0;s:34:\"forumrunner_googleads_bottomthread\";i:0;s:32:\"forumrunner_googleads_usergroups\";s:0:\"\";s:40:\"forumrunner_googleads_exclude_usergroups\";s:0:\"\";s:36:\"forumrunner_admob_publisherid_iphone\";s:0:\"\";s:37:\"forumrunner_admob_publisherid_android\";s:0:\"\";s:32:\"forumrunner_googleads_javascript\";s:0:\"\";s:18:\"postrelease_enable\";s:1:\"0\";s:18:\"postrelease_optout\";s:0:\"\";s:20:\"electron_fixedlayout\";i:0;s:20:\"electron_threadicons\";i:0;s:25:\"vsachatbox_enable_product\";i:1;s:22:\"vsachatbox_script_locs\";s:15:\"index,adv_index\";s:24:\"vsachatbox_template_locs\";s:9:\"FORUMHOME\";s:21:\"vsachatbox_forum_locs\";i:0;s:19:\"vsachatbox_page_loc\";s:1:\"1\";s:20:\"vsachatbox_pos_input\";s:1:\"1\";s:24:\"vsachatbox_pos_statusbar\";s:1:\"2\";s:24:\"vsachatbox_messages_main\";i:30;s:26:\"vsachatbox_archive_perpage\";i:25;s:27:\"vsachatbox_reverse_messages\";i:0;s:31:\"vsachatbox_reverse_messages_arc\";i:0;s:25:\"vsachatbox_align_username\";i:0;s:17:\"vsachatbox_height\";i:100;s:22:\"vsachatbox_height_full\";i:400;s:24:\"vsachatbox_code_maxwidth\";i:450;s:21:\"vsachatbox_dateformat\";s:3:\"d-m\";s:21:\"vsachatbox_timeformat\";s:3:\"H:i\";s:22:\"vsachatbox_time_enable\";i:1;s:18:\"vsachatbox_mecolor\";s:3:\"Red\";s:32:\"vsachatbox_auto_refresh_messages\";i:10;s:30:\"vsachatbox_auto_refresh_guests\";i:0;s:32:\"vsachatbox_auto_refresh_overload\";i:0;s:21:\"vsachatbox_logout_dur\";i:5;s:22:\"vsachatbox_logout_init\";i:0;s:24:\"vsachatbox_status_enable\";i:1;s:26:\"vsachatbox_viewers_timecut\";i:10;s:29:\"vsachatbox_auto_refresh_users\";i:30;s:20:\"vsachatbox_charlimit\";i:255;s:20:\"vsachatbox_textsizes\";s:11:\"11,12,14,16\";s:23:\"vsachatbox_smiliestotal\";i:1;s:22:\"vsachatbox_smiliesinit\";i:10;s:24:\"vsachatbox_smiliesperrow\";s:1:\"5\";s:22:\"vsachatbox_smiliesclip\";i:30;s:24:\"vsachatbox_smilies_parse\";i:1;s:25:\"vsachatbox_smilies_random\";i:1;s:26:\"vsachatbox_clickable_links\";i:1;s:25:\"vsachatbox_colors_enabled\";i:1;s:21:\"vsachatbox_textcolors\";s:212:\"Black, Gold, Khaki, Orange, LightPink, Salmon, Tomato, Red, Brown, Maroon, DarkGreen, DarkCyan, LightSeaGreen, LawnGreen, MediumSeaGreen, BlueViolet, Cyan, Blue, DodgerBlue, LightSkyBlue, White, DimGray, DarkGray\";s:22:\"vsachatbox_canviewonly\";s:1:\"8\";s:26:\"vsachatbox_excluded_groups\";s:3:\"1,8\";s:25:\"vsachatbox_excluded_users\";s:0:\"\";s:22:\"vsachatbox_excluded_pc\";i:0;s:18:\"vsachatbox_can_mod\";s:5:\"5,6,7\";s:21:\"vsachatbox_can_delall\";s:1:\"6\";s:26:\"vsachatbox_users_candelete\";i:1;s:22:\"vsachatbox_cannot_edit\";s:3:\"1,8\";s:22:\"vsachatbox_banned_tags\";s:0:\"\";s:23:\"vsachatbox_topx_results\";i:5;s:27:\"vsachatbox_stats_lastxhours\";i:12;s:22:\"vsachatbox_newmess_dur\";i:10;s:21:\"vsachatbox_auto_prune\";s:0:\"\";s:27:\"vsachatbox_collapsed_always\";i:0;s:25:\"vsachatbox_autoinsertlink\";i:1;s:16:\"wowhead_language\";s:3:\"www\";s:13:\"wowhead_debug\";i:0;s:27:\"wowhead_itemstats_newwindow\";i:1;s:22:\"wowhead_itemstats_bold\";i:1;s:27:\"wowhead_itemstats_underline\";i:0;s:36:\"glowhostspamomatic_bsc_protect_group\";s:5:\"5,6,7\";s:35:\"glowhostspamomatic_bsc_protect_user\";s:0:\"\";s:34:\"glowhostspamomatic_akismet_enabled\";s:1:\"1\";s:36:\"glowhostspamomatic_akismet_postcount\";i:10;s:30:\"glowhostspamomatic_akismet_key\";s:0:\"\";s:47:\"glowhostspamomatic_akismet_do_submit_moderation\";s:1:\"1\";s:31:\"glowhostspamomatic_testfield_ip\";s:1:\"1\";s:37:\"glowhostspamomatic_testfield_username\";s:1:\"1\";s:34:\"glowhostspamomatic_testfield_email\";s:1:\"1\";s:25:\"glowhostspamomatic_result\";s:1:\"0\";s:33:\"glowhostspamomatic_result_timeout\";s:1:\"0\";s:29:\"glowhostspamomatic_expire_day\";s:2:\"90\";s:31:\"glowhostspamomatic_remote_cache\";s:2:\"30\";s:25:\"glowhostspamomatic_apikey\";s:0:\"\";s:39:\"glowhostspamomatic_do_submit_moderation\";s:1:\"1\";s:31:\"glowhostspamomatic_noob_enabled\";s:1:\"0\";s:32:\"glowhostspamomatic_noob_group_id\";s:0:\"\";s:35:\"glowhostspamomatic_noob_autopromote\";s:1:\"1\";s:34:\"glowhostspamomatic_noob_reg_ugroup\";s:1:\"2\";s:40:\"glowhostspamomatic_noob_promotepostcount\";s:1:\"4\";s:33:\"glowhostspamomatic_automodenabled\";s:1:\"0\";s:36:\"glowhostspamomatic_automodpostaction\";s:1:\"0\";s:40:\"glowhostspamomatic_noob_restrict_automod\";s:1:\"0\";s:35:\"glowhostspamomatic_automodpostcount\";i:6;s:34:\"glowhostspamomatic_automodkeywords\";s:0:\"\";s:30:\"glowhostspamomatic_automodurls\";i:0;s:29:\"glowhostspamomatic_bsc_enable\";s:1:\"1\";s:31:\"glowhostspamomatic_bsc_ban_user\";s:1:\"0\";s:28:\"glowhostspamomatic_bsc_group\";i:8;s:37:\"glowhostspamomatic_bsc_delete_threads\";s:1:\"1\";s:35:\"glowhostspamomatic_bsc_delete_posts\";s:1:\"1\";s:33:\"glowhostspamomatic_bsc_delete_pms\";s:1:\"1\";s:36:\"glowhostspamomatic_bsc_delete_events\";s:1:\"1\";s:34:\"glowhostspamomatic_bsc_hard_delete\";s:1:\"1\";s:32:\"glowhostspamomatic_bsc_overrride\";s:1:\"1\";s:35:\"glowhostspamomatic_stat_show_denied\";s:1:\"1\";s:35:\"glowhostspamomatic_stat_show_banned\";s:1:\"1\";s:34:\"glowhostspamomatic_stat_show_s_sfs\";s:1:\"1\";s:38:\"glowhostspamomatic_stat_show_s_akismet\";s:1:\"1\";s:32:\"glowhostspamomatic_stat_show_mod\";s:1:\"1\";s:36:\"glowhostspamomatic_stat_show_removed\";s:1:\"1\";s:33:\"glowhostspamomatic_stat_show_link\";s:1:\"0\";s:35:\"glowhostspamomatic_affiliate_enable\";s:1:\"0\";s:31:\"glowhostspamomatic_affiliate_id\";s:0:\"\";s:34:\"glowhostspamomatic_affiliate_place\";s:1:\"1\";s:33:\"glowhostspamomatic_affiliate_text\";s:11:\"Web Hosting\";s:31:\"glowhostspamomatic_credits_give\";s:1:\"0\";s:35:\"glowhostspamomatic_credits_location\";s:1:\"1\";s:15:\"nospamimg_onoff\";i:1;s:19:\"nospamimg_questions\";s:123:\"How many cats are in this picture?:nospam_example2.jpg:2:two\r\nHow many palm trees in this picture?:howmanypalmsx.jpg:4:four\";s:17:\"nospamimg_use_reg\";i:1;s:23:\"nospamimg_use_contactus\";i:1;s:18:\"nospamimg_use_post\";s:1:\"0\";s:28:\"dbtech_thanks_displayversion\";i:1;s:27:\"dbtech_thanks_branding_free\";s:0:\"\";s:21:\"dbtech_thanks_nohivel\";i:0;s:22:\"dbtech_thanks_referral\";i:0;s:25:\"dbtech_thanks_integration\";i:3;s:32:\"dbtech_thanks_postbit_deployment\";i:0;s:24:\"dbtech_thanks_hideguests\";i:0;s:27:\"dbtech_thanks_notifications\";i:1;s:33:\"dbtech_thanks_disabledintegration\";i:0;s:30:\"dbtech_thanks_displayextrainfo\";i:1;s:24:\"dbtech_thanks_nocollapse\";i:0;s:22:\"dbtech_thanks_features\";i:7;s:21:\"dbtech_thanks_postbit\";i:15;s:30:\"dbtech_thanks_allow_likethanks\";i:1;s:29:\"dbtech_gallery_thread_img_cat\";i:1;s:29:\"dbtech_gallery_thread_img_ugs\";s:10:\"6,7,2,5,-1\";s:25:\"dbtech_gallery_thread_img\";i:0;s:34:\"dbtech_gallery_thread_img_instance\";i:1;s:32:\"dbtech_gallery_notify_cat_create\";i:1;s:27:\"dbtech_gallery_urlpath_text\";s:0:\"\";s:25:\"dbtech_gallery_thumb_type\";s:1:\"2\";s:28:\"dbtech_gallery_filename_text\";s:14:\"dbtgallery.php\";s:24:\"dbtech_gallery_view_type\";s:1:\"1\";s:30:\"dbtech_gallery_scrollable_type\";s:1:\"1\";s:33:\"dbtech_gallery_scrollable_enabled\";i:0;s:28:\"dbtech_gallery_shout_enabled\";i:0;s:23:\"dbtech_gallery_fh_count\";i:5;s:22:\"dbtech_gallery_fh_type\";s:1:\"1\";s:28:\"dbtech_gallery_fh_autodeploy\";i:1;s:25:\"dbtech_gallery_fh_enabled\";i:0;s:24:\"dbtech_gallery_cms_count\";i:5;s:23:\"dbtech_gallery_cms_type\";s:1:\"1\";s:26:\"dbtech_gallery_cms_enabled\";i:1;s:23:\"dbtech_gallery_cms_view\";s:1:\"2\";s:29:\"dbtech_gallery_editor_enabled\";i:1;s:28:\"dbtech_gallery_closed_reason\";s:127:\"<p>Sorry, the gallery is unavailable at the moment while we are testing some functionality.</p>\r\n<p>We will be back soon...</p>\";s:28:\"dbtech_gallery_branding_free\";s:0:\"\";s:22:\"dbtech_gallery_nohivel\";i:1;s:29:\"dbtech_gallery_displayversion\";i:0;s:22:\"dbtech_gallery_enabled\";i:1;s:3:\"wvt\";i:1;s:8:\"wvtnames\";i:1;s:5:\"wvt24\";i:0;s:7:\"wvtgrps\";s:14:\"a:1:{i:0;i:0;}\";s:7:\"wvtgrpz\";i:0;s:7:\"wvtmost\";i:1;s:11:\"wvtcollapse\";i:0;s:34:\"dbtech_gallery_comm_block_disabled\";i:0;s:32:\"dbtech_gallery_home_block_latest\";i:0;s:38:\"dbtech_gallery_home_block_latest_count\";i:5;s:33:\"dbtech_gallery_home_block_toprate\";i:0;s:39:\"dbtech_gallery_home_block_toprate_count\";i:5;s:34:\"dbtech_gallery_home_block_mostcomm\";i:0;s:40:\"dbtech_gallery_home_block_mostcomm_count\";i:5;s:34:\"dbtech_gallery_home_block_mostview\";i:0;s:40:\"dbtech_gallery_home_block_mostview_count\";i:5;s:28:\"dbtech_gallery_filepath_text\";s:29:\"dbtech/gallery/images/upload/\";s:22:\"dbtech_gallery_jpg_res\";i:80;s:24:\"dbtech_gallery_next_prev\";i:0;s:27:\"dbtech_gallery_allow_dnload\";i:0;s:24:\"dbtech_gallery_url_force\";i:0;s:26:\"dbtech_gallery_soft_delete\";i:0;s:21:\"dbtech_gallery_resize\";i:1;s:25:\"dbtech_gallery_hover_info\";i:1;s:32:\"dbtech_gallery_repeat_view_count\";i:0;s:31:\"dbtech_gallery_guest_view_count\";i:0;s:22:\"dbtech_gallery_twitter\";i:1;s:20:\"dbtech_gallery_gplus\";i:1;s:24:\"dbtech_gallery_pinterest\";i:1;s:21:\"dbtech_gallery_fblike\";i:1;s:22:\"dbtech_gallery_di_code\";i:1;s:22:\"dbtech_gallery_bi_code\";i:1;s:22:\"dbtech_gallery_bb_code\";i:1;s:18:\"vba_portal_homeurl\";s:10:\"/index.php\";s:18:\"vba_portal_pagevar\";s:6:\"pageid\";s:18:\"vba_portal_navtabs\";s:1:\"0\";s:13:\"elvine_status\";i:1;s:13:\"rs_img_active\";s:1:\"1\";s:15:\"rs_img_maxwidth\";i:800;s:12:\"lgvcleardays\";i:0;s:10:\"lgvblocked\";s:0:\"\";s:11:\"lgvforumids\";s:1:\"0\";s:10:\"lgvbguests\";i:1;s:9:\"lgvblckon\";i:1;s:10:\"lgvblckcnt\";i:10;s:5:\"lgvon\";i:1;s:5:\"lgvdb\";i:0;s:9:\"lgvmesson\";i:1;s:10:\"lgvmesscnt\";i:5;s:19:\"autotag_enabled_all\";i:1;s:15:\"autotag_enabled\";i:1;s:20:\"autotag_enabled_ajax\";i:0;s:22:\"autotag_exclude_forums\";s:0:\"\";s:21:\"autotag_exclude_users\";s:0:\"\";s:27:\"autotag_exclude_searchwords\";i:1;s:27:\"autotag_exclude_tagbadwords\";i:1;s:20:\"autotag_exclude_date\";i:1;s:23:\"autotag_use_smartquotes\";i:1;s:22:\"autotag_excluded_words\";s:2235:\"a, about, above, across, after, afterwards, again, against, all, almost, alone, along, already, also, although, always, am, among, amongst, amoungst, amount, an, and, another, any, anyhow, anyone, anything, anyway, anywhere, are, around, as, at, back, be, became, because, become, becomes, becoming, been, before, beforehand, behind, being, below, beside, besides, between, beyond, bill, both, bottom, but, by, call, can, cannot, cant, co, computer, con, could, couldnt, cry, de, describe, detail, do, done, down, due, during, each, eg, eight, either, eleven, else, elsewhere, empty, enough, etc, even, ever, every, everyone, everything, everywhere, except, few, fifteen, fify, fill, find, fire, first, five, for, former, formerly, forty, found, four, from, front, full, further, get, give, go, had, has, hasnt, have, he, hence, her, here, hereafter, hereby, herein, hereupon, hers, herself, him, himself, his, how, however, hundred, i, ie, if, in, inc, indeed, interest, into, is, it, its, itself, keep, last, latter, latterly, least, less, ltd, made, many, may, me, meanwhile, might, mill, mine, more, moreover, most, mostly, move, much, must, my, myself, name, namely, neither, never, nevertheless, next, nine, no, nobody, none, noone, nor, not, nothing, now, nowhere, of, off, often, on, once, one, only, onto, or, other, others, otherwise, our, ours, ourselves, out, over, own, part, per, perhaps, please, put, rather, re, same, see, seem, seemed, seeming, seems, serious, several, she, should, show, side, since, sincere, six, sixty, so, some, somehow, someone, something, sometime, sometimes, somewhere, still, such, system, take, ten, than, that, the, their, them, themselves, then, thence, there, thereafter, thereby, therefore, therein, thereupon, these, they, thick, thin, third, this, those, though, three, through, throughout, thru, thus, to, together, too, top, toward, towards, twelve, twenty, two, un, under, until, up, upon, us, very, via, was, we, well, were, what, whatever, when, whence, whenever, where, whereafter, whereas, whereby, wherein, whereupon, wherever, whether, which, while, whither, who, whoever, whole, whom, whose, why, will, with, within, without, would, yet, you, your, yours, yourself, yourselves\";s:18:\"autotag_cron_count\";s:3:\"500\";s:25:\"autotag_disable_if_tagged\";i:0;s:21:\"autotag_ajax_existing\";i:1;s:33:\"autotag_filter_replace_characters\";s:276:\"\'\'s\'=>\'\'\r\n\'&amp;\'=>\'and\'\r\n\'&quot;\'=>\'\'\r\n\'(\'=>\'\'\r\n\')\'=>\'\'\r\n\'\"\'=>\'\'\r\n\'\'\'=>\'\'\r\n\'!\'=>\'\'\r\n\'^\'=>\'\'\r\n\'*\'=>\'\'\r\n\'[\'=>\'\'\r\n\']\'=>\'\'\r\n\'{\'=>\'\'\r\n\'}\'=>\'\'\r\n\'~\'=>\'\'\r\n\'?\'=>\'\'\r\n\'<\'=>\'\'\r\n\'>\'=>\'\'\r\n\':\'=>\'\'\r\n\';\'=>\'\'\r\n\'=\'=>\'\'\r\n\'+\'=>\'\'\r\n\'-\'=>\'\'\r\n\'_\'=>\'\'\r\n\'/\'=>\' or \'\r\n\'\\\'=>\' or \'\r\n\'.\'=>\'\'\r\n\' & \'=>\'and\'\";s:22:\"autotag_composite_tags\";s:0:\"\";s:21:\"autotag_tag_rss_feeds\";i:0;s:26:\"autotag_excluded_rss_feeds\";s:0:\"\";s:33:\"autotag_rss_feeds_additional_tags\";s:0:\"\";s:18:\"autotag_tag_prefix\";i:1;s:25:\"autotag_tag_prefix_filter\";i:1;s:25:\"autotag_exclude_usernames\";i:1;s:8:\"lgvdebug\";i:0;s:19:\"boofo_legend_groups\";s:7:\"6,5,7,9\";s:21:\"boofo_legend_location\";s:1:\"7\";s:22:\"boofo_legend_separator\";s:1:\"9\";s:20:\"boofo_legend_display\";s:1:\"0\";s:20:\"boofo_legend_spiders\";i:0;s:24:\"boofo_legend_spiderimage\";i:0;}', 1)
  207.  
  208. # Fri Feb  1 22:17:34 2013
  209. # Query_time: 4.069450  Lock_time: 0.000053 Rows_sent: 0  Rows_examined: 0
  210. use fromthe4_vbulletin;
  211. SET timestamp=1359782254;
  212. INSERT INTO threadviews (threadid)
  213.                 VALUES (64)
  214.  
  215. # Fri Feb  1 22:24:33 2013
  216. # Query_time: 8.214451  Lock_time: 5.749552 Rows_sent: 17  Rows_examined: 17
  217. use fromthe4_vbulletin;
  218. SET timestamp=1359782673;
  219. SELECT *
  220.   FROM datastore
  221.   WHERE title IN ('smiliecache','bbcodecache','mailqueue','bookmarksitecache','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream')
  222.  
  223. # Fri Feb  1 22:25:00 2013
  224. # Query_time: 4.883872  Lock_time: 1.872407 Rows_sent: 1  Rows_examined: 1
  225. use fromthe4_vbulletin;
  226. SET timestamp=1359782700;
  227. SELECT
  228.   userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
  229.   IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
  230.   language.phrasegroup_global AS phrasegroup_global,
  231.   language.phrasegroup_fronthelp AS phrasegroup_fronthelp,
  232.   language.phrasegroup_register AS phrasegroup_register,
  233.   language.phrasegroupinfo AS lang_phrasegroupinfo,
  234.   language.options AS lang_options,
  235.   language.languagecode AS lang_code,
  236.   language.charset AS lang_charset,
  237.   language.locale AS lang_locale,
  238.   language.imagesoverride AS lang_imagesoverride,
  239.   language.dateoverride AS lang_dateoverride,
  240.   language.timeoverride AS lang_timeoverride,
  241.   language.registereddateoverride AS lang_registereddateoverride,
  242.   language.calformat1override AS lang_calformat1override,
  243.   language.calformat2override AS lang_calformat2override,
  244.   language.logdateoverride AS lang_logdateoverride,
  245.   language.decimalsep AS lang_decimalsep,
  246.   language.thousandsep AS lang_thousandsep
  247.   FROM user AS user
  248.                 LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
  249.                 LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
  250.   WHERE user.userid = 962
  251.  
  252. # Fri Feb  1 22:25:04 2013
  253. # Query_time: 4.956537  Lock_time: 0.538070 Rows_sent: 17  Rows_examined: 17
  254. use fromthe4_vbulletin;
  255. SET timestamp=1359782704;
  256. SELECT *
  257.   FROM datastore
  258.   WHERE title IN ('smiliecache','bbcodecache','mailqueue','bookmarksitecache','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream')
  259.  
  260. # Fri Feb  1 22:26:05 2013
  261. # Query_time: 4.844944  Lock_time: 0.000071 Rows_sent: 1  Rows_examined: 1
  262. use fromthe4_vbulletin;
  263. SET timestamp=1359782765;
  264. SELECT *
  265.   FROM datastore
  266.   WHERE title IN ('routes','profilefield')
  267.  
  268. # Fri Feb  1 22:29:49 2013
  269. # Query_time: 9.774725  Lock_time: 2.190685 Rows_sent: 13  Rows_examined: 13
  270. use fromthe4_vbulletin;
  271. SET timestamp=1359782989;
  272. SELECT *
  273.   FROM datastore
  274.   WHERE title IN ('options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream')
  275.  
  276. # Fri Feb  1 22:29:51 2013
  277. # Query_time: 8.213467  Lock_time: 5.888917 Rows_sent: 13  Rows_examined: 13
  278. use fromthe4_vbulletin;
  279. SET timestamp=1359782991;
  280. SELECT *
  281.   FROM datastore
  282.   WHERE title IN ('options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream')
  283.  
  284. # Fri Feb  1 22:30:02 2013
  285. # Query_time: 1.510386  Lock_time: 0.000101 Rows_sent: 0  Rows_examined: 1
  286. use fromthe4_vbulletin;
  287. SET timestamp=1359783002;
  288. UPDATE session
  289.   SET lastactivity = 1359782994, location = '/forums/misc.php?do=resize_images', badlocation = 0, useragent = 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.57 Safari/537.17'
  290.   WHERE sessionhash = 'de60e855b5361da7f9264b594207febd'
  291.  
  292. # Fri Feb  1 22:30:10 2013
  293. # Query_time: 6.259806  Lock_time: 1.594577 Rows_sent: 15  Rows_examined: 15
  294. use fromthe4_vbulletin;
  295. SET timestamp=1359783010;
  296. SELECT *
  297.   FROM datastore
  298.   WHERE title IN ('crondata','mailqueue','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream')
  299.  
  300. # Fri Feb  1 22:30:10 2013
  301. # Query_time: 6.352994  Lock_time: 1.597880 Rows_sent: 15  Rows_examined: 15
  302. SET timestamp=1359783010;
  303. SELECT *
  304.   FROM datastore
  305.   WHERE title IN ('crondata','mailqueue','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream')
  306.  
  307. # Fri Feb  1 22:30:15 2013
  308. # Query_time: 2.637444  Lock_time: 0.197777 Rows_sent: 0  Rows_examined: 1
  309. use fromthe4_vbulletin;
  310. SET timestamp=1359783015;
  311. UPDATE user SET
  312.   profilevisits = profilevisits + 1
  313.   WHERE userid = 134
  314.  
  315. # Fri Feb  1 22:33:11 2013
  316. # Query_time: 28.455287  Lock_time: 0.000089 Rows_sent: 0  Rows_examined: 1
  317. use fromthe4_vbulletin;
  318. SET timestamp=1359783191;
  319. UPDATE session
  320.   SET lastactivity = 1359783161, location = '/forums/archive/index.php/t-190.html', inforum = 17, inthread = 190, badlocation = 0, bypass = 1
  321.   WHERE sessionhash = '4bfa8afa3a76c822da741256184e23f7'
  322.  
  323. # Fri Feb  1 22:33:11 2013
  324. # Query_time: 4.653260  Lock_time: 3.354377 Rows_sent: 1  Rows_examined: 1
  325. use fromthe4_vbulletin;
  326. SET timestamp=1359783191;
  327. SELECT *
  328.   FROM session
  329.   WHERE sessionhash = 'a537eb239d237f734d2f27d76aa27ea6'
  330.   AND lastactivity > 1359782286
  331.   AND idhash = 'f8a0c3c823acd77924a7fde0b5e0eec3'
  332.  
  333. # Fri Feb  1 22:33:13 2013
  334. # Query_time: 2.329058  Lock_time: 0.198874 Rows_sent: 1  Rows_examined: 1
  335. use fromthe4_vbulletin;
  336. SET timestamp=1359783193;
  337. SELECT *
  338.   FROM session
  339.   WHERE sessionhash = 'd48b31dfb779d7ff836ea1d3cfc0df7d'
  340.   AND lastactivity > 1359782289
  341.   AND idhash = 'a6a43ed24213e1e2e712856a0ba21f9d'
  342.  
  343. # Fri Feb  1 22:33:17 2013
  344. # Query_time: 6.387167  Lock_time: 0.000233 Rows_sent: 1  Rows_examined: 1
  345. use fromthe4_vbulletin;
  346. SET timestamp=1359783197;
  347. SELECT
  348.   userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
  349.   IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
  350.   language.phrasegroup_global AS phrasegroup_global,
  351.   language.phrasegroup_posting AS phrasegroup_posting,
  352.   language.phrasegroup_postbit AS phrasegroup_postbit,
  353.   language.phrasegroup_showthread AS phrasegroup_showthread,
  354.   language.phrasegroup_inlinemod AS phrasegroup_inlinemod,
  355.   language.phrasegroup_reputationlevel AS phrasegroup_reputationlevel,
  356.   language.phrasegroupinfo AS lang_phrasegroupinfo,
  357.   language.options AS lang_options,
  358.   language.languagecode AS lang_code,
  359.   language.charset AS lang_charset,
  360.   language.locale AS lang_locale,
  361.   language.imagesoverride AS lang_imagesoverride,
  362.   language.dateoverride AS lang_dateoverride,
  363.   language.timeoverride AS lang_timeoverride,
  364.   language.registereddateoverride AS lang_registereddateoverride,
  365.   language.calformat1override AS lang_calformat1override,
  366.   language.calformat2override AS lang_calformat2override,
  367.   language.logdateoverride AS lang_logdateoverride,
  368.   language.decimalsep AS lang_decimalsep,
  369.   language.thousandsep AS lang_thousandsep
  370.   FROM user AS user
  371.                 LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
  372.                 LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
  373.   WHERE user.userid = 963
  374.  
  375. # Fri Feb  1 22:33:17 2013
  376. # Query_time: 6.550449  Lock_time: 0.186988 Rows_sent: 0  Rows_examined: 1
  377. use fromthe4_vbulletin;
  378. SET timestamp=1359783197;
  379. DELETE FROM strikes WHERE striketime < 1359779573
  380.  
  381. # Fri Feb  1 22:33:25 2013
  382. # Query_time: 7.218512  Lock_time: 2.313530 Rows_sent: 0  Rows_examined: 1
  383. use fromthe4_vbulletin;
  384. SET timestamp=1359783205;
  385. UPDATE user SET
  386.   profilevisits = profilevisits + 1
  387.   WHERE userid = 248
  388.  
  389. # Fri Feb  1 22:33:31 2013
  390. # Query_time: 13.732675  Lock_time: 11.482559 Rows_sent: 10  Rows_examined: 10
  391. use fromthe4_vbulletin;
  392. SET timestamp=1359783211;
  393. SELECT  post.postid, post.attach
  394.   FROM post AS post
  395.   WHERE post.threadid = 177
  396.   AND post.visible = 1
  397.   ORDER BY post.dateline
  398.   LIMIT 0, 10
  399.  
  400. # Fri Feb  1 22:33:31 2013
  401. # Query_time: 6.231092  Lock_time: 0.000181 Rows_sent: 0  Rows_examined: 0
  402. use fromthe4_vbulletin;
  403. SET timestamp=1359783211;
  404. SELECT user.userid, user.username, user.usergroupid, user.displaygroupid, profilevisitor.visible, user.infractiongroupid
  405.   FROM profilevisitor AS profilevisitor
  406.   INNER JOIN user AS user ON (user.userid = profilevisitor.visitorid)
  407.   WHERE profilevisitor.userid = 248
  408.   AND (visible = 1 OR profilevisitor.visitorid = 0)
  409.   ORDER BY profilevisitor.dateline DESC
  410.   LIMIT 10
  411.  
  412. # Fri Feb  1 22:33:50 2013
  413. # Query_time: 32.277681  Lock_time: 13.313425 Rows_sent: 0  Rows_examined: 0
  414. use fromthe4_vbulletin;
  415. SET timestamp=1359783230;
  416. (SELECT permissions, permissions2, FIND_IN_SET(forumid, '8,6,-1') AS pos, forumid
  417.   FROM moderator
  418.   WHERE userid = 963 AND forumid IN (8,6,-1)
  419.   ORDER BY pos ASC
  420.   LIMIT 1)
  421.   UNION
  422.   (SELECT permissions, permissions2, 0, forumid
  423.   FROM moderator
  424.   WHERE userid = 963 AND forumid = -1
  425.   )
  426.  
  427. # Fri Feb  1 22:33:58 2013
  428. # Query_time: 4.608943  Lock_time: 0.000467 Rows_sent: 0  Rows_examined: 0
  429. use fromthe4_vbulletin;
  430. SET timestamp=1359783238;
  431. SELECT *
  432.   FROM session
  433.   WHERE userid = 0
  434.   AND host = '107.3.145.142'
  435.   AND idhash = 'f0c51c6906ba8ee2ce15b27e7a50fac9'
  436.   LIMIT 1
  437.  
  438. # Fri Feb  1 22:34:02 2013
  439. # Query_time: 31.072019  Lock_time: 26.323592 Rows_sent: 1  Rows_examined: 1
  440. use fromthe4_vbulletin;
  441. SET timestamp=1359783242;
  442. SELECT
  443.   userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
  444.   IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
  445.   language.phrasegroup_global AS phrasegroup_global,
  446.   language.phrasegroup_fronthelp AS phrasegroup_fronthelp,
  447.   language.phrasegroup_register AS phrasegroup_register,
  448.   language.phrasegroupinfo AS lang_phrasegroupinfo,
  449.   language.options AS lang_options,
  450.   language.languagecode AS lang_code,
  451.   language.charset AS lang_charset,
  452.   language.locale AS lang_locale,
  453.   language.imagesoverride AS lang_imagesoverride,
  454.   language.dateoverride AS lang_dateoverride,
  455.   language.timeoverride AS lang_timeoverride,
  456.   language.registereddateoverride AS lang_registereddateoverride,
  457.   language.calformat1override AS lang_calformat1override,
  458.   language.calformat2override AS lang_calformat2override,
  459.   language.logdateoverride AS lang_logdateoverride,
  460.   language.decimalsep AS lang_decimalsep,
  461.   language.thousandsep AS lang_thousandsep
  462.   FROM user AS user
  463.                 LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
  464.                 LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
  465.   WHERE user.userid = 961
  466.  
  467. # Fri Feb  1 22:34:02 2013
  468. # Query_time: 9.345375  Lock_time: 4.604258 Rows_sent: 1  Rows_examined: 1
  469. use fromthe4_vbulletin;
  470. SET timestamp=1359783242;
  471. SELECT  post.postid, post.attach
  472.   FROM post AS post
  473.   WHERE post.threadid = 128
  474.   AND post.visible = 1
  475.   ORDER BY post.dateline
  476.   LIMIT 0, 10
  477.  
  478. # Fri Feb  1 22:34:07 2013
  479. # Query_time: 5.419146  Lock_time: 1.011387 Rows_sent: 17  Rows_examined: 17
  480. use fromthe4_vbulletin;
  481. SET timestamp=1359783247;
  482. SELECT *
  483.   FROM datastore
  484.   WHERE title IN ('smiliecache','bbcodecache','banemail','ranks','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream')
  485.  
  486. # Fri Feb  1 22:34:10 2013
  487. # Query_time: 3.418840  Lock_time: 0.750612 Rows_sent: 18  Rows_examined: 18
  488. use fromthe4_vbulletin;
  489. SET timestamp=1359783250;
  490. SELECT *
  491.   FROM datastore
  492.   WHERE title IN ('smiliecache','bbcodecache','blogcategorycache','blogstats','blogfeatured_settings','blogfeatured_entries','blogtagcloud','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream')
  493.  
  494. # Fri Feb  1 22:34:10 2013
  495. # Query_time: 19.745033  Lock_time: 16.801720 Rows_sent: 0  Rows_examined: 0
  496. use fromthe4_vbulletin;
  497. SET timestamp=1359783250;
  498. SELECT SQL_CALC_FOUND_ROWS
  499.   visitormessage.*, user.*, visitormessage.ipaddress AS messageipaddress
  500.   ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom
  501.   FROM visitormessage AS visitormessage
  502.   LEFT JOIN user AS user ON (visitormessage.postuserid = user.userid)
  503.   LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
  504.   WHERE visitormessage.userid = 248
  505.   AND (visitormessage.state IN ('visible'))
  506.   ORDER BY visitormessage.dateline DESC
  507.   LIMIT 0, 10
  508.  
  509. # Fri Feb  1 22:34:10 2013
  510. # Query_time: 7.333917  Lock_time: 4.695852 Rows_sent: 9  Rows_examined: 9
  511. use fromthe4_vbulletin;
  512. SET timestamp=1359783250;
  513. SELECT  post.postid, post.attach
  514.   FROM post AS post
  515.   WHERE post.threadid = 67
  516.   AND post.visible = 1
  517.   ORDER BY post.dateline
  518.   LIMIT 0, 10
  519.  
  520. # Fri Feb  1 22:34:17 2013
  521. # Query_time: 2.253957  Lock_time: 0.050302 Rows_sent: 17  Rows_examined: 17
  522. use fromthe4_vbulletin;
  523. SET timestamp=1359783257;
  524. SELECT *
  525.   FROM datastore
  526.   WHERE title IN ('smiliecache','bbcodecache','banemail','ranks','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream')
  527.  
  528. # Fri Feb  1 22:34:20 2013
  529. # Query_time: 2.527203  Lock_time: 0.050107 Rows_sent: 2  Rows_examined: 2
  530. use fromthe4_vbulletin;
  531. SET timestamp=1359783260;
  532. SELECT *
  533.   FROM datastore
  534.   WHERE title IN ('dbtech_gallery_instances','dbtech_gallery_modules','profilefield')
  535.  
  536. # Fri Feb  1 22:34:24 2013
  537. # Query_time: 2.864635  Lock_time: 0.003749 Rows_sent: 0  Rows_examined: 0
  538. use fromthe4_vbulletin;
  539. SET timestamp=1359783264;
  540. SELECT relationid
  541.   FROM userlist
  542.   WHERE
  543.   userid IN (651)
  544.   AND
  545.   type = 'buddy'
  546.   AND
  547.   friend = 'yes'
  548.  
  549. # Fri Feb  1 22:36:23 2013
  550. # Query_time: 1.909410  Lock_time: 0.050379 Rows_sent: 1  Rows_examined: 1
  551. use fromthe4_vbulletin;
  552. SET timestamp=1359783383;
  553. SELECT
  554.   userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
  555.   IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
  556.   language.phrasegroup_global AS phrasegroup_global,
  557.   language.phrasegroup_user AS phrasegroup_user,
  558.   language.phrasegroup_timezone AS phrasegroup_timezone,
  559.   language.phrasegroup_posting AS phrasegroup_posting,
  560.   language.phrasegroup_cprofilefield AS phrasegroup_cprofilefield,
  561.   language.phrasegroup_cppermission AS phrasegroup_cppermission,
  562.   language.phrasegroupinfo AS lang_phrasegroupinfo,
  563.   language.options AS lang_options,
  564.   language.languagecode AS lang_code,
  565.   language.charset AS lang_charset,
  566.   language.locale AS lang_locale,
  567.   language.imagesoverride AS lang_imagesoverride,
  568.   language.dateoverride AS lang_dateoverride,
  569.   language.timeoverride AS lang_timeoverride,
  570.   language.registereddateoverride AS lang_registereddateoverride,
  571.   language.calformat1override AS lang_calformat1override,
  572.   language.calformat2override AS lang_calformat2override,
  573.   language.logdateoverride AS lang_logdateoverride,
  574.   language.decimalsep AS lang_decimalsep,
  575.   language.thousandsep AS lang_thousandsep
  576.   FROM user AS user
  577.                 LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
  578.                 LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
  579.   WHERE user.userid = 961
  580.  
  581. # Fri Feb  1 22:36:24 2013
  582. # Query_time: 1.262158  Lock_time: 0.101262 Rows_sent: 11  Rows_examined: 737
  583. use fromthe4_vbulletin;
  584. SET timestamp=1359783384;
  585. SELECT avatar.*, imagecategory.title AS category
  586.   FROM avatar AS avatar LEFT JOIN imagecategory AS imagecategory USING(imagecategoryid)
  587.   WHERE minimumposts <= 0
  588.   AND avatar.imagecategoryid=3
  589.   AND avatarid <> 0
  590.   ORDER BY avatar.displayorder
  591.   LIMIT 200,50
  592.  
  593. # Fri Feb  1 22:37:16 2013
  594. # Query_time: 30.880093  Lock_time: 0.000104 Rows_sent: 0  Rows_examined: 1
  595. use fromthe4_vbulletin;
  596. SET timestamp=1359783436;
  597. UPDATE user SET
  598.   profilevisits = profilevisits + 1
  599.   WHERE userid = 147
  600.  
  601. # Fri Feb  1 22:42:30 2013
  602. # Query_time: 1.622278  Lock_time: 0.005433 Rows_sent: 70  Rows_examined: 2280
  603. use fromthe4_vbulletin;
  604. SET timestamp=1359783750;
  605. SELECT tagsearch.tagid, COUNT(*) AS searchcount
  606.   FROM tagsearch AS tagsearch
  607.   WHERE tagsearch.dateline > 1357191746
  608.   GROUP BY tagsearch.tagid
  609.   ORDER BY searchcount DESC
  610.   LIMIT 70
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top