Fleamarts Posted March 7, 2010 Posted March 7, 2010 Table 'fleamarts_forum.ibf_iarcade_scores' doesn't exist How do i fix this? I have tried uninstall and reinstall again by dropping tables and overwrite. Not working <_<
Collin1000 Posted March 7, 2010 Posted March 7, 2010 Table 'fleamarts_forum.ibf_iarcade_scores' doesn't exist How do i fix this? I have tried uninstall and reinstall again by dropping tables and overwrite. Not working <_< Read install directions and follow steps. http://iarcademod.com/install/rc1.php?step=2 "Note: You may need to change the MySQL table prefix in line mysql_query("INSERT INTO `ibf_iarcade_scores` to suit your board. Also, if your MySQL server is not Localhost, you will need to change this." Your site prefix most likely is not ibf_ so you need to change it to match your site. If you do not understand how to locate this info, let me know.
Joe D Posted March 7, 2010 Posted March 7, 2010 collin, this might be what I need to do, how do I find that to change this? mysql_query("INSERT INTO `ibf_iarcade_scores`
Collin1000 Posted March 7, 2010 Posted March 7, 2010 collin, this might be what I need to do, how do I find that to change this? mysql_query("INSERT INTO `ibf_iarcade_scores` It is in the edit you made in step 2.
Joe D Posted March 7, 2010 Posted March 7, 2010 Collin, I know its in the edit I did in step#2 but what is the prefix to change that to. Thanks I am almost there
Collin1000 Posted March 7, 2010 Posted March 7, 2010 Collin, I know its in the edit I did in step#2 but what is the prefix to change that to. Thanks I am almost there Whatever prefix you use. If you open your conf_global.php file, look for the sql prefix used in that.
Joe D Posted March 7, 2010 Posted March 7, 2010 collin, the prefix for this is blank, apparently during the install it was never set up to what we wanted it to be, is there a particular prefix that is needed? I have 14 games installed and working, just cant submit scores. Thanks buddy have a good night, my eyes are bleeding trying to get this done :blink:
Mat Barrie Posted March 7, 2010 Posted March 7, 2010 I just spent four hours making the RC1 MSSQL compatible - who do I send the files to. (I.e. send me an email address) Also note: I've managed to remove the requirement to re-enter in your DB details in index.php as well.
Andy Rixon Posted March 7, 2010 Author Posted March 7, 2010 I just spent four hours making the RC1 MSSQL compatible - who do I send the files to. (I.e. send me an email address) Also note: I've managed to remove the requirement to re-enter in your DB details in index.php as well. That's very nice of you, send them over to Collin1000 in PM and he can sort it out, I am currently off development for this due to misses in a very long labour :(
Joe D Posted March 7, 2010 Posted March 7, 2010 Then simply remove ibf_ from the table name. :) Just did that thanks, but still cant get games to submit scores, the last thing I can try is this Also, if your MySQL server is not Localhost, you will need to change this." how do I know if it is local host or not? My forum and server is hosted by IPB.
Wolfie Posted March 7, 2010 Posted March 7, 2010 Just did that thanks, but still cant get games to submit scores, the last thing I can try is this [color="#ff0000"]Also, if your MySQL server is not Localhost, you will need to change this."[/color] how do I know if it is local host or not? My forum and server is hosted by IPB. Under most circumstances, if it's not "localhost", then you'd know and not need to ask. But to play it safe, open the conf_global.php file and look in there. The "sql_host" will be blank if it's localhost.
Joe D Posted March 7, 2010 Posted March 7, 2010 Under most circumstances, if it's not "localhost", then you'd know and not need to ask. But to play it safe, open the conf_global.php file and look in there. The "sql_host" will be blank if it's localhost. this is what I have: $INFO['sql_host'] = 'localhost'; and I thank you for your help.:thumbsup:
Collin1000 Posted March 7, 2010 Posted March 7, 2010 I just spent four hours making the RC1 MSSQL compatible - who do I send the files to. (I.e. send me an email address) Also note: I've managed to remove the requirement to re-enter in your DB details in index.php as well. Drop me a PM with the changes you made and I can once-over it. The problem is that since I do not have the IPS MSSQL driver, or an MSSQL host, I cannot really provide support for this driver. this is what I have: $INFO['sql_host'] = 'localhost'; and I thank you for your help.:thumbsup: Drop me a PM with your ACP and FTP into and I will take a look for you.
Mat Barrie Posted March 7, 2010 Posted March 7, 2010 Done. Also, I think my index.php modifications might fix PeterC's problem too, since I removed the reliance on manually entering your DB details. PeterC, can you back up your index.php, and try replacing the iArcade section in it with the following:// --------------------------------- // IP.ARCADE CUSTOMIZATION: // Work-around for support of older ibproarcade v2 format games // Begin custom edit // --------------------------------- if ($_GET["act"] == "Arcade") { //Init IPSReg ipsRegistry::init(); $hackaroundearn = $_POST['gscore']; $tgn = $_POST['gname']; $encearn = base64_encode($hackaroundearn); //Connect to DB using conf global file $registry = ipsRegistry::instance(); $DB = $registry->DB(); $who = ipsRegistry::member()->getProperty('name'); $time = time(); //Insert Score $DB->insert('iarcade_scores', array( 'gname' => $tgn, 'member' => $who, 'score' => $hackaroundearn, 'time' => $time, 'ip' => '' ) ); $DB = null; $registry = null; //Send them packing! echo "<meta http-equiv='refresh' content='0;url=index.php?app=iArcade&view=newscore&game=$tgn&n=$hackaroundearn&s=$encearn'>"; die(); } // --------------------------------- // IP.ARCADE CUSTOMIZATION: // Work-around for support of older ibproarcade v2 format games // End Custom Edit // ---------------------------------
Joe D Posted March 7, 2010 Posted March 7, 2010 Hey guys! I tried IE and the scores save! but I see no images of the thumbnail games! Firefox does not save the scores.
Collin1000 Posted March 7, 2010 Posted March 7, 2010 Hey guys! I tried IE and the scores save! but I see no images of the thumbnail games! Firefox does not save the scores. Same here.... this is odd :unsure:
Amy T Posted March 7, 2010 Posted March 7, 2010 Mat do you think you could by chance figure out the v32 compatibility issue? That would be awesome if you could.
SG Staff Posted March 8, 2010 Posted March 8, 2010 Awesome, thanks a ton!!! No clue why I couldn't seem to locate it on my own. Search was not my friend. :lol: Question for you all, can I make this mod usable by only certain user groups? We have members that support our site (monetarily of course) and I would like to make the games available to only the Site Supporters group. If it's not possible, no biggie, just curious if it was. Thanks again!
Collin1000 Posted March 8, 2010 Posted March 8, 2010 Awesome, thanks a ton!!! No clue why I couldn't seem to locate it on my own. Search was not my friend. :lol: Question for you all, can I make this mod usable by only certain user groups? We have members that support our site (monetarily of course) and I would like to make the games available to only the Site Supporters group. If it's not possible, no biggie, just curious if it was. Thanks again! Yes, there is permissions built in.
Wolfie Posted March 8, 2010 Posted March 8, 2010 Awesome, thanks a ton!!! No clue why I couldn't seem to locate it on my own. Search was not my friend. :lol: Question for you all, can I make this mod usable by only certain user groups? We have members that support our site (monetarily of course) and I would like to make the games available to only the Site Supporters group. If it's not possible, no biggie, just curious if it was. Thanks again! ACP, iArcade, settings.
Calvin39 Posted March 8, 2010 Posted March 8, 2010 Done. Also, I think my index.php modifications might fix PeterC's problem too, since I removed the reliance on manually entering your DB details. PeterC, can you back up your index.php, and try replacing the iArcade section in it with the following:// --------------------------------- // IP.ARCADE CUSTOMIZATION: // Work-around for support of older ibproarcade v2 format games // Begin custom edit // --------------------------------- if ($_GET["act"] == "Arcade") { //Init IPSReg ipsRegistry::init(); $hackaroundearn = $_POST['gscore']; $tgn = $_POST['gname']; $encearn = base64_encode($hackaroundearn); //Connect to DB using conf global file $registry = ipsRegistry::instance(); $DB = $registry->DB(); $who = ipsRegistry::member()->getProperty('name'); $time = time(); //Insert Score $DB->insert('iarcade_scores', array( 'gname' => $tgn, 'member' => $who, 'score' => $hackaroundearn, 'time' => $time, 'ip' => '' ) ); $DB = null; $registry = null; //Send them packing! echo "<meta http-equiv='refresh' content='0;url=index.php?app=iArcade&view=newscore&game=$tgn&n=$hackaroundearn&s=$encearn'>"; die(); } // --------------------------------- // IP.ARCADE CUSTOMIZATION: // Work-around for support of older ibproarcade v2 format games // End Custom Edit // --------------------------------- Matt this works perfect mate, saves scores no problem, also there is nothing wrong with Firefox with this Arcade as I use nothing else, and the arcade works brilliantly.
Collin1000 Posted March 8, 2010 Posted March 8, 2010 Mat's edit will become the new index.php edit for RC2. :thumbsup:
Mat Barrie Posted March 8, 2010 Posted March 8, 2010 Mat do you think you could by chance figure out the v32 compatibility issue? That would be awesome if you could. No guarantees :)
Recommended Posts
Archived
This topic is now archived and is closed to further replies.