Unknown Error with resource. What's now?

Delejt · January 31, 2012

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 ()

Jaysds1 · January 31, 2012

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

Delejt · January 31, 2012

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.

Jaysds1 · January 31, 2012

Do they connect to the MySQL?

Delejt · January 31, 2012

Yes.

Jaysds1 · January 31, 2012

Can you post the script for connecting to the MySQL?

Delejt · January 31, 2012

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>

Jaysds1 · January 31, 2012

Did you downloaded this from the community?

Delejt · January 31, 2012

No, from code.google.com

Jaysds1 · January 31, 2012

Can you give me the link please?

Delejt · January 31, 2012

Sent to your PM.

Jaysds1 · January 31, 2012

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.

Delejt · January 31, 2012

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

Delejt · January 31, 2012

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

Jaysds1 · February 1, 2012

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

Delejt · February 1, 2012

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.

Jaysds1 · February 1, 2012

is it on your site?

Delejt · February 1, 2012

I haven't file 'ph_auth.php'. What i can do now?

Jaysds1 · February 1, 2012

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.

Delejt · February 1, 2012

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

Jaysds1 · February 1, 2012

Do you have php knowledge?

Delejt · February 1, 2012

Unfortunately not.

Jaysds1 · February 1, 2012

probably, u could make someone create a auth.php file for you

Unknown Error with resource. What's now?

Question

Link to comment

22 answers to this question

Recommended Posts

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Create an account or sign in to comment

Create an account

Sign in

Recently Browsing 0 members