6oct
12-07-2008, 09:09 PM
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!!!!!!!!
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)
--------------- Added 1228691408 at 1228691408 ---------------
there is much more logs from the mysql processlist
but the forum cant accept more char !
WHT vulnerability the vbulletin came with this time!!
version 3.7.4
Server load reached 90!!!!!!!!
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)
--------------- Added 1228691408 at 1228691408 ---------------
there is much more logs from the mysql processlist
but the forum cant accept more char !