resources.py

import sqlite3
import pygame
import numpy as np
import sys
import os

FNAME = 'Mutation Purge BETA'
GNAME = 'Setesalém: Mutation Purge BETA'
AUTHOR = 'Matt Kai'
DESCRIPTION = 'Setesalém: Mutation Purge BETA (2021)'
VERSION = '0.1.0'
YEAR = '2021'
MAINLANG = 'PT'
SPLASH = None
ICON = 'icon.ico'
DEBUG = True
GSCALE = 2 #game ratio ÷ window ratio
INTERPOLATE = 'bilinear'
FULLSCREEN = 0
FPS = 60

BACKG_PATH = 'backgrounds/'
SPRITES_PATH = 'sprites/'
CHARS_PATH = 'sprites/characters/'
TEMP_PATH = 'sprites/templates/'
ITEMS_PATH = 'sprites/items/it_'
FREAKS_PATH = 'sprites/freaks/frk_'
SFX_PATH = 'sfx/'
MUSIC_PATH = 'music/'
MAPS_PATH = 'maps/'
TILES_PATH = 'tiles/'
TILESETS_PATH = 'tiles/files/'
FONTS_PATH = 'fonts/'

SPRITES = {}
SOUND = {}
RADIO = {
0: ['Astronomy Domine','Pow .R Toc .H','Take Up Thy Stethoscope And Walk','Bike'],
1: ['Adeus Maria Fulô','A Day in the Life','Ouro de Tolo','mr_kite'],
2: ['Dreamcast','Infinite Login','my_pain','cattle_king'],
3: ['Polythene Pam','Save Me','from_russia_with_love'],
4: ['Duplo Andantes','hey_sam','urban_plague','wacky_ways'],
5: ['Sombra ou Dúvida','Elogio á Intuição do Cinismo','Give it Away'],
6: ['Discipline','Elephant Talk','she_left_me','mayanman']
}
FONTS = {}
MIXER = []

PALETTES = [
#SKIN COLOR
[(63,37,0),(153,92,58),(206,138,78),(226,157,97),(234,161,100),(234,154,107),(235,185,139),(247,202,163),(255,215,168),(255,231,204)],
#HAIR COLOR
[(76,39,17),(114,65,32),(165,95,48),(255,191,0),(119,7,0),(255,255,255),(63,255,0),(84,39,0),(255,144,0)],
#SHIRT COLOR
[(200,10,10),(200,100,10),(200,200,10),(10,200,10),(10,200,100),(10,10,200),(200,10,200)]
]
RANGE_BUMP = 27
RANGE_HAIR = 8
RANGE_FACE = 6
RANGE_COSTUME = 2
RANGE_SKIN = len(PALETTES[0])
RANGE_RADIO = 7
RANGE_BORDER = 7
RANGE_CURSOR = 6

FILES = []
ID = 0
LANG = 'PT'
GAMETIME = 0
CHAPTER = 1
MAP = None
PLAYER = [200,300]
PX = 200
PY = 100
SIGNAL = 3
TIME = [14,30,0] #hour-minute-second
DATE = [25,12,2007,1,1] #day-month-year-week-moon
CALENDAR = []
ss = 6
for y in range(10):
	CALENDAR.append([])
	for m in range(12):
		CALENDAR[y].append([])
		if m == 1:
			if (y + 2005)%4 == 0: dd = 29
			else: dd = 28
		elif m < 6:
			if m%2 == 0: dd = 31
			else: dd = 30
		else:
			if m%2 == 0: dd = 30
			else: dd = 31
		for d in range(dd):
			CALENDAR[y][m].append(ss)
			ss += 1
			if ss >= 7: ss = 0
TEMPERATURE = 25
WEATHER = 0

PAUSE = 0
CLICK = ['shoot','swap','shoot']
ACTION = ['walk','walk','walk','walk','shoot_unidirectional','swap','upgrade','pause','shortcut']
COMBINATIONS = [(4,5,'bomb')]
SEQUENCES = [(0,0,1,1,2,3,2,3,4,5,6,"res.CHARACTERS[0]['ENERGY'] = 100"),(1,2,0,3,1,2,0,3,1,2,0,3,"res.CHARACTERS[0]['BONUS'][2] = 10")]
EQUIP = [2,4,0]
SHORTCUT = [1,0,1]
CONTROLS = [[pygame.K_w,pygame.K_s,pygame.K_a,pygame.K_d,pygame.K_g,pygame.K_h,pygame.K_RETURN,pygame.K_BACKSPACE,pygame.K_INSERT],
	[pygame.K_UP,pygame.K_DOWN,pygame.K_LEFT,pygame.K_RIGHT,pygame.K_KP0,pygame.K_KP_ENTER,pygame.K_KP_MULTIPLY,pygame.K_KP_MINUS,pygame.K_KP_MINUS],
	[pygame.K_w,pygame.K_s,pygame.K_a,pygame.K_d,pygame.K_g,pygame.K_h,pygame.K_RETURN,pygame.K_BACKSPACE,pygame.K_INSERT],
	[pygame.K_UP,pygame.K_DOWN,pygame.K_LEFT,pygame.K_RIGHT,pygame.K_KP0,pygame.K_KP_ENTER,pygame.K_KP_MULTIPLY,pygame.K_KP_MINUS,pygame.K_KP_MINUS]]
'''
CONTROLS = [{
	'walk_up': pygame.K_w,
	'walk_down': pygame.K_s,
	'walk_left': pygame.K_a,
	'walk_right': pygame.K_d,
	'shoot_unidirectional': pygame.K_g,
	'shoot_directional': None,
	'shoot_mouse': None,
	'swap': pygame.K_h,
	'upgrade': pygame.K_RETURN,
	'pause': pygame.K_BACKSPACE,
	'shortcut': pygame.K_INSERT,
	'camera': None,
	'move': None,
	'turn_left': None,
	'turn_right': None,
	'look': None,
	'squat': None,
	'jump': None,
	'run': None,
	'bomb': None,
	'equip': None,
	'chat': None,
	'screenshot': None,
	'record': None,
}
]
'''
JOYSTICK = [0,1,2,3,4,5,6,7,None,None,None,8,None,6,7,0,1,2,3,0,1,None,None]
COMBO = []

#SETTINGS
SETTRIBUTES = ['MOUSE','VIBRATE','SFX','MSC','MUTE','DTYPE','SPEED','COLOR','CAMACC','BORDER','CENSORSHIP',
	'HELP','HINT','CURSOR','TMNU','CC','DISLEXIC','BTYPE','AUTOSAVE','AUTOBATTLE','QUICKSTART']
MOUSE = 1 #keyboard only/keyboard and mouse/touchpad/joystick
VIBRATE = False #vibrate controlller
SFX = 0.0
MSC = 0.0
MUTE = 1 #mute when game is minimized
DTYPE = 1 #type of dialog
SPEED = 2 #dialog speed
COLOR = (255,10,10) #UI color
CAMACC = 10 #player camera acceleration
BORDER = 0 #UI border
CENSORSHIP = 2 #censor mature content
HELP = True #tutorials and hints along the game
HINT = False #display instructions on bottom of screen
CURSOR = 0 #custom cursor
TMNU = False #option to start on title screen or jump right into the first file
TTS = False #text-to-speech
CC = False #close caption
DISLEXIC = False #spaced font
BTYPE = 3 #1=turns,2=dynamic,3=action
AUTOSAVE = 10#in minutes
AUTOBATTLE = False
QUICKSTART = 4 #start from logos/start from title menu/start from files menu/start from chapters menu/start from last save/start from last session

HOVERTEXT = None
HINTEXT = None

PARTY = [[0,1]]
FORMATION = 0
CALLHIST = []
CONTACTS = []
INBOX = []
TASKS = [['CH10',2]]
TACTICAL = [['1.0','1.1'],['2.0'],[],[],[],[]]
BESTIARY = {'4.1.1': {'ID': '1','DATE': (3,3,2007),'SEEN': 2},'2.1.1': {'ID': '2','DATE': (3,3,2007),'SEEN': 2}}
INVENTORY = []
for u in range(6):
	INVENTORY.append([])
	for y in range(5):
		INVENTORY[u].append([])
		for x in range(5):
			INVENTORY[u][y].append(['_','0000'])
INVENTORY[0] = [
	[['_','0'],['phone','3600','simcard1','0003'],['tube100','0050'],['wallet','0100','creditcard1','0100','id_card1','0000'],['food_pizza_chicken','9999']],
	[['clth_shirt1','7'],['_','0000'],['_','0000'],['_','0000'],['food_pizza_4cheese','0000']],
	[['head_glasses1','0000'],['_','0'],['_','0000'],['_','0000'],['_','0000']],
	[['head_hairclip','0000'],['_','0000'],['_','0000'],['_','0000'],['_','0000']],
	[['bag1','0000'],['reactor2','5'],['reactor3','1'],['cigar','0000'],['tool_lighter1','0000']]
	]
STORAGE = [['amulet2','0000'],['amulet3','0000'],['_','0000'],['_','0000'],['_','0000']]
PRODUCTS = []
for i in range(25): PRODUCTS.append(['_',1])
BASKET = []
for i in range(25): BASKET.append(['_','0000'])
CHAT = ['@kaixtr: batatinha','@kanbz: quando nasce','@kaixtr: se esparrama','@kanbz: pelo chão.',
'@kaixtr: meninha','@kanbz: quando dorme','@kaixtr: põe a mão','@kanbz: no coração.']
RANK = []

CHATTRIBUTES = [['VITALITY','HEALTH','EXPERIENCE','LEVEL','SANITY','HUNGER','THIRST','SLEEP','BONUS'],
	['ENERGY','SCORE','BLESS','MORALITY','INSPIRATION','INTIMIDATION','PERSUASION','ANIMALS','SPIRITS','STAMINA','ATLETISM',
	'ACROBATICS','FURTIVITY','PERCEPTION','MEDICINE','IMUNITY','INFANTRY','INVESTIGATION','CRAFTING','CULINARY','KILLS','DEATHS']]

CHARACTERS = [
{'NAME': 'Sidney','LASTNAME': 'Barreto','NICK': 'Sid','PRONOUN': 'he','BIRTH': (3,3,1985),'HOMETOWN': 'ITATIAIA/RJ','BLOOD': 'A+','CLASS': 'mercenary','SUBCLASS': 'gunslinger',
'HAIR': [0,1,0],'SKIN': 5,'FAVFOOD': ['food_coxinha','drink_whisky'],'IDEOLOGY': 'atheist','FEAR': 'psychic','FLAW': 'alcoholic'},
  
{'NAME': 'Jane', 'LASTNAME': 'Oliveira','NICK': None,'PRONOUN': 'she','BIRTH': (3,3,1985),'HOMETOWN': 'VOLTA REDONDA/RJ','BLOOD': 'O-','CLASS': 'medium','SUBCLASS': 'necromancer',
'HAIR': [0,2,0],'SKIN': 4,'FAVFOOD': ['food_chesse_bread','food_coffee'],'IDEOLOGY': 'spiritist','FEAR': 'reptile','FLAW': 'myopia'},
  
{'NAME': 'Renan', 'LASTNAME': 'Pinheiro','NICK': None,'PRONOUN': 'he','BIRTH': (3,3,1985),'HOMETOWN': 'NILÓPOLIS/RJ','BLOOD': 'A-','CLASS': 'thief','SUBCLASS': 'smartass',
'HAIR': [0,3,7],'SKIN': 6,'FAVFOOD': ['food_cola','food_cake_carrot'],'IDEOLOGY': 'baptist evangelic','FEAR': 'mammal','FLAW': 'asthma'},
 
{'NAME': 'Diego', 'LASTNAME': 'Donovan','NICK': None,'PRONOUN': 'he','BIRTH': (3,3,1985),'HOMETOWN': 'CAMPOS DO JORDÃO/SP','BLOOD': 'A-','CLASS': 'hunter','SUBCLASS': 'researcher',
'HAIR': [0,4,1],'SKIN': 8,'FAVFOOD': ['food_burguer','food_cola'],'IDEOLOGY': 'scientologist','FEAR': 'plant','FLAW': 'lactose intolerant'},
  
{'NAME': 'Bianca', 'LASTNAME': 'Pacheco','NICK': 'Bia','PRONOUN': 'she','BIRTH': (3,3,1985),'HOMETOWN': 'BELO HORIZONTE/MG','BLOOD': 'O+','CLASS': 'scientist','SUBCLASS': 'healer',
'HAIR': [0,5,0],'SKIN': 9,'FAVFOOD': ['food_sushi','food_juice_orange'],'IDEOLOGY': 'agnostic','FEAR': 'spirit','FLAW': 'celiac'},
 
{'NAME': 'Lúcia', 'LASTNAME': 'Figueiredo','NICK': 'Lúci','PRONOUN': 'she','BIRTH': (3,3,1985),'HOMETOWN': 'NITERÓI/RJ','BLOOD': 'O+','CLASS': 'watchman','SUBCLASS': 'detective',
'HAIR': [0,6,0],'SKIN': 1,'FAVFOOD': ['food_juice_orange','food_fish'],'IDEOLOGY': 'pentecostal evangelic','FEAR': 'inorganic','FLAW': 'cigarette addict'},
]
'''
{'NAME': 'Maicon', 'LASTNAME': 'Neves','NICK': None,'PRONOUN': 'he','BIRTH': (3,3,1985),'ID': '0013','BLOOD': 'O+','CLASS': 'hunter','SUBCLASS': 'warrior',
'HAIR': [0,1,0],'SKIN': '0','FAVFOOD': ['food_juice_orange','food_fish'],'IDEOLOGY': 'baptist evangelic','FEAR': 'psychic','FLAW': 'alcoholic'},

{'NAME': 'Iago', 'LASTNAME': 'Dantas','NICK': None,'PRONOUN': 'he','BIRTH': (3,3,1985),'ID': '0013','BLOOD': 'O+','CLASS': 'nomad','SUBCLASS': 'traveler',
'HAIR': [0,14,0],'SKIN': '0','FAVFOOD': ['food_juice_orange','food_fish'],'IDEOLOGY': 'atheist','FEAR': 'psychic','FLAW': 'alcoholic'},

{'NAME': 'Vinicíus', 'LASTNAME': 'Tavares','NICK': 'Vini','PRONOUN': 'he','BIRTH': (3,3,1985),'ID': '0013','BLOOD': 'O+','CLASS': 'mercenary','SUBCLASS': 'barbarian',
'HAIR': [0,3,0],'SKIN': '0','FAVFOOD': ['food_juice_orange','food_fish'],'IDEOLOGY': 'non religious','FEAR': 'psychic','FLAW': 'alcoholic'},

{'NAME': 'João', 'LASTNAME': 'Pedro Lima','NICK': 'João Grande','PRONOUN': 'he','BIRTH': (3,3,1985),'ID': '0013','BLOOD': 'O+','CLASS': 'watchman','SUBCLASS': 'forensic',
'HAIR': [0,3,0],'SKIN': '0','FAVFOOD': ['food_juice_orange','food_fish'],'IDEOLOGY': 'atheist','FEAR': 'psychic','FLAW': 'alcoholic'},

{'NAME': 'Sofia', 'LASTNAME': 'Torres','NICK': None,'PRONOUN': 'she','BIRTH': (3,3,1985),'ID': '0013','BLOOD': 'O+','CLASS': 'scientist','SUBCLASS': 'healer',
'HAIR': [0,12,0],'SKIN': '0','FAVFOOD': ['food_juice_orange','food_fish'],'IDEOLOGY': 'atheist','FEAR': 'psychic','FLAW': 'alcoholic'},

{'NAME': 'Paulo', 'LASTNAME': 'Sousa','NICK': None,'PRONOUN': 'he','BIRTH': (3,3,1985),'ID': '0013','BLOOD': 'O+','CLASS': 'watchman','SUBCLASS': 'shooter',
'HAIR': [0,0,6],'SKIN': '0','FAVFOOD': ['food_juice_orange','food_fish'],'IDEOLOGY': 'apostolic catholic','FEAR': 'psychic','FLAW': 'alcoholic'},

{'NAME': 'Pietra', 'LASTNAME': 'Amaral','NICK': None,'PRONOUN': 'she','BIRTH': (3,3,1985),'ID': '0013','BLOOD': 'O+','CLASS': 'thief','SUBCLASS': 'assassin',
'HAIR': [0,8,0],'SKIN': '0','FAVFOOD': ['food_juice_orange','food_fish'],'IDEOLOGY': 'baptist evangelic','FEAR': 'psychic','FLAW': 'alcoholic'},

{'NAME': 'Hermes', 'LASTNAME': 'Fonseca','NICK': None,'PRONOUN': 'he','BIRTH': (3,3,1985),'ID': '0013','BLOOD': 'O+','CLASS': 'alchemist','SUBCLASS': 'sorcerer',
'HAIR': [0,13,0],'SKIN': '0','FAVFOOD': ['food_juice_orange','food_fish'],'IDEOLOGY': 'alchemy','FEAR': 'psychic','FLAW': 'alcoholic'},

{'NAME': 'Dalibor', 'LASTNAME': 'Marković','NICK': 'Sr.Dalibor','PRONOUN': 'he','BIRTH': (3,3,1985),'ID': '0013','BLOOD': 'O+','CLASS': 'watchman','SUBCLASS': 'detective',
'HAIR': [0,13,0],'SKIN': '0','FAVFOOD': ['food_juice_orange','food_fish'],'IDEOLOGY': 'ortodox catholic','FEAR': 'psychic','FLAW': 'alcoholic'}
]
'''
for i in range(len(CHARACTERS)):
	CHARACTERS[i]['BONUS'] = [0,0,0,0,0]
	CHARACTERS[i]['HUNGER'] = 1000
	CHARACTERS[i]['THIRST'] = 1000
	CHARACTERS[i]['SLEEP'] = 1000
	CHARACTERS[i]['SANITY'] = 100
	CHARACTERS[i]['RACE'] = 'human'
	CHARACTERS[i]['VITALITY'] = 0
	CHARACTERS[i]['EXPERIENCE'] = 50
	CHARACTERS[i]['LEVEL'] = 1
	CHARACTERS[i]['HEALTH'] = []
	for j in CHATTRIBUTES[1]: CHARACTERS[i][j] = 0
CHARACTERS[0]['VITALITY'] = 100
CHARACTERS[0]['SCORE'] = 1240
CHARACTERS[0]['ENERGY'] = 120

RELATIONS = []
for i in range(15):
	RELATIONS.append([])
	for j in range(15):
		if i > j: RELATIONS[i].append(RELATIONS[j][i])
		elif i == j: RELATIONS[i].append(0)
		else: RELATIONS[i].append(0)
for i in [(0,3,70),(0,5,10),(0,6,30),(0,11,10),(0,12,60),(1,7,80),(2,8,50),(2,12,70),(3,0,80),(3,9,70),(4,10,70),(5,11,50)]:
	RELATIONS[i[0]][i[1]] = i[2]

DLGSAV = {}
DISITEMS = {}

MARKER = [['1urban_0',300,300,1],['1urban_0',200,300,0]]

def recent_data(m,opt=0):
	global FILES, ID, CHAPTER, GAMETIME, LANG, PARTY
	tbl = sqlite3.connect('userdata.db')
	com = tbl.cursor()

	#LOAD FILES
	if m == 0:
		com.execute("SELECT name FROM sqlite_master WHERE type='table' AND name='files'")
		rs = com.fetchone()
		if rs != None:
			FILES = []
			com.execute("SELECT id,name,chp,gt,lang,party FROM files")
			for i in com.fetchall(): FILES.append(i)
			for i in FILES:
				if i[1] == 0: del i
		else:
			com.execute("CREATE TABLE files (id integer,name text,chp integer,gt integer,lang text,party text)")
			com.execute("INSERT INTO files VALUES (0,'Matt',0,0,'PT','0')")
			tbl.commit()
			FILES = [[0,'Matt',0,0,'PT',[0]]]
		print(FILES)
	#UPDATE FILE
	elif m == 1:
		prt = ''
		for i in PARTY[FORMATION]:
			prt += str(i)
		com.execute("UPDATE files SET chp = {}, gt = {}, lang = '{}', party = '{}' WHERE id = {}".format(CHAPTER,GAMETIME,LANG,prt,opt))
		tbl.commit()
	com.close()
	tbl.close()

def new_data(add=0,opt=0):
	global ID, LANG, SFX, MSC, CONTROLS, SPEED, COLOR, INVENTORY, STORAGE, WASH, RANK, WEATHER, BORDER, CHARACTERS, TASKPIN, MINIMAP, SCENE, CENSORSHIP, HINT, HELP,\
	FORMATION, MAP, PX, PY, TIME, DATE, CHAPTER, GAS, GAMETIME, PARTY, CONTACTS, CALLHIST, INBOX, TASKS, TACTICAL, BESTIARY, ACHIEVEMENTS, DISITEMS, RELATIONS
 
	tbl = sqlite3.connect('userdata.db')
	com = tbl.cursor()
	
	if add == 1:
		ID = opt
		CHAPTER = 0
		GAMETIME = 0
		LANG = 'PT'
		FILES.append([ID,'Matt',CHAPTER,GAMETIME,LANG,'0'])
		com.execute(f"INSERT INTO files VALUES ({ID},'{'Matt'}',{CHAPTER},{GAMETIME},'{LANG}','0')")

		MAP = 'worldmap'

	if add > 1:
		LANG = 'PT'
		SFX = 1.5
		MSC = 0.0
		CONTROLS = [[pygame.K_w,pygame.K_s,pygame.K_a,pygame.K_d,
		pygame.K_g,pygame.K_h,pygame.K_RETURN,pygame.K_RETURN,pygame.K_BACKSPACE],
		[pygame.K_UP,pygame.K_DOWN,pygame.K_LEFT,pygame.K_RIGHT,
		pygame.K_KP0,pygame.K_KP_ENTER,pygame.K_KP_PLUS,pygame.K_KP_MULTIPLY,pygame.K_KP_MINUS],[],[]]
		MOUSE = 2
		CURSOR = 0
		SPEED = 2
		COLOR = [242,30,30]
		BORDER = 0
		FONT = 'BohemianTypewriter.ttf'
		CENSORSHIP = True
		HINT = True
		HELP = True
		DISLEXIC = False
		BTYPE = 2
		
		WEATHER = 0
		CHAPTER = 0
		SCENE = 0
		GAMETIME = 0
		FORMATION = 0
		TIME = dtb.CHAPTERS[CHAPTER][3]
		DATE = dtb.CHAPTERS[CHAPTER][2]
		MAP = dtb.CHAPTERS[CHAPTER][4][0]
		PX = dtb.CHAPTERS[CHAPTER][4][1]
		PY = dtb.CHAPTERS[CHAPTER][4][2]
		SHORTCUT = [1,1,4]
		 
		for i in range(6):
			'''CHARACTERS[i]['NAME'] = ''
			CHARACTERS[i]['LASTNAME'] = '''''
			CHARACTERS[i]['LEVEL'] = 0
			CHARACTERS[i]['XP'] = 90
			CHARACTERS[i]['BONUS'] = [3,3,3,3,3]
			CHARACTERS[i]['DEATHS'] = 0
	 
		PARTY = [[0]]
		CONTACTS = [['Maicon','923778988'],['Mercador','969696969'],['Pizza Delivery','953478809']]
		CALLHIST = []
		INBOX = []
		#TASKS = [['LVL_00_0',0]]
		TASKS = [['CH01',0]]
		TACTICAL = [[1,1,1,1]]
		for i in dtb.ITEMS.items():
			if i[0].startswith('food'):
				DISITEMS[i[0]] = 0
			if i[0].startswith('drug'):
				DISITEMS[i[0]] = 0
		BESTIARY = []
		for i in dtb.FREAKS.items(): BESTIARY.append({'N': i[0],'ID': 'xxxx','DATE': '000000','SEEN': 0})
		for i in dtb.ACHIEVEMENTS:
			i[2] = 0
			i[3] = ''

		INVENTORY = []
		for u in range(6):
			INVENTORY.append([])
			for y in range(5):
				INVENTORY[u].append([])
				for x in range(5):
					INVENTORY[u][y].append(['_','0000'])
		INVENTORY[1] = [
		[['amulet1','0000'],['phone','3600','sim_card','0003'],['tube100','0050'],['wallet','0100','creditcard1','0100','id_card1','0000'],['food_pizza_chicken','9999']],
		[['vest1','7'],['til_grass','infinite'],['til_color','infinite'],['til_metalbars','infinite'],['food_pizza_4cheese','0000']],
		[['head_glasses1','0000'],['guit_load','0'],['guit_save','0000'],['guit_undo','0000'],['guit_redo','0000']],
		[['head_hairclip','0000'],['guit_pencil','0000'],['guit_erase','0000'],['guit_dropper','0000'],['_','0000']],
		[['bag1','0000'],['bomb_regular','3'],['pow_triplebubble','3'],['cigar','0000'],['_','0000']]
		]
	 
		STORAGE = [['jewel_ruby','0000'],['drink_whiskey','1503']]
		for i in range(23): STORAGE.append(['_','0000'])
		WASH = [] #[('clth_shirt00','0000','0000')]
		RANK = []
	
	#CREATE CHARACTER TABLE
	txt = ''
	for i in CHATTRIBUTES[0] + CHATTRIBUTES[1]: txt += ',' + i.lower() + " integer"
	com.execute("CREATE TABLE IF NOT EXISTS characters (id integer,n integer,name text,lastname text{})".format(txt))

	#CREATE SETTINGS TABLE
	txt = ''
	for i in ['id','lang','sfx','msc','cursor','mouse','speed','color1','color2','color3','border','font_face','censor','hint','help','btype','dislexic','mute','autosave','quickstart']:
		txt += ',' + i.lower()
		if i in ['lang','font_face']: txt += ' text'
		else: txt += ' integer'
	com.execute("CREATE TABLE IF NOT EXISTS settings ({})".format(txt[1:]))

	#CREATE EVERY OTHER TABLE
	com.execute("CREATE TABLE IF NOT EXISTS achievements (id integer,nb integer,got integer,date text)")
	com.execute("CREATE TABLE IF NOT EXISTS bestiary (id integer,name text,nb text,date text,seen int)")
	com.execute("CREATE TABLE IF NOT EXISTS callhist (id integer,n integer,w integer)")
	com.execute("CREATE TABLE IF NOT EXISTS contacts (id integer,n integer)")
	com.execute("CREATE TABLE IF NOT EXISTS controls (id integer,player integer,key integer,value integer)")
	com.execute("CREATE TABLE IF NOT EXISTS chapters (id integer,n integer,progress integer)")
	com.execute("CREATE TABLE IF NOT EXISTS data (id integer,gt integer,fr integer,map text,x integer,y integer,time text,date text,weather integer,chapter integer,shortcut text)")
	com.execute("CREATE TABLE IF NOT EXISTS disitems (id integer,it text,vl integer)")
	com.execute("CREATE TABLE IF NOT EXISTS dlgsav (id integer,who text,vl integer)")
	com.execute("CREATE TABLE IF NOT EXISTS inbox (id integer,n integer,red integer)")
	com.execute("CREATE TABLE IF NOT EXISTS inventory (id integer,item text,position text,properties text)")
	com.execute("CREATE TABLE IF NOT EXISTS party (id integer,n integer,p1 integer,p2 integer,p3 integer)")
	com.execute("CREATE TABLE IF NOT EXISTS paths (id integer,backg text,sprites text,chars text,temp text,items text,freaks text,sfx text,music text,maps text,tiles text,fonts text)")
	com.execute("CREATE TABLE IF NOT EXISTS rank (id integer,chp integer,level integer,score integer,time integer,paint integer,enemies integer,deaths integer)")
	com.execute("CREATE TABLE IF NOT EXISTS relations (id integer,w1 integer,w2 integer,vl integer)")
	com.execute("CREATE TABLE IF NOT EXISTS storage (id integer,it text,ip text)")
	com.execute("CREATE TABLE IF NOT EXISTS tactical (id integer,n integer,pl1 integer,pl2 integer,pl3 integer,pl4 integer)")
	com.execute("CREATE TABLE IF NOT EXISTS tasks (id integer,tsk text,don integer)")
	  
    #FILE ALREADY EXISTS
	for i in ['achievements','bestiary','callhist','contacts','controls','chapters','data','disitems','dlgsav','files',
		'inbox','inventory','party','paths','rank','relations','storage','tactical','tasks']:
		com.execute("DELETE FROM " + i + " WHERE id=" + str(ID))
	
	#INSERT NEW VALUES
	for i in range(len(CONTROLS)):
		for l in range(len(CONTROLS[i])): com.execute("INSERT INTO controls VALUES ({},{},{},{})".format(ID,i,l,CONTROLS[i][l]))
	
	com.execute("INSERT INTO paths VALUES (0,'{}','{}','{}','{}','{}','{}','{}','{}','{}','{}','{}')".format(BACKG_PATH,SPRITES_PATH,CHARS_PATH,TEMP_PATH,ITEMS_PATH,FREAKS_PATH,SFX_PATH,MUSIC_PATH,MAPS_PATH,TILES_PATH,FONTS_PATH))
	com.execute("INSERT INTO data VALUES ({},0,0,'hauntedhouse_0',0,0,'0030','2512200711',0,0,'001')".format(ID))
	#for i in range(len(CHARACTERS)): com.execute("INSERT INTO characters VALUES({},{},'','',0,0,0,0,0,100,100,10000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)".format(ID,i))
	for i in range(len(dtb.CHAPTERS)): com.execute("INSERT INTO chapters VALUES ({},{},0)".format(ID,i))
	for i in dtb.FREAKS.items(): com.execute("INSERT INTO bestiary VALUES({},'{}','xxxxxx','000000',0)".format(ID,i[0]))
	for i in DLGSAV: com.execute("INSERT INTO dlgsav VALUES({},'{}',0)".format(ID,i))
	for i in DISITEMS: com.execute("INSERT INTO disitems VALUES({},'{}',0)".format(ID,i))
	com.execute("INSERT INTO party VALUES({},0,1,2,0)".format(ID))
	com.execute("INSERT INTO settings VALUES ({},'PT',0.8,0.6,0,0,2,242,30,30,0,'BohemianTypewriter.ttf',1,1,1,2,0,0,0,0)".format(ID))
	for i in range(25): com.execute("INSERT INTO storage VALUES({},'_','0000')".format(ID))
	
	for i in range(15):
		for j in range(15):
			com.execute("INSERT INTO relations VALUES({},'{}','{}',0)".format(ID,str(i),str(j)))
	for u in range(6):
		for x in range(5):
			for y in range(5):
				com.execute("INSERT INTO inventory VALUES({},'_','{}{}{}0','0000')".format(ID,u,x,y))
	for i in range(len(dtb.CHAPTERS)):
		for l in range(8): com.execute("INSERT INTO rank VALUES ({},{},{},0,0,0,0,0)".format(ID,i,l))
	
	tbl.commit()
	com.close()
	tbl.close()

def load_data():
	global ID, LANG, SFX, MSC, CONTROLS, MOUSE, CURSOR, SPEED, COLOR, FONT, WEATHER, BORDER, TASKPIN, MINIMAP, SCENE, CENSORSHIP, HINT, HELP, BTYPE, DISLEXIC,\
	FORMATION, MAP, PX, PY, TIME, DATE, CHAPTER, GAS, GAMETIME, PARTY, CONTACTS, CALLHIST, INBOX, TASKS, TACTICAL, BESTIARY, INVENTORY, STORAGE, WASH, DISITEMS, RELATIONS
	  
	tbl = sqlite3.connect('userdata.db')
	com = tbl.cursor()
	
	com.execute("SELECT * FROM {}".format(i))
	lst = [d[0] for d in com.description if d[0] != 'id']
	#lst = ['lang','sfx','msc','cursor','mouse','speed','color1','color2','color3','border','font_face','censor','hint','help','btype','dislexic','mute','autosave','quickstart']
	com.execute("SELECT {} FROM settings WHERE id={}".format(",".join(map(str,lst)),str(ID)))
	vl = com.fetchall()[0]
	for v in range(len(lst)):
		if v.startswith('color'): COLOR[int(lst[v][-1]) - 1] = vl[v]
		else: eval(lst[v].upper() + '=vl[v]')

	CONTROLS = []
	for p in range(2):
		com.execute("SELECT value FROM controls WHERE id={} AND p={} ORDER BY key".format(ctrl,p))
		CONTROLS.append(com.fetchall()[0])
	
	com.execute("SELECT gt,fr,map,x,y,time,date,weather,chapter,shortcut FROM data WHERE id=" + str(ID))
	vl = com.fetchall()[0]
	GAMETIME = vl[0]
	FORMATION = vl[1]
	MAP = vl[2]
	PX = vl[3]
	PY = vl[4]
	TIME = [int(vl[5][0:2]),int(vl[5][2:4]),0]
	DATE = [int(vl[6][0:2]),int(vl[6][2:4]),int(vl[6][4:8]),int(vl[6][8]),int(vl[6][9])]
	WEATHER = vl[7]
	CHAPTER = vl[8]
	SHORTCUT = [int(vl[9][0]),int(vl[9][1]),(vl[9][2])]
	
	com.execute("SELECT * FROM characters WHERE id=" + str(ID))
	res = com.fetchall()
	for i in range(len(CHARACTERS)):
		ix = 2
		for ch in ['NAME','LASTNAME','LEVEL','HP','XP','HEALTH','MORALITY','HAIR','HUNGER','THIRST','SLEEP','BONUS','INSPIRATION','INTIMIDATION','PERSUASION','ANIMALS','SPIRITS','STAMINA','ATLETISM','ACROBATICS','FURTIVITY','PERCEPTION','MEDICINE','IMUNITY','INFANTRY','INVESTIGATION','CRAFTING','CULINARY','DEATHS']:
			if ch == 'HAIR': CHARACTERS[i][ch] = [res[i][ix],res[i][ix + 1],res[i][ix + 2]]; ix += 3
			elif ch == 'BONUS': CHARACTERS[i][ch] = [res[i][ix],res[i][ix + 1],res[i][ix + 2],res[i][ix + 3],res[i][ix + 4]]; ix += 5
			else: CHARACTERS[i][ch] = res[i][ix]; ix += 1
	com.execute("SELECT * FROM dlgsav WHERE id=" + str(ID))
	res = com.fetchall()
	for i in res: DLGSAV[i[0]] = i[1]
	com.execute("SELECT * FROM disitems WHERE id=" + str(ID))
	res = com.fetchall()
	for i in res: DISITEMS[i[0]] = i[1]
	com.execute("SELECT * FROM relations WHERE id=" + str(ID))
	res = com.fetchall()
	for i in res: RELATIONS[i[0]][i[1]] = i[2]
	com.execute("SELECT * FROM party WHERE id=" + str(ID) + " ORDER BY n")
	res = com.fetchall()
	PARTY = []
	for i in res: PARTY.append([i[2],i[3],i[4]])
	com.execute("SELECT * FROM contacts WHERE id=" + str(ID))
	res = com.fetchall()
	CONTACTS = []
	for i in res: CONTACTS.append(NUMBERS[i[0]].copy())
	CONTACTS = [['Maicon','923778988'],['Mercador','969696969'],['Pizza Delivery','953478809']]
	com.execute("SELECT * FROM callhist WHERE id=" + str(ID))
	res = com.fetchall()
	CALLHIST = []
	for i in res: CALLHIST.append([i[0],i[1]])
	com.execute("SELECT * FROM inbox WHERE id=" + str(ID))
	res = com.fetchall()
	INBOX = []
	for i in res:
		mail = EMAILS[i[0]].copy()
		mail.append(i[1])
		INBOX.append(mail)
	com.execute("SELECT * FROM tasks WHERE id=" + str(ID))
	res = com.fetchall()
	TASKS = []
	for i in res: TASKS.append([i[0],i[1]])
	com.execute("SELECT * FROM tactical WHERE id=" + str(ID))
	res = com.fetchall()
	TACTICAL = []
	for i in res: TACTICAL.append([i[2],i[3],i[4],i[5]])
	com.execute("SELECT * FROM bestiary WHERE id=" + str(ID))
	res = com.fetchall()
	BESTIARY = []
	for i in res:
		BESTIARY.append({'N': i[1],'ID': i[2],'DATE': i[3],'SEEN': i[4]})
	com.execute("SELECT * FROM achievements WHERE id="+ str(ID))
	res = com.fetchall()
	for i in res:
		dtb.ACHIEVEMENTS[i[1]][2] = i[2]
		dtb.ACHIEVEMENTS[i[1]][3] = i[3]
	if res == []:
		for i in dtb.ACHIEVEMENTS:
			i[2] = 0
			i[3] = ''
	com.execute("SELECT * FROM inventory WHERE id="+ str(ID))
	res = com.fetchall()
	INVENTORY = []
	for u in range(6):
		INVENTORY.append([])
		for y in range(5):
			INVENTORY[u].append([])
			for x in range(5):
				for i in res:
					if int(i[2][0]) == u and int(i[2][1]) == y and int(i[2][2]) == x:
						if len(INVENTORY[u][y]) <= x:
							INVENTORY[u][y].append([])
						INVENTORY[u][y][x].append(i[1])
						INVENTORY[u][y][x].append(i[3])
	com.execute("SELECT * FROM storage WHERE id="+ str(ID))
	res = com.fetchall()
	STORAGE = []
	for i in res:
		STORAGE.append([i[1],i[2]])
	com.execute("SELECT * FROM wash WHERE id="+ str(ID))
	res = com.fetchall()
	WASH = []
	for i in res:
		WASH.append([i[1],i[2],i[3]])
	com.execute("SELECT * FROM rank WHERE id="+ str(ID))
	res = com.fetchall()
	RANK = []
	for i in res:
		RANK.append([])
	com.close()
	tbl.close()

def save_data(t):
	global ID, MAP, PX, PY, TIME, DATE, WEATHER, CHAPTER, GAS, GAMETIME, FORMATION, CHARACTERS, TASKPIN, MINIMAP, DLGSAV, SCENE, BESTIARY
 
	tbl = sqlite3.connect('userdata.db')
	com = tbl.cursor()
	
	#REGULAR SAVING
	if t == 0:
		if TIME[0] < 10: hr = '0' + str(TIME[0])
		else: hr = str(TIME[0])
		if TIME[1] < 10: mn = '0' + str(TIME[1])
		else: mn = str(TIME[1])
		ts = hr + mn
		
		if DATE[0] < 10: dd = '0' + str(DATE[0])
		else: dd = str(DATE[0])
		if DATE[1] < 10: mm = '0' + str(DATE[1])
		else: mm = str(DATE[1])
		if DATE[2] < 10: yy = '0' + str(DATE[2])
		else: yy = str(DATE[2])
		dt = dd + mm + yy + str(DATE[3]) + str(DATE[4])
		st = str(SHORTCUT[0]) + str(SHORTCUT[1]) + str(SHORTCUT[2])
		#SAVE GLOBAL GAME DATA
		com.execute("UPDATE data SET gt = {},fr = {},map = '{}',x = {},y = {},time = '{}',date = '{}',weather = {},chapter = {},scene = {},gas = {},\
			shortcut = {} WHERE id = {}".format(GAMETIME,FORMATION,MAP,PX,PY,ts,dt,WEATHER,CHAPTER,SCENE,GAS,st,ID))
		#SAVE CHARACTERS DATA
		p = 0
		for i in CHARACTERS:
			com.execute("UPDATE characters SET name = '{}',lastname = '{}',level = {},hp = {},xp = {},health = {},morality = {},hc = {},ht = {},fh = {},hunger = {},thirst = {},sleep = {},b1 = {},b2 = {},b3 = {},b4 = {},b5 = {},\
				inspiration = {},intimidation = {},persuasion = {},animals = {},spirits = {},stamina = {},atletism = {},acrobatics = {},furtivity = {},perception = {},\
				medicine = {},imunity = {},infantry = {},investigation = {},crafting = {},culinary = {},deaths = {} WHERE n = {} AND id = {}".format(i['NAME'],i['LASTNAME'],i['LEVEL'],
					i['HP'],i['XP'],i['HEALTH'],i['MORALITY'],i['HAIR'][0],i['HAIR'][1],i['HAIR'][2],i['HUNGER'],i['THIRST'],i['SLEEP'],i['BONUS'][0],i['BONUS'][1],i['BONUS'][2],i['BONUS'][3],i['BONUS'][4],i['INSPIRATION'],i['INTIMIDATION'],i['PERSUASION'],
					i['SPIRITS'],i['ANIMALS'],0,i['ATLETISM'],i['ACROBATICS'],i['FURTIVITY'],i['PERCEPTION'],i['MEDICINE'],i['IMUNITY'],
					i['INFANTRY'],i['INVESTIGATION'],i['CRAFTING'],i['CULINARY'],i['DEATHS'],p,ID))
			p += 1
		#SAVE DIALOGS DATA
		for i in DLGSAV:
			com.execute("UPDATE dlgsav SET vl = {} WHERE who = '{}' AND id={}".format(DLGSAV[i],i,ID))
		#SAVE DISCOVERED ITEMS DATA
		for i in DISITEMS:
			com.execute("UPDATE disitems SET vl = {} WHERE it = '{}' AND id = {}".format(DISITEMS[i],i,ID))
		#SAVE RELATIONS DATA
		for i in range(len(RELATIONS)):
			for j in range(len(RELATIONS[i])):
				com.execute("UPDATE relations SET vl = {} WHERE w1 = '{}' and w2 = '{}' AND id = {}".format(RELATIONS[i][j],i,j,ID))
		#SAVE PARTY DATA
		com.execute("DELETE FROM party WHERE id = " + str(ID))
		p = 0
		for i in PARTY:
			com.execute("INSERT INTO party VALUES({},{},'{}','{}','{}')".format(ID,p,i[0],i[1],i[2]))
			p += 1
		#SAVE TACTICAL DATA
		for i in range(len(TACTICAL)):
			try: com.execute("UPDATE tactical SET p1 = {},p2 = {},p3 = {},p4 = {} WHERE n = {} AND id = {}".format(TACTICAL[i][0],TACTICAL[i][1],TACTICAL[i][2],TACTICAL[i][3],i,ID))
			except: com.execute("INSERT INTO tactical VALUES({},{},{},{},{},{})".format(ID,i,TACTICAL[i][0],TACTICAL[i][1],TACTICAL[i][2],TACTICAL[i][3]))
		#SAVE BESTIARY DATA
		for i in BESTIARY:
			com.execute("UPDATE bestiary SET id = '{}',date = '{}',seen = {} WHERE name = '{}' AND id = {}".format(i['ID'],i['DATE'],i['SEEN'],i['N'],ID))
		#SAVE INVENTORY DATA
		for u in range(len(INVENTORY)):
			for y in range(5):
				for x in range(5):
					for i in range(int(len(INVENTORY[u][y][x])/2)):
						com.execute("DELETE FROM inventory WHERE id = {} AND position = '{}'".format(ID,str(u) + str(y) + str(x) + str(i)))
						com.execute("INSERT INTO inventory VALUES({},'{}','{}','{}')".format(ID,INVENTORY[u][y][x][i * 2],str(u) + str(y) + str(x) + str(i),INVENTORY[u][y][x][(i * 2) + 1]))
		#SAVE STORAGE DATA
		com.execute("DELETE FROM storage WHERE id = " + str(ID))
		for i in STORAGE:
			com.execute("INSERT INTO storage VALUES({},'{}','{}')".format(ID,i[0],i[1]))
		#SAVE WASH DATA
		com.execute("DELETE FROM wash WHERE id = " + str(ID))
		for i in WASH:
			com.execute("INSERT INTO wash VALUES({},'{}','{}','{}')".format(ID,i[0],i[1],i[2]))
		#SAVE RANK DATA
		for i in range(len(RANK)):
			for j in range(len(RANK[i])):
				for p in RANK[i][j]:
					com.execute("UPDATE rank SET score = {},time = {},paint = {},enemies = {},deaths = {} WHERE id = {} AND chp = {} AND level = {}".format(p[0],p[1],p[2],p[3],p[4],ID,i,j))
	#SETTINGS SAVE
	if t == 1:
		com.execute("UPDATE settings SET lang = '{}',sfx = {},msc = {},ctrl = {},mouse = {},cursor = {},speed = {},color1 = {},color2 = {},color3 = {},border = {},\
		font = '{}',censor = {},hint = {},help = {},btype = {},dislexic = {} WHERE id = {}".format(LANG,SFX,MSC,0,MOUSE,CURSOR,SPEED,COLOR[0],COLOR[1],COLOR[2],BORDER,
		FONT,int(CENSORSHIP),int(HINT),int(HELP),BTYPE,DISLEXIC,ID))
	#CONTROLS SAVE
	if t == 2:
		for p in range(3):
			com.execute("UPDATE controls SET up = '{}',down = '{}',left = '{}',right = '{}',act = '{}',run = '{}',pause = '{}',inventory = '{}',device = '{}' WHERE id = {} AND p = {}".format(
			CONTROLS[p][0],CONTROLS[p][1],CONTROLS[p][2],CONTROLS[p][3],CONTROLS[p][4],CONTROLS[p][5],CONTROLS[p][6],CONTROLS[p][7],CONTROLS[p][8],ID,p))
	#ACHIEVEMENTS SAVE
	if t == 3:
		com.execute("UPDATE achievements SET got = {},date = '{}' WHERE nb = {} AND id = {}".format(ACHIEVEMENTS[i][2],ACHIEVEMENTS[i][3],i,ID))
		
	tbl.commit()
	com.close()
	tbl.close()

def delete_data():
	global ID
	tbl = sqlite3.connect('userdata.db')
	com = tbl.cursor()
	
	del FILES[ID]
	for i in ['files','settings','data','characters','party','contacts',
	'callhist','inbox','tasks','tactical','bestiary','achievements','inventory',
	'storage','rank']:
		com.execute("DELETE FROM " + i + " WHERE id=" + str(ID))
	
	tbl.commit()
	com.close()
	tbl.close()

def sprites():
	global SPRITES
	
	#HUMANS
	dirs = ['U','LU','L','LD','D','RD','R','RU']
	movs = [('STAND',[0,1,2,3]),('TIREDSTAND',[0,0,1,1]),('SEAT',[0]),('DRIVE',[0]),
	('JUMP',[0,1]),('WALK',[0,1,2,1,0,3,4,3]),('RUN',[0,1,2,1,0,3,4,3])]
	
	SPRITES['PHONE'] = [pygame.image.load(TEMP_PATH + 'body_phone.png').convert_alpha()]
	SPRITES['CALL'] = [pygame.image.load(TEMP_PATH + 'body_call.png').convert_alpha()]
	SPRITES['REST'] = [pygame.image.load(TEMP_PATH + 'body_rest.png').convert_alpha()]
	
	for m in movs:
		for d in dirs:
			trg = True
			if m[0] == 'JUMP' and d not in ['U','D']: trg = False
			if trg == True:
				SPRITES[m[0] + d] = []
				for f in m[1]:
					if m[1] == [0]: fn = ''
					else: fn = '_' + str(f)
					if d == 'LU': spr = pygame.image.load(TEMP_PATH + 'body_' + m[0].lower() + 'HU' + fn + '.png').convert_alpha()
					elif d == 'L': spr = pygame.image.load(TEMP_PATH + 'body_' + m[0].lower() + 'H' + fn + '.png').convert_alpha()
					elif d == 'LD': spr = pygame.image.load(TEMP_PATH + 'body_' + m[0].lower() + 'HD' + fn + '.png').convert_alpha()
					elif d == 'RU': spr = pygame.transform.flip(pygame.image.load(TEMP_PATH + 'body_' + m[0].lower() + 'HU' + fn + '.png').convert_alpha(),True,False)
					elif d == 'R': spr = pygame.transform.flip(pygame.image.load(TEMP_PATH + 'body_' + m[0].lower() + 'H' + fn + '.png').convert_alpha(),True,False)
					elif d == 'RD': spr = pygame.transform.flip(pygame.image.load(TEMP_PATH + 'body_' + m[0].lower() + 'HD' + fn + '.png').convert_alpha(),True,False)
					else: spr = pygame.image.load(TEMP_PATH + 'body_' + m[0].lower() + d + fn + '.png').convert_alpha()
					SPRITES[m[0] + d].append(spr)
	
	#ANIMALS
	SPRITES['PIGEON_WALKL'] = []
	SPRITES['PIGEON_WALKR'] = []
	SPRITES['PIGEON_FLYL'] = []
	SPRITES['PIGEON_FLYR'] = []
	for i in (0,1):
		SPRITES['PIGEON_WALKL'].append(pygame.transform.flip(pygame.image.load(SPRITES_PATH + 'ani_pigeon_walk_' + str(i) + '.png').convert(),True,False))
		SPRITES['PIGEON_WALKR'].append(pygame.image.load(SPRITES_PATH + 'ani_pigeon_walk_' + str(i) + '.png').convert())
	for i in (0,1):
		SPRITES['PIGEON_FLYL'].append(pygame.transform.flip(pygame.image.load(SPRITES_PATH + 'ani_pigeon_fly_' + str(i) + '.png').convert(),True,False))
		SPRITES['PIGEON_FLYR'].append(pygame.image.load(SPRITES_PATH + 'ani_pigeon_fly_' + str(i) + '.png').convert())
	for a in [0]:
		SPRITES['DOG' + str(a) + '_STANDL'] = []
		SPRITES['DOG' + str(a) + '_STANDR'] = []
		SPRITES['DOG' + str(a) + '_SITL'] = []
		SPRITES['DOG' + str(a) + '_SITR'] = []
		SPRITES['DOG' + str(a) + '_WALKL'] = []
		SPRITES['DOG' + str(a) + '_WALKR'] = []
		for i in (0,1):
			SPRITES['DOG' + str(a) + '_STANDL'].append(pygame.transform.flip(pygame.image.load(SPRITES_PATH + 'ani_dog' + str(a) + '_stand_' + str(i) + '.png').convert(),True,False))
			SPRITES['DOG' + str(a) + '_STANDR'].append(pygame.image.load(SPRITES_PATH + 'ani_dog' + str(a) + '_stand_' + str(i) + '.png').convert())
		for i in (0,1):
			SPRITES['DOG' + str(a) + '_SITL'].append(pygame.transform.flip(pygame.image.load(SPRITES_PATH + 'ani_dog' + str(a) + '_sit_' + str(i) + '.png').convert(),True,False))
			SPRITES['DOG' + str(a) + '_SITR'].append(pygame.image.load(SPRITES_PATH + 'ani_dog' + str(a) + '_sit_' + str(i) + '.png').convert())
		for i in (0,1,2,3,4,3,2,1):
			SPRITES['DOG' + str(a) + '_WALKL'].append(pygame.transform.flip(pygame.image.load(SPRITES_PATH + 'ani_dog' + str(a) + '_walk_' + str(i) + '.png').convert(),True,False))
			SPRITES['DOG' + str(a) + '_WALKR'].append(pygame.image.load(SPRITES_PATH + 'ani_dog' + str(a) + '_walk_' + str(i) + '.png').convert())

def fonts():
	global FONTS
	pygame.font.init()
	FONTS = {
		'DEFAULT': pygame.font.Font(FONTS_PATH + 'BohemianTypewriter.ttf', 10 * GSCALE),
		'CALIBRI': pygame.font.SysFont('Calibri', 10 * GSCALE),
		'PRESTIGE': pygame.font.Font(FONTS_PATH + 'PrestigeEliteStd.otf', int(7.5 * GSCALE)),
		'MONOTYPE': pygame.font.Font(FONTS_PATH + 'monotype.ttf', 5 * GSCALE),
		'TITLE': pygame.font.Font(FONTS_PATH + 'pixel-font.ttf', 20 * GSCALE),
		'DATETIME': pygame.font.Font(FONTS_PATH + 'datetype.ttf', 8 * GSCALE),
		'CONTROLKEYS': pygame.font.Font(FONTS_PATH + 'controlkeys.ttf', 15)}

def sfx(ignore=True):
	global SOUND

	for j in os.listdir(SFX_PATH[:-1]):
		if j[:-4].upper() in SOUND.keys() and ignore == False: print(dtb.ERROR['sound_exists'].format(j))
		if j.endswith('.wav'): SOUND[j[:-4].upper()] = pygame.mixer.Sound(SFX_PATH + j)
		elif j.endswith('.ogg'): SOUND[j[:-4].upper()] = pygame.mixer.Sound(SFX_PATH + j)
		else:
			for i in os.listdir(SFX_PATH + j):
				if i.endswith('.wav'):
					if i[:-4].upper() in SOUND.keys() and ignore == False: print(dtb.ERROR['sound_exists'].format(i))
					SOUND[i[:-4].upper()] = pygame.mixer.Sound(SFX_PATH + j + '/' + i)

if FILES != []: exec(f'import databases.database_{FILES[0][4]} as dtb')
else: exec(f'import databases.database_{MAINLANG} as dtb')

if os.path.basename(sys.argv[0]) == os.path.basename(__file__):
	#SHOW TABLES ON TERMINAL
	if len(sys.argv) > 1:
		tbl = sqlite3.connect('userdata.db')
		com = tbl.cursor()
		if sys.argv[1] == 'sql':
			if len(sys.argv) > 2: com.execute(" ".join(map(str,sys.argv[2:])))
			else: cc = input("> "); com.execute(cc)
			tbl.commit()
		elif sys.argv[1] == 'tables':
			com.execute("SELECT name FROM sqlite_schema WHERE type IN ('table','view') AND name NOT LIKE 'sqlite_%' ORDER BY 1")
			lst = [c[0] for c in com.fetchall()]
			for i in lst: print('	' + i.upper())
		elif sys.argv[1] == 'show':
			com.execute("SELECT name FROM sqlite_schema WHERE type IN ('table','view') AND name NOT LIKE 'sqlite_%' ORDER BY 1")
			lst = [c[0] for c in com.fetchall()]
			if sys.argv[2].lower() in lst: lst = [sys.argv[2]]
			for i in lst:
				com.execute("SELECT * FROM {}".format(i))
				columns = [d[0] for d in com.description]
				res = com.fetchall()
				txt = '| '
				for c in columns: txt += c.upper() + ' | '
				ll = '\n--'
				for c in columns:
					for cc in range(len(c)): ll += '-'
					ll += '---'
				ll = ll[0:-1]
				txt += ll
				for r in range(len(res)):
					txt += '\n| '
					for rr in range(len(res[r])):
						add = str(res[r][rr])
						if len(str(res[r][rr])) < len(columns[rr]):
							for s in range(len(columns[rr]) - len(str(res[r][rr]))): add += ' '
						if len(str(res[r][rr])) > len(columns[rr]): add = add[:len(columns[rr])]
						#txt += columns[rr] + ' | '
						txt += add + ' | '
				tt = '\n-' + i.upper()
				for s in range(len(ll) - len(tt)): tt += '-'
				txt += '\n'
				for s in range(len(ll) - 1): txt += '-'
				print(tt + '\n' + txt)

		com.close()
		tbl.close()
recent_data(0)