[RELEASE]PHP Scripts

Page 2 of 2 1 2
02/01/2011 13:38 zargon05#16
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?
02/01/2011 13:42 -Infamy-#17
I downloaded it like a week ago, is it any newer than that?
02/01/2011 13:45 zargon05#18
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.
02/01/2011 22:20 AriezOMG#19
Prof, think you can release your res script on here?
02/02/2011 13:06 ProfNerwosol#20
Quote:
Originally Posted by AriezOMG View Post
Prof, think you can release your res script on here?
I did. Here is the link.

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

It's the 2nd version. This one shows detailed summary about every processed character at the end.
04/15/2011 19:30 cobraecks#21
Quote:
Originally Posted by ProfNerwosol View Post
@ 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:

Code:
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,
06/24/2011 14:05 remnikalija#22
how can i put 1000 AP for ressurection from site so te resurrect from side need 1k AP
11/29/2012 11:09 Devine Souls#23
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.
11/29/2012 12:45 Truth1010#24
Quote:
"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)
11/29/2012 18:55 Devine Souls#25
Quote:
Originally Posted by Truth1010 View Post
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.
02/27/2014 02:52 Devine Souls#26
on the pvp script I get a error:
Quote:
Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\pvp\pvp-rank.php on line 10
idk how to fix it..
Page 2 of 2 1 2