|
|
<?php
) ^& o/ s( B% Z0 R, G# E1 p- ~2 A4 Bfunction Connect () {7 k! o! p; ]$ V
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB ( P3 s$ \# P) g, J2 t- W& D
# i$ x( T/ c! H0 e6 D4 AFailed.');. y' h: d7 a* f$ v3 a* p
}0 w5 U% ~. f; J& s" Z; n8 u
Connect();
w3 X$ _- D" M* x( h4 n' R. \* X3 d8 g/ E) T1 `+ f, e
function InitForm(){
& ~! |; _7 ?/ h( g//layout for the form
% T. f3 ?2 p( z+ l1 hecho "<strong>Send Items.</strong>
! R6 E- C1 ]: ]' ]; m* E# y<form name='select' method='post'>
+ N- P q# @7 y# ?! u+ g<lable>Character Name</lable><br/>4 M2 j2 [8 ^, G' o; c9 p
<input type='text' name='char'/><br/>
8 U7 C! X4 X) |6 w/ W<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
8 D9 u3 X9 ]( H<input type='text' name='item_name'/><br/>" i {" d0 j% ~5 Y) Q/ {+ ]% H
<lable>Item Amount</lable><br/>
' h, j1 F- N" A1 g* h" y<input type='text' name='item_amount'/><br/>$ `. b, K; h& l
<lable>Item Upgrade Amount</lable><br/>
9 \; m) M/ S I+ H3 ~<input type='text' name='item_upgrade'/><br/>; Z1 d& r3 m O! r9 E# h! m& J
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)$ a. G1 s6 f0 n. g F
9 u4 G" h' d& s1 g0 W8 n+ q</lable><br/>
& K7 x6 Z# N+ C* E- N+ g$ n- b$ ~<input type='text' name='item_element'/><br/>8 P' I4 N" q( k. F! |% X8 K
<lable>Element Upgrade Amount</lable><br/>! w! d2 w% J9 @) D* W4 k) b# T, y
<input type='text' name='element_upgrade'/><br/>
4 n: ?+ v# V' o3 [7 ~<lable>Pierced Amount</lable><br/>
) ?, K8 u# d1 f<input type='text' name='item_pierce'/><br/>; X# Z' H. i! j; n! ~) Q3 r. S" R
<input type='submit'/>
4 \+ u! |6 y7 _$ m: V0 X</form>";" w: I5 } y0 F
}
7 X; x) W+ ?: e4 g4 F: C
. ?1 n4 n" H" H. qfunction PostListener (){5 l, d. U( |) F- W" G( t$ m. v
//Add more post variables if needed and add them to initform() function aswell
0 H/ q v, v$ p; z
2 O4 s5 q" N4 a; j! ]################################
# Z% ^8 Y0 p/ H( ]# x6 z! Q- W##### Connection and Post ######$ t5 j0 g0 J; e4 L$ k
################################
8 L6 ^& Q6 r0 y' L! W, Q$name = @$_POST['char'];
$ {% Z9 y! z9 `+ ?/ W( {4 L$ItemName = @$_POST['item_name'];3 ^0 x9 D7 K# x0 y' X9 q$ h3 Z1 b
$ItemAmount = @$_POST['item_amount'];- |: j/ I9 q$ w0 L
$ItemId = @$_POST['item_id'];
8 @' p7 {5 d& s1 K3 h7 `$ItemUpgrade = @$_POST['item_upgrade'];, `( ^9 `" P) n) j9 g9 S# u& D
$ItemElement = @$_POST['item_element'];' s% r w- ?$ V6 ]! O: w7 s" r3 ~
$ElementUpgrade = @$_POST['element_upgrade'];9 F4 I: s# V O h7 J6 }2 Z& c& `
$ItemPierce = @$_POST['item_pierce'];: Q. z' c. L7 ^& C" A- D" _* x
################################! U! L" d$ G% Z- B
/ C H2 c" c0 ]# K# E
//Check both variables for empty value
" u9 a6 T" A% f3 r) J1 \1 t) l' o: ~
if (!empty($_POST['char'])){
# q, a) W) ?3 d7 E7 G w$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where
: e( n: M+ y9 x; R; x! p2 B
$ k# W5 x0 y# n' fm_szName = '{$name}'");% p8 K( A& b/ @7 ^ O; f
while ($row = mssql_fetch_object($find)){
; h+ x6 _$ k" h' e' Uecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";8 X' \7 N7 M! a4 D" a5 U6 j
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], - H7 i& f1 `- Z/ ?1 g: F% k: c
$ h: m) n0 ~5 J& v
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
8 ^5 g7 J: C. z( z
2 c' X5 j3 R2 j[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
2 q+ N3 D9 H, R
6 t0 h" N) k6 R; u& `& RN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ( ]3 }+ S# W' X
: {! ]+ M' O/ h( Z2 Z
'{$ElementUpgrade}', '{$ItemPierce}');");
1 o- A3 V6 e2 _& g}
& t% S- a. j0 W2 ^5 D4 l. u! f |* _2 L8 z3 q! `# u
}3 W- J1 U% _, S2 ]6 i! A
, |, H4 Q2 U9 T" O
}5 M0 P4 n" v" _4 x. e- j' ?3 v8 J# a& w/ W
_2 e5 \( O& s2 r/ [$InitForm = InitForm();, j2 P e0 |: m8 H4 ~$ X U
$Listener = PostListener();
. v& u: B4 `$ t' f9 j, r* u
, W) x( |0 v+ ^9 x3 Y3 v. J?>
8 L8 F( E. L- d6 n
$ a9 N; j9 a& J9 M8 \2 ~5 v
& O. Y: x$ j! R0 b4 e: ^. d' ?( u4 n3 O' g
0 P# d9 l9 t0 _6 C4 X' | |
|