Jump to content

PHP IntersectCMS (Open Source)

Lathelmar

By Lathelmar
in Resources

 Share

Recommended Posts

  • Replies 122
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

Lathelmar
Lathelmar

IntersectCMS - Open Source CMS for ORPG   Hi MMO-makers,    I've been around for years now, and firstly, I want to clap the Intersect Team for this beautiful engine. I always loved

Lathelmar
Lathelmar

Thanks !   To summarize the installation : Download Xampp Start Xampp, and start Apache/Mysql Download the repository (https://bitbucket.org/ramlethalss/intersectcms/down

Lathelmar
Lathelmar

If you right click an item in your item editor it will copy the ID ! And you're right, the folder hasn't been uploaded to bitbucket, maybe because it was empty... Yep, create it, and copy/paste a

Worldofjimmy

Worldofjimmy

Posted
Posted
  On 3/15/2021 at 6:53 PM, XFallSeane said:

 

 

Hi 

In cms db, you need enter the ip in default_value and value. Plain password needed.

In your server you can give api access for specific user account (cmd in API DOC)

We recommend this configuration in api.config.json :

  

{
  "RouteAuthorization": {},
  "Hosts": [
    "http://localhost:5400",
    "*:5400"
  ],
  "Cors": [],
  "DataProtectionKey": "yourkey",
  "Enabled": true,
  "DebugMode": false,
  "SeedMode": false,
  "RefreshTokenLifetime": 30,
  "ThrottlePolicy": {
    "IpThrottling": false,
    "IpWhitelist": [],
    "IpRules": {},
    "ClientThrottling": false,
    "ClientWhitelist": [],
    "ClientRules": {
      "test": {
        "PerSecond": 50,
        "PerMinute": 50,
        "PerHour": 0,
        "PerDay": 0,
        "PerWeek": 0
      }
    },
    "EndpointThrottling": false,
    "EndpointWhitelist": [],
    "EndpointRules": {
      "/api/oauth/token": {
        "PerSecond": 1,
        "PerMinute": 5,
        "PerHour": 0,
        "PerDay": 0,
        "PerWeek": 0
      }
    },
    "StackBlockedRequests": false,
    "Rates": {
      "Second": 1,
      "Minute": 60
    }
  },
  "FallbackClientKey": "test",
  "RequestLogLevel": 128
}

 

I work on a total rework for Intersect CMS with several optimization and bug correction.

Two official game work with my version of Intersect CMS.

I publish soon a post for Rework Intersect CMS.

Expand  

 

The user have api roles full access made via cmd accordingly to api docs.

Is this cms database settings correct then? Or do you have an example?

f29b4e0bd0f4d38f9084807990cd126a.png

 

 

 

 

Link to comment
Share on other sites
XFallSeane

XFallSeane

Posted
Posted
  On 3/16/2021 at 5:33 PM, Worldofjimmy said:

 

The user have api roles full access made via cmd accordingly to api docs.

Is this cms database settings correct then? Or do you have an example?

f29b4e0bd0f4d38f9084807990cd126a.png

 

 

 

 

Expand  



For this version is correct
If the cms not work  check in your playerdata.db with SqlLite Browser if the account has all  after api: true is true in the power

Link to comment
Share on other sites
Worldofjimmy

Worldofjimmy

Posted
Posted
  On 3/16/2021 at 5:38 PM, XFallSeane said:



For this version is correct
If the cms not work  check in your playerdata.db with SqlLite Browser if the account has all  after api: true is true in the power

Expand  

 

This is in SqlLite Browser for this user.

I have also opened all incoming traffic for this port 5400-5403 in IIS in Windows 10 and I run the server as admin.

 

Not sure where I can debug as it works fine via Postman...

 

8e37220b2265dfaab651b1f4eabe238b.png

Link to comment
Share on other sites
XFallSeane

XFallSeane

Posted
Posted
  On 3/16/2021 at 5:56 PM, Worldofjimmy said:

 

Exactly, does not work.

If the password was "Password" then yes, the password is in plain text in web database...

Expand  


If u want my rework version is available here :
https://github.com/Thomasfds/intersect-cms

Installation process in french is here :
https://github.com/Thomasfds/intersect-cms/wiki/Installation-(FR)

Link to comment
Share on other sites
Worldofjimmy

Worldofjimmy

Posted
Posted
  On 3/16/2021 at 6:02 PM, XFallSeane said:


If u want my rework version is available here :
https://github.com/Thomasfds/intersect-cms

Installation process in french is here :
https://github.com/Thomasfds/intersect-cms/wiki/Installation-(FR)

Expand  

 

I'll try your reworked version, use google translate for the installation guide and update you on this :-) Thanks for sharing!
 

Link to comment
Share on other sites
XFallSeane

XFallSeane

Posted
Posted
  On 3/16/2021 at 6:57 PM, Worldofjimmy said:

 

Now I receive this error when I try to Login, is there any logs that I can check somewhere?

6c014fdaea3dec93eb901f0a0089cf0b.png

Expand  


Hm, 

Can you go to the App / Controller / UserController file on line 162 and remove the // from the code?  If no code at this line add this die(var_dump($register)); and retry logging in and screen the page

Before in your database web, in cms_setting api_token is # or a token as save ? default_value and value do you have  been modified to text instead of varchar?

Link to comment
Share on other sites
Worldofjimmy

Worldofjimmy

Posted
Posted
  On 3/16/2021 at 7:09 PM, XFallSeane said:


Hm, 

Can you go to the App / Controller / UserController file on line 162 and remove the // from the code?  If no code at this line add this die(var_dump($register)); and retry logging in and screen the page

Expand  

 

I guess CMS cannot connect to my IP via the port. Not sure why since Postman requests works fine. Maybe the game server needs to be located on an VPS instead of my mini homelab?

 

I got this message:

4fe459aa1f7c3d165446555932e7efe2.png

Link to comment
Share on other sites
XFallSeane

XFallSeane

Posted
Posted
  On 3/16/2021 at 7:14 PM, Worldofjimmy said:

 

I guess CMS cannot connect to my IP via the port. Not sure why since Postman requests works fine. Maybe the game server needs to be located on an VPS instead of my mini homelab?

 

I got this message:

4fe459aa1f7c3d165446555932e7efe2.png

Expand  


Nice, in db modify in table cms_setting => setting => api_server => http://yourip:yourport and that works ;) 

api_server : http://votreip:votreport => step 7 of installation

Link to comment
Share on other sites
Worldofjimmy

Worldofjimmy

Posted
Posted
  On 3/16/2021 at 7:17 PM, XFallSeane said:


Nice, in db modify in table cms_setting => setting => api_server => http://yourip:yourport and that works ;) 

api_server : http://votreip:votreport => step 7 of installation

Expand  

 

I did that but it does not work. I setup a new host via Intersect hosting and tried to connect to API there but same problem.

I this correct for your version of cms?
5f7d261a29bd2c6835340b0ec9d32421.png

Link to comment
Share on other sites
XFallSeane

XFallSeane

Posted
Posted
  On 3/16/2021 at 8:22 PM, Worldofjimmy said:

 

I did that but it does not work. I setup a new host via Intersect hosting and tried to connect to API there but same problem.

I this correct for your version of cms?

Expand  

 

For me yes everything is correct you have same message? Failed to connect yourip....? 

 

IIf you have the same message it's because it's from the server of the shot and not from the cms 

Link to comment
Share on other sites
  • 1 month later...
Nimbus

Nimbus

Posted
Posted

I am getting the following error when trying to access the url after setup:

Fatal error: Uncaught PDOException: Could not connect to database (BSC). in C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Driver\RPDO.php:440 Stack trace: #0 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Driver\RPDO.php(161): RedBeanPHP\Driver\RPDO->connect() #1 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Driver\RPDO.php(464): RedBeanPHP\Driver\RPDO->runQuery('SELECT * FROM c...', Array) #2 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Adapter\DBAdapter.php(118): RedBeanPHP\Driver\RPDO->GetAll('SELECT * FROM c...', Array) #3 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Facade.php(158): RedBeanPHP\Adapter\DBAdapter->get('SELECT * FROM c...', Array) #4 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Facade.php(1226): RedBeanPHP\Facade::query('get', 'SELECT * FROM c...', Array) #5 C:\xampp\htdocs\BSC-CMS\public\index.php(63): RedBeanPHP\Facade::getAll('SELECT * FROM c...') #6 {main} thrown in C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Driver\RPDO.php on line 440

Any help would be greatly appreciated!

Link to comment
Share on other sites
XFallSeane

XFallSeane

Posted
Posted
  On 4/21/2021 at 4:39 PM, Nimbus said:

I am getting the following error when trying to access the url after setup:

Fatal error: Uncaught PDOException: Could not connect to database (BSC). in C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Driver\RPDO.php:440 Stack trace: #0 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Driver\RPDO.php(161): RedBeanPHP\Driver\RPDO->connect() #1 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Driver\RPDO.php(464): RedBeanPHP\Driver\RPDO->runQuery('SELECT * FROM c...', Array) #2 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Adapter\DBAdapter.php(118): RedBeanPHP\Driver\RPDO->GetAll('SELECT * FROM c...', Array) #3 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Facade.php(158): RedBeanPHP\Adapter\DBAdapter->get('SELECT * FROM c...', Array) #4 C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Facade.php(1226): RedBeanPHP\Facade::query('get', 'SELECT * FROM c...', Array) #5 C:\xampp\htdocs\BSC-CMS\public\index.php(63): RedBeanPHP\Facade::getAll('SELECT * FROM c...') #6 {main} thrown in C:\xampp\htdocs\BSC-CMS\vendor\gabordemooij\redbean\RedBeanPHP\Driver\RPDO.php on line 440

Any help would be greatly appreciated!

Expand  

 

Hi,

Did you correctly fill in the information in application / App / preferences.php?

Link to comment
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
 Share
Go to topic listing
×
×
  • Create New...