[Question]Adding Dils via POST

gedimazs · 06/27/2009, 00:23

Hi all,

Wanted to ask how to send dils via post. You know the web script when we admins can send items via post, so wanted to ask how to send dils via post, cause when you open letter you can see ammount of dils. It is showing 0. So what the index of dils?
Thx for answering

janvier123 · 06/27/2009, 03:48

download the php control panel in my signature
thats the way to do it

gedimazs · 06/27/2009, 08:51

Quote:

Originally Posted by janvier123

download the php control panel in my signature
thats the way to do it

There are no such adding DILS not coins via POST. I know I have one script but player must be disconected from the server if I want to send DILS. But I want to send DILS not disconnecting people from the game.

Zombe · 06/27/2009, 09:44

Get dill from a chest and then trade them? Or spawn a chest near them? Lol...

gedimazs · 06/27/2009, 10:47

Quote:

Originally Posted by Zombe

Get dill from a chest and then trade them? Or spawn a chest near them? Lol...

That way is known for ages

Ok I see no1 knows how to send DILS via POST.
Ok so then pls close the thread

janvier123 · 06/27/2009, 13:47

trade them o_O ?

caper · 06/29/2009, 04:20

I'm currently writing a php page to send any item via index number through the post. I will also have the option to send dils.

So if you can wait a few days, I should have it posted.

Otherwise you have to do it manually in the db with the user_postbox table. I can help with that if needed but the script should be out in a few days.

Once I get that done, I'm going to mess around with a script to turn a scroll in the inventory to a piece of armor or weapon that has options like slots or noble or divine. I'm not anticipating that one to be easy but I'm going to try anyways.

janvier123 · 06/29/2009, 10:44

money.php

Code:

<?php

require_once "config.inc.php";


if(isset($_SESSION[step2]) && isset($_POST[step2])) {
    //×¢²áµÄ×îºóÒ»²½
    $errorStr = formStep3();
    if($errorStr!=null){
        require_once('money.html');
    }else{
        $success="³É¹¦¸øÕÊºÅ£º$_POST[user_name]¼ÓÈëÓÎÏ·±Ò$_POST[money]DIL";
		require_once('success.html');
		unset($_SESSION[step2], $_SESSION[step1]);
    }}
else {
    //×¢²áµÄµÚ¶þ²½
    require_once('money.html');
    $_SESSION[step2] = 1;	}
	

function formStep3(){
    $errors = array();
    $errorStr = null;
	
//²éÑ¯ÓÃ»§ÃûÊÇ·ñ´æÔÚ
	$strSql1="select * from character.dbo.user_character where character_name='$_POST[user_name]'";
    $character_odbc = odbc_connect('account','DBUSER','DBPASS'); 
    $character_result=odbc_do($character_odbc,$strSql1);
    odbc_fetch_row($character_result);
	$character_no=odbc_result($character_result,1);
	odbc_close($character_odbc);
    if ( $character_no== null)  $errors[] = "ÎÞ´ËÍæ¼Ò£¡";
	
    if (strlen($_POST[money])<1) $errors[]="ÇëÊäÈëÔö¼ÓµÄÓÎÏ·±ÒÊý";
	
    if(!preg_match("/^[0-9]{1,12}$/i",$_POST[money])) $errors[]="ÓÎÏ·±ÒÖ»ÄÜÎªÊý×Ö,×îÉÙÎª1Î»";
    if(sizeof($errors)>0){
       $errorStr .= "<br><font>";
       $errorStr .= "ÐÅÏ¢ÊäÈë´íÎó£º";
       foreach($errors as $error)
               $errorStr .= "<li>$error</li>";
       $errorStr .= "</font><br><br>";
    }else{

    $money_query="update character.dbo.user_character set dwMoney=dwMoney+$_POST[money] where character_no='$character_no'";
    $dk_money_odbc = odbc_connect('account','DBUSER','PASS'); 
    $dk_money_result=odbc_do($dk_money_odbc,$money_query);
	odbc_close($dk_money_odbc);
    }
    return $errorStr;

}

?>

config.inc.php

Code:

<?php

//¿ªÊ¼session
session_start();

//ÉèÖÃ²»½øÐÐ±¾µØ»º´æ
header('Expires: '.date('D,d M Y H:i:s',mktime(0,0,0,1,1,2000)).' GMT');
header('Last-Modified:'.gmdate('D,d M Y H:i:s').' GMT');
header('Cache-control: private, no-cache,must-revalidate');
header('Pragma: no-cache');



?>

money.html

Code:

<strong><font size="2">ÐÞ¸ÄÓÎÏ·±Ò</font></strong><br>
<form method="post" action="money.php">
<?=$errorStr ?>
<input type="hidden" name="step2" value="1">
Íæ¼Ò½ÇÉ«Ãû:
<input type="text" name="user_name" value="">
<br>
ÓÎÏ·±ÒÊý¶î:
<input type="text" name="money" value="">
<br>
<br>
<input type="submit" name="Submit4" value="Ìá½»">
</form>

success.html

Code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>sucess...</title>
</head>

<body>
<h1>sucess</h1>
</body>

</html>

gedimazs · 06/29/2009, 14:14

Quote:

Originally Posted by janvier123

money.php

Code:

<?php

require_once "config.inc.php";


if(isset($_SESSION[step2]) && isset($_POST[step2])) {
    //×¢²áµÄ×îºóÒ»²½
    $errorStr = formStep3();
    if($errorStr!=null){
        require_once('money.html');
    }else{
        $success="³É¹¦¸øÕÊºÅ£º$_POST[user_name]¼ÓÈëÓÎÏ·±Ò$_POST[money]DIL";
		require_once('success.html');
		unset($_SESSION[step2], $_SESSION[step1]);
    }}
else {
    //×¢²áµÄµÚ¶þ²½
    require_once('money.html');
    $_SESSION[step2] = 1;	}
	

function formStep3(){
    $errors = array();
    $errorStr = null;
	
//²éÑ¯ÓÃ»§ÃûÊÇ·ñ´æÔÚ
	$strSql1="select * from character.dbo.user_character where character_name='$_POST[user_name]'";
    $character_odbc = odbc_connect('account','DBUSER','DBPASS'); 
    $character_result=odbc_do($character_odbc,$strSql1);
    odbc_fetch_row($character_result);
	$character_no=odbc_result($character_result,1);
	odbc_close($character_odbc);
    if ( $character_no== null)  $errors[] = "ÎÞ´ËÍæ¼Ò£¡";
	
    if (strlen($_POST[money])<1) $errors[]="ÇëÊäÈëÔö¼ÓµÄÓÎÏ·±ÒÊý";
	
    if(!preg_match("/^[0-9]{1,12}$/i",$_POST[money])) $errors[]="ÓÎÏ·±ÒÖ»ÄÜÎªÊý×Ö,×îÉÙÎª1Î»";
    if(sizeof($errors)>0){
       $errorStr .= "<br><font>";
       $errorStr .= "ÐÅÏ¢ÊäÈë´íÎó£º";
       foreach($errors as $error)
               $errorStr .= "<li>$error</li>";
       $errorStr .= "</font><br><br>";
    }else{

    $money_query="update character.dbo.user_character set dwMoney=dwMoney+$_POST[money] where character_no='$character_no'";
    $dk_money_odbc = odbc_connect('account','DBUSER','PASS'); 
    $dk_money_result=odbc_do($dk_money_odbc,$money_query);
	odbc_close($dk_money_odbc);
    }
    return $errorStr;

}

?>

It is nice that you copied the script that I was talking about that I have, but to send dils with that script player must be disconnected from the server. I don't need it. I want send DILS via POST

janvier123 · 06/29/2009, 14:23

i got a other script that can do that wihout the player need to be offline
its in my sig

gedimazs · 06/29/2009, 15:19

Quote:

Originally Posted by janvier123

i got a other script that can do that wihout the player need to be offline
its in my sig

wich one? if you are talking about Name: Remote Admin PHP Panel so there is no download link. But I think I have it and there is no such script to add DILS (not coins) via POST when player is online.

janvier123 · 06/29/2009, 17:58

thx for telling me

ill put the link back

gedimazs · 06/29/2009, 20:24

Quote:

Originally Posted by janvier123

thx for telling me
ill put the link back

I was right. There is no script for adding DILS via MAIL.

caper · 06/29/2009, 20:28

I'm at work so I can't post it but I got mine working. It uses the stored procedure for sending mail to a player and can send items by index number and dils at the same time to a mailbox. No need to be offline to use it.

Basically if you can work with PHP, you can modify the armor or weapon form in that control panel by adding a dil field and then use this line (may need a tweak or two)

Code:

mssql_query("EXEC character.dbo.SP_POST_SEND_OP '".$_POST['char_no']."','".$gm."',1,'".$text1."','".$text2."','".$_POST['item']."','".$_POST

['dil']."',0",$ms_con);

Otherwise I'll send you a link later.

gedimazs · 06/29/2009, 20:43

Quote:
Originally Posted by caper
I'm at work so I can't post it but I got mine working. It uses the stored procedure for sending mail to a player and can send items by index number and dils at the same time to a mailbox. No need to be offline to use it.

Basically if you can work with PHP, you can modify the armor or weapon form in that control panel by adding a dil field and then use this line (may need a tweak or two)
Code:
mssql_query("EXEC character.dbo.SP_POST_SEND_OP '".$_POST['char_no']."','".$gm."',1,'".$text1."','".$text2."','".$_POST['item']."','".$_POST

['dil']."',0",$ms_con);
Otherwise I'll send you a link later.

I think I'll wait for your link. Cause I'm not so good with PHP