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

Quote:

---

Originally Posted by Quackster

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?

Hey Alex,

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

Code:

---

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.

Quote:

---

Originally Posted by Leon

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 ;)

Quote:

---

Originally Posted by wy479

Thats a long list ;)

---

It sure is. :):

Quote:

---

Originally Posted by Pure

Hey Alex,

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

Code:

---

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? :D:

Quote:

---

Originally Posted by Quackster

English please? :D:

---

I think he means something like this:

PHP Code:

---

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?

Quote:

---

Originally Posted by Quackster

English please? :D:

---

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

lmfao

Quote:

---

Originally Posted by Jenna Doe

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

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).

Quote:

---

Originally Posted by gammer123

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.

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

Anyway, nice updates, looks promising. :)

Quote:

---

Originally Posted by Caustik

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?!?!

Quote:

---

Originally Posted by Quackster

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

---

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

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

Code:

---

########
# 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})

---

Code:

---

(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

---

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