The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
facing a massive database connecetion causing my server to be down !!
WHT vulnerability the vbulletin came with this time!! version 3.7.4 Server load reached 90!!!!!!!! Code:
UHyyuh localhost jarabhar_vb Query 43 Locked ( select u.userid, u.username\nfrom user u\nwhere u.userid in ('1268') ) 70523 jarabhar_JUHyyuh localhost jarabhar_vb Query 159 Copying to tmp table SELECT COUNT(post.dateline) AS postcount, post.userid, user.username \n\t\t\tFROM post AS post \n\t\t\tLEFT 70517 jarabhar_JUHyyuh localhost jarabhar_vb Query 104 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678800, location = '/forum/showthread.php?t=88758', inthr 70516 jarabhar_JUHyyuh localhost jarabhar_vb Query 90 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678800, location = '/forum/showthread.php?t=57861&pag 70590 jarabhar_JUHyyuh localhost jarabhar_vb Query 106 Locked UPDATE user\n\t\t\t\t\t\tSET lastactivity = 1228678815\n\t\t\t\t\t\tWHERE userid = 11122713 70611 jarabhar_JUHyyuh localhost jarabhar_vb Query 105 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678818, location = '/forum/showthread.php?t=67507', inthr 70650 jarabhar_JUHyyuh localhost jarabhar_vb Query 54 Locked SELECT userid, username FROM user\n\t\t\tWHERE userid != 0\n\t\t\tAND\n\t\t\t(\n\t\t\t\tusername = 'king78'\n\t\t\t\tOR\n\t\t 70655 jarabhar_JUHyyuh localhost jarabhar_vb Query 85 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678826, location = '/forum/showthread.php?t=103933', logg 70662 jarabhar_JUHyyuh localhost jarabhar_vb Query 101 Locked INSERT IGNORE INTO session\n\t\t\t\t\t(sessionhash, userid, host, idhash, lastactivity, location, styleid, 70674 jarabhar_JUHyyuh localhost jarabhar_vb Query 103 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678829, location = '/forum/showthread.php?t=88702', inthr 70681 jarabhar_JUHyyuh localhost jarabhar_vb Query 103 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678829, location = '/forum/showthread.php?t=88702', inthr 70684 jarabhar_JUHyyuh localhost jarabhar_vb Query 94 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678830, location = '/forum/forumdisplay.php?f=46', inthre 70688 jarabhar_JUHyyuh localhost jarabhar_vb Query 103 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678831, location = '/forum/showthread.php?t=88702', inthr 70694 jarabhar_JUHyyuh localhost jarabhar_vb Query 103 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678832, location = '/forum/showthread.php?t=88702', inthr 70700 jarabhar_JUHyyuh localhost jarabhar_vb Query 103 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678832, location = '/forum/showthread.php?t=88702', inthr 70699 jarabhar_JUHyyuh localhost jarabhar_vb Query 101 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678832, location = '/forum/showthread.php?t=42181', infor 70738 jarabhar_JUHyyuh localhost jarabhar_vb Query 102 Locked INSERT IGNORE INTO session\n\t\t\t\t\t(sessionhash, userid, host, idhash, lastactivity, location, styleid, 70740 jarabhar_JUHyyuh localhost jarabhar_vb Query 101 Locked ( select u.userid, u.username\nfrom user u\nwhere u.userid in ('159100') ) 70753 jarabhar_JUHyyuh localhost jarabhar_vb Query 101 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678839, location = '/forum/showthread.php?t=86882', incal 70766 jarabhar_JUHyyuh localhost jarabhar_vb Query 98 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678840, location = '/forum/forumdisplay.php?f=14', inforu 70778 jarabhar_JUHyyuh localhost jarabhar_vb Query 105 Locked ( select u.userid, u.username\nfrom user u\nwhere u.userid in ('11111253','11122736','163312','10786 70780 jarabhar_JUHyyuh localhost jarabhar_vb Query 103 Locked SELECT\n\t\t\tannouncement.announcementid, startdate, title, announcement.views,\n\t\t\tuser.username, user. 70788 jarabhar_JUHyyuh localhost jarabhar_vb Query 103 Locked SELECT\n\t\t\tannouncement.announcementid, startdate, title, announcement.views,\n\t\t\tuser.username, user. 70789 jarabhar_JUHyyuh localhost jarabhar_vb Query 103 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70790 jarabhar_JUHyyuh localhost jarabhar_vb Query 105 Locked ( select u.userid, u.username\nfrom user u\nwhere u.userid in ('11111253','11122736','163312','10786 70794 jarabhar_JUHyyuh localhost jarabhar_vb Query 67 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70796 jarabhar_JUHyyuh localhost jarabhar_vb Query 93 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678845, inforum = 0, inthread = 0, incalendar = 0, badloc 70806 jarabhar_JUHyyuh localhost jarabhar_vb Query 97 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70807 jarabhar_JUHyyuh localhost jarabhar_vb Query 95 Locked SELECT post.pagetext AS preview,\n\t\t\t\tthread.threadid, thread.threadid AS postid, thread.title AS thr 70810 jarabhar_JUHyyuh localhost jarabhar_vb Query 95 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70821 jarabhar_JUHyyuh localhost jarabhar_vb Query 94 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70824 jarabhar_JUHyyuh localhost jarabhar_vb Query 103 Locked SELECT\n\t\t\tannouncement.announcementid, startdate, title, announcement.views,\n\t\t\tuser.username, user. 70831 jarabhar_JUHyyuh localhost jarabhar_vb Query 103 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70833 jarabhar_JUHyyuh localhost jarabhar_vb Query 104 Locked SELECT moderator.*, user.username,\n\t\tIF(user.displaygroupid = 0, user.usergroupid, user.displaygroup 70836 jarabhar_JUHyyuh localhost jarabhar_vb Query 101 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70838 jarabhar_JUHyyuh localhost jarabhar_vb Query 105 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70842 jarabhar_JUHyyuh localhost jarabhar_vb Query 105 Locked SELECT\n\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70844 jarabhar_JUHyyuh localhost jarabhar_vb Query 97 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70846 jarabhar_JUHyyuh localhost jarabhar_vb Query 94 Locked SELECT userid AS primarykey, lastpost AS readcolumn\n\t\t\tFROM user AS user\n\t\t\tWHERE userid = 145377\n\t\t 70847 jarabhar_JUHyyuh localhost jarabhar_vb Query 105 Locked SELECT\n\t\t\tuser.username, (user.options & 512) AS invisible, user.usergroupid,\n\t\t\tsession.userid, ses 70869 jarabhar_JUHyyuh localhost jarabhar_vb Query 89 Locked SELECT post.pagetext AS preview,\n\t\t\t\tthread.threadid, thread.threadid AS postid, thread.title AS thr 70871 jarabhar_JUHyyuh localhost jarabhar_vb Query 100 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70875 jarabhar_JUHyyuh localhost jarabhar_vb Query 102 Locked INSERT IGNORE INTO session\n\t\t\t\t\t(sessionhash, userid, host, idhash, lastactivity, location, styleid, 70876 jarabhar_JUHyyuh localhost jarabhar_vb Query 103 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70879 jarabhar_JUHyyuh localhost jarabhar_vb Query 97 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70888 jarabhar_JUHyyuh localhost jarabhar_vb Query 103 Locked SELECT\n\t\t\tannouncement.announcementid, startdate, title, announcement.views,\n\t\t\tuser.username, user. 70890 jarabhar_JUHyyuh localhost jarabhar_vb Query 103 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70893 jarabhar_JUHyyuh localhost jarabhar_vb Query 105 Locked ( select u.userid, u.username\nfrom user u\nwhere u.userid in ('11111253','11122736','163312','10786 70896 jarabhar_JUHyyuh localhost jarabhar_vb Query 99 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70898 jarabhar_JUHyyuh localhost jarabhar_vb Query 103 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678874, location = '/forum/showthread.php?t=88702', inthr 70903 jarabhar_JUHyyuh localhost jarabhar_vb Query 103 Locked SELECT\n\t\t\tannouncement.announcementid, startdate, title, announcement.views,\n\t\t\tuser.username, user. 70904 jarabhar_JUHyyuh localhost jarabhar_vb Query 104 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70905 jarabhar_JUHyyuh localhost jarabhar_vb Query 104 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70913 jarabhar_JUHyyuh localhost jarabhar_vb Query 69 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70917 jarabhar_JUHyyuh localhost jarabhar_vb Query 105 Locked SELECT moderator.*, user.username,\n\t\tIF(user.displaygroupid = 0, user.usergroupid, user.displaygroup 70926 jarabhar_JUHyyuh localhost jarabhar_vb Query 103 Locked SELECT moderator.*, user.username,\n\t\tIF(user.displaygroupid = 0, user.usergroupid, user.displaygroup 70931 animal2 localhost animal2_vb2 Query 15 closing tables UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678879, location = '/showthread.php?t=2366', inforum = 52 70940 jarabhar_JUHyyuh localhost jarabhar_vb Query 105 Sorting result SELECT post.postid\n\t\t\tFROM post AS post\n\t\t\t\n\t\t\tWHERE post.threadid = 57861\n\t\t\t\tAND post.visible = 1\n 70941 jarabhar_JUHyyuh localhost jarabhar_vb Query 105 Locked ( select u.userid, u.username\nfrom user u\nwhere u.userid in ('11111253','11122736','163312','10786 70945 jarabhar_JUHyyuh localhost jarabhar_vb Query 105 Locked ( select u.userid, u.username\nfrom user u\nwhere u.userid in ('11111253','11122736','163312','10786 70947 jarabhar_JUHyyuh localhost jarabhar_vb Query 101 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678884, location = '/forum/search.php?do=finduser&use 70948 jarabhar_JUHyyuh localhost jarabhar_vb Query 106 Locked SELECT \n\t\t\tuserfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user. 70950 jarabhar_JUHyyuh localhost jarabhar_vb Query 99 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70952 jarabhar_JUHyyuh localhost jarabhar_vb Query 69 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70958 jarabhar_JUHyyuh localhost jarabhar_vb Query 102 Locked SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE sessionhash = 'e422f3326c9e04e4db3b4fc80bc6ed65'\n\t\t\t\t\tAND lastac 70962 jarabhar_JUHyyuh localhost jarabhar_vb Query 103 Locked SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '74.6.8.91'\n\t\t\t\t\tAND idhash = '8391e2 70963 animal2 localhost animal2_vb2 Query 12 Opening tables SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user 70964 jarabhar_JUHyyuh localhost jarabhar_vb Query 103 Locked SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '94.98.101.212'\n\t\t\t\t\tAND idhash = '64 70966 hakarrr localhost hakarrr_vb2 Query 90 Sorting result SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las 70967 hakarrr localhost hakarrr_vb2 Query 13 Opening tables SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS 70968 jarabhar_JUHyyuh localhost jarabhar_vb Query 101 Locked SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '61.247.222.53'\n\t\t\t\t\tAND idhash = 'a9 70974 jarabhar_JUHyyuh localhost jarabhar_vb Query 98 Locked SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '41.214.131.149'\n\t\t\t\t\tAND idhash = 'c 70976 jarabhar_JUHyyuh localhost jarabhar_vb Query 98 Locked SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '41.235.61.127'\n\t\t\t\t\tAND idhash = '6d 70975 jarabhar_JUHyyuh localhost jarabhar_vb Query 98 Locked select userid from user where username like "cassaei cacaea" limit 1 70977 animal2 localhost animal2_vb2 Query 11 Writing to net SELECT title, template\n\t\t\tFROM template\n\t\t\tWHERE templateid IN (3796,3657,3882,3883,3886,3887,3888,3 70978 hakarrr localhost hakarrr_vb2 Query 13 Opening tables UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678894, incalendar = 0, badlocation = 0\n\t\t\t\t\tWHERE sessio 70979 animal2 localhost animal2_vb2 Query 17 closing tables SELECT *\n\t\tFROM style\n\t\tWHERE (styleid = 22 AND userselect = 1)\n\t\t\tOR styleid = 22\n\t\tORDER BY stylei 70980 jarabhar_JUHyyuh localhost jarabhar_vb Query 98 Locked SELECT \n\t\t\tuserfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user. 70971 animal2 localhost animal2_vb2 Query 12 Sorting result SELECT userid, usergroupid, displaygroupid, username, posts \n\t\t\t\t\t\tFROM user AS user \n\t\t\t\t\t\tWHERE po 70982 animal2 localhost animal2_vb2 Query 97 closing tables SELECT \n\t\t\tuserfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user. 70983 jarabhar_JUHyyuh localhost jarabhar_vb Query 97 Locked SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '82.114.174.57'\n\t\t\t\t\tAND idhash = 'f1 70984 jarabhar_JUHyyuh localhost jarabhar_vb Query 96 Locked select userid from user where username like "oin cauiae" limit 1 70985 animal2 localhost animal2_vb2 Query 11 Opening tables SELECT *\n\t\tFROM style\n\t\tWHERE (styleid = 22 AND userselect = 1)\n\t\t\tOR styleid = 22\n\t\tORDER BY stylei 70986 jarabhar_JUHyyuh localhost jarabhar_vb Query 95 Locked SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '41.235.61.127'\n\t\t\t\t\tAND idhash = '6d 70994 jarabhar_JUHyyuh localhost jarabhar_vb Query 94 Locked SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE sessionhash = '13181b98c8b8b18f2b6adfcc64b63a03'\n\t\t\t\t\tAND lastac 70995 jarabhar_JUHyyuh localhost jarabhar_vb Query 93 Locked SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE sessionhash = 'b0ce577d5f9a5507975229eb7489ac37'\n\t\t\t\t\tAND lastac 70998 jarabhar_JUHyyuh localhost jarabhar_vb Query 93 Locked select userid from user where username like "thewizard0" limit 1 70996 jarabhar_JUHyyuh localhost jarabhar_vb Query 93 Locked SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '91.144.0.100'\n\t\t\t\t\tAND idhash = '1d0 71000 jarabhar_JUHyyuh localhost jarabhar_vb Query 93 Locked SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE sessionhash = '07ca51b433a2306341efb9467a4a7b98'\n\t\t\t\t\tAND lastac 71003 s7aba_vb localhost s7aba_vb Query 13 Opening tables SELECT userselect_tag, opentag_user, closetag_user \n\t\tFROM user AS user \n\t\tWHERE username = '??? 71005 jarabhar_JUHyyuh localhost jarabhar_vb Query 92 Locked select userid from user where username like "tech\\_admin" limit 1 71009 jarabhar_JUHyyuh localhost jarabhar_vb Query 92 Locked SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '65.111.177.102'\n\t\t\t\t\tAND idhash = '8 71010 jarabhar_JUHyyuh localhost jarabhar_vb Query 91 Locked SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE sessionhash = '8ef6de648114e052ab55edaa5313b2e9'\n\t\t\t\t\tAND lastac 71011 s7aba_vb localhost s7aba_vb Query 12 Sorting result SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las 71012 jarabhar_JUHyyuh localhost jarabhar_vb Query 91 Locked SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '87.230.141.175'\n\t\t\t\t\tAND idhash = '2 71013 hakarrr localhost hakarrr_vb2 Query 90 Sorting result SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las 71015 jarabhar_JUHyyuh localhost jarabhar_vb Query 91 Locked SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '41.232.198.251'\n\t\t\t\t\tAND idhash = '8 71017 qwaihco_vbuser localhost qwaihco_vb35 Query 3 Opening tables SELECT COUNT(threadid) AS total FROM thread WHERE postuserid=214 71022 jarabhar_JUHyyuh localhost jarabhar_vb Query 84 Locked SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE sessionhash = '57f70d252d4b446441774e31304af94b'\n\t\t\t\t\tAND lastac 71024 animal2 localhost animal2_vb2 Query 11 Opening tables SELECT userid, usergroupid, displaygroupid, username, posts \n\t\t\t\t\t\tFROM user AS user \n\t\t\t\t\t\tWHERE po 71026 jarabhar_JUHyyuh localhost jarabhar_vb Query 81 Locked SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE sessionhash = '57f70d252d4b446441774e31304af94b'\n\t\t\t\t\tAND lastac 71033 jarabhar_JUHyyuh localhost jarabhar_vb Query 64 Locked SELECT *\n\t\t\t\tFROM session\n\t\t\t\tWHERE userid = 0\n\t\t\t\t\tAND host = '41.233.230.191'\n\t\t\t\t\tAND idhash = '2 71035 jarabhar_JUHyyuh localhost jarabhar_vb Query 15 Opening tables REPLACE INTO datastore\n\t\t\t\t(title, data, unserialize)\n\t\t\tVALUES\n\t\t\t\t('cron', '1228679100', 0) there is much more logs from the mysql processlist but the forum cant accept more char ! |
#2
|
|||
|
|||
![]() Quote:
|
#3
|
|||
|
|||
![]()
i didnt made any modification and have disabled all the addons and hacks...
this is a fresh vbulletin copy 3.7.4 installed and using vbSEO |
#4
|
|||
|
|||
![]()
vBSEO is a modification.
![]() |
#5
|
|||
|
|||
![]()
ok i'll disable it...
|
#6
|
||||
|
||||
![]()
Are you getting vb database error emails, about connections?
|
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|