Killing Floor - lokalne statystyki

DaVidoSS · Post autor: **DaVidoSS** » 09 lipca 2011, 19:40

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

Bastian · Post autor: **Bastian** » 10 lipca 2011, 11:47

Zmieniałeś w skrypcie /bin/bash na /bin/sh może?

DaVidoSS · Post autor: **DaVidoSS** » 10 lipca 2011, 12:29

Nie nie zmieniałam nic oprócz tych zmiennych.

Jeśli wykonuję plik w ten sposób:

Kod: Zaznacz cały

./kf_users.sh

Nic się nie dzieje i konsola nic nie zwraca.
Baza danych pozostaje pusta.

Jesli użyję sh:

Kod: Zaznacz cały

sh kf_users.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

Bastian · Post autor: **Bastian** » 10 lipca 2011, 13:10

Po pierwsze nie odpalaj tego tak:

Kod: Zaznacz cały

sh kf_users.sh

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

DaVidoSS · Post autor: **DaVidoSS** » 10 lipca 2011, 13:15

$~ ./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

Bastian · Post autor: **Bastian** » 10 lipca 2011, 13:56

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

DaVidoSS · Post autor: **DaVidoSS** » 10 lipca 2011, 14:04

$ ~ ./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

Bastian · Post autor: **Bastian** » 10 lipca 2011, 14:27

A baza wypełniła się danymi?

DaVidoSS · Post autor: **DaVidoSS** » 10 lipca 2011, 14:32

Tak!
Wygada jednak, że są jakieś błędy:
Wygląda to tak:

Załącznik zrzut ekranu3.jpg nie jest już dostępny

Bastian · Post autor: **Bastian** » 10 lipca 2011, 14:39

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