[DiscordArchive] is that something I change in HeidiSQL when Im opening the database?
[DiscordArchive] is that something I change in HeidiSQL when Im opening the database?
Archived author: Gordon McAllister • Posted: 2024-02-01T21:27:38.421000+00:00
Original source
I had entered the new source directory in Authserver in the commented section instead of the SourceDirectory=' ' section
Archived author: Gordon McAllister • Posted: 2024-02-01T21:53:43.438000+00:00
Original source
I got everything to work, the issue was that I wasnt running it in admin mode, the Auth server was looking at the wrong IP and source directory and the user acore need to be deleted and the commands from the guide re-commanded.
Archived author: Gordon McAllister • Posted: 2024-02-01T21:56:41.447000+00:00
Original source
Thanks for trying to help me Ymir, but for future reference, you dont need to be an ass when somebody asks you a question and doesn't understand something. Especially when the topic is something pretty complicated such as SQL and databases. It had nothing to do with the Bind IP, and the fact that I did not understand your cryptic instructions does not mean I do not "have any proper knowledge" learn proper people-skills and grammar.
Archived author: Ymir • Posted: 2024-02-02T04:57:35.331000+00:00
Original source
thank you for your kind remarks i will keep them in mind and i was like that bc i was doing other things while chatting with ya so the stressing got me
Archived author: Ymir • Posted: 2024-02-02T04:58:30.152000+00:00
Original source
and when you try to connect externally well see if am saying crap or not
Archived author: Ymir • Posted: 2024-02-02T05:00:02.857000+00:00
Original source
and what i meant for "you dont have any proper knowledge on mysql" its like telling a 13years old kid that only know 1+1=2 to solve an equation
Archived author: Ymir • Posted: 2024-02-02T05:00:26.497000+00:00
Original source
and am glad your problem is solved
Archived author: Abillister • Posted: 2024-02-02T13:21:48.534000+00:00
Original source
A:/ - are you running on a floppy?! Please insert disk #4.
Glad to see you figured out your issue. A good note with SQL - as you start mucking around with things make sure to SAVE any update statements you do against the World database. What you will find is that you start to make small tweaks, then at some point reload the World (doesn't effect your characters/accounts) but forgot to save something.
Archived author: Abillister • Posted: 2024-02-02T13:24:21.343000+00:00
Original source
I've just been putting my custom little tweaks that get applied here and there into a single SQL/text file with comments before each one. For example I added a NPC to sell a specific item...then decided to add a few more things to that NPC . So each time I've tweaked that NPC I just go to that section of the file and add the new lines there.
Archived author: Abillister • Posted: 2024-02-02T13:24:57.053000+00:00
Original source
But when I first started I made some tweaks that I did not save. And upon reloading the world I had to figure them out again.