[question] WEB & Querys

[B13.]

hello,
is it possible to make a query works throw my website
like if i want to reset all players position to jangan but i don't wanna open my SQL. can it be done throw my website ?
if yes how ?

[​Exo]

I am not so good at web stuff but as far as I remember php had a function called mysqli_query for this purpose.

Edit:: Yes here's a reference from W3Schools

PHP Code:

<?php
$con=mysqli_connect("localhost","my_user","my_password","my_db");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

// Perform queries 
mysqli_query($con,"SELECT * FROM Persons");
mysqli_query($con,"INSERT INTO Persons (FirstName,LastName,Age) 
VALUES ('Glenn','Quagmire',33)");

mysqli_close($con);
?>

[B13.]

can't understand how the query works :/
what if i want the player to be able to reset his own chr position to jangan .
shouldn't be a button for him to press ?
thx for your reply Exo.
still need more explanation..

[AceSpace]

Originally Posted by B13.

can't understand how the query works :/
what if i want the player to be able to reset his own chr position to jangan .
shouldn't be a button for him to press ?
thx for your reply Exo.
still need more explanation..

Uhm I would use what Exo posted, ps; i have no knowledge when it comes to PHP.

PHP Code:

<?php
$con=mysqli_connect("localhost","my_user","my_password","my_db");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

// Perform queries 
mysqli_query($con,"UPDATE SRO_VT_SHARD.._Char SET LatestRegion = 25000, PosX = '1021.903', PosY = '-32.60888', PosZ = '489.0886', AppointedTeleport = 2094");
// To reset a single players' position, put where Charname = @charname or whatever
// However the query above will change the position of all the players to a place in jangan, (I randomly chosen one from database).

mysqli_close($con);
?>

[KoKsPfLaNzE]

btw sro is mssql, so mysqli_query will not work thats for mysql=)

you have to use mssql_query, or better PDO =)

[B13.]

thx all,
but how to execute that query i mean if i just loaded the page it will be executed by it self or what ?