adaptar un resource de server sql a server de windows

david_mikito · September 12, 2012

hola buenas a todos , pues lo que pone en el titulo , e descargado el gamemode mta paradise y no soy capaz de ponerlos en el server normal para windows no el sql , necesito ayuda , si me pudieseis dar información o algun tutorial os estaria agradecido eternamente , jeje muchas gracias de antemano , un saludo

BorderLine · September 12, 2012

quieres pasar para que no guarde en myqlo y lo guarde en sqlite?

Castillo · September 12, 2012

SQL es una base de datos nada mas, el MTA Paradise usa MySQL para guardar todo ( cuentas, personajes, etc, etc... ).

david_mikito · September 12, 2012

muchas gracias por responder , jejeje os explico , yo por ejemplo cojo un resource y no meto en donde se ponen los resources en el mta , y al ejecutar la consola del server me da error al ejecutar el resource , jeje si sabéis de algun tutorial o algo para hacer esa base de datos o para que los resources y tal funcionen bien os lo agradecería muchiisiiimo jejeje , estoy empezando ahora en la programación lua y tal así que no se mucho jejeje . Un saludo y muchas gracias jeje

Posdata : tambien deciros que cuando abro un archivo de algun resource , no aparece como siempre , que esta escrito por columnas y tal , estos no estos estan escritos como si fueran un texto normal , cuando pueda os pongo unas fotos jeje .

david_mikito · September 20, 2012

haber si me podeis ayudar , porfa

Renkon · September 20, 2012

Tienes que cambiar la configuración del servidor MySQL para iniciar.

david_mikito · September 20, 2012

gracias por responder jeje si me dijeras como se hace mas o menos o algún tutorial te lo agradecería muchiiisiimo jejeje un saludo

Renkon · September 20, 2012

Pues necesitas saber el host, el nombre de la base, el usuario y la contraseña.

Arsilex · September 20, 2012

los scripts / resource del paradise estan todos configurados con el sql si el sql no se conecto con un mysql no funciona un script .

Primero necesitas un mysql segundo necesitas configurar el sql/mysql.lua y settings.xml que estan donde el mtaserver.conf

cuando tengas eso te ira.

david_mikito · September 20, 2012

muchas gracias por responder jeje , bueno el settings.xml ya esta configurado pero el archivo sql/mysql.lua no lo encuentro , no se donde podra estar

Arsilex · September 20, 2012

ya te lo eh dixo esta en resource/sql/mysql.lua

david_mikito · September 20, 2012

ok jeje lo único que me queda por preguntar es q si la informacion del sql la ponfo donde estan las frases esas que son asi local server = get( "server" ) or "localhost" no?

Arsilex · September 20, 2012

Tienes que editar esto en el sql/mysql.lua

  
    local server = get( "server" ) or "HOSTDELMYSQL" 
    local user = get( "user" ) or "USERDEMYSQL" 
    local password = get( "password" ) or "PASSDEMYSQL" 
    local db = get( "database" ) or "BASEDEDATOSMYSQL" 
  
  
--Esto lo dejas como esta.! 
    local port = get( "port" ) or 3306 
    local socket = get( "socket" ) or nil

david_mikito · September 20, 2012

eres mi salvador jajaja ahora estoy haber si soy capaz de hacer una base de datos mysql jejeje

Arsilex · September 20, 2012

olle tu eres uno de los de el servidor de mikito el de bayside rp?

david_mikito · September 20, 2012

no jaja si lo conozco pero es una mierda de server estan namas que con las carreras todo el rato ya apenas hay rol

david_mikito · October 19, 2012

hola buenas , ya tengo la base de datos y tal , pero la consola del server me da errores y se cierra , si podéis explicarme mas o menos como se instala el gamemode por que no soy capaz de instalarlo bien jejeje .

Un saludo , gracias de antemano.

Renkon · October 19, 2012

Podrías mostrar los errores?

david_mikito · October 19, 2012

ok mira te pongo lo que me sale jeje intentare ponerte todo jeje:7

==================================================================

= Multi Theft Auto: San Andreas v1.3.1

==================================================================

= Server name : paradise ~ Roleplay

= Server IP address:

= Server port : 22003

=

= Log file : ...3.0/server/mods/deathmatch/logs/server.log

= Maximum players : 32

= HTTP port : 22005

= Voice Chat : Disabled

= Bandwidth saving : Medium

==================================================================

[2012-10-19 18:34:39] File 'settings.xml' not present, creating new node.

[2012-10-19 18:34:47] ERROR: Not processing resource 'admin' as it has duplicates on different paths:

Path #1: "resources\admin"

Path #2: "resources\[admin]\admin"

[2012-10-19 18:34:47] ERROR: Problem with resource: editor;

[2012-10-19 18:34:47] ERROR: Problem with resource: editor_main; Failed to link to freecam

[2012-10-19 18:34:47] ERROR: Not processing resource 'freecam' as it has duplicates on different paths:

Path #1: "resources\freecam"

Path #2: "resources\[editor]\freecam"

[2012-10-19 18:34:47] ERROR: Not processing resource 'interiors' as it has duplicates on different paths:

Path #1: "resources\interiors"

Path #2: "resources\[gameplay]\interiors"

[2012-10-19 18:34:47] ERROR: Problem with resource: job-carrier; Failed to link to interiors

[2012-10-19 18:34:47] ERROR: Not processing resource 'runcode' as it has duplicates on different paths:

Path #1: "resources\runcode"

Path #2: "resources\[admin]\runcode"

[2012-10-19 18:34:47] Resources: 207 loaded, 3 failed

[2012-10-19 18:34:47] Querying game-monitor.com master server... failed! (302: Moved temporarily)

[2012-10-19 18:34:48] Querying backup master server... success!

[2012-10-19 18:34:49] MODULE: Unable to find modules/mta_mysql.dll!

[2012-10-19 18:34:49] MODULE: Loaded "SHA Module" (1.02) by "mabako"

[2012-10-19 18:34:49] Starting resources.....

[2012-10-19 18:34:49] Server shutdown as requested by resource sql (MySQL module missing.)

[2012-10-19 18:34:49] Start up of resource sql cancelled by script

[2012-10-19 18:34:49] ERROR: Unable to start resource sql; Start up of resource cancelled by script

[2012-10-19 18:34:49] Start up of resource irc cancelled by script

[2012-10-19 18:34:49] ERROR: Unable to start resource irc; Start up of resource cancelled by script

[2012-10-19 18:34:52] WARNING: players/main.lua(Line 379) [server] setPedFrozen is deprecated and may not work in future versions. Please replace with setElementFrozen before Tuesday.

[2012-10-19 18:34:52] Some files in 'players' use deprecated functions.

[2012-10-19 18:34:52] Use the 'upgrade' command to perform a basic upgrade of resources.

[2012-10-19 18:34:52] Server shutdown as requested by resource sql (MySQL module missing.)

[2012-10-19 18:34:52] Start up of resource sql cancelled by script

[2012-10-19 18:34:52] ERROR: exports: Call to non-running server resource (sql) [string "?"]

[2012-10-19 18:34:52] Start up of resource players cancelled by script

[2012-10-19 18:34:52] ERROR: Unable to start resource players; Start up of resource cancelled by script

[2012-10-19 18:34:53] Server shutdown as requested by resource sql (MySQL module missing.)

[2012-10-19 18:34:53] Start up of resource sql cancelled by script

[2012-10-19 18:34:53] ERROR: exports: Call to non-running server resource (sql) [string "?"]

[2012-10-19 18:34:53] Start up of resource vehicles cancelled by script

[2012-10-19 18:34:53] ERROR: Unable to start resource vehicles; Start up of resource cancelled by script

[2012-10-19 18:34:53] ERROR: Couldn't find resource interiors. Check it exists.

[2012-10-19 18:34:53] Server shutdown as requested by resource sql (MySQL module missing.)

[2012-10-19 18:34:53] Start up of resource sql cancelled by script

[2012-10-19 18:34:54] Server shutdown as requested by resource sql (MySQL module missing.)

[2012-10-19 18:34:54] Start up of resource sql cancelled by script

[2012-10-19 18:34:54] ERROR: exports: Call to non-running server resource (sql) [string "?"]

[2012-10-19 18:34:54] Start up of resource players cancelled by script

[2012-10-19 18:34:54] Server shutdown as requested by resource sql (MySQL module missing.)

[2012-10-19 18:34:54] Start up of resource sql cancelled by script

[2012-10-19 18:34:54] ERROR: exports: Call to non-running server resource (sql) [string "?"]

[2012-10-19 18:34:54] Start up of resource items cancelled by script

[2012-10-19 18:34:54] ERROR: Unable to start resource items; Start up of resource cancelled by script

[2012-10-19 18:34:54] Server shutdown as requested by resource sql (MySQL module missing.)

[2012-10-19 18:34:54] Start up of resource sql cancelled by script

[2012-10-19 18:34:54] ERROR: exports: Call to non-running server resource (sql) [string "?"]

[2012-10-19 18:34:54] Start up of resource players cancelled by script

[2012-10-19 18:34:54] Server shutdown as requested by resource sql (MySQL module missing.)

[2012-10-19 18:34:54] Start up of resource sql cancelled by script

[2012-10-19 18:34:54] ERROR: exports: Call to non-running server resource (sql) [string "?"]

[2012-10-19 18:34:54] Start up of resource vehicles cancelled by script

[2012-10-19 18:34:54] Server shutdown as requested by resource sql (MySQL module missing.)

[2012-10-19 18:34:54] Start up of resource sql cancelled by script

[2012-10-19 18:34:55] Server shutdown as requested by resource sql (MySQL module missing.)

[2012-10-19 18:34:55] Start up of resource sql cancelled by script

[2012-10-19 18:34:55] ERROR: exports: Call to non-running server resource (sql) [string "?"]

[2012-10-19 18:34:55] Start up of resource players cancelled by script

[2012-10-19 18:34:55] Server shutdown as requested by resource sql (MySQL module missing.)

[2012-10-19 18:34:55] Start up of resource sql cancelled by script

[2012-10-19 18:34:55] ERROR: exports: Call to non-running server resource (sql) [string "?"]

[2012-10-19 18:34:55] Start up of resource items cancelled by script

[2012-10-19 18:34:55] Server shutdown as requested by resource sql (MySQL module missing.)

[2012-10-19 18:34:55] Start up of resource sql cancelled by script

[2012-10-19 18:34:55] ERROR: exports: Call to non-running server resource (sql) [string "?"]

[2012-10-19 18:34:55] Start up of resource players cancelled by script

[2012-10-19 18:34:55] ERROR: Couldn't find resource admin. Check it exists.

[2012-10-19 18:34:55] WARNING: shops/shop.lua(Line 57) [server] setPedFrozen is deprecated and may not work in future versions. Please replace with setElementFrozen before Tuesday.

[2012-10-19 18:34:55] Some files in 'shops' use deprecated functions.

[2012-10-19 18:34:55] Use the 'upgrade' command to perform a basic upgrade of resources.