Saving on MySQL wont work... :(

Read log files for errors! If this fails, come here for help

Moderator: Forum Moderator

Post Reply
Odium
Peon
Posts: 11
Joined: Wed Mar 01, 2006 1:27 am

Saving on MySQL wont work... :(

Post by Odium » Wed Mar 01, 2006 1:41 am

Hallo,
ich habe es nun schon etliche male versucht, aber ich bekomme es einfach nicht hin, dass die XP unter der MYSQL Datenbank gespeichert werden.
Es wird ständig in die Datei vault.ini gespeichert, obwohl in der war3FT.cfg die Einstellungen völlig korrekt sind.
Ich nutze WC3FT im Zusammenhang mit AMXMODX 1.60

Hoffe dass mir einer helfen kann.



________________________________________________________


Hello, I has it now already some paints tried, but I get it simply not that the XP under the MYSQL data base is stored.
It is constantly stored into the file vault.ini, although into the war3FT.cfg the attitudes are completely correct.
I use WC3FT in connection with AMXMODX 1,60 hope that me one to help can.


Sorry for my bad english. It was the google translator :(

DarkJP2
Rifleman
Posts: 163
Joined: Tue Jul 26, 2005 3:18 pm
Location: Swiss

Post by DarkJP2 » Wed Mar 01, 2006 3:42 am

kompillier die .sma mal und ersetz die alte .amxx dann mit der neukompillierten

Odium
Peon
Posts: 11
Joined: Wed Mar 01, 2006 1:27 am

Post by Odium » Wed Mar 01, 2006 3:53 am

Hmm,

wenn ich es auf www.amxmodx.org machen will, dann kann er es nicht.
Und wenn ich es mit dem compiler von amxx mache, dann kommt nachdem ich die neue hochgeladen habe, ein bad load.....

DarkJP2
Rifleman
Posts: 163
Joined: Tue Jul 26, 2005 3:18 pm
Location: Swiss

Post by DarkJP2 » Wed Mar 01, 2006 4:00 am

onlinecompier geht sowieso nicht, da das plugin noch anderedateien einschliesst, die nicht aufm webcompier zuverfügung stehen.

zeig maln paar log dateien und die modules.ini

Odium
Peon
Posts: 11
Joined: Wed Mar 01, 2006 1:27 am

Post by Odium » Wed Mar 01, 2006 10:49 am

Was für Log Dateien brauchst Du genau ?

Habe eben nochmal compiliert aber geht nicht. Die Datei die dann entsteht ist auch kleiner als die alte.

Das hier ist die modules.ini:

; AMX Mod X Modules
; You can specify both linux & win32 modules here
; To enable a module, remove the semi-colon from the line

; ------------------------------
; Fun - provides extra functions
; ------------------------------
fun_amxx_i386.so
fun_amxx_amd64.so

; ----------------------------------------------------
; Engine - provides engine functions core to Half-Life
; ----------------------------------------------------
engine_amxx_i386.so
engine_amxx_amd64.so

; ----------------------------------------------------------
; Fakemeta - provides a massive interface into the HL engine
; ----------------------------------------------------------
;fakemeta_amxx_i386.so
;fakemeta_amxx_amd64.so

; -------------------------------------------
; Database Access - only enable one of these
; -------------------------------------------
; MySQL
mysql_amxx_i386.so
mysql_amxx.dll
mysql_amxx_amd64.so
; PostgreSQL
;pgsql_amxx_i386.so
; SQLite
;sqlite_amxx_i386.so
;sqlite_amxx_amd64.so

; ---------------------------------------------
; GeoIP - determines the country of ip adresses
; ---------------------------------------------
;geoip_amxx_i386.so
;geoip_amxx_amd64.so

; --------------------------------
; Sockets - network socket support
; --------------------------------
;sockets_amxx_i386.so
;sockets_amxx_amd64.so

; --------------------------
; Regular Expression support
; --------------------------
;regex_amxx_i386.so
;regex_amxx_amd64.so

; --------------------
; Binary Vault support
; --------------------
;nvault_amxx_i386.so
;nvault_amxx_amd64.so

; ----------------------------------------------------------
; Counter-Strike - adds functions specific to Counter-Strike
; ----------------------------------------------------------
cstrike_amxx_i386.so
cstrike_amxx_amd64.so

; -----------------------------------------------------
; CSX - adds functionality for CS statistics and events
; -----------------------------------------------------
csx_amxx_i386.so
csx_amxx_amd64.so

; --------------------------------------------------------------
; WAR3FT - adds functions used by war3ft - By Geesu (Pimp Daddy)
; --------------------------------------------------------------
war3ft_amxx_i386.so
war3ft_amxx_amd64.so

User avatar
Striker
Footman
Posts: 106
Joined: Thu Jul 07, 2005 2:40 pm
Location: Duisburg, Germany
Contact:

Post by Striker » Wed Mar 01, 2006 12:26 pm

Das War3FT Modul wird nicht mehr benötigt.

Poste mal deine war3FT.cfg und die Logs von AMXX.

Odium
Peon
Posts: 11
Joined: Wed Mar 01, 2006 1:27 am

Post by Odium » Wed Mar 01, 2006 12:38 pm

Das hier ist die war3FT.cfg

// Warcraft 3 Frozen Throne Configuration File

mp_savexp 1 // Enables saving of experience (uses a vault, default is 0)
sv_sql 1 // Save using a SQL module (a module needs to be turned on, note: to use this mp_savexp must also be 1, default is 0)
FT_saveby 0 // What should I save this as? steam id = 0, IP = 1, name = 2 (default is 0)

// SQL configuration
FT_sql_host "127.0.0.1" // Host Name
FT_sql_user "WC3XP" // User Name
FT_sql_pass "warpoints" // Password
FT_sql_db "wc3" // Database Name
sv_mysql_auto_pruning 0 // Automatically prunes the database of old users at a mapchange occuring between 5:36 to 5:59 AM (default is 0, doesn't work for vault)
sv_daysbeforedelete 90 // However many days before deleting XP or pruning from MySQL database (default is 31)
sv_mysqltablename "war3users" // Table Name, no need to change (default is war3users)
sv_mysql_save_end_round 1

// Experience options
mp_xpmultiplier 1.0 // set the level required to gain a level as a multiple (default 1.0)
mp_weaponxpmodifier 1 // gives additional XP for using certain weaker weapons (default is 1)
FT_min_b4_XP 1 // Minimum amount of players needed b4 awarding XP (default is 2)
FT_objectives 1 // If enabled, will display message in chat to show XP they gain for completing certain objectives (default is 1)
FT_kill_objectives 0 // Shows how much XP you gain for killing someone (each kill, default is 0)
FT_bombplanterxp 1 // XP given for planting the bomb (default is 15)
FT_defusexp 3 // XP given for defusing the bomb (default is 30)
FT_hostagexp 2 // XP given for helping to rescue the hostages (default is 25)
FT_killrescuemanxp 2 // XP given for killing the person rescuing the hostages (default is 25)
FT_xpbonus 5 // XP given for purchasing tome of experience (default is 50)
FT_kill_bomb_carrier_bonus 2 // XP given for killing the bomb carrier (default is 25)
FT_defuser_kill_bonus 2 // XP given for killing the defuser (default is 25)
FT_VIP_kill_bonus 2 // XP given for killing the VIP (default is 25)
FT_VIP_escape_bonus 3 // XP given when the VIP escapes (default is 30)
FT_headshot_bonus 9 // XP given for getting a headshot (default is 9)
FT_xp_radius 750 // Radius to give XP to teammates near where the special objective is completed (rescued hosties, bomb planted, killed vip, vip escaped, default is 750)
FT_round_win_XP 3 // Experience given to the winning team (default is 35)
FT_autoxp 0 // With this option set to 1, the joining players will receive the average amount of XP that all of the players have (SHORT TERM XP ONLY, default is 0)

// Game Play Enhancements
sv_warcraft3 1 // Set this to 0 to disable warcraft (default is 1)
mp_grenadeprotection 1 // Only 1 HE grenade will be allowed for purchase per round (default is 0)
FT_position 0 // 0 is for left, 1 is for right (where to put the information for those spectating, default is 0)
FT_centerhud 1 // Automatically makes the hud be centered (message that shows xp/race/level, default is 1)
FT_items_in_hud 0 // Display items w/a HUD message (this will take up 1 of the 4 channels, default is 0)
FT_spec_info 1 // Show Spectating information for dead players (default is 1)
FT_show_icons 1 // Shows icons on your screen when your ultimate is ready (default is 1)
FT_race_icons 1 // Allow users to type /icons to show player icons above the player (default is 1)
FT_level_icons 1 // Allow users to type /icons to see player levels above the player (default is 1)
FT_CD 0 // If set to 1, it will not allow players without Cheating Death to play this mod (default is 0)
FT_buyzone 0 // Restrict purchasing shopmenu items to within the buyzone? (default is 0)
FT_buytime 0 // Restrict purchasing shopmenu items to within the buytime? (default is 0)
FT_buydead 1 // Allow users to purchase items when dead? (default is 1)
FT_show_player 1 // Show teammate and enemy information in the center of the screen when they are on target? (not for DOD, default is 1)
FT_query_client 1 // Check user's cl_minmodel cvar every second (default is 1)

// TYPE OF WARCRAFT (If race 4 or 5 is selected, messsages will say WAR3 instead
// of saying WAR3FT, also shopmenu2 will be disabled, as well as saying rings and ability)
FT_races 8 // Number of races (if races are less than 5, the second shopmenu will be disabled (4 is standard war3), default is 8)

// ****************************************************************************************************
// ABILITY ENHANCEMENTS
// ****************************************************************************************************

// Chameleon Race Configuration Options (Race 9)
// This race allows you to either assign skills that will be permanent, or random skills will be chosen each round
FT_Race9_Random 1 // Should the 9th race have random skills each round?, if so the next 4 option are irrelevant (default is 1)
FT_Race9_Skill1 1 // What race should the first skill be taken from? (default is 1)
FT_Race9_Skill2 1 // What race should the second skill be taken from? (default is 1)
FT_Race9_Skill3 1 // What race should the third skill be taken from? (default is 1)
FT_Race9_Ultimate 1 // What race should the ultimate be taken from? (default is 1)


// Skill and Ultimate configurations
FT_ultimatedelay 15.0 // Amount of time (in seconds) to delay the ultimates at the start of each round (default is 15.0)
FT_healing_range 750 // Range for Healing Wave to jump from player to player and heal (default is 750)
FT_ultimate_cooldown 35.0 // Cooldown of all ultimates (default is 35.0)
FT_warn_suicide 1 // Tells Undead Scourges their bomb is armed when they hit ultimate key, a second key press then detonates it (default is 1)
FT_blinkenabled 1 // Use blink instead of team teleport (default is 1)
FT_blink_protection 1 // slays people who abuse blink on some maps (skywalking, map exploiting, default is 1)
FT_blink_radius 500 // Enemies who have immunity w/in this radius will cause blink to fail (default is 500)
FT_blink_dizziness 1 // What type of diziness? (1 or 0 is flashbang effect, 2 is fading blue screen, default is 1)
FT_entangle_drop 0 // Should the player's primary weapon be dropped when they are entangled? (default is 0)
FT_impale_intensity 10 // Setting this to a lower non-negative number will lower the intensity of impale (default is 10)

// Item configurations
FT_glove_timer 10 // Interval between receiving a new grenade with the Flaming Gloves of Warmth (default is 10)
FT_no_gloves_on_ka 1 // Prevents Flaming gloves of warmth on ka maps and scoutzknivez (default is 1)
FT_glove_orc_damage 0 // When using gloves, should orcs be given the critical dmg? (Default is 0)
FT_no_orcnades 0 // Prevent orc nades on ka_ maps, fy_ maps and jail_riot (default is 0)
FT_claw 6 // Damage done by Claws of Attack (default is 6)
FT_bootspeed 275.0 // Speed given for purchasing boots of speed (different for dod, see dod section, default is 275)
FT_health_bonus 15 // Health bonus given for periapt of health (default is 15)
FT_frost_speed 125.0 // Speed of victim when attacked with Orb of Frost (default is 125.0)
FT_mask_of_death 0.2 // Percentage of like gained back by mask of death (default is 0.3)
FT_cloak 150 // Invisibility given with cloak, lower is more invisible (default is 150)
FT_sock 0.5 // Gravity level for Sock of the Feather

// Bot Configuration Options
FT_bot_buy_item 0.33 // Chance of a bot buying a shopmenu item at the beginning of the round (default is 0.33)

// DOD Options
DOD_startmoney 800 // Starting "fake" money for dod
DOD_bootspeed 45.0 // Stamina given for boots of speed in Day of Defeat (default is 45.0)



Und das hier kommt wenn ich die neu compilierte reinschmeiss bei amxx
L 03/01/2006 - 17:46:23: [AMXX] Plugin "warcraft3FT.amxx" failed to load: Module "dodfun" required for plugin. Check modules.ini.

nur ich hab ja die gleiche sma genommen.... :(

User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

Post by Geesu » Wed Mar 01, 2006 12:53 pm

using the wrong compiled version
No Support via PM

DarkJP2
Rifleman
Posts: 163
Joined: Tue Jul 26, 2005 3:18 pm
Location: Swiss

Post by DarkJP2 » Wed Mar 01, 2006 1:44 pm

Odium falls du den fehler suchst, such mal nach:
#define MOD
(ist in der .sma)

Odium
Peon
Posts: 11
Joined: Wed Mar 01, 2006 1:27 am

Post by Odium » Thu Mar 02, 2006 7:48 am

Hallo,

habe den Mod nun richtig gesetzt und dann nochmal kompiliert.

Nun hat die amxx datei auch funktioniert, nur als ich dann die neue hochgeladen habe, hat er anstatt bei 1000 XP level 1 schon bei 100 XP level 1 gegeben. Auch war das savexp nicht mehr an. Jede Runde musste man von null anfangen. Die War3FT.cfg war aber immer noch gleich eingestellt.

Kann man jemand von euch über ICQ erreichen ? Dann kann ich ihm vielleicht auch mal den kompletten amxmodx Ordner zukommen lassen und er kann sich das anschauen.

Gruß

DarkJP2
Rifleman
Posts: 163
Joined: Tue Jul 26, 2005 3:18 pm
Location: Swiss

Post by DarkJP2 » Thu Mar 02, 2006 8:06 am

post mal die log datei

die logs findest du unter addons\amxmodx\logs

Odium
Peon
Posts: 11
Joined: Wed Mar 01, 2006 1:27 am

Post by Odium » Thu Mar 02, 2006 9:05 am

JUHUUU :)

Es geht nun endlich.

Nur sind nun die XP komisch eingestellt...

Vorher hat man erst bei 1000 XP Lvl 1 bekommen. nun schon bei 100


Muss ich das in der Datei xp.inl noch ändern ?

Odium
Peon
Posts: 11
Joined: Wed Mar 01, 2006 1:27 am

Post by Odium » Thu Mar 02, 2006 9:27 am

Hmm, hab das gerade probiert.

Aber dann kann ich die sma wieder nicht kompilieren wenn ich da was ändere.

Wenn ich es in der War3FT.cfg umstelle (den multiplier), also so dass man level 1 bei 1000 XP erst bekommt, dann liegt die Höhe von Level 10 bei über 500000

Hätte das gerne wieder bei um die 70000 gehabt.

Wo genau kann ich die Änderungen nun machen dass ich die einzelnen Level Stufen selbst anpassen kann ?

DarkJP2
Rifleman
Posts: 163
Joined: Tue Jul 26, 2005 3:18 pm
Location: Swiss

Post by DarkJP2 » Thu Mar 02, 2006 9:35 am

such nach:

// If we're saving XP, we want to set the max. amount of XP higher and the amount gained per kill/objective lower
if ( iCvar[MP_SAVEXP] )
{
xpgiven = {6,8,10,12,14,16,18,20,24,28,32};
xplevel = {0,100,200,400,800,1600,3200,6400,12800,25600,51200};
}

da kannst du dann frei dran rumschrauben

Odium
Peon
Posts: 11
Joined: Wed Mar 01, 2006 1:27 am

Post by Odium » Thu Mar 02, 2006 9:39 am

Da hab ich bei xplevel schon rumgemacht. Nur konnte ich danach die sma komischerweise nicht mehr kompillieren. Da kam nen Fehler.

DarkJP2
Rifleman
Posts: 163
Joined: Tue Jul 26, 2005 3:18 pm
Location: Swiss

Post by DarkJP2 » Thu Mar 02, 2006 9:42 am

xpgiven = {60,80,1000,120,140,160,180,200,240,280,320};
xplevel = {0,1000,2000,4000,8000,16000,32000,64000,128000,256000,512000};

btw so dauerts gleich lang wie vorher

Odium
Peon
Posts: 11
Joined: Wed Mar 01, 2006 1:27 am

Post by Odium » Thu Mar 02, 2006 9:55 am

Hmm, komisch, habe es nochmal probiert, nun geht es :)

Ok, ich glaube das wars dann

Hab die Abschusspunkte so gelassen :D

nur die Punkte wo man die Levels erreicht so hoch gesetzt, ist bisschen anspruchsvoller

Ich danke Dir für Deine hilfe !!!!

Post Reply