Thread: Sql Scape!

SQLSCAPE

Yup, thats right, a server that stores information in a MySQL database !!

I basically took an edited CheezeScape source and made it run with SQL.

[Only registered and activated users can see links. ]


Positives:

- many servers can use the same database, making it easy to have a "sister" server
- suspected to be faster than normal .txt file saving
- allows you to edit characters and weapons away from the host computer
- Banning is now much more secure
- if your good, you could create a php website to let your players view their highscore

Negatives:

- You can only save 50 bank items currently ( im working on making it 100 )
- Your server is more vulnerable to TRUE hackers (don't worry... prolly not anyone here)

NEED TO KNOWS :

if you use portforwarding, you must forward the port.... 3306 to allow you and other people to edit the database away from the host computer

INSTALATION: ( just the jist of it )

1. Set up your MySql 5.0 or 5.1 Server.
-Write down your Username and Password, you will need them for later.

2. Set up SQLyog.
- Just follow the installer.

3. Execute the file called DB.sql & db_itemlist, located at "/source/!!!! OPEN ME !!!!/db/DB.sql"
- To do this , you need to open up SQLyog and connect to your new MySQL server
- Click the Execute Batch File button.
- .. i hope i don't have to say much more.

4. Edit Lifescapeserver.java
- look for " String username = "username";
String password = "password"; "

- Replace the "username" with your username
- Replace the "password" with your password

5. Compile / Run



You will need these programs :

[Only registered and activated users can see links. ] // the actual database
[Only registered and activated users can see links. ] // allows you and "others" to edit the database


THANK YOU FOR YOUR PATIENCE

If you get any errors PLZ tell me.