Jump to content
AriusII

PHP [Release] IntersectCMS by AriusII

Recommended Posts

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 !
 

Spoiler

Index of the site.
RHGhISj.png
lb72SKr.png

UserPanel page
XybefHk.png

Your character list :
yDNDt2D.png

Global ranking :
9gv35z3.png

When you click a Character on Ranking system ( Global & Top 5 ranking, work both )
lg1v0GK.png
VK0TW8v.png

ADMIN PANEL page
qzMH50d.png

Listing of news / Adds / Removes news : 
LRqTBwv.png

COPYRIGHT & ACCORDS :
hhWvxth.png

qb56m0b.png


\! 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 :) !
 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

meh.

 

I think something AGD could do is "partner up" with your code and as the server sends things to AGD servers it can also send things to whatever stuff you have and then do stuff from there :p

Share this post


Link to post
Share on other sites

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 "

Share this post


Link to post
Share on other sites
1 minute ago, Kibbelz said:

@AriusII could you please upload this to AGD's file hosting service so we wont have any external links going down in a few years time.

It's done :) ! 

Share this post


Link to post
Share on other sites

Hello, 

First of all would like to shout out to Ariusll, thank you so much for this code it's so awesome!
After reading and following your instructions I kept getting an error when trying to load the website, I quickly noticed a minor error in the config file and wanted to help and bring this to your attention and show new users how to get the website working if they run into the same issue as I did.

in the config file located in the /inc folder look for the following line.

 $db_web = "websitdata"; // Put the correct DataBase Name of the < WebSite >, Default : websitedata.

and change websitdata to websitedata that's it.  Looks like the letter "e" was missing, Ariusll if you could fix this from the download .rar file that would be even better however, since it really is a minor error not sure if it's worth your time to change that when the users can do it.  

anyways, thanks again!

Side Note:  I will be playing with the website and see if I can possibly add bootstrap into this project.

Share this post


Link to post
Share on other sites
14 hours ago, Worldofjimmy said:

How do I get website to connect to the gameworld database? I have it as mysql

 

Hi Worldofjimmy,

Like, Ariusll said you will first need to install your favorite choice of web server either wamp or xampp, depending on your operating system wamp may not always work.  In my case Xampp worked perfect for me.  Than you will need to open MyPHPadmin and create the three databases like Ariusll said.   the three database are playerdata , worlddata , and websitedata Xampp at first might ask to create a table for each database that's fine just use the same name as the database that's what I did and it worked for me.  Than load your Intersect server if loading from the same computer you can leave the default ip address as 127.0.0.1 I personally changed mine to localhost doesn't really matter I am just OCD about stuff like that.  on the Intersect server type "migrate" without the quotation marks  than follow the prompts, at this point you should have your user name and password to the mysql ready, if the connection was successful it will say it and than ask to hit a key to close you will have to reopen your Intersect server and do this all again for the playerdata, remember gameworld will be connected to the worlddata database.  Hope this helps let me know if you have any questions.  Make sure to read my last post if you see the "Try to connect at WebSite DataBase impossible." error message.  

Share this post


Link to post
Share on other sites
8 minutes ago, The Bunny Gamer said:

I already have a SQLite database, can I convert this to MySQL?

 

Sup the bunny gamer,

The migration tool is used to migrate your current non mysql to mysql.

Share this post


Link to post
Share on other sites
On 4/29/2019 at 8:22 PM, starlord said:

 

Sup the bunny gamer,

The migration tool is used to migrate your current non mysql to mysql.

 

Oki doki thanks, I will attempt to convert my SQLite database to mySQL tomorrow.

 

(To person who created this):

By the way, I don't think I've said yet, you've done really well and much better than most people on this forum!!!

 

Edit: I've converted the databases to mySQL, now to see if it works. Also, this is free right or you need to give credits? Also, MySQL workbench is perfect for it.

Share this post


Link to post
Share on other sites

Hello,

 

I use Ampps on my other computer.

I have 3 MySQL databases, 1 for players, 1 for website and 1 for game server.

I can connect to game from outside my network.

 

I still get Game Server Offline.

f7535752bd5ce78fe5401655ca418c00.png

 

I have this settings for server

551d889e0e14d733554a0c6dd4bb979e.png

 

 

What Should I do?

Share this post


Link to post
Share on other sites
1 hour ago, Worldofjimmy said:

Hello,

 

I use Ampps on my other computer.

I have 3 MySQL databases, 1 for players, 1 for website and 1 for game server.

I can connect to game from outside my network.

 

I still get Game Server Offline.

f7535752bd5ce78fe5401655ca418c00.png

 

I have this settings for server

551d889e0e14d733554a0c6dd4bb979e.png

 

 

What Should I do?

 

Hello worldofjimmy,

 

Yeah it seems using localhost is causing the -1 resulting in the game server showing offline.  I'm sure there is a way to fix this looking into this now.

Share this post


Link to post
Share on other sites
2 minutes ago, starlord said:

 

Hello worldofjimmy,

 

Yeah it seems using localhost is causing the -1 resulting in the game server showing offline.  I'm sure there is a way to fix this looking into this now.

 

I tried to use external IP and local IP. Still same, Game Server Offline.

Shouldn't I type in credentials to the gameserver database somewhere? like user and password?

Share this post


Link to post
Share on other sites

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 :)

Share this post


Link to post
Share on other sites
17 minutes ago, AriusII said:

when I will be back i would like to work on this with other people , if some are interessed :)

I know php and mysql, I would happily help with this project anytime 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×