Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import mysql.connector
- config_cv = {
- 'user': 'cs_stats',
- 'password': 'toor',
- 'host': '10.1.3.88',
- 'port': '21212',
- 'database': 'adrushstat'
- }
- full_stat = {
- 'STEAM_1:0:83485281': ['STEAM_1:0:83485281', 0, 0, 0, 0, 'Qikert', 'Golubev Alexey', 'Qikert_front.png', 'Qikert_left.png', 'Qikert_right.png', 'KZ.jpg', 'AVANGARPVP.png', 'AVANGARPP.png', 0, 0],
- 'STEAM_1:1:106468097': ['STEAM_1:1:106468097', 0, 0, 0, 0, 'buster', 'Tulepov Timur', 'buster_front.png', 'buster_left.png', 'buster_right.png', 'KZ.jpg', 'AVANGARPVP.png', 'AVANGARPP.png', 0, 0],
- 'STEAM_1:1:53836085': ['STEAM_1:1:53836085', 0, 0, 0, 0, 'KrizzeN', 'Turlybekov Aidyn', 'KrizzeN_front.png', 'KrizzeN_left.png', 'KrizzeN_right.png', 'KZ.jpg', 'AVANGARPVP.png', 'AVANGARPP.png', 0, 0],
- 'STEAM_1:0:412634': ['STEAM_1:0:412634', 0, 0, 0, 0, 'dimasick', 'Matviyenko Dmitriy', 'dimasick_front.png', 'dimasick_left.png', 'dimasick_right.png', 'KZ.jpg', 'AVANGARPVP.png', 'AVANGARPP.png', 0, 0],
- 'STEAM_1:0:37929928': ['STEAM_1:0:37929928', 0, 0, 0, 0, 'Jame', 'Ali Dzhami', 'Jame_front.png', 'Jame_left.png', 'Jame_right.png', 'KZ.jpg', 'AVANGARPVP.png', 'AVANGARPP.png', 0, 0],
- 'STEAM_1:0:1824214': ['STEAM_1:0:1824214', 0, 0, 0, 0, 'seized', 'Denis Kostin', 'seized_front.png', 'seized_left.png', 'seized_right.png', 'RU.jpg', 'GMBPVP.png', 'GMBPP.png', 0, 0],
- 'STEAM_0:1:23100489': ['STEAM_0:1:23100489', 0, 0, 0, 0, 'AdreN', 'Dauren Kystaubayev', 'AdreN_front.png', 'AdreN_left.png', 'AdreN_right.png', 'KZ.jpg', 'GMBPVP.png', 'GMBPP.png', 0, 0],
- 'STEAM_0:1:26339383': ['STEAM_0:1:26339383', 0, 0, 0, 0, 'mou', 'Rustem Telepov', 'mou_front.png', 'mou_left.png', 'mou_right.png', 'KZ.jpg', 'GMBPVP.png', 'GMBPP.png', 0, 0],
- 'STEAM_0:0:34013515': ['STEAM_0:0:34013515', 0, 0, 0, 0, 'Hobbit', 'Abay Khassenov', 'Hobbit_front.png', 'Hobbit_left.png', 'Hobbit_right.png', 'KZ.jpg', 'GMBPVP.png', 'GMBPP.png', 0, 0],
- 'STEAM_0:0:73320765': ['STEAM_0:0:73320765', 0, 0, 0, 0, 'Dosia', 'Mikhail Stolyarov', 'Dosia_front.png', 'Dosia_left.png', 'Dosia_right.png', 'RU.jpg', 'GMBPVP.png', 'GMBPP.png', 0, 0],
- 'STEAM_1:1:212233': ['STEAM_1:1:212233', 0, 0, 0, 0, 'FalleN', 'Gabriel Toledo de Alcantara Sguario', 'FalleN _front.png', 'FalleN _left.png', 'FalleN _right.png', 'BR.jpg', 'SKPVP.png', 'SKPP.png', 0, 0],
- 'STEAM_1:1:39860435': ['STEAM_1:1:39860435', 0, 0, 0, 0, 'coldzera', 'Marcelo Augusto David', 'coldzera_front.png', 'coldzera_left.png', 'coldzera_right.png', 'BR.jpg', 'SKPVP.png', 'SKPP.png', 0, 0],
- 'STEAM_1:0:19369141': ['STEAM_1:0:19369141', 0, 0, 0, 0, 'Stewie2K', 'Jacky Yip', 'Stewie2K_front.png', 'Stewie2K_left.png', 'Stewie2K_right.png', 'USA.jpg', 'SKPVP.png', 'SKPP.png', 0, 0],
- 'STEAM_1:1:19460609': ['STEAM_1:1:19460609', 0, 0, 0, 0, 'fer', 'Fernando Alvarenga Ferreira da Costa', 'fer_front.png', 'fer_left.png', 'fer_right.png', 'BR.jpg', 'SKPVP.png', 'SKPP.png', 0, 0],
- 'STEAM_1:0:29056836': ['STEAM_1:0:29056836', 0, 0, 0, 0, 'boltz', 'Ricardo de Souza Prass', 'boltz_front.png', 'boltz_left.png', 'boltz_right.png', 'BR.jpg', 'SKPVP.png', 'SKPP.png', 0, 0],
- 'STEAM_1:1:10937922': ['STEAM_1:1:10937922', 0, 0, 0, 0, 'Snax', 'Janusz Pogorzelski', 'Snax_front.png', 'Snax_left.png', 'Snax_right.png', 'PL.jpg', 'VPPVP.png', 'VPPP.png', 0, 0],
- 'STEAM_1:0:230103': ['STEAM_1:0:230103', 0, 0, 0, 0, 'NEO', 'Filip Kubski', 'NEO_front.png', 'NEO_left.png', 'NEO_right.png', 'PL.jpg', 'VPPVP.png', 'VPPP.png', 0, 0],
- 'STEAM_1:0:6790045': ['STEAM_1:0:6790045', 0, 0, 0, 0, 'pashaBiceps', 'Jarosław Jarząbkowski', 'pashaBiceps_front.png', 'pashaBiceps_left.png', 'pashaBiceps_right.png', 'PL.jpg', 'VPPVP.png', 'VPPP.png', 0, 0],
- 'STEAM_1:0:9430177': ['STEAM_1:0:9430177', 0, 0, 0, 0, 'byali', 'Paweł Bieliński', '_front.png', 'byali_left.png', 'byali_right.png', 'PL.jpg', 'VPPVP.png', 'VPPP.png', 0, 0],
- 'STEAM_1:1:30179537': ['STEAM_1:1:30179537', 0, 0, 0, 0, 'MICHU', 'Michał Müller', 'MICHU_front.png', 'MICHU_left.png', 'MICHU_right.png', 'PL.jpg', 'VPPVP.png', 'VPPP.png', 0, 0],
- }
- data_payload = [
- (0, 'STEAM_1:0:83485281', 1, 0, 0, 0),
- (0, 'STEAM_1:1:106468097', 0, 1, 0, 0),
- (0, 'STEAM_1:1:53836085', 1, 0, 0, 0),
- (0, 'STEAM_1:0:412634', 1, 0, 0, 0),
- (0, 'STEAM_1:0:37929928', 0, 1, 0, 0),
- (0, 'STEAM_1:0:1824214', 1, 0, 0, 0),
- (0, 'STEAM_0:1:23100489', 0, 1, 0, 0),
- (0, 'STEAM_0:1:26339383', 1, 0, 0, 0),
- (0, 'STEAM_0:0:34013515', 0, 1, 0, 0),
- (0, 'STEAM_0:0:73320765', 1, 0, 0, 0),
- (0, 'STEAM_1:1:212233', 0, 1, 0, 0),
- (0, 'STEAM_1:1:39860435', 1, 0, 0, 0),
- (0, 'STEAM_1:0:19369141', 0, 1, 0, 0),
- (0, 'STEAM_1:1:19460609', 1, 0, 0, 0),
- (0, 'STEAM_1:0:29056836', 0, 1, 0, 0),
- (0, 'STEAM_1:1:10937922', 1, 0, 1, 1),
- (0, 'STEAM_1:0:230103', 1, 0, 1, 0),
- (0, 'STEAM_1:0:6790045', 1, 0, 0, 0),
- (0, 'STEAM_1:0:9430177', 1, 0, 0, 0),
- (0, 'STEAM_1:1:30179537', 1, 0, 0, 1)
- ]
- def write_to_global(data_tuple):
- data_item = list(data_tuple)
- steam_id = data_item[1]
- player = full_stat[steam_id]
- for i in range(1, 5):
- player[i] += data_item[i+1]
- try:
- hs_ratio = player[1]/player[4]
- except ZeroDivisionError:
- hs_ratio = 0
- hs_ratio = round(hs_ratio, 1)
- try:
- kd_ratio = player[1]/player[3]
- except ZeroDivisionError:
- kd_ratio = 0
- kd_ratio = round(kd_ratio, 1)
- player[-2] = hs_ratio
- player[-1] = kd_ratio
- full_stat[steam_id] = player
- dbcv = mysql.connector.connect(**config_cv)
- cvcursor = dbcv.cursor()
- cvcursor.execute("TRUNCATE TABLE adrushfullstat")
- cv_full_override = (
- "INSERT into adrushfullstat (steam_id, nb_kill, assist, death, hs, nickname, name, photo_front, photo_left, photo_right, flag, logo1, logo2, hs_percent) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s) "
- )
- for items in data_payload:
- write_to_global(items)
- for item in full_stat:
- cvcursor.execute(cv_full_override, item)
- dbcv.commit()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement