Guild reset in php

[Speederes]

Hi.

I want guild reseting in php. Please help me.

My code:

<?php
  $con = mssql_connect('*****','***','***');
  mssql_select_db('SRO_VT_SHARD', $con);

	$sql = "DELETE FROM _TimedJob WHERE CharID = 'ID' and JobID = '1'";
    $res = mssql_query($sql,$con);
	if (!$res) {
    print("SQL statement failed with error:\n");
    print("   ".mssql_get_last_message()."\n");
  } else {
    $number_of_rows = mssql_rows_affected($con);
    print("$number_of_rows rows deleted.\n");
  }
	
?>

How can I get the Char Id in logged in player(at the website)?

[sarkoplata]

$char_array = mssql_fetch_array(mssql_query("SELECT * FROM _Char WHERE CharName16='Charname'", $connection));
$char_id = $char_array['CharID'];

(dunno how mssql system work with php, made this for odbc, should be the same)

[Speederes]

I have ODBC But i don't know how work with this.

I copied the code to the my code. But doesn't work.

[sarkoplata]

Dear dude,
Do you want to delete a chars guild penalty?

So I would not give you wrong code

[Speederes]

Yes i want deleting guild penelatly reseting.

<?php
  $con = mssql_connect('*****','****','****');
  mssql_select_db('SRO_VT_SHARD', $con);
    $char_array = mssql_fetch_array(mssql_query("SELECT * FROM _Char WHERE CharName16='Charname'", $con));
    $char_id = $char_array['CharID'];
	$sql = "DELETE FROM _TimedJob WHERE CharID = '$char_id' and JobID = '1'";
    $res = mssql_query($sql,$con);
	if (!$res) {
    print("SQL statement failed with error:\n");
    print("   ".mssql_get_last_message()."\n");
  } else {
    $number_of_rows = mssql_rows_affected($con);
    print("$number_of_rows rows deleted.\n");
  }
	
?>

I give 0 rows deleted. :-/
I have 1 character. But if i have 2 characters? :-/

[sarkoplata]

You want to delete every characters penalty?

[Speederes]

Not.

I or other player logged on the website.
Click to Guild reset and i want delete the guildpenaltly.