Sierra ~ Java // Netty // MySQL // BoneCP // Plugin System (Like Bukkit!)

[Bui]

Reset my repository. Why? I left a lot of un-need garbage in it. (I also got a bit pissed how I saw my repo on another forum without a mention of my name)

https://github.com/Quackster/Sierra

There is a README on how to run Sierra without the source. However, there is a link to Pure's video on how to set up with the source!

https://github.com/Quackster/Sierra/...ter/README.txt

And within the /dist there is an API folder. Worry about that later as I have documentation to write!

What about SierraCMS?

[Pure]

Hey Alex,

Line 71, https://github.com/Quackster/Sierra/...HabboUser.java

Sierra.getDatabase().ExecuteQuery("UPDATE members SET rank = '"+Rank+"', gender = '"+Gender+"', figure = '"+Figure+"', mission = '"+Motto+"', credits = '"+Credits+"' WHERE username = '"+Username+"';").execute();

This should be limited to one row only.

[wy479]

Quests, events, games, guide help, room saving information, friend stream, mod tool, placing wall items and changing state of items in the room? Also groups too?

Thats a long list ;)

[Leon]

Thats a long list ;)

It sure is.

[Quackster]

Hey Alex,

Line 71, https://github.com/Quackster/Sierra/...HabboUser.java

Sierra.getDatabase().ExecuteQuery("UPDATE members SET rank = '"+Rank+"', gender = '"+Gender+"', figure = '"+Figure+"', mission = '"+Motto+"', credits = '"+Credits+"' WHERE username = '"+Username+"';").execute();

This should be limited to one row only.

English please?

[Leon]

English please?

I think he means something like this:

public void SaveData(String key, String value, String Username) {

        try {
            Sierra.getDatabase().ExecuteQuery("UPDATE members SET `" + value + "` = '" + key + "' WHERE username = '" + Username + "';").execute();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    } 

Might be wrong though?

[Jenna Doe]

English please?

Sierra.getDatabase().ExecuteQuery("UPDATE blablablabla LIMIT 1;");.....

lmfao

[Pure]

Sierra.getDatabase().ExecuteQuery("UPDATE blablablabla LIMIT 1;");.....

lmfao

Yeah! This, because you are only ever going to have one row with that username you should LIMIT 1. Because it won't go crawling through the rest of the data. Looking for another row with that username

[Mininova]

Looks nice, but i want to try it myself but got the error:
String Index out of Range = -2

Has someone the RIGHT Habbo.swf (nothing more :D).

[Quackster]

Looks nice, but i want to try it myself but got the error:
String Index out of Range = -2

Has someone the RIGHT Habbo.swf (nothing more :D).

There is a special way you need to enter with Sierra. I'll post it on Git soon.

[Caustik]

Will you be implementing some sort of DAO system into this?

Anyway, nice updates, looks promising. :)

[Quackster]

Will you be implementing some sort of DAO system into this?

Anyway, nice updates, looks promising. :)

I can't just implement it without even knowing about it first?!?!

[Caustik]

I can't just implement it without even knowing about it first?!?!

You're Quackster, of course you can?!
Unless you arent...

[Quackster]

Just to let you know people do get a mention if they want to help out.

also u liek mai sexy startupz?

Updates

- Recoded the startup. Was messy and horrible under detailed.
- Recoded a few other classes. MessageEvent, each category of packets are registered under it's own category now.
- You can now choose how to format the startup of dates. Etc. If you want to.

The configuration will get larger as development goes on.

Config

########
# MySQL
########

mysql.host=localhost
mysql.user=root
mysql.password=lulz
mysql.database=sierradb

#########
# Server
#########

game.port=1232

##########
# Logging
##########

date.format=HH:mm:ss MM/dd/yyyy
date.syntax=({date})

(18:53:23 08/11/2012) [SIERRA] >> #######################################
(18:53:23 08/11/2012) [SIERRA] >> ## Sierra - Habbo Hotel Java Server
(18:53:23 08/11/2012) [SIERRA] >> #######################################
(18:53:23 08/11/2012) [SIERRA] >> ## Author: Quackster (quackster.net)
(18:53:23 08/11/2012) [SIERRA] >> #######################################
(18:53:23 08/11/2012) [SIERRA] >> ## Thanks: matty13, Zak, Joopie,
(18:53:23 08/11/2012) [SIERRA] >> ##         Garrison, Shynoshy
(18:53:23 08/11/2012) [SIERRA] >> #######################################
(18:53:23 08/11/2012) [SIERRA]
(18:53:23 08/11/2012) [SIERRA] >> Connecting to MySQL...
(18:53:23 08/11/2012) [SIERRA] >> MySQL connection successful.
(18:53:23 08/11/2012) [SIERRA]
(18:53:23 08/11/2012) [SIERRA] >> Cached [48] room models
(18:53:23 08/11/2012) [SIERRA] >> Cached [122] catalogue categories
(18:53:23 08/11/2012) [SIERRA] >> Cached [122] catalogue pages
(18:53:23 08/11/2012) [SIERRA] >> Cached [2563] furniture entries
(18:53:23 08/11/2012) [SIERRA] >> Cached [2850] catalogue itemss
(18:53:23 08/11/2012) [SIERRA] >> Cached [9] frontpage categories
(18:53:23 08/11/2012) [SIERRA] >> Cached [5] fuserights
(18:53:23 08/11/2012) [SIERRA] >> Cached [11] filtered words
(18:53:23 08/11/2012) [SIERRA]
(18:53:23 08/11/2012) [SIERRA] >> Creating API instance for componenets
(18:53:23 08/11/2012) [SIERRA] >> API success!
(18:53:23 08/11/2012) [SIERRA]
(18:53:23 08/11/2012) [SIERRA] >> Loading API assemblys...
(18:53:23 08/11/2012) [SIERRA] >> Loaded 0 API instances!
(18:53:23 08/11/2012) [SIERRA]
(18:53:23 08/11/2012) [SIERRA] >> Loading Socket Factory...
(18:53:23 08/11/2012) [SIERRA] >> Server started on port 1232

[Mininova]

This is good, because it looks very nice and i want to Try it :)