Strona 2 z 4
: 09 lipca 2011, 19:40
autor: DaVidoSS
Cześć .
Dzięki wielkie za pomoc, jednakże nie do końca wiem co ma jak być zmienione.
Skrypt kf_users.sh zadziałał prawidłowo. Utworzył tabele w bazie danych.
Po ponownym jego uruchomieniu za pierwszym razem nic sie nie wydarzyło,
żadnych zmian w bazie danych.
Za drugim razem pokazało się:
Kod: Zaznacz cały
davidoss@jned:/usr/local/games/steam_servers/kfserver/log$ sh kf_users.sh
id int(10) NO NULL
player char(40) NO NULL
connections int(11) NO NULL
davidoss@jned:/usr/local/games/steam_servers/kfserver/log$ ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
/bin/bash: line 62: nieoczekiwany EOF podczas poszukiwania pasującego ``'
/bin/bash: line 121: błąd składni: nieoczekiwany koniec pliku
: 10 lipca 2011, 11:47
autor: Bastian
Zmieniałeś w skrypcie /bin/bash na /bin/sh może?
: 10 lipca 2011, 12:29
autor: DaVidoSS
Nie nie zmieniałam nic oprócz tych zmiennych.
Jeśli wykonuję plik w ten sposób:
Nic się nie dzieje i konsola nic nie zwraca.
Baza danych pozostaje pusta.
Jesli użyję sh:
Pojawiają się błędy jak wyżej.
Kod: Zaznacz cały
#!/bin/bash
USER="xxxxxx"
HASLO="zzzzzzzz";
HOST="localhost";
BAZA="yyyyyyyy";
TABELA="players";
KF_LOG="server_kfbasic.log";
TEMP="tmp.log"; #to tymczasowy plik nazwijmy "wymiany", zostaw tak jak jest
mysql -u ${USER} -h ${HOST} --password=${HASLO} ${BAZA} -Bse "DESCRIBE ${TABELA}" &> /dev/null
if [ $? -eq 0 ]; then
mysql -u ${USER} -h ${HOST} --password=${HASLO} ${BAZA} -Bse "SELECT * FROM ${TABELA}" > ${TEMP}
awk -f kf_users.awk ${TEMP} ${KF_LOG} &> /dev/null
rm ${TEMP}
else
echo "tabela nieistnieje. Tworze...";
mysql -u ${USER} -h ${HOST} --password=${HASLO} ${BAZA} -Bse "CREATE TABLE ${TABELA} (id INT(10) NOT NULL, player CHAR(40) NOT NULL, connections INT(11) NOT NULL) "
if [ $? -eq 0 ]; then
echo "Tabela utworzona. Prosze wywołać skrypt raz jeszcze"
else
echo "Nie udalo się utworzyć tabeli. Sprawdź konfigurację, i spróbuj raz jeszcze"
fi
fi
Kod: Zaznacz cały
$1 ~ /^[[:digit:]]/ {
connb[$2]= $3; nickb[$2]=$2;}
$1 ~ /ScriptLog:/ {
if (start) {
znalazl=0;
{for (x in conn) {
if ( x == $4) {
znalazl=1;
conn[x]++; break
}
}}
{if (znalazl == 0) {
conn[$4]= 1; id[$4]= substr($5, 4); nick[$4]=$4;}}
} else {
start=1;
conn[$4] = 1; id[$4]= substr($5, 4); nick[$4]=$4
}}
END {
tabela="players"; //config
for (l in conn) {
if (!nickb[l]) {
insert_tb="INSERT INTO "tabela "(id, player, connections) VALUES (\'"id[l]"\', \'"nick[l]"\', \'"conn[l]"\')"
print "mysql -u xxxxxxx -h localhost --password=zzzzzzzzzzzzzz yyyyyyyy -Bse \""insert_tb"\"" | "/bin/bash"
} else {
if (conn[l] > connb[l]) {
update_tb= "UPDATE "tabela" SET connections="conn[l]" WHERE player='"nick[l]"'"
print "mysql -u xxxxxxx -h localhost --password=zzzzzzzzzzzzz yyyyyyyy -Bse \""update_tb"\"" | "/bin/bash"
}
}
}
}
Kod: Zaznacz cały
$grep 'New Player' server_kfbasic.log
ScriptLog: New Player Basjuh_[NL] id=50855474
ScriptLog: New Player Radix id=28161660
ScriptLog: New Player Basjuh_[NL] id=50855474
ScriptLog: New Player Pr�zli id=37637159
ScriptLog: New Player Kowalski id=19336113
ScriptLog: New Player Veddharta id=34088043
ScriptLog: New Player xeYon id=3186985
ScriptLog: New Player [POT]Thumass id=82879758
ScriptLog: New Player Bombar_Bertil id=56030957
ScriptLog: New Player Fonck_IV id=47167199
ScriptLog: New Player Nexebtion id=38243244
ScriptLog: New Player Skipper id=11945012
ScriptLog: New Player Veddharta id=34088043
ScriptLog: New Player Veddharta id=34088043
ScriptLog: New Player Deimos[LM] id=48507270
ScriptLog: New Player Curion id=78186128
ScriptLog: New Player knacki id=84196950
ScriptLog: New Player Baerium id=19736571
ScriptLog: New Player Knasty id=69994062
ScriptLog: New Player (£***£)THEFOURBE(� id=63486323
ScriptLog: New Player Kert�sz_Karcsi id=6658871
ScriptLog: New Player Kert�sz_Karcsi id=6658871
ScriptLog: New Player Knasty id=69994062
ScriptLog: New Player Pipi_Vagina id=52883381
ScriptLog: New Player Skille[R] id=65541871
ScriptLog: New Player RìP_I_Painhead_Skil id=51821338
ScriptLog: New Player Pipi_Vagina id=52883381
ScriptLog: New Player Skille[R] id=65541871
ScriptLog: New Player Kert�sz_Karcsi id=6658871
ScriptLog: New Player RìP_I_Painhead_Skil id=51821338
ScriptLog: New Player =[Mark93Special]= id=51077798
ScriptLog: New Player Knasty id=69994062
ScriptLog: New Player Flopy55 id=82658098
ScriptLog: New Player guadanya id=45657282
ScriptLog: New Player Kert�sz_Karcsi id=6658871
ScriptLog: New Player =[Mark93Special]= id=51077798
ScriptLog: New Player Knasty id=69994062
ScriptLog: New Player Whitle id=74778654
ScriptLog: New Player m4Rn1tSCH id=21646615
ScriptLog: New Player Whitle id=74778654
ScriptLog: New Player NeMy' id=50421198
ScriptLog: New Player Kert�sz_Karcsi id=6658871
ScriptLog: New Player =[Mark93Special]= id=51077798
ScriptLog: New Player Whitle id=74778654
ScriptLog: New Player NeMy' id=50421198
ScriptLog: New Player düsbert id=79323722
ScriptLog: New Player (£***£)THEFOURBE(� id=63486323
ScriptLog: New Player BakedAndy id=78792806
ScriptLog: New Player Sold_Laugh id=37676805
ScriptLog: New Player NeMy' id=50421198
ScriptLog: New Player Whitle id=74778654
ScriptLog: New Player (£***£)THEFOURBE(� id=63486323
ScriptLog: New Player Sold_Laugh id=37676805
ScriptLog: New Player schybba[NO] id=17735142
ScriptLog: New Player Mephisto id=46363061
ScriptLog: New Player fidolk id=80956137
ScriptLog: New Player Mephisto id=46363061
ScriptLog: New Player Tomkka id=48888859
ScriptLog: New Player fidolk id=80956137
ScriptLog: New Player Vern_CZ id=34532385
ScriptLog: New Player MAjKy_SvK id=31919152
ScriptLog: New Player [:Ray-Raider:] id=59332988
ScriptLog: New Player Vitek_[CZ] id=57662658
ScriptLog: New Player MAjKy_SvK id=31919152
ScriptLog: New Player NeMy' id=50421198
ScriptLog: New Player Whitle id=74778654
ScriptLog: New Player Vern_CZ id=34532385
ScriptLog: New Player gavtron5000 id=58696777
ScriptLog: New Player gavtron5000 id=58696777
ScriptLog: New Player none id=40501219
ScriptLog: New Player Yasou id=32448741
ScriptLog: New Player Trintox id=16882516
ScriptLog: New Player Nihth id=8433186
ScriptLog: New Player Nihth id=8433186
ScriptLog: New Player MAjKy_SvK id=31919152
ScriptLog: New Player IOBI^1c.^7_Pad^1no^7 id=22040665
ScriptLog: New Player Krille id=32771147
ScriptLog: New Player Vern_CZ id=34532385
ScriptLog: New Player Repulze_:3 id=54148142
ScriptLog: New Player bajer84 id=36240368
ScriptLog: New Player nS.`V id=35158419
ScriptLog: New Player KillerCam id=6319980
ScriptLog: New Player {LI}_CaStiLzOr id=31953505
ScriptLog: New Player Nihth id=8433186
ScriptLog: New Player {LI}_CaStiLzOr id=31953505
ScriptLog: New Player KillerCam id=6319980
ScriptLog: New Player Repulze_:3 id=54148142
ScriptLog: New Player Lord_von_Hopper id=22234246
ScriptLog: New Player <~$-R~>_Csibe id=55422019
ScriptLog: New Player Nick id=32475492
ScriptLog: New Player bajer84 id=36240368
ScriptLog: New Player Veckpreb id=82530829
ScriptLog: New Player ajatim id=34224136
ScriptLog: New Player Heatman id=33361897
ScriptLog: New Player falqon id=37382502
ScriptLog: New Player Venom_t0088 id=64971737
ScriptLog: New Player YellowCherry id=64652804
ScriptLog: New Player Hierro id=5634454
ScriptLog: New Player Venom_t0088 id=64971737
ScriptLog: New Player Bergkamener_Bumser id=72505475
ScriptLog: New Player -=[C.o.H]=-_[FREAK]_ id=62272604
ScriptLog: New Player Eretoryi id=83329319
ScriptLog: New Player -=[C.o.H]=-_[FREAK]_ id=62272604
ScriptLog: New Player Venom_t0088 id=64971737
ScriptLog: New Player Lemon_Cosmos id=52922347
ScriptLog: New Player LauritaKiLL id=79150410
ScriptLog: New Player kolle :D id=45024284
ScriptLog: New Player kolle :D id=45024284
ScriptLog: New Player Xeillo id=41376399
ScriptLog: New Player [SCG]_Andro id=38560181
ScriptLog: New Player Black_Fox! id=39686684
ScriptLog: New Player Respen id=46769304
ScriptLog: New Player l0st_b0y id=13585585
ScriptLog: New Player Khan id=37962230
ScriptLog: New Player CrazyPet id=50772905
ScriptLog: New Player Calleron id=11344582
ScriptLog: New Player [SCG]_Andro id=38560181
ScriptLog: New Player Black_Fox! id=39686684
ScriptLog: New Player Xeillo id=41376399
ScriptLog: New Player Khan id=37962230
ScriptLog: New Player [SCG]_Andro id=38560181
ScriptLog: New Player zorgat id=26218160
ScriptLog: New Player TSPISoptunna id=39871012
ScriptLog: New Player akselsg2 id=84144828
ScriptLog: New Player Shellamala id=40662649
ScriptLog: New Player Kristian id=81872560
ScriptLog: New Player xLeLex id=66196854
ScriptLog: New Player Black_Fox! id=39686684
ScriptLog: New Player [SCG]_Andro id=38560181
ScriptLog: New Player Xeillo id=41376399
ScriptLog: New Player Khan id=37962230
ScriptLog: New Player Barack_Obama id=66836159
ScriptLog: New Player Chicken_Wings id=51631413
ScriptLog: New Player [SCG]_Andro id=38560181
ScriptLog: New Player Chicken_Wings id=51631413
ScriptLog: New Player Black_Fox! id=39686684
ScriptLog: New Player Xeillo id=41376399
ScriptLog: New Player Khan id=37962230
ScriptLog: New Player \m/Rune\m/ id=75679172
ScriptLog: New Player Black_Fox! id=39686684
ScriptLog: New Player [SCG]_Andro id=38560181
ScriptLog: New Player Xeillo id=41376399
ScriptLog: New Player Khan id=37962230
ScriptLog: New Player HolyCrap id=49989209
ScriptLog: New Player [SCG]_Andro id=38560181
ScriptLog: New Player HolyCrap id=49989209
ScriptLog: New Player Black_Fox! id=39686684
ScriptLog: New Player Xeillo id=41376399
ScriptLog: New Player Khan id=37962230
ScriptLog: New Player Saint_Keo_II_����� id=41441092
ScriptLog: New Player Thun id=37273987
ScriptLog: New Player Fa11 id=10756088
ScriptLog: New Player ChildofNite id=11713236
ScriptLog: New Player György_Van_Dózsa id=3453898
ScriptLog: New Player ShadiX id=51178455
ScriptLog: New Player PIPIPIPIPI id=40198682
ScriptLog: New Player Edenxfire_! id=51049309
ScriptLog: New Player Wittels id=63025824
ScriptLog: New Player Deadly-Dosage id=10194997
ScriptLog: New Player PIPIPIPIPI id=40198682
ScriptLog: New Player ChildofNite id=11713236
ScriptLog: New Player Deadly-Dosage id=10194997
ScriptLog: New Player Fa11 id=10756088
ScriptLog: New Player György_Van_Dózsa id=3453898
ScriptLog: New Player [HFR]_Kikasstou id=33173467
ScriptLog: New Player Jdizl id=24717885
ScriptLog: New Player Jdizl id=24717885
ScriptLog: New Player [HFR]_Kikasstou id=33173467
ScriptLog: New Player ChildofNite id=11713236
ScriptLog: New Player György_Van_Dózsa id=3453898
ScriptLog: New Player Fa11 id=10756088
ScriptLog: New Player Unknown[NF] id=74813902
ScriptLog: New Player Bubbi id=44740614
ScriptLog: New Player Tompkins id=32906833
ScriptLog: New Player [HFR]_Kikasstou id=33173467
ScriptLog: New Player Tompkins id=32906833
ScriptLog: New Player TheGrym id=25518635
ScriptLog: New Player Tanyax14 id=84173968
ScriptLog: New Player ^0[NOR]^6Zpectro id=16300372
ScriptLog: New Player CoolHead id=71795591
ScriptLog: New Player Umbert id=10794411
ScriptLog: New Player Shadow id=48498122
ScriptLog: New Player knacki id=84196950
ScriptLog: New Player Knasty id=69994062
ScriptLog: New Player elBOILER id=57851204
ScriptLog: New Player elBOILER id=57851204
ScriptLog: New Player knacki id=84196950
ScriptLog: New Player Knasty id=69994062
ScriptLog: New Player DeadlyThug id=12198436
ScriptLog: New Player NickagubbeN id=55438909
ScriptLog: New Player Kofi id=59775281
ScriptLog: New Player evilprimarch id=67644325
ScriptLog: New Player Slarto_/_LOADSAMONEY id=38781177
ScriptLog: New Player Frank(CZ) id=52625948
ScriptLog: New Player Seventhson id=61948187
ScriptLog: New Player [_Heavy-Rain_] id=41338713
ScriptLog: New Player Meyers id=36462177
ScriptLog: New Player Blizzardking id=67015913
ScriptLog: New Player knacki id=84196950
ScriptLog: New Player Blizzardking id=67015913
ScriptLog: New Player Knasty id=69994062
ScriptLog: New Player Kornwit id=55557631
ScriptLog: New Player Jesper id=40896205
ScriptLog: New Player Goatic id=43591696
ScriptLog: New Player krzys837 id=75932981
ScriptLog: New Player Jesper id=40896205
ScriptLog: New Player Kornwit id=55557631
ScriptLog: New Player Goatic id=43591696
ScriptLog: New Player knacki id=84196950
ScriptLog: New Player Knasty id=69994062
ScriptLog: New Player Shellamala id=40662649
ScriptLog: New Player OnLiiiNE id=52143334
: 10 lipca 2011, 13:10
autor: Bastian
Po pierwsze nie odpalaj tego tak:
To nie ma prawa działać, bo nie pisałem w dashu tylko w bashu.
Podmień w kf_users.sh tresc na;
Kod: Zaznacz cały
#!/bin/bash
USER="xxxxxx"
HASLO="zzzzzzzz";
HOST="localhost";
BAZA="yyyyyyyy";
TABELA="players";
KF_LOG="server_kfbasic.log";
TEMP="tmp.log"; #to tymczasowy plik nazwijmy "wymiany", zostaw tak jak jest
mysql -u ${USER} -h ${HOST} --password=${HASLO} ${BAZA} -Bse "DESCRIBE ${TABELA}"
if [ $? -eq 0 ]; then
mysql -u ${USER} -h ${HOST} --password=${HASLO} ${BAZA} -Bse "SELECT * FROM ${TABELA}" > ${TEMP}
awk -f kf_users.awk ${TEMP} ${KF_LOG}
rm ${TEMP}
else
echo "tabela nieistnieje. Tworze...";
mysql -u ${USER} -h ${HOST} --password=${HASLO} ${BAZA} -Bse "CREATE TABLE ${TABELA} (id INT(10) NOT NULL, player CHAR(40) NOT NULL, connections INT(11) NOT NULL) "
if [ $? -eq 0 ]; then
echo "Tabela utworzona. Prosze wywołać skrypt raz jeszcze"
else
echo "Nie udalo się utworzyć tabeli. Sprawdź konfigurację, i spróbuj raz jeszcze"
fi
fi
I wklej to co zwróci konsola
: 10 lipca 2011, 13:15
autor: DaVidoSS
$~ ./kf_users.sh
Kod: Zaznacz cały
id int(10) NO NULL
player char(40) NO NULL
connections int(11) NO NULL
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
ERROR at line 1: Unknown command '\''.
/bin/bash: line 111: nieoczekiwany EOF podczas poszukiwania pasującego ``'
/bin/bash: line 204: błąd składni: nieoczekiwany koniec pliku
: 10 lipca 2011, 13:56
autor: Bastian
kf_users.awk
Kod: Zaznacz cały
$1 ~ /^[[:digit:]]/ {
connb[$2]= $3; nickb[$2]=$2;}
$1 ~ /ScriptLog:/ {
if (start) {
znalazl=0;
{for (x in conn) {
if ( x == $4) {
znalazl=1;
conn[x]++; break
}
}}
{if (znalazl == 0) {
conn[$4]= 1; id[$4]= substr($5, 4); nick[$4]=$4;}}
} else {
start=1;
conn[$4] = 1; id[$4]= substr($5, 4); nick[$4]=$4
}}
END {
tabela="players"; //config
for (l in conn) {
if (!nickb[l]) {
insert_tb="INSERT INTO "tabela "(id, player, connections) VALUES ('"id[l]"', '"nick[l]"', '"conn[l]"')"
print "mysql -u xxxxxxx -h localhost --password=zzzzzzzzzzzzzz yyyyyyyy -Bse \""insert_tb"\"" | "/bin/bash"
} else {
if (conn[l] > connb[l]) {
update_tb= "UPDATE "tabela" SET connections="conn[l]" WHERE player='"nick[l]"'"
print "mysql -u xxxxxxx -h localhost --password=zzzzzzzzzzzzz yyyyyyyy -Bse \""update_tb"\"" | "/bin/bash"
}
}
}
}
Spróbuj tak
: 10 lipca 2011, 14:04
autor: DaVidoSS
$ ~ ./kf_users.sh
Kod: Zaznacz cały
id int(10) NO NULL
player char(40) NO NULL
connections int(11) NO NULL
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '4')' at line 1
/bin/bash: line 118: nieoczekiwany EOF podczas poszukiwania pasującego ``'
/bin/bash: line 214: błąd składni: nieoczekiwany koniec pliku
$~ mysql -V
mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (x86_64) using readline 6.1
: 10 lipca 2011, 14:27
autor: Bastian
A baza wypełniła się danymi?
: 10 lipca 2011, 14:32
autor: DaVidoSS
Tak!
Wygada jednak, że są jakieś błędy:
Wygląda to tak:
Załącznik zrzut ekranu3.jpg nie jest już dostępny
: 10 lipca 2011, 14:39
autor: Bastian
Ok, błędy o których mówisz to błędy kodowania znaków. Niestety jak ktoś uzywa innego kodowania (np regionalnych znaków) to tak to wygląda. Zmien kodowanie bazy na UTF-8. Co do błędu, który pojawił się powyżej, to wynika on stąd, że jakiś łepek sobie apostrof w nicku daje (NeMy'). Poprawie Ci ten skrypt tak, żeby wycinał takie kwiatki.
Prześlij mi cały plik logu