speedprog / eve-inc-waitlist Goto Github PK

Add information about setting up stattool_config.js before updating database to the installation instructions.

this is with the tag v1.0.2 code, as i recall it was the same in the main code to.

==> /var/log/pywaitlist/info.log <==
return self.view_functionsrule.endpoint
File "/usr/local/lib/python3.6/site-packages/flask_login/utils.py", line 228, in decorated_view
return func(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/flask_principal.py", line 199, in _decorated
rv = f(*args, **kw)
File "/var/www/waitlist/waitlist/blueprints/settings/staticdataimport.py", line 41, in update_type_ids
f.save(dest_name)
File "/usr/local/lib/python3.6/site-packages/werkzeug/datastructures.py", line 2703, in save
dst = open(dst, 'wb')
FileNotFoundError: [Errno 2] No such file or directory: './sde/typeIDs.yaml.bz2'

just have to make the folder and then it works.

Implement Confirmation Dialog for calendar event if the added event date/time is in the past
Make the dialog client side? (can be an option since it is not security related)

Should add an UI to map waitlist roles to murmur groups, instead of making it only changeable by editing a mapping object in the sourcecode

2017-09-20 22:11:17,142 - waitlist - ERROR - /usr/local/lib/python3.6/site-packages/flask/app.py - log_exception - 1560 - Exception on /settings/sde/sde/update/typeids [POST]
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
context)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 250, in execute
self.errorhandler(self, exc, value)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
raise errorvalue
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 247, in execute
res = self._query(query)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 411, in _query
rowcount = self._do_query(q)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 374, in _do_query
db.query(q)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 277, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1366, "Incorrect string value: '\xE6\xB3\xB0\xE5\x9D\xA6...' for column 'typeName' at row 1")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1982, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1614, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1517, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python3.6/site-packages/flask/_compat.py", line 33, in reraise
raise value
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1612, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1598, in dispatch_request
return self.view_functionsrule.endpoint
File "/usr/local/lib/python3.6/site-packages/flask_login/utils.py", line 228, in decorated_view
return func(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/flask_principal.py", line 199, in _decorated
rv = f(*args, **kw)
File "/var/www/waitlist/waitlist/blueprints/settings/staticdataimport.py", line 43, in update_type_ids
sde.update_invtypes(dest_name)
File "/var/www/waitlist/waitlist/utility/sde.py", line 76, in update_invtypes
db.session.merge(inv_type)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/scoping.py", line 157, in do
return getattr(self.registry(), name)(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 1839, in merge
self._autoflush()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 1407, in _autoflush
util.raise_from_cause(e)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 187, in reraise
raise value
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 1397, in _autoflush
self.flush()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2177, in flush
self._flush(objects)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2297, in _flush
transaction.rollback(_capture_exception=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 66, in exit
compat.reraise(exc_type, exc_value, exc_tb)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 187, in reraise
raise value
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2261, in _flush
flush_context.execute()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 389, in execute
rec.execute(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 548, in execute
uow
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 181, in save_obj
mapper, table, insert)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 799, in _emit_insert_statements
execute(statement, multiparams)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 945, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context
context)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1402, in _handle_dbapi_exception
exc_info
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
context)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 250, in execute
self.errorhandler(self, exc, value)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
raise errorvalue
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 247, in execute
res = self._query(query)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 411, in _query
rowcount = self._do_query(q)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/cursors.py", line 374, in _do_query
db.query(q)
File "/usr/local/lib/python3.6/site-packages/MySQLdb/connections.py", line 277, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (_mysql_exceptions.OperationalError) (1366, "Incorrect string value: '\xE6\xB3\xB0\xE5\x9D\xA6...' for column 'typeName' at row 1") [SQL: 'INSERT INTO invtypes (typeID, groupID, typeName, description, marketGroupID) VALUES (%s, %s, %s, %s, %s)'] [parameters: (33857, 310, '泰坦会战遗址', '这里到处充斥着巨大舰船的残骸，无声地诉说着YC116年3月25-26日在这里爆发的那场宏大战役。 \r\n\r\n两个阵营的飞行员和他们的舰队群在这里用几千艘战舰谱写了一首壮烈的战争史诗，成就了一场史无前例的大决战。在征求了各大帝国的意见后，统合部决定留下几条战舰残骸在这里，以供后来者瞻仰唏嘘。表面上看这是对克隆飞行员的警告，提醒他们冲动是魔鬼，不过，如果你熟悉那些拥有不死之身的舰长们，你自然明白，这只会激励他们为战斗与毁灭的事业奉献终身。', None)]

Add some basic info on how to use behind proxy

i'm working on setting up a waitlist for my alliance and have the server up and running. what is the URI that i should send the call back to?

i'm trying the root of the app,
==> info.log <==
2017-09-19 23:47:54,141 - waitlist.utility.flask - INFO - /var/www/waitlist/waitlist/utility/flask/init.py - on_identity_loaded - 64 - loading identity for <flask_login.mixins.AnonymousUserMixin object at 0x7f56f142dbe0>

==> debug.log <==
2017-09-19 23:47:54,141 - waitlist.utility.flask - INFO - /var/www/waitlist/waitlist/utility/flask/init.py - on_identity_loaded - 64 - loading identity for <flask_login.mixins.AnonymousUserMixin object at 0x7f56f142dbe0>

==> access.log <==
2017-09-19 23:47:54,152 - gevent.pywsgi.WSGIServer - INFO - /usr/local/lib/python3.6/site-packages/gevent/pywsgi.py - write - 1146 - 127.0.0.1 - - [2017-09-19 23:47:54] "GET /?code={my info looking good} HTTP/1.0" 302 1441 0.012472

i'm useing nginx infront of it with a proxy rewrite

location /waitlist/ {
  proxy_pass              http://127.0.0.1:81/;
  proxy_read_timeout      90;
  proxy_redirect          http://127.0.0.1:81/ http://$host/waitlist/;
  proxy_set_header        Host $host;
  proxy_set_header        X-Forwarded-For $proxy_add_x_forwarded_for;
  proxy_set_header        X-Real-IP $remote_addr;
  proxy_set_header        X-Forwarded-Proto $scheme;
}

but after hitting CCP SSO page it dose not return to the waitlist.

This is an idea, not an issue. It would make it more clear for FC's who's multiboxing and how many alts we have in fleet. It would making it easier to just remove one or two alts if there are many in fleet and we just need one more slot for example. Would also allow fc's to keep alts for example in waitlist during the time they are not needed. Would allow for quick mom fleet forms also witouth another fleet noticing.

To the point:

• ADD a checkmark button right under or above teamspeak poke that says something in the lines of ''Dualboxing alt''
  This button will do two things: add a ''ALT'' badge same style like the blue new badge or role badges.
  When being in the waitlist they will still be added to the corresponding in waitlist squad DPS / SNIPER. When being invited instead of being invited in the corresponding squad DPS or SNIPER they will be added to More DPS (which the waitlist already supports).

Maybe little extra, don't know how hard this one would be: make them always appear last in the waitlist order.

IT please, trying to change the WL title from HQ to Vanguard gives Internal Server error... everything else seems to be working...

Did you try a work around like VG fleet?

Was manually writing "Vanguard", exact same as the 3rd fleet down

Hmm odd, one would think if it works as a drop down it should work.
Just in case anyone is confused, council has a text box for fleet status not a drop down.

yeah, I'd always wondered how you guys put weird stuff in the Running/forming/down section untill I got officer :leichtes_lächeln:

;)
You should be able to write anything in there

Add a config option to disable the scruffy code

There should be some information about gong sound in the readme

i have,
characterLocationRead
characterNavigationWrite
characterSkillsRead
characterClonesRead
but i'm thinking i'll need to add some more.