[Request] Some Queries...

[Katsuro]

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

[MentaL]

[wesman2232]

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:

DELETE * FROM Item WHERE AID =?

that might be Items :P
Set level to one:

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

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

[Katsuro]

Cant you do something like:

 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?

DELETE FROM CharacterItem

[Mr.Lucifer]

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.

[Lambda]

Delete items in inventory.

DELETE FROM CharacterItem

Sets all players level to 1

UPDATE Character SET Level = 1

[Katsuro]

Ah, I thought I was close.
Thanks Lambda.

[wesman2232]

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