COD server block

[IchBin]

Looking for someone to help me get a COD server block on my phpnuke site. I uploaded the files. Everything went well, but when I click on the link it gives me an error. I didn't edit any files (which I know I need to do to query my server) can anyone lend a helping hand?

[Tighten]

Did you run the query script?

And do you see that added icon "Gameservers" to your GUI in the admin screen?

Also make sure your SQL can make tables - some hosts have this off.

Now I am not a "WEB" guy so to speak, so only take note of this help. I did my own with little to no problems.

I would be happy to help in anyway I can.

[IchBin]

I read in another topic on this that the guy had the same error as me.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/growfam/public_html/includes/sql_layer.php on line 342

I did add the sql file to my database. I don't see a seperate icon in my admin.php page though.

I don't even know where to begin.

[IchBin]

Ok, got it working. Just didn't have my server setting right. Now, how do I get the thumbnails working?

[Tighten]

Once you have the thumb nails you have to make a directory in your web site.

If you go to the edit server GUI with all of the drop down boxes - query port, name ,port ,IP etc..

You can test it or view it it will tell you what the folders name should be and where to place it. Chances are your folder criteria will be the same.

My sub directoy is set up like this >

httpdocs/modules/Gameserver/images/q3a_main - for COD

httpdocs/modules/Gameserver/images/q3a_OSP - for RTCW

That is where I placed them, for RTCW I added rtcw.png for a little logo at the top, as well as the current map images.

[IchBin]

Sweet, you are my hero. All I needed was a little nudge in the right direction. Thanks a bunch!!!!

[Tighten]

I read in another topic on this that the guy had the same error as me.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/growfam/public_html/includes/sql_layer.php on line 342

This may have something to do with you SQL database not creating tables - I am not 100% sure though. If it is, you either need to have the permissions for MySQL set to enable tables or manually add the tables yourself.

CREATE TABLE prefix_gameserver (
id int(11) NOT NULL auto_increment,
name varchar(128) NOT NULL default '',
shortname varchar(32) NOT NULL default '',
address varchar(15) NOT NULL default '',
queryport int(11) NOT NULL default '0',
protocol enum('detect','gsqp','hlife','q3a') NOT NULL default 'gsqp',
gamename varchar(16) NOT NULL default '',
show_in_block enum('yes','if_online','no') NOT NULL default 'no',
showrules enum('yes','no') NOT NULL default 'yes',
customlinks varchar(255) NOT NULL default '',
active enum('yes','no') NOT NULL default 'yes',
PRIMARY KEY (id)
);


I am assuming you ran the query script?

I hope this is of some help.