Rusherzin

function onUse(cid, item, fromPosition, item2, toPosition) local pos = {x=437, y=58, z=7} if getPlayerLevel(cid) >= 5 then doTeleportThing(cid, pos) doSendMagicEffect(getPlayerPosition(cid), 10) doPlayerSendTextMessage(cid, 22, "msg se TIVER level e passar!") else doPlayerSendTextMessage(cid, 22, "msg se não tiver level.") end return TRUE end Tag actions.xml <action actionid="2572" event="script" value="NOMEDOARQUIVO.lua"/>

Não testei: <?xml version="1.0" encoding="UTF-8"?> <mod name="Frag Remover" version="1.1" author="Hermes" contact="otland.net" enabled="yes"> <action itemid="9969" event="script"><![CDATA[ local noRemove = {SKULL_WHITE, SKULL_YELLOW} local playerSkull = getPlayerSkullType(cid) if isInArray(noRemove, playerSkull) then doPlayerSendCancel(cid, "You can't remove this type of skull.") doSendMagicEffect(getPlayerPosition(cid), CONST_ME_POFF) return true elseif playerSkull == SKULL_NONE then

ALTER TABLE `accounts` ADD `rlname` VARCHAR(255) NOT NULL DEFAULT '';

Vishe, tenta isso então ALTER TABLE `accounts` ADD `nickname` VARCHAR(255) NOT NULL DEFAULT '';

Tenta isso: UPDATE `accounts` SET `nickname`= ""

Eu vi, é o mesmo erro que tu me disseste A Database Error Occurred Error Number: 1054 Unknown column 'nickname' in 'where clause' SELECT `id` FROM (`accounts`) WHERE `nickname` = 'Rusherzin'

Não sei o que pode ser agora, primeira vez que mexo com modern :x

Eu testei aqui e criou de boa :/

Tenta ;-; ALTER TABLE `accounts` ADD `nickname` INT(11) DEFAULT 0;

Procura ali onde eu falei.. /\

@Edit Achei, é em \xampp\htdocs\system\application\views\ no arquivo create.php

Isso é em outro arquivo, talvez o createaccount.php

INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `d

Beleza, manda no pv

Preciso ver sua Db, tem como exportar ela aí e postar pra download?

Vish, então tenta executar isso CREATE TABLE IF NOT EXISTS `players` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0', `group_id` int(11) NOT NULL DEFAULT '1', `account_id` int(11) NOT NULL DEFAULT '0', `level` int(11) NOT NULL DEFAULT '1', `vocation` int(11) NOT NULL DEFAULT '0', `health` int(11) NOT NULL DEFAULT '150', `healthmax` int(11) NOT NULL DEFAULT '150', `experience` bigint(20) NOT NULL DEFAULT '0', `lookbody` int(11) NOT NULL DEFAULT '0', `lookfeet` int(11) NOT NULL DEFAULT '0', `

Tenta agora: INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `promotion`, `delete

Tenta executar na tua db INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`,

Quais são as vocações que tem para escolher?

Criou os samples na sua database?

Tenta essa: ALTER TABLE `players` ADD `offlinetraining_time` smallint(5) unsigned NOT NULL DEFAULT '43200';

Executa isso na tua db CREATE TABLE IF NOT EXISTS `players` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `world_id` tinyint(4) unsigned NOT NULL DEFAULT '0', `group_id` int(11) NOT NULL DEFAULT '1', `account_id` int(11) NOT NULL DEFAULT '0', `level` int(11) NOT NULL DEFAULT '1', `vocation` int(11) NOT NULL DEFAULT '0', `health` int(11) NOT NULL DEFAULT '150', `healthmax` int(11) NOT NULL DEFAULT '150', `experience` bigint(20) unsigned NOT NULL DEFAULT '0', `lookbody` int(11) NOT NULL DEFAULT '0', `lookfeet` int(11) NOT NULL DEFAULT '0', `l

Tenta usar divisão então "/"

O seu password está criptografado? Pelo que vi em seu config.lua está em "plain" tenta trocar por "sha1" ..

De boa, qualquer dúvida com o site, posta ai..