• 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!

people Cant die

8683984

8683984

New Member
Joined
Jun 5, 2009
Messages
95
Reaction score
2
Location
Sweden
Ok, this is really wierd, would love to get some help here.
I got a custom map and when people die, they get deep red hp but they never die?
Would be really greatful if someone could help :) asap please


[ERROR - CREATURESCRIPT INTERFACE]
buffer: onkill
Description:
[String "loadbuffer"]1:104: attemp to index a number value
stack traceback

Here is a pick on the problem: http://www.speedy*****malware.localhost/files/24063354/tibiapic.jpg
Please help asap :/
 
Last edited:
Sort by date Sort by votes
I aw you answered another guy, that had the same problem... could it be this? cause it is something with the war system.
ANd if so, where do i put it?

LUA: 
ALTER TABLE "guilds"
ADD (   "invited_to" INTEGER NOT NULL,
	"invited_by" INTEGER NOT NULL,
	"in_war_with" INTEGER NOT NULL,
	"kills" INTEGER NOT NULL,
	"show" TINYINT NOT NULL,
	"war_time" INTEGER NOT NULL);

CREATE TABLE "deaths_in_wars" (
	"guild_id" INTEGER NOT NULL,
	"player_id" INTEGER NOT NULL,
	"killer_guild" INTEGER NOT NULL,
	"killer" INTEGER NOT NULL,
	"date" INTEGER NOT NULL,
	"result1" INTEGER NOT NULL,
	"result2" INTEGER NOT NULL
);

UPDATE "guilds" SET "invited_to" = 0, "invited_by" = 0, "in_war_with" = 0, "kills" = 0, "show" = 0, "war_time" = 0 WHERE "id" > 0;
 
Last edited:
Upvote 0 Downvote
wich script? you got the error on a pic at the first post, do you know what's wrong?

everything worked fine before, or well before they started atk eachother in the guild.
 
Last edited:
Upvote 0 Downvote
LUA: 
 local PZ = createConditionObject(CONDITION_INFIGHT)
setConditionParam(PZ, CONDITION_PARAM_TICKS, getConfigInfo('whiteSkullTime'))

function onkill (cid, target, lastHit)

        if isPlayer(cid) == TRUE and isPlayer(target) == TRUE then
 
Upvote 0 Downvote
Cykotitan said:
Change onkill to onKill ?
and execute the SQL query in phpMyAdmin
Click to expand...

change onkill to onkill? :)

adn where in phpmyadmin?
i mean i got plenty of "tables" so does it matter where?

cuase it says like this if just put it it
LUA: 
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"guilds"
ADD ( "invited_to" INTEGER NOT NULL,
    "invited_by" INTEGER NOT NULL,
' at line 1
 
Last edited:
Upvote 0 Downvote
try uhm..
SQL: 
ALTER TABLE `guilds`
ADD `invited_to` INT( 11 ) NOT NULL DEFAULT 0,
ADD `invited_by` INT( 11 ) NOT NULL DEFAULT 0,
ADD `in_war_with` INT( 11 ) NOT NULL DEFAULT 0,
ADD `kills` INT( 11 ) NOT NULL DEFAULT 0,
ADD `show` SMALLINT( 1 ) NOT NULL DEFAULT 0,
ADD `war_time` INT( 11 ) NOT NULL DEFAULT 0;

CREATE TABLE `deaths_in_wars` (
`guild_id` INT( 11 ) NOT NULL ,
`player_id` INT( 11 ) NOT NULL ,
`killer_guild` INT( 11 ) NOT NULL ,
`killer` INT( 11 ) NOT NULL ,
`date` INT( 11 ) NOT NULL ,
`result1` INT( 11 ) NOT NULL ,
`result2` INT( 11 ) NOT NULL
) ENGINE = InnoDB;
 
Last edited:
Upvote 0 Downvote
Cykotitan said:
try uhm..
SQL: 
ALTER TABLE `guilds`
ADD `invited_to` INT( 11 ) NOT NULL DEFAULT 0,
ADD `invited_by` INT( 11 ) NOT NULLL DEFAULT 0,
ADD `in_war_with` INT( 11 ) NOT NULL DEFAULT 0,
ADD `kills` INT( 11 ) NOT NULL DEFAULT 0,
ADD `show` SMALLINT( 1 ) NOT NULL DEFAULT 0,
ADD `war_time` INT( 11 ) NOT NULL DEFAULT 0;

CREATE TABLE `deaths_in_wars` (
`guild_id` INT( 11 ) NOT NULL ,
`player_id` INT( 11 ) NOT NULL ,
`killer_guild` INT( 11 ) NOT NULL ,
`killer` INT( 11 ) NOT NULL ,
`date` INT( 11 ) NOT NULL ,
`result1` INT( 11 ) NOT NULL ,
`result2` INT( 11 ) NOT NULL
) ENGINE = InnoDB;
Click to expand...


LUA: 
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULLL DEFAULT 0,
ADD `in_war_with` INT( 11 ) NOT NULL DEFAULT 0,
ADD `kills` I' at line 3

maybe i put it at the wrong place?
 
Upvote 0 Downvote
Make it in sql line by line , so copy a line and excute there
SQL: 
ALTER TABLE `guilds` ADD `invited_to` INT( 11 ) NOT NULL DEFAULT '0'
ALTER TABLE `guilds`  ADD `invited_by` INT( 11 ) NOT NULL DEFAULT '0'
ALTER TABLE `guilds`  ADD `in_war_with` INT( 11 ) NOT NULL DEFAULT '0'
ALTER TABLE `guilds`  ADD `kills` INT( 11 ) NOT NULL DEFAULT '0'
ALTER TABLE `guilds`  ADD `show` SMALLINT( 1 ) NOT NULL DEFAULT '0'
ALTER TABLE `guilds`  ADD `war_time` INT( 11 ) NOT NULL DEFAULT '0'
after that copy all this and excute
SQL: 
CREATE TABLE `deaths_in_wars` (
`guild_id` INT( 11 ) NOT NULL ,
`player_id` INT( 11 ) NOT NULL ,
`killer_guild` INT( 11 ) NOT NULL ,
`killer` INT( 11 ) NOT NULL ,
`date` INT( 11 ) NOT NULL ,
`result1` INT( 11 ) NOT NULL ,
`result2` INT( 11 ) NOT NULL
) ENGINE = InnoDB;
 
Upvote 0 Downvote
Glidarn said:
LUA: 
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULLL DEFAULT 0,
ADD `in_war_with` INT( 11 ) NOT NULL DEFAULT 0,
ADD `kills` I' at line 3

maybe i put it at the wrong place?
Click to expand...

change NULLL -> NULL
 
Upvote 0 Downvote
Back
Top