[Help Ascent] Very weird mod needed

[Fentus]

I don't know How to do this but let me describe what I need.

I need a script that will delete every item, IDs 100000 threw 100100 form everyones inventories every week.

This is for like a reward process if they report a bug ill let them buy a reward form a reward vendor and every week the reward will be deleted form everyone inventories.

IF YOU CAN POST A SOLUTION OR A SCRIPT GO FOR IT I NEED THIS DONE.

:technologTHANKS!:technolog

[MentaL]

[Erlend]

i don't understand why you want them to miss their items...

[Fentus]

No no no no, Only "spacific" items will be deleted these items are "temparay rewards" for them.

[rr2739]

No no no no, Only "spacific" items will be deleted these items are "temparay rewards" for them.

i can make a SQL query to do that.

But a script? That will auto delete certain items? like i dont think you realise what you asking.

[Kameleon20]

rr2739... just a sql query to delete the items and attach a batch file wich do it with just a double click ;)
that would be become the closest to what he wants :)

[Fentus]

Will I have to restart the server for this to happen or will it happen instantly in game?
Thats my only dilemma... Still can you post What you have Ill Try it out even if I have to take down server every one month for a down time. That will most likely happen anyways.
Also a batch will be nice I can make those but if you do thats good too.
Thanks!

[aceindy]

DELETE FROM playeritems WHERE entry BETWEEN 100000 AND 100100;
It doesn't work for online players; it only works for people who are offline; (just online chars will be saving current inventory again).

U can use Navicat's build in scheduler to make it run once a week ;)

[Juggalo90]

Yea but they want a script to do it in game without restarting the server...so he wants it to pretty much use the command .remove...
But doing that too all players while they are in game would be so memory intensive it wouldn't be worth it honestly....

[Fentus]

:drinks_noWell Thanks guys this will work pretty well.:drinks_no

[Juggalo90]

If i find a way to do it in scripting ill PM you...
Otherwise it would take ALOT of memory/cpu power to do this...

[Fentus]

Hey can you send my the Batch file info need to do this I can't get it working again... I have an error somewhere.

[Juggalo90]

DELETE FROM playeritems WHERE entry BETWEEN 100000 AND 100100;

[Fentus]

:jester::jester:No The batch file thing to just dobble click and it dose it...:jester::jester:

[Juggalo90]

Oh...
Well im on my Laptop with ubuntu...but err hold on i think i make one for ya real quick =]

Blah linux is gay and i cant make a .bat or .sql with the word processor i got now...and at the hotel internet speed i dont wanna download a dif one XD

[Fentus]

Lolz Np if I don't have it now Thanks though!
Send it anytime

[Juggalo90]

Kk
Ill get it done...either 2morrow night or saturday...just keep me reminded...if u want...u could PM me ur MSN and ill send it over MSN when i get home
it will take 5 min to make

[Juggalo90]

Your welcome
Just edit the tool.bat and the items.sql to your needs
Clickage

[Fentus]

Thanks Man Rep Points for you Much better then I did my 1st time.
only 3 mistakes in my version... lolz
:juggle::juggle::juggle: