21
burfodus
Re: SELECT COUNT - sql wont work
  • 2009/3/28 15:13

  • burfodus

  • Just popping in

  • Posts: 94

  • Since: 2008/9/2 1


thanks ghia, I just resolved it in the last few hours, i must have tried 300+ cominations of syntax lol, but it wasnt working cos the number cant be interpreted i believe. this worked in the end.
$counttest mysql_query(" SELECT player_name FROM ".$xoopsDB->prefix('cuesportdraws_players')."") or die('count failed');
$test mysql_num_rows($counttest);


cheers
steve.
XOOPS Version - XOOPS 2.3.2
PHP Version - 5.2.6
MySQL Version - 5.0.67-community
Server API Version - apache2handler
OS Version - WINNT



22
burfodus
Re: Same Module in use TWICE with different names?
  • 2009/3/28 4:14

  • burfodus

  • Just popping in

  • Posts: 94

  • Since: 2008/9/2 1


id say it would not work, it uses the db, and without changing the db tables they will both install on the same ones, im not an expert tho.

i rekon to do this you would have to change the sql file, entries in xoopsversion to have new table names, and then switch every reference to this table name in the module.

prob not that hard to do, im pretty new to this too tho, so best find out for sure, if you have a test site, give it a go, but i doubt it will work.

sb..

XOOPS Version - XOOPS 2.3.2
PHP Version - 5.2.6
MySQL Version - 5.0.67-community
Server API Version - apache2handler
OS Version - WINNT



23
burfodus
SELECT COUNT - sql wont work
  • 2009/3/28 2:03

  • burfodus

  • Just popping in

  • Posts: 94

  • Since: 2008/9/2 1


hi guys, I have tried on several occasions to use the SELECT COUNT function in my module.

this works (i use it further down on same page to form a select box)
$playerlist mysql_query("SELECT player_name FROM ".$xoopsDB->prefix('cuesportdraws_players')." ") or die('getting playerlist failed');


but this doesnt
$counttest mysql_query("SELECT COUNT player_name FROM ".$xoopsDB->prefix('cuesportdraws_players')." ") or die('getting playercount failed');


any help muchly appreciated.
im looking up sql commands to learn how to use them in xoops, if there is guidelines i need to follow or certain things i cant do id like to know them.

cheers
steve.
XOOPS Version - XOOPS 2.3.2
PHP Version - 5.2.6
MySQL Version - 5.0.67-community
Server API Version - apache2handler
OS Version - WINNT



24
burfodus
Re: GPL licence - competing sites?
  • 2009/3/26 6:29

  • burfodus

  • Just popping in

  • Posts: 94

  • Since: 2008/9/2 1


thanks Ghia , you seem to help me out alot on here.

Nice Work!

sb..
XOOPS Version - XOOPS 2.3.2
PHP Version - 5.2.6
MySQL Version - 5.0.67-community
Server API Version - apache2handler
OS Version - WINNT



25
burfodus
Re: GPL licence - competing sites?
  • 2009/3/25 12:06

  • burfodus

  • Just popping in

  • Posts: 94

  • Since: 2008/9/2 1


depends i guess on the sport, for professional sporting results, i would say there is no copyright as such, how many football results sites are there.

I have permission from the world body to republish news and results from their site, and there is another site that already publishes the results after obtaining them from the world body.
the sport im aiming at is cuesports (snooker particularly) the worldsnooker site and other site im referring to are not very easy to navigate or get inforamtion from. the other site however, http://www.global-snooker.com/ would be the main competitor, and this is primarily updated by one person, who would benefit greatly by the module im creating. hence my concern.

tis a shame, would like to offer it to others to be used for other sports, maybe I can send it to people on a request basis.

sb..
XOOPS Version - XOOPS 2.3.2
PHP Version - 5.2.6
MySQL Version - 5.0.67-community
Server API Version - apache2handler
OS Version - WINNT



26
burfodus
GPL licence - competing sites?
  • 2009/3/25 7:15

  • burfodus

  • Just popping in

  • Posts: 94

  • Since: 2008/9/2 1


Hi guys, im building a module to display sporting results, draws, player stats etc.

I have no problems offering it to the xoops/world community to use for their sites about different sports. However im concerned if someone uses my module to make a competing site to mine ie same sport.

Is there a way to offer it on a restricted licence or something to that effect, so it can be not allowed to be used for a site in the same topic/sport?

steve.
XOOPS Version - XOOPS 2.3.2
PHP Version - 5.2.6
MySQL Version - 5.0.67-community
Server API Version - apache2handler
OS Version - WINNT



27
burfodus
Re: using language constants
  • 2009/3/24 6:23

  • burfodus

  • Just popping in

  • Posts: 94

  • Since: 2008/9/2 1


is ok, sorted it out

echo "this is a test ".CUE_ADPLAYERS." and another test";


through trial an error lol.

thanks for your help.
steve.
XOOPS Version - XOOPS 2.3.2
PHP Version - 5.2.6
MySQL Version - 5.0.67-community
Server API Version - apache2handler
OS Version - WINNT



28
burfodus
Re: using language constants
  • 2009/3/24 6:10

  • burfodus

  • Just popping in

  • Posts: 94

  • Since: 2008/9/2 1


ok so how do i write it in a line of text

echo 'iwant my text to go before TT_NAME and after it';


??
thanks
steve
XOOPS Version - XOOPS 2.3.2
PHP Version - 5.2.6
MySQL Version - 5.0.67-community
Server API Version - apache2handler
OS Version - WINNT



29
burfodus
Re: using language constants
  • 2009/3/24 6:07

  • burfodus

  • Just popping in

  • Posts: 94

  • Since: 2008/9/2 1


OMG lol.

tried every combination of ' " . etc..lol

thanks.
steve
XOOPS Version - XOOPS 2.3.2
PHP Version - 5.2.6
MySQL Version - 5.0.67-community
Server API Version - apache2handler
OS Version - WINNT



30
burfodus
using language constants
  • 2009/3/24 5:48

  • burfodus

  • Just popping in

  • Posts: 94

  • Since: 2008/9/2 1


im just getting a little stuck on somethign simple.

i have set 6 language constants, and they work with this code

echo '<table width="100" border="0">
<tr>
<td bgcolor="#99CC99">'
.TT_NAME.'</td>
<td bgcolor="#66CC99">'
.TT_EMAIL.'</td>
</tr>'
;
echo 
'</table>';


but it doesnt when I put simply

echo '.TT_NAME.';


or several variations of this syntax.

can someone please give me a quick pointer as to why this is?

thanks heaps
steve.
XOOPS Version - XOOPS 2.3.2
PHP Version - 5.2.6
MySQL Version - 5.0.67-community
Server API Version - apache2handler
OS Version - WINNT




TopTop
« 1 2 (3) 4 5 6 ... 10 »



Login

Username:
Password:

Lost Password? Register now!

Who's Online

74 user(s) are online (43 user(s) are browsing Support Forums)


Members: 0


Guests: 74


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Jan 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits