Sign in to follow this  
Delejt

Unknown Error with resource. What's now?

Recommended Posts

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 <rydencillo@gmail.com>" 
[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 () 

Share this post


Link to post

Do you know what's in these scripts or what they have in them that makes them all common in each other?

Share this post


Link to post

Yes, i know it's some resources of gamemode, but some phoenix_XXX is good, and phoenix_Base, phoenix_Cops, phoenix_Gropus have errors.

I know must create sprayTags, but phoenix_Base etc, will be.

Share this post


Link to post

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> 

Share this post


Link to post

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.

Share this post


Link to post

I have xampp, and base mySQL with this structure, connect informations add to meta.xml of phoenix_Base.

Share this post


Link to post

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 

Share this post


Link to post
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

Share this post


Link to post

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.

Share this post


Link to post

Why do you need the MTA-MySQL?

If your putting peoples username and passwords on a mysql, i suggest you put it on a site else leave it on the server.

Share this post


Link to post

Look, people register on vBulletin forum, next log in to server nick and password from forum, but ph_auth.php must authorized their password and nick from forum. And i haven't php_auth.php

Share this post


Link to post

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
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.