|
|
• الانـتـسـاب » Apr 2010
|
|
• رقـم العـضـويـة » 70810
|
|
• المشـــاركـات » 503
|
|
• الـدولـة » 4D Cinema Module room
|
|
• الـهـوايـة » JuliusjefJD
|
|
• اسـم الـسـيـرفـر » No Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 11
|
|
|
  
|
.gif)
اقتباس:
المشاركة الأصلية كتبت بواسطة ™anas™
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
ضريت بريميم غلط و عايز تشيله هتعمل الكويري دي
كود PHP:
delete from [sro_vt_shard].[dbo].[_timedjob]
where charid = 'char id'
هنغير ال char id بال id بتاع الاكونت من sro_vt_shard > char
-----------------------------------------------------------------------------------------
عايز تفتح كل السيكلات في اكونت الجي ام من غير ما تبوظ الماوس بتاعك
كود PHP:
declare @charname varchar(255)
declare @charid int
set @charname='mrs_mero'
select @charid = charid from _char where charname16=@charname
update _charskillmastery set level = '120' where charid=@charid
insert into _charskill values (@charid,1,1)
insert into _charskill values (@charid,2,1)
insert into _charskill values (@charid,40,1)
insert into _charskill values (@charid,70,1)
insert into _charskill values (@charid,298,1)
insert into _charskill values (@charid,306,1)
insert into _charskill values (@charid,314,1)
insert into _charskill values (@charid,322,1)
insert into _charskill values (@charid,346,1)
insert into _charskill values (@charid,378,1)
insert into _charskill values (@charid,418,1)
insert into _charskill values (@charid,463,1)
insert into _charskill values (@charid,558,1)
insert into _charskill values (@charid,569,1)
insert into _charskill values (@charid,580,1)
insert into _charskill values (@charid,588,1)
insert into _charskill values (@charid,596,1)
insert into _charskill values (@charid,604,1)
insert into _charskill values (@charid,647,1)
insert into _charskill values (@charid,655,1)
insert into _charskill values (@charid,672,1)
insert into _charskill values (@charid,689,1)
insert into _charskill values (@charid,699,1)
insert into _charskill values (@charid,708,1)
insert into _charskill values (@charid,716,1)
insert into _charskill values (@charid,724,1)
insert into _charskill values (@charid,735,1)
insert into _charskill values (@charid,746,1)
insert into _charskill values (@charid,757,1)
insert into _charskill values (@charid,765,1)
insert into _charskill values (@charid,773,1)
insert into _charskill values (@charid,781,1)
insert into _charskill values (@charid,789,1)
insert into _charskill values (@charid,797,1)
insert into _charskill values (@charid,805,1)
insert into _charskill values (@charid,813,1)
insert into _charskill values (@charid,821,1)
insert into _charskill values (@charid,829,1)
insert into _charskill values (@charid,853,1)
insert into _charskill values (@charid,885,1)
insert into _charskill values (@charid,925,1)
insert into _charskill values (@charid,933,1)
insert into _charskill values (@charid,943,1)
insert into _charskill values (@charid,952,1)
insert into _charskill values (@charid,960,1)
insert into _charskill values (@charid,968,1)
insert into _charskill values (@charid,976,1)
insert into _charskill values (@charid,984,1)
insert into _charskill values (@charid,992,1)
insert into _charskill values (@charid,1003,1)
insert into _charskill values (@charid,1014,1)
insert into _charskill values (@charid,1025,1)
insert into _charskill values (@charid,1033,1)
insert into _charskill values (@charid,1041,1)
insert into _charskill values (@charid,1049,1)
insert into _charskill values (@charid,1053,1)
insert into _charskill values (@charid,1057,1)
insert into _charskill values (@charid,1065,1)
insert into _charskill values (@charid,1073,1)
insert into _charskill values (@charid,1081,1)
insert into _charskill values (@charid,1089,1)
insert into _charskill values (@charid,1099,1)
insert into _charskill values (@charid,1108,1)
insert into _charskill values (@charid,1116,1)
insert into _charskill values (@charid,1124,1)
insert into _charskill values (@charid,1132,1)
insert into _charskill values (@charid,1140,1)
insert into _charskill values (@charid,1148,1)
insert into _charskill values (@charid,1153,1)
insert into _charskill values (@charid,1158,1)
insert into _charskill values (@charid,1163,1)
insert into _charskill values (@charid,1168,1)
insert into _charskill values (@charid,1173,1)
insert into _charskill values (@charid,1178,1)
insert into _charskill values (@charid,1189,1)
insert into _charskill values (@charid,1200,1)
insert into _charskill values (@charid,1217,1)
insert into _charskill values (@charid,1234,1)
insert into _charskill values (@charid,1244,1)
insert into _charskill values (@charid,1253,1)
insert into _charskill values (@charid,1261,1)
insert into _charskill values (@charid,1269,1)
insert into _charskill values (@charid,1271,1)
insert into _charskill values (@charid,1273,1)
insert into _charskill values (@charid,1275,1)
insert into _charskill values (@charid,1286,1)
insert into _charskill values (@charid,1297,1)
insert into _charskill values (@charid,1308,1)
insert into _charskill values (@charid,1316,1)
insert into _charskill values (@charid,1324,1)
insert into _charskill values (@charid,1332,1)
insert into _charskill values (@charid,1337,1)
insert into _charskill values (@charid,1342,1)
insert into _charskill values (@charid,1350,1)
insert into _charskill values (@charid,1358,1)
insert into _charskill values (@charid,1368,1)
insert into _charskill values (@charid,1377,1)
insert into _charskill values (@charid,1385,1)
insert into _charskill values (@charid,1393,1)
insert into _charskill values (@charid,1398,1)
insert into _charskill values (@charid,1403,1)
insert into _charskill values (@charid,1408,1)
insert into _charskill values (@charid,1410,1)
insert into _charskill values (@charid,1412,1)
insert into _charskill values (@charid,1414,1)
insert into _charskill values (@charid,1422,1)
insert into _charskill values (@charid,1430,1)
insert into _charskill values (@charid,1438,1)
insert into _charskill values (@charid,1443,1)
insert into _charskill values (@charid,1448,1)
insert into _charskill values (@charid,1465,1)
insert into _charskill values (@charid,1482,1)
insert into _charskill values (@charid,1499,1)
insert into _charskill values (@charid,1509,1)
insert into _charskill values (@charid,1518,1)
insert into _charskill values (@charid,1526,1)
insert into _charskill values (@charid,1534,1)
insert into _charskill values (@charid,1539,1)
insert into _charskill values (@charid,1544,1)
insert into _charskill values (@charid,1549,1)
insert into _charskill values (@charid,1557,1)
insert into _charskill values (@charid,1565,1)
insert into _charskill values (@charid,1573,1)
insert into _charskill values (@charid,1578,1)
insert into _charskill values (@charid,1583,1)
insert into _charskill values (@charid,1588,1)
insert into _charskill values (@charid,1593,1)
insert into _charskill values (@charid,1598,1)
insert into _charskill values (@charid,1609,1)
insert into _charskill values (@charid,1617,1)
insert into _charskill values (@charid,1628,1)
insert into _charskill values (@charid,3149,1)
insert into _charskill values (@charid,3167,1)
insert into _charskill values (@charid,3176,1)
insert into _charskill values (@charid,3224,1)
insert into _charskill values (@charid,3340,1)
insert into _charskill values (@charid,3349,1)
insert into _charskill values (@charid,3364,1)
insert into _charskill values (@charid,3379,1)
insert into _charskill values (@charid,3391,1)
insert into _charskill values (@charid,3406,1)
insert into _charskill values (@charid,3409,1)
insert into _charskill values (@charid,3415,1)
insert into _charskill values (@charid,3430,1)
insert into _charskill values (@charid,3431,1)
insert into _charskill values (@charid,3446,1)
insert into _charskill values (@charid,3461,1)
insert into _charskill values (@charid,3467,1)
insert into _charskill values (@charid,3473,1)
insert into _charskill values (@charid,7139,1)
insert into _charskill values (@charid,7159,1)
insert into _charskill values (@charid,7203,1)
insert into _charskill values (@charid,7322,1)
insert into _charskill values (@charid,7385,1)
insert into _charskill values (@charid,7390,1)
insert into _charskill values (@charid,7392,1)
insert into _charskill values (@charid,7404,1)
insert into _charskill values (@charid,7418,1)
insert into _charskill values (@charid,7474,1)
insert into _charskill values (@charid,7484,1)
insert into _charskill values (@charid,7513,1)
insert into _charskill values (@charid,7520,1)
insert into _charskill values (@charid,7536,1)
insert into _charskill values (@charid,7554,1)
insert into _charskill values (@charid,7577,1)
insert into _charskill values (@charid,7582,1)
insert into _charskill values (@charid,7584,1)
insert into _charskill values (@charid,7596,1)
insert into _charskill values (@charid,7612,1)
insert into _charskill values (@charid,7637,1)
insert into _charskill values (@charid,7651,1)
insert into _charskill values (@charid,7672,1)
insert into _charskill values (@charid,7675,1)
insert into _charskill values (@charid,7688,1)
insert into _charskill values (@charid,7798,1)
insert into _charskill values (@charid,7805,1)
insert into _charskill values (@charid,7829,1)
insert into _charskill values (@charid,7838,1)
insert into _charskill values (@charid,7839,1)
insert into _charskill values (@charid,7853,1)
insert into _charskill values (@charid,7862,1)
insert into _charskill values (@charid,7877,1)
insert into _charskill values (@charid,7881,1)
insert into _charskill values (@charid,7894,1)
insert into _charskill values (@charid,7899,1)
insert into _charskill values (@charid,7907,1)
insert into _charskill values (@charid,7919,1)
insert into _charskill values (@charid,7931,1)
insert into _charskill values (@charid,7938,1)
insert into _charskill values (@charid,7947,1)
insert into _charskill values (@charid,7953,1)
insert into _charskill values (@charid,7959,1)
insert into _charskill values (@charid,7962,1)
insert into _charskill values (@charid,7972,1)
insert into _charskill values (@charid,7980,1)
insert into _charskill values (@charid,7995,1)
insert into _charskill values (@charid,7997,1)
insert into _charskill values (@charid,8010,1)
insert into _charskill values (@charid,8024,1)
insert into _charskill values (@charid,8050,1)
insert into _charskill values (@charid,8084,1)
insert into _charskill values (@charid,8097,1)
insert into _charskill values (@charid,8103,1)
insert into _charskill values (@charid,8109,1)
insert into _charskill values (@charid,8115,1)
insert into _charskill values (@charid,8119,1)
insert into _charskill values (@charid,8129,1)
insert into _charskill values (@charid,8133,1)
insert into _charskill values (@charid,8142,1)
insert into _charskill values (@charid,8150,1)
insert into _charskill values (@charid,8164,1)
insert into _charskill values (@charid,8171,1)
insert into _charskill values (@charid,8183,1)
insert into _charskill values (@charid,8195,1)
insert into _charskill values (@charid,8204,1)
insert into _charskill values (@charid,8214,1)
insert into _charskill values (@charid,8220,1)
insert into _charskill values (@charid,8221,1)
insert into _charskill values (@charid,8238,1)
insert into _charskill values (@charid,8239,1)
insert into _charskill values (@charid,8250,1)
insert into _charskill values (@charid,8253,1)
insert into _charskill values (@charid,8276,1)
insert into _charskill values (@charid,8291,1)
insert into _charskill values (@charid,8304,1)
insert into _charskill values (@charid,8316,1)
insert into _charskill values (@charid,8320,1)
insert into _charskill values (@charid,8338,1)
insert into _charskill values (@charid,8347,1)
insert into _charskill values (@charid,8348,1)
insert into _charskill values (@charid,8361,1)
insert into _charskill values (@charid,8370,1)
insert into _charskill values (@charid,8379,1)
insert into _charskill values (@charid,8383,1)
insert into _charskill values (@charid,8390,1)
insert into _charskill values (@charid,8399,1)
insert into _charskill values (@charid,8405,1)
insert into _charskill values (@charid,8410,1)
insert into _charskill values (@charid,8414,1)
insert into _charskill values (@charid,8416,1)
insert into _charskill values (@charid,20494,1)
insert into _charskill values (@charid,20497,1)
insert into _charskill values (@charid,20500,1)
insert into _charskill values (@charid,21215,1)
insert into _charskill values (@charid,21217,1)
insert into _charskill values (@charid,30578,1)
insert into _charskill values (@charid,30584,1)
insert into _charskill values (@charid,30590,1)
insert into _charskill values (@charid,30596,1)
insert into _charskill values (@charid,30600,1)
هتغير اسم mrs_mero باسم الاكونت بتاع الجي ام طبعا
-------------------------------------------------------------------------------------------------------
شيل وقت الجيلد للناس اللي عندك اللي واكلين دماغك >الناس اللي طلعت من جيلد و عايزه تخش واحد تاني <
كود PHP:
use [sro_vt_shard]
go
/******mrs_mero ******/
set ansi_nulls on
go
set quoted_identifier on
go
alter procedure [dbo].[_addtimedjob]
@charid int,
@category tinyint,
@jobid int,
@timetokeep int,
@data1 int,
@data2 int,
--##begin due to develop composite item
@data3 int,
@data4 int,
@data5 int,
@data6 int,
@data7 int,
@data8 int,
@serial64 bigint,
@jid int
--##end due to develop composite item
as
if (not exists (select charid from _char with (nolock) where charid = @charid))
return -1
if (@timetokeep <= 0)
return -2
declare @newjobid int
set @newjobid = 0
--##jobid 1 = guild // jobid 2 = thief/hunter/trader
--##if you want to only have one not both, then just modify the line below!
If (@jobid = 1 or @jobid = 2)
begin
insert into _timedjob(charid,category,jobid,timetokeep,data1,data2,data3,data4,data5,data6,data7,data8,serial64,jid)
values(@charid, @category, @jobid, 1, @data1, @data2, @data3, @data4, @data5, @data6, @data7, @data8, @serial64, @jid)
end
else
begin
--##begin due to develop composite item
insert into _timedjob(charid,category,jobid,timetokeep,data1,data2,data3,data4,data5,data6,data7,data8,serial64,jid)
values(@charid, @category, @jobid, @timetokeep, @data1, @data2, @data3, @data4, @data5, @data6, @data7, @data8, @serial64, @jid)
end
--##end due to develop composite item
set @newjobid = @@identity
if (@@error <> 0 or @@rowcount = 0)
return -3
return @newjobid
------------------------------------------------------------------------------------------------------
عايز تعمل الــ grap pet 5 صفح سهله برضه
كود PHP:
use [sro_vt_shard]
go
/****** object: Storedprocedure [dbo].[_addnewcos] script date: 02/10/2012 11:32:15 ******/
set ansi_nulls off
go
set quoted_identifier on
go
alter procedure [dbo].[_addnewcos]
@ownercharid int,
@refobjid int,
@level int,
@hp int,
@mp int,
@hgp int,
@keepernpc int,
@state int,
@inventorysize int,
@itemid int,
@pickitemconfig tinyint,
@rentendtime smalldatetime
as
begin tran
declare @cos_id int
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
declare @maxinventorysize tinyint
select @maxinventorysize = inventorysize
from _refobjcommon, _refobjchar
where _refobjcommon.id = @refobjid and _refobjcommon.link = _refobjchar.id
if( @@rowcount = 0 or @maxinventorysize < @inventorysize )
begin
rollback tran
return -5
end
insert into _charcos values (@ownercharid, @refobjid, @hp, @mp, @keepernpc, @state, null, @level, 0, @hgp, @pickitemconfig, @rentendtime)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
set @cos_id = @@identity
if (@cos_id = 0 or @@error <> 0)
begin
rollback tran
return -1
end
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
if (@maxinventorysize > 0)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
declare @slot int
set @slot = 0
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
while (@slot < @maxinventorysize)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
insert into _invcos values(@cos_id, @slot, 0)
if (@@error <> 0)
begin
-- Àκ¥Å丮 »ý¼º ½ÇÆÐ!
Rollback tran
return -2
end
set @slot = @slot + 1
end
end
/* --´õ ÀÌ»ó ÀÌ Ä÷³¿¡´Â µ¥ÀÌÅ͸¦ ³ÖÁö ¾Ê´Â´Ù!
Update _char set engagedcos = @cos_id where charid = @ownercharid
if (@@error <> 0 or @@rowcount = 0)
begin
rollback transaction
return -3
end
*/
if( @itemid <> 0 )
begin
update _items set data = @cos_id where id64 = @itemid
if( @@error <> 0 or @@rowcount = 0 )
begin
rollback transaction
return -4
end
--begin additional 112 slot in grab pets for 1 month
declare @serial64 bigint
select @serial64 = serial64 from _items where data = @cos_id
exec _addtimedjobforpet @cos_id,5,22926,1331260204,1111708465,1,112,0,0,0,0,0,@serial64
--begin additional 112 slot in grab pets for 1 month
end
commit tran
return @cos_id
-------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------
الــ honor ranking مش شغال ؟؟ حماده
كود PHP:
use sro_vt_shard
truncate table _trainingcamphonorrank
insert into _trainingcamphonorrank(ranking) values (1)
insert into _trainingcamphonorrank(ranking) values (2)
insert into _trainingcamphonorrank(ranking) values (3)
insert into _trainingcamphonorrank(ranking) values (4)
insert into _trainingcamphonorrank(ranking) values (5)
insert into _trainingcamphonorrank(ranking) values (6)
insert into _trainingcamphonorrank(ranking) values (7)
insert into _trainingcamphonorrank(ranking) values (8)
insert into _trainingcamphonorrank(ranking) values (9)
insert into _trainingcamphonorrank(ranking) values (10)
insert into _trainingcamphonorrank(ranking) values (11)
insert into _trainingcamphonorrank(ranking) values (12)
insert into _trainingcamphonorrank(ranking) values (13)
insert into _trainingcamphonorrank(ranking) values (14)
insert into _trainingcamphonorrank(ranking) values (15)
insert into _trainingcamphonorrank(ranking) values (16)
insert into _trainingcamphonorrank(ranking) values (17)
insert into _trainingcamphonorrank(ranking) values (18)
insert into _trainingcamphonorrank(ranking) values (19)
insert into _trainingcamphonorrank(ranking) values (20)
insert into _trainingcamphonorrank(ranking) values (21)
insert into _trainingcamphonorrank(ranking) values (22)
insert into _trainingcamphonorrank(ranking) values (23)
insert into _trainingcamphonorrank(ranking) values (24)
insert into _trainingcamphonorrank(ranking) values (25)
insert into _trainingcamphonorrank(ranking) values (26)
insert into _trainingcamphonorrank(ranking) values (27)
insert into _trainingcamphonorrank(ranking) values (28)
insert into _trainingcamphonorrank(ranking) values (29)
insert into _trainingcamphonorrank(ranking) values (30)
insert into _trainingcamphonorrank(ranking) values (31)
insert into _trainingcamphonorrank(ranking) values (32)
insert into _trainingcamphonorrank(ranking) values (33)
insert into _trainingcamphonorrank(ranking) values (34)
insert into _trainingcamphonorrank(ranking) values (35)
insert into _trainingcamphonorrank(ranking) values (36)
insert into _trainingcamphonorrank(ranking) values (37)
insert into _trainingcamphonorrank(ranking) values (38)
insert into _trainingcamphonorrank(ranking) values (39)
insert into _trainingcamphonorrank(ranking) values (40)
insert into _trainingcamphonorrank(ranking) values (41)
insert into _trainingcamphonorrank(ranking) values (42)
insert into _trainingcamphonorrank(ranking) values (43)
insert into _trainingcamphonorrank(ranking) values (44)
insert into _trainingcamphonorrank(ranking) values (45)
insert into _trainingcamphonorrank(ranking) values (46)
insert into _trainingcamphonorrank(ranking) values (47)
insert into _trainingcamphonorrank(ranking) values (48)
insert into _trainingcamphonorrank(ranking) values (49)
insert into _trainingcamphonorrank(ranking) values (50)
exec _training_camp_updatehonorrank
---------------------------------------------------------------------------------------------------
|
دول إللي أنا كنت عايزهم فعلا شكرا ليك
بس للأسف الأول والتاني والتالت بس هما إللي شغالين الجيلد مش شغاله[/quote]
شغالين كلهم و ربنا و انا شغال بيهم اتاكد من الاعدادات انت بس
و شكرا لكل الرجاله اللي ردت علي الموضوع ♥
|
12-12-2012, 09:40 PM
المواضيع المتشابهه
العرض المتطور
