Sadness

.Qual servidor ou website você utiliza como base? MyAAc Qual o motivo deste tópico? Ajuda Você tem o código disponível? Se tiver publique-o aqui: Sim, o sistema, só preciso de ajuda em como inserir. <?php if (!$logged){ include ('login.php'); } if ($logged) if ($action == ''){ $main_content .=' Para resetar o personagem escolha o personagem e digite sua senha para confirmação.<br> Ao resetar seu personagem, o personagem vai para level 8 mantendo o restante dos atributos.<br/><br/> <form action="?subtopic=reset&action=reset" method="post" > <div class="TableContainer" > <table class="Table1" cellpadding="0" cellspacing="0" > <div class="CaptionContainer" > <div class="CaptionInnerContainer" > <span class="CaptionEdgeLeftTop" style="background-image:url(layouts/tibiacom/images/content/box-frame-edge.gif);" /></span> <span class="CaptionEdgeRightTop" style="background-image:url(layouts/tibiacom/images/content/box-frame-edge.gif);" /></span> <span class="CaptionBorderTop" style="background-image:url(layouts/tibiacom/images/content/table-headline-border.gif);" ></span> <span class="CaptionVerticalLeft" style="background-image:url(layouts/tibiacom/images/content/box-frame-vertical.gif);" /></span> <div class="Text" >Resetar personagem</div> <span class="CaptionVerticalRight" style="background-image:url(layouts/tibiacom/images/content/box-frame-vertical.gif);" /></span> <span class="CaptionBorderBottom" style="background-image:url(layouts/tibiacom/images/content/table-headline-border.gif);" ></span> <span class="CaptionEdgeLeftBottom" style="background-image:url(layouts/tibiacom/images/content/box-frame-edge.gif);" /></span> <span class="CaptionEdgeRightBottom" style="background-image:url(layouts/tibiacom/images/content/box-frame-edge.gif);" /></span> </div> </div> <tr> <td> <div class="InnerTableContainer" > <table style="width:100%;" > <tr> <td class="LabelV" ><span >Nome do personagem:</td> <td style="width:90%;" > <select name="reset_name">'; $players_from_logged_acc = $account_logged->getPlayersList(); if(count($players_from_logged_acc) > 0) { $players_from_logged_acc->orderBy('name'); foreach($players_from_logged_acc as $player) { $main_content .= '<option value="'.$player->getName().'">'.$player->getName().'</option>'; } } else { $main_content .= 'You don\'t have any character on your account.'; } $main_content .=' </select> </td> </tr> <!--tr> <td class="LabelV" > <span >Account Name:</td><td><input type="password" name="reset_acc" size="30" maxlength="29" ></td></tr--> </table> </div> </table> </div> </td> </tr> <br/> <table style="width:100%" > <tr align="center" > <td> <table border="0" cellspacing="0" cellpadding="0" ><tr><td style="border:0px;" > <div class="BigButton" style="background-image:url(layouts/tibiacom/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url(layouts/tibiacom/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Submit" alt="Submit" src="layouts/tibiacom/images/buttons/_sbutton_submit.gif" ></div></div></td><tr></form></table></td><td><table border="0" cellspacing="0" cellpadding="0" ><form action="?subtopic=accountmanagement" method="post" ><tr><td style="border:0px;" ><div class="BigButton" style="background-image:url(layouts/tibiacom/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url(layouts/tibiacom/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="layouts/tibiacom/images/buttons/_sbutton_back.gif" ></div></div></td></tr></form></table></td></tr></table> '; } if ($action == 'reset'){ $reset_name = stripslashes(ucwords(strtolower(trim($_REQUEST['reset_name'])))); if(check_name($reset_name)) { $player = $ots->createObject('Player'); $player->find($reset_name); if($player->isLoaded()) { $PlayerLevel = $player->getLevel(); $PlayerReset = $player->getCustomField('reset'); $PlayerResetNow = $player->getCustomField('reset') + 1; $ResetTable = array ( 0 => 350, 1 => 350, 2 => 350, 3 => 350, 4 => 350, 5 => 355, 6 => 355, 7 => 355, 8 => 355, 9 => 355, 10 => 360, 11 => 360, 12 => 360, 13 => 360, 14 => 360, 15 => 365, 16 => 365, 17 => 365, 18 => 365, 19 => 365, 20 => 380, 21 => 380, 22 => 380, 23 => 380, 24 => 380, 25 => 390, 26 => 390, 27 => 390, 28 => 390, 29 => 390, 30 => 410, 31 => 410, 32 => 410, 33 => 410, 34 => 410, 35 => 430, 36 => 430, 37 => 430, 38 => 430, 39 => 430, 40 => 450, 41 => 450, 42 => 450, 43 => 450, 44 => 450, 45 => 480, 46 => 480, 47 => 480, 48 => 480, 49 => 480, 50 => 510, 51 => 510, 52 => 510, 53 => 510, 54 => 510, 55 => 550, 56 => 550, 57 => 550, 58 => 550, 59 => 550, ); $LevelLeft = $ResetTable[$PlayerReset] - $PlayerLevel; if ($PlayerLevel >= $ResetTable[$PlayerReset]){ $SQL->query ("UPDATE `players` SET `reset` = `reset` + '1', level = 8 WHERE `players`.`id` = '".$player->getId()."' LIMIT 1 ;"); $main_content .= ' <div class="reset_class"> Personagem '.$player->getName().' estava level '.$PlayerLevel.' e foi resetado com sucesso.<br /> Agora o personagem tem '.$PlayerResetNow.' reset(s). </div> <br /> <table border="0" cellpadding="0" cellspacing="0" align="center"> <tbody> <tr> <td style="border: 0px none;"> <div class="BigButton" style="background-image: url('.$layout_name.'/images/buttons/sbutton.gif);"> <div onmouseover="MouseOverBigButton(this);" onmouseout="MouseOutBigButton(this);"><div class="BigButtonOver" style="background-image: url('.$layout_name.'/images/buttons/sbutton_over.gif);"></div> <form action="?subtopic=reset" method="post"> <input class="ButtonText" name="Back" alt="Back" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" type="image"> </form> </div> </div> </td> </tr> </tbody> </table> '; } else { $main_content .= ' <div class="reset_class"> Você tem '.$PlayerReset.' resets.<br /> Você reseta level '.$ResetTable[$PlayerReset].'.<br /> <span style="color: red;">Faltam '.$LevelLeft.' level(s).</span> </div> <br /> <table border="0" cellpadding="0" cellspacing="0" align="center"> <tbody> <tr> <td style="border: 0px none;"> <div class="BigButton" style="background-image: url('.$layout_name.'/images/buttons/sbutton.gif);"> <div onmouseover="MouseOverBigButton(this);" onmouseout="MouseOutBigButton(this);"><div class="BigButtonOver" style="background-image: url('.$layout_name.'/images/buttons/sbutton_over.gif);"></div> <form action="?subtopic=reset" method="post"> <input class="ButtonText" name="Continue" alt="Continue" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" type="image"> </form> </div> </div> </td> </tr> </tbody> </table> '; } /**********************************************/ } // Carregar modulos } // Checar Player Existente } // Fim page ?> Você tem alguma imagem que possa auxiliar no problema? Se sim, coloque-a aqui.

Retire esta linha: doRemoveCreature(cid)

Tente retirar esta linha: db.executeQuery("UPDATE `players` SET `name` = '[Vip] "..name.."' WHERE `id` = "..getPlayerGUID(player)..";") doRemoveCreature(player) 

up

Não consigo acessar os registros da minha database(mysql) http://prntscr.com/inx3qp Como resolvo ?

UP

Já brinquei com os pixels, porém não alterava em nada vou tentar de novo. Obrigado

Bom dia, estou aqui á procura de pessoas que tenham vontade de participar da staff do meu servidor. Ele está quase pronto, irei abrir um servidor test por um mês, e quando estiver totalmente pronto será lançado. A versão é 8.60 high exp, caso você se interesse me mande um email: [email protected] Nome: Localização: Idade: Quanto tempo joga: Facebook: Obrigado !

Aqui está o layout.php inteiro .

Eu coloquei o networking box, porém ele fica assim como resolvo? http://prntscr.com/ikebs0

Como você colocou a linha no globalevents.xml?

Então, troque o seu shop.lua do globalevents por esse que eu passei.

local SHOP_MSG_TYPE = MESSAGE_EVENT_ORANGE local SQL_interval = 30 --- ### Outfits List ### local femaleOutfits = { ["citizen"]={136}, ["hunter"]={137}, ["mage"]={138}, ["knight"]={139}, ["noblewoman"]={140}, ["summoner"]={141}, ["warrior"]={142}, ["barbarian"]={147}, ["druid"]={148}, ["wizard"]={149}, ["oriental"]={150}, ["pirate"]={155}, ["assassin"]={156}, ["beggar"]={157}, ["shaman"]={158}, ["norsewoman"]={252}, ["nightmare"]={269}, ["jester"]={270}, ["brotherhood"]={279}, ["demonhunter"]={288}, ["yalaharian"]={324}, ["warmaster"]={336}, ["wayfarer"]={366}, ["afflicted"]={431}, ["elementalist"]={433}, ["deepling"]={464}, ["insectoid"]={466}, ["red baron"]={471}, ["crystal warlord"]={513}, ["soil guardian"]={514}, ["demon"]={542} } local maleOutfits = { ["citizen"]={128}, ["hunter"]={129}, ["mage"]={130}, ["knight"]={131}, ["noblewoman"]={132}, ["summoner"]={133}, ["warrior"]={134}, ["barbarian"]={143}, ["druid"]={144}, ["wizard"]={145}, ["oriental"]={146}, ["pirate"]={151}, ["assassin"]={152}, ["beggar"]={153}, ["shaman"]={154}, ["norsewoman"]={251}, ["nightmare"]={268}, ["jester"]={273}, ["brotherhood"]={278}, ["demonhunter"]={289}, ["yalaharian"]={325}, ["warmaster"]={335}, ["wayfarer"]={367}, ["afflicted"]={430}, ["elementalist"]={432}, ["deepling"]={463}, ["insectoid"]={465}, ["red baron"]={472}, ["crystal warlord"]={512}, ["soil guardian"]={516}, ["demon"]={541} } function onThink(interval, lastExecution) local result_plr = db.getResult("SELECT * FROM z_ots_comunication") if(result_plr:getID() ~= -1) then while(true) do id = tonumber(result_plr:getDataInt("id")) local action = tostring(result_plr:getDataString("action")) local delete = tonumber(result_plr:getDataInt("delete_it")) local cid = getPlayerByName(tostring(result_plr:getDataString("name"))) if isPlayer(cid) then local itemtogive_id = tonumber(result_plr:getDataInt("param1")) local itemtogive_count = tonumber(result_plr:getDataInt("param2")) local outfit_name = string.lower(tostring(result_plr:getDataString("param3"))) local itemvip = tonumber(result_plr:getDataInt("param4")) local add_item_type = tostring(result_plr:getDataString("param5")) local add_item_name = tostring(result_plr:getDataString("param6")) local points = tonumber(result_plr:getDataInt("param7")) local received_item = 0 local full_weight = 0 if(action == 'give_item') then full_weight = getItemWeightById(itemtogive_id, itemtogive_count) if isItemRune(itemtogive_id) == TRUE then full_weight = getItemWeightById(itemtogive_id, 1) else full_weight = getItemWeightById(itemtogive_id, itemtogive_count) end local free_cap = getPlayerFreeCap(cid) local new_item = doCreateItemEx(itemtogive_id, itemtogive_count) received_item = doPlayerAddItemEx(cid, new_item) if full_weight <= free_cap then if received_item == RETURNVALUE_NOERROR then doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, 'You received >> '.. add_item_name ..' << RELOGUE PARA SALVAR URGENTE.') db.executeQuery("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";") db.query("UPDATE `z_shop_history_item` SET `trans_state`='realized', `trans_real`=" .. os.time() .. " WHERE id = " .. id .. ";") else doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> '.. add_item_name ..' << from OTS shop is waiting for you. Please make place for this item in your backpack/hands and wait about '.. SQL_interval ..' seconds to get it.') end else doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, '>> '.. add_item_name ..' << from OTS shop is waiting for you. It weight is '.. full_weight ..' oz., you have only '.. free_cap ..' oz. free capacity. Put some items in depot and wait about '.. SQL_interval ..' seconds to get it.') end end if(action == 'give_outfit') then if outfit_name ~= "" and maleOutfits[outfit_name] and femaleOutfits[outfit_name] then local add_outfit = getPlayerSex(cid) == 0 and femaleOutfits[outfit_name][1] or maleOutfits[outfit_name][1] if not canPlayerWearOutfit(cid, add_outfit, 3) then db.query("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";") doSendMagicEffect(getCreaturePosition(cid), CONST_ME_GIFT_WRAPS) doPlayerAddOutfit(cid, add_outfit, 3) doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, "You received the outfit " .. add_item_name .. " of our Shop Online.") else doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, "You already have this outfit. Your points were returned, thank you.") db.query("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";") db.query("UPDATE `accounts` SET `premium_points` = `premium_points` + " .. points .. " WHERE `id` = " .. getPlayerAccountId(cid) .. ";") end end end end if not(result_plr:next()) then break end end result_plr:free() end return true end Testa esse aí.

Poste seu config lua.

Você saberia me dizer como crio essa coluna? Eu peguei um servidor só que a database dele não abre no meu mysql, ai tive que usar de outro que acaba dando todos esses erros, não manjo muito de sql se puder me ajudar com o comando é nos