Jump to content
  • 0

Unknown Error with resource. What's now?


Delejt

Question

Hello!

I have next problem. I start MTA-Server, and have some errors:

=========================================================== 
= Multi Theft Auto: San Andreas v1.3 
=========================================================== 
= Server name      : Default MTA Server 
= Server IP address: 127.0.0.1 
= Server port      : 22003 
=  
= Log file         : .. 1.3/server/mods/deathmatch/logs/server.log 
= Maximum players  : 32 
= HTTP port        : 22005 
= Voice Chat       : Disabled 
=========================================================== 
[2012-01-31 22:28:48] ERROR: Problem with resource: phoenix_Base;  
[2012-01-31 22:28:48] ERROR: Problem with resource: phoenix_Cops;  
[2012-01-31 22:28:48] ERROR: Problem with resource: phoenix_Groups;  
[2012-01-31 22:28:48] ERROR: Problem with resource: sprayTagging; Failed to link to sprayTags 
[2012-01-31 22:28:48] Resources: 33 loaded, 4 failed 
[2012-01-31 22:28:48] Querying game-monitor.com master server... failed! (Not available) 
[2012-01-31 22:28:48] Querying backup master server... failed! (Not available) 
[2012-01-31 22:28:48] MODULE: Loaded "MySQL 5.0 database module" (0.50) by "Alberto Alonso <[email protected]>" 
[2012-01-31 22:28:48] Starting resources... 
[2012-01-31 22:28:48] Server started and is ready to accept connections! 
[2012-01-31 22:28:48] Type 'help' for a list of commands. 
[2012-01-31 22:28:58] start: Requested by Console 
[2012-01-31 22:28:58] start: Resource is loaded, but has errors () 

Link to comment

22 answers to this question

Recommended Posts

  • 0

Of course, it's meta.xml of phoenix_Base.

<meta> 
  
        <info author="eRP-Gaming" version="0.3" type="gamemode" name="Phoenix" description="Phoenix Base system." /> 
        <settings> 
                <setting name="#MYSQL_HOST" value="localhost" /> 
                <setting name="#MYSQL_PASS" value="pass" /> 
                <setting name="#MYSQL_USER" value="root" /> 
                <setting name="#MYSQL_DB" value="erp" /> 
                <setting name="#VERSION" value="0.3" /> 
                <setting name="#REVISION" value="231" /> 
                <setting name="#MotdTime" value="60000" />  
        </settings> 
  
        <script src="Authenticate_Class.lua" type="server" /> 
        <script src="base-server.lua" type="server" /> 
        <script src="base-client.lua" type="client" /> 
        <script src="motd.lua" type="server" /> 
        <script src="motd_c.lua" type="client" /> 
        <script src="settings.lua" type="client" /> 
        <script src="combobox_rep.lua" type="client" /> 
  
        <export function="MysqlUpdatebuild" type="server" /> 
        <export function="MysqlSetField" type="server" /> 
        <export function="UpdateFinish" type="server" /> 
        <export function="DoUpdateFinish" type="server" /> 
        <export function="DoSimpleQuery" type="server" /> 
        <export function="SelectQuery" type="server" /> 
        <export function="PayDayIncome" type="server" /> 
        <export function="PayDayTax" type="server" /> 
        <export function="AddMotdString" type="server" /> 
         
        <include resource="cookies" /> 
        <include resource="pmenu" /> 
        <include resource="poffer" /> 
         
        <include resource="phoenix_ServerTab" /> 
        <include resource="phoenix_Estonia" /> 
        <include resource="phoenix_Vehicles" /> 
        <include resource="phoenix_Characters" /> 
        <include resource="phoenix_Chat" /> 
        <include resource="phoenix_Skills" /> 
        <include resource="phoenix_SpawnManager" /> 
        <include resource="phoenix_Infospots" /> 
        <include resource="phoenix_Phone" /> 
        <include resource="phoenix_Pockets" /> 
        <include resource="phoenix_DropItems" /> 
        <include resource="phoenix_Jobs" /> 
        <include resource="phoenix_Housing" /> 
        <include resource="phoenix_Business" /> 
        <include resource="phoenix_Groups" /> 
         
        <include resource="phoenix_CityHall" />  
        <include resource="phoenix_Cops" /> 
         
        <include resource="rpg_vehicle_lights" /> 
         
        <include resource="tutomanager" /> 
  
        <config src="help.xml" type="client"/> 
  
        <!-- Files --> 
  
        <file src="files/images/logo.png" /> 
        <file src="images/dropdown.png" /> 
  
</meta> 

Link to comment
  • 0

thanks, so the script connects to the MySQL, and the downloaded file called phoenix.sql, was uploaded to your mysql server.

If it was, then the maybe you have to create a script to connect to the MySQL Server which is located either on the web or on a MySQL software located on your computer.

Link to comment
  • 0

I have next problems, i join to server, and can't register, because is only login, how i can create account?

In database is only ph_characters with pool - id, userid, name, money, etc. Where is nick und password?

EDIT:

What's sqlId?

function GetUserCharactersAsTable( sqlId ) 
  
    local query = "SELECT id, name, sex, age, model FROM ph_characters WHERE userid = '" .. sqlId .. "'"; 
    local result = exports.phoenix_Base:SelectQuery( query ); 
     
    local tabel = { }; 
     
    if( result ) then 
     
        local i = 1; 
         
        for k, v in ipairs( result ) do 
                     
            tabel[i] = { }; 
            tabel[i]["id"] = v["id"]; 
            tabel[i]["name"] = v["name"]; 
            tabel[i]["sex"] = v["sex"]; 
            tabel[i]["age"] = v["age"]; 
            tabel[i]["model"] = v["model"]; 
            i = i+1; 
             
        end 
         
    end 
  
    return tabel; 
  
end 

Link to comment
  • 0
I have next problems, i join to server, and can't register, because is only login, how i can create account?

In database is only ph_characters with pool - id, userid, name, money, etc. Where is nick und password?

What was the server name

EDIT:

What's sqlId?

function GetUserCharactersAsTable( sqlId ) 
  
    local query = "SELECT id, name, sex, age, model FROM ph_characters WHERE userid = '" .. sqlId .. "'"; 
    local result = exports.phoenix_Base:SelectQuery( query ); 
     
    local tabel = { }; 
     
    if( result ) then 
     
        local i = 1; 
         
        for k, v in ipairs( result ) do 
                     
            tabel[i] = { }; 
            tabel[i]["id"] = v["id"]; 
            tabel[i]["name"] = v["name"]; 
            tabel[i]["sex"] = v["sex"]; 
            tabel[i]["age"] = v["age"]; 
            tabel[i]["model"] = v["model"]; 
            i = i+1; 
             
        end 
         
    end 
  
    return tabel; 
  
end 

I'mtry using the basic functions for the mta-mysql MTA-MySQL

Link to comment
  • 0

Okay, I came to this, from userid gets, this is another problem when I try to log data from vBulletin for userid 1 [figures are already in the database under this userid] in the console, there is this warning:

[2012-02-01 14:52] WARNING: phoenix_Base\Authenticate_Class.lua:160: Access denied @ 'callRemote' 

And nothing in the game happens.

Here, line 160:

  
callRemote ( get( "#AUTH_SERVER" ) .. "/" .. get( "#AUTH_FILE" ),  

A cała funkcja wygląda tak:

function Authenticate:DoAuth( ) 
  
    theSelf = self; 
     
    callRemote ( get( "#AUTH_SERVER" ) .. "/" .. get( "#AUTH_FILE" ),  
        function ( ... ) 
         
            theSelf:OnAuthResult( ... ); 
         
        end 
    , self.User, self.Pass ); 
  
end 

I found - user and password is export from vbulletin users, but i haven't ph_auth.php.

Are you want to edit this resource to check users and passwords from users - vbulletin? Because i don't have ph_auth.php on localhost [xampp].

This is equivalent #AUTH_SERVER and #AUTH_FILE

meta.xml of phoenix_Base:

  
        <setting name="#AUTH_SERVER" value="http://localhost" /> 
        <setting name="#AUTH_FILE" value="ph_auth.php" /> 
  

Can you help me?

PS. Sorry for my bad english.

Link to comment

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
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...