Hi there....old player, guild leader, php programmer

Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 32
  1. #16

    Re: Hi there....old player, guild leader, php programmer

    Quote Originally Posted by crosenblum View Post
    Just an update.

    Already previously had xampp for windows, which comes with apache, php and mysql of course. Then used the service https://www.rebasedata.com/convert-sql-to-mysql-online To convert a repack's mssql db to mysql. Then created two new db's to insert the sql statements for kal_auth and kal_db, got the odbc working.

    Now I'm trying to see if the dbserver can connect to the odbc I created.
    oh boy
    XAMPP, that's old.

  2. #17
    LordJustice crosenblum is offline
    MemberRank
    Apr 2007 Join Date
    Burnsville, MNLocation
    417Posts

    Re: Hi there....old player, guild leader, php programmer

    So I got the database working fine, and the odbc connector to mysql installed and working.

    Right now just want to get the auth, dbserver and main server connecting via mysql odbc.

    How did you get server software to connect to the mysql server, what was your approach?

  3. #18
    Account Upgraded | Title Enabled! RevEngKal is offline
    MemberRank
    Mar 2016 Join Date
    229Posts

    Re: Hi there....old player, guild leader, php programmer

    .....
    Last edited by RevEngKal; 14-08-21 at 05:51 PM.

  4. #19
    LordJustice crosenblum is offline
    MemberRank
    Apr 2007 Join Date
    Burnsville, MNLocation
    417Posts

    Re: Hi there....old player, guild leader, php programmer

    Ah I see.

    I'd rather use mysql, if i can get the game server to connect to it, then it shouldn't be a difference to the end users, the players, but hopefully much better performance, and reliability.

    I am figuring on trying to see what ports each program tries to connect to, and see if i can switch those somehow.

  5. #20
    Account Upgraded | Title Enabled! RevEngKal is offline
    MemberRank
    Mar 2016 Join Date
    229Posts

    Re: Hi there....old player, guild leader, php programmer

    .....
    Last edited by RevEngKal; 14-08-21 at 05:51 PM.

  6. #21
    LordJustice crosenblum is offline
    MemberRank
    Apr 2007 Join Date
    Burnsville, MNLocation
    417Posts

    Re: Hi there....old player, guild leader, php programmer

    I can use MSSQL fine, having worked for years as a web programmer. Or oracle or mysql, etc.

    Just that mysql is easier to manage and administer.

  7. #22
    Account Upgraded | Title Enabled! RevEngKal is offline
    MemberRank
    Mar 2016 Join Date
    229Posts

    Re: Hi there....old player, guild leader, php programmer

    .....
    Last edited by RevEngKal; 14-08-21 at 05:51 PM.

  8. #23
    LordJustice crosenblum is offline
    MemberRank
    Apr 2007 Join Date
    Burnsville, MNLocation
    417Posts

    Re: Hi there....old player, guild leader, php programmer

    Well I got the web/php part. But the server software won't work with it.

    So atm I have a working unmodified installed clean exe repack working, got odbc, everything works.

    Have a working website with just registration process.

    But now starts the long work of customizing it.

    And then once I have everything working, I want to migrate it and test it on my other linux/debian pc, and see if i can get docker figured out, since I've never used it.

    How are you doing btw, I appreciate your interest.

  9. #24
    Account Upgraded | Title Enabled! RevEngKal is offline
    MemberRank
    Mar 2016 Join Date
    229Posts

    Re: Hi there....old player, guild leader, php programmer

    .....
    Last edited by RevEngKal; 14-08-21 at 05:50 PM.

  10. #25
    Enthusiast pkedpker is offline
    MemberRank
    Dec 2006 Join Date
    46Posts

    Re: Hi there....old player, guild leader, php programmer

    Have you tried this?

    https://dev.mysql.com/downloads/connector/odbc/

    ODBC for mysql..
    should work to avoid MSSQL.

    when you run odbcad32

    select MySQL connector instead of SQL Server Connectors

  11. #26
    Account Upgraded | Title Enabled! RevEngKal is offline
    MemberRank
    Mar 2016 Join Date
    229Posts

    Re: Hi there....old player, guild leader, php programmer

    .....
    Last edited by RevEngKal; 14-08-21 at 05:49 PM.

  12. #27
    Enthusiast pkedpker is offline
    MemberRank
    Dec 2006 Join Date
    46Posts

    Re: Hi there....old player, guild leader, php programmer

    no didn't test it but you can patch the SQL Queries in DB Server with a hex editor or Notepad++ or whatever favorite editor you use that supports binary mode. Check every query with MySQL Lint
    https://www.eversql.com/sql-syntax-check-validator/

  13. #28
    Alpha Member Stup is offline
    MemberRank
    Oct 2006 Join Date
    AustraliaLocation
    2,429Posts

    Re: Hi there....old player, guild leader, php programmer

    Hey LJ :D

    How did you go with this?

  14. #29
    Enthusiast pkedpker is offline
    MemberRank
    Dec 2006 Join Date
    46Posts

    Re: Hi there....old player, guild leader, php programmer

    whos LJ?

  15. #30
    Account Upgraded | Title Enabled! RevEngKal is offline
    MemberRank
    Mar 2016 Join Date
    229Posts

    Re: Hi there....old player, guild leader, php programmer

    .....
    Last edited by RevEngKal; 14-08-21 at 05:49 PM.



Page 2 of 3 FirstFirst 123 LastLast

Advertisement