Mysidia Adoptables Support Forum  

Home Community Mys-Script Creative Off-Topic
Go Back   Mysidia Adoptables Support Forum > Mysidia Adoptables > Questions and Supports
Reload this Page Will pay for this....
vBCommerceProjects FAQ Community Calendar Today's Posts Search

Notices

Reply
Page 2 of 5 1 2 34 Last »
 
Thread Tools Display Modes
  #11  
Old 03-22-2012, 09:44 PM
SilverDragonTears's Avatar
SilverDragonTears SilverDragonTears is offline
I am your Nemesis.
  
Join Date: Jun 2011
Posts: 1,113
Gender: Female
Credits: 96,925
SilverDragonTears is on a distinguished road
Default
*waits somewhat patiently* :)
__________________

Check out SilvaTales
Reply With Quote
  #12  
Old 03-22-2012, 10:32 PM
!Alive !Alive is offline
Member
  
Join Date: Feb 2012
Posts: 39
Gender: Male
Credits: 1,428
!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, 10:34 PM
SilverDragonTears's Avatar
SilverDragonTears SilverDragonTears is offline
I am your Nemesis.
  
Join Date: Jun 2011
Posts: 1,113
Gender: Female
Credits: 96,925
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, 10:57 PM
!Alive !Alive is offline
Member
  
Join Date: Feb 2012
Posts: 39
Gender: Male
Credits: 1,428
!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, 11:08 PM
SilverDragonTears's Avatar
SilverDragonTears SilverDragonTears is offline
I am your Nemesis.
  
Join Date: Jun 2011
Posts: 1,113
Gender: Female
Credits: 96,925
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 11:14 PM.
Reply With Quote
  #16  
Old 03-22-2012, 11:24 PM
SilverDragonTears's Avatar
SilverDragonTears SilverDragonTears is offline
I am your Nemesis.
  
Join Date: Jun 2011
Posts: 1,113
Gender: Female
Credits: 96,925
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, 11:25 PM
!Alive !Alive is offline
Member
  
Join Date: Feb 2012
Posts: 39
Gender: Male
Credits: 1,428
!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, 11:26 PM
SilverDragonTears's Avatar
SilverDragonTears SilverDragonTears is offline
I am your Nemesis.
  
Join Date: Jun 2011
Posts: 1,113
Gender: Female
Credits: 96,925
SilverDragonTears is on a distinguished road
Default
Read post above yours :)
__________________

Check out SilvaTales
Reply With Quote
  #19  
Old 03-22-2012, 11:29 PM
!Alive !Alive is offline
Member
  
Join Date: Feb 2012
Posts: 39
Gender: Male
Credits: 1,428
!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, 11:32 PM
SilverDragonTears's Avatar
SilverDragonTears SilverDragonTears is offline
I am your Nemesis.
  
Join Date: Jun 2011
Posts: 1,113
Gender: Female
Credits: 96,925
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
Page 2 of 5 1 2 34 Last »

« Previous Thread | Next Thread »

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 02:48 PM.

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





What's New?

What's Hot?

What's Popular?
Mysidia Adoptables - Archive - Privacy Statement - Terms of Service - Top

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