[BUG] SMG Object Database displays error when you choose category


Views: 22,888,880	Home \| Forums \| Uploader \| Wiki \| Object databases \| IRC Rules/FAQ \| Memberlist \| Calendar \| Stats \| Online users \| Last posts \| Search	10-04-24 05:23 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

Hide post layouts | New reply

Hiccup

Posted on 05-15-15 06:29 PM

Link | #59841

Normal user

Level: 58

Posts: 204/815
EXP: 1545311
Next: 32235

Since: 09-06-12

Last post: 1853 days ago
Last view: 208 days ago

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

Arisotura

Posted on 05-15-15 06:32 PM

Link | #59842

Star Mario
in this room you have a pile of apple pies

Level: 164

Posts: 3697/9039
EXP: 57499050
Next: 203340

Since: 07-03-12
From: in a box

Last post: 3 days ago
Last view: 3 days ago

There, should be fixed.

____________________
NSMBHD - Kafuka - Jul
melonDS the most fruity DS emulator there is

zafkflzdasd

Hiccup

Posted on 05-15-15 07:22 PM

Link | #59843

Normal user

Level: 58

Posts: 205/815
EXP: 1545311
Next: 32235

Since: 09-06-12

Last post: 1853 days ago
Last view: 208 days ago

Thanks

Hiccup

Posted on 05-18-15 11:13 AM

Link | #59900

Normal user

Level: 58

Posts: 206/815
EXP: 1545311
Next: 32235

Since: 09-06-12

Last post: 1853 days ago
Last view: 208 days ago

Also: Recent changes show the last person that edited as the author of all changes.

Arisotura

Posted on 05-18-15 12:24 PM

Link | #59903

Star Mario
in this room you have a pile of apple pies

Level: 164

Posts: 3706/9039
EXP: 57499050
Next: 203340

Since: 07-03-12
From: in a box

Last post: 3 days ago
Last view: 3 days ago

Fixed.

____________________
NSMBHD - Kafuka - Jul
melonDS the most fruity DS emulator there is

zafkflzdasd

Hiccup

Posted on 05-18-15 02:50 PM (rev. 4 of 05-18-15 06:15 PM)

Link | #59907

Normal user

Level: 58

Posts: 208/815
EXP: 1545311
Next: 32235

Since: 09-06-12

Last post: 1853 days ago
Last view: 208 days ago

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 03:16 PM

Link | #59908

Boss Bass
Normal user

Level: 75

Posts: 1109/1551
EXP: 3747679
Next: 79225

Since: 06-15-14
From: Germany

Last post: 2448 days ago
Last view: 2421 days ago

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 07:24 PM

Link | #59910

Fire Mario
DROP TABLE users;

Level: 124

Posts: 3696/4661
EXP: 21280255
Next: 556346

Since: 07-07-12

Last post: 1511 days ago
Last view: 524 days ago

>looks like it is every text dumped from the dol

dude those are hashes

____________________
a

Arisotura

Posted on 05-18-15 07:29 PM (rev. 2 of 05-18-15 07:32 PM)

Link | #59911

Star Mario
in this room you have a pile of apple pies

Level: 164

Posts: 3708/9039
EXP: 57499050
Next: 203340

Since: 07-03-12
From: in a box

Last post: 3 days ago
Last view: 3 days ago

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
melonDS the most fruity DS emulator there is

zafkflzdasd

shibboleet

Posted on 05-18-15 07:32 PM

Link | #59912

Fire Mario
DROP TABLE users;

Level: 124

Posts: 3697/4661
EXP: 21280255
Next: 556346

Since: 07-07-12

Last post: 1511 days ago
Last view: 524 days ago

Well yeah you dumped the ObjNameTable, Ithink. Which doesn't have everything in it.

____________________
a

SunakazeKun

Posted on 05-19-15 11:57 AM

Link | #59929

Boss Bass
Normal user

Level: 75

Posts: 1110/1551
EXP: 3747679
Next: 79225

Since: 06-15-14
From: Germany

Last post: 2448 days ago
Last view: 2421 days ago

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 01:39 PM (rev. 2 of 05-19-15 01:44 PM)

Link | #59934

Normal user

Level: 58

Posts: 209/815
EXP: 1545311
Next: 32235

Since: 09-06-12

Last post: 1853 days ago
Last view: 208 days ago

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 03:47 PM

Link | #59935

Boss Bass
Normal user

Level: 75

Posts: 1111/1551
EXP: 3747679
Next: 79225

Since: 06-15-14
From: Germany

Last post: 2448 days ago
Last view: 2421 days ago

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 06:22 PM

Link | #59942

Normal user

Level: 58

Posts: 210/815
EXP: 1545311
Next: 32235

Since: 09-06-12

Last post: 1853 days ago
Last view: 208 days ago

Well. These documentations could do with being in the object database

. And I'm sure they could be expanded upon.

SunakazeKun

Posted on 05-19-15 06:40 PM

Link | #59944

Boss Bass
Normal user

Level: 75

Posts: 1112/1551
EXP: 3747679
Next: 79225

Since: 06-15-14
From: Germany

Last post: 2448 days ago
Last view: 2421 days ago

http://sunakazekun.bplaced.net/files/smg/smg1-UnusedContent.txt

There are all undocumented & unused objects from SMG1.

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

Hiccup

Posted on 05-20-15 10:49 AM

Link | #59978

Normal user

Level: 58

Posts: 211/815
EXP: 1545311
Next: 32235

Since: 09-06-12

Last post: 1853 days ago
Last view: 208 days ago

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

Hide post layouts | New reply

Page rendered in 0.039 seconds. (2048KB of memory used)
MySQL - queries: 28, rows: 225/225, time: 0.014 seconds.
[powered by Acmlm]