'##################################################'
'#### Trayhoper's Drop List Maker Source Codes ####'
'#### 25.09.2008 Perşembe .. zzz Hasta Oldum ! ####'
'##################################################'
Private Declare Sub Sleep Lib "kernel32" _
(ByVal dwMilliseconds As Long)
Dim conn As New ADODB.Connection
Dim conn2 As New ADODB.Connection
Dim conn3 As New ADODB.Connection
Dim tray As New ADODB.Recordset
Dim tray2 As New ADODB.Recordset
Dim tray3 As New ADODB.Recordset
Dim genelveri As String
Dim canavar, item1, item2, item3, item4, item5 As String
Dim CanavarAd, item1ad, item2ad, item3ad, item4ad, item5ad As String
Dim oran1, oran2, oran3, oran4, oran5 As String
Dim ItemAdi As String
Public Sub baglan(Veritabani As String)
On Error GoTo hata
If conn.State = 1 Then
conn.Close
End If
conn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=" & Veritabani & " "
genelveri = Veritabani
Exit Sub
hata:
MsgBox "Database : " & Veritabani & " bağlanılamadı ..", vbCritical
End
End Sub
Public Sub baglan2(Veritabani As String)
On Error GoTo hata
If conn2.State = 1 Then
conn2.Close
End If
conn2.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=" & Veritabani & " "
Exit Sub
hata:
MsgBox "Database : " & Veritabani & " bağlanılamadı ..", vbCritical
End
End Sub
Public Sub baglan3(Veritabani As String)
On Error GoTo hata
If conn3.State = 1 Then
MsgBox "Zaten bir bağlantı açık !", vbCritical
conn3.Close
End If
conn3.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=" & Veritabani & " "
Exit Sub
hata:
MsgBox "Database : " & Veritabani & " bağlanılamadı ..", vbCritical
End
End Sub
Private Sub Command1_Click()
baglan Text1.Text
baglan2 Text1.Text
baglan3 Text1.Text
Sleep 1000
Drop
End SubPrivate Sub Text1_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Command1_Click
End If
End Sub
Public Sub IsimBul(CanavarIndex As String)
On Error GoTo hata
Check2
tray2.Open "Select strName FROM K_MONSTER WHERE sSid = '" & CanavarIndex & "'", conn2, 1, 3
CanavarAd = tray2!strName
Exit Sub
hata:
conn2.Execute "DELETE FROM K_MONSTER_ITEM WHERE sIndex = '" & CanavarIndex & "'"
End Sub
Public Sub ItemBul(ItemIndex As String)
On Error Resume Next
Check3
If Int(Trim(ItemIndex)) = "0" Then
ItemAdi = "Drop Yok !"
Exit Sub
End If
If Int(Trim(ItemIndex)) < Int(1000000) Then
ItemAdi = "Rasgele Item"
Exit Sub
End If
tray3.Open "Select strName FROM ITEM WHERE Num = '" & ItemIndex & "'", conn3, 1, 3
ItemAdi = tray3!strName
End Sub
Public Sub Drop()
tray.Open "Select * FROM K_MONSTER_ITEM", conn, 1, 3
Do Until tray.EOF
canavar = tray!sIndex
item1 = tray!iItem01
item2 = tray!iItem02
item3 = tray!iItem03
item4 = tray!iItem04
item5 = tray!iItem05
oran1 = Int(Int(tray!sPersent01) / Int(100))
oran2 = Int(Int(tray!sPersent02) / Int(100))
oran3 = Int(Int(tray!sPersent03) / Int(100))
oran4 = Int(Int(tray!sPersent04) / Int(100))
oran5 = Int(Int(tray!sPersent05) / Int(100))
IsimBul "" & canavar & ""
List1.AddItem "** " & CanavarAd & " **"
CanavarAd = vbNullString
ItemBul "" & item1 & ""
List1.AddItem ""
List1.AddItem "1) " & Trim(ItemAdi) & " %" & oran1 & ""
ItemAdi = vbNullString
ItemBul "" & item2 & ""
List1.AddItem "2) " & Trim(ItemAdi) & " %" & oran2 & ""
ItemAdi = vbNullString
ItemBul "" & item3 & ""
List1.AddItem "3) " & Trim(ItemAdi) & " %" & oran3 & ""
ItemAdi = vbNullString
ItemBul "" & item4 & ""
List1.AddItem "4) " & Trim(ItemAdi) & " %" & oran4 & ""
ItemAdi = vbNullString
ItemBul "" & item5 & ""
List1.AddItem "5) " & Trim(ItemAdi) & " %" & oran4 & ""
List1.AddItem ""
ItemAdi = vbNullString
tray.MoveNext
Loop
ListeKayit List1
MsgBox "Kayıt Edildi : " & App.Path & "\" & genelveri & ".txt"
End
End Sub
Public Sub Check()
If tray.State = 1 Then
tray.Close
End If
End Sub
Public Sub Check3()
If tray3.State = 1 Then
tray3.Close
End If
End Sub
Public Sub Check2()
If tray2.State = 1 Then
tray2.Close
End If
End Sub
Private Sub ListeKayit(Liste As ListBox)
Dim Sayac%
Open App.Path & "\" & genelveri & ".txt" For Output As #1
For Sayac = 0 To Liste.ListCount - 1
Print #1, Liste.List(Sayac)
Next Sayac
Close #1
End Sub
'#### Trayhoper's Drop List Maker Source Codes ####'
'#### 25.09.2008 Perşembe .. zzz Hasta Oldum ! ####'
'##################################################'
Private Declare Sub Sleep Lib "kernel32" _
(ByVal dwMilliseconds As Long)
Dim conn As New ADODB.Connection
Dim conn2 As New ADODB.Connection
Dim conn3 As New ADODB.Connection
Dim tray As New ADODB.Recordset
Dim tray2 As New ADODB.Recordset
Dim tray3 As New ADODB.Recordset
Dim genelveri As String
Dim canavar, item1, item2, item3, item4, item5 As String
Dim CanavarAd, item1ad, item2ad, item3ad, item4ad, item5ad As String
Dim oran1, oran2, oran3, oran4, oran5 As String
Dim ItemAdi As String
Public Sub baglan(Veritabani As String)
On Error GoTo hata
If conn.State = 1 Then
conn.Close
End If
conn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=" & Veritabani & " "
genelveri = Veritabani
Exit Sub
hata:
MsgBox "Database : " & Veritabani & " bağlanılamadı ..", vbCritical
End
End Sub
Public Sub baglan2(Veritabani As String)
On Error GoTo hata
If conn2.State = 1 Then
conn2.Close
End If
conn2.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=" & Veritabani & " "
Exit Sub
hata:
MsgBox "Database : " & Veritabani & " bağlanılamadı ..", vbCritical
End
End Sub
Public Sub baglan3(Veritabani As String)
On Error GoTo hata
If conn3.State = 1 Then
MsgBox "Zaten bir bağlantı açık !", vbCritical
conn3.Close
End If
conn3.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=" & Veritabani & " "
Exit Sub
hata:
MsgBox "Database : " & Veritabani & " bağlanılamadı ..", vbCritical
End
End Sub
Private Sub Command1_Click()
baglan Text1.Text
baglan2 Text1.Text
baglan3 Text1.Text
Sleep 1000
Drop
End SubPrivate Sub Text1_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Command1_Click
End If
End Sub
Public Sub IsimBul(CanavarIndex As String)
On Error GoTo hata
Check2
tray2.Open "Select strName FROM K_MONSTER WHERE sSid = '" & CanavarIndex & "'", conn2, 1, 3
CanavarAd = tray2!strName
Exit Sub
hata:
conn2.Execute "DELETE FROM K_MONSTER_ITEM WHERE sIndex = '" & CanavarIndex & "'"
End Sub
Public Sub ItemBul(ItemIndex As String)
On Error Resume Next
Check3
If Int(Trim(ItemIndex)) = "0" Then
ItemAdi = "Drop Yok !"
Exit Sub
End If
If Int(Trim(ItemIndex)) < Int(1000000) Then
ItemAdi = "Rasgele Item"
Exit Sub
End If
tray3.Open "Select strName FROM ITEM WHERE Num = '" & ItemIndex & "'", conn3, 1, 3
ItemAdi = tray3!strName
End Sub
Public Sub Drop()
tray.Open "Select * FROM K_MONSTER_ITEM", conn, 1, 3
Do Until tray.EOF
canavar = tray!sIndex
item1 = tray!iItem01
item2 = tray!iItem02
item3 = tray!iItem03
item4 = tray!iItem04
item5 = tray!iItem05
oran1 = Int(Int(tray!sPersent01) / Int(100))
oran2 = Int(Int(tray!sPersent02) / Int(100))
oran3 = Int(Int(tray!sPersent03) / Int(100))
oran4 = Int(Int(tray!sPersent04) / Int(100))
oran5 = Int(Int(tray!sPersent05) / Int(100))
IsimBul "" & canavar & ""
List1.AddItem "** " & CanavarAd & " **"
CanavarAd = vbNullString
ItemBul "" & item1 & ""
List1.AddItem ""
List1.AddItem "1) " & Trim(ItemAdi) & " %" & oran1 & ""
ItemAdi = vbNullString
ItemBul "" & item2 & ""
List1.AddItem "2) " & Trim(ItemAdi) & " %" & oran2 & ""
ItemAdi = vbNullString
ItemBul "" & item3 & ""
List1.AddItem "3) " & Trim(ItemAdi) & " %" & oran3 & ""
ItemAdi = vbNullString
ItemBul "" & item4 & ""
List1.AddItem "4) " & Trim(ItemAdi) & " %" & oran4 & ""
ItemAdi = vbNullString
ItemBul "" & item5 & ""
List1.AddItem "5) " & Trim(ItemAdi) & " %" & oran4 & ""
List1.AddItem ""
ItemAdi = vbNullString
tray.MoveNext
Loop
ListeKayit List1
MsgBox "Kayıt Edildi : " & App.Path & "\" & genelveri & ".txt"
End
End Sub
Public Sub Check()
If tray.State = 1 Then
tray.Close
End If
End Sub
Public Sub Check3()
If tray3.State = 1 Then
tray3.Close
End If
End Sub
Public Sub Check2()
If tray2.State = 1 Then
tray2.Close
End If
End Sub
Private Sub ListeKayit(Liste As ListBox)
Dim Sayac%
Open App.Path & "\" & genelveri & ".txt" For Output As #1
For Sayac = 0 To Liste.ListCount - 1
Print #1, Liste.List(Sayac)
Next Sayac
Close #1
End Sub
翻译： 英语 » 中文
'################################################# ＃ '
'#### Trayhoper的下拉列表制作源代码####'
'#### 08年9月25日Perşembe ..译成zzz直到Oldum ！ ####'
'################################################# ＃ '
私人小组睡眠宣告解放“ kernel32 ” _
（ ByVal只要dwMilliseconds ）
昏暗单元作为新ADODB.Connection
昏暗conn2作为新ADODB.Connection
昏暗conn3作为新ADODB.Connection
昏暗托盘作为新ADODB.Recordset
昏暗tray2作为新ADODB.Recordset
昏暗tray3作为新ADODB.Recordset
昏暗genelveri作为字符串
昏暗canavar ， item1 ， item2 ， item3 ， item4 ， item5如弦
昏暗CanavarAd ， item1ad ， item2ad ， item3ad ， item4ad ， item5ad如弦
昏暗oran1 ， oran2 ， oran3 ， oran4 ， oran5如弦
昏暗ItemAdi作为字符串
公共小组巴格兰（ Veritabani如弦）
在错误后藤羽田孜
如果conn.State = 1然后
conn.Close
如果完
conn.Open “供应商= SQLOLEDB.1 ;集成安全= SSPI ;坚持安全信息=虚假;初始目录= ” ＆ Veritabani ＆ “ ”
genelveri = Veritabani
退出小组
羽田孜：
MsgBox “数据库： ” ＆ Veritabani ＆ “ bağlanılamadı .. ” ， vbCritical
末端
小组完
公共小组baglan2 （ Veritabani如弦）
在错误后藤羽田孜
如果conn2.State = 1然后
conn2.Close
如果完
conn2.Open “供应商= SQLOLEDB.1 ;集成安全= SSPI ;坚持安全信息=虚假;初始目录= ” ＆ Veritabani ＆ “ ”
退出小组
羽田孜：
MsgBox “数据库： ” ＆ Veritabani ＆ “ bağlanılamadı .. ” ， vbCritical
末端
小组完
公共小组baglan3 （ Veritabani如弦）
在错误后藤羽田孜
如果conn3.State = 1然后
MsgBox “ Zaten井bağlantı açık ！ ” ， vbCritical
conn3.Close
如果完
conn3.Open “供应商= SQLOLEDB.1 ;集成安全= SSPI ;坚持安全信息=虚假;初始目录= ” ＆ Veritabani ＆ “ ”
退出小组
羽田孜：
MsgBox “数据库： ” ＆ Veritabani ＆ “ bağlanılamadı .. ” ， vbCritical
末端
小组完
私人小组Command1_Click （ ）
巴格兰Text1.Text
baglan2 Text1.Text
baglan3 Text1.Text
1000睡眠
落下
小组完 私人小组Text1_KeyPress （ KeyAscii为整数）
如果KeyAscii = 13然后
Command1_Click
如果完
小组完
公共小组IsimBul （ CanavarIndex作为字符串）
在错误后藤羽田孜
Check2
tray2.Open “选择strName从哪里SSID的K_MONSTER = ' ” ＆ CanavarIndex ＆ “ ' ” ， conn2 ， 1 ， 3
CanavarAd = tray2 ！ strName
退出小组
羽田孜：
conn2.Execute “删除K_MONSTER_ITEM哪里sIndex = ' ” ＆ CanavarIndex ＆ “ ' ”
小组完
公共小组ItemBul （ ItemIndex为字符串）
关于明年的错误恢复
Check3
如果国际（修剪（ ItemIndex ） ） = “ 0 ”之后
ItemAdi = “降郁慕明！ ”
退出小组
如果完
如果国际（修剪（ ItemIndex ） ） “国际（ 1000000 ）接着
ItemAdi = “ Rasgele项目”
退出小组
如果完
tray3.Open “选择strName从项目的WHERE数= ' ” ＆ ItemIndex ＆ “ ' ” ， conn3 ， 1 ， 3
ItemAdi = tray3 ！ strName
小组完
公共小组降（ ）
tray.Open “选择由K_MONSTER_ITEM * ” ，连通， 1 ， 3
请勿在此之前tray.EOF
canavar =托盘！ sIndex
item1 =托盘！ iItem01
item2 =托盘！ iItem02
item3 =托盘！ iItem03
item4 =托盘！ iItem04
item5 =托盘！ iItem05
oran1 =国际（国际（托盘！ sPersent01 ） /国际（ 100 ） ）
oran2 =国际（国际（托盘！ sPersent02 ） /国际（ 100 ） ）
oran3 =国际（国际（托盘！ sPersent03 ） /国际（ 100 ） ）
oran4 =国际（国际（托盘！ sPersent04 ） /国际（ 100 ） ）
oran5 =国际（国际（托盘！ sPersent05 ） /国际（ 100 ） ）
IsimBul “ ” ＆ canavar ＆ “ ”
List1.AddItem “ ** ” ＆ CanavarAd ＆ “ ** ”
CanavarAd = vbNullString
ItemBul “ ” ＆ item1 ＆ “ ”
List1.AddItem “ ”
List1.AddItem “ 1 ） ” ＆修剪（ ItemAdi ） ＆ “ ％ ” ＆ oran1 ＆ “ ”
ItemAdi = vbNullString
ItemBul “ ” ＆ item2 ＆ “ ”
List1.AddItem “ 2 ） ” ＆修剪（ ItemAdi ） ＆ “ ％ ” ＆ oran2 ＆ “ ”
ItemAdi = vbNullString
ItemBul “ ” ＆ item3 ＆ “ ”
List1.AddItem “ 3 ） ” ＆修剪（ ItemAdi ） ＆ “ ％ ” ＆ oran3 ＆ “ ”
ItemAdi = vbNullString
ItemBul “ ” ＆ item4 ＆ “ ”
List1.AddItem “ 4 ） ” ＆修剪（ ItemAdi ） ＆ “ ％ ” ＆ oran4 ＆ “ ”
ItemAdi = vbNullString
ItemBul “ ” ＆ item5 ＆ “ ”
List1.AddItem “ 5 ） ” ＆修剪（ ItemAdi ） ＆ “ ％ ” ＆ oran4 ＆ “ ”
List1.AddItem “ ”
ItemAdi = vbNullString
tray.MoveNext
环
ListeKayit列表
MsgBox “ Kayıt Edildi ： ” ＆ App.Path ＆ “ \ ” ＆ genelveri ＆ “ 。文本”
末端
小组完
公共小组检查（ ）
如果tray.State = 1然后
tray.Close
如果完
小组完
公共小组Check3 （ ）
如果tray3.State = 1然后
tray3.Close
如果完
小组完
公共小组Check2 （ ）
如果tray2.State = 1然后
tray2.Close
如果完
小组完
私人小组ListeKayit （目录作为列表）
昏暗Sayac ％
打开App.Path ＆ “ \ ” ＆ genelveri ＆ “ 。文本”对于输出＃ 1
对于Sayac = 0 Liste.ListCount -1
打印＃ 1 ， Liste.List （ Sayac ）
下一步Sayac
关闭＃ 1
小组完