Why Can't My Members Activate Their Account?, I have a new exchange and new members can't activate their account |
Why Can't My Members Activate Their Account?, I have a new exchange and new members can't activate their account |
Feb 24 2006, 08:31 PM
Post
#1
|
|
WSF Commander Group: Admin Posts: 4,662 Joined: 26-August 05 Member No.: 10 |
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);
|
|
|
Lo-Fi Version | Time is now: 31st October 2024 - 09:25 PM |