Archived copy of war3source.com, the War3Source forum (2009–2020), rebuilt from the Internet Archive by wc3mods.net. This page was captured on 2012-09-22 (original capture). Forum · All archived topics · Wiki · Bug tracker · Blog
Chat

War3:Source
September 21, 2012, 10:01:36 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Download: http://war3source.com/index.php?board=9.0
What is War3Source?: http://war3source.com/index.php?topic=200.0
Sample Stats: http://war3source.com/war3stats
Steam Community Group: http://steamcommunity.com/groups/war3source
War3Source SVN Checkout: http://ownageclan.com/svn/war3source/
War3Source servers: http://www.game-monitor.com/search.php?vars=war3_version=
 
   Home   Help Search Login Register  
Pages: [1] 2
  Print  
Author Topic: 1.1.5 BETA 2+ DB CHANGE  (Read 3181 times)
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2032



View Profile WWW Email
« on: July 24, 2010, 08:57:46 AM »

if ur locust swarm or claws deal 0 damage, please tell us!




BETA 2 CONTAINS A DATABASE CHANGE. IT IS REQUIRED BECAUSE WE WILL RUN INTO SCALING ISSUES FOR LARGE NUMBER OF RACES

>>>>>>------READ ALL OF THE FOLLOWING BEFORE YOU PROCEED--------<<<<<<<

WE RECOMMEND YOU UPDATE WHEN THE SERVER IS EMPTY/ WHEN ITS AT THE LOWEST ACTIVITY OF THE DAY

LOAD THE  war3source_convertDB_useONCE.smx ONCE ON YOUR SERVER ALONG WITH OTHER NEW *.SMX FILES (DO A HARD BOOT)
XP AND LEVELS WILL BE CONVERTED FROM YOUR OLD TABLE TO NEW TABLE, SKILL LEVELS ARE NOT SAVED, 0 ENTRIES WILL NOT BE SAVED. YOUR OLD XP WILL BE LEFT INTACT IN CASE YOU NEED TO GO BACK TO OLD VERSION

SEE YOUR ERROR LOG FOR CONVERSION PROCESS BECAUSE THE SERVER WILL APPEAR TO BE FROZEN AND NOT RESPOND: SAMPLE ENTRY
L 07/24/2010 - 00:54:48: [w3s\war3source_convertDB.smx] This Race: 3900 / 4270  INSERT INTO war3source_racedata1 (steamid,raceshortname,level,xp) VALUES ('STEAM_0:0:19xxxxx','undead','9','1763')

POPULATED SERVER CONVERSION SHOULD TAKE 5-10 MINUTES

IF YOUR SERVER PROVIDER TRIES TO RESTART YOUR SERVER BECAUSE ITS NOT RESPONDING DURING THIS TIME, DISABLE THE FEATURE IF POSSIBLE OR LET US CONVERT IT UP FOR YOU (REPLY HERE WE WILL GIVE YOU OPTIONS)

REMOVE war3source_convertDB.smx WHEN ITS DONE. SEE THE ERROR LOG TO CONFIRM THAT ITS ACTUALLY FULLY COMPLETED AND NOT THAT THE SERVER RESTARTED BY YOUR CONTROL PANEL.

POST HERE FOR CONVERSION HELP

-----------------------
-----------------------
-----------------------
download @ www.ownageclan.com/war3source

1.1.5

B9

(public release)

minor crypt lord changes to fix retriggering issues

fixed being able to buy with say when item is restricted

Engine 4 deals with weapons (especially restrictions)
native War3_WeaponRestrictTo(client,String:onlyallowedweaponsnames[]);
ie "weapon_knife,weapon_hegrenade" //c4 automatically allowed

separated some include files

war3_print_levelbank_spawn 1 (default 0)
to print player's levelbank every spawn if they have any

default auto save time reduced to 60
auto save will no longer print to chat by default ( war3_print_on_autosave 0 )

dev1

merge sort algorithm for sorting your races by min level! maintains relative order!
war3_sort_minlevel 0

buff bFlyModeDeny

armor buffs fPhysArmor, fMagicArmor are now used in DealDamage (maybe also in normal game damage later)
both scales according to http://honwiki.net/wiki/Armor

stock print skill message  and damage functions (see interface)

cvar for bonus xp for level difference (war3_xp_level_difference_bonus)*(level difference) if victim's level is higher

removed OnRaceChanged
please change it to OnRaceSelected

revivals (mage, orc) allows guns to have full ammo



B8FIX 1
reverted war3_dealdamage back to creating an entity each time

B8

crypt lord spiked carapace will deal damage to its attacker, and other minor changes with spiked carapace

races can be reloaded on the fly, use: sm plugins list, sm plugins reload #, and server command "loadraces" to reload a race.

force redefinition of MAXPLAYERS

changed all 65 and 66 arrays to use MAXPLAYERS

increase human teleport check time

race limits per team:
war3_racelimit_enable 1 (default 1)
war3_SHORTNAME_team1_limit X (default 99)
war3_SHORTNAME_team2_limit X (default 99)

auto join race will be disabled when race limits are enabled

races set by admins do not count towards race restrictions

B7
new buffs
bSilenced,//cannot use skills
bStunned, //cannot shoot, cannot cast, cannot move
bBashed, //cannot move
bDisarm,//cannot shoot
bNoMoveMode,//move type none! overrrides all other movestypes
bFlyMode, //fly mode!

War3_ValidPlayer is now a stock instead of a native

point_hurt entity is not recreated for War3_DealDamage, other optimizations

team name and level in players with this race list

Engine 2 for tracing view end point (untested)

B6

skills limit increased to 7

playerinfo shows race on the name

No Race name for race id 0

added naix sounds

naix teleport location will be cached death location of the victim (which does not equal the abs origin right after he died)

naix will  telepeort to victim location only if he is ducking

added mask of death sound, implements War3_TrackDelay for not alowing sound to be re emiited under a .3 second delay

mask of death now calculates correct leech amount via PostHurt instead of theoretical TakeDamage

B5
increased default XP rewarded for objectives (cvars)

added level bank for new players, cvar for level bank default is 30. DB failure will not trigger free levelbank

show levelbank amount  in changerace menu if he has any

more info added to playerinfo and skillsinfo like max level and skill level

playerinfo can direct people to a menu about his current race

raceinfo can direct people to a menu about all people who are currently that race

fixed a naix print message

tweaks to the CD electric tide animation

forcing save xp on race set

B4 Dev

added native War3_GetRaceIDByShortname(String:raceshortname[]);


B4

cvar war3_SHORTRACENAME_restrict_items "claw,orb"   to prevent people from buying the listed items if they are that race
restricted items for race is checked on spawn, and will be removed without refund


removed many "public " keywords for performance (minor)

buy via say or team say command using item shortname. extra characters after the shortname are accepted "boot" "boots" "bootwtf"

reverted race change to at death. race will be changed at spawn or death (after OnWar3EventDeath so u can do some last minute stuff right here before his race changes)

TRUE/MAGIC damage via War3_DealDamage in CS will remove CS armor and reapply CS armor, PHYSICAL will have to go through armor
War3_DealDamage will use HP comparison for getting the damage dealt if victim is still alive after damage, otherwise war3 physical and magic armor reduced damge is considered the damage dealt

increased CS undead suicide bomber max damage by 66 at every level (166 - 266 theoretical max dmg, reduced via CS armor)
For enemies with Full HP full armor you basically have to be touching for instant kill, the armor basically reduce half the damage.
suicide bomber damage count as PHYSICAL

welcome menu changes


B3

fixed cooldown manager not managing the last race for spawn and death expirations

better handling of level check

increased CD overload range
added CD overload zap sound

fixed CD not tracing correctly in CS
CD ultimate overload will double the zaps per second in CS for the same duration

fixed weapon fire event preventing tf2 load

moved cooldown manager and created delay tracker into its own plugin (engine 1)

added sound for CD ult state

fixed cd ult not damageing the lowest hp target

War3_DealDamage now REQUIRES a weapon name, this is likely to break backwards compatability on compile, but those that are already compiled will work fine



B2

DATABASE CONVERSION
(use DB converter once and once only)
all xp are stored in one table, and one main table for other player data
xp is saved for one race only (1 query), and if you change race ur old race xp will be saved

sql separation for saving and retrieving parts

set race on join is now default 0

fixed Sr ultimate cvar

fixed weapon fire event for attack speed (CS)

playerinfo can accept name argument

levelbank adding fix

war3sourceraces insert will be threaded
« Last Edit: August 05, 2010, 09:05:59 AM by Ownz » Logged

DarkEnergy
[Oddity]TeacherCreature
Sr. Member
****
Posts: 461


View Profile
« Reply #1 on: July 24, 2010, 10:15:47 AM »

SKILL LEVELS ARE NOT SAVED,

Huh
Logged

Ownz
Developer
Administrator
Hero Member
*****
Posts: 2032



View Profile WWW Email
« Reply #2 on: July 24, 2010, 10:17:37 AM »

which skills they have leveled, cuz thats complicated, they just have to  rechoose their skills which aint hard
Logged

DarkEnergy
iceman
Full Member
***
Posts: 160



View Profile
« Reply #3 on: July 25, 2010, 10:45:36 AM »

I have a pub server and a small test server with a shared database. Do i run the db converter.smx on my test server then just add the new version to my pub server?
Logged
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2032



View Profile WWW Email
« Reply #4 on: July 25, 2010, 10:58:46 AM »

u sure can, ur tests server can convert, after its done upgrade ur pub server and viola
Logged

DarkEnergy
iceman
Full Member
***
Posts: 160



View Profile
« Reply #5 on: July 25, 2010, 11:03:32 AM »

alrighty then thanks
Logged
iceman
Full Member
***
Posts: 160



View Profile
« Reply #6 on: July 25, 2010, 11:27:05 AM »

getting these on startup now

Quote
L 07/25/2010 - 13:08:49: SourceMod error session started
L 07/25/2010 - 13:08:49: Info (map "cp_well") (file "errors_20100725.log")
L 07/25/2010 - 13:08:49: [SM] Native "HookEvent" reported: Game event "weapon_fire" does not exist
L 07/25/2010 - 13:08:49: [SM] Displaying call stack trace for plugin "War3Source\War3Source.smx":
L 07/25/2010 - 13:08:49: [SM]   
  •   Line 90, W3SIncs/events.inc::War3Source_HookEvents()
L 07/25/2010 - 13:08:49: [SM]   [1]  Line 123, S:\Programming\SCRIPTINGSMX\War3SourcePv2\War3Source.sp::OnPluginStart()
L 07/25/2010 - 13:08:49: [SM] Native "War3_GetGame" reported: Plugin owning this native is currently paused.
L 07/25/2010 - 13:08:49: [SM] Displaying call stack trace for plugin "War3Source\War3Source_007_Warden.smx":
L 07/25/2010 - 13:08:49: [SM]   
  •   Line 79, War3Source_007_Warden.sp::OnPluginStart()
L 07/25/2010 - 13:09:05: [SM] Native "War3_GetGame" reported: Plugin owning this native is currently paused.
L 07/25/2010 - 13:09:05: [SM] Displaying call stack trace for plugin "War3Source\War3Source_001_UndeadScourge.smx":
L 07/25/2010 - 13:09:05: [SM]   
  •   Line 167, War3Source_001_UndeadScourge.sp::OnMapStart()
L 07/25/2010 - 13:09:06: [SM] Native "War3_ValidPlayer" reported: Plugin owning this native is currently paused.
L 07/25/2010 - 13:09:06: [SM] Displaying call stack trace for plugin "War3Source\War3Source_011_BloodHunter.smx":
L 07/25/2010 - 13:09:06: [SM]   
  •   Line 151, War3Source_011_BloodHunter.sp::RuptureCheckLoop()
L 07/25/2010 - 13:09:06: [SM] Native "War3_ValidPlayer" reported: Plugin owning this native is currently paused.
L 07/25/2010 - 13:09:06: [SM] Displaying call stack trace for plugin "War3Source\War3Source_011_BloodHunter.smx":
L 07/25/2010 - 13:09:06: [SM]   
  •   Line 151, War3Source_011_BloodHunter.sp::RuptureCheckLoop()
L 07/25/2010 - 13:09:06: [SM] Native "War3_ValidPlayer" reported: Plugin owning this native is currently paused.
L 07/25/2010 - 13:09:06: [SM] Displaying call stack trace for plugin "War3Source\War3Source_011_BloodHunter.smx":
L 07/25/2010 - 13:09:06: [SM]   
  •   Line 151, War3Source_011_BloodHunter.sp::RuptureCheckLoop()
L 07/25/2010 - 13:09:06: [SM] Native "War3_ValidPlayer" reported: Plugin owning this native is currently paused.
L 07/25/2010 - 13:09:06: [SM] Displaying call stack trace for plugin "War3Source\War3Source_011_BloodHunter.smx":
L 07/25/2010 - 13:09:06: [SM]   
  •   Line 151, War3Source_011_BloodHunter.sp::RuptureCheckLoop()
L 07/25/2010 - 13:09:07: [SM] Native "War3_ValidPlayer" reported: Plugin owning this native is currently paused.
L 07/25/2010 - 13:09:07: [SM] Displaying call stack trace for plugin "War3Source\War3Source_011_BloodHunter.smx":
L 07/25/2010 - 13:09:07: [SM]   
  •   Line 151, War3Source_011_BloodHunter.sp::RuptureCheckLoop()
L 07/25/2010 - 13:09:07: [SM] Native "War3_ValidPlayer" reported: Plugin owning this native is currently paused.
L 07/25/2010 - 13:09:07: [SM] Displaying call stack trace for plugin "War3Source\War3Source_011_BloodHunter.smx":
L 07/25/2010 - 13:09:07: [SM]   
  •   Line 193, War3Source_011_BloodHunter.sp::BloodCrazyDOTLoop()
L 07/25/2010 - 13:09:07: [SM] Native "War3_ValidPlayer" reported: Plugin owning this native is currently paused.
Logged
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2032



View Profile WWW Email
« Reply #7 on: July 25, 2010, 11:58:48 AM »

damn tf, ill come up with a fix asap
Logged

DarkEnergy
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2032



View Profile WWW Email
« Reply #8 on: July 25, 2010, 12:02:36 PM »

you can remove line 90 in events.inc and compile
HookEvent("weapon_fire",WeaponFireEvent, EventHookMode_Pre); //CS
Logged

DarkEnergy
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2032



View Profile WWW Email
« Reply #9 on: July 25, 2010, 09:13:04 PM »

beta 3 is out
Logged

DarkEnergy
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2032



View Profile WWW Email
« Reply #10 on: July 26, 2010, 12:12:25 PM »

BETA 4
Logged

DarkEnergy
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2032



View Profile WWW Email
« Reply #11 on: July 27, 2010, 03:20:35 PM »

beta 5
Logged

DarkEnergy
saintk
Jr. Member
**
Posts: 71


View Profile Email
« Reply #12 on: July 28, 2010, 05:01:33 AM »

Hi,

When i try to do this update it spams this:

L 07/28/2010 - 12:55:15: [SM] Native "War3_ValidPlayer" reported: Plugin owning this native is currently paused.
L 07/28/2010 - 12:55:15: [SM] Displaying call stack trace for plugin "War3Source_011_BloodHunter.smx":
L 07/28/2010 - 12:55:15: [SM]   
  •   Line 151, War3Source_011_BloodHunter.sp::RuptureCheckLoop()
L 07/28/2010 - 12:55:49: [SM] Native "War3_GetRacesLoaded" reported: Plugin owning this native is currently paused.
L 07/28/2010 - 12:55:49: [SM] Displaying call stack trace for plugin "war3source_convertDB_useONCE.smx":
L 07/28/2010 - 12:55:49: [SM]   
  •   Line 90, war3source_convertDB.sp::next1()
L 07/28/2010 - 12:55:49: [SM]   [1]  Line 79, war3source_convertDB.sp::convert()


afterwards i get this when booting:

 07/28/2010 - 12:59:12: [SM] Native "War3_ValidPlayer" reported: Plugin owning this native is currently paused.
L 07/28/2010 - 12:59:12: [SM] Displaying call stack trace for plugin "War3Source_011_BloodHunter.smx":
L 07/28/2010 - 12:59:12: [SM]   
  •   Line 151, War3Source_011_BloodHunter.sp::RuptureCheckLoop()
L 07/28/2010 - 12:59:12: [SM] Native "War3_ValidPlayer" reported: Plugin owning this native is currently paused.
L 07/28/2010 - 12:59:12: [SM] Displaying call stack trace for plugin "War3Source_011_BloodHunter.smx":
L 07/28/2010 - 12:59:12: [SM]   
  •   Line 151, War3Source_011_BloodHunter.sp::RuptureCheckLoop()
L 07/28/2010 - 12:59:13: [SM] Native "War3_ValidPlayer" reported: Plugin owning this native is currently paused.
L 07/28/2010 - 12:59:13: [SM] Displaying call stack trace for plugin "War3Source_011_BloodHunter.smx":
L 07/28/2010 - 12:59:13: [SM]   
  •   Line 151, War3Source_011_BloodHunter.sp::RuptureCheckLoop()
L 07/28/2010 - 12:59:13: [SM] Native "War3_ValidPlayer" reported: Plugin owning this native is currently paused.
L 07/28/2010 - 12:59:13: [SM] Displaying call stack trace for plugin "War3Source_011_BloodHunter.smx":
L 07/28/2010 - 12:59:13: [SM]   
  •   Line 193, War3Source_011_BloodHunter.sp::BloodCrazyDOTLoop()
L 07/28/2010 - 12:59:13: [rcon_lock.smx] <server> executes: mp_disable_autokick
L 07/28/2010 - 12:59:13: [SM] Native "War3_ValidPlayer" reported: Plugin owning this native is currently paused.
L 07/28/2010 - 12:59:13: [SM] Displaying call stack trace for plugin "War3Source_011_BloodHunter.smx":
L 07/28/2010 - 12:59:13: [SM]   
  •   Line 151, War3Source_011_BloodHunter.sp::RuptureCheckLoop()


and from the looks of it it didnt upgrade the DB cause wc3 wont work.

Cheers
Logged
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2032



View Profile WWW Email
« Reply #13 on: July 28, 2010, 07:22:15 AM »

u war3source main didnt load. delete the error logs and launch again, find the first few errors teh indicate why this happened
Logged

DarkEnergy
saintk
Jr. Member
**
Posts: 71


View Profile Email
« Reply #14 on: July 28, 2010, 08:26:15 AM »

These were the first few lines:

Code:
L 07/28/2010 - 12:50:28: [SM] Native "HookEvent" reported: Game event "weapon_fire" does not exist
L 07/28/2010 - 12:50:28: [SM] Displaying call stack trace for plugin "War3Source.smx":
L 07/28/2010 - 12:50:28: [SM]   [0]  Line 90, W3SIncs/events.inc::War3Source_HookEvents()
L 07/28/2010 - 12:50:28: [SM]   [1]  Line 123, S:\Programming\SCRIPTINGSMX\War3SourcePv2\War3Source.sp::OnPluginStart()
L 07/28/2010 - 12:50:40: [SM] Native "War3_GetGame" reported: Plugin owning this native is currently paused.
L 07/28/2010 - 12:50:40: [SM] Displaying call stack trace for plugin "War3Source_001_UndeadScourge.smx":
L 07/28/2010 - 12:50:40: [SM]   [0]  Line 167, War3Source_001_UndeadScourge.sp::OnMapStart()
L 07/28/2010 - 12:50:41: [SM] Native "War3_ValidPlayer" reported: Plugin owning this native is currently paused.
L 07/28/2010 - 12:50:41: [SM] Displaying call stack trace for plugin "War3Source_011_BloodHunter.smx":
L 07/28/2010 - 12:50:41: [SM]   [0]  Line 151, War3Source_011_BloodHunter.sp::RuptureCheckLoop()
Logged
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2032



View Profile WWW Email
« Reply #15 on: July 28, 2010, 08:27:47 AM »

get on the latest beta, do ur conversion process
Logged

DarkEnergy
saintk
Jr. Member
**
Posts: 71


View Profile Email
« Reply #16 on: July 28, 2010, 11:55:17 AM »

I tried it with beta 5 as well with the same result.
Logged
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2032



View Profile WWW Email
« Reply #17 on: July 28, 2010, 12:13:42 PM »

did you get another fire_event  error?
Logged

DarkEnergy
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2032



View Profile WWW Email
« Reply #18 on: July 28, 2010, 01:16:11 PM »

BETA 6
Logged

DarkEnergy
saintk
Jr. Member
**
Posts: 71


View Profile Email
« Reply #19 on: July 29, 2010, 03:09:11 AM »

I think with beta 6 the conversion worked. Only "problem" is that it doesn't seem to report anything when its done?

Cheers
Logged
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2032



View Profile WWW Email
« Reply #20 on: July 29, 2010, 07:40:50 AM »

Quote
SEE YOUR ERROR LOG FOR CONVERSION PROCESS BECAUSE THE SERVER WILL APPEAR TO BE FROZEN AND NOT RESPOND: SAMPLE ENTRY
L 07/24/2010 - 00:54:48: [w3s\war3source_convertDB.smx] This Race: 3900 / 4270  INSERT INTO war3source_racedata1 (steamid,raceshortname,level,xp) VALUES ('STEAM_0:0:19xxxxx','undead','9','1763')

SEE THE ERROR LOG TO CONFIRM THAT ITS ACTUALLY FULLY COMPLETED AND NOT THAT THE SERVER RESTARTED BY YOUR CONTROL PANEL.
Logged

DarkEnergy
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2032



View Profile WWW Email
« Reply #21 on: July 29, 2010, 05:05:21 PM »

B7
Logged

DarkEnergy
vogon
Newbie
*
Posts: 16



View Profile WWW
« Reply #22 on: July 30, 2010, 01:50:54 AM »

B7

Just to clarify, the DB conversion is made only once right? so If I did it on B2 then I dont need to do it anymore?

Cheers for the continuing releases!
Logged

saintk
Jr. Member
**
Posts: 71


View Profile Email
« Reply #23 on: July 30, 2010, 05:39:17 AM »

Quote
SEE YOUR ERROR LOG FOR CONVERSION PROCESS BECAUSE THE SERVER WILL APPEAR TO BE FROZEN AND NOT RESPOND: SAMPLE ENTRY
L 07/24/2010 - 00:54:48: [w3s\war3source_convertDB.smx] This Race: 3900 / 4270  INSERT INTO war3source_racedata1 (steamid,raceshortname,level,xp) VALUES ('STEAM_0:0:19xxxxx','undead','9','1763')

SEE THE ERROR LOG TO CONFIRM THAT ITS ACTUALLY FULLY COMPLETED AND NOT THAT THE SERVER RESTARTED BY YOUR CONTROL PANEL.

Ye i read your instructions, but as i said, there is no message. I've had the server sitting there long enough to be 100% sure it should be done with conversions.
Logged
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2032



View Profile WWW Email
« Reply #24 on: July 30, 2010, 06:40:13 AM »

@vogon you convert once when u switching from < 1.1.5B2 to B2 or higher

saintk check your database manually then
Logged

DarkEnergy
Pages: [1] 2
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!