Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ListSQL:
- Override: true
- Script:
- - '@IF s <playername> = KyadCK'
- - ' @DELLIST @MySQLOutput.<playeruuid>'
- - ' @MYSQL @MySQLOutput.<playeruuid> SELECT * FROM vt_temp2;'
- - ' @SETINT $<playeruuid>.RowCounter @MySQL.<playeruuid>'
- - ' @SUBINT $<playeruuid>.RowCounter 1'
- - ' @DIVINT $<playeruuid>.RowCounter 3'
- - ' @PLAYER $<playeruuid>.RowCounter'
- - ' @IF i $<playeruuid>.RowCounter > 3'
- - ' @SETINT $<playeruuid>.MySQLPages <var:$<playeruuid>.RowCounter>'
- - ' @DIVINT $<playeruuid>.MySQLPages 3'
- - ' @ADDINT $<playeruuid>.MySQLPages 1'
- - ' @PLAYER &9----&6Page 1 of $<playeruuid>.MySQLPages &9----'
- - ' @SETINT $<playeruuid>.ColumnCounter 1'
- - ' @LOOP 3'
- - ' @SETSTR $<playeruuid>.ColumnName <playeruuid>[<var:$<playeruuid>.ColumnCounter>]'
- - ' @PLAYER &6Player UUID:&7 @MySQLOutput.<var:$<playeruuid>.ColumnName>'
- - ' @ADDINT $<playeruuid>.ColumnCounter 1'
- - ' @SETSTR $<playeruuid>.ColumnName <playeruuid>[<var:$<playeruuid>.ColumnCounter>]'
- - ' @PLAYER &ePlayer Name:&2 @MySQLOutput.<var:$<playeruuid>.ColumnName>'
- - ' @ADDINT $<playeruuid>.ColumnCounter 1'
- - ' @SETSTR $<playeruuid>.ColumnName <playeruuid>[<var:$<playeruuid>.ColumnCounter>]'
- - ' @PLAYER &4Submit Date:&c @MySQLOutput.<var:$<playeruuid>.ColumnName>'
- - ' @ADDINT $<playeruuid>.ColumnCounter 1'
- - ' @ENDLOOP'
- - ' @PLAYER &9--&6Run &c/SQL Page [Number] &6to see more. &9--'
- - ' @ELSE'
- - ' @SETINT $<playeruuid>.ColumnCounter 1'
- - ' @LOOP $<playeruuid>.RowCounter'
- - ' @SETSTR $<playeruuid>.ColumnName <playeruuid>[<var:$<playeruuid>.ColumnCounter>]'
- - ' @PLAYER &6Player UUID:&7 @MySQL.<var:$<playeruuid>.ColumnName>'
- - ' @ADDINT $<playeruuid>.ColumnCounter 1'
- - ' @SETSTR $<playeruuid>.ColumnName <playeruuid>[<var:$<playeruuid>.ColumnCounter>]'
- - ' @PLAYER &ePlayer Name:&2 @MySQL.<var:$<playeruuid>.ColumnName>'
- - ' @ADDINT $<playeruuid>.ColumnCounter 1'
- - ' @SETSTR $<playeruuid>.ColumnName <playeruuid>[<var:$<playeruuid>.ColumnCounter>]'
- - ' @PLAYER &4Submit Date:&c @MySQL.<var:$<playeruuid>.ColumnName>'
- - ' @ADDINT $<playeruuid>.ColumnCounter 1'
- - ' @PLAYER &9--------------------'
- - ' @ENDLOOP'
- - ' @ENDIF'
- - '@ELSE'
- - ' @PLAYER Nope.'
- - '@ENDIF'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement