物品发送脚本

admin

<?php
. b& L; h; a! H  ffunction Connect () {
% t! W+ x: s& f( g& `: C1 `mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
! M$ s" }. u6 j! F9 ?* U
Failed.');
8 x, q- P; }  n6 Y9 E}
Connect();
- X. I9 m8 p; S0 x  {
function InitForm(){
//layout for the form
0 ^: e/ W6 R" n/ ^6 @- d# S# xecho "<strong>Send Items.</strong>
8 j4 [1 f+ S. B& ?: d<form name='select' method='post'>
<lable>Character Name</lable><br/>
+ j1 G$ S) W+ J7 C$ A<input type='text' name='char'/><br/>
0 ]: u0 X1 @' U) v! x/ k<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
0 G5 L9 T# a/ R<input type='text' name='item_name'/><br/>
<lable>Item Amount</lable><br/>
1 m/ G4 o. o# U  L/ n/ g0 w<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
<input type='text' name='item_element'/><br/>
6 }4 ~0 `4 V9 e1 C<lable>Element Upgrade Amount</lable><br/>
<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
# k" m8 X: M3 h& r1 W) q0 g<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
</form>";
}

function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
# v  j! h8 y2 O# \8 L
################################
##### Connection and Post ######
* `( Q# f9 |; j) p- v################################
$name = @$_POST['char'];
4 T$ m$ F6 |8 p: A4 O9 ~  J/ r$ItemName = @$_POST['item_name'];
$ItemAmount = @$_POST['item_amount'];
$ItemId = @$_POST['item_id'];
$ItemUpgrade = @$_POST['item_upgrade'];
& c6 f0 R9 ]0 ~; R  q$ItemElement = @$_POST['item_element'];
/ m/ Z& K: E2 M/ ~- N1 y5 f+ b1 X$ t$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
8 b: A" \, @7 a) h$ R8 X( I# d) `+ J################################
5 F" e0 x- G8 ?
$ J8 i" F7 N. D4 {' _: ]//Check both variables for empty value
& Q! D( N, H/ A/ c- a
8 E- O) z/ Y+ F' O" [' c: Rif (!empty($_POST['char'])){
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

m_szName = '{$name}'");
% D- d5 s4 X9 ^3 lwhile ($row = mssql_fetch_object($find)){
+ e" a1 p! o& P3 A& y7 E* ~# Mecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
/ Q$ j7 K) f  q7 A$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
& b* ]4 Q; U2 E4 o: S6 a, u
) j  v; ]! K* h9 U. D$ U[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
, @* E4 x. x5 `4 X( H
* x8 J$ E+ Q; P- V[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
- p$ P4 i' [$ R3 d
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
2 n  z: j; x0 v' \, x3 {
, U. F0 S1 V" p& @'{$ElementUpgrade}', '{$ItemPierce}');");
' ~' j8 p& e9 X}

$ n! }3 @- F+ E# j3 k$ Y+ L; b}
) A2 }& J8 y* `
}

$InitForm = InitForm();
! w4 F) U: ^6 r: Y4 P$Listener = PostListener();

5 @4 X9 t, c# @! }: [2 s?>

9 \9 ^  b! Q* j& X