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

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

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

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

It's done !

Thanks !

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 "

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 ^^ !

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 .

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 !

Your welcome a pleasure to help you

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

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.