• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Lua Move items from slot to bp/depo.

Sort by date Sort by votes
Three Magic said:
By dragging them?
Click to expand...

Oh great idea, login into 10000 accounts, 14000 characters and dragging item on each character.
Anyway, you need passwords to all accounts, and its encrypted ;/
Can you do that for me?

Srlsly...
I want to move items of EVERYONE, not my one fucking character, because of bug. Mages and knight were using weapon for paladin. So i need to move it back to bp or depo.
I changed movement that mages now cant equip that weapon, but some players still has it equiped.
Any sql query that will delete record with item from x slot, and add item with the same id to the same player id in another slot/bp or deposit?

If you don't fucking understand, maybe that will help:
If player get item with ID in arrow slot, query/script or whateva will move that item to backpack/depo, or remove that item, and create it in bp/dp...
God, i can't explain it better. If you still playing idiot with post like @up, or do not understood. Shutdown your internet connection and go kill youself and die in hell motherfucker.

Btw. I hate support here. Are ppl here idiots or something? I wrote about every character, and they give me advice like "drag them"...
Or my latest question, for query that will create records of skills for players that exist but has no skill record in database. And someone write stupid query that will chage existing skills to 10, without thinking about that, the record of skills fucking doesn't exist...
Anyway. Fuck you all, and sorry for that. Just too much idiots which didn't read and think.
 
Upvote 0 Downvote
You should try asking nicely. Cussing at people and saying fuck in almost every sentence will get you nowhere.
And for your problem it should be on your database on Player_depotitems.

Delete the line and that should do it.
Otherwise edit the item that you are having problems with to the correct state you want it in and leave it alone

I hope my answer was the most unhelpful ;)
 
Last edited:
Upvote 0 Downvote
Powtreeman said:
You should try asking nicely. Cussing at people and saying fuck in almost every sentence will get you nowhere.
And for your problem it should be on your database on Player_depotitems.

Delete the line and that should do it.
Otherwise edit the item that you are having problems with to the correct state you want it in and leave it alone

I hope my answer was the most unhelpful ;)
Click to expand...

If i ask nicely, noone read my post, or just they are too stupid to understand simply post...
I now how i can fix it. If item exist in playeritems, delete it and add to player depo items table, with the same player id.
But oh my fucking god. Do it manually for 10000 characters. Are yo crazy? I know exacly what i want, but i don't know how to formulate sql queries, so, i ask for them here...
But no one on otland can help in this i think.
Only answers like do it by dragging item or mannually change over 10000 records in database...

Anyway, i solved this problem in other way, that was stupid, but it works now... Thanks for most unusefull support board on the internet.
Im goin out now from this shitty forum. Cya.
 
Upvote 0 Downvote
Back
Top