Archive

Posts Tagged ‘restrict’

Php Script For Ccbilling To Restrict 2 Ip Address Logins

January 9th, 2012 Comments off

I will be using CCBilling for my payment for RECURRING subscribers. But they do not have a limit to the IPs that can login per member. I will be using their login and subscription payment system.

I need a PHP script that will restrict EVERY PAYED MEMBER to only 2 IP address logins, so they can not share their account access (user and password).

Please be familiar with the CCBilling payment system.

Email me if you have any questions.

Joomla Restrict Access To Page To Registered Users Only

October 28th, 2011 Comments off

Http://meetyourpsychic.com/horoscopes

We need to restrict access to this page to registered viewers only. When a non-registered person goes to this page, they should see this notice or be redirected to an article with this text:

“We sorry, you must sign up for your FREE account to view your
FREE horoscopes or simply login into your account now.

CREATE MY FREE ACCOUNT”
(links to www.meetyourpsychic.com/welcome)

I’ve installed a plugin and it works, but I need to customize the error message to the above text. http://extensions.joomla.org/extensions/access-a-security/content-restriction/6004

Of course you can use any plugin you want or make it work any way you know how

Restrict Pages In Oscommerce

October 13th, 2011 Comments off

Http://meandconsignment.com

We want to restrict the product pages, to see it customers have to register first.
this will be the only visible pages (no restricted):

1- HOME
2- ABOUT US
3- SELLING W/ US
4- REVIEWS
5- CONTACT US
8- FAQ
9- SHIPPING AND RETURNS

also in the member registration form take out the phone number.

Week 3

June 5th, 2011 Comments off

Use the database and tables from last week’s assignment to write SQL statements and enter records into the Employee table for workers identified in the employee files for the administrative offices and the Del Mar store. Check results by selecting all columns from both tables.

1) Use the database and tables from last week’s assignment to write SQL Select queries using Between, Like with Joins:
a. Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. Use salary to restrict data.
b. Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. Use hire dates to restrict data.
c. Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. Use telephone area codes to restrict data.
d. Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. Use age to restrict data.
e. Write a SQL query that joins the two tables to produce a third table. Use Select Into.
f. Deliverable: Save each SQL Statement for the above in a Word file and post using the Assignments tab with your week 3 individual assignments.
2) Use the updated database to write the following queries:
a. Select employees’ including last names and order them by EEO-1 classification.
b. Select employees’ including last names and order them by salary.
c. Select employees’ last names and order them by salary in their EEO-1 classification.
d. Count employees grouped by Exempt/Non-Exempt Status.
e. Count employees grouped by their EEO-1 classification.
f. Deliverable: Save each SQL Statement for the above in a Word file and post using the Assignments tab with your week 3 individual assignments.

Categories: SQL Tags: , , , , , ,

Php Code Security

March 2nd, 2010 Comments off

Hello, I’m not sure if it is possible but if it is I need a code to restrict access to certain field on a table in a MYSQL database depending on the user logged on the site, I can restrict access to the whole table, but I would like to restrict access just to one field on a table. Thanks for bidding

Restrict Emails Phpfox V2

March 2nd, 2010 Comments off

In PHPFox V2, there is no way at present to restrict number of e-mails in an hour.
Want mod so that PHPFox V2 site-wide e-mails are sent in batches to control number of e-mails in an hour.
Let’s say User 1 has 500 friends. On his Birthday, system generates 500 messages from his friends wishing Birthday, which would generate 500 e-mails. It should be set up in cron-job so that say 300 mails max in an hour.
Or, say, admin sends newsletter to 2000 members, again e-mails would be sent in batches so that say 300 e-mails in an hour.
This is the project.
You have to provide me all modified files & installation instructions. Also, I would retain copyright for resale.
Please quote.

Data Changes & Sql Statements

July 13th, 2009 Comments off

Use the database and tables from last week’s assignment to write SQL statements and enter records into the Employee table for workers identified in the employee files for the administrative offices and the Del Mar store. Check results by selecting all columns from both tables.

Sql Good 3

June 18th, 2009 Comments off

(You are to put all your screen snapshots for the items below, each showing the required SQL statements and results, in order, in a single Microsoft Word file. Failure to do so may result in lost points on this assignment.)

Using the database and tables from Week Two, write SQL statements and enter the records into the Employee table for the workers identified in the Employee Files for the administrative offices and the Del Mar location. Check the results by selecting all of the columns from both of your tables. You should now have 17 total employees and 9 total job titles (2 points)

Using the database and tables in Week Two, write SQL queries using Between, Like and Union: (1 point each)

Two Sql Projects

April 27th, 2009 Comments off

Project #1

Save all of your code in Notepad as a *.txt file and attach it when you submit the project. Take screen shots of all successful implementation of each set of SQL.

Data Changes and SQL Statements

Resource: Table Queries assignment

Use the database and tables that are attached to write SQL statements and enter records into the Employee table for workers identified in the employee files for the administrative offices and the store. Check results by selecting all columns from both tables.

Between, Like, and Union:

Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. Use salary to restrict data.

Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. Use hire dates to restrict data.
Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. Use telephone area codes to restrict data.

Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. Use age to restrict data.

Write a SQL query that uses the UNION of the two tables to produce a third table.

Save each query in a txt file and take a screen shot of its results and submit them as an attachment.

Group:

Use the updated database to write the following queries, using the SQL GROUP statement:

Select employees’ last names and group them by EEO-1 classification.

Select employees’ last names and group them by salary.

Select employees’ last names and group them by salary in their EEO-1 classification.

Select employees’ last names and group them by salary in job titles, grouped into exempt and non-exempt.

Save all the SQL statements in a txt file and submit as an attachment.

Screen Shot

Bear