[Release] SQL-Based Rs Server Server Download

[Brandon]

ORIGNIAL POST BY: meiscooldude

SQLSCAPE

Yup, that

 

[laurens]

Re: Recommended: SQL-Based Rs Server Server Download

nice is there anyway to add more bank room?

 

[SiK]

Re: Recommended: SQL-Based Rs Server Server Download

You can only save 50 bank items currently ( im working on making it 100 )

Think that answers your question.

 

[Jare]

Re: Recommended: SQL-Based Rs Server Server Download

Edited version of cheezescape... can you specify which Cheezescape edit?

 

[Brandon]

Re: Recommended: SQL-Based Rs Server Server Download

Edited version of cheezescape... can you specify which Cheezescape edit?

Not even sure...As of right now we just needed a server that had an SQL base...we plan to modify it to something more stable/realistic.

 

[Jare]

Re: Recommended: SQL-Based Rs Server Server Download

Ah I see. Cheezescape has a fairly seperated database. That definatly makes it a prime candidate for a SQL server anyways.

 

[Destine]

Re: Recommended: SQL-Based Rs Server Server Download

erm, can i request the MODs not to upload in erm sites like rapidshare or megaupload? coz some of us, like me cannot get to download it for some reasons be it using free or etc, i can reccommend u

To view the content, you need to sign in or register

it comes free,upload's free and everyone can download =) hope u take this request off mine, and upload there lol, coz i cannot download it from rapidshare XD

 

[Jare]

Re: Recommended: SQL-Based Rs Server Server Download

erm, can i request the MODs not to upload in erm sites like rapidshare or megaupload? coz some of us, like me cannot get to download it for some reasons be it using free or etc, i can reccommend u

To view the content, you need to sign in or register

it comes free,upload's free and everyone can download =) hope u take this request off mine, and upload there lol, coz i cannot download it from rapidshare XD

Don't over download and or don't use a proxy.

 

[dupie121]

Re: Recommended: SQL-Based Rs Server Server Download

when i try to runserver i get this error :

'Running' is not recognised as an internal or external command, operable program or batch file.
Exception in thread "main" java.lang.NoClassDefFoundError: Server

i have executed the db files and edited the "lifescapeserver.java" file to my my database username and password..

plz help thx

 

[K34nu]

Re: Recommended: SQL-Based Rs Server Server Download

I quite like this idea. But as soon as its updated more.. I'd really love a SQL version of Runescape, like the actual servers. (yeah, thats how they do it) But i'm worried about all of the... Erm.. Lack of feautres maybe?

Can you list if it has all the skills enabled?.. Or... Better - Anything that it doesn't have. Thanks in advance!
-Keanu

 

[bored292]

Re: Recommended: SQL-Based Rs Server Server Download

yo i'm getting the same error as dupie121

anyone know why? :S

 

[dupie121]

Re: Recommended: SQL-Based Rs Server Server Download

4 people have tried that exact tutorial, 2 of which are experienced in databases and this doesn't work, they get errors, either the guide isn't saying everything which needs to be done or files maybe corrupt or something, if anyone got this working can you please post a guide on how you got this going

"string user name and password" as in the root and pass for MySql ?

any help greatly appreciated ~Dupi3~

 

[iJonno]

Re: Recommended: SQL-Based Rs Server Server Download

Mmm .. I tried doing my own MySQL server a while ago ..
Can anyone guess what happened? Thats right .. Nothing ;]
I really don't understand. Maybe someone make a more detailed TuT with pictures for the less experienced with MySQL.

Not saying your TuT is extremely bad .. Its quite good but not understandble if you ask me. But excellent work with the SQL part. You saved our lives.

Jonno'

 

[ThuGie]

Re: Recommended: SQL-Based Rs Server Server Download

Well i took a look at the sql side of the server it aint that pretty
Here are some samples on how to increase the speed of the server

ResultSet rs = s.executeQuery("SELECT * FROM ipbans WHERE bannedip='"+connectedFrom+"'");

As you can see this is taken from SqlScape without changing it
It looks up if a ip is banned
Now so far i know the ip sould only be listed in the ban list 1 time
So why not use LIMIT 1
If you got 2000 bans or something it useless to let the query run a check on all 2000 while the ip might be on the 1 row
Second i also see that only bannedip is needed so why use *
When you fix it up you get this

ResultSet rs = s.executeQuery("SELECT bannedip FROM ipbans WHERE bannedip='"+connectedFrom+"' LIMIT 1");

Easy change big diffrentse in speed .
Now i also see the function does a double check first the check is done by mysql,
Second the function checks it

String ss = rs.getString("bannedip");
	if(ss.equals(connectedFrom)) {

Although that doesnt take alot of speed i would recommand changing it.

Ofcourse not only the ban check can be updated .

 

[adidishen]

Re: Recommended: SQL-Based Rs Server Server Download

when i try to runserver i get this error :

'Running' is not recognised as an internal or external command, operable program or batch file.
Exception in thread "main" java.lang.NoClassDefFoundError: Server

i have executed the db files and edited the "lifescapeserver.java" file to my my database username and password..

plz help thx

yo i'm getting the same error as dupie121

anyone know why? :S

you have to compile your server.
running is not recognised blablabla is because someone forgot to use echo before the running:winky:

 

[Sc00by22]

Re: Recommended: SQL-Based Rs Server Server Download

I can't compile it says its an unrecognized command

 

[general snipe]

Re: Recommended: SQL-Based Rs Server Server Download

connected YAY!
Starting SQLscape on port :43594
ERROR LOADING (ItemList) : Table 'lifescape.zitemlist' doesn't exist
config\objects.cfg: file not found.
Summoning: Loading monsters from Summon.cfg ...
Summoning: Loaded 25 monsters from Summon.cfg!

that is what i get when i run it,

 

[ThuGie]

Re: Recommended: SQL-Based Rs Server Server Download

connected YAY!
Starting SQLscape on port :43594
ERROR LOADING (ItemList) : Table 'lifescape.zitemlist' doesn't exist
config\objects.cfg: file not found.
Summoning: Loading monsters from Summon.cfg ...
Summoning: Loaded 25 monsters from Summon.cfg!

that is what i get when i run it,

You forgot to add the sql files to your database.

 

[general snipe]

Re: Recommended: SQL-Based Rs Server Server Download

ya i did put my database like the readme said to, only the 2 files

 

[ThuGie]

Re: Recommended: SQL-Based Rs Server Server Download

maybe you didnt do it correct?