1.
Code:
create table users(ID int auto_increment primary key, username varchar(20), password varchar(20), pin int default 0, gender int default 0, gm int default 0);
create table characters(ID int auto_increment primary key, name varchar(12), userid int, level tinyint unsigned default 1, job smallint default 0, str smallint, dex smallint, intt smallint, luk smallint, chp smallint default 50, mhp smallint default 50, cmp smallint default 50, mmp smallint default 50, ap smallint default 0, sp smallint default 0, exp int default 0, fame smallint default 0, map int default 0,
pos smallint default 0, gender tinyint, skin tinyint, eyes int, hair int, mesos int default 0);
create table equip(equipid int, type tinyint, charid int, pos smallint default 0, slots tinyint default 7, scrolls smallint default 0, istr smallint default 0, idex smallint default 0, iint smallint default 0, iluk smallint default 0, ihp smallint default 0, imp smallint default 0, iwatk smallint default 0, imatk smallint default 0, iwdef smallint default 0, imdef smallint default 0, iacc smallint default 0, iavo smallint default 0, ihand smallint default 0, ispeed smallint default 0, ijump smallint default 0);
create table items(itemid int, charid int, inv tinyint, pos smallint, amount smallint);
create table keymap(charid int, pos0 int default 0, pos1 int default 0, pos2 int default 2564, pos3 int default 3076, pos4 int default 3332, pos5 int default 4612, pos6 int default 5380, pos7 int default 0, pos8 int default 0, pos9 int default 0, pos10 int default 0, pos11 int default 0, pos12 int default 0, pos13 int default 0, pos14 int default 0, pos15 int default 0, pos16 int default 2052, pos17 int default 1284, pos18 int default 4, pos19 int default 1028, pos20 int default 0, pos21 int default 0, pos22 int default 0, pos23 int default 260, pos24 int default 0, pos25 int default 4868, pos26 int default 3588, pos27 int default 3844, pos28 int default 0, pos29 int default 13317, pos30 int default 0, pos31 int default 516, pos32 int default 0, pos33 int default 0, pos34 int default 3456, pos35 int default 2820, pos36 int default 0, pos37 int default 772, pos38 int default 0, pos39 int default 5124, pos40 int default 4100, pos41 int default 0, pos42 int default 0, pos43 int default 2308, pos44 int default 12805, pos45 int default 13061, pos46 int default 1540, pos47 int default 0, pos48 int default 0, pos49 int default 0, pos50 int default 1796, pos51 int default 0, pos52 int default 0, pos53 int default 0, pos54 int default 0, pos55 int default 0, pos56 int default 13573, pos57 int default 0, pos58 int default 0, pos59 int default 25606, pos60 int default 25862, pos61 int default 26118, pos62 int default 26374, pos63 int default 26630, pos64 int default 26886, pos65 int default 27142, pos66 int default 0, pos67 int default 0, pos68 int default 0, pos69 int default 0, pos70 int default 0, pos71 int default 0, pos72 int default 0, pos73 int default 0, pos74 int default 0, pos75 int default 0, pos76 int default 0, pos77 int default 0, pos78 int default 0, pos79 int default 0, pos80 int default 0, pos81 int default 0, pos82 int default 0, pos83 int default 0, pos84 int default 0, pos85 int default 0, pos86 int default 0, pos87 int default 0, pos88 int default 0, pos89 int default 0);
create table skills(charid int, skillid int, points int);
2.
Code:
alter table characters change exp exp int default 0
3.
Code:
ALTER TABLE characters ADD online INT( 1 ) NOT NULL DEFAULT 0;
ALTER TABLE characters ADD origin INT DEFAULT 0 AFTER map;
4.
Code:
ALTER TABLE `users` ADD `ban_expire` DATETIME NOT NULL DEFAULT 0,
ADD `ban_reason` TINYINT( 2 ) UNSIGNED NOT NULL DEFAULT '0';
5.
Code:
alter table characters add gotpack int default 0;
6.
Code:
DROP TABLE IF EXISTS `events`;
CREATE TABLE `events` (
`type` int(1) NOT NULL,
`ID` int(1) NOT NULL,
`start` int(1) NOT NULL,
`town` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `events` VALUES ('0', '1', '0', '0');
7. ONLY IF NECESSARY
Code:
alter table characters change level level int default 1;
[שחרור] Re-pack - Krytical's Pack v6 Rev.007 - הגירסא החדשה
ציטוט ההודעה
נכתב במקור על ידי SinteL
