Lua cast system work in-game but not show at webpage (gesior aac)

Ted F · Apr 18, 2015

Hello .
I got this problem, cast is working in game but it dont want to show at cast webpage, any ideas of whats wrong ? I use gesior aac. And i have done as tutorial when installed cast .. But it seems to be another problem..

Regards. Ted F

bumps, anyone?

Elgenady · Apr 18, 2015

don't wast ur time no one will help you

Ted F · Apr 18, 2015

heba said:
don't wast ur time no one will help you

uhm.. lol, why?

gs1994 · Apr 18, 2015

Give us more info... We need some code of it. Where you store casting players.

Elgenady · Apr 18, 2015

i think cast system not for free Summ sell this for money

Tarek · Apr 18, 2015

Please read the support board rules.. I doesn't see you have written your server version.

Ted F · Apr 18, 2015

gs1994 said:
Give us more info... We need some code of it. Where you store casting players.

I use TFS 1.0
I use cast.php and i have added the query to db.

I found a link here when search on cast tfs 1,0 and downloaded the pages.

In db this query

Code:

ALTER TABLE  `players` ADD  `cast` TINYINT NOT NULL DEFAULT  '0',
ADD  `castViewers` INT( 11 ) NOT NULL DEFAULT  '0',
ADD  `castDescription` VARCHAR( 255 ) NOT NULL

In php this:

PHP:

<?PHP
$order = $_REQUEST['order'];
if($order == 'name') {
   $orderby = 'name';
}
if($order == 'level') {
   $orderby = 'level';
}
if($order == 'vocation') {
   $orderby = 'vocation';
}
if(empty($orderby)) {
   $orderby = 'name';
}
if(count($config['site']['worlds']) > 1)
{
   $worlds .= '<i>Select world:</i> ';
   foreach($config['site']['worlds'] as $idd => $world_n)
   {
     if($idd == (int) $_GET['world'])
     {
       $world_id = $idd;
       $world_name = $world_n;
     }
   }
}
if($idd == (int) $_GET['world'])
{
   $world_id = $idd;
   $world_name = $world_n;
}
if(!isset($world_id))
{
   $world_id = 0;
   $world_name = $config['server']['serverName'];
}
if(count($config['site']['worlds']) > 1)
{
   $main_content .= '<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100%><TR><TD>
     <FORM ACTION="?subtopic=whoisonline" METHOD=get><INPUT TYPE=hidden NAME=subtopic VALUE=whoisonline><INPUT TYPE=hidden NAME=list VALUE=experience>
     <TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>World Selection</B></TD></TR><TR><TD BGCOLOR="'.$config['site']['lightborder'].'">
     <TABLE BORDER=0 CELLPADDING=1><TR><TD>World: </TD><TD><SELECT SIZE="1" NAME="world"><OPTION VALUE="" SELECTED>(choose world)</OPTION>';
     foreach($config['site']['worlds'] as $id => $world_n)
     {
       $main_content .= '<OPTION VALUE="'.$id.'">'.$world_n.'</OPTION>';
     }
     $main_content .= '</SELECT> </TD><TD><INPUT TYPE=image NAME="Submit" ALT="Submit" SRC="'.$layout_name.'/images/buttons/sbutton_submit.gif" BORDER=0 WIDTH=120 HEIGHT=18>
     </TD></TR></TABLE></TABLE></FORM></TABLE><br>';
}
$players_online_data = $SQL->query('SELECT * FROM players WHERE online > 0 AND cast = 1 AND world_id = '.$world_id.' ORDER BY '.$orderby);
$number_of_players_online = 0;
foreach($players_online_data as $player)
{
   $number_of_players_online++;
   if($config['site']['show_flag'])
   {
     $account = $SQL->query('SELECT * FROM accounts WHERE id = '.$player['account_id'].'')->fetch();
     $flag = '<image src="images/flags/'.$account['flag'].'.png"/> ';
   }
   if(is_int($number_of_players_online / 2))
   {
     $bgcolor = $config['site']['darkborder'];
   }
   else
   {
     $bgcolor = $config['site']['lightborder'];
   }
   $players_rows .= '
   <TR BGCOLOR='.$bgcolor.'>
     <TD WIDTH=40%>'.$flag.'<A HREF="index.php?subtopic=characters&name='.urlencode($player['name']).'">'.$player['name'].'</A>
     <br/>'.$player['level'].' '.Website::getVocationName($player['vocation'], $player['promotion']).'</TD>
     <TD WIDTH=40%>'.($player['castDescription'] == "" ? '-' : $player['castDescription']).'</TD>
     <TD WIDTH=20%>'.$player['castViewers'].'/50</TD>
   </TR>';
}
if($number_of_players_online == 0)
{
   //server status - server empty
   $main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><B>Server Status</B></TD></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=1><TR><TD>Currently there are no active casts on '.$config['server']['serverName'].'.</TD></TR></TABLE></TD></TR></TABLE><BR>';
}
else
{
   //server status - someone is online
   $main_content .= '
   <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
     <TR BGCOLOR="'.$config['site']['vdarkborder'].'">
       <TD CLASS=white><B>Server Status</B></TD>
     </TR>
     <TR BGCOLOR='.$config['site']['darkborder'].'>
       <TD>';
       $main_content .= 'Currently there are '.$number_of_players_online.' active live casts';
       $main_content .= ' on '.$world_name.' gameworlds.<br>
       </TD>
     </TR>
   </TABLE><BR>';
   //list of players
   $main_content .= '
   <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
     <TR BGCOLOR="'.$config['site']['vdarkborder'].'">
       <TD><A HREF="index.php?subtopic=cast&order=name" CLASS=white>Name</A></TD>
       <TD><A HREF="index.php?subtopic=cast&order=level" CLASS=white>Description</A></TD>
       <TD><A HREF="index.php?subtopic=cast&order=vocation" CLASS=white>Viewers</TD>
     </TR>
   '.$players_rows.'</TABLE>';
   //search bar
   //$main_content .= '<BR><FORM ACTION="index.php?subtopic=characters" METHOD=post>  <TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>Search Character</B></TD></TR><TR><TD BGCOLOR="'.$config['site']['darkborder'].'"><TABLE BORDER=0 CELLPADDING=1><TR><TD>Name:</TD><TD><INPUT NAME="name" VALUE=""SIZE=29 MAXLENGTH=29></TD><TD><INPUT TYPE=image NAME="Submit" SRC="'.$layout_name.'/images/buttons/sbutton_submit.gif" BORDER=0 WIDTH=120 HEIGHT=18></TD></TR></TABLE></TD></TR></TABLE></FORM>';
}
   $main_content .= '<BR><TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>Description</B></TD></TR><TR><TD BGCOLOR="'.$config['site']['darkborder'].'"><h4 style="margin: 0px;">Commands (owner):</h4><i>/cast {on/off}</i> - Create or close your own cast<br/><i>/cast password |password|</i> - Sets a password for the cast<br/><i>/cast desc |description|</i> - Set a description for the cast<br/><i>/cast status</i> - Information about your cast (viewer amount, description, password)<br/><i>/cast viewers</i> - Displays the name of all viewers<br/><i>/cast {ban/unban} "name"</i> - Bans a viewer from joining your cast/Removes the ban<br/><i>/cast {mute/unmute} "name"</i> - Mutes a viewer on your cast/Removes the mute<br/><i>/cast bans</i> - Displays a list of banned viewers<br/><i>/cast mutes</i> - Displays a list of muted viewers<br/><i>/cast update</i> - Updates the description and status on the website<br/><br/><h4 style="margin: 0px;">Commands (viewer):</h4><i>/nick newNick</i> - Changes the viewer\'s name<br><i>/info</i> - Displays a list of all viewers</TD></TR></TABLE>';

?>

WibbenZ · Apr 19, 2015

@Ted F use code tags.
Use sql queries and send if the player is casting, description etc.

Ted F · Apr 19, 2015

WibbenZ said:
@Ted F use code tags.
Use sql queries and send if the player is casting, description etc.

?? what do u mean? lolz

WibbenZ · Apr 19, 2015

It's not magic lol..

Code:

ALTER TABLE `players` ADD `cast` TINYINT NOT NULL DEFAULT '0',
ADD `castViewers` INT( 11 ) NOT NULL DEFAULT '0',
ADD `castDescription` VARCHAR( 255 ) NOT NULL

You send a query to change cast to 1 when the player starts to cast.
Since you give no information about what cast system you are using, files etc it will be imposible to tell you what has to be changed.
Most likely you either got the wrong sql schema or the source code isen't that well done imo.

Ted F · Apr 19, 2015

I am using TFS 1.0 with cast system (?) I use Gesior 2012 aac.
http://Destiny.sytes.net

The code u posted :
ALTER TABLE `players` ADD `cast` TINYINT NOT NULL DEFAULT '0',
ADD `castViewers` INT( 11 ) NOT NULL DEFAULT '0',
ADD `castDescription` VARCHAR( 255 ) NOT NULL

I already have in the database.
I posted copy of cast.php & db query up in the post.
If i look in players, to the right, there is column "cast"
But when you turn cast on it wont change to 1.
Then i tried change manually, to "1" but it didnt show in webpage anyway?

WibbenZ · Apr 19, 2015

Im sorry to be rude but I think you should learn abit more about coding.
You need a way to set the sql info (ex. in the source code, lua file etc etc) and you need a way to fetch it(in this cast the cast.php file)
To make you understand this:
If I throw a ball, can you catch it? Yes.
If I don't throw a ball can you catch it? No.

And that is what you are doing right now, you are trying to catch a ball(players that cast) when nothing has thrown you the ball.
Ill send you a PM insted.

Zak.Tibiam · Sep 13, 2016

solution?

Lua cast system work in-game but not show at webpage (gesior aac)

Ted F

destiny.sytes.net - Try out NEW DESTINY 10.76

Elgenady

Veteran OT User

Ted F

destiny.sytes.net - Try out NEW DESTINY 10.76

gs1994

Not Like Mark

Elgenady

Veteran OT User

Tarek

Premium User

Ted F

destiny.sytes.net - Try out NEW DESTINY 10.76

WibbenZ

Global Moderator

Ted F

destiny.sytes.net - Try out NEW DESTINY 10.76

WibbenZ

Global Moderator

Ted F

destiny.sytes.net - Try out NEW DESTINY 10.76

WibbenZ

Global Moderator

Zak.Tibiam

New Member