Register for your free account! | Forgot your password?

You last visited: Today at 20:53

  • Please register to post and access all features, it's quick, easy and FREE!


[Release]Unstick Character (PHP)

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2011
Posts: 286
Received Thanks: 70
Post [Release]Unstick Character (PHP)

Add this HTML code in a website
Code:
<form method="post" action="unstick.php">
<table>
<tr>
<td height="43">
Username: </td><td width="30px"></td><td><center><input type="text" name="username" value="" /></center></td>
</tr>
</table>
<input type="submit" name="submit" value="Unstick!" />
</form>
Create a file called "unstick.php"
Code:
<?php
	// MySQL Connection
        // Enter your MySQL information here
	$con = mysql_connect("localhost","root","password");
	if (!$con)
	{
		die('Could not connect: ' . mysql_error());
	}
	mysql_select_db("*YourDatabase", $con);
     
	 // The lines below checks to see if the character even exists
	$obj1=mysql_query("SELECT COUNT(*ColumnForNameOfCharacter*) FROM *CharacterTable* WHERE Name='$_POST[username]'");
	
	$row = mysql_fetch_assoc($obj1);
	
	if(mysql_num_rows($obj1) > 0)
	{
		// The line below, set accounts to whatever table holds the info of where your character is in the world. Also change MapID, MapX and MapY to whatever is in your table.
		
		mysql_query("UPDATE *ChangeToCharactersTable* SET MapID = '1002', X = '250', Y = '250' WHERE *ChangeToColumnForNameOfCharacter* = '" . $_POST['username'] . "'");
	}
	else
	{
		die("Character doesn't even exist.");
	}

	mysql_close($con);
	header("location:*Change to whatever page you want to go to after the script is run. Ex: http://127.0.0.1*");
?>
What this does is that the user visits the html page right? They then enter in their in-game name. If it exists, good for them, it teleports them to a location in TC. If it doesn't, it'll tell 'em so. If you want to edit things around that's cool, but this is just a basic layout. What you MIGHT wanna do, is add some security in there because if you just add what I gave you, anyone could enter ANY accound name and have them "unstuck".



xBlackPlagu3x is offline  
Thanks
2 Users
Old 09/29/2011, 20:07   #2
 
elite*gold: 0
Join Date: Nov 2009
Posts: 785
Received Thanks: 405
Useful post.
Keep up the good work mate.


F i n c h i is offline  
Old 09/29/2011, 20:31   #3
 
elite*gold: 0
Join Date: Jan 2011
Posts: 286
Received Thanks: 70
Quote:
Originally Posted by F i n c h i View Post
Useful post.
Keep up the good work mate.
Thanks Finchi!
xBlackPlagu3x is offline  
Old 09/29/2011, 21:13   #4
 
elite*gold: 0
Join Date: May 2011
Posts: 1,769
Received Thanks: 755
Maybe a password check or you can teleport other players ^^


BaussHacker is offline  
Old 09/29/2011, 21:14   #5
 
elite*gold: 0
Join Date: Jun 2010
Posts: 3,408
Received Thanks: 2,024
sql injection is possibel, also you can unstuck other charakters
NotEnoughForYou is offline  
Old 09/29/2011, 21:40   #6
 
elite*gold: 0
Join Date: Jun 2006
Posts: 895
Received Thanks: 477
Its a good basis. The ideal way to do it is to have a login system on the website and have the unstuck option in the user page. So only people with the user and password could unstuck a char. Then ofc you would want to do map checks to check if the user is in botjail etc.
devilsmum is offline  
Old 09/30/2011, 06:06   #7
 
elite*gold: 0
Join Date: Jan 2011
Posts: 286
Received Thanks: 70
Quote:
Originally Posted by xBlackPlagu3x
What this does is that the user visits the html page right? They then enter in their in-game name. If it exists, good for them, it teleports them to a location in TC. If it doesn't, it'll tell 'em so. If you want to edit things around that's cool, but this is just a basic layout. What you MIGHT wanna do, is add some security in there because if you just add what I gave you, anyone could enter ANY accound name and have them "unstuck".
I believe I said something like that. Also as I said this is just a basic layout of what you could do. I personally implemented my idea into a character login panel, it's up to the people who use this to figure it out.
xBlackPlagu3x is offline  
Old 09/30/2011, 11:55   #8
 
elite*gold: 0
Join Date: Jul 2010
Posts: 55
Received Thanks: 11
code server w/o characters be able to stuck.
pwerty is offline  
Thanks
1 User
Old 09/30/2011, 21:38   #9
 
elite*gold: 0
Join Date: Jan 2011
Posts: 286
Received Thanks: 70
Quote:
Originally Posted by pwerty View Post
code server w/o characters be able to stuck.
That would be a really good idea lol but some people just don't have that kind of talent. Luckily, I've never had that problem but I know a lot of people (Especially when using TQ binaries) who have.
xBlackPlagu3x is offline  
Old 09/30/2011, 22:13   #10
 
elite*gold: 0
Join Date: May 2011
Posts: 1,769
Received Thanks: 755
I don't even get how you can get stuck in the first place.
BaussHacker is offline  
Old 09/30/2011, 22:17   #11
 
elite*gold: 0
Join Date: Nov 2009
Posts: 785
Received Thanks: 405
Quote:
Originally Posted by BaussHacker View Post
I don't even get how you can get stuck in the first place.
You would get stuck if you'd try to swim in bird island.
F i n c h i is offline  
Old 09/30/2011, 22:23   #12
 
elite*gold: 0
Join Date: May 2011
Posts: 1,769
Received Thanks: 755
Quote:
Originally Posted by F i n c h i View Post
You would get stuck if you'd try to swim in bird island.
Oh stuck like that. I thought it was like others. Pfft, if people can't avoid that in a source, then they shouldn't even run a server.
BaussHacker is offline  
Old 10/03/2011, 03:12   #13
 
elite*gold: 0
Join Date: Jan 2011
Posts: 286
Received Thanks: 70
Quote:
Originally Posted by BaussHacker View Post
Oh stuck like that. I thought it was like others. Pfft, if people can't avoid that in a source, then they shouldn't even run a server.
Seriously, right? Of if you at least have it in your source, you could at least make an attempt to fix it. Ferserious.


xBlackPlagu3x is offline  
Reply



« [Release] Status Effects [Full] | How to decompiler the start.dat (Login screen) »

Similar Threads
[RELEASE] Character(s) Statistics Query
12/23/2012 - Shaiya PServer Guides & Releases - 4 Replies
What this query does: Calculates a character(s) total statistics and displays them one row per character. What this query does not account for: Skills that passively add attack power. Currently applied buffs and nostrums. Characters with no items are left out of the results of this query. Multiple of the same lapis in a single item (like if an item was GM linked with two or more Craft 7s in it, only one would be counted). Any lapis GM linked to your mount. Anything I forgot to account...
[Release]Log in Game with GM Character?
09/21/2011 - SRO PServer - Discussions / Questions - 0 Replies
Hello, :) GM characters, some people can not log in to the game. I will share:) first: creating a one gm char .. or. sro_gm1 can use the character.
[RELEASE] character unstuck script
04/29/2011 - EO PServer Guides & Releases - 8 Replies
hi all i aim proud to release a character unstuck script i created it whit the help of funhacker (he gave me the info i needed to start creating it , becouse i dint know how i needed to start whit it :P , for the rest is it a complete fresh script) for the rest is it just a simple script where you can input your charname to get teleported back to cronus the script is ready to use on a standart instalation of a server (standart pass/username/db)
New Release Character In Season 3
06/03/2010 - Grand Chase Philippines - 11 Replies
THIS ALL CHARACTER IS RELEASE IN SEASON 3 Amy's 4th Job http://img217.imageshack.us/img217/4892/amyx.jpg http://img709.imageshack.us/img709/7844/amy2.gif Starlet possesses Amy's speed and freedom of movement, allowing for Starlet's attacks to climax both on the ground and in the air. Though shooting a machine gun from the air or firing a cannon from the ground are not acts becoming of an oracle, they're still effective in battle. Since there are no classes that allow a restrained...
[Release] Character form for Acro's new halo release!
02/05/2010 - CO2 PServer Guides & Releases - 9 Replies
Hello everyone, I made an edit of the character form for Acro's new halo system. The new halo system must be added for this to work. I added PK points to this one.... I'm not sure if the other character form has them. :P It didn't have them in the one I had. When you add Acro's halo system the character form will show 1..2..3..4 w/e you put for halos.



All times are GMT +1. The time now is 20:53.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.