Useful Queries - Revision history

Teo at 00:28, 2 December 2019

2019-12-02T00:28:32Z

Teo: SQL query to mail an item to all characters on the entire server

2018-12-25T00:33:23Z

SQL query to mail an item to all characters on the entire server

Teo: /* Expansion icons */

2018-01-16T03:37:31Z

‎Expansion icons

Teo: /* Expansion icons */

2018-01-16T03:36:21Z

‎Expansion icons

Whasf: Add expansion icons information

2018-01-16T00:06:41Z

Add expansion icons information

Teo at 19:56, 11 April 2017

2017-04-11T19:56:35Z

Teo: Add password reset query

2015-11-15T09:55:27Z

Add password reset query

Lautan at 03:04, 12 November 2015

2015-11-12T03:04:42Z

Lautan: Created page with "== Find All Mobs Without Pets ==

 select mobid, mobname, mob_pets.pet_offset  from mob_spawn_points  inner join mob_groups on mob_spawn_points.groupid = mob_groups.group..."

2015-11-12T02:23:41Z

Created page with "== Find All Mobs Without Pets == <pre> select mobid, mobname, mob_pets.pet_offset from mob_spawn_points inner join mob_groups on mob_spawn_points.groupid = mob_groups.group..."

New page

== Find All Mobs Without Pets ==

<pre>
select mobid, mobname, mob_pets.pet_offset
from mob_spawn_points
inner join mob_groups on mob_spawn_points.groupid = mob_groups.groupid
inner join mob_pools on mob_groups.poolid = mob_pools.poolid
left join mob_pets on mob_pets.mob_mobid = mob_spawn_points.mobid
where mob_pools.mJob IN (9, 14, 15, 18) and mob_pets.pet_offset IS NULL;
</pre>

@@ Line 9: / Line 9: @@
 INSERT INTO delivery_box (charid, charname, box, slot, itemid, itemsubid, quantity, extra, senderid, sender, received, sent)
    SELECT chars.charid, chars.charname, 1, 0, ItemIdHere, 0, 1, NULL, 0, 'The MHMU', 0, 0 FROM chars;
 </pre>

@@ Line 3: / Line 3: @@
 <pre>
 UPDATE accounts SET password = PASSWORD("NEW_PASSWORD_HERE") WHERE login = 'ACCOUNT_NAME_HERE';
 </pre>

@@ Line 48: / Line 48: @@
 </pre>
-It's a decimal representation of multiple bytes. Lets look at them in binary, where it's all on/off (one and zero):
+It's a decimal representation of multiple bytes. Lets look at them in binary, where it's all on/off (one and zero):<br>
-= 0000111111111110 (everything except the "Not Used" bits)
+so our default value of 4094 = 0000111111111110 (everything except the "Not Used" bits). You can use almost any calculator to swap between these formats if you need to.

← Older revision		Revision as of 03:36, 16 January 2018
Line 47:		Line 47:
	10000000 Bit7 - Not Used - Future expansion		10000000 Bit7 - Not Used - Future expansion
	</pre>		</pre>
		+
		+	It's a decimal representation of multiple bytes. Lets look at them in binary, where it's all on/off (one and zero):
		+	4094 = 0000111111111110 (everything except the "Not Used" bits)

@@ Line 20: / Line 20: @@
 <pre>
 select mobid, mobname from mob_spawn_points where mobname LIKE '%\_s\_%' and NOT EXISTS (select * from mob_pets where mob_mobid + pet_offset = mobid limit 1);
 </pre>

← Older revision		Revision as of 09:55, 15 November 2015
Line 1:		Line 1:
		+	== Resetting an account password ==
		+
		+	<pre>
		+	UPDATE accounts SET password = PASSWORD("NEW_PASSWORD_HERE") WHERE login = 'ACCOUNT_NAME_HERE'
		+	</pre>
		+
	== Find All Mobs Without Pets ==		== Find All Mobs Without Pets ==

@@ Line 8: / Line 8: @@
 left join mob_pets on mob_pets.mob_mobid = mob_spawn_points.mobid
 where mob_pools.mJob IN (9, 14, 15, 18) and mob_pets.pet_offset IS NULL;
 </pre>