[Request] auto resurrect UM's

[AriezOMG]

Me, I love anything that's given to me free to help my server

[ShaiyaUnited]

Believe me or not try out your self.



User: GuestTest
Pass: 123456

=) Enjoy

[il.mane]

well check our one too then lol
aswell to check it u need to create an acc in our server (), download the client () kill a UM and ress it whit this
and ppl can res their toons for free

[ShaiyaUnited]

hehe nice one .. mine was just a test..


Edit: Allright im going to relase mine soon with sample theme. create your own if your good designer. =)
[don't think il.mane will relase his]

[ProfNerwosol]

If you're going to use parts of mine, please give creadits. That's all I ask.

[AriezOMG]

Parts of yours? But yours isn't even released. >.<

[abrasive]

Originally Posted by ProfNerwosol

Actually it'd be easier to write it in SQL as a procedure than PHP. The difficulty lies in checking for free slots. There's a built in function in PHP that does it for you, but I can't find one in SMSE. Writing it by myself proved itself to be difficult.

Btw, I might release the script at some point. Kingdom is closed. For now, members of my group can have a look at it.

You can check for free slots like this:

SELECT MIN(Slots.Slot) FROM
(SELECT 0 AS Slot UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4) AS Slots
LEFT JOIN
(SELECT C.Slot
FROM PS_userdata.dbo.Users_Master AS UM
INNER JOIN PS_GameData.dbo.Chars AS C ON C.UserUID = UM.UserUID
WHERE UM.UserUID = 1
AND C.Del = 0) AS Chars ON Chars.Slot = Slots.Slot
WHERE Chars.Slot IS NULL

For a single user account it returns the minimum open slot, or nothing if all five slots are full for that account.

I wrote it based on what the structure of the database looked like, and assumed things such as Char.Del would be 1 if a character was deleted, etc. I've not tested in a resurrection stored procedure.

[ProfNerwosol]

I don't fully understand how but it works. Thank you 'abrasive'. I am going to use it in a procedure.

[lilprohacker]

...

[AriezOMG]

Tell me how to use that and i'll <3 you forever o.o

[ProfNerwosol]

Originally Posted by Apocalypsist

Parts of yours? But yours isn't even released. >.<

It was to ShaiyaUnited. He's in my group.

[ShaiyaUnited]

Yap =)

[joins.dj]

mmm

[zargon05]

I think i have found a way to auto-rez, i'll look into it and tell u guys further.

EDIT: I am wondering do u want to a way to allow UM toons to be alive as soon as a the account is relogged or you are looking for PHP script?

[Linxis172]

As much as i hate myself for not being a coder and feeling so stupid when reading HTML and PHP :P I would really want this made easily public. But remember, you can always have a resurrection email :P Does take work but make a resurrection GM who is in charge of that. Thats what my loser mind would do o.o