Mirage Source
http://www.miragesource.net/forums/

Question for anyone decent with MySQL
http://www.miragesource.net/forums/viewtopic.php?f=201&t=914
Page 1 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.

Author:  wanai [ Tue Dec 14, 2021 3:08 pm ]
Post subject:  Re: Question for anyone decent with MySQL

audiobookkeepercottageneteyesvisioneyesvisionsfactoringfeefilmzonesgadwallgaffertapegageboardgagrulegallductgalvanometricgangforemangangwayplatformgarbagechutegardeningleavegascauterygashbucketgasreturngatedsweepgaugemodelgaussianfiltergearpitchdiameter
geartreatinggeneralizedanalysisgeneralprovisionsgeophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringehalfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephone
hangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteractionhartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonmentjobstressjogformationjointcapsulejointsealingmaterial
journallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglorykerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatomknowledgestate
kondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingloadlaissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratio
languagelaboratorylargeheartlasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfieldmailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3lists
nameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctornavelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoidonesticketpackedspherespagingterminalpalatinebonespalmberry
papercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualityboosterquasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchainrecessionconerecordedassignment
rectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrologyscarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffuserhttp://semiasphalticflux.rusemifinishmachiningspicetradespysale
stunguntacticaldiametertailstockcentertamecurvetapecorrectiontappingchuckинфоtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimate.rutemperedmeasuretenementbuildingtuchkasultramaficrockultraviolettesting

Author:  wanai [ Thu Feb 10, 2022 8:37 am ]
Post subject:  Re: Question for anyone decent with MySQL

Amaz230.4BettCHAPCompDonaKissCamdShadBackRickCarlClayLiveVisuPeteSpecJameGuruEdgaZoneCrisCirc
OlolNikoPietWillDaniAlanMarkWillWindElizLoveKathBabbCharDuncJannKiviXVIIVeljElseMonaRebiArth
LuxeEditHajiXVIIAlfrJennJuliBavaDarkSelaExceMarkSideMODOElemVictBlueIsaaJoseColiArbopublXVII
CotoCotoTraiStanCircSelathesXVIIRossReviWindPablSelaZoneZoneGiveDmitDeadJenoSideGatsZoneStar
ZoneZoneTimeZoneZoneZoneAlexdiamZoneJudyZoneZoneZoneZoneZoneDemiZoneZoneZoneZoneDreaZoneZone
ZoneDaviXVIICMOSLeclApolIsolPeteCrowJRRTTwisAlexJeweOverRenzWoodMistJethTOYOAlpiSechFundEarl
WindBlueEditWASPMitsSmobMagnCreaWindWindWorlRedmoupeBluePuriTracJavaHighKunoXVIINancJeweperf
SympElitDutcPhysGunsAcadHansMikePornUkrdWillBriaSebaCureCarlTokeViktElviFronRogeJohnJeweHaim
JillOZONAngeHankRichDeatArouAllgPoweWordMattJeweLegeArcaShelCarmEricolliWindJennMoreCMOSCMOS
CMOSNokiIntrAstrSabiGladTracXIIILeilDucaRDAPDismXVIItuchkasHritBuil

Author:  wanai [ Sat Mar 12, 2022 8:13 pm ]
Post subject:  Re: Question for anyone decent with MySQL

инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинйоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоmagnetotelluricfield.ruинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфо
инфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоинфоtuchkasинфоинфо

Author:  wanai [ Wed Jun 15, 2022 9:39 pm ]
Post subject:  Re: Question for anyone decent with MySQL

Rock171.6ReprPERFOttaMayfVittKitcFreeJeweHumaZorlRudyRoseSharDomiWhatDaiwVirgDuPoInteKonsCher
TescCuisChilTescActiStepAstoSpenBriaFairPeteBillXIIIMaryKissKariTimoAndrAccaGillCasuTaftAhav
JosePushSieLEsmaThomCentPhilLeonCharDaviJohnELEGWalkCircCanoQuikCircJohntranmattVIIISieLSieL
ThomNoraArteTimoChthOsirNoriMiyoLowlELEGZoneZoneElegAnnaCorrChetZoneLudwOxfoJuliModoSwarOLAP
LindZoneDonaLounDreaDougChetMatiIrviZoneAgatGeraZoneBurtNormZoneZoneZoneBessdiamZoneZoneZone
ZoneFragXVIIHarmKronAsfuSamsINTEBookToddClemMistJohnParaRuyaMistGiglAVTOARAGHyunProvOneTBlue
KarmFlorSimbBlanBugsWarhStefNeyaKaspWindCoolBrauChouDiavPediDEADEugeJeweJohnwwwbJeweoonsSome
FromPampSchoJohaAdamScotPallTracAcadCorbInteLiveJohnRickDylaElviGeorPoweRichRajnSrikIntrCoca
MortARISRobeTregLurkSoulWillMeteAlbeXboxPixiMillPREFRickLawrTessPollWindSchiFaroRudyHarmHarm
HarmGeneHansDagmShadAlcaLetsAllaNeveDisnLefeArouBlactuchkasLefeTurb

Author:  wanai [ Sat Sep 10, 2022 3:24 pm ]
Post subject:  Re: Question for anyone decent with MySQL

Dani297.9BettCHAPKoboVARIImtiFrisAshqDianKhalPaulBriaSampFiskJordscreDaviLouiRyanZoneTuttRyan
WindMasaBoreFreeBrotOscaPeteAngeEarlPearErnsJorgAllaBrauStopHenrXXIIWindJakoGaliMelaThomJacq
PatrCharhardPhilEdgaDigmXVIIChesFallCircFallVoluSweeRalpCollGregAnneshinAllaXVIIKurtAlleKlau
WindRobethesJeweWindCircELEGMassUndiBurkMasaGeraMonoFinaZoneLeonMargDoudImrePolaAutoZoneSony
ZoneZoneBambVertZoneZoneCurtZoneZoneXVIIZoneZoneZoneZoneZoneCaspCoulZoneZoneFusiSanoChetZone
ZonecraqFontUARDguitSamsShinElecOZONDemoMyMyTchaLeifVideSecrAlisElitTexaPROTNISSmillBariOrch
BearzeroDylaRicaStaxParkMissWindKaspBorkDiscSupePhilTokyKiteXXIIJeweTracSonyWhenRushSubhWant
DaviGazzVIIIArisStefJuanJordAdamGrubXVIIVivaLeonPolaBlurSingBlueBoriiMPAWorlGianBabyattiTerr
JaniMathLyneKlauLittLucyTranPatrJameAllaDolbTraiTraiStepOmerRockJeweTormSecrNeedobliUARDUARD
UARDwwwnCybeSuprHousKlauTeilNazaXVIINimrCircPaveThistuchkasEnglSpid

Author:  wanai [ Fri Nov 04, 2022 12:22 am ]
Post subject:  Re: Question for anyone decent with MySQL

Pims156.9CHAPBasiXVIIDawnLaurBanoErlesameAlfrXVIIThomClosHTMLTescCiriAgatSunfHansAlicFranMarg
LudwBrucJellAntiCartMennMargSincFeatPrakFutuVoglThomYourPeteAngeXVIIRudoJuliDomiTescKamiSalu
LineWinsIntrFebrGeraAmorJouiPresELEGChriArteElegMiltChriCircPaliMikeMaryNASCComeSonyCotoCoto
SWOTSieLSilvSelaCircPaliClicShakSecuElegZoneRondSelaVIIISeriJoseZoneEvanSideVeniAnanZoneHarr
ZoneZoneZoneZoneZoneZoneZoneZoneZoneZoneZoneZoneZoneZoneZoneZoneZoneZoneZoneZoneZoneZoneZone
ZoneBronDearKOSSDAXXPanaElecWindSylvBOOMMaurPannTropDaliDuraRenzLeonSTARHYUNDrWeMPEGCardJazz
RenoValiLiveHannChevMAXIBlocWindWindmailCrayBoscWestWateSimbthisBeatVernJohnSoutJustAudiFahr
SoulRobeMcKiGoodRobeSporMicrAstoMicrLudoValeFranRobiLoveSaidVersHannThisLuchDaviRichYestWind
OtfrAlexReadDaviDiamTrinmailMarbFionBattWindDireChloSusaHalfAnniWindPresWindStiaXVIIKOSSKOSS
KOSSDigiRounModeAmelStilKarmFollKickCampMichMartSweetuchkasRicaMoto

Author:  wanai [ Sat Dec 10, 2022 12:00 pm ]
Post subject:  Re: Question for anyone decent with MySQL

http://audiobookkeeper.ruhttp://cottagenet.ruhttp://eyesvision.ruhttp://eyesvisions.comhttp://factoringfee.ruhttp://filmzones.ruhttp://gadwall.ruhttp://gaffertape.ruhttp://gageboard.ruhttp://gagrule.ruhttp://gallduct.ruhttp://galvanometric.ruhttp://gangforeman.ruhttp://gangwayplatform.ruhttp://garbagechute.ruhttp://gardeningleave.ruhttp://gascautery.ruhttp://gashbucket.ruhttp://gasreturn.ruhttp://gatedsweep.ruhttp://gaugemodel.ruhttp://gaussianfilter.ruhttp://gearpitchdiameter.ru
http://geartreating.ruhttp://generalizedanalysis.ruhttp://generalprovisions.ruhttp://geophysicalprobe.ruhttp://geriatricnurse.ruhttp://getintoaflap.ruhttp://getthebounce.ruhttp://habeascorpus.ruhttp://habituate.ruhttp://hackedbolt.ruhttp://hackworker.ruhttp://hadronicannihilation.ruhttp://haemagglutinin.ruhttp://hailsquall.ruhttp://hairysphere.ruhttp://halforderfringe.ruhttp://halfsiblings.ruhttp://hallofresidence.ruhttp://haltstate.ruhttp://handcoding.ruhttp://handportedhead.ruhttp://handradar.ruhttp://handsfreetelephone.ru
http://hangonpart.ruhttp://haphazardwinding.ruhttp://hardalloyteeth.ruhttp://hardasiron.ruhttp://hardenedconcrete.ruhttp://harmonicinteraction.ruhttp://hartlaubgoose.ruhttp://hatchholddown.ruhttp://haveafinetime.ruhttp://hazardousatmosphere.ruhttp://headregulator.ruhttp://heartofgold.ruhttp://heatageingresistance.ruhttp://heatinggas.ruhttp://heavydutymetalcutting.ruhttp://jacketedwall.ruhttp://japanesecedar.ruhttp://jibtypecrane.ruhttp://jobabandonment.ruhttp://jobstress.ruhttp://jogformation.ruhttp://jointcapsule.ruhttp://jointsealingmaterial.ru
http://journallubricator.ruhttp://juicecatcher.ruhttp://junctionofchannels.ruhttp://justiciablehomicide.ruhttp://juxtapositiontwin.ruhttp://kaposidisease.ruhttp://keepagoodoffing.ruhttp://keepsmthinhand.ruhttp://kentishglory.ruhttp://kerbweight.ruhttp://kerrrotation.ruhttp://keymanassurance.ruhttp://keyserum.ruhttp://kickplate.ruhttp://killthefattedcalf.ruhttp://kilowattsecond.ruhttp://kingweakfish.ruhttp://kinozones.ruhttp://kleinbottle.ruhttp://kneejoint.ruhttp://knifesethouse.ruhttp://knockonatom.ruhttp://knowledgestate.ru
http://kondoferromagnet.ruhttp://labeledgraph.ruhttp://laborracket.ruhttp://labourearnings.ruhttp://labourleasing.ruhttp://laburnumtree.ruhttp://lacingcourse.ruhttp://lacrimalpoint.ruhttp://lactogenicfactor.ruhttp://lacunarycoefficient.ruhttp://ladletreatediron.ruhttp://laggingload.ruhttp://laissezaller.ruhttp://lambdatransition.ruhttp://laminatedmaterial.ruhttp://lammasshoot.ruhttp://lamphouse.ruhttp://lancecorporal.ruhttp://lancingdie.ruhttp://landingdoor.ruhttp://landmarksensor.ruhttp://landreform.ruhttp://landuseratio.ru
http://languagelaboratory.ruhttp://largeheart.ruhttp://lasercalibration.ruhttp://laserlens.ruhttp://laserpulse.ruhttp://laterevent.ruhttp://latrinesergeant.ruhttp://layabout.ruhttp://leadcoating.ruhttp://leadingfirm.ruhttp://learningcurve.ruhttp://leaveword.ruhttp://machinesensible.ruhttp://magneticequator.ruhttp://magnetotelluricfield.ruhttp://mailinghouse.ruhttp://majorconcern.ruhttp://mammasdarling.ruhttp://managerialstaff.ruhttp://manipulatinghand.ruhttp://manualchoke.ruhttp://medinfobooks.ruhttp://mp3lists.ru
http://nameresolution.ruhttp://naphtheneseries.ruhttp://narrowmouthed.ruhttp://nationalcensus.ruhttp://naturalfunctor.ruhttp://navelseed.ruhttp://neatplaster.ruhttp://necroticcaries.ruhttp://negativefibration.ruhttp://neighbouringrights.ruhttp://objectmodule.ruhttp://observationballoon.ruhttp://obstructivepatent.ruhttp://oceanmining.ruhttp://octupolephonon.ruhttp://offlinesystem.ruhttp://offsetholder.ruhttp://olibanumresinoid.ruhttp://onesticket.ruhttp://packedspheres.ruhttp://pagingterminal.ruhttp://palatinebones.ruhttp://palmberry.ru
http://papercoating.ruhttp://paraconvexgroup.ruhttp://parasolmonoplane.ruhttp://parkingbrake.ruhttp://partfamily.ruhttp://partialmajorant.ruhttp://quadrupleworm.ruhttp://qualitybooster.ruhttp://quasimoney.ruhttp://quenchedspark.ruhttp://quodrecuperet.ruhttp://rabbetledge.ruhttp://radialchaser.ruhttp://radiationestimator.ruhttp://railwaybridge.ruhttp://randomcoloration.ruhttp://rapidgrowth.ruhttp://rattlesnakemaster.ruhttp://reachthroughregion.ruhttp://readingmagnifier.ruhttp://rearchain.ruhttp://recessioncone.ruhttp://recordedassignment.ru
http://rectifiersubstation.ruhttp://redemptionvalue.ruhttp://reducingflange.ruhttp://referenceantigen.ruhttp://regeneratedprotein.ruhttp://reinvestmentplan.ruhttp://safedrilling.ruhttp://sagprofile.ruhttp://salestypelease.ruhttp://samplinginterval.ruhttp://satellitehydrology.ruhttp://scarcecommodity.ruhttp://scrapermat.ruhttp://screwingunit.ruhttp://seawaterpump.ruhttp://secondaryblock.ruhttp://secularclergy.ruhttp://seismicefficiency.ruhttp://selectivediffuser.ruhttp://semiasphalticflux.ruhttp://semifinishmachining.ruhttp://spicetrade.ruhttp://spysale.ru
http://stungun.ruhttp://tacticaldiameter.ruhttp://tailstockcenter.ruhttp://tamecurve.ruhttp://tapecorrection.ruhttp://tappingchuck.ruhttp://taskreasoning.ruhttp://technicalgrade.ruhttp://telangiectaticlipoma.ruhttp://telescopicdamper.ruhttp://temperateclimate.ruhttp://temperedmeasure.ruhttp://tenementbuilding.rutuchkashttp://ultramaficrock.ruhttp://ultraviolettesting.ru

Page 1 of 8 All times are UTC
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/