物品发送脚本

admin

<?php
function Connect () {
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
! ~& t% l  s, P5 K- x9 }& ^. _/ O
Failed.');
. i# C  Q* _1 i) Z}
9 Q! f  F1 k, p5 ?4 X3 R# G$ QConnect();
7 f2 a6 M# i2 z1 T% i0 v
- r( K( g4 r  p) S# k6 W$ tfunction InitForm(){
1 {+ E% m1 `5 W" A6 e//layout for the form
" F+ s' q4 q) x" Wecho "<strong>Send Items.</strong>
<form name='select' method='post'>
2 V* X9 n6 l! ?3 R: f% y" `<lable>Character Name</lable><br/>
<input type='text' name='char'/><br/>
/ `8 B/ {$ B; c: p( ]<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
<input type='text' name='item_name'/><br/>
6 G* V; ^8 ?6 y* p* [8 L" o3 A<lable>Item Amount</lable><br/>
2 u7 @7 h7 p% N  j) C  O<input type='text' name='item_amount'/><br/>
# x. Z8 ^# Y  x" P4 m) O<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
2 x  G. Y. r, P' B8 _<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)

</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
5 J& h1 }( z3 ^# k, T<input type='text' name='element_upgrade'/><br/>
<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
1 j) n$ x' z# Q" D4 u$ V3 Q! I<input type='submit'/>
: N: \9 A' s8 U% f: X</form>";
}
% W9 c) d  _2 q; q) [
function PostListener (){
//Add more post variables if needed and add them to initform() function aswell
; f: K5 w! l% F* q& l, m( z: k! P% }
################################
! h8 {# Y( c+ t! H& T##### Connection and Post ######
. M3 ]/ G2 [6 ^4 p& D* r################################
$name = @$_POST['char'];
$ItemName = @$_POST['item_name'];
/ |" c( {: S: y- j" `$ItemAmount = @$_POST['item_amount'];
' V* [8 j: w- T$ItemId = @$_POST['item_id'];
  Q% z7 E# I* b$ z; P$ItemUpgrade = @$_POST['item_upgrade'];
$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
* x0 |" |3 d! j2 v; P  N$ \7 q$ItemPierce = @$_POST['item_pierce'];
################################
0 L4 I/ E" K& K8 y
& ?: ^" N- n2 \) S1 ]$ a//Check both variables for empty value

+ G( ?) e( z% I) yif (!empty($_POST['char'])){
$ @7 z8 J7 ]. H' n7 X& y( W$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

0 v5 v9 O1 ~' {" O* Hm_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
8 v# S2 X1 C8 T( o* A1 D, _5 s! Uecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
0 y7 t& Y; Q3 M. H) {' ]
' v1 V% a5 l6 J5 y- l3 w[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
+ n' ?. [/ S: F, R4 g6 h
$ b* y2 K; u7 S" S6 Q) r) m[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
8 J; K; C. q; y! h5 f2 Z- Y
1 [+ c. P! W5 G1 S- nN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
5 K  q( Y% d" |; G* o
+ S$ |9 m( h8 x% j+ u- |'{$ElementUpgrade}', '{$ItemPierce}');");
}

+ Z  r3 e6 R. a2 p' X$ m2 X}

}

. ]% S0 ^6 T; z1 S7 U+ C) q$InitForm = InitForm();
4 V: \; g9 L# X# B4 M$Listener = PostListener();

% c4 b+ Z2 Q2 i?>

1 _$ e6 o4 Q3 ^- m) u) f& k: Y


# y$ @# K: \. ~7 m! I% S' D' u