Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- -- zlicza ilość morderstw danego gracza
- create procedure killCountByNickName @nickname varchar(45)
- select kills from Player where nickname=@nickname
- -------------------------------------------------------------------
- -- 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 3 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
- -- najlepsi gracze wzgledem ilosci smierci danego dnia
- create view dateTopDeath
- as
- Select top 5 nickname, deaths
- from player
- where
- -- zestawienie morderstw wg gracza
- create view topKillers
- exec killCountByNickName 'mateusz'
- -------------------------------------------------------------------
- -- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement