ERRO Gesior Highscores POT

[weverton]

Fatal error: Uncaught exception 'E_OTS_NotLoaded' in C:\xampp\htdocs\pot\OTS_Account.php:789 Stack trace: #0 C:\xampp\htdocs\highscores.php(93): OTS_Account->getCustomField('flag') #1 C:\xampp\htdocs\index.php(105): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 789


http://noobwar24h.servegame.com/index.php?subtopic=highscores

I delete an account by phpmyadmin
is now giving this error
how I fix?
please rep + + +

 

[Cykotitan]

alter table `accounts` add `flag` varchar(40) not null default ''

 

[weverton]

Erro

consulta SQL:

ALTER TABLE `accounts` ADD `flag` VARCHAR( 40 ) NOT NULL DEFAULT ''

Mensagens do MySQL : Documentação
#1060 - Duplicate column name 'flag'


erro

 

[Cykotitan]

alter table `accounts` modify `flag` varchar(40) not null default ''

 

[weverton]

Fatal error: Uncaught exception 'E_OTS_NotLoaded' in C:\xampp\htdocs\pot\OTS_Account.php:789 Stack trace: #0 C:\xampp\htdocs\highscores.php(93): OTS_Account->getCustomField('flag') #1 C:\xampp\htdocs\index.php(105): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 789




;/

 

[Chris]

UPDATE `accounts` SET `flag` = '' WHERE `flag` IS NULL;

 

[weverton]

I've reset the date that the players are dying to get frags
know how tidy?

 

[Chris]

Uhr, what?

 

[weverton]

players committed suicide to gain frags

 

[Chris]

Oh, all right... I'm not very up-to-date with OTs, but you should be able to make a simple check to see the ID of a persons latest frag. If he kills the same person twice in a row (or more), only one of them is recorded as a frag. Or something by that fashion.

 

[weverton]

NoobWAR - Last Kills

gain evul eye + frags

script

local storage = 20233
local reward = {
        item = 11197,
        count = 1
}
function onKill(cid, target, flags, damage)
	if isPlayer(target) then
		--[[if getPlayerIp(cid) ~= getPlayerIp(target) then]]
				local frags = math.max(0, getPlayerStorageValue(cid, storage))
				doCreatureSetStorage(cid, storage, frags+1)
				if(frags >= 5000) then
					doCreatureSetGuildEmblem(cid, EMBLEM_RED)
				elseif(frags >= 1500) then
					doCreatureSetGuildEmblem(cid, EMBLEM_BLUE)
				elseif(frags >= 250) then
					doCreatureSetGuildEmblem(cid, EMBLEM_GREEN)
				end

				if getPlayerItemCount(cid, reward.item) > 0 then
					local item = getPlayerItemById(cid, true, reward.item)
					if item.type >= 100 then
						doPlayerAddItem(cid, reward.item, reward.count)
					else
						doTransformItem(item.uid, reward.item, item.type + 1)
					end
				else
					doPlayerAddItem(cid, reward.item, reward.count)
				end
				doSendAnimatedText(getPlayerPosition(cid), "Frag!", TEXTCOLOR_RED)
		--[[else
			doPlayerSendTextMessage(cid, 18, "You didn't get frag/reward because of killing a player with same ip.")
		end]]
	end
	return true
end

 

[Cykotitan]

replace

if isPlayer(target) then​

with

if [highlight]cid ~= target and[/highlight] isPlayer(target) then​

 

[weverton]

thx cyko
repp++