Support Forums - All Posts - XOOPS Web Application System

21

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

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

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

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

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

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

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

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

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

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

Stats
Goal:	$100.00
Due Date:	Apr 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Forum Index

Re: SELECT COUNT - sql wont work

Re: Same Module in use TWICE with different names?

SELECT COUNT - sql wont work

Re: GPL licence - competing sites?

Re: GPL licence - competing sites?

GPL licence - competing sites?

Re: using language constants

Re: using language constants

Re: using language constants

using language constants

Login

Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Re: NewBB v 5.1.0 b 6

Re: NewBB v 5.1.0 b 6

NewBB v 5.1.0 b 6

Re: XOOPS 2.5.11 search user is not working

Re: oledrion

Re: oledrion

Re: oledrion

Re: oledrion

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}