|
|
<?php
! E& @/ m: L% pfunction Connect () {. O4 z5 [* N6 q5 S) S: Z% M& c
mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
U4 M; @, X4 ? _: }0 W2 Z
1 M5 A( A5 Q1 V7 y% Z- E; B6 r, ~Failed.');3 `/ V9 f& |! Z) S3 ?
}
9 A) e6 Z7 N- i- dConnect(); T$ o4 K. R# B) w+ f x* O
4 I1 G$ z) p* @. }7 w* ^
function InitForm(){3 [* M& A7 R* U( Z
//layout for the form4 I M- g' e& F7 r
echo "<strong>Send Items.</strong>. O# N% w4 \4 K3 |; E
<form name='select' method='post'>; ]# s6 n; n4 R# \, c5 w
<lable>Character Name</lable><br/>
# w* W9 M2 g0 ~8 \7 ?<input type='text' name='char'/><br/>( K% f \0 v9 l5 W5 Y$ Z
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
% V6 M$ C% Q8 e5 B( Y( _$ l" u<input type='text' name='item_name'/><br/>5 p% b! l7 ?$ b
<lable>Item Amount</lable><br/>" n6 f& v: ?: J
<input type='text' name='item_amount'/><br/>
; g6 j: |. Z8 K* I7 ]<lable>Item Upgrade Amount</lable><br/>" S* _$ W4 g8 x0 D' b) q, X2 J# [
<input type='text' name='item_upgrade'/><br/>
! w& ~+ `9 c8 b4 W4 ^4 A3 Z<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
! a1 Q1 A$ y2 A/ z, h" I1 t! l
: b0 m) a6 x' o Q0 T( Z1 s! ]7 y' Y</lable><br/>% X& }" x8 b Q ~- H4 n
<input type='text' name='item_element'/><br/>4 D! M# I0 Y0 Y E# D
<lable>Element Upgrade Amount</lable><br/>
% |. Z# @6 P4 ~0 \$ I' h$ q+ u<input type='text' name='element_upgrade'/><br/>
" T4 X7 ]+ l5 {; T* {<lable>Pierced Amount</lable><br/>
5 g4 R; S" q: R/ _0 i8 U/ J- E/ s<input type='text' name='item_pierce'/><br/># G2 A* a7 Q0 O* c. V2 D8 k3 N
<input type='submit'/>
T1 ]) U8 w% Z</form>";
% P. b2 V/ t$ v}
/ @+ f/ T3 @& c i, \1 S0 L% t' h* p% |9 h
function PostListener (){& s5 `8 E5 o) u: e T( A
//Add more post variables if needed and add them to initform() function aswell5 ^) S. v. ]/ O2 b
( F$ `9 a+ [% W9 x, M# ]################################
7 R3 s% }5 d* p5 l! c | x2 Y* h% v& G##### Connection and Post ######
# k/ b- m2 D' `* C9 b- ]9 L################################& x$ X# d$ Y4 y1 C. q
$name = @$_POST['char'];
! ^: I3 o/ y: f9 i7 s, c$ItemName = @$_POST['item_name'];
" N, A7 j5 ?' Q4 ]( x' R2 L. |+ _& s9 s$ItemAmount = @$_POST['item_amount'];: K, _) }8 T4 a3 A0 m
$ItemId = @$_POST['item_id'];- n4 [, a0 j- [# d0 i5 e: D
$ItemUpgrade = @$_POST['item_upgrade'];
. y: ^6 f2 D/ e& H) h$ItemElement = @$_POST['item_element'];
, d9 l4 H, [4 `- k) X$ElementUpgrade = @$_POST['element_upgrade']; {! m v) u q
$ItemPierce = @$_POST['item_pierce'];
" g% c7 a1 S% _7 D/ `, P################################/ x6 @; q3 o1 X) y2 S
6 C! I! P* p+ k7 d- X& F- T! z
//Check both variables for empty value+ _1 I* c: T+ I( _/ R
) N! a C4 E( a6 vif (!empty($_POST['char'])){
8 L9 [. Z4 v$ C9 ^4 @* @: u$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where - F* l; z5 R. S0 ~' E4 I
4 o% W- ?( k6 g! i1 T+ o! j9 pm_szName = '{$name}'");
" V- q9 p- c/ P% B+ b& ewhile ($row = mssql_fetch_object($find)){- \% e! k/ i2 T- {
echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";! s$ u# O* L g2 k" J
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer], 9 F4 _2 Y8 M. X5 r* `$ Y
* W% O" G4 q4 N[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
8 ] I1 h& e, r e5 {% }
7 }5 ?5 g5 c; `" d. ][m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer', 6 M1 V( X, B. D6 X) A1 l" u0 z
$ U% X& E! P \$ `; PN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',
4 B" `7 H% M. A
) B2 X0 c* U/ N4 [# E1 H! T'{$ElementUpgrade}', '{$ItemPierce}');");
1 c% \# T& f% T, G% u8 z* |% z}4 S! V# F8 U( z# }% x1 a
; y2 @' J) q9 x# a \4 z
}7 s, s( V" h/ p5 G
' Z! D% |5 ?" n* W$ u% X: D
}3 Z' c5 O; o' g: b. o
2 C+ Q8 M! b' C+ E) X w
$InitForm = InitForm();
/ f! e) N( p3 w: J4 c$Listener = PostListener();, R: V0 b) S. o
& y: H# K% z, O4 `. s?>5 S/ _6 A% ~. e# c
e, W5 B. y' v0 I6 R
9 g* w3 _: t( A) T
! d: A% v0 p. r$ v0 p
6 x- V7 N' _7 g' E9 r |
|