|
|
<?php& Q9 E0 a; ^! e* s( Y( k0 m, V
function Connect () {
% f1 g. L' c$ L) h. \: t/ Z2 lmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
+ l" [2 F( o, M5 n, H8 b6 `1 c- g
4 d6 V8 W0 t# X0 s( NFailed.');6 V& f! |& h( c& W2 z" d* U
}$ _7 I4 y$ B3 l0 u2 |8 ?
Connect();% Z) N( F7 u$ h
# b: D6 J0 [0 V( Tfunction InitForm(){
, m* H; v: N& G9 A//layout for the form F% X/ L. `, z0 |
echo "<strong>Send Items.</strong>: L% Q0 m! l/ ?5 C
<form name='select' method='post'>9 [8 Q4 ?1 r% v
<lable>Character Name</lable><br/>; i) W. |! H! t' g! z, M) g5 J
<input type='text' name='char'/><br/>! I; Z0 e! D# t4 J b# ]' X
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>2 ~) ~9 u4 f0 I) a- o9 z+ C
<input type='text' name='item_name'/><br/># g6 | ~% t7 D8 t; J z
<lable>Item Amount</lable><br/>
/ A0 v. i* E* o# Z- A3 H$ ^4 d$ N0 Y<input type='text' name='item_amount'/><br/>. h6 ?9 X5 k2 ^
<lable>Item Upgrade Amount</lable><br/>
# U/ u2 V* V; @9 w0 V0 T! t# q9 e<input type='text' name='item_upgrade'/><br/>; {* `" K( [: E; b
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
: P( ^/ w; |* r7 o/ q4 D' |
5 v* N" |( y5 V, n' ~4 X</lable><br/>! b$ E o; K0 p0 X1 z
<input type='text' name='item_element'/><br/>
, O5 U6 u" ]. K4 H L0 q9 n<lable>Element Upgrade Amount</lable><br/>
* q3 V5 T$ v# z! ]( a- k/ ]* o' R! W<input type='text' name='element_upgrade'/><br/>
, m. k. \- }3 B, ~3 f<lable>Pierced Amount</lable><br/>
9 D+ {# X" n+ ]( m% m+ T4 s( u<input type='text' name='item_pierce'/><br/>6 r z) v: m3 l
<input type='submit'/>4 I# J }8 m$ J) `6 q% _
</form>";
- R3 E5 t7 ?* W$ a}
2 u7 K0 X2 q. l/ E5 [& O
/ D; U5 x% C$ c* n9 Ffunction PostListener (){
E, H7 }5 x/ G7 b" ~3 N3 k7 A//Add more post variables if needed and add them to initform() function aswell& g T" o j9 `; x, X7 b- m" _3 g
. C- K( n( q4 G5 L' ^4 S, o################################
8 ~8 |" n+ K2 \- Q8 @; h##### Connection and Post ######
( S6 v1 ]" `* H/ K################################& D/ c/ m0 Y* L" o/ X7 l
$name = @$_POST['char'];6 E7 r/ f' g5 K6 ?0 d! u
$ItemName = @$_POST['item_name'];
+ \* D5 H5 u& ?, P' X; t; T8 @$ItemAmount = @$_POST['item_amount'];1 O3 ]9 G* z# }: B- v5 z9 k- T$ O# A
$ItemId = @$_POST['item_id'];8 s# v& U% |5 U' K
$ItemUpgrade = @$_POST['item_upgrade'];
/ E6 R6 A% T% M3 U1 }1 \+ q$ItemElement = @$_POST['item_element'];
: g) f* y m& ? V' y$ElementUpgrade = @$_POST['element_upgrade'];$ m) f9 @# `4 h, ~9 V
$ItemPierce = @$_POST['item_pierce'];1 Y% q6 ?* B7 J: E& }- S
################################/ d/ c; s$ B+ D, J% p4 L
1 C# D; f7 J/ H% K8 P/ F
//Check both variables for empty value
: w; d( l1 c! R8 ^6 w( O5 Z# Q
7 ? Q7 j$ _2 tif (!empty($_POST['char'])){
% q' c# G; i; q) m; a$ y# O/ \$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
0 y" v2 o' a: {2 `! u1 Y: w$ L. J& C
m_szName = '{$name}'");
s8 U& n1 m3 A; Y/ v3 Fwhile ($row = mssql_fetch_object($find)){
. L, {* `3 z+ H4 B+ n' e0 qecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";0 W8 h# p4 Y' Q6 {" p& ^; S
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 0 w2 D7 G, ?' ?, M
/ M1 c+ w6 M- X) ]& _[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
8 }. z. D0 _( D( ?9 c$ p9 f' v. Y! _5 Q2 G3 z
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
/ s Z# w3 ~: B& D8 l L0 }+ I* t6 I! h5 a6 y& f6 A
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
& k8 x& f8 F: d3 g1 l: N8 {7 b$ F( p( d; Y s( V" M( t
'{$ElementUpgrade}', '{$ItemPierce}');");
4 t* e: ` S& k a; M" ]1 K+ \}4 s1 y% ~- [% @2 e E: V7 p* O
. k( Q9 ` F! Z& v" p8 l+ o
}! T0 f+ ~! M0 R0 H& z4 I" ]
- f" L/ C$ [! h8 l8 S- h" n- \- {% `
}
" H$ I- B( F/ ~, ~0 M" i+ t: K5 G6 B* t* K/ d* _/ N
$InitForm = InitForm();- z( R0 ]7 @# p5 A
$Listener = PostListener();
3 O! W6 g9 ~5 ?- u; y3 y/ c- n, G& z& q# B# u' u1 J
?>
+ s4 p% B& `" s
6 ?9 h5 d. h9 N) i. K( I/ I: o( W' X
: ?8 M6 H! f/ y
2 O6 D5 T# S) ]1 \! | |
|