|
|
<?php& g; J J+ A! `/ F/ j
function Connect () {
3 V/ |+ C+ n3 @1 p5 O! _% y' E& zmssql_connect('Server','UserName','Password') or die('Error: Connection to DB
6 Y1 }( K6 N% V$ Z& o v/ b! ^$ u- t) |' I% P
Failed.');( Q1 s# K8 w6 O9 j r( D
}# C. [8 ]/ m' ^
Connect();
2 w6 F: S- \3 e) {" N7 g
' i- S Q9 K9 q& Cfunction InitForm(){+ ^5 ]4 u3 V0 N# s) p0 Q
//layout for the form
7 s- r% e& ^- x, Hecho "<strong>Send Items.</strong>0 @7 g$ J. q6 j q* @
<form name='select' method='post'>. [2 k b4 c4 y, j6 C
<lable>Character Name</lable><br/>6 y) ]* u% n" \! E$ F6 v( q
<input type='text' name='char'/><br/>( R4 [+ @' p) i$ W+ x: Y& @
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>) m9 f4 a/ s4 B, B
<input type='text' name='item_name'/><br/>
1 ?4 u5 Z; z Z' `. `2 B& Q<lable>Item Amount</lable><br/>. y% E R1 P8 s! q4 u7 F# u1 K( k
<input type='text' name='item_amount'/><br/>
6 e5 ~5 M- c! t3 i<lable>Item Upgrade Amount</lable><br/>
6 |+ |4 w2 h: V- @4 ^- g, K<input type='text' name='item_upgrade'/><br/>! I( e' p$ n( Z4 D" H
<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
8 B3 D% u- T9 J& }, x. Z; I) O5 V; G. j5 g4 w
</lable><br/>5 }) r/ R! `: R* P* ?& w
<input type='text' name='item_element'/><br/>$ C3 k( {/ s6 l* }
<lable>Element Upgrade Amount</lable><br/>" B, z1 n- I0 ?9 Y2 b1 k
<input type='text' name='element_upgrade'/><br/>
: `( h' U3 f9 z6 d* U' ^& p/ l" i<lable>Pierced Amount</lable><br/>; V+ S; a/ B r; [& A k: R
<input type='text' name='item_pierce'/><br/>' m$ O& L: |0 S8 `, T
<input type='submit'/>3 {5 _3 \8 g+ x X/ O z
</form>";
( V5 G1 b, n. x* |% i7 ?}- `$ D! |+ J3 l& [+ \7 I, n
% d6 b( ~; y$ G/ D
function PostListener (){. ^8 e" I! [+ {$ u% B* Z+ c0 `
//Add more post variables if needed and add them to initform() function aswell
5 @& P& A! k! W4 t6 Z6 L- v6 T* [0 b9 r4 Y; J# y
################################0 d5 V+ ^3 m3 r6 I
##### Connection and Post ######
, Q+ C7 U9 Y) R v0 H' ]: t: l$ c################################
& V4 S, C) h- @) M. x$name = @$_POST['char'];" L) p, X: x% v8 F; z* v1 T
$ItemName = @$_POST['item_name'];6 h' H4 ]& N; b# @3 _; r
$ItemAmount = @$_POST['item_amount'];/ N, ]0 e0 c! V. `7 `: P: F
$ItemId = @$_POST['item_id'];* i' {) f6 F3 N( P: T( j
$ItemUpgrade = @$_POST['item_upgrade'];
6 Q" g, u/ n4 K$ Z* b$ItemElement = @$_POST['item_element'];) q5 ?, D& }3 f2 Q* }( P
$ElementUpgrade = @$_POST['element_upgrade'];
X2 M2 w, `* a6 n. ]$ j! K$ItemPierce = @$_POST['item_pierce'];5 G- R3 i$ v, I
################################
/ y b: p7 d8 S5 N0 |: N7 {9 @7 D: T4 j6 k6 a4 C- F1 B
//Check both variables for empty value
Z9 K1 P6 Q( u: r1 v6 h; s ?1 G7 N1 L8 x
if (!empty($_POST['char'])){
/ r! U5 G* e1 n3 b4 I$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where * M& Y# k4 J; }! S6 ?, M% d j
% E! g* [2 b5 J" r. [0 e' I. v1 z- Dm_szName = '{$name}'");! x: P# X" x$ V# ~) M
while ($row = mssql_fetch_object($find)){
1 J& f8 P* P( Y: \+ X7 Xecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";! I3 h/ m. G! \* A$ u, N
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
. l- u1 g3 E5 L) A. [
' J3 K g S; U5 \[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
* a' w( G$ x3 Y& L. m- m; X" l! {+ w; ?8 Z. P5 L% @! Y
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', & `# T( {; D; @: H
3 a- R0 _8 |- I
N'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
* }) p7 T# S! x% g% X* @( {; d0 h9 y, c2 E7 v/ _
'{$ElementUpgrade}', '{$ItemPierce}');");; a" E; f9 F9 ^( ^$ t
}
8 U" z0 K' f& y H6 i! G" u( L& H* c- V, j# S
}
: R4 y1 a7 r# W& U/ ^+ m. F2 v% ]; E: r/ b( W
}
6 P0 f @+ Y: j- j
! ~0 y& p! A0 ?% w0 a$InitForm = InitForm();" @ h8 W" C) E8 `7 L
$Listener = PostListener();
8 ]1 G8 {* {- k9 M
: @) M9 P& b* b?>7 M- h9 j, \( t3 B
5 F8 P8 B1 ^ N6 E' p2 q7 B
- i9 Q8 Z2 t2 F- u$ V2 h. M
# t: _5 t" Y$ }( Q% V, }* S$ K/ g8 S
|
|