Konfiguracja bazy danych w diablo modzie

napisałes :

Tylko nie wiem co wpisac

Allow access from following IP **:

a zaraz piszesz :

ale Miczu kazał zostawić puste <img src='https://amxx.pl/public/style_emoticons/<#EMO_DIR#>/smile.gif' class='bbc_emoticon' alt=':)' />

to zostaw puste

bo napisałem temat ale Miczu szybciej mi na pw odpisał ...

pozostaw % no chyba ze chcesz zabezpieczyc przed dostepem innych osob to podaj ip serwera z ktorego bedziesz sie laczyl do bazy

Jesli napisalem "pozostaw puste" no to zal... nic dziwnego ze masz problemy skoro nie umiesz czytac ze zrozumieniem ;>

kazales pozostawic % lub wpisac ip z ktorego będę sie laczyl ale mam dziwny problem mam baze z ost jest na porcie 3308 dodalem wszystkei cvary zrobilem reset przez rcona i jak wchodze na serwer nie widzi mi klasy ani nie daje exp jak kogos zabije .. ale itemy dzialaja patrzylem w diablo.log to nie ma nic oprocz

L 02/04/2009 - 17:51:47: Log file started (file "cstrike/addons/amxmodx/logs/diablo.log") (game "cstrike") (amx "1.8.1.3746")
L 02/04/2009 - 17:51:47: 02/04/2009 - 17:51:47 ### MAPA: de_dust2 ### 

a cvary mam tak

//
// diablomod
//
diablo_xpbonus "7"
diablo_xpbonus2 "50"
diablo_durability "5"
diablo_saveitems "1"
diablo_spawnchance "1"
SaveXp "1"

diablo_sql_host "localhost:3308"
diablo_sql_user "xxxxx"
diablo_sql_pass "xxxxxx"
diablo_sql_database "10249001"
diablo_sql_table "diablo"
diablo_sql_save "2"

amx_revkit_time "3"
amx_revkit_health "25"
amx_revkit_distance "70.0"

diablo_dir "addons/amxmodx/diablo/"
diablo_show_health "1"

diablo_knife "20"
diablo_knife_speed "1000"
diablo_arrow "120"
diablo_arrow_speed "1500"
diablo_klass_delay "2.5"

By uzyc bazy danych o porcie innym niz 3306 nalezy koniecznie dac "hosta:port" czyli:

diablo_sql_host "sql.miczu.nazwa.pl:3308"

może w tym tkwi problem ?

"no to jest nazwa hosta : port" dzwonilem do ost i mowili ze baza ma port 3308 a nazwa hosta to lokalhost wiec nei czaje ;/

a nie masz dodac tak ? :

diablo_sql_host "sql.twojanazwa.nazwa.pl:tutaj port"

a teraz mam takie logi

L 02/04/2009 - 17:51:47: Log file started (file "cstrike/addons/amxmodx/logs/diablo.log") (game "cstrike") (amx "1.8.1.3746")

L 02/04/2009 - 17:51:47: 02/04/2009 - 17:51:47 ### MAPA: de_dust2 ### 

L 02/04/2009 - 18:03:02: 02/04/2009 - 18:03:02 ### MAPA: aim_headshot ### 

L 02/04/2009 - 18:27:51: 02/04/2009 - 18:27:51 ### MAPA: de_train ### 

L 02/04/2009 - 18:35:04: 02/04/2009 - 18:35:04 ### MAPA: de_train ### 

L 02/04/2009 - 18:35:12: 02/04/2009 - 18:35:12 ### MAPA: aim_headshot ### 

L 02/04/2009 - 19:00:00: 02/04/2009 - 19:00:00 ### MAPA: awp_india ### 

L 02/04/2009 - 19:24:48: 02/04/2009 - 19:24:48 ### MAPA: de_aztec ### 

L 02/04/2009 - 19:49:37: 02/04/2009 - 19:49:37 ### MAPA: de_dust ### 

L 02/04/2009 - 20:09:18: 02/04/2009 - 20:09:18 ### MAPA: de_aztec ### 

L 02/04/2009 - 20:29:24: 02/04/2009 - 20:29:24 ### MAPA: aim_headshot ### 

L 02/04/2009 - 20:49:28: 02/04/2009 - 20:49:28 ### MAPA: awp_india ### 

L 02/04/2009 - 21:09:32: 02/04/2009 - 21:09:32 ### MAPA: de_aztec ### 

L 02/04/2009 - 21:29:35: 02/04/2009 - 21:29:35 ### MAPA: de_dust ### 

L 02/04/2009 - 21:49:38: 02/04/2009 - 21:49:38 ### MAPA: de_dust2 ### 

L 02/04/2009 - 22:08:59: 02/04/2009 - 22:08:59 ### MAPA: de_aztec ### 

L 02/04/2009 - 22:29:03: 02/04/2009 - 22:29:03 ### MAPA: aim_headshot ### 

L 02/04/2009 - 22:49:05: 02/04/2009 - 22:49:05 ### MAPA: awp_india ### 

L 02/04/2009 - 23:09:07: 02/04/2009 - 23:09:07 ### MAPA: de_aztec ### 

L 02/04/2009 - 23:29:09: 02/04/2009 - 23:29:09 ### MAPA: de_dust ### 

L 02/04/2009 - 23:49:11: 02/04/2009 - 23:49:11 ### MAPA: de_dust2 ### 

L 02/05/2009 - 00:08:41: 02/05/2009 - 00:08:41 ### MAPA: de_aztec ### 

L 02/05/2009 - 00:28:45: 02/05/2009 - 00:28:45 ### MAPA: aim_headshot ### 

L 02/05/2009 - 00:48:47: 02/05/2009 - 00:48:47 ### MAPA: awp_india ### 

L 02/05/2009 - 01:08:49: 02/05/2009 - 01:08:49 ### MAPA: de_aztec ### 

L 02/05/2009 - 01:28:51: 02/05/2009 - 01:28:51 ### MAPA: de_dust ### 

L 02/05/2009 - 01:48:53: 02/05/2009 - 01:48:53 ### MAPA: de_dust2 ### 

L 02/05/2009 - 02:08:21: 02/05/2009 - 02:08:21 ### MAPA: de_aztec ### 

L 02/05/2009 - 02:28:25: 02/05/2009 - 02:28:25 ### MAPA: aim_headshot ### 

L 02/05/2009 - 02:48:26: 02/05/2009 - 02:48:26 ### MAPA: awp_india ### 

L 02/05/2009 - 03:08:28: 02/05/2009 - 03:08:28 ### MAPA: de_aztec ### 

L 02/05/2009 - 03:28:30: 02/05/2009 - 03:28:30 ### MAPA: de_dust ### 

L 02/05/2009 - 03:48:32: 02/05/2009 - 03:48:32 ### MAPA: de_dust2 ### 

L 02/05/2009 - 04:08:02: 02/05/2009 - 04:08:02 ### MAPA: de_aztec ### 

L 02/05/2009 - 04:28:05: 02/05/2009 - 04:28:05 ### MAPA: aim_headshot ### 

L 02/05/2009 - 04:48:07: 02/05/2009 - 04:48:07 ### MAPA: awp_india ### 

L 02/05/2009 - 05:01:53: 02/05/2009 - 05:01:53 ### MAPA: de_aztec ### 

L 02/05/2009 - 05:22:00: 02/05/2009 - 05:22:00 ### MAPA: aim_headshot ### 

L 02/05/2009 - 05:42:01: 02/05/2009 - 05:42:01 ### MAPA: awp_india ### 

L 02/05/2009 - 06:02:03: 02/05/2009 - 06:02:03 ### MAPA: de_aztec ### 

L 02/05/2009 - 06:22:05: 02/05/2009 - 06:22:05 ### MAPA: de_dust ### 

L 02/05/2009 - 06:42:09: 02/05/2009 - 06:42:09 ### MAPA: de_dust2 ### 

L 02/05/2009 - 07:01:24: 02/05/2009 - 07:01:24 ### MAPA: de_aztec ### 

L 02/05/2009 - 07:21:30: 02/05/2009 - 07:21:30 ### MAPA: aim_headshot ### 

L 02/05/2009 - 07:41:32: 02/05/2009 - 07:41:32 ### MAPA: awp_india ### 

L 02/05/2009 - 08:01:33: 02/05/2009 - 08:01:33 ### MAPA: de_aztec ### 

L 02/05/2009 - 08:21:36: 02/05/2009 - 08:21:36 ### MAPA: de_dust ### 

L 02/05/2009 - 08:41:37: 02/05/2009 - 08:41:37 ### MAPA: de_dust2 ### 

L 02/05/2009 - 09:01:03: 02/05/2009 - 09:01:03 ### MAPA: de_aztec ### 

L 02/05/2009 - 09:21:07: 02/05/2009 - 09:21:07 ### MAPA: aim_headshot ### 

L 02/05/2009 - 09:41:10: 02/05/2009 - 09:41:10 ### MAPA: awp_india ### 

L 02/05/2009 - 10:01:12: 02/05/2009 - 10:01:12 ### MAPA: de_aztec ### 

L 02/05/2009 - 10:21:14: 02/05/2009 - 10:21:14 ### MAPA: de_dust ### 

L 02/05/2009 - 10:41:16: 02/05/2009 - 10:41:16 ### MAPA: de_dust2 ### 

L 02/05/2009 - 10:41:54: Error on Table query: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

L 02/05/2009 - 10:41:54: Could not connect to SQL database.

L 02/05/2009 - 10:41:54: Error on Table query: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

L 02/05/2009 - 10:41:54: Could not connect to SQL database.

L 02/05/2009 - 10:42:07: Error on Table query: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

L 02/05/2009 - 10:42:07: Could not connect to SQL database.

L 02/05/2009 - 10:42:07: Error on Table query: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

L 02/05/2009 - 10:42:07: Could not connect to SQL database.

L 02/05/2009 - 10:42:07: Error on Table query: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

L 02/05/2009 - 10:42:07: Could not connect to SQL database.

L 02/05/2009 - 10:42:07: Error on Table query: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

L 02/05/2009 - 10:42:07: Could not connect to SQL database.

L 02/05/2009 - 11:00:46: 02/05/2009 - 11:00:46 ### MAPA: de_aztec ### 

L 02/05/2009 - 10:42:07: Could not connect to SQL database.
L 02/05/2009 - 10:42:07: Error on Table query: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

tak jak pisałes z SQL i MySQL

co mam z tym zrobic ?

Nie rozumieim o co biega z tymi portami help!!?

[ Dodano: 27-02-2009, 17:03 ]
L 02/27/2009 - 17:02:09: Error on Table query: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 02/27/2009 - 17:02:09: Could not connect to SQL database.
L 02/27/2009 - 17:02:10: Error on Table query: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 02/27/2009 - 17:02:10: Could not connect to SQL database.
L 02/27/2009 - 17:02:10: Error on Table query: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 02/27/2009 - 17:02:10: Could not connect to SQL database.
L 02/27/2009 - 17:02:10: Error on Table query: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 02/27/2009 - 17:02:10: Could not connect to SQL database.
L 02/27/2009 - 17:02:10: Error on Table query: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 02/27/2009 - 17:02:10: Could not connect to SQL database.
L 02/27/2009 - 17:02:10: Error on Table query: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 02/27/2009 - 17:02:10: Could not connect to SQL database.





diablo_sql_host "sprawdzsquilla.host.sk"
diablo_sql_user "sps"
diablo_sql_pass "***"
diablo_sql_database "sql"
diablo_sql_table "diablo"
diablo_sql_save "1"
diablo_sql_host "localhost:3306"


Co jest zle?

[ Dodano: 27-02-2009, 17:06 ]
MySQL Server - db.host.sk (port 3306)


Tak pisze na host sq stronie jak dac ten port?

diablo_sql_host "sprawdzsquilla.host.sk"
diablo_sql_user "sps"
diablo_sql_pass "***"
diablo_sql_database "sql"
diablo_sql_table "diablo"
diablo_sql_save "1"
diablo_sql_host "localhost:3306"

2x ten sam cvar? A do tego ani 1 ten co ty podales w pozniejszym poscie ;>

To jak to mam dac?

[ Dodano: 27-02-2009, 17:24 ]
Miczu plis

[ Dodano: 27-02-2009, 17:46 ]
FAQ

FAQ sections
Services
MySQL

* What is MySQL?
* How can I access my MySQL database?
* Where should I find MySQL manual?

What is MySQL?

MySQL is the world's most popular open source, binary database server. It is capable of supporting over 50,000,000 records. SQL (Structured Query Language) is the language used to communicate with the MySQL server.
How can I access my MySQL database?

You can create your db at https://www.host.sk/users/mydb/. Accessing your MySQL database by your PHP scripts use following db address:
MySQL Server - db.host.sk (port 3306)
Where should I find MySQL manual?

To communicate with MySQL server use SQL (Structure Query Language) language. SQL Manual is available at http://www.dbmaker.c...als/sql/SQL.htm.




Tak pisze na stronie temtej.


Daje tak:

diablo_sql_host "sprawdzsquilla.host.sk"
diablo_sql_user "sps"
diablo_sql_pass "***"
diablo_sql_database "sql"
diablo_sql_table "diablo"
diablo_sql_save "1"



I NIE DZALA proszę bo nie czaje tego a ludzie chca grac.

[ Dodano: 27-02-2009, 17:52 ]


[ Dodano: 27-02-2009, 18:27 ]
MAM SQLA ALE MAM CRASHE!!!!!!!!!!!!!!!!!!Co robic?

Ja mam problem, posiadam Hosting na Hitme.pl

P.S. Dodam Iż Serwer teraz się wyłącza cały czas co dojdę do tt/ct..

Moje cvar'y:

diablo_sql_host "sql.hitme.pl"
diablo_sql_user "empetrzy_empe"
diablo_sql_pass "******"
diablo_sql_database "empetrzy_diablo"
diablo_sql_table "diablo"
diablo_sql_save "0"

Logi;

L 03/25/2009 - 12:50:42: Log file started (file "cstrike/addons/amxmodx/logs/diablo.log") (game "cstrike") (amx "1.8.1.3746")
L 03/25/2009 - 12:50:42: 03/25/2009 - 12:50:42 ### MAPA: de_dust2 ### 
L 03/25/2009 - 12:55:03: Error on Table query: Can't connect to MySQL server on 'sql.hitme.pl' (113)
L 03/25/2009 - 12:55:03: Could not connect to SQL database.
L 03/25/2009 - 12:55:13: Error on Table query: Can't connect to MySQL server on 'sql.hitme.pl' (113)
L 03/25/2009 - 12:55:13: Could not connect to SQL database.
L 03/25/2009 - 12:55:14: Error on Table query: Can't connect to MySQL server on 'sql.hitme.pl' (113)
L 03/25/2009 - 12:55:14: Could not connect to SQL database.
L 03/25/2009 - 12:55:37: Error on Table query: Can't connect to MySQL server on 'sql.hitme.pl' (113)
L 03/25/2009 - 12:55:37: Could not connect to SQL database.
L 03/25/2009 - 12:55:37: Error on Table query: Can't connect to MySQL server on 'sql.hitme.pl' (113)
L 03/25/2009 - 12:55:37: Could not connect to SQL database.
L 03/25/2009 - 14:33:29: 03/25/2009 - 14:33:29 ### MAPA: de_dust2 ### 
L 03/25/2009 - 14:40:05: Error on Table query: Can't connect to MySQL server on 'sql.hitme.pl' (113)
L 03/25/2009 - 14:40:05: Could not connect to SQL database.
L 03/25/2009 - 14:44:42: 03/25/2009 - 14:44:42 ### MAPA: de_dust2 ###

P.S. Dodam Iż Serwer teraz się wyłącza cały czas co dojdę do tt/ct..

Jak widac nie mozna sie polaczyc do bazy danych - sprawdz czy:
- masz dobre dane
- czy port jest inny niz standardowy 3306 (chyba :F)
- czy na pewno mozna sie polaczyc z serwera na hosta sql

Dobra, hitme.pl dam spokój, ale czy mogę się dowiedzieć jaki jest dobry hosting do diablo moda? Chodzi mi tylko o samą bazę danych...

www.no-1.pl

Zamówiłem hosting na nazwa.pl i wszystko działa dobrze ; ) ;>

Wytłumaczy ktoś zielonemu co dokladnie zrobic? Zalozylem konto na http://www.db4free.net, mam baze danych -> co dalej?

Wytłumaczy ktoś zielonemu co dokladnie zrobic? Zalozylem konto na http://www.db4free.net, mam baze danych -> co dalej?

http://amxx.pl/viewtopic.php?t=4329