[RELEASE]PHP Scripts

[zargon05]

I tried my best in making sure that doesn't, if they still got past it, I am stumped. Just curious are you using the new version?

[-Infamy-]

I downloaded it like a week ago, is it any newer than that?

[zargon05]

I dont think so, The newest one display the possible characters in a tabular format instead of a drop-down. In the table only the chars from the same nation will be displayed.

[AriezOMG]

Prof, think you can release your res script on here?

[ProfNerwosol]

Originally Posted by AriezOMG

Prof, think you can release your res script on here?

I did. Here is the link.



It's the 2nd version. This one shows detailed summary about every processed character at the end.

[cobraecks]

Originally Posted by ProfNerwosol

@ Abrasive

I haven't read into the original script but your optimization will do the same what I had problem with. Meaning my first UM resurrection script resurrected an AoL character on UoF side. You need to check for Country separately with extra checks for Family. Players can change sides if they loose all of their characters.

Country=2 is only when all characters are dead. It means Faction Selection screen.

EDIT:
Here's my solution to this problem:

IF (SELECT Country FROM PS_GameData.dbo.UserMaxGrow WHERE UserUID=@UserUID)<>2
begin
	PRINT 'Player chose faction after loosing all characters. Checking whether new characters exist.'
		-- let's get that new faction and see if it's the same as the last time
	SELECT @Country=Country FROM PS_GameData.dbo.UserMaxGrow WHERE UserUID=@UserUID
	
	IF EXISTS (SELECT * FROM PS_GameData.dbo.Chars WHERE UserUID=@UserUID AND Del=0)
	begin
		PRINT 'Player has new characters. Checking faction.'
		PRINT '----------'
		
		IF (@Family=0 OR @Family=1) AND @Country<>0
		begin
			-- Faction is not the same. Was Alliance of Light is Union of Fury. Character not resurrected.										
			
			INSERT INTO @ResultTable 
				(CharID, CharName, Resurrected, NoFreeSlots, FactionChange) 
			VALUES
				(@CharID, @CharName, 'no', 'no', 'yes');
			FETCH NEXT FROM dead_um INTO
				@UserUID,@CharID,@Slot,@CharName,@Family																										
			
			CONTINUE;
		end
		ELSE IF (@Family=2 OR @Family=3) AND @Country<>1
		begin
			-- Faction is not the same. Was Union of Fury is Alliance of Light. Character not resurrected.
			
			INSERT INTO @ResultTable
				(CharID, CharName, Resurrected, NoFreeSlots, FactionChange) 
			VALUES
				(@CharID, @CharName, 'no', 'no', 'yes');
			FETCH NEXT FROM dead_um INTO
				@UserUID,@CharID,@Slot,@CharName,@Family																										
			
			CONTINUE;										
		end																
	end
	ELSE
	begin
		PRINT 'No new characters detected. Proceeding with standard routine.'
		PRINT '----------'
	end						
end

I was that AoL toon on the kingdom server, and I remember thinking i did something wrong, an you A.K.A. [GM]Tommo said it wasn't my fault. lol

and thank you for this script it will come in handy.

Recycle,

[remnikalija]

how can i put 1000 AP for ressurection from site so te resurrect from side need 1k AP

[Devine Souls]

I downloaded it and when I put in my ip and host and pass all that stuff i get a error "Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\scripts\pvp-rank.php on line 10" does somone know my problem? thanks.

[Truth1010]

"Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\scripts\pvp-rank.php on line 10"

You kinda answered your own question. Look at line 10 of your pvp-rank.php file and see if something doesn't look right there. Most likely a user-name / password / ip that you did wrong.

Also in the future, try not to post in threads that have had no activity for over a year. Make a new thread for help if it's needed, or John will come hunt you down..

Or, try the search (I'm sure I've seen this asked a couple of times in the past, and most likely fixed)

[Devine Souls]

Originally Posted by Truth1010

You kinda answered your own question. Look at line 10 of your pvp-rank.php file and see if something doesn't look right there. Most likely a user-name / password / ip that you did wrong.

Also in the future, try not to post in threads that have had no activity for over a year. Make a new thread for help if it's needed, or John will come hunt you down..

Or, try the search (I'm sure I've seen this asked a couple of times in the past, and most likely fixed)

Right, sorry I didnt realized this thread wasent active.

[Devine Souls]

on the pvp script I get a error:

Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\pvp\pvp-rank.php on line 10

idk how to fix it..