Global Subscribers Management

The Global Subscribers page provides comprehensive management of global advertisement subscriptions across all sites in the network. This interface allows administrators to search, view, and manage ad placements, monitor subscription status, and control the activation/deactivation of global advertisements across multiple domains.

---

Toolbar Functions

Button	Function
Back	Returns to the previous page in browser history
Search Box	Enter text to search across subscription IDs, site names, and page names. Press Enter or click Search button to execute
Search	Executes the search query entered in the search box
Show All	Clears all search filters and displays all global subscribers

Alphabetical Filters

The alphabetical button row allows quick filtering of results by the first character of site names:

• ALL - Shows all subscribers regardless of starting character
• 0-9 - Shows subscribers starting with numbers
• A-Z - Shows subscribers starting with the selected letter

---

Subscriber Table Columns

Column	Description	Sortable
Site	Domain name of the subscriber site. Underscores are displayed as dots (e.g., example_com shows as example.com). Links to ad details page	â??
Sponsor	Name of the sponsor/advertiser. Links to subscriber details window	â??
Category	Advertisement category classification	â??
Page	Specific page where the ad is displayed. Links to the actual page	â??
Width	Advertisement width in pixels	â??
Height	Advertisement height in pixels	â??
Status	Subscription status - Active or InActive. Click to toggle status	â??
View	Opens detailed ad information in a new browser tab	-
ID	Unique global subscription identifier number	â??

---

Search Functionality

Search Scope

The search function queries across multiple fields:

• Subscription ID - Exact or partial matches
• Site Domain - Partial matches in domain names
• Page Names - Partial matches in GlobalAdSpace_Page field

Search Behavior

1. Enter search terms in the search box
2. Press Enter key or click the Search button
3. Results are filtered to show matching records
4. Search terms are displayed in blue text above results
5. Record count is shown for search results

---

Status Management

Activation Workflow

1. Locate the subscription in the table
2. Check the Status column for current state
3. Click on the status text to toggle:
   • Active - Click to deactivate
   • InActive - Click to activate
4. Page refreshes automatically with updated status

Status Effects

• Active Subscriptions - Ads are displayed on the specified pages
• Inactive Subscriptions - Ads are hidden but subscription data is preserved
• Status Changes - Take effect immediately across all network sites

---

Sorting Options

Click any column header to sort the table by that field. Sorting behavior:

Column	Sort Behavior
Site	Alphabetical by domain name
Sponsor	Alphabetical by sponsor name
Category	Alphabetical by category name
Page	Alphabetical by page name
Width/Height	Numerical ascending/descending
ID	Numerical by subscription ID

Click the same column header again to reverse the sort order. Arrow indicators show current sort direction.

---

Permission Requirements

Access Control

This page requires administrator-level permissions:

• Client ID = 1 - Full administrative access required
• Users Permission - Must be included in sponsor permissions
• Workgroup Access - Limited to assigned workgroups for non-admin users

Restricted Actions

• Status changes require admin privileges
• View access to detailed ad information
• Search across all network sites

---

Data Relationships

The Global Subscribers system connects several database tables:

Table	Purpose
Global_AdSubscriptions	Main subscription records with status and relationships
Global_AdSpace	Ad placement locations and dimensions
Global_Ads	Advertisement content and properties
Global_AdSpaceMembers	Subscriber membership information
Local Sponsors Table	Site-specific sponsor details and names

---

---

Troubleshooting

Common Issues

Issue	Solution
No search results	Check spelling, try partial terms, or use "Show All" to reset filters
Status not changing	Verify admin permissions and refresh the page
Missing sponsor names	Check if sponsor exists in the local site's sponsor table
Access denied	Contact system administrator to verify user permissions

Performance Notes

• Large result sets may load slowly - use search filters to narrow results
• Status changes are processed immediately but may take a moment to reflect
• Cross-database queries may have slight delays