Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-23-2012, 06:20 PM
Julesx
Sarnak
 
Join Date: Sep 2008
Location: winston
Posts: 35
Default Help with Sql commands

First off i'm completely new to running my own server but i'm attempting it to appease my wife so please bear with me.

Trying to do a global item scale of all equips/item by like 5x there normal stats
ex str/sta/agi/dex/int/wis/cha resists and so forth. What would be the commands to do this via Sql. Looked all over can't find any help with these other than mob scaleing.
UPDATE npc_types SET ac = level;
UPDATE npc_types SET mindmg = level;
UPDATE npc_types SET maxdmg = level + 1;
UPDATE npc_types SET str = level/2;
UPDATE npc_types SET sta = level/2;
UPDATE npc_types SET dex = level/2;
UPDATE npc_types SET agi = level/2;
UPDATE npc_types SET wis = level/2;
UPDATE npc_types SET _int = level/2;
UPDATE npc_types SET cha = level/2;
UPDATE npc_types SET mr = level/2;
UPDATE npc_types SET fr = level/2;
UPDATE npc_types SET cr = level/2;
UPDATE npc_types SET dr = level/2;
UPDATE npc_types SET pr = level/2;
UPDATE npc_types SET hp_regen_rate = (level/10);
UPDATE npc_types SET mana_regen_rate = (level/5);

But this makes server entirely too weak. Lol forgot to back up database and had to do fresh install again. So could def use explict dirrections or link to a guild with eqemu sql commands. http://www.w3schools.com/sql/sql_update.asp Doesnt help me much considering i don't know what fields to even type in or how to 5x the stats. Any help much appreciated.
Reply With Quote
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 03:45 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3