[release] Reset Lost Password Script

[PowerChaos]

hey all
i going release a nice script
but there is a little catch on this script

it contains out of 2 scripts and a mysql table

i do not provide free install service , if you fail to install it on your own then you can request me to do it , but it will not be for free (you get the script already for free )



small instal price list

basic install = 5$

• configure script to your database from your server
• configure the email sending script on your site
• making basic mysql conection for script to work

advanced install = 15$

• configure script on server
• configure the email sending script on your site
• securing mysql so it can do no damage for the script
• site intregration with the template you provide (fit your site)

special install = 25$

• configure script on server
• configure the email sending script on your site
• securing mysql so it can do no damage for the script
• site intregration with the template you provide (fit your site)
• register page fix to allow emails to be added
• securing register page like i have on demonpower (only allow acces from your server , and few security checks in it + a avaible name checker on it )

enjoy

Update:
Script modified with the info in this topic (mysql sanitizing)
added "die" commands to prevent execution after a error


Greets From PowerChaos

[PowerChaos]

i forgot to delete a small part in the mysql dump

open the mysql file and search for

DEFAULT CHARSET=latin1

remove that line (only that little peace of text ) and the mysql dump will work

sorry about that

Greets From PowerChaos

[Marcus*]

if you were going to sell installation why not post that part in

[PowerChaos]

because it is still a release and a wanted request
and i want that users know what they do and that they stop bothering me with pm's all the time because they can not get something done

the script is still a free release so the black market is not the right place ( as it is still a free release)

but if they can not get it installed because they do not know how or can not even open a php file then i do not need to waste my time on it
and for that reason i ask instalation costs , so they will do it on there own first or ask there friends

and i only do that for this script , and soon i going release a few other requests to with the same kind of system
but that is a other story

to make it short
if a user is not able to install then i like to get paid for the time i need to waste on it to help that user

Greets From PowerChaos

[KiiDxLaggy]

can you release a way to add email to register page? i tried a way that sword stalker said but it didnt work

[~Sword~Stalker~.]

try this one , if it didnt work pm me .

<TR>
<TD align="left" height="32">Email:<span class="required"><font color="#CC0000">*</font></span></TD>
<TD class=it3 height="32">
<input class="textfield_effect" id="email" style="FONT-SIZE: 9pt" type=text maxlength=30 name=email></TD>
</TR>

[PowerChaos]

i guess he was talking for the backend and how to edit the register page to include the email settings so it assign the email to the registered user

i will later on release a nice register script with email verification
but if you search a bit around on this forum then you will find enouf register scripts who got that email already implented

but in case of intrest
here is the code

$email=trim($_POST['email']);
mysql_query("insert into account (name,Password,Reg_date,email) values ('".$userid."','".$hash."','".date("y-m-d H:i:s", time())."',"'.$email.'")");

Greets from PowerChaos

[Eurion]

Instead of just trimming the input for the email, you should make sure that it's a valid email address. Something like this should do the check

If (!preg_match("/^([a-zA-Z0-9_.-])+@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+/", $_POST['email']))
{
  Echo 'The Email address you entered is incorrect';
}

[~Sword~Stalker~.]

ehmm then as powerchaos said . i guess its better that u use a full Register page With E-mail function and verification too

true Eurion but at first i thought he just want the entering of the e-mail to the db so i didnt add the validation .

 Spoiler

                          <p align="center">
                               <html xmlns="http://www.w3.org/1999/xhtml">
<head>
<link href="css/style.css" rel="stylesheet" type="text/css" />
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script type="text/javascript" src="./inc/md5.js"></script>

<style type="text/css">
</style>
  <script>
  $(document).ready(function(){
    $.validator.addMethod("username", function(value, element) {
        return this.optional(element) || /^[a-z0-9\_]+$/i.test(value);
    }, "Username must contain only letters, numbers, or underscore.");

    $("#regForm").validate();
  });
  </script>
<script language="JavaScript" type="text/javascript" src="js/jquery-1.3.2.min.js"></script>
<script language="JavaScript" type="text/javascript" src="js/jquery.validate.js"></script>
</head>
<DIV align="center"><b class="h2">
</b>Register
<br />
<table width="299" height="22" border="0" align="center">
  <tr>

  </tr>
</table>
<br />
<form method='post' action='register.php?act=register'>
      <TABLE width="312">
        <TBODY>
        <TR>
          <TD id=GoodStuff style="PADDING-LEFT: 0px; MARGIN-LEFT: 0px">
            <DIV id=theform style="PADDING-LEFT: 0px">
            <TABLE class=body width="323" height="229">

              <TBODY>
            <td>UserID:<span class="required"><font color="#CC0000">*</font></span></td>
            <td><input name="user_name" type="text" id="user_name" class="required username" minlength="5" > 
              <input name="btnAvailable" type="button" id="btnAvailable" onclick='$("#checkid").html("Please wait..."); $.get("[B]Your search user link[/B]",{ cmd: "check", user: $("#user_name").val() } ,function(data){  $("#checkid").html(data); });' value="Check Availability"> 
                <span style="color:red; font: bold 12px verdana; " id="checkid" ></span> 
            </td>
              <TR>
                <TD align="left" height="37">Password:<span class="required"><font color="#CC0000">*</font></span></TD>

                <TD class=it3 height="37">
                <INPUT class="textfield_effect" id="ipassword" style="FONT-SIZE: 9pt" type=password maxLength=12 name=pass></TD>
                </TR>
              <TR>
                <TD align="left" height="32">Retype Password:<span class="required"><font color="#CC0000">*</font></span></TD>
                <TD class=it3 height="32">
                <input class="textfield_effect" id="ipassword" style="FONT-SIZE: 9pt" type=password maxlength=12 name=retpass></TD>
                </TR>

              <TR>
                <TD align="left" height="32">Email:<span class="required"><font color="#CC0000">*</font></span></TD>
                <TD class=it3 height="32">
                <input class="textfield_effect" id="email" style="FONT-SIZE: 9pt" type=text maxlength=30 name=email></TD>
                </TR>
              <TR>
                <TD align="left" height="32">Type Check Code:<span class="required"><font color="#CC0000">*</font></span></TD>

                <TD class=it3 height="32">
                    <input name='CheckCode' size='20' maxlength='6'class="textfield_effect" style="FONT-SIZE: 9pt"></TD>
                </TR>
              <TR>
                <TD height="25" align="left">Check Code:</TD>
                <TD height="25"><span style="font-size: 9pt"><[B]your background[/B] ' width='200' height='60' alt='Visual CAPTCHA' 
  style='border: 1px solid #000000; padding: 2px;' /></TD></TR>
              <TR>
                <TD></TD>

                <TD style="FONT-SIZE: 14px; VERTICAL-ALIGN: middle">
                <span style="font-size: 9pt"><input type="hidden" name="hash"><input class=Butt type=submit onclick="hash.value = login(pass.value)" value='Register' style="width: 82px; height: 32px; background:#867D6C" name=B1></span></TD>
                </TR></TBODY></TABLE>
            </DIV></TD></TR></TBODY></TABLE></FORM>

the CAPTCHA might not work so delete it and it would be non CAPTCHA

correct PC . but also some datas doesnt have the e-mail function ,

so u guys need to create a tab called email . and all u gonna do is add this one to ur register.php watch for the bolds i made . also u need to be sure everything is right spelled it differs from a db to another
u can make some edits here too .

[$.validator.addMethod("username", function(value, element) {
return this.optional(element) || /^[a-z0-9\_]+$/i.test(value);Here u can add something thay will not be verified if they registered using it for example the PM etc.
}, "Username must contain only letters, numbers, or underscore.");

$("#regForm").validate();
});

same as this part

<input name="btnAvailable" type="button" id="btnAvailable" onclick='$("#checkid").html("Please wait..."); $.get("Your search user link",{ cmd: "check", user: $("#user_name").val() } ,function(data){ $("#checkid").html(data); });' value="Check Availability">

it might differ here so if u dont have a search method delete this function .



.. its a nice server btw ..

[PowerChaos]

swordstalker
it is for that reason that i offer a install service
as not all databases are the same and the persones who know how to work with the database can do those things on there own (and most databases contains the email tab , even my old database contains it )

and for that reason i do not like to waste time on it to keep repeating the same over and over , as the forum is already full of those things

then for the verification
as you probaly know , the email verification you provided is not the best way for it
as it can not contain a double dot ( like )
but it is a start as verification

then there are a bit funny bugs to in the register script itself
users who got a longer email then 30 chars wont be able to register ( as max chars is 30 )

the big point i mean with this topic is that i love to release this kind of things
but that the users who like to continue with it and like to use it need to use 2 things
1) google
2) this forum
3) need to learn php/mysql (basic to change a few parameters)
4)need to be able to start with opening a txt file ( as most users doesnt do that )

on that way you know that users who got this sucessfuly installed are not rubish
as i wanna bet that 95% forget to change the email that it sends out and got no clue how to get the email sending to work ( as you need a webserver for it or smtp server)
or are not even able to conect to there mysql server (then we do not talk about security)

anyway
for the users who get it installed , i wish them good luck and my next release will be a same kind release for email verification and password change script (with locked account info and stuff)

on that way the users are unlikely to get spammed or abused by the systems they have now and it give a more secure feeling of what the scripts does now

its not bad meaned , but i am just a bit tired of providing the same answer and answer over and over again
i still love to release stuff to help , but the support and lazyness of some persones are just to mutch for me

Greets From PowerChaos

[~Sword~Stalker~.]

its okay since by a way or another ur trying to saying that i cant make my own but its fine .. accepted .

as i just mensioned this reg. page is not fully edited / done , what are u goin to lose changing the max. characters , etc .

of course it has got bugs and mistakes .. but after all , no one is going to release a 100% perfect free script . etc...


Regards

[Eurion]

Originally Posted by PowerChaos

then for the verification
as you probaly know , the email verification you provided is not the best way for it
as it can not contain a double dot ( like )


Greets From PowerChaos

I hate to say it, but you need to take another look at my code. You can have as many characters as your database can contain.

10004301	brian44	05d5f45a9b580074c8e77ec87dd4242e	2011-04-30 14:15:21	127.0.0.1	Yes	[color=red][/color]	Mothers Maiden Name?	test

In my example, my email contains 44 characters including the email hoster. So by you saying that you can't contain more than 30 characters is absolutely incorrect. As for the multiple periods, As you can see, Ive included 3 in mine.


So before you try to discredit someones work, you should atleast try it out.

[~Sword~Stalker~.]

yes Eurion urs doesnt have a limit . that was about mine , not urs .

<TR>
<TD align="left" height="32">Email:<span class="required"><font color="#CC0000">*</font></span></TD>
<TD class=it3 height="32">
<input class="textfield_effect" id="email" style="FONT-SIZE: 9pt" type=text maxlength=30 name=email></TD>
</TR>

even the maxlength can be easily changed .

i prefer someone with [email protected] than spams and others with

of course others can change / delete the max length . its just full so they can do what they want ,

[Eurion]

I'm pretty sure he was posting about mine, since yours doesn't actually verify that its an email address. You just have input areas that has a max length.

[PowerChaos]

edit:
i was talking about both scripts
swordstalker because email limit (was just pointing at it )
and eurion because the code (i supose my code was a bit messy when i used it as his code does work )

@swordstalker
you can make your own register script ( else you woulnd even provide code )
but the point i meaned with it is that we get the same answer over and over
they keep asking for the same stuff over and over and where is that time that they dit it on there own and just asked us difficult questions where we barely got a answer on ??

@eurion
i guess i messed up your code with the code i used before
as the code i used before coulnd contain more then 1 dot or the verificaion failt ( same as a dot after @ like )

and for the email
most register scripts got a max char set on it ( max of 30 chars)
but the database value is a max of 128 chars ( in my case)

i do not want to descredit some1
i just want to proof a small point that most users does not even edit stuff
and that this release was made for the users who do know how to take care of that stuff
next time i will make the title

[advanced release] so the users does not need to read more then just the tittle and know if it is to hard for them or not

but before we go to mutch offtopic here
hopely you can understand my point

my point in short
users need to know atleast a basic before they start up a server
they need to learn again to use google (even those 12 years old kids)
they need to learn again that we do this for fun and does not like to have all the time pm's or to repeat the same answer over and over again

as soon they learn that part then i am sure that there are a lot more persones who going release scripts
but on this way i am not so sure about that some1 like to release a script if they ned to answer the same answer over and over again

Greets From PowerChaos