[SQL] Darkness

Boniuu1 · Luty 9, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

no slepy jestes? pisze ze niemoge zainportowac inbecylu moze niewyzywaj palo jeba** ? zaimportowac trzeba folder Darkness i wyskakuje mi blad gdy to robie

Kacol · Luty 9, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

Boniuu1 napisał:
no slepy jestes? pisze ze niemoge zainportowac inbecylu moze niewyzywaj palo jeba** ? zaimportowac trzeba folder Darkness i wyskakuje mi blad gdy to robie

zaimportuj inny

wyjdzie na to samo

Boniuu1 · Luty 9, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

no juz z 4 silnikow kopiowalem i nic NIE WIEM CO SIE DZIEJE!!

moze wklej tu zawartosc swojego folderu z baza danych...

Kacol · Luty 9, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

hmm... to juz nie wiem jak Ci pom?c morze zresetuj webserver i spr?buj ponownie?

Boniuu1 · Luty 9, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

od wczoraj sie z tym mecze... wes wklej swoja zawartosc Darkness plz

Kacol · Luty 9, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

zaraz znajde i wkleje

ja to sie od wczoraj mecze bo nikt nie oze u mnei na servie grac ;/ i nie wiem co jest nie tak

DROP TRIGGER IF EXISTS `oncreate_players`;
DROP TRIGGER IF EXISTS `oncreate_guilds`;
DROP TRIGGER IF EXISTS `ondelete_players`;
DROP TRIGGER IF EXISTS `ondelete_guilds`;
DROP TRIGGER IF EXISTS `ondelete_accounts`;

DROP TABLE IF EXISTS `player_depotitems`;
DROP TABLE IF EXISTS `tile_items`;
DROP TABLE IF EXISTS `tiles`;
DROP TABLE IF EXISTS `bans`;
DROP TABLE IF EXISTS `house_lists`;
DROP TABLE IF EXISTS `houses`;
DROP TABLE IF EXISTS `player_items`;
DROP TABLE IF EXISTS `player_skills`;
DROP TABLE IF EXISTS `player_storage`;
DROP TABLE IF EXISTS `player_viplist`;
DROP TABLE IF EXISTS `player_spells`;
DROP TABLE IF EXISTS `player_deaths`;
DROP TABLE IF EXISTS `guild_ranks`;
DROP TABLE IF EXISTS `guilds`;
DROP TABLE IF EXISTS `guild_invites`;
DROP TABLE IF EXISTS `global_storage`;
DROP TABLE IF EXISTS `players`;
DROP TABLE IF EXISTS `accounts`;
DROP TABLE IF EXISTS `groups`;

CREATE TABLE `groups`
(
`id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL COMMENT 'group name',
`flags` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`access` INT NOT NULL,
`maxdepotitems` INT NOT NULL,
`maxviplist` INT NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB;

INSERT INTO `groups` VALUES (3, 'a god', 134788128760, 1, 0, 0);
INSERT INTO `groups` VALUES (2, 'a gamemaster', 137438953471, 1, 0, 0);
INSERT INTO `groups` VALUES (1, 'player', 0, 0, 0, 0);

CREATE TABLE `accounts`
(
`id` INT NOT NULL AUTO_INCREMENT,
`password` VARCHAR(255) /* VARCHAR(32) for MD5*/ NOT NULL DEFAULT '',
`type` INT NOT NULL DEFAULT 1,
`premdays` INT NOT NULL DEFAULT 0,
`lastday` INT UNSIGNED NOT NULL DEFAULT 0,
`key` VARCHAR(20) NOT NULL DEFAULT '0',
`email` VARCHAR(255) NOT NULL DEFAULT '',
`blocked` TINYINT(1) NOT NULL DEFAULT FALSE,
`warnings` INT NOT NULL DEFAULT 0,
`group_id` INT NOT NULL DEFAULT 1,
PRIMARY KEY (`id`),
FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)
) ENGINE = InnoDB;

INSERT INTO `accounts` VALUES (1, '1', 1, 65535, 0, '0', '', 0, 0, 1);

CREATE TABLE `players`
(
`id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`group_id` INT NOT NULL DEFAULT 1,
`account_id` INT NOT NULL DEFAULT 0,
`level` INT NOT NULL DEFAULT 1,
`vocation` INT NOT NULL DEFAULT 0,
`health` INT NOT NULL DEFAULT 150,
`healthmax` INT NOT NULL DEFAULT 150,
`experience` BIGINT NOT NULL DEFAULT 0,
`lookbody` INT NOT NULL DEFAULT 0,
`lookfeet` INT NOT NULL DEFAULT 0,
`lookhead` INT NOT NULL DEFAULT 0,
`looklegs` INT NOT NULL DEFAULT 0,
`looktype` INT NOT NULL DEFAULT 136,
`lookaddons` INT NOT NULL DEFAULT 0,
`maglevel` INT NOT NULL DEFAULT 0,
`mana` INT NOT NULL DEFAULT 0,
`manamax` INT NOT NULL DEFAULT 0,
`manaspent` INT NOT NULL DEFAULT 0,
`soul` INT UNSIGNED NOT NULL DEFAULT 0,
`town_id` INT NOT NULL DEFAULT 0,
`posx` INT NOT NULL DEFAULT 0,
`posy` INT NOT NULL DEFAULT 0,
`posz` INT NOT NULL DEFAULT 0,
`conditions` BLOB NOT NULL,
`cap` INT NOT NULL DEFAULT 0,
`sex` INT NOT NULL DEFAULT 0,
`lastlogin` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`lastip` INT UNSIGNED NOT NULL DEFAULT 0,
`save` TINYINT(1) NOT NULL DEFAULT 1,
`redskull` TINYINT(1) NOT NULL DEFAULT 0,
`redskulltime` INT NOT NULL DEFAULT 0,
`rank_id` INT NOT NULL DEFAULT 0,
`guildnick` VARCHAR(255) NOT NULL DEFAULT '',
`lastlogout` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`blessings` TINYINT(2) NOT NULL DEFAULT 0,
`direction` INT NOT NULL DEFAULT 0 COMMENT 'NOT IN USE BY THE SERVER',
`loss_experience` INT NOT NULL DEFAULT '10' COMMENT 'NOT IN USE BY THE SERVER',
`loss_mana` INT NOT NULL DEFAULT '10' COMMENT 'NOT IN USE BY THE SERVER',
`loss_skills` INT NOT NULL DEFAULT '10' COMMENT 'NOT IN USE BY THE SERVER',
`premend` INT NOT NULL DEFAULT 0 COMMENT 'NOT IN USE BY THE SERVER',
`online` TINYINT NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY (`name`),
FOREIGN KEY (`account_id`) REFERENCES `accounts`(`id`) ON DELETE CASCADE,
FOREIGN KEY (`group_id`) REFERENCES `groups`(`id`)
) ENGINE = InnoDB;

INSERT INTO `players` VALUES (1, 'Account Manager', 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 10, 10, 10, 0, 0);

CREATE TABLE `bans`
(
`type` INT NOT NULL COMMENT 'this field defines if its ip, accountban or namelock',
`ip` INT UNSIGNED NOT NULL DEFAULT 0,
`mask` INT UNSIGNED NOT NULL DEFAULT 4294967295,
`player` INT UNSIGNED NOT NULL DEFAULT 0,
`account` INT UNSIGNED NOT NULL DEFAULT 0,
`time` INT UNSIGNED NOT NULL DEFAULT 0,
`reason_id` INT NOT NULL DEFAULT 0,
`action_id` INT NOT NULL DEFAULT 0,
`comment` VARCHAR(60) NOT NULL DEFAULT '',
`banned_by` INT UNSIGNED NOT NULL DEFAULT 0
) ENGINE = InnoDB;

CREATE TABLE `global_storage`
(
`key` INT UNSIGNED NOT NULL,
`value` INT NOT NULL,
PRIMARY KEY (`key`)
) ENGINE = InnoDB;

CREATE TABLE `guilds`
(
`id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL COMMENT 'guild name - nothing else needed here',
`ownerid` INT NOT NULL,
`creationdata` INT NOT NULL,
`motd` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB;

CREATE TABLE `guild_invites`
(
`player_id` INT UNSIGNED NOT NULL DEFAULT 0,
`guild_id` INT UNSIGNED NOT NULL DEFAULT 0
) ENGINE = InnoDB;

CREATE TABLE `guild_ranks`
(
`id` INT NOT NULL AUTO_INCREMENT,
`guild_id` INT NOT NULL COMMENT 'guild',
`name` VARCHAR(255) NOT NULL COMMENT 'rank name',
`level` INT NOT NULL COMMENT 'rank level - leader, vice, member, maybe something else',
PRIMARY KEY (`id`),
FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `house_lists`
(
`house_id` INT NOT NULL,
`listid` INT NOT NULL,
`list` TEXT NOT NULL
) ENGINE = InnoDB;

CREATE TABLE `houses`
(
`id` INT NOT NULL AUTO_INCREMENT,
`owner` INT NOT NULL,
`paid` INT UNSIGNED NOT NULL DEFAULT 0,
`warnings` TEXT NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB;

CREATE TABLE `player_deaths`
(
`player_id` INT NOT NULL,
`time` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`level` INT NOT NULL DEFAULT 1,
`killed_by` VARCHAR(255) NOT NULL,
`is_player` TINYINT(1) NOT NULL DEFAULT 1,
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_depotitems`
(
`player_id` INT NOT NULL,
`depot_id` INT NOT NULL DEFAULT 0,
`sid` INT NOT NULL COMMENT 'any given range eg 0-100 will be reserved for depot lockers and all > 100 will be then normal items inside depots',
`pid` INT NOT NULL DEFAULT 0,
`itemtype` INT NOT NULL,
`count` INT NOT NULL DEFAULT 0,
`attributes` BLOB NOT NULL,
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
KEY (`player_id`, `depot_id`),
UNIQUE KEY (`player_id`, `sid`)
) ENGINE = InnoDB;

CREATE TABLE `player_items`
(
`player_id` INT NOT NULL DEFAULT 0,
`pid` INT NOT NULL DEFAULT 0,
`sid` INT NOT NULL DEFAULT 0,
`itemtype` INT NOT NULL DEFAULT 0,
`count` INT NOT NULL DEFAULT 0,
`attributes` BLOB NOT NULL,
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_skills`
(
`player_id` INT NOT NULL DEFAULT 0,
`skillid` tinyint(4) NOT NULL DEFAULT 0,
`value` INT UNSIGNED NOT NULL DEFAULT 0,
`count` INT UNSIGNED NOT NULL DEFAULT 0,
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_spells`
(
`player_id` INT NOT NULL,
`name` VARCHAR(255) NOT NULL,
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_storage`
(
`player_id` INT NOT NULL DEFAULT 0,
`key` INT UNSIGNED NOT NULL DEFAULT 0,
`value` INT NOT NULL DEFAULT 0,
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_viplist`
(
`player_id` INT NOT NULL COMMENT 'id of player whose viplist entry it is',
`vip_id` INT NOT NULL COMMENT 'id of target player of viplist entry',
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
FOREIGN KEY (`vip_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `tiles`
(
`id` INT NOT NULL AUTO_INCREMENT,
`x` INT NOT NULL,
`y` INT NOT NULL,
`z` INT NOT NULL,
PRIMARY KEY(`id`)
) ENGINE = InnoDB;

CREATE TABLE `tile_items`
(
`tile_id` INT NOT NULL,
`sid` INT NOT NULL,
`pid` INT NOT NULL DEFAULT 0,
`itemtype` INT NOT NULL,
`count` INT NOT NULL DEFAULT 0,
`attributes` BLOB NOT NULL,
FOREIGN KEY (`tile_id`) REFERENCES `tiles` (`id`) ON DELETE CASCADE,
INDEX (`sid`)
) ENGINE = InnoDB;

DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR EACH ROW
BEGIN
DELETE FROM `bans` WHERE `account` = OLD.`id`;
END|

CREATE TRIGGER `ondelete_guilds`
BEFORE DELETE
ON `guilds`
FOR EACH ROW
BEGIN
UPDATE `players` SET `guildnick` = '', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = OLD.`id`);
END|

CREATE TRIGGER `ondelete_players`
BEFORE DELETE
ON `players`
FOR EACH ROW
BEGIN
DELETE FROM `bans` WHERE `type` = 2 AND `player` = OLD.`id`;
UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`;
END|

CREATE TRIGGER `oncreate_guilds`
AFTER INSERT
ON `guilds`
FOR EACH ROW
BEGIN
INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('the Leader', 3, NEW.`id`);
INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('a Vice-Leader', 2, NEW.`id`);
INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('a Member', 1, NEW.`id`);
END|

CREATE TRIGGER `oncreate_players`
AFTER INSERT
ON `players`
FOR EACH ROW
BEGIN
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);
END|

DELIMITER ;

Boniuu1 · Luty 9, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

B??d
zapytanie SQL:

DROP TRIGGER IF EXISTS `oncreate_players` ;

MySQL zwr?ci? komunikat:

#1064 - Something is wrong in your syntax obok 'TRIGGER IF EXISTS `oncreate_players`' w linii 1

TO MI WYSKAKUJE !!!

Vizorix94 · Luty 9, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

wlasnie jak zrobic Gm albo utworzyc zeby bylo account i players Help plx

Boniuu1 · Luty 9, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

musisz zaimportowa? baz? danych kt?ra mi nie chce sie zaimportowa?...

citko194 · Luty 9, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

@Trepido mam pytanie jak przejsc inquisition quest bo jak dohodze do shadow nexuz to nie wiem co zrobic z tym magic wall moze mi powiesz??

wollymen · Luty 9, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

Trepido napisał:
W Configu Nale?y z sqlite zmieni? na Mysql
I Wszystko b?dzie dzia?a?
@down
Ustawi?e? ip w confingu? np trepidots.no-ip.org?

zrobi?em tak jak napisa?e?,odpalam OTSa i..

ImageShack - Image Hosting :: otszw7.png

Tibionauta · Luty 9, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

Kto mi mo?e pom?c zamiast k??ci? si? ze sob? co zrobi? je?eli skille po logu spadaj? do 10? A i nale?y nacisn?? ten magic wall

citko194 · Luty 9, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

@up jak nacisne ppm na wall teleprtuje mnie do room gdzie sa tp na komnaty i pisze nademna na czerwono ze to nie mozliwe

Tibionauta · Luty 9, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

No to w?a?nie wtedy zawalaj do tego gostka co ci da? zadanie i powiedz "Hi" , "Mission" to ci? powinien wpu?ci? do komnaty z nagrodami. Tylko nie m?w jeszcze raz mission bo od nowa b?dziesz musia? zacz??. A i citko mam pytanie tobi? te? spadaj? skille jak si? wylogowujesz ? Jak nie to jak to zrobi?e?

?

citko194 · Luty 9, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

@up napisalem mu i odpowiedzial 16:44 Henricus: Greetings, fellow believer Edions! I'm a Inquisitor.
16:44 Edions [435]: mission
16:44 Henricus: Are you so crazy? You don't have finished this mission.
16:44 Edions [435]: bye
16:44 Henricus: How rude!

nie spadaja mi skile

Tibionauta · Luty 9, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

HmM... trudna sprawa. Ja wlaz?em tam na g?r? najpierw i ubija?em po kolei wszystkich boss?w... Spr?buj jeszcze raz przelecie? all roomy. A wracaj?c to skilli... Jakiego programu u?ywasz ?

Kacol · Luty 9, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

Mam zmienne ip i router z wi-fi i stawiam ten server na no-ip i i tak nikt nie morze wbi? pomo?e kto? ? plzz

Tibionauta · Luty 9, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

A ustawi?e? w configu , to ip? A poza tym musisz zaktualizowa? je co jaki? czas. A czy nikt nie mo?e mi pom?c z tym problemem ze skillami?

Kacol · Luty 9, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

no niby mam ustawione i wszystko ?adnie dzia?a ale nikt nie morze wbi? normalnie wyskakuje ze czeka na liste postaci i potem error connect ;/

@Edit
Juz sobie poradzilem

dzieki

artas99 · Luty 10, 2009

Odp: [8.4][SQL] Darkness

Odp: [8.4][SQL] Darkness

Wszystko pi?knie ?adnie ale w skanie pokazane jest ze kaspersky nic nie wykry? a mi usuwa silnik ;/
@Tibionauta a zapisujesz serwer? Mo?e zapomniasz o tym i skille cofaj? si? ;p

[SQL] Darkness

User

New User

User

New User

User

New User

User

User

User

Active User

New User

Advanced User

Active User

Advanced User

Active User

Advanced User

New User

Advanced User

New User

Active User