飞飞世界论坛

标题: 物品发送脚本 [打印本页]

---

作者: admin    时间: 2016-1-10 03:43
标题: 物品发送脚本
<?php
function Connect () {
! g3 o5 n) ^5 ?mssql_connect('Server','UserName','Password') or die('Error: Connection to DB
$ W$ `& j% r4 X# J
Failed.');
}
) f# M# e6 @0 x" B; V  B1 _Connect();

function InitForm(){
//layout for the form
echo "<strong>Send Items.</strong>
<form name='select' method='post'>
<lable>Character Name</lable><br/>
1 G8 w; s! L8 T2 f- e2 [<input type='text' name='char'/><br/>
<lable>Item Name (Needs to be Exact or can use Item ID.)</lable><br/>
' O9 A. W7 V, m7 O. \; _" V$ ~<input type='text' name='item_name'/><br/>
) O# Y0 s9 I* U" o<lable>Item Amount</lable><br/>
; d3 K4 r. [5 c1 H<input type='text' name='item_amount'/><br/>
<lable>Item Upgrade Amount</lable><br/>
<input type='text' name='item_upgrade'/><br/>
" Y& x2 ~4 x, S<lable>Element Type.(0-None, 1-Fire, 2-Water, 3-Electricity, 4-Wind, 5-Earth.)
5 S) ]7 x  b7 [% V8 M" j, L  b! |
2 I. Q+ c/ d( O. K/ ]* X</lable><br/>
<input type='text' name='item_element'/><br/>
<lable>Element Upgrade Amount</lable><br/>
$ F& S/ j) ]6 v. a<input type='text' name='element_upgrade'/><br/>
1 N9 I. k; c; U' g3 ?<lable>Pierced Amount</lable><br/>
<input type='text' name='item_pierce'/><br/>
<input type='submit'/>
0 e/ O8 l/ Y* z' ]</form>";
; B5 Y$ w; {- r8 e2 N}
6 _+ g& j6 F+ r
% W, z2 a) J8 m7 Dfunction PostListener (){
% ~; I% s5 }! l- [9 a0 @//Add more post variables if needed and add them to initform() function aswell
: u; i/ e. H: \' a1 w0 M2 @
' s: Z3 B3 j. u# v# S- Z################################
##### Connection and Post ######
: x% |$ _! U: ~7 X' ?. ~################################
# l( F- }, ~, m7 g6 H$name = @$_POST['char'];
. s1 ]0 U& z9 C( y2 G$ItemName = @$_POST['item_name'];
( V5 f* @' d0 Y& ~& h1 j! y& f$ItemAmount = @$_POST['item_amount'];
8 S7 i' u- q0 X$ItemId = @$_POST['item_id'];
: _: ~  i  r9 B' G: P; F$ItemUpgrade = @$_POST['item_upgrade'];
7 e: G1 I& J- |# K3 w5 J- b$ItemElement = @$_POST['item_element'];
$ElementUpgrade = @$_POST['element_upgrade'];
$ItemPierce = @$_POST['item_pierce'];
  C# @0 Q% D2 K################################
" j3 L# O3 m- P  N# Y
/ w8 m' S: A0 H  q/ S5 C//Check both variables for empty value
6 {8 H# H" [( q6 o
/ I$ m0 j, d: C8 {& k1 [8 Uif (!empty($_POST['char'])){
: q) Z3 u* z5 c. \, _& V0 k# H$find = mssql_query("select * from [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] where

* v: p$ M9 ~% A9 h. @+ fm_szName = '{$name}'");
while ($row = mssql_fetch_object($find)){
  N' O( X+ D1 [" M9 @" Q) L9 @echo "You Just Sent {$ItemAmount} {$ItemName}(s) to {$name}<br>";
$logs = mssql_query("INSERT INTO CHARACTER_01_DBF.dbo.ITEM_SEND_TBL([m_idPlayer],

2 x: t4 G. }# ]9 |6 M+ ?5 R# J( B[serverindex], [Item_Name], [Item_count], [idSender], [m_nAbilityOption],
* `: p- t- N4 _! k4 L8 @* T
[m_bItemResist], [m_nResistAbilityOption], [nPiercedSize]) VALUES(N'$row->m_idPlayer',

$ Y0 N; H- ?' G+ ZN'01', N'{$ItemName}', '{$ItemAmount}', N'0000001', '{$ItemUpgrade}', '{$ItemElement}',

'{$ElementUpgrade}', '{$ItemPierce}');");
}

}

6 k7 f& Z+ @; n0 c- I. q5 M}

$InitForm = InitForm();
# Z* ?: Q" f- n$Listener = PostListener();
4 q/ d/ B# z8 ?+ ~# Q5 O! A
( Q: Z  Q" n; r5 @' s?>

/ C5 t. U0 Q2 Z) q$ Q6 J$ P7 i  n
- N# ^- [; c. j! }, z

) `; N$ Q! ]; t8 ]0 w9 W: o

---

欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)

Powered by Discuz! X3.2