Where does the XP Save to?

Want to talk about war3ft or make suggestions? Post them here

Moderator: Forum Moderator

Post Reply
hsungyoon7
Peon
Posts: 3
Joined: Sat Jun 23, 2007 10:20 am

Where does the XP Save to?

Post by hsungyoon7 » Sat Jun 23, 2007 12:51 pm

Hello...I was wondering...Where does all the people saved XP goto? which file? i just can't seem to find it...can anyone help me?

My WC3 FT server:
12.47.45.77:27015

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Post by YamiKaitou » Sat Jun 23, 2007 12:55 pm

Depends on how you are saving it. What version of War3ft are you using and I can help you better
Image

No support via PM or Email

hsungyoon7
Peon
Posts: 3
Joined: Sat Jun 23, 2007 10:20 am

Post by hsungyoon7 » Sat Jun 23, 2007 12:57 pm

This is the version i use: cs_cz_war3ft_v3.0rc7

Please help me out..thank you..lol

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Post by YamiKaitou » Sat Jun 23, 2007 1:07 pm

What is the value of the cvar "wc3_save_xp_db" ?
Image

No support via PM or Email

hsungyoon7
Peon
Posts: 3
Joined: Sat Jun 23, 2007 10:20 am

Post by hsungyoon7 » Sat Jun 23, 2007 1:17 pm

THis is what it says
wc3_save_xp_db 0 // How should we save XP? (0 = SQLite, 1 = MySQL)

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Post by YamiKaitou » Sat Jun 23, 2007 1:18 pm

The xp is saved to a binary file located in addons/amxmodx/data/sqlite3

You can not read this file by any means. It can only be read by a plugin
Image

No support via PM or Email

User avatar
kevlartester
Militia
Posts: 75
Joined: Tue Nov 14, 2006 10:26 am
Location: Germany
Contact:

Post by kevlartester » Sat Jun 23, 2007 3:50 pm

is there a possibility to backup these files?
for example when saving to nvault in the old versions you could download the vault files...something equal possible with sqlite?
Image

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Post by YamiKaitou » Sat Jun 23, 2007 5:20 pm

Yeah, just download the sq3 files in that folder
Image

No support via PM or Email

User avatar
kevlartester
Militia
Posts: 75
Joined: Tue Nov 14, 2006 10:26 am
Location: Germany
Contact:

Post by kevlartester » Sun Jun 24, 2007 2:52 am

xD
last time i had a look into this folder (should have been rc6) there was no file...
whatever...now there is one...thx
Image

SmokingJoePot
Peon
Posts: 12
Joined: Sat Aug 18, 2007 6:58 pm
Location: Dallas TX
Contact:

Post by SmokingJoePot » Sat Aug 18, 2007 7:05 pm

which is the best way to save? like if I don't know what my SQL is? Should I use nvault?

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Post by YamiKaitou » Sat Aug 18, 2007 9:30 pm

nVault is gone. SQLite is somewhat the same, just SQL based. Anyone can save to SQLite, nothing extra is needed
Image

No support via PM or Email

SmokingJoePot
Peon
Posts: 12
Joined: Sat Aug 18, 2007 6:58 pm
Location: Dallas TX
Contact:

Post by SmokingJoePot » Sun Aug 19, 2007 4:21 pm

ok, so what do I enable, I'm convinced to change it to SQLite. But fIrst, I wanna get this straight, there is no more nvault? Also, when using SQLite, I can save everybody who plays on my server's experince so they can come back and play with the same experience and when then they get to level 10, everybody else is who is new joining the server is gonna have an unfair advantage wouldn't they?

I'm just wanting to save between rounds, not everytime I get on and off, cause I don't want to save everybodies experience so it'll be there when they come back. It would only be fair to let them level up like everybody else.

SmokingJoePot
Peon
Posts: 12
Joined: Sat Aug 18, 2007 6:58 pm
Location: Dallas TX
Contact:

Post by SmokingJoePot » Sun Aug 19, 2007 4:27 pm

So far I know to enable SQLite on modules.ini by taking the ; way from the sqlite_ammx.dll, and then in war3FT.cfg change how do we save EXP? to number 2 which is SQLite, is that correct? and then what else do i do?

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Post by YamiKaitou » Sun Aug 19, 2007 8:41 pm

First, upgrade your AmxModX files. If you have sqlite_amxx.dll in the modules.ini file that is a sign that you may be using an out of date version. Then, look in the war3ft.cfg file. It should tell you everything you need to know in there
Image

No support via PM or Email

User avatar
unnamed_ro
Peon
Posts: 14
Joined: Fri Nov 11, 2005 3:44 pm

re all

Post by unnamed_ro » Mon Aug 20, 2007 10:29 am

I have a problem related to this one

My server :AMXX v1.01, MM v1.17.2, FTWC3 v2.2.2

On my server everibody has level 10 on all races for some reason..

What am i dooing wrong?

This is my war.cfg i wanted to have a savexp with automatic save but it does not seem to work


// Warcraft 3 Frozen Throne Configuration File


// Saving Options

wc3_save_xp 1 // Enables saving of experience (default is 0)
wc3_save_xp_db 1 // How should we save XP? (0 = SQLite, 1 = MySQL)

wc3_save_by 1 // What should I save this as? steam id = 0, IP = 1, name = 2 (default is 0)
wc3_save_pruning 0 // Automatically prunes the database of old users at a mapchange (default is 0)
wc3_days_before_delete 31 // However many days before deleting XP or pruning from the database (default is 31)
wc3_save_end_round 1 // Save xp at the end of each round (may cause lag, default is 1)


// SQL Database Information

wc3_sql_dbhost "localhost" // Host Name
wc3_sql_dbuser "root" // User Name
wc3_sql_dbpass "" // Password
wc3_sql_dbname "" // Database Name


// Admin Options

wc3_admin_flag "m" // Admin flag required to give/take XP (default is m)


// Experience Options

wc3_xp_multiplier 1.0 // set the level required to gain a level as a multiple (default 1.0)
wc3_xp_weap_multiplier 1 // Award XP based on the weapon used (default is 1)
wc3_min_players 2 // Minimum amount of players needed b4 awarding XP (default is 2)
wc3_ignore_bots 0 // Should you ignore bots when calculating the minimum players required to gain xp? (default is 0)
wc3_xp_auto_average 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)
wc3_show_objectives 1 // If enabled, will display message in chat to show XP they gain for completing certain objectives (default is 1)
wc3_show_kill_obj 0 // Shows how much XP you gain for killing someone (each kill, default is 0)
wc3_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)


// Game Play Enhancements

wc3_races 8 // Number of races (if races are less than 5, the second shopmenu will be disabled (4 is standard war3), default is 8)
wc3_grenade_protection 0 // Only 1 HE grenade will be allowed for purchase per round (default is 0)
wc3_spec_position 0 // 0 is for left, 1 is for right (where to put the information for those spectating, default is 0)
wc3_buy_zone 0 // Restrict purchasing shopmenu items to within the buyzone? (default is 0)
wc3_buy_time 0 // Restrict purchasing shopmenu items to within the buytime? (default is 0)
wc3_buy_dead 1 // Allow users to purchause items when dead? (default is 1)
wc3_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)
wc3_query_client 1 // Check user's cl_minmodel cvar every second (default is 1)
wc3_cheats 0 // Enable cheats for wc3? (default is 0)
wc3_psychostats 1 // Print psychostats information to log files for wc3 abilities? (default is 0)
wc3_start_level 0 // What level should all players start at when joining? (default is 0)

// Icon Options (displayed above player's head)

wc3_race_icon 1 // Allow users to type /icons to show player icons above the player (default is 1)
wc3_level_icon 1 // Allow users to type /icons to see player levels above the player (default is 1)


// Chameleon Race Configuration Options - see _chameleon.txt for more information

wc3_cham_random 1 // Should the 9th race have random skills each round?, if so the next 4 option are irrelevant (default is 1)
wc3_cham_skill1 14 // What skill ID for skill 1?
wc3_cham_skill2 0 // What skill ID for skill 2?
wc3_cham_skill3 6 // What skill ID for skill 3?
wc3_cham_ultimate 7 // What skill ID for the user's ultimate?
wc3_cham_passive 20 // What skill ID for the user's passive skill?


// Skill and Ultimate configurations

wc3_ult_delay 15.0 // Amount of time (in seconds) to delay the ultimates at the start of each round (default is 15.0)
wc3_ult_cooldown 35.0 // Cooldown of all ultimates (default is 35.0)
wc3_blink_protection 1 // slays people who abuse blink on some maps (skywalking, map exploiting, default is 1)
wc3_blink_dizziness 0 // What type of diziness? (0 is flashbang effect, 1 is fading blue screen, default is 0)
wc3_entangle_drop 0 // Should the player's primary weapon be dropped when they are entangled? (default is 0)


// Item configurations

wc3_glove_timer 10 // Interval between receiving a new grenade with the Flaming Gloves of Warmth (default is 10)
wc3_glove_orc_damage 0 // When using gloves, should orcs be given the critical dmg? (Default is 0)
wc3_boots 0.10 // Percentage increase given by boots (.10 = 10%, default is 0.10)
wc3_claw 6 // Damage done by Claws of Attack (default is 6)
wc3_health 15 // Health bonus given for periapt of health (default is 15)
wc3_frost 125.0 // Speed of victim when attacked with Orb of Frost (default is 125.0)
wc3_mask 0.3 // Percentage of life gained back by mask of death (default is 0.3)
wc3_cloak 150 // Invisibility given with cloak, lower is more invisible (default is 150)
wc3_sock 0.5 // Gravity level for Sock of the Feather (default is 0.5)
wc3_tome 50 // XP given for purchasing tome of experience (default is 50)


// Bot Configuration Options

wc3_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

wc3_dod_start_money 800 // Starting money for dod

And this is my 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.dll
fun_amxx_amd64.so

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

; ----------------------------------------------------------
; Fakemeta - provides a massive interface into the HL engine
; ----------------------------------------------------------
fakemeta_amxx_i386.so
fakemeta_amxx.dll
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
;pgsql_amxx.dll
; Microsoft SQL
;mssql_amxx.dll
; SQLite
;sqlite_amxx.dll
;sqlite_amxx_i386.so
;sqlite_amxx_amd64.so

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

; ------------------------------------
; Array - advanced arrays in scripting
; ------------------------------------
;array_amxx_i386.so
;array_amxx.dll
;array_amxx_amd64.so

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

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

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

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

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

ps: in hlsw console i can see on map start this: IP Descriptions file not found!
19:33:35 IP Descriptions file not found!

can this be the problem?
"The worst is death,
and death will have its day.."

William Shakespeare (1564 - 1616)

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Post by YamiKaitou » Mon Aug 20, 2007 11:45 am

Upgrade your files. Why are you still using an out-dated everything?
Image

No support via PM or Email

User avatar
mannisch
Peon
Posts: 24
Joined: Sat Jun 03, 2006 4:05 am
Location: Germany
Contact:

Post by mannisch » Mon Sep 10, 2007 12:50 pm

As Yamikaitou said, it´s pretty much outdated...

Nevertheless, it should maybe work...
You have defined in the WC3 config to save by mySQL, but you didn´t set up any mySQL Database information.
I think you want to save it in vault? So change the wc3_save_xp_db to 0.

But i am wondering about, you say its WC3FT V2.x.x, this doesn´t support mySQL???
This is a config from WAR3FT V3.0??? This does not work with such an old amxx.

You should delete all and install it new... :roll: :roll: :roll:
It´s confusing what you have posted here...

Post Reply