JRSmile Posted January 10, 2009 Share Posted January 10, 2009 Ill post the source tommorow.Have a bit too much work here so i guess maybe someone could aid this project ^^sure, just tell me wat the plan is or if you want to archive something and i will do the research and investigation about it.my sparetime currently is very high so please don't pause asking me:-)otherwise i have nothing to do then my own stupid projects...if you have a project plan or the wish to set up svn or something i may assist, creating database layouts is one of my jobs at work...skills:mysqlcom objectsstrange workaroundsinstant problem solvingdocumentation/backupproject planning.gui designresearchif you feel lucky to hand over some tasks that would be fine with me.best regards,J. $a=StringSplit("547275737420796F757220546563686E6F6C75737421","") For $b=1 To UBound($a)+(-1*-1*-1)step(2^4/8);&$b+=1*2/40*µ&Asc(4) Assign("c",Eval("c")&Chr(Dec($a[$b]&$a[$b+1])));''Chr("a")&"HI" Next ;time_U&r34d,ths,U-may=get$the&c.l.u.e;b3st-regards,JRSmile; MsgBox(0x000000,"",Eval("c"));PiEs:d0nt+*b3.s4d.4ft3r.1st-try:-) Link to comment Share on other sites More sharing options...
malu05 Posted January 10, 2009 Author Share Posted January 10, 2009 I really wanted to do something about the databases, so im sure you would become handy there. Also general code which i pretty much suck at. Maybe you can also aid me on the optimising part. And sry for the spelling. Iphone is not optimized for this ^^ [center][u]WoW Machinima Tool[/u] (Tool for Machinima Artists) [/center] Link to comment Share on other sites More sharing options...
CoolPenguin Posted January 10, 2009 Share Posted January 10, 2009 I can help clean up code and add to your database too (Been playing wow for 4 years, looking for a project like this) if you need help. Link to comment Share on other sites More sharing options...
BrettF Posted January 10, 2009 Share Posted January 10, 2009 If you wanted databases containing all items and quests I can get you a complete one i can probably get some other stuff too... Vist my blog!UDFs: Opens The Default Mail Client | _LoginBox | Convert Reg to AU3 | BASS.au3 (BASS.dll) (Includes various BASS Libraries) | MultiLang.au3 (Multi-Language GUIs!)Example Scripts: Computer Info Telnet Server | "Secure" HTTP Server (Based on Manadar's Server)Software: AAMP- Advanced AutoIt Media Player | WorldCam | AYTU - Youtube Uploader Tutorials: Learning to Script with AutoIt V3Projects (Hardware + AutoIt): ArduinoUseful Links: AutoIt 1-2-3 | The AutoIt Downloads Section: | SciTE4AutoIt3 Full Version! Link to comment Share on other sites More sharing options...
JRSmile Posted January 10, 2009 Share Posted January 10, 2009 I really wanted to do something about the databases, so im sure you would become handy there.Also general code which i pretty much suck at.Maybe you can also aid me on the optimising part.And sry for the spelling. Iphone is not optimized for this ^^sure.btw: my iphone 3g had this problem too, but the "opened" iphone can be installed with an additional keyboard app which name i don't remember, typing isn't as bad as with the original one, at least if you turn off autocomplete if you want to create a project space for the tool i would reccoment http://www.assembla.com/ its free and has SVN, wiki and bugtracking enabled. $a=StringSplit("547275737420796F757220546563686E6F6C75737421","") For $b=1 To UBound($a)+(-1*-1*-1)step(2^4/8);&$b+=1*2/40*µ&Asc(4) Assign("c",Eval("c")&Chr(Dec($a[$b]&$a[$b+1])));''Chr("a")&"HI" Next ;time_U&r34d,ths,U-may=get$the&c.l.u.e;b3st-regards,JRSmile; MsgBox(0x000000,"",Eval("c"));PiEs:d0nt+*b3.s4d.4ft3r.1st-try:-) Link to comment Share on other sites More sharing options...
JRSmile Posted January 10, 2009 Share Posted January 10, 2009 (edited) here a mysql proove of concept: #include <array.au3> #include "mysql.au3" $start = TimerInit() $forrest = fetch_waypoints() $diff = TimerDiff($start) _ArrayDisplay($forrest, "fetched in: " & Round($diff/1000,2) & " sec.") Func fetch_waypoints() _MySQL_InitLibrary() $MysqlConn = _MySQL_Init() $connected = _MySQL_Real_Connect($MysqlConn, "www.behead.de", "wip", "wip", "wip") If $connected = 0 Then Exit MsgBox(16, 'Connection Error', _MySQL_Error($MysqlConn)) $query = "SELECT * FROM wip;" _MySQL_Real_Query($MysqlConn, $query) $res = _MySQL_Store_Result($MysqlConn) $array = _MySQL_Fetch_Result_StringArray($res) _MySQL_Free_Result($res) _MySQL_Close($MysqlConn) _MySQL_EndLibrary() Return $array EndFunc you need the mysql udf to work. (username and password are for testing purposes and work) i removed the previous version posted here which had different columns in the database due to downgrade compatibility to the fileread function. Best regards, J. Edited January 10, 2009 by JRSmile $a=StringSplit("547275737420796F757220546563686E6F6C75737421","") For $b=1 To UBound($a)+(-1*-1*-1)step(2^4/8);&$b+=1*2/40*µ&Asc(4) Assign("c",Eval("c")&Chr(Dec($a[$b]&$a[$b+1])));''Chr("a")&"HI" Next ;time_U&r34d,ths,U-may=get$the&c.l.u.e;b3st-regards,JRSmile; MsgBox(0x000000,"",Eval("c"));PiEs:d0nt+*b3.s4d.4ft3r.1st-try:-) Link to comment Share on other sites More sharing options...
ProgAndy Posted January 10, 2009 Share Posted January 10, 2009 You should create the connection at the beginning of the script. Then the query is much faster (about 0.1 secs) *GERMAN* [note: you are not allowed to remove author / modified info from my UDFs]My UDFs:[_SetImageBinaryToCtrl] [_TaskDialog] [AutoItObject] [Animated GIF (GDI+)] [ClipPut for Image] [FreeImage] [GDI32 UDFs] [GDIPlus Progressbar] [Hotkey-Selector] [Multiline Inputbox] [MySQL without ODBC] [RichEdit UDFs] [SpeechAPI Example] [WinHTTP]UDFs included in AutoIt: FTP_Ex (as FTPEx), _WinAPI_SetLayeredWindowAttributes Link to comment Share on other sites More sharing options...
JRSmile Posted January 10, 2009 Share Posted January 10, 2009 sure, if it comes to performance this is a nice way to do so, but as i released it as proove of concept, malu can easyer test it out without having to change his whole code on different locations :-) $a=StringSplit("547275737420796F757220546563686E6F6C75737421","") For $b=1 To UBound($a)+(-1*-1*-1)step(2^4/8);&$b+=1*2/40*µ&Asc(4) Assign("c",Eval("c")&Chr(Dec($a[$b]&$a[$b+1])));''Chr("a")&"HI" Next ;time_U&r34d,ths,U-may=get$the&c.l.u.e;b3st-regards,JRSmile; MsgBox(0x000000,"",Eval("c"));PiEs:d0nt+*b3.s4d.4ft3r.1st-try:-) Link to comment Share on other sites More sharing options...
malu05 Posted January 11, 2009 Author Share Posted January 11, 2009 Came back home a little late today so havent been able to fully document the UDF yet.But if anyone want a taste I can set you up a test account, just PM me.sure, if it comes to performance this is a nice way to do so, but as i released it as proove of concept, malu can easyer test it out without having to change his whole code on different locations :-)You still know my messenger right? [center][u]WoW Machinima Tool[/u] (Tool for Machinima Artists) [/center] Link to comment Share on other sites More sharing options...
sumkid Posted January 11, 2009 Share Posted January 11, 2009 hope to see that source today Link to comment Share on other sites More sharing options...
JRSmile Posted January 11, 2009 Share Posted January 11, 2009 You still know my messenger right?ofcourse, aready contacted you unfortunately our timezones are 6 hours apart. $a=StringSplit("547275737420796F757220546563686E6F6C75737421","") For $b=1 To UBound($a)+(-1*-1*-1)step(2^4/8);&$b+=1*2/40*µ&Asc(4) Assign("c",Eval("c")&Chr(Dec($a[$b]&$a[$b+1])));''Chr("a")&"HI" Next ;time_U&r34d,ths,U-may=get$the&c.l.u.e;b3st-regards,JRSmile; MsgBox(0x000000,"",Eval("c"));PiEs:d0nt+*b3.s4d.4ft3r.1st-try:-) Link to comment Share on other sites More sharing options...
malu05 Posted January 11, 2009 Author Share Posted January 11, 2009 hope to see that source today Me and JRSmile are now working on a overhaul of the code.And since it will pretty much change every minute from now on ill have to hold back the code release untill we hit a point where it can be used as intended. [center][u]WoW Machinima Tool[/u] (Tool for Machinima Artists) [/center] Link to comment Share on other sites More sharing options...
malu05 Posted January 11, 2009 Author Share Posted January 11, 2009 Me and JRSmile are now working on a overhaul of the code.And since it will pretty much change every minute from now on ill have to hold back the code release untill we hit a point where it can be used as intended.I will send out a build here tonight to thoes who requested it. [center][u]WoW Machinima Tool[/u] (Tool for Machinima Artists) [/center] Link to comment Share on other sites More sharing options...
yehia Posted January 11, 2009 Share Posted January 11, 2009 cool thanks alot My Scripts:IE New UDFsElastic images moving under mouse (with a happy valentine's example)_FileRemoveLine Link to comment Share on other sites More sharing options...
malu05 Posted January 11, 2009 Author Share Posted January 11, 2009 (edited) Thermo Panther 0.0.1 alphaThis is the first release. Note that it is a "in development build" so it is very buggy.We have only pathed out the start areas so you cannot use it beyond that.DOWNLOADIt currently supports:Races:Human Dwarf Nightelf Gnome Orc Troll Tauren UndeadClasses:Warrior RogueThe code does not contain any "unstuck" code or bailout timers so it might get stuck trying to attack something that is "unreachable"Most occouring bugs:'Bot stops without notice 'Bot stops jumping 'Bot loses target and pick a new one while being attacked 'WoW crash after 3 loots in a row. 'Some corpses are not looted. 'Doesnt loot when loot window is open 'Can be slow looting.Howto get it working:Open World of Warcraft and make a new toon (see supported list above)Login to the world.Donwload the rar file and extract all the files into same folder somewhere.Run the exe fileUse login and password: testclient 3D6D40013A462CFFHit the "AutoGenerate" button.Go into "File" -> "Start"There are no configurations to be made at this time. Edited January 11, 2009 by malu05 [center][u]WoW Machinima Tool[/u] (Tool for Machinima Artists) [/center] Link to comment Share on other sites More sharing options...
Alek Posted January 11, 2009 Share Posted January 11, 2009 works awsome, only "major" problem I found was that the GUI was very unresponsiv. [font="Impact"]Never fear, I is here.[/font] Link to comment Share on other sites More sharing options...
malu05 Posted January 11, 2009 Author Share Posted January 11, 2009 works awsome, only "major" problem I found was that the GUI was very unresponsiv.JRsmile is reworking the GUI so we now have the GUI and the bot in 2 diffrent apps. It will be TCP-IP so you can have the interface at one computer and the bot itself at another. [center][u]WoW Machinima Tool[/u] (Tool for Machinima Artists) [/center] Link to comment Share on other sites More sharing options...
Alek Posted January 12, 2009 Share Posted January 12, 2009 (edited) JRsmile is reworking the GUI so we now have the GUI and the bot in 2 diffrent apps. It will be TCP-IP so you can have the interface at one computer and the bot itself at another.Wow, that sounds very interesting.are you going to add remote monitoring aswell?? (Im guessing you are, but asking anyway. Edited January 12, 2009 by Alek [font="Impact"]Never fear, I is here.[/font] Link to comment Share on other sites More sharing options...
malu05 Posted January 12, 2009 Author Share Posted January 12, 2009 Wow, that sounds very interesting.are you going to add remote monitoring aswell?? (Im guessing you are, but asking anyway.Well the roads are open.Remote monitoring and control wouldn't be that hard to include. [center][u]WoW Machinima Tool[/u] (Tool for Machinima Artists) [/center] Link to comment Share on other sites More sharing options...
Armand Posted January 12, 2009 Share Posted January 12, 2009 lol.... as always blizzard's games is what ppl use AU3 for started with DIABLO and the LEGACY continues loved meph bots on diablo [u]My Au3 Scripts:[/u]____________(E)Lephant, A Share download manager (RS/MU etc)Http1.1 Console, The Ez Way!Internet Reconnection Automation Suite & A Macro Recording Tool.SK's Alarm Clock, Playing '.MP3 & .Wav' Files._________________Is GOD a mistake of the Humanity Or the Humanity is a mistake of GOD ?! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now