im stumped sub actions

[Dragooon]

It doesn't shows anything because you didn't made it to return anything
Try

Code Select Expand

function clickcounts() {
   
   db_query("UPDATE {$db_prefix}clickcounts     
   SET value = value + 1     
   WHERE name = ' Conquer Antarctica Multiplayer'     
   LIMIT 1", __FILE__, __LINE__);
$request = db_query("SELECT value
FROM {$db_prefix}clickcounts
WHERE name = ' Conquer Antartica Multiplayer'",__FILE__,__LINE__);
list($views) = mysql_fetch_row($request);
mysql_free_result($request);
return $views;
   }
Do the table corrections you made.

[SA™]

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 'WHERE name = ' Conquer Antartica Multiplayer'' at line 2
File: C:\xampp\htdocs\test\Sources\multiplayer.php
Line: 111

[Dragooon]

Actually, I just realized that db_prefix wasn't in globals.
Try

Code Select Expand

function clickcounts() {
   global $db_prefix;
   db_query("UPDATE {$db_prefix}clickcounts     
   SET value = value + 1     
   WHERE name = ' Conquer Antarctica Multiplayer'     
   LIMIT 1", __FILE__, __LINE__);
$request = db_query("SELECT value
FROM {$db_prefix}clickcounts
WHERE name = ' Conquer Antartica Multiplayer'",__FILE__,__LINE__);
list($views) = mysql_fetch_row($request);
mysql_free_result($request);
return $views;
   }

[SA™]

still not shoing nothing

[Nathaniel]

Is the name ' Conquer Antarctica Multiplayer' meant to have a space at the beginning, maybe it should be 'Conquer Antarctica Multiplayer'. This could be the problem.

[SA™]

nope still not displaying any numbers

[Dragooon]

Hm, open up the table with phpMyAdmin, do you see any rows?

[SA™]

hmmm the table is there i cant brouse it tho as the brouse button isnt clicking

[Nathaniel]

That means that there isn't anything in there, try adding a row with the name 'Conquer Antarctica Multiplayer'. There should be an insert tab.

[SA™]

hmm help lol im in the insert bit this is what im seeing

Field Type Function Null Value

where i start

[Dragooon]

OK Try this function, and make sure to enter the correct value in the $gameName clause.

Code Select Expand

function clickcounts($gameName) {
global $db_prefix;

$request = db_query("SELECT value
FROM {$db_prefix}clickcounts
WHERE name = '$gameName'",__FILE__,__LINE__);
list($views) = mysql_fetch_row($request);
if(mysql_num_rows($request) == 0)
{
db_query("
INSERT INTO {$db_prefix}clickcounts
(name, value)
VALUES
($gameName, 0)",__FILE__,__LINE__);
$views = 0;
}

mysql_free_result($request);
db_query("UPDATE {$db_prefix}clickcounts     
SET value = value + 1     
WHERE name = '$gameName'     
LIMIT 1", __FILE__, __LINE__);
$views = $views + 1;
return $views;
}

[SA™]

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)' at line 4
File: C:\xampp\htdocs\test\Sources\multiplayer.php
Line: 116

[Dragooon]

Try

Code Select Expand

function clickcounts($gameName) {
   global $db_prefix;
   
   $request = db_query("SELECT value
   FROM {$db_prefix}clickcounts
   WHERE name = '$gameName'",__FILE__,__LINE__);
   list($views) = mysql_fetch_row($request);
   if(mysql_num_rows($request) == 0)
   {
      db_query("
         INSERT INTO {$db_prefix}clickcounts
         (name, value)
         VALUES
         ('$gameName', 0)",__FILE__,__LINE__);
      $views = 0;
   }
   
   mysql_free_result($request);
   db_query("UPDATE {$db_prefix}clickcounts     
   SET value = value + 1     
   WHERE name = '$gameName'     
   LIMIT 1", __FILE__, __LINE__);
   $views = $views + 1;
   return $views;
}

[SA™]

nope still nothing im getting peed of lol so im gonna shoot my self

so ithink im gonna leave this one as im not gonna be able to do it

thank you dragoon,LHVWB,[sinan] i appretiate you help

ill try again somtime next century [never]lol

[[SiNaN]]

Can you attach here the source file and template file?

[SA™]

sure heres the whole packeg i undone all the changes i made just now sry

click

[SA™]

Sadrazam have you manged to help with this yet?


wayne

[[SiNaN]]

Checked your codes. You've made it in a very long way. Why don't you save the game name, game picture, game description, game url in the db?

Or what is the difference between this one and the SMF Arcade?

[Dragooon]

@Sardazm, this I believe, basically is a multiplayer game script showing multiplayer games from various sites.

[[SiNaN]]

@Sardazm, this I beli....

It's Sadrazam Dragooon.

Hımmm, okay. Something like this would be better:

This is your smf_multiplayer table:

ID_GAME gameName gameDescription timesPlayed gameUrl pictureUrl active

Then when ?action=multiplayer is called, you get the ID_GAME gameName gameDescription timesPlayed pictureUrl active from db. You put them in an array. Then show if the active is true with the foreach function. You can use the constructPageIndex() function to create a page index. So your game link is like this ?action=multiplayer;sa=game;id=5. Then you call the "game" sub-template and get the information about the game which has the ID 5. And when in the "game" sub-template, you put the gameUrl as the "value" in parameters.

Believe me, trying to add hits to these codes are harder then coding the mod as I wrote above.