
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
_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_HOST:www.podcastfm.co.uk\nHTTP_USER_AGENT:CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\nHTTP_X_CC_ID:ccc01-02\nHTTP_X_REWRITE_URL:/\n
HTTPS String off
SCRIPT_NAME String /index.php
HTTP_COOKIE String 
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.211
REMOTE_HOST String 38.107.179.211
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_USER_AGENT String CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID String ccc01-02
HTTP_X_REWRITE_URL String /
argv Array
0 String 
_ENV Array
_FILES Array
_REQUEST 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 INSERT INTO [tracked_sessions] ([entry_time],[last_access],[entry_page],[exit_page]) VALUES ('1327813513','1327813513','index.php','index.php');
26 String SELECT @@IDENTITY;
27 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';
29 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_clear_interval') ;
39 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
40 String USE Podcast\n
41 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]
42 String UPDATE [settings] SET [var_value]='1327813513' WHERE [var_name]='cache_last_cleared_timestamp';
43 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';
45 String USE Podcast\n
46 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]
74 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1325376000')  ORDER BY [download_count] DESC, [pubDate] DESC;
82 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';
84 String USE Podcast\n
85 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]
93 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='01')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
99 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] = 'users';
111 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
112 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';
114 String USE Podcast\n
115 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]
136 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
142 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 = 01) 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
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
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 
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 INSERT INTO [tracked_sessions] ([entry_time],[last_access],[entry_page],[exit_page]) VALUES ('1327813513','1327813513','index.php','index.php');
26 String SELECT @@IDENTITY;
27 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';
29 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_clear_interval') ;
39 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
40 String USE Podcast\n
41 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]
42 String UPDATE [settings] SET [var_value]='1327813513' WHERE [var_name]='cache_last_cleared_timestamp';
43 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';
45 String USE Podcast\n
46 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]
74 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1325376000')  ORDER BY [download_count] DESC, [pubDate] DESC;
82 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';
84 String USE Podcast\n
85 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]
93 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='01')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
99 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] = 'users';
111 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
112 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';
114 String USE Podcast\n
115 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]
136 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
142 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 = 01) 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
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
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 
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 5047165
cache_clear_interval String 180
cache_next_db_check Integer '1327813573'
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
insert_array Array
entry_time Integer '1327813513'
last_access Integer '1327813513'
entry_page String index.php
exit_page String index.php
tracked_sessions_id String 5047165
insert_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 INSERT INTO [tracked_sessions] ([entry_time],[last_access],[entry_page],[exit_page]) VALUES ('1327813513','1327813513','index.php','index.php');
26 String SELECT @@IDENTITY;
27 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';
29 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_clear_interval') ;
39 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
40 String USE Podcast\n
41 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]
42 String UPDATE [settings] SET [var_value]='1327813513' WHERE [var_name]='cache_last_cleared_timestamp';
43 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';
45 String USE Podcast\n
46 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]
74 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1325376000')  ORDER BY [download_count] DESC, [pubDate] DESC;
82 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';
84 String USE Podcast\n
85 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]
93 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='01')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
99 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] = 'users';
111 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
112 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';
114 String USE Podcast\n
115 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]
136 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
142 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 = 01) 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
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
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 
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 INSERT INTO [tracked_sessions] ([entry_time],[last_access],[entry_page],[exit_page]) VALUES ('1327813513','1327813513','index.php','index.php');
26 String SELECT @@IDENTITY;
27 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';
29 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_clear_interval') ;
39 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
40 String USE Podcast\n
41 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]
42 String UPDATE [settings] SET [var_value]='1327813513' WHERE [var_name]='cache_last_cleared_timestamp';
43 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';
45 String USE Podcast\n
46 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]
74 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1325376000')  ORDER BY [download_count] DESC, [pubDate] DESC;
82 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';
84 String USE Podcast\n
85 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]
93 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='01')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
99 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] = 'users';
111 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
112 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';
114 String USE Podcast\n
115 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]
136 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
142 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 = 01) 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
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
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 
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 Object stdClass Object
field String pubDate
condition String >
id Integer '1325376000'
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 INSERT INTO [tracked_sessions] ([entry_time],[last_access],[entry_page],[exit_page]) VALUES ('1327813513','1327813513','index.php','index.php');
26 String SELECT @@IDENTITY;
27 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';
29 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_clear_interval') ;
39 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
40 String USE Podcast\n
41 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]
42 String UPDATE [settings] SET [var_value]='1327813513' WHERE [var_name]='cache_last_cleared_timestamp';
43 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';
45 String USE Podcast\n
46 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]
74 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1325376000')  ORDER BY [download_count] DESC, [pubDate] DESC;
82 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';
84 String USE Podcast\n
85 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]
93 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='01')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
99 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] = 'users';
111 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
112 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';
114 String USE Podcast\n
115 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]
136 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
142 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 = 01) 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
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
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 
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 All about IITS
guid String 13256933184f0479974ac93
download_count String 9
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 INSERT INTO [tracked_sessions] ([entry_time],[last_access],[entry_page],[exit_page]) VALUES ('1327813513','1327813513','index.php','index.php');
26 String SELECT @@IDENTITY;
27 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';
29 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_clear_interval') ;
39 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
40 String USE Podcast\n
41 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]
42 String UPDATE [settings] SET [var_value]='1327813513' WHERE [var_name]='cache_last_cleared_timestamp';
43 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';
45 String USE Podcast\n
46 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]
74 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1325376000')  ORDER BY [download_count] DESC, [pubDate] DESC;
82 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';
84 String USE Podcast\n
85 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]
93 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='01')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
99 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] = 'users';
111 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
112 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';
114 String USE Podcast\n
115 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]
136 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
142 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 = 01) 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
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
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 
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 Kingdom of God - Chris - 8th Jan 12
guid String 13260336674f09ab032253d
download_count String 6
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 INSERT INTO [tracked_sessions] ([entry_time],[last_access],[entry_page],[exit_page]) VALUES ('1327813513','1327813513','index.php','index.php');
26 String SELECT @@IDENTITY;
27 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';
29 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_clear_interval') ;
39 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
40 String USE Podcast\n
41 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]
42 String UPDATE [settings] SET [var_value]='1327813513' WHERE [var_name]='cache_last_cleared_timestamp';
43 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';
45 String USE Podcast\n
46 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]
74 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1325376000')  ORDER BY [download_count] DESC, [pubDate] DESC;
82 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';
84 String USE Podcast\n
85 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]
93 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='01')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
99 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] = 'users';
111 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
112 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';
114 String USE Podcast\n
115 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]
136 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
142 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 = 01) 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
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
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 
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 Baseline 22nd Jan - Linda - Identity
guid String 13272436124f1c215bb5660
download_count String 1
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 INSERT INTO [tracked_sessions] ([entry_time],[last_access],[entry_page],[exit_page]) VALUES ('1327813513','1327813513','index.php','index.php');
26 String SELECT @@IDENTITY;
27 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';
29 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_clear_interval') ;
39 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
40 String USE Podcast\n
41 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]
42 String UPDATE [settings] SET [var_value]='1327813513' WHERE [var_name]='cache_last_cleared_timestamp';
43 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';
45 String USE Podcast\n
46 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]
74 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1325376000')  ORDER BY [download_count] DESC, [pubDate] DESC;
82 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';
84 String USE Podcast\n
85 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]
93 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='01')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
99 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] = 'users';
111 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
112 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';
114 String USE Podcast\n
115 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]
136 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
142 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 = 01) 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
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
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 
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 LeylandSmith22Jan12.mp3
guid String 13274405494f1f22b688c3c
download_count String 1
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 INSERT INTO [tracked_sessions] ([entry_time],[last_access],[entry_page],[exit_page]) VALUES ('1327813513','1327813513','index.php','index.php');
26 String SELECT @@IDENTITY;
27 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';
29 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_clear_interval') ;
39 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
40 String USE Podcast\n
41 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]
42 String UPDATE [settings] SET [var_value]='1327813513' WHERE [var_name]='cache_last_cleared_timestamp';
43 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';
45 String USE Podcast\n
46 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]
74 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1325376000')  ORDER BY [download_count] DESC, [pubDate] DESC;
82 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';
84 String USE Podcast\n
85 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]
93 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='01')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
99 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] = 'users';
111 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
112 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';
114 String USE Podcast\n
115 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]
136 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
142 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 = 01) 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
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
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 
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 PeterKemp15Jan12.mp3
guid String 13274404214f1f2231e42fa
download_count String 1
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 INSERT INTO [tracked_sessions] ([entry_time],[last_access],[entry_page],[exit_page]) VALUES ('1327813513','1327813513','index.php','index.php');
26 String SELECT @@IDENTITY;
27 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';
29 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_clear_interval') ;
39 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
40 String USE Podcast\n
41 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]
42 String UPDATE [settings] SET [var_value]='1327813513' WHERE [var_name]='cache_last_cleared_timestamp';
43 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';
45 String USE Podcast\n
46 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]
74 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1325376000')  ORDER BY [download_count] DESC, [pubDate] DESC;
82 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';
84 String USE Podcast\n
85 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]
93 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='01')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
99 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] = 'users';
111 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
112 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';
114 String USE Podcast\n
115 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]
136 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
142 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 = 01) 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
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
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 
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 3908
podcast_channel_id String 651
user_id String 32
title String House Sessions Bassline
itunes_author String Mr Big
itunes_subtitle String 
itunes_summary String 
filename String pure_bassline_tx_27_03_10.mp3
pubDate String 1269903600
itunes_duration String 64:37
keywords String 
length String 31018560
type String audio/mpeg
itunes_explicit String 0
duration_secs String 3877
bitrate String 64
media_framerate String 
media_medium String audio
media_width String 
media_height String 
media_channels String 2
media_samplingrate String 24
id3_genre String 
guid String 12699694314bb23217d0177
download_count String 70
last_download String 1327805921
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 INSERT INTO [tracked_sessions] ([entry_time],[last_access],[entry_page],[exit_page]) VALUES ('1327813513','1327813513','index.php','index.php');
26 String SELECT @@IDENTITY;
27 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';
29 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_clear_interval') ;
39 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
40 String USE Podcast\n
41 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]
42 String UPDATE [settings] SET [var_value]='1327813513' WHERE [var_name]='cache_last_cleared_timestamp';
43 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';
45 String USE Podcast\n
46 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]
74 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1325376000')  ORDER BY [download_count] DESC, [pubDate] DESC;
82 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';
84 String USE Podcast\n
85 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]
93 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='01')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
99 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] = 'users';
111 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
112 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';
114 String USE Podcast\n
115 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]
136 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
142 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 = 01) 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
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
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 
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 01
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 INSERT INTO [tracked_sessions] ([entry_time],[last_access],[entry_page],[exit_page]) VALUES ('1327813513','1327813513','index.php','index.php');
26 String SELECT @@IDENTITY;
27 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';
29 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_clear_interval') ;
39 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
40 String USE Podcast\n
41 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]
42 String UPDATE [settings] SET [var_value]='1327813513' WHERE [var_name]='cache_last_cleared_timestamp';
43 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';
45 String USE Podcast\n
46 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]
74 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1325376000')  ORDER BY [download_count] DESC, [pubDate] DESC;
82 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';
84 String USE Podcast\n
85 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]
93 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='01')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
99 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] = 'users';
111 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
112 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';
114 String USE Podcast\n
115 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]
136 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
142 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 = 01) 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
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
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 
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 last_download
direction String DESC
limit Object stdClass Object
offset Integer '0'
maxRows Integer '5'
select String *
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 INSERT INTO [tracked_sessions] ([entry_time],[last_access],[entry_page],[exit_page]) VALUES ('1327813513','1327813513','index.php','index.php');
26 String SELECT @@IDENTITY;
27 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';
29 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_clear_interval') ;
39 String SELECT * FROM [Podcast].[dbo].[settings] WHERE ([settings].[var_name]='cache_last_cleared') ;
40 String USE Podcast\n
41 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]
42 String UPDATE [settings] SET [var_value]='1327813513' WHERE [var_name]='cache_last_cleared_timestamp';
43 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';
45 String USE Podcast\n
46 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]
74 String SELECT TOP 5 title, guid, download_count FROM [Podcast].[dbo].[vw_visible_podcast_items] WHERE ([vw_visible_podcast_items].[pubDate]>'1325376000')  ORDER BY [download_count] DESC, [pubDate] DESC;
82 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';
84 String USE Podcast\n
85 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]
93 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_extended_subscriber_log] WHERE ([vw_extended_subscriber_log].[check_month]='01')  AND ([vw_extended_subscriber_log].[check_year]='2012')  ORDER BY [subscriber_count] DESC;
99 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] = 'users';
111 String SELECT TOP 1 * FROM [Podcast].[dbo].[users] ORDER BY [activation_date] DESC;
112 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';
114 String USE Podcast\n
115 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]
136 String SELECT TOP 5 * FROM [Podcast].[dbo].[vw_visible_podcast_channels] ORDER BY [last_access] DESC;
142 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 = 01) 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
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
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