Mirage Source http://miragesource.net/forums/ |
|
Question for anyone decent with MySQL http://miragesource.net/forums/viewtopic.php?f=201&t=914 |
Page 8 of 8 |
Author: | halla [ Thu Dec 21, 2006 9:14 pm ] |
Post subject: | Question for anyone decent with MySQL |
Ok im adding the custom experience guide. Its no problem but im using 3.0.7 which uses mysql instead of ini files. Ok that shouldnt be a big deal right? Just find how it loads other tables and so the same but for exp... well I copied loadnpcs and then switched all for the exp table and doesnt look bad but gets this error... With object must be user-defined type, Object, or Variant Then it highlights WITH Heres the code.. Code: Sub LoadExps()
Dim i As Long Dim cCount As Long Dim RS As ADODB.Recordset 'Setup database stuff Set RS = New ADODB.Recordset RS.Open "SELECT * FROM exps;", Conn_Server, adOpenStatic, adLockReadOnly If RS.EOF Then Exit Sub RS.MoveFirst For i = 1 To MAX_EXP Call SetStatus("Loading Exp " & i & "/" & MAX_EXP) With Exp(i) .FKey = CLng(RS("FKey")) .Exp = CLng(RS("Exp")) End With DoEvents If i <> MAX_EXP Then RS.MoveNext End If Next i RS.Close Set RS = Nothing End Sub My table is set up simple. Theres FKey and then Exp and thats it ... should be enough. |
Author: | Dragoons Master [ Thu Dec 21, 2006 11:24 pm ] |
Post subject: | |
I use 303 w/ mysql, added my self. If you need any help, add me on msn(mailto:azchohfi@hotmail.com) and/or gtalk(mailto:blackagesbr@gmail.com). The code seams to be fine. If its not working, probly the data base is not beeing started up correctly thru VB. Tell me the exact error so I can help you better ^^ |
Author: | halla [ Fri Dec 22, 2006 12:38 am ] |
Post subject: | |
Ok I added you to MSN. Its the Custom Experience tutorial from the old servers I just changed the part that loads it to work with MySQL. I guess I got some part wrong there. Like for the original it loads EXP1, EXP2 and so on... but sql is different unless making a row for each one which wouldnt make sense. |
Page 8 of 8 | All times are UTC |
Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |