Mysidia Adoptables Support Forum  

Home Community Mys-Script Creative Off-Topic
Go Back   Mysidia Adoptables Support Forum > Mysidia Adoptables > Questions and Supports

Notices

Reply
 
Thread Tools Display Modes
  #11  
Old 03-22-2012, 08:44 PM
SilverDragonTears's Avatar
SilverDragonTears SilverDragonTears is offline
I am your Nemesis.
 
Join Date: Jun 2011
Posts: 1,113
Gender: Female
Credits: 81,208
SilverDragonTears is on a distinguished road
Default

*waits somewhat patiently* :)
__________________

Check out SilvaTales
Reply With Quote
  #12  
Old 03-22-2012, 09:32 PM
!Alive !Alive is offline
Member
 
Join Date: Feb 2012
Posts: 39
Gender: Male
Credits: 1,053
!Alive is on a distinguished road
Default

I found a way to make the three adoptables have a random rarity but I am sure it is NOT the best way to do it. I just can't come up with a better way of doing it right now. :P
I can make the changes to the original adopts.php file and post it for you.
Do you know how to add a column to your adoptables table?
Reply With Quote
  #13  
Old 03-22-2012, 09:34 PM
SilverDragonTears's Avatar
SilverDragonTears SilverDragonTears is offline
I am your Nemesis.
 
Join Date: Jun 2011
Posts: 1,113
Gender: Female
Credits: 81,208
SilverDragonTears is on a distinguished road
Default

I do :) I'll give it a try and see how it works... do you want payment for this?
__________________

Check out SilvaTales
Reply With Quote
  #14  
Old 03-22-2012, 09:57 PM
!Alive !Alive is offline
Member
 
Join Date: Feb 2012
Posts: 39
Gender: Male
Credits: 1,053
!Alive is on a distinguished road
Default

Okay. XD I don't need anything.

For the code below you will need to create a new column in the (prefix)_adoptables table with the name of rarity and type int(11).
Rarity values(assign to the adoptables for their rarity)
common = 0
uncommon = 1
rare = 2
ultrarare = 3

more can be added but you would have to add more statments to the code.

Find (aaround line 25):
PHP Code:
$query "SELECT * FROM ".$prefix."adoptables";
    
$result runquery($query);
    
    
$article_content .= "<form name='form1' method='get' action='doadopt.php'>
    <h3>Available Adoptables</h3><table>"
;

    while(
$row mysql_fetch_array($result)) {
        
$aid=$row['id']; //The adoptable's ID
        
$type=$row['type'];
        
$description=$row['description'];
        
$eggimage=$row['eggimage'];

        
// Call a function to check if we have the proper privledge level to adopt this pet
        
if($promocode == ""){
            
$promocode "none";
        }

        
$canadopt canadopt($aid"showing"$promocode$row); // Feed an adoptable ID and showing, to show the adopt to guests...

        
if($canadopt == "yes"){
            
//If we can adopt the adoptable, show the image and adoption link...
            
$article_content .= "<tr>
            <td><input type='radio' name='id' id='id' value='
{$aid}' /></td>
            <td style='text-align: center'><img src='"
.$eggimage."' /></td>
            <td><strong>
{$type}</strong> - {$row['cost']} {$GLOBALS['settings']['cost']}.<br />{$description}</td></tr>";
        }
    } 
Replace with:
PHP Code:
    $uncommon rand(1,50);
    
$rare rand(1,100);
    
$ultrarare rand(1,200);

    if (
$uncommon==1){
    
$query "SELECT * FROM ".$prefix."adoptables WHERE rarity='1' ORDER BY RAND() LIMIT 1";
    }
    else if (
$rare==1){
    
$query "SELECT * FROM ".$prefix."adoptables WHERE rarity='2' ORDER BY RAND() LIMIT 1";
    }    
    else if (
$ultrarare==1){
    
$query "SELECT * FROM ".$prefix."adoptables WHERE rarity='3' ORDER BY RAND() LIMIT 1";
    }    
    else{
    
$query "SELECT * FROM ".$prefix."adoptables WHERE rarity='0' ORDER BY RAND() LIMIT 1";
    }


    
$result runquery($query);
    
    
$article_content .= "<form name='form1' method='get' action='doadopt.php'>
    <h3>Available Adoptables</h3><table>"
;

    while(
$row mysql_fetch_array($result)) {
        
$aid=$row['id']; //The adoptable's ID
        
$type=$row['type'];
        
$description=$row['description'];
        
$eggimage=$row['eggimage'];

        
// Call a function to check if we have the proper privledge level to adopt this pet
        
if($promocode == ""){
            
$promocode "none";
        }

        
$canadopt canadopt($aid"showing"$promocode$row); // Feed an adoptable ID and showing, to show the adopt to guests...

        
if($canadopt == "yes"){
            
//If we can adopt the adoptable, show the image and adoption link...
            
$article_content .= "<tr>
            <td><input type='radio' name='id' id='id' value='
{$aid}' /></td>
            <td style='text-align: center'><img src='"
.$eggimage."' /></td>
            <td><strong>
{$type}</strong> - {$row['cost']} {$GLOBALS['settings']['cost']}.<br />{$description}</td></tr>";
        }
    } 
    

    if (
$uncommon==1){
    
$query "SELECT * FROM ".$prefix."adoptables WHERE rarity='1' ORDER BY RAND() LIMIT 1";
    }
    else if (
$rare==1){
    
$query "SELECT * FROM ".$prefix."adoptables WHERE rarity='2' ORDER BY RAND() LIMIT 1";
    }    
    else if (
$ultrarare==1){
    
$query "SELECT * FROM ".$prefix."adoptables WHERE rarity='3' ORDER BY RAND() LIMIT 1";
    }    
    else{
    
$query "SELECT * FROM ".$prefix."adoptables WHERE rarity='0' ORDER BY RAND() LIMIT 1";
    }


    
$result runquery($query);


while(
$row mysql_fetch_array($result)) {
        
$aid=$row['id']; //The adoptable's ID
        
$type=$row['type'];
        
$description=$row['description'];
        
$eggimage=$row['eggimage'];

        
// Call a function to check if we have the proper privledge level to adopt this pet
        
if($promocode == ""){
            
$promocode "none";
        }

        
$canadopt canadopt($aid"showing"$promocode$row); // Feed an adoptable ID and showing, to show the adopt to guests...

        
if($canadopt == "yes"){
            
//If we can adopt the adoptable, show the image and adoption link...
            
$article_content .= "<tr>
            <td><input type='radio' name='id' id='id' value='
{$aid}' /></td>
            <td style='text-align: center'><img src='"
.$eggimage."' /></td>
            <td><strong>
{$type}</strong> - {$row['cost']} {$GLOBALS['settings']['cost']}.<br />{$description}</td></tr>";
        }
    }

if (
$uncommon==1){
    
$query "SELECT * FROM ".$prefix."adoptables WHERE rarity='1' ORDER BY RAND() LIMIT 1";
    }
    else if (
$rare==1){
    
$query "SELECT * FROM ".$prefix."adoptables WHERE rarity='2' ORDER BY RAND() LIMIT 1";
    }    
    else if (
$ultrarare==1){
    
$query "SELECT * FROM ".$prefix."adoptables WHERE rarity='3' ORDER BY RAND() LIMIT 1";
    }    
    else{
    
$query "SELECT * FROM ".$prefix."adoptables WHERE rarity='0' ORDER BY RAND() LIMIT 1";
    }


    
$result runquery($query);


while(
$row mysql_fetch_array($result)) {
        
$aid=$row['id']; //The adoptable's ID
        
$type=$row['type'];
        
$description=$row['description'];
        
$eggimage=$row['eggimage'];

        
// Call a function to check if we have the proper privledge level to adopt this pet
        
if($promocode == ""){
            
$promocode "none";
        }

        
$canadopt canadopt($aid"showing"$promocode$row); // Feed an adoptable ID and showing, to show the adopt to guests...

        
if($canadopt == "yes"){
            
//If we can adopt the adoptable, show the image and adoption link...
            
$article_content .= "<tr>
            <td><input type='radio' name='id' id='id' value='
{$aid}' /></td>
            <td style='text-align: center'><img src='"
.$eggimage."' /></td>
            <td><strong>
{$type}</strong> - {$row['cost']} {$GLOBALS['settings']['cost']}.<br />{$description}</td></tr>";
        }
    } 
Oh, and if you use the admin panel to add new adoptables you will want to be sure to add the value to the insert into query when creating.

That should do it. Let me know how it works for you or if you need help. :D
*is still learning this stuff myself*
Reply With Quote
  #15  
Old 03-22-2012, 10:08 PM
SilverDragonTears's Avatar
SilverDragonTears SilverDragonTears is offline
I am your Nemesis.
 
Join Date: Jun 2011
Posts: 1,113
Gender: Female
Credits: 81,208
SilverDragonTears is on a distinguished road
Default

Scratch that, lol... that was hard... Ok I had to pick through... is this right?

Code:
	// Begin the output of all the adoptables to the user...
    $uncommon = rand(1,50); 
    $rare = rand(1,100); 
    $ultrarare = rand(1,200); 

    if ($uncommon==1){ 
    $query = "SELECT * FROM ".$prefix."adoptables WHERE rarity='1' ORDER BY RAND() LIMIT 1"; 
    } 
    else if ($rare==1){ 
    $query = "SELECT * FROM ".$prefix."adoptables WHERE rarity='2' ORDER BY RAND() LIMIT 1"; 
    }     
    else if ($ultrarare==1){ 
    $query = "SELECT * FROM ".$prefix."adoptables WHERE rarity='3' ORDER BY RAND() LIMIT 1"; 
    }     
    else{ 
    $query = "SELECT * FROM ".$prefix."adoptables WHERE rarity='0' ORDER BY RAND() LIMIT 1"; 
    } 
	$stmt = $adopts->query($query);
	
	$article_content .= "
	<table class='adopt'><tr>";

	
	while($row = $stmt->fetch(PDO::FETCH_OBJ)) {
		$aid=$row->id; //The adoptable's ID
		$type=$row->type;
		$description=$row->description;
		$eggimage=$row->eggimage;

		// Call a function to check if we have the proper privledge level to adopt this pet
		if($promocode == "") $promocode = "none";
		$canadopt = canadopt($aid, "showing", $promocode, $row); // Feed an adoptable ID and showing, to show the adopt to guests...

		if($canadopt == "yes"){
			//If we can adopt the adoptable, show the image and adoption link...
			$article_content .= "
			<td  VALIGN='top'><br><br><br><br><br><br><br><br><br><br><a href='doadopt.php?id=".$aid."'><img src='picuploads/png/e42598f988b271a7e66b36b9a5d8143b.png' /></a><br>
			{$description}</td>";
		}
	}



    if ($uncommon==1){ 
    $query = "SELECT * FROM ".$prefix."adoptables WHERE rarity='1' ORDER BY RAND() LIMIT 1"; 
    } 
    else if ($rare==1){ 
    $query = "SELECT * FROM ".$prefix."adoptables WHERE rarity='2' ORDER BY RAND() LIMIT 1"; 
    }     
    else if ($ultrarare==1){ 
    $query = "SELECT * FROM ".$prefix."adoptables WHERE rarity='3' ORDER BY RAND() LIMIT 1"; 
    }     
    else{ 
    $query = "SELECT * FROM ".$prefix."adoptables WHERE rarity='0' ORDER BY RAND() LIMIT 1"; 
    } 
	$stmt = $adopts->query($query);
	
	$article_content .= "
	<table class='adopt'><tr>";

	
	while($row = $stmt->fetch(PDO::FETCH_OBJ)) {
		$aid=$row->id; //The adoptable's ID
		$type=$row->type;
		$description=$row->description;
		$eggimage=$row->eggimage;

		// Call a function to check if we have the proper privledge level to adopt this pet
		if($promocode == "") $promocode = "none";
		$canadopt = canadopt($aid, "showing", $promocode, $row); // Feed an adoptable ID and showing, to show the adopt to guests...

		if($canadopt == "yes"){
			//If we can adopt the adoptable, show the image and adoption link...
			$article_content .= "
			<td  VALIGN='top'><br><br><br><br><br><br><br><br><br><br><a href='doadopt.php?id=".$aid."'><img src='picuploads/png/e42598f988b271a7e66b36b9a5d8143b.png' /></a><br>
			{$description}</td>";
		}
	}



    if ($uncommon==1){ 
    $query = "SELECT * FROM ".$prefix."adoptables WHERE rarity='1' ORDER BY RAND() LIMIT 1"; 
    } 
    else if ($rare==1){ 
    $query = "SELECT * FROM ".$prefix."adoptables WHERE rarity='2' ORDER BY RAND() LIMIT 1"; 
    }     
    else if ($ultrarare==1){ 
    $query = "SELECT * FROM ".$prefix."adoptables WHERE rarity='3' ORDER BY RAND() LIMIT 1"; 
    }     
    else{ 
    $query = "SELECT * FROM ".$prefix."adoptables WHERE rarity='0' ORDER BY RAND() LIMIT 1"; 
    } 
	$stmt = $adopts->query($query);
	
	$article_content .= "
	<table class='adopt'><tr>";

	
	while($row = $stmt->fetch(PDO::FETCH_OBJ)) {
		$aid=$row->id; //The adoptable's ID
		$type=$row->type;
		$description=$row->description;
		$eggimage=$row->eggimage;

		// Call a function to check if we have the proper privledge level to adopt this pet
		if($promocode == "") $promocode = "none";
		$canadopt = canadopt($aid, "showing", $promocode, $row); // Feed an adoptable ID and showing, to show the adopt to guests...

		if($canadopt == "yes"){
			//If we can adopt the adoptable, show the image and adoption link...
			$article_content .= "
			<td  VALIGN='top'><br><br><br><br><br><br><br><br><br><br><a href='doadopt.php?id=".$aid."'><img src='picuploads/png/e42598f988b271a7e66b36b9a5d8143b.png' /></a><br>
			{$description}</td>";
		}
	}
__________________

Check out SilvaTales

Last edited by SilverDragonTears; 03-22-2012 at 10:14 PM.
Reply With Quote
  #16  
Old 03-22-2012, 10:24 PM
SilverDragonTears's Avatar
SilverDragonTears SilverDragonTears is offline
I am your Nemesis.
 
Join Date: Jun 2011
Posts: 1,113
Gender: Female
Credits: 81,208
SilverDragonTears is on a distinguished road
Default

omg. It's working JUST like I needed it to!!! *bows to !Alive* You are amazing, my friend. How can I thank you? Seriously... I feel like I owe you... That is an amazing code.
__________________

Check out SilvaTales
Reply With Quote
  #17  
Old 03-22-2012, 10:25 PM
!Alive !Alive is offline
Member
 
Join Date: Feb 2012
Posts: 39
Gender: Male
Credits: 1,053
!Alive is on a distinguished road
Default

That looks like it should work with the new 1.3 version. Though I have not messed with it at all as of yet. XP But it looks like you make the changes so it should work in the 1.3 version. XD
Reply With Quote
  #18  
Old 03-22-2012, 10:26 PM
SilverDragonTears's Avatar
SilverDragonTears SilverDragonTears is offline
I am your Nemesis.
 
Join Date: Jun 2011
Posts: 1,113
Gender: Female
Credits: 81,208
SilverDragonTears is on a distinguished road
Default

Read post above yours :)
__________________

Check out SilvaTales
Reply With Quote
  #19  
Old 03-22-2012, 10:29 PM
!Alive !Alive is offline
Member
 
Join Date: Feb 2012
Posts: 39
Gender: Male
Credits: 1,053
!Alive is on a distinguished road
Default

^-^ I'm glad that it works for you. *blushes* Thanks, I'm happy that I was able to help even with my limited knowledge. X3
You don't owe me anything, seriously. I don't even know what I would ask for...
Reply With Quote
  #20  
Old 03-22-2012, 10:32 PM
SilverDragonTears's Avatar
SilverDragonTears SilverDragonTears is offline
I am your Nemesis.
 
Join Date: Jun 2011
Posts: 1,113
Gender: Female
Credits: 81,208
SilverDragonTears is on a distinguished road
Default

Ok well if you EVER need anything... please don't hesitate to ask me. On one more note, do you know how to make it so that if two users click the same adopt at the same time, only one will get it? Not sure if I explained that one clearly either.
__________________

Check out SilvaTales
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 08:05 AM.

Currently Active Users: 439 (0 members and 439 guests)
Threads: 4,080, Posts: 32,024, Members: 2,016
Welcome to our newest members, jolob.
BETA





What's New?

What's Hot?

What's Popular?


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
vBCommerce I v2.0.0 Gold ©2010, PixelFX Studios
vBCredits I v2.0.0 Gold ©2010, PixelFX Studios
Emoticons by darkmoon3636