Question: Install of stfc2

[Caberhagen]

Hi

i tried to install your branch.
I have setup the ui in webfolder and databes in mysql.
Now i can't find the config.inc.php. So it shows me no connection to databes.
Ande a can not see, waht for crons are needet.
Du you have a setup how to?
Or you can help me?

And thx for you work. was a long time ago i have played this game :)

[kirirur]

Hello, I'll try to help.

First of all I've added to the repository a sample of config.inc.php (it was missing since a lot). You'll need to fill it with your configuration.

Please take note that present version of the repository still assume the game running with two galaxies and a IPB forum, so if it's not your case you have to modify at least login.php, register.php, stats.php in pages folder and portal.php in modules folder.

I don't understand your trouble with the crons. If you mean the scheduler, they are all stored in a separate repository here on GitHub. There are mainly the following running tasks:

• daily once a day usually at midnight
• main once a tick, usually each 3 minutes
• moves_main once a minute, it also need the Combat module to handle fleets fight
• fix_all, usually each hour
• six_hours, usually well, each six hours

Depending on your configuration of the Galaxy (especially if you want NPC or not), it's possible to disable or customize the last two and main one.

Let me know if everything is clear now.

I hope you had and maybe you'll have great time on stfc! :)

[Caberhagen]

Thx this helps a lot.

$config=array();
$config['server']="localhost";
$config['port']="3306";
$config['user']="***";
$config['password']="**";
$config['game_database']="**********";
$config['game_url']="http://game.sbhost.ch/game/";
$config['site_url']="http://game.sbhost.ch";
$config['game_path']="/var/www/virtual/game.sbhost.ch/htdocs/game/";
$config['scheduler_path']="/var/www/virtual/game.sbhost.ch/htdocs/scheduler/";
$config['galaxy']=0;
$config['uploaddir'] = '/var/www/virtual/game.sbhost.ch/htdocs/gallery/';

define ('ERROR_LOG_FILE', '/var/www/virtual/game.sbhost.ch/htdocs/error_log.htm');
define ('ADMIN_LOG_FILE', '/var/www/virtual/game.sbhost.ch/htdocs/admin_log.htm');
define('DEFAULT_GFX_PATH', '/var/www/virtual/game.sbhost.ch/htdocs/gfx/');
define('PROXY_GFX_PATH', '/var/www/virtual/game.sbhost.ch/htdocs/gfx/');
define('JSCRIPT_PATH', '/var/www/virtual/game.sbhost.ch/htdocs/game/stgc2.js');

this is my setting on the dev box now.
I am not sure about the js path.? is it the right?

Now the Start page open. but i have problems with queries from db.
output from error_log

18.11.14 20:13:15 User: external user Database Error:
Could not select database

No error occured (0)

But the values are rigth in config.inc.

i use mysql 5.5.40-0+wheezy1
PHP extension: mysqli

can mysqli be the problem?

and really thx for your help. :)

[kirirur]

It's seems quite good to me, only the define JSCRIPT_PATH needs to point to the folder containing the js and not directly the file. On mine config it's configured as '' and it works.

Current version of the game code is still using the old mysql php extension so yes, mysqli could be a problem if you have only this extension enabled. Luckly I've pull a request #6 in order to provide support to that extension,

Before applying the patch to your code, however, which page of the game show that error? I mean, you're able to log in?

[Caberhagen]

Error shows at login, register and statistics.

[kirirur]

Hmm, did you correctly modify UI/game/include/global.php in order to point correctly to your config.inc.php file?

[Caberhagen]

i think so:
/var/www/virtual/game.sbhost.ch/htdocs/config.inc.php

so i try now your new merged version to see is mysqli the problem.

but anyway really thx for your help.

[kirirur]

Ok, it's seems a valid path indeed. Check the new mySQLi support, however I'm almost sure that the game can run on mySQL 5.5 without it with some failing queries, the problem you're facing seem something more serious. It seems the game cannot access to the whole database.

Just to be clear I'll repeat myself: are you sure you removed all references to secondary galaxy from the pages you mentioned? As I wrote in the first post?

[Caberhagen]

Ok startet now a new devbox. install all like you write here.

Now it look so as it connect to database.
on login register and stats all fine.

crons not startet now. have tried to register first user. but on click the register button only refreshing page. and no new user in db.

if you want see the code on server, i can give you access by teamviewer. but i search to find the problem.

every day it looks a little bit better :)

[Caberhagen]

it seems like i have to start the galaxy first. but dont find where.

[kirirur]

Hello,

are you saying that after you've filled all required fields in registration form, when you it Register button nothing happened? This sound really strange to me. No errors came out?

It could be some skin related problem. After Register button is pressed the game performs some checks before creating the user (it should inform the user if something went wrong however), and if everything is fine it create the new user in the DB, the required instructions are just two:

• create a new row in user table
• creare a new row in user_templates table but if the skins table is empty it will fail

if you downloaded the empty database from the repository you need to create at least one row in the skin table and add you own skin.

[kirirur]

It's difficult to have the game up and running, I know. That's why I'm trying to rationalize its code, restructure it in order to have a base in the future for a setup script. At the moment lot of the operations needed must be performed manually.

I think your problem at the moment is the empty DB, take a look to game/modules/tools/world/reset.php (unfortunately it can be called only logged to the game), you should find the needed mySQL query to create admin user.

I had forgotten that the default skin can be found here: https://github.com/stfc2/UI/blob/master/game/modules/tools/world/default_template.html

[Caberhagen]

Yes its the empty db.
So it need in the sql data not only the structure also the values from
reset.
But with standard values like user:admin pw:admin email:muster@somthing.com
So an intial setup will have the bas asmin account to start.
Can you add the vaules to the database branch?
Am 19.11.2014 20:34 schrieb "Andrea Carolfi" notifications@github.com:

It's difficult to have the game up and running, I know. That's why I'm
trying to rationalize its code, restructure it in order to have a base in
the future for a setup script. At the moment lot of the operations needed
must be performed manually.

I think your problem at the moment is the empty DB, take a look to
game/modules/tools/world/reset.php (unfortunately it can be called only
logged to the game), you should find the needed mySQL query to create admin
user.

I haven't yet loaded the skins in the repository, I'll do asap but I think
you'll have one haven't it?

—
Reply to this email directly or view it on GitHub
#9 (comment).

[kirirur]

Well, I'm really sorry but my intention is to store on the repository only the structure of the DB, while the install script will do all the needed task and insert all the needed data. There are several steps to perform in order to start the galaxy, almost of them are already automated even if sparse in several scripts, my intention is to create a sort of "caller" of those scrips including a new one asking the installer for admin user authentication.

For your purpose you just have to take the data from the script reset.php and alter the password with phpMyAdmin to set your taste.

UI repository is not complete, when the work will be finished you'll have to download the latest release and launch the web installer.

[Caberhagen]

Ok i try it after work to add the values from reset.php.
I added yesterday the first values to admin account. An can login to it.
But have to add the rest to build the gakaxy.
Am 20.11.2014 06:31 schrieb "Andrea Carolfi" notifications@github.com:

Well, I'm really sorry but my intention is to store on the repository only
the structure of the DB, while the install script will do all the needed
task and insert all the needed data. There are several steps to perform in
order to start the galaxy, almost of them are already automated even if
sparse in several scripts, my intention is to create a sort of "caller" of
those scrips including a new one asking the installer for admin user
authentication.

For your purpose you just have to take the data from the script reset.php
and alter the password with phpMyAdmin to set your taste.

UI repository is not complete, when the work will be finished you'll have
to download the latest release and launch the web installer.

—
Reply to this email directly or view it on GitHub
#9 (comment).