Tytuł projektu: Gra MMORPG
Autor: Mateusz Oracz
Indeks: 412150
-------------------------------------------------------------------
-- DROP TABLES --
-------------------------------------------------------------------
IF OBJECT_ID('Player_Items', 'U') IS NOT NULL
DROP TABLE Player_Items;

IF OBJECT_ID('Item_List', 'U') IS NOT NULL
	DROP TABLE Item_List;

IF OBJECT_ID('Player_Fight', 'U') IS NOT NULL
DROP TABLE Player_Fight;

IF OBJECT_ID('Account_Ban', 'U') IS NOT NULL
DROP TABLE Account_Ban;

IF OBJECT_ID('Player', 'U') IS NOT NULL
	BEGIN
		ALTER TABLE Player
		DROP CONSTRAINT add_fk_guild_id
	END

IF OBJECT_ID('Guild', 'U') IS NOT NULL
	DROP TABLE Guild;

IF OBJECT_ID('Player', 'U') IS NOT NULL
	BEGIN
		ALTER TABLE Player
		DROP CONSTRAINT add_fk_account_id
		DROP TABLE Player;
	END

IF OBJECT_ID('Account', 'U') IS NOT NULL
DROP TABLE Account;

-------------------------------------------------------------------
-- CREATE TABLES --
-------------------------------------------------------------------
------ Account
CREATE TABLE Account(
	idAccount int identity(1,1) primary key,
	username varchar(45) NOT NULL check (username NOT LIKE '%[^A-Z]%'),
	password varchar(45) NOT NULL check (DATALENGTH(password) >= 4),
	group_id varchar(10) check (group_id in ('admin', 'user')) default 'user'
)
-------------------------------------------------------------------
-- Account_Ban
CREATE TABLE Account_Ban(
	idAccount_Ban int identity(1,1) primary key,
	account_ban_id int,
	reason varchar(255) NOT NULL,
	ban_day DATE NOT NULL,
	expire_day DATE NOT NULL
)
-------------------------------------------------------------------
-- Player
CREATE TABLE Player(
	idPlayer int identity(1,1) primary key,
	nickname varchar(45) NOT NULL check (nickname NOT LIKE '%[^A-Z]%'),
	account_id int,
	level int NOT NULL default 1,
	vocation varchar(45) NOT NULL check (vocation in ('warrior', 'mage', 'ranger')),
	deaths int default null,
	kills int default null,
	balance int default 30000,
	guild_id int
)
-------------------------------------------------------------------
-- Guild
CREATE TABLE Guild(
	idGuild int identity(1,1) primary key,
	name varchar(45) NOT NULL check (name NOT LIKE '%[^A-Z]%'),
	points int default null,
	owner_id int
)
-------------------------------------------------------------------
-- Player_Fight
CREATE TABLE Player_Fight(
	idPlayer_Fight int identity(1,1) primary key,
	first_id int,
	second_id int,
	result int NOT NULL,
	date DATE NOT NULL default getdate()
)
-------------------------------------------------------------------
-- Player_Items
CREATE TABLE Player_Items(
	idPlayer_Items int identity(1,1) primary key,
	player_id int,
	item_id int
)
-------------------------------------------------------------------
-- Item_List
CREATE TABLE Item_List(
	idItem_List int identity(1,1) primary key,
	item_name varchar(45) NOT NULL check (item_name NOT LIKE '%[^A-Z]%'),
	price int NOT NULL,
	bonus_level int NOT NULL
)
-------------------------------------------------------------------
-- ALTER TABLES --
-------------------------------------------------------------------
ALTER TABLE Account_Ban
ADD CONSTRAINT add_fk_account_ban_id  foreign key (account_ban_id ) references Account(idAccount)

ALTER TABLE Player
ADD CONSTRAINT add_fk_account_id foreign key (account_id) references Account(idAccount)

ALTER TABLE Player
ADD CONSTRAINT add_fk_guild_id foreign key (guild_id) references Guild (idGuild)

ALTER TABLE Guild
ADD CONSTRAINT add_fk_owner_id foreign key (owner_id) references Player(idPlayer)

ALTER TABLE Player_Fight
ADD CONSTRAINT add_fk_first_id foreign key (first_id) references Player(idPlayer)

ALTER TABLE Player_Fight
ADD CONSTRAINT add_fk_second_id foreign key (second_id) references Player(idPlayer)

ALTER TABLE Player_Items
ADD CONSTRAINT add_fk_player_id foreign key (player_id) references Player(idPlayer)

ALTER TABLE Player_Items
ADD CONSTRAINT add_fk_item_id foreign key (item_id) references Item_List(idItem_List)
-------------------------------------------------------------------
-- SHOW DATABASE --
-------------------------------------------------------------------
select * from Account
select * from Account_Ban
select * from Player
select * from Guild
select * from Player_Fight
select * from Player_Items
select * from Item_List
-------------------------------------------------------------------
-- PROCEDURES --
-------------------------------------------------------------------
-- Dodawanie i modyfikacja danych
-------------------------------------------------------------------
-- Dodanie konta - Admin
create procedure addAccountAdmin
	@username varchar(45),
	@password varchar(45),
	@group_id varchar(10)
		as
		begin
		begin try
			if exists (select username from Account where username=@username)
				begin
					raiserror ('Konto o podanej nazwie już istnieje', 11, 1)
				end
			else
				begin
					insert into Account(username, password, group_id)
					values(@username, @password, @group_id);
				end
		end try
		begin catch
				select error_number() as 'number bledu', error_message() as 'komunikat'
		end catch
		end

-- Dodanie konta - User
create procedure addAccountUser
	@username varchar(45),
	@password varchar(45)
		as
		begin
		begin try
			if exists (select username from Account where username=@username)
				begin
					raiserror ('Konto o podanej nazwie już istnieje', 11, 1)
				end
			else
				begin
					insert into Account(username, password)
					values(@username, @password);
				end
		end try
		begin catch
				select error_number() as 'number bledu', error_message() as 'komunikat'
		end catch
		end

-- Modyfikacja konta - Admin
create procedure modifyAccountAdmin
	@idAccount int,
	@username varchar(45),
	@password varchar(45),
	@group_id varchar(45)
		as
		begin
		begin try
			if not exists (select @idAccount from Account where idAccount=@idAccount)
				begin
					raiserror ('Nie istnieje takie konto', 11, 1)
				end
			else if exists (select username from Account where username=@username)
				begin
					raiserror ('Konto o podanej nazwie już istnieje', 11, 1)
				end
			else
				update Account
					set
						username=isnull(@username, username),
						password=isnull(@password,password),
						group_id=isnull(@group_id,group_id)
					where idAccount=@idAccount
					end
			try
			begin catch
				select error_number() as 'number bledu', error_message() as 'komunikat'
			end catch
		end

-- Modyfikacja konta - User
create procedure modifyAccountUser
	@username varchar(45),
	@password varchar(45)
		as
		begin
		begin try
			if not exists (select @username from Account where username=@username)
				begin
					raiserror ('Nie istnieje takie konto', 11, 1)
				end
			else
				update Account
					set
						password=isnull(@password,password)
					where username=@username
					end
			try
			begin catch
				select error_number() as 'number bledu', error_message() as 'komunikat'
			end catch
		end

-- Dodanie postaci - Admin
create procedure addPlayerAdmin
	@nickname varchar(45),
	@account_id int,
	@level int = 1,
	@vocation varchar(45),
	@deaths int = 0,
	@kills int = 0,
	@balance int = 30000
		as
		begin
		begin try
			if exists (select nickname from Player where nickname=@nickname)
				begin
					raiserror ('Postac o takim nicku juz istnieje', 11, 1)
				end
			else
				begin
					insert into Player(nickname, account_id, level, vocation, deaths, kills, balance)
					values(@nickname, @account_id, @level, @vocation, @deaths, @kills, @balance);
				end
		end try
		begin catch
				select error_number() as 'number bledu', error_message() as 'komunikat'
		end catch
		end

-- Dodanie postaci - User
create procedure addPlayerUser
	@nickname varchar(45),
	@account_id int,
	@vocation varchar(45)
		as
		begin
		begin try
			if exists (select nickname from Player where nickname=@nickname)
				begin
					raiserror ('Postac o takim nicku juz istnieje', 11, 1)
				end
			else
				begin
					insert into Player(nickname, account_id, vocation)
					values(@nickname, @account_id, @vocation);
				end
		end try
		begin catch
				select error_number() as 'number bledu', error_message() as 'komunikat'
		end catch
		end

-- Usuwanie postaci
create procedure deletePlayer
	@nickname varchar(45),
	@account_id int
		as
		begin
		begin try
			if not exists (select @nickname from Player where nickname=@nickname)
				begin
					raiserror ('Nie istnieje taka postać', 11, 1)
				end
			else
				begin
					declare @acc_id int set @acc_id = (select account_id from Player where nickname=@nickname)
					if @account_id = @acc_id
						begin
							delete from Player
							where nickname=@nickname
						end
					else
						begin
							raiserror ('Na tym koncie nie istnieje taka postać', 11, 1)
						end
				end
		end try
		begin catch
				select error_number() as 'numer bledu', error_message() as 'komunikat'
		end catch
		end

-- Dodawanie śmierci postaci
create procedure addDeath
	@idPlayer int
		as
		begin
		begin try
			if not exists (select @idPlayer from Player where idPlayer=@idPlayer)
				begin
					raiserror ('Nie istnieje takie gracz', 11, 1)
				end
			else
				declare @deaths int set @deaths = (select deaths from Player where idPlayer=@idPlayer)
				if(@deaths IS NULL)
					begin
						update Player
						set
							deaths = 1
						where idPlayer=@idPlayer
					end
				else
					begin
						update Player
						set
							deaths=isnull(deaths+1,deaths),
							level=isnull(level-1,level)
						where idPlayer=@idPlayer
						end
				end
			try
			begin catch
				select error_number() as 'number bledu', error_message() as 'komunikat'
			end catch
		end

-- Czasowa blokada konta
create procedure banAccout
	@idPlayer int,
	@reason varchar(255)
		as
		begin
		begin try
			if exists (select idPlayer from Player where idPlayer=@idPlayer)
				begin
					declare @idAccount int set @idAccount = (select account_id from Player where idPlayer = @idPlayer)
					insert into Account_Ban(account_ban_id, reason, ban_day, expire_day)
					values(@idAccount, @reason, GETDATE(), GETDATE()+3)
				end
			else
				raiserror ('Nie ma takiej postaci', 11, 1)
		end try
		begin catch
				select error_number() as 'number bledu', error_message() as 'komunikat'
		end catch
		end

-- Dodawanie nowych przedmiotów do spisu
create procedure addItemList
	@item_name varchar(45),
	@price int,
	@bonus_level int
		as
		begin
		begin try
			if exists (select item_name from Item_List where item_name=@item_name)
				begin
					raiserror ('Przedmiot o danej nazwie juz istnieje', 11, 1)
				end
			else
				begin
					insert into Item_List(item_name, price, bonus_level)
					values(@item_name, @price, @bonus_level);
				end
		end try
		begin catch
				select error_number() as 'number bledu', error_message() as 'komunikat'
		end catch
		end

-- Kupno przedmiotów
create procedure addPlayerItems
	@player_id int,
	@item_id int
		as
		begin
		begin try
				declare @itemPrice int set @itemPrice = (select price from Item_List where idItem_List=@item_id)
				declare @playerBalance int set @playerBalance = (select balance from Player where idPlayer=@player_id)
				if(@playerBalance<@itemPrice)
					begin
						raiserror ('Gracz nie posiada wystarczajacej ilosci zlota', 11, 1)
					end
				else
					begin
						insert into Player_Items(player_id, item_id)
						values(@player_id, @item_id);
						update Player
						set
							balance=isnull(balance-@itemPrice, balance)
						where idPlayer=@player_id
					end
		end try
		begin catch
				select error_number() as 'number bledu', error_message() as 'komunikat'
		end catch
		end

-- Dodawanie gildii
create procedure addGuild
	@name varchar(45),
	@owner_id int
		as
		begin
		begin try
			if exists (select idPlayer from Player where idPlayer=@owner_id)
				begin
					if exists (select name from Guild where name=@name)
						begin
							raiserror ('Gildia o podanej nazwie juz istnieje', 11, 1)
						end
					else
						begin
							insert into Guild(name, owner_id)
							values(@name, @owner_id);
						end
				end
			else
				raiserror ('Nie ma takiego gracza', 11, 1)
		end try
			begin catch
				select error_number() as 'number bledu', error_message() as 'komunikat'
			end catch
		end

-- Przypisanie gildii do postaci
create procedure joinGuild
	@id_player int,
	@id_guild int
		as
		begin
		begin try
			if not exists (select idPlayer from Player where idPlayer=@id_player)
				begin
					raiserror ('Nie ma takiego gracza', 11, 1)
				end
			else if not exists (select idGuild from Guild where idGuild=@id_guild)
				begin
					raiserror ('Nie ma takiej gildii', 11, 1)
				end
			else
				begin
					update Player
					set
						guild_id=isnull(@id_guild, guild_id)
					where idPlayer=@id_player
				end
		end try
		begin catch
				select error_number() as 'number bledu', error_message() as 'komunikat'
		end catch
		end

-- Zwiększenie poziomu
create procedure levelUp
	@id_player int
		as
		begin
		begin try
			if not exists (select idPlayer from Player where idPlayer=@id_player)
				begin
					raiserror ('Nie ma takiego gracza', 11, 1)
				end
			else
				begin
					update Player
					set
						level=isnull(level+1,level),
						balance=isnull(balance+10000,balance)
					where idPlayer=@id_player
				end
		end try
		begin catch
				select error_number() as 'number bledu', error_message() as 'komunikat'
		end catch
		end

-- Dodanie punkt gildii
create procedure addGuildPoints
	@id_guild int
		as
		begin
		begin try
			if not exists (select idGuild from Guild where idGuild=@id_guild)
				begin
					raiserror ('Nie ma takiej gildii', 11, 1)
				end
			else
				begin
					declare @points int set @points = (select points from Guild where idGuild=@id_guild)
					if(@points IS NULL)
						begin
							update Guild
							set
								points = 1
							where idGuild=@id_guild
						end
					else
						begin
							update Guild
							set
								points =isnull(points+1, points)
							where idGuild=@id_guild
						end
				end
		end try
		begin catch
				select error_number() as 'number bledu', error_message() as 'komunikat'
		end catch
		end

-- Dodawanie zabójstwa postaci
create procedure addKill
	@idPlayer int
		as
		begin
		begin try
			if not exists (select @idPlayer from Player where idPlayer=@idPlayer)
				begin
					raiserror ('Nie istnieje takie gracz', 11, 1)
				end
			else
				declare @kills int set @kills = (select kills from Player where idPlayer=@idPlayer)
				if(@kills IS NULL)
					begin
						update Player
						set
							kills = 1
						where idPlayer=@idPlayer
					end
				else
					begin
						update Player
						set
							kills=isnull(kills+1,deaths)
						where idPlayer=@idPlayer
						end
				end
			try
			begin catch
				select error_number() as 'number bledu', error_message() as 'komunikat'
			end catch
		end

-- Walka postaci
create procedure playerFight
	@first_id int,
	@second_id int
		as
		begin
		begin try
			declare @first_level int set @first_level = (select level from Player where idPlayer=@first_id)
			declare @second_level int set @second_level = (select level from Player where idPlayer=@second_id)
			if not exists (select idPlayer from Player where idPlayer=@first_id)
				begin
					raiserror ('Nie ma pierwsego gracza', 11, 1)
				end
			else if not exists (select idPlayer from Player where idPlayer=@second_id)
				begin
					raiserror ('Nie ma drugiego gracza', 11, 1)
				end
			else if (@first_level < 10)
				begin
					raiserror ('Za niski poziom pierwszego gracza (min 10)', 11, 1)
				end
			else if (@second_level < 10)
				begin
					raiserror ('Za niski poziom drugiego gracza (min 10)', 11, 1)
				end
			else
				begin
					declare @randNumber int set @randNumber = (SELECT FLOOR(RAND()*(10-1)+1))
					declare @first_guild_id int set @first_guild_id = (select guild_id from Player where idPlayer=@first_id)
					declare @second_guild_id int set @second_guild_id = (select guild_id from Player where idPlayer=@second_id)

					if (@randNumber <= 5)
						begin
							insert into Player_Fight(first_id, second_id, result, date)
							values (@first_id, @second_id, @first_id, GETDATE())
							exec addDeath @second_id
							exec addKill @first_id
							exec levelUp @first_id
							if ((select guild_id from Player where idPlayer=@first_id) IS NOT NULL)
								begin
									exec addGuildPoints @first_guild_id
								end
						end
					else
						begin
							insert into Player_Fight(first_id, second_id, result, date)
							values (@first_id, @second_id, @second_id, GETDATE())
							exec addDeath @first_id
							exec levelUp @second_id
							exec addKill @second_id
							if ((select guild_id from Player where idPlayer=@first_id) IS NOT NULL)
								begin
									exec addGuildPoints @second_guild_id
								end
						end
				end
		end try
		begin catch
				select error_number() as 'number bledu', error_message() as 'komunikat'
		end catch
		end

-------------------------------------------------------------------
-- FUNKCJE
-------------------------------------------------------------------
-- zlicza przedmioty gracza
create function itemCount
	(@id_player int)
	returns table
as
	return select * from Player_Items where player_id=@id_player

-- zlicza członków gildii
create function memberCount
	(@id_guild int)
	returns table
as
	return select * from Player where guild_id=@id_guild

-- zlicza profesje w gildii
create function memberVocationCount
(
	@id_guild int,
 	@vocation varchar(45)
)
	returns table
as
	return select * from player where vocation=@vocation and guild_id=@id_guild

-------------------------------------------------------------------
-- TRIGGERY
-------------------------------------------------------------------
-- trigger na limit postaci - user
create trigger t_addPlayerUser
on Player
for insert
as
declare @account_id int set @account_id = (select account_id from inserted)
if ((select count(*) from Player where account_id=@account_id) > 3)
	begin
		print 'Osiagnieto limit postaci na konto ( 3 )'
		rollback
	end

-- trigger na dodanie śmierci
create trigger t_addDeath
on Player
after update
as
if ((select level from inserted) < 1)
	begin
		print 'Postac ma minimalny poziom'
		rollback
	end

-- trigger na dodanie poziomu i golda (przedmioty)
create trigger t_addPlayerItems
on Player_Items
for insert
as
	declare @itemId int set @itemId = (select item_id from inserted)
	declare @playerId int set @playerId = (select player_id from inserted)
	declare @bonusLevel int set @bonusLevel = (select bonus_level from Item_List where idItem_List=@itemId)
	update Player
		set
			level=isnull(level+@bonusLevel,level),
			balance=isnull(balance + (@bonusLevel*10000), balance)
		where(idPlayer=@playerId)

-- trigger na limit przedmiotów ( max 5 )
create trigger t_addPlayerItemsLimit
on Player_Items
for insert
as
	declare @idPlayer int set @idPlayer = (select player_id from inserted)
	declare @itemCount int set @itemCount = (select COUNT(*) from itemCount(@idPlayer))
	if(@itemCount>=5)
		begin
			print 'Osiagnieto limit przedmiotow na postac ( 5 )'
			rollback
		end

-- trigger na limity w gildii
create trigger t_joinGuild
on Player
after update
as
	declare @idGuild int set @idGuild = (select guild_id from inserted)
	declare @memberCount int set @memberCount = (select COUNT(*) from memberCount(@idGuild))
	declare @warriorCount int set @warriorCount = (select COUNT(*) from memberVocationCount(@idGuild,'warrior'))
	declare @mageCount int set @mageCount = (select COUNT(*) from memberVocationCount(@idGuild,'mage'))
	declare @rangerCount int set @rangerCount = (select COUNT(*) from memberVocationCount(@idGuild,'ranger'))
	if (@memberCount > 9)
		begin
			print 'Osiagnieto limit postaci w gildii ( 9 )'
			rollback
		end
	else if (@warriorCount > 3)
		begin
			print 'Osiagnieto limit warriorow w gildii ( 3 )'
			rollback
		end
	else if (@mageCount > 3)
		begin
			print 'Osiagnieto limit magow w gildii ( 3 )'
			rollback
		end
	else if (@rangerCount > 3)
		begin
			print 'Osiagnieto limit rangerow w gildii ( 3 )'
			rollback
		end

-- trigger na dolaczenie lidera do gildii
create trigger t_addGuild
on Guild
after insert
as
	declare @guild_id int set @guild_id = (select idGuild from inserted)
	declare @player_id int set @player_id = (select owner_id from inserted)
	update Player
	set
		guild_id=@guild_id
	where idPlayer=@player_id

-------------------------------------------------------------------
-- WIDOKI
-------------------------------------------------------------------
-- najlepsi gracze wzgledem doswiadczenia
create view topLevel
as
select top 5 nickname, level
from Player
order by level desc

-- najlepsi gracze wzgledem majatku
create view topBalance
as
select top 5 nickname, balance
from Player
order by balance desc

-- najlepsi gracze wzgledem ilosci smierci
create view topDeath
as
select top 5 nickname, deaths
from Player
order by deaths

-- najlepsi gracze wzgledem zabojstw
create view topKillers
as
select top 5 nickname, kills
from Player
order by kills desc

-- najlepsze gildie
create view topGuilds
as
select top 5 name, points
from Guild
order by points desc

-------------------------------------------------------------------
-- SCENARIUSZ --
-------------------------------------------------------------------
-- Tworzenie kont ( admin, user )
exec addAccountAdmin 'admin','admin','admin' -- dodanie admin konta
exec addAccountAdmin 'admin','admin','admin' -- login zajety
exec addAccountAdmin 'reguser','reguser','moderator' -- group id check
exec addAccountAdmin 'reguser123','reguser','user' -- login check
exec addAccountAdmin 'reguser','reg','user' -- password check
exec addAccountAdmin 'reguser', 'reguser', 'user' -- dodanie usera przez admina
exec addAccountUser 'mateusz','mateusz'
exec addAccountUser 'test','test'

select * from Account

-- Modyfkacja kont ( admin, user )
exec modifyAccountAdmin 900, 'user', 'user', 'user' -- zle id
exec modifyAccountAdmin 14, 'mateusz', 'mateusz', 'user' -- login zajety
exec modifyAccountAdmin 14, 'adminuser', 'adminuser', 'admin' -- zmiana konta reguser na admina
exec modifyAccountUser 'test', 'test123' -- zmiana hasla

select * from Account

-- Dodanie postaci ( Admin, User )
exec addPlayerAdmin 'Admin', 1, 500, 'warrior', 10, 30, 100000 -- dodanie przez admina
exec addPlayerUser 'mateusz', 15, 'mage' -- dodanie postaci przez usera
exec addPlayerUser 'mateusz', 16, 'warrior' -- zajety nick
exec addPlayerUser 'mateuszDwa', 15, 'mage' -- dodanie postaci przez usera
exec addPlayerUser 'mateuszTrzy', 15, 'mage' -- dodanie postaci przez usera
exec addPlayerUser 'mateuszCztery', 15, 'mage' -- dodanie postaci przez usera
exec addPlayerUser 'Test', 16, 'warrior' -- dodanie postaci przez usera
exec addPlayerUser 'TestDwa', 16, 'warrior' -- dodanie postaci przez usera
exec addPlayerUser 'AdminUser', 14, 'warrior' -- dodanie postaci przez usera

select * from Player

-- Usuwanie postaci
exec deletePlayer 'mateuszOsiem', 15 -- usuniecie postaci ktora nie istnieje
exec deletePlayer 'mateuszTrzy', 600 -- usuniecie postaci z nie swojego konta
exec deletePlayer 'mateuszTrzy', 15 -- poprawne usuniecie

select * from Player

-- Blokada Konta
exec banAccout 500, 'Uzywanie nielegalnego oprogramowania' -- brak takiej postci
exec banAccout 10, 'Uzywanie nielegalnego oprogramowania' -- poprawny ban

select * from Account_Ban

-- Dodanie przedmiotow do spisu
exec addItemList 'sword',  50000, 3 -- poprawne dodanie
exec addItemList 'sword',  70000, 5 -- duplikat nazwy
exec addItemList 'club', 20000, 2 -- poprawne dodanie
exec addItemList 'wand', 10000, 3 -- poprawne dodanie
exec addItemList 'armor', 25000, 6 -- poprawne dodanie

select * from Item_List

-- Kupno przedmiotów
exec levelUp 3 -- dodanie levelu postaci ( wieksza ilosc zlota )
exec addPlayerItems 3, 5 -- poprawne dodanie (t_addPlayerItems), dodawanie do limitu
exec addPlayerItems 8, 2 -- za malo pieniedzy

select * from Player
select * from Player_Items
select * from Item_List

-- Gildie
exec addGuild 'FirstGuild', 3 -- poprawne dodanie, przypisanie ownera gildii, dodanie go do gildii
							  -- max czlonkow w gildii, max 3 dane profesje
exec addGuild 'FirstGuild', 7 -- nazwa zajeta
exec addGuild 'SecondGuild', 8 -- poprawne dodanie

exec joinGuild 4, 1 -- przypisanie postaci do gildii
exec joinGuild 500,1 -- gracz nie istnieje
exec joinGuild 7,500 -- gildia nie istnieje
exec joinGuild 7, 2 -- przypisanie postaci do gildii
exec joinGuild 1, 2 -- limit warriorow
exec joinGuild 10,2 -- limit warriorow

select * from Player
select * from Guild

-- Walka postaci
exec playerFight 3, 7 -- walka graczy, zwieksza poziom wygranemu, zmniejsza przegranemu,
					  -- dodaje pkt wygranej gildii jezeli gracz nalezy, dodanie smierci
					  -- i zabojstwa postaci
exec playerFight 4, 8 -- jeden bez gildii
exec playerFight 900,8 -- brak gracza
exec addDeath 11 -- trigger na min level

exec levelUp 8
select * from Player
select * from Guild
select * from Player_Fight

-- Widoki
select * from topLevel
select * from topBalance
select * from topDeath
select * from topKillers
select * from topGuilds