[Request] Some Queries...

Hello,

I was wondering if someone could make a quick querie for me that would do the following
1. Do a Inventory Wipe on All Char's.
2. Set everyone's level to One.

I would try to learn myself but I don't really want to mess up my database right now. ;3
Thanks in Advance.

Regards,
~Katsuro

umm you might have to do it all by one, i don't know if you can do every single one xD though my php knowledge isn't that great.
Lets see...
Inventory wipe:

Code:

---

DELETE * FROM Item WHERE AID =?

---

that might be Items :P
Set level to one:

Code:

---

UPDATE * FROM Character WHERE AID =? SET Level = 1

---

might be Characters :P
They might not work but they seem right :P
Hope I helped.

Cant you do something like:

Code:

---

UPDATE * FROM Character WHERE level < '99'

---

Lol, Don't mind if that would be a failure. No experience in SQL Queries.
But, Its supposed to be Update the Char table and set level 1 where level is less then 99.
Would that work or not?

As for the Inventory Wipe, Would this work?

Code:

---

DELETE FROM CharacterItem

---

Backup your database first.

The first query is good as long as no one is exactly lvl 99 I believe, but the second query wont work.

Edit: Disregard that.

Delete items in inventory.

Quote:

---

DELETE FROM CharacterItem

---

Sets all players level to 1

Quote:

---

UPDATE Character SET Level = 1

---

Ah, I thought I was close.
Thanks Lambda.

Quote:

---

Originally Posted by Lambda

Delete items in inventory.



Sets all players level to 1

---

rofl thanks, I didnt realize you could do every single one with just one query xD