Is it even possible?

[Believer]

Hello, Is it possible to make an reset that only REMOVES Quests, items, houses AND NOT Skills?
etc. you get hacked on your char which is level 300 and the hacker took everything, every item, every house you had and left it with the skills only.. also, the quests are automaticlly gone like you just created the character except that it is on level 300 with good skills!

-Is there any script for that?

Greatful for answers
Yours Believer:thumbup:

 

[zakius]

delete from player_storage where id = 'playerguid'
delete from player_items where id='playerguid' etc
dont know how you handle the houses, but you should find a way(I belive)(possible that id have another name like player_id, just check it)

 

[Believer]

So you mean i must write down every single id of each item to get everything reseted? xD

 

[chojrak]

delete from player_storage where id = 'playerguid'
delete from player_items where id='playerguid' etc
dont know how you handle the houses, but you should find a way(I belive)(possible that id have another name like player_id, just check it)

>player guid
>apostrophe
>string
>trolling

 

[Cykotitan]

>player guid
>apostrophe
>string
>trolling

l2sqli

 

[Believer]

as far as i understand you guys i should do this in phpmyadmin?

delete from player_storage where id = 'player guid'
delete from player_items where id='player guid'

delete from player_storage where id = 'apostrophe'
delete from player_items where id='apostrophe'

delete from player_storage where id = 'string'
delete from player_items where id='string'

delete from player_storage where id = 'trolling'
delete from player_items where id='trolling'

Please explain what will happens if i execute these in phpmyadmin?

 

[Believer]

Bump

 

[QuaS]

>truncate

 

[Believer]

>truncate

hmm and that is?

 

[QuaS]

truncate table `player_storage`;
truncate table `player_items`;
truncate table `player_depotitems`;
truncate table `tiles`;
truncate table `tile_items`;

maybe houses either

 

[Believer]

truncate table `player_storage`; = removes what?
truncate table `player_items`; = Removes items?
truncate table `player_depotitems`; = removes items in depot?
truncate table `tiles`; = what does this doo?
truncate table `tile_items`; = and this?

PLease explain!!

ALso, this:

delete from player_storage where id = 'player guid'
delete from player_items where id='player guid'

delete from player_storage where id = 'apostrophe'
delete from player_items where id='apostrophe'

delete from player_storage where id = 'string'
delete from player_items where id='string'

delete from player_storage where id = 'trolling'
delete from player_items where id='trolling'

 

[kaffekilla]

Why not just wipe the database?

 

[Believer]

I want the character to reset everything except skills.. lol

 

[kaffekilla]

So..it's like wiping the acc without wiping the skills.. nice.

 

[QuaS]

sotrage = quests.
tiles = map tiles
tile_items = items on map [houses?]
items/depotitem = player items