|
|
<?php
- b m# Q! {6 N5 Y& z5 X" nfunction Connect () {
8 u1 U' {* D' j2 s) v7 ?8 dmssql_connect('Server','UserName','Password') or die('Error: Connection to DB + W' j( J; q8 m: D; N% [
u- c; B( O+ X6 q% G iFailed.');
. I0 Y/ T' p! ^' I D" @2 x}
. v! n- K) e/ v2 z: g5 {Connect();0 u# o; V; ?! r
7 }2 Z6 G s$ W% U. i$ m
function InitForm(){ d! S3 Q, u& }7 u
//layout for the form
2 {8 L* G4 X$ m/ `+ wecho "<strong>Send Items.</strong>
6 r. e3 Z f/ [5 z8 B<form name='select' method='post'>0 A$ G/ }7 s" L, B- ~) P
<lable>Character Name</lable><br/>
0 `+ b! s8 J5 u! X e. R<input type='text' name='char'/><br/>
; E7 l( r$ g; T<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/># E, p7 h3 O! q- H
<input type='text' name='item_name'/><br/>
9 O' w5 Z4 B, F8 Y2 W6 B2 ?# H<lable>Item Amount</lable><br/>* k, E& m) L1 h% o& ^+ G- m" Z7 U
<input type='text' name='item_amount'/><br/>
t( ?- h1 ^# h: E8 G) }: V8 ~<lable>Item Upgrade Amount</lable><br/>
. p5 p9 K9 |* ]: T<input type='text' name='item_upgrade'/><br/>
( E* o5 G. W9 K$ |- `8 f G<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
8 f- b5 w; [+ C, k* ]" c
* e# d" I9 @+ B5 h# l, I% {</lable><br/>
8 B% G. `9 I1 }' n! b* m<input type='text' name='item_element'/><br/>
6 y- E+ f: H/ x$ K$ b9 U<lable>Element Upgrade Amount</lable><br/>, c! K! _% z. o: c* S
<input type='text' name='element_upgrade'/><br/>
, b4 l F* ~' Q! {, H% E2 e<lable>Pierced Amount</lable><br/>& b0 y) @7 g! ?: r) X- A# S" I6 a
<input type='text' name='item_pierce'/><br/>8 |0 j! w9 J% ]
<input type='submit'/>7 @9 U8 }! J! M" M0 S4 @; m8 q
</form>";
* Z; C- c6 t: |/ B' K3 f, y8 g}. d) T" r8 K; m$ q: Q' z* Q
9 }! C( d# n9 d( x" tfunction PostListener (){
( c) ~- {$ ~# _/ Q( E' M" c//Add more post variables if needed and add them to initform() function aswell6 O: P7 B& ?3 N1 B# b" i
; J2 v0 H( u( P+ @3 X& M################################+ i, W( ? q7 f: x; Q8 B/ I
##### Connection and Post ######
8 z, s/ L7 k5 q7 |; T* X& p& O################################% y* b3 a" p" P2 a8 G
$name = @$_POST['char'];5 n0 m% ^9 T9 a1 v# d- n
$ItemName = @$_POST['item_name'];
# k, Z5 N2 w: |* l: G$ItemAmount = @$_POST['item_amount'];
5 [4 y5 W+ V1 H& n$ItemId = @$_POST['item_id'];
& |4 b. J/ |: @5 n$ A. j. @6 e. m$ItemUpgrade = @$_POST['item_upgrade'];2 k' }2 o/ x# X c, s, F* G
$ItemElement = @$_POST['item_element'];( e% o! R; G% w
$ElementUpgrade = @$_POST['element_upgrade'];
' `) e" E; r, v- y o: Y1 ^* b$ItemPierce = @$_POST['item_pierce'];
& f- Q U; v0 G1 w, {################################
; W/ [$ T3 N. W$ t* i) D
5 [/ G' {7 S9 I0 N9 N: L; [$ X. N//Check both variables for empty value
+ d/ }6 ?. o% v8 a8 H7 X' {2 j2 N
; p; e, ]% C& Aif (!empty($_POST['char'])){# S _4 t+ j" G$ M/ o5 z$ A. ?
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
; u: X. f- S( F" c0 T" @0 X; ]) o( N9 k d$ }
m_szName = '{$name}'");, V# M H( ^. K
while ($row = mssql_fetch_object($find)){+ `0 Y1 i& p! q! Z* @* Z) }& \
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";% P9 g4 t' W, h
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
8 L, }4 Z, ^6 z& N- t- [" r2 `# G# J! @' S, }+ Q* p6 T
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
; B4 O6 u: s/ P. D7 k# [
0 i7 x. L/ Y+ s$ I! k[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
0 n# @' e; w! `# j8 z/ Q
6 b" D+ o! ?/ U5 D- xN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', S8 M2 W1 O: \7 a8 l' Q; g
+ U$ V% a) j/ y, `# z0 h
'{$ElementUpgrade}', '{$ItemPierce}');");
, t( p# X* [' E, Y5 L W. C+ m}
) ?: D9 G5 P6 u: W% ?. Y( l+ z5 |1 a2 t4 a8 ]
}
& t1 j- e- {0 d5 ~6 i" }, {
/ B/ I+ i" J1 y5 K; @}. n. W% I# }3 H8 B* `6 m" y+ S% V- ]6 N
# O/ n8 u Q' _# w* ^# @4 e$ Z
$InitForm = InitForm();
" `6 [, |* Z: I$Listener = PostListener();
6 O3 F; |2 O7 l9 k! \
+ u2 p' S! h6 h4 [: S?>
$ g% `( x9 W3 S% n9 t
; D8 S8 U! E& z m8 x
( o! J0 v0 \* D" f% `% |4 Y9 P. }2 h! X
+ w, F1 j/ B5 x0 h+ ~
|
|