Aleeda Emulator [C#, Deltar] R63+

Roper / Veelox, using a enum to get the type wouldn't be a good idea either ( Using too much mysql at high user count ), I'm talking about something like this:

PHP Code:

---

if (Item.X == 0 && Item.Y == 0 && Item.Z == 0)
{
    this.InventoryItem = true;
    this.RoomItem = false;
}
else
{
    this.InventoryItem = false;
    this.RoomItem = true;
} 


---

---------- Post added at 11:21 PM ---------- Previous post was at 11:19 PM ----------

Quote:

---

Originally Posted by AresCJ

Create user_items and room_items, why I said so?

» Easier to configure if there's SQL errors, it'll show on Console.
» Let's say something happens where you have to TRUNCATE table or DESTROY, you can backup, and re-insert the data.

Simple right?

---

You'r a damn faggot, go read some books about how to design a fast, yet lightweight MySQL database structure.

---------- Post added at 11:23 PM ---------- Previous post was at 11:21 PM ----------

Quote:

---

Originally Posted by tweeney

I agree with the above...
less complicated also - Easier to find stuffd

---

This probably explains why you'r hotel failed..

Quote:

---

Originally Posted by AresCJ

Create user_items and room_items, why I said so?

» Easier to configure if there's SQL errors, it'll show on Console.
» Let's say something happens where you have to TRUNCATE table or DESTROY, you can backup, and re-insert the data.

Simple right?

---

LOL

that will slow up your sql server!

I started the pages (not the tabs) without MySQL.. (Will be MySQL soon)
Because the tabs were originally MySQL (:

http://img705.imageshack.us/img705/9652/catawindows.png

http://img862.imageshack.us/img862/1392/cataspaces.png

Quote:

---

Originally Posted by PEjump2

Roper / Veelox, using a enum to get the type wouldn't be a good idea either ( Using too much mysql at high user count ), I'm talking about something like this:

PHP Code:

---

if (Item.X == 0 && Item.Y == 0 && Item.Z == 0)
{
    this.InventoryItem = true;
    this.RoomItem = false;
}
else
{
    this.InventoryItem = false;
    this.RoomItem = true;
} 


---

---------- Post added at 11:21 PM ---------- Previous post was at 11:19 PM ----------

You'r a damn faggot, go read some books about how to design a fast, yet lightweight MySQL database structure.

---------- Post added at 11:23 PM ---------- Previous post was at 11:21 PM ----------

This probably explains why you'r hotel failed..

---

Well, I'm the faggot who's had your back since you've been on RZ when bitches are whining and crying about your criticism, and see my hotel has never failed, Echo Hotel had over 700 users at once with r35/r26, so please I know my SQL and also your spelling is incorrect. It won't slow SQL down at all, if you know what you're doing so therefore /facepalm to you, and /facepalm to Richard. Maybe you need to GOOGLE some shit up before your fucking dumbass try to debate with me about 2 LITTLE TABLES, fucking beginner.

NOTE: SQL Servers only slow down with LARGE TABLES , not having so many tables, you can have 10,000 tables, with little info, and the server will still be at a sufficient speed. So please get your information straight, wanna-be developer.

Quote:

---

Originally Posted by Richardjuhh

LOL

that will slow up your sql server!

---

/facepalm
Read some books & gain knowledge, kk?:thumbup1:

A smaller amount of tables with collective data, that is properly indexed and has a good table structure the better an faster. The less seeking your hard drive does, the better. Because MySQL is read/wrote from the hard drive It's best to be as efficient as possible. However, relaying on MySQL isn't such a good idea (for everything). It isn't the fastest thing. Because we all know hard drives are the slowest component in a computer, with the exepction of a top-end SSD. If I had the motivation, which with this community, I don't and won't ever I would write a server that uses an object database and caches most user values. The server shouldn't be totally dependant on something that has to read/write from a hard drive. If it is, after many people are on, you will get a fair amount of lag. And no, I'm not talking about 20 users. I'm talking more of 300 +.

No one here, in the HH section besides private deveopers take performance into account. There's the flawed ideology that "Gee this works". Well yeah it does, but will it be this good when 400 people are trying to access it?

Ares, I don't believe your hotel had 700 users online. You're also wrong about large tables. They aren't slower.

Quote:

---

Originally Posted by Matthew

A smaller amount of tables with collective data, that is properly indexed and has a good table structure the better an faster. The less seeking your hard drive does, the better. Because MySQL is read/wrote from the hard drive It's best to be as efficient as possible. However, relaying on MySQL isn't such a good idea (for everything). It isn't the fastest thing. Because we all know hard drives are the slowest component in a computer, with the exepction of a top-end SSD. If I had the motivation, which with this community, I don't and won't ever I would write a server that uses an object database and caches most user values. The server shouldn't be totally dependant on something that has to read/write from a hard drive. If it is, after many people are on, you will get a fair amount of lag. And no, I'm not talking about 20 users. I'm talking more of 300 +.

No one here, in the HH section besides private deveopers take performance into account. There's the flawed ideology that "Gee this works". Well yeah it does, but will it be this good when 400 people are trying to access it?

Ares, I don't believe your hotel had 700 users online. You're also wrong about large tables. They aren't slower.

---

Well, Matthew, that's something you have to deal with on your own, about my old hotel's population, eh? No need for me to debate on that.

However, I am not wrong about larger tables.


» MySQL having large tables does awesomely effect the performance of the server
» You can have small amounts of data in many tables as you please, in my opinion, it doesn't matter how many tables you have, it's about the amount that's contained in those tables.

I thought this was based on HabboPlus ;o But I see ION? Someone mind telling me when exactly you've changed your mind on using ION as a base.

AresCJ you've got it totally wrong, You need good database structure no matter how much entrys are given, Database structure & Caching is needed if you want a "stable" hotel.

But yeah, people that leech other projects ( Hebbo's & Maartens r32 server ) like you don't give a shit about it cuz their to dumb to understand that.

Quote:

---

Originally Posted by PEjump2

AresCJ you've got it totally wrong, You need good database structure no matter how much entrys are given, Database structure & Caching is needed if you want a "stable" hotel.

But yeah, people that leech other projects ( Hebbo's & Maartens r32 server ) like you don't give a shit about it cuz their to dumb to understand that.

---

Honestly you are a fucking idiot, just get the hell out of RaGEZONE you n00b. You don't know ANYTHING about coding, you just say; "o, im c00l coz i ripped loads of c0dez from kek0mundo, pehump v2 is amazing so u need buy my "uberemu" ripped emulator called HumpEmulator - R1; License; Imafaggot".

You fucking idiot. :glare:

Quote:

---

Originally Posted by PowahAlert

Honestly you are a fucking idiot, just get the hell out of RaGEZONE you n00b. You don't know ANYTHING about coding, you just say; "o, im c00l coz i ripped loads of c0dez from kek0mundo, pehump v2 is amazing so u need buy my "uberemu" ripped emulator called HumpEmulator - R1; License; Imafaggot".

You fucking idiot. :glare:

---

If you don't like him, why bother replying to him. Just ignore him. Also, it isn't fair that we all go off-topic on DJQuack's thread.

Quote:

---

Originally Posted by PEjump2

AresCJ you've got it totally wrong, You need good database structure no matter how much entrys are given, Database structure & Caching is needed if you want a "stable" hotel.

But yeah, people that leech other projects ( Hebbo's & Maartens r32 server ) like you don't give a shit about it cuz their to dumb to understand that.

---

Yet again, you can also use indexing, regardless as Matt said in his post, but hey you can call me what you want ( i <3 your criticism, it rockzzzz my world), but I know what I do..

Quote:

---

Originally Posted by PowahAlert

I thought this was based on HabboPlus ;o But I see ION? Someone mind telling me when exactly you've changed your mind on using ION as a base.

---

Yes, I have changed to ION/Deltar..

The reasons because it's faster, stabler and doesn't use switch cases for packet handling.

It uses delegates.. I am waiting on a Mod to change the title (:

---------- Post added at 02:12 PM ---------- Previous post was at 02:07 PM ----------

I'll be happy to upload my old HabboPlus source soon.. :P

When think you to release aleedaemu?

Quote:

---

Originally Posted by pepijndut

When think you to release aleedaemu?

---

Don't ask something that doesn't require to tell the future ;)

Quackie, You said the HabboPlus base was awesome a while ago? Lolwut? Using switch statements and only 1 socket instead of server & client & multiple connections?

//Back on topic =]

Quote:

---

Originally Posted by PEjump2

Quackie, You said the HabboPlus base was awesome a while ago? Lolwut? Using switch statements and only 1 socket instead of server & client & multiple connections?

---

Yes, my fault.

I didn't realise how shit it really was.

Quote:

---

Originally Posted by WizardC0der

//Back on topic =]

---

GTFO, wichard wanna-be.

Alex, hows progress?

Quote:

---

Originally Posted by Quackster

Yes, my fault.

I didn't realise how shit it really was.

---

i only told u like 30 million times bby D:

--


So, i've just read through the last page or 2 of this thread...

I hate how the n00bs think they can HERP A DERP their way in here and spam out wrong shit, seriously how do you little children learn how to use your keyboards, did mommy and daddy have to hold your hand so you could post?

A CORRECT database would use small tables, you n00bs can go create one big user table and store everything in it, your server will lag to hell trying to process querys, why do you think debbo failed? Oh, wait, you probably weren't here during debbo....

Quote:

---

Originally Posted by james

i only told u like 30 million times bby D:

--


So, i've just read through the last page or 2 of this thread...

I hate how the n00bs think they can HERP A DERP their way in here and spam out wrong shit, seriously how do you little children learn how to use your keyboards, did mommy and daddy have to hold your hand so you could post?

A CORRECT database would use small tables, you n00bs can go create one big user table and store everything in it, your server will lag to hell trying to process querys, why do you think debbo failed? Oh, wait, you probably weren't here during debbo....

---

You are bringing up the spam again ..
Just leave it and stay on-topic, btw the progress is going amazing and very fast ;)

Good work:thumbup1:

Quote:

---

Originally Posted by james

i only told u like 30 million times bby D:

--


So, i've just read through the last page or 2 of this thread...

I hate how the n00bs think they can HERP A DERP their way in here and spam out wrong shit, seriously how do you little children learn how to use your keyboards, did mommy and daddy have to hold your hand so you could post?

A CORRECT database would use small tables, you n00bs can go create one big user table and store everything in it, your server will lag to hell trying to process querys, why do you think debbo failed? Oh, wait, you probably weren't here during debbo....

---

I waz, but I used a server called "GoldenShox" :blushing:

Quote:

---

Originally Posted by Tr0ll.™

I waz, but I used a server called "GoldenShox" :blushing:

---

Woah, I thought you were donkjam

I used that server too, it was really shitty

Quote:

---

Originally Posted by Eronisch

You are bringing up the spam again ..
Just leave it and stay on-topic, btw the progress is going amazing and very fast ;)

Good work:thumbup1:

---

"Spam" is those few words that you just stated "BTW, the progress is going amazing and very fast" with a gay wink smiley face.

Technically, it wasn't spam, it was a discussion between multiple users about a (subject which was about MySQL Performance)

When having indexing, indexing is the same thing as compressing files on your drives, it saves space, and enhances speed, am I correct? Therefore, if SQL had problems with performance because of tabling, why don't they limit it then?

Quote:

---

Originally Posted by james

i only told u like 30 million times bby D:

--


So, i've just read through the last page or 2 of this thread...

I hate how the n00bs think they can HERP A DERP their way in here and spam out wrong shit, seriously how do you little children learn how to use your keyboards, did mommy and daddy have to hold your hand so you could post?

A CORRECT database would use small tables, you n00bs can go create one big user table and store everything in it, your server will lag to hell trying to process querys, why do you think debbo failed? Oh, wait, you probably weren't here during debbo....

---

Did you expect anything more no one seems to know anything here? And I thought Debbo used flatfiles.. I haven't used it in like 3 years.