4 odpowiedzi w tym temacie

[adi92]

L 06/08/2010 - 19:59:32: [sparta_mod.amxx] Error in querying database
L 06/08/2010 - 19:59:32: [sparta_mod.amxx] Message: MySQL server has gone away (2006)
L 06/08/2010 - 19:59:32: [sparta_mod.amxx] Query statement: SELECT `player_id` FROM `sparta_info` WHERE `player_name` = ''wolna konopia aKa. zAba'';
L 06/08/2010 - 19:59:32: [sparta_mod.amxx] Attempting to re-establish connection to MySQL server.
L 06/08/2010 - 19:59:32: [sparta_mod.amxx] Invalid UniqueID! ERROR


wszystko zrobilem wg instrukcji korzystam z bazy danych wszsystko wpisalem tak jak kazano i niewiem co jest zle

[hardbot]

Brak połączenia z bazą MySQL

[adi92]

ale to nie mozliwe wszystko wpisalem!


Look

// Sparta-Mod (300) Config file
// Last-Modified 24.6.08


// main settings
sp_modon "1" // Enable (1) or Disable (0) Sparta-Mod


// Where should we save the XP''s then?
sp_typesave "0" // 0 = MySQL, 1 = NVault


// How should we save the XP''s then?
sp_xp_saveby "2" // 0 = SteamID, 1 = IP, 2 = Name


// MYSQL options. You don''t have to edit it if you use nvault
sp_db_host "nonie4hp.xaa.pl" // Server ip where the Mysql Database is hosted
sp_db_user "noniehp" // The login name from the database
sp_db_pass "no do c panelu" // The password from the database
sp_db_name "noniehp_sparta" // The database name


// Admin options
sp_adminon "1" // Enable (1) or Disable (0) the Admin commands
sp_admin_flag "a" // The required flag for admin commands


// XP options
sp_savexp "1" // Enable (1) or Disable (0) Saved XP


// XPs for Event''s
sp_killxp "15" // XPs for killing an enemy
sp_plantingxp "200" // XPs for planting the bomb
sp_defusingxp "200" // XPs for defusing the bomb
sp_spawnbombxp "20" // XPs for spawning with the bomb
sp_dropbombxp "20" // XPs lost for dropping the bomb
sp_pickbombxp "20" // XPs for picking up the bomb
sp_follhostagexp "30" // XPs for starting to rescue the hostage
sp_rescuehostagexp "50" // XPs for rescuing the hostage
sp_killhostagexp "50" // XPs lost for killing a hostage
sp_gotvipxp "100" // XPs for spawning as a VIP
sp_rescuevipxp "200" // XPs for escaping as the VIP
sp_rolekillxp "50" // XPs for killing important players (bomb planter, defuser, vip etc)
sp_ctwinxp "80" // XPs for CT''s if they winning the round
sp_twinxp "80" // XPs for T''s if they winning the round
sp_bombplantingxp "40" // XPs for starting to plant the bomb
sp_bombdefusingxp "40" // XPs for starting to defuse the bomb


// Beginner''s Luck
sp_beginnersluck "1" // Enable (1) or Disable (0) Beginner''s Luck abilitie
sp_beginnersdmg "20" // The beginner evade shoots and get health
sp_beginnerlevel "20" // If the player''s level over this var, he will no more get Beginner''s Luck


// Ultimate''s
sp_ultdelay "20" // 20 Seconds ultimate delay


// Sounds
sp_soundon "1" // Enable (1) or Disable (0) sparta sound''s


// Bot''s CVAR''s
sp_botallow "0" // Enable (1) or Disable (0) the plugin to count the bot''s as full players (sp_minplayers will count they)
sp_botlevel "1" // Set the bot start level


// Minplayers
sp_minplayers "2" // Minplayers on the server to start getting and losing xps

[hardbot]

udostępniałeś w Cpanelu co do serwera? IP że może się łączyć

[adi92]

dalem %!

08 czerwiec 2010 - 21:51:
niby exp sie zapisuje ale blad nadal jest

09 czerwiec 2010 - 17:06:
no jednak nie chodzi po wylaczeniu i wlaczeniu serwerwa sie lvl nie zapisal oto wyciag z konsoli:

L 06/09/2010 - 15:50:34: [sparta_mod.amxx] Error in querying database
L 06/09/2010 - 15:50:34: [sparta_mod.amxx] Message: MySQL server has gone away (2006)
L 06/09/2010 - 15:50:34: [sparta_mod.amxx] Query statement: SELECT `player_id` FROM `sparta_info` WHERE `player_name` = ''Adi'';
L 06/09/2010 - 15:50:34: [sparta_mod.amxx] Attempting to re-establish connection to MySQL server.
L 06/09/2010 - 15:50:34: [sparta_mod.amxx] Invalid UniqueID! ERROR

a oto cvary:

// Sparta-Mod (300) Config file
// Last-Modified 24.6.08


// main settings
sp_modon "1" // Enable (1) or Disable (0) Sparta-Mod


// Where should we save the XP''''s then?
sp_typesave "0" // 0 = MySQL, 1 = NVault


// How should we save the XP''''s then?
sp_xp_saveby "2" // 0 = SteamID, 1 = IP, 2 = Name


// MYSQL options. You don''''t have to edit it if you use nvault
sp_db_host "nonie4hp.xaa.pl" // Server ip where the Mysql Database is hosted
sp_db_user "noniehp" // The login name from the database
sp_db_pass "haslo do cpanel" // The password from the database
sp_db_name "noniehp_sparta" // The database name


// Admin options
sp_adminon "1" // Enable (1) or Disable (0) the Admin commands
sp_admin_flag "a" // The required flag for admin commands


// XP options
sp_savexp "1" // Enable (1) or Disable (0) Saved XP


// XPs for Event''''s
sp_killxp "50" // XPs for killing an enemy
sp_plantingxp "350" // XPs for planting the bomb
sp_defusingxp "350" // XPs for defusing the bomb
sp_spawnbombxp "30" // XPs for spawning with the bomb
sp_dropbombxp "30" // XPs lost for dropping the bomb
sp_pickbombxp "25" // XPs for picking up the bomb
sp_follhostagexp "50" // XPs for starting to rescue the hostage
sp_rescuehostagexp "100" // XPs for rescuing the hostage
sp_killhostagexp "100" // XPs lost for killing a hostage
sp_gotvipxp "150" // XPs for spawning as a VIP
sp_rescuevipxp "300" // XPs for escaping as the VIP
sp_rolekillxp "70" // XPs for killing important players (bomb planter, defuser, vip etc)
sp_ctwinxp "100" // XPs for CT''''s if they winning the round
sp_twinxp "100" // XPs for T''''s if they winning the round
sp_bombplantingxp "80" // XPs for starting to plant the bomb
sp_bombdefusingxp "80" // XPs for starting to defuse the bomb


// Beginner''''s Luck
sp_beginnersluck "1" // Enable (1) or Disable (0) Beginner''''s Luck abilitie
sp_beginnersdmg "50" // The beginner evade shoots and get health
sp_beginnerlevel "20" // If the player''''s level over this var, he will no more get Beginner''''s Luck


// Ultimate''''s
sp_ultdelay "20" // 20 Seconds ultimate delay


// Sounds
sp_soundon "1" // Enable (1) or Disable (0) sparta sound''''s


// Bot''''s CVAR''''s
sp_botallow "0" // Enable (1) or Disable (0) the plugin to count the bot''''s as full players (sp_minplayers will count they)
sp_botlevel "1" // Set the bot start level


// Minplayers
sp_minplayers "2" // Minplayers on the server to start getting and losing xps

te cvary sa w amxmodx/config/sparta/sp_config.cfg
Jak naprawic ta baze danych juz mnie to drazni