-
re: Sierra - [Java, R63, Post-Shuffle, Latest Releases, CMS]
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?
-
re: Sierra - [Java, R63, Post-Shuffle, Latest Releases, CMS]
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.
-
re: Sierra - [Java, R63, Post-Shuffle, Latest Releases, CMS]
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 ;)
-
re: Sierra - [Java, R63, Post-Shuffle, Latest Releases, CMS]
Quote:
Originally Posted by
wy479
Thats a long list ;)
It sure is. :):
-
re: Sierra - [Java, R63, Post-Shuffle, Latest Releases, CMS]
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:
-
re: Sierra - [Java, R63, Post-Shuffle, Latest Releases, CMS]
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?
-
re: Sierra - [Java, R63, Post-Shuffle, Latest Releases, CMS]
Quote:
Originally Posted by
Quackster
English please? :D:
Sierra.getDatabase().ExecuteQuery("UPDATE blablablabla LIMIT 1;");.....
lmfao
-
re: Sierra - [Java, R63, Post-Shuffle, Latest Releases, CMS]
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
-
re: Sierra - [Java, R63, Post-Shuffle, Latest Releases, CMS]
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).
-
re: Sierra - [Java, R63, Post-Shuffle, Latest Releases, CMS]
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.
-
re: Sierra - [Java, R63, Post-Shuffle, Latest Releases, CMS]
Will you be implementing some sort of DAO system into this?
Anyway, nice updates, looks promising. :)
-
re: Sierra - [Java, R63, Post-Shuffle, Latest Releases, CMS]
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?!?!
-
re: Sierra - [Java, R63, Post-Shuffle, Latest Releases, CMS]
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... :*:
-
re: Sierra - [Java, R63, Post-Shuffle, Latest Releases, CMS]
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
-
re: Sierra - [Java, R63, Post-Shuffle, Latest Releases, CMS]
This is good, because it looks very nice and i want to Try it :)