Kuzaro

Eu não sei o que acontece mas eu executo tudo e não excluo os itens das casas não entendo o que está acontecendo

http://prntscr.com/m9waun http://prntscr.com/m9wazl o player não existe mais Não funciona: S " DELETE FROM `tile_items`; "

esses itens não aparecem quando abro o mapa na rme

http://prntscr.com/m9w1vr esta é minha tile_items : S eu não entendo

Como ajudo a apagar todos os itens das casas? Eu fiz uma redefinição de contas, mas os itens das casas ainda estão lá!

database please!

como eu abrir o servidor? onde você baixou as DLLs e exe? ou como eu compilar?

Tengo gessior acc de los viejos e intento colocar sistema paypal pero al momento de entregar los puntos despues de haber hecho el pago no los entega :s no entiendo que esta pasando si alguien puede ayudarme le agradeceria mucho ! aqui dejo los scripts paypal.htm <?php $main_content .= ' <b>Danera donation system.</b><br><br> <b>Los pasos para comprar:</b> <br> 1. una cuenta PayPal con un saldo de [1, 5, o 10 USD] o una tarjeta de credito. <br> 2. Coloca tu Account. <br> 3. Click en el boton de donar o tarjeta de credito. <br> 4. Haz la transaaccion. <br> 5. Luego añadiras, 2, 10 o 30 puntos a tu cuenta. <br> 6. Ve a la tineda para gastar tus puntos <br> <br> <br> </b> <span style="color:red">En caso de que los puntos no se sumen automaticamente manda un correo a <b>[email protected]</b> con el account y correo desde que se hizo la transaccion.</span> <form action="https://www.paypal.com/cgi-bin/webscr" method="post"> <input type="hidden" name="cmd" value="_donations"> <input type="hidden" name="business" value="[email protected]"> <input type="hidden" name="lc" value="US"> <input type="hidden" name="item_name" value="Donation Points"> <b>Account name/login:</b> <input type="text" name="custom" value=""> <select name="amount"> <option value="0.01">0.01 USD</option> <option value="5.00">5 USD</option> <option value="10.00">10 USD</option> </select> <input type="hidden" name="button_subtype" value="products"> <input type="hidden" name="currency_code" value="USD"> <input type="hidden" name="no_shipping" value="0"> <input type="hidden" name="currency_code" value="USD"> <input type="hidden" name="notify_url" value="http://danera.sytes.net/ipn/ipn.php"> <input type="hidden" name="return" value="http://danera.sytes.net"> <input type="hidden" name="rm" value="0"> <input type="hidden" name="bn" value="PP-BuyNowBF:btn_buynowCC_LG.gif:NonHostedGuest"> <input type="image" src="https://www.paypalobjects.com/en_US/i/btn/btn_donateCC_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!"> <img alt="" border="0" src="https://www.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1"> </form>'; y acá el Ipn <?php if ($_REQUEST['debug']) { ini_set("display_errors", True); error_reporting(E_ALL); } $mysql_host = 'localhost'; //Leave at localhost $mysql_user = 'root'; //DB User $mysql_pass = miclave'; //DB Pass $mysql_db = 'mibasededatos'; //DB Name $file = 'paypal.log'; //Paypal Log Name will be placed in the same location as your ipn.php file $payer_email = $_REQUEST['payer_email']; $ip = $_SERVER['REMOTE_ADDR']; $ips = array('173.0.81.1','173.0.81.33','66.211.170.66'); if(!in_array($ip, $ips)) { print "Scammer.. Your IP has been logged and forwarded to the server owner."; $hak = fopen("scammer.log", "a"); fwrite($hak, "$ip \r\n"); fclose($hak); die(0); } $time = date("F j, Y, g:i a"); $paylist = array("0.01" => 2, "5.00" => 10, "30.00"); // connect db $db = mysql_connect($mysql_host, $mysql_user, $mysql_pass); $custom = stripslashes(ucwords(strtolower(trim($_REQUEST['custom'])))); $receiver_email = $_REQUEST['receiver_email']; $payment_status = $_REQUEST['payment_status']; $mc_gross = $_REQUEST['mc_gross']; $mc_currency = $_REQUEST['mc_currency']; mysql_select_db($mysql_db, $db); if ($_REQUEST['debug']){ print $payment_status . '\n'; print (isset($paylist[$mc_gross])) ? 1 : 0 . '\n'; print $receiver_email . '\n'; print $custom . '\n'; } if ($payment_status == "Completed" && $receiver_email == "[email protected]" && isset($paylist[$mc_gross]) && $mc_currency == "USD") { $qry2 = "UPDATE accounts SET premium_points = premium_points + {$paylist[$mc_gross]} WHERE name = '$custom'"; $qry2 = "UPDATE accounts SET premium_points = premium_points + {$paylist[$mc_gross]} WHERE name = '$custom'"; // Log Paypal Transaction $hak = fopen($file, "a"); fwrite($hak, $somecode); fclose($hak); $result2 = mysql_query($qry2); } else { echo("Error."); } ?> gracias de antemano

sim globalevents?

Bons amigos à noite, preciso de um favor, se eles podem ajudar na seguinte roteiro, eu preciso de você para entrar em um metros quadrados este invocar um demônio, mas pode ser ativado apenas uma vez a cada 5 minutos. obrigado antecipadamente

eu uso o tfs 0.4

UP

[13:28:42.220] [Error - TalkAction Interface] [13:28:42.222] domodlib("lms_config") [13:28:42.222] function onSay(cid, words, param) [13:28:42.223] local storage, playerJoined, counter = getCreatureStorage(cid, configFire.storage), {}, getStorage(configFire.countPlayerStorage) [13:28:42.224] if getStorage(configFire.joinEventStorage) == 1 then [13:28:42.225] if(param == '') then [13:28:42.225] return doPlayerSendTextMessage(cid, MESSAGE_STATUS_SMALL, 'Command param required (say: "!event join" or "!event leave").') [13:28:42.226] end [13:28:42.226] if configFire.minLevel ~= nil then [13:28:42.227] if getPlayerLevel(cid) < configFire.minLevel then [13:28:42.227] return doPlayerSendTextMessage(cid, MESSAGE_STATUS_SMALL, 'You cannot join The Fire Storm Event if you do not have a require level. [' .. configFire.minLevel .. ']') [13:28:42.228] end [13:28:42.228] end [13:28:42.230] if getTileInfo(getThingPos(cid)).protection ~= true then [13:28:42.233] return doPlayerSendTextMessage(cid, MESSAGE_STATUS_SMALL, 'You cannot join The Fire Storm Event if you are not in a Protection Zone.') [13:28:42.233] end [13:28:42.234] if exhaustion.check(cid, configFire.exhaustStorage) ~= false then [13:28:42.235] return doPlayerSendTextMessage(cid, MESSAGE_STATUS_SMALL, 'You must wait' .. exhaustion.get(cid, configFire.exhaustStorage) .. ' seconds.') [13:28:42.235] end [13:28:42.236] if param == 'join' then [13:28:42.236] if storage <= 0 then [13:28:42.236] if counter ~= configFire.maxPlayers - 1 then [13:28:42.237] doSetStorage(configFire.countPlayerStorage, 0) [13:28:42.237] for _, pid in ipairs(getPlayersOnline()) do [13:28:42.238] if getCreatureStorage(pid, configFire.storage) > 0 then [13:28:42.238] table.insert(playerJoined, pid) [13:28:42.239] doSetStorage(configFire.countPlayerStorage, #playerJoined) [13:28:42.239] end [13:28:42.239] end [13:28:42.240] local count = getStorage(configFire.countPlayerStorage) [13:28:42.243] doPlayerSendTextMessage(cid, MESSAGE_EVENT_ORANGE, count == 0 and 'You are first in the fire storm event.' or count == 1 and 'There is 1 player in fire storm event.' or count > 1 and 'There are '.. count ..' players in fire storm event.') [13:28:42.244] doCreatureSetStorage(cid, configFire.storage, 1) [13:28:42.247] doCreatureSetNoMove(cid, true) [13:28:42.248] local condition = createConditionObject(CONDITION_INFIGHT,-1) [13:28:42.250] doAddCondition(cid, condition) [13:28:42.250] doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, 'You have joined the Fire Storm Event, You may not move until the Event has started please wait patiently...') [13:28:42.251] else [13:28:42.251] doPlayerSendTextMessage(cid, MESSAGE_STATUS_SMALL, 'Max players in event have been reached.') [13:28:42.254] end [13:28:42.254] else [13:28:42.255] doPlayerSendTextMessage(cid, MESSAGE_STATUS_SMALL, 'You already joined the Event, Wait patiently for it to start.') [13:28:42.256] end [13:28:42.256] elseif param == 'leave' then [13:28:42.256] if storage > 0 then [13:28:42.257] doCreatureSetNoMove(cid, false) [13:28:42.258] doRemoveCondition(cid, CONDITION_INFIGHT) [13:28:42.259] doCreatureSetStorage(cid, configFire.storage, -1) [13:28:42.260] doPlayerSendTextMessage(cid, MESSAGE_EVENT_ORANGE, 'You have left the Fire Run Event, And you can move now.') [13:28:42.260] else [13:28:42.261] doPlayerSendTextMessage(cid, MESSAGE_STATUS_SMALL, 'You cannot leave The Fire Storm Event.') [13:28:42.261] end [13:28:42.262] end [13:28:42.265] else [13:28:42.267] doPlayerSendTextMessage(cid, MESSAGE_STATUS_SMALL, 'You cannot join/leave The Fire Storm Event yet.') [13:28:42.269] end [13:28:42.270] exhaustion.set(cid, configFire.exhaustStorage, 5) [13:28:42.271] return true [13:28:42.272] end [13:28:42.272] :onSay [13:28:42.273] Description: [13:28:42.276] data/lib/034-exhaustion.lua:8: field 'day' missing in date table [13:28:42.276] stack traceback: [13:28:42.277] [C]: in function 'time' [13:28:42.277] data/lib/034-exhaustion.lua:8: in function 'check' [13:28:42.278] [string "LuaInterface::loadBuffer"]:21: in function <[string "LuaInterface::loadBuffer"]:3> este erro depois de eu dizer !fire join tfs 0.4 <?xml version="1.0" encoding="UTF-8"?> <mod name="Fire Storm Event" version="1.0" author="iFate" contact="otland.net/members/iFate/" enabled="yes"> <config name="lms_config"> <![CDATA[ configFire = { storage = 8998, -- set free storage eventStorage = 6254, -- set free storage joinEventStorage = 5535, -- set free storage countPlayerStorage = 7373, -- set free storage exhaustStorage = 8387, maxPlayers = 50, -- max players in event teleportPos = {x=32435 ,y=32486,z=7}, -- position to which player is teleporting rewardID = {9693}, -- reward id which player can win (reward is random) minLevel = 1, -- minimum of level with which player can join to event days = { ['Monday'] = {'18:00:00'}, ['Tuesday'] = {'18:00:00'}, ['Wednesday'] = {'18:00:00'}, ['Thursday'] = {'18:00:00'}, ['Friday'] = {'18:00:00'}, ['Saturday'] = {'18:00:00'}, ['Sunday'] = {'18:00:00'} }, minPlayers = 2, delayTime = 3.0, -- time in which players who joined to event are teleporting to teleport position timeToStartEvent = 30 -- time from teleport to start event } arena = {fromPos = {x=32435,y=32486,z=7}, -- left top corner of event room toPos = {x=32467,y=32512,z=7} -- right bottom corner of event room } y, x = 1, 1 ]]> </config> <lib name="lms_fire_lib"> <![CDATA[ function doStartEvent() doSetStorage(configFire.joinEventStorage, -1) if configFire.minPlayers <= getStorage(configFire.countPlayerStorage) + 1 then for _, cid in ipairs(getPlayersOnline()) do if getCreatureStorage(cid, configFire.storage) == 1 then addEvent(doSetStorage, configFire.timeToStartEvent * 1000, configFire.eventStorage, 1) doCreatureSetStorage(cid, configFire.storage, -1) doCreatureSetNoMove(cid, false) doRemoveCondition(cid, CONDITION_INFIGHT) doTeleportThing(cid, configFire.teleportPos) doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, 'Get ready, The Event will start in ' .. configFire.timeToStartEvent .. ' seconds.') end end else for _, cid in ipairs(getPlayersOnline()) do if getCreatureStorage(cid, configFire.storage) == 1 then doCreatureSetNoMove(cid, false) doRemoveCondition(cid, CONDITION_INFIGHT) end end doBroadcastMessage('The fire storm event has not started because not enough players joined.', MESSAGE_EVENT_ADVANCE) end doSetStorage(configFire.countPlayerStorage, 0) end ]]> </lib> <talkaction words="!event" event="script"> <![CDATA[ domodlib("lms_config") function onSay(cid, words, param) local storage, playerJoined, counter = getCreatureStorage(cid, configFire.storage), {}, getStorage(configFire.countPlayerStorage) if getStorage(configFire.joinEventStorage) == 1 then if(param == '') then return doPlayerSendTextMessage(cid, MESSAGE_STATUS_SMALL, 'Command param required (say: "!event join" or "!event leave").') end if configFire.minLevel ~= nil then if getPlayerLevel(cid) < configFire.minLevel then return doPlayerSendTextMessage(cid, MESSAGE_STATUS_SMALL, 'You cannot join The Fire Storm Event if you do not have a require level. [' .. configFire.minLevel .. ']') end end if getTileInfo(getThingPos(cid)).protection ~= true then return doPlayerSendTextMessage(cid, MESSAGE_STATUS_SMALL, 'You cannot join The Fire Storm Event if you are not in a Protection Zone.') end if exhaustion.check(cid, configFire.exhaustStorage) ~= false then return doPlayerSendTextMessage(cid, MESSAGE_STATUS_SMALL, 'You must wait' .. exhaustion.get(cid, configFire.exhaustStorage) .. ' seconds.') end if param == 'join' then if storage <= 0 then if counter ~= configFire.maxPlayers - 1 then doSetStorage(configFire.countPlayerStorage, 0) for _, pid in ipairs(getPlayersOnline()) do if getCreatureStorage(pid, configFire.storage) > 0 then table.insert(playerJoined, pid) doSetStorage(configFire.countPlayerStorage, #playerJoined) end end local count = getStorage(configFire.countPlayerStorage) doPlayerSendTextMessage(cid, MESSAGE_EVENT_ORANGE, count == 0 and 'You are first in the fire storm event.' or count == 1 and 'There is 1 player in fire storm event.' or count > 1 and 'There are '.. count ..' players in fire storm event.') doCreatureSetStorage(cid, configFire.storage, 1) doCreatureSetNoMove(cid, true) local condition = createConditionObject(CONDITION_INFIGHT,-1) doAddCondition(cid, condition) doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, 'You have joined the Fire Storm Event, You may not move until the Event has started please wait patiently...') else doPlayerSendTextMessage(cid, MESSAGE_STATUS_SMALL, 'Max players in event have been reached.') end else doPlayerSendTextMessage(cid, MESSAGE_STATUS_SMALL, 'You already joined the Event, Wait patiently for it to start.') end elseif param == 'leave' then if storage > 0 then doCreatureSetNoMove(cid, false) doRemoveCondition(cid, CONDITION_INFIGHT) doCreatureSetStorage(cid, configFire.storage, -1) doPlayerSendTextMessage(cid, MESSAGE_EVENT_ORANGE, 'You have left the Fire Run Event, And you can move now.') else doPlayerSendTextMessage(cid, MESSAGE_STATUS_SMALL, 'You cannot leave The Fire Storm Event.') end end else doPlayerSendTextMessage(cid, MESSAGE_STATUS_SMALL, 'You cannot join/leave The Fire Storm Event yet.') end exhaustion.set(cid, configFire.exhaustStorage, 5) return true end ]]> </talkaction> <talkaction words="!startfire" access="5" event="script"> <![CDATA[ domodlib("lms_config") domodlib("lms_fire_lib") function onSay(cid, words, param) doBroadcastMessage('Fire Storm Event will start in ' .. configFire.delayTime .. ' minutes. You can join the Fire Storm Event by using this command "!event join".', MESSAGE_EVENT_ADVANCE) for _, pid in ipairs(getPlayersOnline()) do if getCreatureStorage(pid, configFire.storage) == 1 then doCreatureSetStorage(pid, configFire.storage, -1) doSetStorage(configFire.countPlayerStorage, 0) doTeleportThing(pid, getTownTemplePosition(getPlayerTown(pid)), true) end end doSetStorage(configFire.joinEventStorage, 1) addEvent(doStartEvent, configFire.delayTime * 60 * 1000) return true end ]]> </talkaction> <event type="think" name="LMS_Event_Start" event="script"> <![CDATA[ domodlib("lms_config") domodlib("lms_fire_lib") local daysOpen = {} for k, v in pairs(configFire.days) do table.insert(daysOpen, k) end function onThink(cid, interval) if isInArray(daysOpen, os.date('%A')) then if isInArray(configFire.days[os.date('%A')], os.date('%X', os.time())) then if getStorage(configFire.joinEventStorage) ~= 1 then doBroadcastMessage('Fire Storm Event will start in '.. configFire.delayTime ..' minutes. You can join the event by typing "!event join".', MESSAGE_EVENT_ADVANCE) for _, pid in ipairs(getPlayersOnline()) do if getCreatureStorage(pid, configFire.storage) == 1 then doCreatureSetStorage(pid, configFire.storage, -1) doSetStorage(configFire.countPlayerStorage, 0) doTeleportThing(pid, getTownTemplePosition(getPlayerTown(pid)), true) end end doSetStorage(configFire.joinEventStorage, 1) addEvent(doStartEvent, configFire.delayTime * 60 * 1000) end end end return true end ]]> </event> <globalevent name="LMS_Event" interval="1000" event="script"> <![CDATA[ domodlib("lms_config") function onThink(interval, lastExecution) if getStorage(configFire.eventStorage) == 1 then local xTable, yTable, playerTable = {}, {}, {} for x = arena.fromPos.x, arena.toPos.x do for y = arena.fromPos.y, arena.toPos.y do table.insert(xTable, x) table.insert(yTable, y) local n, i = getTileInfo({x=x, y=y, z=7}).creatures, 1 if n ~= 0 then local v = getThingfromPos({x=x, y=y, z=7, stackpos=i}).uid while v ~= 0 do if isPlayer(v) then table.insert(playerTable, v) if n == #playerTable then break end end i = i + 1 v = getThingfromPos({x=x, y=y, z=7, stackpos=i}).uid end end end end if #playerTable == 1 then local prize = math.random(#configFire.rewardID) doTeleportThing(playerTable[1], getTownTemplePosition(getPlayerTown(playerTable[1])), true) doPlayerAddItem(playerTable[1], configFire.rewardID[prize], 1) doPlayerSendTextMessage(playerTable[1], MESSAGE_EVENT_ADVANCE, 'You win. Your reward is ' .. getItemNameById(configFire.rewardID[prize]) .. '.') doBroadcastMessage('Fire Storm Event have finished. The winner is ' .. getCreatureName(playerTable[1]) .. '. Congratulations.', MESSAGE_EVENT_ADVANCE) doSetStorage(configFire.eventStorage, -1) x, y = 1, 1 elseif #playerTable > 1 then for a = 1, y do local pos = {x=xTable[math.random(#xTable)], y=yTable[math.random(#yTable)], z=7} for _, player in ipairs(playerTable) do local pPos = getThingPos(player) if pPos.x == pos.x and pPos.y == pos.y and pPos.z == pos.z then doCreatureAddHealth(player, - getCreatureMaxHealth(player)) end end doSendDistanceShoot({x = pos.x - math.random(4, 6), y = pos.y - 5, z = pos.z}, pos, CONST_ANI_FIRE) addEvent(doSendMagicEffect, 150, pos, CONST_ME_HITBYFIRE) addEvent(doSendMagicEffect, 150, pos, CONST_ME_FIREAREA) end if x == 5 * y then y = y + 1 end x = x + 1 else doBroadcastMessage('No one Won the Fire Storm Event.', MESSAGE_EVENT_ADVANCE) doSetStorage(configFire.eventStorage, -1) x, y = 1, 1 end end return true end ]]> </globalevent> <event type="login" name="LMS_Fire_login" event="script"> <![CDATA[ function onLogin(cid) if getCreatureStorage(cid, configFire.storage) == 1 then doCreatureSetStorage(cid, configFire.storage, -1) doTeleportThing(cid, getTownTemplePosition(getPlayerTown(cid)), true) doCreatureSetNoMove(cid, false) doRemoveCondition(cid, CONDITION_INFIGHT) end registerCreatureEvent(cid, "LMS_fire_dead") registerCreatureEvent(cid, "LMS_Event_Start") return true end ]]> </event> <event type="statschange" name="LMS_fire_dead" event="script"> <![CDATA[ domodlib("lms_config") function onStatsChange(cid, attacker, type, combat, value) if type == 1 and getCreatureHealth(cid) <= value then if isInRange(getThingPos(cid), arena.fromPos, arena.toPos) then doCreatureAddHealth(cid, - getCreatureHealth(cid) + 1) doCreatureAddMana(cid, - getCreatureMana(cid)) doTeleportThing(cid, getTownTemplePosition(getPlayerTown(cid))) doPlayerSendTextMessage(cid, MESSAGE_EVENT_ADVANCE, 'You have lost the Fire Storm Event.') return false end end return true end ]]> </event> </mod> SCRIPT!

mysql_real_query(): UPDATE `players` SET `rank_id` = 0, `guildnick` = '', `guildjoin` = 0 WHERE `rank_id` IN (1,2,3); - MYSQL ERROR: Unknown column 'guildjoin' in 'field list' (1054) alguem sabe?

UP