TMoore 217 Posted February 9, 2015 (edited) Para quem não quer/não consegue utilizar apenas a sql como base de dados para item e mob proto, deixo abaixo uma solução: O que faz? Acede à base de dados (podem verificar o script, não há acesso externo, por isso podem e devem utilizar a conta localhost para tal), lê o item e mob proto, converte-os para txt e guarda os txt no mesmo directório. Executar o seguinte comando na máquina: cd /usr/ports/databases/py-MySQLdb/ && make install clean Editar esta linha no final dos ficheiros, com o vosso utilizador, password e tabela da base de dados, como por exemplo: Modificar o que está a azul. db = MySQLdb.connect(host="localhost", user="utilizador", passwd="password", db="player") Colocar os ficheiros na vossa pasta db/conf (onde quer que tenham os txt) Correr os ficheiros utilizando a seguinte estrutura: cd /sitio/dos/txt && python item.py cd /sitio/dos/txt && python mob.py Download ficheiros: Item.py Mob.py Mirror: Item.py Mob.py Mirror 2: Item.py Mob.py Scan: Scan item.py Scan mob.py Nota: É necessário a máquina ter acesso à internet para poder instalar o MySQLdb para python. Edited February 9, 2015 by TMoore (see edit history) 5 ⚜️ Glossy ⚜️, RebooTz, Tyler Durden and 2 others reacted to this Share this post Link to post Share on other sites
⚜️ Glossy ⚜️ 672 Posted February 9, 2015 Não vou usar, mas obrigado por contribuir para a comunidade. :) Share this post Link to post Share on other sites
Tyler Durden 556 Posted February 9, 2015 ===> Found saved configuration for py27-MySQLdb-1.2.3_2=> MySQL-python-1.2.3.tar.gz doesn't seem to exist in /usr/ports/distfiles/.=> Attempting to fetch http://heanet.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://heanet.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://sunet.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://sunet.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://iweb.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://iweb.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://switch.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://switch.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://freefr.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://freefr.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://garr.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://garr.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://aarnet.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://aarnet.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://jaist.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://jaist.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://master.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://master.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://nchc.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://nchc.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://ncu.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://ncu.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://internode.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://internode.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://waix.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://waix.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://hivelocity.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://hivelocity.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://superb-dca3.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://superb-dca3.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://ufpr.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://ufpr.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://tenet.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://tenet.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://netcologne.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://netcologne.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://ignum.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://ignum.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://kent.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://kent.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch http://kaz.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gzfetch: http://kaz.dl.sourceforge.net/project/mysql-python/mysql-python/1.2.3/MySQL-python-1.2.3.tar.gz: No address record=> Attempting to fetch ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/MySQL-python-1.2.3.tar.gzfetch: ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/MySQL-python-1.2.3.tar.gz: No address record=> Couldn't fetch it - please try to retrieve this=> port manually into /usr/ports/distfiles/ and try again.*** [do-fetch] Error code 1Stop in /usr/ports/databases/py-MySQLdb.*** [install] Error code 1Stop in /usr/ports/databases/py-MySQLdb. Share this post Link to post Share on other sites
TMoore 217 Posted February 9, 2015 (edited) De notar, a maquina tem de ter acesso externo à internet para poder fazer download do módulo para o python, ou seja, para este comando: cd /usr/ports/databases/py-MySQLdb/ && make install clean Caso já tenha acesso à internet, mas não consigam instalar, façam isto: portsnap fetch extract update cd /usr/ports/databases/py-MySQLdb/ && make install clean Edited February 9, 2015 by TMoore (see edit history) Share this post Link to post Share on other sites
Tyler Durden 556 Posted February 9, 2015 Nada melhor do que extrair à mão.edit: db = MySQLdb.connect ( host="localhost", user="root", passwd="maxmi33", db="player" )Badly placed ()'s.Tá tudo bem? Share this post Link to post Share on other sites
anonomussilva147 0 Posted February 9, 2015 Boas uso as files VANILLA project rev54250 . sempre que vou muda transmutação dou reboot continua mesma coisa esse metodo ai pode mim ajudar Share this post Link to post Share on other sites
TMoore 217 Posted February 9, 2015 Nada melhor do que extrair à mão.edit: db = MySQLdb.connect ( host="localhost", user="root", passwd="maxmi33", db="player" )Badly placed ()'s.Tá tudo bem? tira o primeiro espaço do host, e ultimo espaço, ficando assim: db = MySQLdb.connect(host="localhost", user="root", passwd="maxmi33", db="player") Se as files tiverem a utilizar o txt então sim irá ajudar. Share this post Link to post Share on other sites
Tyler Durden 556 Posted February 9, 2015 tira o primeiro espaço do host, e ultimo espaço, ficando assim: db = MySQLdb.connect(host="localhost", user="root", passwd="maxmi33", db="player") Se as files tiverem a utilizar o txt então sim irá ajudar. Eu já fiz isso, mas continua a dar esse erro Badly placed ()'s. De qlq forma não importa, não te chates mais. :like: Share this post Link to post Share on other sites
TMoore 217 Posted February 9, 2015 Realmente é estranho, tentei agora de novo, e só mudando o utilizador e pass dá logo: Se quiseres eu posso ajudar-te por team, algo deve estar errado o.o Share this post Link to post Share on other sites
RuiRock 12 Posted February 9, 2015 deu-me esta mensagem : python: command not found. fiz o portsnap fetch extract update, fiz o cd /usr/ports/databases/py-MySQLdb/ && make install clean ,modifiquei o utilizador e a pass dentro desses ficheiros e meti-os onde estão localizados os meus txt. depois fui a esse diretório, meti python item.py e tambem com o bom.py e apareceu-me esse erro :S podes ajudar por favor? Share this post Link to post Share on other sites
TMoore 217 Posted February 9, 2015 É porque não tens o python instalado. cd /usr/ports/lang/python27 && make -DBATCH install clean Share this post Link to post Share on other sites
RuiRock 12 Posted February 9, 2015 ===> Checking if python27 already installed ===> python27-2.7.9 is already installed You may wish to ``make deinstall'' and install this port again by ``make reinstall'' to upgrade it properly. If you really wish to overwrite the old port of python27 without deleting it first, set the variable "FORCE_PKG_REGISTER" in your environment or the "make install" command line. *** [check-already-installed] Error code 1 Stop in /usr/ports/lang/python27. já o tenho instalado, contudo continua sem me funcionar infelizmente. Share this post Link to post Share on other sites
TMoore 217 Posted February 9, 2015 Não ficou bem instalado, experimenta fazer reinstall. Caso não funcione: pkg remove python pkg clean pkg install python 1 Shad0w reacted to this Share this post Link to post Share on other sites
Shad0w 347 Posted February 9, 2015 Não ficou bem instalado, experimenta fazer reinstall. Caso não funcione: pkg remove python pkg clean pkg install python Penso que não te vale apena fazer reinstall, da ultima vez que me aconteceu isso foi mesmo do fazendo unistall e depois voltei a fazer install... Ou seja é um reinstall manual D: Share this post Link to post Share on other sites
RuiRock 12 Posted February 11, 2015 TMoore, consegui fazer como tu disseste e criou os documentos txt sem problema contudo quando tento iniciar o servidor aparece sempre a mensagem connection refused. tenho nas config TXT_STARTUP = 1 será que tu ou alguem me poderia ajudar? :S Share this post Link to post Share on other sites