Script Requests

by **Ultra** on Wed Mar 21, 2012 9:03 pm

1) Who can make or Do it is possible to make register with more functions like to create the character too? (ex. Male or Female , Name ,)
2) Hmm i really wanna to know how can i make a signature creator/ viewer (like in arua)
3)Do the Storage script is done ?
4)Do someone can give me and script (news) that you can see from who is writed (author) ?
5)Do someone can give me a script (news) that you can reply to the news ?
6)How i can make that you can choise refine for the armors/fun sets (like in Item Mall 1 i think)
7)Do someone can give me a scipt where you can make a clan? (From the website)

by **Mark** on Thu Mar 22, 2012 1:05 pm

Ultra wrote:1) Who can make or Do it is possible to make register with more functions like to create the character too? (ex. Male or Female , Name ,)

The Register Script Creates the base account, so take a look in the php for it and see how it inputs data into the sql table, i'm sure you could make a simple php script for it to create a character, you'd have to pull the right table data from the "characters.sql" to do this though.

Ultra wrote:2) Hmm i really wanna to know how can i make a signature creator/ viewer (like in arua)

Sig Creator? as in Forum type of signatures?

Ultra wrote:3)Do the Storage script is done ?

Iv'e been busy working on my own client and server the past week or so, I'm hoping I wont be the only one to work on the Storage script ( *pokes Hoegarden and others ) as this would be a great community release, I'll start working again on it soon and post results into a thread.

Ultra wrote:4)Do someone can give me and script (news) that you can see from who is writed (author) ?

There is a News script which comes with the IceDynasty layout in its modules folder

Ultra wrote:5)Do someone can give me a script (news) that you can reply to the news ?

Not sure about replying to it though, maybe you should use a forum for this, as it would be much easier for users to reply to rather than using up lots of your hosting accounts bandwidth everytime someone reply's to a message or reloads the page.

Ultra wrote:6)How i can make that you can choise refine for the armors/fun sets (like in Item Mall 1 i think)

There should be a Column called "Ref_Able" in the sql table for your Item mall, simple change the number 0 to whatever refine you want it set at when the customer purchases the item.
*p.s: Soc_able determines weather the item comes with a slot or not too.

by **Mark** on Thu Mar 22, 2012 3:27 pm

Just having a few issues when collecting data from the sql tables.

So far iv'e got:

Line number On/Off | Expand/Contract | Select all

<html>
<body>
<?php
if(!session_is_registered(User_Name)) {
die('You must be logged in to view your storage!');
}
 
if(!session_is_registered(User_Pass)) {
die('You must be logged in to view your storage!');
}
mysql_connect($dbhost, $dbuser, $dbpasswd);
mysql_select_db($dbname) or die( "Unable to connect to database");
 
$query="SELECT * FROM storage";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
?>
<table border="0" cellspacing="2" cellpadding="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif">owner</font>
</th>
<th><font face="Arial, Helvetica, sans-serif">itemnum</font></th>
<th><font face="Arial, Helvetica, sans-serif">itemtype</font></th>
<th><font face="Arial, Helvetica, sans-serif">refine</font></th>
<th><font face="Arial, Helvetica, sans-serif">stats</font></th>
</tr>
 
<?php
$i=0;
while ($i < $num) {
 
$f1=mysql_result($result,$i,"owner");
$f2=mysql_result($result,$i,"itemnum");
$f3=mysql_result($result,$i,"itemtype");
$f4=mysql_result($result,$i,"refine");
$f5=mysql_result($result,$i,"stats");
?>
 
<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td>
</tr>
 
<?php
$i++;
}
?>
</body>
</html>

What i need to figure out is what WHERE statement to use, Iv'e tried using WHERE owner = '".$_SESSION['account'].";
and
WHERE owner = '".$_SESSION['owner'].";

But so far it just keeps on displaying ALL of the users on the server' storage contents, the way it works so far is that users log in > there user panel comes up > they click the link to take them to storage > then the storage is displayed.

Any ideas on a sql filter please?

Thanks

by **xadet3** on Thu Mar 22, 2012 3:43 pm

At the top of your page put

Line number On/Off | Expand/Contract | Select all

print_r($_SESSION);
die();

and paste here what it returns.

by **hoegarden31** on Thu Mar 22, 2012 6:10 pm

Maybe it's because owner in the storage table is the ID of the user. not his name

So try $_SESSION['account_id']...

by **Mark** on Thu Mar 22, 2012 8:54 pm

xadet3 wrote:At the top of your page put
Line number On/Off | Expand/Contract | Select all
print_r($_SESSION);
die();

and paste here what it returns.

As requested:

Line number On/Off | Expand/Contract | Select all

Array ( [User_Name] => [User_Pass] => [account] => Mark [account_id] => 84 )

Is whats being printed.

@hoegarden31: I'll try that now too.

by **Ultra** on Thu Mar 22, 2012 9:03 pm

It would be GREAT if you share the script

!
But do it will have a design like in speed rose ?
Or it will be as a text or so .. ?

by **Mark** on Thu Mar 22, 2012 9:12 pm

We'll share the script when its finished

And Yeah im hoping we could possibly have a UI similar to that used in-game

@hoegarden31:

Tried that .$_SESSION['account_id'] the full statement was:

Line number On/Off | Expand/Contract | Select all

$query="SELECT * FROM storage WHERE owner = ".$_SESSION['account_id']."'");

Could an If statement be used instead of the WHERE filter, i.e

Line number On/Off | Expand/Contract | Select all

$query="SELECT * FROM storage WHERE owner = ".$_SESSION['account_id']."'");
if ($S_SESSION['account_id']) < owner
{
die ();
}

I dunno, i'm just shooting blindly and hoping for a "Success"

by **Ultra** on Thu Mar 22, 2012 10:20 pm

I will say you Good Luck

! Because these months dont have new scripts ..
Tha last tool was the map viewer (i think) ... but i will wait when xadet finish him new tools for the community

!
I will try to realese something too soon

( im not PRO xD)

by **Mark** on Fri Mar 23, 2012 7:19 pm

Mini Bump:

@Xadet, as requested this is whats being printed

Line number On/Off | Expand/Contract | Select all

LINE NUMBER ON/OFF | EXPAND/CONTRACT | SELECT ALL
Array ( [User_Name] => [User_Pass] => [account] => Mark [account_id] => 84 )

Thanks

Script Requests

Script Requests

Re: Script Requests

Re: Script Requests

Re: Script Requests

Re: Script Requests

Re: Script Requests

Re: Script Requests

Re: Script Requests

Re: Script Requests

Re: Script Requests

Who is online