|
|
<?php
/ Z$ d) }- [2 E wfunction Connect () {- G* D! Y9 u' [; a1 i5 q* y
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
. K% k$ g; a( O5 C% J) A$ n. i- e6 [$ H6 u
Failed.');
: r. R9 w- O9 ^7 e! J- h}
+ @. c3 N% i& S/ yConnect();
# W1 K8 Q# h4 F9 `& `( X$ M. g; f% N7 U
function InitForm(){
! b9 A, R u5 Z( A//layout for the form
( `7 I% d. R7 Y/ `* s d3 b; t: Hecho "<strong>Send Items.</strong># w' t& d. l. Q9 d8 j! L
<form name='select' method='post'>
+ \& `- ~5 O6 ^% b' v: j<lable>Character Name</lable><br/>
* [. M. N) ^, R$ ?- D6 r7 O<input type='text' name='char'/><br/>/ }: L: i( t- p5 C" \
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>, j$ e* b- A, g# V# d0 u
<input type='text' name='item_name'/><br/>
( L5 Z0 \* h6 l% A6 X4 }<lable>Item Amount</lable><br/>' T2 I+ j! {1 p7 e4 Y0 O7 p7 M# S
<input type='text' name='item_amount'/><br/>( Q# f. r8 R4 B( O% c
<lable>Item Upgrade Amount</lable><br/>+ q* F) y6 s1 ~* A
<input type='text' name='item_upgrade'/><br/>
( v6 Z. X6 F4 V! g9 \* Y+ @<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)- J1 u6 T% z) B
$ A5 v. n' b1 Y" H
</lable><br/>
1 ?8 R0 |/ ^6 R& h. j7 g4 ]( H+ M. w<input type='text' name='item_element'/><br/># ^! ^3 K2 N! g
<lable>Element Upgrade Amount</lable><br/>; i+ @, v% J5 E
<input type='text' name='element_upgrade'/><br/>
* X, k% Y1 G- c: H<lable>Pierced Amount</lable><br/>
4 z$ t# Y5 t7 y2 X' q; i<input type='text' name='item_pierce'/><br/>& b& t9 V0 o4 s* B: [! x5 o
<input type='submit'/>8 W2 K2 F$ s& ]
</form>";
0 Y3 U- F' ]3 w5 Y7 `: t( w3 |; x}
, Z8 d) t/ t( ]2 b* D; ~& F x) w% I+ S" L7 |1 j% O
function PostListener (){
6 S. R* ^/ p' F I0 z, ~9 o//Add more post variables if needed and add them to initform() function aswell l2 n$ x n2 o. q
9 q# E7 H% F5 V' ?6 o) r+ g- R################################ A1 t2 e) b$ M2 f& h6 }. V
##### Connection and Post ######/ n0 ^/ A* z' v$ b$ O2 D
################################0 _5 b' F. H# d$ ~6 Q
$name = @$_POST['char'];, |8 I! H9 k* b+ e7 G2 ~& }
$ItemName = @$_POST['item_name'];
" O6 f& d. G9 k$ItemAmount = @$_POST['item_amount'];
# T0 ?: H+ [7 V, y$ItemId = @$_POST['item_id'];
+ v' o; D: G& X- P$ItemUpgrade = @$_POST['item_upgrade'];- G+ S/ T6 S# p' y3 s7 a1 T6 r
$ItemElement = @$_POST['item_element'];
/ \6 k- ^5 D, O& D8 k% g! @$ d$ElementUpgrade = @$_POST['element_upgrade'];( D; L3 u/ R" N) A
$ItemPierce = @$_POST['item_pierce'];7 k9 w! q" p' V* q4 w
################################: G, ^* V N# z! z& q
9 _4 Z" C. G! e# X9 E6 Y//Check both variables for empty value& G/ |0 M# r, P9 t# E
5 U2 i3 O" u$ n& T) } _" o: v
if (!empty($_POST['char'])){, i+ M: M( S( o- j5 m; I/ S; L
$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where " ], b1 I0 k+ _4 O
, m% j9 A6 {6 l$ Lm_szName = '{$name}'");% {" {) U( H- u% C0 ] I* J
while ($row = mssql_fetch_object($find)){
, x) G; [- J- v' Jecho "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
% e3 u. @9 j: y* W! h$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],
2 V9 q; {# q: d2 | [# [; r4 Z( v/ h7 h7 x/ V: D/ A
[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption], , x7 u7 b" T: F3 g, s
/ g! y3 } X8 r* Z, U
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',
4 L( b$ L, v9 p4 |- @8 o
9 a3 N3 {% n p9 W( V! Z8 j. LN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}', ; t( G9 g) e8 Q1 H
% N' M# J& |2 `8 W
'{$ElementUpgrade}', '{$ItemPierce}');");1 ^! U3 p" }/ c
}
t5 J% C/ U* e+ J1 d1 V
4 A. N1 E- e- g/ C9 u+ ^}
% L! D4 L2 j1 ?5 t. w; \
! v n0 Z9 S( B) z. g1 J9 X; L}
" m8 n1 H8 z7 ^; M* U, _& v- H$ h0 }, w! o
$InitForm = InitForm();
9 D0 r7 i$ a* j& A1 ?$ k$Listener = PostListener();
B0 ?7 U/ B. F( d% p9 J6 E' G1 V5 ^2 Z, \4 V. v4 W
?>8 H! N( K- V7 A* {% C- D2 P
' `/ y" L3 U8 e- N
* [& M( ~) n# G m$ j6 M2 A3 V) N0 W5 C' `
) W' \; l' j: p& D v/ ^ |
|