The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
complex sched task, need vb to execute 4 sql queries in one connection
This works great in phpmyadmin, but if I enclose all statements together or individually in
PHP Code:
Any clues? Does vB not support creating temp tables in this way? Code:
create temporary table infraction6mo (iID Integer Primary Key, iName varchar(255), iTot integer); Insert into infraction6mo SELECT infraction.userid as iID, user.username as iName,SUM( infraction.points ) AS iTot FROM `user`,`infraction` WHERE infraction.dateline > (unix_timestamp()-15724800) and user.userid = infraction.userid and infraction.action = 1 GROUP BY infraction.userid ORDER BY itot DESC; update user set adminoptions = 1 where usergroupid = 2; update infraction6mo,user set user.adminoptions = 0 WHERE infraction6mo.iID = user.userid and infraction6mo.iTot >= 30; |
#2
|
||||
|
||||
Just split them up into four function calls.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|