Forum :: EOSERV :: Insomniacs trunk updated 2/3/12

Sorry, really nooby question as I haven't used eoserv in a while, but, how do you create a database with HeidiSQL or Sqliteman? I mean, I can download it, open it and name it, but it says 0 fields and it's supposed to be 4 there, I think? (Chars, accs, guilds, bans, etc). I've searched the forums and couldn't find the help I needed, people may post another link in-case I have missed one, or something? Thanks in advanced.

Don't know if you've already tried this, but you could add a check for players on the map.

Map *map = world->GetMap(mapid);

if(map->characters.size() == 0)

{

break; or return false;

}

This is how i stop a script that uses characters from the map. You might have to fix somethings up, to fit your source.

EDIT: I do believe I fixed the problem: Click me for new download!

If someone could please test this for me, that would be great!

Btw: I only edited 1 part of world.cpp, added a check for the player count.

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

right on! Good lookin out!

@ sky ,you just use the sql that comes with the trunk and select all and then run a query!

insomniac posted: (14th Dec 2011, 03:28 am)

right on! Good lookin out!

@ sky ,you just use the sql that comes with the trunk and select all and then run a query!

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

Thank you. But, I ran it and only Accounts tab came up, no characters, bans, or guilds.

--------------------

Fixed.

----------------

I have another question. May I ask, how do you edit the login private message you get and edit the bot name that pms you. And also the death messages? :)

Sky posted: (14th Dec 2011, 12:36 pm)

Thank you. But, I ran it and only Accounts tab came up, no characters, bans, or guilds.

--------------------

Fixed.

----------------

I have another question. May I ask, how do you edit the login private message you get and edit the bot name that pms you. And also the death messages? :)

search Pandemonium and change it =D

and also sorry to be awkward, is there anyway somone would be able to make a sqlite database for this?

This is only compiled for mysql. You would need to recompile it.

Hollow posted: (14th Dec 2011, 04:13 pm)

This is only compiled for mysql. You would need to recompile it.

eoserv stays hard doesn't it? You simply convert your old database to this one and add his costum columns.

Hollow posted: (14th Dec 2011, 04:23 pm)

eoserv stays hard doesn't it? You simply convert your old database to this one and add his costum columns.

o.o  i cant see what columns to add? i cant open the database,, Why im asking for a Sqlite one to be posted

Check the install.sql or it was called something like insomniac-database.sql?

what do you mean?? How can i check it? Its Mysql... I cant Open it,,,,

.sql file types can simply be opened with notepad

Hollow posted: (14th Dec 2011, 04:27 pm)

.sql file type can simply be opened with notepad

Click me!

This is a SQLITE OR MYSQL build. I also created a blank database for sql. And I fixed the install.sql, from the one that I uploaded earlier, had reborn in there twice.

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