Ошибка Квеста

iPerfect · 28 ноября, 2012

Люди Нужна ваша помощь, установил аукцион на сервер.

Но он выдает ошибку.

Вот собственно квест и ошибка:

Ошибка:

Error on: C:\server\data\scripts\custom\purchase\__init__.py.error.log

Line: -1 - Column: -1

Traceback (innermost last):

(no code object) at line 0

SyntaxError: ('invalid syntax', ('__init__.py', 80, 4, ' finally:'))

и сам скрипт:

# -*- coding: utf-8 -*-

import sys

from javolution.text import TextBuilder

from net.sf.l2j import L2DatabaseFactory

from net.sf.l2j.gameserver.datatables import AugmentationData

from net.sf.l2j.gameserver.datatables import ItemTable

from net.sf.l2j.gameserver.datatables import SkillTable

from net.sf.l2j.gameserver.model import L2Augmentation

from net.sf.l2j.gameserver.model import L2ItemInstance

from net.sf.l2j.gameserver.model import L2Skill

from net.sf.l2j.gameserver.model import L2World

from net.sf.l2j.gameserver.model.quest import State

from net.sf.l2j.gameserver.model.quest import QuestState

from net.sf.l2j.gameserver.model.quest.jython import QuestJython as JQuest

from net.sf.l2j.gameserver.network import SystemMessageId

from net.sf.l2j.gameserver.network.serverpackets import ExMailArrived

from net.sf.l2j.gameserver.network.serverpackets import ItemList

from net.sf.l2j.gameserver.network.serverpackets import SystemMessage

from net.sf.l2j.gameserver.templates import L2Item

from net.sf.l2j.util import Rnd

from net.sf.l2j.gameserver.util import Util

from time import gmtime, strftime

qn = "purchase"

MARKET = 80007

PAGE_LIMIT = 10

SORT_LIMIT = 8

MAX_ADENA = 2147000000

FORBIDDEN = [6611,6612,6613,6614,6615,6616,6617,6618,6619,6620,6621]

#

CENCH = "CCCC33"

CPRICE = "669966"

CITEM = "993366"

CAUG1 = "333366"

CAUG2 = "006699"

moneys = {4037: "Coin Of Luck", 4355: "Blue Eva", 5962: "Gold Golem"}

sorts = {0: "Оружие", 1: "Броня", 2: "Бижутерия"}

class Quest (JQuest) :

def __init__(self,id,name,descr): JQuest.__init__(self,id,name,descr)

def init_LoadGlobalData(self) :

print "purchase: ok"

def closeStat(self,st):

if st != None:

st.close()

return

def closeRes(self,rs):

if rs != None:

rs.close()

return

def closeCon(self,con):

if con != None:

con.close()

return

def getIcon(self,con,iid):

icon = "Icon.NOIMAGE"

ext = False

try:

if con == None:

ext = True

con=L2DatabaseFactory.getInstance().getConnection()

st = con.prepareStatement("SELECT itemIcon FROM `z_market_icons` WHERE `itemId`=? LIMIT 1");

st.setInt(1, iid);

rs = st.executeQuery();

if rs.next():

icon = rs.getString("itemIcon")

except:

pass

finally:

self.closeRes(rs)

self.closeStat(st)

if ext:

self.closeCon(con)

return icon

def getMoneyCall(self,money):

return moneys.get(money, str("Adena"))

def getSellerName(self,con,charId):

name = "???"

try:

st = con.prepareStatement("SELECT char_name FROM `characters` WHERE `Obj_Id`=? LIMIT 1");

st.setInt(1, charId);

rs = st.executeQuery();

if rs.next():

name = rs.getString("char_name")

except:

pass

finally:

self.closeRes(rs)

self.closeStat(st)

return name

def getAugmentSkill(self, aid, lvl):

augment = SkillTable.getInstance().getInfo(aid, 1)

if augment == None:

return ""

augName = augment.getName();

stype = "Шанс";

if augment.isActive():

stype = "Актив"

elif augment.isPassive():

stype = "Пассив"

augName = augName.replace("Item Skill: ", "");

return "<font color="+CAUG1+">Аугмент:</font> <font color="+CAUG2+">" + augName + " (" + stype + ":" + str(lvl) + "lvl)</font>";

def getPageCount(self, con, me, itemId, augment, type2, charId):

rowCount = 0

pages = 0

try:

con=L2DatabaseFactory.getInstance().getConnection()

if type2 >= 0:

st=con.prepareStatement("SELECT COUNT(`id`) FROM `z_stock_items` WHERE `type` = ?")

st.setInt(1, type2)

elif itemId > 0:

st=con.prepareStatement("SELECT COUNT(`id`) FROM `z_stock_items` WHERE `itemId` = ?")

st.setInt(1, itemId)

elif augment > 0:

st=con.prepareStatement("SELECT COUNT(`id`) FROM `z_stock_items` WHERE `augment` = ?")

st.setInt(1, augment)

elif me == 1:

st=con.prepareStatement("SELECT COUNT(`id`) FROM `z_stock_items` WHERE `ownerId` = ?")

st.setInt(1, charId)

else:

st=con.prepareStatement("SELECT COUNT(`id`) FROM `z_stock_items` WHERE `id` > 0")

rs=st.executeQuery()

if (rs.next()):

rowCount = rs.getInt(1)

except :

pass

finally:

self.closeRes(rs)

self.closeStat(st)

if rowCount == 0:

return "0"

pages = (rowCount / PAGE_LIMIT) + 1

return str(pages)

def error(self,action, text):

return "<html><body> " + action + ": <br> " + text + "</body></html>"

def transferPay(self,con,charId,itemId,enchant,augment,auhLevel,price,money):

item = ItemTable.getInstance().getTemplate(itemId)

if item == None:

return False

data = str(strftime("%Y-%m-%d", gmtime()))

time = str(strftime("%H:%M:%S", gmtime()))

text = TextBuilder()

text.append("Итем: <font color=FF3399>" + item.getName() + " +" + str(enchant) + " " + self.getAugmentSkill(augment, auhLevel) +"</font><br1> был успешно продан.<br1>")

text.append("Благодарим за сотрудничество.")

try:

sName = self.getSellerName(con,charId)

st = con.prepareStatement("INSERT INTO `z_post_pos` (`id`,`tema`,`text`,`from`,`to`,`type`,`date`,`time`,`itemName`,`itemId`,`itemCount`,`itemEnch`,`augData`,`augSkill`,`augLvl`) VALUES (NULL,?,?,?,?,?,?,?,?,?,?,?,?,?,?)")

st.setString(1, "Шмотка продана")

st.setString(2, text.toString())

st.setString(3, "~zzAuction#.")

st.setString(4, sName)

st.setInt(5, 0)

st.setString(6, data)

st.setString(7, time)

st.setString(8, item.getName())

st.setInt(9, money)

st.setInt(10, price)

st.setInt(11, 0)

st.setInt(12, 0)

st.setInt(13, 0)

st.setInt(14, 0)

st.execute()

alarm = L2World.getInstance().getPlayer(sName)

if alarm:

alarm.sendMessage("Уведомление с аукциона: проверь почту")

alarm.sendPacket(ExMailArrived())

return True

except:

return False

finally:

text.clear()

self.closeStat(st)

return False

def showSellItems(self,player, page, me, last, itemId, augment, type2):

text = TextBuilder("<br><table width=300><tr><td width=36></td><td width=264>")

if last == 1:

text.append("Последние " + str(PAGE_LIMIT) + ":</td></tr>")

else:

text.append("Страница " + str(page) + ":</td></tr>")

limit1 = (page-1) * PAGE_LIMIT

limit2 = PAGE_LIMIT

con = None

try:

con=L2DatabaseFactory.getInstance().getConnection()

if type2 >= 0:

st=con.prepareStatement("SELECT id, itemId, enchant, augment, augLvl, price, money, ownerId, shadow FROM `z_stock_items` WHERE `type` = ? ORDER BY `id` DESC LIMIT ?, ?")

st.setInt(1, type2)

st.setInt(2, limit1)

st.setInt(3, limit2)

elif itemId > 0:

st=con.prepareStatement("SELECT id, itemId, enchant, augment, augLvl, price, money, ownerId, shadow FROM `z_stock_items` WHERE `itemId` = ? ORDER BY `id` DESC LIMIT ?, ?")

st.setInt(1, itemId)

st.setInt(2, limit1)

st.setInt(3, limit2)

elif augment > 0:

st=con.prepareStatement("SELECT id, itemId, enchant, augment, augLvl, price, money, ownerId, shadow FROM `z_stock_items` WHERE `augment` = ? ORDER BY `id` DESC LIMIT ?, ?")

st.setInt(1, augment)

st.setInt(2, limit1)

st.setInt(3, limit2)

elif me == 1:

st=con.prepareStatement("SELECT id, itemId, enchant, augment, augLvl, price, money, ownerId, shadow FROM `z_stock_items` WHERE `ownerId` = ? ORDER BY `id` DESC LIMIT ?, ?")

st.setInt(1, player.getObjectId())

st.setInt(2, limit1)

st.setInt(3, limit2)

else:

st=con.prepareStatement("SELECT id, itemId, enchant, augment, augLvl, price, money, ownerId, shadow FROM `z_stock_items` ORDER BY `id` DESC LIMIT ?, ?")

st.setInt(1, limit1)

st.setInt(2, limit2)

rs=st.executeQuery()

while (rs.next()):

sId = rs.getInt("id")

itmId = rs.getInt("itemId")

ownerId = rs.getInt("ownerId")

brokeItem = ItemTable.getInstance().getTemplate(itmId)

if brokeItem == None:

continue

priceB = "<font color="+CPRICE+">" + str(Util.formatAdena(rs.getInt("price"))) + " " + self.getMoneyCall(rs.getInt("money")) + "; \"" + self.getSellerName(con,ownerId) + "</font>"

if player.getObjectId() == ownerId:

priceB = "<table width=240><tr><td width=160><font color=666699>" + str(Util.formatAdena(rs.getInt("price"))) + " " + self.getMoneyCall(rs.getInt("money")) + ";</font></td><td align=right><button value=\"X\" action=\"bypass -h Quest purchase StockBuyItem_" + str(sId) + "\" width=25 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td></tr></table><br1>"

text.append("<tr><td><img src=\"Icon." + brokeItem.getIcon() + "\" width=32 height=32></td><td><a action=\"bypass -h Quest purchase StockShowItem_" + str(sId) + "\"> <font color="+CITEM+">" + brokeItem.getName() + "</font></a><font color="+CENCH+">+" + str(rs.getInt("enchant")) + "</font> <br1> " +priceB+ " <br1>" + self.getAugmentSkill(rs.getInt("augment"), rs.getInt("augLvl")) + "</td></tr>");

except:

pass

finally:

self.closeRes(rs)

self.closeStat(st)

text.append("</table><br>");

if last == 1:

text.append("<br>");

else:

pages = int(self.getPageCount(con, me, itemId, augment, type2,player.getObjectId()))

if pages >= 2:

text.append(self.sortPages(page,pages,me,itemId,augment,type2))

self.closeCon(con)

htmltext = text.toString()

text.clear()

return htmltext

def sortPages(self,page,pages,me,itemId,augment,type2):

text = TextBuilder("<br>Страницы:<br1><table width=300><tr>")

step = 1

s = page - 3

f = page + 3

if page < SORT_LIMIT and s < SORT_LIMIT:

s = 1

if page >= SORT_LIMIT:

text.append("<td><a action=\"bypass -h Quest purchase StockShowPage_" + str(s) + "_" + str(me) + "_" + str(itemId) + "_" + str(augment) + "_" + str(type2) + "\"> ... </a></td>")

for i in range(s,(pages+1)):

al = i + 1

if i == page:

text.append("<td>" + str(i) + "</td>")

else:

if al <= pages:

text.append("<td><a action=\"bypass -h Quest purchase StockShowPage_" + str(i) + "_" + str(me) + "_" + str(itemId) + "_" + str(augment) + "_" + str(type2) + "\">" + str(i) + "</a></td>")

if step == SORT_LIMIT and f < pages:

if al < pages:

text.append("<td><a action=\"bypass -h Quest purchase StockShowPage_" + str(al) + "_" + str(me) + "_" + str(itemId) + "_" + str(augment) + "_" + str(type2) + "\"> ... </a></td>")

break

step+=1

text.append("</tr></table><br>")

htmltext = text.toString()

text.clear()

return htmltext

def clearVars(self,player):

quest = player.getQuestState(qn)

quest.unset("objId")

quest.unset("augment")

quest.unset("enchant")

return

def onAdvEvent (self,event,npc,player):

quest = player.getQuestState(qn)

if event == "list":

htmltext = "<html><body><table width=280><tr><td>Аукцион</td><td align=right><button value=\"Офис\" action=\"bypass -h Quest purchase office\" width=70 height=17 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td><td align=right><button value=\"Добавить\" action=\"bypass -h Quest purchase add\" width=70 height=17 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td><td align=right><button value=\"Поиск\" action=\"bypass -h Quest purchase search\" width=40 height=17 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td></tr></table><br>"

htmltext += self.showSellItems(player, 1, 0, 0, 0, 0, -1)

htmltext += "<br></body></html>"

return htmltext

elif event.startswith("StockShowPage_"):

search = str(event.replace("StockShowPage_", ""))

page,me,itemId,augment,type2=search.split("_")

if page == "" or me == "" or augment == "" or itemId == "" or type2 == "":

return self.error("Листание страниц","Ошибка запроса")

page,me,itemId,augment,type2=int(page),int(me),int(itemId),int(augment),int(type2)

if me == 1:

stype = "Мои шмотки"

htmltext = "<html><body><table width=280><tr><td>Аукцион</td><td align=right><button value=\"Офис\" action=\"bypass -h Quest purchase office\" width=70 height=17 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td><td align=right><button value=\"Добавить\" action=\"bypass -h Quest purchase add\" width=70 height=17 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td><td align=right><button value=\"Поиск\" action=\"bypass -h Quest purchase search\" width=40 height=17 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td></tr></table><br><br1>"

htmltext += self.showSellItems(player, page, me, 0, itemId, augment, type2)

htmltext += "<br></body></html>"

return htmltext

elif event.startswith("StockShowItem_"):

sellId = event.replace("StockShowItem_", "")

if sellId == "":

return self.error("Просмотр шмотки","Ошибка запроса")

sellId=int(sellId)

text = TextBuilder("<html><body>")

try:

con = L2DatabaseFactory.getInstance().getConnection();

st = con.prepareStatement("SELECT itemId, enchant, augment, augLvl, price, money, ownerId, shadow FROM `z_stock_items` WHERE `id`=? LIMIT 1");

st.setInt(1, sellId);

rs = st.executeQuery();

if rs.next():

itemId = rs.getInt("itemId");

brokeItem = ItemTable.getInstance().getTemplate(itemId);

if brokeItem == None:

return self.error("Просмотр шмотки","Ошибка запроса")

text.append("<font color=666666>ID шмотки: " + str(itemId) + "</font> <button value=\"Найти еще\" action=\"bypass -h Quest purchase find_ 777 _ " + str(itemId) + " _ Id шмотки\" width=70 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\">")

enchant = rs.getInt("enchant");

augment = rs.getInt("augment");

auhLevel = rs.getInt("augLvl");

price = rs.getInt("price");

money = rs.getInt("money");

charId = rs.getInt("ownerId");

shadow = rs.getInt("shadow");

valute = self.getMoneyCall(money);

#<

text.append("<table width=300><tr><td><img src=\"" + brokeItem.getIcon() + "\" width=32 height=32></td><td><font color=LEVEL>" + brokeItem.getName() + " +" + str(enchant) + "</font><br></td></tr></table><br><br>")

text.append("Продавец: " + self.getSellerName(con,charId) + "<br><br>")

text.append(self.getAugmentSkill(augment, auhLevel) + "<br1>")

if augment > 0:

text.append("<button value=\"Найти еще\" action=\"bypass -h Quest purchase find_ 777 _ " + str(augment) + " _ Id аугмента\" width=70 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br><br>")

if player.getObjectId() == charId:

text.append("<button value=\"Забрать\" action=\"bypass -h Quest purchase StockBuyItem_" + str(sellId) + "\" width=60 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br>")

else:

payment = player.getInventory().getItemByItemId(money);

fprice = str(Util.formatAdena(price))

if payment != None and payment.getCount() >= price:

text.append("<font color=33CC00>Стоимость: " + fprice+ " " + str(valute) + "</font><br>");

text.append("<button value=\"Купить\" action=\"bypass -h Quest purchase StockBuyItem_" + str(sellId) + "\" width=60 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br>")

else:

text.append("<font color=CC3333>Стоимость: " + fprice + " " + str(valute) + "</font><br>");

text.append("<font color=999999>[Купить]</font>");

else:

return self.error("Просмотр шмотки","Ни найдена или уже купили")

except:

pass

finally:

self.closeRes(rs)

self.closeStat(st)

self.closeCon(con)

text.append("<br><br><a action=\"bypass -h Quest purchase list\">Вернуться</a><br>");

text.append("</body></html>");

htmltext = text.toString()

text.clear()

return htmltext

elif event.startswith("StockBuyItem_"):

sellId = event.replace("StockBuyItem_", "")

if sellId == "":

return self.error("Покупка шмотки","Ошибка запроса")

sellId=int(sellId)

try:

con = L2DatabaseFactory.getInstance().getConnection();

st = con.prepareStatement("SELECT itemId, itemName, enchant, augment, augAttr, augLvl, price, money, ownerId, shadow FROM `z_stock_items` WHERE `id`=? LIMIT 1");

st.setInt(1, sellId);

rs = st.executeQuery();

if rs.next():

itemId = rs.getInt("itemId");

bItem = ItemTable.getInstance().getTemplate(itemId);

if bItem == None:

return self.error("Покупка шмотки","Ошибка запроса")

itemName = rs.getString("itemName");

enchant = rs.getInt("enchant");

augment = rs.getInt("augment");

augAttr = rs.getInt("augAttr");

auhLevel = rs.getInt("augLvl");

price = rs.getInt("price");

money = rs.getInt("money");

charId = rs.getInt("ownerId");

shadow = rs.getInt("shadow");

valute = self.getMoneyCall(money);

#<

if player.getObjectId() == charId:

price = 0

if price > 0:

payment = player.getInventory().getItemByItemId(money);

if payment != None and payment.getCount() >= price:

quest.takeItems(money,price)

else:

return self.error("Покупка шмотки","Проверьте стоимость")

#>

try:

zabiraem=con.prepareStatement("DELETE FROM `z_stock_items` WHERE `id`=?")

zabiraem.setInt(1, sellId)

zabiraem.executeUpdate()

except:

return self.error("Покупка шмотки","Ошибка запроса")

finally:

self.closeStat(zabiraem)

#>

if price > 0 and not self.transferPay(con,charId,itemId,enchant,augment,auhLevel,price,money):

return self.error("Покупка шмотки","Ошибка запроса")

#>

item = player.getInventory().addItem("zzAuction", itemId, 1, player, player.getTarget())

if enchant != 0:

item.setEnchantLevel(enchant)

if augAttr != 0:

item.setAugmentation(L2Augmentation(item, augAttr, augment, auhLevel, True))

smsg = SystemMessage(SystemMessageId.EARNED_S2_S1_S)

smsg.addItemName(itemId)

smsg.addNumber(1)

player.sendPacket(smsg)

player.sendPacket(ItemList(player, True))

action,payment = "Снято",""

if price > 0:

action,payment = "Куплено","Стоимость: <font color="+CPRICE+">" + str(Util.formatAdena(price)) + " " + str(valute) + "</font>"

alarm = L2World.getInstance().getPlayer(self.getSellerName(con,charId))

if alarm:

alarm.sendMessage("Уведомление с аукциона:" + bItem.getName() + " (+" + str(enchant) + ") купили!")

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase list\">Назад|<-</a></td></tr></table><br>"

htmltext += action + "<br1> <font color="+CITEM+">" + bItem.getName() + "</font><font color="+CENCH+"> +" + str(enchant) + "</font><br> " + self.getAugmentSkill(augment, auhLevel) + " <br> " + payment + "</body></html>"

else:

return self.error("Покупка шмотки","Ни найдена или уже купили")

except:

pass

finally:

self.closeRes(rs)

self.closeStat(st)

self.closeCon(con)

return htmltext

elif event == "search":

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase list\">Назад|<-</a></td></tr></table><br>"

htmltext += "<table width=260><tr>"

step = 0

for i in sorts:

htmltext += "<td><button value=\"" + sorts + "\" action=\"bypass -h Quest purchase find_ " + str(i) + " _ no _ no\" width=50 height=21 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td>"

step+=1

if step == 4:

step = 0

htmltext += "</tr><tr>"

htmltext += "</tr></table><br><table width=220 border=0><tr><td align=right><edit var=\"value\" width=150 length=\"16\"></td><td align=right><combobox width=71 var=keyword list=\"Id шмотки;Id аугмента\"></td><td><button value=\"Поиск\" action=\"bypass -h Quest purchase find_ 777 _ $value _ $keyword\" width=50 height=21 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td></tr></table>"

htmltext += "<br></body></html>"

return htmltext

elif event.startswith("find_ "):

search = str(event.replace("find_ ", ""))

type2,value,ptype=search.split("_")

type2,value,ptype=str(type2),str(value),str(ptype)

value = str(value.replace(" ", ""))

type2 = int(type2.replace(" ", ""))

if value == "" or ptype == "":

htmltext = "<html><body>Задан пустой поисковый запрос<br><br><a action=\"bypass -h Quest purchase list\">Вернуться.</a></body></html>"

return htmltext

if type2 != 777 and type2 >= 0:

ptype = "Тип шмотки"

psort = self.showSellItems(player, 1, 0, 0, 0, 0, type2)

value = sorts.get(type2, "")

if value == "":

return self.error("Сортировка","Ошибка запроса")

else:

if not value.isdigit():

return self.error("Сортировка","Ошибка запроса")

if ptype == " Id шмотки":

psort = self.showSellItems(player, 1, 0, 0, int(value), 0, -1)

else:

psort = self.showSellItems(player, 1, 0, 0, 0, int(value), -1)

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase search\">Назад|<-</a></td></tr></table><br>"

htmltext += "<table><tr><td width=260><font color=336699>Поиск по:</font> <font color=CC66CC>"+ptype+":</font><font color=CC33CC>"+value+"</font></td><td align=right width=70></td></tr></table><br1>"

htmltext += psort

htmltext += "<br><a action=\"bypass -h Quest purchase list\">Вернуться</a><br></body></html>"

return htmltext

elif event == "add":

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase list\">Назад|<-</a></td></tr></table><br1>"

htmltext += "<font color=LEVEL>Что хотите выставить на продажу?</font><br1>"

htmltext += "Оружие:<br1>"

htmltext += "<table width=240><tr><td><button value=\"Заточенное\" action=\"bypass -h Quest purchase enchanted_0\" width=90 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td>"

htmltext += "<td><button value=\"Аугментированное.\" action=\"bypass -h Quest purchase augment_1\" width=90 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td>"

htmltext += "</tr></table><br>--------<br1>"

htmltext += "<button value=\"Броня (+)\" action=\"bypass -h Quest purchase enchanted_1\" width=90 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br>"

htmltext += "<button value=\"Бижутерия (+)\" action=\"bypass -h Quest purchase enchanted_2\" width=90 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br>"

htmltext += "</body></html>"

return htmltext

elif event.startswith("enchanted_"):

chType = int(event.replace("enchanted_", ""))

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase add\">Назад|<-</a></td></tr></table><br1>"

htmltext += "Шаг 1.<br>Выберите шмотку:<br><br><table width=300>"

self.clearVars(player)

if chType > 3: # каг?

return self.error("Добавление шмоток","Ошибка запроса")

for item in player.getInventory().getItems():

itemTemplate = item.getItem()

itemId = itemTemplate.getItemId()

itemType = itemTemplate.getType2()

itemGrade = itemTemplate.getCrystalType()

preench = item.getEnchantLevel()

if item.canBeEnchanted() and preench > 0 and itemType == chType and itemId not in FORBIDDEN and itemTemplate.getDuration() == -1 and itemGrade > 3 and not item.isEquipped():

augment = ""

if chType == 0:

augment = "<font color=333366>Нет аугмента</font>"

if item.isAugmented() and item.getAugmentation().getAugmentSkill() != None:

augment = item.getAugmentation().getAugmentSkill()

augment,level = str(augment.getId()),str(augment.getLevel())

augment = self.getAugmentSkill(int(augment), int(level))

htmltext += "<tr><td><img src=\"Icon."+itemTemplate.getIcon()+"\" width=32 height=32><br></td><td><a action=\"bypass -h Quest purchase step2_" + str(item.getObjectId()) +"_1\">" + itemTemplate.getName() + "</a> <font color="+CENCH+">+" + str(preench) + "</font><br1>" + augment + "</td></tr>"

htmltext += "</table><br></body></html>"

return htmltext

elif event.startswith("augment_"):

chType = int(event.replace("augment_", ""))

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase add\">Назад|<-</a></td></tr></table><br1>"

htmltext += "Шаг 1.<br>Выберите шмотку:<br><br><table width=300>"

self.clearVars(player)

if chType != 1: # каг?

return self.error("Добавление шмоток","Ошибка запроса")

for item in player.getInventory().getItems():

itemTemplate = item.getItem()

itemId = itemTemplate.getItemId()

itemType = itemTemplate.getType2()

itemGrade = itemTemplate.getCrystalType()

preench = item.getEnchantLevel()

if item.canBeEnchanted() and item.isAugmented() and item.getAugmentation().getAugmentSkill() != None and itemType == 0 and itemId not in FORBIDDEN and itemTemplate.getDuration() == -1 and itemGrade > 3 and not item.isEquipped():

augment = ""

if chType == 0:

augment = "<font color=333366>Нет аугмента</font>"

if item.isAugmented() and item.getAugmentation().getAugmentSkill() != None:

augment = item.getAugmentation().getAugmentSkill()

augment,level = str(augment.getId()),str(augment.getLevel())

augment = self.getAugmentSkill(int(augment), int(level))

htmltext += "<tr><td><img src=\""+itemTemplate.getIcon()+"\" width=32 height=32><br></td><td><a action=\"bypass -h Quest purchase step2_" + str(item.getObjectId()) +"_2\">" + itemTemplate.getName() + "</a> <font color="+CENCH+">+" + str(preench) + "</font><br1>" + augment + "</td></tr>"

htmltext += "</table><br></body></html>"

return htmltext

elif event.startswith("step2_"):

search = str(event.replace("step2_", ""))

itemObjId,chType=search.split("_")

itemObjId,chType=int(itemObjId),int(chType)

item = player.getInventory().getItemByObjectId(itemObjId)

if item.canBeEnchanted() and item and not item.isEquipped():

itemId = item.getItemId()

itemTemplate = item.getItem()

itemType = itemTemplate.getType2()

preench = item.getEnchantLevel()

if chType == 1 and preench == 0:

return self.error("Подробная инфа о шмотке","Ошибка запроса")

augment = ""

if chType == 2:

augment = "<font color=333366>Нет аугмента</font>"

augSkill = 0

if item.isAugmented() and item.getAugmentation().getAugmentSkill() != None:

augment = item.getAugmentation().getAugmentSkill()

#if chType == 2 and augment == None:

#return self.error("Подробная инфа о шмотке","Ошибка запроса")

augment,level = str(augment.getId()),str(augment.getLevel())

augSkill = int(augment)

augment = self.getAugmentSkill(int(augment), int(level))

quest.set("augment",str(augSkill))

quest.set("objId",str(itemObjId))

quest.set("enchant",str(preench))

htmltext = "<html><body>Шаг 2.<br>Подтверждаете?<br>"

htmltext += "<table width=300><tr><td><img src=\""+itemTemplate.getIcon()+"\" width=32 height=32></td><td><font color="+CITEM+">" + itemTemplate.getName() + "</font><font color="+CENCH+">+" + str(preench) + "</font><br>"+ augment + "</td></tr></table><br><br>"

htmltext += "Введите желаемую цену и выберите валюту:<br>"

mvars = "Adena;"

for i in moneys:

mvars+=moneys+";"

htmltext += "<table width=300><tr><td><edit var=\"price\" width=70 length=\"16\"></td><td><combobox width=100 var=type list=\"" + mvars + "\"></td></tr></table><br>"

htmltext += "<button value=\"Продолжить\" action=\"bypass -h Quest purchase step3_ $price _ $type\" width=70 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br>"

htmltext += "<br><a action=\"bypass -h Quest purchase add\">Вернуться.</a></body></html>"

else :

htmltext = "<html><body>Ошибка!<br><a action=\"bypass -h Quest purchase step1\">Вернуться.</a></body></html>"

return htmltext

elif event.startswith("step3_ "):

search = str(event.replace("step3_ ", ""))

price,mvar=search.split("_")

price,mvar=str(price),str(mvar)

price = str(price.replace(" ", ""))

if price == "" or mvar == "":

return self.error("Шаг 3","Ошибка запроса")

if not price.isdigit():

return self.error("Шаг 3","Ошибка запроса")

price = int(price)

if price == 0:

return self.error("Шаг 3","Ошибка запроса")

mvarId = 57

for i in moneys:

if " "+moneys == mvar:

mvarId = i

break

if mvarId == 57 and price > MAX_ADENA:

self.clearVars(player)

return self.error("Шаг 3","Максимальная цена " + str(Util.formatAdena(MAX_ADENA)) + " Adena.")

myItem = quest.getInt("objId")

item = player.getInventory().getItemByObjectId(myItem)

if item:

if item.isEquipped():

return self.error("Шаг 3","Ошибка запроса")

if not item.canBeEnchanted():

return self.error("Шаг 3","Ошибка запроса")

myEnch = quest.getInt("enchant")

myAugm = quest.getInt("augment")

itemId = item.getItemId()

itemTemplate = item.getItem()

itemType = itemTemplate.getType2()

preench = item.getEnchantLevel()

if preench != myEnch:

self.clearVars(player)

return self.error("Шаг 3","Ошибка запроса")

augment = "нет."

augEffId = 0

augSkId = 0

augSkLvl = 0

if item.isAugmented() and item.getAugmentation().getAugmentSkill() != None:

augment = item.getAugmentation().getAugmentSkill()

augEffId = item.getAugmentation().getAugmentationId()

augSkId,augSkLvl = str(augment.getId()),str(augment.getLevel())

if myAugm != int(augSkId):

self.clearVars(player)

return self.error("Шаг 3","Ошибка запроса")

#<

try:

con2=L2DatabaseFactory.getInstance().getConnection()

storeitem=con2.prepareStatement("INSERT INTO `z_stock_items` (`id`,`itemId`,`itemName`,`enchant`,`augment`,`augAttr`,`augLvl`,`price`,`money`,`type`,`ownerId`,`shadow`) VALUES (NULL,?,?,?,?,?,?,?,?,?,?,?);")

storeitem.setInt(1,itemId)

storeitem.setString(2, itemTemplate.getName())

storeitem.setInt(3, preench)

storeitem.setInt(4, int(augSkId))

storeitem.setInt(5, int(augEffId))

storeitem.setInt(6, int(augSkLvl))

storeitem.setInt(7, price)

storeitem.setInt(8, mvarId)

storeitem.setInt(9, itemType)

storeitem.setInt(10, player.getObjectId())

storeitem.setInt(11, 0)

storeitem.executeUpdate()

except:

self.clearVars(player)

return self.error("Шаг 3","Ошибка базы данных")

finally:

self.closeStat(storeitem)

self.closeCon(con2)

player.destroyItem("zzAuction",myItem, 1, player, 1)

#<

self.clearVars(player)

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase add\">Назад|<-</a></td></tr></table><br1>"

htmltext += "<font color="+CITEM+">" + itemTemplate.getName() + "</font><font color="+CENCH+">+" + str(preench) + "</font><br1> " + self.getAugmentSkill(int(augSkId), int(augSkLvl)) + " <br1>выставлена на продажу!</body></html>"

else:

self.clearVars(player)

return self.error("Шаг 3","Ошибка запроса")

return htmltext

elif event == "office":

#data = str(strftime("%Y-%m-%d", gmtime()))

#time = str(strftime("%H:%M:%S", gmtime()))

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase list\">Назад|<-</a></td></tr></table><br1>"

htmltext += "Привет, " + player.getName() + ".<br>"

#htmltext += "Привет, " + player.getName() + ".<br>Сейчас " + data + " " + time + "<br>"

htmltext += "<button value=\"Мои шмотки\" action=\"bypass -h Quest purchase StockShowPage_1_1_0_0_-1\" width=70 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br>"

htmltext += "</body></html>"

return htmltext

return

def onTalk (self,npc,player):

st = player.getQuestState(qn)

npcId = npc.getNpcId()

if npcId == MARKET:

return "<html><body>На аукционе вы можете торговать заточенными и аугментированными шмотками.<br><a action=\"bypass -h Quest purchase list\">Просмотр</a><br><br>Если шмотку купили, оплата придет на почту.</body></html>"

return

QUEST = Quest(-1,qn,"custom")

QUEST.addStartNpc(MARKET)

QUEST.addTalkId(MARKET)

NewTrend · 28 ноября, 2012

# -*- coding: utf-8 -*-

уберите эту строку

iPerfect · 28 ноября, 2012

# -*- coding: utf-8 -*-

уберите эту строку

Она тут не причем.

Убрал, проблема осталась

NewTrend · 28 ноября, 2012

Скиньте 80 строку суда

Absent · 28 ноября, 2012

Если не ошибаюсь то мне кажется из за этой строки

sorts = {0: "Оружие", 1: "Броня", 2: "Бижутерия"}

Absent · 28 ноября, 2012

Хотя,нет она тут не при чем)

щас глянем что не так

iPerfect · 28 ноября, 2012

Скиньте 80 строку суда

Вот 80: finally:

вот 81: self.closeRes(rs)

Вот 82: self.closeStat(st)

Изменено 28 ноября, 2012 пользователем iPerfect

Absent · 28 ноября, 2012

# -*- coding: utf-8 -*-

import sys

from javolution.text import TextBuilder

from net.sf.l2j import L2DatabaseFactory

from net.sf.l2j.gameserver.datatables import AugmentationData

from net.sf.l2j.gameserver.datatables import ItemTable

from net.sf.l2j.gameserver.datatables import SkillTable

from net.sf.l2j.gameserver.model import L2Augmentation

from net.sf.l2j.gameserver.model import L2ItemInstance

from net.sf.l2j.gameserver.model import L2Skill

from net.sf.l2j.gameserver.model import L2World

from net.sf.l2j.gameserver.model.quest import State

from net.sf.l2j.gameserver.model.quest import QuestState

from net.sf.l2j.gameserver.model.quest.jython import QuestJython as JQuest

from net.sf.l2j.gameserver.network import SystemMessageId

from net.sf.l2j.gameserver.network.serverpackets import ExMailArrived

from net.sf.l2j.gameserver.network.serverpackets import ItemList

from net.sf.l2j.gameserver.network.serverpackets import SystemMessage

from net.sf.l2j.gameserver.templates import L2Item

from net.sf.l2j.util import Rnd

from net.sf.l2j.gameserver.util import Util

from time import gmtime, strftime

qn = "purchase"

MARKET = 80007

PAGE_LIMIT = 10

SORT_LIMIT = 8

MAX_ADENA = 2147000000

FORBIDDEN = [6611,6612,6613,6614,6615,6616,6617,6618,6619,6620,6621]

#

CENCH = "CCCC33"

CPRICE = "669966"

CITEM = "993366"

CAUG1 = "333366"

CAUG2 = "006699"

moneys = {4037: "Coin Of Luck", 4355: "Blue Eva", 5962: "Gold Golem"}

sorts = {0: "Оружие", 1: "Броня", 2: "Бижутерия"}

class Quest (JQuest) :

def __init__(self,id,name,descr): JQuest.__init__(self,id,name,descr)

def init_LoadGlobalData(self) :

print "purchase: ok"

def closeStat(self,st):

if st != None:

st.close()

return

def closeRes(self,rs):

if rs != None:

rs.close()

return

def closeCon(self,con):

if con != None:

con.close()

return

def getMoneyCall(self,money):

return moneys.get(money, str("Adena"))

def getSellerName(self,con,charId):

name = "???"

try:

st = con.prepareStatement("SELECT char_name FROM `characters` WHERE `Obj_Id`=? LIMIT 1");

st.setInt(1, charId);

rs = st.executeQuery();

if rs.next():

name = rs.getString("char_name")

except:

pass

finally:

self.closeRes(rs)

self.closeStat(st)

return name

def getAugmentSkill(self, aid, lvl):

augment = SkillTable.getInstance().getInfo(aid, lvl)

if augment == None:

return ""

augName = augment.getName();

stype = "Шанс";

ttype = "";

power = ":" + str(int(augment.getPower())) + "power";

if augment.isActive():

stype = "Актив"

if augment.isAuraSkill():

ttype = "<br1>(Массовый)";

elif augment.isPassive():

stype = "Пассив"

power = "";

augName = augName.replace("Item Skill: ", "");

return "<font color="+CAUG1+">Аугмент:</font> <font color="+CAUG2+">" + augName + " Lv " + str(lvl) + " (" + stype + power + ")" + ttype + "</font>";

def getPageCount(self, con, me, itemId, augment, type2, charId):

rowCount = 0

pages = 0

try:

con=L2DatabaseFactory.getInstance().getConnection()

if type2 >= 0:

st=con.prepareStatement("SELECT COUNT(`id`) FROM `z_stock_items` WHERE `type` = ?")

st.setInt(1, type2)

elif itemId > 0:

st=con.prepareStatement("SELECT COUNT(`id`) FROM `z_stock_items` WHERE `itemId` = ?")

st.setInt(1, itemId)

elif augment > 0:

st=con.prepareStatement("SELECT COUNT(`id`) FROM `z_stock_items` WHERE `augment` = ?")

st.setInt(1, augment)

elif me == 1:

st=con.prepareStatement("SELECT COUNT(`id`) FROM `z_stock_items` WHERE `ownerId` = ?")

st.setInt(1, charId)

else:

st=con.prepareStatement("SELECT COUNT(`id`) FROM `z_stock_items` WHERE `id` > 0")

rs=st.executeQuery()

if (rs.next()):

rowCount = rs.getInt(1)

except :

pass

finally:

self.closeRes(rs)

self.closeStat(st)

if rowCount == 0:

return "0"

pages = (rowCount / PAGE_LIMIT) + 1

return str(pages)

def error(self,action, text):

return "<html><body> " + action + ": <br> " + text + "</body></html>"

def transferPay(self,con,charId,itemId,enchant,augment,auhLevel,price,money):

item = ItemTable.getInstance().getTemplate(itemId)

if item == None:

return False

data = str(strftime("%Y-%m-%d", gmtime()))

time = str(strftime("%H:%M:%S", gmtime()))

text = TextBuilder()

text.append("Итем: <font color=FF3399>" + item.getName() + " +" + str(enchant) + " " + self.getAugmentSkill(augment, auhLevel) +"</font><br1> был успешно продан.<br1>")

text.append("Благодарим за сотрудничество.")

try:

sName = self.getSellerName(con,charId)

st = con.prepareStatement("INSERT INTO `z_post_pos` (`id`,`tema`,`text`,`from`,`to`,`type`,`date`,`time`,`itemName`,`itemId`,`itemCount`,`itemEnch`,`augData`,`augSkill`,`augLvl`) VALUES (NULL,?,?,?,?,?,?,?,?,?,?,?,?,?,?)")

st.setString(1, "Шмотка продана")

st.setString(2, text.toString())

st.setString(3, "~zzAuction#.")

st.setString(4, sName)

st.setInt(5, 0)

st.setString(6, data)

st.setString(7, time)

st.setString(8, item.getName())

st.setInt(9, money)

st.setInt(10, price)

st.setInt(11, 0)

st.setInt(12, 0)

st.setInt(13, 0)

st.setInt(14, 0)

st.execute()

alarm = L2World.getInstance().getPlayer(sName)

if alarm:

alarm.sendMessage("Уведомление с аукциона: проверь почту")

alarm.sendPacket(ExMailArrived())

return True

except:

return False

finally:

text.clear()

self.closeStat(st)

return False

def showSellItems(self,player, page, me, last, itemId, augment, type2):

text = TextBuilder("<br><table width=300><tr><td width=36></td><td width=264>")

if last == 1:

text.append("Последние " + str(PAGE_LIMIT) + ":</td></tr>")

else:

text.append("Страница " + str(page) + ":</td></tr>")

limit1 = (page-1) * PAGE_LIMIT

limit2 = PAGE_LIMIT

con = None

try:

con=L2DatabaseFactory.getInstance().getConnection()

if type2 >= 0:

st=con.prepareStatement("SELECT id, itemId, enchant, augment, augLvl, price, money, ownerId, shadow FROM `z_stock_items` WHERE `type` = ? ORDER BY `id` DESC LIMIT ?, ?")

st.setInt(1, type2)

st.setInt(2, limit1)

st.setInt(3, limit2)

elif itemId > 0:

st=con.prepareStatement("SELECT id, itemId, enchant, augment, augLvl, price, money, ownerId, shadow FROM `z_stock_items` WHERE `itemId` = ? ORDER BY `id` DESC LIMIT ?, ?")

st.setInt(1, itemId)

st.setInt(2, limit1)

st.setInt(3, limit2)

elif augment > 0:

st=con.prepareStatement("SELECT id, itemId, enchant, augment, augLvl, price, money, ownerId, shadow FROM `z_stock_items` WHERE `augment` = ? ORDER BY `id` DESC LIMIT ?, ?")

st.setInt(1, augment)

st.setInt(2, limit1)

st.setInt(3, limit2)

elif me == 1:

st=con.prepareStatement("SELECT id, itemId, enchant, augment, augLvl, price, money, ownerId, shadow FROM `z_stock_items` WHERE `ownerId` = ? ORDER BY `id` DESC LIMIT ?, ?")

st.setInt(1, player.getObjectId())

st.setInt(2, limit1)

st.setInt(3, limit2)

else:

st=con.prepareStatement("SELECT id, itemId, enchant, augment, augLvl, price, money, ownerId, shadow FROM `z_stock_items` ORDER BY `id` DESC LIMIT ?, ?")

st.setInt(1, limit1)

st.setInt(2, limit2)

rs=st.executeQuery()

while (rs.next()):

sId = rs.getInt("id")

itmId = rs.getInt("itemId")

ownerId = rs.getInt("ownerId")

brokeItem = ItemTable.getInstance().getTemplate(itmId)

if brokeItem == None:

continue

priceB = "<font color="+CPRICE+">" + str(Util.formatAdena(rs.getInt("price"))) + " " + self.getMoneyCall(rs.getInt("money")) + "; \"" + self.getSellerName(con,ownerId) + "</font>"

if player.getObjectId() == ownerId:

priceB = "<table width=240><tr><td width=160><font color=666699>" + str(Util.formatAdena(rs.getInt("price"))) + " " + self.getMoneyCall(rs.getInt("money")) + ";</font></td><td align=right><button value=\"X\" action=\"bypass -h Quest purchase StockBuyItem_" + str(sId) + "\" width=25 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td></tr></table><br1>"

text.append("<tr><td><img src=\"" + brokeItem.getIcon() + "\" width=32 height=32></td><td><a action=\"bypass -h Quest purchase StockShowItem_" + str(sId) + "\"> <font color="+CITEM+">" + brokeItem.getName() + "</font></a><font color="+CENCH+">+" + str(rs.getInt("enchant")) + "</font> <br1> " +priceB+ " <br1>" + self.getAugmentSkill(rs.getInt("augment"), rs.getInt("augLvl")) + "</td></tr>");

except:

pass

finally:

self.closeRes(rs)

self.closeStat(st)

text.append("</table><br>");

if last == 1:

text.append("<br>");

else:

pages = int(self.getPageCount(con, me, itemId, augment, type2,player.getObjectId()))

if pages >= 2:

text.append(self.sortPages(page,pages,me,itemId,augment,type2))

self.closeCon(con)

htmltext = text.toString()

text.clear()

return htmltext

def sortPages(self,page,pages,me,itemId,augment,type2):

text = TextBuilder("<br>Страницы:<br1><table width=300><tr>")

step = 1

s = page - 3

f = page + 3

if page < SORT_LIMIT and s < SORT_LIMIT:

s = 1

if page >= SORT_LIMIT:

text.append("<td><a action=\"bypass -h Quest purchase StockShowPage_" + str(s) + "_" + str(me) + "_" + str(itemId) + "_" + str(augment) + "_" + str(type2) + "\"> ... </a></td>")

for i in range(s,(pages+1)):

al = i + 1

if i == page:

text.append("<td>" + str(i) + "</td>")

else:

if al <= pages:

text.append("<td><a action=\"bypass -h Quest purchase StockShowPage_" + str(i) + "_" + str(me) + "_" + str(itemId) + "_" + str(augment) + "_" + str(type2) + "\">" + str(i) + "</a></td>")

if step == SORT_LIMIT and f < pages:

if al < pages:

text.append("<td><a action=\"bypass -h Quest purchase StockShowPage_" + str(al) + "_" + str(me) + "_" + str(itemId) + "_" + str(augment) + "_" + str(type2) + "\"> ... </a></td>")

break

step+=1

text.append("</tr></table><br>")

htmltext = text.toString()

text.clear()

return htmltext

def clearVars(self,player):

quest = player.getQuestState(qn)

quest.unset("objId")

quest.unset("augment")

quest.unset("enchant")

return

def onAdvEvent (self,event,npc,player):

quest = player.getQuestState(qn)

if event == "list":

htmltext = "<html><body><table width=280><tr><td>Аукцион</td><td align=right><button value=\"Офис\" action=\"bypass -h Quest purchase office\" width=70 height=17 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td><td align=right><button value=\"Добавить\" action=\"bypass -h Quest purchase add\" width=70 height=17 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td><td align=right><button value=\"Поиск\" action=\"bypass -h Quest purchase search\" width=40 height=17 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td></tr></table><br>"

htmltext += self.showSellItems(player, 1, 0, 0, 0, 0, -1)

htmltext += "<br></body></html>"

return htmltext

elif event.startswith("StockShowPage_"):

search = str(event.replace("StockShowPage_", ""))

page,me,itemId,augment,type2=search.split("_")

if page == "" or me == "" or augment == "" or itemId == "" or type2 == "":

return self.error("Листание страниц","Ошибка запроса")

page,me,itemId,augment,type2=int(page),int(me),int(itemId),int(augment),int(type2)

if me == 1:

stype = "Мои шмотки"

htmltext = "<html><body><table width=280><tr><td>Аукцион</td><td align=right><button value=\"Офис\" action=\"bypass -h Quest purchase office\" width=70 height=17 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td><td align=right><button value=\"Добавить\" action=\"bypass -h Quest purchase add\" width=70 height=17 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td><td align=right><button value=\"Поиск\" action=\"bypass -h Quest purchase search\" width=40 height=17 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td></tr></table><br><br1>"

htmltext += self.showSellItems(player, page, me, 0, itemId, augment, type2)

htmltext += "<br></body></html>"

return htmltext

elif event.startswith("StockShowItem_"):

sellId = event.replace("StockShowItem_", "")

if sellId == "":

return self.error("Просмотр шмотки","Ошибка запроса")

sellId=int(sellId)

text = TextBuilder("<html><body>")

try:

con = L2DatabaseFactory.getInstance().getConnection();

st = con.prepareStatement("SELECT itemId, enchant, augment, augLvl, price, money, ownerId, shadow FROM `z_stock_items` WHERE `id`=? LIMIT 1");

st.setInt(1, sellId);

rs = st.executeQuery();

if rs.next():

itemId = rs.getInt("itemId");

brokeItem = ItemTable.getInstance().getTemplate(itemId);

if brokeItem == None:

return self.error("Просмотр шмотки","Ошибка запроса")

text.append("<font color=666666>ID шмотки: " + str(itemId) + "</font> <button value=\"Найти еще\" action=\"bypass -h Quest purchase find_ 777 _ " + str(itemId) + " _ Id шмотки\" width=70 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\">")

enchant = rs.getInt("enchant");

augment = rs.getInt("augment");

auhLevel = rs.getInt("augLvl");

price = rs.getInt("price");

money = rs.getInt("money");

charId = rs.getInt("ownerId");

shadow = rs.getInt("shadow");

valute = self.getMoneyCall(money);

#<

text.append("<table width=300><tr><td><img src=\"" + brokeItem.getIcon() + "\" width=32 height=32></td><td><font color=LEVEL>" + brokeItem.getName() + " +" + str(enchant) + "</font><br></td></tr></table><br><br>")

text.append("Продавец: " + self.getSellerName(con,charId) + "<br><br>")

text.append(self.getAugmentSkill(augment, auhLevel) + "<br1>")

if augment > 0:

text.append("<button value=\"Найти еще\" action=\"bypass -h Quest purchase find_ 777 _ " + str(augment) + " _ Id аугмента\" width=70 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br><br>")

if player.getObjectId() == charId:

text.append("<button value=\"Забрать\" action=\"bypass -h Quest purchase StockBuyItem_" + str(sellId) + "\" width=60 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br>")

else:

payment = player.getInventory().getItemByItemId(money);

fprice = str(Util.formatAdena(price))

if payment != None and payment.getCount() >= price:

text.append("<font color=33CC00>Стоимость: " + fprice+ " " + str(valute) + "</font><br>");

text.append("<button value=\"Купить\" action=\"bypass -h Quest purchase StockBuyItem_" + str(sellId) + "\" width=60 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br>")

else:

text.append("<font color=CC3333>Стоимость: " + fprice + " " + str(valute) + "</font><br>");

text.append("<font color=999999>[Купить]</font>");

else:

return self.error("Просмотр шмотки","Ни найдена или уже купили")

except:

pass

finally:

self.closeRes(rs)

self.closeStat(st)

self.closeCon(con)

text.append("<br><br><a action=\"bypass -h Quest purchase list\">Вернуться</a><br>");

text.append("</body></html>");

htmltext = text.toString()

text.clear()

return htmltext

elif event.startswith("StockBuyItem_"):

sellId = event.replace("StockBuyItem_", "")

if sellId == "":

return self.error("Покупка шмотки","Ошибка запроса")

sellId=int(sellId)

try:

con = L2DatabaseFactory.getInstance().getConnection();

st = con.prepareStatement("SELECT itemId, itemName, enchant, augment, augAttr, augLvl, price, money, ownerId, shadow FROM `z_stock_items` WHERE `id`=? LIMIT 1");

st.setInt(1, sellId);

rs = st.executeQuery();

if rs.next():

itemId = rs.getInt("itemId");

bItem = ItemTable.getInstance().getTemplate(itemId);

if bItem == None:

return self.error("Покупка шмотки","Ошибка запроса")

itemName = rs.getString("itemName");

enchant = rs.getInt("enchant");

augment = rs.getInt("augment");

augAttr = rs.getInt("augAttr");

auhLevel = rs.getInt("augLvl");

price = rs.getInt("price");

money = rs.getInt("money");

charId = rs.getInt("ownerId");

shadow = rs.getInt("shadow");

valute = self.getMoneyCall(money);

#<

if player.getObjectId() == charId:

price = 0

if price > 0:

payment = player.getInventory().getItemByItemId(money);

if payment != None and payment.getCount() >= price:

quest.takeItems(money,price)

else:

return self.error("Покупка шмотки","Проверьте стоимость")

#>

try:

zabiraem=con.prepareStatement("DELETE FROM `z_stock_items` WHERE `id`=?")

zabiraem.setInt(1, sellId)

zabiraem.executeUpdate()

except:

return self.error("Покупка шмотки","Ошибка запроса")

finally:

self.closeStat(zabiraem)

#>

if price > 0 and not self.transferPay(con,charId,itemId,enchant,augment,auhLevel,price,money):

return self.error("Покупка шмотки","Ошибка запроса")

#>

item = player.getInventory().addItem("zzAuction", itemId, 1, player, player.getTarget())

if enchant != 0:

item.setEnchantLevel(enchant)

if augAttr != 0:

item.setAugmentation(L2Augmentation(item, augAttr, augment, auhLevel, True))

smsg = SystemMessage(SystemMessageId.EARNED_S2_S1_S)

smsg.addItemName(itemId)

smsg.addNumber(1)

player.sendPacket(smsg)

player.sendPacket(ItemList(player, True))

action,payment = "Снято",""

if price > 0:

action,payment = "Куплено","Стоимость: <font color="+CPRICE+">" + str(Util.formatAdena(price)) + " " + str(valute) + "</font>"

alarm = L2World.getInstance().getPlayer(self.getSellerName(con,charId))

if alarm:

alarm.sendMessage("Уведомление с аукциона:" + bItem.getName() + " (+" + str(enchant) + ") купили!")

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase list\">Назад|<-</a></td></tr></table><br>"

htmltext += action + "<br1> <font color="+CITEM+">" + bItem.getName() + "</font><font color="+CENCH+"> +" + str(enchant) + "</font><br> " + self.getAugmentSkill(augment, auhLevel) + " <br> " + payment + "</body></html>"

else:

return self.error("Покупка шмотки","Ни найдена или уже купили")

except:

pass

finally:

self.closeRes(rs)

self.closeStat(st)

self.closeCon(con)

return htmltext

elif event == "search":

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase list\">Назад|<-</a></td></tr></table><br>"

htmltext += "<table width=260><tr>"

step = 0

for i in sorts:

htmltext += "<td><button value=\"" + sorts + "\" action=\"bypass -h Quest purchase find_ " + str(i) + " _ no _ no\" width=50 height=21 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td>"

step+=1

if step == 4:

step = 0

htmltext += "</tr><tr>"

htmltext += "</tr></table><br><table width=220 border=0><tr><td align=right><edit var=\"value\" width=150 length=\"16\"></td><td align=right><combobox width=71 var=keyword list=\"Id шмотки;Id аугмента\"></td><td><button value=\"Поиск\" action=\"bypass -h Quest purchase find_ 777 _ $value _ $keyword\" width=50 height=21 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td></tr></table>"

htmltext += "<br></body></html>"

return htmltext

elif event.startswith("find_ "):

search = str(event.replace("find_ ", ""))

type2,value,ptype=search.split("_")

type2,value,ptype=str(type2),str(value),str(ptype)

value = str(value.replace(" ", ""))

type2 = int(type2.replace(" ", ""))

if value == "" or ptype == "":

htmltext = "<html><body>Задан пустой поисковый запрос<br><br><a action=\"bypass -h Quest purchase list\">Вернуться.</a></body></html>"

return htmltext

if type2 != 777 and type2 >= 0:

ptype = "Тип шмотки"

psort = self.showSellItems(player, 1, 0, 0, 0, 0, type2)

value = sorts.get(type2, "")

if value == "":

return self.error("Сортировка","Ошибка запроса")

else:

if not value.isdigit():

return self.error("Сортировка","Ошибка запроса")

if ptype == " Id шмотки":

psort = self.showSellItems(player, 1, 0, 0, int(value), 0, -1)

else:

psort = self.showSellItems(player, 1, 0, 0, 0, int(value), -1)

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase search\">Назад|<-</a></td></tr></table><br>"

htmltext += "<table><tr><td width=260><font color=336699>Поиск по:</font> <font color=CC66CC>"+ptype+":</font><font color=CC33CC>"+value+"</font></td><td align=right width=70></td></tr></table><br1>"

htmltext += psort

htmltext += "<br><a action=\"bypass -h Quest purchase list\">Вернуться</a><br></body></html>"

return htmltext

elif event == "add":

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase list\">Назад|<-</a></td></tr></table><br1>"

htmltext += "<font color=LEVEL>Что хотите выставить на продажу?</font><br1>"

htmltext += "Оружие:<br1>"

htmltext += "<table width=240><tr><td><button value=\"Заточенное\" action=\"bypass -h Quest purchase enchanted_0\" width=90 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td>"

htmltext += "<td><button value=\"Аугментированное.\" action=\"bypass -h Quest purchase augment_1\" width=90 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td>"

htmltext += "</tr></table><br>--------<br1>"

htmltext += "<button value=\"Броня (+)\" action=\"bypass -h Quest purchase enchanted_1\" width=90 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br>"

htmltext += "<button value=\"Бижутерия (+)\" action=\"bypass -h Quest purchase enchanted_2\" width=90 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br>"

htmltext += "</body></html>"

return htmltext

elif event.startswith("enchanted_"):

chType = int(event.replace("enchanted_", ""))

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase add\">Назад|<-</a></td></tr></table><br1>"

htmltext += "Шаг 1.<br>Выберите шмотку:<br><br><table width=300>"

self.clearVars(player)

if chType > 3: # каг?

return self.error("Добавление шмоток","Ошибка запроса")

for item in player.getInventory().getItems():

itemTemplate = item.getItem()

itemId = itemTemplate.getItemId()

itemType = itemTemplate.getType2()

itemGrade = itemTemplate.getCrystalType()

preench = item.getEnchantLevel()

if item.canBeEnchanted() and preench > 0 and itemType == chType and itemId not in FORBIDDEN and itemTemplate.getDuration() == -1 and itemGrade > 3 and not item.isEquipped():

augment = ""

if chType == 0:

augment = "<font color=333366>Нет аугмента</font>"

if item.isAugmented() and item.getAugmentation().getAugmentSkill() != None:

augment = item.getAugmentation().getAugmentSkill()

augment,level = str(augment.getId()),str(augment.getLevel())

augment = self.getAugmentSkill(int(augment), int(level))

htmltext += "<tr><td><img src=\""+itemTemplate.getIcon()+"\" width=32 height=32><br></td><td><a action=\"bypass -h Quest purchase step2_" + str(item.getObjectId()) +"_1\">" + itemTemplate.getName() + "</a> <font color="+CENCH+">+" + str(preench) + "</font><br1>" + augment + "</td></tr>"

htmltext += "</table><br></body></html>"

return htmltext

elif event.startswith("augment_"):

chType = int(event.replace("augment_", ""))

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase add\">Назад|<-</a></td></tr></table><br1>"

htmltext += "Шаг 1.<br>Выберите шмотку:<br><br><table width=300>"

self.clearVars(player)

if chType != 1: # каг?

return self.error("Добавление шмоток","Ошибка запроса")

for item in player.getInventory().getItems():

itemTemplate = item.getItem()

itemId = itemTemplate.getItemId()

itemType = itemTemplate.getType2()

itemGrade = itemTemplate.getCrystalType()

preench = item.getEnchantLevel()

if item.canBeEnchanted() and item.isAugmented() and item.getAugmentation().getAugmentSkill() != None and itemType == 0 and itemId not in FORBIDDEN and itemTemplate.getDuration() == -1 and itemGrade > 3 and not item.isEquipped():

augment = ""

if chType == 0:

augment = "<font color=333366>Нет аугмента</font>"

if item.isAugmented() and item.getAugmentation().getAugmentSkill() != None:

augment = item.getAugmentation().getAugmentSkill()

augment,level = str(augment.getId()),str(augment.getLevel())

augment = self.getAugmentSkill(int(augment), int(level))

htmltext += "<tr><td><img src=\""+itemTemplate.getIcon()+"\" width=32 height=32><br></td><td><a action=\"bypass -h Quest purchase step2_" + str(item.getObjectId()) +"_2\">" + itemTemplate.getName() + "</a> <font color="+CENCH+">+" + str(preench) + "</font><br1>" + augment + "</td></tr>"

htmltext += "</table><br></body></html>"

return htmltext

elif event.startswith("step2_"):

search = str(event.replace("step2_", ""))

itemObjId,chType=search.split("_")

itemObjId,chType=int(itemObjId),int(chType)

item = player.getInventory().getItemByObjectId(itemObjId)

if item.canBeEnchanted() and item and not item.isEquipped():

itemId = item.getItemId()

itemTemplate = item.getItem()

itemType = itemTemplate.getType2()

preench = item.getEnchantLevel()

if chType == 1 and preench == 0:

return self.error("Подробная инфа о шмотке","Ошибка запроса")

augment = ""

if chType == 2:

augment = "<font color=333366>Нет аугмента</font>"

augSkill = 0

if item.isAugmented() and item.getAugmentation().getAugmentSkill() != None:

augment = item.getAugmentation().getAugmentSkill()

#if chType == 2 and augment == None:

#return self.error("Подробная инфа о шмотке","Ошибка запроса")

augment,level = str(augment.getId()),str(augment.getLevel())

augSkill = int(augment)

augment = self.getAugmentSkill(int(augment), int(level))

quest.set("augment",str(augSkill))

quest.set("objId",str(itemObjId))

quest.set("enchant",str(preench))

htmltext = "<html><body>Шаг 2.<br>Подтверждаете?<br>"

htmltext += "<table width=300><tr><td><img src=\""+itemTemplate.getIcon()+"\" width=32 height=32></td><td><font color="+CITEM+">" + itemTemplate.getName() + "</font><font color="+CENCH+">+" + str(preench) + "</font><br>"+ augment + "</td></tr></table><br><br>"

htmltext += "Введите желаемую цену и выберите валюту:<br>"

mvars = "Adena;"

for i in moneys:

mvars+=moneys+";"

htmltext += "<table width=300><tr><td><edit var=\"price\" width=70 length=\"16\"></td><td><combobox width=100 var=type list=\"" + mvars + "\"></td></tr></table><br>"

htmltext += "<button value=\"Продолжить\" action=\"bypass -h Quest purchase step3_ $price _ $type\" width=70 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br>"

htmltext += "<br><a action=\"bypass -h Quest purchase add\">Вернуться.</a></body></html>"

else :

htmltext = "<html><body>Ошибка!<br><a action=\"bypass -h Quest purchase step1\">Вернуться.</a></body></html>"

return htmltext

elif event.startswith("step3_ "):

search = str(event.replace("step3_ ", ""))

price,mvar=search.split("_")

price,mvar=str(price),str(mvar)

price = str(price.replace(" ", ""))

if price == "" or mvar == "":

return self.error("Шаг 3","Ошибка запроса")

if not price.isdigit():

return self.error("Шаг 3","Ошибка запроса")

price = int(price)

if price == 0:

return self.error("Шаг 3","Ошибка запроса")

mvarId = 57

for i in moneys:

if " "+moneys == mvar:

mvarId = i

break

if mvarId == 57 and price > MAX_ADENA:

self.clearVars(player)

return self.error("Шаг 3","Максимальная цена " + str(Util.formatAdena(MAX_ADENA)) + " Adena.")

myItem = quest.getInt("objId")

item = player.getInventory().getItemByObjectId(myItem)

if item:

if item.isEquipped():

return self.error("Шаг 3","Ошибка запроса")

if not item.canBeEnchanted():

return self.error("Шаг 3","Ошибка запроса")

myEnch = quest.getInt("enchant")

myAugm = quest.getInt("augment")

itemId = item.getItemId()

itemTemplate = item.getItem()

itemType = itemTemplate.getType2()

preench = item.getEnchantLevel()

if preench != myEnch:

self.clearVars(player)

return self.error("Шаг 3","Ошибка запроса")

augment = "нет."

augEffId = 0

augSkId = 0

augSkLvl = 0

if item.isAugmented() and item.getAugmentation().getAugmentSkill() != None:

augment = item.getAugmentation().getAugmentSkill()

augEffId = item.getAugmentation().getAugmentationId()

augSkId,augSkLvl = str(augment.getId()),str(augment.getLevel())

if myAugm != int(augSkId):

self.clearVars(player)

return self.error("Шаг 3","Ошибка запроса")

#<

try:

con2=L2DatabaseFactory.getInstance().getConnection()

storeitem=con2.prepareStatement("INSERT INTO `z_stock_items` (`id`,`itemId`,`itemName`,`enchant`,`augment`,`augAttr`,`augLvl`,`price`,`money`,`type`,`ownerId`,`shadow`) VALUES (NULL,?,?,?,?,?,?,?,?,?,?,?);")

storeitem.setInt(1,itemId)

storeitem.setString(2, itemTemplate.getName())

storeitem.setInt(3, preench)

storeitem.setInt(4, int(augSkId))

storeitem.setInt(5, int(augEffId))

storeitem.setInt(6, int(augSkLvl))

storeitem.setInt(7, price)

storeitem.setInt(8, mvarId)

storeitem.setInt(9, itemType)

storeitem.setInt(10, player.getObjectId())

storeitem.setInt(11, 0)

storeitem.executeUpdate()

except:

self.clearVars(player)

return self.error("Шаг 3","Ошибка базы данных")

finally:

self.closeStat(storeitem)

self.closeCon(con2)

player.destroyItem("zzAuction",myItem, 1, player, 1)

#<

self.clearVars(player)

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase add\">Назад|<-</a></td></tr></table><br1>"

htmltext += "<font color="+CITEM+">" + itemTemplate.getName() + "</font><font color="+CENCH+">+" + str(preench) + "</font><br1> " + self.getAugmentSkill(int(augSkId), int(augSkLvl)) + " <br1>выставлена на продажу!</body></html>"

else:

self.clearVars(player)

return self.error("Шаг 3","Ошибка запроса")

return htmltext

elif event == "office":

#data = str(strftime("%Y-%m-%d", gmtime()))

#time = str(strftime("%H:%M:%S", gmtime()))

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase list\">Назад|<-</a></td></tr></table><br1>"

htmltext += "Привет, " + player.getName() + ".<br>"

#htmltext += "Привет, " + player.getName() + ".<br>Сейчас " + data + " " + time + "<br>"

htmltext += "<button value=\"Мои шмотки\" action=\"bypass -h Quest purchase StockShowPage_1_1_0_0_-1\" width=70 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br>"

htmltext += "</body></html>"

return htmltext

return

def onTalk (self,npc,player):

st = player.getQuestState(qn)

npcId = npc.getNpcId()

if npcId == MARKET:

return "<html><body>На аукционе вы можете торговать заточенными и аугментированными шмотками.<br><a action=\"bypass -h Quest purchase list\">Просмотр</a><br><br>Если шмотку купили, оплата придет на почту.</body></html>"

return

QUEST = Quest(-1,qn,"custom")

CREATED = State('Start', QUEST)

QUEST.setInitialState(CREATED)

QUEST.addStartNpc(MARKET)

QUEST.addTalkId(MARKET)

Изменено 28 ноября, 2012 пользователем Absent

iPerfect · 28 ноября, 2012

# -*- coding: utf-8 -*-

import sys

from javolution.text import TextBuilder

from net.sf.l2j import L2DatabaseFactory

from net.sf.l2j.gameserver.datatables import AugmentationData

from net.sf.l2j.gameserver.datatables import ItemTable

from net.sf.l2j.gameserver.datatables import SkillTable

from net.sf.l2j.gameserver.model import L2Augmentation

from net.sf.l2j.gameserver.model import L2ItemInstance

from net.sf.l2j.gameserver.model import L2Skill

from net.sf.l2j.gameserver.model import L2World

from net.sf.l2j.gameserver.model.quest import State

from net.sf.l2j.gameserver.model.quest import QuestState

from net.sf.l2j.gameserver.model.quest.jython import QuestJython as JQuest

from net.sf.l2j.gameserver.network import SystemMessageId

from net.sf.l2j.gameserver.network.serverpackets import ExMailArrived

from net.sf.l2j.gameserver.network.serverpackets import ItemList

from net.sf.l2j.gameserver.network.serverpackets import SystemMessage

from net.sf.l2j.gameserver.templates import L2Item

from net.sf.l2j.util import Rnd

from net.sf.l2j.gameserver.util import Util

from time import gmtime, strftime

qn = "purchase"

MARKET = 80007

PAGE_LIMIT = 10

SORT_LIMIT = 8

MAX_ADENA = 2147000000

FORBIDDEN = [6611,6612,6613,6614,6615,6616,6617,6618,6619,6620,6621]

#

CENCH = "CCCC33"

CPRICE = "669966"

CITEM = "993366"

CAUG1 = "333366"

CAUG2 = "006699"

moneys = {4037: "Coin Of Luck", 4355: "Blue Eva", 5962: "Gold Golem"}

sorts = {0: "Оружие", 1: "Броня", 2: "Бижутерия"}

class Quest (JQuest) :

def __init__(self,id,name,descr): JQuest.__init__(self,id,name,descr)

def init_LoadGlobalData(self) :

print "purchase: ok"

def closeStat(self,st):

if st != None:

st.close()

return

def closeRes(self,rs):

if rs != None:

rs.close()

return

def closeCon(self,con):

if con != None:

con.close()

return

def getMoneyCall(self,money):

return moneys.get(money, str("Adena"))

def getSellerName(self,con,charId):

name = "???"

try:

st = con.prepareStatement("SELECT char_name FROM `characters` WHERE `Obj_Id`=? LIMIT 1");

st.setInt(1, charId);

rs = st.executeQuery();

if rs.next():

name = rs.getString("char_name")

except:

pass

finally:

self.closeRes(rs)

self.closeStat(st)

return name

def getAugmentSkill(self, aid, lvl):

augment = SkillTable.getInstance().getInfo(aid, lvl)

if augment == None:

return ""

augName = augment.getName();

stype = "Шанс";

ttype = "";

power = ":" + str(int(augment.getPower())) + "power";

if augment.isActive():

stype = "Актив"

if augment.isAuraSkill():

ttype = "<br1>(Массовый)";

elif augment.isPassive():

stype = "Пассив"

power = "";

augName = augName.replace("Item Skill: ", "");

return "<font color="+CAUG1+">Аугмент:</font> <font color="+CAUG2+">" + augName + " Lv " + str(lvl) + " (" + stype + power + ")" + ttype + "</font>";

def getPageCount(self, con, me, itemId, augment, type2, charId):

rowCount = 0

pages = 0

try:

con=L2DatabaseFactory.getInstance().getConnection()

if type2 >= 0:

st=con.prepareStatement("SELECT COUNT(`id`) FROM `z_stock_items` WHERE `type` = ?")

st.setInt(1, type2)

elif itemId > 0:

st=con.prepareStatement("SELECT COUNT(`id`) FROM `z_stock_items` WHERE `itemId` = ?")

st.setInt(1, itemId)

elif augment > 0:

st=con.prepareStatement("SELECT COUNT(`id`) FROM `z_stock_items` WHERE `augment` = ?")

st.setInt(1, augment)

elif me == 1:

st=con.prepareStatement("SELECT COUNT(`id`) FROM `z_stock_items` WHERE `ownerId` = ?")

st.setInt(1, charId)

else:

st=con.prepareStatement("SELECT COUNT(`id`) FROM `z_stock_items` WHERE `id` > 0")

rs=st.executeQuery()

if (rs.next()):

rowCount = rs.getInt(1)

except :

pass

finally:

self.closeRes(rs)

self.closeStat(st)

if rowCount == 0:

return "0"

pages = (rowCount / PAGE_LIMIT) + 1

return str(pages)

def error(self,action, text):

return "<html><body> " + action + ": <br> " + text + "</body></html>"

def transferPay(self,con,charId,itemId,enchant,augment,auhLevel,price,money):

item = ItemTable.getInstance().getTemplate(itemId)

if item == None:

return False

data = str(strftime("%Y-%m-%d", gmtime()))

time = str(strftime("%H:%M:%S", gmtime()))

text = TextBuilder()

text.append("Итем: <font color=FF3399>" + item.getName() + " +" + str(enchant) + " " + self.getAugmentSkill(augment, auhLevel) +"</font><br1> был успешно продан.<br1>")

text.append("Благодарим за сотрудничество.")

try:

sName = self.getSellerName(con,charId)

st = con.prepareStatement("INSERT INTO `z_post_pos` (`id`,`tema`,`text`,`from`,`to`,`type`,`date`,`time`,`itemName`,`itemId`,`itemCount`,`itemEnch`,`augData`,`augSkill`,`augLvl`) VALUES (NULL,?,?,?,?,?,?,?,?,?,?,?,?,?,?)")

st.setString(1, "Шмотка продана")

st.setString(2, text.toString())

st.setString(3, "~zzAuction#.")

st.setString(4, sName)

st.setInt(5, 0)

st.setString(6, data)

st.setString(7, time)

st.setString(8, item.getName())

st.setInt(9, money)

st.setInt(10, price)

st.setInt(11, 0)

st.setInt(12, 0)

st.setInt(13, 0)

st.setInt(14, 0)

st.execute()

alarm = L2World.getInstance().getPlayer(sName)

if alarm:

alarm.sendMessage("Уведомление с аукциона: проверь почту")

alarm.sendPacket(ExMailArrived())

return True

except:

return False

finally:

text.clear()

self.closeStat(st)

return False

def showSellItems(self,player, page, me, last, itemId, augment, type2):

text = TextBuilder("<br><table width=300><tr><td width=36></td><td width=264>")

if last == 1:

text.append("Последние " + str(PAGE_LIMIT) + ":</td></tr>")

else:

text.append("Страница " + str(page) + ":</td></tr>")

limit1 = (page-1) * PAGE_LIMIT

limit2 = PAGE_LIMIT

con = None

try:

con=L2DatabaseFactory.getInstance().getConnection()

if type2 >= 0:

st=con.prepareStatement("SELECT id, itemId, enchant, augment, augLvl, price, money, ownerId, shadow FROM `z_stock_items` WHERE `type` = ? ORDER BY `id` DESC LIMIT ?, ?")

st.setInt(1, type2)

st.setInt(2, limit1)

st.setInt(3, limit2)

elif itemId > 0:

st=con.prepareStatement("SELECT id, itemId, enchant, augment, augLvl, price, money, ownerId, shadow FROM `z_stock_items` WHERE `itemId` = ? ORDER BY `id` DESC LIMIT ?, ?")

st.setInt(1, itemId)

st.setInt(2, limit1)

st.setInt(3, limit2)

elif augment > 0:

st=con.prepareStatement("SELECT id, itemId, enchant, augment, augLvl, price, money, ownerId, shadow FROM `z_stock_items` WHERE `augment` = ? ORDER BY `id` DESC LIMIT ?, ?")

st.setInt(1, augment)

st.setInt(2, limit1)

st.setInt(3, limit2)

elif me == 1:

st=con.prepareStatement("SELECT id, itemId, enchant, augment, augLvl, price, money, ownerId, shadow FROM `z_stock_items` WHERE `ownerId` = ? ORDER BY `id` DESC LIMIT ?, ?")

st.setInt(1, player.getObjectId())

st.setInt(2, limit1)

st.setInt(3, limit2)

else:

st=con.prepareStatement("SELECT id, itemId, enchant, augment, augLvl, price, money, ownerId, shadow FROM `z_stock_items` ORDER BY `id` DESC LIMIT ?, ?")

st.setInt(1, limit1)

st.setInt(2, limit2)

rs=st.executeQuery()

while (rs.next()):

sId = rs.getInt("id")

itmId = rs.getInt("itemId")

ownerId = rs.getInt("ownerId")

brokeItem = ItemTable.getInstance().getTemplate(itmId)

if brokeItem == None:

continue

priceB = "<font color="+CPRICE+">" + str(Util.formatAdena(rs.getInt("price"))) + " " + self.getMoneyCall(rs.getInt("money")) + "; \"" + self.getSellerName(con,ownerId) + "</font>"

if player.getObjectId() == ownerId:

priceB = "<table width=240><tr><td width=160><font color=666699>" + str(Util.formatAdena(rs.getInt("price"))) + " " + self.getMoneyCall(rs.getInt("money")) + ";</font></td><td align=right><button value=\"X\" action=\"bypass -h Quest purchase StockBuyItem_" + str(sId) + "\" width=25 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td></tr></table><br1>"

text.append("<tr><td><img src=\"" + brokeItem.getIcon() + "\" width=32 height=32></td><td><a action=\"bypass -h Quest purchase StockShowItem_" + str(sId) + "\"> <font color="+CITEM+">" + brokeItem.getName() + "</font></a><font color="+CENCH+">+" + str(rs.getInt("enchant")) + "</font> <br1> " +priceB+ " <br1>" + self.getAugmentSkill(rs.getInt("augment"), rs.getInt("augLvl")) + "</td></tr>");

except:

pass

finally:

self.closeRes(rs)

self.closeStat(st)

text.append("</table><br>");

if last == 1:

text.append("<br>");

else:

pages = int(self.getPageCount(con, me, itemId, augment, type2,player.getObjectId()))

if pages >= 2:

text.append(self.sortPages(page,pages,me,itemId,augment,type2))

self.closeCon(con)

htmltext = text.toString()

text.clear()

return htmltext

def sortPages(self,page,pages,me,itemId,augment,type2):

text = TextBuilder("<br>Страницы:<br1><table width=300><tr>")

step = 1

s = page - 3

f = page + 3

if page < SORT_LIMIT and s < SORT_LIMIT:

s = 1

if page >= SORT_LIMIT:

text.append("<td><a action=\"bypass -h Quest purchase StockShowPage_" + str(s) + "_" + str(me) + "_" + str(itemId) + "_" + str(augment) + "_" + str(type2) + "\"> ... </a></td>")

for i in range(s,(pages+1)):

al = i + 1

if i == page:

text.append("<td>" + str(i) + "</td>")

else:

if al <= pages:

text.append("<td><a action=\"bypass -h Quest purchase StockShowPage_" + str(i) + "_" + str(me) + "_" + str(itemId) + "_" + str(augment) + "_" + str(type2) + "\">" + str(i) + "</a></td>")

if step == SORT_LIMIT and f < pages:

if al < pages:

text.append("<td><a action=\"bypass -h Quest purchase StockShowPage_" + str(al) + "_" + str(me) + "_" + str(itemId) + "_" + str(augment) + "_" + str(type2) + "\"> ... </a></td>")

break

step+=1

text.append("</tr></table><br>")

htmltext = text.toString()

text.clear()

return htmltext

def clearVars(self,player):

quest = player.getQuestState(qn)

quest.unset("objId")

quest.unset("augment")

quest.unset("enchant")

return

def onAdvEvent (self,event,npc,player):

quest = player.getQuestState(qn)

if event == "list":

htmltext = "<html><body><table width=280><tr><td>Аукцион</td><td align=right><button value=\"Офис\" action=\"bypass -h Quest purchase office\" width=70 height=17 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td><td align=right><button value=\"Добавить\" action=\"bypass -h Quest purchase add\" width=70 height=17 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td><td align=right><button value=\"Поиск\" action=\"bypass -h Quest purchase search\" width=40 height=17 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td></tr></table><br>"

htmltext += self.showSellItems(player, 1, 0, 0, 0, 0, -1)

htmltext += "<br></body></html>"

return htmltext

elif event.startswith("StockShowPage_"):

search = str(event.replace("StockShowPage_", ""))

page,me,itemId,augment,type2=search.split("_")

if page == "" or me == "" or augment == "" or itemId == "" or type2 == "":

return self.error("Листание страниц","Ошибка запроса")

page,me,itemId,augment,type2=int(page),int(me),int(itemId),int(augment),int(type2)

if me == 1:

stype = "Мои шмотки"

htmltext = "<html><body><table width=280><tr><td>Аукцион</td><td align=right><button value=\"Офис\" action=\"bypass -h Quest purchase office\" width=70 height=17 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td><td align=right><button value=\"Добавить\" action=\"bypass -h Quest purchase add\" width=70 height=17 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td><td align=right><button value=\"Поиск\" action=\"bypass -h Quest purchase search\" width=40 height=17 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td></tr></table><br><br1>"

htmltext += self.showSellItems(player, page, me, 0, itemId, augment, type2)

htmltext += "<br></body></html>"

return htmltext

elif event.startswith("StockShowItem_"):

sellId = event.replace("StockShowItem_", "")

if sellId == "":

return self.error("Просмотр шмотки","Ошибка запроса")

sellId=int(sellId)

text = TextBuilder("<html><body>")

try:

con = L2DatabaseFactory.getInstance().getConnection();

st = con.prepareStatement("SELECT itemId, enchant, augment, augLvl, price, money, ownerId, shadow FROM `z_stock_items` WHERE `id`=? LIMIT 1");

st.setInt(1, sellId);

rs = st.executeQuery();

if rs.next():

itemId = rs.getInt("itemId");

brokeItem = ItemTable.getInstance().getTemplate(itemId);

if brokeItem == None:

return self.error("Просмотр шмотки","Ошибка запроса")

text.append("<font color=666666>ID шмотки: " + str(itemId) + "</font> <button value=\"Найти еще\" action=\"bypass -h Quest purchase find_ 777 _ " + str(itemId) + " _ Id шмотки\" width=70 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\">")

enchant = rs.getInt("enchant");

augment = rs.getInt("augment");

auhLevel = rs.getInt("augLvl");

price = rs.getInt("price");

money = rs.getInt("money");

charId = rs.getInt("ownerId");

shadow = rs.getInt("shadow");

valute = self.getMoneyCall(money);

#<

text.append("<table width=300><tr><td><img src=\"" + brokeItem.getIcon() + "\" width=32 height=32></td><td><font color=LEVEL>" + brokeItem.getName() + " +" + str(enchant) + "</font><br></td></tr></table><br><br>")

text.append("Продавец: " + self.getSellerName(con,charId) + "<br><br>")

text.append(self.getAugmentSkill(augment, auhLevel) + "<br1>")

if augment > 0:

text.append("<button value=\"Найти еще\" action=\"bypass -h Quest purchase find_ 777 _ " + str(augment) + " _ Id аугмента\" width=70 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br><br>")

if player.getObjectId() == charId:

text.append("<button value=\"Забрать\" action=\"bypass -h Quest purchase StockBuyItem_" + str(sellId) + "\" width=60 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br>")

else:

payment = player.getInventory().getItemByItemId(money);

fprice = str(Util.formatAdena(price))

if payment != None and payment.getCount() >= price:

text.append("<font color=33CC00>Стоимость: " + fprice+ " " + str(valute) + "</font><br>");

text.append("<button value=\"Купить\" action=\"bypass -h Quest purchase StockBuyItem_" + str(sellId) + "\" width=60 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br>")

else:

text.append("<font color=CC3333>Стоимость: " + fprice + " " + str(valute) + "</font><br>");

text.append("<font color=999999>[Купить]</font>");

else:

return self.error("Просмотр шмотки","Ни найдена или уже купили")

except:

pass

finally:

self.closeRes(rs)

self.closeStat(st)

self.closeCon(con)

text.append("<br><br><a action=\"bypass -h Quest purchase list\">Вернуться</a><br>");

text.append("</body></html>");

htmltext = text.toString()

text.clear()

return htmltext

elif event.startswith("StockBuyItem_"):

sellId = event.replace("StockBuyItem_", "")

if sellId == "":

return self.error("Покупка шмотки","Ошибка запроса")

sellId=int(sellId)

try:

con = L2DatabaseFactory.getInstance().getConnection();

st = con.prepareStatement("SELECT itemId, itemName, enchant, augment, augAttr, augLvl, price, money, ownerId, shadow FROM `z_stock_items` WHERE `id`=? LIMIT 1");

st.setInt(1, sellId);

rs = st.executeQuery();

if rs.next():

itemId = rs.getInt("itemId");

bItem = ItemTable.getInstance().getTemplate(itemId);

if bItem == None:

return self.error("Покупка шмотки","Ошибка запроса")

itemName = rs.getString("itemName");

enchant = rs.getInt("enchant");

augment = rs.getInt("augment");

augAttr = rs.getInt("augAttr");

auhLevel = rs.getInt("augLvl");

price = rs.getInt("price");

money = rs.getInt("money");

charId = rs.getInt("ownerId");

shadow = rs.getInt("shadow");

valute = self.getMoneyCall(money);

#<

if player.getObjectId() == charId:

price = 0

if price > 0:

payment = player.getInventory().getItemByItemId(money);

if payment != None and payment.getCount() >= price:

quest.takeItems(money,price)

else:

return self.error("Покупка шмотки","Проверьте стоимость")

#>

try:

zabiraem=con.prepareStatement("DELETE FROM `z_stock_items` WHERE `id`=?")

zabiraem.setInt(1, sellId)

zabiraem.executeUpdate()

except:

return self.error("Покупка шмотки","Ошибка запроса")

finally:

self.closeStat(zabiraem)

#>

if price > 0 and not self.transferPay(con,charId,itemId,enchant,augment,auhLevel,price,money):

return self.error("Покупка шмотки","Ошибка запроса")

#>

item = player.getInventory().addItem("zzAuction", itemId, 1, player, player.getTarget())

if enchant != 0:

item.setEnchantLevel(enchant)

if augAttr != 0:

item.setAugmentation(L2Augmentation(item, augAttr, augment, auhLevel, True))

smsg = SystemMessage(SystemMessageId.EARNED_S2_S1_S)

smsg.addItemName(itemId)

smsg.addNumber(1)

player.sendPacket(smsg)

player.sendPacket(ItemList(player, True))

action,payment = "Снято",""

if price > 0:

action,payment = "Куплено","Стоимость: <font color="+CPRICE+">" + str(Util.formatAdena(price)) + " " + str(valute) + "</font>"

alarm = L2World.getInstance().getPlayer(self.getSellerName(con,charId))

if alarm:

alarm.sendMessage("Уведомление с аукциона:" + bItem.getName() + " (+" + str(enchant) + ") купили!")

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase list\">Назад|<-</a></td></tr></table><br>"

htmltext += action + "<br1> <font color="+CITEM+">" + bItem.getName() + "</font><font color="+CENCH+"> +" + str(enchant) + "</font><br> " + self.getAugmentSkill(augment, auhLevel) + " <br> " + payment + "</body></html>"

else:

return self.error("Покупка шмотки","Ни найдена или уже купили")

except:

pass

finally:

self.closeRes(rs)

self.closeStat(st)

self.closeCon(con)

return htmltext

elif event == "search":

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase list\">Назад|<-</a></td></tr></table><br>"

htmltext += "<table width=260><tr>"

step = 0

for i in sorts:

htmltext += "<td><button value=\"" + sorts + "\" action=\"bypass -h Quest purchase find_ " + str(i) + " _ no _ no\" width=50 height=21 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td>"

step+=1

if step == 4:

step = 0

htmltext += "</tr><tr>"

htmltext += "</tr></table><br><table width=220 border=0><tr><td align=right><edit var=\"value\" width=150 length=\"16\"></td><td align=right><combobox width=71 var=keyword list=\"Id шмотки;Id аугмента\"></td><td><button value=\"Поиск\" action=\"bypass -h Quest purchase find_ 777 _ $value _ $keyword\" width=50 height=21 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td></tr></table>"

htmltext += "<br></body></html>"

return htmltext

elif event.startswith("find_ "):

search = str(event.replace("find_ ", ""))

type2,value,ptype=search.split("_")

type2,value,ptype=str(type2),str(value),str(ptype)

value = str(value.replace(" ", ""))

type2 = int(type2.replace(" ", ""))

if value == "" or ptype == "":

htmltext = "<html><body>Задан пустой поисковый запрос<br><br><a action=\"bypass -h Quest purchase list\">Вернуться.</a></body></html>"

return htmltext

if type2 != 777 and type2 >= 0:

ptype = "Тип шмотки"

psort = self.showSellItems(player, 1, 0, 0, 0, 0, type2)

value = sorts.get(type2, "")

if value == "":

return self.error("Сортировка","Ошибка запроса")

else:

if not value.isdigit():

return self.error("Сортировка","Ошибка запроса")

if ptype == " Id шмотки":

psort = self.showSellItems(player, 1, 0, 0, int(value), 0, -1)

else:

psort = self.showSellItems(player, 1, 0, 0, 0, int(value), -1)

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase search\">Назад|<-</a></td></tr></table><br>"

htmltext += "<table><tr><td width=260><font color=336699>Поиск по:</font> <font color=CC66CC>"+ptype+":</font><font color=CC33CC>"+value+"</font></td><td align=right width=70></td></tr></table><br1>"

htmltext += psort

htmltext += "<br><a action=\"bypass -h Quest purchase list\">Вернуться</a><br></body></html>"

return htmltext

elif event == "add":

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase list\">Назад|<-</a></td></tr></table><br1>"

htmltext += "<font color=LEVEL>Что хотите выставить на продажу?</font><br1>"

htmltext += "Оружие:<br1>"

htmltext += "<table width=240><tr><td><button value=\"Заточенное\" action=\"bypass -h Quest purchase enchanted_0\" width=90 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td>"

htmltext += "<td><button value=\"Аугментированное.\" action=\"bypass -h Quest purchase augment_1\" width=90 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"></td>"

htmltext += "</tr></table><br>--------<br1>"

htmltext += "<button value=\"Броня (+)\" action=\"bypass -h Quest purchase enchanted_1\" width=90 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br>"

htmltext += "<button value=\"Бижутерия (+)\" action=\"bypass -h Quest purchase enchanted_2\" width=90 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br>"

htmltext += "</body></html>"

return htmltext

elif event.startswith("enchanted_"):

chType = int(event.replace("enchanted_", ""))

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase add\">Назад|<-</a></td></tr></table><br1>"

htmltext += "Шаг 1.<br>Выберите шмотку:<br><br><table width=300>"

self.clearVars(player)

if chType > 3: # каг?

return self.error("Добавление шмоток","Ошибка запроса")

for item in player.getInventory().getItems():

itemTemplate = item.getItem()

itemId = itemTemplate.getItemId()

itemType = itemTemplate.getType2()

itemGrade = itemTemplate.getCrystalType()

preench = item.getEnchantLevel()

if item.canBeEnchanted() and preench > 0 and itemType == chType and itemId not in FORBIDDEN and itemTemplate.getDuration() == -1 and itemGrade > 3 and not item.isEquipped():

augment = ""

if chType == 0:

augment = "<font color=333366>Нет аугмента</font>"

if item.isAugmented() and item.getAugmentation().getAugmentSkill() != None:

augment = item.getAugmentation().getAugmentSkill()

augment,level = str(augment.getId()),str(augment.getLevel())

augment = self.getAugmentSkill(int(augment), int(level))

htmltext += "<tr><td><img src=\""+itemTemplate.getIcon()+"\" width=32 height=32><br></td><td><a action=\"bypass -h Quest purchase step2_" + str(item.getObjectId()) +"_1\">" + itemTemplate.getName() + "</a> <font color="+CENCH+">+" + str(preench) + "</font><br1>" + augment + "</td></tr>"

htmltext += "</table><br></body></html>"

return htmltext

elif event.startswith("augment_"):

chType = int(event.replace("augment_", ""))

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase add\">Назад|<-</a></td></tr></table><br1>"

htmltext += "Шаг 1.<br>Выберите шмотку:<br><br><table width=300>"

self.clearVars(player)

if chType != 1: # каг?

return self.error("Добавление шмоток","Ошибка запроса")

for item in player.getInventory().getItems():

itemTemplate = item.getItem()

itemId = itemTemplate.getItemId()

itemType = itemTemplate.getType2()

itemGrade = itemTemplate.getCrystalType()

preench = item.getEnchantLevel()

if item.canBeEnchanted() and item.isAugmented() and item.getAugmentation().getAugmentSkill() != None and itemType == 0 and itemId not in FORBIDDEN and itemTemplate.getDuration() == -1 and itemGrade > 3 and not item.isEquipped():

augment = ""

if chType == 0:

augment = "<font color=333366>Нет аугмента</font>"

if item.isAugmented() and item.getAugmentation().getAugmentSkill() != None:

augment = item.getAugmentation().getAugmentSkill()

augment,level = str(augment.getId()),str(augment.getLevel())

augment = self.getAugmentSkill(int(augment), int(level))

htmltext += "<tr><td><img src=\""+itemTemplate.getIcon()+"\" width=32 height=32><br></td><td><a action=\"bypass -h Quest purchase step2_" + str(item.getObjectId()) +"_2\">" + itemTemplate.getName() + "</a> <font color="+CENCH+">+" + str(preench) + "</font><br1>" + augment + "</td></tr>"

htmltext += "</table><br></body></html>"

return htmltext

elif event.startswith("step2_"):

search = str(event.replace("step2_", ""))

itemObjId,chType=search.split("_")

itemObjId,chType=int(itemObjId),int(chType)

item = player.getInventory().getItemByObjectId(itemObjId)

if item.canBeEnchanted() and item and not item.isEquipped():

itemId = item.getItemId()

itemTemplate = item.getItem()

itemType = itemTemplate.getType2()

preench = item.getEnchantLevel()

if chType == 1 and preench == 0:

return self.error("Подробная инфа о шмотке","Ошибка запроса")

augment = ""

if chType == 2:

augment = "<font color=333366>Нет аугмента</font>"

augSkill = 0

if item.isAugmented() and item.getAugmentation().getAugmentSkill() != None:

augment = item.getAugmentation().getAugmentSkill()

#if chType == 2 and augment == None:

#return self.error("Подробная инфа о шмотке","Ошибка запроса")

augment,level = str(augment.getId()),str(augment.getLevel())

augSkill = int(augment)

augment = self.getAugmentSkill(int(augment), int(level))

quest.set("augment",str(augSkill))

quest.set("objId",str(itemObjId))

quest.set("enchant",str(preench))

htmltext = "<html><body>Шаг 2.<br>Подтверждаете?<br>"

htmltext += "<table width=300><tr><td><img src=\""+itemTemplate.getIcon()+"\" width=32 height=32></td><td><font color="+CITEM+">" + itemTemplate.getName() + "</font><font color="+CENCH+">+" + str(preench) + "</font><br>"+ augment + "</td></tr></table><br><br>"

htmltext += "Введите желаемую цену и выберите валюту:<br>"

mvars = "Adena;"

for i in moneys:

mvars+=moneys+";"

htmltext += "<table width=300><tr><td><edit var=\"price\" width=70 length=\"16\"></td><td><combobox width=100 var=type list=\"" + mvars + "\"></td></tr></table><br>"

htmltext += "<button value=\"Продолжить\" action=\"bypass -h Quest purchase step3_ $price _ $type\" width=70 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br>"

htmltext += "<br><a action=\"bypass -h Quest purchase add\">Вернуться.</a></body></html>"

else :

htmltext = "<html><body>Ошибка!<br><a action=\"bypass -h Quest purchase step1\">Вернуться.</a></body></html>"

return htmltext

elif event.startswith("step3_ "):

search = str(event.replace("step3_ ", ""))

price,mvar=search.split("_")

price,mvar=str(price),str(mvar)

price = str(price.replace(" ", ""))

if price == "" or mvar == "":

return self.error("Шаг 3","Ошибка запроса")

if not price.isdigit():

return self.error("Шаг 3","Ошибка запроса")

price = int(price)

if price == 0:

return self.error("Шаг 3","Ошибка запроса")

mvarId = 57

for i in moneys:

if " "+moneys == mvar:

mvarId = i

break

if mvarId == 57 and price > MAX_ADENA:

self.clearVars(player)

return self.error("Шаг 3","Максимальная цена " + str(Util.formatAdena(MAX_ADENA)) + " Adena.")

myItem = quest.getInt("objId")

item = player.getInventory().getItemByObjectId(myItem)

if item:

if item.isEquipped():

return self.error("Шаг 3","Ошибка запроса")

if not item.canBeEnchanted():

return self.error("Шаг 3","Ошибка запроса")

myEnch = quest.getInt("enchant")

myAugm = quest.getInt("augment")

itemId = item.getItemId()

itemTemplate = item.getItem()

itemType = itemTemplate.getType2()

preench = item.getEnchantLevel()

if preench != myEnch:

self.clearVars(player)

return self.error("Шаг 3","Ошибка запроса")

augment = "нет."

augEffId = 0

augSkId = 0

augSkLvl = 0

if item.isAugmented() and item.getAugmentation().getAugmentSkill() != None:

augment = item.getAugmentation().getAugmentSkill()

augEffId = item.getAugmentation().getAugmentationId()

augSkId,augSkLvl = str(augment.getId()),str(augment.getLevel())

if myAugm != int(augSkId):

self.clearVars(player)

return self.error("Шаг 3","Ошибка запроса")

#<

try:

con2=L2DatabaseFactory.getInstance().getConnection()

storeitem=con2.prepareStatement("INSERT INTO `z_stock_items` (`id`,`itemId`,`itemName`,`enchant`,`augment`,`augAttr`,`augLvl`,`price`,`money`,`type`,`ownerId`,`shadow`) VALUES (NULL,?,?,?,?,?,?,?,?,?,?,?);")

storeitem.setInt(1,itemId)

storeitem.setString(2, itemTemplate.getName())

storeitem.setInt(3, preench)

storeitem.setInt(4, int(augSkId))

storeitem.setInt(5, int(augEffId))

storeitem.setInt(6, int(augSkLvl))

storeitem.setInt(7, price)

storeitem.setInt(8, mvarId)

storeitem.setInt(9, itemType)

storeitem.setInt(10, player.getObjectId())

storeitem.setInt(11, 0)

storeitem.executeUpdate()

except:

self.clearVars(player)

return self.error("Шаг 3","Ошибка базы данных")

finally:

self.closeStat(storeitem)

self.closeCon(con2)

player.destroyItem("zzAuction",myItem, 1, player, 1)

#<

self.clearVars(player)

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase add\">Назад|<-</a></td></tr></table><br1>"

htmltext += "<font color="+CITEM+">" + itemTemplate.getName() + "</font><font color="+CENCH+">+" + str(preench) + "</font><br1> " + self.getAugmentSkill(int(augSkId), int(augSkLvl)) + " <br1>выставлена на продажу!</body></html>"

else:

self.clearVars(player)

return self.error("Шаг 3","Ошибка запроса")

return htmltext

elif event == "office":

#data = str(strftime("%Y-%m-%d", gmtime()))

#time = str(strftime("%H:%M:%S", gmtime()))

htmltext = "<html><body><table><tr><td width=260>Аукцион</td><td align=right width=70><a action=\"bypass -h Quest purchase list\">Назад|<-</a></td></tr></table><br1>"

htmltext += "Привет, " + player.getName() + ".<br>"

#htmltext += "Привет, " + player.getName() + ".<br>Сейчас " + data + " " + time + "<br>"

htmltext += "<button value=\"Мои шмотки\" action=\"bypass -h Quest purchase StockShowPage_1_1_0_0_-1\" width=70 height=15 back=\"sek.cbui94\" fore=\"sek.cbui92\"><br>"

htmltext += "</body></html>"

return htmltext

return

def onTalk (self,npc,player):

st = player.getQuestState(qn)

npcId = npc.getNpcId()

if npcId == MARKET:

return "<html><body>На аукционе вы можете торговать заточенными и аугментированными шмотками.<br><a action=\"bypass -h Quest purchase list\">Просмотр</a><br><br>Если шмотку купили, оплата придет на почту.</body></html>"

return

QUEST = Quest(-1,qn,"custom")

CREATED = State('Start', QUEST)

QUEST.setInitialState(CREATED)

QUEST.addStartNpc(MARKET)

QUEST.addTalkId(MARKET)

Теперь новая ошибка:

Traceback (innermost last):

(no code object) at line 0

SyntaxError: ('invalid syntax', ('__init__.py', 46, 1, 'def __init__(self,id,name,descr): JQuest.__init__(self,id,name,descr)'))

Absent · 28 ноября, 2012

Попробуй инит закинуть вот этот

__init__.rar

Изменено 28 ноября, 2012 пользователем Absent

iPerfect · 28 ноября, 2012

Попробуй инит закинуть вот этот

Вернулась старая ошибка))))

Traceback (innermost last):

(no code object) at line 0

SyntaxError: ('invalid syntax', ('__init__.py', 80, 4, ' finally:'))

Absent · 28 ноября, 2012

Вернулась старая ошибка))))

Traceback (innermost last):

(no code object) at line 0

SyntaxError: ('invalid syntax', ('__init__.py', 80, 4, ' finally:'))

Сборка pw ?

iPerfect · 28 ноября, 2012

Сборка pw ?

софт

Absent · 28 ноября, 2012

софт

А скрипт с пв,я так понимаю?

У них структура написания скрипта разная,там скрипт надо переделывать почти полностью

Изменено 28 ноября, 2012 пользователем Absent

iPerfect · 28 ноября, 2012

А скрипт с пв,я так понимаю?

У них структура написания скрипта разная,там скрипт надо переделывать почти полностью

я даже хз, я в Инете нашел, там написано не было)

Absent · 28 ноября, 2012

я даже хз, я в Инете нашел, там написано не было)

Скрипт от pw сборки,я точно уверен)

Даже если поменяешь импорты все равно не поможет,хотя попробуй поменять

Изменено 28 ноября, 2012 пользователем Absent

iPerfect · 28 ноября, 2012

Скрипт от pw сборки,я точно уверен)

Даже если поменяешь импорты все равно не поможет,хотя попробуй поменять

Так с имортами вроде все нормуль

Absent · 28 ноября, 2012

Так с имортами вроде все нормуль

Ну да,не посмотрел.

Ну значит я прав что у них разные структуры написания)

iPerfect · 28 ноября, 2012

Ну да,не посмотрел.

Ну значит я прав что у них разные структуры написания)

Печалько(

ZooTee · 28 ноября, 2012

Печалько(

Вот попробуйте этот - http://rghost.ru/41872572

enermax7864 · 28 ноября, 2012

Макс почему тебя в аське нету?

У меня еще 1 вопрос есть)

iPerfect · 28 ноября, 2012

Вот попробуйте этот - http://rghost.ru/41872572

Ошибка(((

Traceback (innermost last):

(no code object) at line 0

SyntaxError: ('invalid syntax', ('__init__.py', 2, 2, ' import sys'))

ZooTee · 28 ноября, 2012

Ошибка(((

Traceback (innermost last):

(no code object) at line 0

SyntaxError: ('invalid syntax', ('__init__.py', 2, 2, ' import sys'))

Попробуйте с этими импортами

from javolution.text import TextBuilder
from net.sf.l2j import L2DatabaseFactory
from net.sf.l2j.gameserver.datatables import AugmentationData
from net.sf.l2j.gameserver.datatables import ItemTable
from net.sf.l2j.gameserver.datatables import SkillTable
from net.sf.l2j.gameserver.model import L2Augmentation
from net.sf.l2j.gameserver.model import L2ItemInstance
from net.sf.l2j.gameserver.model import L2Skill
from net.sf.l2j.gameserver.model import L2World
from net.sf.l2j.gameserver.model.quest import State
from net.sf.l2j.gameserver.model.quest import QuestState
from net.sf.l2j.gameserver.model.quest.jython import QuestJython as JQuest
from net.sf.l2j.gameserver.network import SystemMessageId
from net.sf.l2j.gameserver.network.serverpackets import ExMailArrived
from net.sf.l2j.gameserver.network.serverpackets import ItemList
from net.sf.l2j.gameserver.network.serverpackets import SystemMessage
from net.sf.l2j.gameserver.templates import L2Item
from net.sf.l2j.util import Rnd
from net.sf.l2j.gameserver.util import Util
from time import gmtime, strftime

iPerfect · 28 ноября, 2012

Попробуйте с этими импортами

from javolution.text import TextBuilder
from net.sf.l2j import L2DatabaseFactory
from net.sf.l2j.gameserver.datatables import AugmentationData
from net.sf.l2j.gameserver.datatables import ItemTable
from net.sf.l2j.gameserver.datatables import SkillTable
from net.sf.l2j.gameserver.model import L2Augmentation
from net.sf.l2j.gameserver.model import L2ItemInstance
from net.sf.l2j.gameserver.model import L2Skill
from net.sf.l2j.gameserver.model import L2World
from net.sf.l2j.gameserver.model.quest import State
from net.sf.l2j.gameserver.model.quest import QuestState
from net.sf.l2j.gameserver.model.quest.jython import QuestJython as JQuest
from net.sf.l2j.gameserver.network import SystemMessageId
from net.sf.l2j.gameserver.network.serverpackets import ExMailArrived
from net.sf.l2j.gameserver.network.serverpackets import ItemList
from net.sf.l2j.gameserver.network.serverpackets import SystemMessage
from net.sf.l2j.gameserver.templates import L2Item
from net.sf.l2j.util import Rnd
from net.sf.l2j.gameserver.util import Util
from time import gmtime, strftime

Такая же ошибка:

Traceback (innermost last):

(no code object) at line 0

SyntaxError: ('invalid syntax', ('__init__.py', 2, 2, ' import sys'))

ZooTee · 28 ноября, 2012

Такая же ошибка:

Traceback (innermost last):

(no code object) at line 0

SyntaxError: ('invalid syntax', ('__init__.py', 2, 2, ' import sys'))

Не может быть эта же ошибка, т.к. импорт import sys я убрал, вы точно обновили импорты свои на мои ?

Войти

Ошибка Квеста

Рекомендуемые сообщения

iPerfect 381

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

NewTrend 159

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

iPerfect 381

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

NewTrend 159

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

Absent 263

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

Absent 263

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

iPerfect 381

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

Absent 263

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

iPerfect 381

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

Absent 263

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

iPerfect 381

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

Absent 263

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

iPerfect 381

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

Absent 263

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

iPerfect 381

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

Absent 263

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

iPerfect 381

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

Absent 263

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

iPerfect 381

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

ZooTee 29