To all Tantra newbie developers I think you might like this

Page 4 of 24 FirstFirst 12345678910111214 ... LastLast
Results 46 to 60 of 353
  1. #46
    Developer Terrified is offline
    MemberRank
    Dec 2013 Join Date
    Six MountainsLocation
    229Posts

    Re: To all Tantra newbie developers I think you might like this

    hi again TantraNewbie, the correct code was <?php phpinfo(); ?>
    save it as index.php of which the screenshot you posted displays the php configuration. however, i need to see if there is a MSSQL part on the displayed. or try to search that in your display. something like this:

    mssql

    MSSQL Support enabled
    Active Persistent Links 0
    Active Links 0
    Library version 7.0

    and if not. then you need to setup MSSQL. or you have to re-install it. use my link in the first page so that you would not have much to configure and it is not atrial version.

    for sir elitegeek; the MSSQL20012 advance server is a free edition. so i think you have downloaded the enterprise edition. please do share more of the data. the link i have placed is a free edition directly from microsoft and as is.

    .
    Last edited by Terrified; 16-04-14 at 09:04 AM. Reason: Added for elitegeek

  2. #47
    Tantra Freelancer A v a r a is offline
    MemberRank
    Apr 2014 Join Date
    In Your HeadLocation
    554Posts

    Re: To all Tantra newbie developers I think you might like this

    Quote Originally Posted by TantraNewbie View Post
    PHP is on Xampp not on the MSSQL Server where I have a problem with Just finish first all the things on Sir Terror's guide before asking for PHP you will confuse yourself more....
    Bro, can you give me a screenshot on where should I locate and edit this particular php connections in XAMPP (step 6 on Sir Terror's Guide)? Thanks in advance.

    Also, I can see that you message me but somehow for some reason I can't access the private message page of Ragezone. Can you just post your PM here please.

    Ciao!

    - - - Updated - - -

    Quote Originally Posted by Terrified View Post
    for sir elitegeek; the MSSQL20012 advance server is a free edition. so i think you have downloaded the enterprise edition. please do share more of the data. the link i have placed is a free edition directly from microsoft and as is.

    .
    ..but I can still use this right? During the installation it says Evaluation (default) which I think will run free for at least 180 days.
    Last edited by A v a r a; 16-04-14 at 09:19 AM. Reason: Additional post

  3. #48
    Member TantraNewbie is offline
    MemberRank
    Apr 2014 Join Date
    56Posts

    Re: To all Tantra newbie developers I think you might like this

    Quote Originally Posted by Terrified View Post
    hi again TantraNewbie, the correct code was <?php phpinfo(); ?>
    save it as index.php of which the screenshot you posted displays the php configuration. however, i need to see if there is a MSSQL part on the displayed. or try to search that in your display. something like this:

    mssql

    MSSQL Support enabled
    Active Persistent Links 0
    Active Links 0
    Library version 7.0

    and if not. then you need to setup MSSQL. or you have to re-install it. use my link in the first page so that you would not have much to configure and it is not atrial version.

    for sir elitegeek; the MSSQL20012 advance server is a free edition. so i think you have downloaded the enterprise edition. please do share more of the data. the link i have placed is a free edition directly from microsoft and as is.

    .
    Thank you very much Sir for that info . Yes Sir I follow the set up which you posted in on page 1 here my SS
    [IMG][/IMG]

    I also set up my ODBC, User DNS and System DNS on this manner I set up it with login ID and password here some SS
    [IMG][/IMG]
    -
    I didn't found the mssql support Sir but I found this
    [/IMG]

    I dont know but I think this is because of the new Xampp. Which they change the extension=php_mssql.dll to extension=php_sqlsrv and the extension=php_mssql.dll is no longer supported.

    [IMG][/IMG]

    When I open to PHP/ext/ the dll the extension php_mssql.dll is not there..
    [IMG][/IMG]

    But I found this the dll extension that I downloded from driver 3.0
    [IMG][/IMG]

    And Sir I have this error whenever I will get the";" in the php.ini
    [IMG][/IMG]

    I dont know If im correct but I think this is because the php_mssql.dll is no longer located in "etc". and its no longer supported with new Xampp..

    I do hope Sir all my SS here could solve my problem... I really appreciate if you can help me.. Thanks in advance..
    Last edited by TantraNewbie; 16-04-14 at 11:05 AM.

  4. #49
    Tantra Freelancer A v a r a is offline
    MemberRank
    Apr 2014 Join Date
    In Your HeadLocation
    554Posts

    Re: To all Tantra newbie developers I think you might like this

    Really appreciate if someone could help me in STEP 6. I have now my MSSQL working and XAMPP working now. I just need to proceed to the next steps of this tutorial.



    Tested also with this code..

    <?php
    $test = mssql_connect('HERO\SQL2012','MYU','MYPW')
    or die('Something went wrong while connecting to MSSQL');

    if ($test) echo "Connection Success!";
    else echo "Connection Failed!";

    ?>



    ..but just don't know what file to use in STEP 6.

    Sorry if I am whining. I am just a beginner with this stuff but for the love of the game I willing to learn.
    Last edited by A v a r a; 16-04-14 at 01:49 PM.

  5. #50
    Member TantraNewbie is offline
    MemberRank
    Apr 2014 Join Date
    56Posts

    Re: To all Tantra newbie developers I think you might like this

    Quote Originally Posted by Terrified View Post
    hi again TantraNewbie, the correct code was <?php phpinfo(); ?>
    save it as index.php of which the screenshot you posted displays the php configuration. however, i need to see if there is a MSSQL part on the displayed. or try to search that in your display. something like this:

    mssql

    MSSQL Support enabled
    Active Persistent Links 0
    Active Links 0
    Library version 7.0

    and if not. then you need to setup MSSQL. or you have to re-install it. use my link in the first page so that you would not have much to configure and it is not atrial version.

    for sir elitegeek; the MSSQL20012 advance server is a free edition. so i think you have downloaded the enterprise edition. please do share more of the data. the link i have placed is a free edition directly from microsoft and as is.

    .
    Sir Thank very much for all the info I manage to solve the MSSQL Server problem but when I try to register this things happen..

    [IMG][/IMG]
    [/IMG]

    I have this thought may the problem now is my DB .I use the fix data base with pher1433 post since its bak file I try to restore it by overwriting on the DB..Problem after another but I will not give up with your help I know i can run my on server hopefully. I more thing when I run the client using a batch file I end with this..
    [IMG][/IMG]


    I got of ???? I hope you can help me with this other problem that i have..Thanks in Advance.. regards
    Last edited by TantraNewbie; 22-04-14 at 07:32 AM.

  6. #51
    Novice dkhauz22 is offline
    MemberRank
    Apr 2014 Join Date
    1Posts

    Re: To all Tantra newbie developers I think you might like this

    sir where i can find the php.ini file?

  7. #52
    Tantra Freelancer A v a r a is offline
    MemberRank
    Apr 2014 Join Date
    In Your HeadLocation
    554Posts

    Re: To all Tantra newbie developers I think you might like this

    Quote Originally Posted by dkhauz22 View Post
    sir where i can find the php.ini file?
    You can find it @ C:/xampp/php/

  8. #53
    MMORG Fan in Ragezone KyleMarvin is offline
    MemberRank
    Nov 2011 Join Date
    AustraliaLocation
    349Posts

    Re: To all Tantra newbie developers I think you might like this

    congratz guys! you are doing it! GM Terror can you teach me regarding the 3 skillbar K4? I don't like the K6. It has no editor for HTSSetting

  9. #54
    Member TantraNewbie is offline
    MemberRank
    Apr 2014 Join Date
    56Posts

    Re: To all Tantra newbie developers I think you might like this

    Quote Originally Posted by KyleMarvin View Post
    congratz guys! you are doing it! GM Terror can you teach me regarding the 3 skillbar K4? I don't like the K6. It has no editor for HTSSetting
    Warning: mssql_query() [function.mssql-query]: message: Column name or number of supplied values does not match table definition. (severity 16) in D:\xampp\xampp\htdocs\home\register\reg.php on line 161

    Warning: mssql_query() [function.mssql-query]: Query failed in D:\xampp\xampp\htdocs\home\register\reg.php on line 161

    Warning: mssql_query() [function.mssql-query]: message: Cannot insert the value NULL into column 'userId', table 'billcrux_phil.dbo.tblUser'; column does not allow nulls. INSERT fails. (severity 16) in D:\xampp\xampp\htdocs\home\register\reg.php on line 169


    Sir Kyle I have seen your post and I encounter the same problem too.I've try everything but still it does not work.would you please be kind to share how you change the code in register.php "
    $sql "INSERT INTO " please help me Sir Kyle regards
    Last edited by TantraNewbie; 18-04-14 at 03:37 PM.

  10. #55
    MMORG Fan in Ragezone KyleMarvin is offline
    MemberRank
    Nov 2011 Join Date
    AustraliaLocation
    349Posts

    Re: To all Tantra newbie developers I think you might like this

    I created this config.php

    with this code:
    <?php

    $host = 'GMKYLE\SQLEXPRESS';
    $user = 'sa';
    $pass = 'passwordbutyoucantedit';
    $db = 'UserLogin';

    ?>
    Then the login.php

    <?php
    require '../config.php';

    $user_id = $_GET['user_id'];
    $user_pass = $_GET['user_pass'];

    $conn = mssql_pconnect($host,$user,$pass);
    mssql_select_db($db,$conn);

    $sql = "SELECT * FROM Account WITH (NOLOCK) WHERE UserId = '$user_id' AND Activated = 1";
    $res = mssql_query($sql,$conn);

    $sql = "SELECT isUserCreated,Password,ID,UserKey,Email,BlockedEndDate FROM Account WITH (NOLOCK) WHERE UserId = '$user_id'";
    $r2 = mssql_query($sql);
    $userPass = mssql_result($r2,0,1);
    $ID = mssql_result($r2,0,2);
    $userKey = mssql_result($r2,0,3);
    $email = mssql_result($r2,0,4);
    $sql = "SELECT DATEDIFF(day, getdate(), BlockedEndDate) FROM Account WITH (NOLOCK) WHERE UserId = '$user_id'";
    $r3 = mssql_query($sql);
    if (mssql_result($r3,0,0) >= 0);
    $sql = "UPDATE Account SET Blocked = 0 WHERE UserId = '$user_id'";
    mssql_query($sql);
    $result = 0;
    $result = mssql_result($r2,0,0);
    mssql_close($conn);

    if (($result == -100) || ($result == -99))
    {
    echo '2';
    die();
    }

    $user_pass_ok = strtolower($userPass);
    //echo $user_pass_ok."<br>";
    $user_pass_ok = "@".substr($user_pass_ok,0,1)."^".substr($user_pass_ok,1);
    //echo $user_pass_ok."<br>";
    $user_pass_ok = md5($user_pass_ok);
    //echo $user_pass_ok."<br>";

    if ($user_pass != $user_pass_ok)
    {
    echo '1';
    die();
    }


    echo '0';

    $AccDir = "V:\TServer\DBSRV\account";
    $password2 = strtolower(md5(strtolower($userPass)));
    $ini=substr($user_id,0,1);

    if (ereg("^[a-zA-Z]$",$ini)) {
    $initial=strtoupper($ini);
    }
    else
    {
    $initial="etc";
    }


    $f=@fopen($AccDir."\\".$initial."\\".$user_id.".TAD",r) or die("Error");
    $acc = @fread($f,7124);
    $demopass=substr($acc,52,32);
    $acc = str_replace($demopass,$password2,$acc);
    $f2=@fopen($AccDir."\\".$initial."\\".$user_id.".TAD",w);
    @fwrite($f2,$acc) or die("Error");
    @fclose($f);

    ?>
    Hope you could understand it. it is how I made the login account.
    Quote Originally Posted by TantraNewbie View Post
    Warning: mssql_query() [function.mssql-query]: message: Column name or number of supplied values does not match table definition. (severity 16) in D:\xampp\xampp\htdocs\home\register\reg.php on line 161

    Warning: mssql_query() [function.mssql-query]: Query failed in D:\xampp\xampp\htdocs\home\register\reg.php on line 161

    Warning: mssql_query() [function.mssql-query]: message: Cannot insert the value NULL into column 'userId', table 'billcrux_phil.dbo.tblUser'; column does not allow nulls. INSERT fails. (severity 16) in D:\xampp\xampp\htdocs\home\register\reg.php on line 169


    Sir I have seen your post and I encounter the same problem too.I've try everything but still it does not work.would you please be kind to share how you change the code in register.php "
    $sql "INSERT INTO " please help me Sir regards

  11. #56
    Member TantraNewbie is offline
    MemberRank
    Apr 2014 Join Date
    56Posts

    Re: To all Tantra newbie developers I think you might like this

    Quote Originally Posted by KyleMarvin View Post
    I created this config.php

    with this code:

    Then the login.php



    Hope you could understand it. it is how I made the login account.
    Thank you very much Sir I will dig to script I have now a lead how you made it work...

    - - - Updated - - -




    Sir Kyle I'm to excited to test if the script is working but I have not read it thoroughly I have no problem in login Sir its working very fine but on the register.php script I try to use your script but still may register.php wont work..I can you share your register php script Sir that solve your problem please. Regards

  12. #57
    Tantra Freelancer A v a r a is offline
    MemberRank
    Apr 2014 Join Date
    In Your HeadLocation
    554Posts

    Re: To all Tantra newbie developers I think you might like this

    @Terrified

    After trying things out I came up with this kind of error of which I don't have knowledge about.



    Appreciate your inputs.

    Ciao!
    Last edited by A v a r a; 21-04-14 at 02:07 PM.

  13. #58
    Account Upgraded | Title Enabled! elche27 is offline
    MemberRank
    Dec 2004 Join Date
    TucumanLocation
    302Posts

    Re: To all Tantra newbie developers I think you might like this

    Quote Originally Posted by elitegeek View Post
    @Terrified

    After trying things out I came up with this kind of error of which I don't have knowledge about.



    Appreciate your inputs.

    Ciao!
    The warning is telling you that certain Tables/Fields (in this case Account) you reference in your query are either invalid or don't exist. Could be several thing:

    Check if you are connected to the right server/database
    Check if the data are u inserting is a correct value respect the column
    Some quote is missing
    other

    Try to run the query with a consult on your mssql app, that will give to u a better perspective

  14. #59
    Developer Terrified is offline
    MemberRank
    Dec 2013 Join Date
    Six MountainsLocation
    229Posts

    Re: To all Tantra newbie developers I think you might like this

    and how can i help you with that error?

    can you share some and what have you done so far?
    Quote Originally Posted by elitegeek View Post
    @Terrified

    After trying things out I came up with this kind of error of which I don't have knowledge about.



    Appreciate your inputs.

    Ciao!

  15. #60
    Member TantraNewbie is offline
    MemberRank
    Apr 2014 Join Date
    56Posts

    Re: To all Tantra newbie developers I think you might like this

    MG][/IMG]
    [/IMG]

    I have this thought may the problem now is my DB .I use the fix data base with pher1433 post since its bak file I try to restore it by overwriting on the DB..Problem after another but I will not give up with your help I know i can run my on server hopefully. I more thing when I run the client using a batch file I end with this..
    [IMG][/I


    Im still stuck with these problems.. I hope anyone can help me with these problems..Thanks in Advance.. regards



Advertisement