BK201

@BK201: > Well a lot of what you said is incorrect but it's w/e, I don't wanna explain anymore :P. My main point is wrong because I thought the server was parsing text files. But why would you have a game without a functional website :confused:. omfg I keep hitting quote instead of edit.

Well a lot of what you said is incorrect but it's w/e, I don't wanna explain anymore :P. My main point is wrong because I thought the server was parsing text files. I'm a newbie myself not ready to teach anyone or go really in-depth about shit.

@BK201: > OK in terms of efficiency it's not better here. I wasn't paying attention to what SJR. Blah I'm sorry. Though, you still have the advantage of queries, running a wesbite. > > Sorry for the double post.

OK in terms of efficiency it's not better here. I wasn't paying attention to what SJR. Blah I'm sorry. Though, you still have the advantage of queries, running a wesbite. Sorry for the double post.

Thanks man. :cheesy:

It's not slower, it's faster. Lets stick with 2000 for example purposes. In some instances the server is running through 2000 files, and all the data in those files. Lets user a real world example, you have 2000 contact files you need to find all names that have one of three phone numbers and organize them. So you can't use the index numbers at the top, those aren't related to phone numbers so you have to go through all the files, and every line in them MANUALY. Now what if you had something in your brain that would spit out the data your requesting. Which is easier on your brain? server connects to database -> executes query -> a database administration program handles the query (MySQL, SQLite) -> returns the data to the server. Which is more efficient?

@♥: > With a database you would have to maintain the connection of the database with the server, but without it you can localize all your files. > > A database is where you keep everything if its distributed among different computers. Why's that a bad thing. If you didn't want to connect to a web server you could use SQLite for example.

How is it more efficient, having 2000 player files separated. Whereas you could have them all in a database. Like i was saying earlier what if you wanted to make changes to a large amount of players. Or say, you wanted to have a high scores page on a website. Currently you'd have to run through all the separate files, like the high scores example you would have to run through all the files constantly or a set period. Whereas using something like MySQL you could have it in real-time consuming almost no resources? Just being able to execute queries would make it a better option imo.

I realise this is an old thread but I'd rather make a comment on this one instead of starting a new thread. SQL is still far more efficient, but the biggest thing that would be gained from the switch is being able to execute queries. Say, you wanted players to have a id for a farming skill, but your current 2000 players don't have that in the files and any scripts calling those values are going to generate errors. While with SQL you could update the entire database incredibly efficiently and simply. Granted, I'm not saying there isn't other ways to solve the problem. But SQL is for more simple and efficient imagine if you need to update or create a lot of new values on a lot of players or players with a certain value in a certain field.

Where can I find the player data accounts/players in the server? Are the folders made on first account creation? I'm running Linux so I really don't want to fiddle with getting EO running atm. And I would like to start working on a web app in which I need to view these. If this is the case would anyone be so kind as to post a default account/player file. :)

You should add captions or some form of narration and some music for a promotional video! :)

Hello, everyone, would like to introduce myself to the forums. I'm here, as well an aspiring PHP programmer, to further my skills. Albeit this may not be the best place for that, this site iterests me. I haven't checked yet, but I'm hoping player data is store via database. How'd I end up here? Well, I've actually played on the eclipse engine or some earlier version about er… 8-9 years ago on a server called Koronia which was the beginning of my MMORPG journey haha. Soon after I began playing a game called Tibia, played that for several years and finally retired after the game declined to a sad and pathetic state (this is in early '07). Then I ended up at a community called OTFans after an old friend on TIbia introduced me to (O)pen (T)ibia. OTFans was a player and development community for Tibia private servers. I began making and customising my own servers and had a blast for a few years. During that time I picked up on a little LUA, SQL, and markup languages. I fiddle with that mostly through highschool and ended up as a moderator on the forums. From 17 - 18 my activity on the forums slowly decreased eventually stopping except for the occasional browsing to recall fond memories. I just recently stopped by those forums (I'm 20 now) to consider developing but sadly the OT community has declined into terrible shape and will eventually die due many things among them the death of Tibia itself. So I'm here: I love open source communities, 2d sprite based mmo's, and I want to further develop my skills. I really hope I'll enjoy my time here and hopefully contribute to the development of this community. //I think the front page inspired me to write that... O.o