Mysqldan Bilgi Çekip Düzenlemem lazım

[gstsfb123]

Beyler k.bakmayın autoit ile alakalı çok fazla bir bilgim yok koda form desinger programı ile yaptığım tasarım a mysql alanımdan veri çekip düzenleyip geri kaydetmek için bir çalışma yaptım fakat komut kodlarından hiç anlamıyorum bu anlatmaya çalıştığım şey mysql alanımda şöyle yer almakta

DB min yolu

Player sekmesinin içinde item_proto dosyası

Player>item_proto

ben bu
item protonun içinden vnum bölmesinden kod aratıcam üstteki ara butonu onun içinden arıyor

[img]http://www.tnctr.com/uploads/imgs/pre_1310892777__adsz.png[/img]

DB'deki tablonun resmi burdan msla 11299 u arattım ordan program kendi içinden bulsun soldaki type subtype fln gibi yerleri yerlerine göre sıralasın formdaki yaptığım gibi sırası değişik olması gerekiyorda

[img]http://www.tnctr.com/uploads/imgs/pre_1310893194__adsz.png[/img]

birde alt tarafa yeni diye buton koymuştum oda arama yapmadan alanları doldurduğumda yeni bir satır oluşturabilirmiyiz

yardımlarınız için çok teşekkürler harika bir forum formun kodları

[code]#include <ButtonConstants.au3>
#include <EditConstants.au3>
#include <GUIConstantsEx.au3>
#include <StaticConstants.au3>
#include <WindowsConstants.au3>
GUISetState(@SW_SHOW)
$Form1_1 = GUICreate("X-Virus İtem Proto Editor", 1018, 456, 155, 112, -1)
$Group1 = GUICtrlCreateGroup("Bilgiler", 8, 64, 1001, 385, BitOR($GUI_SS_DEFAULT_GROUP,$BS_FLAT))

$Label2 = GUICtrlCreateLabel("Vnum :", 16, 88, 37, 17)
$vnum = GUICtrlCreateInput("", 64, 86, 105, 21)

$Label3 = GUICtrlCreateLabel("Locale_Name :", 184, 88, 76, 17)
$local_name = GUICtrlCreateInput("", 256, 86, 105, 21)

$Label4 = GUICtrlCreateLabel("Type :", 368, 88, 34, 17)
$type = GUICtrlCreateInput("", 408, 86, 105, 21)

$Label5 = GUICtrlCreateLabel("Subtype :", 520, 88, 49, 17)
$subtype = GUICtrlCreateInput("", 576, 86, 105, 21)

$Label6 = GUICtrlCreateLabel("Weight :", 688, 88, 44, 17)
$weight = GUICtrlCreateInput("", 736, 86, 105, 21)

$Label7 = GUICtrlCreateLabel("Size :", 848, 88, 30, 17)
$size = GUICtrlCreateInput("", 896, 86, 105, 21)

$Label8 = GUICtrlCreateLabel("Antiflag :", 16, 128, 45, 17)
$antiflag = GUICtrlCreateInput("", 64, 126, 105, 21)

$Label9 = GUICtrlCreateLabel("Flag :", 184, 128, 30, 17)
$flag = GUICtrlCreateInput("", 256, 126, 105, 21)

$Label10 = GUICtrlCreateLabel("W.Flag :", 368, 128, 44, 17)
$wearflag = GUICtrlCreateInput("", 408, 126, 105, 21)

$Label11 = GUICtrlCreateLabel("İm.Flag :", 520, 128, 44, 17)
$immuneflag = GUICtrlCreateInput("", 576, 126, 105, 21)

$Label12 = GUICtrlCreateLabel("Gold :", 688, 128, 32, 17)
$gold = GUICtrlCreateInput("", 736, 126, 105, 21)

$Label13 = GUICtrlCreateLabel("B.Price :", 848, 128, 44, 17)
$shop_buy_price = GUICtrlCreateInput("", 896, 126, 105, 21)

$Label14 = GUICtrlCreateLabel("Limittype0 :", 16, 168, 57, 17)
$limittype0 = GUICtrlCreateInput("", 80, 166, 105, 21)

$Label15 = GUICtrlCreateLabel("Limitvalue0 :", 192, 168, 63, 17)
$limitvalue0 = GUICtrlCreateInput("", 272, 166, 105, 21)

$Label16 = GUICtrlCreateLabel("Limittype1 :", 384, 168, 57, 17)
$limittype1 = GUICtrlCreateInput("", 456, 166, 105, 21)

$Label17 = GUICtrlCreateLabel("LimittypeV.1 :", 568, 168, 67, 17)
$limitvalue1 = GUICtrlCreateInput("", 632, 166, 105, 21)

$Label18 = GUICtrlCreateLabel("Applytype0 :", 744, 168, 62, 17)
$applytype0 = GUICtrlCreateInput("", 816, 166, 105, 21)

$Label19 = GUICtrlCreateLabel("ApplyV.0 :", 16, 208, 52, 17)
$applyvalue0 = GUICtrlCreateInput("", 80, 206, 105, 21)

$Label20 = GUICtrlCreateLabel("Applytype1 :", 192, 208, 62, 17)
$applytype1 = GUICtrlCreateInput("", 272, 206, 105, 21)

$Label21 = GUICtrlCreateLabel("ApplyV.1 :", 384, 208, 52, 17)
$applyvalue1 = GUICtrlCreateInput("", 456, 206, 105, 21)

$Label22 = GUICtrlCreateLabel("Applytype2 :", 568, 208, 62, 17)
$applytype2 = GUICtrlCreateInput("", 632, 206, 105, 21)

$Label23 = GUICtrlCreateLabel("Apply.V.2 :", 744, 208, 55, 17)
$applyvalue2 = GUICtrlCreateInput("", 816, 206, 105, 21)

$Label24 = GUICtrlCreateLabel("Value0 :", 16, 248, 43, 17)
$value0 = GUICtrlCreateInput("", 80, 246, 105, 21)

$Label25 = GUICtrlCreateLabel("Value1 :", 192, 248, 43, 17)
$value1 = GUICtrlCreateInput("", 272, 246, 105, 21)

$Label26 = GUICtrlCreateLabel("Value2 :", 384, 248, 43, 17)
$value2 = GUICtrlCreateInput("", 456, 246, 105, 21)

$Label27 = GUICtrlCreateLabel("Value3 :", 568, 248, 43, 17)
$value3 = GUICtrlCreateInput("", 632, 246, 105, 21)

$Label28 = GUICtrlCreateLabel("Value4 :", 752, 248, 43, 17)
$value4 = GUICtrlCreateInput("", 816, 246, 105, 21)

$Label29 = GUICtrlCreateLabel("Value5 :", 16, 288, 43, 17)
$value5 = GUICtrlCreateInput("", 80, 286, 105, 21)

$Label30 = GUICtrlCreateLabel("Socket0 :", 192, 288, 50, 17)
$socket0 = GUICtrlCreateInput("", 272, 286, 105, 21)

$Label31 = GUICtrlCreateLabel("Socket1 :", 384, 288, 50, 17)
$socket1 = GUICtrlCreateInput("", 456, 286, 105, 21)

$Label32 = GUICtrlCreateLabel("Socket2 :", 568, 288, 50, 17)
$socket2 = GUICtrlCreateInput("", 632, 286, 105, 21)

$Label33 = GUICtrlCreateLabel("Socket3 :", 744, 288, 50, 17)
$socket3 = GUICtrlCreateInput("", 816, 286, 105, 21)

$Label34 = GUICtrlCreateLabel("Socket4 :", 16, 328, 50, 17)
$socket4 = GUICtrlCreateInput("", 80, 326, 105, 21)

$Label35 = GUICtrlCreateLabel("Socket5 :", 192, 328, 50, 17)
$socket5 = GUICtrlCreateInput("", 272, 326, 105, 21)

$Label36 = GUICtrlCreateLabel("Refined_Vnum :", 384, 328, 80, 17)
$refined_vnum = GUICtrlCreateInput("", 456, 326, 105, 21)

$Label37 = GUICtrlCreateLabel("Refine_Set :", 568, 328, 63, 17)
$refine_set = GUICtrlCreateInput("", 632, 326, 105, 21)

$Label38 = GUICtrlCreateLabel("Magic_Pct :", 744, 328, 61, 17)
$magic_pct = GUICtrlCreateInput("", 816, 326, 105, 21)

$Label39 = GUICtrlCreateLabel("Specular :", 16, 368, 52, 17)
$specular = GUICtrlCreateInput("", 80, 366, 105, 21)

$Label40 = GUICtrlCreateLabel("Socket_Pct", 192, 368, 60, 17)
$socket_pct = GUICtrlCreateInput("", 272, 366, 105, 21)

$Label41 = GUICtrlCreateLabel("Refine_Set2 :", 568, 368, 69, 17)
$refine_set2 = GUICtrlCreateInput("", 632, 366, 105, 21)

$Label42 = GUICtrlCreateLabel("Addon_Type :", 384, 368, 71, 17)
$addon_type = GUICtrlCreateInput("", 456, 366, 105, 21)

$Label43 = GUICtrlCreateLabel("Name :", 744, 368, 38, 17)
$name = GUICtrlCreateInput("", 816, 366, 105, 21)

$Group2 = GUICtrlCreateGroup("Arama", 8, 8, 233, 57, BitOR($GUI_SS_DEFAULT_GROUP,$BS_FLAT))

$Label1 = GUICtrlCreateLabel("İtem kodu :", 18, 34, 54, 17)
$itemkodu = GUICtrlCreateInput("", 72, 32, 97, 21)

$Button1 = GUICtrlCreateButton("Ara", 176, 32, 57, 21)

$Ekle = GUICtrlCreateButton("Ekle", 136, 400, 113, 41)
$Button2 = GUICtrlCreateButton("Kaydet", 16, 400, 113, 41)

$kapat2 = GUICtrlCreateButton("Kapat", 256, 400, 113, 41)
GUICtrlSetOnEvent($kapat2, "_kapat")
GUISetState(@SW_SHOW)

func _kapat ()
Exit
EndFunc

Sleep (1)


While 1
$nMsg = GUIGetMsg()
Switch $nMsg
Case $GUI_EVENT_CLOSE
Exit
case $Button1
$mysql=_MySQLConnect("root","12345","player","192.168.1.100")
_Query($mysql, "select * from item_proto where vnum like '%"&GUICtrlRead($itemkodu)&"%'")
EndSwitch
WEnd

[/code]

bunlarda DB'mde yer alan üst satırdaki isimler vnum gibi

[code]vnum
locale_name
type
subtype
weight
size
antiflag
flag
wearflag
immuneflag
gold
shop_buy_price
limittype0
limitvalue0
limittype1
limitvalue1
applytype0
applyvalue0
applytype1
applyvalue1
applytype2
applyvalue2
value0
value1
value2
value3
value4
value5
socket0
socket1
socket2
socket3
socket4
socket5
refined_vnum
refine_set
magic_pct
specular
socket_pct
addon_type
refine_set2
name[/code] Edited July 20, 2011 by gstsfb123

[TalhaZekeriyaDurmuş]

mysql.au3 ü include et öncelikle
http://www.autoitscript.com/forum/topic/20814-mysql-udfs/ buradan bulabilirsin.
GUICtrlCreateInput("", 72, 32, 97, 21) bunu $itemkodu=GUICtrlCreateInput("", 72, 32, 97, 21) olarak değiştir
case $Button1
$mysql=_MySQLConnect("root","12345","player","192.168.1.100")
_Query($mysql, "select * from item_proto where vnum like '%"&GUICtrlRead($itemkodu)&"%'")
bunları da exitin altına koy

[asmazh]

@gstsfb123
bu database yi hangi programla oluşturdun? SQL SERVER ile mi?
Yoksa herhangi bir oyunun pvp serveri için nacivat ı mı kullanıyorsun?

Edited July 19, 2011 by asmazh

[gstsfb123]

ewt navicat kullanıyorumda fakat hala yapamadım