Thursday, October 3, 2024

Moutain Time: || Universal Time:

Profile Information:
Last Seen:
Wed Jan 31, 2024 3:19 pm on
Manage Console Categories

Date Recruited:
Tue Dec 19, 2023 8:41 pm

Profile Views: 316

Birthday:
Jan 1, 1970

Age: 54
User Information
Username: admin
Rank: Administrator
Recruited By: Website Admin
Recruits: 0
Last Log In: Wed Jan 31, 2024 3:05 pm
Times Logged In: 27
Last Promotion: Never Promoted
Last Demotion: Never Demoted
Days In Clan: 289
Personal Information
Gender: Alien
First Name: Not Set
Last Name: Not Set
Game Statistics
Stellaris: Wins:
Losses:

Medals

Powered By: BlueThrust Clan Scripts v5
Based On: Bluethrust Clan Scripts v4
© Copyright 2024 Welcome to Zarks Fallen Angels :: Home of the most feared Zark fraggers around
SQL Queries: 104

Debug mode is on. To turn off these notifications, please go to My Account -> Administrator Options -> Website Settings -> Debug Mode and set to "Off"

PHP Version: 8.1.20
Queries: 104

$_SESSION

Variable Value
$_SESSION['csrfKey'] '5f70f9e5bb5a4e39e9a667b38b169ec2'
$_SESSION['appendIP'] '1e6af22b28'

5 Most Repeated Queries

Count Query Stack Trace Of 1 Random Query
1 DELETE FROM ipban WHERE exptime != '0' AND exptime < '1728000695' [Click To Show]
1 OPTIMIZE TABLE `ipban` [Click To Show]
1 SELECT * FROM clocks [Click To Show]
1 SELECT * FROM console [Click To Show]
1 SELECT * FROM console [Click To Show]

5 Slowest Queries

# Seconds Query Stack Trace
1 0.001 SELECT * FROM hitcounter WHERE ipaddress = '44.220.184.63' [Click To Show]
2 0.001 SELECT social_members.* FROM social_members, social WHERE social.social_id = social_members.social_id AND social_members.member_id = '1' AND social_members.value != '' ORDER BY social.ordernum DESC [Click To Show]
3 0 SELECT * FROM ipban WHERE ipaddress = '44.220.184.63' [Click To Show]
4 0 SELECT * FROM ipban WHERE ipaddress LIKE '%*%' AND (exptime > '1728000695' OR exptime = '0') [Click To Show]
5 0 DELETE FROM ipban WHERE exptime != '0' AND exptime < '1728000695' [Click To Show]

Query List - Order Of Execution

# Seconds Query Stack Trace
1 0 SELECT * FROM ipban WHERE ipaddress = '44.220.184.63' [Click To Show]
2 0 SELECT * FROM ipban WHERE ipaddress LIKE '%*%' AND (exptime > '1728000695' OR exptime = '0') [Click To Show]
3 0 DELETE FROM ipban WHERE exptime != '0' AND exptime < '1728000695' [Click To Show]
4 0 OPTIMIZE TABLE `ipban` [Click To Show]
5 0 SELECT * FROM plugin_pages WHERE page = 'mods' ORDER BY sortnum [Click To Show]
6 0 SELECT * FROM clocks [Click To Show]
7 0 SELECT * FROM console [Click To Show]
8 0 SELECT * FROM consolecategory [Click To Show]
9 0 SELECT * FROM gamesplayed [Click To Show]
10 0 SELECT * FROM menu_category [Click To Show]
11 0 SELECT * FROM menu_item [Click To Show]
12 0 SELECT * FROM menuitem_link [Click To Show]
13 0 SELECT * FROM rankcategory [Click To Show]
14 0 SELECT * FROM ranks [Click To Show]
15 0 SELECT * FROM console_members [Click To Show]
16 0 SELECT * FROM rank_privileges [Click To Show]
17 0 SELECT * FROM console [Click To Show]
18 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]
19 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]
20 0 SELECT * FROM medals WHERE autodays != '0' OR autorecruits != '0' ORDER BY ordernum DESC [Click To Show]
21 0 SELECT * FROM medals WHERE medal_id = '6' [Click To Show]
22 0 SELECT * FROM medals_members WHERE medal_id = '6' [Click To Show]
23 0 SELECT * FROM freezemedals_members WHERE medal_id = '6' [Click To Show]
24 0 SELECT * FROM medals WHERE medal_id = '8' [Click To Show]
25 0 SELECT * FROM medals_members WHERE medal_id = '8' [Click To Show]
26 0 SELECT * FROM freezemedals_members WHERE medal_id = '8' [Click To Show]
27 0 SELECT rank_id FROM ranks WHERE autodays != '0' ORDER BY ordernum DESC [Click To Show]
28 0 SELECT * FROM membersonlypage WHERE pageurl = 'zarksfallenangels.com/profile.php?mID=1' [Click To Show]
29 0.001 SELECT * FROM hitcounter WHERE ipaddress = '44.220.184.63' [Click To Show]
30 0 SELECT * FROM hitcounter WHERE hit_id = '4451' [Click To Show]
31 0 SELECT * FROM hitcounter WHERE hit_id = '4451' [Click To Show]
32 0 SELECT tablename FROM tableupdates WHERE tablename = 'hitcounter' [Click To Show]
33 0 UPDATE tableupdates SET updatetime = '1728000695' WHERE tablename = 'hitcounter' [Click To Show]
34 0 SELECT * FROM members WHERE username = '' [Click To Show]
35 0 SELECT menucategory_id FROM menu_category WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND section = '2' ORDER BY sortnum [Click To Show]
36 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '24' ORDER BY sortnum [Click To Show]
37 0 SELECT menucategory_id FROM menu_category WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND section = '0' ORDER BY sortnum [Click To Show]
38 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '17' ORDER BY sortnum [Click To Show]
39 0 SELECT * FROM menuitem_custompage WHERE menucustompage_id = '10' [Click To Show]
40 0 SELECT * FROM custompages WHERE custompage_id = '11' [Click To Show]
41 0 SELECT * FROM menuitem_custompage WHERE menucustompage_id = '11' [Click To Show]
42 0 SELECT * FROM custompages WHERE custompage_id = '12' [Click To Show]
43 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '29' ORDER BY sortnum [Click To Show]
44 0 SELECT * FROM gamesplayed ORDER BY ordernum DESC [Click To Show]
45 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '16' ORDER BY sortnum [Click To Show]
46 0 SELECT * FROM polls WHERE poll_id = '1' [Click To Show]
47 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '5' ORDER BY sortnum [Click To Show]
48 0 SELECT forumpost_id FROM forum_post ORDER BY dateposted DESC [Click To Show]
49 0 SELECT * FROM forum_post WHERE forumpost_id = '4' [Click To Show]
50 0 SELECT * FROM forum_topic WHERE forumtopic_id = '4' [Click To Show]
51 0 SELECT * FROM forum_board WHERE forumboard_id = '4' [Click To Show]
52 0 SELECT * FROM forum_post WHERE forumpost_id = '4' [Click To Show]
53 0 SELECT * FROM forum_topic WHERE forumtopic_id = '4' [Click To Show]
54 0 SELECT * FROM forum_topic WHERE forumtopic_id = '4' [Click To Show]
55 0 SELECT * FROM forum_post WHERE forumpost_id = '4' [Click To Show]
56 0 SELECT * FROM forum_post WHERE forumpost_id = '4' [Click To Show]
57 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]
58 0 SELECT * FROM forum_post WHERE forumtopic_id = '4' ORDER BY dateposted [Click To Show]
59 0 SELECT * FROM forum_post WHERE forumtopic_id = '4' AND dateposted <= '1705894179' [Click To Show]
60 0 SELECT menucategory_id FROM menu_category WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND section = '1' ORDER BY sortnum [Click To Show]
61 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '1' ORDER BY sortnum [Click To Show]
62 0 SELECT * FROM menuitem_shoutbox WHERE menushoutbox_id = '1' [Click To Show]
63 0 SELECT * FROM members WHERE username = '' [Click To Show]
64 0 SELECT * FROM news WHERE newstype = '3' ORDER BY dateposted [Click To Show]
65 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '4' ORDER BY sortnum [Click To Show]
66 0 SELECT member_id FROM members WHERE rank_id != '1' AND disabled = '0' ORDER BY datejoined DESC LIMIT 5 [Click To Show]
67 0 SELECT clock_id FROM clocks ORDER BY ordernum DESC [Click To Show]
68 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]
69 0.001 SELECT social_members.* FROM social_members, social WHERE social.social_id = social_members.social_id AND social_members.member_id = '1' AND social_members.value != '' ORDER BY social.ordernum DESC [Click To Show]
70 0 SELECT * FROM members WHERE member_id = '0' [Click To Show]
71 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]
72 0 SELECT * FROM members WHERE recruiter = '1' AND disabled = '0' [Click To Show]
73 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]
74 0 SELECT * FROM plugin_pages WHERE page = 'profile' ORDER BY sortnum [Click To Show]
75 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]
76 0 SELECT * FROM profilecategory ORDER BY ordernum DESC [Click To Show]
77 0 SELECT * FROM profilecategory WHERE profilecategory_id = '1' [Click To Show]
78 0 SELECT * FROM profileoptions WHERE profilecategory_id = '1' ORDER BY sortnum [Click To Show]
79 0 SELECT * FROM profileoptions WHERE profileoption_id = '3' [Click To Show]
80 0 SELECT * FROM profileoptions_values WHERE member_id = '1' AND profileoption_id = '3' [Click To Show]
81 0 SELECT * FROM profileoptions WHERE profileoption_id = '3' [Click To Show]
82 0 SELECT * FROM profileoptions_select WHERE selectopt_id = '13' [Click To Show]
83 0 SELECT * FROM profileoptions WHERE profileoption_id = '2' [Click To Show]
84 0 SELECT * FROM profileoptions_values WHERE member_id = '1' AND profileoption_id = '2' [Click To Show]
85 0 SELECT * FROM profileoptions WHERE profileoption_id = '2' [Click To Show]
86 0 SELECT * FROM profileoptions WHERE profileoption_id = '6' [Click To Show]
87 0 SELECT * FROM profileoptions_values WHERE member_id = '1' AND profileoption_id = '6' [Click To Show]
88 0 SELECT * FROM profileoptions WHERE profileoption_id = '6' [Click To Show]
89 0 SELECT * FROM gamesplayed ORDER BY ordernum DESC [Click To Show]
90 0 SELECT * FROM gamesplayed_members WHERE gamesplayed_id = '5' AND member_id = '1' [Click To Show]
91 0 SELECT * FROM gamestats WHERE gamesplayed_id = '5' ORDER BY ordernum [Click To Show]
92 0 SELECT * FROM gamestats WHERE gamestats_id = '4' [Click To Show]
93 0 SELECT * FROM gamestats WHERE gamestats_id = '4' [Click To Show]
94 0 SELECT * FROM gamestats_members WHERE member_id = '1' AND gamestats_id = '4' [Click To Show]
95 0 SELECT * FROM gamestats WHERE gamestats_id = '5' [Click To Show]
96 0 SELECT * FROM gamestats WHERE gamestats_id = '5' [Click To Show]
97 0 SELECT * FROM gamestats_members WHERE member_id = '1' AND gamestats_id = '5' [Click To Show]
98 0 SELECT * FROM gamesplayed_members WHERE gamesplayed_id = '7' AND member_id = '1' [Click To Show]
99 0 SELECT * FROM squads_members WHERE member_id = '1' [Click To Show]
100 0 SELECT * FROM medals_members mm, medals m WHERE member_id = '1' AND m.medal_id = mm.medal_id ORDER BY m.ordernum DESC [Click To Show]
101 0 SELECT * FROM medals WHERE medal_id = '6' [Click To Show]
102 0 SELECT * FROM medals_members WHERE member_id = '1' AND medal_id = '6' [Click To Show]
103 0 SELECT * FROM medals WHERE medal_id = '8' [Click To Show]
104 0 SELECT * FROM medals_members WHERE member_id = '1' AND medal_id = '8' [Click To Show]

Query List - Alphabetical

# Seconds Query Stack Trace
1 0 DELETE FROM ipban WHERE exptime != '0' AND exptime < '1728000695' [Click To Show]
2 0 OPTIMIZE TABLE `ipban` [Click To Show]
3 0 SELECT * FROM clocks [Click To Show]
4 0 SELECT * FROM console [Click To Show]
5 0 SELECT * FROM console [Click To Show]
6 0 SELECT * FROM console_members [Click To Show]
7 0 SELECT * FROM consolecategory [Click To Show]
8 0 SELECT * FROM custompages WHERE custompage_id = '11' [Click To Show]
9 0 SELECT * FROM custompages WHERE custompage_id = '12' [Click To Show]
10 0 SELECT * FROM forum_board WHERE forumboard_id = '4' [Click To Show]
11 0 SELECT * FROM forum_post WHERE forumpost_id = '4' [Click To Show]
12 0 SELECT * FROM forum_post WHERE forumpost_id = '4' [Click To Show]
13 0 SELECT * FROM forum_post WHERE forumpost_id = '4' [Click To Show]
14 0 SELECT * FROM forum_post WHERE forumpost_id = '4' [Click To Show]
15 0 SELECT * FROM forum_post WHERE forumtopic_id = '4' AND dateposted <= '1705894179' [Click To Show]
16 0 SELECT * FROM forum_post WHERE forumtopic_id = '4' ORDER BY dateposted [Click To Show]
17 0 SELECT * FROM forum_topic WHERE forumtopic_id = '4' [Click To Show]
18 0 SELECT * FROM forum_topic WHERE forumtopic_id = '4' [Click To Show]
19 0 SELECT * FROM forum_topic WHERE forumtopic_id = '4' [Click To Show]
20 0 SELECT * FROM freezemedals_members WHERE medal_id = '6' [Click To Show]
21 0 SELECT * FROM freezemedals_members WHERE medal_id = '8' [Click To Show]
22 0 SELECT * FROM gamesplayed [Click To Show]
23 0 SELECT * FROM gamesplayed ORDER BY ordernum DESC [Click To Show]
24 0 SELECT * FROM gamesplayed ORDER BY ordernum DESC [Click To Show]
25 0 SELECT * FROM gamesplayed_members WHERE gamesplayed_id = '5' AND member_id = '1' [Click To Show]
26 0 SELECT * FROM gamesplayed_members WHERE gamesplayed_id = '7' AND member_id = '1' [Click To Show]
27 0 SELECT * FROM gamestats WHERE gamesplayed_id = '5' ORDER BY ordernum [Click To Show]
28 0 SELECT * FROM gamestats WHERE gamestats_id = '4' [Click To Show]
29 0 SELECT * FROM gamestats WHERE gamestats_id = '4' [Click To Show]
30 0 SELECT * FROM gamestats WHERE gamestats_id = '5' [Click To Show]
31 0 SELECT * FROM gamestats WHERE gamestats_id = '5' [Click To Show]
32 0 SELECT * FROM gamestats_members WHERE member_id = '1' AND gamestats_id = '4' [Click To Show]
33 0 SELECT * FROM gamestats_members WHERE member_id = '1' AND gamestats_id = '5' [Click To Show]
34 0 SELECT * FROM hitcounter WHERE hit_id = '4451' [Click To Show]
35 0 SELECT * FROM hitcounter WHERE hit_id = '4451' [Click To Show]
36 0.001 SELECT * FROM hitcounter WHERE ipaddress = '44.220.184.63' [Click To Show]
37 0 SELECT * FROM ipban WHERE ipaddress = '44.220.184.63' [Click To Show]
38 0 SELECT * FROM ipban WHERE ipaddress LIKE '%*%' AND (exptime > '1728000695' OR exptime = '0') [Click To Show]
39 0 SELECT * FROM medals WHERE autodays != '0' OR autorecruits != '0' ORDER BY ordernum DESC [Click To Show]
40 0 SELECT * FROM medals WHERE medal_id = '6' [Click To Show]
41 0 SELECT * FROM medals WHERE medal_id = '6' [Click To Show]
42 0 SELECT * FROM medals WHERE medal_id = '8' [Click To Show]
43 0 SELECT * FROM medals WHERE medal_id = '8' [Click To Show]
44 0 SELECT * FROM medals_members WHERE medal_id = '6' [Click To Show]
45 0 SELECT * FROM medals_members WHERE medal_id = '8' [Click To Show]
46 0 SELECT * FROM medals_members WHERE member_id = '1' AND medal_id = '6' [Click To Show]
47 0 SELECT * FROM medals_members WHERE member_id = '1' AND medal_id = '8' [Click To Show]
48 0 SELECT * FROM medals_members mm, medals m WHERE member_id = '1' AND m.medal_id = mm.medal_id ORDER BY m.ordernum DESC [Click To Show]
49 0 SELECT * FROM members WHERE member_id = '0' [Click To Show]
50 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]
51 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]
52 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]
53 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]
54 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]
55 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]
56 0 SELECT * FROM members WHERE member_id = '1' [Click To Show]
57 0 SELECT * FROM members WHERE recruiter = '1' AND disabled = '0' [Click To Show]
58 0 SELECT * FROM members WHERE username = '' [Click To Show]
59 0 SELECT * FROM members WHERE username = '' [Click To Show]
60 0 SELECT * FROM membersonlypage WHERE pageurl = 'zarksfallenangels.com/profile.php?mID=1' [Click To Show]
61 0 SELECT * FROM menu_category [Click To Show]
62 0 SELECT * FROM menu_item [Click To Show]
63 0 SELECT * FROM menuitem_custompage WHERE menucustompage_id = '10' [Click To Show]
64 0 SELECT * FROM menuitem_custompage WHERE menucustompage_id = '11' [Click To Show]
65 0 SELECT * FROM menuitem_link [Click To Show]
66 0 SELECT * FROM menuitem_shoutbox WHERE menushoutbox_id = '1' [Click To Show]
67 0 SELECT * FROM news WHERE newstype = '3' ORDER BY dateposted [Click To Show]
68 0 SELECT * FROM plugin_pages WHERE page = 'mods' ORDER BY sortnum [Click To Show]
69 0 SELECT * FROM plugin_pages WHERE page = 'profile' ORDER BY sortnum [Click To Show]
70 0 SELECT * FROM polls WHERE poll_id = '1' [Click To Show]
71 0 SELECT * FROM profilecategory ORDER BY ordernum DESC [Click To Show]
72 0 SELECT * FROM profilecategory WHERE profilecategory_id = '1' [Click To Show]
73 0 SELECT * FROM profileoptions WHERE profilecategory_id = '1' ORDER BY sortnum [Click To Show]
74 0 SELECT * FROM profileoptions WHERE profileoption_id = '2' [Click To Show]
75 0 SELECT * FROM profileoptions WHERE profileoption_id = '2' [Click To Show]
76 0 SELECT * FROM profileoptions WHERE profileoption_id = '3' [Click To Show]
77 0 SELECT * FROM profileoptions WHERE profileoption_id = '3' [Click To Show]
78 0 SELECT * FROM profileoptions WHERE profileoption_id = '6' [Click To Show]
79 0 SELECT * FROM profileoptions WHERE profileoption_id = '6' [Click To Show]
80 0 SELECT * FROM profileoptions_select WHERE selectopt_id = '13' [Click To Show]
81 0 SELECT * FROM profileoptions_values WHERE member_id = '1' AND profileoption_id = '2' [Click To Show]
82 0 SELECT * FROM profileoptions_values WHERE member_id = '1' AND profileoption_id = '3' [Click To Show]
83 0 SELECT * FROM profileoptions_values WHERE member_id = '1' AND profileoption_id = '6' [Click To Show]
84 0 SELECT * FROM rank_privileges [Click To Show]
85 0 SELECT * FROM rankcategory [Click To Show]
86 0 SELECT * FROM ranks [Click To Show]
87 0 SELECT * FROM squads_members WHERE member_id = '1' [Click To Show]
88 0 SELECT clock_id FROM clocks ORDER BY ordernum DESC [Click To Show]
89 0 SELECT forumpost_id FROM forum_post ORDER BY dateposted DESC [Click To Show]
90 0 SELECT member_id FROM members WHERE rank_id != '1' AND disabled = '0' ORDER BY datejoined DESC LIMIT 5 [Click To Show]
91 0 SELECT menucategory_id FROM menu_category WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND section = '0' ORDER BY sortnum [Click To Show]
92 0 SELECT menucategory_id FROM menu_category WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND section = '1' ORDER BY sortnum [Click To Show]
93 0 SELECT menucategory_id FROM menu_category WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND section = '2' ORDER BY sortnum [Click To Show]
94 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '1' ORDER BY sortnum [Click To Show]
95 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '16' ORDER BY sortnum [Click To Show]
96 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '17' ORDER BY sortnum [Click To Show]
97 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '24' ORDER BY sortnum [Click To Show]
98 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '29' ORDER BY sortnum [Click To Show]
99 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '4' ORDER BY sortnum [Click To Show]
100 0 SELECT menuitem_id FROM menu_item WHERE (accesstype = '0' OR accesstype = '2') AND hide = '0' AND menucategory_id = '5' ORDER BY sortnum [Click To Show]
101 0 SELECT rank_id FROM ranks WHERE autodays != '0' ORDER BY ordernum DESC [Click To Show]
102 0.001 SELECT social_members.* FROM social_members, social WHERE social.social_id = social_members.social_id AND social_members.member_id = '1' AND social_members.value != '' ORDER BY social.ordernum DESC [Click To Show]
103 0 SELECT tablename FROM tableupdates WHERE tablename = 'hitcounter' [Click To Show]
104 0 UPDATE tableupdates SET updatetime = '1728000695' WHERE tablename = 'hitcounter' [Click To Show]