Kuribo64
Views: 8,232,730 Home | Forums | Uploader | Wiki | Object databases | IRC
Rules/FAQ | Memberlist | Calendar | Stats | Online users | Last posts | Search
04-21-18 08:46 PM
Guest:

0 users reading [BUG] SMG Object Database displays error when you choose category | 1 bot

Main - Site help, bug reports, suggestions - [BUG] SMG Object Database displays error when you choose category New reply


Hiccup
Posted on 05-15-15 02:29 PM Link | #59841
When selecting "beta objects" (a category that I find to be made useless by the "unused" category"):
MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0} AND sr.games & 1 ORDER BY s.id' at line 9
Query: SELECT sr.games, s.*, le.id leid, le.name lename, le.sex lesex, le.power lepower FROM spriterevisions sr LEFT JOIN sprites s ON s.id=sr.id AND s.revision=sr.revision LEFT JOIN users le ON le.id=s.lasteditor where s.category={0} AND sr.games & 1 ORDER BY s.id

StapleButter
Posted on 05-15-15 02:32 PM Link | #59842
There, should be fixed.

____________________
NSMBHD - Kafuka - Jul

what do you use to measure bolts? a boltmeter

Hiccup
Posted on 05-15-15 03:22 PM Link | #59843
Thanks

Hiccup
Posted on 05-18-15 07:13 AM Link | #59900
Also: Recent changes show the last person that edited as the author of all changes.

StapleButter
Posted on 05-18-15 08:24 AM Link | #59903
Fixed.

____________________
NSMBHD - Kafuka - Jul

what do you use to measure bolts? a boltmeter

Hiccup
Posted on 05-18-15 10:50 AM (rev. 4 of 05-18-15 02:15 PM) Link | #59907
There seem to be some missing objects:
DragonHeadFlower
SkeletalFishBabyRail
TsukidashikunBig
CrystalSwitch
EterminationMeramera
HitWalltimerSwitch
PTimerSwitch
BossPlanetR50
RevolvingWay
UFOBlueStarCupsule
KillerGunnerTriple
MeteoContainer
MiniKoopaBattleVs3Galaxy
EffectObjSample
DrainPipeBubbleA
DrainPipeBubbleB
LavaSparksL
SpaceDustS
BossKameckPattarn
BossKameck2Pattarn

Sources:
http://sunakazekun.bplaced.net/files/smg
https://tcrf.net/Super_Mario_Galaxy#Removed_Objects


Also, I found a pastebin which seems to have even more?
http://pastebin.com/egajXYsp

SunakazeKun
Posted on 05-18-15 11:16 AM Link | #59908
Ignore the pastebin thing. Looks like it is every text dumped from the DOL.



Youtube | Github | Neo Mario Galaxy | Super Mario Galaxy & Super Mario 3D Land Modding


shibboleet
Posted on 05-18-15 03:24 PM Link | #59910
>looks like it is every text dumped from the dol

dude those are hashes

____________________
a

StapleButter
Posted on 05-18-15 03:29 PM (rev. 2 of 05-18-15 03:32 PM) Link | #59911
That's how they found most of the BCSV field hashes I guess-- hashing every potential string found in the binary.

Those are unrelated to the ObjectDB, too-- object names are in there, but there are also many many other things.

____________________
NSMBHD - Kafuka - Jul

what do you use to measure bolts? a boltmeter

shibboleet
Posted on 05-18-15 03:32 PM Link | #59912
Well yeah you dumped the ObjNameTable, Ithink. Which doesn't have everything in it.

____________________
a

SunakazeKun
Posted on 05-19-15 07:57 AM Link | #59929
Posted by MrRean
dude those are hashes

I forgot looking on the left side.



Youtube | Github | Neo Mario Galaxy | Super Mario Galaxy & Super Mario 3D Land Modding


Hiccup
Posted on 05-19-15 09:39 AM (rev. 2 of 05-19-15 09:44 AM) Link | #59934
Could the missing objects be added (including all the ones I didn't list)?

I am willing to organise/document them. (i.e. naming them, testing them (in SMG at least))

SunakazeKun
Posted on 05-19-15 11:47 AM Link | #59935
I already tested all undocumented, unused objects. There is no need to test them again.



Youtube | Github | Neo Mario Galaxy | Super Mario Galaxy & Super Mario 3D Land Modding


Hiccup
Posted on 05-19-15 02:22 PM Link | #59942
Well. These documentations could do with being in the object database :P. And I'm sure they could be expanded upon.

SunakazeKun
Posted on 05-19-15 02:40 PM Link | #59944

Hiccup
Posted on 05-20-15 06:49 AM Link | #59978
I have seen that list. I used it as a source for my missing objects list.


Main - Site help, bug reports, suggestions - [BUG] SMG Object Database displays error when you choose category New reply

Page rendered in 0.034 seconds. (2048KB of memory used)
MySQL - queries: 26, rows: 220/220, time: 0.021 seconds.
[powered by Acmlm] Acmlmboard 2.064 (2017-11-20)
© 2005-2008 Acmlm, Xkeeper, blackhole89 et al.