• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Lua No Account to kill Frag Player Wrongly! HELP

L

Lucas Ming

New Member
Joined
Oct 22, 2012
Messages
4
Reaction score
0
My server is not counting the "frags".

In my config.lua "WorldType =" open "
I've tried for:
"pvp" and the server did not initialize! ...


Even I Getting PK, and Unjustly killing does not count any Frag!
I do not know what else to do, I ask You to Help Solve this I Can Bug!





* I am Brazilian, I used a tool to translate what I wrote above, from Portuguese to Inglês!

Thank you :)
 
Sort by date Sort by votes
Code: 
	useFragHandler = true
	redSkullLength = 1 * 24 * 60 * 60
	blackSkullLength = 2 * 24 * 60 * 60
	dailyFragsToRedSkull = 6
	weeklyFragsToRedSkull = 999
	monthlyFragsToRedSkull = 999
	dailyFragsToBlackSkull = dailyFragsToRedSkull
	weeklyFragsToBlackSkull = weeklyFragsToRedSkull
	monthlyFragsToBlackSkull = monthlyFragsToRedSkull
	dailyFragsToBanishment = dailyFragsToRedSkull
	weeklyFragsToBanishment = weeklyFragsToRedSkull
	monthlyFragsToBanishment = monthlyFragsToRedSkull
	blackSkulledDeathHealth = 45
	blackSkulledDeathMana = 0
	useBlackSkull = true
	advancedFragList = false
 
Upvote 0 Downvote
Did not work
:(

22:30 Warning! The murder of Lukinhas was not justified.
22:30 You currently have 0 frags today, 0 this week and 0 this month.
Click to expand...



Window Server
[22:29:32.147] The Forgotten Server, version 0.4_SVN ()
[22:29:32.147] Compiled with GNU C++ version 3.4.5 (mingw special) at Jan 9 201
1, 01:40:40.
[22:29:32.147] A server developed by Elf, Talaturen, Stian, Slawkens, KaczooH a
nd Kornholijo.
[22:29:32.147] Visit our forum for updates, support and resources: http://otland
.net.

[22:29:32.147] >> Loading config (config.lua)
[22:29:32.147] > Opening logs
[22:29:32.147] > Using SHA1 encryption
[22:29:32.506] >> Checking software version... running sub version, please mind
it's unstable and only for testing purposes!
[22:29:32.506] > Current version information - version: 0.4_SVN, patch: 0, build
: 0, timestamp: 1294543725.
[22:29:32.506] > Latest version information - version: 0.3.6, patch: 0, build: 3
293, timestamp: 1260652199.
[22:29:32.506] >> Loading RSA key
[22:29:32.724] >> Starting SQL connection
[22:29:32.724] >> Running Database Manager
[22:29:32.927] > Optimized database.
[22:29:32.927] >> Loading items (OTB)
[22:29:33.067] >> Loading items (XML)
[22:29:33.176] >> Loading groups
[22:29:33.176] >> Loading vocations
[22:29:33.176] >> Loading outfits
[22:29:33.176] >> Loading chat channels
[22:29:33.176] >> Loading script systems
[22:29:33.535] >> Loading mods...
[22:29:33.535] > 0 mods were loaded.
[22:29:33.535] >> Loading experience stages
[22:29:33.535] >> Loading monsters
[22:29:34.019] >> Loading map and spawns...
[22:29:34.658] > Map size: 65000x65000.
[22:29:34.658] > Map descriptions:
[22:29:34.658] "Saved with Remere's Map Editor 2.1"
[22:29:34.658] "No map description available."
[22:29:34.736] Duplicate uniqueId 5041
[22:29:35.189] Duplicate uniqueId 7100
[22:29:35.579] Duplicate uniqueId 5031
[22:29:35.579] Duplicate uniqueId 5031
[22:29:35.579] Duplicate uniqueId 5031
[22:29:35.579] Duplicate uniqueId 5031
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.594] Duplicate uniqueId 5040
[22:29:35.610] Duplicate uniqueId 5040
[22:29:35.610] Duplicate uniqueId 5040
[22:29:35.610] Duplicate uniqueId 5040
[22:29:35.610] Duplicate uniqueId 5040
[22:29:35.610] Duplicate uniqueId 5040
[22:29:35.610] Duplicate uniqueId 5040
[22:29:35.610] Duplicate uniqueId 5040
[22:29:35.610] Duplicate uniqueId 5040
[22:29:35.610] Duplicate uniqueId 5040
[22:29:35.610] Duplicate uniqueId 5040
[22:29:35.610] Duplicate uniqueId 5040
[22:29:35.610] Duplicate uniqueId 5040
[22:29:35.610] Duplicate uniqueId 5040
[22:29:35.610] Duplicate uniqueId 5040
[22:29:35.610] Duplicate uniqueId 5040
[22:29:35.610] Duplicate uniqueId 5035
[22:29:35.610] Duplicate uniqueId 5036
[22:29:35.626] Duplicate uniqueId 5032
[22:29:35.626] Duplicate uniqueId 5032
[22:29:35.626] Duplicate uniqueId 5032
[22:29:35.626] Duplicate uniqueId 5032
[22:29:39.635] > Map loading time: 5.616 seconds.
[22:29:40.040] > Data parsing time: 0.405 seconds.
[22:29:58.704] > Houses synchronization time: 18.664 seconds.
[22:29:58.896] > Content unserialization time: 0.192 seconds.
[22:29:58.911] >> Checking world type... Open PvP
[22:29:58.911] >> Initializing game state and binding services...
[22:29:58.911] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.958] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.958] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.958] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.958] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.958] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.958] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.958] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.958] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.958] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.958] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.958] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.958] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.958] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.958] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.958] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.958] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.958] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.958] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.958] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.974] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.974] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.974] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.974] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.974] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.974] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.974] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.974] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.974] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.974] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.974] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.974] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.974] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:58.974] [Warning - Monster::Monster] Unknown event name - KillingInTheNam
eOf
[22:29:59.021] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIM
ESTAMP (SELECT "id","name","account_id" FROM "players" WHERE "level" < 100 AND "
name" NOT IN('Account Manager', 'Sorcerer Sample', 'Druid Sample', 'Paladin Samp
le', 'Knight Sample', 'Rook Sample') AND "group_id" < 2 AND "lastlogin" < UNIX_T
IMESTAMP() - 604800;)
[22:29:59.021] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIM
ESTAMP (SELECT "id","name","account_id" FROM "players" WHERE "level" < 300 AND "
name" NOT IN('Account Manager', 'Sorcerer Sample', 'Druid Sample', 'Paladin Samp
le', 'Knight Sample', 'Rook Sample') AND "group_id" < 2 AND "lastlogin" < UNIX_T
IMESTAMP() - 5184000;)
[22:29:59.099] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: guild_wars
(SELECT "id", "guild_id", "enemy_id" FROM "guild_wars" WHERE "status" IN (1,4) A
ND "end" > 0 AND "end" < 1350865799)
[22:29:59.099] > Global IP address: 189.71.89.68
[22:29:59.217] > Local IP address(es): 192.168.254.3 5.16.180.27
[22:29:59.283] > Bound ports: 7171 7172
[22:29:59.284] >> Everything smells good, server is starting up...
[22:30:09.285] >> Light Server server Online!

[22:30:15.391] Lucas has logged in.
[22:30:30.345] Lukinhas has logged in.
[22:30:33.543] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.on
linetime6 (UPDATE "players" SET "onlinetime7"=players.onlinetime6, "onlinetime6"
=players.onlinetime5, "onlinetime5"=players.onlinetime4, "onlinetime4"=players.o
nlinetime3, "onlinetime3"=players.onlinetime2, "onlinetime2"=players.onlinetime1
, "onlinetime1"=players.onlinetimetoday, "onlinetimetoday"=0;)
[22:30:33.543] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.ex
phist6 (UPDATE "players" SET "exphist7"=players.exphist6, "exphist6"=players.exp
hist5, "exphist5"=players.exphist4, "exphist4"=players.exphist3, "exphist3"=play
ers.exphist2, "exphist2"=players.exphist1, "exphist1"=players.experience-players
.exphist_lastexp, "exphist_lastexp"=players.experience;)
[22:30:33.543] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.on
linetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60
, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[22:30:35.228] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: k.war (SEL
ECT "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" = 10 AND "k"."unjustified" = 1 AND "pd"."date" >= 1348273835 AND "k
"."war" = 0)
[22:30:35.244] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: table killers has no colum
n named war (INSERT INTO "killers" ("death_id", "final_hit", "unjustified", "war
") VALUES (2, 1, 1, 0))
[22:30:35.306] Lukinhas has logged out.
[22:30:38.473] Lukinhas has logged in.
[22:31:33.565] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.on
linetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60
, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
Click to expand...
 
Upvote 0 Downvote
This looks like database schema issues.

You are using features that require additions that haven't been baked into the SQLITE. This can cause all sorts of havoc, because the execution of a scripts stops at the first error.

You have to actually have a running MySQL server to switch to it.


The 'onlinetime' is from a very old Gesior module called "Powergamers", and it's horribly coded, but here is the needed changes:

Code: 
ALTER TABLE `players` ADD `exphist_lastexp` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist1` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist2` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist3` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist4` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist5` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist6` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `exphist7` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetimetoday` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime1` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime2` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime3` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime4` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime5` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime6` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetime7` BIGINT( 255 ) NOT NULL DEFAULT '0', 
ADD `onlinetimeall` BIGINT( 255 ) NOT NULL DEFAULT '0';

you can do that from a mysql command line or a phpMyAdmin console or even the /lua talkaction if you felt creative and used dofile("");

But it seems like you are hopelessly lost. You need to research more. I'm gonna guess you're running Windows... which means I don't have the patience to guide you all the way through this.

The other SQL errors are related to guild war additions that also haven't been provisioned.
 
Upvote 0 Downvote
Tank You :)



So unfortunately I have to change server?

Incidentally, if I download a new server, copy and paste aa "DATA" and all the "scripts" and paste the new server, it will work?
 
Upvote 0 Downvote
Back
Top