[RELEASE] Simple register (Works 100%)

Page 1 of 2 12 LastLast
Results 1 to 25 of 27
  1. 29-03-08 #1
    Rbit
    Member Rbit is offline
    MemberRank
    Mar 2008 Join Date
    EstoniaLocation
    59Posts

    [RELEASE] Simple register (Works 100%)

    It works on Xampp and appserv 100%, i have tested it out!
    I know there is like this, but this is based on BR (Lg, Kekku) Database

    Its made by Wizkidje

    He gaved it to me, so i release it for thouse ppl who needs!
    Attached Files Attached Files
    Last edited by Rbit; 31-03-08 at 12:49 PM.
    Reply With Quote Reply With Quote
  2. Check out our sponsor
    [RELEASE] Simple register (Works 100%)
  3. 30-03-08 #2
    Roxas
    Apprentice Roxas is offline
    MemberRank
    Sep 2007 Join Date
    8Posts

    Re: [RELEASE] Simple register (Works 100%)

    good job.
    Reply With Quote Reply With Quote
  4. 30-03-08 #3
    sherwinlfc
    Member sherwinlfc is offline
    MemberRank
    Nov 2007 Join Date
    68Posts

    Re: [RELEASE] Simple register (Works 100%)

    how do you use it? zz instructions please~
    Reply With Quote Reply With Quote
  5. 30-03-08 #4
    Rbit
    Member Rbit is offline
    MemberRank
    Mar 2008 Join Date
    EstoniaLocation
    59Posts

    Re: [RELEASE] Simple register (Works 100%)

    Quote Originally Posted by sherwinlfc View Post
    how do you use it? zz instructions please~
    Download Xampp

    Then edit index.php with notepad, put your information!
    Then put it to htdocs folder in Xampp folder!

    Then open web browser and type localhost or 127.0.0.1
    Reply With Quote Reply With Quote
  6. 30-03-08 #5
    Jaycub
    Proficient Member Jaycub is offline
    MemberRank
    Nov 2007 Join Date
    162Posts

    Re: [RELEASE] Simple register (Works 100%)

    So if it is 127.0.0.1.. hoow the hell do other people register
    Reply With Quote Reply With Quote
  7. 30-03-08 #6
    Rbit
    Member Rbit is offline
    MemberRank
    Mar 2008 Join Date
    EstoniaLocation
    59Posts

    Re: [RELEASE] Simple register (Works 100%)

    [quote=Jaycub;3244541]So if it is 127.0.0.1.. hoow the hell do other people register
    Last edited by Rbit; 31-03-08 at 12:27 PM.
    Reply With Quote Reply With Quote
  8. 30-03-08 #7
    Amandy
    Account Upgraded | Title Enabled! Amandy is offline
    MemberRank
    Feb 2007 Join Date
    Crapvile, USALocation
    768Posts

    Re: [RELEASE] Simple register (Works 100%)

    The host should be Jacob\SQLEXPRESS
    Reply With Quote Reply With Quote
  9. 30-03-08 #8
    Jaycub
    Proficient Member Jaycub is offline
    MemberRank
    Nov 2007 Join Date
    162Posts

    Re: [RELEASE] Simple register (Works 100%)

    There rlly isnt a password for it..

    When i connect to database it just says
    connecting to server : Laptop1/sqlexpress
    user : Laptop1/Jacob
    password:

    The password is blank
    Reply With Quote Reply With Quote
  10. 31-03-08 #9
    MAXTRAXv3
    Banned MAXTRAXv3 is offline
    BannedRank
    Jan 2007 Join Date
    Perth, WesternLocation
    2,252Posts

    Re: [RELEASE] Simple register (Works 100%)

    works for me on Wamp and Xampp
    Reply With Quote Reply With Quote
  11. 31-03-08 #10
    NarutoUzamaki
    Account Upgraded | Title Enabled! NarutoUzamaki is offline
    MemberRank
    Jan 2008 Join Date
    In a big condom, where else?Location
    232Posts

    Re: [RELEASE] Simple register (Works 100%)

    Nice release thnx :D. =p.
    Reply With Quote Reply With Quote
  12. 31-03-08 #11
    Rbit
    Member Rbit is offline
    MemberRank
    Mar 2008 Join Date
    EstoniaLocation
    59Posts

    Re: [RELEASE] Simple register (Works 100%)

    Quote Originally Posted by Antv912 View Post
    The host should be Jacob\SQLEXPRESS
    Yeah, thanks for correct my mistake :P
    Reply With Quote Reply With Quote
  13. 31-03-08 #12
    Solaire
    Praise the Sun! Solaire is offline
    MemberRank
    Dec 2007 Join Date
    Undead BurgLocation
    2,862Posts

    Re: [RELEASE] Simple register (Works 100%)

    Ty for giving credits.
    Reply With Quote Reply With Quote
  14. 01-04-08 #13
    redhellhound
    Member redhellhound is offline
    MemberRank
    Sep 2007 Join Date
    BC, Canada! EHLocation
    99Posts

    Re: [RELEASE] Simple register (Works 100%)

    you should of made the password when you installed mssql lol. and it should be on sql auth not windows.
    Reply With Quote Reply With Quote
  15. 01-04-08 #14
    Solaire
    Praise the Sun! Solaire is offline
    MemberRank
    Dec 2007 Join Date
    Undead BurgLocation
    2,862Posts

    Re: [RELEASE] Simple register (Works 100%)

    Zzzz, it must be that otherwise your whole gunzserver will not work.
    Reply With Quote Reply With Quote
  16. 02-04-08 #15
    Jaycub
    Proficient Member Jaycub is offline
    MemberRank
    Nov 2007 Join Date
    162Posts

    Re: [RELEASE] Simple register (Works 100%)

    IS THEIR A WAY TO RE-GET MY PASSWORD FOR MYSQL BACK ? COZ I DONT THINK I CAN REMEMBER IT !

    Error :
    Code:
     Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\wamp\www\index.php on line 5
Couldn't connect to the database, we're sorry...

    In index :
    Code:
    <?php 
$dns="GunZDB";
$user="Jacob\SQLEXPRESS";
$pass="";
$connect=odbc_connect($dns, $user, $pass) or die ("Couldn't connect to the database, we're sorry...");
odbc_exec($connect,"use GunzDB");

function antisql($bericht){
$bericht = stripslashes($bericht); 
$bericht = htmlspecialchars($bericht); 
$bericht = nl2br($bericht); 
return $bericht;
}

if(isset($_GET['action']) AND $_GET['action'] == "register"){

if(empty($_POST['username'])){
$error.="No username filled!<br>";
}

if(empty($_POST['password'])){
$error.="No password filled!<br>";
}

if(empty($_POST['email'])){
$error.="No e-mail filled!<br>";
}

if(empty($_POST['name'])){
$error.="No name filled!<br>";
}

if(empty($_POST['age'])){
$error.="No age filled!<br>";
}

if($error == TRUE){
echo "<br><br><center>There are some troubles while registering your account:<br>".$error."</center><br>";
die();
}

else
{
$regdate = date("Y-m-d H:i:s");
$email = antisql($_POST['email']);
$reg = "INSERT INTO Account (UserID, UGradeID, PGradeID, RegDate, Email, Age, Name) VALUES ('".antisql($_POST['username'])."', '1', '1', '$regdate', '$email', '".antisql($_POST['age'])."', '".antisql($_POST['name'])."')";
$query = odbc_exec($connect,$reg);
$gebruiker1 = "SELECT AID FROM Account WHERE UserID='".antisql($_POST['username'])."'";
$gebruiker = odbc_exec($connect,$gebruiker1);
$i=1;
while (odbc_fetch_row($gebruiker, $i)){
$aid = odbc_result($gebruiker, 'AID');
$i++;
}
if (!$aid)
{
die ("Oeps, something's wrong with the database");
}
$reg2 = "INSERT INTO Login (UserID, AID, Password) VALUES ('".antisql($_POST['username'])."', '$aid', '".antisql($_POST['password'])."')";
$query = odbc_exec($connect,$reg2);
print ("<center>Your account is succesfully created!</center>");
}
}
?>
<center><b>You can register a IMP Gunz account right here:</b><br><br>
<?php echo "<form action='".$_SERVER['PHP_SELF']."?action=register' method='POST'>"; ?>
<tr>
<td align=center height='24'>Username</td>
<td align=center height='24'><input type='text' name='username'></td>
</tr>
<br>
<tr>
<td align=center height='24'>Password</td>
<td align=center height='24'><input type='password' name='password'></td>
</tr>
<br>
<tr>
<td align=center height='24'>E-mail&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
<td align=center height='24'><input type='text' name='email'></td>
</tr>
<br>
<tr>
<td align=center height='24'>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
<td align=center height='24'><input type='text' name='name'></td>
</tr>
<br>
<tr>
<td align=center height='24'>Age&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
<td align=center height='24'><input type='text' name='age'></td>
</tr>
<br>
<tr>
<td align=center height='24'></td>
<td align=center height='24'><input type='submit' value='Register!'></td>
</tr>
</form>
    Reply With Quote Reply With Quote
  17. 02-04-08 #16
    Rbit
    Member Rbit is offline
    MemberRank
    Mar 2008 Join Date
    EstoniaLocation
    59Posts

    Re: [RELEASE] Simple register (Works 100%)

    Quote Originally Posted by Jaycub View Post
    IS THEIR A WAY TO RE-GET MY PASSWORD FOR MYSQL BACK ? COZ I DONT THINK I CAN REMEMBER IT !

    Error :
    Code:
     Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\wamp\www\index.php on line 5
Couldn't connect to the database, we're sorry...

    In index :
    Code:
    <?php 
$dns="GunZDB";
$user="Jacob\SQLEXPRESS";
$pass="";
$connect=odbc_connect($dns, $user, $pass) or die ("Couldn't connect to the database, we're sorry...");
odbc_exec($connect,"use GunzDB");
 
function antisql($bericht){
$bericht = stripslashes($bericht); 
$bericht = htmlspecialchars($bericht); 
$bericht = nl2br($bericht); 
return $bericht;
}
 
if(isset($_GET['action']) AND $_GET['action'] == "register"){
 
if(empty($_POST['username'])){
$error.="No username filled!<br>";
}
 
if(empty($_POST['password'])){
$error.="No password filled!<br>";
}
 
if(empty($_POST['email'])){
$error.="No e-mail filled!<br>";
}
 
if(empty($_POST['name'])){
$error.="No name filled!<br>";
}
 
if(empty($_POST['age'])){
$error.="No age filled!<br>";
}
 
if($error == TRUE){
echo "<br><br><center>There are some troubles while registering your account:<br>".$error."</center><br>";
die();
}
 
else
{
$regdate = date("Y-m-d H:i:s");
$email = antisql($_POST['email']);
$reg = "INSERT INTO Account (UserID, UGradeID, PGradeID, RegDate, Email, Age, Name) VALUES ('".antisql($_POST['username'])."', '1', '1', '$regdate', '$email', '".antisql($_POST['age'])."', '".antisql($_POST['name'])."')";
$query = odbc_exec($connect,$reg);
$gebruiker1 = "SELECT AID FROM Account WHERE UserID='".antisql($_POST['username'])."'";
$gebruiker = odbc_exec($connect,$gebruiker1);
$i=1;
while (odbc_fetch_row($gebruiker, $i)){
$aid = odbc_result($gebruiker, 'AID');
$i++;
}
if (!$aid)
{
die ("Oeps, something's wrong with the database");
}
$reg2 = "INSERT INTO Login (UserID, AID, Password) VALUES ('".antisql($_POST['username'])."', '$aid', '".antisql($_POST['password'])."')";
$query = odbc_exec($connect,$reg2);
print ("<center>Your account is succesfully created!</center>");
}
}
?>
<center><b>You can register a IMP Gunz account right here:</b><br><br>
<?php echo "<form action='".$_SERVER['PHP_SELF']."?action=register' method='POST'>"; ?>
<tr>
<td align=center height='24'>Username</td>
<td align=center height='24'><input type='text' name='username'></td>
</tr>
<br>
<tr>
<td align=center height='24'>Password</td>
<td align=center height='24'><input type='password' name='password'></td>
</tr>
<br>
<tr>
<td align=center height='24'>E-mail&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
<td align=center height='24'><input type='text' name='email'></td>
</tr>
<br>
<tr>
<td align=center height='24'>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
<td align=center height='24'><input type='text' name='name'></td>
</tr>
<br>
<tr>
<td align=center height='24'>Age&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
<td align=center height='24'><input type='text' name='age'></td>
</tr>
<br>
<tr>
<td align=center height='24'></td>
<td align=center height='24'><input type='submit' value='Register!'></td>
</tr>
</form>


    Dude! Just reinstall SQL!
    Reply With Quote Reply With Quote
  18. 03-04-08 #17
    Jaycub
    Proficient Member Jaycub is offline
    MemberRank
    Nov 2007 Join Date
    162Posts

    Re: [RELEASE] Simple register (Works 100%)

    SQL = MYSql ??

    Does it depend on which version ?
    Reply With Quote Reply With Quote
  19. 03-04-08 #18
    xXPointBlankxXx
    Apprentice xXPointBlankxXx is offline
    MemberRank
    Mar 2008 Join Date
    23Posts

    Re: [RELEASE] Simple register (Works 100%)

    Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\AppServ\www\index.php on line 5
    Couldn't connect to the database, we're sorry...

    i use my ip address when i go into the html and thats what it shows, i use my ip address on my servers instead of 127.0.0.1, what am i doing wrong?

    i have dns: GunzDB
    user: sa
    pass: my pass (i dont want to release it to every1) so what am i doing wrong?
    Reply With Quote Reply With Quote
  20. 04-04-08 #19
    MAXTRAXv3
    Banned MAXTRAXv3 is offline
    BannedRank
    Jan 2007 Join Date
    Perth, WesternLocation
    2,252Posts

    Re: [RELEASE] Simple register (Works 100%)

    JayNub you need to reinstall MSSQL (not MYSQL)...

    xXPointBlankxXx you forgot to do part of the tut
    Reply With Quote Reply With Quote
  21. 04-04-08 #20
    sari4ever
    Who is the cow! sari4ever is offline
    MemberRank
    Apr 2007 Join Date
    Holy LandLocation
    790Posts

    Re: [RELEASE] Simple register (Works 100%)

    same problem like xxpointblackxxx
    Reply With Quote Reply With Quote
  22. 05-04-08 #21
    Jaycub
    Proficient Member Jaycub is offline
    MemberRank
    Nov 2007 Join Date
    162Posts

    Re: [RELEASE] Simple register (Works 100%)

    Quote Originally Posted by MAXTRAXv3 View Post
    JayNub

    Im sorry.. im sure that YOU Asked questions aswell...


    I dont waste money on taking classes like coding so i dont know what some of these terms r

    Im only learning so get the Hell of my Back !!!

    Question : Is MYSQL Needed at all ?

    Ok Now seriously.. THERE IS NO.. NO !!! PASSWORD !!

    Last edited by Jaycub; 05-04-08 at 02:25 PM.
    Reply With Quote Reply With Quote
  23. 06-04-08 #22
    Uzi910
    Apprentice Uzi910 is offline
    MemberRank
    Apr 2007 Join Date
    17Posts

    Re: [RELEASE] Simple register (Works 100%)

    Quote Originally Posted by Jaycub View Post
    Im sorry.. im sure that YOU Asked questions aswell...


    I dont waste money on taking classes like coding so i dont know what some of these terms r

    Im only learning so get the Hell of my Back !!!

    Question : Is MYSQL Needed at all ?

    Ok Now seriously.. THERE IS NO.. NO !!! PASSWORD !!

    he means you should of chose the other option not windows authentication
    Reply With Quote Reply With Quote
  24. 07-04-08 #23
    Jaycub
    Proficient Member Jaycub is offline
    MemberRank
    Nov 2007 Join Date
    162Posts

    Re: [RELEASE] Simple register (Works 100%)

    Quote Originally Posted by Uzi910 View Post
    he means you should of chose the other option not windows authentication

    Why didnt he just say that :)

    Now. THAT I understand ! :sweatdrop
    Reply With Quote Reply With Quote
  25. 10-04-08 #24
    killerbros2
    Enthusiast killerbros2 is offline
    MemberRank
    Oct 2007 Join Date
    31Posts

    Re: [RELEASE] Simple register (Works 100%)

    yea u shoulda chose other option. and i thoaght pw is supposed 2 b ur computer name lol
    Reply With Quote Reply With Quote
  26. 07-06-08 #25
    SilentVoice
    Apprentice SilentVoice is offline
    MemberRank
    Jun 2008 Join Date
    RussiaLocation
    9Posts

    Re: [RELEASE] Simple register (Works 100%)

    Code:
    Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\AppServ\www\index.php on line 5
Couldn't connect to the database, we're sorry...
    if you got this problem - make sure that you created SYSTEM DNS, not USER DNS

    and sorry if my english bad -_-
    Reply With Quote Reply With Quote


Page 1 of 2 12 LastLast
« Previous Thread | Next Thread »

Advertisement