View Single Post
  #1  
Old 04-04-2009, 05:44 PM
kisazeky kisazeky is offline
Member
 
Join Date: Mar 2009
Posts: 44
Credits: 19,454
kisazeky
Default Show who recently leveled up a given adoptable

What!? OMG ANOTHER MOD!!?

This one is kind of tricky so pay attention!!

---
[size=medium]
If you have installed my profile mod[/size]

Wherever in the code there is:
PHP Code:
$article_content $article_content."$voter "
change it to:

PHP Code:
$article_content $article_content."<a href='profile.php?owner=$voter'>$voter</a> "
This will link their name to their profile.

----

Step 1:

Run this query (this is the only easy part)

PHP Code:
ALTER vote_voters ADD (voteid INT NOT NULL AUTO_INCREMENT PRIMARY KEY
Step 2:


Open levelup.php and look for something like this code. It may vary if you have changed the "already leveled up" message.

PHP Code:
if($checkdate == $todaydate){
                
//We've gone this far, this means that we found a match because a date was returned
                //Cannot vote because we already voted today...
                
$article_title "You already voted for me today!";
                
$article_date date('Y-m-d');    
                
$article_content "You already voted for this adoptable today.  Please come back in 24 hours to level up this adoptable again."
Below it, put:

PHP Code:
$article_content=$article_content."<p>Recently leveled up by:</p>";

$query "SELECT * FROM vote_voters WHERE adoptableid = '".$id."' AND date = '".$todaydate."' ORDER BY voteid DESC LIMIT 20";
$result mysql_query($query);
$num mysql_numrows($result);

//Loop out code
$i=0;
while (
$i $num) {

$voter=@mysql_result($result,$i,"username");

$article_content $article_content."$voter ";

$i++;


Step 3:
[size=medium]
This is if you have not installed my currency mod
[/size]

Find something like this bit of code (it will not be exact if you changed the level up message):

PHP Code:
            mysql_query("UPDATE owned_adoptables SET currentlevel='".$levelup."' WHERE uid='".$id."'");
            
mysql_query("UPDATE owned_adoptables SET imageurl='".$img."' WHERE uid='".$id."'");
            
$flag 1;
            
$currentlevel $levelup;
            }


            }    

            if(
$flag == 1){
            
$imageurl $img;
            }

            
$article_content "You just gave ".$name." 1 LevelUP point!<br><br><img src='".$imageurl."' border='0'><br>
            <b>"
.$name."'s Current Level: ".$currentlevel."</b><br><br>Be sure and come back tomorrow to rank ".$name." up again!"
Below it...insert this code:

PHP Code:
$article_content=$article_content."<p>Recently leveled up by:</p>";

$query "SELECT * FROM vote_voters WHERE adoptableid = '".$id."' AND date = '".$todaydate."' ORDER BY voteid DESC LIMIT 20";
$result mysql_query($query);
$num mysql_numrows($result);

//Loop out code
$i=0;
while (
$i $num) {

$voter=@mysql_result($result,$i,"username");

$article_content $article_content."$voter ";

$i++;


[size=medium]If you have installed my currency mod then...[/size]

Find something similar to this code. The article content may vary if you changed the message.

PHP Code:
mysql_query("UPDATE `users` SET `money`='".$newbalance."' WHERE `username`='".$luser."'");
            
            
$article_content=$article_content"
            <p>You have earned 10 currency name for leveling up this pet.
            <br>You now have a total of "
.$newbalance." currency name."
Erase the "; at the end of your message for earning currency. Then below it, paste this:

PHP Code:
<p>Recently leveled up by:</p>";

$query = "SELECT FROM vote_voters WHERE adoptableid '".$id."' AND date '".$todaydate."' ORDER BY voteid DESC LIMIT 20";
$result = mysql_query($query);
$num = mysql_numrows($result);

//Loop out code
$i=0;
while (
$i < $num) {

$voter=@mysql_result($result,$i,"username");

$article_content = $article_content."$voter ";

$i++;

Step 4:

Find
PHP Code:
mysql_query("INSERT INTO vote_voters VALUES ('$todaydate', '','$ip','$id')"); 
Change it to
PHP Code:
mysql_query("INSERT INTO vote_voters VALUES ('$todaydate', '','$ip','$id', '')"); 
Then find
PHP Code:
mysql_query("INSERT INTO vote_voters VALUES ('$todaydate', '$username','','$id')"); 
again

and change it to
PHP Code:
mysql_query("INSERT INTO vote_voters VALUES ('$todaydate', '$username','','$id', '')");