Jump to content

AriusII

Contributors
  • Content Count

    33
  • Donations

    $5.00 
  • Joined

  • Last visited

  • Days Won

    3

Everything posted by AriusII

  1. For peoples who have some little errors, you need to check if the name of your database Tables, if them are in caps or not, if them are, you need to edit sql code
  2. Hello, could you send us, your MySQL database Tables ? and other error who are reported one the site or in logs ?
  3. Hello everyone, sorry I was absent. Thanks everyone for each feedback ! For each problems about the 'ip' don't worry it's working. It's just cause the (local ip - 127.0.0.1 - 192.168.x.x) can't resolve an ip issue for make a valid check with the AGD api system. you could modify it if you know php and edit the code. this was using for external ip using ( web Host , vps Host ... ) kiss everyone ❤️ when I will be back i would like to work on this with other people , if some are interessed
  4. You need to use an APACHE server like Wamp / Xampp / XAMP
  5. Them are working on a API system who can work ( if I don't say wrong things ) with SQLite system. If I sharing this, it's for everyone can use it / manage it , review the code and take what them want ^^ ! You can do a Live demo here : https://sao-france.fr/ with account ' test / test "
  6. I can understand what's you trying to say and what's your feeling, But actually MySQL > SQLite, that why I make my priority of this one. The only interest of Lite it's able to stock data on it without connection ... But for a Website (FTP / VPS) connection it's work like a sham, what's sqlite can't do cause this one don't have TCP/IP. And alot of people who know manage a game / server, will be ok with me to say MySQL is more usefull ^^ !
  7. Yes it is. Actually I don't have plan to make ODBC SQLite connection with this one, but maybe in futur ! Who's know ! @The Bunny Gamer .
  8. have finally published IntersectCMS V1 -> here

     

  9. Good morning, everybody ! I’m glad you share my little creation ! But before we tell you what it is, we’re gonna talk a little bit more about what makes you want to create this ! I’ve been following the " Intersect Engine " project for a long time, even before I joined the forum. But I found that it missed a very important addition, which responds to the call of the MMORPG, not only for the game, but also the aspect that lies behind the "Back-End", the way was managed the Database! Yes, this famous SQLite ! Whatever we say, he always did his work, but one that is not insignificant and that was missing in the call the "TCP/IP". And, FINALLY! The project went under the "MySQL Engine", Liberation! We can finally call our database where we want, and... What better way to make our game more popular by having its own website? Because you can say anything you want, it’s still nicer to have your own website attached to your game? Make your own announcements, have a real-time ranking, add your own changes/creations, and so much more…! And this is now possible with "IntersectCMS". What is IntersectCMS IntersectCMS was created by AriusII. It is a kind of fansite, but for anyone who wants to have the opportunity to be seen on the internets, there is no need of great knowledge in this area, you just have to edit a few lines and everything works! The Features - You can log in with your game account on the site. - You can display the number of players connected. - You can display the number of create players. - You can display the number of create accounts. - You can create/display your news, with different headers. - You can show the ranking of the top 5 players in your game on the main screen, in real time! - You have access to a general ranking page in real time. - You can click on the characters and know their information, even if the character is not part of your account! Admins ? - You must be the Admin of your game, and you log in with this account on the site, no worries! You will also be the admin of the site and you can all change as you please! With a dedicated place. And so much more in preparation... ! Want some screen ? Here it is ! \! IMPORTANT !/ + Setup Config * you need to read this if you planned to use it * 1 ) For people who already have an existing project, (under SQLITE) this will not be compatible! * please read number 3* 2)For those who want to create or recreate a zero project, now go to MySQL * please read number 3 * 3. Little config step; 3.1 You need to having software like apache + mysql, like this one : http://www.wampserver.com/en/ Create 3 databases : playerdata , worlddata , websitedata Migrate : playerdata.db into the mysql database playerdata. & gamedata.db into the mysql database worldata. In the folder you have a ' websitedata-news.sql ', execute the querys in the websitedata database. When query are correctly executed you can delete this file. Go on your " www " folder ( if you use wampserver ) or ' htdocs ' if you are on other software/FTP Extract all ' www ' file on the folder sayed before. Set your settings in the " www/inc/config.inc.php " file. Edit all the informations needed. Go on " http://localhost " or " http://mydomainname.com " Enjoy ! ________________________________________ Actualy this release is the first one, other system will come in futur ! How to get it ? You can find it here: Give me your feedback !
  10. Your welcome a pleasure to help you
  11. Here, you are all talking about something you know how to do it < better >. This tutorial was for Beginner user... I have started this type of project when I had 10-12 year old, I have 23 YO now, & I'm from an ancient 2D mmorpg community named FRoG Creator #RIP little froggy. And when I had this age I didn't know how to do it, not the skill / motivation / knowledge, for doing this. This tutorial is for them, an easy way to do it. +(Argument) If you want make a custom webserver on your computer ... you have already do the job ! Of course, if we talk about DNS it's just a way to ' mask ' your IP with a name, but the real motivation of this, it's basically why we have create DNS register, it's easy to think with a 'name(dot)something' out of xxx.xxx.xxx.xxx (:port). But like say before if you don't have an Static IP you need to say to everyone ' Hey my IP is now this. -2 day later: Now it's this.' It's not at us player's to do them self update/modification ( Yeah I know they are a Launcher avaiable, but making a update for only 1 file it's really ... creepy ) That why I recommand using No-Ip for free use, and with the DUC Client the refresh is so much better and simply ! - Regards, Arius
  12. Go on navicat Log into your database and double click on " users " table. At the top-left of navicat you will find " Query " button, press it. put this : DELETE FROM `playerdata`.`users` WHERE `Name` = 'simsim' I have put the name of simsim if it's this one you would like to delete.
  13. Required Level : Beginner Estimated time: Between 5 and 10 minutes Hello dear community ! Here we go for a new tutorial ! This tutorial affects our server, and more specifically How to make our server accessible at either home without buying VPS / Dedicate Server. And for this we will talk about NO-IP ! Requirement: - Some patience - A beer ! or Two .. I. Step I II. Step II III. Step III Thanks everyone for reading this tutorial. This have help you ? It was usefull for you ? don't forget to react ! Help & Question about this : here. - AriusII
  14. Hello ! Can you explain us more details about your current setup ? What do you use : Personnal Computer ? VPS ? Dedicate Server ? If in the case you use your own Personnal Computer you have some tools and step to do. I have wanted to make a tutorial for making it working ^^ ! So here the step : First you need to setting up your Windows FireWall Set in UDP the port "5400" by default or other number if you have change this number. You need to do it 2 times, Interne connection and Extern connection. When this is done, you need to check your rooter/modem. Does your modem allow the UDP port '5400' too ? For my case it's automaticly add with the first startup of the Intersect Server.exe ( when it's needed to start it in admin ). If it's not added, you need to do it manually, it's not very complicated. Good all the majors step are done. We can allow external connection to read us ip+port ( Only this one ). You need now to get a DNS refresher or an other LAN software. More effective in this case it's : No-Ip or you can select : LoginMeInHamachi For both using you need to creat an account on one of them device of your choice When your No-Ip account is done download the DNS refresher Client ( DUC ) : Here You need to make a custom DNS on this page : Here and press ' Create Hostname ' You need to put ONLY custom value on : Hostname text field & Domain like this : Exemple , and put ' Creat Hostname ". Now you need to install the No-Ip Client ( DUC ) , log into it, you have to select your recent no-ip dns just created. and it's done ! You could use your External Public IP in clear, or the DNS You need edit the Client or Editor config.json for to be able to read the server on external computer. 1 Client or Editor for yourself who keep reading 127.0.0.1 ( I say you are on a Personnal Computer ) And need and other Client / Editor with modifier config.json who read the ' External IP or DNS " The most effective it's reading by DNS cause the DUC make a refresh of your IP DNS every 5 minutes, so if you restart your modem you don't need to send again your External Ip it's done automaticly. When your LoginMeInHamachi account is done you need to download the client : Here Your friend need to do it too. / ! \ It's only a 14 days trials, but old version of this one was without this trials ( It's not a crack ! ^^ ) You need to creat a channel on this client Your friends need to join it too. Hamachi normaly return you a custom IPv4 IP, Copy it And modify your Client or Editor config.json files with this IP. You just need to make 1 copy of thoses folder, no need to make one for local and one for hamachi. It's work too If you are on VPS / DEDICATED SERVER : First you need to setting up your Windows FireWall Set in UDP the port "5400" by default or other number if you have change this number. You need to do it 2 times, Interne connection and Extern connection. Modify Client & Editor config.json files with your VPS / Dedicated server IP. And it's done ! Happy if this helping
  15. #Request Close / Delete Thread ? Reason : I would like to do a correct thread about this; More Organised.
  16. Working on IntersectCMS -> 7IWj3qo.png

  17. Hum try with SQL QUERY to delete the user something like this : DELETE FROM `playerdata`.`users` WHERE `Name` = '<TheNameOfFuturDelete>' Cause as I could see you have some problems with your Id collumn, the delete record from navicat, delete from ID.
  18. Hello, Wish user are you trying to delete ? Make sure your server is off for doing this step, Jcnider sayed me, modify data during server up can cause some unstability. Select all your row ( the little arrow " > " at the left of ID collumn ) and press DEL or Click right on it, Delete Record
  19. Yeah it's working ... just needed to do some convertions : Here it is a gif for making the exemple. https://i.imgur.com/JQasyyF.gifv
  20. Ohhhh ! Ok thanks ! Sorry ! I was thinked it's plain text pass + Salt, but you do two convertion. Sha256 + PlainText = hash1 Hash1+Salt = hash2 = Password. It's done !
  21. Hello everyone ! I'm doing a little project for this community, having a WebSite for your own game server ! This CMS use my own base code for other CMS game website and work like a charm, I just edit it for make working with Intersect / MySQL ( And maybe SQLite too if i'm motivate to do sqlite jdbc connection ). But I'm a bit frustate about something.., I have a problem about my login form ( B-E code ) exactly about hashing password result., If my password in clear is : Dragon123 and my Salt is : 357EF1FF2A9A5EAF893CBCE985FE667ACB1547669761E7CDBD0483DC43E0C188 It's making the hash form like this = Dragon123357EF1FF2A9A5EAF893CBCE985FE667ACB1547669761E7CDBD0483DC43E0C188 Right ? My Password collumn saying me, the result it's : 7DE02F71146E0BA0B33BFB7BBA8C99A258DEEF71FD83C401F5CD240C2A1F8352 I have try to go here : https://passwordsgenerator.net/sha256-hash-generator/ and do my clear password + Salt. ( cf : Dragon123357EF1FF2A9A5EAF893CBCE985FE667ACB1547669761E7CDBD0483DC43E0C188 ) and getting an other hash : 309407CFBF0798BB31795E88384B4482F2A296C54CA1FEB8AD52A7AFCA5B0CCA You can try it .. and you can see it's not the same result / hashing. So here it's my first problem and after read the docs by @jcsnider ( https://www.freemmorpgmaker.com/docs/en/Advanced_Topics/Database.html ) No doubt about the password encryption ... it's in PHP/PDO. Here it's my page about the connection (asking if value are correct and be able to logon the site): And as you could see, I do the same procedure... but not working, someone know why ..? - Arius
  22. Hello back ! Thanks for this reply .. ! I have try to do the migrate command, and when I have try to put the same informations, it's saying -> So I just doing a second database ( like what it's actually do with SQLite ), I was trying to work with only 1 DB like old version of intersect... I have create 2 Databases ( Player & Game ) and the migration ( with server works ! ) I have try to do it with Migration Tool with the two databases, it's worked too ! So conclusion we need 2 DataBases for making works. Note : When you just extract the Server Files Folder ( 4 files , migration + pdb / Server + pdb ) when you launch the server the first time, edit the config.json, change the DB connexion type with MySQL and using for both the same Database, and remove all other files execpt the 4 first + config.json. All informations are correctly insert without error, and the server run without problems. Ps: I think it's better to write it somewhere for not having the same probleme issue, of course it's my fault if I just put 1 DB and not 2 like it's say now for SQLite, yeah this fell really assist but i was creat only 1 DB cause I have see it's working with starting clean files so at this point I was not in search to make 2 DB's x) ! Thanks you @jcsnider
×
×
  • Create New...