Problem z instalacja Travian

pekiniak · 5 Września 2015

Witam, dziś chciałem pobawić się silnikiem Travian ale napotkałem problem z kilkoma silnikami ciągle ten sam może ktoś z was mi pomoże.

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'cba.pl' (111) in /virtual/xxxx.xx.xx/install/include/database.php on line 30
Can't connect to MySQL server on 'cba.pl' (111)

Jestem w kropce, może ktoś z was powie mi co dalej? bo bawię się z tym już z 2 godziny.

Salur · 5 Września 2015

Problem z połączeniem z bazą, zamiast cba.pl daj mysql.cba.pl, jeśli nie pomoże daj zawartość pliku database.php.

pekiniak · 5 Września 2015

Nic nie dało, więc podaje zawartość database.

<?php
//////////////////////////////////////////////////////////////////////////////////////////////////////
// TRAVIANX //
// Only for advanced users, do not edit if you dont know what are you doing! //
// Made by: Dzoki & Dixie (TravianX) //
// - TravianX = Travian Clone Project - //
// DO NOT REMOVE COPYRIGHT NOTICE! //
//////////////////////////////////////////////////////////////////////////////////////////////////////

include("constant.php");

class MYSQLi_DB {

    var $connection;

    function MYSQLi_DB() {
        $this->connection = mysqli_connect(SQL_SERVER, SQL_USER, SQL_PASS, SQL_DB) or die(mysqli_error());
    }
        function query($query) {
        return $this->connection->query($query);
        }

};

class MYSQL_DB {

    var $connection;

    function MYSQL_DB() {
        $this->connection = mysql_connect(SQL_SERVER, SQL_USER, SQL_PASS) or die(mysql_error());
        mysql_select_db(SQL_DB, $this->connection) or die(mysql_error());
    }

    function mysql_exec_batch ($p_query, $p_transaction_safe = true) {
if ($p_transaction_safe) {
$p_query = 'START TRANSACTION;' . $p_query . '; COMMIT;';
};
$query_split = preg_split ("/[;]+/", $p_query);
foreach ($query_split as $command_line) {
$command_line = trim($command_line);
if ($command_line != '') {
$query_result = mysql_query($command_line);
if ($query_result == 0) {
break;
};
};
};
return $query_result;
}

    function query($query) {
        return mysql_query($query, $this->connection);
    }
};

if(DB_TYPE) {
    $database = new MYSQLi_DB;
}
else {
    $database = new MYSQL_DB;
}
?>

Salur · 5 Września 2015

Po zmianie na mysql.cba.pl blad sie zmienil?? Daj jeszcze zawartosc pliku konfiguracyjnego gdzie ustawiasz host itp, hasla zamaz.

pekiniak · 5 Września 2015

a błąd taki:

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'cba.pl' (111) in /virtual/lotnictwo.c0.pl/install/include/database.php on line 30
Can't connect to MySQL server on 'cba.pl' (111)

Salur · 5 Września 2015

Skoro ustawiles host na mysql.cba.pl to powinno ci sie w bledzie zmienic. Najprosciej znajdz plik w ktorym zapisuja sie dane do bazy typu haslo host itp i tam to ustaw lub takowy plik wstaw tu.

pekiniak · 5 Września 2015

Pośród tylu plików znaleźć ten jeden, uff będzie ciężko.

Salur · 5 Września 2015

Wszystko bedziesz miał wskazane w pliku instalacyjnym. Zobacz jaki jest adres tego pliku z ktorego dawales zdjecie.

Ps: jest to plik constant.php znajdujacy sie w folderze include

pekiniak · 5 Września 2015

Wszystko bedziesz miał wskazane w pliku instalacyjnym. Zobacz jaki jest adres tego pliku z ktorego dawales zdjecie.

Ps: jest to plik constant.php znajdujacy sie w folderze include

Ale tu nie ma tego pliku ;/

Jedyny plik jaki jest to constat_format.tpl i znajduje się zupełnie gdzie indziej ;/

<?php

############################### S T A R T   ################################

##              -= YOU MAY NOT REMOVE OR CHANGE THIS NOTICE =-                 ##

## --------------------------------------------------------------------------- ##

## Filename       config.php                                                  ##

## Version        4.8.5                                                       ##

## Developed by: Dzoki Edited by Advocaite                                   ##

## License:       TravianX Project                                            ##

## Copyright:     TravianX © 2010-2011. All rights reserved.                ##

##                                                                             ##

#################################################################################

//////////////////////////////////

// ***** ERROR REPORTING *****//

//////////////////////////////////

// (E_ALL ^ E_NOTICE) = enabled

// (0) = disabled

%ERROR%

//////////////////////////////////

// ***** SERVER SETTINGS *****//

//////////////////////////////////

// ***** Name

define("SERVER_NAME","%SERVERNAME%");

// ***** Started

// Defines when has server started.

define("COMMENCE","%STARTTIME%");

// ***** Language

// Choose your server language.

define("LANG","%LANG%");

// ***** Speed

// Choose your server speed. NOTICE: Higher speed, more likely

// to have some bugs. Lower speed, most likely no major bugs.

// Values: 1 (normal), 3 (3x speed) etc...

define("SPEED", "%SPEED%");

// ***** World size

// Defines world size. NOTICE: DO NOT EDIT!!

define("WORLD_MAX", "%MAX%");

// ***** Graphic Pack

// True = enabled, false = disabled

//!!!!!!!!!!!! DO NOT ENABLE !!!!!!!!!!!!

define("GP_ENABLE",false);

// Graphic pack location (default: gpack/travian_default/)

define("GP_LOCATE", "gpack/travian_default/");

// ***** Troop Speed

// Values: 1 (normal), 3 (3x speed) etc...

define("INCREASE_SPEED","%INCSPEED%");

// ***** Storage Multiplier

// Values: 1 (normal), 3 (3x speed) etc...

define("STORAGE_MULTIPLIER",%STORAGE_MULTIPLIER%);

define("STORAGE_BASE",800*STORAGE_MULTIPLIER);

// ***** Village Expand

// 1 = slow village expanding - more Cultural Points needed for every new village

// 0 = fast village expanding - less Cultural Points needed for every new village

define("CP", %VILLAGE_EXPAND%);

// ***** Demolish Level Required

// Defines which level of Main building is required to be able to

// demolish. Min value = 1, max value = 20

// Default: 10

define("DEMOLISH_LEVEL_REQ","%DEMOLISH%");

// ***** Quest

// Ingame quest enabled/disabled.

define("QUEST",%QUEST%);

// ***** Beginners Protection

// 3600 = 1 hour

// 3600*12 = 12 hours

// 3600*24 = 1 day

// 3600*24*3 = 3 days

// You can choose any value you want!

define("PROTECTION","%BEGINNER%");

// ***** Enable WW Statistics

define("WW",%WW%);

// ***** Activation Mail

// true = activation mail will be sent, users will have to finish registration

//        by clicking on link recieved in mail.

// false = users can register with any mail. Not needed to be real one.

define("AUTH_EMAIL",%ACTIVATE%);

// ***** PLUS

//Plus account lenght

define("PLUS_TIME",%PLUS_TIME%);

//+25% production lenght

define("PLUS_PRODUCTION",%PLUS_PRODUCTION%);

// ***** Great Workshop

define("GREAT_WKS",%GREAT_WKS%);

// ***** Tourn threshold

define("TS_THRESHOLD",%TS_THRESHOLD%);

//////////////////////////////////

//    **** LOG SETTINGS ****   //

//////////////////////////////////

// LOG BUILDING/UPGRADING

define("LOG_BUILD",%LOGBUILD%);

// LOG RESEARCHES

define("LOG_TECH",%LOGTECH%);

// LOG USER LOGIN (IP's)

define("LOG_LOGIN",%LOGLOGIN%);

// LOG GOLD

define("LOG_GOLD_FIN",%LOGGOLDFIN%);

// LOG ADMIN

define("LOG_ADMIN",%LOGADMIN%);

// LOG ATTACK REPORTS

define("LOG_WAR",%LOGWAR%);

// LOG MARKET REPORTS

define("LOG_MARKET",%LOGMARKET%);

// LOG ILLEGAL ACTIONS

define("LOG_ILLEGAL",%LOGILLEGAL%);

//////////////////////////////////

// **** NEWSBOX SETTINGS **** //

//////////////////////////////////

//true = enabled

//false = disabled

define("NEWSBOX1",%BOX1%);

define("NEWSBOX2",%BOX2%);

define("NEWSBOX3",%BOX3%);

//////////////////////////////////

//   **** SQL SETTINGS ****   //

//////////////////////////////////

// ***** SQL Hostname

// example. sql106.000space.com / localhost

// If you host server on own PC than this value is: localhost

// If you use online hosting, value must be written in host cpanel

define("SQL_SERVER", "%SSERVER%");

// ***** Database Username

define("SQL_USER", "%SUSER%");

// ***** Database Password

define("SQL_PASS", "%SPASS%");

// ***** Database Name

define("SQL_DB", "%SDB%");

// ***** Database - Table Prefix

define("TB_PREFIX", "%PREFIX%");

// ***** Database type

// 0 = MYSQL

// 1 = MYSQLi

// default: 1

define("DB_TYPE", %CONNECTT%);

////////////////////////////////////

//   **** EXTRA SETTINGS ****   //

////////////////////////////////////

// ***** Censore words

//define("WORD_CENSOR", "%ACTCEN%");

// ***** Words (censore)

// Choose which words do you want to be censored

//define("CENSORED","%CENWORDS%");

// ***** Limit Mailbox

// Limits mailbox to defined number of mails. (IGM's)

define("LIMIT_MAILBOX",%LIMIT_MAILBOX%);

// If enabled, define number of maximum mails.

define("MAX_MAIL","%MAX_MAILS%");

// ***** Include administrator in statistics/rank

define("INCLUDE_ADMIN", %ARANK%);

////////////////////////////////////

//   **** ADMIN SETTINGS ****   //

////////////////////////////////////

// ***** Admin Email

define("ADMIN_EMAIL", "%AEMAIL%");

// ***** Admin Name

define("ADMIN_NAME", "%ANAME%");

//////////////////////////////////////////

//   **** DO NOT EDIT SETTINGS ****   //

//////////////////////////////////////////

define("TRACK_USR","%UTRACK%");

define("USER_TIMEOUT","%UTOUT%");

define("ALLOW_BURST",false);

define("BASIC_MAX",1);

define("INNER_MAX",1);

define("PLUS_MAX",1);

define("ALLOW_ALL_TRIBE",false);

define("CFM_ADMIN_ACT",true);

define("SERVER_WEB_ROOT",false);

define("USRNM_SPECIAL",true);

define("USRNM_MIN_LENGTH",3);

define("PW_MIN_LENGTH",4);

define("BANNED",0);

define("AUTH",1);

define("USER",2);

define("MULTIHUNTER",8);

define("ADMIN",9);

define("COOKIE_EXPIRE", 60*60*24*7);

define("COOKIE_PATH", "/");

////////////////////////////////////////////

//   **** DOMAIN/SERVER SETTINGS ****   //

////////////////////////////////////////////

define("DOMAIN", "%DOMAIN%");

define("HOMEPAGE", "%HOMEPAGE%");

define("SERVER", "%DOMAIN%");

############################### E    N    D   ##################################

##              -= YOU MAY NOT REMOVE OR CHANGE THIS NOTICE =-                 ##

## --------------------------------------------------------------------------- ##

## Filename       config.php                                                  ##

## Version        4.8.5                                                       ##

## Developed by: Dzoki Edited by Advocaite                                   ##

## License:       TravianX Project                                            ##

## Copyright:     TravianX © 2010-2011. All rights reserved.                ##

##                                                                             ##

#################################################################################

?>

a na serwerze utworzył się plik a jego zawartość jest taka:

//////////////////////////////////

// ***** ERROR REPORTING *****//

//////////////////////////////////

// (E_ALL ^ E_NOTICE) = enabled

// (0) = disabled

error_reporting (E_ALL ^ E_NOTICE);

//////////////////////////////////

// ***** SERVER SETTINGS *****//

//////////////////////////////////

// ***** Name

define("SERVER_NAME","Adronia");

// ***** Started

// Defines when has server started.

define("COMMENCE","1441483872");

// ***** Language

// Choose your server language.

define("LANG","en");

Salur · 5 Września 2015

Ehh, skoro nie możesz znaleźć tamtego pliku zmień zawartość pliku database.php na:

(w konfiguracji wpisz swoje dane w tym pliku)

<?php
//////////////////////////////////////////////////////////////////////////////////////////////////////
// TRAVIANX //
// Only for advanced users, do not edit if you dont know what are you doing! //
// Made by: Dzoki & Dixie (TravianX) //
// - TravianX = Travian Clone Project - //
// DO NOT REMOVE COPYRIGHT NOTICE! //
//////////////////////////////////////////////////////////////////////////////////////////////////////

include("constant.php");

class MYSQLi_DB {
    
    var $connection;
    
    function MYSQLi_DB() {
        $this->connection = mysqli_connect(SQL_SERVER, SQL_USER, SQL_PASS, SQL_DB) or die(mysqli_error());
    }
        function query($query) {
        return $this->connection->query($query);
        }
        
};

#KONFIGURACJA#

$host = 'mysql.cba.pl';
$user = 'nazwa uzytkownika';
$pass = 'hasło';
$dbname= 'nazwa bazy';


class MYSQL_DB {
    
    var $connection;
    
    function MYSQL_DB() {
        $this->connection = mysql_connect($host, $user, $pass) or die(mysql_error());
        mysql_select_db($dbname, $this->connection) or die(mysql_error());
    }
    
    function mysql_exec_batch ($p_query, $p_transaction_safe = true) {
if ($p_transaction_safe) {
$p_query = 'START TRANSACTION;' . $p_query . '; COMMIT;';
};
$query_split = preg_split ("/[;]+/", $p_query);
foreach ($query_split as $command_line) {
$command_line = trim($command_line);
if ($command_line != '') {
$query_result = mysql_query($command_line);
if ($query_result == 0) {
break;
};
};
};
return $query_result;
}

    function query($query) {
        return mysql_query($query, $this->connection);
    }
};

if(DB_TYPE) {
    $database = new MYSQLi_DB;
}
else {
    $database = new MYSQL_DB;
}
?>

pekiniak · 5 Września 2015

Cóż nadal "4 litery" być może że coś jest nie tak, albo ja coś źle robię, bo teraz jest błąd

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '127.0.0.1' (111) in /virtual/lotnictwo.c0.pl/install/include/database.php on line 38
Can't connect to MySQL server on '127.0.0.1' (111)

Salur · 5 Września 2015

Czy w zmiennej masz cos takiego? $host = '127.0.0.1'; ??

pekiniak · 5 Września 2015

Czy w zmiennej masz cos takiego? $host = '127.0.0.1'; ??

nie skopiowałem to co wstawiłeś + moje dane do bazy

Salur · 5 Września 2015

Wstaw mi jeszcze kod pliku instalacyjnego, zobaczymy gdzie jest plik konfiguracyjny i gdzie to zapisuje.

pekiniak · 5 Września 2015

<?php

#################################################################################

##              -= YOU MAY NOT REMOVE OR CHANGE THIS NOTICE =-                 ##

## --------------------------------------------------------------------------- ##

## Filename       process.php                                                 ##

## License:       TravianX Project                                            ##

## Copyright:     TravianX © 2010-2011. All rights reserved.                ##

##                                                                             ##

#################################################################################

        if(file_exists("include/constant.php")) {

           include ("include/database.php");

        }

        class Process {

           function Process() {

               if(isset($_POST['subconst'])) {

                   $this->constForm();

               } else

                   if(isset($_POST['substruc'])) {

                       $this->createStruc();

                   } else

                       if(isset($_POST['subwdata'])) {

                           $this->createWdata();

                       } else

                           if(isset($_POST['subacc'])) {

                               $this->createAcc();

                               } else {

                                   header("Location: index.php");

                               }

           }

           function constForm() {

               $myFile = "include/constant.php";

               $fh = fopen($myFile, 'w') or die("<br/><br/><br/>Can't open file: install\include\constant.php");

               $text = file_get_contents("data/constant_format.tpl");

               $text = preg_replace("'%SERVERNAME%'", $_POST['servername'], $text);

               $text = preg_replace("'%LANG%'", $_POST['lang'], $text);

               $text = preg_replace("'%SPEED%'", $_POST['speed'], $text);

               $text = preg_replace("'%INCSPEED%'", $_POST['incspeed'], $text);

               $text = preg_replace("'%STORAGE_MULTIPLIER%'", $_POST['storage_multiplier'], $text);

               $text = preg_replace("'%UTRACK%'", $_POST['trackusers'], $text);

               $text = preg_replace("'%UTOUT%'", $_POST['timeout'], $text);

               $text = preg_replace("'%AUTOD%'", $_POST['autodel'], $text);

               $text = preg_replace("'%AUTODT%'", $_POST['autodeltime'], $text);

               $text = preg_replace("'%MAX%'", $_POST['wmax'], $text);

               $text = preg_replace("'%GP%'", $_POST['gpack'], $text);

               $text = preg_replace("'%SSERVER%'", $_POST['sserver'], $text);

               $text = preg_replace("'%SUSER%'", $_POST['suser'], $text);

               $text = preg_replace("'%SPASS%'", $_POST['spass'], $text);

               $text = preg_replace("'%SDB%'", $_POST['sdb'], $text);

               $text = preg_replace("'%PREFIX%'", $_POST['prefix'], $text);

               $text = preg_replace("'%CONNECTT%'", $_POST['connectt'], $text);

               $text = preg_replace("'%AEMAIL%'", $_POST['aemail'], $text);

               $text = preg_replace("'%ANAME%'", $_POST['aname'], $text);

               $text = preg_replace("'%SUBDOM%'", $_POST['subdom'], $text);

               $text = preg_replace("'%LOGBUILD%'", $_POST['log_build'], $text);

               $text = preg_replace("'%LOGTECH%'", $_POST['log_tech'], $text);

               $text = preg_replace("'%LOGLOGIN%'", $_POST['log_login'], $text);

               $text = preg_replace("'%LOGGOLDFIN%'", $_POST['log_gold_fin'], $text);

               $text = preg_replace("'%LOGADMIN%'", $_POST['log_admin'], $text);

               $text = preg_replace("'%LOGWAR%'", $_POST['log_war'], $text);

               $text = preg_replace("'%LOGMARKET%'", $_POST['log_market'], $text);

               $text = preg_replace("'%LOGILLEGAL%'", $_POST['log_illegal'], $text);

               $text = preg_replace("'%MINUSERLENGTH%'", $_POST['userlength'], $text);

               $text = preg_replace("'%MINPASSLENGTH%'", $_POST['passlength'], $text);

               $text = preg_replace("'%SPECIALCHARS%'", $_POST['specialchars'], $text);

               $text = preg_replace("'%ACTIVATE%'", $_POST['activate'], $text);

               $text = preg_replace("'%ARANK%'", $_POST['admin_rank'], $text);

               $text = preg_replace("'%QUEST%'", $_POST['quest'], $text);

               $text = preg_replace("'%BEGINNER%'", $_POST['beginner'], $text);

               $text = preg_replace("'%STARTTIME%'", time(), $text);

               $text = preg_replace("'%DOMAIN%'", $_POST['domain'], $text);

               $text = preg_replace("'%HOMEPAGE%'", $_POST['homepage'], $text);

               $text = preg_replace("'%LIMIT_MAILBOX%'", $_POST['limit_mailbox'], $text);

               $text = preg_replace("'%MAX_MAILS%'", $_POST['max_mails'], $text);

               $text = preg_replace("'%DEMOLISH%'", $_POST['demolish'], $text);

               $text = preg_replace("'%BOX1%'", $_POST['box1'], $text);

               $text = preg_replace("'%BOX2%'", $_POST['box2'], $text);

               $text = preg_replace("'%BOX3%'", $_POST['box3'], $text);

               $text = preg_replace("'%VILLAGE_EXPAND%'", $_POST['village_expand'], $text);

               $text = preg_replace("'%ERROR%'", $_POST['error'], $text);

               $text = preg_replace("'%GP_LOCATE%'", $_POST['gp_locate'], $text);

               $text = preg_replace("'%PLUS_TIME%'", $_POST['plus_time'], $text);

               $text = preg_replace("'%PLUS_PRODUCTION%'", $_POST['plus_production'], $text);

               $text = preg_replace("'%GREAT_WKS%'", $_POST['great_wks'], $text);

               $text = preg_replace("'%TS_THRESHOLD%'", $_POST['ts_threshold'], $text);

               $text = preg_replace("'%WW%'", $_POST['ww'], $text);

               fwrite($fh, $text);

               if(file_exists("include/constant.php")) {

                   header("Location: index.php?s=2");

               } else {

                   header("Location: index.php?s=1&c=1");

               }

               fclose($fh);

           }

           function createStruc() {

               global $database;

               $str = file_get_contents("data/sql.sql");

               $str = preg_replace("'%PREFIX%'", TB_PREFIX, $str);

               if(DB_TYPE) {

                   $result = $database->connection->multi_query($str);

               } else {

                   $result = $database->mysql_exec_batch($str);

               }

               if($result) {

                   header("Location: index.php?s=3");

               } else {

                   header("Location: index.php?s=2&c=1");

               }

           }

           function createWdata() {

               header("Location: include/wdata.php");

           }



        }

        ;

        $process = new Process;

?>

Chyba to

Salur · 5 Września 2015

Nie to nie to, żeby nie spamować napisz do mnie na PW.

pekiniak · 5 Września 2015

Problem Rozwiązany

Zaloguj się

👋 Witaj na MPCForum!

Problem z instalacja Travian

Rekomendowane odpowiedzi

pekiniak

pekiniak

Salur

Salur

pekiniak

pekiniak

Salur

Salur

pekiniak

pekiniak

Salur

Salur

pekiniak

pekiniak

Salur

Salur

pekiniak

pekiniak

Salur

Salur

pekiniak

pekiniak

Salur

Salur

pekiniak

pekiniak

Salur

Salur

pekiniak

pekiniak

Salur

Salur

pekiniak

pekiniak

Zarchiwizowany