Uridium

Re: adding php to an embed code ? tried that Nothing at all is being called not even the part that dislpays the title name and artist name

Re: adding php to an embed code ? ok i a nut shell ive mad the admin center so staff can insert the link for swf + the php page + height width allowaccess,, What i need is for when a user selects the required link from the video page the video opens up with the links added to the SQL Except that the links are blank. here is my full script for the users... videos.php <?php include "globals.php"; $_GET['st'] = abs((int) $_GET['st']); $st=($_GET['st']) ? $_GET['st'] : 0; $by=($_GET['by']) ? $_GET['by'] : 'tracktitle'; $ord=($_GET['ord']) ? $_GET['ord'] : 'ASC'; print "<h3>Userlist</h3>"; $cnt=$db->query("SELECT tracktitle FROM videos",$c); $membs=mysql_num_rows($cnt); $pages=(int) ($membs/100)+1; if($membs % 100 == 0) { $pages--; } print "Pages: "; for($i=1;$i <= $pages;$i++) { $stl=($i-1)*100; print "[url='videos.php?st=$stl&by=$by&ord=$ord']$i[/url] "; } print " Order By: [url='videos.php?st=$st&by=videoalphabet&ord=$ord']Alphabet Letter[/url] | [url='videos.php?st=$st&by=artist&ord=$ord']artist[/url] | [url='videos.php?st=$st&by=tracktitle&ord=$ord']Track Title[/url] [url='videos.php?st=$st&by=$by&ord=asc']Ascending[/url] | [url='videos.php?st=$st&by=$by&ord=desc']Descending[/url] "; $q=$db->query("SELECT * FROM videos ORDER BY $by $ord LIMIT $st,100"); $no1=$st+1; $no2=$st+100; print "Showing Videos $no1 to $no2 by order of $by $ord. <table width=75% cellspacing=1 class='table'><tr style='background:gray'><th>Track Name</th><th>Artists Name</th><th>Letter</th></tr>"; while($r=$db->fetch_row($q)) { $d=""; if($r['tracktitle']) { $r['artist'] = "<font color=yellow>{$r['artist']}</font>";$d=""; } print "<tr><td>{$r['tracktitle']}</td><td>[url='playvideo.php?u={$r[']{$r['artist']}[/url]</td><td>{$r['videoalphabet']}</td>"; print "</td></tr>"; } print "</table>"; $h->endpage(); ?>   playvideo.php   <?php include "globals.php"; global $db,$r,$c,$userid; $_GET['u'] = abs((int) $_GET['u']); if(!$_GET['u']) { print "Invalid use of file"; } else { $video=$db->query("SELECT * FROM videos WHERE videoID={$_GET['u']}",$c); if($db->fetch_row($video) == 0) { print "There is no such video!"; } else { $r=$db->query("SELECT playerswflink, videophplink, width, height, allowaccess FROM videos ",$c); $db->fetch_row($r); print "video Artist {$r['name']} Track Title {$r['title']} added. <h1>Preview</h1> <center><embed src='{$r['playerswflink']}' width='$width' height='$height' allowsiptallowaccess='{$r['videophplink']}' allowfullseen='true' flashvars='height=$height&width=$width&file={$r['videophplink']}$videoidlink&backcolor=0x000000&frontcolor=0xFFFFFF&lightcolor=0xCC0000&displayheight=$height&autostart='{$r['autostart']}'/></a></embed></center> "; //$db->query("UPDATE videos SET videoVIEWS=videoVIEWS+1 WHERE videoID={$_GET['u']}"); } } $h->endpage(); ?>

Ok got a bit of a brain freeze and this thing is annoing me....   <?php include "globals.php"; global $db,$r,$c,$userid; $_GET['u'] = abs((int) $_GET['u']); if(!$_GET['u']) { print "Invalid use of file"; } else { $video=$db->query("SELECT * FROM videos WHERE videoID={$_GET['u']}",$c); if($db->fetch_row($video) == 0) { print "There is no such video!"; } else { $q=$db->query("SELECT playerswflink, videophplink, width, height, allowaccess FROM videos ",$c); $db->fetch_row($q); print "video Artist {$r['name']} Track Title {$r['title']} added. <h1>Preview</h1> <center><embed src='{$r['playerswflink']}' width='$width' height='$height' allowsiptallowaccess='{$r['videophplink']}' allowfullseen='true' flashvars='height=$height&width=$width&file={$r['videophplink']}$videoidlink&backcolor=0x000000&frontcolor=0xFFFFFF&lightcolor=0xCC0000&displayheight=$height&autostart='{$r['autostart']}'/></a></embed></center> "; } } $h->endpage(); ?>   The $'s are not being placed into the script neither is the {$r['playerswflink']} can anyone tell me what im doing wrong here its annoying me as you can see here from the Source code from the webpage you will see that '' isnt being inserted <embed src='' width='' height='' allowsiptallowaccess='' allowfullseen='true' flashvars='height=&width=&file=&backcolor=0x000000&frontcolor=0xFFFFFF&lightcolor=0xCC0000&displayheight=&autostart='/></a></embed>

Re: [mccodes V2] Add any type of video media to your game Sorry found a typo on the SQLS change `videoIDlink` INT(11) NOT NULL default '186', to `videoidlink` INT(11) NOT NULL default '0',

Re: [mccodes V2] Add any type of video media to your game Ok so how does it work... All sites use either a sef link and or a php link both of which also use a unique ID for the track to be played... so For example.... if you want to play say Wonderwoman. (Bound to get some crap comments now lol) The url on youtube is......   <object width="425" height="344"><param name="movie" value="http://www.youtube.com/v/qahSU4RYblY&hl=en&fs=1"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/qahSU4RYblY&hl=en&fs=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="425" height="344"></embed></object>   We need to extract a few parts from here example the link for swf would be the PHP link would be And the Video ID link number would be 1 to work on Youtube... for Jesusjones.com the link looks like   <center><embed src='http://www.gamepapa.com/music/vplayer.swf' width='480' height='360' allowscriptaccess='always' allowfullscreen='true' flashvars='height=360&width=480&file=http://www.gamepapa.com/music/flash.php?id=186&backcolor=0x000000&frontcolor=0xFFFFFF&lightcolor=0xCC0000&displayheight=380&autostart=true'/></a></embed></center>   So the example would be SWF LINK = http://www.gamepapa.com/music/vplayer.swf PHP LINK = http://www.gamepapa.com/music/flash.php?id= Video Track ID = 186

Re: [mccodes V2] Add any type of video media to your game SQLS   CREATE TABLE `videos` ( `videoID` INT(11) NOT NULL auto_increment, `artist` varchar(255) NOT NULL default 'ABBA', `tracktitle` varchar(255) NOT NULL default 'One Of US', `videoalphabet` varchar(255) NOT NULL default 'A', `playerswflink` varchar(255) NOT NULL default 'http://www.gamepapa.com/music/vplayer.swf', `videophplink` varchar(255) NOT NULL default 'http://www.gamepapa.com/music/flash.php?id=', `allowaccess` varchar(255) NOT NULL default 'always', `autostart` varchar(255) NOT NULL default 'true', `videoIDlink` INT(11) NOT NULL default '186', `width` INT(11) NOT NULL default '350', `height` INT(11) NOT NULL default '400', PRIMARY KEY (`videoID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;   Call this file staff_videos.php   <?php include "sglobals.php"; if($ir['user_level'] > 2) { die("403"); } //This contains video stuffs switch($_GET['action']) { case "addvideo": addvideo(); break; case "editvideo": editvideo(); break; case "delvideo": delvideo(); break; default: print "Error: This sipt requires an action."; break; } function addvideo() { global $db, $ir, $c, $h, $userid; $videoidlink=abs((int) $_POST['videoidlink']); $width=abs((int) $_POST['width']); $height=abs((int) $_POST['height']); if($_POST['name'] && $_POST['title'] && $videoidlink && $height && $width) { $db->query("INSERT INTO videos VALUES(NULL, '{$_POST['name']}', '{$_POST['title']}', '{$_POST['alphabet']}', '{$_POST['playerswflink']}', '{$_POST['videophplink']}', '{$_POST['allowaccess']}', '{$_POST['autostart']}', '$videoidlink', '$width', '$height')"); print "video Artist {$_POST['name']} Track Title {$_POST['title']} added. <h1>Preview</h1> <center><embed src='{$_POST['playerswflink']}' width='$width' height='$height' allowsiptallowaccess='always' allowfullseen='true' flashvars='height=360&width=480&file={$_POST['videophplink']}$videoidlink&backcolor=0x000000&frontcolor=0xFFFFFF&lightcolor=0xCC0000&displayheight=380&autostart=true'/></a></embed></center> "; stafflog_add("Added video {$_POST['title']}"); } else { print "<h3>Add video</h3><hr /> <form action='staff_videos.php?action=addvideo' method='post'> Artist Name: <input type='text' name='name' /> Track Title: <input type='text' name='title' /> Alphabet Letter: <input type='text' name='alphabet' /> SWF Link: <input type='text' name='playerswflink' /> Example [url]http://www.domain.com/music/vplayer.swf[/url] PHP link: <input type='text' name='videophplink' /> Example [url]http://www.domain.com/music/flash.php?id=[/url] Allow allowaccess: <input type='text' name='allowaccess' /> Default always Autostart Media: <input type='text' name='autostart' /> true or false Video ID Number: <input type='text' name='videoidlink' /> example 17635 Player Width: <input type='text' name='width' /> default 350 Player Height: <input type='text' name='height' />default 400 <input type='submit' value='Add video' /></form>"; } } function editvideo() { global $db, $ir, $c, $h, $userid; switch($_POST['step']) { case "2": $videoidlink=abs((int) $_POST['videoidlink']); $width=abs((int) $_POST['width']); $height=abs((int) $_POST['height']); $name=$_POST['name']; $db->query("UPDATE videos SET artist='$name', tracktitle='{$_POST['title']}', videoalphabet='{$_POST['alphabet']}', playerswflink='{$_POST['playerswflink']}', videophplink='{$_POST['videophplink']}' , videoidlink=$videoidlink, width=$width, height=$height WHERE videoID={$_POST['video']}"); print "video $name was edited successfully. <h1>Preview</h1> <center><embed src='{$_POST['playerswflink']}' width='$width' height='$height' allowsiptallowaccess='always' allowfullseen='true' flashvars='height=360&width=480&file={$_POST['videophplink']}$videoidlink&backcolor=0x000000&frontcolor=0xFFFFFF&lightcolor=0xCC0000&displayheight=380&autostart=true'/></a></embed></center> "; stafflog_add("Edited video $name"); break; case "1": $q=$db->query("SELECT * FROM videos WHERE videoID={$_POST['video']}"); $old=$db->fetch_row($q); print "<h3>Editing a video</h3><hr /> <form action='staff_videos.php?action=editvideo' method='post'> <input type='hidden' name='step' value='2' /> <input type='hidden' name='video' value='{$_POST['video']}' /> Artist Name <input type='text' name='name' value='{$old['artist']}' /> Track Title: <input type='text' name='title' value='{$old['tracktitle']}' /> Alphabet Entry: <input type='text' name='alphabet' value='{$old['videoalphabet']}' /> SWF link Text: <input type='text' name='playerswflink' value='{$old['playerswflink']}' /> PHP Link Text: <input type='text' name='videophplink' value='{$old['videophplink']}' /> Allow allowaccess: <input type='text' name='allowaccess' value='{$old['allowaccess']}' /> Auto Start: <input type='text' name='autostart' value='{$old['autostart']}' />true or false Video ID Number: <input type='text' name='videoidlink' value='{$old['videoidlink']}' /> Player Width: <input type='text' name='width' value='{$old['width']}' /> Player Height: <input type='text' name='height' value='{$old['height']}' /> <input type='submit' value='Edit video' /></form>"; break; default: print "<h3>Editing a video</h3><hr /> <form action='staff_videos.php?action=editvideo' method='post'> <input type='hidden' name='step' value='1' /> video: ".video2_dropdown($c, "video")." <input type='submit' value='Edit video' /></form>"; break; } } function delvideo() { global $db,$ir,$c,$h,$userid; if($_POST['video']) { $q=$db->query("SELECT * FROM videos WHERE videoID={$_POST['video']}"); $old=$db->fetch_row($q); $db->query("DELETE FROM videos WHERE videoID={$_POST['video']}"); print "video {$old['tracktitle']} deleted."; stafflog_add("Deleted video {$old['tracktitle']}"); } else { print "<h3>Deleting a video</h3><hr /> <form action='staff_videos.php?action=delvideo' method='post'> video: ".video2_dropdown($c, "video")." <input type='submit' value='Delete video' /></form>"; } } $h->endpage(); ?>   Add these links to smenu   Create New video Edit Exsisting video Delete video Open up global_func.php and add this   function video2_dropdown($connection,$ddname="video",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM videos ORDER BY tracktitle ASC"); if($selected == -1) { $first=0; } else { $first=1; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['videoID']}'"; if ($selected == $r['videoID'] || $first == 0) { $ret.=" selected='selected'";$first=1; } $ret.=">{$r['tracktitle']}</option>"; } $ret.="\n</select>"; return $ret; }

Ive started a script which will allow staff to put up any type of video link from google, youtube and virtually any other kind of media that uses flash player. The prototype works fine for the admin section just a few editing Flash problems to overcome. Artist Name: Track Title: Alphabet Letter: SWF Link: Example http://www.domain.com/music/vplayer.swf PHP link: Example http://www.domain.com/music/flash.php?id= Allow Access: Default always Autostart Media: true or false Video ID Number: example 17635 Player Width: default 350 Player Height: default 400 Is how the staff menu is laid out havent started the user side yet but that wont take too long......

Re: Automatically returns to inventory after equipping Ive just given you a +1 cos your script as just helped me out on one of my mods Cheers and keep up the good work...

Re: [MC-Codes][V2]Thugs (core system)   What is it with this Girl and Arrays shes Array mad.

Re: [MCCODES V2] 100% Working Copy Enhanced Schooling Thanks to furn355's script from here FURNS SCRIPT We can fix the refreshing error.. open your education.php and imediatley underneath include"globals.php"; add print"<META HTTP-EQUIV=Refresh CONTENT='100;url=index.php'>"; That should cure it...

Re: [uPDATE] V2 extract Users from Bots when adding to Battletent Badgirl All my scripts are generated for easy setup and run for everyone even those that havent got a clue what stripslashes are.. When you purchase your first MCCODES script there is hardly any mention of of higher level php coding so i keep all mine as basic as possible to help those that are still learning. Once theyve gained more confidence then they can change the script to their needs.

Re: [MCCODES V2] 100% Working Copy Enhanced Schooling Yeah i noticed that this morning i'll work on a fix for it...

Re: [Mccodes V2] Set Up V2 the way you want it without altering files.... I forgot all about this topic :)

Are you fed up of the standard font files on your game ? so heres the problem you can change them to a font file in your c:\fonts folder but then you run into the problem that if another user doesnt have that particular font then all they will see is the default arial font instead. So have a read of this article and get your newly uploaded fonts noticed by everyone. READ THIS POST And start having fun with your new fonts.

Re: [MCCODES V2] Fighting stats just cleaned up   <? $stat = mysql_fetch_object(mysql_query("SELECT `strength`, `agility`, `guard`, `labour` FROM `userstats` WHERE (`userid` = ". $ir['userid'] .")")); echo '<h2>Fighting Stats</h2>'. '<table border="1" width="100%">'. '<tr>'. '<th>Strength</th>'. '<th>Agility</th>'. '<th>Guard</th>'. '<th>Labour</th> '<th>Total Stats</th>'. '</tr>'. '<tr style="text-align: center;">'. '<td>'. $stat->strength .'</td>'. '<td>'. $stat->agility .'</td>'. '<td>'. $stat->guard .'</td>'. '<td>'. $stat->labour .'</td>'. '<td>'. ($stat->strength + $stat->agility + $stat->guard + $stat->labour) .'</td>'. '</tr>'. '</table>'; ?>

Re: [MCCODES V2] Fighting stats just cleaned up Cheeers Badgril :) I was just trying to space it out abit as most people find spaced Scripting easier to read. But i dont think yours would quite work hun. Have a look at your script again and you'll see what i mean.

Re: [MCCODES V2] 100% Working Copy Enhanced Schooling Add this to your hourly cron   $db->query("UPDATE users SET clickend=0 where clickend > '0'"); $db->query("UPDATE users SET minus_clicks=0 where minus_clicks >'0'");   And this to your daily cron   $db->query("UPDATE users SET course_clicks=18");

Re: [MCCODES V2] 100% Working Copy Enhanced Schooling ooops i made an error on the User sqls sorry i must have not been paying attention   ALTER TABLE users ADD cpercent INT ( 11 ) NOT NULL DEFAULT 0; ALTER TABLE users ADD course_clicks INT ( 11 ) NOT NULL DEFAULT 18; ALTER TABLE users ADD minus_clicks INT ( 11 ) NOT NULL DEFAULT 0; ALTER TABLE users ADD clickend INT ( 11 ) NOT NULL DEFAULT 0;   How the above Works cpercent is the whole percentage the user has to achieve course_clicks is the amount of daily clicks they are allowed per day minus_clicks is the amount of clicks per session before the come back in an hour message is displayed endclicks works with minus_clicks so users dont exceed their hourly allowance.

Re: [MCCODES V2] 100% Working Copy Enhanced Schooling SQLS for courses. including my setup   CREATE TABLE IF NOT EXISTS `courses` ( `crID` int(11) NOT NULL auto_increment, `crNAME` varchar(255) NOT NULL default '', `crDESC` text NOT NULL, `crSTARTING` text NOT NULL, `crCOMPLETED` text NOT NULL, `crCOST` int(11) NOT NULL default '0', `crENERGY` int(11) NOT NULL default '0', `crCASHPRIZE` int(11) NOT NULL default '0', `crITEM` int(11) NOT NULL default '0', `crQTY` int(11) NOT NULL default '0', `crCOMPPERCENT` int(11) NOT NULL default '0', `crPERCENT` int(11) NOT NULL default '0', `crCLICKS` int(11) NOT NULL default '0', `crPERCLICKS` int(11) NOT NULL default '0', `crSTR` int(11) NOT NULL default '0', `crGUARD` int(11) NOT NULL default '0', `crLABOUR` int(11) NOT NULL default '0', `crAGIL` int(11) NOT NULL default '0', `crIQ` int(11) NOT NULL default '0', PRIMARY KEY (`crID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- Dumping data for table `courses` -- INSERT INTO `courses` (`crID`, `crNAME`, `crDESC`, `crSTARTING`, `crCOMPLETED`, `crCOST`, `crENERGY`, `crCASHPRIZE`, `crITEM`, `crQTY`, `crCOMPPERCENT`, `crPERCENT`, `crCLICKS`, `crPERCLICKS`, `crSTR`, `crGUARD`, `crLABOUR`, `crAGIL`, `crIQ`) VALUES (1, 'Human Bodies', 'Now to find your Agility Boost', 'You start running and your master seems very impressed with you', '0', 10, 10, 2000, 1, 0, 300, 1, 18, 0, 10, 10, 10, 10, 10), (2, 'Herbology', 'Learn to Clense yourself Better', 'Your master throws you into a pit of lions its up to you how you survive this.', 'Your Master is so impressed with the Outcome he rewards you with.', 5, 5, 1000, 1, 0, 100, 3, 18, 0, 5, 5, 5, 5, 5), (3, 'test', 'Just testing', 'kill him', '"Weldone you have proved without a doubt you are a worthy fighter"', 1, 1, 0, 1, 1, 10000, 1, 18, 0, 1, 1, 1, 1, 1), (4, 'Harry Pothead', 'Time to kill bogeyed boy', 'You see Harry Pothead and start taking potshots with your air rifle', 'Congratulation the little sod is dead weldone', 1, 1, 1000, 1, 1, 100, 90, 18, 0, 1, 1, 1, 1, 1), (5, 'TESTING 123', 'STILL TESTING 123', ' CARRY ME HOME MOMMA', 'THATS THE WAY IT IS', 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1);   USERS SQLS ALTER TABLE users ADD cpercent INT ( 11 ) NOT NULL DEFAULT 18; ALTER TABLE users ADD course_clicks INT ( 11 ) NOT NULL DEFAULT 0; ALTER TABLE users ADD minus_clicks INT ( 11 ) NOT NULL DEFAULT 0; ALTER TABLE users ADD clickend INT ( 11 ) NOT NULL DEFAULT 0;

open up index.php and add this code before the endpage statement $cd=$db->query("SELECT strength, agility, guard, labour, IQ FROM userstats Where userid={$ir['userid']}"); $fstats=$db->fetch_row($cd); echo '<h2>Fighting Stats</h2> <table border="1" width="100%" class="table" cellspacing="3" cellpadding="4"> <tr> <th>Strength</th> <th>Agility</th> <th>Guard</th> <th>Labour</th> <th>Total Stats</th> </tr> <tr>'; echo ' <td>'.$fstats['strength'].'</td> <td>'.$fstats['agility'].'</td> <td>'.$fstats['guard'].'</td> <td>'.$fstats['labour'].'</td> <td>'.($fstats['strength'] + $fstats['agility'] + $fstats['strength'] + $fstats['strength']).'</td> </tr> </table>';

Re: [mccode v2] Stock Market. Working + Secured HAUNTED just gets an Instant +1 without me even adding his script cos the Chances of it NOT working are very slim Great mod pal :)

Re: [MCCODES ALL] IE8 Fix for visual Errors   Ive seen this issue before cant quite remember how it was solved. i am sure though it was a header.php file problem.

Not sure if anyone noticed any glitches on their Internet Explorer 8 where by some things just didnt seem right. On mine it was mainly the CSS and Javascript it would act up at times... So heres a small fix.. for those using IE8 open up header.php Just under <? Add header('X-UA-Compatible: IE=EmulateIE7'); This should make IE8 Emulate IE7 which was fine for me.   Reason for EDIT fat fingers

Re: [mccode V2] Search Islands Nice script :) However if you put your mind to this you could use it to yur advantage instead of a one off system that just finds whats available make an admin center to create pre defined finds.... example........ and this is just me thinking out-side the box yet again ;) LOCATION SETUP What will user find at chance 1 = What will user find at chance 2 = What will user find at chance 3 = What will user find at chance 4 = What will user find at chance 5 = What will user find at chance 6 = What will user find at chance 7 = What will user find at chance 8 = What will user find at chance 9 = What will user find at chance 10 = Then on your script you would only need 1 chance but rand it by 10

Re: [MCCODES V2] 100% Working Copy Enhanced Schooling Ooops sorry about that Inferno yes hes right the USERS should be cpercent   Thanks matey :)