bennyh

Re: could i have 20 seconds of your time please!? help needed UPDATE: Its now not deleting them from the validate table so therefore its not adding them into the user table as i said $5 to whoever can fix it Bennyh

Re: could i have 20 seconds of your time please!? help needed Again thanks for all the replies the error has gone but now when they press the link to validate it says account vaidated but they cannot login, again its not entering them into the users database? Any ideas Whoever can help i will pay $5 Thanks Ben

Re: could i have 20 seconds of your time please!? help needed Thanks for your reply but i get this error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 2, 2, 1, 12, 12, 100, 100, 5, 5, 100, 100, 9, 'Male', unix_timestamp(), '', -1,' at line 1

Re: could i have 20 seconds of your time please!? help needed I dont get it :? Sorry am i being stupid

When my users validate their email account it deletes them from the validate table but its not entering them into my users database Can anyone help me please? below is my validate page   <?php session_start(); require "mysql.php"; global $c; if ( $_GET['act'] == 'val') { $q=mysql_query("SELECT * FROM validating WHERE vdID='{$_GET['token']}'", $c); if (!mysql_num_rows($q)) { die("Invalid account"); } $r=mysql_fetch_array($q); $pass=strip_tags($r['vdPASSW']); $pass=md5($pass); $username=($r['vdUSERN']); $email=($r['vdEMAIL']); $money=($r['vdMONEY']); mysql_query("INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney, lastip) VALUES( '{$username}', '{$username}', md5('{$_POST['password']}'), 1, $sm, 2, 2, 1, 12, 12, 100, 100, 5, 5, 100, 100, 9, 'Male', unix_timestamp(), '{$_POST['email']}', -1, '$ip')", $c); $i=mysql_insert_id($c); mysql_query("INSERT INTO userstats VALUES($i,10,10,10,10,10)",$c); mysql_query("DELETE FROM validating WHERE vdID='{$_GET['token']}'", $c); print "Account validated! [url='login.php']> Login[/url]"; } else { mysql_query("DELETE FROM validating WHERE vdID='{$_GET['token']}'", $c); print "Registration Cancelled."; } ?>   THANKS

Re: Has anyone got a email validation mod for V1 for sale will pay $$$ Already bought his mod it didn't work and offered no support just said it's my fault I spoke to other people that bought they had the same problem, then tried to get him to install it but he's not answering me been about 3 weeks. If anyone else has one for sale then please pm me

Re: Has anyone got a email validation mod for V1 for sale will pay $$$ Sorry... So would like it when a user registers they have to validate their email address before they can play the game thanks ben

As title says really have tried looking on here but couldnt find any and have also tried converting the V2 ones on here but have no luck Any help would be greatly appreciated Thanks Ben

Re: [MCcode V2 or V1] raDiO's Raffle Script [$10 USD] Radio couldnt have been more helpful had trouble installing it and he even done it for me for FREE! Mod works perfectly and all users are happy Thanks Mate +1

Re: [V1][V2] 50/50 Chance Mod. Free Version +1 wicked mod thanks :mrgreen:

Re: Wanted email verification mod v1 I cant find them anywhere any chance of help? Paid or unpaid Thanks Ben

Re: Wanted email verification mod v1 Must be someone

Re: Wanted email verification mod v1 $$$ Forgot to say I am expecting to pay for it lol bennyh

As title says really I would like an email validation mod for v1 thanks for your time bennyh

Re: Help with email validation The system notices that they have validated it's just not adding them to the database