Forum :: EOSERV :: Spells and shit for EOSERV

Aye, Very nice release, But How do you get rid of the all admin? XD

---
Create your own destiny, don't let someone else do it for you.

Change it through your database manager,You will have to edit the Admin section on the actual .SQL file.

Festa posted: (27th Jun 2010 01:39 am)

Change it through your database manager,You will have to edit the Admin section on the actual .SQL file.

Yeah. Your a little slow =P i figured it out on my own! :D

EDIT* Dude, your god command is messed up. even after i say $god austin off i still hit like 10m...

---
Create your own destiny, don't let someone else do it for you.

Battleofeo posted: (27th Jun 2010 01:40 am)

Festa posted: (27th Jun 2010 01:39 am)

Change it through your database manager,You will have to edit the Admin section on the actual .SQL file.

Yeah. Your a little slow =P i figured it out on my own! :D

EDIT* Dude, your god command is messed up. even after i say $god austin off i still hit like 10m...

If you are class 9 you will

---
https://www.youtube.com/watch?v=d_DFVzxsEUc

i can't do that install.sql or back i get sqlyog error
do i use my own install.sql?

Use this


CREATE TABLE IF NOT EXISTS `accounts`
(
    `username`   VARCHAR(16) NOT NULL,
    `password`   CHAR(64)    NOT NULL,
    `fullname`   VARCHAR(64) NOT NULL,
    `location`   VARCHAR(64) NOT NULL,
    `email`      VARCHAR(64) NOT NULL,
    `computer`   VARCHAR(64) NOT NULL,
    `hdid`       INTEGER     NOT NULL,
    `regip`      VARCHAR(15) NOT NULL,
    `lastip`     VARCHAR(15)          DEFAULT NULL,
    `created`    INTEGER     NOT NULL,
    `lastused`   INTEGER              DEFAULT NULL,

    PRIMARY KEY (`username`)
);

CREATE TABLE IF NOT EXISTS `characters`
(
    `name`        VARCHAR(16) NOT NULL,
    `account`     VARCHAR(16)          DEFAULT NULL,
    `title`       VARCHAR(32)          DEFAULT NULL,
    `home`        VARCHAR(32)          DEFAULT NULL,
    `fiance`      VARCHAR(16)          DEFAULT NULL,
    `partner`     VARCHAR(16)          DEFAULT NULL,
    `admin`       INTEGER     NOT NULL DEFAULT 0,
      `hidden`      tinyint(1)  NOT NULL DEFAULT 0,
      `invincible`  tinyint(1)  NOT NULL DEFAULT 0,
    `class`       INTEGER     NOT NULL DEFAULT 0,
    `gender`      INTEGER     NOT NULL DEFAULT 0,
    `race`        INTEGER     NOT NULL DEFAULT 0,
    `hairstyle`   INTEGER     NOT NULL DEFAULT 0,
    `haircolor`   INTEGER     NOT NULL DEFAULT 0,
    `map`         INTEGER     NOT NULL DEFAULT 192,
    `x`           INTEGER     NOT NULL DEFAULT 7,
    `y`           INTEGER     NOT NULL DEFAULT 6,
    `direction`   INTEGER     NOT NULL DEFAULT 2,
    `level`       INTEGER     NOT NULL DEFAULT 0,
    `exp`         INTEGER     NOT NULL DEFAULT 0,
    `hp`          INTEGER     NOT NULL DEFAULT 10,
    `tp`          INTEGER     NOT NULL DEFAULT 10,
    `str`         INTEGER     NOT NULL DEFAULT 0,
    `int`         INTEGER     NOT NULL DEFAULT 0,
    `wis`         INTEGER     NOT NULL DEFAULT 0,
    `agi`         INTEGER     NOT NULL DEFAULT 0,
    `con`         INTEGER     NOT NULL DEFAULT 0,
    `cha`         INTEGER     NOT NULL DEFAULT 0,
    `statpoints`  INTEGER     NOT NULL DEFAULT 0,
    `skillpoints` INTEGER     NOT NULL DEFAULT 0,
    `karma`       INTEGER     NOT NULL DEFAULT 1000,
    `sitting`     INTEGER     NOT NULL DEFAULT 0,
    `bankmax`     INTEGER     NOT NULL DEFAULT 0,
    `goldbank`    INTEGER     NOT NULL DEFAULT 0,
    `usage`       INTEGER     NOT NULL DEFAULT 0,
    `inventory`   TEXT        NOT NULL,
    `bank`        TEXT        NOT NULL,
    `paperdoll`   TEXT        NOT NULL,
    `spells`      TEXT        NOT NULL,
    `guild`       CHAR(3)              DEFAULT NULL,
    `guild_rank`  INTEGER              DEFAULT NULL,
    `quest`       TEXT        NOT NULL,
    `vars`        TEXT        NOT NULL,

    PRIMARY KEY (`name`)
);

CREATE TABLE IF NOT EXISTS `guilds`
(
    `tag`         CHAR(3)     NOT NULL,
    `name`        VARCHAR(32) NOT NULL,
    `description` TEXT        NOT NULL,
    `created`     INTEGER     NOT NULL,
    `ranks`       TEXT        NOT NULL,
    `bank`        INTEGER     NOT NULL DEFAULT 0,

    PRIMARY KEY (`tag`),
    UNIQUE      (`name`)
);

CREATE TABLE IF NOT EXISTS `bans`
(
    `ip`       INTEGER              DEFAULT NULL,
    `hdid`     INTEGER              DEFAULT NULL,
    `username` VARCHAR(16)          DEFAULT NULL,
    `setter`   VARCHAR(16)          DEFAULT NULL,
    `expires`  INTEGER     NOT NULL DEFAULT 0
);

CREATE INDEX `character_account_index` ON `characters` (`account`);
CREATE INDEX `character_guild_index` ON `characters` (`guild`);
CREATE INDEX `ban_ip_index` ON `bans` (`ip`);
CREATE INDEX `ban_hdid_index` ON `bans` (`hdid`);
CREATE INDEX `ban_username_index` ON `bans` (`username`);

---
https://www.youtube.com/watch?v=d_DFVzxsEUc

First I would like to thank you for spells release!  The only thing i've noticed is the npc's wont drop anything. Any advice on that issue!

I've just tested Madao's source.The drops.ini file works fine.You have just got to update the drops.ini file with your own  provided information.

Thank you for quick reply I found the problem it was in the config.ini
## DropRate (number)
# Rate that items are dropped at
DropRate = 1%

For the people that are having trouble with install.sql, Simple rename back.sql to install.sql Worked for me, delete the accounts that are already there.

I didnt have any issues/errors with source and btw u can change the 10mil dmg for class 9 users its in map.cpp i believe just remove the 99999999 and it will only hit wat ur actual dmg is.

---
Fate-Gaming/Forgotten Memories Owner.

epicnoob posted: (27th Jun 2010 05:40 pm)

I didnt have any issues/errors with source and btw u can change the 10mil dmg for class 9 users its in map.cpp i believe just remove the 99999999 and it will only hit wat ur actual dmg is.

Set it to 0

Lets see. I have tried to use this package and for some reason it isnt working. None of the spells seem to be showing up on skill list. Am I suppose to be doing something with other files to get this to work? Also is has seemed to disable my player # commands.

Krissy posted: (29th Jun 2010 10:26 pm)

Lets see. I have tried to use this package and for some reason it isnt working. None of the spells seem to be showing up on skill list. Am I suppose to be doing something with other files to get this to work? Also is has seemed to disable my player # commands.

Well this source just has spells and some other stuff and u get spells when u make ur char.All u gata do is use the F1-F8 Keys and it should work.And did u add ur own # commands?Do u get any errors or they just dont work?

---
Fate-Gaming/Forgotten Memories Owner.

UPDATE: Ok so I was trying to install the install.sql and it keep giving me an error saying access is denied to database "eoserv" any ideas how to fix this?