[Request] auto resurrect UM's

Page 2 of 3 1 2 3
08/17/2010 00:52 AriezOMG#16
Me, I love anything that's given to me free to help my server :)
08/17/2010 01:28 ShaiyaUnited#17
Believe me or not :) try out your self.

[Only registered and activated users can see links. Click Here To Register...]

User: GuestTest
Pass: 123456

=) Enjoy
08/17/2010 13:01 il.mane#18
well check our one too then lol
aswell to check it u need to create an acc in our server ([Only registered and activated users can see links. Click Here To Register...]), download the client ([Only registered and activated users can see links. Click Here To Register...]) kill a UM and ress it whit this [Only registered and activated users can see links. Click Here To Register...]
and ppl can res their toons for free

:)
08/17/2010 13:22 ShaiyaUnited#19
hehe nice one :D.. 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]
08/18/2010 02:05 ProfNerwosol#20
If you're going to use parts of mine, please give creadits. That's all I ask.
08/18/2010 05:12 AriezOMG#21
Parts of yours? But yours isn't even released. >.<
08/18/2010 05:47 abrasive#22
Quote:
Originally Posted by ProfNerwosol View Post
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:
Code:
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.
08/18/2010 11:31 ProfNerwosol#23
I don't fully understand how but it works. Thank you 'abrasive'. I am going to use it in a procedure.
08/18/2010 14:48 lilprohacker#24
...
08/19/2010 05:45 AriezOMG#25
Tell me how to use that and i'll <3 you forever o.o
08/20/2010 00:19 ProfNerwosol#26
Quote:
Originally Posted by Apocalypsist View Post
Parts of yours? But yours isn't even released. >.<
It was to ShaiyaUnited. He's in my group.
08/20/2010 03:26 ShaiyaUnited#27
Yap =)
01/05/2011 08:03 joins.dj#28
mmm
01/05/2011 13:32 zargon05#29
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?
01/06/2011 06:06 Linxis172#30
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
Page 2 of 3 1 2 3