HQ NETWORK:   XBOX ONE |  XBOX 360 |  AIDELUXE HQ Network: 2,087 | Guests: 409 | Members: 4 


   Current Location: Forums New Game - Fursan al-Aqsa - Knights of al-Aqsa Mosque   |   Where are the websites listing the files you can delete from   |   Hello everyone   |   Installing a new Dashboard on an Chip modded XBox   |   error 5 on xbox   |   HELP! replacement motherboard with XECUTER 2 BIOS   |   1.2 Board spitting Christmas lights   |   new member   |   Seagate Momentus XT   |   MY PROFILE -> MY GAMES now available on XBOX-HQ!   |   
  Home | Active Topics | CD/DVD Media | Downloads | Forums | Feedback | Games | HardDrives | Homebrew | My Profile | ModChips | Reviews | Search | SoftMods | Tutorials

Xbox Forums

Discuss all aspects of the original Xbox Console in our Interactive Xbox Forums..

Xbox-Hq.Com :: View topic - pnFlashGames for PHPNuke v0.5++ (VIP) Testers needed!
Xbox-Hq.Com Forum Index -> pnFlashGames Beta Testers/Bug Reports
Post new topic Reply to topic    
 pnFlashGames for PHPNuke v0.5++ (VIP) Testers needed! View previous topic :: View next topic  
 
 
 
 
forahobby
Administrator
Administrator


Joined: May 22, 2003
Posts: 23834
Location: NSW, Australia

Post Posted: Thu Jun 23, 2005 10:12 am   
Post subject: pnFlashGames for PHPNuke v0.5++ (VIP) Testers needed!
Reply with quote
 
Hi VIP Members,

- New Search Function
- Sort Functions
- My Settings (members only)

Im hoping some of you may want to test the new v0.5++ version which im going to release to all very soon.. I just want to make sure there are no huge bugs..

For anyone that wants to help please contact me via EMAIL! Smile
http://www.xbox-hq.com/html/feedback.html

Ill get back to you ASAP... Im trying to get this baby all polished up now for you all.. If there is more optoins you want SPEAK UP NOW!

anyway, talk soon coolies.

l8r

FH
http://www.xbox-hq.com

_________________
HQ Network:
www.xbox-hq.com | www.xboxone-hq.com | www.360-hq.com | www.c64-hq.com


View user's profile Send private message Send e-mail Visit poster's website
 
 
 
 
usapmaster
Xbox-HQ User
Xbox-HQ User



Joined: Apr 26, 2005
Posts: 17

Post Posted: Fri Oct 07, 2005 4:08 pm   
Post subject:
Reply with quote
 
Hi FH,
You may want to check my post regarding saving scores that already exist. It seems score field is part of a unique key, thus when the same score is already recorded, your score wont save. This means that you cant have two (or more) scores of 1000 in the same game.
BTW, I am using PHPNUKE 7.8 patched and pnflashgames 0.4.

Take care.

http://www.usapangpinoy.com


View user's profile Send private message
 
 
 
 
usapmaster
Xbox-HQ User
Xbox-HQ User



Joined: Apr 26, 2005
Posts: 17

Post Posted: Fri Oct 07, 2005 7:58 pm   
Post subject:
Reply with quote
 
I may have found where the problem is...
I found the ff lines in index.php in module folder for Flash_games, as well as in the oldcomponent.php.
I commented out those specific to double scores. My reasoning being is, if i played 2 hrs and it happened that I tied the score of the first placer, I will not get a credit for that??? At least give me the second place ..Smile.


Code:
// check if user has already got this score in the database
$sql2 = "SELECT * FROM ".$prefix."_flashgames_hiscores WHERE gid=$game_id and playerscore=$player_score";
$count = 0;
$result = $db->sql_query($sql2);
if(sql_num_rows($result, $db) > 0) {
// identical score found so display error that game not saved
echo "&opSuccess=false&error=notloggedin&endvar=1";
   die();
}else{
// no score found for user so save this score
sql_query("INSERT INTO $prefix"._flashgames_hiscores." (hid,gid,gamename,playername,playerscore,date) VALUES ('','$game_id','$game_name', '$player_name','$player_score','$date')", $dbi);
}

Code:
// check if user has already got this score in the database
$sql2 = "SELECT * FROM ".$prefix."_flashgames_hiscores WHERE gid=$game_id and playerscore=$player_score";
$count = 0;
//$result = $db->sql_query($sql2);
//if(sql_num_rows($result, $db) > 0) {
// identical score found so display error that game not saved
//echo "&opSuccess=false&error=notloggedin&endvar=1";
//   die();
//}else{
// no score found for user so save this score
sql_query("INSERT INTO $prefix"._flashgames_hiscores." (hid,gid,gamename,playername,playerscore,date) VALUES ('','$game_id','$game_name', '$player_name','$player_score','$date')", $dbi);
//}


View user's profile Send private message
 
 
 
 
usapmaster
Xbox-HQ User
Xbox-HQ User



Joined: Apr 26, 2005
Posts: 17

Post Posted: Fri Oct 07, 2005 8:50 pm   
Post subject:
Reply with quote
 
I know am playing around.. I revised the query statement to foolproof saving of scores...there is a possibility that the same game's score maybe submitted more than once.
Now my flashgames can record same scores!

Code:
// check if user has already got this score in the database
//$sql2 = "SELECT * FROM ".$prefix."_flashgames_hiscores WHERE gid=$game_id and playerscore=$player_score";
$sql2 = "SELECT * FROM ".$prefix."_flashgames_hiscores WHERE gid=$game_id and playerscore=$player_score and playername=$player_name and date=$date";


View user's profile Send private message
 
 
 
 
usapmaster
Xbox-HQ User
Xbox-HQ User



Joined: Apr 26, 2005
Posts: 17

Post Posted: Fri Oct 07, 2005 8:52 pm   
Post subject:
Reply with quote
 
I know am playing around.. I revised the query statement to foolproof saving of scores...there is a possibility that the same game's score maybe submitted more than once.
Now my flashgames can record same scores! Make sure to edit your codes using notepad. I think wordpad is messing it up.

Code:

// check if user has already got this score in the database
//$sql2 = "SELECT * FROM ".$prefix."_flashgames_hiscores WHERE gid=$game_id and playerscore=$player_score";
$sql2 = "SELECT * FROM ".$prefix."_flashgames_hiscores WHERE gid=$game_id and playerscore=$player_score and playername=$player_name and date=$date";


View user's profile Send private message
 
 
 
 
forahobby
Administrator
Administrator


Joined: May 22, 2003
Posts: 23834
Location: NSW, Australia

Post Posted: Sat Oct 08, 2005 3:17 am   
Post subject:
Reply with quote
 
Quote:
You may want to check my post regarding saving scores that already exist. It seems score field is part of a unique key, thus when the same score is already recorded, your score wont save. This means that you cant have two (or more) scores of 1000 in the same game.
BTW, I am using PHPNUKE 7.8 patched and pnflashgames 0.4.


Why would you want more then one score..?? Especially since its the same points.. The hiscores chart would look ugly becausse you would just see the same user over and over which i think is silly.

anyway, thats about to you.. You can remove that code and jst insert all hiscores if you like.

_________________
HQ Network:
www.xbox-hq.com | www.xboxone-hq.com | www.360-hq.com | www.c64-hq.com


View user's profile Send private message Send e-mail Visit poster's website
 
Display posts from previous:   
  Post new topic  
 
  Reply to topic  
|
 All times are GMT | Page 1 of 1
Jump to:  
 

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
 

 Members Online (4) / Guests Online (409)
Members Browsing
paqman, Darkinbone, Breck2181, forahobby,

Legend
Administrator  Moderator  VIP Member  Registered User  Banned Users

McAfee US