Windows Killers don't get frags? Rev777 with Gesior 0.3.6

[Chrippe]

Hello!

I'm using the Rev 3777 With Warsystem (compiled by _Arthur) for 8.6 and whenever a player on my server kills another, he's getting the message "The kill of <name> was unjustified", but then when he hit "!frags" it says he has 0 frags. Also it's not recorded to the deathlist of the Gesior AAC 0.3.6, that I'm using. Also whenever the player dies, this show up in the server-console:

mysql_real_query(): SELECT 'pd'.'date' FROM 'player_killers' pk LEFT JOIN 'killers' k ON 'pk'.'kill_id' = 'k.id'LEFT JOIN 'player_deaths' pd ON 'k'.'death_id' = 'pd'.'id' WHERE 'pk'.'player_id' = 27 AND 'k'.'unjustified' = 1 AND 'pd'.'date' >= 1289221554 AND 'k'.'war' = 0 - MYSQL ERROR: Unknown column 'k.war' in 'where clause' (1054)

mysql_real_query(): INSERT INTO 'killers' ('death_id', 'final_hit', 'unjustified', 'war') VALUES (3, 1, 1, 0) = MYSQL ERROR: Unknown column 'war' in 'field list' (1054)
Kallakuttar has logged out.

What's wrong? I've been trying to solve the problem without no result. I'd really appreciate your help! Rep++ will be given.

Thanks in advance!

 

[thecycles]

Lol, post ur config.lua just want to make sure something xD

 

[knightxd]

Hello!

I'm using the Rev 3777 With Warsystem (compiled by _Arthur) for 8.6 and whenever a player on my server kills another, he's getting the message "The kill of <name> was unjustified", but then when he hit "!frags" it says he has 0 frags. Also it's not recorded to the deathlist of the Gesior AAC 0.3.6, that I'm using. Also whenever the player dies, this show up in the server-console:

mysql_real_query(): SELECT 'pd'.'date' FROM 'player_killers' pk LEFT JOIN 'killers' k ON 'pk'.'kill_id' = 'k.id'LEFT JOIN 'player_deaths' pd ON 'k'.'death_id' = 'pd'.'id' WHERE 'pk'.'player_id' = 27 AND 'k'.'unjustified' = 1 AND 'pd'.'date' >= 1289221554 AND 'k'.'war' = 0 - MYSQL ERROR: Unknown column 'k.war' in 'where clause' (1054)

mysql_real_query(): INSERT INTO 'killers' ('death_id', 'final_hit', 'unjustified', 'war') VALUES (3, 1, 1, 0) = MYSQL ERROR: Unknown column 'war' in 'field list' (1054)
Kallakuttar has logged out.

What's wrong? I've been trying to solve the problem without no result. I'd really appreciate your help! Rep++ will be given.

Thanks in advance!

i got just the SAME problem on rev 3676

 

[Chrippe]

Lol, post ur config.lua just want to make sure something xD

Alright then Here's my config:

	accountManager = false
	namelockManager = true
	newPlayerChooseVoc = false
	newPlayerSpawnPosX = 895
	newPlayerSpawnPosY = 698
	newPlayerSpawnPosZ = 7
	newPlayerTownId = 1
	newPlayerLevel = 1
	newPlayerMagicLevel = 0
	generateAccountNumber = false


	redSkullLength = 30 * 24 * 60 * 60
	blackSkullLength = 45 * 24 * 60 * 60
	dailyFragsToRedSkull = 3
	weeklyFragsToRedSkull = 5
	monthlyFragsToRedSkull = 10
	dailyFragsToBlackSkull = dailyFragsToRedSkull
	weeklyFragsToBlackSkull = weeklyFragsToRedSkull
	monthlyFragsToBlackSkull = monthlyFragsToRedSkull
	dailyFragsToBanishment = dailyFragsToRedSkull
	weeklyFragsToBanishment = weeklyFragsToRedSkull
	monthlyFragsToBanishment = monthlyFragsToRedSkull
	blackSkulledDeathHealth = 40
	blackSkulledDeathMana = 0
	useBlackSkull = true
	useFragHandler = true
	advancedFragList = false


	notationsToBan = 3
	warningsToFinalBan = 4
	warningsToDeletion = 5
	banLength = 7 * 24 * 60 * 60
	killsBanLength = 7 * 24 * 60 * 60
	finalBanLength = 30 * 24 * 60 * 60
	ipBanishmentLength = 1 * 24 * 60 * 60
	broadcastBanishments = true
	maxViolationCommentSize = 200
	violationNameReportActionType = 2
	autoBanishUnknownBytes = false


	worldType = "open"
	protectionLevel = 1
	pvpTileIgnoreLevelAndVocationProtection = true
	pzLocked = 60 * 1000
	huntingDuration = 60 * 1000
	criticalHitChance = 7
	criticalHitMultiplier = 1
	displayCriticalHitNotify = false
	removeWeaponAmmunition = true
	removeWeaponCharges = true
	removeRuneCharges = true
	whiteSkullTime = 15 * 60 * 1000
	noDamageToSameLookfeet = false
	showHealingDamage = false
	showHealingDamageForMonsters = false
	fieldOwnershipDuration = 5 * 1000
	stopAttackingAtExit = false
	oldConditionAccuracy = false
	loginProtectionPeriod = 10 * 1000
	deathLostPercent = 10
	stairhopDelay = 2 * 1000
	pushCreatureDelay = 2 * 1000
	deathContainerId = 1987
	gainExperienceColor = 215
	addManaSpentInPvPZone = true
	squareColor = 0
	allowFightback = true


	worldId = 0
	ip = "localhost"
	bindOnlyConfiguredIpAddress = false
	loginPort = 7171
	gamePort = 7172
	adminPort = 7171
	statusPort = 7171
	loginTries = 10
	retryTimeout = 5 * 1000
	loginTimeout = 60 * 1000
	maxPlayers = 1000
	motd = "Welcome to Jamba!"
	displayOnOrOffAtCharlist = false
	onePlayerOnlinePerAccount = true
	allowClones = false
	serverName = "Jamba"
	loginMessage = "Welcome to Jamba!"
	statusTimeout = 5 * 60 * 1000
	replaceKickOnLogin = true
	forceSlowConnectionsToDisconnect = false
	loginOnlyWithLoginServer = false
	premiumPlayerSkipWaitList = false


	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "secret"
	sqlDatabase = "hehe"
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "sha1"


	deathListEnabled = true
	deathListRequiredTime = 1 * 60 * 1000
	deathAssistCount = 19
	maxDeathRecords = 5


	ingameGuildManagement = true
	levelToFormGuild = 8
	premiumDaysToFormGuild = 0
	guildNameMinLength = 4
	guildNameMaxLength = 20


	highscoreDisplayPlayers = 15
	updateHighscoresAfterMinutes = 60


	buyableAndSellableHouses = true
	houseNeedPremium = true
	bedsRequirePremium = true
	levelToBuyHouse = 1
	housesPerAccount = 0
	houseRentAsPrice = false
	housePriceAsRent = false
	housePriceEachSquare = 1000
	houseRentPeriod = "never"
	houseCleanOld = 0
	guildHalls = false


	timeBetweenActions = 200
	timeBetweenExActions = 1000
	hotkeyAimbotEnabled = true


	mapName = "jambamap.otbm"
	mapAuthor = "Chrippe"
	randomizeTiles = true
	storeTrash = true
	cleanProtectedZones = true
	mailboxDisabledTowns = "-1"


	defaultPriority = "high"
	niceLevel = 5
	coresUsed = "-1"


	optimizeDatabaseAtStartup = true
	removePremiumOnInit = true
	confirmOutdatedVersion = false


	formulaLevel = 5.0
	formulaMagic = 1.0
	bufferMutedOnSpellFailure = false
	spellNameInsteadOfWords = false
	emoteSpells = false


	allowChangeOutfit = true
	allowChangeColors = true
	allowChangeAddons = true
	disableOutfitsForPrivilegedPlayers = false
	addonsOnlyPremium = true


	dataDirectory = "data/"
	bankSystem = true
	displaySkillLevelOnAdvance = false
	promptExceptionTracerErrorBox = true
	separateViplistPerCharacter = false
	maximumDoorLevel = 500
	maxMessageBuffer = 4


	saveGlobalStorage = true
	useHouseDataStorage = false
	storePlayerDirection = false


	checkCorpseOwner = true
	monsterLootMessage = 3
	monsterLootMessageType = 25


	ghostModeInvisibleEffect = false
	ghostModeSpellEffects = true


	idleWarningTime = 14 * 60 * 1000
	idleKickTime = 15 * 60 * 1000
	expireReportsAfterReads = 1
	playerQueryDeepness = 2
	maxItemsPerPZTile = 0
	maxItemsPerHouseTile = 0


	freePremium = true
	premiumForPromotion = true


	blessingOnlyPremium = true
	blessingReductionBase = 30
	blessingReductionDecreament = 5
	eachBlessReduction = 8


	experienceStages = true
	rateExperience = 5.0
	rateExperienceFromPlayers = 0
	rateSkill = 35
	rateMagic = 20
	rateLoot = 3.5
	rateSpawn = 2


	rateMonsterHealth = 1.0
	rateMonsterMana = 1.0
	rateMonsterAttack = 1.0
	rateMonsterDefense = 1.0


	minLevelThresholdForKilledPlayer = 0.9
	maxLevelThresholdForKilledPlayer = 1.1


	rateStaminaLoss = 1
	rateStaminaGain = 3
	rateStaminaThresholdGain = 12
	staminaRatingLimitTop = 41 * 60
	staminaRatingLimitBottom = 14 * 60
	rateStaminaAboveNormal = 1.5
	rateStaminaUnderNormal = 0.5
	staminaThresholdOnlyPremium = true


	experienceShareRadiusX = 30
	experienceShareRadiusY = 30
	experienceShareRadiusZ = 1
	experienceShareLevelDifference = 2 / 3
	extraPartyExperienceLimit = 20
	extraPartyExperiencePercent = 5
	experienceShareActivity = 2 * 60 * 1000


	globalSaveEnabled = false
	globalSaveHour = 8
	shutdownAtGlobalSave = true
	cleanMapAtGlobalSave = false


	deSpawnRange = 2
	deSpawnRadius = 50


	maxPlayerSummons = 2
	teleportAllSummons = false
	teleportPlayerSummons = false


	ownerName = ""
	ownerEmail = "@otland.net"
	url = "http://otland.net/"
	location = "Europe"
	displayGamemastersWithOnlineCommand = false


	adminLogsEnabled = false
	displayPlayersLogging = true
	prefixChannelLogs = ""
	runFile = ""
	outLogName = ""
	errorLogName = ""
	truncateLogsOnStartup = false

 

[_Arthur]

Alright then Here's my config: config lua

Just paste it in

 tags.       c,c

 

[Radium]

Also, test to see if its your Frags.lua
Kill people on a test character and see if you get red skull, if you do, then its your frags.lua

If you don't then.. Sources

 

[Chrippe]

Also, test to see if its your Frags.lua
Kill people on a test character and see if you get red skull, if you do, then its your frags.lua

If you don't then.. Sources

Don't get a redskull, doubt it's the sources? :S


Anyway here's the config:

	accountManager = false
	namelockManager = true
	newPlayerChooseVoc = false
	newPlayerSpawnPosX = 895
	newPlayerSpawnPosY = 698
	newPlayerSpawnPosZ = 7
	newPlayerTownId = 1
	newPlayerLevel = 1
	newPlayerMagicLevel = 0
	generateAccountNumber = false


	redSkullLength = 30 * 24 * 60 * 60
	blackSkullLength = 45 * 24 * 60 * 60
	dailyFragsToRedSkull = 3
	weeklyFragsToRedSkull = 5
	monthlyFragsToRedSkull = 10
	dailyFragsToBlackSkull = dailyFragsToRedSkull
	weeklyFragsToBlackSkull = weeklyFragsToRedSkull
	monthlyFragsToBlackSkull = monthlyFragsToRedSkull
	dailyFragsToBanishment = dailyFragsToRedSkull
	weeklyFragsToBanishment = weeklyFragsToRedSkull
	monthlyFragsToBanishment = monthlyFragsToRedSkull
	blackSkulledDeathHealth = 40
	blackSkulledDeathMana = 0
	useBlackSkull = true
	useFragHandler = true
	advancedFragList = false


	notationsToBan = 3
	warningsToFinalBan = 4
	warningsToDeletion = 5
	banLength = 7 * 24 * 60 * 60
	killsBanLength = 7 * 24 * 60 * 60
	finalBanLength = 30 * 24 * 60 * 60
	ipBanishmentLength = 1 * 24 * 60 * 60
	broadcastBanishments = true
	maxViolationCommentSize = 200
	violationNameReportActionType = 2
	autoBanishUnknownBytes = false


	worldType = "open"
	protectionLevel = 1
	pvpTileIgnoreLevelAndVocationProtection = true
	pzLocked = 60 * 1000
	huntingDuration = 60 * 1000
	criticalHitChance = 7
	criticalHitMultiplier = 1
	displayCriticalHitNotify = false
	removeWeaponAmmunition = true
	removeWeaponCharges = true
	removeRuneCharges = true
	whiteSkullTime = 15 * 60 * 1000
	noDamageToSameLookfeet = false
	showHealingDamage = false
	showHealingDamageForMonsters = false
	fieldOwnershipDuration = 5 * 1000
	stopAttackingAtExit = false
	oldConditionAccuracy = false
	loginProtectionPeriod = 10 * 1000
	deathLostPercent = 10
	stairhopDelay = 2 * 1000
	pushCreatureDelay = 2 * 1000
	deathContainerId = 1987
	gainExperienceColor = 215
	addManaSpentInPvPZone = true
	squareColor = 0
	allowFightback = true


	worldId = 0
	ip = "localhost"
	bindOnlyConfiguredIpAddress = false
	loginPort = 7171
	gamePort = 7172
	adminPort = 7171
	statusPort = 7171
	loginTries = 10
	retryTimeout = 5 * 1000
	loginTimeout = 60 * 1000
	maxPlayers = 1000
	motd = "Welcome to Jamba!"
	displayOnOrOffAtCharlist = false
	onePlayerOnlinePerAccount = true
	allowClones = false
	serverName = "Jamba"
	loginMessage = "Welcome to Jamba!"
	statusTimeout = 5 * 60 * 1000
	replaceKickOnLogin = true
	forceSlowConnectionsToDisconnect = false
	loginOnlyWithLoginServer = false
	premiumPlayerSkipWaitList = false


	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "secret"
	sqlDatabase = "hehe"
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "sha1"


	deathListEnabled = true
	deathListRequiredTime = 1 * 60 * 1000
	deathAssistCount = 19
	maxDeathRecords = 5


	ingameGuildManagement = true
	levelToFormGuild = 8
	premiumDaysToFormGuild = 0
	guildNameMinLength = 4
	guildNameMaxLength = 20


	highscoreDisplayPlayers = 15
	updateHighscoresAfterMinutes = 60


	buyableAndSellableHouses = true
	houseNeedPremium = true
	bedsRequirePremium = true
	levelToBuyHouse = 1
	housesPerAccount = 0
	houseRentAsPrice = false
	housePriceAsRent = false
	housePriceEachSquare = 1000
	houseRentPeriod = "never"
	houseCleanOld = 0
	guildHalls = false


	timeBetweenActions = 200
	timeBetweenExActions = 1000
	hotkeyAimbotEnabled = true


	mapName = "jambamap.otbm"
	mapAuthor = "Chrippe"
	randomizeTiles = true
	storeTrash = true
	cleanProtectedZones = true
	mailboxDisabledTowns = "-1"


	defaultPriority = "high"
	niceLevel = 5
	coresUsed = "-1"


	optimizeDatabaseAtStartup = true
	removePremiumOnInit = true
	confirmOutdatedVersion = false


	formulaLevel = 5.0
	formulaMagic = 1.0
	bufferMutedOnSpellFailure = false
	spellNameInsteadOfWords = false
	emoteSpells = false


	allowChangeOutfit = true
	allowChangeColors = true
	allowChangeAddons = true
	disableOutfitsForPrivilegedPlayers = false
	addonsOnlyPremium = true


	dataDirectory = "data/"
	bankSystem = true
	displaySkillLevelOnAdvance = false
	promptExceptionTracerErrorBox = true
	separateViplistPerCharacter = false
	maximumDoorLevel = 500
	maxMessageBuffer = 4


	saveGlobalStorage = true
	useHouseDataStorage = false
	storePlayerDirection = false


	checkCorpseOwner = true
	monsterLootMessage = 3
	monsterLootMessageType = 25


	ghostModeInvisibleEffect = false
	ghostModeSpellEffects = true


	idleWarningTime = 14 * 60 * 1000
	idleKickTime = 15 * 60 * 1000
	expireReportsAfterReads = 1
	playerQueryDeepness = 2
	maxItemsPerPZTile = 0
	maxItemsPerHouseTile = 0


	freePremium = true
	premiumForPromotion = true


	blessingOnlyPremium = true
	blessingReductionBase = 30
	blessingReductionDecreament = 5
	eachBlessReduction = 8


	experienceStages = true
	rateExperience = 5.0
	rateExperienceFromPlayers = 0
	rateSkill = 35
	rateMagic = 20
	rateLoot = 3.5
	rateSpawn = 2


	rateMonsterHealth = 1.0
	rateMonsterMana = 1.0
	rateMonsterAttack = 1.0
	rateMonsterDefense = 1.0


	minLevelThresholdForKilledPlayer = 0.9
	maxLevelThresholdForKilledPlayer = 1.1


	rateStaminaLoss = 1
	rateStaminaGain = 3
	rateStaminaThresholdGain = 12
	staminaRatingLimitTop = 41 * 60
	staminaRatingLimitBottom = 14 * 60
	rateStaminaAboveNormal = 1.5
	rateStaminaUnderNormal = 0.5
	staminaThresholdOnlyPremium = true


	experienceShareRadiusX = 30
	experienceShareRadiusY = 30
	experienceShareRadiusZ = 1
	experienceShareLevelDifference = 2 / 3
	extraPartyExperienceLimit = 20
	extraPartyExperiencePercent = 5
	experienceShareActivity = 2 * 60 * 1000


	globalSaveEnabled = false
	globalSaveHour = 8
	shutdownAtGlobalSave = true
	cleanMapAtGlobalSave = false


	deSpawnRange = 2
	deSpawnRadius = 50


	maxPlayerSummons = 2
	teleportAllSummons = false
	teleportPlayerSummons = false


	ownerName = ""
	ownerEmail = "@otland.net"
	url = "http://otland.net/"
	location = "Europe"
	displayGamemastersWithOnlineCommand = false


	adminLogsEnabled = false
	displayPlayersLogging = true
	prefixChannelLogs = ""
	runFile = ""
	outLogName = ""
	errorLogName = ""
	truncateLogsOnStartup = false

 

[Chrippe]

You guys have any idea?

 

[Summ]

Ye got a idea.
Goto 127.0.0.1/phpmyadmin -> Login there -> Select your database -> click on SQL at top -> Write:

ALTER TABLE killers ADD war int(11);

and press OK

 

[Chrippe]

Great! Thanks Summ, it worked. I'll rep ya after I'm done writing this!

I have another problem, maybe you could help me with that aswell, whenever I login to a character, the following message pops up:

mysql_real_query(): SELECT 'id', 'guild_id', 'enemy_id' FROM 'guild_wars' WHERE ('guild_id' = 2 OR 'enemy_id' = 2) AND 'status' IN (1,4) - MYSQL ERROR: Table 'jambarl.guildwars_wars' doesn't exist (1146)

Really appreciate your help, thank you!