Blade-Edge wrote:
archmage wrote:
You already got 2 posts explaining ways to do it, the administrators won't tell you anything different.
That's the problem; those ways don't go into specifics. The administrators who have hooked up the forum can explain it more thoroughly than someone who "hasn't looked at the ScratchR source"
And builder, I meant the Scratch admins
You will have better luck if you email them. Only paddle2see really goes on often and he didn't build Scratchr, nor did lightning.
This is really a copy & paste job too so anyone decent with code should be able to figure it out. Go to the Scratchr signup page, in the part where it adds the user name and password to the member table, copy and paste this over again, but change the table it adds to to the forum's member table.
If they are incompatible you are most likely going to get an error, that looks something like
"can't add x value to y table"
You have to change it so that the incompatible table holds the x values instead of the y values. In short, give the tables the same data type.
If none of this works go to a real programming forum and ask for php help, you will get better replys there.
Last edited by archmage (2011-05-01 17:22:24)
Offline
archmage wrote:
Blade-Edge wrote:
archmage wrote:
You already got 2 posts explaining ways to do it, the administrators won't tell you anything different.
That's the problem; those ways don't go into specifics. The administrators who have hooked up the forum can explain it more thoroughly than someone who "hasn't looked at the ScratchR source"
And builder, I meant the Scratch adminsYou will have better luck if you email them. Only paddle2see really goes on often and he didn't build Scratchr, nor did lightning.
This is really a copy & paste job too so anyone decent with code should be able to figure it out. Go to the Scratchr signup page, in the part where it adds the user name and password to the member table, copy and paste this over again, but change the table it adds to to the forum's member table.
You can try to contact andresmh at andresmh@media.mit.edu
Offline
It's not really a cut and paste job. It uses functions that would need to get completely redefined to be able to output to the forum database. The problem is that we don't know how to redefine them.
I'll email them after they respond to the one I just sent a few days ago
Offline
Would this help?
Or these:
http://scratch.mit.edu/api/getproject/1211743
http://scratch.mit.edu/api/getprojectpath/1211743
http://scratch.mit.edu/api/getuser/139
http://scratch.mit.edu/api/getusernamebyid/139
http://scratch.mit.edu/api/getregisteredusers
http://scratch.mit.edu/api/getcreators
http://scratch.mit.edu/api/gettotalprojects
http://scratch.mit.edu/api/gettotalscripts
http://scratch.mit.edu/api/gettotalsprites.
http://scratch.mit.edu/api/getprojectsbyusername/ashok
http://scratch.mit.edu/api/getgalleriesbyusername/ashok
http://scratch.mit.edu/api/getinfobyusername/ashok
http://scratch.mit.edu/api/getprojectsbygallery/27321
http://scratch.mit.edu/api/getprojectinfobyid/1210197
http://scratch.mit.edu/api/getprojectinfobyid/785614/490868
http://scratch.mit.edu/api/getgalleryinfobyid/24994
http://scratch.mit.edu/api/getnumprojectsbyuser/ashok
http://scratch.mit.edu/api/getnumprojectsbyuser/ashok?onlyvisible='no'
http://scratch.mit.edu/api/getpcommentsbyid/255443
http://scratch.mit.edu/api/getusersfavoriteprojectsbyuid/261892
http://scratch.mit.edu/api/getprojectblockscount/4447
http://scratch.mit.edu/api/getprojectblocks/1308192
http://scratch.mit.edu/api/get_latest_project/XXXXXXXXXXXXX
http://scratch.mit.edu/api/getblockcountpercategorybyuserid/139
http://scratch.mit.edu/api/get_remixed_project
Last edited by Pecola1 (2011-05-01 20:40:26)
Offline
If I had to fathom a guess I would say that FluxBB and ScratchR user data exist in two separate tables. The ScratchR dev team probably modified the production code to create a user on the FluxBB tables when you sign up for ScratchR. There's probably something similar in the login handling code that sets FluxBB session variables when you log into Scratch. You'd also have to add a few other things, such as redirection to user pages upon clicking a forumer's name. I don't know how much of this is already clear to you, just my two cents (¥1.6).
EDIT: Just read the whole thread more thoroughly. What do you mean by 'incompatible' tables between ScratchR and FluxBB? Are they just using different fields/data types or can you literally not get them to coexist in the same database?
Last edited by fullmoon (2011-05-01 21:21:06)

Offline
Basically, we can get them to coexist, but we don't know how to
Offline
If you're having trouble getting them into the same database, you can use phpMyAdmin to move tables between databases...is that what you mean? Then the rest of it is probably just custom code, I'm afraid.

Offline