Xampp:
http://sourceforge.net/projects/xampp/SQW Files:
http://www.mediafire.com/download/brddh ... iCrack.rar
SQW SQL:
http://www.mediafire.com/download/daceo ... /Qileu.sql
Netbeans w/ JDK 7:
http://www.oracle.com/technetwork/java/ ... 32126.html
Hamachi:
https://secure.logmein.com/products/ham ... nload.aspx
X.G Emulator (password is: "boot"):
http://www.mediafire.com/?79xy6cdc2zov6veJava:http://www.java.com/en/download/index.jsp
NOTE: You should already have Java installed, but the link is there, just in case.
The StylinQuest Worlds files do not belong to me. They are owned by Azshurith of the Trilliux forums and I have been given permission to post them here.
Setting up the files:
1. Download all of the files and install Xampp, Java, and Hamachi. Hamachi will make a temporary host for your server until your either portforward or buy a VPS. Java will be needed to run the emulator, unless the server runs via Netbeans. Xampp houses and helps function and shape your server.
2. Dump all of your files into the HTDocs. No need to add the folder it came from, just grab the folders inside and insert it. NOTE: This does not apply if the folder name is called HTDocs. Just add it to the Xampp folder and merge both HTDocs.
3. Go to the configs and edit the IP. Remove the password in the configs (if any). The IP will be the same IP of your Hamachi IP. For example, mine is 5.234.70.46.
4. Go to your emulator folder, go to configs and apply the same treatment to the configs for your server files.
5. Go to
http://localhost/phpmyadmin and add the DB name suitable for your server files, like globalhost or eatl_db.
6. Go to etl_servers, and edit the information. Give the server a name. Then, change the IP to the Hamachi IP you're using.
7. Go to your emulator and check the client token. Go to your database, to etl_settings, and make sure the tokens are the same.
8. Check all .php and .asp files for any changes to IP, DB, or any other line of code that may/will conflict with the creation of your server.
9. Open up your emulator, type the password needed to run it (check the thread of the created emulator for the password), and run the server.
10. Before you publish your server to the public eye, test the server yourself and see if everything is running smoothly.
11. Publish the server where appropriate.
Further Customisation
- Add custom items to your server. You can find people who can offer customs, like myself, or you can make your own if you know how to use Adobe Flash.
- If you're a decent coder, you can customise your own CMS, client, maps and loader. If you cannot code, however, a few forum members who can code can help. They may require you to pay for their services, however.
- If you are extremely good at coding, you can even create your own emulator to run the server.
- Get staff members to contribute in the creation of your server. The more, the merrier.
Coding legendary/guilds to your server:
Add this to etl_servers:
Code:
-- phpMyAdmin SQL Dump
-- version 3.2.4
--
http://www.phpmyadmin.net--
-- Host: localhost
-- Generation Time: Mar 15, 2012 at 11:23 PM
-- Server version: 5.1.41
-- PHP Version: 5.3.1
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `eatl_db`
--
-- --------------------------------------------------------
--
-- Table structure for table `etl_servers`
--
CREATE TABLE IF NOT EXISTS `etl_servers` (
`id` mediumint(6) NOT NULL AUTO_INCREMENT,
`bOnline` tinyint(1) NOT NULL DEFAULT '0',
`bUpg` tinyint(1) NOT NULL DEFAULT '0',
`sName` varchar(60) NOT NULL DEFAULT 'Server',
`sIP` varchar(40) NOT NULL DEFAULT '0.0.0.0',
`iChat` tinyint(1) NOT NULL DEFAULT '2',
`iCount` mediumint(4) NOT NULL DEFAULT '0',
`iMax` mediumint(4) NOT NULL DEFAULT '500',
`sLang` varchar(2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `etl_servers`
--
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Add this to etl_users:
Code:
-- phpMyAdmin SQL Dump
-- version 3.2.4
--
http://www.phpmyadmin.net--
-- Host: localhost
-- Generation Time: Mar 15, 2012 at 11:19 PM
-- Server version: 5.1.41
-- PHP Version: 5.3.1
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `eatl_db`
--
-- --------------------------------------------------------
--
-- Table structure for table `etl_users`
--
CREATE TABLE IF NOT EXISTS `etl_users` (
`id` mediumint(10) NOT NULL AUTO_INCREMENT,
`strUsername` varchar(40) NOT NULL DEFAULT '',
`strPassword` varchar(40) NOT NULL DEFAULT '',
`strGender` varchar(1) NOT NULL DEFAULT '',
`strEmail` varchar(60) NOT NULL DEFAULT '',
`sHouseInfo` text NOT NULL,
`iAccess` smallint(2) NOT NULL DEFAULT '0',
`iAge` smallint(2) NOT NULL DEFAULT '0',
`iCoins` int(8) NOT NULL DEFAULT '0',
`iExp` int(8) NOT NULL DEFAULT '0',
`iFounder` tinyint(1) NOT NULL DEFAULT '0',
`iGold` int(8) NOT NULL DEFAULT '0',
`iLvl` smallint(3) NOT NULL DEFAULT '1',
`iUpg` tinyint(1) NOT NULL DEFAULT '0',
`iUpgDays` smallint(8) NOT NULL DEFAULT '-1',
`iSendEmail` smallint(1) NOT NULL DEFAULT '5',
`iBankSlots` smallint(3) NOT NULL DEFAULT '0',
`iHouseSlots` smallint(3) NOT NULL DEFAULT '20',
`iBagSlots` smallint(3) NOT NULL DEFAULT '40',
`intColorEye` int(10) NOT NULL DEFAULT '0',
`intColorHair` int(10) NOT NULL DEFAULT '0',
`intColorSkin` int(10) NOT NULL DEFAULT '0',
`intColorTrim` int(10) NOT NULL DEFAULT '0',
`intColorBase` int(10) NOT NULL DEFAULT '0',
`intColorAccessory` int(10) NOT NULL DEFAULT '0',
`strHairName` varchar(40) NOT NULL DEFAULT '',
`strHairFilename` varchar(60) NOT NULL DEFAULT '',
`HairID` smallint(8) NOT NULL DEFAULT '1',
`lastArea` varchar(20) NOT NULL DEFAULT 'battleon-1',
`currentClass` smallint(2) NOT NULL DEFAULT '1',
`currentServer` varchar(40) NOT NULL DEFAULT 'Offline',
`dUpgExp` datetime NOT NULL DEFAULT '2012-01-01 00:00:00',
`referredBy` varchar(40) NOT NULL DEFAULT '',
`isReferred` tinyint(1) NOT NULL DEFAULT '0',
`refGold` int(10) NOT NULL DEFAULT '0',
`refExp` int(10) NOT NULL DEFAULT '0',
`refCP` int(10) NOT NULL DEFAULT '0',
`gotReward50players` int(1) DEFAULT '0',
`bHelm` tinyint(1) NOT NULL DEFAULT '1',
`bCloak` tinyint(1) NOT NULL DEFAULT '1',
`bPet` tinyint(1) NOT NULL DEFAULT '1',
`bTT` tinyint(1) NOT NULL DEFAULT '1',
`bWhisper` tinyint(1) NOT NULL DEFAULT '1',
`bGoto` tinyint(1) NOT NULL DEFAULT '1',
`bSoundOn` tinyint(1) NOT NULL DEFAULT '1',
`bFriend` tinyint(1) NOT NULL DEFAULT '1',
`bParty` tinyint(1) NOT NULL DEFAULT '1',
`bFBShare` tinyint(1) NOT NULL DEFAULT '0',
`bPermaMute` tinyint(1) NOT NULL DEFAULT '0',
`registered_ip` varchar(40) NOT NULL DEFAULT '0.0.0.0',
`login_ip` varchar(40) NOT NULL DEFAULT '0.0.0.0',
`monkill` int(11) NOT NULL DEFAULT '0',
`pvpkill` int(11) NOT NULL DEFAULT '0',
`killed` int(11) NOT NULL DEFAULT '0',
`ip0` tinyint(1) NOT NULL DEFAULT '1',
`strQuests` varchar(60) NOT NULL DEFAULT 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ',
`GuildName` varchar(100) NOT NULL,
`GuildID` varchar(100) NOT NULL,
`legendary` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `etl_users`
--
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Client with guilds and corresponding loader:
http://www.mediafire.com/download/d7see ... _Fixed.swf
http://www.mediafire.com/download/xxqh2 ... der_r8.swf
Replace your server's cf-userlogin.php with the php code in this file:
http://www.mediafire.com/download/dagv9 ... rlogin.php
Client token:
XyoForTheSakeIsTheBest
Credits:
- Qileu for maps
- Xyo, Mystical, Alex and Aqua for emulator
- Azshurith for adding a lot of files to the database
- Oracle for Netbeans
- Apachefriends for Xampp
- Logmein for Hamachi
- Java for Java
Hope you find this thread helpful. Enjoy your PS.