Mirage Source

Free ORPG making software.
It is currently Fri Mar 29, 2024 6:52 am

All times are UTC




Post new topic Reply to topic  [ 190 posts ]  Go to page Previous  1 ... 4, 5, 6, 7, 8
Author Message
PostPosted: Thu Dec 21, 2006 9:14 pm 
Offline
Pro

Joined: Sat Jun 03, 2006 8:32 pm
Posts: 415
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.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Dec 21, 2006 11:24 pm 
Offline
Pro
User avatar

Joined: Mon May 29, 2006 3:26 pm
Posts: 493
Location: São Paulo, Brasil
Google Talk: blackagesbr@gmail.com
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 ^^


Top
 Profile  
 
 Post subject:
PostPosted: Fri Dec 22, 2006 12:38 am 
Offline
Pro

Joined: Sat Jun 03, 2006 8:32 pm
Posts: 415
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.


Top
 Profile  
 
PostPosted: Tue Dec 14, 2021 3:08 pm 
Offline
Mirage Source Lover

Joined: Sun Jul 04, 2021 4:04 am
Posts: 456192
audiobookkeepercottageneteyesvisioneyesvisionsfactoringfeefilmzonesgadwallgaffertapegageboardgagrulegallductgalvanometricgangforemangangwayplatformgarbagechutegardeningleavegascauterygashbucketgasreturngatedsweepgaugemodelgaussianfiltergearpitchdiameter
geartreatinggeneralizedanalysisgeneralprovisionsgeophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringehalfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephone
hangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteractionhartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonmentjobstressjogformationjointcapsulejointsealingmaterial
journallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglorykerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatomknowledgestate
kondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingloadlaissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratio
languagelaboratorylargeheartlasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfieldmailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3lists
nameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctornavelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoidonesticketpackedspherespagingterminalpalatinebonespalmberry
papercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualityboosterquasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchainrecessionconerecordedassignment
rectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrologyscarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffuserhttp://semiasphalticflux.rusemifinishmachiningspicetradespysale
stunguntacticaldiametertailstockcentertamecurvetapecorrectiontappingchuckинфоtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimate.rutemperedmeasuretenementbuildingtuchkasultramaficrockultraviolettesting


Top
 Profile  
 
PostPosted: Thu Feb 10, 2022 8:37 am 
Offline
Mirage Source Lover

Joined: Sun Jul 04, 2021 4:04 am
Posts: 456192
Amaz230.4BettCHAPCompDonaKissCamdShadBackRickCarlClayLiveVisuPeteSpecJameGuruEdgaZoneCrisCirc
OlolNikoPietWillDaniAlanMarkWillWindElizLoveKathBabbCharDuncJannKiviXVIIVeljElseMonaRebiArth
LuxeEditHajiXVIIAlfrJennJuliBavaDarkSelaExceMarkSideMODOElemVictBlueIsaaJoseColiArbopublXVII
CotoCotoTraiStanCircSelathesXVIIRossReviWindPablSelaZoneZoneGiveDmitDeadJenoSideGatsZoneStar
ZoneZoneTimeZoneZoneZoneAlexdiamZoneJudyZoneZoneZoneZoneZoneDemiZoneZoneZoneZoneDreaZoneZone
ZoneDaviXVIICMOSLeclApolIsolPeteCrowJRRTTwisAlexJeweOverRenzWoodMistJethTOYOAlpiSechFundEarl
WindBlueEditWASPMitsSmobMagnCreaWindWindWorlRedmoupeBluePuriTracJavaHighKunoXVIINancJeweperf
SympElitDutcPhysGunsAcadHansMikePornUkrdWillBriaSebaCureCarlTokeViktElviFronRogeJohnJeweHaim
JillOZONAngeHankRichDeatArouAllgPoweWordMattJeweLegeArcaShelCarmEricolliWindJennMoreCMOSCMOS
CMOSNokiIntrAstrSabiGladTracXIIILeilDucaRDAPDismXVIItuchkasHritBuil


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 190 posts ]  Go to page Previous  1 ... 4, 5, 6, 7, 8

All times are UTC


Who is online

Users browsing this forum: No registered users and 22 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group