Auto Gallery SQL Problem

[BennyX]

i have a very big problem i change the script to Auto Gallery SQL
and i have allready a mistake in my code
i hope somebody can help me ... here or icq: 47099938
thx alot

and now the problem
<----Hall of Fame ----> I hope its correct! Best 12 Galleries!
<%GALLERIES
HASTHUMB 1
TYPE Submitted
CATEGORY Mixed
AMOUNT 6
GETNEW False
EXCLUDE Hardcore, Fetish
AGE 1
ORDER (Clicks/Build_Counter) DESC
HTML Thumb
%>
</tr>
<tr>
<%GALLERIES
HASTHUMB 1
TYPE Submitted
CATEGORY Mixed
AMOUNT 6
GETNEW False
EXCLUDE Hardcore, Fetish
AGE 2
ORDER (Clicks/Build_Counter) DESC
HTML Thumb
%>

Today Galleries:
i want to show 20 thumbs and after the daily submission (i submit every 6 hours) the old thumbgalleries should go to the textlink section

<!-- New Galleries Added Here -->
<table align="center" cellpadding="5" border="0">
<tr>
<%GALLERIES
HASTHUMB 1
TYPE Submitted
CATEGORY Mixed
AMOUNT 20
GETNEW True
AGE 0
ORDER Approve_Stamp
REORDER Build_Counter
HTML Thumb

INSERT
{
LOCATION +5
HTML </tr><tr>
}
%>
</tr>
</table><br>
<center>
</center><br>
<table align="center">
<tr>
<td valign="top">
<%GALLERIES
HASTHUMB 0
TYPE Permanent
CATEGORY Mixed
AMOUNT 200
GETNEW True
ORDER Approve_Stamp
REORDER Build_Counter
HTML Text

INSERT
{
LOCATION 100
HTML </td><td width="50%"></td><td valign="top">
}
%>
</td>
</tr>
</table>

and than should follow the
yesterday gallerie's
the same like Today galleries
<%GALLERIES
HASTHUMB 1
TYPE Submitted
CATEGORY Mixed
AMOUNT 20
GETNEW True
AGE 0
ORDER Approve_Stamp
REORDER Build_Counter
HTML Thumb

INSERT
{
LOCATION +5
HTML </tr><tr>
}
%>
</tr>
</table><br>
<center>
</center><br>
<table align="center">
<tr>
<td valign="top">
<%GALLERIES
HASTHUMB 0
TYPE Permanent
CATEGORY Mixed
AMOUNT 200
GETNEW True
ORDER Approve_Stamp
REORDER Build_Counter
HTML Text

INSERT
{
LOCATION 100
HTML </td><td width="50%"></td><td valign="top">
}
%>
</td>
</tr>
</table>

but there is somthing wrong

[phatbiatch]

have you posted on jmpbsoft.coms support forum before posting about it here? they might be able to help you...

[BennyX]

have you posted on jmpbsoft.coms support forum before posting about it here? they might be able to help you...

i posted there but no body answer me

[amateurcanada]

There could be 1000 problems. Email [email protected] or use there ticket system, they respond within a few hours.

[Jeremita]

or try with exaples from exaples directory ;)

btw. AG SQL is great script !