
Podcast FM News...
Welcome to Podcast FM

Podcast FM: the one-stop solution for podcast hosting and syndication.
Podcast in either audio or video with Podcast FM's easy-to-use podcasting control panel.
No need for technical know-how, Podcast FM handles all the uploading, renaming and cataloguing of your podcasts. We then track downloads for you so you can see which podcasts are popular.
Create podcast subscription buttons in seconds with Podcast FM's html generator.
Podcast FM's prices are based on how many podcasts you upload each month so you only need to pay for the service you need.
Podcasting has never been easier.
To see what Podcast FM has to offer, why not check out a full list of features.
We list all the podcasts we host. Why not check out the search pages and see what podcasts other people are putting out.
Unlimited Subscribers
Video podcasting enabled
Uploads your Podcasts to the web
Supports all major podcatchers including iTunes
Tracks downloads and subscriptions
Multiple podcast channels
Adds ID3 tags to your MP3s
Calculates play length
Generates HTML for your website
Choose from masses of cool buttons
Add images to your channels
Sign Up For A Podcast FM Publisher Account

Sign up now and receive your first month free! Our automated sign-up process means you can be podcasting in no time. Just select the plan that suits you and go.
Not sure what this all means? Check out our frequently asked questions for details.
Sampler Plan
Unlimited subscribers
1000 MB per month download bandwidth
10 MB per month upload
30 Mb total storage space
1 channel
Audio podcasting only
Free
Starter Plan
Unlimited subscribers
Unlimited downloads
40 MB per month upload bandwidth
240 Mb total space
Up to 3 channels
FTP for files over 20 Mb
First month free
No tie ins
£4.95 per month
Blogger Plan
Unlimited subscribers
Unlimited downloads
160 MB per month upload bandwidth
960 Mb total space
Up to 10 channels
FTP for files over 20 Mb
First month free
No tie ins
£9.95 per month
Broadcaster Plan
Unlimited subscribers
Unlimited downloads
2000 MB per month upload bandwidth
Unlimited total space
Unlimited channels
FTP for files over 20 Mb
First month free
No tie ins
£39.95 per month
What Are People Checking Out Right Now?

These channels were all checked recently. Sign up now to start publishing you podcasts and to get people checking your channels to see what you have to offer.
Warning: in_array(): Wrong datatype for second argument


Call Stack:
c:\Inetpub\wwwroot\www.podcastfm.co.uk\index.php	293	

Globals:
_POST Array
_GET Array
_COOKIE Array
PHPSESSID String aa92fe4202cd57ff1f70e61159b8fa49
_SERVER Array
ALL_HTTP String HTTP_CACHE_CONTROL:no-cache\nHTTP_CONNECTION:close\nHTTP_PRAGMA:no-cache\nHTTP_ACCEPT:text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5\nHTTP_ACCEPT_CHARSET:ISO-8859-1,utf-8;q=0.7,*;q=0.7\nHTTP_ACCEPT_ENCODING:gzip\nHTTP_ACCEPT_LANGUAGE:en-us,en;q=0.5\nHTTP_COOKIE:PHPSESSID=aa92fe4202cd57ff1f70e61159b8fa49\nHTTP_HOST:www.podcastfm.co.uk\nHTTP_IF_MODIFIED_SINCE:Mon, 09 Aug 2010 12:13:33 GMT\nHTTP_USER_AGENT:CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\nHTTP_X_CC_ID:ccc01-02\nHTTP_X_REWRITE_URL:/index.php\n
HTTPS String off
SCRIPT_NAME String /index.php
HTTP_COOKIE String PHPSESSID=aa92fe4202cd57ff1f70e61159b8fa49
AUTH_PASSWORD String 
AUTH_TYPE String 
AUTH_USER String 
CONTENT_LENGTH String 0
CONTENT_TYPE String 
PATH_TRANSLATED String c:\Inetpub\wwwroot\www.podcastfm.co.uk
QUERY_STRING String 
REMOTE_ADDR String 38.107.179.213
REMOTE_HOST String 38.107.179.213
REMOTE_USER String 
REQUEST_METHOD String GET
SERVER_NAME String www.podcastfm.co.uk
SERVER_PORT String 80
SERVER_PROTOCOL String HTTP/1.1
SERVER_SOFTWARE String Microsoft-IIS/6.0
APPL_MD_PATH String /LM/w3svc/2127951859/root
APPL_PHYSICAL_PATH String c:\Inetpub\wwwroot\www.podcastfm.co.uk\
INSTANCE_ID String 2127951859
INSTANCE_META_PATH String /LM/W3SVC/2127951859
LOGON_USER String 
REQUEST_URI String /index.php
URL String /index.php
SCRIPT_FILENAME String c:\Inetpub\wwwroot\www.podcastfm.co.uk\index.php
ORIG_PATH_INFO String /index.php
PATH_INFO String 
ORIG_PATH_TRANSLATED String c:\Inetpub\wwwroot\www.podcastfm.co.uk\index.php
DOCUMENT_ROOT String c:\Inetpub\wwwroot\www.podcastfm.co.uk
PHP_SELF String /index.php
HTTP_CACHE_CONTROL String no-cache
HTTP_CONNECTION String close
HTTP_PRAGMA String no-cache
HTTP_ACCEPT String text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_CHARSET String ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING String gzip
HTTP_ACCEPT_LANGUAGE String en-us,en;q=0.5
HTTP_HOST String www.podcastfm.co.uk
HTTP_IF_MODIFIED_SINCE String Mon, 09 Aug 2010 12:13:33 GMT
HTTP_USER_AGENT String CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID String ccc01-02
HTTP_X_REWRITE_URL String /index.php
argv Array
0 String 
_ENV Array
_FILES Array
_REQUEST Array
PHPSESSID String aa92fe4202cd57ff1f70e61159b8fa49
DbAccess Object cdbaccessmssql Object
db_name String podcast
db_user String PodcastFM PHP
db_pass String iZxr662dxl1bOgb
conn Resource 'Resource id #18'
resultCache Array
24 String SET DATEFORMAT dmy
25 String UPDATE [tracked_sessions] SET [last_access]='1328384283', [exit_page]='index.php' WHERE [tracked_sessions_id]='5103945';
35 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'settings';
37 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
38 String USE Podcast\n
39 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'settings' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
40 String UPDATE [settings] SET [var_value]='1328384283' WHERE [var_name]='cache_last_cleared_timestamp';
41 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_items';
43 String USE Podcast\n
44 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_items' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
72 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1328054400')  ORDER BY [download_count] DESC, [pubDate] DESC;
76 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [download_count] DESC, [pubDate] DESC;
84 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_extended_subscriber_log';
86 String USE Podcast\n
87 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_extended_subscriber_log' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
95 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='02')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
101 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [last_download] DESC;
110 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'tracked_sessions';
112 String USE Podcast\n
113 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'tracked_sessions' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
114 String SELECT * FROM [Podcast].[dbo].[tracked_sessions] WHERE ([tracked_sessions].[last_access]>'1328383684') ;
117 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'users';
118 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
119 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_channels';
121 String USE Podcast\n
122 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_channels' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
143 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
149 String 	SELECT     	podcast_channel_id\r\n				FROM		subscriber_log\r\n				GROUP BY 	podcast_channel_id, check_month, check_year\r\n				HAVING      (check_month = 02) AND (check_year = 2012)\r\n				ORDER BY 	COUNT(subscriber_log_id) DESC
databaseAndSchemaCache Array
settings Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_items Object stdClass Object
database String Podcast
schema String dbo
vw_extended_subscriber_log Object stdClass Object
database String Podcast
schema String dbo
tracked_sessions Object stdClass Object
database String Podcast
schema String dbo
users Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_channels Object stdClass Object
database String Podcast
schema String dbo
primaryKeyCache Array
settings String settings_id
vw_visible_podcast_items NULL
vw_extended_subscriber_log NULL
tracked_sessions String tracked_sessions_id
vw_visible_podcast_channels NULL
fieldInfoCache Array
settings Array
settings_id Object stdClass Object
Field String settings_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
var_name Object stdClass Object
Field String var_name
Type String varchar(100)
Null String 
Key String 
Default String 
Extra String 
var_value Object stdClass Object
Field String var_value
Type String varchar(1000)
Null String 
Key String 
Default String 
Extra String 
description Object stdClass Object
Field String description
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_items Array
podcast_item_id Object stdClass Object
Field String podcast_item_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
filename Object stdClass Object
Field String filename
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
pubDate Object stdClass Object
Field String pubDate
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_duration Object stdClass Object
Field String itunes_duration
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
keywords Object stdClass Object
Field String keywords
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
length Object stdClass Object
Field String length
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
type Object stdClass Object
Field String type
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
duration_secs Object stdClass Object
Field String duration_secs
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
bitrate Object stdClass Object
Field String bitrate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_framerate Object stdClass Object
Field String media_framerate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_medium Object stdClass Object
Field String media_medium
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
media_width Object stdClass Object
Field String media_width
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_height Object stdClass Object
Field String media_height
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_channels Object stdClass Object
Field String media_channels
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_samplingrate Object stdClass Object
Field String media_samplingrate
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
id3_genre Object stdClass Object
Field String id3_genre
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
guid Object stdClass Object
Field String guid
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
download_count Object stdClass Object
Field String download_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_download Object stdClass Object
Field String last_download
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
vw_extended_subscriber_log Array
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
check_month Object stdClass Object
Field String check_month
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
check_year Object stdClass Object
Field String check_year
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
tracked_sessions Array
tracked_sessions_id Object stdClass Object
Field String tracked_sessions_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
entry_time Object stdClass Object
Field String entry_time
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
entry_page Object stdClass Object
Field String entry_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
exit_page Object stdClass Object
Field String exit_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_channels Array
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_name Object stdClass Object
Field String itunes_owner_name
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_email Object stdClass Object
Field String itunes_owner_email
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_image Object stdClass Object
Field String itunes_image
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_category Object stdClass Object
Field String itunes_category
Type String varchar(1000)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
private Object stdClass Object
Field String private
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
allow_comments Object stdClass Object
Field String allow_comments
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
expiry_date Object stdClass Object
Field String expiry_date
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
item_count Object stdClass Object
Field String item_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
latest_podcast_timestamp Object stdClass Object
Field String latest_podcast_timestamp
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
active Object stdClass Object
Field String active
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
minimumValueForFieldTypeCache NULL
host_name String LocalServer
dbSelected Boolean '1'
test Object stdClass Object
database String Podcast
schema String dbo
increment Boolean ''
podcast_server Object cpodcastfileserver Object
errors Array
DbAccess Object cdbaccessmssql Object
db_name String podcast
db_user String PodcastFM PHP
db_pass String iZxr662dxl1bOgb
conn Resource 'Resource id #18'
resultCache Array
24 String SET DATEFORMAT dmy
25 String UPDATE [tracked_sessions] SET [last_access]='1328384283', [exit_page]='index.php' WHERE [tracked_sessions_id]='5103945';
35 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'settings';
37 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
38 String USE Podcast\n
39 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'settings' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
40 String UPDATE [settings] SET [var_value]='1328384283' WHERE [var_name]='cache_last_cleared_timestamp';
41 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_items';
43 String USE Podcast\n
44 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_items' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
72 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1328054400')  ORDER BY [download_count] DESC, [pubDate] DESC;
76 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [download_count] DESC, [pubDate] DESC;
84 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_extended_subscriber_log';
86 String USE Podcast\n
87 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_extended_subscriber_log' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
95 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='02')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
101 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [last_download] DESC;
110 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'tracked_sessions';
112 String USE Podcast\n
113 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'tracked_sessions' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
114 String SELECT * FROM [Podcast].[dbo].[tracked_sessions] WHERE ([tracked_sessions].[last_access]>'1328383684') ;
117 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'users';
118 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
119 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_channels';
121 String USE Podcast\n
122 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_channels' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
143 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
149 String 	SELECT     	podcast_channel_id\r\n				FROM		subscriber_log\r\n				GROUP BY 	podcast_channel_id, check_month, check_year\r\n				HAVING      (check_month = 02) AND (check_year = 2012)\r\n				ORDER BY 	COUNT(subscriber_log_id) DESC
databaseAndSchemaCache Array
settings Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_items Object stdClass Object
database String Podcast
schema String dbo
vw_extended_subscriber_log Object stdClass Object
database String Podcast
schema String dbo
tracked_sessions Object stdClass Object
database String Podcast
schema String dbo
users Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_channels Object stdClass Object
database String Podcast
schema String dbo
primaryKeyCache Array
settings String settings_id
vw_visible_podcast_items NULL
vw_extended_subscriber_log NULL
tracked_sessions String tracked_sessions_id
vw_visible_podcast_channels NULL
fieldInfoCache Array
settings Array
settings_id Object stdClass Object
Field String settings_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
var_name Object stdClass Object
Field String var_name
Type String varchar(100)
Null String 
Key String 
Default String 
Extra String 
var_value Object stdClass Object
Field String var_value
Type String varchar(1000)
Null String 
Key String 
Default String 
Extra String 
description Object stdClass Object
Field String description
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_items Array
podcast_item_id Object stdClass Object
Field String podcast_item_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
filename Object stdClass Object
Field String filename
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
pubDate Object stdClass Object
Field String pubDate
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_duration Object stdClass Object
Field String itunes_duration
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
keywords Object stdClass Object
Field String keywords
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
length Object stdClass Object
Field String length
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
type Object stdClass Object
Field String type
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
duration_secs Object stdClass Object
Field String duration_secs
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
bitrate Object stdClass Object
Field String bitrate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_framerate Object stdClass Object
Field String media_framerate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_medium Object stdClass Object
Field String media_medium
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
media_width Object stdClass Object
Field String media_width
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_height Object stdClass Object
Field String media_height
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_channels Object stdClass Object
Field String media_channels
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_samplingrate Object stdClass Object
Field String media_samplingrate
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
id3_genre Object stdClass Object
Field String id3_genre
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
guid Object stdClass Object
Field String guid
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
download_count Object stdClass Object
Field String download_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_download Object stdClass Object
Field String last_download
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
vw_extended_subscriber_log Array
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
check_month Object stdClass Object
Field String check_month
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
check_year Object stdClass Object
Field String check_year
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
tracked_sessions Array
tracked_sessions_id Object stdClass Object
Field String tracked_sessions_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
entry_time Object stdClass Object
Field String entry_time
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
entry_page Object stdClass Object
Field String entry_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
exit_page Object stdClass Object
Field String exit_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_channels Array
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_name Object stdClass Object
Field String itunes_owner_name
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_email Object stdClass Object
Field String itunes_owner_email
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_image Object stdClass Object
Field String itunes_image
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_category Object stdClass Object
Field String itunes_category
Type String varchar(1000)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
private Object stdClass Object
Field String private
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
allow_comments Object stdClass Object
Field String allow_comments
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
expiry_date Object stdClass Object
Field String expiry_date
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
item_count Object stdClass Object
Field String item_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
latest_podcast_timestamp Object stdClass Object
Field String latest_podcast_timestamp
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
active Object stdClass Object
Field String active
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
minimumValueForFieldTypeCache NULL
host_name String LocalServer
dbSelected Boolean '1'
test Object stdClass Object
database String Podcast
schema String dbo
increment String increment
file_url NULL
mp3 Boolean ''
public_page Boolean '1'
_SESSION Array
tracked_sessions_id String 5103945
cache_clear_interval String 180
cache_next_db_check Integer '1328384343'
Authenticator Object cauthentication Object
table Object stdClass Object
tableName String users
primaryKey String user_id
passwordField String password
row NULL
lastLoginTime NULL
useCookies Boolean ''
hide Array
DbAccess Object cdbaccessmssql Object
db_name String podcast
db_user String PodcastFM PHP
db_pass String iZxr662dxl1bOgb
conn Resource 'Resource id #18'
resultCache Array
20 String SET DATEFORMAT dmy
21 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'users';
databaseAndSchemaCache Array
users Object stdClass Object
database String Podcast
schema String dbo
primaryKeyCache Array
users String user_id
fieldInfoCache NULL
minimumValueForFieldTypeCache NULL
host_name String LocalServer
dbSelected Boolean '1'
test Object stdClass Object
database String Podcast
schema String dbo
table Object stdClass Object
tableName String users
primaryKey String user_id
update_array Array
tracked_sessions_id String 5103945
last_access Integer '1328384283'
exit_page String index.php
update_success Boolean '1'
Cache Object ctimedcache Object
db_check_interval Integer '60'
cache_dir String cache/
DbAccess Object cdbaccessmssql Object
db_name String podcast
db_user String PodcastFM PHP
db_pass String iZxr662dxl1bOgb
conn Resource 'Resource id #18'
resultCache Array
24 String SET DATEFORMAT dmy
25 String UPDATE [tracked_sessions] SET [last_access]='1328384283', [exit_page]='index.php' WHERE [tracked_sessions_id]='5103945';
35 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'settings';
37 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
38 String USE Podcast\n
39 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'settings' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
40 String UPDATE [settings] SET [var_value]='1328384283' WHERE [var_name]='cache_last_cleared_timestamp';
41 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_items';
43 String USE Podcast\n
44 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_items' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
72 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1328054400')  ORDER BY [download_count] DESC, [pubDate] DESC;
76 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [download_count] DESC, [pubDate] DESC;
84 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_extended_subscriber_log';
86 String USE Podcast\n
87 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_extended_subscriber_log' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
95 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='02')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
101 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [last_download] DESC;
110 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'tracked_sessions';
112 String USE Podcast\n
113 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'tracked_sessions' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
114 String SELECT * FROM [Podcast].[dbo].[tracked_sessions] WHERE ([tracked_sessions].[last_access]>'1328383684') ;
117 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'users';
118 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
119 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_channels';
121 String USE Podcast\n
122 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_channels' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
143 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
149 String 	SELECT     	podcast_channel_id\r\n				FROM		subscriber_log\r\n				GROUP BY 	podcast_channel_id, check_month, check_year\r\n				HAVING      (check_month = 02) AND (check_year = 2012)\r\n				ORDER BY 	COUNT(subscriber_log_id) DESC
databaseAndSchemaCache Array
settings Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_items Object stdClass Object
database String Podcast
schema String dbo
vw_extended_subscriber_log Object stdClass Object
database String Podcast
schema String dbo
tracked_sessions Object stdClass Object
database String Podcast
schema String dbo
users Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_channels Object stdClass Object
database String Podcast
schema String dbo
primaryKeyCache Array
settings String settings_id
vw_visible_podcast_items NULL
vw_extended_subscriber_log NULL
tracked_sessions String tracked_sessions_id
vw_visible_podcast_channels NULL
fieldInfoCache Array
settings Array
settings_id Object stdClass Object
Field String settings_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
var_name Object stdClass Object
Field String var_name
Type String varchar(100)
Null String 
Key String 
Default String 
Extra String 
var_value Object stdClass Object
Field String var_value
Type String varchar(1000)
Null String 
Key String 
Default String 
Extra String 
description Object stdClass Object
Field String description
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_items Array
podcast_item_id Object stdClass Object
Field String podcast_item_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
filename Object stdClass Object
Field String filename
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
pubDate Object stdClass Object
Field String pubDate
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_duration Object stdClass Object
Field String itunes_duration
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
keywords Object stdClass Object
Field String keywords
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
length Object stdClass Object
Field String length
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
type Object stdClass Object
Field String type
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
duration_secs Object stdClass Object
Field String duration_secs
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
bitrate Object stdClass Object
Field String bitrate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_framerate Object stdClass Object
Field String media_framerate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_medium Object stdClass Object
Field String media_medium
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
media_width Object stdClass Object
Field String media_width
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_height Object stdClass Object
Field String media_height
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_channels Object stdClass Object
Field String media_channels
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_samplingrate Object stdClass Object
Field String media_samplingrate
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
id3_genre Object stdClass Object
Field String id3_genre
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
guid Object stdClass Object
Field String guid
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
download_count Object stdClass Object
Field String download_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_download Object stdClass Object
Field String last_download
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
vw_extended_subscriber_log Array
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
check_month Object stdClass Object
Field String check_month
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
check_year Object stdClass Object
Field String check_year
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
tracked_sessions Array
tracked_sessions_id Object stdClass Object
Field String tracked_sessions_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
entry_time Object stdClass Object
Field String entry_time
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
entry_page Object stdClass Object
Field String entry_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
exit_page Object stdClass Object
Field String exit_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_channels Array
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_name Object stdClass Object
Field String itunes_owner_name
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_email Object stdClass Object
Field String itunes_owner_email
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_image Object stdClass Object
Field String itunes_image
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_category Object stdClass Object
Field String itunes_category
Type String varchar(1000)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
private Object stdClass Object
Field String private
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
allow_comments Object stdClass Object
Field String allow_comments
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
expiry_date Object stdClass Object
Field String expiry_date
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
item_count Object stdClass Object
Field String item_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
latest_podcast_timestamp Object stdClass Object
Field String latest_podcast_timestamp
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
active Object stdClass Object
Field String active
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
minimumValueForFieldTypeCache NULL
host_name String LocalServer
dbSelected Boolean '1'
test Object stdClass Object
database String Podcast
schema String dbo
ads Array
0 String <a href="../../order.php"><img src="../../images/box_offer.jpg" /></a>
1 String <a href="../../what_is_a_podcast.php"><img src="../../images/box_how.jpg" /></a>
cache_id String whos_online
popularPodcasts Object clist Object
thisPage NULL
DbAccess Object cdbaccessmssql Object
db_name String podcast
db_user String PodcastFM PHP
db_pass String iZxr662dxl1bOgb
conn Resource 'Resource id #18'
resultCache Array
24 String SET DATEFORMAT dmy
25 String UPDATE [tracked_sessions] SET [last_access]='1328384283', [exit_page]='index.php' WHERE [tracked_sessions_id]='5103945';
35 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'settings';
37 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
38 String USE Podcast\n
39 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'settings' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
40 String UPDATE [settings] SET [var_value]='1328384283' WHERE [var_name]='cache_last_cleared_timestamp';
41 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_items';
43 String USE Podcast\n
44 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_items' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
72 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1328054400')  ORDER BY [download_count] DESC, [pubDate] DESC;
76 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [download_count] DESC, [pubDate] DESC;
84 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_extended_subscriber_log';
86 String USE Podcast\n
87 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_extended_subscriber_log' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
95 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='02')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
101 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [last_download] DESC;
110 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'tracked_sessions';
112 String USE Podcast\n
113 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'tracked_sessions' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
114 String SELECT * FROM [Podcast].[dbo].[tracked_sessions] WHERE ([tracked_sessions].[last_access]>'1328383684') ;
117 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'users';
118 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
119 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_channels';
121 String USE Podcast\n
122 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_channels' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
143 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
149 String 	SELECT     	podcast_channel_id\r\n				FROM		subscriber_log\r\n				GROUP BY 	podcast_channel_id, check_month, check_year\r\n				HAVING      (check_month = 02) AND (check_year = 2012)\r\n				ORDER BY 	COUNT(subscriber_log_id) DESC
databaseAndSchemaCache Array
settings Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_items Object stdClass Object
database String Podcast
schema String dbo
vw_extended_subscriber_log Object stdClass Object
database String Podcast
schema String dbo
tracked_sessions Object stdClass Object
database String Podcast
schema String dbo
users Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_channels Object stdClass Object
database String Podcast
schema String dbo
primaryKeyCache Array
settings String settings_id
vw_visible_podcast_items NULL
vw_extended_subscriber_log NULL
tracked_sessions String tracked_sessions_id
vw_visible_podcast_channels NULL
fieldInfoCache Array
settings Array
settings_id Object stdClass Object
Field String settings_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
var_name Object stdClass Object
Field String var_name
Type String varchar(100)
Null String 
Key String 
Default String 
Extra String 
var_value Object stdClass Object
Field String var_value
Type String varchar(1000)
Null String 
Key String 
Default String 
Extra String 
description Object stdClass Object
Field String description
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_items Array
podcast_item_id Object stdClass Object
Field String podcast_item_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
filename Object stdClass Object
Field String filename
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
pubDate Object stdClass Object
Field String pubDate
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_duration Object stdClass Object
Field String itunes_duration
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
keywords Object stdClass Object
Field String keywords
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
length Object stdClass Object
Field String length
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
type Object stdClass Object
Field String type
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
duration_secs Object stdClass Object
Field String duration_secs
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
bitrate Object stdClass Object
Field String bitrate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_framerate Object stdClass Object
Field String media_framerate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_medium Object stdClass Object
Field String media_medium
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
media_width Object stdClass Object
Field String media_width
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_height Object stdClass Object
Field String media_height
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_channels Object stdClass Object
Field String media_channels
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_samplingrate Object stdClass Object
Field String media_samplingrate
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
id3_genre Object stdClass Object
Field String id3_genre
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
guid Object stdClass Object
Field String guid
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
download_count Object stdClass Object
Field String download_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_download Object stdClass Object
Field String last_download
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
vw_extended_subscriber_log Array
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
check_month Object stdClass Object
Field String check_month
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
check_year Object stdClass Object
Field String check_year
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
tracked_sessions Array
tracked_sessions_id Object stdClass Object
Field String tracked_sessions_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
entry_time Object stdClass Object
Field String entry_time
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
entry_page Object stdClass Object
Field String entry_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
exit_page Object stdClass Object
Field String exit_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_channels Array
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_name Object stdClass Object
Field String itunes_owner_name
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_email Object stdClass Object
Field String itunes_owner_email
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_image Object stdClass Object
Field String itunes_image
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_category Object stdClass Object
Field String itunes_category
Type String varchar(1000)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
private Object stdClass Object
Field String private
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
allow_comments Object stdClass Object
Field String allow_comments
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
expiry_date Object stdClass Object
Field String expiry_date
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
item_count Object stdClass Object
Field String item_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
latest_podcast_timestamp Object stdClass Object
Field String latest_podcast_timestamp
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
active Object stdClass Object
Field String active
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
minimumValueForFieldTypeCache NULL
host_name String LocalServer
dbSelected Boolean '1'
test Object stdClass Object
database String Podcast
schema String dbo
row NULL
table Object stdClass Object
tableName String vw_visible_podcast_items
primaryKey NULL
fieldInfo Array
podcast_item_id Object stdClass Object
Field String podcast_item_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
filename Object stdClass Object
Field String filename
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
pubDate Object stdClass Object
Field String pubDate
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_duration Object stdClass Object
Field String itunes_duration
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
keywords Object stdClass Object
Field String keywords
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
length Object stdClass Object
Field String length
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
type Object stdClass Object
Field String type
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
duration_secs Object stdClass Object
Field String duration_secs
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
bitrate Object stdClass Object
Field String bitrate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_framerate Object stdClass Object
Field String media_framerate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_medium Object stdClass Object
Field String media_medium
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
media_width Object stdClass Object
Field String media_width
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_height Object stdClass Object
Field String media_height
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_channels Object stdClass Object
Field String media_channels
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_samplingrate Object stdClass Object
Field String media_samplingrate
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
id3_genre Object stdClass Object
Field String id3_genre
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
guid Object stdClass Object
Field String guid
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
download_count Object stdClass Object
Field String download_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_download Object stdClass Object
Field String last_download
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
restriction NULL
sort Array
0 Object stdClass Object
field String download_count
direction String DESC
1 Object stdClass Object
field String pubDate
direction String DESC
limit Object stdClass Object
maxRows Integer '5'
select String title, guid, download_count
andOr String AND
usePrimaryKey NULL
groupBy NULL
items Array
0 Object clistitem Object
thisPage NULL
DbAccess Object cdbaccessmssql Object
db_name String podcast
db_user String PodcastFM PHP
db_pass String iZxr662dxl1bOgb
conn Resource 'Resource id #18'
resultCache Array
24 String SET DATEFORMAT dmy
25 String UPDATE [tracked_sessions] SET [last_access]='1328384283', [exit_page]='index.php' WHERE [tracked_sessions_id]='5103945';
35 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'settings';
37 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
38 String USE Podcast\n
39 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'settings' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
40 String UPDATE [settings] SET [var_value]='1328384283' WHERE [var_name]='cache_last_cleared_timestamp';
41 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_items';
43 String USE Podcast\n
44 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_items' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
72 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1328054400')  ORDER BY [download_count] DESC, [pubDate] DESC;
76 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [download_count] DESC, [pubDate] DESC;
84 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_extended_subscriber_log';
86 String USE Podcast\n
87 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_extended_subscriber_log' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
95 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='02')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
101 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [last_download] DESC;
110 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'tracked_sessions';
112 String USE Podcast\n
113 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'tracked_sessions' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
114 String SELECT * FROM [Podcast].[dbo].[tracked_sessions] WHERE ([tracked_sessions].[last_access]>'1328383684') ;
117 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'users';
118 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
119 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_channels';
121 String USE Podcast\n
122 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_channels' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
143 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
149 String 	SELECT     	podcast_channel_id\r\n				FROM		subscriber_log\r\n				GROUP BY 	podcast_channel_id, check_month, check_year\r\n				HAVING      (check_month = 02) AND (check_year = 2012)\r\n				ORDER BY 	COUNT(subscriber_log_id) DESC
databaseAndSchemaCache Array
settings Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_items Object stdClass Object
database String Podcast
schema String dbo
vw_extended_subscriber_log Object stdClass Object
database String Podcast
schema String dbo
tracked_sessions Object stdClass Object
database String Podcast
schema String dbo
users Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_channels Object stdClass Object
database String Podcast
schema String dbo
primaryKeyCache Array
settings String settings_id
vw_visible_podcast_items NULL
vw_extended_subscriber_log NULL
tracked_sessions String tracked_sessions_id
vw_visible_podcast_channels NULL
fieldInfoCache Array
settings Array
settings_id Object stdClass Object
Field String settings_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
var_name Object stdClass Object
Field String var_name
Type String varchar(100)
Null String 
Key String 
Default String 
Extra String 
var_value Object stdClass Object
Field String var_value
Type String varchar(1000)
Null String 
Key String 
Default String 
Extra String 
description Object stdClass Object
Field String description
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_items Array
podcast_item_id Object stdClass Object
Field String podcast_item_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
filename Object stdClass Object
Field String filename
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
pubDate Object stdClass Object
Field String pubDate
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_duration Object stdClass Object
Field String itunes_duration
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
keywords Object stdClass Object
Field String keywords
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
length Object stdClass Object
Field String length
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
type Object stdClass Object
Field String type
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
duration_secs Object stdClass Object
Field String duration_secs
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
bitrate Object stdClass Object
Field String bitrate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_framerate Object stdClass Object
Field String media_framerate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_medium Object stdClass Object
Field String media_medium
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
media_width Object stdClass Object
Field String media_width
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_height Object stdClass Object
Field String media_height
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_channels Object stdClass Object
Field String media_channels
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_samplingrate Object stdClass Object
Field String media_samplingrate
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
id3_genre Object stdClass Object
Field String id3_genre
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
guid Object stdClass Object
Field String guid
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
download_count Object stdClass Object
Field String download_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_download Object stdClass Object
Field String last_download
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
vw_extended_subscriber_log Array
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
check_month Object stdClass Object
Field String check_month
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
check_year Object stdClass Object
Field String check_year
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
tracked_sessions Array
tracked_sessions_id Object stdClass Object
Field String tracked_sessions_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
entry_time Object stdClass Object
Field String entry_time
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
entry_page Object stdClass Object
Field String entry_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
exit_page Object stdClass Object
Field String exit_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_channels Array
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_name Object stdClass Object
Field String itunes_owner_name
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_email Object stdClass Object
Field String itunes_owner_email
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_image Object stdClass Object
Field String itunes_image
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_category Object stdClass Object
Field String itunes_category
Type String varchar(1000)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
private Object stdClass Object
Field String private
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
allow_comments Object stdClass Object
Field String allow_comments
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
expiry_date Object stdClass Object
Field String expiry_date
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
item_count Object stdClass Object
Field String item_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
latest_podcast_timestamp Object stdClass Object
Field String latest_podcast_timestamp
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
active Object stdClass Object
Field String active
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
minimumValueForFieldTypeCache NULL
host_name String LocalServer
dbSelected Boolean '1'
test Object stdClass Object
database String Podcast
schema String dbo
row Array
title String Show # 069 - Creative Thinking for Non Creative People
guid String 117379598445f6b499cd360
download_count String 8311
table Object stdClass Object
tableName String vw_visible_podcast_items
primaryKey NULL
fieldInfo Array
podcast_item_id Object stdClass Object
Field String podcast_item_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
filename Object stdClass Object
Field String filename
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
pubDate Object stdClass Object
Field String pubDate
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_duration Object stdClass Object
Field String itunes_duration
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
keywords Object stdClass Object
Field String keywords
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
length Object stdClass Object
Field String length
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
type Object stdClass Object
Field String type
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
duration_secs Object stdClass Object
Field String duration_secs
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
bitrate Object stdClass Object
Field String bitrate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_framerate Object stdClass Object
Field String media_framerate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_medium Object stdClass Object
Field String media_medium
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
media_width Object stdClass Object
Field String media_width
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_height Object stdClass Object
Field String media_height
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_channels Object stdClass Object
Field String media_channels
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_samplingrate Object stdClass Object
Field String media_samplingrate
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
id3_genre Object stdClass Object
Field String id3_genre
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
guid Object stdClass Object
Field String guid
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
download_count Object stdClass Object
Field String download_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_download Object stdClass Object
Field String last_download
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
1 Object clistitem Object
thisPage NULL
DbAccess Object cdbaccessmssql Object
db_name String podcast
db_user String PodcastFM PHP
db_pass String iZxr662dxl1bOgb
conn Resource 'Resource id #18'
resultCache Array
24 String SET DATEFORMAT dmy
25 String UPDATE [tracked_sessions] SET [last_access]='1328384283', [exit_page]='index.php' WHERE [tracked_sessions_id]='5103945';
35 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'settings';
37 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
38 String USE Podcast\n
39 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'settings' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
40 String UPDATE [settings] SET [var_value]='1328384283' WHERE [var_name]='cache_last_cleared_timestamp';
41 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_items';
43 String USE Podcast\n
44 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_items' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
72 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1328054400')  ORDER BY [download_count] DESC, [pubDate] DESC;
76 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [download_count] DESC, [pubDate] DESC;
84 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_extended_subscriber_log';
86 String USE Podcast\n
87 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_extended_subscriber_log' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
95 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='02')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
101 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [last_download] DESC;
110 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'tracked_sessions';
112 String USE Podcast\n
113 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'tracked_sessions' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
114 String SELECT * FROM [Podcast].[dbo].[tracked_sessions] WHERE ([tracked_sessions].[last_access]>'1328383684') ;
117 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'users';
118 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
119 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_channels';
121 String USE Podcast\n
122 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_channels' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
143 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
149 String 	SELECT     	podcast_channel_id\r\n				FROM		subscriber_log\r\n				GROUP BY 	podcast_channel_id, check_month, check_year\r\n				HAVING      (check_month = 02) AND (check_year = 2012)\r\n				ORDER BY 	COUNT(subscriber_log_id) DESC
databaseAndSchemaCache Array
settings Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_items Object stdClass Object
database String Podcast
schema String dbo
vw_extended_subscriber_log Object stdClass Object
database String Podcast
schema String dbo
tracked_sessions Object stdClass Object
database String Podcast
schema String dbo
users Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_channels Object stdClass Object
database String Podcast
schema String dbo
primaryKeyCache Array
settings String settings_id
vw_visible_podcast_items NULL
vw_extended_subscriber_log NULL
tracked_sessions String tracked_sessions_id
vw_visible_podcast_channels NULL
fieldInfoCache Array
settings Array
settings_id Object stdClass Object
Field String settings_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
var_name Object stdClass Object
Field String var_name
Type String varchar(100)
Null String 
Key String 
Default String 
Extra String 
var_value Object stdClass Object
Field String var_value
Type String varchar(1000)
Null String 
Key String 
Default String 
Extra String 
description Object stdClass Object
Field String description
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_items Array
podcast_item_id Object stdClass Object
Field String podcast_item_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
filename Object stdClass Object
Field String filename
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
pubDate Object stdClass Object
Field String pubDate
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_duration Object stdClass Object
Field String itunes_duration
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
keywords Object stdClass Object
Field String keywords
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
length Object stdClass Object
Field String length
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
type Object stdClass Object
Field String type
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
duration_secs Object stdClass Object
Field String duration_secs
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
bitrate Object stdClass Object
Field String bitrate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_framerate Object stdClass Object
Field String media_framerate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_medium Object stdClass Object
Field String media_medium
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
media_width Object stdClass Object
Field String media_width
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_height Object stdClass Object
Field String media_height
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_channels Object stdClass Object
Field String media_channels
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_samplingrate Object stdClass Object
Field String media_samplingrate
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
id3_genre Object stdClass Object
Field String id3_genre
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
guid Object stdClass Object
Field String guid
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
download_count Object stdClass Object
Field String download_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_download Object stdClass Object
Field String last_download
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
vw_extended_subscriber_log Array
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
check_month Object stdClass Object
Field String check_month
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
check_year Object stdClass Object
Field String check_year
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
tracked_sessions Array
tracked_sessions_id Object stdClass Object
Field String tracked_sessions_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
entry_time Object stdClass Object
Field String entry_time
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
entry_page Object stdClass Object
Field String entry_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
exit_page Object stdClass Object
Field String exit_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_channels Array
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_name Object stdClass Object
Field String itunes_owner_name
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_email Object stdClass Object
Field String itunes_owner_email
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_image Object stdClass Object
Field String itunes_image
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_category Object stdClass Object
Field String itunes_category
Type String varchar(1000)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
private Object stdClass Object
Field String private
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
allow_comments Object stdClass Object
Field String allow_comments
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
expiry_date Object stdClass Object
Field String expiry_date
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
item_count Object stdClass Object
Field String item_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
latest_podcast_timestamp Object stdClass Object
Field String latest_podcast_timestamp
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
active Object stdClass Object
Field String active
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
minimumValueForFieldTypeCache NULL
host_name String LocalServer
dbSelected Boolean '1'
test Object stdClass Object
database String Podcast
schema String dbo
row Array
title String Innovation Podcast Ep21
guid String 12936213134d1b18417c03c
download_count String 7880
table Object stdClass Object
tableName String vw_visible_podcast_items
primaryKey NULL
fieldInfo Array
podcast_item_id Object stdClass Object
Field String podcast_item_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
filename Object stdClass Object
Field String filename
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
pubDate Object stdClass Object
Field String pubDate
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_duration Object stdClass Object
Field String itunes_duration
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
keywords Object stdClass Object
Field String keywords
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
length Object stdClass Object
Field String length
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
type Object stdClass Object
Field String type
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
duration_secs Object stdClass Object
Field String duration_secs
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
bitrate Object stdClass Object
Field String bitrate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_framerate Object stdClass Object
Field String media_framerate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_medium Object stdClass Object
Field String media_medium
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
media_width Object stdClass Object
Field String media_width
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_height Object stdClass Object
Field String media_height
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_channels Object stdClass Object
Field String media_channels
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_samplingrate Object stdClass Object
Field String media_samplingrate
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
id3_genre Object stdClass Object
Field String id3_genre
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
guid Object stdClass Object
Field String guid
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
download_count Object stdClass Object
Field String download_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_download Object stdClass Object
Field String last_download
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
2 Object clistitem Object
thisPage NULL
DbAccess Object cdbaccessmssql Object
db_name String podcast
db_user String PodcastFM PHP
db_pass String iZxr662dxl1bOgb
conn Resource 'Resource id #18'
resultCache Array
24 String SET DATEFORMAT dmy
25 String UPDATE [tracked_sessions] SET [last_access]='1328384283', [exit_page]='index.php' WHERE [tracked_sessions_id]='5103945';
35 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'settings';
37 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
38 String USE Podcast\n
39 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'settings' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
40 String UPDATE [settings] SET [var_value]='1328384283' WHERE [var_name]='cache_last_cleared_timestamp';
41 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_items';
43 String USE Podcast\n
44 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_items' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
72 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1328054400')  ORDER BY [download_count] DESC, [pubDate] DESC;
76 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [download_count] DESC, [pubDate] DESC;
84 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_extended_subscriber_log';
86 String USE Podcast\n
87 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_extended_subscriber_log' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
95 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='02')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
101 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [last_download] DESC;
110 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'tracked_sessions';
112 String USE Podcast\n
113 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'tracked_sessions' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
114 String SELECT * FROM [Podcast].[dbo].[tracked_sessions] WHERE ([tracked_sessions].[last_access]>'1328383684') ;
117 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'users';
118 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
119 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_channels';
121 String USE Podcast\n
122 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_channels' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
143 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
149 String 	SELECT     	podcast_channel_id\r\n				FROM		subscriber_log\r\n				GROUP BY 	podcast_channel_id, check_month, check_year\r\n				HAVING      (check_month = 02) AND (check_year = 2012)\r\n				ORDER BY 	COUNT(subscriber_log_id) DESC
databaseAndSchemaCache Array
settings Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_items Object stdClass Object
database String Podcast
schema String dbo
vw_extended_subscriber_log Object stdClass Object
database String Podcast
schema String dbo
tracked_sessions Object stdClass Object
database String Podcast
schema String dbo
users Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_channels Object stdClass Object
database String Podcast
schema String dbo
primaryKeyCache Array
settings String settings_id
vw_visible_podcast_items NULL
vw_extended_subscriber_log NULL
tracked_sessions String tracked_sessions_id
vw_visible_podcast_channels NULL
fieldInfoCache Array
settings Array
settings_id Object stdClass Object
Field String settings_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
var_name Object stdClass Object
Field String var_name
Type String varchar(100)
Null String 
Key String 
Default String 
Extra String 
var_value Object stdClass Object
Field String var_value
Type String varchar(1000)
Null String 
Key String 
Default String 
Extra String 
description Object stdClass Object
Field String description
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_items Array
podcast_item_id Object stdClass Object
Field String podcast_item_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
filename Object stdClass Object
Field String filename
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
pubDate Object stdClass Object
Field String pubDate
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_duration Object stdClass Object
Field String itunes_duration
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
keywords Object stdClass Object
Field String keywords
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
length Object stdClass Object
Field String length
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
type Object stdClass Object
Field String type
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
duration_secs Object stdClass Object
Field String duration_secs
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
bitrate Object stdClass Object
Field String bitrate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_framerate Object stdClass Object
Field String media_framerate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_medium Object stdClass Object
Field String media_medium
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
media_width Object stdClass Object
Field String media_width
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_height Object stdClass Object
Field String media_height
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_channels Object stdClass Object
Field String media_channels
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_samplingrate Object stdClass Object
Field String media_samplingrate
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
id3_genre Object stdClass Object
Field String id3_genre
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
guid Object stdClass Object
Field String guid
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
download_count Object stdClass Object
Field String download_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_download Object stdClass Object
Field String last_download
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
vw_extended_subscriber_log Array
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
check_month Object stdClass Object
Field String check_month
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
check_year Object stdClass Object
Field String check_year
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
tracked_sessions Array
tracked_sessions_id Object stdClass Object
Field String tracked_sessions_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
entry_time Object stdClass Object
Field String entry_time
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
entry_page Object stdClass Object
Field String entry_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
exit_page Object stdClass Object
Field String exit_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_channels Array
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_name Object stdClass Object
Field String itunes_owner_name
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_email Object stdClass Object
Field String itunes_owner_email
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_image Object stdClass Object
Field String itunes_image
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_category Object stdClass Object
Field String itunes_category
Type String varchar(1000)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
private Object stdClass Object
Field String private
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
allow_comments Object stdClass Object
Field String allow_comments
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
expiry_date Object stdClass Object
Field String expiry_date
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
item_count Object stdClass Object
Field String item_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
latest_podcast_timestamp Object stdClass Object
Field String latest_podcast_timestamp
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
active Object stdClass Object
Field String active
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
minimumValueForFieldTypeCache NULL
host_name String LocalServer
dbSelected Boolean '1'
test Object stdClass Object
database String Podcast
schema String dbo
row Array
title String Innovation Podcast Ep15
guid String 12705523284bbb1707d7da6
download_count String 7858
table Object stdClass Object
tableName String vw_visible_podcast_items
primaryKey NULL
fieldInfo Array
podcast_item_id Object stdClass Object
Field String podcast_item_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
filename Object stdClass Object
Field String filename
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
pubDate Object stdClass Object
Field String pubDate
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_duration Object stdClass Object
Field String itunes_duration
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
keywords Object stdClass Object
Field String keywords
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
length Object stdClass Object
Field String length
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
type Object stdClass Object
Field String type
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
duration_secs Object stdClass Object
Field String duration_secs
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
bitrate Object stdClass Object
Field String bitrate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_framerate Object stdClass Object
Field String media_framerate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_medium Object stdClass Object
Field String media_medium
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
media_width Object stdClass Object
Field String media_width
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_height Object stdClass Object
Field String media_height
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_channels Object stdClass Object
Field String media_channels
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_samplingrate Object stdClass Object
Field String media_samplingrate
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
id3_genre Object stdClass Object
Field String id3_genre
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
guid Object stdClass Object
Field String guid
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
download_count Object stdClass Object
Field String download_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_download Object stdClass Object
Field String last_download
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
3 Object clistitem Object
thisPage NULL
DbAccess Object cdbaccessmssql Object
db_name String podcast
db_user String PodcastFM PHP
db_pass String iZxr662dxl1bOgb
conn Resource 'Resource id #18'
resultCache Array
24 String SET DATEFORMAT dmy
25 String UPDATE [tracked_sessions] SET [last_access]='1328384283', [exit_page]='index.php' WHERE [tracked_sessions_id]='5103945';
35 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'settings';
37 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
38 String USE Podcast\n
39 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'settings' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
40 String UPDATE [settings] SET [var_value]='1328384283' WHERE [var_name]='cache_last_cleared_timestamp';
41 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_items';
43 String USE Podcast\n
44 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_items' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
72 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1328054400')  ORDER BY [download_count] DESC, [pubDate] DESC;
76 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [download_count] DESC, [pubDate] DESC;
84 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_extended_subscriber_log';
86 String USE Podcast\n
87 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_extended_subscriber_log' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
95 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='02')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
101 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [last_download] DESC;
110 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'tracked_sessions';
112 String USE Podcast\n
113 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'tracked_sessions' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
114 String SELECT * FROM [Podcast].[dbo].[tracked_sessions] WHERE ([tracked_sessions].[last_access]>'1328383684') ;
117 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'users';
118 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
119 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_channels';
121 String USE Podcast\n
122 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_channels' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
143 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
149 String 	SELECT     	podcast_channel_id\r\n				FROM		subscriber_log\r\n				GROUP BY 	podcast_channel_id, check_month, check_year\r\n				HAVING      (check_month = 02) AND (check_year = 2012)\r\n				ORDER BY 	COUNT(subscriber_log_id) DESC
databaseAndSchemaCache Array
settings Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_items Object stdClass Object
database String Podcast
schema String dbo
vw_extended_subscriber_log Object stdClass Object
database String Podcast
schema String dbo
tracked_sessions Object stdClass Object
database String Podcast
schema String dbo
users Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_channels Object stdClass Object
database String Podcast
schema String dbo
primaryKeyCache Array
settings String settings_id
vw_visible_podcast_items NULL
vw_extended_subscriber_log NULL
tracked_sessions String tracked_sessions_id
vw_visible_podcast_channels NULL
fieldInfoCache Array
settings Array
settings_id Object stdClass Object
Field String settings_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
var_name Object stdClass Object
Field String var_name
Type String varchar(100)
Null String 
Key String 
Default String 
Extra String 
var_value Object stdClass Object
Field String var_value
Type String varchar(1000)
Null String 
Key String 
Default String 
Extra String 
description Object stdClass Object
Field String description
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_items Array
podcast_item_id Object stdClass Object
Field String podcast_item_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
filename Object stdClass Object
Field String filename
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
pubDate Object stdClass Object
Field String pubDate
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_duration Object stdClass Object
Field String itunes_duration
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
keywords Object stdClass Object
Field String keywords
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
length Object stdClass Object
Field String length
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
type Object stdClass Object
Field String type
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
duration_secs Object stdClass Object
Field String duration_secs
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
bitrate Object stdClass Object
Field String bitrate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_framerate Object stdClass Object
Field String media_framerate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_medium Object stdClass Object
Field String media_medium
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
media_width Object stdClass Object
Field String media_width
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_height Object stdClass Object
Field String media_height
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_channels Object stdClass Object
Field String media_channels
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_samplingrate Object stdClass Object
Field String media_samplingrate
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
id3_genre Object stdClass Object
Field String id3_genre
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
guid Object stdClass Object
Field String guid
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
download_count Object stdClass Object
Field String download_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_download Object stdClass Object
Field String last_download
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
vw_extended_subscriber_log Array
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
check_month Object stdClass Object
Field String check_month
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
check_year Object stdClass Object
Field String check_year
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
tracked_sessions Array
tracked_sessions_id Object stdClass Object
Field String tracked_sessions_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
entry_time Object stdClass Object
Field String entry_time
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
entry_page Object stdClass Object
Field String entry_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
exit_page Object stdClass Object
Field String exit_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_channels Array
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_name Object stdClass Object
Field String itunes_owner_name
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_email Object stdClass Object
Field String itunes_owner_email
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_image Object stdClass Object
Field String itunes_image
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_category Object stdClass Object
Field String itunes_category
Type String varchar(1000)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
private Object stdClass Object
Field String private
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
allow_comments Object stdClass Object
Field String allow_comments
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
expiry_date Object stdClass Object
Field String expiry_date
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
item_count Object stdClass Object
Field String item_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
latest_podcast_timestamp Object stdClass Object
Field String latest_podcast_timestamp
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
active Object stdClass Object
Field String active
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
minimumValueForFieldTypeCache NULL
host_name String LocalServer
dbSelected Boolean '1'
test Object stdClass Object
database String Podcast
schema String dbo
row Array
title String Innovation Podcast Ep18
guid String 12810935884c5befd4acfa3
download_count String 7552
table Object stdClass Object
tableName String vw_visible_podcast_items
primaryKey NULL
fieldInfo Array
podcast_item_id Object stdClass Object
Field String podcast_item_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
filename Object stdClass Object
Field String filename
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
pubDate Object stdClass Object
Field String pubDate
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_duration Object stdClass Object
Field String itunes_duration
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
keywords Object stdClass Object
Field String keywords
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
length Object stdClass Object
Field String length
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
type Object stdClass Object
Field String type
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
duration_secs Object stdClass Object
Field String duration_secs
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
bitrate Object stdClass Object
Field String bitrate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_framerate Object stdClass Object
Field String media_framerate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_medium Object stdClass Object
Field String media_medium
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
media_width Object stdClass Object
Field String media_width
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_height Object stdClass Object
Field String media_height
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_channels Object stdClass Object
Field String media_channels
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_samplingrate Object stdClass Object
Field String media_samplingrate
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
id3_genre Object stdClass Object
Field String id3_genre
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
guid Object stdClass Object
Field String guid
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
download_count Object stdClass Object
Field String download_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_download Object stdClass Object
Field String last_download
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
4 Object clistitem Object
thisPage NULL
DbAccess Object cdbaccessmssql Object
db_name String podcast
db_user String PodcastFM PHP
db_pass String iZxr662dxl1bOgb
conn Resource 'Resource id #18'
resultCache Array
24 String SET DATEFORMAT dmy
25 String UPDATE [tracked_sessions] SET [last_access]='1328384283', [exit_page]='index.php' WHERE [tracked_sessions_id]='5103945';
35 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'settings';
37 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
38 String USE Podcast\n
39 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'settings' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
40 String UPDATE [settings] SET [var_value]='1328384283' WHERE [var_name]='cache_last_cleared_timestamp';
41 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_items';
43 String USE Podcast\n
44 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_items' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
72 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1328054400')  ORDER BY [download_count] DESC, [pubDate] DESC;
76 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [download_count] DESC, [pubDate] DESC;
84 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_extended_subscriber_log';
86 String USE Podcast\n
87 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_extended_subscriber_log' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
95 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='02')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
101 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [last_download] DESC;
110 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'tracked_sessions';
112 String USE Podcast\n
113 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'tracked_sessions' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
114 String SELECT * FROM [Podcast].[dbo].[tracked_sessions] WHERE ([tracked_sessions].[last_access]>'1328383684') ;
117 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'users';
118 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
119 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_channels';
121 String USE Podcast\n
122 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_channels' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
143 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
149 String 	SELECT     	podcast_channel_id\r\n				FROM		subscriber_log\r\n				GROUP BY 	podcast_channel_id, check_month, check_year\r\n				HAVING      (check_month = 02) AND (check_year = 2012)\r\n				ORDER BY 	COUNT(subscriber_log_id) DESC
databaseAndSchemaCache Array
settings Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_items Object stdClass Object
database String Podcast
schema String dbo
vw_extended_subscriber_log Object stdClass Object
database String Podcast
schema String dbo
tracked_sessions Object stdClass Object
database String Podcast
schema String dbo
users Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_channels Object stdClass Object
database String Podcast
schema String dbo
primaryKeyCache Array
settings String settings_id
vw_visible_podcast_items NULL
vw_extended_subscriber_log NULL
tracked_sessions String tracked_sessions_id
vw_visible_podcast_channels NULL
fieldInfoCache Array
settings Array
settings_id Object stdClass Object
Field String settings_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
var_name Object stdClass Object
Field String var_name
Type String varchar(100)
Null String 
Key String 
Default String 
Extra String 
var_value Object stdClass Object
Field String var_value
Type String varchar(1000)
Null String 
Key String 
Default String 
Extra String 
description Object stdClass Object
Field String description
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_items Array
podcast_item_id Object stdClass Object
Field String podcast_item_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
filename Object stdClass Object
Field String filename
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
pubDate Object stdClass Object
Field String pubDate
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_duration Object stdClass Object
Field String itunes_duration
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
keywords Object stdClass Object
Field String keywords
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
length Object stdClass Object
Field String length
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
type Object stdClass Object
Field String type
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
duration_secs Object stdClass Object
Field String duration_secs
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
bitrate Object stdClass Object
Field String bitrate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_framerate Object stdClass Object
Field String media_framerate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_medium Object stdClass Object
Field String media_medium
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
media_width Object stdClass Object
Field String media_width
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_height Object stdClass Object
Field String media_height
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_channels Object stdClass Object
Field String media_channels
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_samplingrate Object stdClass Object
Field String media_samplingrate
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
id3_genre Object stdClass Object
Field String id3_genre
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
guid Object stdClass Object
Field String guid
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
download_count Object stdClass Object
Field String download_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_download Object stdClass Object
Field String last_download
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
vw_extended_subscriber_log Array
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
check_month Object stdClass Object
Field String check_month
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
check_year Object stdClass Object
Field String check_year
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
tracked_sessions Array
tracked_sessions_id Object stdClass Object
Field String tracked_sessions_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
entry_time Object stdClass Object
Field String entry_time
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
entry_page Object stdClass Object
Field String entry_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
exit_page Object stdClass Object
Field String exit_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_channels Array
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_name Object stdClass Object
Field String itunes_owner_name
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_email Object stdClass Object
Field String itunes_owner_email
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_image Object stdClass Object
Field String itunes_image
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_category Object stdClass Object
Field String itunes_category
Type String varchar(1000)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
private Object stdClass Object
Field String private
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
allow_comments Object stdClass Object
Field String allow_comments
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
expiry_date Object stdClass Object
Field String expiry_date
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
item_count Object stdClass Object
Field String item_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
latest_podcast_timestamp Object stdClass Object
Field String latest_podcast_timestamp
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
active Object stdClass Object
Field String active
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
minimumValueForFieldTypeCache NULL
host_name String LocalServer
dbSelected Boolean '1'
test Object stdClass Object
database String Podcast
schema String dbo
row Array
title String Innovation Podcast Ep26
guid String 13052827854dcd08e0d436d
download_count String 7356
table Object stdClass Object
tableName String vw_visible_podcast_items
primaryKey NULL
fieldInfo Array
podcast_item_id Object stdClass Object
Field String podcast_item_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
filename Object stdClass Object
Field String filename
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
pubDate Object stdClass Object
Field String pubDate
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_duration Object stdClass Object
Field String itunes_duration
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
keywords Object stdClass Object
Field String keywords
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
length Object stdClass Object
Field String length
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
type Object stdClass Object
Field String type
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
duration_secs Object stdClass Object
Field String duration_secs
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
bitrate Object stdClass Object
Field String bitrate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_framerate Object stdClass Object
Field String media_framerate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_medium Object stdClass Object
Field String media_medium
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
media_width Object stdClass Object
Field String media_width
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_height Object stdClass Object
Field String media_height
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_channels Object stdClass Object
Field String media_channels
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_samplingrate Object stdClass Object
Field String media_samplingrate
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
id3_genre Object stdClass Object
Field String id3_genre
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
guid Object stdClass Object
Field String guid
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
download_count Object stdClass Object
Field String download_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_download Object stdClass Object
Field String last_download
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
itemCount Integer '5'
searchFields Array
searchCriteria String 
relatedSort NULL
num Integer '1'
item Object clistitem Object
thisPage NULL
DbAccess Object cdbaccessmssql Object
db_name String podcast
db_user String PodcastFM PHP
db_pass String iZxr662dxl1bOgb
conn Resource 'Resource id #18'
resultCache Array
24 String SET DATEFORMAT dmy
25 String UPDATE [tracked_sessions] SET [last_access]='1328384283', [exit_page]='index.php' WHERE [tracked_sessions_id]='5103945';
35 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'settings';
37 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
38 String USE Podcast\n
39 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'settings' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
40 String UPDATE [settings] SET [var_value]='1328384283' WHERE [var_name]='cache_last_cleared_timestamp';
41 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_items';
43 String USE Podcast\n
44 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_items' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
72 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1328054400')  ORDER BY [download_count] DESC, [pubDate] DESC;
76 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [download_count] DESC, [pubDate] DESC;
84 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_extended_subscriber_log';
86 String USE Podcast\n
87 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_extended_subscriber_log' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
95 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='02')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
101 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [last_download] DESC;
110 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'tracked_sessions';
112 String USE Podcast\n
113 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'tracked_sessions' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
114 String SELECT * FROM [Podcast].[dbo].[tracked_sessions] WHERE ([tracked_sessions].[last_access]>'1328383684') ;
117 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'users';
118 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
119 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_channels';
121 String USE Podcast\n
122 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_channels' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
143 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
149 String 	SELECT     	podcast_channel_id\r\n				FROM		subscriber_log\r\n				GROUP BY 	podcast_channel_id, check_month, check_year\r\n				HAVING      (check_month = 02) AND (check_year = 2012)\r\n				ORDER BY 	COUNT(subscriber_log_id) DESC
databaseAndSchemaCache Array
settings Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_items Object stdClass Object
database String Podcast
schema String dbo
vw_extended_subscriber_log Object stdClass Object
database String Podcast
schema String dbo
tracked_sessions Object stdClass Object
database String Podcast
schema String dbo
users Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_channels Object stdClass Object
database String Podcast
schema String dbo
primaryKeyCache Array
settings String settings_id
vw_visible_podcast_items NULL
vw_extended_subscriber_log NULL
tracked_sessions String tracked_sessions_id
vw_visible_podcast_channels NULL
fieldInfoCache Array
settings Array
settings_id Object stdClass Object
Field String settings_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
var_name Object stdClass Object
Field String var_name
Type String varchar(100)
Null String 
Key String 
Default String 
Extra String 
var_value Object stdClass Object
Field String var_value
Type String varchar(1000)
Null String 
Key String 
Default String 
Extra String 
description Object stdClass Object
Field String description
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_items Array
podcast_item_id Object stdClass Object
Field String podcast_item_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
filename Object stdClass Object
Field String filename
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
pubDate Object stdClass Object
Field String pubDate
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_duration Object stdClass Object
Field String itunes_duration
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
keywords Object stdClass Object
Field String keywords
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
length Object stdClass Object
Field String length
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
type Object stdClass Object
Field String type
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
duration_secs Object stdClass Object
Field String duration_secs
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
bitrate Object stdClass Object
Field String bitrate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_framerate Object stdClass Object
Field String media_framerate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_medium Object stdClass Object
Field String media_medium
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
media_width Object stdClass Object
Field String media_width
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_height Object stdClass Object
Field String media_height
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_channels Object stdClass Object
Field String media_channels
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_samplingrate Object stdClass Object
Field String media_samplingrate
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
id3_genre Object stdClass Object
Field String id3_genre
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
guid Object stdClass Object
Field String guid
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
download_count Object stdClass Object
Field String download_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_download Object stdClass Object
Field String last_download
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
vw_extended_subscriber_log Array
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
check_month Object stdClass Object
Field String check_month
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
check_year Object stdClass Object
Field String check_year
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
tracked_sessions Array
tracked_sessions_id Object stdClass Object
Field String tracked_sessions_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
entry_time Object stdClass Object
Field String entry_time
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
entry_page Object stdClass Object
Field String entry_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
exit_page Object stdClass Object
Field String exit_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_channels Array
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_name Object stdClass Object
Field String itunes_owner_name
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_email Object stdClass Object
Field String itunes_owner_email
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_image Object stdClass Object
Field String itunes_image
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_category Object stdClass Object
Field String itunes_category
Type String varchar(1000)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
private Object stdClass Object
Field String private
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
allow_comments Object stdClass Object
Field String allow_comments
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
expiry_date Object stdClass Object
Field String expiry_date
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
item_count Object stdClass Object
Field String item_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
latest_podcast_timestamp Object stdClass Object
Field String latest_podcast_timestamp
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
active Object stdClass Object
Field String active
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
minimumValueForFieldTypeCache NULL
host_name String LocalServer
dbSelected Boolean '1'
test Object stdClass Object
database String Podcast
schema String dbo
row Array
podcast_item_id String 785
podcast_channel_id String 54
user_id String 150
title String Show # 069 - Creative Thinking For Non Creative People
itunes_author String Anna Farmery
itunes_subtitle String Interview with Todd Henry
itunes_summary String Creative thinking is part of growing a successful business. How do you bring creativity into a team that is not naturally creative, how can you develop ideas and a culture that supports new ideas
filename String show69.mp3
pubDate String 1173744000
itunes_duration String 30:18
keywords String creativity,work and business,leadership development,management skills,team building,creative thinking,hr,innovation
length String 14545734
type String audio/mpeg
itunes_explicit String 0
duration_secs String 1818
bitrate String 64
media_framerate String 
media_medium String audio
media_width String 
media_height String 
media_channels String 1
media_samplingrate String 44.1
id3_genre String Speech
guid String 117379598445f6b499cd360
download_count String 8311
last_download String 1328378217
table Object stdClass Object
tableName String vw_visible_podcast_items
primaryKey NULL
fieldInfo Array
podcast_item_id Object stdClass Object
Field String podcast_item_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
filename Object stdClass Object
Field String filename
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
pubDate Object stdClass Object
Field String pubDate
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_duration Object stdClass Object
Field String itunes_duration
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
keywords Object stdClass Object
Field String keywords
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
length Object stdClass Object
Field String length
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
type Object stdClass Object
Field String type
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
duration_secs Object stdClass Object
Field String duration_secs
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
bitrate Object stdClass Object
Field String bitrate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_framerate Object stdClass Object
Field String media_framerate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_medium Object stdClass Object
Field String media_medium
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
media_width Object stdClass Object
Field String media_width
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_height Object stdClass Object
Field String media_height
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_channels Object stdClass Object
Field String media_channels
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_samplingrate Object stdClass Object
Field String media_samplingrate
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
id3_genre Object stdClass Object
Field String id3_genre
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
guid Object stdClass Object
Field String guid
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
download_count Object stdClass Object
Field String download_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_download Object stdClass Object
Field String last_download
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
row Boolean ''
popularChannelsBySubscriber Object clist Object
thisPage NULL
DbAccess Object cdbaccessmssql Object
db_name String podcast
db_user String PodcastFM PHP
db_pass String iZxr662dxl1bOgb
conn Resource 'Resource id #18'
resultCache Array
24 String SET DATEFORMAT dmy
25 String UPDATE [tracked_sessions] SET [last_access]='1328384283', [exit_page]='index.php' WHERE [tracked_sessions_id]='5103945';
35 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'settings';
37 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
38 String USE Podcast\n
39 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'settings' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
40 String UPDATE [settings] SET [var_value]='1328384283' WHERE [var_name]='cache_last_cleared_timestamp';
41 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_items';
43 String USE Podcast\n
44 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_items' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
72 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1328054400')  ORDER BY [download_count] DESC, [pubDate] DESC;
76 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [download_count] DESC, [pubDate] DESC;
84 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_extended_subscriber_log';
86 String USE Podcast\n
87 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_extended_subscriber_log' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
95 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='02')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
101 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [last_download] DESC;
110 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'tracked_sessions';
112 String USE Podcast\n
113 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'tracked_sessions' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
114 String SELECT * FROM [Podcast].[dbo].[tracked_sessions] WHERE ([tracked_sessions].[last_access]>'1328383684') ;
117 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'users';
118 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
119 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_channels';
121 String USE Podcast\n
122 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_channels' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
143 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
149 String 	SELECT     	podcast_channel_id\r\n				FROM		subscriber_log\r\n				GROUP BY 	podcast_channel_id, check_month, check_year\r\n				HAVING      (check_month = 02) AND (check_year = 2012)\r\n				ORDER BY 	COUNT(subscriber_log_id) DESC
databaseAndSchemaCache Array
settings Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_items Object stdClass Object
database String Podcast
schema String dbo
vw_extended_subscriber_log Object stdClass Object
database String Podcast
schema String dbo
tracked_sessions Object stdClass Object
database String Podcast
schema String dbo
users Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_channels Object stdClass Object
database String Podcast
schema String dbo
primaryKeyCache Array
settings String settings_id
vw_visible_podcast_items NULL
vw_extended_subscriber_log NULL
tracked_sessions String tracked_sessions_id
vw_visible_podcast_channels NULL
fieldInfoCache Array
settings Array
settings_id Object stdClass Object
Field String settings_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
var_name Object stdClass Object
Field String var_name
Type String varchar(100)
Null String 
Key String 
Default String 
Extra String 
var_value Object stdClass Object
Field String var_value
Type String varchar(1000)
Null String 
Key String 
Default String 
Extra String 
description Object stdClass Object
Field String description
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_items Array
podcast_item_id Object stdClass Object
Field String podcast_item_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
filename Object stdClass Object
Field String filename
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
pubDate Object stdClass Object
Field String pubDate
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_duration Object stdClass Object
Field String itunes_duration
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
keywords Object stdClass Object
Field String keywords
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
length Object stdClass Object
Field String length
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
type Object stdClass Object
Field String type
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
duration_secs Object stdClass Object
Field String duration_secs
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
bitrate Object stdClass Object
Field String bitrate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_framerate Object stdClass Object
Field String media_framerate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_medium Object stdClass Object
Field String media_medium
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
media_width Object stdClass Object
Field String media_width
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_height Object stdClass Object
Field String media_height
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_channels Object stdClass Object
Field String media_channels
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_samplingrate Object stdClass Object
Field String media_samplingrate
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
id3_genre Object stdClass Object
Field String id3_genre
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
guid Object stdClass Object
Field String guid
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
download_count Object stdClass Object
Field String download_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_download Object stdClass Object
Field String last_download
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
vw_extended_subscriber_log Array
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
check_month Object stdClass Object
Field String check_month
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
check_year Object stdClass Object
Field String check_year
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
tracked_sessions Array
tracked_sessions_id Object stdClass Object
Field String tracked_sessions_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
entry_time Object stdClass Object
Field String entry_time
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
entry_page Object stdClass Object
Field String entry_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
exit_page Object stdClass Object
Field String exit_page
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_channels Array
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_name Object stdClass Object
Field String itunes_owner_name
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_owner_email Object stdClass Object
Field String itunes_owner_email
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_image Object stdClass Object
Field String itunes_image
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_category Object stdClass Object
Field String itunes_category
Type String varchar(1000)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
private Object stdClass Object
Field String private
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
allow_comments Object stdClass Object
Field String allow_comments
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
expiry_date Object stdClass Object
Field String expiry_date
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_access Object stdClass Object
Field String last_access
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
item_count Object stdClass Object
Field String item_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
latest_podcast_timestamp Object stdClass Object
Field String latest_podcast_timestamp
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
active Object stdClass Object
Field String active
Type String bit(1)
Null String YES
Key String 
Default String 
Extra String 
minimumValueForFieldTypeCache NULL
host_name String LocalServer
dbSelected Boolean '1'
test Object stdClass Object
database String Podcast
schema String dbo
row NULL
table Object stdClass Object
tableName String vw_extended_subscriber_log
primaryKey NULL
fieldInfo Array
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
check_month Object stdClass Object
Field String check_month
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
check_year Object stdClass Object
Field String check_year
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
subscriber_count Object stdClass Object
Field String subscriber_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
restriction Array
0 Object stdClass Object
field String check_month
id String 02
1 Object stdClass Object
field String check_year
id String 2012
sort Object stdClass Object
field String subscriber_count
direction String DESC
limit Object stdClass Object
maxRows Integer '5'
select String *
andOr String AND
usePrimaryKey NULL
groupBy NULL
items Array
itemCount Integer '0'
searchFields Array
searchCriteria String 
relatedSort NULL
myItems Object clist Object
thisPage NULL
DbAccess Object cdbaccessmssql Object
db_name String podcast
db_user String PodcastFM PHP
db_pass String iZxr662dxl1bOgb
conn Resource 'Resource id #18'
resultCache Array
24 String SET DATEFORMAT dmy
25 String UPDATE [tracked_sessions] SET [last_access]='1328384283', [exit_page]='index.php' WHERE [tracked_sessions_id]='5103945';
35 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'settings';
37 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
38 String USE Podcast\n
39 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'settings' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
40 String UPDATE [settings] SET [var_value]='1328384283' WHERE [var_name]='cache_last_cleared_timestamp';
41 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_items';
43 String USE Podcast\n
44 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_items' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
72 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1328054400')  ORDER BY [download_count] DESC, [pubDate] DESC;
76 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [download_count] DESC, [pubDate] DESC;
84 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_extended_subscriber_log';
86 String USE Podcast\n
87 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_extended_subscriber_log' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
95 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='02')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
101 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_items] ORDER BY [last_download] DESC;
110 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'tracked_sessions';
112 String USE Podcast\n
113 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'tracked_sessions' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
114 String SELECT * FROM [Podcast].[dbo].[tracked_sessions] WHERE ([tracked_sessions].[last_access]>'1328383684') ;
117 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'users';
118 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
119 String SELECT DISTINCT db_name() AS [database], user_name(uid) AS [schema] FROM [sysobjects] WHERE [xtype] in ('U', 'V') AND permissions([id]) != 0 AND [name] = 'vw_visible_podcast_channels';
121 String USE Podcast\n
122 String SELECT [syscolumns].[name] as Field, [systypes].[name] as [Type], [syscolumns].[length] as [Length], [syscolumns].[isnullable] as [Null], [syscomments].[text] as [Default] FROM [sysobjects], [syscolumns] LEFT OUTER JOIN [syscomments] on [syscolumns].[cdefault] = [syscomments].[id], [systypes] WHERE [sysobjects].[xtype] in ('U', 'V') AND permissions([sysobjects].[id]) != 0 AND [sysobjects].[name] = 'vw_visible_podcast_channels' AND [syscolumns].[id] = [sysobjects].[id] AND [syscolumns].[xtype] = [systypes].[xtype] ORDER BY [syscolumns].[colorder]
143 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
149 String 	SELECT     	podcast_channel_id\r\n				FROM		subscriber_log\r\n				GROUP BY 	podcast_channel_id, check_month, check_year\r\n				HAVING      (check_month = 02) AND (check_year = 2012)\r\n				ORDER BY 	COUNT(subscriber_log_id) DESC
databaseAndSchemaCache Array
settings Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_items Object stdClass Object
database String Podcast
schema String dbo
vw_extended_subscriber_log Object stdClass Object
database String Podcast
schema String dbo
tracked_sessions Object stdClass Object
database String Podcast
schema String dbo
users Object stdClass Object
database String Podcast
schema String dbo
vw_visible_podcast_channels Object stdClass Object
database String Podcast
schema String dbo
primaryKeyCache Array
settings String settings_id
vw_visible_podcast_items NULL
vw_extended_subscriber_log NULL
tracked_sessions String tracked_sessions_id
vw_visible_podcast_channels NULL
fieldInfoCache Array
settings Array
settings_id Object stdClass Object
Field String settings_id
Type String int(4)
Null String 
Key String PRI
Default String 
Extra String 
var_name Object stdClass Object
Field String var_name
Type String varchar(100)
Null String 
Key String 
Default String 
Extra String 
var_value Object stdClass Object
Field String var_value
Type String varchar(1000)
Null String 
Key String 
Default String 
Extra String 
description Object stdClass Object
Field String description
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
vw_visible_podcast_items Array
podcast_item_id Object stdClass Object
Field String podcast_item_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
podcast_channel_id Object stdClass Object
Field String podcast_channel_id
Type String int(4)
Null String 
Key String 
Default String 
Extra String 
user_id Object stdClass Object
Field String user_id
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
title Object stdClass Object
Field String title
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_author Object stdClass Object
Field String itunes_author
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_subtitle Object stdClass Object
Field String itunes_subtitle
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
itunes_summary Object stdClass Object
Field String itunes_summary
Type String varchar(4000)
Null String YES
Key String 
Default String 
Extra String 
filename Object stdClass Object
Field String filename
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
pubDate Object stdClass Object
Field String pubDate
Type String varchar(255)
Null String 
Key String 
Default String 
Extra String 
itunes_duration Object stdClass Object
Field String itunes_duration
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
keywords Object stdClass Object
Field String keywords
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
length Object stdClass Object
Field String length
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
type Object stdClass Object
Field String type
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
itunes_explicit Object stdClass Object
Field String itunes_explicit
Type String tinyint(1)
Null String YES
Key String 
Default String 
Extra String 
duration_secs Object stdClass Object
Field String duration_secs
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
bitrate Object stdClass Object
Field String bitrate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_framerate Object stdClass Object
Field String media_framerate
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_medium Object stdClass Object
Field String media_medium
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
media_width Object stdClass Object
Field String media_width
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_height Object stdClass Object
Field String media_height
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_channels Object stdClass Object
Field String media_channels
Type String smallint(2)
Null String YES
Key String 
Default String 
Extra String 
media_samplingrate Object stdClass Object
Field String media_samplingrate
Type String varchar(10)
Null String YES
Key String 
Default String 
Extra String 
id3_genre Object stdClass Object
Field String id3_genre
Type String varchar(50)
Null String YES
Key String 
Default String 
Extra String 
guid Object stdClass Object
Field String guid
Type String varchar(255)
Null String YES
Key String 
Default String 
Extra String 
download_count Object stdClass Object
Field String download_count
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
last_download Object stdClass Object
Field String last_download
Type String int(4)
Null String YES
Key String 
Default String 
Extra String 
vw_extended_subscriber_log Array