[]DrChaos said: ya, its set in the file when you upload it as a new game.
where did you guys get that game. I would like to try to add it and see if it works for me. the rest didnt so far.. [/]
Yeah I know it can be changed. That's why I asked.
This is working well on my site. Check the post where Scroungr talks about that thread for converting the games to work on your site. That site has many games that will work "out of the box". I've downloaded quite a few already and have some installed on my site.
I can't get blackjack to submit, I get a permission denied error but all of the other games do work. BTW I have a ton of these games from when I ran it on a vb board that are ready to go, you can also grab games from existing sites, make a couple of mods to an existing game.php file and make them your own So if you have something specific you would like go ahead and request it and I will post it here as long as it's not on the black list.
Quick question. My games are sorting by the order in which I uploaded them (ie gamesid), but the one place I could find in arcade.php where it states ORDERBY $gamesid, I changed that and it did not take.
What would you change in the code to sort by shortname instead?
[]ericgtr said: I can't get blackjack to submit, I get a permission denied error but all of the other games do work. BTW I have a ton of these games from when I ran it on a vb board that are ready to go, you can also grab games from existing sites, make a couple of mods to an existing game.php file and make them your own So if you have something specific you would like go ahead and request it and I will post it here as long as it's not on the black list. [/]
Okay I ran the new instarcade.php and upgraded, now I get this error when I go into the arcade:
SQL ERROR: Thu, Sep 02 2004 13:34:11 -0400 Unable to do_query: SELECT gameid, shortname, gamesettings, title, width, height, FILE, stdimage, highscore FROM w3t_games WHERE gameid=7 Unknown column 'stdimage' in 'field list' Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /site/name/public_html/ubbthreads/mysql.inc.php on line 133
Also on line 311 the "red" needs to be "red" or you will get a parse error.
eric check to make sure you grabbed the right files I just rechecked and all occurrences of stdimage is no longer present in any of my new files I changed it to gameimage
Okay, I updated all the files and it's working now the initial instructions said only to re-run the instarcade.php script. Even my Blackjack is working
hmmm {$myprefs['language']} should be english so it would be redundant? unless of course theres an english directory inside english? or your not getting the cookie setting?
It didn't work without that path for me so I changed it according to where the file was in the structure provided. Not sure why I wouldn't get the cookie setting if that's the case.
echo "<br /><br /><center><font color = "red" face="Verdana, Arial" size="2">You must manually go in and change all gifs from gamename1.gif or gamename2.gif to gamename.gif using the larger of the two files</font><br /><br /><font face="Verdana, Arial" size="2">Upgrade complete! Read Installation.txt for the next step! Remember to remove this file.</font></center><br /><br />";
Change to this:
echo "<br /><br /><center><font color = "red" face="Verdana, Arial" size="2">You must manually go in and change all gifs from gamename1.gif or gamename2.gif to gamename.gif using the larger of the two files</font><br /><br /><font face="Verdana, Arial" size="2">Upgrade complete! Read Installation.txt for the next step! Remember to remove this file.</font></center><br /><br />";
I also added the pacman game from the same site that snake came from and I used the install page. it created the code but I had to upload the files. the files didnt upload with the install page. I cant figure out how to get pacman to keep scores. [/]
I have this problem too, but only on some games archery being one, my thought is that it depends if the user has submitted the score or not, the high score viewed next to the game is correct in the gamesessions table but not in the game table.
I also added the pacman game from the same site that snake came from and I used the install page. it created the code but I had to upload the files. the files didnt upload with the install page. I cant figure out how to get pacman to keep scores. [/]
I have this problem too, but only on some games archery being one, my thought is that it depends if the user has submitted the score or not, the high score viewed next to the game is correct in the gamesessions table but not in the game table. [/]
okay uploaded a new copy its installed here it does fix the hiscore issue make sure your not getting a cache'd copy look for this line in arcadeadmin.php
$query = " SELECT score, U_Number, U_Username FROM {$config['tbprefix']}gamesessions AS t1 LEFT JOIN {$config['tbprefix']}Users AS t2 ON t2.U_Number = t1.userid WHERE valid=1 AND $sessionclause AND gamename = '$shortname' AND score = '$currenthiscore' ORDER BY gamename ASC "; $stj = $dbh -> do_query($query,__LINE__,__FILE__); list($currenthiscore_q,$usernumber,$username) = $dbh -> fetch_array($stj);
if you don;t you don;t have the latest copy that is here..
its getting pulled from gamesession and displaying the currenthighscore and the username associated to it thats the part I fixed it use to be seperate puylls in arcade.php so I will need more info like your URl and also create a user called threadsdev with password threadsdev so I can poke around ya know.. help a little
BTW it was a minor change that was suppose to be in the 1.6 zip but wasn't so I didn't change the version number only updated the proper files in the zip that I missed.
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.