Hall of Fame problem

You can talk about anything here, not necessarily game-related. You may also advertise here.
Post Reply
hackerkts
Advanced Member
Posts: 36
Joined: Sat May 14, 2005 5:56 am
Location: Singaporeâ„¢
Contact:
Contact hackerkts

Post by hackerkts »

code: Select all

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/sunyanzi/public_html/faf/hfame.php on line 45
Beatles do you know how to fix it ? Thanks in advance.
Top
ohmyjapan16
Sir Devari's Squire
Posts: 941
Joined: Sun Feb 27, 2005 2:15 am

Post by ohmyjapan16 »

There's a suggestions/bugs sub-forum. Beatles can do anything. :P
edit: Told ya.
It ain't about how hard ya hit. It's about how hard you can get hit and keep moving forward. How much you can take and keep moving forward. That's how winning is done!
Top
User avatar
The Beatles
Fear me for I am root
Posts: 6285
Joined: Tue May 24, 2005 8:12 pm

Post by The Beatles »

You don't have a faf_hfame table. Unfortunately no dump exists at this time. I'll get back to you later.
:wq
Top
hackerkts
Advanced Member
Posts: 36
Joined: Sat May 14, 2005 5:56 am
Location: Singaporeâ„¢
Contact:
Contact hackerkts

Post by hackerkts »

Ok i will wait for it :*laughs*:
Top
User avatar
Slasher
The FAF Forums SMEGHEAD!!! lol
Posts: 2635
Joined: Mon May 03, 2004 5:08 pm
Location: http://florida4us.com/
Contact:
Contact Slasher

Post by Slasher »

Can you send me it aswell please?
I do not have a signature, you must be imagining

http://florida4us.com/

Image
Top
User avatar
Slasher
The FAF Forums SMEGHEAD!!! lol
Posts: 2635
Joined: Mon May 03, 2004 5:08 pm
Location: http://florida4us.com/
Contact:
Contact Slasher

Post by Slasher »

What would I have to put in the table(s) I will try and do one and then make it avalible on FAF if you like *laughs*...
I do not have a signature, you must be imagining

http://florida4us.com/

Image
Top
hackerkts
Advanced Member
Posts: 36
Joined: Sat May 14, 2005 5:56 am
Location: Singaporeâ„¢
Contact:
Contact hackerkts

Post by hackerkts »

I wonder is Beatles free to help us.. :D
Top
User avatar
The Beatles
Fear me for I am root
Posts: 6285
Joined: Tue May 24, 2005 8:12 pm

Post by The Beatles »

Sorry, I'm really busy. I'll dump the table structure this week if I don't forget.
:wq
Top
hackerkts
Advanced Member
Posts: 36
Joined: Sat May 14, 2005 5:56 am
Location: Singaporeâ„¢
Contact:
Contact hackerkts

Post by hackerkts »

Ok Thanks :D
Top
User avatar
Slasher
The FAF Forums SMEGHEAD!!! lol
Posts: 2635
Joined: Mon May 03, 2004 5:08 pm
Location: http://florida4us.com/
Contact:
Contact Slasher

Post by Slasher »

Can you send to me aswell please?
I do not have a signature, you must be imagining

http://florida4us.com/

Image
Top
User avatar
The Beatles
Fear me for I am root
Posts: 6285
Joined: Tue May 24, 2005 8:12 pm

Post by The Beatles »

Here it is:

<!--sql--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td>SQL </td></tr><tr><td id='CODE'><!--sql1-->CREATE TABLE `faf_hfame` (
`num` bigint(20) NOT NULL default <span style='color:red'>'0'</span>,
`name` varchar(100) NOT NULL default '',
`empire` varchar(100) NOT NULL default '',
`land` bigint(20) NOT NULL default <span style='color:red'>'0'</span>,
`networth` bigint(20) NOT NULL default <span style='color:red'>'0'</span>,
`race` smallint(6) NOT NULL default <span style='color:red'>'0'</span>,
`location` smallint(6) NOT NULL default <span style='color:red'>'0'</span>,
`off` bigint(20) NOT NULL default <span style='color:red'>'0'</span>,
`offsucc` bigint(20) NOT NULL default <span style='color:red'>'0'</span>,
`def` bigint(20) NOT NULL default <span style='color:red'>'0'</span>,
`defsucc` bigint(20) NOT NULL default <span style='color:red'>'0'</span>,
`kills` bigint(20) NOT NULL default <span style='color:red'>'0'</span>,
PRIMARY KEY (`num`)
) TYPE<span style='color:orange'>=</span>MyISAM; <!--sql2--></td></tr></table><div class='postcolor'><!--sql3-->
:wq
Top
User avatar
Slasher
The FAF Forums SMEGHEAD!!! lol
Posts: 2635
Joined: Mon May 03, 2004 5:08 pm
Location: http://florida4us.com/
Contact:
Contact Slasher

Post by Slasher »

Thanks "The Beatles"! You're a star *laughs* :)
I do not have a signature, you must be imagining

http://florida4us.com/

Image
Top
hackerkts
Advanced Member
Posts: 36
Joined: Sat May 14, 2005 5:56 am
Location: Singaporeâ„¢
Contact:
Contact hackerkts

Post by hackerkts »

Can i have more details where to put it in ?
Is it sql-setup.php ? I still having problem. =/
Top
User avatar
The Beatles
Fear me for I am root
Posts: 6285
Joined: Tue May 24, 2005 8:12 pm

Post by The Beatles »

No, just run that query in PHPMyAdmin.
:wq
Top
User avatar
Slasher
The FAF Forums SMEGHEAD!!! lol
Posts: 2635
Joined: Mon May 03, 2004 5:08 pm
Location: http://florida4us.com/
Contact:
Contact Slasher

Post by Slasher »

hackerkts wrote: Can i have more details where to put it in ?
Is it sql-setup.php ? I still having problem. =/
Contact me on YIM and I will help ya out :)
I do not have a signature, you must be imagining

http://florida4us.com/

Image
Top
Post Reply

  • Members connected in real time

    🔒 Close the panel of connected members

Return to “General Discussion”