Eu coloquei a VIP para vender pelo Gesior por este Link abaixo:

http://www.xtibia.com/forum/topic/142729-gesior-acc-vendedo-vip-pelo-pacc/

Fiz tudo certinho e quando eu vou testar para ver se a VIP está realmente indo para o char aparece esse erro abaixo:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'vip_time' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:610 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(610): PDO->query('SELECT `vip_tim...') #1 C:\xampp\htdocs\shopsystem.php(390): OTS_Account->getCustomField('vip_time') #2 C:\xampp\htdocs\index.php(196): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 610

Alguem sabe como retirar esse erro ?

Obrigado !

Outro erro pessoal no REPUTATION

Eu não consigo dar Look em nenhum Player mais consigo da Look nos monstro, isso eu me lembro que eu tenho que executar alguma coisa no MYSQL mais não lembro oque se puderem me ajudar...

E tem esse erro a baixo tambem que quando mata outro player o player nao morre na real ele fica vivo com 0 de life e tals... E quem matou fica ganhando -Rep sem parar o player so morre quando quem matou sai como da para ver ai abaixo o erro...

Quem poder me ajudar com esses dois erros eu dou +REP aki no site

[24/02/2011 03:07:15] [Error - CreatureScript Interface]

[24/02/2011 03:07:15] data/creaturescripts/scripts/rep/repKill.lua:onKill

[24/02/2011 03:07:15] Description:

[24/02/2011 03:07:15] data/lib/004-database.lua:60: [Result:getDataInt] Result not set!

[24/02/2011 03:07:15] stack traceback:

[24/02/2011 03:07:15] [C]: in function 'error'

[24/02/2011 03:07:15] data/lib/004-database.lua:60: in function 'getDataInt'

[24/02/2011 03:07:15] data/lib/050-function.lua:667: in function 'getRepPoints'

[24/02/2011 03:07:15] data/creaturescripts/scripts/rep/repKill.lua:6: in function <data/creaturescripts/scripts/rep/repKill.lua:1>

[24/02/2011 03:07:16] Test has logged out.

[24/02/2011 03:07:16] T has logged out.

[24/02/2011 03:07:38] T has logged in.

[24/02/2011 03:07:41] mysql_real_query(): SELECT `rep` FROM `players` WHERE `id` = 11; - MYSQL ERROR: Unknown column 'rep' in 'field list' (1054)

Crie um arquivo chamado vip_time.sql e cole isto dentro:

SELECT COUNT(*) AS `Registros`, `vip_time` FROM `accounts` GROUP BY `vip_time` ORDER BY `vip_time`

Agora vá no seu database, abra a tabela Accounts e Clique em Importar agora só selecionar o arquivo vip_time.sql

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'vip_time' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:610 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(610): PDO->query('SELECT `vip_tim...') #1 C:\xampp\htdocs\shopsystem.php(390): OTS_Account->getCustomField('vip_time') #2 C:\xampp\htdocs\Index.php(196): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 610

Isso ainda continua a me atormentar --'

#1054 - Unknown column 'vip_time' in 'field list'

SELECT COUNT( * ) AS `Registros` , `vip_time`

FROM `accounts`

GROUP BY `vip_time`

ORDER BY `vip_time`

LIMIT 0 , 30

Não sei se importo

Você criou o arquivo no formato .sql ?

qual seu sistema Vip?

Criei no formato .sql sim.

Meu sistema VIP

http://www.xtibia.com/forum/topic/136543-vip-system-by-account-v10/

Execute isso em sua tabela:

alter table `accounts` add `vip_time` INT NOT NULL;

abrçs

Caso ajudei rep+

Obrigado (:

Alguem sabe me dizer porque que mesmo assim o PACC não está indo para o char ? '-'

Tem que configurar no ot para receber os items e Pacc.

Vá em \data\globalevents\scripts , crie um arquivo shop.lua e cole isto:

-- ### CONFIG ###
-- message send to player by script "type" (types you can check in "global.lua")
SHOP_MSG_TYPE = 19
-- time (in seconds) between connections to SQL database by shop script
SQL_interval = 30
-- ### END OF CONFIG ###
function onThink(interval, lastExecution)
   local result_plr = db.getResult("SELECT * FROM z_ots_comunication WHERE `type` = 'login';")
   if(result_plr:getID() ~= -1) then
       while(true) do
           id = tonumber(result_plr:getDataInt("id"))
           action = tostring(result_plr:getDataString("action"))
           delete = tonumber(result_plr:getDataInt("delete_it"))
           cid = getCreatureByName(tostring(result_plr:getDataString("name")))
           if isPlayer(cid) == TRUE then
               local itemtogive_id = tonumber(result_plr:getDataInt("param1"))
               local itemtogive_count = tonumber(result_plr:getDataInt("param2"))
               local container_id = tonumber(result_plr:getDataInt("param3"))
               local container_count = tonumber(result_plr:getDataInt("param4"))
               local add_item_type = tostring(result_plr:getDataString("param5"))
               local add_item_name = tostring(result_plr:getDataString("param6"))
               local received_item = 0
               local full_weight = 0
               if add_item_type == 'container' then
                   container_weight = getItemWeightById(container_id, 1)
                   if isItemRune(itemtogive_id) == TRUE then
                       items_weight = container_count * getItemWeightById(itemtogive_id, 1)
                   else
                       items_weight = container_count * getItemWeightById(itemtogive_id, itemtogive_count)
                   end
                   full_weight = items_weight + container_weight
               else
                   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
               end
               local free_cap = getPlayerFreeCap(cid)
               if full_weight <= free_cap then
                   if add_item_type == 'container' then
                       local new_container = doCreateItemEx(container_id, 1)
                       local iter = 0
                       while iter ~= container_count do
                           doAddContainerItem(new_container, itemtogive_id, itemtogive_count)
                           iter = iter + 1
                       end
                       received_item = doPlayerAddItemEx(cid, new_container)
                   else
                       local new_item = doCreateItemEx(itemtogive_id, itemtogive_count)
                       received_item = doPlayerAddItemEx(cid, new_item)
                   end
                   if received_item == RETURNVALUE_NOERROR then
                       doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, 'You received >> '.. add_item_name ..' << from OTS shop.')
                       db.executeQuery("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";")
                       db.executeQuery("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 not(result_plr:next()) then
               break
           end
       end
       result_plr:free()
   end
   return TRUE
end

agora abra o arquivo globalevents.xml adicione a TAG:

<globalevent name="shop" interval="30" script="shop.lua"/>

E como o seu Vip system é feito pelo Kydrai, tente usar este script no lugar do antigo caso você usou outro.

                                        if($buy_offer['type'] == 'pacc') {
                                           $player_viptime = $buy_player_account->getCustomField('viptime');
                                           $player_lastlogin = $buy_player_account->getCustomField('lastday');
                                           $save_transaction = 'INSERT INTO '.$SQL->tableName('z_shop_history_pacc').' (id, to_name, to_account, from_nick, from_account, price, pacc_days, trans_state, trans_start, trans_real) VALUES (NULL, '.$SQL->quote($buy_player->getName()).', '.$SQL->quote($buy_player_account->getId()).', '.$SQL->quote($buy_from).',  '.$SQL->quote($account_logged->getId()).', '.$SQL->quote($buy_offer['points']).', '.$SQL->quote($buy_offer['days']).', \'realized\', '.$SQL->quote(time()).', '.$SQL->quote(time()).');';
                                           $SQL->query($save_transaction);
                                           if($player_viptime > 0)
                                               $buy_player_account->setCustomField('viptime', $player_viptime + $buy_offer['days'] * 86400);
                                           else
                                               $buy_player_account->setCustomField('viptime', time() + $buy_offer['days'] * 86400);
                                           $buy_player_account->setCustomField('premium_points', $user_premium_points-$buy_offer['points']);
                                           $user_premium_points = $user_premium_points - $buy_offer['points'];
                                           if ($player_vip_days >= 1) {
                                           }
                                           $main_content .= '<center><h2>VIP Days added!</h2><b>'.$buy_offer['days'].' days</b> of VIP days added to the account of player <b>'.$buy_player->getName().'</b> for <b>'.$buy_offer['points'].' premium points</b> from your account.<br />Now you have <b>'.$user_premium_points.' premium points</b>.<br><br><a href="index.php?subtopic=shopsystem">Go to Shop Site</a><br>';
                                           }

Você fez exatamente oque manda o topico.?

http://www.xtibia.com/forum/topic/142729-gesior-acc-vendedo-vip-pelo-pacc/

Peço que va ate a coluna accounts e mande o numero que foi adicionado apos você comprar a vip em Vip_time

abrçs

@NoHeAD

Aee pegou Muito obrigado leke :*

@FagnerBoff

Sim. já conseguir ...

@all

Pessoal outro erro aqui

Na hora de entregar o Item aparece a seguinte mensagem:

19:53 >> 1 << from OTS shop is waiting for you. Please make place for this item in your backpack/hands and wait about 30 seconds to get it.

E no executavel do sv.

[24/02/2011 19:53:32] [Error - GlobalEvent Interface]

[24/02/2011 19:53:32] data/globalevents/scripts/shop.lua:onThink

[24/02/2011 19:53:32] Description:

[24/02/2011 19:53:32] (luaDoAddContainerItem) Container not found

Eu sei que a mensagem:

19:53 >> 1 << from OTS shop is waiting for you. Please make place for this item in your backpack/hands and wait about 30 seconds to get it.

È normal... mais o erro no executavel não :s

E o item não chega até o player...

Amanhã vou REP em quem ta me ajudando hoje ja chegou no limite.

[24/02/2011 19:53:32] [Error - GlobalEvent Interface] 
[24/02/2011 19:53:32] data/globalevents/scripts/shop.lua:onThink
[24/02/2011 19:53:32] Description: 
[24/02/2011 19:53:32] (luaDoAddContainerItem) Container not found

Não está achando o Container(Backpack, Bag, etc.) certifique-se que você esta usando uma backpack.

Ou então... Tente esse script no lugar do shop.lua :

-- FIXED BY Cybermaster && Kekox © OTLand.net
-- ### CONFIG ###
-- message send to player by script "type" (types you can check in "global.lua")
SHOP_MSG_TYPE = 19
-- time (in seconds) between connections to SQL database by shop script
SQL_interval = 30
-- ### END OF CONFIG ###
function onThink(interval, lastExecution)
   local result_plr = db.getResult("SELECT * FROM z_ots_comunication WHERE `type` = 'login';")
   if(result_plr:getID() ~= -1) then
       while(true) do
           id = tonumber(result_plr:getDataInt("id"))
           action = tostring(result_plr:getDataString("action"))
           delete = tonumber(result_plr:getDataInt("delete_it"))
           cid = getCreatureByName(tostring(result_plr:getDataString("name")))
           if isPlayer(cid) == TRUE then
                   local itemtogive_id = tonumber(result_plr:getDataInt("param3"))
                   local itemtogive_count = tonumber(result_plr:getDataInt("param2"))
                   local container_id = tonumber(result_plr:getDataInt("param1"))
                   local container_count = tonumber(result_plr:getDataInt("param4"))
                   local add_item_type = tostring(result_plr:getDataString("param5"))
                   local add_item_name = tostring(result_plr:getDataString("param6"))
                   local received_item = 0
                   local full_weight = 0
                   if add_item_type == 'container' then
                       container_weight = getItemWeightById(container_id, 1)
                       if isItemRune(itemtogive_id) == TRUE then
                           items_weight = container_count * getItemWeightById(itemtogive_id, 1)
                       else
                           items_weight = container_count * getItemWeightById(itemtogive_id, itemtogive_count)
                       end
                       full_weight = items_weight + container_weight
                   else
                       full_weight = getItemWeightById(container_id, itemtogive_count)
                           if isItemRune(container_id) == TRUE then
                           full_weight = getItemWeightById(container_id, 1)
                       else
                           full_weight = getItemWeightById(container_id, itemtogive_count)
                       end
                   end
                   local free_cap = getPlayerFreeCap(cid)
                   if full_weight <= free_cap then
                       if add_item_type == 'container' then
                           local new_container = doCreateItemEx(container_id, 1)
                           local iter = 0
                           while iter ~= container_count do
                               doAddContainerItem(new_container, itemtogive_id, itemtogive_count)
                               iter = iter + 1
                           end
                           received_item = doPlayerAddItemEx(cid, new_container)
                       else
                           local new_item = doCreateItemEx(container_id, itemtogive_count)
                           received_item = doPlayerAddItemEx(cid, new_item)
                       end
                       if received_item == RETURNVALUE_NOERROR then
                           doPlayerSave(cid, true)
                           doPlayerSendTextMessage(cid, SHOP_MSG_TYPE, 'You received >> '.. add_item_name ..' << from Shop.')
                           db.executeQuery("DELETE FROM `z_ots_comunication` WHERE `id` = " .. id .. ";")
                           db.executeQuery("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 Prison Break 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 Spider 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 not(result_plr:next()) then
               break
           end
       end
       result_plr:free()
   end
   return TRUE
end

Fiz um teste e descobri, Ambos scripts passados para mim do SHOP.LUA aqui no Topico estáva bom pois o Item que eu estou tentando passar pode tá com o Item ID errado ou não existir o item pois tentei com o Item ID 2160, 2323 e pegou...

+REP na galera que me ajudou.

*---*

FagnerBoff uuuhhhhh gostosa

pok302010, cuidado com seus comentários brother. Você pode ser alertado por comentários sem sentido e sem relação com o tópico.

Abraços