Jump to content

AriusII

Contributors
  • Content Count

    33
  • Donations

    $5.00 
  • Joined

  • Last visited

  • Days Won

    3

Everything posted by AriusII

  1. 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 !
  2. AriusII

    [Release] IntersectCMS by AriusII

    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
  3. AriusII

    [Release] IntersectCMS by AriusII

    Hello, could you send us, your MySQL database Tables ? and other error who are reported one the site or in logs ?
  4. AriusII

    [Release] IntersectCMS by AriusII

    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
  5. AriusII

    [Release] IntersectCMS by AriusII

    You need to use an APACHE server like Wamp / Xampp / XAMP
  6. AriusII

    [Release] IntersectCMS by AriusII

    It's done !
  7. AriusII

    [Release] IntersectCMS by AriusII

    Thanks !
  8. AriusII

    [Release] IntersectCMS by AriusII

    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 "
  9. AriusII

    [Release] IntersectCMS by AriusII

    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 ^^ !
  10. AriusII

    [Release] IntersectCMS by AriusII

    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 .
  11. have finally published IntersectCMS V1 -> here

     

  12. 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
  13. AriusII

    How to play with friends?

    Your welcome a pleasure to help you
  14. Hello all ! I have just having a suggestion to maybe add on Intersect. One day I have try to make a class with the specification to Buff he's friends = Party Member or Guild member. The suggestion it this one : When we creat a New Spell, can we get the choice to apply it on us Party Members. Just imagine we have a CheckBox with a text like : " This skill do Party Effect ? " If the skill have < Bonus > it's a possitive value, If the skill have < Malus > it's a negative value. This idea/suggestion can be using for Guild too ! If the guild system can have Level ranking too, we can imagine to creat some Guild Spell used only by the Guild Master ? Vice ? or Member too ? A special Guild Buff, who is effective when guild member are logged in the game ? Using the same idea, with a CheckBox : ' This skill do Guild Effect ? " . - Arius
  15. We are a bit Off-Topic but; If you know how work the Party system, doing a Guild System is a bit same, just you keep more data saved ^^ ! But as I sayed, that was an idea to add in futur if ... it's accepted :p !
  16. 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
  17. I just saying this, cause it could work with the same logic. And who's know if in futur the guild system will not be implanted ? :p
  18. AriusII

    playerdata.db why can delete user

    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.
  19. AriusII

    How to play with friends?

    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
  20. #Request Close / Delete Thread ? Reason : I would like to do a correct thread about this; More Organised.
  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. Working on IntersectCMS -> 7IWj3qo.png

  23. AriusII

    playerdata.db why can delete user

    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.
  24. AriusII

    playerdata.db why can delete user

    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
  25. 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
×