DLX Server, Source & SVN 6.5

[xworndownx]

DLX Test Server Release: Build date 2/17/11 - Rev.1

Added a link to the server in the original post. Scripts included.
Added a dlx-readme file with basic instructions/update notes.

Other Notes:
Debug data has been disabled in the console excluding potential major errors and simple lua errors.
It's just as buggy as the current 24/7 server I've been hosting for the past couple months.

So there ya go, download and start your own servers if you like. Run them how you want and good luck. I won't be shutting down the live server unless it just empties out. Which at that point I'll re-install Linux and use it to host the DS server for testing.

Have fun!

P.S: The usual rules apply: If you don't know what you are doing with MySql or installing the server then RTFM & RTFF! ^^

[CherokeeMist]

Aw, this is the first update that I've ever gotten an SQL error on.

Query:
CREATE TRIGGER `account_delete` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN
DELETE FROM `chars` WHERE `acctid` = OLD.id

Error occured at:2011-02-17 14:38:03
Line no.:193173
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE FROM `chars` WHERE `acctid` = OLD.id' at line 2

Query:
CREATE TRIGGER `account_delete` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN
DELETE FROM `chars` WHERE `acctid` = OLD.id

Error occured at:2011-02-17 15:03:26
Line no.:193173
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE FROM `chars` WHERE `acctid` = OLD.id' at line 2

Query:
CREATE TRIGGER `account_delete` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN
DELETE FROM `chars` WHERE `acctid` = OLD.id

Error occured at:2011-02-17 15:20:34
Line no.:193173
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE FROM `chars` WHERE `acctid` = OLD.id' at line 2

[xworndownx]

meh, knew I'd leave something in there behind. Just delete the triggers from accounts and chars tables. Using triggers makes life easier on my end when testing things. I can just delete the account and every character linked to that account will delete as well.

Unfortunately since not everyone will be able to use triggers I went and stripped them out and re-uploaded the server with the new DB files. Link is in the OP.

[xworndownx]

Even though DLX is not working on the PXI server as a group there are still some things I want to do with it as I get the time. These changes are currently only available on the DLX test server that I host.

Updates:

Content: Can not craft HQ items!
-- Introductory Patch.
---- Crafters are now able to create HQ items.
------ The crafting system has been getting an overhaul and a new formula has been implemented.
------ Disabled content: Player direction, crafting gear, day time, day & weather are not currently implemented.

Bug: Stats don't decrease when changing jobs, adding gear then changing again.
-- Patched.
---- When changing your main job stats will reset when gear gets removed.
------ Does not apply to sub job.

Bug: HP goes to 0 or above max when changing jobs. (blacks out)
-- Patched.
---- When changing your job HP/MP should go to 100% of that job's max.

Bug: Can't access mog safe when logging a character into the mog house.
-- Patched.
---- If you logged out in the mog house you should be able to use it w/o changing gear.

Bug: Gear, spells, inventory etc don't always show up when logging in/zoning
-- Test Patch.
---- Cleaned up the code for this. Takes a sec longer for the char to load. I don't advise speed @zoning through areas during the load.

Bug: Crafting skills can go up to 200.
-- Patched.
---- You shouldn't be able to go beyond 100 now.

Bug: You get skillups after max craft skill.
-- Patched.
---- You shouldn't get any more skill ups if the main skill is capped at 100 or if you are +15 above the craft.
------ This should affect sub skills on the same craft.

Bug: @skill command sucks!
-- Patched.
---- "@skill" will now set skills (weapons, evasion, magic etc) to 255 & set crafting skills to 100.
---- When you use @skill it will self disable and you won't be able to use it again.

@skill testing:
All player skills have been reset.

These aren't the droids your looking for!

[CherokeeMist]

Sadly, I couldn't import the pxiah_1 due to a similar error I had before. However, I did get a chance to play your SVN. Something I noticed (that I hadn't in previous versions), Hand-to-hand works, yet it seems the 2nd hit is dependent on the first. If the first misses, the second misses. If the first hits for 11, the second does. If the first is a critical hit, the second is as well.

I also noticed that some mobs (Mainly the Pugils in East Ronfaure) are much stronger than I remember. They would /c as Tough at level one, yet almost any class could solo them with ease.

The main thing I miss from previous versions are roaming mobs. Although, it was buggy and mobs could walk through objects players could not.

[xworndownx]

I'm not sure what program you are using to import the SQL tables. I use navicat and never got any errors. If your not using navicat then well go get the trial and import the tables using that.

Sadly h2h, mobs, and mob roaming are broken features that have been around long before we started working with the source. They are known issues and further bug reporting is not necessary any longer. Mobs can still roam though the feature is just disabled. W/O proper collision checking for mobs they will always walk through walls/buildings which can be very bothersome.

[CherokeeMist]

I was using SQLyog to import them as I had some trouble working with navicat. Are the files within the pxiah_1 vital? I assume it allows a working auction house, but I can't be sure. I had a server running without it imported.

[borfax]

The pxiah_1 is not vital. The AH will not run unless it has been enabled in the script. It has been turned off for your safety
The AH is really buggy and causes too many crashes. This is the main reason it is not enabled. For private servers, it is not very important anyway. I guess if you really wanted to make things interesting, you could add random items to the shops every week.

Good luck with the server.

~Borfax~

[iCath]

Thanks a lot for sharing this fun server. I am new to this and I managed to set it up for solo testing. A couple of questions, I set the level cap at 99 and added required exp in the sqlyog, also modified combat.lua exp section but after LV 76, I could not gain xp. Is there anything else I need to change?
Secondly, I wonder if anyone noticed that if Nin sj rdm and cast utsusemi the mp goes to zero.

Thank you again for all the hard work. I really enjoyed a different way of playing this game

[xworndownx]

Live Test server Updates:

New feature:
-- Partial mob movement.
---- When a player dies/zones/runs out of range the mob should return to it's spawn point.
---- This is how it used to be before SE made mobs disappear. Oh how I miss the Garliage Citadel trains.
---- This is also in a test phase. Animations my not be 100% and the mob can/will go through walls/buildings mountains to get back to its spawn point.

Major Bug Found:
-- Server crashing.
---- Finally found the ***** that was causing 90% of the server crashes.
---- The server is MUCH more stable now.

Zoning Issues:
-- Bug: Player health still goes to 0, skills don't load.
---- While the 1st patch was close this new one should fix things up a bit better.

Hacks and cheats:
-- Exploit: Healing then using @zone can give you perma health regen.
--- Patched.
---- Added in a few checks to disable healing when a person uses @zone.

GM Commands
-- @zone changed.
---- using @zone too fast and too many times has caused player & server crashes.
---- After using @zone # there is a 30sec delay before you can use it again.

Notes:
Remember the @zone is one of those emergency and absolute necessity commands. It does not save your character, your items or anything else when using it.

No ETA on the next public release. The new changes in crafting and the mob movement need time and extensive testing before I get comfortable enough to send it out. If there is enough demand I may disable them and release a build with the bug fix for server crashes.

[varbara]

bug or cheats

1.when you use skill and you log out . server not remember delay skill .*-*

2.when use magic 1 turn kill monster is freeze but monster is dead(No animation) - -.

[CherokeeMist]

Do AF armor quests work? Or do you have an available log of working/non-working things other than the included DLX readme?

[Smashbros]

Can I haz Cheeseburger?

[MASTERXZ]

woooa great updates on the test server thanks again xworndownx and no you cant have a cheeseburger Smashbros (wajaa) lol

[fdurv7]

so is there like a server i tryed to use that program to connect and i cant figure it out