update chars set charname = reverse(charname);
update char_look set race = race + 3;
update char_look set race = race - 8 where race >8;
Search found 141 matches
- Mon Apr 03, 2017 9:23 pm
- Forum: Scripting
- Topic: April Fools!
- Replies: 6
- Views: 5113
- Tue Feb 28, 2017 10:40 am
- Forum: Server Setup & Guides
- Topic: Can't find where to download navicat lite
- Replies: 4
- Views: 3815
Re: Can't find where to download navicat lite
You can do everything in mysql workbench that you can do in navicat. However, I find navicat is still easier.
Here's a link to navicat premium: https://www.dropbox.com/s/nz3zh07scetdh ... at.7z?dl=0
Here's a link to navicat premium: https://www.dropbox.com/s/nz3zh07scetdh ... at.7z?dl=0
- Thu Jan 26, 2017 5:59 am
- Forum: Custom Applications and Tools
- Topic: Rare/ex mods
- Replies: 6
- Views: 8475
Re: Rare/ex mods
Why not add both leaping and bounding boots to LL at a drop rate of 0%, then in LL.lua have it check status and add a line for LL on which boots he drops, then onmobspawn set drop rate of the correct boots to the drop rate %, that way it's configurable and more user friendly, plus a better chance of...
- Mon Aug 22, 2016 9:00 pm
- Forum: Server Setup & Guides
- Topic: Server Questions - Residential ISP & Settings
- Replies: 4
- Views: 3903
Re: Server Questions - Residential ISP & Settings
The amount of bandwidth used is of no consequence when it comes to your ISP's TOS. No servers is no servers, regardless of bandwidth used. For that purpose, you open yourself to the risk they may find out, and may not like it. Your missions are stored in a blob, unless you know how to handle blobs, ...
- Mon Aug 22, 2016 3:28 pm
- Forum: Scripting
- Topic: Change items to vendor NPC
- Replies: 2
- Views: 2614
Re: Change items to vendor NPC
That vendor changes their stock based on the nation rankings. If the nation is in 1st place, they will have items 1, 2, 3. If they're in 2nd, they'll only have items 2, 3. And 3rd, naturally, htey'll only have items with 3 at the end.
- Sat Aug 20, 2016 10:02 pm
- Forum: Bugs
- Topic: smn bp crashes
- Replies: 1
- Views: 2162
Re: smn bp crashes
In ability_state.cpp you need to add an exception block on ability finish, if target = null then return 0;. They exist in magic_state for spells, but i don't think all of the aiblity_state is done yet.
Edit: it may be in mobutils too, i would check where that ability goes off and look for a check.
Edit: it may be in mobutils too, i would check where that ability goes off and look for a check.
- Sat Aug 20, 2016 9:59 pm
- Forum: Server Setup & Guides
- Topic: Server Questions - Residential ISP & Settings
- Replies: 4
- Views: 3903
Re: Server Questions - Residential ISP & Settings
some ISPs will ban/throttle your connection. This is not a thing you have to worry about. You can run the server with a hundred users on 1.5mbit up. The rest of the stuff is something you really have to figure out on your own with experience in running the server. Everyone runs things differently. ...
- Mon Aug 08, 2016 8:29 am
- Forum: Server Setup & Guides
- Topic: Setup server on 2nd router
- Replies: 3
- Views: 3082
Re: Setup server on 2nd router
You know, you can just disable the DHCP server in any wifi router to turn it into a wireless hotspot. That way you aren't isolated from other machines on the network.
- Tue Jul 26, 2016 2:05 pm
- Forum: Custom Applications and Tools
- Topic: Renamer
- Replies: 5
- Views: 8546
Re: renamer
That is neat, good job. Now do it native from the server! If only...
- Tue Jul 05, 2016 5:14 pm
- Forum: Server Setup & Guides
- Topic: Domain instead of IP?
- Replies: 2
- Views: 2672
Re: Domain instead of IP?
depending on your isp, ip's generally don't change often. I run into it maybe once a year.