[KO-FOX] Upgrade ve Drop Notice Programı

K Çevrimdışı

Kutsal

Kayıtlı Üye
7 Mayıs 2015
440
0
16
42
Cevap: [KO-FOX] Upgrade ve Drop Notice Programı



inş. çalışır
 
V Çevrimdışı

valorvalor

Yeni Cüce
29 Ekim 2015
26
0
1
29
Cevap: [KO-FOX] Upgrade ve Drop Notice Programı



+++++++++++++++++++++++++++++++++++:happy:
 
H Çevrimdışı

HFExpress

Kayıtlı Üye
22 Eylül 2013
74
0
6
36
Cevap: [KO-FOX] Upgrade ve Drop Notice Programı



Merhaba

Evet arkadaşlar biliyorsunuz upgrade ve drop notice programını BrateAchpnr yani berat yapmıstı ama baktımdı linkler felan hepsi kırılmış paylasayım dedim.



***Hidden content cannot be quoted.***
***Hidden content cannot be quoted.***



SQL Kodu :

PHP:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BRATE_DROP]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[BRATE_DROP]GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BRATE_UPGRADE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[BRATE_UPGRADE]GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BRATE_EXCHANGE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[BRATE_EXCHANGE]GO

CREATE TABLE [dbo].[BRATE_DROP] (    [itemNo] [int] NOT NULL ) ON [PRIMARY]GO

CREATE TABLE [dbo].[BRATE_UPGRADE] (    [itemNo] [int] NOT NULL ) ON [PRIMARY]GO

CREATE TABLE [dbo].[BRATE_EXCHANGE] (    [itemNo] [int] NOT NULL ) ON [PRIMARY]GO

truncate table BRATE_UPGRADEinsert into BRATE_UPGRADE (itemno) select num from item where num like '%8'insert into BRATE_UPGRADE (itemno) select num from item where itemtype=4 and slot in(10,11,12,14)truncate table BRATE_DROPinsert into BRATE_DROP (itemno) select num from item where itemtype=4truncate table BRATE_EXCHANGEinsert into BRATE_EXCHANGE (itemno) select nExchangeItemNum1 from ITEM_EXCHANGE where nExchangeItemNum1 in(select num from item where itemtype=4)insert into BRATE_EXCHANGE (itemno) select nExchangeItemNum2 from ITEM_EXCHANGE where nExchangeItemNum2 in(select num from item where itemtype=4) and not nExchangeItemNum2 in(select itemno from BRATE_EXCHANGE) insert into BRATE_EXCHANGE (itemno) select nExchangeItemNum3 from ITEM_EXCHANGE where nExchangeItemNum3 in(select num from item where itemtype=4) and not nExchangeItemNum3 in(select itemno from BRATE_EXCHANGE) insert into BRATE_EXCHANGE (itemno) select nExchangeItemNum4 from ITEM_EXCHANGE where nExchangeItemNum4 in(select num from item where itemtype=4) and not nExchangeItemNum4 in(select itemno from BRATE_EXCHANGE) insert into BRATE_EXCHANGE (itemno) select nExchangeItemNum5 from ITEM_EXCHANGE where nExchangeItemNum5 in(select num from item where itemtype=4) and not nExchangeItemNum5 in(select itemno from BRATE_EXCHANGE)








teşekürlerrr
 
O Çevrimdışı
29 Ağustos 2015
9,720
0
36
43
Cevap: [KO-FOX] Upgrade ve Drop Notice Programı



Merhaba

Evet arkadaşlar biliyorsunuz upgrade ve drop notice programını BrateAchpnr yani berat yapmıstı ama baktımdı linkler felan hepsi kırılmış paylasayım dedim.



***Hidden content cannot be quoted.***
***Hidden content cannot be quoted.***



SQL Kodu :

PHP:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BRATE_DROP]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[BRATE_DROP]GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BRATE_UPGRADE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[BRATE_UPGRADE]GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BRATE_EXCHANGE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[BRATE_EXCHANGE]GO

CREATE TABLE [dbo].[BRATE_DROP] (    [itemNo] [int] NOT NULL ) ON [PRIMARY]GO

CREATE TABLE [dbo].[BRATE_UPGRADE] (    [itemNo] [int] NOT NULL ) ON [PRIMARY]GO

CREATE TABLE [dbo].[BRATE_EXCHANGE] (    [itemNo] [int] NOT NULL ) ON [PRIMARY]GO

truncate table BRATE_UPGRADEinsert into BRATE_UPGRADE (itemno) select num from item where num like '%8'insert into BRATE_UPGRADE (itemno) select num from item where itemtype=4 and slot in(10,11,12,14)truncate table BRATE_DROPinsert into BRATE_DROP (itemno) select num from item where itemtype=4truncate table BRATE_EXCHANGEinsert into BRATE_EXCHANGE (itemno) select nExchangeItemNum1 from ITEM_EXCHANGE where nExchangeItemNum1 in(select num from item where itemtype=4)insert into BRATE_EXCHANGE (itemno) select nExchangeItemNum2 from ITEM_EXCHANGE where nExchangeItemNum2 in(select num from item where itemtype=4) and not nExchangeItemNum2 in(select itemno from BRATE_EXCHANGE) insert into BRATE_EXCHANGE (itemno) select nExchangeItemNum3 from ITEM_EXCHANGE where nExchangeItemNum3 in(select num from item where itemtype=4) and not nExchangeItemNum3 in(select itemno from BRATE_EXCHANGE) insert into BRATE_EXCHANGE (itemno) select nExchangeItemNum4 from ITEM_EXCHANGE where nExchangeItemNum4 in(select num from item where itemtype=4) and not nExchangeItemNum4 in(select itemno from BRATE_EXCHANGE) insert into BRATE_EXCHANGE (itemno) select nExchangeItemNum5 from ITEM_EXCHANGE where nExchangeItemNum5 in(select num from item where itemtype=4) and not nExchangeItemNum5 in(select itemno from BRATE_EXCHANGE)








cok tesekkurler
 
A Çevrimdışı

asdtak

Kayıtlı Üye
27 Eylül 2013
142
0
16
37
Cevap: [KO-FOX] Upgrade ve Drop Notice Programı



ts,kkkkkkkkkkkkkkkkkkk
 
Üst