[REL] Project Cold Coffeee ~ Jeax Server [C#, MySQL, Source, Executable]

Ok Jeax, I just have a question for you.
I'm not very familiar with MySQL, but I've already made a database on my personal server and I have already imported the MySQL file you included with your server. Now, I've created the user+pass for my SQL database and I've edited the settings.ini file

Code:

---

[database]
host=localhost
port=3306
db=rocky_server
username=rocky_server
password=*removed*

---

Now, I know I'm missing something in there.. lmao, mind helping me out?

hmm.. well if its on the same machine as the server itself then it all looks fine.

if not then the host will need to be changed obviously :p

Yeah, It's hosted on a different machine, nevermind now. I got it. Thanks. :P

It is necessary to transfer config.ini on the basis from MySQL data?

What port should I use in the loader?

1337.

Jeax i need some help... The server connects to my SQL .... but when i try to register ... it does this.

Quote:

---

(7/24/2007 - 6:18 PM) -- Connected to MySQL
(7/24/2007 - 6:18 PM) -- Error with running query 'SELECT `text` FROM `static` WHERE `value` = 'dcmessage'' Error Returned: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-4.1.21-standard]MySQL server has gone away
(7/24/2007 - 6:18 PM) -- Error with running query 'UPDATE `public` SET `CurIn` = '0'' Error Returned: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-4.1.21-standard]MySQL server has gone away
(7/24/2007 - 6:18 PM) -- Error with running query 'UPDATE `private` SET `CurIn` = '0'' Error Returned: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-4.1.21-standard]MySQL server has gone away
(7/24/2007 - 6:18 PM) -- Started listening for connection requests on port '1337'
(7/24/2007 - 6:22 PM) -- New connection established {1}
(7/24/2007 - 6:22 PM) -- @@BCN
(7/24/2007 - 6:22 PM) -- @@BCJ
(7/24/2007 - 6:22 PM) -- Error with running query 'SELECT `ip` FROM `bans` WHERE `ip` = '127.0.0.1'' Error Returned: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-4.1.21-standard]MySQL server has gone away

(7/24/2007 - 6:22 PM) -- @@w@EYdA@A2@mhttp://www.hablink.net/data/external/vars.txt
(7/24/2007 - 6:22 PM) -- @@X@F@T89049778811486222007
(7/24/2007 - 6:22 PM) -- Error with running query 'SELECT `shockwave` FROM `bans` WHERE `shockwave` = '89049778811486222007'' Error Returned: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-4.1.21-standard]MySQL server has gone away

(7/24/2007 - 6:22 PM) -- @@BBu
(7/24/2007 - 6:22 PM) -- @@B@q
(7/24/2007 - 6:22 PM) -- @@B@I
(7/24/2007 - 6:24 PM) -- Client Disconnected
(7/24/2007 - 6:24 PM) -- Client Disconnected
(7/24/2007 - 6:24 PM) -- New connection established {1}
(7/24/2007 - 6:24 PM) -- @@BCN
(7/24/2007 - 6:24 PM) -- @@BCJ
(7/24/2007 - 6:24 PM) -- Error with running query 'SELECT `ip` FROM `bans` WHERE `ip` = '127.0.0.1'' Error Returned: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-4.1.21-standard]MySQL server has gone away

(7/24/2007 - 6:24 PM) -- @@w@EYdA@A2@mhttp://www.hablink.net/data/external/vars.txt
(7/24/2007 - 6:24 PM) -- @@X@F@T89049778811486222007
(7/24/2007 - 6:24 PM) -- Error with running query 'SELECT `shockwave` FROM `bans` WHERE `shockwave` = '89049778811486222007'' Error Returned: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-4.1.21-standard]MySQL server has gone away

(7/24/2007 - 6:24 PM) -- @@BBu
(7/24/2007 - 6:24 PM) -- @@B@q
(7/24/2007 - 6:24 PM) -- @@B@I

---

Best server yet I would think... Considering its got MySQL and it isnt vb I would start my retro up again if it had more updated features (trax, diving, etc.) Otherwise... Kick ass start.

ty DylLazy :)

Qurb: that error means that the MySQL Server has disconnected for some reason or another, either your host refused the connection or it just dropped it.

Either re-try re-opening the app which might fix it. Or check your mysql settings to see if its allowing the connection.

Quote:

---

Originally Posted by MrGiMmE

jeax ur server is noob becuz u dont have battleball!

---

Can U tell us what server has got battleball

@ kuidjesjors - None have battle ball ... and if they clame to .... they making up shit... or their server is shit.

@ Jeax - Thanks for the help. I restarted the server and now it does this:

Quote:

---

(7/24/2007 - 6:53 PM) -- Connected to MySQL
(7/24/2007 - 6:53 PM) -- Started listening for connection requests on port '1337'
(7/24/2007 - 6:55 PM) -- New connection established {1}
(7/24/2007 - 6:55 PM) -- @@BCN
(7/24/2007 - 6:55 PM) -- @@BCJ
(7/24/2007 - 6:55 PM) -- @@w@EYdA@A2@mhttp://www.hablink.net/data/external/vars.txt
(7/24/2007 - 6:55 PM) -- @@X@F@T89049778811486222007
(7/24/2007 - 6:55 PM) -- @@BBu
(7/24/2007 - 6:55 PM) -- @@B@q
(7/24/2007 - 6:55 PM) -- @@B@I

---

It is connecting to my database ... but not starting or stuff. Any help?

Jeax is back?

Quote:

---

Originally Posted by Qurb

@ kuidjesjors - None have battle ball ... and if they clame to .... they making up shit... or their server is shit.

@ Jeax - Thanks for the help. I restarted the server and now it does this:



It is connecting to my database ... but not starting or stuff. Any help?

---

That's all perfectly fine, thats just the incoming packetlog. i forgot to disable it :p Feel free to edit the source and stop it from showing all incoming packets if you know any c# :)

The reason it wont login for you if it doesn't is due to the fact it doesn't use the v9 version of logging in and uses SSO instead.

like this: http://ijeax.com/habbo/index.php?client=go2&id=local

Doo Not Spam On This Thread I Report It !

Yea lol... but it dosen't let me register. am i able to use V15/V14 DCR's ??? and ... are you able to use the normal registration on the DCR's or can you only use a SSL loader? If only SSL can you supply one :D

i become to an error xD can u post a tut? xD

only allows SSL Login.

and you'll have to code your own i'm afraid.

its pretty simple though, the logic is just

-- Check password of username = the password in table users
-- Create a random string and put it into the field ssoticket in the table users
-- Echo it into the loader

ta-da.

For an example:
iJeax.com ~ Login
username: jeax
password: irpr0

Quote:

---

Originally Posted by HabbAHotel

Doo Not Spam On This Thread I Report It !

---

Learn English And Stop Beginning Every Word With A Capital Letter.

You think you aren't annoying? If you are such a safety noob fuck off to a habbo.co.uk and keep away from retro.

What about the registration? Can I use the one in the DCR?

no. Registration & login = SSL :)

WTF ???

Wheres the server?
Theres only one server-program and the name of that program is warlord :S
I've been sick of it...

Sorry for my English , im Dutch
[url=http://www.djhabbohotel.nl.tt]Patrick en Tom Productions

[quote=patje007;2478475]WTF ???

Wheres the server?
Theres only one server-program and the name of that program is warlord :S
I've been sick of it...

Sorry for my English , im Dutch
[URL="http://www.djhabbohotel.nl.tt"]Patrick en Tom Productions

ye, but its says error, because its the old version of .net framework

Wow Brill

Quote:

---

Originally Posted by patje007

ye, but its says error

---

Because, either, you don't have NET Framework 2.0 installed or you have not configured your settings.ini file correctly.