-
Posts
58 -
Joined
-
Last visited
Posts posted by rastaman46
-
-
Well im trying make search with multiple checkbox
-
hello again sorry for to many post but im still new in php
here sql im run
SELECT t.tid, t.info_hash, t.name, t.description, t.cid, t.size, t.added, t.leechers, t.seeders, t.times_completed, t.owner, t.options, t.nfo, t.sticky, t.flags, t.mtime, t.ctime, t.download_multiplier, t.upload_multiplier, t.external, t.tags, r.cname, u.membername, m.groupname, m.groupstyle FROM tsue_membergroups AS m Inner Join tsue_members AS u ON u.membergroupid = m.membergroupid Inner Join tsue_torrents AS t ON t.owner = u.memberid Inner Join tsue_torrents_categories AS r ON t.cid = r.cid WHERE upper(name) LIKE '%%' and `t.cid` IN(1)
and error im get
#1054 - Unknown column 't.cid' in 'where clause'
-
What i trying to do is make search with multiple check boxes
here is may error im get
Please try again later or contact an Administrator. (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Inner Join rasta_cinema_categories AS r ON cat = r.cat WHERE upper() LIKE'%%'' at line 2 SELECT `video_id`, `name`, `description`, `video_name`, `thumb_image`, `release`, `cat`, `format`, `imbd_url`,`added`, `recomended` ,`sticky`, `owner`, `clicks` FROM `rasta_cinema` AS Inner Join rasta_cinema_categories AS r ON cat = r.cat WHERE upper() LIKE'%%'
and here is the code
$searching = (isset($_POST['searching']) ? $_POST['searching'] : ''); if ($searching =="yes") { $paieska = (isset($_POST['find']) ? $_POST['find'] : ''); if ($paieska == "") { $klaida = '<div class="error" id="show_error">You forgot to enter a search term</div>'; } $checkbox = $_POST['cat']; if ($checkbox !='') { $extra = " and `cat` IN(". explode(', ',$checkbox) . ")"; } $cinema = ''; $filmai = $TSUE['TSUE_Database']->query("SELECT `video_id`, `name`, `description`, `video_name`, `thumb_image`, `release`, `cat`, `format`, `imbd_url`,`added`, `recomended` ,`sticky`, `owner`, `clicks` FROM `rasta_cinema` AS Inner Join rasta_cinema_categories AS r ON cat = r.cat WHERE upper($field) LIKE'%$paieska%'".$extra); $numrows = mysqli_num_rows($filmai); if($numrows == 0) { $klaida = '<div class="error" id="show_error">Nothing found</div>'; } while ($row = mysqli_fetch_array($filmai)) { $cinema_row = ''; $id = $row['video_id']; $name = $row['name']; $description = $row['description']; $video_name = $row['video_name']; $thumb = $row['thumb_image']; $release = $row['release']; $format = $row['format']; $imbd_url = $row['imbd_url']; $cat = $row['cat']; $owner = $row['owner']; $clicks = $row['clicks']; $data = date('Y-m-d H:i:s',$row['added']); $nujo = $row['recomended']; $sticky = $row['sticky']; $free = ""; if ($row['recomended'] == 1){ $free = '<img title="Recomended" src="/cinema/images/heart.png"/>'; } $sticky = ""; if ($row['sticky'] == 1){ $sticky = '<img title="Sticky" src="/cinema/images/pin.png"/>'; } $recomended = ''; $recomended = $free.$sticky; eval("\$cinema_row = \"".$TSUE['TSUE_Template']->LoadTemplate('cinema_row')."\";"); $cinema .= $cinema_row; } }
-
PHP Warning: preg_replace() [function.preg-replace]: Unknown modifier '.'
-
if im use preg im get white page
-
How to solve this error out
PHP Deprecated: Function ereg_replace() is deprecated in
using this code
$shoutcast_on_off =''; $scsuccs = ''; $listenlink = ''.$scdef.''; $scfp = fsockopen("$scip", $scport, &$errno, &$errstr, 30); if(!$scfp) { $scsuccs=1; } $page = ''; if($scsuccs!=1){ fputs($scfp,"GET /admin.cgi?pass=$scpass&mode=viewxml HTTP/1.0\r\nUser-Agent: SHOUTcast Song Status (Mozilla Compatible)\r\n\r\n"); while(!feof($scfp)) { $page .= fgets($scfp, 1000); } $loop = array("STREAMSTATUS"); $y=0; while($loop[$y]!=''){ $pageed = ereg_replace(".*<$loop[$y]>", "", $page); $scphp = strtolower($loop[$y]); $$scphp = ereg_replace("</$loop[$y]>.*", "", $pageed); $y++; } fclose($scfp); } $online1 = ''; if ($streamstatus == "1") { $online1 = '<center><img src="'.$BASEURL.'/styles/'.$theme.'/theme_images/DJ.png" border="0" height="150"></center><br> <center><a href="'.$BASEURL.':'.$scport.'/listen.pls"><img src="'.$BASEURL.'/styles/'.$theme.'/theme_images/klausom.png" width="150px" height="auto"></a></center>'; } else { $online2 = ''; $online2 = '<center><img src="'.$BASEURL.'/styles/'.$theme.'/theme_images/off.png" border="0" height="150"></center>'; } // BEGIN Plugin: shoutcast_on_off $shoutcast_on_off = $online1.$online2; // END Plugin: shoutcast_on_off eval("\$shoutcast = \"".$TSUE['TSUE_Template']->LoadTemplate('shoutcast')."\";"); return $shoutcast;
-
How can i use php in java?
code below dont work
hdwebplayer({
id : 'player',
swf : 'cinema/player.swf',
width : '640',
height : '360',
video : 'cinema/videos/'.$video_name.'',
autoStart: 'true'
});
-
dont work even if im do
$mycode = 'Can get dam thing to make me page';
any other options make page like index.php?mypage
????
-
how to do it other way
im cant use echo
-
Hello again having trouble to switch pages
All it dose just refrashe page
<a href=/?p=cinema&pid=503&act=video>Test</a>
$keiciam = isset($_GET['act']) ? $_GET['act']:'';switch($keiciam)
{
case 'video':
eval("\$cinema_player = \"".$TSUE['TSUE_Template']->LoadTemplate('cinema_player')."\";");
break;
default:
}
-
LOVE you m8 thanks sorted
Big big thanks m8
-
Thanks works now query
but my form dont post anything in just refrech page ???
form is
<form name="search" method="post"> Search for: <input class="rasta_text" type= "text" name="find" /> in <Select class="darozas" NAME="field"> <Option VALUE="name">Torrent name</option> <Option VALUE="membername">Username</option> <Option VALUE="info">Paskey</option> </Select> <input type="hidden" name="searching" value="yes" /> <input class="submit" type="submit" name="search" value="Search" /> </form>
//This is only displayed if they have submitted the form $searching = ''; if ($searching =="yes") { $nervai = "<h2>Results</h2><p>"; //If they did not enter a search term we give them an error $find = ''; if ($find == "") { $nervai = "<p>You forgot to enter a search term"; exit; } // We preform a bit of filtering $find = strtoupper($find); $find = strip_tags($find); $find = trim ($find); $nervai = ''; $run = $TSUE['TSUE_Database']->query("SELECT t.tid, t.info_hash, t.name, t.description, t.cid, t.size, t.added, t.leechers, t.seeders, t.times_completed, t.owner, t.options, t.nfo, t.sticky, t.flags, t.mtime, t.ctime, t.download_multiplier, t.upload_multiplier, t.external, t.tags, r.cname, u.membername, m.groupname, m.groupstyle FROM tsue_membergroups AS m Inner Join tsue_members AS u ON u.membergroupid = m.membergroupid Inner Join tsue_torrents AS t ON t.owner = u.memberid Inner Join tsue_torrents_categories AS r ON t.cid = r.cid WHERE upper($field) LIKE'%$find%'"); $week_yra = mysqli_num_rows($run); if($run){ if(mysqli_num_rows($run) == 0){ $nervai = '<div class="error" id="show_error">Nothing found</div>'; } else { while ($row = mysqli_fetch_array($run)) { $savaites = ''; $name = $row['name']; $cat = $row['cid']; $data = date('Y-m-d H:i:s',$row['added']); $baigtas = $row['times_completed']; $uploader = str_replace('{membername}', $row['membername'], $row['groupstyle']); $description= $row['description']; $dydis = size_hum_read($row['size']); $leechers= $row['leechers']; $owner= $row['owner']; $nunx= $row['tid']; $seeders= $row['seeders']; $free = ""; if ($row['download_multiplier'] < 1){ $free = '<img title="'.get_phrase('torrent_free').'" src="'.$baseurl.'/styles/'.$theme.'/torrents/torrent_free.png"/>'; } $freeif = ''; if ($row['download_multiplier'] > 1){ $freeif = '<img title="'.get_phrase('torrent_download_multiplier').':'.$row['download_multiplier'].'" src="'.$baseurl.'/styles/'.$theme.'/torrents/torrent_free.png"/>'; } $double = ""; if ($row['upload_multiplier'] > 1){ $double = '<img title="'.get_phrase('torrent_upload_multiplier').':'.$row['upload_multiplier'].'" src="'.$baseurl.'/styles/'.$theme.'/torrents/torrent_multiple_upload.png"/>'; } $stiky = ""; if ($row['sticky'] > 0){ $stiky = '<img title="'.get_phrase('sticky_torrent').'" src="'.$baseurl.'/styles/'.$theme.'/torrents/sticky.png"/>'; } $torrent_images = ''; $torrent_images = $free.$freeif.$double.$stiky; $test = $TSUE['TSUE_Database']->query("select * from tsue_attachments where tsue_attachments.content_id = $nunx and content_type = 'torrent_images'"); $filename = ''; if(mysqli_num_rows($test) == 0){ $filename = "noposter.png"; }else{ while ($row = mysqli_fetch_array($test)) { $filename = $row ['filename']; } } eval("\$jamam = \"".$TSUE['TSUE_Template']->LoadTemplate('rasta_export')."\";"); $nervai .= $jamam; } } } //This counts the number or results - and if there wasn't any it gives them a little message explaining that $anymatches=mysqli_num_rows($run); if ($anymatches == 0) { $nervai = "Sorry, but we can not find an entry to match your query<br><br>"; } //And we remind them what they searched for $nervai = "<b>Searched For:</b> " .$find; }
-
Hello again
here is my prob
im trying to run in my search php
membername is column with all members in it rastaman46 is one of the members
But im cant get it search by name
Please help
SELECT * FROM tsue_members WHERE upper(membername) LIKE %Rastaman46%
but keep geting error
MySQL server version for the right syntax to use near '%Rastaman46% LIMIT 0, 30' at line 1
-
Thanks you save my day...
-
Hello again
here is my code but its dont work correct
$super = $_GET['video_id']; $filmai = $TSUE['TSUE_Database']->query("SELECT rasta_cinema.video_id, rasta_cinema.name, rasta_cinema.description, rasta_cinema.video_name, rasta_cinema.thumb_image FROM rasta_cinema WHERE video_id = $super LIMIT 1");
error im get is
Database Error! Please try again later or contact an Administrator. (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1 SELECT rasta_cinema.video_id, rasta_cinema.name, rasta_cinema.description, rasta_cinema.video_name, rasta_cinema.thumb_image FROM rasta_cinema WHERE video_id = LIMIT 1
Thanks
-
thanks
-
hello again
how to get ratio with result max 3 numbers such as 3.00 or 0.11
if im do $mynumbers = 1000 / 400;
so reusult to be 1.00 ?
and how to put full stop if it is more then 4 numbers
result instead of 1000 to have 1.000
-
Did any other options to do this ?
-
that was just example
im need take user posts say user posted 500 post i need to put image next to hes nick name
somthing like
here my sql query go in this lane
if ($row['user_posted'] == 500)
{
$bestposter = 'here i need add image'
}
-
hello again need some advice
cant get it working
SELECT * FROM `tsue_members` WHERE memberid=0 if ($row['memberid'] == '0') { $img = "1.gif"; } echo $img;
-
well if im use session im getting this
Database Error! Please try again later or contact an Administrator. (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
-
Well all system is encoded.
Any chance to make my own function to get current user ID
-
that im put as the sample i like so this $get_my_id'; get me logged user ID auto somthing like $curuser['ID]; but i dont know how to make it
-
SELECT m.memberid, p.memberid, p.uploaded, p.downloaded, p.total_posts, p.invites_left, p.points FROM tsue_members m, tsue_member_profile p WHERE p.memberid=m.memberid AND p.memberid='$get_my_id';
In php if you know what im mean.
zip multiple items with check box [HELLP]
in PHP Coding Help
Posted
Hello need some help
keep getting
code im use
html
Please help