Why Can't My Members Activate Their Account?, I have a new exchange and new members can't activate their account Options

[Martyn]

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.

 SNAG_0039.gif ( 2.34K ) Number of downloads: 147


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

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);