SYMPTOMS

New members surf the allotted number of pages but their accounts are not being activated. They also see a warning message that warns them the need to surf "0" or even a negative number to activate their accounts.

Click to view attachment

CAUSE

You have recently installed your traffic exchange script and deleted the demo data and/or their are no valid URLs for your members to surf.

RESOLUTION

Add some URLs to your account as well as the demo account so that your members have some pages to surf and accrue the credits required to activate their account.

QUICK FIX

Run the following SQL in your BCP/Advanced SQL viewer to get something into the demo account:-

1. If you have deleted the demo account you will need to run this one first:-

SQL
INSERT INTO `vtp_members` VALUES (57963, 'Demo Account', 'demo', 'demo', 1, 57962, '0', '2006-02-24 13:55:11', '2006-02-22 19:14:36', '2004-12-04 14:27:34', 'No', '', 'Yes', 43842, 6271, 46, 50006, 10724.66691, 819, -1, 0, 0, 0, '82080', '192.168.1.13', '1140635676|10|2', 0, 0, 1.001000, 700.0000, '0000-00-00');


2. Sample data, note you could change the URLs in this code to your own if you wish, and perhaps some of the more entrepreneural members will add some links to their programs in easy to cut n paste SQL after these too laugh.gif


SQL
INSERT INTO `vtp_urls` VALUES (4, 57962, 'http://www.ebookpro.com/t.cgi/765886', 182, 1, 0, 0, 58, 0, '0000-00-00', '2005-11-27 13:44:56', 100);
SQL
INSERT INTO `vtp_urls` VALUES (5, 57963, 'http://www.marketingtips.com/warpspeed/t/765886', 147, 0, 0, 0, 0, 0, '0000-00-00', '2006-02-15 18:10:02', 5871);
SQL
INSERT INTO `vtp_urls` VALUES (6, 57963, 'http://www.FixedOddsLoophole.com/affiliates/b.php?rid=58&linkid=1&adid=', 108, 0, 0, 0, 0, 0, '0000-00-00', '2006-02-22 19:17:12', 5867);
SQL
INSERT INTO `vtp_urls` VALUES (7, 57963, 'http://www.freemoneyloophole.com/cgi-bin/c.cgi/hitsnapper_ad', 111, 0, 0, 0, 0, 0, '0000-00-00', '2006-02-06 15:03:29', 5869);