php registration

Page 2 of 2 FirstFirst 12
Results 26 to 46 of 46
  1. #26
    Member djtrancer is offline
    MemberRank
    Feb 2004 Join Date
    Nora, SwedenLocation
    86Posts
    awesome.. thanx alot m8 :D

  2. #27
    Newbie zcloud is offline
    MemberRank
    Oct 2004 Join Date
    14Posts
    please help me
    [11-Nov-2004 12:32:11] PHP Warning: mssql_connect() [C:\apache2triad\php\manual\function.mssql-connect.html]: message: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. (severity 14) in C:\apache2triad\htdocs\reg\reg.php on line 51

    [11-Nov-2004 12:32:11] PHP Warning: mssql_connect() [C:\apache2triad\php\manual\function.mssql-connect.html]: Unable to connect to server: 192.168.1.101 in C:\apache2triad\htdocs\reg\reg.php on line 51

    [11-Nov-2004 12:32:17] PHP Warning: mssql_select_db() [C:\apache2triad\php\manual\function.mssql-select-db.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 53

    [11-Nov-2004 12:32:17] PHP Warning: mssql_select_db() [C:\apache2triad\php\manual\function.mssql-select-db.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 53

    [11-Nov-2004 12:32:23] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 66

    [11-Nov-2004 12:32:23] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 66

    [11-Nov-2004 12:32:23] PHP Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\apache2triad\htdocs\reg\reg.php on line 67

    [11-Nov-2004 12:32:29] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 71

    [11-Nov-2004 12:32:29] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 71

    [11-Nov-2004 12:32:35] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 72

    [11-Nov-2004 12:32:35] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 72

    [11-Nov-2004 12:32:41] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 73

    [11-Nov-2004 12:32:41] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 73

    [11-Nov-2004 12:32:41] PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\apache2triad\htdocs\reg\reg.php on line 73

  3. #28
    Newbie Ice-T-WTF is offline
    MemberRank
    Nov 2004 Join Date
    9Posts
    Quote Originally Posted by zcloud
    please help me
    [11-Nov-2004 12:32:11] PHP Warning: mssql_connect() [C:\apache2triad\php\manual\function.mssql-connect.html]: message: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. (severity 14) in C:\apache2triad\htdocs\reg\reg.php on line 51

    [11-Nov-2004 12:32:11] PHP Warning: mssql_connect() [C:\apache2triad\php\manual\function.mssql-connect.html]: Unable to connect to server: 192.168.1.101 in C:\apache2triad\htdocs\reg\reg.php on line 51

    [11-Nov-2004 12:32:17] PHP Warning: mssql_select_db() [C:\apache2triad\php\manual\function.mssql-select-db.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 53

    [11-Nov-2004 12:32:17] PHP Warning: mssql_select_db() [C:\apache2triad\php\manual\function.mssql-select-db.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 53

    [11-Nov-2004 12:32:23] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 66

    [11-Nov-2004 12:32:23] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 66

    [11-Nov-2004 12:32:23] PHP Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\apache2triad\htdocs\reg\reg.php on line 67

    [11-Nov-2004 12:32:29] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 71

    [11-Nov-2004 12:32:29] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 71

    [11-Nov-2004 12:32:35] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 72

    [11-Nov-2004 12:32:35] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 72

    [11-Nov-2004 12:32:41] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: Unable to connect to server: (null) in C:\apache2triad\htdocs\reg\reg.php on line 73

    [11-Nov-2004 12:32:41] PHP Warning: mssql_query() [C:\apache2triad\php\manual\function.mssql-query.html]: A link to the server could not be established in C:\apache2triad\htdocs\reg\reg.php on line 73

    [11-Nov-2004 12:32:41] PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\apache2triad\htdocs\reg\reg.php on line 73
    it tells you whats wrong on the first line...
    try changeing the security in the sql manager to mixed sql and windows autherisation..

  4. #29
    Newbie man77 is offline
    MemberRank
    Mar 2004 Join Date
    vnLocation
    16Posts
    Trying to register account:"test1" with password:"test1"


    DB Connection established:Resource id #2


    DataBase opened:1


    Account successfully created

    but when i log in game..i have this problem:
    password does not match for this account when i used account test1/test1

  5. #30
    Sorcerer Supreme rstrst is offline
    Member +Rank
    Oct 2004 Join Date
    Russia, MoscowLocation
    320Posts
    but when i log in game..i have this problem:
    password does not match for this account when i used account test1/test1
    does it works with asp??
    check your client dlls version...

  6. #31
    Newbie man77 is offline
    MemberRank
    Mar 2004 Join Date
    vnLocation
    16Posts
    Quote Originally Posted by rstrst
    does it works with asp??
    check your client dlls version...
    nope..doesn't work with ASP and php...i see server Batz with 9999 ms ..click on Batz is back to login ID and Pass..access failed

  7. #32
    Newbie Ice-T-WTF is offline
    MemberRank
    Nov 2004 Join Date
    9Posts
    Quote Originally Posted by man77
    Trying to register account:"test1" with password:"test1"


    DB Connection established:Resource id #2


    DataBase opened:1


    Account successfully created

    but when i log in game..i have this problem:
    password does not match for this account when i used account test1/test1
    ur using the wrong authd server there an encrypt one and a decrypt one, u need the encrypt one

  8. #33
    Newbie man77 is offline
    MemberRank
    Mar 2004 Join Date
    vnLocation
    16Posts
    no..i using \l2AuthD.exe with file size 475.192 b (encrypt)
    and decrypt is (421 943 b)

  9. #34
    Sorcerer Supreme rstrst is offline
    Member +Rank
    Oct 2004 Join Date
    Russia, MoscowLocation
    320Posts
    look client patch topic... you need 4 dlls... also i've posted a better one:
    http://dhhq.narod.ru/patchv3.rar
    page opens (it's not error), then click same link in yellow bar
    try it, maybe it will help... and you should use your own l2.ini

  10. #35
    Newbie lordxp is offline
    MemberRank
    Jun 2004 Join Date
    ltuLocation
    9Posts
    Quote Originally Posted by rstrst
    Your php setup needs all vars to be defined... It's a security feature and is not default setup... Look at php.net docs on how to define vars and make reqired changes to my code...
    Code:
    global $account;
    global $l2password;
    But it will probably ask to define all vars
    i got this error too.i can't find any info in php.net and iam php newbie so could you write short tutorial or share your php.ini (if needed).
    p.s could you implement password confirm field?

  11. #36
    Sorcerer Supreme doraemon2000 is offline
    Member +Rank
    Nov 2004 Join Date
    Toronto, CanadaLocation
    470Posts
    Well, I got lots of errors as well but the php script created the account. So you gota do is add...

    error_reporting(0);

    ...at the top of reg.php and it won't show any errors. There are some bad side effects to it though because if it isn't able to connect to the database, it wouldn't show it because you turned off error reporting. This could also be done in your php.ini which would apply to all .php files you host.

  12. #37
    Newbie Mathiu is offline
    MemberRank
    Nov 2004 Join Date
    12Posts
    rstrst - great work! I saved me from installing IIs or recompiling apache. I owe you one, mate :)

    - Mathiu Silverburg

  13. #38
    Member Sesshoumaru is offline
    MemberRank
    Apr 2003 Join Date
    SwedenLocation
    60Posts
    Getting this error:


    Notice: Undefined index: user in e:\easyphp1-7\www\index.php on line 3

    Notice: Undefined index: pass in e:\easyphp1-7\www\index.php on line 3

    Fatal error: Call to undefined function: mssql_connect() in e:\easyphp1-7\www\function.php on line 36


    Using EasyPhP 1.7
    Defined extensions folder to: E:\EasyPHP1-7\php\extensions
    (in a plain guess, I never used this stuff before, but since there was an "extensions" folder alredy...)
    Put all files in folder "www" n loaded it all up
    loged in and got above message

    Sorrie if I placed files wrong, "forgot" (more likely didnt know) to add something somewhere etc... just... what to do?

  14. #39
    Member Sesshoumaru is offline
    MemberRank
    Apr 2003 Join Date
    SwedenLocation
    60Posts
    Edit:

    Erased. Sorrie for doubbel post, bad connection to RZ today.
    Last edited by Sesshoumaru; 02-12-04 at 01:54 PM.

  15. #40
    Sorcerer Supreme rstrst is offline
    Member +Rank
    Oct 2004 Join Date
    Russia, MoscowLocation
    320Posts
    1)I recommend using php4
    2)I can provide some support for php4 and 5(not tested but similar)
    3)I don't know, if easyphp have mssql extension and how to enable it =)
    4)check your manual

  16. #41
    Sorcerer Supreme rstrst is offline
    Member +Rank
    Oct 2004 Join Date
    Russia, MoscowLocation
    320Posts
    And some notice about security:
    As I said this script is just a template and should to be rewritten to your needs... Mostly it's just an examle of mssql api use.
    I've tried to write it secure, but there is still some vuln exist: I recommend removing single quotes char from account variable before querying DB to prevent server DoS(in my script). It would be perfect to allow only letters and numbers.
    If you removed variable length checks from my script, this becomes critical for you

  17. #42
    Newbie zEr0Z is offline
    MemberRank
    Nov 2004 Join Date
    RussiaLocation
    8Posts
    please help find this Fixed15-10-2004html.zip

  18. #43
    Newbie Johancze is offline
    MemberRank
    Feb 2006 Join Date
    Czech RepublicLocation
    10Posts
    Please, send mirror link.

  19. #44
    Elite Member isachs is offline
    Member +Rank
    Jun 2006 Join Date
    CzechLocation
    122Posts
    Could anybody reshare? pliz?

  20. #45
    Member Wouter2004 is offline
    MemberRank
    Apr 2006 Join Date
    NetherlandsLocation
    59Posts
    Link is broken, mirror please.

  21. #46
    Sorcerer Supreme iCODY is offline
    Member +Rank
    Jun 2005 Join Date
    EarthLocation
    251Posts
    all links broken ... :(



Page 2 of 2 FirstFirst 12

Advertisement